DBA Data[Home] [Help]

APPS.FND_FUNCTION dependencies on FND_MENU_ENTRIES

Line 44: /* That involves reading the FND_MENU_ENTRIES table, which is considered */

40: G_BULK_COLLECTS_SUPPORTED VARCHAR2(30) := 'TRUE';
41:
42: /* This table stores marks while being called from row level db triggers,*/
43: /* because those row level db triggers can't actually mark the menu */
44: /* That involves reading the FND_MENU_ENTRIES table, which is considered */
45: /* a mutating table. So we store the marks here and then process them in*/
46: /* the after statement trigger. */
47: TBL_QUEUED_MENU_ID NUMBER_TABLE_TYPE;
48: TBL_QUEUED_MENU_ID_MAX NUMBER := 0;

Line 265: from fnd_menu_entries

261:
262: /* Cursor to get menu entries on a particular menu.*/
263: cursor get_mnes_c is
264: SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG
265: from fnd_menu_entries
266: where MENU_ID = l_sub_menu_id;
267:
268: menulist_cur pls_integer;
269: menulist_size pls_integer;

Line 623: from fnd_menu_entries

619:
620: /* Cursor to get menu entries that have a submenu*/
621: cursor get_mnes_w_sm_c is
622: SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG
623: from fnd_menu_entries
624: where SUB_MENU_ID = l_sub_menu_id;
625:
626: entry_excluded boolean;
627: already_in_list boolean;

Line 2186: from fnd_menu_entries

2182: result boolean;
2183: dummy number;
2184: cursor get_mnes_down_c is
2185: SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG
2186: from fnd_menu_entries
2187: where MENU_ID = p_menu_id;
2188:
2189: TYPE NUMBER_TABLE_TYPE is table of NUMBER INDEX BY BINARY_INTEGER;
2190: TYPE VARCHAR2_TABLE_TYPE is table of VARCHAR2(1) INDEX BY BINARY_INTEGER;