DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_WEDI

Line 357: delete from eam_forecast_wedi

353: delete from eam_forecast_wro
354: where forecast_id = p_forecast_id
355: AND wip_entity_id = p_wip_id;
356:
357: delete from eam_forecast_wedi
358: where forecast_id = p_forecast_id
359: AND wip_entity_id = p_wip_id;
360:
361: delete from eam_forecast_cebba

Line 386: delete from eam_forecast_wedi

382:
383: delete from eam_forecast_wro
384: where forecast_id = p_forecast_id;
385:
386: delete from eam_forecast_wedi
387: where forecast_id = p_forecast_id;
388:
389: delete from eam_forecast_cebba
390: where forecast_id = p_forecast_id;

Line 410: delete from eam_forecast_wedi

406:
407: delete from eam_forecast_wro
408: where forecast_id = p_forecast_id;
409:
410: delete from eam_forecast_wedi
411: where forecast_id = p_forecast_id;
412:
413: delete from eam_forecast_cebba
414: where forecast_id = p_forecast_id;

Line 2594: INSERT INTO EAM_FORECAST_WEDI (

2590:
2591: debug('WeDI');
2592: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2593:
2594: INSERT INTO EAM_FORECAST_WEDI (
2595: DESCRIPTION, PURCHASING_CATEGORY_ID, DIRECT_ITEM_SEQUENCE_ID,
2596: OPERATION_SEQ_NUM, DEPARTMENT_ID, WIP_ENTITY_ID,
2597: ORGANIZATION_ID, SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_ID,
2598: SUGGESTED_VENDOR_SITE, SUGGESTED_VENDOR_SITE_ID, SUGGESTED_VENDOR_CONTACT,