eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_MENU_ENTRIES

Line 17: type t_fnd_menu_entries IS TABLE OF fnd_menu_entries % rowtype;

13:
14: x_rowid VARCHAR2(64);
15: type t_fnd_grants IS TABLE OF fnd_grants % rowtype;
16: type t_fnd_menus IS TABLE OF fnd_menus % rowtype;
17: type t_fnd_menu_entries IS TABLE OF fnd_menu_entries % rowtype;
18: type t_fnd_form_functions IS TABLE OF fnd_form_functions % rowtype;
19:
20: function_id fnd_form_functions.function_id%TYPE;
21: menu_id fnd_menus.menu_id%TYPE;

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 31: v_fnd_menu_entries t_fnd_menu_entries;

27:
28: -- to store existing menus and grants
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;

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 37: v_fnd_menu_entries_new t_fnd_menu_entries;

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;
39: v_fnd_menus_tl_new t_fnd_menus_tl;
40: v_fnd_menu_entries_tl_new t_fnd_menu_entries_tl;
41:

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 223: if v_fnd_menu_entries is not null then

219: -- Delete collections
220: if v_fnd_form_functions is not null then
221: v_fnd_form_functions.DELETE;
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;

Line 224: v_fnd_menu_entries.DELETE;

220: if v_fnd_form_functions is not null then
221: v_fnd_form_functions.DELETE;
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;

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 1479: v_fnd_menu_entries:= t_fnd_menu_entries();

1475: PROCEDURE GET_DELETE_GRANTS(key_id IN NUMBER) IS
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();

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 1499: -- temp table values are in v_fnd_menu_entries_new

1495:
1496: IF v_fnd_form_functions(i).function_id IS NOT NULL THEN
1497:
1498:
1499: -- temp table values are in v_fnd_menu_entries_new
1500: SELECT *bulk collect
1501: INTO v_fnd_menu_entries_new
1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;

Line 1501: INTO v_fnd_menu_entries_new

1497:
1498:
1499: -- temp table values are in v_fnd_menu_entries_new
1500: SELECT *bulk collect
1501: INTO v_fnd_menu_entries_new
1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries

Line 1502: FROM fnd_menu_entries

1498:
1499: -- temp table values are in v_fnd_menu_entries_new
1500: SELECT *bulk collect
1501: INTO v_fnd_menu_entries_new
1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);

Line 1505: -- appended table values are in v_fnd_menu_entries

1501: INTO v_fnd_menu_entries_new
1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);
1507: menu_entry_count := v_fnd_menu_entries.last;
1508:
1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then

Line 1506: v_fnd_menu_entries.extend(1);

1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);
1507: menu_entry_count := v_fnd_menu_entries.last;
1508:
1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then
1510:

Line 1507: menu_entry_count := v_fnd_menu_entries.last;

1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);
1507: menu_entry_count := v_fnd_menu_entries.last;
1508:
1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then
1510:
1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST

Line 1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then

1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);
1507: menu_entry_count := v_fnd_menu_entries.last;
1508:
1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then
1510:
1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1512: LOOP
1513: v_fnd_menu_entries(menu_entry_count) := v_fnd_menu_entries_new(k);

Line 1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST

1507: menu_entry_count := v_fnd_menu_entries.last;
1508:
1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then
1510:
1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1512: LOOP
1513: v_fnd_menu_entries(menu_entry_count) := v_fnd_menu_entries_new(k);
1514: v_fnd_menu_entries.extend(1);
1515: menu_entry_count :=menu_entry_count+1;

Line 1513: v_fnd_menu_entries(menu_entry_count) := v_fnd_menu_entries_new(k);

1509: if v_fnd_menu_entries_new is not null and v_fnd_menu_entries_new.count > 0 then
1510:
1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1512: LOOP
1513: v_fnd_menu_entries(menu_entry_count) := v_fnd_menu_entries_new(k);
1514: v_fnd_menu_entries.extend(1);
1515: menu_entry_count :=menu_entry_count+1;
1516: end loop;
1517:

