[Home] [Help]
PACKAGE BODY: APPS.PER_DE_ELE_API
Source
1 PACKAGE BODY PER_DE_ELE_API AS
2 /*$Header: perdeele.pkb 120.0.12000000.2 2007/03/20 15:17:27 abppradh noship $*/
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_effective_start_date out nocopy date,
69 p_effective_end_date out nocopy date,
70 p_update_warning out nocopy boolean
71 ) is
72 l_delete_warning boolean;
73
74 BEGIN
75
76 -- l_last_day_of_year := '31-DEC-' || to_char(p_effective_date,'YYYY');
77
78 pay_element_entry_api.update_element_entry (
79 p_validate => p_validate
80 ,p_datetrack_update_mode => p_datetrack_update_mode
81 ,p_effective_date => p_effective_date
82 ,p_business_group_id => p_business_group_id
83 ,p_element_entry_id => p_element_entry_id
84 ,p_object_version_number => p_object_version_number
85 ,p_entry_information_category => p_entry_information_category
86 ,p_entry_information2 => p_tax_year
87 ,p_entry_information1 => p_tax_card_number
88 ,p_entry_information3 => p_issue_date
89 ,p_entry_information4 => p_card_issuer
90 --,p_entry_information5 => p_tax_office
91 --,p_entry_information6 => p_tax_office_name
92 ,p_entry_information20 => p_tax_organization_id
93 ,p_entry_information7 => p_tax_card_location
94 ,p_entry_information8 => p_tax_status
95 ,p_entry_information9 => p_tax_table
96 ,p_entry_information10 => p_tax_class
97 ,p_entry_information11 => p_no_of_children
98 ,p_entry_information12 => p_yearly_tax_free_income
99 ,p_entry_information13 => p_monthly_tax_free_income
100 ,p_entry_information14 => p_additional_year_tax_income
101 ,p_entry_information15 => p_Yearly_Income_Tax_Calc_flag
102 ,p_entry_information16 => p_chamber_contribution
103 ,p_entry_information17 => p_pensioners_tax_flag
104 ,p_entry_information18 => p_additional_mth_tax_income
105 ,p_entry_information19 => p_employee_church_code
106 ,p_entry_information21 => p_spouse_church_code
107 ,p_entry_information22 => hr_api.g_varchar2
108 ,p_entry_information23 => p_bundesland_church
109 ,p_entry_information24 => p_yearly_church_tax_flag
110 ,p_entry_information25 => p_Max_church_tax_flag
111 ,p_entry_information26 => p_updated
112 ,p_entry_information27 => hr_api.g_varchar2
113 ,p_entry_information28 => hr_api.g_varchar2
114 ,p_entry_information29 => hr_api.g_varchar2
115 ,p_entry_information30 => hr_api.g_varchar2
116 ,p_updating_action_type => hr_api.g_varchar2
117 ,p_creator_type => hr_api.g_varchar2
118 ,p_reason => hr_api.g_varchar2
119 ,p_attribute_category => hr_api.g_varchar2
120 ,p_attribute1 => hr_api.g_varchar2
121 ,p_attribute2 => hr_api.g_varchar2
122 ,p_attribute3 => hr_api.g_varchar2
123 ,p_attribute4 => hr_api.g_varchar2
124 ,p_attribute5 => hr_api.g_varchar2
125 ,p_attribute6 => hr_api.g_varchar2
126 ,p_attribute7 => hr_api.g_varchar2
127 ,p_attribute8 => hr_api.g_varchar2
128 ,p_attribute9 => hr_api.g_varchar2
129 ,p_attribute10 => hr_api.g_varchar2
130 ,p_attribute11 => hr_api.g_varchar2
131 ,p_attribute12 => hr_api.g_varchar2
132 ,p_attribute13 => hr_api.g_varchar2
133 ,p_attribute14 => hr_api.g_varchar2
134 ,p_attribute15 => hr_api.g_varchar2
135 ,p_attribute16 => hr_api.g_varchar2
136 ,p_attribute17 => hr_api.g_varchar2
137 ,p_attribute18 => hr_api.g_varchar2
138 ,p_attribute19 => hr_api.g_varchar2
139 ,p_attribute20 => hr_api.g_varchar2
140 ,p_effective_start_date => p_effective_start_date
141 ,p_effective_end_date => p_effective_end_date
142 ,p_update_warning => p_update_warning
143 );
144 -- Following the update, check the Tax Card details and set the end date back to the last day of the year.
145 -- no longer required
146 /* IF p_datetrack_update_mode in ('FUTURE_CHANGES','UPDATE_OVERRIDE') THEN
147 pay_element_entry_api.delete_element_entry
148 (
149 p_datetrack_delete_mode => 'DELETE'
150 ,p_effective_date => l_last_day_of_year
151 ,p_element_entry_id => p_element_entry_id
152 ,p_object_version_number => p_object_version_number
153 ,p_effective_start_date => p_effective_start_date
154 ,p_effective_end_date => p_effective_end_date
155 ,p_delete_warning => l_delete_warning );
156 END IF;
157 */
158 END Update_tax_information;
159
160
161 PROCEDURE Insert_tax_information
162 (
163 p_validate in boolean default false
164 ,p_effective_date in date
165 ,p_business_group_id in number
166 ,p_assignment_id in number
167 ,p_element_link_id in number
168 ,p_entry_type in varchar2
169 ,p_entry_information_category in varchar2 default 'DE_TAX INFORMATION'
170 ,p_tax_year varchar2 default hr_api.g_varchar2
171 ,p_tax_card_number in varchar2 default hr_api.g_varchar2
172 ,p_issue_date in varchar2 default hr_api.g_varchar2
173 ,p_card_issuer in varchar2 default hr_api.g_varchar2
174 ,p_tax_status varchar2 default hr_api.g_varchar2
175 ,p_tax_table varchar2 default hr_api.g_varchar2
176 ,p_tax_class varchar2 default hr_api.g_varchar2
177 --,p_tax_office varchar2 default hr_api.g_varchar2
178 --,p_tax_office_name varchar2 default hr_api.g_varchar2
179 ,p_tax_organization_id varchar2 default hr_api.g_varchar2
180 ,p_tax_card_location varchar2 default hr_api.g_varchar2
181 ,p_no_of_children varchar2 default hr_api.g_varchar2
182 ,p_yearly_tax_free_income varchar2 default hr_api.g_varchar2
183 ,p_monthly_tax_free_income varchar2 default hr_api.g_varchar2
184 ,p_additional_year_tax_income varchar2 default hr_api.g_varchar2
185 ,p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2
186 ,p_chamber_contribution varchar2 default hr_api.g_varchar2
187 ,p_pensioners_tax_flag varchar2 default hr_api.g_varchar2
188 ,p_additional_mth_tax_income varchar2 default hr_api.g_varchar2
189 -- ,p_effective_date_from varchar2 default hr_api.g_varchar2
190 -- ,p_effective_date_to varchar2 default hr_api.g_varchar2
191 ,p_employee_church_code varchar2 default hr_api.g_varchar2
192 ,p_spouse_church_code varchar2 default hr_api.g_varchar2
193 ,p_bundesland_church varchar2 default hr_api.g_varchar2
194 ,p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2
195 ,p_max_church_tax_flag varchar2 default hr_api.g_varchar2
196 ,p_updated varchar2 default hr_api.g_varchar2
197 ,p_effective_start_date out nocopy date
198 ,p_effective_end_date out nocopy date
199 ,p_element_entry_id out nocopy number
200 ,p_object_version_number out nocopy number
201 ,p_create_warning out nocopy boolean ) is
202
203 BEGIN
204 pay_element_entry_api.create_element_entry
205 ( p_effective_date => p_effective_date
206 ,p_business_group_id => p_business_group_id
207 ,p_assignment_id => p_assignment_id
208 ,p_element_link_id => p_element_link_id
209 ,p_entry_type => p_entry_type
210 ,p_entry_information2 => p_tax_year
211 ,p_entry_information_category => p_entry_information_category
212 ,p_entry_information1 => p_tax_card_number
213 ,p_entry_information3 => p_issue_date
214 ,p_entry_information4 => p_card_issuer
215 -- ,p_entry_information5 => p_tax_office
216 -- ,p_entry_information6 => p_tax_office_name
217 ,p_entry_information7 => p_tax_card_location
218 ,p_entry_information8 => p_tax_status
219 ,p_entry_information9 => p_tax_table
220 ,p_entry_information10 => p_tax_class
221 ,p_entry_information11 => p_no_of_children
222 ,p_entry_information12 => p_yearly_tax_free_income
223 ,p_entry_information13 => p_monthly_tax_free_income
224 ,p_entry_information14 => p_additional_year_tax_income
225 ,p_entry_information15 => p_Yearly_Income_Tax_Calc_flag
226 ,p_entry_information16 => p_chamber_contribution
227 ,p_entry_information17 => p_pensioners_tax_flag
228 ,p_entry_information18 => p_additional_mth_tax_income
229 ,p_entry_information19 => p_employee_church_code
230 ,p_entry_information20 => p_tax_organization_id
231 ,p_entry_information21 => p_spouse_church_code
232 ,p_entry_information23 => p_bundesland_church
233 ,p_entry_information24 => p_yearly_church_tax_flag
234 ,p_entry_information25 => p_Max_church_tax_flag
235 ,p_entry_information26 => p_updated
236 ,p_effective_start_date => p_effective_start_date
237 ,p_effective_end_date => p_effective_end_date
238 ,p_element_entry_id => p_element_entry_id
239 ,p_object_version_number => p_object_version_number
240 ,p_create_warning => p_create_warning );
241
242 END Insert_tax_information;
243
244 PROCEDURE delete_tax_exemptions
245 (p_validate in boolean default false
246 ,p_datetrack_delete_mode in varchar2
247 ,p_effective_date in date
248 ,p_element_entry_id in number
249 ,p_object_version_number in out nocopy number
250 ,p_effective_start_date out nocopy date
251 ,p_effective_end_date out nocopy date
252 ,p_delete_warning out nocopy boolean
253 ) IS
254
255 l_last_day_of_year varchar2(11);
256
257 BEGIN
258 pay_element_entry_api.delete_element_entry
259 (
260 p_validate => p_validate
261 ,p_datetrack_delete_mode => p_datetrack_delete_mode
262 ,p_effective_date => p_effective_date
263 ,p_element_entry_id => p_element_entry_id
264 ,p_object_version_number => p_object_version_number
265 ,p_effective_start_date => p_effective_start_date
266 ,p_effective_end_date => p_effective_end_date
267 ,p_delete_warning => p_delete_warning );
268
269 -- no longer required
270 -- Carry out a correction to fix the Tax card Details so that the end date is still the last day of the year
271
272 -- l_last_day_of_year := '31-DEC-' || to_char(p_effective_start_date,'YYYY');
273
274 /* IF p_datetrack_delete_mode = 'FUTURE_CHANGES' THEN
275 py_element_entry_api.delete_element_entry
276 (
277 p_datetrack_delete_mode => 'DELETE'
278 ,p_effective_date => l_last_day_of_year
279 ,p_element_entry_id => p_element_entry_id
280 ,p_object_version_number => p_object_version_number
281 ,p_effective_start_date => p_effective_start_date
282 ,p_effective_end_date => p_effective_end_date
283 ,p_delete_warning => p_delete_warning );
284 END IF; */
285
286 END delete_tax_exemptions;
287
288 PROCEDURE Update_tax_exemptions
289 (
290 p_validate in boolean default false,
291 p_datetrack_update_mode in varchar2,
292 p_effective_date in date,
293 p_business_group_id in number,
294 p_element_entry_id in number,
295 p_object_version_number in out nocopy number,
296 p_entry_information_category varchar2 default 'DE_TAX EXEMPTIONS',
297 p_form_number varchar2 default hr_api.g_varchar2,
298 p_issue_date varchar2 default hr_api.g_varchar2,
299 p_valid_from varchar2 default hr_api.g_varchar2,
300 p_valid_to varchar2 default hr_api.g_varchar2,
301 p_tax_free_remuneration varchar2 default hr_api.g_varchar2,
302 -- p_assignment_id varchar2 default hr_api.g_varchar2,
303 p_effective_start_date out nocopy date,
304 P_effective_end_date out nocopy date,
305 p_update_warning out nocopy boolean
306 ) is
307
308 BEGIN
309
310 pay_element_entry_api.update_element_entry (
311 p_validate => p_validate
312 ,p_datetrack_update_mode => p_datetrack_update_mode
313 ,p_effective_date => p_effective_date
314 ,p_business_group_id => p_business_group_id
315 ,p_element_entry_id => p_element_entry_id
316 ,p_object_version_number => p_object_version_number
317 ,p_entry_information_category => p_entry_information_category
318 ,p_entry_information1 => p_form_number
319 ,p_entry_information2 => p_issue_date
320 ,p_entry_information3 => p_valid_from
321 ,p_entry_information4 => p_valid_to
322 ,p_entry_information5 => p_tax_free_remuneration
323 ,p_entry_information6 => hr_api.g_varchar2
324 ,p_entry_information7 => hr_api.g_varchar2
325 ,p_entry_information8 => hr_api.g_varchar2
326 ,p_entry_information9 => hr_api.g_varchar2
327 ,p_entry_information10 => hr_api.g_varchar2
328 ,p_entry_information11 => hr_api.g_varchar2
329 ,p_entry_information12 => hr_api.g_varchar2
330 ,p_entry_information13 => hr_api.g_varchar2
331 ,p_entry_information14 => hr_api.g_varchar2
332 ,p_entry_information15 => hr_api.g_varchar2
333 ,p_entry_information16 => hr_api.g_varchar2
334 ,p_entry_information17 => hr_api.g_varchar2
335 ,p_entry_information18 => hr_api.g_varchar2
336 ,p_entry_information19 => hr_api.g_varchar2
337 ,p_entry_information20 => hr_api.g_varchar2
338 ,p_entry_information21 => hr_api.g_varchar2
339 ,p_entry_information22 => hr_api.g_varchar2
340 ,p_entry_information23 => hr_api.g_varchar2
341 ,p_entry_information24 => hr_api.g_varchar2
342 ,p_entry_information25 => hr_api.g_varchar2
343 ,p_entry_information26 => hr_api.g_varchar2
344 ,p_entry_information27 => hr_api.g_varchar2
345 ,p_entry_information28 => hr_api.g_varchar2
346 ,p_entry_information29 => hr_api.g_varchar2
347 ,p_entry_information30 => hr_api.g_varchar2
348 ,p_updating_action_type => hr_api.g_varchar2
349 ,p_creator_type => hr_api.g_varchar2
350 ,p_reason => hr_api.g_varchar2
351 ,p_attribute_category => hr_api.g_varchar2
352 ,p_attribute1 => hr_api.g_varchar2
353 ,p_attribute2 => hr_api.g_varchar2
354 ,p_attribute3 => hr_api.g_varchar2
355 ,p_attribute4 => hr_api.g_varchar2
356 ,p_attribute5 => hr_api.g_varchar2
357 ,p_attribute6 => hr_api.g_varchar2
358 ,p_attribute7 => hr_api.g_varchar2
359 ,p_attribute8 => hr_api.g_varchar2
360 ,p_attribute9 => hr_api.g_varchar2
361 ,p_attribute10 => hr_api.g_varchar2
362 ,p_attribute11 => hr_api.g_varchar2
363 ,p_attribute12 => hr_api.g_varchar2
364 ,p_attribute13 => hr_api.g_varchar2
365 ,p_attribute14 => hr_api.g_varchar2
366 ,p_attribute15 => hr_api.g_varchar2
367 ,p_attribute16 => hr_api.g_varchar2
368 ,p_attribute17 => hr_api.g_varchar2
369 ,p_attribute18 => hr_api.g_varchar2
370 ,p_attribute19 => hr_api.g_varchar2
371 ,p_attribute20 => hr_api.g_varchar2
372 ,p_effective_start_date => p_effective_start_date
373 ,p_effective_end_date => p_effective_end_date
374 ,p_update_warning => p_update_warning
375 );
376
377 END Update_tax_exemptions;
378
379 PROCEDURE Insert_tax_exemptions
380 (
381 p_validate in boolean default false
382 ,p_effective_date in date
383 ,p_business_group_id in number
384 ,p_assignment_id in number
385 ,p_element_link_id in number
386 ,p_entry_type in varchar2
387 ,p_entry_information_category in varchar2 default 'DE_TAX EXEMPTIONS'
388 ,p_form_number varchar2 default hr_api.g_varchar2
389 ,p_issue_date varchar2 default hr_api.g_varchar2
390 ,p_valid_from varchar2 default hr_api.g_varchar2
391 ,p_valid_to varchar2 default hr_api.g_varchar2
392 ,p_tax_free_remuneration varchar2 default hr_api.g_varchar2
393 ,p_effective_start_date out nocopy date
394 ,p_effective_end_date out nocopy date
395 ,p_element_entry_id out nocopy number
396 ,p_object_version_number out nocopy number
397 ,p_create_warning out nocopy boolean ) is
398
399 BEGIN
400
401 pay_element_entry_api.create_element_entry
402 ( p_effective_date => p_effective_date
403 ,p_business_group_id => p_business_group_id
404 ,p_assignment_id => p_assignment_id
405 ,p_element_link_id => p_element_link_id
406 ,p_entry_type => p_entry_type
407 ,p_entry_information_category => p_entry_information_category
408 ,p_entry_information1 => p_form_number
409 ,p_entry_information2 => p_issue_date
410 ,p_entry_information3 => p_valid_from
411 ,p_entry_information4 => p_valid_to
412 ,p_entry_information5 => p_tax_free_remuneration
413 ,p_effective_start_date => p_effective_start_date
414 ,p_effective_end_date => p_effective_end_date
415 ,p_element_entry_id => p_element_entry_id
416 ,p_object_version_number => p_object_version_number
417 ,p_create_warning => p_create_warning );
418
419 END Insert_tax_exemptions;
420
421 /*------------------------------------------------------------------------
422 Social Insurance
423
424 -------------------------------------------------------------------------*/
425
426 PROCEDURE delete_social_insurance_info
427 (p_validate in boolean default false
428 ,p_datetrack_delete_mode in varchar2
429 ,p_effective_date in date
430 ,p_element_entry_id in number
431 ,p_object_version_number in out nocopy number
432 ,p_effective_start_date out nocopy date
433 ,p_effective_end_date out nocopy date
434 ,p_delete_warning out nocopy boolean
435 ) is
436
437 BEGIN
438
439 pay_element_entry_api.delete_element_entry
440 (
441 p_validate => p_validate
442 ,p_datetrack_delete_mode => p_datetrack_delete_mode
443 ,p_effective_date => p_effective_date
444 ,p_element_entry_id => p_element_entry_id
445 ,p_object_version_number => p_object_version_number
446 ,p_effective_start_date => p_effective_start_date
447 ,p_effective_end_date => p_effective_end_date
448 ,p_delete_warning => p_delete_warning );
449
450 END delete_social_insurance_info;
451
452
453 PROCEDURE update_social_insurance_info
454 ( p_validate in boolean default false
455 ,p_datetrack_update_mode in varchar2
456 ,p_effective_date in date
457 ,p_business_group_id in number
458 ,p_element_entry_id in number
459 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
460 ,p_contribution_key in varchar2
461 ,p_health_org_id in number
462 ,p_pension_org_id in number
463 ,p_unemployment_org_id in number
464 ,p_special_care_org_id in number
465 ,p_occupation_key in varchar2
466 ,p_people_class_key in varchar2
467 ,p_legal_area_code in varchar2
468 ,p_health_insurance_number in number
469 ,p_private_health_prov_id in number
470 ,p_private_health_contribution in number
471 ,p_voluntary_pension_prov_id in number
472 ,p_voluntary_pension_contr in number
473 ,p_voluntary_pension_number in varchar2
474 ,p_contribution_transfer_code in varchar2
475 ,p_special_care_contribution in number
476 ,p_privately_insured_flag in varchar2
477 ,p_add_insurance_provider in number default hr_api.g_number
478 ,p_add_ins_memship_number in varchar2 default hr_api.g_varchar2
479 ,p_add_ins_status in varchar2 default hr_api.g_varchar2
480 ,p_add_ins_start_date in date default hr_api.g_date
481 ,p_add_ins_end_date in date default hr_api.g_date
482 ,p_add_ins_end_reason in number default hr_api.g_number
483 ,p_effective_start_date out nocopy date
484 ,p_effective_end_date out nocopy date
485 ,p_object_version_number in out nocopy number
486 ,p_update_warning out nocopy boolean ) is
487
488 BEGIN
489 pay_element_entry_api.update_element_entry (
490 p_validate => p_validate
491 ,p_datetrack_update_mode => p_datetrack_update_mode
492 ,p_effective_date => p_effective_date
493 ,p_business_group_id => p_business_group_id
494 ,p_element_entry_id => p_element_entry_id
495 ,p_object_version_number => p_object_version_number
496 ,p_entry_information_category => p_entry_information_category
497 ,p_entry_information1 => p_contribution_key
498 ,p_entry_information2 => p_health_org_id
499 ,p_entry_information3 => p_pension_org_id
500 ,p_entry_information4 => p_unemployment_org_id
501 ,p_entry_information5 => p_special_care_org_id
502 ,p_entry_information6 => p_occupation_key
503 ,p_entry_information7 => p_people_class_key
504 ,p_entry_information8 => p_legal_area_code
505 ,p_entry_information9 => p_health_insurance_number
506 ,p_entry_information10 => p_private_health_prov_id
507 ,p_entry_information11 => p_private_health_contribution
508 ,p_entry_information12 => p_voluntary_pension_prov_id
509 ,p_entry_information13 => p_voluntary_pension_contr
510 ,p_entry_information14 => p_contribution_transfer_code
511 ,p_entry_information15 => p_special_care_contribution
512 ,p_entry_information16 => p_privately_insured_flag
513 ,p_entry_information17 => p_voluntary_pension_number
514 ,p_entry_information18 => p_add_insurance_provider
515 ,p_entry_information19 => p_add_ins_memship_number
516 ,p_entry_information20 => p_add_ins_status
517 ,p_entry_information21 => fnd_date.date_to_canonical(p_add_ins_start_date)
518 ,p_entry_information22 => fnd_date.date_to_canonical(p_add_ins_end_date)
519 ,p_entry_information23 => p_add_ins_end_reason
520 ,p_entry_information24 => hr_api.g_varchar2
521 ,p_entry_information25 => hr_api.g_varchar2
522 ,p_entry_information26 => hr_api.g_varchar2
523 ,p_entry_information27 => hr_api.g_varchar2
524 ,p_entry_information28 => hr_api.g_varchar2
525 ,p_entry_information29 => hr_api.g_varchar2
526 ,p_entry_information30 => hr_api.g_varchar2
527 ,p_updating_action_type => hr_api.g_varchar2
528 ,p_creator_type => hr_api.g_varchar2
529 ,p_reason => hr_api.g_varchar2
530 ,p_attribute_category => hr_api.g_varchar2
531 ,p_attribute1 => hr_api.g_varchar2
532 ,p_attribute2 => hr_api.g_varchar2
533 ,p_attribute3 => hr_api.g_varchar2
534 ,p_attribute4 => hr_api.g_varchar2
535 ,p_attribute5 => hr_api.g_varchar2
536 ,p_attribute6 => hr_api.g_varchar2
537 ,p_attribute7 => hr_api.g_varchar2
538 ,p_attribute8 => hr_api.g_varchar2
539 ,p_attribute9 => hr_api.g_varchar2
540 ,p_attribute10 => hr_api.g_varchar2
541 ,p_attribute11 => hr_api.g_varchar2
542 ,p_attribute12 => hr_api.g_varchar2
543 ,p_attribute13 => hr_api.g_varchar2
544 ,p_attribute14 => hr_api.g_varchar2
545 ,p_attribute15 => hr_api.g_varchar2
546 ,p_attribute16 => hr_api.g_varchar2
547 ,p_attribute17 => hr_api.g_varchar2
548 ,p_attribute18 => hr_api.g_varchar2
549 ,p_attribute19 => hr_api.g_varchar2
550 ,p_attribute20 => hr_api.g_varchar2
551 ,p_effective_start_date => p_effective_start_date
552 ,p_effective_end_date => p_effective_end_date
553 ,p_update_warning => p_update_warning );
554
555 END update_social_insurance_info;
556
557
558 PROCEDURE insert_social_insurance_info
559 ( p_validate in boolean default false
560 ,p_effective_date in date
561 ,p_business_group_id in number
562 ,p_assignment_id in number
563 ,p_element_link_id in number
564 ,p_entry_type in varchar2
565 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
566 ,p_contribution_key in varchar2
567 ,p_health_org_id in number
568 ,p_pension_org_id in number
569 ,p_unemployment_org_id in number
570 ,p_special_care_org_id in number
571 ,p_occupation_key in varchar2
572 ,p_people_class_key in varchar2
573 ,p_legal_area_code in varchar2
574 ,p_health_insurance_number in number
575 ,p_private_health_prov_id in number
576 ,p_private_health_contribution in number
577 ,p_voluntary_pension_prov_id in number
578 ,p_voluntary_pension_contr in number
579 ,p_voluntary_pension_number in varchar2
580 ,p_contribution_transfer_code in varchar2
581 ,p_special_care_contribution in number
582 ,p_privately_insured_flag in varchar2
583 ,p_add_insurance_provider in number default null
584 ,p_add_ins_memship_number in varchar2 default null
585 ,p_add_ins_status in varchar2 default null
586 ,p_add_ins_start_date in date default null
587 ,p_add_ins_end_date in date default null
588 ,p_add_ins_end_reason in number default null
589 ,p_effective_start_date out nocopy date
590 ,p_effective_end_date out nocopy date
591 ,p_element_entry_id out nocopy number
592 ,p_object_version_number out nocopy number
593 ,p_create_warning out nocopy boolean ) is
594
595 BEGIN
596
597 pay_element_entry_api.create_element_entry
598 ( p_effective_date => p_effective_date
599 ,p_business_group_id => p_business_group_id
600 ,p_assignment_id => p_assignment_id
601 ,p_element_link_id => p_element_link_id
602 ,p_entry_type => p_entry_type
603 ,p_entry_information_category => p_entry_information_category
604 ,p_entry_information1 => p_contribution_key
605 ,p_entry_information2 => p_health_org_id
606 ,p_entry_information3 => p_pension_org_id
607 ,p_entry_information4 => p_unemployment_org_id
608 ,p_entry_information5 => p_special_care_org_id
609 ,p_entry_information6 => p_occupation_key
610 ,p_entry_information7 => p_people_class_key
611 ,p_entry_information8 => p_legal_area_code
612 ,p_entry_information9 => p_health_insurance_number
613 ,p_entry_information10 => p_private_health_prov_id
614 ,p_entry_information11 => p_private_health_contribution
615 ,p_entry_information12 => p_voluntary_pension_prov_id
616 ,p_entry_information13 => p_voluntary_pension_contr
617 ,p_entry_information14 => p_contribution_transfer_code
618 ,p_entry_information15 => p_special_care_contribution
619 ,p_entry_information16 => p_privately_insured_flag
620 ,p_entry_information17 => p_voluntary_pension_number
621 ,p_entry_information18 => p_add_insurance_provider
622 ,p_entry_information19 => p_add_ins_memship_number
623 ,p_entry_information20 => p_add_ins_status
624 ,p_entry_information21 => fnd_date.date_to_canonical(p_add_ins_start_date)
625 ,p_entry_information22 => fnd_date.date_to_canonical(p_add_ins_end_date)
626 ,p_entry_information23 => p_add_ins_end_reason
627 ,p_effective_start_date => p_effective_start_date
628 ,p_effective_end_date => p_effective_end_date
629 ,p_element_entry_id => p_element_entry_id
630 ,p_object_version_number => p_object_version_number
631 ,p_create_warning => p_create_warning );
632
633 END insert_social_insurance_info;
634
635 END;