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_DEMAND_PLANS

Line 518: Delete from MSD_DEMAND_PLANS; -- commit;

514: PROCEDURE COPY_DP_DEMAND_PLANS IS
515:
516: BEGIN
517:
518: Delete from MSD_DEMAND_PLANS; -- commit;
519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DEMAND_PLANS '|| SQL%ROWCOUNT);
520: v_sql_stmt:=
521: 'Insert into MSD_DEMAND_PLANS ('
522: || 'DEMAND_PLAN_ID,'

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

515:
516: BEGIN
517:
518: Delete from MSD_DEMAND_PLANS; -- commit;
519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DEMAND_PLANS '|| SQL%ROWCOUNT);
520: v_sql_stmt:=
521: 'Insert into MSD_DEMAND_PLANS ('
522: || 'DEMAND_PLAN_ID,'
523: || 'ORGANIZATION_ID,'

Line 521: 'Insert into MSD_DEMAND_PLANS ('

517:
518: Delete from MSD_DEMAND_PLANS; -- commit;
519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DEMAND_PLANS '|| SQL%ROWCOUNT);
520: v_sql_stmt:=
521: 'Insert into MSD_DEMAND_PLANS ('
522: || 'DEMAND_PLAN_ID,'
523: || 'ORGANIZATION_ID,'
524: || 'SR_INSTANCE_ID,'
525: || 'DEMAND_PLAN_NAME,'

Line 650: || ' from MSD_DEMAND_PLANS'|| v_aps_dblink

646: || 'BUILD_STRIPE_STREAM_DESIG,'
647: || 'BUILD_STRIPE_STREAM_REF_NUM,'
648: || 'USE_ORG_SPECIFIC_BOM_FLAG,'
649: || 'DELETE_REQUEST_ID'
650: || ' from MSD_DEMAND_PLANS'|| v_aps_dblink
651: || ' where sr_instance_id = '|| v_instance_id;
652:
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
654: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;

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

649: || 'DELETE_REQUEST_ID'
650: || ' from MSD_DEMAND_PLANS'|| v_aps_dblink
651: || ' where sr_instance_id = '|| v_instance_id;
652:
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
654: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;

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

651: || ' where sr_instance_id = '|| v_instance_id;
652:
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
654: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;
658:
659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');

Line 659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');

655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;
658:
659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');
660: v_sql_stmt:=
661: 'Insert into MSD_DEMAND_PLANS ('
662: || 'DEMAND_PLAN_ID,'
663: || 'DEMAND_PLAN_NAME,'

Line 661: 'Insert into MSD_DEMAND_PLANS ('

657: Commit;
658:
659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');
660: v_sql_stmt:=
661: 'Insert into MSD_DEMAND_PLANS ('
662: || 'DEMAND_PLAN_ID,'
663: || 'DEMAND_PLAN_NAME,'
664: || 'ORGANIZATION_ID,'
665: || 'SR_INSTANCE_ID,'

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

678: || ':v_creation_date,'
679: || ':v_created_by,'
680: || 'NULL)';
681:
682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
683: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id,v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted for demantra into MSD_DEMAND_PLANS is :- '||sql%rowcount);
685:
686: Commit;

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

680: || 'NULL)';
681:
682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
683: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id,v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted for demantra into MSD_DEMAND_PLANS is :- '||sql%rowcount);
685:
686: Commit;
687:
688: END COPY_DP_DEMAND_PLANS;