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 2889: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,

2885: PROCEDURE validate_skill_level
2886: (
2887: x_return_status OUT NOCOPY VARCHAR2,
2888: x_msg_data OUT NOCOPY VARCHAR2,
2889: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
2890: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
2891: p_skill_level_desc IN VARCHAR2,
2892: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
2893: )

Line 2890: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,

2886: (
2887: x_return_status OUT NOCOPY VARCHAR2,
2888: x_msg_data OUT NOCOPY VARCHAR2,
2889: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
2890: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
2891: p_skill_level_desc IN VARCHAR2,
2892: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
2893: )
2894: IS

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

2888: x_msg_data OUT NOCOPY VARCHAR2,
2889: p_business_group_id IN PER_RATING_LEVELS.business_group_id%TYPE,
2890: p_skill_competence_id IN PER_RATING_LEVELS.competence_id%TYPE,
2891: p_skill_level_desc IN VARCHAR2,
2892: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
2893: )
2894: IS
2895:
2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;

Line 2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;

2892: p_x_rating_level_id IN OUT NOCOPY PER_RATING_LEVELS.rating_level_id%TYPE
2893: )
2894: IS
2895:
2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
2897:
2898: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

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

2894: IS
2895:
2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
2897:
2898: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2901: IS
2902: SELECT DISTINCT rating_level_id

Line 2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,

2895:
2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
2897:
2898: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2901: IS
2902: SELECT DISTINCT rating_level_id
2903: FROM PER_RATING_LEVELS

Line 2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

2896: l_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE;
2897:
2898: CURSOR get_rec_from_value ( c_skill_level_desc PER_RATING_LEVELS.name%TYPE,
2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2901: IS
2902: SELECT DISTINCT rating_level_id
2903: FROM PER_RATING_LEVELS
2904: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc

Line 2903: FROM PER_RATING_LEVELS

2899: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2900: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2901: IS
2902: SELECT DISTINCT rating_level_id
2903: FROM PER_RATING_LEVELS
2904: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc
2905: AND competence_id = c_skill_competence_id
2906: AND business_group_id = c_business_group_id;
2907:

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

2904: WHERE TO_CHAR( step_value ) || '-' || name = c_skill_level_desc
2905: AND competence_id = c_skill_competence_id
2906: AND business_group_id = c_business_group_id;
2907:
2908: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
2909: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2910: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2911: IS
2912: SELECT DISTINCT rating_level_id

Line 2909: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,

2905: AND competence_id = c_skill_competence_id
2906: AND business_group_id = c_business_group_id;
2907:
2908: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
2909: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2910: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2911: IS
2912: SELECT DISTINCT rating_level_id
2913: FROM PER_RATING_LEVELS

Line 2910: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )

2906: AND business_group_id = c_business_group_id;
2907:
2908: CURSOR get_rec_from_id ( c_rating_level_id PER_RATING_LEVELS.rating_level_id%TYPE,
2909: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2910: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2911: IS
2912: SELECT DISTINCT rating_level_id
2913: FROM PER_RATING_LEVELS
2914: WHERE rating_level_id = c_rating_level_id

Line 2913: FROM PER_RATING_LEVELS

2909: c_skill_competence_id PER_RATING_LEVELS.competence_id%TYPE,
2910: c_business_group_id PER_RATING_LEVELS.business_group_id%TYPE )
2911: IS
2912: SELECT DISTINCT rating_level_id
2913: FROM PER_RATING_LEVELS
2914: WHERE rating_level_id = c_rating_level_id
2915: AND competence_id = c_skill_competence_id
2916: AND business_group_id = c_business_group_id;
2917: