APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DEM_UPLOAD_FORECAST

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

58: /* Check if the Data Profile Name specified is present inside Demantra or not */
59: x_sql_stmt := 'SELECT nvl(sum(tq.id), 0) '
60: || ' FROM msd_dem_transfer_query tq '
61: || ' WHERE tq.query_name = ''' || x_data_profile_name || ''''
62: || ' AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ';
63: EXECUTE IMMEDIATE x_sql_stmt INTO x_data_profile_id;
64:
65:
66: IF (x_data_profile_id <> 0)

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

69:
70: /* Check if the given New Plan Name already exists */
71: x_sql_stmt := 'SELECT nvl(sum(scenario_id), 0) '
72: || ' FROM msd_dp_scenarios mds '
73: || ' WHERE mds.demand_plan_id = ' || MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID
74: || ' AND mds.scenario_name = ''' || x_new_plan_name || '''';
75: EXECUTE IMMEDIATE x_sql_stmt INTO x_scenario_id;
76:
77:

Line 99: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,

95: last_updated_by,
96: creation_date,
97: created_by )
98: VALUES (
99: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,
100: x_scenario_id,
101: x_new_plan_name,
102: substrb(x_data_profile_name,1,30),
103: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),

Line 103: msd_dem_upload_forecast.is_global_scenario(x_data_profile_id),

99: MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID,
100: x_scenario_id,
101: x_new_plan_name,
102: substrb(x_data_profile_name,1,30),
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,

Line 104: msd_dem_upload_forecast.get_error_type(x_data_profile_id),

100: x_scenario_id,
101: x_new_plan_name,
102: substrb(x_data_profile_name,1,30),
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,

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

112:
113: UPDATE msd_dp_scenarios
114: SET
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;

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

113: UPDATE msd_dp_scenarios
114: SET
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:

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 281: ' WHERE scenario_id = ' || MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET || '+ ' || x_data_profile_id || ') entries';

277: 'CREATION_DATE, ' ||
278: 'CREATED_BY, ' ||
279: 'LAST_UPDATE_LOGIN ' ||
280: 'FROM msd_dp_scn_entries_denorm ' ||
281: ' WHERE scenario_id = ' || MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET || '+ ' || x_data_profile_id || ') entries';
282: EXECUTE IMMEDIATE x_sql;
283: COMMIT;
284:
285: x_sql := 'DELETE /*+ PARALLEL (msd_dp_scn_entries_denorm,' || x_parallelism_degree

Line 287: || ' WHERE scenario_id =' || MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET || '+ ' || x_data_profile_id;

283: COMMIT;
284:
285: x_sql := 'DELETE /*+ PARALLEL (msd_dp_scn_entries_denorm,' || x_parallelism_degree
286: || ') */ FROM msd_dp_scn_entries_denorm'
287: || ' WHERE scenario_id =' || MSD_DEM_UPLOAD_FORECAST.C_SCENARIO_ID_OFFSET || '+ ' || x_data_profile_id;
288: EXECUTE IMMEDIATE x_sql;
289:
290: COMMIT;
291: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';

Line 699: || ' AND mds.demand_plan_id = ' || MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID

695: /* Get the scenario_id of given Plan scenario id */
696: x_sql_stmt := 'SELECT nvl(sum(scenario_id), 0) '
697: || ' FROM msd_dp_scenarios mds '
698: || ' WHERE associate_parameter = ''Assign Plan Name'' '
699: || ' AND mds.demand_plan_id = ' || MSD_DEM_UPLOAD_FORECAST.C_DEMAND_PLAN_ID
700: || ' AND mds.scenario_id = ' || p_plan_scn_id ;
701:
702: EXECUTE IMMEDIATE x_sql_stmt INTO x_scenario_id ;
703: