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.AHL_RM_ROUTE_UTIL dependencies on PER_RATING_LEVELS

Line 3021: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,

3017: PROCEDURE validate_skill_level
3018: (
3019: x_return_status OUT NOCOPY VARCHAR2,
3020: x_msg_data OUT NOCOPY VARCHAR2,
3021: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
3022: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
3023: p_skill_level_desc IN VARCHAR2,
3024: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
3025: )

Line 3022: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,

3018: (
3019: x_return_status OUT NOCOPY VARCHAR2,
3020: x_msg_data OUT NOCOPY VARCHAR2,
3021: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
3022: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
3023: p_skill_level_desc IN VARCHAR2,
3024: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
3025: )
3026: IS

Line 3024: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE

3020: x_msg_data OUT NOCOPY VARCHAR2,
3021: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
3022: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
3023: p_skill_level_desc IN VARCHAR2,
3024: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
3025: )
3026: IS
3027:
3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;

Line 3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;

3024: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
3025: )
3026: IS
3027:
3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
3029:
3030: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

Line 3030: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,

3026: IS
3027:
3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
3029:
3030: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3033: IS
3034: SELECT DISTINCT rating_level_id

Line 3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,

3027:
3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
3029:
3030: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3033: IS
3034: SELECT DISTINCT rating_level_id
3035: FROM PER_RATING_LEVELS

Line 3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

3028: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
3029:
3030: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3033: IS
3034: SELECT DISTINCT rating_level_id
3035: FROM PER_RATING_LEVELS
3036: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc

Line 3035: FROM PER_RATING_LEVELS

3031: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3032: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3033: IS
3034: SELECT DISTINCT rating_level_id
3035: FROM PER_RATING_LEVELS
3036: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc
3037: AND competence_id = c_skill_competence_id
3038: AND business_group_id = c_business_group_id;
3039:

Line 3040: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,

3036: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc
3037: AND competence_id = c_skill_competence_id
3038: AND business_group_id = c_business_group_id;
3039:
3040: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
3041: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3042: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3043: IS
3044: SELECT DISTINCT rating_level_id

Line 3041: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,

3037: AND competence_id = c_skill_competence_id
3038: AND business_group_id = c_business_group_id;
3039:
3040: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
3041: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3042: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3043: IS
3044: SELECT DISTINCT rating_level_id
3045: FROM PER_RATING_LEVELS

Line 3042: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

3038: AND business_group_id = c_business_group_id;
3039:
3040: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
3041: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3042: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3043: IS
3044: SELECT DISTINCT rating_level_id
3045: FROM PER_RATING_LEVELS
3046: WHERE rating_level_id = c_rating_level_id

Line 3045: FROM PER_RATING_LEVELS

3041: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
3042: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
3043: IS
3044: SELECT DISTINCT rating_level_id
3045: FROM PER_RATING_LEVELS
3046: WHERE rating_level_id = c_rating_level_id
3047: AND competence_id = c_skill_competence_id
3048: AND business_group_id = c_business_group_id;
3049: