DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_12X_PKG8 dependencies on FND_MENU_ENTRIES

Line 17: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f

13: -- query to get all menu entries to be deleted
14: -- note: will only delete entry if it has not been modified
15: cursor c_get_menu_entries is
16: ( select me.menu_id, me.entry_sequence
17: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
18: where m.menu_id = me.menu_id
19: and me.function_id = f.function_id
20: and me.last_updated_by in (120,121,122)
21: and m.menu_name='CSD_DEPOT_MENU'

Line 25: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f

21: and m.menu_name='CSD_DEPOT_MENU'
22: and f.function_name in ('CSDHVR', 'CSDSRRCL', 'MRPCHORG' )
23: union all
24: select me.menu_id, me.entry_sequence
25: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
26: where m.menu_id = me.menu_id
27: and me.function_id = f.function_id
28: and me.last_updated_by in (120,121,122)
29: and m.menu_name='CSD_SETUP_MENU'

Line 36: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f

32: 'CSDDEFCODE', 'CSDRBIRSSET', 'CSDRBIDRSET', 'CSDRBIETSET',
33: 'CSDRECLSET', 'CSDRECSTMP', 'CSDFLSTS_RCL', 'CSD_REGION_GEOGRAPHY_SETUP')
34: union all
35: select me.menu_id, me.entry_sequence
36: from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
37: where m.menu_id = me.menu_id
38: and me.function_id = f.function_id
39: and me.last_updated_by in (120,121,122)
40: and m.menu_name='CSD_OTHER_MENU'

Line 66: FND_MENU_ENTRIES_PKG.DELETE_ROW (

62: FETCH c_get_menu_entries BULK COLLECT INTO l_menu_id_arr, l_menu_entry_id_arr LIMIT MAX_BUFFER_SIZE;
63:
64: FOR i IN 1..l_menu_entry_id_arr.COUNT
65: LOOP
66: FND_MENU_ENTRIES_PKG.DELETE_ROW (
67: X_MENU_ID => l_menu_id_arr(i),
68: X_ENTRY_SEQUENCE => l_menu_entry_id_arr(i)
69: );
70: END LOOP;