1 PACKAGE ghr_pay_caps AS
2 /* $Header: ghpaycap.pkh 120.3.12010000.1 2008/07/28 10:36:03 appldev ship $ */
3 --
4 -- This record structure will keep all the in parameters that were passed to the main pay calc process
5 TYPE pay_cap_in_rec_type IS RECORD
6 (effective_date DATE
7 ,pay_rate_determinant VARCHAR2(30)
8 ,pay_plan VARCHAR2(30)
9 ,to_position_id NUMBER
10 ,pay_basis VARCHAR2(30)
11 ,person_id NUMBER
12 ,basic_pay NUMBER
13 ,locality_adj NUMBER
14 ,adj_basic_pay NUMBER
15 ,total_salary NUMBER
16 ,other_pay_amount NUMBER
17 ,au_overtime NUMBER
18 ,availability_pay NUMBER
19 ,noa_code ghr_pa_requests.first_noa_code%type -- New 8/28
20 ,retention_allowance NUMBER -- New 8/28
21 ,retention_allow_percentage NUMBER -- New 8/28
22 ,supervisory_allowance NUMBER -- New 8/28
23 ,staffing_differential NUMBER -- New 8/28
24 ,capped_other_pay NUMBER -- New 8/28
25 ,pa_request_id NUMBER -- New 12/12
26 );
27
28 --
29 TYPE pay_cap_out_rec_type IS RECORD
30 (open_pay_fields BOOLEAN
31 ,message_set BOOLEAN
32 ,locality_adj NUMBER -- New 8/28
33 ,adj_basic_pay NUMBER -- New 8/28
34 ,total_salary NUMBER -- New 8/28
35 ,other_pay_amount NUMBER -- New 8/28
36 ,retention_allowance NUMBER -- New 8/28
37 ,retention_allow_percentage NUMBER -- New 8/28
38 ,au_overtime NUMBER -- New 8/28
39 ,availability_pay NUMBER -- New 8/28
40 ,capped_other_pay NUMBER -- New 8/28
41 ,adj_basic_mesg_flag NUMBER -- Change on 8/30
42 ,pay_cap_message BOOLEAN -- New 8/28
43 ,pay_cap_adj NUMBER -- New 8/28
44 ,total_pay_check VARCHAR2(1) ---- Bug 2064497 New 11/21
45 );
46
47 --
48
49 FUNCTION update34_implemented_date (p_person_id IN NUMBER)
50 RETURN DATE;
51
52 --
53 FUNCTION perf_certified(p_agency_code IN ghr_pa_requests.from_Agency_code%TYPE,
54 p_org_id IN hr_positions_f.organization_id%TYPE,
55 p_pay_plan IN ghr_pa_Requests.from_pay_plan%TYPE,
56 p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
57 RETURN BOOLEAN;
58
59 --Bug# 5132113
60
61 function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,
62 l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,
63 l_market_pay IN number,
64 p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
65 RETURN BOOLEAN;
66 --Bug# 5132113
67
68 --
69 FUNCTION get_job_from_pos(p_effective_date IN DATE
70 ,p_position_id IN NUMBER)
71 RETURN VARCHAR2;
72
73 --
74 PROCEDURE update34_implement (p_person_id IN NUMBER
75 ,P_date IN DATE);
76 --
77 PROCEDURE do_pay_caps_main (p_pa_request_id IN NUMBER --NEW
78 ,p_effective_date IN DATE
79 ,p_pay_rate_determinant IN VARCHAR2
80 ,p_pay_plan IN VARCHAR2
81 ,p_to_position_id IN NUMBER
82 ,p_pay_basis IN VARCHAR2
83 ,p_person_id IN NUMBER
84 ,p_noa_code IN VARCHAR2 --New
85 ,p_basic_pay IN NUMBER
86 ,p_locality_adj IN OUT NOCOPY NUMBER
87 ,p_adj_basic_pay IN OUT NOCOPY NUMBER
88 ,p_total_salary IN OUT NOCOPY NUMBER
89 ,p_other_pay_amount IN OUT NOCOPY NUMBER
90 ,p_capped_other_pay IN OUT NOCOPY NUMBER --New
91 ,p_retention_allowance IN OUT NOCOPY NUMBER --New
92 ,p_retention_allow_percentage IN OUT NOCOPY NUMBER --New
93 ,p_supervisory_allowance IN NUMBER --New
94 ,p_staffing_differential IN NUMBER --New
95 ,p_au_overtime IN OUT NOCOPY NUMBER
96 ,p_availability_pay IN OUT NOCOPY NUMBER
97 ,p_adj_basic_message OUT NOCOPY BOOLEAN
98 ,p_pay_cap_message OUT NOCOPY BOOLEAN
99 ,p_pay_cap_adj OUT NOCOPY NUMBER
100 ,p_open_pay_fields OUT NOCOPY BOOLEAN
101 ,p_message_set OUT NOCOPY BOOLEAN
102 ,p_total_pay_check OUT NOCOPY VARCHAR2);
103
104 --
105
106
107 --
108 PROCEDURE do_pay_caps_sql (p_pa_request_id IN NUMBER --NEW
109 ,p_effective_date IN DATE
110 ,p_pay_rate_determinant IN VARCHAR2
111 ,p_pay_plan IN VARCHAR2
112 ,p_to_position_id IN NUMBER
113 ,p_pay_basis IN VARCHAR2
114 ,p_person_id IN NUMBER
115 ,p_noa_code IN VARCHAR2 --New
116 ,p_basic_pay IN NUMBER
117 ,p_locality_adj IN OUT NOCOPY NUMBER
118 ,p_adj_basic_pay IN OUT NOCOPY NUMBER
119 ,p_total_salary IN OUT NOCOPY NUMBER
120 ,p_other_pay_amount IN OUT NOCOPY NUMBER
121 ,p_capped_other_pay IN OUT NOCOPY NUMBER --New
122 ,p_retention_allowance IN OUT NOCOPY NUMBER --New
123 ,p_retention_allow_percentage IN OUT NOCOPY NUMBER --New
124 ,p_supervisory_allowance IN NUMBER --New
125 ,p_staffing_differential IN NUMBER --New
126 ,p_au_overtime IN OUT NOCOPY NUMBER
127 ,p_availability_pay IN OUT NOCOPY NUMBER
128 ,p_adj_basic_message OUT NOCOPY BOOLEAN
129 ,p_pay_cap_message OUT NOCOPY BOOLEAN
130 ,p_pay_cap_adj OUT NOCOPY NUMBER
131 ,p_open_pay_fields OUT NOCOPY BOOLEAN
132 ,p_message_set IN OUT NOCOPY BOOLEAN
133 ,p_total_pay_check OUT NOCOPY VARCHAR2);
134
135
136 --
137 END ghr_pay_caps;