APPS.FND_MENU_ENTRIES_PKG dependencies on FND_FUNCTION_SECURITY_CACHE

Line 61: fnd_function_security_cache.insert_menu_entry(X_MENU_ID, X_SUB_MENU_ID, X_FUNCTION_ID);

57: X_LAST_UPDATE_LOGIN
58: );
59:
60: -- Added for Function Security Cache Invalidation Project.
61: fnd_function_security_cache.insert_menu_entry(X_MENU_ID, X_SUB_MENU_ID, X_FUNCTION_ID);
62:
63: insert into FND_MENU_ENTRIES_TL (
64: MENU_ID,
65: ENTRY_SEQUENCE,

Line 258: fnd_function_security_cache.update_menu_entry(X_MENU_ID, L_SUB_MENU_ID, L_FUNCTION_ID);

254: raise no_data_found;
255: else
256: -- This means that a menu entry was updated.
257: -- Added for Function Security Cache Invalidation Project
258: fnd_function_security_cache.update_menu_entry(X_MENU_ID, L_SUB_MENU_ID, L_FUNCTION_ID);
259: fnd_function_security_cache.update_menu_entry(X_MENU_ID, X_SUB_MENU_ID, X_FUNCTION_ID);
260: end if;
261:
262: update FND_MENU_ENTRIES_TL

Line 259: fnd_function_security_cache.update_menu_entry(X_MENU_ID, X_SUB_MENU_ID, X_FUNCTION_ID);

255: else
256: -- This means that a menu entry was updated.
257: -- Added for Function Security Cache Invalidation Project
258: fnd_function_security_cache.update_menu_entry(X_MENU_ID, L_SUB_MENU_ID, L_FUNCTION_ID);
259: fnd_function_security_cache.update_menu_entry(X_MENU_ID, X_SUB_MENU_ID, X_FUNCTION_ID);
260: end if;
261:
262: update FND_MENU_ENTRIES_TL
263: set prompt = X_PROMPT,

Line 343: fnd_function_security_cache.update_menu_entry(X_MENU_ID, l_sub_menu_id, l_function_id);

339: --last_update_login = 0
340: where menu_id = X_MENU_ID
341: and entry_sequence = X_ENTRY_SEQUENCE;
342:
343: fnd_function_security_cache.update_menu_entry(X_MENU_ID, l_sub_menu_id, l_function_id);
344:
345: end BUMP_ROW;
346:
347: /* Overloaded version below */

Line 597: fnd_function_security_cache.delete_menu_entry(mnu_id,

593: -- Added for Function Security Cache Invalidation Project.
594: -- Seems that I need make sure that each menu entry deleted is taken into account.
595: -- This loop uses the cursor c_mnu_entry defined.
596: for mentry in c_mnu_entry loop
597: fnd_function_security_cache.delete_menu_entry(mnu_id,
598: mentry.sub_menu_id, mentry.function_id);
599: end loop;
600:
601: begin

Line 675: fnd_function_security_cache.update_menu_entry(mnu_id, l_sub_menu_id, l_function_id);

671: last_update_login = 0
672: where menu_id = mnu_id
673: and entry_sequence = eseq;
674:
675: fnd_function_security_cache.update_menu_entry(mnu_id, l_sub_menu_id, l_function_id);
676:
677: end if;
678:
679: -- entry found. and sequence has been taken care of if different.

Line 724: fnd_function_security_cache.update_menu_entry(mnu_id, l_sub_menu_id, l_function_id);

720: last_updated_by = f_luby
721: where entry_sequence = X_ENTRY_SEQUENCE
722: and menu_id = mnu_id;
723:
724: fnd_function_security_cache.update_menu_entry(mnu_id, l_sub_menu_id, l_function_id);
725:
726: -- Bug2410699 - Modified condition to ensure that
727: -- an update occurs when the PROMPT or DESCRIPTION
728: -- from the database has a NULL value. Also no

Line 835: fnd_function_security_cache.delete_menu_entry(X_MENU_ID, l_sub_menu_id, l_function_id);

831: -- This means that the menu entry was updated.
832: -- Added for Function Security Cache Invalidation Project
833: -- Acquire sub_menu_id and function_id using menu_id and entry_sequence
834:
835: fnd_function_security_cache.delete_menu_entry(X_MENU_ID, l_sub_menu_id, l_function_id);
836: end if;
837:
838: delete from FND_MENU_ENTRIES_TL
839: where MENU_ID = X_MENU_ID