43: PROCEDURE insert_into_cebba_auto(p_cebba_table cebba_table_type);
44:
45: PROCEDURE Extract_Forecast(
46: p_api_version IN NUMBER,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_debug IN VARCHAR2 ,
51: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
44:
45: PROCEDURE Extract_Forecast(
46: p_api_version IN NUMBER,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_debug IN VARCHAR2 ,
51: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2 ,
45: PROCEDURE Extract_Forecast(
46: p_api_version IN NUMBER,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_debug IN VARCHAR2 ,
51: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: x_msg_count OUT NOCOPY NUMBER ,
63: procedure delete_forecast_data(p_forecast_id IN number);
64:
65: PROCEDURE Copy_CEBBA_To_Forecast_auto (
66: p_api_version IN NUMBER,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_debug IN VARCHAR2 ,
71:
64:
65: PROCEDURE Copy_CEBBA_To_Forecast_auto (
66: p_api_version IN NUMBER,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_debug IN VARCHAR2 ,
71:
72: p_forecast_rec IN eam_forecasts%ROWTYPE,
65: PROCEDURE Copy_CEBBA_To_Forecast_auto (
66: p_api_version IN NUMBER,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_debug IN VARCHAR2 ,
71:
72: p_forecast_rec IN eam_forecasts%ROWTYPE,
73: p_wip_id_table IN wo_table_type,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2);
87: PROCEDURE extract_historical_forecast(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_debug IN VARCHAR2 ,
93:
86: x_msg_data OUT NOCOPY VARCHAR2);
87: PROCEDURE extract_historical_forecast(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_debug IN VARCHAR2 ,
93:
94: p_forecast_rec IN eam_forecasts%ROWTYPE,
87: PROCEDURE extract_historical_forecast(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_debug IN VARCHAR2 ,
93:
94: p_forecast_rec IN eam_forecasts%ROWTYPE,
95:
108: x_msg_data OUT NOCOPY VARCHAR2);
109:
110: PROCEDURE extract_autonomous_forecast(
111: p_api_version IN NUMBER,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_debug IN VARCHAR2 ,
116:
109:
110: PROCEDURE extract_autonomous_forecast(
111: p_api_version IN NUMBER,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_debug IN VARCHAR2 ,
116:
117: p_forecast_rec IN eam_forecasts%ROWTYPE,
110: PROCEDURE extract_autonomous_forecast(
111: p_api_version IN NUMBER,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_debug IN VARCHAR2 ,
116:
117: p_forecast_rec IN eam_forecasts%ROWTYPE,
118:
131: x_msg_data OUT NOCOPY VARCHAR2);
132:
133: PROCEDURE Get_HistoricalCosts (
134: p_api_version IN NUMBER,
135: p_commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_debug IN VARCHAR2 ,
139:
132:
133: PROCEDURE Get_HistoricalCosts (
134: p_api_version IN NUMBER,
135: p_commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_debug IN VARCHAR2 ,
139:
140: p_forecast_id IN NUMBER,
133: PROCEDURE Get_HistoricalCosts (
134: p_api_version IN NUMBER,
135: p_commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_debug IN VARCHAR2 ,
139:
140: p_forecast_id IN NUMBER,
141: p_organization_id IN NUMBER,
165: /* This is a private PROCEDURE that extracts a future forecast */
166:
167: PROCEDURE extract_future_forecast (
168: p_api_version IN NUMBER,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_debug IN VARCHAR2 ,
173:
166:
167: PROCEDURE extract_future_forecast (
168: p_api_version IN NUMBER,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_debug IN VARCHAR2 ,
173:
174: p_forecast_rec IN eam_forecasts%ROWTYPE,
167: PROCEDURE extract_future_forecast (
168: p_api_version IN NUMBER,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_debug IN VARCHAR2 ,
173:
174: p_forecast_rec IN eam_forecasts%ROWTYPE,
175:
189:
190:
191: PROCEDURE Copy_WDJ_To_Forecast (
192: p_api_version IN NUMBER,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_debug IN VARCHAR2 ,
197:
190:
191: PROCEDURE Copy_WDJ_To_Forecast (
192: p_api_version IN NUMBER,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_debug IN VARCHAR2 ,
197:
198: p_forecast_rec IN eam_forecasts%ROWTYPE,
191: PROCEDURE Copy_WDJ_To_Forecast (
192: p_api_version IN NUMBER,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_debug IN VARCHAR2 ,
197:
198: p_forecast_rec IN eam_forecasts%ROWTYPE,
199: p_wip_id_table IN wo_table_type,
212: x_msg_data OUT NOCOPY VARCHAR2);
213:
214: PROCEDURE Copy_WDJ_To_Forecast_auto (
215: p_api_version IN NUMBER,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_debug IN VARCHAR2 ,
220:
213:
214: PROCEDURE Copy_WDJ_To_Forecast_auto (
215: p_api_version IN NUMBER,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_debug IN VARCHAR2 ,
220:
221: p_forecast_rec IN eam_forecasts%ROWTYPE,
214: PROCEDURE Copy_WDJ_To_Forecast_auto (
215: p_api_version IN NUMBER,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_debug IN VARCHAR2 ,
220:
221: p_forecast_rec IN eam_forecasts%ROWTYPE,
222: p_wip_id_table IN wo_table_type,
239: procedure delete_forecast(p_forecast_id IN number);
240:
241: PROCEDURE Copy_WOR_To_Forecast (
242: p_api_version IN NUMBER,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_debug IN VARCHAR2 ,
247:
240:
241: PROCEDURE Copy_WOR_To_Forecast (
242: p_api_version IN NUMBER,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_debug IN VARCHAR2 ,
247:
248: p_forecast_rec IN eam_forecasts%ROWTYPE,
241: PROCEDURE Copy_WOR_To_Forecast (
242: p_api_version IN NUMBER,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_debug IN VARCHAR2 ,
247:
248: p_forecast_rec IN eam_forecasts%ROWTYPE,
249: p_wip_id_table IN wo_table_type,
262: x_msg_data OUT NOCOPY VARCHAR2);
263:
264: PROCEDURE Copy_WRO_To_Forecast (
265: p_api_version IN NUMBER,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_debug IN VARCHAR2 ,
270:
263:
264: PROCEDURE Copy_WRO_To_Forecast (
265: p_api_version IN NUMBER,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_debug IN VARCHAR2 ,
270:
271: p_forecast_rec IN eam_forecasts%ROWTYPE,
264: PROCEDURE Copy_WRO_To_Forecast (
265: p_api_version IN NUMBER,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_debug IN VARCHAR2 ,
270:
271: p_forecast_rec IN eam_forecasts%ROWTYPE,
272: p_wip_id_table IN wo_table_type,
285: x_msg_data OUT NOCOPY VARCHAR2);
286:
287: PROCEDURE Copy_WO_To_Forecast (
288: p_api_version IN NUMBER,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_debug IN VARCHAR2 ,
293:
286:
287: PROCEDURE Copy_WO_To_Forecast (
288: p_api_version IN NUMBER,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_debug IN VARCHAR2 ,
293:
294: p_forecast_rec IN eam_forecasts%ROWTYPE,
287: PROCEDURE Copy_WO_To_Forecast (
288: p_api_version IN NUMBER,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_debug IN VARCHAR2 ,
293:
294: p_forecast_rec IN eam_forecasts%ROWTYPE,
295: p_wip_id_table IN wo_table_type,
309:
310:
311: PROCEDURE Copy_CEBBA_To_Forecast (
312: p_api_version IN NUMBER,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_debug IN VARCHAR2 ,
317:
310:
311: PROCEDURE Copy_CEBBA_To_Forecast (
312: p_api_version IN NUMBER,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_debug IN VARCHAR2 ,
317:
318: p_forecast_rec IN eam_forecasts%ROWTYPE,
311: PROCEDURE Copy_CEBBA_To_Forecast (
312: p_api_version IN NUMBER,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_debug IN VARCHAR2 ,
317:
318: p_forecast_rec IN eam_forecasts%ROWTYPE,
319: p_wip_id_table IN wo_table_type,
332: x_msg_data OUT NOCOPY VARCHAR2);
333:
334: PROCEDURE Copy_WEDI_To_Forecast (
335: p_api_version IN NUMBER,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_debug IN VARCHAR2 ,
340:
333:
334: PROCEDURE Copy_WEDI_To_Forecast (
335: p_api_version IN NUMBER,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_debug IN VARCHAR2 ,
340:
341: p_forecast_rec IN eam_forecasts%ROWTYPE,
334: PROCEDURE Copy_WEDI_To_Forecast (
335: p_api_version IN NUMBER,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_debug IN VARCHAR2 ,
340:
341: p_forecast_rec IN eam_forecasts%ROWTYPE,
342: p_wip_id_table IN wo_table_type,