eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MIGREATION_UI dependencies on BSC_PMA_MIG_TMP_OBJ_LIST

Line 188: execute immediate 'delete from BSC_PMA_MIG_TMP_OBJ_LIST';

184: l_stmt varchar2(2000);
185:
186: BEGIN
187: -- truncate the table first to remove any data for the same session
188: execute immediate 'delete from BSC_PMA_MIG_TMP_OBJ_LIST';
189:
190: if(p_process_id is not null and pFetchMode = '1') then
191: -- get the configuration from bsc_db_loader_process
192: -- need to fetch indicators

Line 207: INSERT INTO BSC_PMA_MIG_TMP_OBJ_LIST VALUES l_obj_list(i);

203: CLOSE cv;
204:
205: --now put the data in the temp table
206: FORALL i IN l_obj_list.FIRST..l_obj_list.LAST
207: INSERT INTO BSC_PMA_MIG_TMP_OBJ_LIST VALUES l_obj_list(i);
208: elsif(p_process_id is not null and pFetchMode = '2') then
209: -- get the configuration from bsc_db_loader_process
210: -- need to fetch tabs
211: l_stmt:= 'Select DISTINCT K.TAB_ID, K.NAME

Line 225: INSERT INTO BSC_PMA_MIG_TMP_OBJ_LIST VALUES l_obj_list(i);

221: CLOSE cv;
222:
223: --now put the data in the temp table
224: FORALL i IN l_obj_list.FIRST..l_obj_list.LAST
225: INSERT INTO BSC_PMA_MIG_TMP_OBJ_LIST VALUES l_obj_list(i);
226: end if;
227:
228: END;
229: