DBA Data[Home] [Help]

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_MENU_ENTRIES_TL

Line 24: type t_fnd_menu_entries_tl IS TABLE OF fnd_menu_entries_tl % rowtype;

20: function_id fnd_form_functions.function_id%TYPE;
21: menu_id fnd_menus.menu_id%TYPE;
22:
23: type t_fnd_menus_tl IS TABLE OF fnd_menus_tl % rowtype;
24: type t_fnd_menu_entries_tl IS TABLE OF fnd_menu_entries_tl % rowtype;
25: type t_fnd_form_functions_tl IS TABLE OF fnd_form_functions_tl % rowtype;
26:
27:
28: -- to store existing menus and grants

Line 34: v_fnd_menu_entries_tl t_fnd_menu_entries_tl;

30: v_fnd_menus t_fnd_menus;
31: v_fnd_menu_entries t_fnd_menu_entries;
32: v_fnd_form_functions t_fnd_form_functions;
33: v_fnd_menus_tl t_fnd_menus_tl;
34: v_fnd_menu_entries_tl t_fnd_menu_entries_tl;
35: v_fnd_grants_new t_fnd_grants;
36: v_fnd_menus_new t_fnd_menus;
37: v_fnd_menu_entries_new t_fnd_menu_entries;
38: v_fnd_form_functions_new t_fnd_form_functions;

Line 40: v_fnd_menu_entries_tl_new t_fnd_menu_entries_tl;

36: v_fnd_menus_new t_fnd_menus;
37: v_fnd_menu_entries_new t_fnd_menu_entries;
38: v_fnd_form_functions_new t_fnd_form_functions;
39: v_fnd_menus_tl_new t_fnd_menus_tl;
40: v_fnd_menu_entries_tl_new t_fnd_menu_entries_tl;
41:
42: menu_entry_count number;
43: menu_entry_tl_count number;
44: menu_count number;

Line 226: if v_fnd_menu_entries_tl is not null then

222: end if;
223: if v_fnd_menu_entries is not null then
224: v_fnd_menu_entries.DELETE;
225: end if;
226: if v_fnd_menu_entries_tl is not null then
227: v_fnd_menu_entries_tl.DELETE;
228: end if;
229: if v_fnd_menus is not null then
230: v_fnd_menus.DELETE;

Line 227: v_fnd_menu_entries_tl.DELETE;

223: if v_fnd_menu_entries is not null then
224: v_fnd_menu_entries.DELETE;
225: end if;
226: if v_fnd_menu_entries_tl is not null then
227: v_fnd_menu_entries_tl.DELETE;
228: end if;
229: if v_fnd_menus is not null then
230: v_fnd_menus.DELETE;
231: end if;

Line 1480: v_fnd_menu_entries_tl := t_fnd_menu_entries_tl();

1476: error1 varchar2(300);
1477: BEGIN
1478: -- Start Initialize Collections
1479: v_fnd_menu_entries:= t_fnd_menu_entries();
1480: v_fnd_menu_entries_tl := t_fnd_menu_entries_tl();
1481: v_fnd_menus := t_fnd_menus();
1482: v_fnd_menus_tl := t_fnd_menus_tl();
1483: v_fnd_grants := t_fnd_grants();
1484:

Line 1526: INTO v_fnd_menu_entries_tl_new

1522: LOOP
1523: IF v_fnd_menu_entries_new(j).menu_id IS NOT NULL THEN
1524:
1525: SELECT *bulk collect
1526: INTO v_fnd_menu_entries_tl_new
1527: FROM fnd_menu_entries_tl
1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1529:
1530: v_fnd_menu_entries_tl.extend(1);

Line 1527: FROM fnd_menu_entries_tl

1523: IF v_fnd_menu_entries_new(j).menu_id IS NOT NULL THEN
1524:
1525: SELECT *bulk collect
1526: INTO v_fnd_menu_entries_tl_new
1527: FROM fnd_menu_entries_tl
1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1529:
1530: v_fnd_menu_entries_tl.extend(1);
1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;

Line 1530: v_fnd_menu_entries_tl.extend(1);

1526: INTO v_fnd_menu_entries_tl_new
1527: FROM fnd_menu_entries_tl
1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1529:
1530: v_fnd_menu_entries_tl.extend(1);
1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;
1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then
1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST

