APPS.WIP_WS_TIME_ENTRY dependencies on WIP_WS_SKILL_CHECK_PVT

Line 2867: l_skill_check := WIP_WS_SKILL_CHECK_PVT.validate_skill_for_clock_in(

2863:
2864: if(l_logLevel <= wip_constants.trace_logging) then
2865: wip_logger.log('is_emp_shift_in = Y', x_status);
2866: end if;
2867: l_skill_check := WIP_WS_SKILL_CHECK_PVT.validate_skill_for_clock_in(
2868: p_wip_entity_id => p_wip_entity_id,
2869: p_op_seq_num => p_operation_seq_num,
2870: p_emp_id => p_employee_id);
2871:

Line 2875: if l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_SUCCESS then

2871:
2872: if(l_logLevel <= wip_constants.trace_logging) then
2873: wip_logger.log('l_skill_check: ' || l_skill_check, x_status);
2874: end if;
2875: if l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_SUCCESS then
2876:
2877: open clock_in_cursor;
2878: fetch clock_in_cursor into l_dummy_var;
2879: if clock_in_cursor%FOUND then

Line 3002: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then

2998:
2999:
3000: x_status := l_clock_status;
3001:
3002: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
3003: x_status := 'P';
3004: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
3005: x_status := 'Q';
3006: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then

Line 3004: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then

3000: x_status := l_clock_status;
3001:
3002: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
3003: x_status := 'P';
3004: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
3005: x_status := 'Q';
3006: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
3007: x_status := 'R';
3008: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then

Line 3006: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then

3002: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
3003: x_status := 'P';
3004: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
3005: x_status := 'Q';
3006: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
3007: x_status := 'R';
3008: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then
3009: x_status := 'U';
3010: end if;

Line 3008: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then

3004: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
3005: x_status := 'Q';
3006: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
3007: x_status := 'R';
3008: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then
3009: x_status := 'U';
3010: end if;
3011: else
3012: x_status := 'H';