APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_WO

Line 345: delete from eam_forecast_wo

341: delete from eam_forecast_wdj where
342: forecast_id = p_forecast_id
343: AND wip_entity_id = p_wip_id;
344:
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

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 377: delete from eam_forecast_wo

373:
374: delete from eam_forecast_wdj where
375: forecast_id = p_forecast_id;
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;

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 401: delete from eam_forecast_wo

397:
398: delete from eam_forecast_wdj where
399: forecast_id = p_forecast_id;
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;

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:

Line 2460: INSERT INTO EAM_FORECAST_WO (

2456: BEGIN
2457: debug('COPYING WO');
2458: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2459:
2460: INSERT INTO EAM_FORECAST_WO (
2461: WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2462: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2463: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2464: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 2607: from eam_forecast_wo

2603:
2604: debug('DONE Copying WO Op');
2605:
2606: select * bulk collect INTO l_wop_table
2607: from eam_forecast_wo
2608: where forecast_id = p_forecast_rec.forecast_id;
2609:
2610:
2611:

Line 2625: insert into eam_forecast_wo values p_wop_table(i);

2621: pragma autonomous_transaction;
2622: BEGIN
2623: debug(' Size of work order operations table BEFORE ' || p_wop_table.COUNT);
2624: FORALL i IN p_wop_table.First..p_wop_table.last
2625: insert into eam_forecast_wo values p_wop_table(i);
2626: commit;
2627: debug(' Size of work order operations table AFTER ' || p_wop_table.COUNT);
2628: END insert_into_wop_auto;
2629: