APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DP_SCN_ENTRIES_DENORM

Line 14: * uploaded from Demantra into the MSD_DP_SCN_ENTRIES_DENORM table.

10:
11: /*
12: * Procedure Name - ASSIGN_PLAN_NAME_TO_FORECAST
13: * This procedure assigns a user specified name to the forecast
14: * uploaded from Demantra into the MSD_DP_SCN_ENTRIES_DENORM table.
15: *
16: * Parameters -
17: * NewPlanName - Name to be assigned to the recently exported
18: * forecast output.

Line 29: * Update the scenario id in the MSD_DP_SCN_ENTRIES_DENORM table to the Scenario Id generated

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.
31: *
32: * Return Values -
33: * The procedure returns a status. The possible return statuses are:

Line 136: DELETE FROM msd_dp_scn_entries_denorm

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;
138:
139: END IF;
140:

Line 173: UPDATE msd_dp_scn_entries_denorm

169: AND upper(flv.meaning) = upper(gt.table_label);
170:
171:
172: /* Update the scenario id in the denorm table */
173: UPDATE msd_dp_scn_entries_denorm
174: SET scenario_id = x_scenario_id
175: WHERE scenario_id = MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET + x_data_profile_id;
176:
177: ELSE