APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_WOR

Line 349: delete from eam_forecast_wor

345: delete from eam_forecast_wo
346: where forecast_id = p_forecast_id
347: AND wip_entity_id = p_wip_id;
348:
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

Line 380: delete from eam_forecast_wor

376:
377: delete from eam_forecast_wo
378: where forecast_id = p_forecast_id;
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;

Line 404: delete from eam_forecast_wor

400:
401: delete from eam_forecast_wo
402: where forecast_id = p_forecast_id;
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;

Line 2108: INSERT INTO EAM_FORECAST_WOR (

2104: BEGIN
2105:
2106: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2107:
2108: INSERT INTO EAM_FORECAST_WOR (
2109: WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
2110: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
2111: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
2112: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 2227: from eam_forecast_wor

2223:
2224: debug('DONE Copying WO Op resources');
2225:
2226: select * bulk collect INTO l_wor_table
2227: from eam_forecast_wor
2228: where forecast_id = p_forecast_rec.forecast_id;
2229:
2230:
2231:

Line 2245: insert into eam_forecast_wor values p_wor_table(i);

2241: pragma autonomous_transaction;
2242: BEGIN
2243: debug(' Size of work order operations table BEFORE ' || p_wor_table.COUNT);
2244: FORALL i IN p_wor_table.First..p_wor_table.last
2245: insert into eam_forecast_wor values p_wor_table(i);
2246: commit;
2247: debug(' Size of work order operations table AFTER ' || p_wor_table.COUNT);
2248: END insert_into_wor_auto;
2249: