[Home] [Help]
353: delete from eam_forecast_wro
354: where forecast_id = p_forecast_id
355: AND wip_entity_id = p_wip_id;
356:
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
382:
383: delete from eam_forecast_wro
384: where forecast_id = p_forecast_id;
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;
406:
407: delete from eam_forecast_wro
408: where forecast_id = p_forecast_id;
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;
2831:
2832: debug('WeDI');
2833: FORALL j IN p_wip_id_table.FIRST..p_wip_id_table.LAST
2834:
2835: INSERT INTO EAM_FORECAST_WEDI (
2836: DESCRIPTION, PURCHASING_CATEGORY_ID, DIRECT_ITEM_SEQUENCE_ID,
2837: OPERATION_SEQ_NUM, DEPARTMENT_ID, WIP_ENTITY_ID,
2838: ORGANIZATION_ID, SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_ID,
2839: SUGGESTED_VENDOR_SITE, SUGGESTED_VENDOR_SITE_ID, SUGGESTED_VENDOR_CONTACT,
2930:
2931: debug('DONE Copying WO Op resources');
2932:
2933: select * bulk collect INTO l_wedi_table
2934: from eam_forecast_wedi
2935: where forecast_id = p_forecast_rec.forecast_id;
2936:
2937:
2938:
2948: pragma autonomous_transaction;
2949: BEGIN
2950: debug(' Size of work order materials table BEFORE ' || p_wedi_table.COUNT);
2951: FORALL i IN p_wedi_table.First..p_wedi_table.last
2952: insert into eam_forecast_wedi values p_wedi_table(i);
2953: commit;
2954: debug(' Size of work order materials table AFTER ' || p_wedi_table.COUNT);
2955: END insert_into_wedi_auto;
2956: