APPS.MRP_ADJUST_DATES_PK dependencies on MRP_FORECAST_DATES

Line 80: FROM mrp_forecast_dates

76: SELECT 'x' into string_buffer
77: FROM dual
78: WHERE exists
79: (SELECT forecast_date
80: FROM mrp_forecast_dates
81: WHERE organization_id = org_id);
82: forecast_exists := TRUE;
83: EXCEPTION
84: WHEN NO_DATA_FOUND THEN

Line 126: -- in mrp_forecast_dates

122: AND schedule_level=2);
123: statement := 2;
124: END IF;
125: -- Check if enough data exists in the calendar to cover the current dates
126: -- in mrp_forecast_dates
127: IF forecast_exists THEN
128:
129: SELECT 'x' INTO string_buffer
130: FROM dual

Line 133: FROM mrp_forecast_dates

129: SELECT 'x' INTO string_buffer
130: FROM dual
131: WHERE NOT EXISTS
132: (SELECT forecast_date
133: FROM mrp_forecast_dates
134: WHERE organization_id = org_id
135: AND forecast_date < min_date)
136: AND NOT EXISTS
137: (SELECT forecast_date

Line 138: FROM mrp_forecast_dates

134: WHERE organization_id = org_id
135: AND forecast_date < min_date)
136: AND NOT EXISTS
137: (SELECT forecast_date
138: FROM mrp_forecast_dates
139: WHERE organization_id = org_id
140: AND DECODE(rate_end_date, NULL, forecast_date,
141: rate_end_date) > max_date);
142: END IF;

Line 219: UPDATE mrp_forecast_dates dates

215: END IF;
216: -- Set daily forecast entries to be valid dates
217: IF forecast_exists THEN
218:
219: UPDATE mrp_forecast_dates dates
220: SET /* dates.last_update_date = SYSDATE,
221: dates.last_updated_by = user_id, */
222: dates.forecast_date =
223: (SELECT prior_date

Line 233: UPDATE mrp_forecast_dates dates

229: AND dates.organization_id = org_id;
230:
231: -- Set end dates for daily forecast entries to be valid dates
232:
233: UPDATE mrp_forecast_dates dates
234: SET /* dates.last_update_date = SYSDATE,
235: dates.last_updated_by = user_id, */
236: dates.rate_end_date =
237: (SELECT prior_date

Line 248: UPDATE mrp_forecast_dates dates

244: AND organization_id = org_id;
245:
246: -- Set weekly forecast entries to be valid dates
247:
248: UPDATE mrp_forecast_dates dates
249: SET /* dates.last_update_date = SYSDATE,
250: dates.last_updated_by = user_id, */
251: dates.forecast_date =
252: (SELECT MAX(week_start_date)

Line 263: UPDATE mrp_forecast_dates dates

259:
260:
261: -- Set weekly end dates to be valid dates
262:
263: UPDATE mrp_forecast_dates dates
264: SET /* dates.last_update_date = SYSDATE,
265: dates.last_updated_by = user_id, */
266: dates.rate_end_date =
267: (SELECT MAX(week_start_date)

Line 278: UPDATE mrp_forecast_dates dates

274: AND dates.organization_id = org_id;
275:
276: -- Set monthly forecast entries to be valid dates
277:
278: UPDATE mrp_forecast_dates dates
279: SET /* dates.last_update_date = SYSDATE,
280: dates.last_updated_by = user_id, */
281: dates.forecast_date =
282: (SELECT MAX(period_start_date)

Line 292: UPDATE mrp_forecast_dates dates

288: AND dates.organization_id = org_id;
289:
290: -- Set monthly end dates to be valid dates
291:
292: UPDATE mrp_forecast_dates dates
293: SET /* dates.last_update_date = SYSDATE,
294: dates.last_updated_by = user_id, */
295: dates.rate_end_date =
296: (SELECT MAX(period_start_date)