103: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
104: msd_dem_upload_forecast.get_error_type(x_data_profile_id),
105: C_ASSOCIATE_PARAMETER,
106: sysdate,
107: FND_GLOBAL.USER_ID,
108: sysdate,
109: FND_GLOBAL.USER_ID);
110:
111: ELSE
105: C_ASSOCIATE_PARAMETER,
106: sysdate,
107: FND_GLOBAL.USER_ID,
108: sysdate,
109: FND_GLOBAL.USER_ID);
110:
111: ELSE
112:
113: UPDATE msd_dp_scenarios
115: forecast_based_on = substrb(x_data_profile_name,1,30),
116: sc_type = msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
117: error_type = msd_dem_upload_forecast.get_error_type(x_data_profile_id),
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;
152: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,
153: x_scenario_id,
154: to_number(flv.lookup_code),
155: sysdate,
156: FND_GLOBAL.USER_ID,
157: sysdate,
158: FND_GLOBAL.USER_ID
159: FROM
160: msd_dem_transfer_query tq,
154: to_number(flv.lookup_code),
155: sysdate,
156: FND_GLOBAL.USER_ID,
157: sysdate,
158: FND_GLOBAL.USER_ID
159: FROM
160: msd_dem_transfer_query tq,
161: msd_dem_transfer_query_levels tql,
162: msd_dem_group_tables gt,