APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 26: * Using the DataProfileName, populate the table MSD_DP_SCENARIO_OUTPUT_LEVELS with

22: * Given the parameter NewPlanName, create (or replace) an entry in the table MSD_DP_SCENARIOS.
23: * Demand Plan Id - (Hardcoded to) 5555555
24: * Scenario Id - Sequence starting from 8888888
25: *
26: * Using the DataProfileName, populate the table MSD_DP_SCENARIO_OUTPUT_LEVELS with
27: * the levels at which the forecast has been exported.
28: *
29: * Update the scenario id in the MSD_DP_SCN_ENTRIES_DENORM table to the Scenario Id generated
30: * for the given Plan Name.

Line 133: DELETE FROM msd_dp_scenario_output_levels

129: last_update_date = sysdate,
130: last_updated_by = FND_GLOBAL.USER_ID
131: WHERE scenario_id = x_scenario_id;
132:
133: DELETE FROM msd_dp_scenario_output_levels
134: WHERE scenario_id = x_scenario_id;
135:
136: DELETE FROM msd_dp_scn_entries_denorm
137: WHERE scenario_id = x_scenario_id;

Line 143: INSERT INTO msd_dp_scenario_output_levels (

139: END IF;
140:
141:
142: /* Populate output levels for the forecast data */
143: INSERT INTO msd_dp_scenario_output_levels (
144: demand_plan_id,
145: scenario_id,
146: level_id,
147: last_update_date,