APPS.PA_HR_COMPETENCE_UTILS dependencies on PER_RATING_LEVELS

Line 36: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE

32: INDEX BY BINARY_INTEGER;
33:
34: procedure Check_Rating_Level_Or_Id
35: ( p_competence_id IN per_competences.competence_id%TYPE
36: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
37: ,p_rating_level IN per_rating_levels.step_value%TYPE
38: ,p_check_id_flag IN VARCHAR2
39: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
40: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 37: ,p_rating_level IN per_rating_levels.step_value%TYPE

33:
34: procedure Check_Rating_Level_Or_Id
35: ( p_competence_id IN per_competences.competence_id%TYPE
36: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
37: ,p_rating_level IN per_rating_levels.step_value%TYPE
38: ,p_check_id_flag IN VARCHAR2
39: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
40: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
41: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

Line 39: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895

35: ( p_competence_id IN per_competences.competence_id%TYPE
36: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
37: ,p_rating_level IN per_rating_levels.step_value%TYPE
38: ,p_check_id_flag IN VARCHAR2
39: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
40: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
41: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
42:
43: PROCEDURE Check_CompName_Or_Id