[Home] [Help]
357: delete from eam_forecast_wedi
358: where forecast_id = p_forecast_id
359: AND wip_entity_id = p_wip_id;
360:
361: delete from eam_forecast_cebba
362: where forecast_id = p_forecast_id
363: AND wip_entity_id = p_wip_id;
364:
365: end delete_work_order;
385:
386: delete from eam_forecast_wedi
387: where forecast_id = p_forecast_id;
388:
389: delete from eam_forecast_cebba
390: where forecast_id = p_forecast_id;
391:
392: end delete_forecast;
393:
409:
410: delete from eam_forecast_wedi
411: where forecast_id = p_forecast_id;
412:
413: delete from eam_forecast_cebba
414: where forecast_id = p_forecast_id;
415:
416: end delete_forecast_data;
417:
1155: -- Remove non-positive transaction values as well as work orders
1156: -- that have no costs associated with them
1157:
1158: -- delete all costs not within the horizon
1159: delete from eam_forecast_cebba where forecast_id = p_forecast_id AND
1160: period_start_date > (select start_date from gl_periods
1161: where
1162: period_set_name = v_forecast_rec.period_set_name_to
1163: and period_name = v_forecast_rec.period_to);
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);
1171:
1172: delete from eam_forecast_wdj where forecast_id = p_forecast_id and
1173: wip_entity_id
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);
1177:
1178:
1179: -- Standard check of p_commit.
2058: x_msg_data => x_msg_data);
2059:
2060: debug('DONE Copying CEBBA');
2061: select * bulk collect INTO l_cebba_table
2062: from eam_forecast_cebba
2063: where forecast_id = p_forecast_rec.forecast_id;
2064: ROLLBACK;
2065:
2066: insert_into_cebba_auto(l_cebba_table);
2072: IS
2073: pragma autonomous_transaction;
2074: BEGIN
2075: FORALL i IN p_cebba_table.First..p_cebba_table.last
2076: insert into eam_forecast_cebba values p_cebba_table(i);
2077: commit;
2078: END insert_into_cebba_auto;
2079:
2080:
2732: debug(l_hist_cost_tbl(k).PERIOD_YEAR);
2733: debug(l_hist_cost_tbl(k).PERIOD_NUM);
2734:
2735:
2736: INSERT INTO EAM_FORECAST_CEBBA (
2737: PERIOD_SET_NAME, PERIOD_NAME, ACCT_PERIOD_ID,
2738: WIP_ENTITY_ID, ORGANIZATION_ID, OPERATIONS_DEPT_ID,
2739: OPERATION_SEQ_NUM, MAINT_COST_CATEGORY, OWNING_DEPT_ID,
2740: ACCT_VALUE, PERIOD_START_DATE, LAST_UPDATE_DATE,
2776:
2777: ELSE
2778: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2779:
2780: INSERT INTO EAM_FORECAST_CEBBA (
2781: PERIOD_SET_NAME, PERIOD_NAME, ACCT_PERIOD_ID,
2782: WIP_ENTITY_ID, ORGANIZATION_ID, OPERATIONS_DEPT_ID,
2783: OPERATION_SEQ_NUM, MAINT_COST_CATEGORY, OWNING_DEPT_ID,
2784: ACCT_VALUE, PERIOD_START_DATE, LAST_UPDATE_DATE,
3032: AND glp3.period_name = ef2.period_to
3033: )periods,
3034:
3035: (SELECT cebba.wip_entity_id , ef3.forecast_id, cebba.ccid, cebba.period_name AS period_name,SUM(cebba.acct_value) AS cost
3036: FROM eam_forecast_cebba cebba, eam_forecasts ef3
3037: WHERE cebba.forecast_id = ef3.forecast_id
3038: GROUP BY cebba.wip_entity_id, cebba.ccid, cebba.period_name, ef3.forecast_id
3039: ) costs
3040:
3068: SELECT /*+ no_merge */
3069: DISTINCT cebba.wip_entity_id,
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,