APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_RES_SHORTAGE

Line 1952: insert into wip_ws_res_shortage(

1948: ',org_id='||g_wip_job_critical_res_tbl(i).ORGANIZATION_ID||
1949: ',wip_entity_id='||g_wip_job_critical_res_tbl(i).WIP_ENTITY_ID||
1950: ',operation_seq_num='||g_wip_job_critical_res_tbl(i).OPERATION_SEQ_NUM);
1951:
1952: insert into wip_ws_res_shortage(
1953: ORGANIZATION_ID,
1954: WIP_ENTITY_ID,
1955: OPERATION_SEQ_NUM,
1956: RESOURCE_ID,

Line 2029: delete from wip_ws_res_shortage

2025: */
2026: PROCEDURE delete_resources(p_org_id NUMBER) IS
2027: BEGIN
2028: wip_ws_util.log_time('delete_resources: Starting to delete org resources');
2029: delete from wip_ws_res_shortage
2030: where organization_id = p_org_id;
2031: wip_ws_util.log_time('delete_resources: Done with deleting org resources');
2032: END delete_resources;
2033: