APPS.MSC_CL_COPY_DP_FORECAST dependencies on MSD_DP_SCN_ENTRIES_DENORM

Line 230: DELETE FROM MSD_DP_SCN_ENTRIES_DENORM

226:
227:
228: BEGIN
229:
230: DELETE FROM MSD_DP_SCN_ENTRIES_DENORM
231: WHERE SR_INSTANCE_ID = v_src_instance_id;
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);
233:
234: v_sql_stmt:=

Line 232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);

228: BEGIN
229:
230: DELETE FROM MSD_DP_SCN_ENTRIES_DENORM
231: WHERE SR_INSTANCE_ID = v_src_instance_id;
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);
233:
234: v_sql_stmt:=
235: 'INSERT INTO MSD_DP_SCN_ENTRIES_DENORM ('
236: || 'DEMAND_PLAN_ID,'

Line 235: 'INSERT INTO MSD_DP_SCN_ENTRIES_DENORM ('

231: WHERE SR_INSTANCE_ID = v_src_instance_id;
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);
233:
234: v_sql_stmt:=
235: 'INSERT INTO MSD_DP_SCN_ENTRIES_DENORM ('
236: || 'DEMAND_PLAN_ID,'
237: || 'SCENARIO_ID,'
238: || 'DEMAND_ID,'
239: || 'BUCKET_TYPE,'

Line 294: ||' FROM MSD_DP_SCN_ENTRIES_DENORM'|| v_aps_dblink || ' APS, msc_item_id_lid RP_lid'

290: || 'APS.REQUEST_ID,'
291: || 'APS.PROGRAM_APPLICATION_ID,'
292: || 'APS.PROGRAM_ID,'
293: || 'APS.PROGRAM_UPDATE_DATE'
294: ||' FROM MSD_DP_SCN_ENTRIES_DENORM'|| v_aps_dblink || ' APS, msc_item_id_lid RP_lid'
295: ||' WHERE RP_lid.sr_inventory_item_id = APS.sr_inventory_item_id'
296: ||' AND APS.SR_INSTANCE_ID = '||v_instance_id
297: ||' AND RP_lid.sr_instance_id = '|| v_src_instance_id;
298:

Line 303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCN_ENTRIES_DENORM is :- '||sql%rowcount);

299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into denorm table is :- '||v_sql_stmt);
300:
301: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
302:
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCN_ENTRIES_DENORM is :- '||sql%rowcount);
304:
305: Commit;
306:
307: END COPY_DP_FORECAST;