APPS.WIP_WS_UTIL dependencies on WIP_WS_DL_UTIL

Line 180: wip_ws_dl_util.get_first_shift(l_cal_code, p_dept_id, p_resource_id, l_in_date,

176: l_24hr_resource := 2;
177: end if;
178:
179: if( l_24hr_resource = 2 ) then
180: wip_ws_dl_util.get_first_shift(l_cal_code, p_dept_id, p_resource_id, l_in_date,
181: x_shift_seq, x_shift_num, x_shift_start_date, x_shift_end_date);
182: else
183: wip_ws_dl_util.get_first_calendar_date(l_cal_code, l_in_date,
184: x_shift_seq, x_shift_start_date, x_shift_end_date);

Line 183: wip_ws_dl_util.get_first_calendar_date(l_cal_code, l_in_date,

179: if( l_24hr_resource = 2 ) then
180: wip_ws_dl_util.get_first_shift(l_cal_code, p_dept_id, p_resource_id, l_in_date,
181: x_shift_seq, x_shift_num, x_shift_start_date, x_shift_end_date);
182: else
183: wip_ws_dl_util.get_first_calendar_date(l_cal_code, l_in_date,
184: x_shift_seq, x_shift_start_date, x_shift_end_date);
185: x_shift_num := null;
186: end if;
187:

Line 435: wip_ws_dl_util.get_first_shift(get_calendar_code(p_org_id), p_dept_id, null, l_in_date,

431:
432: /* if the date is null, use sysdate */
433: l_in_date := nvl(p_date, sysdate);
434:
435: wip_ws_dl_util.get_first_shift(get_calendar_code(p_org_id), p_dept_id, null, l_in_date,
436: x_shift_seq, x_shift_num, x_shift_start_date, x_shift_end_date);
437:
438: return trunc(x_shift_start_date);
439:

Line 753: l_req_usage := wip_ws_dl_util.get_col_res_usage_req(

749:
750: l_remaining_usage := null;
751:
752: if( p_resource_seq_num is not null ) then
753: l_req_usage := wip_ws_dl_util.get_col_res_usage_req(
754: p_wip_entity_id, p_op_seq_num, p_department_id, p_resource_id, p_resource_seq_num);
755:
756: l_remaining_usage := nvl(l_req_usage, 0) - 0;
757: end if;