1 PACKAGE PQH_FR_SPEED AUTHID CURRENT_USER AS
2 /* $Header: pqchgspd.pkh 120.0 2005/05/29 01:43:38 appldev noship $ */
3 --
4 --Function overloaded with Varchar2 so that it can be used in VO Query.
5 FUNCTION get_increased_index(p_comments IN VARCHAR2
6 ,p_gross_index IN NUMBER
7 ,p_effective_date IN DATE) RETURN NUMBER;
8 --
9 --Function to check whether Notification is to be sent for due appraisals.
10 FUNCTION chk_notify(p_ben_pgm_id NUMBER
11 ,p_mgr_id NUMBER
12 ,p_review_date DATE
13 ,p_effective_date DATE) RETURN VARCHAR2;
14 --
15 --Function to get latest Appraisal Id for Employee as on effective date.
16 FUNCTION get_appraisal(p_ben_pgm_id NUMBER
17 ,p_person_id NUMBER
18 ,p_assignment_id NUMBER
19 ,p_appraisal_status VARCHAR2
20 ,p_appraisal_start_date DATE
21 ,p_appraisal_end_date DATE
22 ,p_effective_date DATE) RETURN NUMBER;
23 --
24 --Function to get the Appraisal Score (Marks) for an Appraisal.
25 FUNCTION get_marks(p_appraisal_id NUMBER) RETURN NUMBER;
26 --
27 --Procedure to check whether Speed Quota Check is success or failure.
28 PROCEDURE chk_speed_quota(p_ben_pgm_id IN NUMBER
29 ,p_grade_id IN NUMBER
30 ,p_speed IN VARCHAR2
31 ,p_effective_date IN DATE
32 ,p_num_allowed OUT NOCOPY NUMBER
33 ,p_speed_meaning OUT NOCOPY VARCHAR2
34 ,p_return_status OUT NOCOPY VARCHAR2);
35 --
36 --Procedure to update Progression Speed.
37 PROCEDURE update_speed(p_place_id IN NUMBER
38 ,p_speed IN VARCHAR2
39 ,p_eff_dt IN DATE
40 ,p_ovn IN OUT NOCOPY NUMBER
41 ,p_eff_st_dt OUT NOCOPY DATE
42 ,p_eff_end_dt OUT NOCOPY DATE);
43 --
44 --Procedure to send WorkFlow Notification.
45 PROCEDURE notify_manager(p_ItemType IN VARCHAR2
46 ,p_ProcessName IN VARCHAR2
47 ,p_EmpNumber IN VARCHAR2
48 ,p_EmpName IN VARCHAR2
49 ,p_UserName IN VARCHAR2
50 ,p_MgrUserName IN VARCHAR2
51 ,p_Corps IN VARCHAR2
52 ,p_Grade IN VARCHAR2
53 ,p_Step IN VARCHAR2
54 ,p_Speed IN VARCHAR2
55 ,p_LastApprDt IN DATE
56 ,p_EffDt IN DATE
57 ,p_Duration IN NUMBER);
58 --
59 --Function defined in Formula Function for checking Speed Length in Fast Formula.
60 FUNCTION chk_speed_length(p_assignment_id IN NUMBER
61 ,p_effective_date IN DATE) RETURN VARCHAR2;
62 --
63 --Procedure to get FNDUSER for Manager
64 PROCEDURE get_mgr_user(p_effective_date IN DATE
65 ,p_mgr_id IN NUMBER
66 ,p_mgr_username OUT NOCOPY VARCHAR2);
67 --
68 END pqh_fr_speed;