DBA Data[Home] [Help]

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_MENUS_TL

Line 23: type t_fnd_menus_tl IS TABLE OF fnd_menus_tl % rowtype;

19:
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:

Line 33: v_fnd_menus_tl t_fnd_menus_tl;

29: v_fnd_grants t_fnd_grants;
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;

Line 39: v_fnd_menus_tl_new t_fnd_menus_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;
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;

Line 232: if v_fnd_menus_tl is not null then

228: end if;
229: if v_fnd_menus is not null then
230: v_fnd_menus.DELETE;
231: end if;
232: if v_fnd_menus_tl is not null then
233: v_fnd_menus_tl.DELETE;
234: end if;
235: if v_fnd_grants is not null then
236: v_fnd_grants.DELETE;

Line 233: v_fnd_menus_tl.DELETE;

229: if v_fnd_menus is not null then
230: v_fnd_menus.DELETE;
231: end if;
232: if v_fnd_menus_tl is not null then
233: v_fnd_menus_tl.DELETE;
234: end if;
235: if v_fnd_grants is not null then
236: v_fnd_grants.DELETE;
237: end if;

Line 1482: v_fnd_menus_tl := t_fnd_menus_tl();

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:
1485: SELECT *bulk collect
1486: INTO v_fnd_form_functions

Line 1567: INTO v_fnd_menus_tl_new

1563:
1564: IF v_fnd_menus_new(l).menu_id IS NOT NULL THEN
1565:
1566: SELECT *bulk collect
1567: INTO v_fnd_menus_tl_new
1568: FROM fnd_menus_tl
1569: WHERE menu_id = v_fnd_menus_new(l).menu_id;
1570:
1571: v_fnd_menus_tl.extend(1);

Line 1568: FROM fnd_menus_tl

1564: IF v_fnd_menus_new(l).menu_id IS NOT NULL THEN
1565:
1566: SELECT *bulk collect
1567: INTO v_fnd_menus_tl_new
1568: FROM fnd_menus_tl
1569: WHERE menu_id = v_fnd_menus_new(l).menu_id;
1570:
1571: v_fnd_menus_tl.extend(1);
1572: menu_tl_count := v_fnd_menus_tl.last;

Line 1571: v_fnd_menus_tl.extend(1);

1567: INTO v_fnd_menus_tl_new
1568: FROM fnd_menus_tl
1569: WHERE menu_id = v_fnd_menus_new(l).menu_id;
1570:
1571: v_fnd_menus_tl.extend(1);
1572: menu_tl_count := v_fnd_menus_tl.last;
1573:
1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST

Line 1572: menu_tl_count := v_fnd_menus_tl.last;

1568: FROM fnd_menus_tl
1569: WHERE menu_id = v_fnd_menus_new(l).menu_id;
1570:
1571: v_fnd_menus_tl.extend(1);
1572: menu_tl_count := v_fnd_menus_tl.last;
1573:
1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST
1576: LOOP

Line 1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then

1570:
1571: v_fnd_menus_tl.extend(1);
1572: menu_tl_count := v_fnd_menus_tl.last;
1573:
1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST
1576: LOOP
1577: v_fnd_menus_tl(menu_tl_count) := v_fnd_menus_tl_new(k);
1578: v_fnd_menus_tl.extend(1);

Line 1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST

1571: v_fnd_menus_tl.extend(1);
1572: menu_tl_count := v_fnd_menus_tl.last;
1573:
1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST
1576: LOOP
1577: v_fnd_menus_tl(menu_tl_count) := v_fnd_menus_tl_new(k);
1578: v_fnd_menus_tl.extend(1);
1579: menu_tl_count :=menu_tl_count+1;

Line 1577: v_fnd_menus_tl(menu_tl_count) := v_fnd_menus_tl_new(k);

1573:
1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST
1576: LOOP
1577: v_fnd_menus_tl(menu_tl_count) := v_fnd_menus_tl_new(k);
1578: v_fnd_menus_tl.extend(1);
1579: menu_tl_count :=menu_tl_count+1;
1580: end loop;
1581: end if ;

Line 1578: v_fnd_menus_tl.extend(1);

1574: if v_fnd_menus_tl_new is not null and v_fnd_menus_tl_new.count > 0 then
1575: FOR k IN v_fnd_menus_tl_new.FIRST .. v_fnd_menus_tl_new.LAST
1576: LOOP
1577: v_fnd_menus_tl(menu_tl_count) := v_fnd_menus_tl_new(k);
1578: v_fnd_menus_tl.extend(1);
1579: menu_tl_count :=menu_tl_count+1;
1580: end loop;
1581: end if ;
1582: SELECT *bulk collect

Line 1692: FOR j IN v_fnd_menus_tl.FIRST .. v_fnd_menus_tl.LAST

1688: LOOP
1689:
1690: IF v_fnd_menus(m).menu_id = v_fnd_menu_entries(k).menu_id THEN
1691:
1692: FOR j IN v_fnd_menus_tl.FIRST .. v_fnd_menus_tl.LAST
1693: LOOP
1694:
1695: IF v_fnd_menus_tl(j).menu_id = v_fnd_menus(m).menu_id THEN
1696:

Line 1695: IF v_fnd_menus_tl(j).menu_id = v_fnd_menus(m).menu_id THEN

1691:
1692: FOR j IN v_fnd_menus_tl.FIRST .. v_fnd_menus_tl.LAST
1693: LOOP
1694:
1695: IF v_fnd_menus_tl(j).menu_id = v_fnd_menus(m).menu_id THEN
1696:
1697: fnd_menus_pkg.insert_row(x_rowid,
1698: t_menu_id,
1699: 'FND_FUNCTION_'||f_id,

Line 1700: v_fnd_menus_tl(j).user_menu_name,

1696:
1697: fnd_menus_pkg.insert_row(x_rowid,
1698: t_menu_id,
1699: 'FND_FUNCTION_'||f_id,
1700: v_fnd_menus_tl(j).user_menu_name,
1701: v_fnd_menus(m).type,
1702: v_fnd_menus_tl(j).description,
1703: v_fnd_menus(m).creation_date,
1704: v_fnd_menus(m).created_by,

Line 1702: v_fnd_menus_tl(j).description,

1698: t_menu_id,
1699: 'FND_FUNCTION_'||f_id,
1700: v_fnd_menus_tl(j).user_menu_name,
1701: v_fnd_menus(m).type,
1702: v_fnd_menus_tl(j).description,
1703: v_fnd_menus(m).creation_date,
1704: v_fnd_menus(m).created_by,
1705: v_fnd_menus(m).last_update_date,
1706: v_fnd_menus(m).last_updated_by,

Line 1710: WHEN v_fnd_menus_tl(j).menu_id = v_fnd_menus(m).menu_id;

1706: v_fnd_menus(m).last_updated_by,
1707: v_fnd_menus(m).last_update_login);
1708:
1709: EXIT
1710: WHEN v_fnd_menus_tl(j).menu_id = v_fnd_menus(m).menu_id;
1711:
1712: END IF;
1713:
1714: END LOOP;