DBA Data[Home] [Help]

APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS_S

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 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 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: