APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_WS_DL_UTIL

Line 200: wip_ws_dl_util.get_first_dept_resource_shift

196: l_calendar_code varchar2(100);
197: begin
198:
199: l_calendar_code := get_calendar_code(p_organization_id);
200: wip_ws_dl_util.get_first_dept_resource_shift
201: (p_cal_code =>l_calendar_code,
202: p_dept_id =>p_dept_id,
203: p_resource_id =>p_resource_id,
204: p_date =>p_date,

Line 908: wip_ws_dl_util.get_first_dept_resource_shift

904: if (g_logLevel <= wip_constants.trace_logging) then
905: wip_ws_util.trace_log('Record found for Actual Available Hours Calculation');
906: end if;
907: is_aah_record_valid := true;
908: wip_ws_dl_util.get_first_dept_resource_shift
909: (p_cal_code =>l_calendar_code,
910: p_dept_id =>employee.department_id,
911: p_resource_id =>employee.resource_id,
912: p_date =>emp_act_avl_hrs.actual_date,

Line 988: wip_ws_dl_util.get_first_dept_resource_shift

984: if (g_logLevel <= wip_constants.trace_logging) then
985: wip_ws_util.trace_log('Record found for Scheduled Available Hours Calculation');
986: end if;
987: is_sah_record_valid :=true;
988: wip_ws_dl_util.get_first_dept_resource_shift
989: (p_cal_code =>l_calendar_code,
990: p_dept_id =>employee.department_id,
991: p_resource_id =>employee.resource_id,
992: p_date =>emp_sch_avl_hrs.actual_date,

Line 1064: wip_ws_dl_util.get_first_dept_resource_shift

1060: if (g_logLevel <= wip_constants.trace_logging) then
1061: wip_ws_util.trace_log('Record found for Direct Labor Hours Calculation');
1062: end if;
1063: is_dlh_record_valid :=true;
1064: wip_ws_dl_util.get_first_dept_resource_shift
1065: (p_cal_code =>l_calendar_code,
1066: p_dept_id =>employee.department_id,
1067: p_resource_id =>employee.resource_id,
1068: p_date =>emp_dir_lab_hrs.actual_date,