1 PACKAGE HRI_OLTP_DISC_PROFICIENCY AUTHID CURRENT_USER AS
2 /* $Header: hriocprf.pkh 120.0 2005/05/29 07:27 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_main_appraiser_id IN NUMBER
12 p_appraisal_id IN NUMBER
13 Post Sucess : Returns the Proficiency Level before the appraisal was done
14 Post Failure : NULL
15 ***************************************************************************/
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;
22 --
23 --
24 -- get_new_proficiency_level
25 --
26 /**************************************************************************
27 Description : Function to get the competence proficiency level for a
28 person before the appraisal was done
29 Preconditions : None
30 In Parameters : p_competence_id IN NUMBER
31 p_person_id IN NUMBER
32 p_appraisal_id IN NUMBER
33 p_main_appraiser_id IN NUMBER
34 Post Sucess : Returns the Proficiency Level after the appraisal was done
35 Post Failure : NULL
36 ***************************************************************************/
37 --
38 FUNCTION get_new_proficiency_level(p_competence_id IN NUMBER,
39 p_main_appraiser_id IN NUMBER,
40 p_appraisal_id IN NUMBER)
41 RETURN VARCHAR2;
42 --
43 --
44 -- get_competence_appraisal_flag
45 --
46 /**************************************************************************
47 Description : Function to chech whether the given competence has been updates
48 by an appraisal
49 Preconditions : None
50 In Parameters : p_competence_id IN NUMBER
51 p_appraisal_id IN NUMBER,
52 p_person_id IN NUBMER
53 Post Sucess : Returns the 'Y' If the competence being updated by appraisal
54 else returns 'N'
55 Post Failure : 'NULL'
56 ***************************************************************************/
57 --
58 FUNCTION get_competence_appraisal_flag(p_competence_id IN NUMBER,
59 p_appraisal_id IN NUMBER,
60 p_person_id IN NUMBER)
61 RETURN VARCHAR2;
62 --
63 --
64 END HRI_OLTP_DISC_PROFICIENCY;
65 --
[Home] [Help]