DBA Data[Home] [Help]

APPS.PA_SEARCH_PUB dependencies on PA_HR_COMPETENCE_UTILS

Line 65: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;

61: l_index NUMBER;
62: l_return_status VARCHAR2(1);
63: l_error_msg_data fnd_new_messages.message_name%TYPE;
64: l_error_message_code fnd_new_messages.message_name%TYPE;
65: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
66: l_no_of_competencies NUMBER;
67: l_msg_index_out NUMBER;
68: l_competence_id per_competences.competence_id%TYPE;
69: -- added for Bug fix: 4537865

Line 577: PA_HR_COMPETENCE_UTILS.Check_CompName_Or_Id (

573: ELSE
574: l_competence_alias := p_competence_alias(i);
575: END IF;
576:
577: PA_HR_COMPETENCE_UTILS.Check_CompName_Or_Id (
578: p_competence_id => l_competence_id, --p_competence_id(i),
579: p_competence_alias => l_competence_alias, --p_competence_alias(i);
580: p_competence_name => p_competence_name(i),
581: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 671: PA_HR_COMPETENCE_UTILS.get_competencies(

667:
668: CLOSE get_search_criteria;
669:
670: -- get the competencies for the requirement
671: PA_HR_COMPETENCE_UTILS.get_competencies(
672: p_object_name => 'OPEN_ASSIGNMENT',
673: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
674: x_competency_tbl => l_competency_tbl,
675: x_no_of_competencies => l_no_of_competencies,