APPS.PA_ROLE_UTILS dependencies on PA_HR_COMPETENCE_UTILS

Line 274: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895

270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
274: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895
275: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
276: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
277:
278: l_num NUMBER;

Line 281: l_competency_tbl pa_hr_competence_utils.competency_tbl_typ;

277:
278: l_num NUMBER;
279: l_return_status VARCHAR2(30);
280: l_error_message_code VARCHAR2(30);
281: l_competency_tbl pa_hr_competence_utils.competency_tbl_typ;
282: CURSOR l_role_csr IS
283: SELECT meaning,
284: default_min_job_level,
285: default_max_job_level,

Line 310: pa_hr_competence_utils.get_competencies

306: CLOSE l_role_csr;
307: -- Get the info on whether the role is schedulable here
308: x_schedulable_flag := get_schedulable_flag(p_role_id);
309: -- Get the default competencies for the role
310: pa_hr_competence_utils.get_competencies
311: ( p_object_name => 'PROJECT_ROLE'
312: ,p_object_id => p_role_id
313: ,x_competency_tbl => l_competency_tbl
314: ,x_no_of_competencies => l_num