APPS.PA_HR_COMPETENCE_UTILS dependencies on PER_COMPETENCES

Line 20: competence_id per_competences.competence_id%TYPE,

16: -- It has not global variables
17: --
18: TYPE competency_rec_typ IS RECORD
19: (object_id per_competence_elements.object_id%TYPE,
20: competence_id per_competences.competence_id%TYPE,
21: rating_level_id per_competence_elements.rating_level_id%TYPE,
22: competence_element_id per_competence_elements.competence_element_id%TYPE,
23: row_id ROWID,
24: mandatory per_competence_elements.mandatory%TYPE,

Line 25: competence_name per_competences.name%TYPE,

21: rating_level_id per_competence_elements.rating_level_id%TYPE,
22: competence_element_id per_competence_elements.competence_element_id%TYPE,
23: row_id ROWID,
24: mandatory per_competence_elements.mandatory%TYPE,
25: competence_name per_competences.name%TYPE,
26: competence_alias per_competences.competence_alias%TYPE,
27: global_flag VARCHAR2(1),
28: object_version_number per_competence_elements.object_version_number%TYPE
29: );

Line 26: competence_alias per_competences.competence_alias%TYPE,

22: competence_element_id per_competence_elements.competence_element_id%TYPE,
23: row_id ROWID,
24: mandatory per_competence_elements.mandatory%TYPE,
25: competence_name per_competences.name%TYPE,
26: competence_alias per_competences.competence_alias%TYPE,
27: global_flag VARCHAR2(1),
28: object_version_number per_competence_elements.object_version_number%TYPE
29: );
30:

Line 35: ( p_competence_id IN per_competences.competence_id%TYPE

31: TYPE competency_tbl_typ IS TABLE OF competency_rec_typ
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

Line 44: ( p_competence_id IN per_competences.competence_id%TYPE

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
44: ( p_competence_id IN per_competences.competence_id%TYPE
45: ,p_competence_alias IN per_competences.competence_alias%TYPE
46: ,p_competence_name IN per_competences.name%TYPE := null
47: ,p_check_id_flag IN VARCHAR2
48: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895

Line 45: ,p_competence_alias IN per_competences.competence_alias%TYPE

41: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
42:
43: PROCEDURE Check_CompName_Or_Id
44: ( p_competence_id IN per_competences.competence_id%TYPE
45: ,p_competence_alias IN per_competences.competence_alias%TYPE
46: ,p_competence_name IN per_competences.name%TYPE := null
47: ,p_check_id_flag IN VARCHAR2
48: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 46: ,p_competence_name IN per_competences.name%TYPE := null

42:
43: PROCEDURE Check_CompName_Or_Id
44: ( p_competence_id IN per_competences.competence_id%TYPE
45: ,p_competence_alias IN per_competences.competence_alias%TYPE
46: ,p_competence_name IN per_competences.name%TYPE := null
47: ,p_check_id_flag IN VARCHAR2
48: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ,x_error_msg_code OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 48: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895

44: ( p_competence_id IN per_competences.competence_id%TYPE
45: ,p_competence_alias IN per_competences.competence_alias%TYPE
46: ,p_competence_name IN per_competences.name%TYPE := null
47: ,p_check_id_flag IN VARCHAR2
48: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ,x_error_msg_code OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
51:
52: PROCEDURE Get_KFF_Structure_Num

Line 97: ,p_competence_id IN per_competences.competence_id%TYPE )

93:
94: FUNCTION check_competence_exists
95: ( p_object_name IN per_competence_elements.object_name%TYPE
96: ,p_object_id IN per_competence_elements.object_id%TYPE
97: ,p_competence_id IN per_competences.competence_id%TYPE )
98: RETURN VARCHAR2 ;
99: PRAGMA RESTRICT_REFERENCES (check_competence_exists , WNPS , WNDS);
100:
101: FUNCTION Get_Res_competences