[Home] [Help]
118: last_update_date = sysdate,
119: last_updated_by = FND_GLOBAL.USER_ID
120: WHERE scenario_id = x_scenario_id;
121:
122: DELETE FROM msd_dp_scenario_output_levels
123: WHERE scenario_id = x_scenario_id;
124:
125: commit;
126:
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,
359: * Given the parameter NewPlanName, create (or replace) an entry in the table MSD_DP_SCENARIOS.
360: * Demand Plan Id - (Hardcoded to) 5555555
361: * Scenario Id - Sequence starting from 8888888
362: *
363: * Using the DataProfileName, populate the table MSD_DP_SCENARIO_OUTPUT_LEVELS with
364: * the levels at which the forecast has been exported.
365: *
366: * Update the scenario id in the MSD_DP_SCN_ENTRIES_DENORM table to the Scenario Id generated
367: * for the given Plan Name.
663: * 2. If the plan_name is assocaited to supply plans and p_delete_assoc is set YES
664: * (OR)
665: * If the plan_name is assocaited NOT to any supply plan
666: * then delete all the data for the plan_name from
667: * msd_dp_scenarios, msd_dp_scenario_output_levels,
668: * msd_dp_scn_entries_denorm, msc_plan_schedules tables
669: *
670: */
671:
740: msd_dem_common_utilities.log_debug (x_del_stmt);
741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
742: msd_dem_common_utilities.log_debug (' ');
743:
744: /* msd_dp_scenario_output_levels */
745: x_del_stmt := 'DELETE FROM msd_dp_scenario_output_levels WHERE scenario_id = ' || x_scenario_id ;
746: EXECUTE IMMEDIATE x_del_stmt;
747: x_count := SQL%ROWCOUNT;
748: COMMIT;
741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
742: msd_dem_common_utilities.log_debug (' ');
743:
744: /* msd_dp_scenario_output_levels */
745: x_del_stmt := 'DELETE FROM msd_dp_scenario_output_levels WHERE scenario_id = ' || x_scenario_id ;
746: EXECUTE IMMEDIATE x_del_stmt;
747: x_count := SQL%ROWCOUNT;
748: COMMIT;
749: