DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_COMP_SHORTAGE

Line 1803: insert into wip_ws_comp_shortage(

1799: wip_ws_util.trace_log('WIP_WS_SHORTAGE:insert_components:inv_item='||g_wip_job_critical_comp_tbl(i).INVENTORY_ITEM_ID||
1800: ',org_id='||g_wip_job_critical_comp_tbl(i).ORGANIZATION_ID||
1801: ',wip_entity_id='||g_wip_job_critical_comp_tbl(i).WIP_ENTITY_ID||
1802: ',operation_seq_num='||g_wip_job_critical_comp_tbl(i).OPERATION_SEQ_NUM);
1803: insert into wip_ws_comp_shortage(
1804: ORGANIZATION_ID,
1805: WIP_ENTITY_ID,
1806: OPERATION_SEQ_NUM,
1807: INVENTORY_ITEM_ID,

Line 1946: delete from wip_ws_comp_shortage

1942: */
1943: PROCEDURE delete_components (p_org_id NUMBER) IS
1944: BEGIN
1945: wip_ws_util.log_time('delete_components: Starting to delete org components');
1946: delete from wip_ws_comp_shortage
1947: where organization_id = p_org_id;
1948: wip_ws_util.log_time('delete_components: Done with deleting org components');
1949: END delete_components;
1950: