DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on EAM_FORECASTS

Line 55: p_forecast_id IN eam_forecasts.forecast_id%TYPE,

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 ,
58: x_msg_data OUT NOCOPY VARCHAR2
59:

Line 78: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
80:
81: --p_acct_period_from IN NUMBER,
82: --p_acct_period_to IN NUMBER,

Line 100: p_forecast_rec IN eam_forecasts%ROWTYPE,

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:
102:
103: --p_acct_period_from IN NUMBER,
104: --p_acct_period_to IN NUMBER,

Line 123: p_forecast_rec IN eam_forecasts%ROWTYPE,

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:
125:
126: --p_acct_period_from IN NUMBER,
127: --p_acct_period_to IN NUMBER,

Line 180: p_forecast_rec IN eam_forecasts%ROWTYPE,

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:
182:
183: --p_acct_period_from IN NUMBER,
184: --p_acct_period_to IN NUMBER,

Line 204: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
206:
207: --p_acct_period_from IN NUMBER,
208: --p_acct_period_to IN NUMBER,

Line 227: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
229:
230: --p_acct_period_from IN NUMBER,
231: --p_acct_period_to IN NUMBER,

Line 254: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
256:
257: --p_acct_period_from IN NUMBER,
258: --p_acct_period_to IN NUMBER,

Line 278: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
280:
281: --p_acct_period_from IN NUMBER,
282: --p_acct_period_to IN NUMBER,

Line 304: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
306:
307: --p_acct_period_from IN NUMBER,
308: --p_acct_period_to IN NUMBER,

Line 329: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
331:
332: --p_acct_period_from IN NUMBER,
333: --p_acct_period_to IN NUMBER,

Line 354: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
356:
357: --p_acct_period_from IN NUMBER,
358: --p_acct_period_to IN NUMBER,

Line 378: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
380:
381: --p_acct_period_from IN NUMBER,
382: --p_acct_period_to IN NUMBER,

Line 402: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
404:
405: --p_acct_period_from IN NUMBER,
406: --p_acct_period_to IN NUMBER,

Line 425: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
427:
428: --p_acct_period_from IN NUMBER,
429: --p_acct_period_to IN NUMBER,

Line 450: p_forecast_rec IN eam_forecasts%ROWTYPE,

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,
452:
453: --p_acct_period_from IN NUMBER,
454: --p_acct_period_to IN NUMBER,

Line 469: FUNCTION get_wip_table(p_forecast_rec eam_forecasts%rowtype)

465:
466: PROCEDURE insert_into_WEDI_auto(p_wedi_table wedi_table_type); --USAF
467:
468: PROCEDURE Populate_Test_Data(p_forecast_id IN NUMBER);
469: FUNCTION get_wip_table(p_forecast_rec eam_forecasts%rowtype)
470: RETURN wo_table_type;
471:
472: FUNCTION get_asset_cursor(p_forecast_rec eam_forecasts%rowtype)
473: RETURN forecast_asset_cursor_type;

Line 472: FUNCTION get_asset_cursor(p_forecast_rec eam_forecasts%rowtype)

468: PROCEDURE Populate_Test_Data(p_forecast_id IN NUMBER);
469: FUNCTION get_wip_table(p_forecast_rec eam_forecasts%rowtype)
470: RETURN wo_table_type;
471:
472: FUNCTION get_asset_cursor(p_forecast_rec eam_forecasts%rowtype)
473: RETURN forecast_asset_cursor_type;
474:
475: FUNCTION get_asset_cursor(p_organization_id IN NUMBER,p_asset_number_from IN VARCHAR2,
476: p_asset_number_to IN VARCHAR2, p_serial_number_from IN VARCHAR2,

Line 481: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)

477: p_serial_number_to IN VARCHAR2 , p_asset_group_from IN VARCHAR2,
478: p_asset_group_to IN VARCHAR2 , p_area_from IN VARCHAR2, p_area_to IN VARCHAR2)
479: RETURN forecast_asset_cursor_type;
480:
481: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)
482: RETURN VARCHAR2;
483:
484: FUNCTION get_asset_query(p_organization_id IN NUMBER,p_asset_number_from IN VARCHAR2,
485: p_asset_number_to IN VARCHAR2, p_serial_number_from IN VARCHAR2,