DBA Data[Home] [Help]

APPS.FND_FUNCTION_SECURITY dependencies on FND_MENU_ENTRIES_TL

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