Line 1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;

1527: FROM fnd_menu_entries_tl
1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1529:
1530: v_fnd_menu_entries_tl.extend(1);
1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;
1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then
1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST
1535: LOOP

Line 1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then

1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1529:
1530: v_fnd_menu_entries_tl.extend(1);
1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;
1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then
1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST
1535: LOOP
1536: v_fnd_menu_entries_tl(menu_entry_tl_count) := v_fnd_menu_entries_tl_new(k);

Line 1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST

1530: v_fnd_menu_entries_tl.extend(1);
1531: menu_entry_tl_count := v_fnd_menu_entries_tl.last;
1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then
1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST
1535: LOOP
1536: v_fnd_menu_entries_tl(menu_entry_tl_count) := v_fnd_menu_entries_tl_new(k);
1537: v_fnd_menu_entries_tl.extend(1);
1538: menu_entry_tl_count :=menu_entry_tl_count+1;

Line 1536: v_fnd_menu_entries_tl(menu_entry_tl_count) := v_fnd_menu_entries_tl_new(k);

1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then
1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST
1535: LOOP
1536: v_fnd_menu_entries_tl(menu_entry_tl_count) := v_fnd_menu_entries_tl_new(k);
1537: v_fnd_menu_entries_tl.extend(1);
1538: menu_entry_tl_count :=menu_entry_tl_count+1;
1539: end loop;
1540:

Line 1537: v_fnd_menu_entries_tl.extend(1);

1533:
1534: FOR k IN v_fnd_menu_entries_tl_new.FIRST .. v_fnd_menu_entries_tl_new.LAST
1535: LOOP
1536: v_fnd_menu_entries_tl(menu_entry_tl_count) := v_fnd_menu_entries_tl_new(k);
1537: v_fnd_menu_entries_tl.extend(1);
1538: menu_entry_tl_count :=menu_entry_tl_count+1;
1539: end loop;
1540:
1541: end if;

Line 1662: FOR j IN v_fnd_menu_entries_tl.FIRST .. v_fnd_menu_entries_tl.LAST

1658: LOOP
1659:
1660: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN
1661:
1662: FOR j IN v_fnd_menu_entries_tl.FIRST .. v_fnd_menu_entries_tl.LAST
1663: LOOP
1664:
1665: IF v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id THEN
1666:

Line 1665: IF v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id THEN

1661:
1662: FOR j IN v_fnd_menu_entries_tl.FIRST .. v_fnd_menu_entries_tl.LAST
1663: LOOP
1664:
1665: IF v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id THEN
1666:
1667: fnd_menu_entries_pkg.insert_row(x_rowid,
1668: t_menu_id,
1669: v_fnd_menu_entries(k).entry_sequence,

Line 1673: v_fnd_menu_entries_tl(j).PROMPT,

1669: v_fnd_menu_entries(k).entry_sequence,
1670: v_fnd_menu_entries(k).sub_menu_id,
1671: f_id,
1672: v_fnd_menu_entries(k).grant_flag,
1673: v_fnd_menu_entries_tl(j).PROMPT,
1674: v_fnd_menu_entries_tl(j).description,
1675: v_fnd_menu_entries(k).creation_date,
1676: v_fnd_menu_entries(k).created_by,
1677: v_fnd_menu_entries(k).last_update_date,

Line 1674: v_fnd_menu_entries_tl(j).description,

1670: v_fnd_menu_entries(k).sub_menu_id,
1671: f_id,
1672: v_fnd_menu_entries(k).grant_flag,
1673: v_fnd_menu_entries_tl(j).PROMPT,
1674: v_fnd_menu_entries_tl(j).description,
1675: v_fnd_menu_entries(k).creation_date,
1676: v_fnd_menu_entries(k).created_by,
1677: v_fnd_menu_entries(k).last_update_date,
1678: v_fnd_menu_entries(k).last_updated_by,

Line 1681: WHEN v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id;

1677: v_fnd_menu_entries(k).last_update_date,
1678: v_fnd_menu_entries(k).last_updated_by,
1679: v_fnd_menu_entries(k).last_update_login);
1680: EXIT
1681: WHEN v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id;
1682:
1683: END IF;
1684:
1685: END LOOP;