APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSD_DP_SCENARIOS

Line 141: SELECT MSD_DP_SCENARIOS_S.NEXTVAL INTO ScenarioId FROM DUAL;

137: ScenarioName IN VARCHAR2
138: ) AS
139: BEGIN
140: BEGIN
141: SELECT MSD_DP_SCENARIOS_S.NEXTVAL INTO ScenarioId FROM DUAL;
142:
143: INSERT INTO msd_dp_scenarios
144: (
145: demand_plan_id, scenario_id, scenario_name, forecast_based_on,

Line 143: INSERT INTO msd_dp_scenarios

139: BEGIN
140: BEGIN
141: SELECT MSD_DP_SCENARIOS_S.NEXTVAL INTO ScenarioId FROM DUAL;
142:
143: INSERT INTO msd_dp_scenarios
144: (
145: demand_plan_id, scenario_id, scenario_name, forecast_based_on,
146: last_update_date, last_updated_by, creation_date, created_by
147: )

Line 214: FROM msd_dp_scenarios

210: BEGIN
211: BEGIN
212: SELECT scenario_id
213: INTO ScenarioId
214: FROM msd_dp_scenarios
215: WHERE
216: demand_plan_id = DemandPlanId AND
217: scenario_name = ScenarioName;
218: EXCEPTION