1 PACKAGE HRI_BPL_PERF_RATING AS
2 /* $Header: hribpfrt.pkh 120.0 2005/05/29 07:04:05 appldev noship $ */
3 --
4 -- Exceptions raised when there is a problem with a fast formula
5 --
6 -- Raised when a fast formula is not compiled
7 --
8 ff_perf_rating_not_compiled EXCEPTION;
9 --
10 -- Raised when a the fast formula returns an invalid value for the parameter
11 --
12 ff_returned_invalid_value EXCEPTION;
13 --
14 FUNCTION get_appraisal_ff (p_business_group_id IN NUMBER)
15 RETURN NUMBER;
16 --
17 FUNCTION get_review_ff
18 RETURN NUMBER;
19 --
20 FUNCTION ff_exits_and_compiled(p_business_group_id IN NUMBER,
21 p_date IN DATE,
22 p_ff_name IN VARCHAR2)
23 RETURN NUMBER;
24 --
25 FUNCTION get_perf_rating_val
26 ( p_session_date IN DATE
27 , p_business_group_id IN NUMBER
28 , p_perf_rating_cd IN VARCHAR2
29 , p_review_type IN VARCHAR2
30 , p_appraisal_template_name IN VARCHAR2
31 )
32 RETURN NUMBER;
33 --
34 FUNCTION get_perf_sql
35 RETURN VARCHAR2;
36 --
37 FUNCTION get_perf_rating_band
38 (p_perf_nrmlsd_rating NUMBER
39 ,p_business_group_id NUMBER
40 ,p_person_id NUMBER
41 ,p_perf_rating_cd VARCHAR2
42 ,p_review_type VARCHAR2
43 ,p_appraisal_template_name VARCHAR2)
44 RETURN NUMBER;
45 --
46 END HRI_BPL_PERF_RATING;