1 PACKAGE ghr_pc_basic_pay AS
2 /* $Header: ghbasicp.pkh 120.4.12010000.2 2008/08/05 15:01:39 ubhat ship $ */
3
4 --
5 g_noa_family_code ghr_families.noa_family_code%type;
6
7 FUNCTION get_retained_grade_details (p_person_id IN NUMBER
8 ,p_effective_date IN DATE
9 ,p_pa_request_id IN NUMBER DEFAULT NULL)
10 RETURN ghr_pay_calc.retained_grade_rec_type;
11 --
12 -- Bug#4016384 Created the following function to get the RG record available
13 -- before the MSL effective date.
14 FUNCTION get_expired_rg_details (p_person_id IN NUMBER
15 ,p_effective_date IN DATE
16 ,p_pa_request_id IN NUMBER DEFAULT NULL)
17 RETURN ghr_pay_calc.retained_grade_rec_type;
18 --
19 PROCEDURE get_min_pay_table_value (p_user_table_id IN NUMBER
20 ,p_pay_plan IN VARCHAR2
21 ,p_grade_or_level IN VARCHAR2
22 ,p_effective_date IN DATE
23 ,p_step_or_rate OUT NOCOPY VARCHAR2
24 ,p_PT_value OUT NOCOPY NUMBER
25 ,p_PT_eff_start_date OUT NOCOPY DATE
26 ,p_PT_eff_end_date OUT NOCOPY DATE);
27 --
28 PROCEDURE get_max_pay_table_value (p_user_table_id IN NUMBER
29 ,p_pay_plan IN VARCHAR2
30 ,p_grade_or_level IN VARCHAR2
31 ,p_effective_date IN DATE
32 ,p_step_or_rate OUT NOCOPY VARCHAR2
33 ,p_PT_value OUT NOCOPY NUMBER
34 ,p_PT_eff_start_date OUT NOCOPY DATE
35 ,p_PT_eff_end_date OUT NOCOPY DATE);
36 --
37
38 --6211029 Added p_in_step_or_rate
39 PROCEDURE get_890_pay_table_value (p_user_table_id IN NUMBER
40 ,p_pay_plan IN VARCHAR2
41 ,p_grade_or_level IN VARCHAR2
42 ,p_effective_date IN DATE
43 ,p_current_val IN NUMBER
44 ,p_in_step_or_rate IN VARCHAR2
45 ,p_step_or_rate OUT NOCOPY VARCHAR2
46 ,p_PT_value OUT NOCOPY NUMBER
47 ,p_PT_eff_start_date OUT NOCOPY DATE
48 ,p_PT_eff_end_date OUT NOCOPY DATE);
49 --
50 PROCEDURE get_basic_pay_SAL894_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
51 ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
52 ,p_pay_table_data IN VARCHAR2
53 ,p_basic_pay OUT NOCOPY NUMBER
54 ,p_PT_eff_start_date OUT NOCOPY DATE
55 ,p_7dp OUT NOCOPY NUMBER);
56
57 PROCEDURE get_basic_pay_SAL894_PRDM (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
58 ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
59 ,p_basic_pay OUT NOCOPY NUMBER
60 ,p_prd OUT NOCOPY VARCHAR2
61 ,p_PT_eff_start_date OUT NOCOPY DATE);
62 --
63 PROCEDURE get_basic_pay (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
64 ,p_pay_calc_out_data OUT NOCOPY ghr_pay_calc.pay_calc_out_rec_type
65 ,p_retained_grade IN OUT NOCOPY ghr_pay_calc.retained_grade_rec_type);
66 --
67 FUNCTION get_next_WGI_step (p_pay_plan IN VARCHAR2
68 ,p_current_step IN VARCHAR2)
69 RETURN VARCHAR2;
70
71 -- Bug#5114467 Calling proc for Calculating basic pay, locality rate and
72 -- adjusted basic pay for employee in 'GM' pay plan and NOA 894 AC
73 PROCEDURE get_894_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
74 ,p_effective_date IN DATE
75 ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
76 ,p_default_table_id IN NUMBER
77 ,p_curr_basic_pay IN NUMBER
78 ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
79 ,p_new_basic_pay OUT NOCOPY NUMBER
80 ,p_new_adj_basic_pay OUT NOCOPY NUMBER
81 ,p_new_locality_adj OUT NOCOPY NUMBER
82 ,p_new_special_rate OUT NOCOPY NUMBER
83 );
84
85 -- Bug#5114467 Calling proc for Calculating basic pay, locality rate and
86 -- adjusted basic pay for WGI employee in 'GM' pay plan AC
87 PROCEDURE get_wgi_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
88 ,p_effective_date IN DATE
89 ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
90 ,p_default_table_id IN NUMBER
91 ,p_curr_basic_pay IN NUMBER
92 ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
93 ,p_new_basic_pay OUT NOCOPY NUMBER
94 ,p_new_adj_basic_pay OUT NOCOPY NUMBER
95 ,p_new_locality_adj OUT NOCOPY NUMBER
96 );
97 --5470182 new procedure added for calculation of 6 step process
98 PROCEDURE get_basic_pay_SAL890_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
99 ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
100 ,p_pay_table_data IN VARCHAR2
101 ,p_basic_pay OUT NOCOPY NUMBER
102 );
103
104 END ghr_pc_basic_pay;