DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_RES_SHORTAGE

Line 1881: insert into wip_ws_res_shortage(

1877: ',org_id='||g_wip_job_critical_res_tbl(i).ORGANIZATION_ID||
1878: ',wip_entity_id='||g_wip_job_critical_res_tbl(i).WIP_ENTITY_ID||
1879: ',operation_seq_num='||g_wip_job_critical_res_tbl(i).OPERATION_SEQ_NUM);
1880:
1881: insert into wip_ws_res_shortage(
1882: ORGANIZATION_ID,
1883: WIP_ENTITY_ID,
1884: OPERATION_SEQ_NUM,
1885: RESOURCE_ID,

Line 1958: delete from wip_ws_res_shortage

1954: */
1955: PROCEDURE delete_resources(p_org_id NUMBER) IS
1956: BEGIN
1957: wip_ws_util.log_time('delete_resources: Starting to delete org resources');
1958: delete from wip_ws_res_shortage
1959: where organization_id = p_org_id;
1960: wip_ws_util.log_time('delete_resources: Done with deleting org resources');
1961: END delete_resources;
1962: