APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DEM_UPLOAD_FORECAST

Line 73: || ' AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ';

69: /* Check if the Data Profile Name specified is present inside Demantra or not */
70: x_sql_stmt := 'SELECT nvl(sum(tq.id), 0) '
71: || ' FROM msd_dem_transfer_query tq '
72: || ' WHERE tq.query_name = ''' || x_data_profile_name || ''''
73: || ' AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ';
74: EXECUTE IMMEDIATE x_sql_stmt INTO x_data_profile_id;
75:
76:
77: IF (x_data_profile_id <> 0)

Line 84: || ' WHERE mds.demand_plan_id = ' || MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID

80:
81: /* Check if the given New Plan Name already exists */
82: x_sql_stmt := 'SELECT nvl(sum(scenario_id), 0) '
83: || ' FROM msd_dp_scenarios mds '
84: || ' WHERE mds.demand_plan_id = ' || MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID
85: || ' AND mds.scenario_name = ''' || x_new_plan_name || '''';
86: EXECUTE IMMEDIATE x_sql_stmt INTO x_scenario_id;
87:
88:

Line 110: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,

106: last_updated_by,
107: creation_date,
108: created_by )
109: VALUES (
110: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,
111: x_scenario_id,
112: x_new_plan_name,
113: substr(x_data_profile_name,1,30),
114: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),

Line 114: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),

110: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,
111: x_scenario_id,
112: x_new_plan_name,
113: substr(x_data_profile_name,1,30),
114: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
115: msd_dem_upload_forecast.get_error_type(x_data_profile_id),
116: C_ASSOCIATE_PARAMETER,
117: sysdate,
118: FND_GLOBAL.USER_ID,

Line 115: msd_dem_upload_forecast.get_error_type(x_data_profile_id),

111: x_scenario_id,
112: x_new_plan_name,
113: substr(x_data_profile_name,1,30),
114: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
115: msd_dem_upload_forecast.get_error_type(x_data_profile_id),
116: C_ASSOCIATE_PARAMETER,
117: sysdate,
118: FND_GLOBAL.USER_ID,
119: sysdate,

Line 127: sc_type = msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),

123:
124: UPDATE msd_dp_scenarios
125: SET
126: forecast_based_on = substr(x_data_profile_name,1,30),
127: sc_type = msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
128: error_type = msd_dem_upload_forecast.get_error_type(x_data_profile_id),
129: last_update_date = sysdate,
130: last_updated_by = FND_GLOBAL.USER_ID
131: WHERE scenario_id = x_scenario_id;

Line 128: error_type = msd_dem_upload_forecast.get_error_type(x_data_profile_id),

124: UPDATE msd_dp_scenarios
125: SET
126: forecast_based_on = substr(x_data_profile_name,1,30),
127: sc_type = msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),
128: error_type = msd_dem_upload_forecast.get_error_type(x_data_profile_id),
129: last_update_date = sysdate,
130: last_updated_by = FND_GLOBAL.USER_ID
131: WHERE scenario_id = x_scenario_id;
132:

Line 152: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,

148: last_updated_by,
149: creation_date,
150: created_by )
151: SELECT
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,

Line 175: WHERE scenario_id = MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET + x_data_profile_id;

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
178: status := 'INVALID_DATA_PROFILE';
179: RETURN;