APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_WRO

Line 353: delete from eam_forecast_wro

349: delete from eam_forecast_wor
350: where forecast_id = p_forecast_id
351: AND wip_entity_id = p_wip_id;
352:
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

Line 383: delete from eam_forecast_wro

379:
380: delete from eam_forecast_wor
381: where forecast_id = p_forecast_id;
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;

Line 407: delete from eam_forecast_wro

403:
404: delete from eam_forecast_wor
405: where forecast_id = p_forecast_id;
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;

Line 2283: INSERT INTO EAM_FORECAST_WRO (

2279:
2280: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2281:
2282:
2283: INSERT INTO EAM_FORECAST_WRO (
2284: INVENTORY_ITEM_ID, ORGANIZATION_ID, WIP_ENTITY_ID,
2285: OPERATION_SEQ_NUM, REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
2286: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
2287: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 2406: from eam_forecast_wro

2402:
2403: debug('DONE Copying WO Op resources');
2404:
2405: select * bulk collect INTO l_wro_table
2406: from eam_forecast_wro
2407: where forecast_id = p_forecast_rec.forecast_id;
2408:
2409:
2410:

Line 2424: insert into eam_forecast_wro values p_wro_table(i);

2420: pragma autonomous_transaction;
2421: BEGIN
2422: debug(' Size of work order materials table BEFORE ' || p_wro_table.COUNT);
2423: FORALL i IN p_wro_table.First..p_wro_table.last
2424: insert into eam_forecast_wro values p_wro_table(i);
2425: commit;
2426: debug(' Size of work order materials table AFTER ' || p_wro_table.COUNT);
2427: END insert_into_wro_auto;
2428: