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_FUNCTION_SECURITY dependencies on FND_MENU_ENTRIES

Line 104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f

100: dummy NUMBER;
101: BEGIN
102: SELECT 1
103: INTO dummy
104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f
105: WHERE me.menu_id = m.menu_id
106: AND m.menu_name = menu_entry_exists.menu_name
107: AND me.sub_menu_id = s.menu_id (+)
108: AND nvl(s.menu_name, 'x') = nvl(menu_entry_exists.sub_menu_name, 'x')

Line 478: FROM fnd_menu_entries me

474: INTO dummy
475: FROM sys.dual
476: WHERE NOT EXISTS
477: (SELECT 1
478: FROM fnd_menu_entries me
479: WHERE me.function_id = form_function.function_id);
480:
481: SELECT 1
482: INTO dummy

Line 681: FROM fnd_menu_entries

677: AND action_id = menu.menu_id;
678:
679: CURSOR MN_ENTRY is
680: SELECT sub_menu_id, function_id
681: FROM fnd_menu_entries
682: WHERE menu_id = menu.menu_id;
683:
684: BEGIN
685:

Line 706: FROM fnd_menu_entries me

702: INTO dummy
703: FROM sys.dual
704: WHERE NOT EXISTS
705: (SELECT 1
706: FROM fnd_menu_entries me
707: WHERE me.sub_menu_id = menu.menu_id);
708:
709: SELECT 1
710: INTO dummy

Line 733: DELETE FROM fnd_menu_entries

729: DELETE FROM fnd_menus_tl
730: WHERE menu_id = menu.menu_id;
731:
732: -- Cascade delete to menu entries and resp functions
733: DELETE FROM fnd_menu_entries
734: WHERE menu_id = menu.menu_id;
735:
736: -- Added for Function Security Cache Invalidation Project.
737: -- Need make sure that each menu entry deleted is taken into account.

Line 743: DELETE FROM fnd_menu_entries_tl

739: fnd_function_security_cache.delete_menu_entry(menu.menu_id,
740: mn.sub_menu_id, mn.function_id);
741: END LOOP;
742:
743: DELETE FROM fnd_menu_entries_tl
744: WHERE menu_id = menu.menu_id;
745:
746: DELETE FROM fnd_resp_functions rf
747: WHERE rf.rule_type = 'M'

Line 923: FROM fnd_menu_entries fme

919: -- Find local entry sequence matching submenu/function pair.
920: BEGIN
921: SELECT fme.entry_sequence
922: INTO l_entry_sequence
923: FROM fnd_menu_entries fme
924: WHERE fme.menu_id = menu_entry.menu_id
925: AND nvl(fme.sub_menu_id, -1) = nvl(menu_entry.sub_menu_id, -1)
926: AND nvl(fme.function_id, -1) = nvl(menu_entry.function_id, -1);
927: EXCEPTION

Line 942: FROM fnd_menu_entries

938: -- previous values determined above since those values may have failed
939: -- in the matching test previous to this code.
940: SELECT sub_menu_id, function_id
941: INTO menu_entry.sub_menu_id, menu_entry.function_id
942: FROM fnd_menu_entries
943: WHERE menu_id = menu_entry.menu_id
944: AND entry_sequence = l_entry_sequence;
945:
946: DELETE FROM fnd_menu_entries

Line 946: DELETE FROM fnd_menu_entries

942: FROM fnd_menu_entries
943: WHERE menu_id = menu_entry.menu_id
944: AND entry_sequence = l_entry_sequence;
945:
946: DELETE FROM fnd_menu_entries
947: WHERE menu_id = menu_entry.menu_id
948: AND entry_sequence = l_entry_sequence;
949:
950: -- Added for Function Security Cache Invalidation Project.

Line 956: DELETE FROM fnd_menu_entries_tl

952: -- derived above.
953: fnd_function_security_cache.delete_menu_entry(menu_entry.menu_id,
954: menu_entry.sub_menu_id, menu_entry.function_id);
955:
956: DELETE FROM fnd_menu_entries_tl
957: WHERE menu_id = menu_entry.menu_id
958: AND entry_sequence = l_entry_sequence;
959:
960: RETURN;

Line 967: FROM fnd_menu_entries

