APPS.PA_HR_COMPETENCE_UTILS dependencies on PER_COMPETENCE_ELEMENTS

Line 19: (object_id per_competence_elements.object_id%TYPE,

15: -- Verified that the file can be used in Self-Service Apps.
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,

Line 21: rating_level_id per_competence_elements.rating_level_id%TYPE,

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,
25: competence_name per_competences.name%TYPE,

Line 22: competence_element_id per_competence_elements.competence_element_id%TYPE,

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,
25: competence_name per_competences.name%TYPE,
26: competence_alias per_competences.competence_alias%TYPE,

Line 24: mandatory per_competence_elements.mandatory%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,
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

Line 28: object_version_number per_competence_elements.object_version_number%TYPE

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:
31: TYPE competency_tbl_typ IS TABLE OF competency_rec_typ
32: INDEX BY BINARY_INTEGER;

Line 80: ( p_object_name IN per_competence_elements.object_name%TYPE

76: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
78:
79: PROCEDURE get_competencies
80: ( p_object_name IN per_competence_elements.object_name%TYPE
81: ,p_object_id IN per_competence_elements.object_id%TYPE
82: ,x_competency_tbl OUT NOCOPY competency_tbl_typ /* Added NOCOPY for bug#2674619 */
83: ,x_no_of_competencies OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
84: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 81: ,p_object_id IN per_competence_elements.object_id%TYPE

77: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
78:
79: PROCEDURE get_competencies
80: ( p_object_name IN per_competence_elements.object_name%TYPE
81: ,p_object_id IN per_competence_elements.object_id%TYPE
82: ,x_competency_tbl OUT NOCOPY competency_tbl_typ /* Added NOCOPY for bug#2674619 */
83: ,x_no_of_competencies OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
84: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
85: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 95: ( p_object_name IN per_competence_elements.object_name%TYPE

91: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
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);

Line 96: ,p_object_id IN per_competence_elements.object_id%TYPE

92: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
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: