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 394: wip_ws_dl_util.get_first_shift(get_calendar_code(p_org_id), p_dept_id, null, l_in_date,

390:
391: /* if the date is null, use sysdate */
392: l_in_date := nvl(p_date, sysdate);
393:
394: wip_ws_dl_util.get_first_shift(get_calendar_code(p_org_id), p_dept_id, null, l_in_date,
395: x_shift_seq, x_shift_num, x_shift_start_date, x_shift_end_date);
396:
397: return trunc(x_shift_start_date);
398:

Line 712: l_req_usage := wip_ws_dl_util.get_col_res_usage_req(

708:
709: l_remaining_usage := null;
710:
711: if( p_resource_seq_num is not null ) then
712: l_req_usage := wip_ws_dl_util.get_col_res_usage_req(
713: p_wip_entity_id, p_op_seq_num, p_department_id, p_resource_id, p_resource_seq_num);
714:
715: l_remaining_usage := nvl(l_req_usage, 0) - 0;
716: end if;