APPS.BSC_MIGREATION_UI dependencies on BSC_PMA_MIG_TMP_RESP_MAP

Line 102: execute immediate 'delete BSC_PMA_MIG_TMP_RESP_MAP';

98: BEGIN
99:
100: l_stmt:= null;
101: -- truncate the table first to remove any data for the same session
102: execute immediate 'delete BSC_PMA_MIG_TMP_RESP_MAP';
103:
104: if(p_process_id is not null) then
105: --this means there is some process on hold
106:

Line 137: INSERT INTO BSC_PMA_MIG_TMP_RESP_MAP VALUES defRespTab(i);

133: CLOSE cv;
134:
135: --now put the data in the temp table
136: FORALL i IN defRespTab.FIRST..defRespTab.LAST
137: INSERT INTO BSC_PMA_MIG_TMP_RESP_MAP VALUES defRespTab(i);
138:
139: num_rows := defRespTab.LAST;
140: else
141: --this means there is no process on hold

Line 165: INSERT INTO BSC_PMA_MIG_TMP_RESP_MAP VALUES defRespTab(i);

161: CLOSE cv;
162:
163: --now put the data in the temp table
164: FORALL i IN defRespTab.FIRST..defRespTab.LAST
165: INSERT INTO BSC_PMA_MIG_TMP_RESP_MAP VALUES defRespTab(i);
166:
167: num_rows := defRespTab.LAST;
168: end if;
169: