1 PACKAGE BODY HRI_OLTP_DISC_PROFICIENCY AS
2 /* $Header: hriocprf.pkb 120.0 2005/05/29 07:27:09 appldev noship $ */
3 --
4 -- get_old_proficiency_level
5 --
6 /**************************************************************************
7 Description : Function to get the competence proficiency level for a
8 person before the appraisal was done
9 Preconditions : None
10 In Parameters : p_competence_id IN NUMBER
11 p_person_id IN NUMBER
12 p_appraisal_id IN NUMBER
13 p_main_appraiser_id IN NUMBER
14 Post Sucess : Returns the Proficiency Level before the appraisal was done
15 Post Failure : NULL
16 ***************************************************************************/
17 FUNCTION get_old_proficiency_level(p_competence_id IN NUMBER,
18 p_person_id IN NUMBER,
19 p_appraisal_id IN NUMBER,
20 p_main_appraiser_id IN NUMBER)
21 RETURN VARCHAR2 IS
22 --
23 l_old_prof_lvl varchar2(2000);
24 --
25 --
26 begin
27 --
28 --
29 l_old_prof_lvl := HRI_BPL_PROFICIENCY.get_old_proficiency_level(p_competence_id,
30 p_person_id, p_appraisal_id, p_main_appraiser_id);
31 return(l_old_prof_lvl);
32 --
33 --
34 exception
35 --
36 --
37 when others then
38 return ('');
39 --
40 --
41 END get_old_proficiency_level;
42 --
43 --
44 -- get_new_proficiency_level
45 --
46 /**************************************************************************
47 Description : Function to get the competence proficiency level for a
48 person after the appraisal was done
49 Preconditions : None
50 In Parameters : p_competence_id IN NUMBER
51 p_main_appraiser_id IN NUMBER
52 p_appraisal_id IN NUMBER
53 Post Sucess : Returns the Proficiency Level after the appraisal was done
54 Post Failure : NULL
55 ***************************************************************************/
56 FUNCTION get_new_proficiency_level(p_competence_id IN NUMBER,
57 p_main_appraiser_id IN NUMBER,
58 p_appraisal_id IN NUMBER)
59 RETURN VARCHAR2 IS
60 --
61 --
62 l_new_prof_lvl varchar2(2000);
63 --
64 --
65 begin
66 --
67 --
68 --
69 --
70 l_new_prof_lvl := HRI_BPL_PROFICIENCY.get_new_proficiency_level(p_competence_id,
71 p_main_appraiser_id, p_appraisal_id);
72 return(l_new_prof_lvl);
73 --
74 --
75 exception
76 --
77 --
78 when others then
79 return ('');
80 --
81 --
82 END get_new_proficiency_level;
83 --
84 --
85 -- get_competence_appraisal_flag
86 --
87 /**************************************************************************
88 Description : Function to chech whether the given competence has been updates
89 by an appraisal
90 Preconditions : None
91 In Parameters : p_competence_id IN NUMBER
92 p_appraisal_id IN NUMBER,
93 p_person_id IN NUMBER
94 Post Sucess : Returns the 'Y' If the competence being updated by appraisal
95 else returns 'N'
96 Post Failure : 'NULL'
97 ***************************************************************************/
98 --
99 FUNCTION get_competence_appraisal_flag(p_competence_id IN NUMBER,
100 p_appraisal_id IN NUMBER,
101 p_person_id IN NUMBER)
102 RETURN VARCHAR2
103 IS
104 --
105 l_flag varchar2(5);
106 --
107 --
108 begin
109 --
110 --
111 l_flag := HRI_BPL_PROFICIENCY.get_competence_appraisal_flag(p_competence_id,
112 p_appraisal_id,
113 p_person_id);
114 return(l_flag);
115 --
116 --
117 exception
118 --
119 --
120 when others then
121 return ('');
122 --
123 --
124 END get_competence_appraisal_flag;
125 --
126 --
127 END HRI_OLTP_DISC_PROFICIENCY;
128 --