APPS.AHL_RM_ROUTE_UTIL dependencies on PER_COMPETENCES

Line 2918: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,

2914: PROCEDURE validate_skill_type
2915: (
2916: x_return_status OUT NOCOPY VARCHAR2,
2917: x_msg_data OUT NOCOPY VARCHAR2,
2918: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2919: p_skill_name IN PER_COMPETENCES.name%TYPE,
2920: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2921: )
2922: IS

Line 2919: p_skill_name IN PER_COMPETENCES.name%TYPE,

2915: (
2916: x_return_status OUT NOCOPY VARCHAR2,
2917: x_msg_data OUT NOCOPY VARCHAR2,
2918: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2919: p_skill_name IN PER_COMPETENCES.name%TYPE,
2920: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2921: )
2922: IS
2923:

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

2916: x_return_status OUT NOCOPY VARCHAR2,
2917: x_msg_data OUT NOCOPY VARCHAR2,
2918: p_business_group_id IN PER_COMPETENCES.business_group_id%TYPE,
2919: p_skill_name IN PER_COMPETENCES.name%TYPE,
2920: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2921: )
2922: IS
2923:
2924: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;

Line 2924: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;

2920: p_x_skill_competence_id IN OUT NOCOPY PER_COMPETENCES.competence_id%TYPE
2921: )
2922: IS
2923:
2924: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2925:
2926: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2927: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2928: IS

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

2922: IS
2923:
2924: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2925:
2926: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2927: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2928: IS
2929: SELECT DISTINCT competence_id
2930: FROM PER_COMPETENCES

Line 2927: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )

2923:
2924: l_skill_competence_id PER_COMPETENCES.competence_id%TYPE;
2925:
2926: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2927: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2928: IS
2929: SELECT DISTINCT competence_id
2930: FROM PER_COMPETENCES
2931: WHERE name = c_skill_name

Line 2930: FROM PER_COMPETENCES

2926: CURSOR get_rec_from_value ( c_skill_name PER_COMPETENCES.name%TYPE,
2927: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2928: IS
2929: SELECT DISTINCT competence_id
2930: FROM PER_COMPETENCES
2931: WHERE name = c_skill_name
2932: AND business_group_id = c_business_group_id;
2933:
2934: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,

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

2930: FROM PER_COMPETENCES
2931: WHERE name = c_skill_name
2932: AND business_group_id = c_business_group_id;
2933:
2934: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2935: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2936: IS
2937: SELECT DISTINCT competence_id
2938: FROM PER_COMPETENCES

Line 2935: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )

2931: WHERE name = c_skill_name
2932: AND business_group_id = c_business_group_id;
2933:
2934: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2935: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2936: IS
2937: SELECT DISTINCT competence_id
2938: FROM PER_COMPETENCES
2939: WHERE competence_id = c_skill_competence_id

Line 2938: FROM PER_COMPETENCES

2934: CURSOR get_rec_from_id ( c_skill_competence_id PER_COMPETENCES.competence_id%TYPE,
2935: c_business_group_id PER_COMPETENCES.business_group_id%TYPE )
2936: IS
2937: SELECT DISTINCT competence_id
2938: FROM PER_COMPETENCES
2939: WHERE competence_id = c_skill_competence_id
2940: AND business_group_id = c_business_group_id;
2941:
2942: BEGIN