[Home] [Help]
PACKAGE BODY: APPS.PAY_AU_TERMINATIONS_ENTRY_API
Source
1 PACKAGE BODY pay_au_terminations_entry_api AS
2 /* $Header: pyautapi.pkb 120.8.12020000.2 2012/09/05 01:27:23 skshin ship $
3 **
4 ** Copyright (c) 1999 Oracle Corporation
5 ** All Rights Reserved
6 **
7 ** Procedures and functions used in AU terminations entry form
8 **
9 ** Change List
10 ** ===========
11 **
12 ** Date Author Reference Description
13 ** =========================================================
14 ** 15-NOV-2000 JMHATRE 115.0 Created for AU
15 ** 05-MAR-2002 JKAROUZA 115.1 2246310 Added new parameter
16 ** p_override_user_ent_chk in calls
17 ** to py_element_entry_api.
18 ** 22-MAR-2002 JKAROUZA 115.2 Added SET VERIFY OFF.
19 ** 04-DEC-2002 Ragovind 115.3 Added NOCOPY for the functions update_al_element_entry, update_etp_element_entry
20 ** ,update_lsl_element_entry,update_super_element_entry
21 **
22 ** 15-May-2003 Ragovind 115.4 Added new parameteres to the procedure update
23 _etp_element_entry for ETP pre/post enhancement.
24 **
25 ** 18-May-2003 Ragovind 115.5 Added Bug Reference - Bug#2819479.
26 ** 09-MAr-2006 hnainani 115.6 Bug# 5080026 - 2 new parameters for update_al_element_entry
27 ** 26-Jun-2006 hnainani 115.7 Added new parameters for update_lsl_element_entry
28 ** 09-MAY-2007 priupadh 115.10 5956223 Added New Parameters to update_etp_element_entry
29 ** 04-Sep-2007 priupadh 115.11 6192381 Added New Parameters to update_super_element_entry
30 ** 07-Sep-2009 pmatamsr 115.12 8769345 Added new parameters to update_super_element_entry
31 ** 12-Nov-2010 avenkatk 115.13 9950136 Added new procedure update_foreign_element_entry
32 ** 05-Sep-2012 skshin 115.14 14358180 Added parameters to update_etp_element_entry procedure in order to update compensation and entry_information1-7
33 **
34 ** Wrappers for updating the element entries through the
35 ** Terminations form.
36 **
37 */
38 ---------------------------------------------------------------------------------------
39
40 PROCEDURE update_al_element_entry
41 (p_dt_update_mode IN VARCHAR2
42 ,p_session_date IN DATE
43 ,p_business_group_id IN NUMBER
44 ,p_element_entry_id IN NUMBER
45 ,p_object_version_number IN OUT NOCOPY NUMBER
46 ,p_hours_input_value_id IN NUMBER
47 ,p_payment_input_value_id IN NUMBER
48 ,p_loading_input_value_id IN NUMBER
49 ,p_other_input_value_id IN NUMBER
50 ,p_hours_entry_value IN VARCHAR2
51 ,p_payment_entry_value IN VARCHAR2
52 ,p_loading_entry_value IN VARCHAR2
53 ,p_other_entry_value IN VARCHAR2
54 ,p_effective_start_date IN OUT NOCOPY DATE
55 ,p_effective_end_date IN OUT NOCOPY DATE
56 ,p_update_warning OUT NOCOPY BOOLEAN) IS
57 BEGIN
58 py_element_entry_api.update_element_entry
59 (p_datetrack_update_mode => P_dt_update_mode
60 ,p_effective_date => P_session_date
61 ,p_business_group_id => P_business_group_id
62 ,p_element_entry_id => P_element_entry_id
63 ,p_object_version_number => P_object_version_number
64 ,p_input_value_id1 => P_hours_input_value_id
65 ,p_input_value_id2 => p_payment_input_value_id
66 ,p_input_value_id3 => p_loading_input_value_id
67 ,p_input_value_id4 => p_other_input_value_id
68 ,p_entry_value1 => p_hours_entry_value
69 ,p_entry_value2 => p_payment_entry_value
70 ,p_entry_value3 => p_loading_entry_value
71 ,p_entry_value4 => p_other_entry_value
72 ,p_effective_start_date => p_effective_start_date
73 ,p_effective_end_date => p_effective_end_date
74 ,p_override_user_ent_chk => 'Y'
75 ,p_update_warning => p_update_warning);
76
77 END update_al_element_entry;
78
79
80 PROCEDURE update_lsl_element_entry
81 (p_dt_update_mode IN VARCHAR2
82 ,p_session_date IN DATE
83 ,p_business_group_id IN NUMBER
84 ,p_element_entry_id IN NUMBER
85 ,p_object_version_number IN OUT NOCOPY NUMBER
86 ,p_pre78_pay_input_value_id IN NUMBER
87 ,p_post78_pay_input_value_id IN NUMBER
88 ,p_post93_pay_input_value_id IN NUMBER
89 ,p_pre78_hours_input_value_id IN NUMBER
90 ,p_post78_hours_input_value_id IN NUMBER
91 ,p_post93_hours_input_value_id IN NUMBER
92 ,p_override_elig_input_value_id IN NUMBER /*Bug# 5056831 */
93 ,p_pre78_pay_entry_value IN VARCHAR2
94 ,p_post78_pay_entry_value IN VARCHAR2
95 ,p_post93_pay_entry_value IN VARCHAR2
96 ,p_pre78_hours_entry_value IN VARCHAR2
97 ,p_post78_hours_entry_value IN VARCHAR2
98 ,p_post93_hours_entry_value IN VARCHAR2
99 ,p_override_elig_entry_value IN VARCHAR2 /*Bug# 5056831 */
103 BEGIN
100 ,p_effective_start_date IN OUT NOCOPY DATE
101 ,p_effective_end_date IN OUT NOCOPY DATE
102 ,p_update_warning OUT NOCOPY BOOLEAN) IS
104
105
106 py_element_entry_api.update_element_entry
107 (p_datetrack_update_mode => p_dt_update_mode
108 ,p_effective_date => p_session_date
109 ,p_business_group_id => p_business_group_id
110 ,p_element_entry_id => p_element_entry_id
111 ,p_object_version_number => p_object_version_number
112 ,p_input_value_id1 => p_pre78_pay_input_value_id
113 ,p_input_value_id2 => p_post78_pay_input_value_id
114 ,p_input_value_id3 => p_post93_pay_input_value_id
115 ,p_input_value_id4 => p_pre78_hours_input_value_id
116 ,p_input_value_id5 => p_post78_hours_input_value_id
117 ,p_input_value_id6 => p_post93_hours_input_value_id
118 ,p_input_value_id7 => p_override_elig_input_value_id /*Bug# 5056831 */
119 ,p_entry_value1 => p_pre78_pay_entry_value
120 ,p_entry_value2 => p_post78_pay_entry_value
121 ,p_entry_value3 => p_post93_pay_entry_value
122 ,p_entry_value4 => p_pre78_hours_entry_value
126 ,p_effective_start_date => p_effective_start_date
123 ,p_entry_value5 => p_post78_hours_entry_value
124 ,p_entry_value6 => p_post93_hours_entry_value
125 ,p_entry_value7 => p_override_elig_entry_value /*Bug# 5056831 */
127 ,p_effective_end_date => p_effective_end_date
128 ,p_override_user_ent_chk => 'Y'
129 ,p_update_warning => p_update_warning);
130
131 END update_lsl_element_entry;
132
133 /* Added new parameters for update_etp_element_entry for Bug#2819479 */
134 PROCEDURE update_etp_element_entry(p_dt_update_mode IN VARCHAR2
135 ,p_session_date IN DATE
136 ,p_business_group_id IN NUMBER
137 ,p_element_entry_id IN NUMBER
138 ,p_object_version_number IN OUT NOCOPY NUMBER
139 ,p_redundancy_input_value_id IN NUMBER
140 ,p_compensation_input_value_id IN NUMBER /*14358180*/
141 ,p_pay_etp_input_value_id IN NUMBER
142 ,p_golden_input_value_id IN NUMBER
143 ,p_lieu_input_value_id IN NUMBER
144 ,p_sick_input_value_id IN NUMBER
145 ,p_rdo_input_value_id IN NUMBER
146 ,p_other_input_value_id IN NUMBER
147 ,p_pre_1983_input_value_id IN NUMBER
148 ,p_post_1983_input_value_id IN NUMBER
149 ,p_etp_cs_date_input_value_id IN NUMBER
150 ,p_trans_etp_input_value_id IN NUMBER /*5956223*/
151 ,p_part_prev_etp_input_value_id IN NUMBER /*5956223*/
152 ,p_redundancy_entry_value IN VARCHAR2
153 ,p_compensation_entry_value IN VARCHAR2 /*14358180*/
154 ,p_pay_etp_entry_value IN VARCHAR2
155 ,p_golden_entry_value IN VARCHAR2
156 ,p_lieu_entry_value IN VARCHAR2
157 ,p_sick_entry_value IN VARCHAR2
161 ,p_post_1983_entry_value IN VARCHAR2
158 ,p_rdo_entry_value IN VARCHAR2
159 ,p_other_entry_value IN VARCHAR2
160 ,p_pre_1983_entry_value IN VARCHAR2
162 ,p_etp_cs_date_entry_value IN VARCHAR2
163 ,p_trans_etp_entry_value IN VARCHAR2 /*5956223 */
164 ,p_part_of_prev_etp_entry_value IN VARCHAR2 /*5956223*/
165 ,p_redeundancy_ne_chk IN VARCHAR2 /*start 14358180*/
166 ,p_compensation_ne_chk IN VARCHAR2
167 ,p_golden_ne_chk IN VARCHAR2
168 ,p_lieu_ne_chk IN VARCHAR2
169 ,p_sick_ne_chk IN VARCHAR2
170 ,p_rdo_ne_chk IN VARCHAR2
171 ,p_other_ne_chk IN VARCHAR2 /*end 14358180*/
172 ,p_effective_start_date IN OUT NOCOPY DATE
173 ,p_effective_end_date IN OUT NOCOPY DATE
174 ,p_update_warning OUT NOCOPY BOOLEAN) IS
175 BEGIN
176
177 py_element_entry_api.update_element_entry
178 (p_datetrack_update_mode => p_dt_update_mode
179 ,p_effective_date => p_session_date
180 ,p_business_group_id => p_business_group_id
181 ,p_element_entry_id => p_element_entry_id
182 ,p_object_version_number => p_object_version_number
183 ,p_input_value_id1 => p_redundancy_input_value_id
184 ,p_input_value_id2 => p_pay_etp_input_value_id
185 ,p_input_value_id3 => p_golden_input_value_id
186 ,p_input_value_id4 => p_lieu_input_value_id
187 ,p_input_value_id5 => p_sick_input_value_id
188 ,p_input_value_id6 => p_rdo_input_value_id
189 ,p_input_value_id7 => p_other_input_value_id
190 ,p_input_value_id8 => p_pre_1983_input_value_id
191 ,p_input_value_id9 => p_post_1983_input_value_id
192 ,p_input_value_id10 => p_etp_cs_date_input_value_id
193 ,p_input_value_id11 => p_trans_etp_input_value_id /*5956223 */
194 ,p_input_value_id12 => p_part_prev_etp_input_value_id /*5956223 */
195 ,p_input_value_id13 => p_compensation_input_value_id /*14358180*/
196 ,p_entry_value1 => p_redundancy_entry_value
197 ,p_entry_value2 => p_pay_etp_entry_value
198 ,p_entry_value3 => p_golden_entry_value
199 ,p_entry_value4 => p_lieu_entry_value
200 ,p_entry_value5 => p_sick_entry_value
201 ,p_entry_value6 => p_rdo_entry_value
202 ,p_entry_value7 => p_other_entry_value
203 ,p_entry_value8 => p_pre_1983_entry_value
204 ,p_entry_value9 => p_post_1983_entry_value
205 ,p_entry_value10 => p_etp_cs_date_entry_value
206 ,p_entry_value11 => p_trans_etp_entry_value /*5956223 */
207 ,p_entry_value12 => p_part_of_prev_etp_entry_value /*5956223 */
208 ,p_entry_value13 => p_compensation_entry_value /*start 14358180*/
209 ,p_entry_information_category => 'AU_INFORMATION'
210 ,p_entry_information1 => p_redeundancy_ne_chk
211 ,p_entry_information2 => p_compensation_ne_chk
212 ,p_entry_information3 => p_golden_ne_chk
213 ,p_entry_information4 => p_lieu_ne_chk
214 ,p_entry_information5 => p_sick_ne_chk
215 ,p_entry_information6 => p_rdo_ne_chk
216 ,p_entry_information7 => p_other_ne_chk /*end 14358180*/
217 ,p_effective_start_date => p_effective_start_date
218 ,p_effective_end_date => p_effective_end_date
219 ,p_override_user_ent_chk => 'Y'
220 ,p_update_warning => p_update_warning);
221
222 END update_etp_element_entry;
223
224 /* Bug 8769345 - Added new parameters to procedure in order to provide support for
225 two new input values added in Super rollover element */
226 PROCEDURE update_super_element_entry
227 (p_dt_update_mode IN VARCHAR2
228 ,p_session_date IN DATE
229 ,p_business_group_id IN NUMBER
230 ,p_element_entry_id IN NUMBER
231 ,p_object_version_number IN OUT NOCOPY NUMBER
232 ,p_amount_input_value_id IN NUMBER
233 ,p_amount_entry_value IN VARCHAR2
234 ,p_amount_ppetp_input_value_id IN NUMBER
235 ,p_amount_ppetp_entry_value IN VARCHAR2
236 ,p_amount_nppetp_input_value_id IN NUMBER
237 ,p_amount_nppetp_entry_value IN VARCHAR2
238 ,p_tax_free_ppetp_ip_value_id IN NUMBER /* Start 8769345 */
239 ,p_tax_free_ppetp_entry_value IN VARCHAR2
240 ,p_tax_free_nppetp_ip_value_id IN NUMBER
241 ,p_tax_free_nppetp_entry_value IN VARCHAR2 /* End 8769345 */
242 ,p_personal_payment_method_id IN NUMBER
243 ,p_effective_start_date IN OUT NOCOPY DATE
244 ,p_effective_end_date IN OUT NOCOPY DATE
245 ,p_update_warning OUT NOCOPY BOOLEAN) IS
246 BEGIN
247
248 py_element_entry_api.update_element_entry
249 (p_datetrack_update_mode => p_dt_update_mode
250 ,p_effective_date => p_session_date
251 ,p_business_group_id => p_business_group_id
252 ,p_element_entry_id => p_element_entry_id
253 ,p_object_version_number => p_object_version_number
254 ,p_input_value_id1 => p_amount_input_value_id
255 ,p_entry_value1 => p_amount_entry_value
256 ,p_input_value_id2 => p_amount_ppetp_input_value_id
257 ,p_entry_value2 => p_amount_ppetp_entry_value
258 ,p_input_value_id3 => p_amount_nppetp_input_value_id
259 ,p_entry_value3 => p_amount_nppetp_entry_value
260 ,p_input_value_id4 => p_tax_free_ppetp_ip_value_id /* Start 8769345 */
261 ,p_entry_value4 => p_tax_free_ppetp_entry_value
262 ,p_input_value_id5 => p_tax_free_nppetp_ip_value_id
263 ,p_entry_value5 => p_tax_free_nppetp_entry_value /* End 8769345 */
264 ,p_personal_payment_method_id => p_personal_payment_method_id
265 ,p_effective_start_date => p_effective_start_date
266 ,p_effective_end_date => p_effective_end_date
267 ,p_override_user_ent_chk => 'Y'
268 ,P_update_warning => p_update_warning );
269
270 END update_super_element_entry;
271
272
273 /* Bug 9950136 Added new procedure to update element entry
274 'Foreign Leave Payments on Termination
275 */
276
277 PROCEDURE update_foreign_element_entry
278 (p_dt_update_mode IN VARCHAR2
279 ,p_session_date IN DATE
280 ,p_business_group_id IN NUMBER
281 ,p_element_entry_id IN NUMBER
282 ,p_object_version_number IN OUT NOCOPY NUMBER
283 ,p_for_ratio_ovr_value IN VARCHAR2
284 ,p_for_ratio_ovr_input_value_id IN NUMBER
285 ,p_std_ratio_ovr_value IN VARCHAR2
286 ,p_std_ratio_ovr_input_value_id IN NUMBER
287 ,p_effective_start_date IN OUT NOCOPY DATE
288 ,p_effective_end_date IN OUT NOCOPY DATE
289 ,p_update_warning OUT NOCOPY BOOLEAN)
290 IS
291 BEGIN
292
293 py_element_entry_api.update_element_entry
294 (p_datetrack_update_mode => p_dt_update_mode
295 ,p_effective_date => p_session_date
296 ,p_business_group_id => p_business_group_id
297 ,p_element_entry_id => p_element_entry_id
298 ,p_object_version_number => p_object_version_number
299 ,p_input_value_id1 => p_for_ratio_ovr_input_value_id
300 ,p_entry_value1 => p_for_ratio_ovr_value
301 ,p_input_value_id2 => p_std_ratio_ovr_input_value_id
302 ,p_entry_value2 => p_std_ratio_ovr_value
303 ,p_effective_start_date => p_effective_start_date
304 ,p_effective_end_date => p_effective_end_date
305 ,p_override_user_ent_chk => 'Y'
306 ,p_update_warning => p_update_warning );
307
308 END update_foreign_element_entry;
309
310 END pay_au_terminations_entry_api;