[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* This procedure updates the existing csd_ro_savedsearches table to */
/* support the iSupport multiparty enhancement. The party_id for the */
/* existing records will be updated to default party_id corresponding to*/
/* user_id. */
/* @param. None */
procedure CSD_MENU_RESTRUCTURE_MIG8 is
-- Cursors --
-- query to get all menu entries to be deleted
-- note: will only delete entry if it has not been modified
cursor c_get_menu_entries is
( select me.menu_id, me.entry_sequence
from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
where m.menu_id = me.menu_id
and me.function_id = f.function_id
and me.last_updated_by in (120,121,122)
and m.menu_name='CSD_DEPOT_MENU'
and f.function_name in ('CSDHVR', 'CSDSRRCL', 'MRPCHORG' )
union all
select me.menu_id, me.entry_sequence
from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
where m.menu_id = me.menu_id
and me.function_id = f.function_id
and me.last_updated_by in (120,121,122)
and m.menu_name='CSD_SETUP_MENU'
and f.function_name in ('CSDRTSET', 'CSDDCSET', 'CSDSCSET', 'CSDRECSET',
'CSDFLSTS', 'CSDFSSET', 'CSDQLSET', 'CSDAGSET',
'CSDDEFCODE', 'CSDRBIRSSET', 'CSDRBIDRSET', 'CSDRBIETSET',
'CSDRECLSET', 'CSDRECSTMP', 'CSDFLSTS_RCL', 'CSD_REGION_GEOGRAPHY_SETUP')
union all
select me.menu_id, me.entry_sequence
from fnd_menu_entries me, fnd_menus m, fnd_form_functions f
where m.menu_id = me.menu_id
and me.function_id = f.function_id
and me.last_updated_by in (120,121,122)
and m.menu_name='CSD_OTHER_MENU'
and f.function_name in ('WF_WORKLIST', 'WF_SS_STATUS_MONITOR')
); -- end cusor c_get_menu_entries
FND_MENU_ENTRIES_PKG.DELETE_ROW (
X_MENU_ID => l_menu_id_arr(i),
X_ENTRY_SEQUENCE => l_menu_entry_id_arr(i)
);