Line 1514: v_fnd_menu_entries.extend(1);

1510:
1511: FOR k IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1512: LOOP
1513: v_fnd_menu_entries(menu_entry_count) := v_fnd_menu_entries_new(k);
1514: v_fnd_menu_entries.extend(1);
1515: menu_entry_count :=menu_entry_count+1;
1516: end loop;
1517:
1518: end if;

Line 1520: IF v_fnd_menu_entries_new.COUNT > 0 THEN

1516: end loop;
1517:
1518: end if;
1519:
1520: IF v_fnd_menu_entries_new.COUNT > 0 THEN
1521: FOR j IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1522: LOOP
1523: IF v_fnd_menu_entries_new(j).menu_id IS NOT NULL THEN
1524:

Line 1521: FOR j IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST

1517:
1518: end if;
1519:
1520: IF v_fnd_menu_entries_new.COUNT > 0 THEN
1521: FOR j IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
1522: LOOP
1523: IF v_fnd_menu_entries_new(j).menu_id IS NOT NULL THEN
1524:
1525: SELECT *bulk collect

Line 1523: IF v_fnd_menu_entries_new(j).menu_id IS NOT NULL THEN

1519:
1520: IF v_fnd_menu_entries_new.COUNT > 0 THEN
1521: FOR j IN v_fnd_menu_entries_new.FIRST .. v_fnd_menu_entries_new.LAST
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

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 1528: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;

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;
1532: if v_fnd_menu_entries_tl_new is not null and v_fnd_menu_entries_tl_new.count > 0 then

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 1546: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;

1542:
1543: SELECT *bulk collect
1544: INTO v_fnd_menus_new
1545: FROM fnd_menus
1546: WHERE menu_id = v_fnd_menu_entries_new(j).menu_id;
1547:
1548: v_fnd_menus.extend(1);
1549: menu_count := v_fnd_menus.last;
1550:

Line 1614: fnd_menu_entries_pkg.delete_row(v_fnd_menu_entries_new(j).menu_id, v_fnd_menu_entries(j).entry_sequence);

1610: END LOOP;
1611: END IF;
1612:
1613: -- remove menu_entries
1614: fnd_menu_entries_pkg.delete_row(v_fnd_menu_entries_new(j).menu_id, v_fnd_menu_entries(j).entry_sequence);
1615:
1616: END LOOP;
1617: END IF;
1618:

Line 1654: IF v_fnd_menu_entries is not null and v_fnd_menu_entries.count > 0 then

1650: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1651: LOOP
1652: IF v_fnd_form_functions(i).function_name = f_name THEN
1653:
1654: IF v_fnd_menu_entries is not null and v_fnd_menu_entries.count > 0 then
1655:
1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST
1657: LOOP
1658:

Line 1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST

1652: IF v_fnd_form_functions(i).function_name = f_name THEN
1653:
1654: IF v_fnd_menu_entries is not null and v_fnd_menu_entries.count > 0 then
1655:
1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST
1657: LOOP
1658:
1659: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN
1660:

Line 1659: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN

1655:
1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST
1657: LOOP
1658:
1659: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN
1660:
1661: FOR j IN v_fnd_menu_entries_tl.FIRST .. v_fnd_menu_entries_tl.LAST
1662: LOOP
1663:

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

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

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

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

