APPS.AHL_RM_ROUTE_UTIL dependencies on PER_COMPETENCES

Line 2786: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,

2782: PROCEDURE validate_skill_type
2783: (
2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_data OUT NOCOPY VARCHAR2,
2786: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2787: p_skill_name IN PER_COMPETENCES.name%TYPE,
2788: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2789: )
2790: IS

Line 2787: p_skill_name IN PER_COMPETENCES.name%TYPE,

2783: (
2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_data OUT NOCOPY VARCHAR2,
2786: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2787: p_skill_name IN PER_COMPETENCES.name%TYPE,
2788: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2789: )
2790: IS
2791:

Line 2788: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE

2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_data OUT NOCOPY VARCHAR2,
2786: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2787: p_skill_name IN PER_COMPETENCES.name%TYPE,
2788: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2789: )
2790: IS
2791:
2792: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;

Line 2792: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;

2788: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2789: )
2790: IS
2791:
2792: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2793:
2794: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2795: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2796: IS

Line 2794: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,

2790: IS
2791:
2792: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2793:
2794: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2795: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2796: IS
2797: SELECT DISTINCT competence_id
2798: FROM PER_COMPETENCES

Line 2795: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )

2791:
2792: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2793:
2794: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2795: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2796: IS
2797: SELECT DISTINCT competence_id
2798: FROM PER_COMPETENCES
2799: WHERE name = c_skill_name

Line 2798: FROM PER_COMPETENCES

2794: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2795: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2796: IS
2797: SELECT DISTINCT competence_id
2798: FROM PER_COMPETENCES
2799: WHERE name = c_skill_name
2800: AND business_group_id = c_business_group_id;
2801:
2802: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,

Line 2802: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,

2798: FROM PER_COMPETENCES
2799: WHERE name = c_skill_name
2800: AND business_group_id = c_business_group_id;
2801:
2802: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2803: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2804: IS
2805: SELECT DISTINCT competence_id
2806: FROM PER_COMPETENCES

Line 2803: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )

2799: WHERE name = c_skill_name
2800: AND business_group_id = c_business_group_id;
2801:
2802: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2803: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2804: IS
2805: SELECT DISTINCT competence_id
2806: FROM PER_COMPETENCES
2807: WHERE competence_id = c_skill_competence_id

Line 2806: FROM PER_COMPETENCES

2802: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2803: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2804: IS
2805: SELECT DISTINCT competence_id
2806: FROM PER_COMPETENCES
2807: WHERE competence_id = c_skill_competence_id
2808: AND business_group_id = c_business_group_id;
2809:
2810: BEGIN