eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ROLE_UTILS dependencies on PER_COMPETENCES

Line 346: (p_competence_id IN per_competences.competence_id%TYPE

342: -- This procedure validates the competencies for a given role
343: --
344: -- HISTORY
345: PROCEDURE Validate_Role_Competency
346: (p_competence_id IN per_competences.competence_id%TYPE
347: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
348: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
349: l_business_group_id NUMBER := 0;
350:

Line 353: FROM per_competences

349: l_business_group_id NUMBER := 0;
350:
351: CURSOR l_get_bg_csr IS
352: SELECT business_group_id
353: FROM per_competences
354: WHERE competence_id = p_competence_id;
355: BEGIN
356: pa_debug.init_err_stack ('pa_role_utils.validate_role_competency');
357: OPEN l_get_bg_csr;