APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_DL_UTIL

Line 1185: nvl(wip_ws_dl_util.get_col_res_usage_req(wor.wip_entity_id, wor.operation_seq_num,wo.department_id, wor.resource_id, null),0) open_quantity,

1181: select distinct
1182: wor.wip_entity_id,
1183: wor.operation_seq_num,
1184: wor.resource_id,
1185: nvl(wip_ws_dl_util.get_col_res_usage_req(wor.wip_entity_id, wor.operation_seq_num,wo.department_id, wor.resource_id, null),0) open_quantity,
1186: wor.uom_code,
1187: decode( wip_ws_time_entry.is_time_uom(wor.uom_code), 'Y',
1188: inv_convert.inv_um_convert(-1,
1189: 38,

Line 2127: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(

2123: end loop;
2124:
2125: --first time this row is accessed
2126: if((l_res_avail_date is NULL) OR (l_res_avail_shift is null)) then
2127: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(
2128: p_org_id,
2129: g_wip_job_critical_res_tbl(i).DEPARTMENT_ID,
2130: g_wip_job_critical_res_tbl(i).RESOURCE_ID,
2131: g_wip_job_critical_res_tbl(i).SHIFT_SEQ,

Line 2152: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(

2148:
2149: else
2150: --found a job resource that is working on a different date or shift then critical record
2151: --in this case we need to refill the resource availability
2152: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(
2153: p_org_id,
2154: g_wip_job_critical_res_tbl(i).DEPARTMENT_ID,
2155: g_wip_job_critical_res_tbl(i).RESOURCE_ID,
2156: g_wip_job_critical_res_tbl(i).SHIFT_SEQ,