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_SCENARIO_OUTPUT_LEVELS

Line 694: Delete from MSD_DP_SCENARIO_OUTPUT_LEVELS;-- Commit;

690: PROCEDURE COPY_MSD_DP_SCENARIO_OP_LEVELS IS
691:
692: BEGIN
693:
694: Delete from MSD_DP_SCENARIO_OUTPUT_LEVELS;-- Commit;
695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_OUTPUT_LEVELS '|| SQL%ROWCOUNT);
696:
697: v_sql_stmt:=
698: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('

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

691:
692: BEGIN
693:
694: Delete from MSD_DP_SCENARIO_OUTPUT_LEVELS;-- Commit;
695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_OUTPUT_LEVELS '|| SQL%ROWCOUNT);
696:
697: v_sql_stmt:=
698: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
699: || ' DEMAND_PLAN_ID, '

Line 698: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('

694: Delete from MSD_DP_SCENARIO_OUTPUT_LEVELS;-- Commit;
695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_OUTPUT_LEVELS '|| SQL%ROWCOUNT);
696:
697: v_sql_stmt:=
698: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
699: || ' DEMAND_PLAN_ID, '
700: || ' SCENARIO_ID, '
701: || ' LEVEL_ID, '
702: || ' LAST_UPDATE_DATE, '

Line 725: || ' from MSD_DP_SCENARIO_OUTPUT_LEVELS'|| v_aps_dblink;

721: || ' REQUEST_ID, '
722: || ' PROGRAM_APPLICATION_ID,'
723: || ' PROGRAM_ID, '
724: || ' PROGRAM_UPDATE_DATE '
725: || ' from MSD_DP_SCENARIO_OUTPUT_LEVELS'|| v_aps_dblink;
726:
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
729: EXECUTE IMMEDIATE v_sql_stmt ;

Line 728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);

724: || ' PROGRAM_UPDATE_DATE '
725: || ' from MSD_DP_SCENARIO_OUTPUT_LEVELS'|| v_aps_dblink;
726:
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
729: EXECUTE IMMEDIATE v_sql_stmt ;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;

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

726:
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
729: EXECUTE IMMEDIATE v_sql_stmt ;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;
733:
734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');

Line 734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');

730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;
733:
734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');
735: v_sql_stmt:=
736: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
737: || ' DEMAND_PLAN_ID, '
738: || ' SCENARIO_ID, '

Line 736: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('

732: Commit;
733:
734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');
735: v_sql_stmt:=
736: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
737: || ' DEMAND_PLAN_ID, '
738: || ' SCENARIO_ID, '
739: || ' LEVEL_ID, '
740: || ' LAST_UPDATE_DATE, '

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

762: || ' PROGRAM_UPDATE_DATE '
763: || ' from msd_dp_scn_output_levels_v'|| v_aps_dblink
764: || ' where DEMAND_PLAN_ID = '|| 5555555;
765:
766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
767: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;

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

764: || ' where DEMAND_PLAN_ID = '|| 5555555;
765:
766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
767: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;
771:
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');

Line 772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');

768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;
771:
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');
773: v_sql_stmt:=
774: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
775: || ' DEMAND_PLAN_ID, '
776: || ' SCENARIO_ID, '

Line 774: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('

770: Commit;
771:
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');
773: v_sql_stmt:=
774: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
775: || ' DEMAND_PLAN_ID, '
776: || ' SCENARIO_ID, '
777: || ' LEVEL_ID, '
778: || ' LAST_UPDATE_DATE, '

Line 794: || ' and not exists (select 1 from MSD_DP_SCENARIO_OUTPUT_LEVELS RP '

790: || ' :v_created_by'
791: || ' from msd_dp_ascp_scenarios_v'|| v_aps_dblink ||' APS'
792: || ' where global_scenario_flag = ''N'''
793: || ' and DEMAND_PLAN_ID = '|| 5555555
794: || ' and not exists (select 1 from MSD_DP_SCENARIO_OUTPUT_LEVELS RP '
795: ||' where RP.scenario_id = APS.SCENARIO_ID'
796: ||' and RP.DEMAND_PLAN_ID = APS.DEMAND_PLAN_ID'
797: ||' and RP.level_id = 7)';
798: