[Home] [Help]
PACKAGE BODY: APPS.PER_DE_ELE_API
Source
1 PACKAGE BODY PER_DE_ELE_API AS
2 /*$Header: perdeele.pkb 120.4.12020000.2 2012/07/05 03:55:15 amnaraya ship $*/
3
4 -- This procedure acts as a cover api for German Tax Information. It calls the element entry
5 -- api.
6
7 -- Created 18.9.01 J.heer
8
9 PROCEDURE delete_tax_information
10 (p_validate in boolean default false
11 ,p_datetrack_delete_mode in varchar2
12 ,p_effective_date in date
13 ,p_element_entry_id in number
14 ,p_object_version_number in out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_delete_warning out nocopy boolean
18 ) IS
19
20 BEGIN
21 pay_element_entry_api.delete_element_entry
22 (
23 p_validate => p_validate
24 ,p_datetrack_delete_mode => p_datetrack_delete_mode
25 ,p_effective_date => p_effective_date
26 ,p_element_entry_id => p_element_entry_id
27 ,p_object_version_number => p_object_version_number
28 ,p_effective_start_date => p_effective_start_date
29 ,p_effective_end_date => p_effective_end_date
30 ,p_delete_warning => p_delete_warning );
31
32 END delete_tax_information;
33
34 PROCEDURE Update_tax_information
35 (
36 p_validate in boolean default false,
37 p_datetrack_update_mode in varchar2,
38 p_effective_date in date,
39 p_business_group_id in number,
40 p_element_entry_id in number,
41 p_object_version_number in out nocopy number,
42 p_entry_information_category varchar2 default 'DE_TAX INFORMATION',
43 p_tax_year varchar2 default hr_api.g_varchar2,
44 p_tax_card_number varchar2 default hr_api.g_varchar2,
45 p_issue_date varchar2 default hr_api.g_varchar2,
46 p_card_issuer varchar2 default hr_api.g_varchar2,
47 p_tax_status varchar2 default hr_api.g_varchar2,
48 p_tax_table varchar2 default hr_api.g_varchar2,
49 p_tax_class varchar2 default hr_api.g_varchar2,
50 --p_tax_office varchar2 default hr_api.g_varchar2,
51 --p_tax_office_name varchar2 default hr_api.g_varchar2,
52 p_tax_organization_id varchar2 default hr_api.g_varchar2,
53 p_tax_card_location varchar2 default hr_api.g_varchar2,
54 p_no_of_children varchar2 default hr_api.g_varchar2,
55 p_yearly_tax_free_income varchar2 default hr_api.g_varchar2,
56 p_monthly_tax_free_income varchar2 default hr_api.g_varchar2,
57 p_additional_year_tax_income varchar2 default hr_api.g_varchar2,
58 p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2,
59 p_chamber_contribution varchar2 default hr_api.g_varchar2,
60 p_pensioners_tax_flag varchar2 default hr_api.g_varchar2,
61 p_additional_mth_tax_income varchar2 default hr_api.g_varchar2,
62 p_employee_church_code varchar2 default hr_api.g_varchar2,
63 p_spouse_church_code varchar2 default hr_api.g_varchar2,
64 p_bundesland_church varchar2 default hr_api.g_varchar2,
65 p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2,
66 p_max_church_tax_flag varchar2 default hr_api.g_varchar2,
67 p_updated varchar2 default hr_api.g_varchar2,
68 p_attribute_category varchar2 default hr_api.g_varchar2,
69 p_attribute1 varchar2 default hr_api.g_varchar2,
70 p_attribute2 varchar2 default hr_api.g_varchar2,
71 p_attribute3 varchar2 default hr_api.g_varchar2,
72 p_attribute4 varchar2 default hr_api.g_varchar2,
73 p_attribute5 varchar2 default hr_api.g_varchar2,
74 p_attribute6 varchar2 default hr_api.g_varchar2,
75 p_attribute7 varchar2 default hr_api.g_varchar2,
76 p_attribute8 varchar2 default hr_api.g_varchar2,
77 p_attribute9 varchar2 default hr_api.g_varchar2,
78 p_attribute10 varchar2 default hr_api.g_varchar2,
79 p_attribute11 varchar2 default hr_api.g_varchar2,
80 p_attribute12 varchar2 default hr_api.g_varchar2,
81 p_attribute13 varchar2 default hr_api.g_varchar2,
82 p_attribute14 varchar2 default hr_api.g_varchar2,
83 p_attribute15 varchar2 default hr_api.g_varchar2,
84 p_attribute16 varchar2 default hr_api.g_varchar2,
85 p_attribute17 varchar2 default hr_api.g_varchar2,
86 p_attribute18 varchar2 default hr_api.g_varchar2,
87 p_attribute19 varchar2 default hr_api.g_varchar2,
88 p_attribute20 varchar2 default hr_api.g_varchar2,
89 p_effective_start_date out nocopy date,
90 p_effective_end_date out nocopy date,
91 p_update_warning out nocopy boolean
92 ) is
93 l_delete_warning boolean;
94
95 BEGIN
96
97 -- l_last_day_of_year := '31-DEC-' || to_char(p_effective_date,'YYYY');
98
99 pay_element_entry_api.update_element_entry (
100 p_validate => p_validate
101 ,p_datetrack_update_mode => p_datetrack_update_mode
102 ,p_effective_date => p_effective_date
103 ,p_business_group_id => p_business_group_id
104 ,p_element_entry_id => p_element_entry_id
105 ,p_object_version_number => p_object_version_number
106 ,p_entry_information_category => p_entry_information_category
107 ,p_entry_information2 => p_tax_year
108 ,p_entry_information1 => p_tax_card_number
109 ,p_entry_information3 => p_issue_date
110 ,p_entry_information4 => p_card_issuer
111 --,p_entry_information5 => p_tax_office
112 --,p_entry_information6 => p_tax_office_name
113 ,p_entry_information20 => p_tax_organization_id
114 ,p_entry_information7 => p_tax_card_location
115 ,p_entry_information8 => p_tax_status
116 ,p_entry_information9 => p_tax_table
117 ,p_entry_information10 => p_tax_class
118 ,p_entry_information11 => p_no_of_children
119 ,p_entry_information12 => p_yearly_tax_free_income
120 ,p_entry_information13 => p_monthly_tax_free_income
121 ,p_entry_information14 => p_additional_year_tax_income
122 ,p_entry_information15 => p_Yearly_Income_Tax_Calc_flag
123 ,p_entry_information16 => p_chamber_contribution
124 ,p_entry_information17 => p_pensioners_tax_flag
125 ,p_entry_information18 => p_additional_mth_tax_income
126 ,p_entry_information19 => p_employee_church_code
127 ,p_entry_information21 => p_spouse_church_code
128 ,p_entry_information22 => hr_api.g_varchar2
129 ,p_entry_information23 => p_bundesland_church
130 ,p_entry_information24 => p_yearly_church_tax_flag
131 ,p_entry_information25 => p_Max_church_tax_flag
132 ,p_entry_information26 => p_updated
133 ,p_entry_information27 => hr_api.g_varchar2
134 ,p_entry_information28 => hr_api.g_varchar2
135 ,p_entry_information29 => hr_api.g_varchar2
136 ,p_entry_information30 => hr_api.g_varchar2
137 ,p_updating_action_type => hr_api.g_varchar2
138 ,p_creator_type => hr_api.g_varchar2
139 ,p_reason => hr_api.g_varchar2
140 ,p_attribute_category => p_attribute_category
141 ,p_attribute1 => p_attribute1
142 ,p_attribute2 => p_attribute2
143 ,p_attribute3 => p_attribute3
144 ,p_attribute4 => p_attribute4
145 ,p_attribute5 => p_attribute5
146 ,p_attribute6 => p_attribute6
147 ,p_attribute7 => p_attribute7
148 ,p_attribute8 => p_attribute8
149 ,p_attribute9 => p_attribute9
150 ,p_attribute10 => p_attribute10
151 ,p_attribute11 => p_attribute11
152 ,p_attribute12 => p_attribute12
153 ,p_attribute13 => p_attribute13
154 ,p_attribute14 => p_attribute14
155 ,p_attribute15 => p_attribute15
156 ,p_attribute16 => p_attribute16
157 ,p_attribute17 => p_attribute17
158 ,p_attribute18 => p_attribute18
159 ,p_attribute19 => p_attribute19
160 ,p_attribute20 => p_attribute20
161 ,p_effective_start_date => p_effective_start_date
162 ,p_effective_end_date => p_effective_end_date
163 ,p_update_warning => p_update_warning
164 );
165 -- Following the update, check the Tax Card details and set the end date back to the last day of the year.
166 -- no longer required
167 /* IF p_datetrack_update_mode in ('FUTURE_CHANGES','UPDATE_OVERRIDE') THEN
168 pay_element_entry_api.delete_element_entry
169 (
170 p_datetrack_delete_mode => 'DELETE'
171 ,p_effective_date => l_last_day_of_year
172 ,p_element_entry_id => p_element_entry_id
173 ,p_object_version_number => p_object_version_number
174 ,p_effective_start_date => p_effective_start_date
175 ,p_effective_end_date => p_effective_end_date
176 ,p_delete_warning => l_delete_warning );
177 END IF;
178 */
179 END Update_tax_information;
180
181
182 PROCEDURE Insert_tax_information
183 (
184 p_validate in boolean default false
185 ,p_effective_date in date
186 ,p_business_group_id in number
187 ,p_assignment_id in number
188 ,p_element_link_id in number
189 ,p_entry_type in varchar2
190 ,p_entry_information_category in varchar2 default 'DE_TAX INFORMATION'
191 ,p_tax_year varchar2 default hr_api.g_varchar2
192 ,p_tax_card_number in varchar2 default hr_api.g_varchar2
193 ,p_issue_date in varchar2 default hr_api.g_varchar2
194 ,p_card_issuer in varchar2 default hr_api.g_varchar2
195 ,p_tax_status varchar2 default hr_api.g_varchar2
196 ,p_tax_table varchar2 default hr_api.g_varchar2
197 ,p_tax_class varchar2 default hr_api.g_varchar2
198 --,p_tax_office varchar2 default hr_api.g_varchar2
199 --,p_tax_office_name varchar2 default hr_api.g_varchar2
200 ,p_tax_organization_id varchar2 default hr_api.g_varchar2
201 ,p_tax_card_location varchar2 default hr_api.g_varchar2
202 ,p_no_of_children varchar2 default hr_api.g_varchar2
203 ,p_yearly_tax_free_income varchar2 default hr_api.g_varchar2
204 ,p_monthly_tax_free_income varchar2 default hr_api.g_varchar2
205 ,p_additional_year_tax_income varchar2 default hr_api.g_varchar2
206 ,p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2
207 ,p_chamber_contribution varchar2 default hr_api.g_varchar2
208 ,p_pensioners_tax_flag varchar2 default hr_api.g_varchar2
209 ,p_additional_mth_tax_income varchar2 default hr_api.g_varchar2
210 -- ,p_effective_date_from varchar2 default hr_api.g_varchar2
211 -- ,p_effective_date_to varchar2 default hr_api.g_varchar2
212 ,p_employee_church_code varchar2 default hr_api.g_varchar2
213 ,p_spouse_church_code varchar2 default hr_api.g_varchar2
214 ,p_bundesland_church varchar2 default hr_api.g_varchar2
215 ,p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2
216 ,p_max_church_tax_flag varchar2 default hr_api.g_varchar2
217 ,p_updated varchar2 default hr_api.g_varchar2
218 ,p_attribute_category varchar2 default hr_api.g_varchar2
219 ,p_attribute1 varchar2 default hr_api.g_varchar2
220 ,p_attribute2 varchar2 default hr_api.g_varchar2
221 ,p_attribute3 varchar2 default hr_api.g_varchar2
222 ,p_attribute4 varchar2 default hr_api.g_varchar2
223 ,p_attribute5 varchar2 default hr_api.g_varchar2
224 ,p_attribute6 varchar2 default hr_api.g_varchar2
225 ,p_attribute7 varchar2 default hr_api.g_varchar2
226 ,p_attribute8 varchar2 default hr_api.g_varchar2
227 ,p_attribute9 varchar2 default hr_api.g_varchar2
228 ,p_attribute10 varchar2 default hr_api.g_varchar2
229 ,p_attribute11 varchar2 default hr_api.g_varchar2
230 ,p_attribute12 varchar2 default hr_api.g_varchar2
231 ,p_attribute13 varchar2 default hr_api.g_varchar2
232 ,p_attribute14 varchar2 default hr_api.g_varchar2
233 ,p_attribute15 varchar2 default hr_api.g_varchar2
234 ,p_attribute16 varchar2 default hr_api.g_varchar2
235 ,p_attribute17 varchar2 default hr_api.g_varchar2
236 ,p_attribute18 varchar2 default hr_api.g_varchar2
237 ,p_attribute19 varchar2 default hr_api.g_varchar2
238 ,p_attribute20 varchar2 default hr_api.g_varchar2
239 ,p_effective_start_date out nocopy date
240 ,p_effective_end_date out nocopy date
241 ,p_element_entry_id out nocopy number
242 ,p_object_version_number out nocopy number
243 ,p_create_warning out nocopy boolean ) is
244
245 BEGIN
246 pay_element_entry_api.create_element_entry
247 ( p_effective_date => p_effective_date
248 ,p_business_group_id => p_business_group_id
249 ,p_assignment_id => p_assignment_id
250 ,p_element_link_id => p_element_link_id
251 ,p_entry_type => p_entry_type
252 ,p_entry_information2 => p_tax_year
253 ,p_entry_information_category => p_entry_information_category
254 ,p_entry_information1 => p_tax_card_number
255 ,p_entry_information3 => p_issue_date
256 ,p_entry_information4 => p_card_issuer
257 -- ,p_entry_information5 => p_tax_office
258 -- ,p_entry_information6 => p_tax_office_name
259 ,p_entry_information7 => p_tax_card_location
260 ,p_entry_information8 => p_tax_status
261 ,p_entry_information9 => p_tax_table
262 ,p_entry_information10 => p_tax_class
263 ,p_entry_information11 => p_no_of_children
264 ,p_entry_information12 => p_yearly_tax_free_income
265 ,p_entry_information13 => p_monthly_tax_free_income
266 ,p_entry_information14 => p_additional_year_tax_income
267 ,p_entry_information15 => p_Yearly_Income_Tax_Calc_flag
268 ,p_entry_information16 => p_chamber_contribution
269 ,p_entry_information17 => p_pensioners_tax_flag
270 ,p_entry_information18 => p_additional_mth_tax_income
271 ,p_entry_information19 => p_employee_church_code
272 ,p_entry_information20 => p_tax_organization_id
273 ,p_entry_information21 => p_spouse_church_code
274 ,p_entry_information23 => p_bundesland_church
275 ,p_entry_information24 => p_yearly_church_tax_flag
276 ,p_entry_information25 => p_Max_church_tax_flag
277 ,p_entry_information26 => p_updated
278 ,p_attribute_category => p_attribute_category
279 ,p_attribute1 => p_attribute1
280 ,p_attribute2 => p_attribute2
281 ,p_attribute3 => p_attribute3
282 ,p_attribute4 => p_attribute4
283 ,p_attribute5 => p_attribute5
284 ,p_attribute6 => p_attribute6
285 ,p_attribute7 => p_attribute7
286 ,p_attribute8 => p_attribute8
287 ,p_attribute9 => p_attribute9
288 ,p_attribute10 => p_attribute10
289 ,p_attribute11 => p_attribute11
290 ,p_attribute12 => p_attribute12
291 ,p_attribute13 => p_attribute13
292 ,p_attribute14 => p_attribute14
293 ,p_attribute15 => p_attribute15
294 ,p_attribute16 => p_attribute16
295 ,p_attribute17 => p_attribute17
296 ,p_attribute18 => p_attribute18
297 ,p_attribute19 => p_attribute19
298 ,p_attribute20 => p_attribute20
299 ,p_effective_start_date => p_effective_start_date
300 ,p_effective_end_date => p_effective_end_date
301 ,p_element_entry_id => p_element_entry_id
302 ,p_object_version_number => p_object_version_number
303 ,p_create_warning => p_create_warning );
304
305 END Insert_tax_information;
306
307 PROCEDURE delete_tax_exemptions
308 (p_validate in boolean default false
309 ,p_datetrack_delete_mode in varchar2
310 ,p_effective_date in date
311 ,p_element_entry_id in number
312 ,p_object_version_number in out nocopy number
313 ,p_effective_start_date out nocopy date
314 ,p_effective_end_date out nocopy date
315 ,p_delete_warning out nocopy boolean
316 ) IS
317
318 l_last_day_of_year varchar2(11);
319
320 BEGIN
321 pay_element_entry_api.delete_element_entry
322 (
323 p_validate => p_validate
324 ,p_datetrack_delete_mode => p_datetrack_delete_mode
325 ,p_effective_date => p_effective_date
326 ,p_element_entry_id => p_element_entry_id
327 ,p_object_version_number => p_object_version_number
328 ,p_effective_start_date => p_effective_start_date
329 ,p_effective_end_date => p_effective_end_date
330 ,p_delete_warning => p_delete_warning );
331
332 -- no longer required
333 -- Carry out a correction to fix the Tax card Details so that the end date is still the last day of the year
334
335 -- l_last_day_of_year := '31-DEC-' || to_char(p_effective_start_date,'YYYY');
336
337 /* IF p_datetrack_delete_mode = 'FUTURE_CHANGES' THEN
338 py_element_entry_api.delete_element_entry
339 (
340 p_datetrack_delete_mode => 'DELETE'
341 ,p_effective_date => l_last_day_of_year
342 ,p_element_entry_id => p_element_entry_id
343 ,p_object_version_number => p_object_version_number
344 ,p_effective_start_date => p_effective_start_date
345 ,p_effective_end_date => p_effective_end_date
346 ,p_delete_warning => p_delete_warning );
347 END IF; */
348
349 END delete_tax_exemptions;
350
351 PROCEDURE Update_tax_exemptions
352 (
353 p_validate in boolean default false,
354 p_datetrack_update_mode in varchar2,
355 p_effective_date in date,
356 p_business_group_id in number,
357 p_element_entry_id in number,
358 p_object_version_number in out nocopy number,
359 p_entry_information_category varchar2 default 'DE_TAX EXEMPTIONS',
360 p_form_number varchar2 default hr_api.g_varchar2,
361 p_issue_date varchar2 default hr_api.g_varchar2,
362 p_valid_from varchar2 default hr_api.g_varchar2,
363 p_valid_to varchar2 default hr_api.g_varchar2,
364 p_tax_free_remuneration varchar2 default hr_api.g_varchar2,
365 -- p_assignment_id varchar2 default hr_api.g_varchar2,
366 p_attribute_category varchar2 default hr_api.g_varchar2,
367 p_attribute1 varchar2 default hr_api.g_varchar2,
368 p_attribute2 varchar2 default hr_api.g_varchar2,
369 p_attribute3 varchar2 default hr_api.g_varchar2,
370 p_attribute4 varchar2 default hr_api.g_varchar2,
371 p_attribute5 varchar2 default hr_api.g_varchar2,
372 p_attribute6 varchar2 default hr_api.g_varchar2,
373 p_attribute7 varchar2 default hr_api.g_varchar2,
374 p_attribute8 varchar2 default hr_api.g_varchar2,
375 p_attribute9 varchar2 default hr_api.g_varchar2,
376 p_attribute10 varchar2 default hr_api.g_varchar2,
377 p_attribute11 varchar2 default hr_api.g_varchar2,
378 p_attribute12 varchar2 default hr_api.g_varchar2,
379 p_attribute13 varchar2 default hr_api.g_varchar2,
380 p_attribute14 varchar2 default hr_api.g_varchar2,
381 p_attribute15 varchar2 default hr_api.g_varchar2,
382 p_attribute16 varchar2 default hr_api.g_varchar2,
383 p_attribute17 varchar2 default hr_api.g_varchar2,
384 p_attribute18 varchar2 default hr_api.g_varchar2,
385 p_attribute19 varchar2 default hr_api.g_varchar2,
386 p_attribute20 varchar2 default hr_api.g_varchar2,
387 p_effective_start_date out nocopy date,
388 P_effective_end_date out nocopy date,
389 p_update_warning out nocopy boolean
390 ) is
391
392 BEGIN
393
394 pay_element_entry_api.update_element_entry (
395 p_validate => p_validate
396 ,p_datetrack_update_mode => p_datetrack_update_mode
397 ,p_effective_date => p_effective_date
398 ,p_business_group_id => p_business_group_id
399 ,p_element_entry_id => p_element_entry_id
400 ,p_object_version_number => p_object_version_number
401 ,p_entry_information_category => p_entry_information_category
402 ,p_entry_information1 => p_form_number
403 ,p_entry_information2 => p_issue_date
404 ,p_entry_information3 => p_valid_from
405 ,p_entry_information4 => p_valid_to
406 ,p_entry_information5 => p_tax_free_remuneration
407 ,p_entry_information6 => hr_api.g_varchar2
408 ,p_entry_information7 => hr_api.g_varchar2
409 ,p_entry_information8 => hr_api.g_varchar2
410 ,p_entry_information9 => hr_api.g_varchar2
411 ,p_entry_information10 => hr_api.g_varchar2
412 ,p_entry_information11 => hr_api.g_varchar2
413 ,p_entry_information12 => hr_api.g_varchar2
414 ,p_entry_information13 => hr_api.g_varchar2
415 ,p_entry_information14 => hr_api.g_varchar2
416 ,p_entry_information15 => hr_api.g_varchar2
417 ,p_entry_information16 => hr_api.g_varchar2
418 ,p_entry_information17 => hr_api.g_varchar2
419 ,p_entry_information18 => hr_api.g_varchar2
420 ,p_entry_information19 => hr_api.g_varchar2
421 ,p_entry_information20 => hr_api.g_varchar2
422 ,p_entry_information21 => hr_api.g_varchar2
423 ,p_entry_information22 => hr_api.g_varchar2
424 ,p_entry_information23 => hr_api.g_varchar2
425 ,p_entry_information24 => hr_api.g_varchar2
426 ,p_entry_information25 => hr_api.g_varchar2
427 ,p_entry_information26 => hr_api.g_varchar2
428 ,p_entry_information27 => hr_api.g_varchar2
429 ,p_entry_information28 => hr_api.g_varchar2
430 ,p_entry_information29 => hr_api.g_varchar2
431 ,p_entry_information30 => hr_api.g_varchar2
432 ,p_updating_action_type => hr_api.g_varchar2
433 ,p_creator_type => hr_api.g_varchar2
434 ,p_reason => hr_api.g_varchar2
435 ,p_attribute_category => p_attribute_category
436 ,p_attribute1 => p_attribute1
437 ,p_attribute2 => p_attribute2
438 ,p_attribute3 => p_attribute3
439 ,p_attribute4 => p_attribute4
440 ,p_attribute5 => p_attribute5
441 ,p_attribute6 => p_attribute6
442 ,p_attribute7 => p_attribute7
443 ,p_attribute8 => p_attribute8
444 ,p_attribute9 => p_attribute9
445 ,p_attribute10 => p_attribute10
446 ,p_attribute11 => p_attribute11
447 ,p_attribute12 => p_attribute12
448 ,p_attribute13 => p_attribute13
449 ,p_attribute14 => p_attribute14
450 ,p_attribute15 => p_attribute15
451 ,p_attribute16 => p_attribute16
452 ,p_attribute17 => p_attribute17
453 ,p_attribute18 => p_attribute18
454 ,p_attribute19 => p_attribute19
455 ,p_attribute20 => p_attribute20
456 ,p_effective_start_date => p_effective_start_date
457 ,p_effective_end_date => p_effective_end_date
458 ,p_update_warning => p_update_warning
459 );
460
461 END Update_tax_exemptions;
462
463 PROCEDURE Insert_tax_exemptions
464 (
465 p_validate in boolean default false
466 ,p_effective_date in date
467 ,p_business_group_id in number
468 ,p_assignment_id in number
469 ,p_element_link_id in number
470 ,p_entry_type in varchar2
471 ,p_entry_information_category in varchar2 default 'DE_TAX EXEMPTIONS'
472 ,p_form_number varchar2 default hr_api.g_varchar2
473 ,p_issue_date varchar2 default hr_api.g_varchar2
474 ,p_valid_from varchar2 default hr_api.g_varchar2
475 ,p_valid_to varchar2 default hr_api.g_varchar2
476 ,p_tax_free_remuneration varchar2 default hr_api.g_varchar2
477 ,p_attribute_category varchar2 default hr_api.g_varchar2
478 ,p_attribute1 varchar2 default hr_api.g_varchar2
479 ,p_attribute2 varchar2 default hr_api.g_varchar2
480 ,p_attribute3 varchar2 default hr_api.g_varchar2
481 ,p_attribute4 varchar2 default hr_api.g_varchar2
482 ,p_attribute5 varchar2 default hr_api.g_varchar2
483 ,p_attribute6 varchar2 default hr_api.g_varchar2
484 ,p_attribute7 varchar2 default hr_api.g_varchar2
485 ,p_attribute8 varchar2 default hr_api.g_varchar2
486 ,p_attribute9 varchar2 default hr_api.g_varchar2
487 ,p_attribute10 varchar2 default hr_api.g_varchar2
488 ,p_attribute11 varchar2 default hr_api.g_varchar2
489 ,p_attribute12 varchar2 default hr_api.g_varchar2
490 ,p_attribute13 varchar2 default hr_api.g_varchar2
491 ,p_attribute14 varchar2 default hr_api.g_varchar2
492 ,p_attribute15 varchar2 default hr_api.g_varchar2
493 ,p_attribute16 varchar2 default hr_api.g_varchar2
494 ,p_attribute17 varchar2 default hr_api.g_varchar2
495 ,p_attribute18 varchar2 default hr_api.g_varchar2
496 ,p_attribute19 varchar2 default hr_api.g_varchar2
497 ,p_attribute20 varchar2 default hr_api.g_varchar2
498 ,p_effective_start_date out nocopy date
499 ,p_effective_end_date out nocopy date
500 ,p_element_entry_id out nocopy number
501 ,p_object_version_number out nocopy number
502 ,p_create_warning out nocopy boolean ) is
503
504 BEGIN
505
506 pay_element_entry_api.create_element_entry
507 ( p_effective_date => p_effective_date
508 ,p_business_group_id => p_business_group_id
509 ,p_assignment_id => p_assignment_id
510 ,p_element_link_id => p_element_link_id
511 ,p_entry_type => p_entry_type
512 ,p_entry_information_category => p_entry_information_category
513 ,p_entry_information1 => p_form_number
514 ,p_entry_information2 => p_issue_date
515 ,p_entry_information3 => p_valid_from
516 ,p_entry_information4 => p_valid_to
517 ,p_entry_information5 => p_tax_free_remuneration
518 ,p_attribute_category => p_attribute_category
519 ,p_attribute1 => p_attribute1
520 ,p_attribute2 => p_attribute2
521 ,p_attribute3 => p_attribute3
522 ,p_attribute4 => p_attribute4
523 ,p_attribute5 => p_attribute5
524 ,p_attribute6 => p_attribute6
525 ,p_attribute7 => p_attribute7
526 ,p_attribute8 => p_attribute8
527 ,p_attribute9 => p_attribute9
528 ,p_attribute10 => p_attribute10
529 ,p_attribute11 => p_attribute11
530 ,p_attribute12 => p_attribute12
531 ,p_attribute13 => p_attribute13
532 ,p_attribute14 => p_attribute14
533 ,p_attribute15 => p_attribute15
534 ,p_attribute16 => p_attribute16
535 ,p_attribute17 => p_attribute17
536 ,p_attribute18 => p_attribute18
537 ,p_attribute19 => p_attribute19
538 ,p_attribute20 => p_attribute20
539 ,p_effective_start_date => p_effective_start_date
540 ,p_effective_end_date => p_effective_end_date
541 ,p_element_entry_id => p_element_entry_id
542 ,p_object_version_number => p_object_version_number
543 ,p_create_warning => p_create_warning );
544
545 END Insert_tax_exemptions;
546
547 /*------------------------------------------------------------------------
548 Social Insurance
549
550 -------------------------------------------------------------------------*/
551
552 PROCEDURE delete_social_insurance_info
553 (p_validate in boolean default false
554 ,p_datetrack_delete_mode in varchar2
555 ,p_effective_date in date
556 ,p_element_entry_id in number
557 ,p_object_version_number in out nocopy number
558 ,p_effective_start_date out nocopy date
559 ,p_effective_end_date out nocopy date
560 ,p_delete_warning out nocopy boolean
561 ) is
562
563 BEGIN
564
565 pay_element_entry_api.delete_element_entry
566 (
567 p_validate => p_validate
568 ,p_datetrack_delete_mode => p_datetrack_delete_mode
569 ,p_effective_date => p_effective_date
570 ,p_element_entry_id => p_element_entry_id
571 ,p_object_version_number => p_object_version_number
572 ,p_effective_start_date => p_effective_start_date
573 ,p_effective_end_date => p_effective_end_date
574 ,p_delete_warning => p_delete_warning );
575
576 END delete_social_insurance_info;
577
578
579 PROCEDURE update_social_insurance_info
580 ( p_validate in boolean default false
581 ,p_datetrack_update_mode in varchar2
582 ,p_effective_date in date
583 ,p_business_group_id in number
584 ,p_element_entry_id in number
585 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
586 ,p_contribution_key in varchar2
587 ,p_health_org_id in number
588 ,p_pension_org_id in number
589 ,p_unemployment_org_id in number
590 ,p_special_care_org_id in number
591 ,p_occupation_key in varchar2
592 ,p_people_class_key in varchar2
593 ,p_legal_area_code in varchar2
594 ,p_health_insurance_number in varchar2 -- number fix for Bug 13925461
595 ,p_private_health_prov_id in number
596 ,p_private_health_contribution in number
597 ,p_voluntary_pension_prov_id in number
598 ,p_voluntary_pension_contr in number
599 ,p_voluntary_pension_number in varchar2
600 ,p_contribution_transfer_code in varchar2
601 ,p_special_care_contribution in number
602 ,p_privately_insured_flag in varchar2
603 ,p_add_insurance_provider in number default hr_api.g_number
604 ,p_add_ins_memship_number in varchar2 default hr_api.g_varchar2
605 ,p_add_ins_status in varchar2 default hr_api.g_varchar2
606 ,p_add_ins_start_date in date default hr_api.g_date
607 ,p_add_ins_end_date in date default hr_api.g_date
608 ,p_add_ins_end_reason in number default hr_api.g_number
609 ,p_attribute_category varchar2 default hr_api.g_varchar2
610 ,p_attribute1 varchar2 default hr_api.g_varchar2
611 ,p_attribute2 varchar2 default hr_api.g_varchar2
612 ,p_attribute3 varchar2 default hr_api.g_varchar2
613 ,p_attribute4 varchar2 default hr_api.g_varchar2
614 ,p_attribute5 varchar2 default hr_api.g_varchar2
615 ,p_attribute6 varchar2 default hr_api.g_varchar2
616 ,p_attribute7 varchar2 default hr_api.g_varchar2
617 ,p_attribute8 varchar2 default hr_api.g_varchar2
618 ,p_attribute9 varchar2 default hr_api.g_varchar2
619 ,p_attribute10 varchar2 default hr_api.g_varchar2
620 ,p_attribute11 varchar2 default hr_api.g_varchar2
621 ,p_attribute12 varchar2 default hr_api.g_varchar2
622 ,p_attribute13 varchar2 default hr_api.g_varchar2
623 ,p_attribute14 varchar2 default hr_api.g_varchar2
624 ,p_attribute15 varchar2 default hr_api.g_varchar2
625 ,p_attribute16 varchar2 default hr_api.g_varchar2
626 ,p_attribute17 varchar2 default hr_api.g_varchar2
627 ,p_attribute18 varchar2 default hr_api.g_varchar2
628 ,p_attribute19 varchar2 default hr_api.g_varchar2
629 ,p_attribute20 varchar2 default hr_api.g_varchar2
630 ,p_job_key_code in varchar2 --fix for Bug 13343138
631 ,p_effective_start_date out nocopy date
632 ,p_effective_end_date out nocopy date
633 ,p_object_version_number in out nocopy number
634 ,p_update_warning out nocopy boolean ) is
635
636 --fix for Bug 13343138
637 -- cursor to find the start and end date of the last record
638 CURSOR C_REC_DATE is
639 SELECT ee.effective_start_date
640 FROM pay_element_entries_f ee
641 WHERE ee.element_entry_id = p_element_entry_id
642 and p_effective_date between ee.effective_start_date and ee.effective_end_date;
643
644 l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
645
646 --fix for Bug 13343138 ends
647
648 BEGIN
649
650 --fix for Bug 13343138
651
652 OPEN C_REC_DATE;
653 FETCH C_REC_DATE into l_effective_start_date;
654 CLOSE C_REC_DATE;
655
656 if (l_effective_start_date < to_date('01-12-2011', 'dd-mm-yyyy') and p_datetrack_update_mode = 'CORRECTION' and (p_effective_date >= to_date('01-12-2011', 'dd-mm-yyyy'))) then
657 fnd_message.set_name('PER', 'HR_DE_WRONG_UPDATE_MODE');
658 fnd_message.raise_error;
659 else
660
661 if ((p_effective_date >= to_date('01-12-2011', 'dd-mm-yyyy')) and p_job_key_code is null) then
662 fnd_message.set_name('PER', 'HR_DE_JOB_KEY_CODE_NOT_NULL');
663 fnd_message.raise_error;
664 else
665 --fix for Bug 13343138 ends
666
667 pay_element_entry_api.update_element_entry (
668 p_validate => p_validate
669 ,p_datetrack_update_mode => p_datetrack_update_mode
670 ,p_effective_date => p_effective_date
671 ,p_business_group_id => p_business_group_id
672 ,p_element_entry_id => p_element_entry_id
673 ,p_object_version_number => p_object_version_number
674 ,p_entry_information_category => p_entry_information_category
675 ,p_entry_information1 => p_contribution_key
676 ,p_entry_information2 => p_health_org_id
677 ,p_entry_information3 => p_pension_org_id
678 ,p_entry_information4 => p_unemployment_org_id
679 ,p_entry_information5 => p_special_care_org_id
680 ,p_entry_information6 => p_occupation_key
681 ,p_entry_information7 => p_people_class_key
682 ,p_entry_information8 => p_legal_area_code
683 ,p_entry_information9 => p_health_insurance_number
684 ,p_entry_information10 => p_private_health_prov_id
685 ,p_entry_information11 => p_private_health_contribution
686 ,p_entry_information12 => p_voluntary_pension_prov_id
687 ,p_entry_information13 => p_voluntary_pension_contr
688 ,p_entry_information14 => p_contribution_transfer_code
689 ,p_entry_information15 => p_special_care_contribution
690 ,p_entry_information16 => p_privately_insured_flag
691 ,p_entry_information17 => p_voluntary_pension_number
692 ,p_entry_information18 => p_add_insurance_provider
693 ,p_entry_information19 => p_add_ins_memship_number
694 ,p_entry_information20 => p_add_ins_status
695 ,p_entry_information21 => fnd_date.date_to_canonical(p_add_ins_start_date)
696 ,p_entry_information22 => fnd_date.date_to_canonical(p_add_ins_end_date)
697 ,p_entry_information23 => p_add_ins_end_reason
698 --,p_entry_information24 => hr_api.g_varchar2
699 ,p_entry_information24 => p_job_key_code -- fix for Bug 13343138
700 ,p_entry_information25 => hr_api.g_varchar2
701 ,p_entry_information26 => hr_api.g_varchar2
702 ,p_entry_information27 => hr_api.g_varchar2
703 ,p_entry_information28 => hr_api.g_varchar2
704 ,p_entry_information29 => hr_api.g_varchar2
705 ,p_entry_information30 => hr_api.g_varchar2
706 ,p_updating_action_type => hr_api.g_varchar2
707 ,p_creator_type => hr_api.g_varchar2
708 ,p_reason => hr_api.g_varchar2
709 ,p_attribute_category => p_attribute_category
710 ,p_attribute1 => p_attribute1
711 ,p_attribute2 => p_attribute2
712 ,p_attribute3 => p_attribute3
713 ,p_attribute4 => p_attribute4
714 ,p_attribute5 => p_attribute5
715 ,p_attribute6 => p_attribute6
716 ,p_attribute7 => p_attribute7
717 ,p_attribute8 => p_attribute8
718 ,p_attribute9 => p_attribute9
719 ,p_attribute10 => p_attribute10
720 ,p_attribute11 => p_attribute11
721 ,p_attribute12 => p_attribute12
722 ,p_attribute13 => p_attribute13
723 ,p_attribute14 => p_attribute14
724 ,p_attribute15 => p_attribute15
725 ,p_attribute16 => p_attribute16
726 ,p_attribute17 => p_attribute17
727 ,p_attribute18 => p_attribute18
728 ,p_attribute19 => p_attribute19
729 ,p_attribute20 => p_attribute20
730 ,p_effective_start_date => p_effective_start_date
731 ,p_effective_end_date => p_effective_end_date
732 ,p_update_warning => p_update_warning );
733
734 end if; --Bug 13343138
735 end if; --Bug 13343138
736
737 END update_social_insurance_info;
738
739
740 PROCEDURE insert_social_insurance_info
741 ( p_validate in boolean default false
742 ,p_effective_date in date
743 ,p_business_group_id in number
744 ,p_assignment_id in number
745 ,p_element_link_id in number
746 ,p_entry_type in varchar2
747 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
748 ,p_contribution_key in varchar2
749 ,p_health_org_id in number
750 ,p_pension_org_id in number
751 ,p_unemployment_org_id in number
752 ,p_special_care_org_id in number
753 ,p_occupation_key in varchar2
754 ,p_people_class_key in varchar2
755 ,p_legal_area_code in varchar2
756 ,p_health_insurance_number in varchar2 -- number fix for Bug 13925461
757 ,p_private_health_prov_id in number
758 ,p_private_health_contribution in number
759 ,p_voluntary_pension_prov_id in number
760 ,p_voluntary_pension_contr in number
761 ,p_voluntary_pension_number in varchar2
762 ,p_contribution_transfer_code in varchar2
763 ,p_special_care_contribution in number
764 ,p_privately_insured_flag in varchar2
765 ,p_add_insurance_provider in number default null
766 ,p_add_ins_memship_number in varchar2 default null
767 ,p_add_ins_status in varchar2 default null
768 ,p_add_ins_start_date in date default null
769 ,p_add_ins_end_date in date default null
770 ,p_add_ins_end_reason in number default null
771 ,p_attribute_category varchar2 default hr_api.g_varchar2
772 ,p_attribute1 varchar2 default hr_api.g_varchar2
773 ,p_attribute2 varchar2 default hr_api.g_varchar2
774 ,p_attribute3 varchar2 default hr_api.g_varchar2
775 ,p_attribute4 varchar2 default hr_api.g_varchar2
776 ,p_attribute5 varchar2 default hr_api.g_varchar2
777 ,p_attribute6 varchar2 default hr_api.g_varchar2
778 ,p_attribute7 varchar2 default hr_api.g_varchar2
779 ,p_attribute8 varchar2 default hr_api.g_varchar2
780 ,p_attribute9 varchar2 default hr_api.g_varchar2
781 ,p_attribute10 varchar2 default hr_api.g_varchar2
782 ,p_attribute11 varchar2 default hr_api.g_varchar2
783 ,p_attribute12 varchar2 default hr_api.g_varchar2
784 ,p_attribute13 varchar2 default hr_api.g_varchar2
785 ,p_attribute14 varchar2 default hr_api.g_varchar2
786 ,p_attribute15 varchar2 default hr_api.g_varchar2
787 ,p_attribute16 varchar2 default hr_api.g_varchar2
788 ,p_attribute17 varchar2 default hr_api.g_varchar2
789 ,p_attribute18 varchar2 default hr_api.g_varchar2
790 ,p_attribute19 varchar2 default hr_api.g_varchar2
791 ,p_attribute20 varchar2 default hr_api.g_varchar2
792 ,p_job_key_code in varchar2 -- fix for Bug 13343138
793 ,p_effective_start_date out nocopy date
794 ,p_effective_end_date out nocopy date
795 ,p_element_entry_id out nocopy number
796 ,p_object_version_number out nocopy number
797 ,p_create_warning out nocopy boolean ) is
798
799 BEGIN
800 -- Bug 13343138
801 if ((p_effective_date >= to_date('01-12-2011', 'dd-mm-yyyy')) and p_job_key_code is null) then
802 fnd_message.set_name('PER', 'HR_DE_JOB_KEY_CODE_NOT_NULL');
803 fnd_message.raise_error;
804 else
805 -- Bug 13343138 ends
806
807 pay_element_entry_api.create_element_entry
808 ( p_effective_date => p_effective_date
809 ,p_business_group_id => p_business_group_id
810 ,p_assignment_id => p_assignment_id
811 ,p_element_link_id => p_element_link_id
812 ,p_entry_type => p_entry_type
813 ,p_entry_information_category => p_entry_information_category
814 ,p_entry_information1 => p_contribution_key
815 ,p_entry_information2 => p_health_org_id
816 ,p_entry_information3 => p_pension_org_id
817 ,p_entry_information4 => p_unemployment_org_id
818 ,p_entry_information5 => p_special_care_org_id
819 ,p_entry_information6 => p_occupation_key
820 ,p_entry_information7 => p_people_class_key
821 ,p_entry_information8 => p_legal_area_code
822 ,p_entry_information9 => p_health_insurance_number
823 ,p_entry_information10 => p_private_health_prov_id
824 ,p_entry_information11 => p_private_health_contribution
825 ,p_entry_information12 => p_voluntary_pension_prov_id
826 ,p_entry_information13 => p_voluntary_pension_contr
827 ,p_entry_information14 => p_contribution_transfer_code
828 ,p_entry_information15 => p_special_care_contribution
829 ,p_entry_information16 => p_privately_insured_flag
830 ,p_entry_information17 => p_voluntary_pension_number
831 ,p_entry_information18 => p_add_insurance_provider
832 ,p_entry_information19 => p_add_ins_memship_number
833 ,p_entry_information20 => p_add_ins_status
834 ,p_entry_information21 => fnd_date.date_to_canonical(p_add_ins_start_date)
835 ,p_entry_information22 => fnd_date.date_to_canonical(p_add_ins_end_date)
836 ,p_entry_information23 => p_add_ins_end_reason
837 ,p_entry_information24 => p_job_key_code -- fix for Bug 13343138
838 ,p_attribute_category => p_attribute_category
839 ,p_attribute1 => p_attribute1
840 ,p_attribute2 => p_attribute2
841 ,p_attribute3 => p_attribute3
842 ,p_attribute4 => p_attribute4
843 ,p_attribute5 => p_attribute5
844 ,p_attribute6 => p_attribute6
845 ,p_attribute7 => p_attribute7
846 ,p_attribute8 => p_attribute8
847 ,p_attribute9 => p_attribute9
848 ,p_attribute10 => p_attribute10
849 ,p_attribute11 => p_attribute11
850 ,p_attribute12 => p_attribute12
851 ,p_attribute13 => p_attribute13
852 ,p_attribute14 => p_attribute14
853 ,p_attribute15 => p_attribute15
854 ,p_attribute16 => p_attribute16
855 ,p_attribute17 => p_attribute17
856 ,p_attribute18 => p_attribute18
857 ,p_attribute19 => p_attribute19
858 ,p_attribute20 => p_attribute20
859 ,p_effective_start_date => p_effective_start_date
860 ,p_effective_end_date => p_effective_end_date
861 ,p_element_entry_id => p_element_entry_id
862 ,p_object_version_number => p_object_version_number
863 ,p_create_warning => p_create_warning );
864
865 end if;
866
867 END insert_social_insurance_info;
868
869 -- fix for Bug 13343138
870 function DECODE_LOOKUP (
871 --******************************************************************************
872 --* Returns the meaning for a lookup code of a specified type.
873 --******************************************************************************
874 --
875 p_lookup_type varchar2,
876 p_lookup_code varchar2) return varchar2 is
877 --
878 cursor csr_lookup is
879 select description
880 from hr_lookups
881 where lookup_type = p_lookup_type
882 and lookup_code = p_lookup_code;
883 --
884 v_meaning varchar2(240) := null;
885 --
886 begin
887 --
888 -- Only open the cursor if the parameters are going to retrieve anything
889 --
890 if p_lookup_type is not null and p_lookup_code is not null then
891 --
892 open csr_lookup;
893 fetch csr_lookup into v_meaning;
894 close csr_lookup;
895 --
896 end if;
897 --
898 return v_meaning;
899 --
900 end decode_lookup;
901 -- fix for Bug 13343138 ends
902
903 END;