963: -- Select to decide if this is insert or update
964: BEGIN
965: SELECT menu_id
966: INTO menu_entry.menu_id
967: FROM fnd_menu_entries
968: WHERE menu_id = menu_entry.menu_id
969: AND entry_sequence = l_entry_sequence;
970: EXCEPTION
971: WHEN no_data_found THEN

Line 973: INSERT INTO fnd_menu_entries (

969: AND entry_sequence = l_entry_sequence;
970: EXCEPTION
971: WHEN no_data_found THEN
972: -- Insert into base
973: INSERT INTO fnd_menu_entries (
974: menu_id,
975: entry_sequence,
976: sub_menu_id,
977: function_id,

Line 1001: INSERT INTO fnd_menu_entries_tl (

997: fnd_function_security_cache.insert_menu_entry(menu_entry.menu_id,
998: menu_entry.sub_menu_id, menu_entry.function_id);
999:
1000: -- Insert into _TL
1001: INSERT INTO fnd_menu_entries_tl (
1002: LANGUAGE,
1003: menu_id,
1004: entry_sequence,
1005: PROMPT,

Line 1032: UPDATE fnd_menu_entries

1028: RETURN;
1029: END;
1030:
1031: -- Update base
1032: UPDATE fnd_menu_entries
1033: SET sub_menu_id = menu_entry.sub_menu_id,
1034: function_id = menu_entry.function_id,
1035: last_update_date = sysdate,
1036: last_updated_by = 1,

Line 1046: UPDATE fnd_menu_entries_tl

1042: fnd_function_security_cache.update_menu_entry(menu_entry.menu_id,
1043: menu_entry.sub_menu_id, menu_entry.function_id);
1044:
1045: -- Update TL
1046: UPDATE fnd_menu_entries_tl
1047: SET PROMPT = menu_entry.PROMPT,
1048: description = menu_entry.description,
1049: last_update_date = sysdate,
1050: last_updated_by = 1,

Line 1182: FROM FND_MENU_ENTRIES

1178: newid NUMBER;
1179:
1180: CURSOR MNU_ENTRY IS
1181: SELECT MENU_ID, ENTRY_SEQUENCE, SUB_MENU_ID
1182: FROM FND_MENU_ENTRIES
1183: WHERE FUNCTION_ID = newid;
1184:
1185: CURSOR RESP_FUNC IS
1186: SELECT APPLICATION_ID, RESPONSIBILITY_ID

Line 1241: UPDATE FND_MENU_ENTRIES

1237: -- 2. Delete new row
1238: -- 3. Update oldname to newname in old row
1239:
1240: -- 1. Reset Fks to all point to old row
1241: UPDATE FND_MENU_ENTRIES
1242: SET FUNCTION_ID = oldid
1243: WHERE FUNCTION_ID = newid;
1244:
1245: -- Added for Function Security Cache Invalidation Project.

Line 1326: FROM FND_MENU_ENTRIES

1322: AND action_id = newid;
1323:
1324: CURSOR mn_entry IS
1325: SELECT SUB_MENU_ID, FUNCTION_ID
1326: FROM FND_MENU_ENTRIES
1327: WHERE MENU_ID = newid;
1328:
1329: BEGIN
1330: -- Find which menu names have already been changed

Line 1379: UPDATE FND_MENU_ENTRIES

1375: -- 2. Delete new row
1376: -- 3. Update oldname to newname in old row
1377:
1378: -- 1. Reset Fks to all point to old row
1379: UPDATE FND_MENU_ENTRIES
1380: SET SUB_MENU_ID = oldid
1381: WHERE MENU_ID = newid;
1382:
1383: -- Added for Function Security Cache Invalidation Project.

Line 1399: UPDATE FND_MENU_ENTRIES

1395: FOR rs IN RESP_CURSOR LOOP
1396: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
1397: END LOOP;
1398:
1399: UPDATE FND_MENU_ENTRIES
1400: SET MENU_ID = oldid
1401: WHERE MENU_ID = newid;
1402:
1403: -- Added for Function Security Cache Invalidation Project.

Line 1409: UPDATE FND_MENU_ENTRIES_TL

1405: FOR mn IN mn_entry LOOP
1406: fnd_function_security_cache.update_menu_entry(newid, mn.sub_menu_id, mn.function_id);
1407: END LOOP;
1408:
1409: UPDATE FND_MENU_ENTRIES_TL
1410: SET MENU_ID = oldid
1411: WHERE MENU_ID = newid;
1412:
1413: UPDATE FND_RESP_FUNCTIONS