APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_WS_DL_UTIL

Line 194: wip_ws_dl_util.get_first_dept_resource_shift

190: l_calendar_code varchar2(100);
191: begin
192:
193: l_calendar_code := get_calendar_code(p_organization_id);
194: wip_ws_dl_util.get_first_dept_resource_shift
195: (p_cal_code =>l_calendar_code,
196: p_dept_id =>p_dept_id,
197: p_resource_id =>p_resource_id,
198: p_date =>p_date,

Line 876: wip_ws_dl_util.get_first_dept_resource_shift

872: window_end_time)
873: loop
874: l_stmt_num :=110;
875: is_aah_record_valid := true;
876: wip_ws_dl_util.get_first_dept_resource_shift
877: (p_cal_code =>l_calendar_code,
878: p_dept_id =>employee.department_id,
879: p_resource_id =>employee.resource_id,
880: p_date =>emp_act_avl_hrs.actual_date,

Line 950: wip_ws_dl_util.get_first_dept_resource_shift

946: window_end_time)
947: loop
948: l_stmt_num :=170;
949: is_sah_record_valid :=true;
950: wip_ws_dl_util.get_first_dept_resource_shift
951: (p_cal_code =>l_calendar_code,
952: p_dept_id =>employee.department_id,
953: p_resource_id =>employee.resource_id,
954: p_date =>emp_sch_avl_hrs.actual_date,

Line 1019: wip_ws_dl_util.get_first_dept_resource_shift

1015: window_end_time)
1016: loop
1017: l_stmt_num :=220;
1018: is_dlh_record_valid :=true;
1019: wip_ws_dl_util.get_first_dept_resource_shift
1020: (p_cal_code =>l_calendar_code,
1021: p_dept_id =>employee.department_id,
1022: p_resource_id =>employee.resource_id,
1023: p_date =>emp_dir_lab_hrs.actual_date,