1 PACKAGE HR_WPM_UTIL AUTHID CURRENT_USER AS
2 /* $Header: hrwpmutl.pkh 120.13.12020000.3 2012/10/18 12:57:12 venksund ship $*/
3
4 FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
5 RETURN varchar2;
6
7 FUNCTION is_los_enabled (p_obj_id IN per_objectives.objective_id%TYPE, p_align_id IN per_objectives.aligned_with_objective_id%TYPE)
8 RETURN varchar2;
9
10 FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)
11 RETURN varchar2;
12
13 FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)
14 RETURN varchar2;
15 FUNCTION enable_share_for_topsupervisor(p_planid in per_perf_mgmt_plans.plan_id%TYPE,
16 p_personid in per_personal_scorecards.person_id%TYPE,
17 p_lookupcode in hr_lookups.lookup_code%TYPE
18 )
19 RETURN varchar2;
20
21 --
22 FUNCTION get_potential_for_9box(p_person_id IN NUMBER,
23 p_effective_date IN DATE) RETURN NUMBER;
24 -- new function added for bug 9849172
25 FUNCTION get_potential_for_9box (p_person_id IN NUMBER, p_potential IN VARCHAR2, p_performance IN NUMBER)
26 RETURN NUMBER;
27
28 --new functions added for Bug 13731815
29 FUNCTION get_iol_for_9box (
30 p_person_id IN NUMBER,
31 p_iol IN VARCHAR2,
32 p_retention IN VARCHAR2
33 )
34 RETURN NUMBER;
35
36 FUNCTION get_retention_for_9box (
37 p_person_id IN NUMBER,
38 p_retention IN VARCHAR2,
39 p_performance IN NUMBER
40 )
41 RETURN NUMBER;
42
43 FUNCTION get_performance_for_9box (p_perf IN VARCHAR2)
44 RETURN NUMBER;
45
46 -- End of added new functions.
47
48 FUNCTION get_performance_for_9box(p_person_id IN NUMBER,
49 p_effective_date IN DATE) RETURN NUMBER;
50 FUNCTION get_retention_for_9box(p_person_id IN NUMBER,
51 p_effective_date IN DATE) RETURN NUMBER;
52 FUNCTION get_value_for_9box(p_person_id IN NUMBER,
53 p_effective_date IN DATE,
54 p_type IN VARCHAR2) RETURN NUMBER;
55
56 FUNCTION get_iol_for_9box(p_person_id IN NUMBER,
57 p_effective_date IN DATE) RETURN NUMBER;
58 --
59 PROCEDURE get_9box_details_for_person(p_person_id IN NUMBER,
60 p_effective_date IN DATE,
61 p_get_performance IN VARCHAR2 DEFAULT
62 'Y',
63 p_get_potential IN VARCHAR2 DEFAULT
64 'Y',
65 p_get_retention IN VARCHAR2 DEFAULT
66 'Y',
67 p_performance OUT NOCOPY NUMBER,
68 p_potential OUT NOCOPY NUMBER,
69 p_retention OUT NOCOPY NUMBER);
70
71 FUNCTION get_latest_appraisal_rating(p_person_id IN NUMBER) RETURN VARCHAR2;
72 FUNCTION get_latest_appraisal_date(p_person_id IN NUMBER) RETURN DATE;
73 FUNCTION get_latest_appraisal_status(p_person_id IN NUMBER) RETURN VARCHAR2;
74 FUNCTION get_latest_appraisal_id(p_person_id IN NUMBER) RETURN NUMBER;
75 FUNCTION is_hipo_key_inplan_worker (p_person_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
76 FUNCTION get_overall_readiness (
77 p_legislation_code IN VARCHAR2,
78 p_business_group_id IN NUMBER,
79 p_mode IN VARCHAR2
80 )
81 RETURN NUMBER;
82
83 FUNCTION get_readiness_by_plan (
84 p_plan_id IN NUMBER
85 )
86 RETURN NUMBER;
87
88 FUNCTION is_sp_data_upgraded RETURN VARCHAR2;
89
90 FUNCTION is_obj_setting_open(p_plan_id NUMBER, p_manager_person_id NUMBER)
91 RETURN VARCHAR2;
92
93 END HR_WPM_UTIL; -- Package spec
94