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.MSC_CL_COPY_DP_FORECAST dependencies on MSD_DP_SCENARIOS

Line 314: Delete from MSD_DP_SCENARIOS;-- commit;

310: PROCEDURE COPY_DP_SCENARIOS IS
311:
312: BEGIN
313:
314: Delete from MSD_DP_SCENARIOS;-- commit;
315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIOS '|| SQL%ROWCOUNT);
316:
317: v_sql_stmt:=
318: 'INSERT INTO MSD_DP_SCENARIOS ('

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

311:
312: BEGIN
313:
314: Delete from MSD_DP_SCENARIOS;-- commit;
315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIOS '|| SQL%ROWCOUNT);
316:
317: v_sql_stmt:=
318: 'INSERT INTO MSD_DP_SCENARIOS ('
319: || 'DEMAND_PLAN_ID,'

Line 318: 'INSERT INTO MSD_DP_SCENARIOS ('

314: Delete from MSD_DP_SCENARIOS;-- commit;
315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIOS '|| SQL%ROWCOUNT);
316:
317: v_sql_stmt:=
318: 'INSERT INTO MSD_DP_SCENARIOS ('
319: || 'DEMAND_PLAN_ID,'
320: || 'SCENARIO_ID,'
321: || 'SCENARIO_NAME,'
322: || 'DESCRIPTION,'

Line 417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;

413: || 'ERROR_TYPE,'
414: || 'DMD_PRIORITY_SCENARIO_ID,'
415: || 'SC_TYPE,'
416: || 'ASSOCIATE_PARAMETER'
417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;
418:
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
420: EXECUTE IMMEDIATE v_sql_stmt;
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);

Line 419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);

415: || 'SC_TYPE,'
416: || 'ASSOCIATE_PARAMETER'
417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;
418:
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
420: EXECUTE IMMEDIATE v_sql_stmt;
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;

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

417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;
418:
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
420: EXECUTE IMMEDIATE v_sql_stmt;
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;
424:
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );

Line 425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );

421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;
424:
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );
426: v_sql_stmt:=
427: 'INSERT INTO MSD_DP_SCENARIOS ('
428: || 'DEMAND_PLAN_ID,'
429: || 'SCENARIO_ID,'

Line 427: 'INSERT INTO MSD_DP_SCENARIOS ('

423: Commit;
424:
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );
426: v_sql_stmt:=
427: 'INSERT INTO MSD_DP_SCENARIOS ('
428: || 'DEMAND_PLAN_ID,'
429: || 'SCENARIO_ID,'
430: || 'SCENARIO_NAME,'
431: || 'LAST_REVISION,'

Line 450: || ' and not exists (select 1 from MSD_DP_SCENARIOS RP '

446: || ':v_creation_date ,'
447: || ':v_created_by '
448: || ' from msd_dp_ascp_scenarios_v'|| v_aps_dblink || ' APS'
449: || ' where DEMAND_PLAN_ID = ' ||5555555
450: || ' and not exists (select 1 from MSD_DP_SCENARIOS RP '
451: ||' where RP.scenario_id = APS.SCENARIO_ID)';
452:
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
454: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;

Line 453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);

449: || ' where DEMAND_PLAN_ID = ' ||5555555
450: || ' and not exists (select 1 from MSD_DP_SCENARIOS RP '
451: ||' where RP.scenario_id = APS.SCENARIO_ID)';
452:
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
454: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);
456:
457: Commit;

Line 455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);

451: ||' where RP.scenario_id = APS.SCENARIO_ID)';
452:
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
454: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);
456:
457: Commit;
458:
459: END COPY_DP_SCENARIOS;