APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_WDJ

Line 341: delete from eam_forecast_wdj where

337:
338: procedure delete_work_order(p_forecast_id IN number, p_wip_id IN number)IS
339:
340: BEGIN
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

Line 374: delete from eam_forecast_wdj where

370:
371: delete from eam_forecasts where
372: forecast_id = p_forecast_id;
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;

Line 398: delete from eam_forecast_wdj where

394: procedure delete_forecast_data(p_forecast_id IN number)IS
395:
396: BEGIN
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;

Line 1145: delete from eam_forecast_wdj where forecast_id = p_forecast_id and wip_entity_id

1141: period_set_name = v_forecast_rec.period_set_name_to
1142: and period_name = v_forecast_rec.period_to);
1143:
1144: -- delete all work orders that have zero costs associated
1145: delete from eam_forecast_wdj where forecast_id = p_forecast_id and wip_entity_id
1146: in
1147: (select wip_entity_id from (select wip_entity_id, sum(acct_value) as total from
1148: eam_forecast_cebba where forecast_id = p_forecast_id
1149: group by wip_entity_id) where total = 0);

Line 1151: delete from eam_forecast_wdj where forecast_id = p_forecast_id and

1147: (select wip_entity_id from (select wip_entity_id, sum(acct_value) as total from
1148: eam_forecast_cebba where forecast_id = p_forecast_id
1149: group by wip_entity_id) where total = 0);
1150:
1151: delete from eam_forecast_wdj where forecast_id = p_forecast_id and
1152: wip_entity_id
1153: not in
1154: (select wip_entity_id from eam_forecast_cebba where forecast_id =
1155: p_forecast_id);

Line 1719: INSERT INTO EAM_FORECAST_WDJ (

1715:
1716: BEGIN
1717: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
1718:
1719: INSERT INTO EAM_FORECAST_WDJ (
1720: WIP_ENTITY_ID, ORGANIZATION_ID, LAST_UPDATE_DATE,
1721: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1722: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
1723: PROGRAM_ID, PROGRAM_UPDATE_DATE, SOURCE_LINE_ID,

Line 1866: from eam_forecast_wdj

1862:
1863: debug('DONE Copying WDJ');
1864:
1865: select * bulk collect INTO l_wdj_table
1866: from eam_forecast_wdj
1867: where forecast_id = p_forecast_rec.forecast_id;
1868: Copy_CEBBA_To_Forecast(
1869: p_api_version => p_api_version,
1870: p_commit => p_commit,

Line 1911: insert into eam_forecast_wdj values p_wdj_table(i);

1907: pragma autonomous_transaction;
1908: BEGIN
1909: debug(' Size of work order table BEFORE ' || p_wdj_table.COUNT);
1910: FORALL i IN p_wdj_table.First..p_wdj_table.last
1911: insert into eam_forecast_wdj values p_wdj_table(i);
1912: commit;
1913: debug(' Size of work order table AFTER ' || p_wdj_table.COUNT);
1914: END insert_into_wdj_auto;
1915:

Line 1925: INSERT INTO EAM_FORECAST_WDJ (

1921: debug(' Size of work order table BEFORE ' || p_wdj_table.COUNT);
1922: FOR i IN 1..p_wdj_table.last
1923: LOOP
1924: debug('inserting : ' || p_wdj_table(i).wip_entity_id);
1925: INSERT INTO EAM_FORECAST_WDJ (
1926: WIP_ENTITY_ID, ORGANIZATION_ID, LAST_UPDATE_DATE,
1927: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1928: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
1929: PROGRAM_ID, PROGRAM_UPDATE_DATE, SOURCE_LINE_ID,

Line 2741: FROM eam_forecasts ef, eam_forecast_wdj job, wip_entities entity,

2737: job.class_code AS CLASS,
2738: pjm_project.all_proj_idtonum(job.project_id) AS PROJECT
2739: )
2740: )))
2741: FROM eam_forecasts ef, eam_forecast_wdj job, wip_entities entity,
2742: mtl_system_items_kfv msi, mtl_serial_numbers msn,
2743: mtl_eam_locations loc, mtl_system_items_kfv msi2,
2744: bom_departments bd, hr_organization_units hou,
2745: