PACKAGE: APPS.HR_APPRAISALS_UTIL_SS

Source

1 Package hr_appraisals_util_ss AUTHID CURRENT_USER as
2 /* $Header: hrapprss.pkh 120.4.12020000.1 2012/06/28 23:45:39 appldev ship $ */
3 
4 FUNCTION get_competence_score (p_competence_id NUMBER,
5                                p_assessment_id NUMBER) return NUMBER;
6 
7 FUNCTION get_assessment_score (p_assessment_id NUMBER) return NUMBER;
8 
9 FUNCTION get_objective_score (p_objective_id NUMBER,
10                               p_appraisal_id NUMBER) return NUMBER;
11 
12 FUNCTION get_overall_score (p_appraisal_id NUMBER,
13                             p_final_formula_id NUMBER) return NUMBER;
14 
15 FUNCTION is_approver_terminated(p_person_id varchar2) return VARCHAR2;
16 FUNCTION is_worker_terminated(p_person_id varchar2) return VARCHAR2;
17 function is_maiappraiser_terminated(p_person_id varchar2) return varchar2;
18 function is_approver_terminated(p_item_type IN VARCHAR2,p_item_key IN VARCHAR2) return varchar2;
19 function get_item_key(p_appraisal_id VARCHAR2) return varchar2;
20 
21 procedure send_notification( p_fromPersonId VARCHAR2, p_toPersonId VARCHAR2,p_comment VARCHAR2,p_mainAprId VARCHAR2,p_actionType VARCHAR2);
22 
23 
24 end hr_appraisals_util_ss;