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 1166: delete from eam_forecast_wdj where forecast_id = p_forecast_id and wip_entity_id

1162: period_set_name = v_forecast_rec.period_set_name_to
1163: and period_name = v_forecast_rec.period_to);
1164:
1165: -- delete all work orders that have zero costs associated
1166: delete from eam_forecast_wdj where forecast_id = p_forecast_id and wip_entity_id
1167: in
1168: (select wip_entity_id from (select wip_entity_id, sum(acct_value) as total from
1169: eam_forecast_cebba where forecast_id = p_forecast_id
1170: group by wip_entity_id) where total = 0);

Line 1172: delete from eam_forecast_wdj where forecast_id = p_forecast_id and

1168: (select wip_entity_id from (select wip_entity_id, sum(acct_value) as total from
1169: eam_forecast_cebba where forecast_id = p_forecast_id
1170: group by wip_entity_id) where total = 0);
1171:
1172: delete from eam_forecast_wdj where forecast_id = p_forecast_id and
1173: wip_entity_id
1174: not in
1175: (select wip_entity_id from eam_forecast_cebba where forecast_id =
1176: p_forecast_id);

Line 1740: INSERT INTO EAM_FORECAST_WDJ (

1736:
1737: BEGIN
1738: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
1739:
1740: INSERT INTO EAM_FORECAST_WDJ (
1741: WIP_ENTITY_ID, ORGANIZATION_ID, LAST_UPDATE_DATE,
1742: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1743: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
1744: PROGRAM_ID, PROGRAM_UPDATE_DATE, SOURCE_LINE_ID,

Line 1887: from eam_forecast_wdj

1883:
1884: debug('DONE Copying WDJ');
1885:
1886: select * bulk collect INTO l_wdj_table
1887: from eam_forecast_wdj
1888: where forecast_id = p_forecast_rec.forecast_id;
1889:
1890: debug(' Size of work order table ' || l_wdj_table.COUNT);
1891: --ROLLBACK; --USAF

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

1899: pragma autonomous_transaction;
1900: BEGIN
1901: debug(' Size of work order table BEFORE ' || p_wdj_table.COUNT);
1902: FORALL i IN p_wdj_table.First..p_wdj_table.last
1903: insert into eam_forecast_wdj values p_wdj_table(i);
1904: commit;
1905: debug(' Size of work order table AFTER ' || p_wdj_table.COUNT);
1906: END insert_into_wdj_auto;
1907:

Line 1917: INSERT INTO EAM_FORECAST_WDJ (

1913: debug(' Size of work order table BEFORE ' || p_wdj_table.COUNT);
1914: FOR i IN 1..p_wdj_table.last
1915: LOOP
1916: debug('inserting : ' || p_wdj_table(i).wip_entity_id);
1917: INSERT INTO EAM_FORECAST_WDJ (
1918: WIP_ENTITY_ID, ORGANIZATION_ID, LAST_UPDATE_DATE,
1919: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1920: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
1921: PROGRAM_ID, PROGRAM_UPDATE_DATE, SOURCE_LINE_ID,

Line 3074: eam_forecast_wdj job, mtl_system_items_kfv msi,

3070: cebba.ccid,
3071: cebba.forecast_id AS id
3072: FROM eam_forecast_cebba cebba
3073: WHERE cebba.forecast_id = :6) efc,
3074: eam_forecast_wdj job, mtl_system_items_kfv msi,
3075: eam_forecasts ef, wip_entities entity,
3076: mtl_serial_numbers msn,
3077: csi_item_instances cii,
3078: mtl_eam_locations loc, mtl_system_items_kfv msi2,