47: PROCEDURE insert_into_cebba_auto(p_cebba_table cebba_table_type);
48:
49: PROCEDURE Extract_Forecast(
50: p_api_version IN NUMBER,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_debug IN VARCHAR2 ,
55: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
48:
49: PROCEDURE Extract_Forecast(
50: p_api_version IN NUMBER,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_debug IN VARCHAR2 ,
55: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
56: x_return_status OUT NOCOPY VARCHAR2 ,
49: PROCEDURE Extract_Forecast(
50: p_api_version IN NUMBER,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_debug IN VARCHAR2 ,
55: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
69: procedure delete_forecast_data(p_forecast_id IN number);
70:
71: PROCEDURE Copy_CEBBA_To_Forecast_auto (
72: p_api_version IN NUMBER,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_debug IN VARCHAR2 ,
77:
70:
71: PROCEDURE Copy_CEBBA_To_Forecast_auto (
72: p_api_version IN NUMBER,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_debug IN VARCHAR2 ,
77:
78: p_forecast_rec IN eam_forecasts%ROWTYPE,
71: PROCEDURE Copy_CEBBA_To_Forecast_auto (
72: p_api_version IN NUMBER,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_debug IN VARCHAR2 ,
77:
78: p_forecast_rec IN eam_forecasts%ROWTYPE,
79: p_wip_id_table IN wo_table_type,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2);
93: PROCEDURE extract_historical_forecast(
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_debug IN VARCHAR2 ,
99:
92: x_msg_data OUT NOCOPY VARCHAR2);
93: PROCEDURE extract_historical_forecast(
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_debug IN VARCHAR2 ,
99:
100: p_forecast_rec IN eam_forecasts%ROWTYPE,
93: PROCEDURE extract_historical_forecast(
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_debug IN VARCHAR2 ,
99:
100: p_forecast_rec IN eam_forecasts%ROWTYPE,
101:
114: x_msg_data OUT NOCOPY VARCHAR2);
115:
116: PROCEDURE extract_autonomous_forecast(
117: p_api_version IN NUMBER,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_debug IN VARCHAR2 ,
122:
115:
116: PROCEDURE extract_autonomous_forecast(
117: p_api_version IN NUMBER,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_debug IN VARCHAR2 ,
122:
123: p_forecast_rec IN eam_forecasts%ROWTYPE,
116: PROCEDURE extract_autonomous_forecast(
117: p_api_version IN NUMBER,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_debug IN VARCHAR2 ,
122:
123: p_forecast_rec IN eam_forecasts%ROWTYPE,
124:
137: x_msg_data OUT NOCOPY VARCHAR2);
138:
139: PROCEDURE Get_HistoricalCosts (
140: p_api_version IN NUMBER,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_debug IN VARCHAR2 ,
145:
138:
139: PROCEDURE Get_HistoricalCosts (
140: p_api_version IN NUMBER,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_debug IN VARCHAR2 ,
145:
146: p_forecast_id IN NUMBER,
139: PROCEDURE Get_HistoricalCosts (
140: p_api_version IN NUMBER,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_debug IN VARCHAR2 ,
145:
146: p_forecast_id IN NUMBER,
147: p_organization_id IN NUMBER,
171: /* This is a private PROCEDURE that extracts a future forecast */
172:
173: PROCEDURE extract_future_forecast (
174: p_api_version IN NUMBER,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_debug IN VARCHAR2 ,
179:
172:
173: PROCEDURE extract_future_forecast (
174: p_api_version IN NUMBER,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_debug IN VARCHAR2 ,
179:
180: p_forecast_rec IN eam_forecasts%ROWTYPE,
173: PROCEDURE extract_future_forecast (
174: p_api_version IN NUMBER,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_debug IN VARCHAR2 ,
179:
180: p_forecast_rec IN eam_forecasts%ROWTYPE,
181:
195:
196:
197: PROCEDURE Copy_WDJ_To_Forecast (
198: p_api_version IN NUMBER,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_debug IN VARCHAR2 ,
203:
196:
197: PROCEDURE Copy_WDJ_To_Forecast (
198: p_api_version IN NUMBER,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_debug IN VARCHAR2 ,
203:
204: p_forecast_rec IN eam_forecasts%ROWTYPE,
197: PROCEDURE Copy_WDJ_To_Forecast (
198: p_api_version IN NUMBER,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_debug IN VARCHAR2 ,
203:
204: p_forecast_rec IN eam_forecasts%ROWTYPE,
205: p_wip_id_table IN wo_table_type,
218: x_msg_data OUT NOCOPY VARCHAR2);
219:
220: PROCEDURE Copy_WDJ_To_Forecast_auto (
221: p_api_version IN NUMBER,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_debug IN VARCHAR2 ,
226:
219:
220: PROCEDURE Copy_WDJ_To_Forecast_auto (
221: p_api_version IN NUMBER,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_debug IN VARCHAR2 ,
226:
227: p_forecast_rec IN eam_forecasts%ROWTYPE,
220: PROCEDURE Copy_WDJ_To_Forecast_auto (
221: p_api_version IN NUMBER,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_debug IN VARCHAR2 ,
226:
227: p_forecast_rec IN eam_forecasts%ROWTYPE,
228: p_wip_id_table IN wo_table_type,
245: procedure delete_forecast(p_forecast_id IN number);
246:
247: PROCEDURE Copy_WOR_To_Forecast (
248: p_api_version IN NUMBER,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_debug IN VARCHAR2 ,
253:
246:
247: PROCEDURE Copy_WOR_To_Forecast (
248: p_api_version IN NUMBER,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_debug IN VARCHAR2 ,
253:
254: p_forecast_rec IN eam_forecasts%ROWTYPE,
247: PROCEDURE Copy_WOR_To_Forecast (
248: p_api_version IN NUMBER,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_debug IN VARCHAR2 ,
253:
254: p_forecast_rec IN eam_forecasts%ROWTYPE,
255: p_wip_id_table IN wo_table_type,
269:
270: --USAF
271: PROCEDURE Copy_WOR_To_Forecast_auto (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_debug IN VARCHAR2 ,
277:
270: --USAF
271: PROCEDURE Copy_WOR_To_Forecast_auto (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_debug IN VARCHAR2 ,
277:
278: p_forecast_rec IN eam_forecasts%ROWTYPE,
271: PROCEDURE Copy_WOR_To_Forecast_auto (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_debug IN VARCHAR2 ,
277:
278: p_forecast_rec IN eam_forecasts%ROWTYPE,
279: p_wip_id_table IN wo_table_type,
295:
296:
297: PROCEDURE Copy_WRO_To_Forecast (
298: p_api_version IN NUMBER,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_debug IN VARCHAR2 ,
303:
296:
297: PROCEDURE Copy_WRO_To_Forecast (
298: p_api_version IN NUMBER,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_debug IN VARCHAR2 ,
303:
304: p_forecast_rec IN eam_forecasts%ROWTYPE,
297: PROCEDURE Copy_WRO_To_Forecast (
298: p_api_version IN NUMBER,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_debug IN VARCHAR2 ,
303:
304: p_forecast_rec IN eam_forecasts%ROWTYPE,
305: p_wip_id_table IN wo_table_type,
320: --USAF
321:
322: PROCEDURE Copy_WRO_To_Forecast_auto (
323: p_api_version IN NUMBER,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327: p_debug IN VARCHAR2 ,
328:
321:
322: PROCEDURE Copy_WRO_To_Forecast_auto (
323: p_api_version IN NUMBER,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327: p_debug IN VARCHAR2 ,
328:
329: p_forecast_rec IN eam_forecasts%ROWTYPE,
322: PROCEDURE Copy_WRO_To_Forecast_auto (
323: p_api_version IN NUMBER,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327: p_debug IN VARCHAR2 ,
328:
329: p_forecast_rec IN eam_forecasts%ROWTYPE,
330: p_wip_id_table IN wo_table_type,
345: PROCEDURE insert_into_wro_auto(p_wro_table wro_table_type); --USAF
346:
347: PROCEDURE Copy_WO_To_Forecast (
348: p_api_version IN NUMBER,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
352: p_debug IN VARCHAR2 ,
353:
346:
347: PROCEDURE Copy_WO_To_Forecast (
348: p_api_version IN NUMBER,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
352: p_debug IN VARCHAR2 ,
353:
354: p_forecast_rec IN eam_forecasts%ROWTYPE,
347: PROCEDURE Copy_WO_To_Forecast (
348: p_api_version IN NUMBER,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
352: p_debug IN VARCHAR2 ,
353:
354: p_forecast_rec IN eam_forecasts%ROWTYPE,
355: p_wip_id_table IN wo_table_type,
369:
370: --USAF
371: PROCEDURE Copy_WO_To_Forecast_auto (
372: p_api_version IN NUMBER,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: p_debug IN VARCHAR2 ,
377:
370: --USAF
371: PROCEDURE Copy_WO_To_Forecast_auto (
372: p_api_version IN NUMBER,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: p_debug IN VARCHAR2 ,
377:
378: p_forecast_rec IN eam_forecasts%ROWTYPE,
371: PROCEDURE Copy_WO_To_Forecast_auto (
372: p_api_version IN NUMBER,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: p_debug IN VARCHAR2 ,
377:
378: p_forecast_rec IN eam_forecasts%ROWTYPE,
379: p_wip_id_table IN wo_table_type,
393:
394:
395: PROCEDURE Copy_CEBBA_To_Forecast (
396: p_api_version IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_debug IN VARCHAR2 ,
401:
394:
395: PROCEDURE Copy_CEBBA_To_Forecast (
396: p_api_version IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_debug IN VARCHAR2 ,
401:
402: p_forecast_rec IN eam_forecasts%ROWTYPE,
395: PROCEDURE Copy_CEBBA_To_Forecast (
396: p_api_version IN NUMBER,
397: p_commit IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_debug IN VARCHAR2 ,
401:
402: p_forecast_rec IN eam_forecasts%ROWTYPE,
403: p_wip_id_table IN wo_table_type,
416: x_msg_data OUT NOCOPY VARCHAR2);
417:
418: PROCEDURE Copy_WEDI_To_Forecast (
419: p_api_version IN NUMBER,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_debug IN VARCHAR2 ,
424:
417:
418: PROCEDURE Copy_WEDI_To_Forecast (
419: p_api_version IN NUMBER,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_debug IN VARCHAR2 ,
424:
425: p_forecast_rec IN eam_forecasts%ROWTYPE,
418: PROCEDURE Copy_WEDI_To_Forecast (
419: p_api_version IN NUMBER,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_debug IN VARCHAR2 ,
424:
425: p_forecast_rec IN eam_forecasts%ROWTYPE,
426: p_wip_id_table IN wo_table_type,
441:
442: --USAF
443: PROCEDURE Copy_WEDI_To_Forecast_auto (
444: p_api_version IN NUMBER,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
448: p_debug IN VARCHAR2 ,
449:
442: --USAF
443: PROCEDURE Copy_WEDI_To_Forecast_auto (
444: p_api_version IN NUMBER,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
448: p_debug IN VARCHAR2 ,
449:
450: p_forecast_rec IN eam_forecasts%ROWTYPE,
443: PROCEDURE Copy_WEDI_To_Forecast_auto (
444: p_api_version IN NUMBER,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
448: p_debug IN VARCHAR2 ,
449:
450: p_forecast_rec IN eam_forecasts%ROWTYPE,
451: p_wip_id_table IN wo_table_type,