1.form开发中活用list,即从表中拉取数据绑定大list

procedure create_index_method_list is
  rg_name VARCHAR2(40) := 'INDEX_METHOD';
  rg_id   RECORDGROUP;
  item_id ITEM;
  errcode number;
begin
  
  rg_id := create_group_from_query(rg_name,
                                   'SELECT MEANING,' || 'LOOKUP_CODE' ||
                                   ' FROM FND_LOOKUP_VALUES_VL' ||
                                   ' WHERE lookup_type = ''CIH_CIRC_INDEX_METHOD''' ||
                                   ' and enabled_flag = ''Y''' ||
                                   ' and nvl(start_date_active, sysdate - 1) <= sysdate' ||
                                   ' and nvl(end_date_active, sysdate + 1) >= sysdate');

  errcode := populate_group(rg_id);
  if errcode = 0 then
    item_id := FIND_ITEM('CCI.METHOD');
    Clear_List(item_id);
    populate_list(item_id, rg_id);
  else
    RAISE FORM_TRIGGER_FAILURE;
  end if;
end;

2.列表项怎么删除已存在列表

选中列表元素,”ctrl+<“;

posted on 2012-07-04 16:18  小波Ooo  阅读(842)  评论(0编辑  收藏  举报