Line 1666: fnd_menu_entries_pkg.insert_row(x_rowid,

1662: LOOP
1663:
1664: IF v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id THEN
1665:
1666: fnd_menu_entries_pkg.insert_row(x_rowid,
1667: t_menu_id,
1668: v_fnd_menu_entries(k).entry_sequence,
1669: v_fnd_menu_entries(k).sub_menu_id,
1670: f_id,

Line 1668: v_fnd_menu_entries(k).entry_sequence,

1664: IF v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id THEN
1665:
1666: fnd_menu_entries_pkg.insert_row(x_rowid,
1667: t_menu_id,
1668: v_fnd_menu_entries(k).entry_sequence,
1669: v_fnd_menu_entries(k).sub_menu_id,
1670: f_id,
1671: v_fnd_menu_entries(k).grant_flag,
1672: v_fnd_menu_entries_tl(j).PROMPT,

Line 1669: v_fnd_menu_entries(k).sub_menu_id,

1665:
1666: fnd_menu_entries_pkg.insert_row(x_rowid,
1667: t_menu_id,
1668: v_fnd_menu_entries(k).entry_sequence,
1669: v_fnd_menu_entries(k).sub_menu_id,
1670: f_id,
1671: v_fnd_menu_entries(k).grant_flag,
1672: v_fnd_menu_entries_tl(j).PROMPT,
1673: v_fnd_menu_entries_tl(j).description,

Line 1671: v_fnd_menu_entries(k).grant_flag,

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

Line 1672: v_fnd_menu_entries_tl(j).PROMPT,

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

Line 1673: v_fnd_menu_entries_tl(j).description,

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

Line 1674: v_fnd_menu_entries(k).creation_date,

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

Line 1675: v_fnd_menu_entries(k).created_by,

1671: v_fnd_menu_entries(k).grant_flag,
1672: v_fnd_menu_entries_tl(j).PROMPT,
1673: v_fnd_menu_entries_tl(j).description,
1674: v_fnd_menu_entries(k).creation_date,
1675: v_fnd_menu_entries(k).created_by,
1676: v_fnd_menu_entries(k).last_update_date,
1677: v_fnd_menu_entries(k).last_updated_by,
1678: v_fnd_menu_entries(k).last_update_login);
1679: EXIT

Line 1676: v_fnd_menu_entries(k).last_update_date,

1672: v_fnd_menu_entries_tl(j).PROMPT,
1673: v_fnd_menu_entries_tl(j).description,
1674: v_fnd_menu_entries(k).creation_date,
1675: v_fnd_menu_entries(k).created_by,
1676: v_fnd_menu_entries(k).last_update_date,
1677: v_fnd_menu_entries(k).last_updated_by,
1678: v_fnd_menu_entries(k).last_update_login);
1679: EXIT
1680: WHEN v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id;

Line 1677: v_fnd_menu_entries(k).last_updated_by,

1673: v_fnd_menu_entries_tl(j).description,
1674: v_fnd_menu_entries(k).creation_date,
1675: v_fnd_menu_entries(k).created_by,
1676: v_fnd_menu_entries(k).last_update_date,
1677: v_fnd_menu_entries(k).last_updated_by,
1678: v_fnd_menu_entries(k).last_update_login);
1679: EXIT
1680: WHEN v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id;
1681:

Line 1678: v_fnd_menu_entries(k).last_update_login);

1674: v_fnd_menu_entries(k).creation_date,
1675: v_fnd_menu_entries(k).created_by,
1676: v_fnd_menu_entries(k).last_update_date,
1677: v_fnd_menu_entries(k).last_updated_by,
1678: v_fnd_menu_entries(k).last_update_login);
1679: EXIT
1680: WHEN v_fnd_menu_entries_tl(j).menu_id = v_fnd_menu_entries(k).menu_id;
1681:
1682: END IF;

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

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

Line 1689: IF v_fnd_menus(m).menu_id = v_fnd_menu_entries(k).menu_id THEN

1685: IF v_fnd_menus is not null and v_fnd_menus.COUNT > 0 THEN
1686: FOR m IN v_fnd_menus.FIRST .. v_fnd_menus.LAST
1687: LOOP
1688:
1689: IF v_fnd_menus(m).menu_id = v_fnd_menu_entries(k).menu_id THEN
1690:
1691: FOR j IN v_fnd_menus_tl.FIRST .. v_fnd_menus_tl.LAST
1692: LOOP
1693: