APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_DL_UTIL

Line 1116: 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,

1112: select distinct
1113: wor.wip_entity_id,
1114: wor.operation_seq_num,
1115: wor.resource_id,
1116: 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,
1117: wor.uom_code,
1118: decode( wip_ws_time_entry.is_time_uom(wor.uom_code), 'Y',
1119: inv_convert.inv_um_convert(-1,
1120: 38,

Line 2056: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(

2052: end loop;
2053:
2054: --first time this row is accessed
2055: if((l_res_avail_date is NULL) OR (l_res_avail_shift is null)) then
2056: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(
2057: p_org_id,
2058: g_wip_job_critical_res_tbl(i).DEPARTMENT_ID,
2059: g_wip_job_critical_res_tbl(i).RESOURCE_ID,
2060: g_wip_job_critical_res_tbl(i).SHIFT_SEQ,

Line 2081: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(

2077:
2078: else
2079: --found a job resource that is working on a different date or shift then critical record
2080: --in this case we need to refill the resource availability
2081: l_res_onhand_qty := wip_ws_dl_util.get_shift_capacity(
2082: p_org_id,
2083: g_wip_job_critical_res_tbl(i).DEPARTMENT_ID,
2084: g_wip_job_critical_res_tbl(i).RESOURCE_ID,
2085: g_wip_job_critical_res_tbl(i).SHIFT_SEQ,