APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS

Line 50: from msd_dp_scenarios

46: No_Source_Dp EXCEPTION;
47:
48: cursor cur_scenario is
49: select scenario_id
50: from msd_dp_scenarios
51: where demand_plan_id = p_source_demand_plan_id
52: and (nvl(supply_plan_flag,'N') = 'N'
53: or p_source_demand_plan_id not in
54: (select demand_plan_id

Line 91: from msd_dp_scenarios

87: where demand_plan_id=p_demand_plan_id;
88:
89: cursor replace_associate_param is
90: select scenario_id,associate_parameter
91: from msd_dp_scenarios
92: where demand_plan_id=x_demand_plan_id;
93:
94: l_template_flag varchar2(3);
95:

Line 509: select msd_dp_scenarios_s.nextval into x_new_scenario_id

505: lv_status_id := 40;
506: for lv_cur_scenario_rec in cur_scenario LOOP
507:
508:
509: select msd_dp_scenarios_s.nextval into x_new_scenario_id
510: from dual;
511:
512:
513: INSERT INTO msd_dp_scenarios

Line 513: INSERT INTO msd_dp_scenarios

509: select msd_dp_scenarios_s.nextval into x_new_scenario_id
510: from dual;
511:
512:
513: INSERT INTO msd_dp_scenarios
514: ( DEMAND_PLAN_ID
515: ,SCENARIO_ID
516: ,SCENARIO_NAME
517: ,DESCRIPTION

Line 625: msd_dp_scenarios sce

621: ,sce.SC_TYPE
622: ,sce.ASSOCIATE_PARAMETER
623: ,sce.dmd_priority_scenario_id -- Bug# 4710963
624: FROM
625: msd_dp_scenarios sce
626: WHERE
627: scenario_id = lv_cur_scenario_rec.scenario_id AND demand_plan_id =
628: p_source_demand_plan_id;
629:

Line 631: INSERT INTO msd_dp_scenarios_tl

627: scenario_id = lv_cur_scenario_rec.scenario_id AND demand_plan_id =
628: p_source_demand_plan_id;
629:
630:
631: INSERT INTO msd_dp_scenarios_tl
632: ( DEMAND_PLAN_ID
633: ,SCENARIO_ID
634: ,DESCRIPTION
635: ,LANGUAGE

Line 663: msd_dp_scenarios_tl sce

659: ,NULL
660: ,NULL
661: ,SYSDATE
662: FROM
663: msd_dp_scenarios_tl sce
664: WHERE
665: scenario_id = lv_cur_scenario_rec.scenario_id
666: AND demand_plan_id = p_source_demand_plan_id
667: and USERENV('LANG') = language;

Line 759: update msd_dp_scenarios set associate_parameter = l_par_type where demand_plan_id=x_demand_plan_id and scenario_id=rep_assoc.scenario_id;

755: for rep_assoc in replace_associate_param
756: loop
757: l_par_type := get_parameter_type(p_source_demand_plan_id,rep_assoc.associate_parameter);
758:
759: update msd_dp_scenarios set associate_parameter = l_par_type where demand_plan_id=x_demand_plan_id and scenario_id=rep_assoc.scenario_id;
760: end loop;
761:
762: msd_apply_template_demand_plan.replace_associate_parameters(x_demand_plan_id);
763: