DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_COMP_SHORTAGE

Line 1874: insert into wip_ws_comp_shortage(

1870: wip_ws_util.trace_log('WIP_WS_SHORTAGE:insert_components:inv_item='||g_wip_job_critical_comp_tbl(i).INVENTORY_ITEM_ID||
1871: ',org_id='||g_wip_job_critical_comp_tbl(i).ORGANIZATION_ID||
1872: ',wip_entity_id='||g_wip_job_critical_comp_tbl(i).WIP_ENTITY_ID||
1873: ',operation_seq_num='||g_wip_job_critical_comp_tbl(i).OPERATION_SEQ_NUM);
1874: insert into wip_ws_comp_shortage(
1875: ORGANIZATION_ID,
1876: WIP_ENTITY_ID,
1877: OPERATION_SEQ_NUM,
1878: INVENTORY_ITEM_ID,

Line 2017: delete from wip_ws_comp_shortage

2013: */
2014: PROCEDURE delete_components (p_org_id NUMBER) IS
2015: BEGIN
2016: wip_ws_util.log_time('delete_components: Starting to delete org components');
2017: delete from wip_ws_comp_shortage
2018: where organization_id = p_org_id;
2019: wip_ws_util.log_time('delete_components: Done with deleting org components');
2020: END delete_components;
2021: