APPS.WIP_WS_TIME_ENTRY dependencies on WIP_WS_SKILL_CHECK_PVT

Line 2236: l_skill_check := WIP_WS_SKILL_CHECK_PVT.validate_skill_for_clock_in(

2232:
2233: if WIP_TIME_ENTRY_PUB.is_emp_shift_in(p_wip_entity_id => p_wip_entity_id,
2234: p_employee_id => p_employee_id) then
2235:
2236: l_skill_check := WIP_WS_SKILL_CHECK_PVT.validate_skill_for_clock_in(
2237: p_wip_entity_id => p_wip_entity_id,
2238: p_op_seq_num => p_operation_seq_num,
2239: p_emp_id => p_employee_id);
2240:

Line 2241: if l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_SUCCESS then

2237: p_wip_entity_id => p_wip_entity_id,
2238: p_op_seq_num => p_operation_seq_num,
2239: p_emp_id => p_employee_id);
2240:
2241: if l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_SUCCESS then
2242:
2243: open clock_in_cursor;
2244: fetch clock_in_cursor into l_dummy_var;
2245: if clock_in_cursor%FOUND then

Line 2355: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then

2351:
2352:
2353: x_status := l_clock_status;
2354:
2355: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
2356: x_status := 'P';
2357: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
2358: x_status := 'Q';
2359: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then

Line 2357: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then

2353: x_status := l_clock_status;
2354:
2355: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
2356: x_status := 'P';
2357: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
2358: x_status := 'Q';
2359: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
2360: x_status := 'R';
2361: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then

Line 2359: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then

2355: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_COMPETENCE_CHECK_FAIL then
2356: x_status := 'P';
2357: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
2358: x_status := 'Q';
2359: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
2360: x_status := 'R';
2361: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then
2362: x_status := 'U';
2363: end if;

Line 2361: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then

2357: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_CERTIFY_CHECK_FAIL then
2358: x_status := 'Q';
2359: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_QUALIFY_CHECK_FAIL then
2360: x_status := 'R';
2361: elsif l_skill_check = WIP_WS_SKILL_CHECK_PVT.G_SKILL_VALIDATION_EXCEPTION then
2362: x_status := 'U';
2363: end if;
2364: else
2365: x_status := 'H';