APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS_S

Line 5215: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;

5211: end if;
5212:
5213:
5214:
5215: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
5216:
5217:
5218:
5219: insert into msd_dp_scenarios

Line 7812: update msd_dp_scenarios set supply_plan_name=p_supply_plan_name, supply_plan_id=p_supply_plan_id

7808: fetch c1 into l_count;
7809: close c1;
7810:
7811: if l_count > 0 then
7812: update msd_dp_scenarios set supply_plan_name=p_supply_plan_name, supply_plan_id=p_supply_plan_id
7813: where demand_plan_id=p_new_dp_id
7814: and supply_plan_flag='Y'
7815: and associate_parameter is not null
7816: and supply_plan_id<>p_supply_plan_id;

Line 7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;

7816: and supply_plan_id<>p_supply_plan_id;
7817: else
7818: for c2_rec in c2
7819: loop
7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;