[Home] [Help]
PACKAGE: APPS.PA_HR_COMPETENCE_UTILS
Source
1 PACKAGE pa_hr_competence_utils AUTHID CURRENT_USER AS
2 -- $Header: PACOMUTS.pls 120.1 2005/08/19 16:20:40 mwasowic noship $
3
4 --
5 -- PROCEDURE
6 -- Check_Rating_Level_Or_Id
7 -- PURPOSE
8 -- This procedure does the following
9 -- If Rating Level (Step Value) is passed converts it to the id
10 -- If Rating Level id is passed,
11 -- based on the check_id_flag validates it
12 -- HISTORY
13 -- 27-JUN-2000 R. Krishnamurthy Created
14 -- 17-NOV-2000 R. Fadia
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,
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;
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
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
51
52 PROCEDURE Get_KFF_Structure_Num
53 (p_competency_structure_type IN VARCHAR2
54 ,p_business_group_id IN NUMBER
55 ,x_kff_structure_num OUT NOCOPY fnd_id_flex_structures_vl.id_flex_num%TYPE --File.Sql.39 bug 4440895
56 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 ,x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
58
59 PROCEDURE Get_KFF_SegmentInfo
60 ( p_kff_structure_num IN fnd_id_flex_structures_vl.id_flex_num%TYPE
61 ,x_segment_name1 OUT NOCOPY fnd_id_flex_segments_vl.segment_name%TYPE --File.Sql.39 bug 4440895
62 ,x_segment_prompt1 OUT NOCOPY fnd_id_flex_segments_vl.form_left_prompt%TYPE --File.Sql.39 bug 4440895
63 ,x_column_name1 OUT NOCOPY fnd_id_flex_segments_vl.application_column_name%TYPE --File.Sql.39 bug 4440895
64 ,x_segment_number1 OUT NOCOPY fnd_id_flex_segments_vl.segment_num%TYPE --File.Sql.39 bug 4440895
65 ,x_value_set_id1 OUT NOCOPY fnd_id_flex_segments_vl.flex_value_set_id%TYPE --File.Sql.39 bug 4440895
66 ,x_segment_name2 OUT NOCOPY fnd_id_flex_segments_vl.segment_name%TYPE --File.Sql.39 bug 4440895
67 ,x_segment_prompt2 OUT NOCOPY fnd_id_flex_segments_vl.form_left_prompt%TYPE --File.Sql.39 bug 4440895
68 ,x_column_name2 OUT NOCOPY fnd_id_flex_segments_vl.application_column_name%TYPE --File.Sql.39 bug 4440895
69 ,x_segment_number2 OUT NOCOPY fnd_id_flex_segments_vl.segment_num%TYPE --File.Sql.39 bug 4440895
70 ,x_value_set_id2 OUT NOCOPY fnd_id_flex_segments_vl.flex_value_set_id%TYPE --File.Sql.39 bug 4440895
71 ,x_segment_name3 OUT NOCOPY fnd_id_flex_segments_vl.segment_name%TYPE --File.Sql.39 bug 4440895
72 ,x_segment_prompt3 OUT NOCOPY fnd_id_flex_segments_vl.form_left_prompt%TYPE --File.Sql.39 bug 4440895
73 ,x_column_name3 OUT NOCOPY fnd_id_flex_segments_vl.application_column_name%TYPE --File.Sql.39 bug 4440895
74 ,x_segment_number3 OUT NOCOPY fnd_id_flex_segments_vl.segment_num%TYPE --File.Sql.39 bug 4440895
75 ,x_value_set_id3 OUT NOCOPY fnd_id_flex_segments_vl.flex_value_set_id%TYPE --File.Sql.39 bug 4440895
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
85 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
86
87 PROCEDURE get_person_competencies
88 ( p_person_id IN NUMBER
89 ,x_competency_tbl OUT NOCOPY competency_tbl_typ /* Added NOCOPY for bug#2674619 */
90 ,x_no_of_competencies OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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);
100
101 FUNCTION Get_Res_competences
102 ( p_person_id IN pa_resources_denorm.person_id%TYPE )
103 RETURN VARCHAR2;
104
105 FUNCTION Get_Res_Competences_Count
106 ( p_person_id IN pa_resources_denorm.person_id%TYPE)
107 RETURN NUMBER;
108
109 FUNCTION Get_Res_Comp_Last_Updated
110 ( p_person_id IN pa_resources_denorm.person_id%TYPE)
111 RETURN DATE;
112
113 FUNCTION Get_Req_Competences
114 ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
115 RETURN VARCHAR2;
116
117 end pa_hr_competence_utils ;