[Home] [Help]
PACKAGE: APPS.PER_DE_ELE_API
Source
4
1 PACKAGE PER_DE_ELE_API AUTHID CURRENT_USER AS
2 /*$Header: perdeele.pkh 120.4.12020000.2 2012/07/05 03:56:05 amnaraya ship $*/
3
5 PROCEDURE delete_tax_information
6 (p_validate in boolean default false
7 ,p_datetrack_delete_mode in varchar2
8 ,p_effective_date in date
9 ,p_element_entry_id in number
10 ,p_object_version_number in out nocopy number
11 ,p_effective_start_date out nocopy date
12 ,p_effective_end_date out nocopy date
13 ,p_delete_warning out nocopy boolean
14 );
15
16 PROCEDURE Update_tax_information
17 (
18 p_validate in boolean default false,
19 p_datetrack_update_mode in varchar2,
20 p_effective_date in date,
21 p_business_group_id in number,
22 p_element_entry_id in number,
23 p_object_version_number in out nocopy number,
24 p_entry_information_category varchar2 default 'DE_TAX INFORMATION',
25 p_tax_year varchar2 default hr_api.g_varchar2,
29 p_tax_status varchar2 default hr_api.g_varchar2,
26 p_tax_card_number varchar2 default hr_api.g_varchar2,
27 p_issue_date varchar2 default hr_api.g_varchar2,
28 p_card_issuer varchar2 default hr_api.g_varchar2,
30 p_tax_table varchar2 default hr_api.g_varchar2,
31 p_tax_class varchar2 default hr_api.g_varchar2,
32 --p_tax_office varchar2 default hr_api.g_varchar2,
33 --p_tax_office_name varchar2 default hr_api.g_varchar2,
34 p_tax_organization_id varchar2 default hr_api.g_varchar2,
35 p_tax_card_location varchar2 default hr_api.g_varchar2,
36 p_no_of_children varchar2 default hr_api.g_varchar2,
37 p_yearly_tax_free_income varchar2 default hr_api.g_varchar2,
38 p_monthly_tax_free_income varchar2 default hr_api.g_varchar2,
39 p_additional_year_tax_income varchar2 default hr_api.g_varchar2,
40 p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2,
41 p_chamber_contribution varchar2 default hr_api.g_varchar2,
42 p_pensioners_tax_flag varchar2 default hr_api.g_varchar2,
43 p_additional_mth_tax_income varchar2 default hr_api.g_varchar2,
44 p_employee_church_code varchar2 default hr_api.g_varchar2,
45 p_spouse_church_code varchar2 default hr_api.g_varchar2,
46 p_bundesland_church varchar2 default hr_api.g_varchar2,
47 p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2,
48 p_max_church_tax_flag varchar2 default hr_api.g_varchar2,
49 -- p_assignment_id varchar2 default hr_api.g_varchar2,
50 p_updated varchar2 default hr_api.g_varchar2,
51 p_attribute_category varchar2 default hr_api.g_varchar2,
52 p_attribute1 varchar2 default hr_api.g_varchar2,
53 p_attribute2 varchar2 default hr_api.g_varchar2,
54 p_attribute3 varchar2 default hr_api.g_varchar2,
55 p_attribute4 varchar2 default hr_api.g_varchar2,
56 p_attribute5 varchar2 default hr_api.g_varchar2,
57 p_attribute6 varchar2 default hr_api.g_varchar2,
58 p_attribute7 varchar2 default hr_api.g_varchar2,
59 p_attribute8 varchar2 default hr_api.g_varchar2,
60 p_attribute9 varchar2 default hr_api.g_varchar2,
61 p_attribute10 varchar2 default hr_api.g_varchar2,
62 p_attribute11 varchar2 default hr_api.g_varchar2,
63 p_attribute12 varchar2 default hr_api.g_varchar2,
64 p_attribute13 varchar2 default hr_api.g_varchar2,
65 p_attribute14 varchar2 default hr_api.g_varchar2,
66 p_attribute15 varchar2 default hr_api.g_varchar2,
67 p_attribute16 varchar2 default hr_api.g_varchar2,
68 p_attribute17 varchar2 default hr_api.g_varchar2,
69 p_attribute18 varchar2 default hr_api.g_varchar2,
70 p_attribute19 varchar2 default hr_api.g_varchar2,
71 p_attribute20 varchar2 default hr_api.g_varchar2,
72 p_effective_start_date out nocopy date,
73 p_effective_end_date out nocopy date,
74 p_update_warning out nocopy boolean
75 );
76
77 PROCEDURE Insert_tax_information
78 (
79 p_validate in boolean default false
80 ,p_effective_date in date
81 ,p_business_group_id in number
82 ,p_assignment_id in number
83 ,p_element_link_id in number
84 ,p_entry_type in varchar2
85 ,p_entry_information_category in varchar2 default 'DE_TAX INFORMATION'
86 ,p_tax_year in varchar2 default hr_api.g_varchar2
87 ,p_tax_card_number in varchar2 default hr_api.g_varchar2
88 ,p_issue_date in varchar2 default hr_api.g_varchar2
89 ,p_card_issuer in varchar2 default hr_api.g_varchar2
90 ,p_tax_status varchar2 default hr_api.g_varchar2
91 ,p_tax_table varchar2 default hr_api.g_varchar2
92 ,p_tax_class varchar2 default hr_api.g_varchar2
93 --,p_tax_office varchar2 default hr_api.g_varchar2
94 --,p_tax_office_name varchar2 default hr_api.g_varchar2
95 ,p_tax_organization_id varchar2 default hr_api.g_varchar2
96 ,p_tax_card_location varchar2 default hr_api.g_varchar2
97 ,p_no_of_children varchar2 default hr_api.g_varchar2
98 ,p_yearly_tax_free_income varchar2 default hr_api.g_varchar2
99 ,p_monthly_tax_free_income varchar2 default hr_api.g_varchar2
100 ,p_additional_year_tax_income varchar2 default hr_api.g_varchar2
101 ,p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2
102 ,p_chamber_contribution varchar2 default hr_api.g_varchar2
103 ,p_pensioners_tax_flag varchar2 default hr_api.g_varchar2
104 ,p_additional_mth_tax_income varchar2 default hr_api.g_varchar2
105 -- ,p_effective_date_from varchar2 default hr_api.g_varchar2
106 -- ,p_effective_date_to varchar2 default hr_api.g_varchar2
107 ,p_employee_church_code varchar2 default hr_api.g_varchar2
108 ,p_spouse_church_code varchar2 default hr_api.g_varchar2
109 ,p_bundesland_church varchar2 default hr_api.g_varchar2
110 ,p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2
111 ,p_max_church_tax_flag varchar2 default hr_api.g_varchar2
115 ,p_attribute2 varchar2 default hr_api.g_varchar2
112 ,p_updated varchar2 default hr_api.g_varchar2
113 ,p_attribute_category varchar2 default hr_api.g_varchar2
114 ,p_attribute1 varchar2 default hr_api.g_varchar2
116 ,p_attribute3 varchar2 default hr_api.g_varchar2
117 ,p_attribute4 varchar2 default hr_api.g_varchar2
118 ,p_attribute5 varchar2 default hr_api.g_varchar2
119 ,p_attribute6 varchar2 default hr_api.g_varchar2
120 ,p_attribute7 varchar2 default hr_api.g_varchar2
121 ,p_attribute8 varchar2 default hr_api.g_varchar2
122 ,p_attribute9 varchar2 default hr_api.g_varchar2
123 ,p_attribute10 varchar2 default hr_api.g_varchar2
124 ,p_attribute11 varchar2 default hr_api.g_varchar2
125 ,p_attribute12 varchar2 default hr_api.g_varchar2
126 ,p_attribute13 varchar2 default hr_api.g_varchar2
127 ,p_attribute14 varchar2 default hr_api.g_varchar2
128 ,p_attribute15 varchar2 default hr_api.g_varchar2
129 ,p_attribute16 varchar2 default hr_api.g_varchar2
130 ,p_attribute17 varchar2 default hr_api.g_varchar2
131 ,p_attribute18 varchar2 default hr_api.g_varchar2
132 ,p_attribute19 varchar2 default hr_api.g_varchar2
133 ,p_attribute20 varchar2 default hr_api.g_varchar2
134 ,p_effective_start_date out nocopy date
135 ,p_effective_end_date out nocopy date
136 ,p_element_entry_id out nocopy number
137 ,p_object_version_number out nocopy number
138 ,p_create_warning out nocopy boolean );
139
140 PROCEDURE delete_tax_exemptions
141 (p_validate in boolean default false
142 ,p_datetrack_delete_mode in varchar2
143 ,p_effective_date in date
144 ,p_element_entry_id in number
145 ,p_object_version_number in out nocopy number
146 ,p_effective_start_date out nocopy date
147 ,p_effective_end_date out nocopy date
148 ,p_delete_warning out nocopy boolean
149 );
150
151 PROCEDURE Update_tax_exemptions
152 (
153 p_validate in boolean default false,
154 p_datetrack_update_mode in varchar2,
155 p_effective_date in date,
156 p_business_group_id in number,
157 p_element_entry_id in number,
158 p_object_version_number in out nocopy number,
159 p_entry_information_category varchar2 default 'DE_TAX EXEMPTIONS',
160 p_form_number varchar2 default hr_api.g_varchar2,
161 p_issue_date varchar2 default hr_api.g_varchar2,
162 p_valid_from varchar2 default hr_api.g_varchar2,
163 p_valid_to varchar2 default hr_api.g_varchar2,
164 p_tax_free_remuneration varchar2 default hr_api.g_varchar2,
165 -- p_assignment_id varchar2 default hr_api.g_varchar2,
166 p_attribute_category varchar2 default hr_api.g_varchar2,
167 p_attribute1 varchar2 default hr_api.g_varchar2,
168 p_attribute2 varchar2 default hr_api.g_varchar2,
169 p_attribute3 varchar2 default hr_api.g_varchar2,
170 p_attribute4 varchar2 default hr_api.g_varchar2,
171 p_attribute5 varchar2 default hr_api.g_varchar2,
172 p_attribute6 varchar2 default hr_api.g_varchar2,
173 p_attribute7 varchar2 default hr_api.g_varchar2,
174 p_attribute8 varchar2 default hr_api.g_varchar2,
175 p_attribute9 varchar2 default hr_api.g_varchar2,
176 p_attribute10 varchar2 default hr_api.g_varchar2,
177 p_attribute11 varchar2 default hr_api.g_varchar2,
178 p_attribute12 varchar2 default hr_api.g_varchar2,
179 p_attribute13 varchar2 default hr_api.g_varchar2,
180 p_attribute14 varchar2 default hr_api.g_varchar2,
181 p_attribute15 varchar2 default hr_api.g_varchar2,
182 p_attribute16 varchar2 default hr_api.g_varchar2,
183 p_attribute17 varchar2 default hr_api.g_varchar2,
184 p_attribute18 varchar2 default hr_api.g_varchar2,
185 p_attribute19 varchar2 default hr_api.g_varchar2,
186 p_attribute20 varchar2 default hr_api.g_varchar2,
187 p_effective_start_date out nocopy date,
188 P_effective_end_date out nocopy date,
189 p_update_warning out nocopy boolean
190 );
191
192 PROCEDURE Insert_tax_exemptions
193 (
194 p_validate in boolean default false
195 ,p_effective_date in date
196 ,p_business_group_id in number
197 ,p_assignment_id in number
198 ,p_element_link_id in number
199 ,p_entry_type in varchar2
200 ,p_entry_information_category in varchar2 default 'DE_TAX EXEMPTIONS'
201 ,p_form_number varchar2 default hr_api.g_varchar2
202 ,p_issue_date varchar2 default hr_api.g_varchar2
203 ,p_valid_from varchar2 default hr_api.g_varchar2
204 ,p_valid_to varchar2 default hr_api.g_varchar2
205 ,p_tax_free_remuneration varchar2 default hr_api.g_varchar2
206 ,p_attribute_category varchar2 default hr_api.g_varchar2
210 ,p_attribute4 varchar2 default hr_api.g_varchar2
207 ,p_attribute1 varchar2 default hr_api.g_varchar2
208 ,p_attribute2 varchar2 default hr_api.g_varchar2
209 ,p_attribute3 varchar2 default hr_api.g_varchar2
211 ,p_attribute5 varchar2 default hr_api.g_varchar2
212 ,p_attribute6 varchar2 default hr_api.g_varchar2
213 ,p_attribute7 varchar2 default hr_api.g_varchar2
214 ,p_attribute8 varchar2 default hr_api.g_varchar2
215 ,p_attribute9 varchar2 default hr_api.g_varchar2
216 ,p_attribute10 varchar2 default hr_api.g_varchar2
217 ,p_attribute11 varchar2 default hr_api.g_varchar2
218 ,p_attribute12 varchar2 default hr_api.g_varchar2
219 ,p_attribute13 varchar2 default hr_api.g_varchar2
220 ,p_attribute14 varchar2 default hr_api.g_varchar2
221 ,p_attribute15 varchar2 default hr_api.g_varchar2
222 ,p_attribute16 varchar2 default hr_api.g_varchar2
223 ,p_attribute17 varchar2 default hr_api.g_varchar2
224 ,p_attribute18 varchar2 default hr_api.g_varchar2
225 ,p_attribute19 varchar2 default hr_api.g_varchar2
226 ,p_attribute20 varchar2 default hr_api.g_varchar2
227 ,p_effective_start_date out nocopy date
228 ,p_effective_end_date out nocopy date
229 ,p_element_entry_id out nocopy number
230 ,p_object_version_number out nocopy number
231 ,p_create_warning out nocopy boolean );
232
233 /*------------------------------------------------------------------------
234 Social Insurance
235
236 -------------------------------------------------------------------------*/
237
238 PROCEDURE delete_social_insurance_info
239 (p_validate in boolean default false
240 ,p_datetrack_delete_mode in varchar2
241 ,p_effective_date in date
242 ,p_element_entry_id in number
243 ,p_object_version_number in out nocopy number
244 ,p_effective_start_date out nocopy date
245 ,p_effective_end_date out nocopy date
246 ,p_delete_warning out nocopy boolean
247 );
248
249 PROCEDURE update_social_insurance_info
250 ( p_validate in boolean default false
251 ,p_datetrack_update_mode in varchar2
252 ,p_effective_date in date
253 ,p_business_group_id in number
254 ,p_element_entry_id in number
255 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
256 ,p_contribution_key in varchar2
257 ,p_health_org_id in number
258 ,p_pension_org_id in number
259 ,p_unemployment_org_id in number
260 ,p_special_care_org_id in number
261 ,p_occupation_key in varchar2
262 ,p_people_class_key in varchar2
263 ,p_legal_area_code in varchar2
264 ,p_health_insurance_number in varchar2 -- number fix for Bug 13925461
265 ,p_private_health_prov_id in number
266 ,p_private_health_contribution in number
267 ,p_voluntary_pension_prov_id in number
268 ,p_voluntary_pension_contr in number
269 ,p_voluntary_pension_number in varchar2
270 ,p_contribution_transfer_code in varchar2
271 ,p_special_care_contribution in number
272 ,p_privately_insured_flag in varchar2
273 ,p_add_insurance_provider in number default hr_api.g_number
274 ,p_add_ins_memship_number in varchar2 default hr_api.g_varchar2
275 ,p_add_ins_status in varchar2 default hr_api.g_varchar2
276 ,p_add_ins_start_date in date default hr_api.g_date
277 ,p_add_ins_end_date in date default hr_api.g_date
278 ,p_add_ins_end_reason in number default hr_api.g_number
279 ,p_attribute_category varchar2 default hr_api.g_varchar2
280 ,p_attribute1 varchar2 default hr_api.g_varchar2
281 ,p_attribute2 varchar2 default hr_api.g_varchar2
282 ,p_attribute3 varchar2 default hr_api.g_varchar2
283 ,p_attribute4 varchar2 default hr_api.g_varchar2
284 ,p_attribute5 varchar2 default hr_api.g_varchar2
285 ,p_attribute6 varchar2 default hr_api.g_varchar2
286 ,p_attribute7 varchar2 default hr_api.g_varchar2
287 ,p_attribute8 varchar2 default hr_api.g_varchar2
288 ,p_attribute9 varchar2 default hr_api.g_varchar2
289 ,p_attribute10 varchar2 default hr_api.g_varchar2
290 ,p_attribute11 varchar2 default hr_api.g_varchar2
291 ,p_attribute12 varchar2 default hr_api.g_varchar2
292 ,p_attribute13 varchar2 default hr_api.g_varchar2
293 ,p_attribute14 varchar2 default hr_api.g_varchar2
294 ,p_attribute15 varchar2 default hr_api.g_varchar2
295 ,p_attribute16 varchar2 default hr_api.g_varchar2
296 ,p_attribute17 varchar2 default hr_api.g_varchar2
297 ,p_attribute18 varchar2 default hr_api.g_varchar2
298 ,p_attribute19 varchar2 default hr_api.g_varchar2
299 ,p_attribute20 varchar2 default hr_api.g_varchar2
300 ,p_job_key_code in varchar2 --fix for Bug 13343138
301 ,p_effective_start_date out nocopy date
305
302 ,p_effective_end_date out nocopy date
303 ,p_object_version_number in out nocopy number
304 ,p_update_warning out nocopy boolean );
306
307 PROCEDURE insert_social_insurance_info
308 ( p_validate in boolean default false
309 ,p_effective_date in date
310 ,p_business_group_id in number
311 ,p_assignment_id in number
312 ,p_element_link_id in number
313 ,p_entry_type in varchar2
314 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
315 ,p_contribution_key in varchar2
316 ,p_health_org_id in number
317 ,p_pension_org_id in number
318 ,p_unemployment_org_id in number
319 ,p_special_care_org_id in number
320 ,p_occupation_key in varchar2
321 ,p_people_class_key in varchar2
322 ,p_legal_area_code in varchar2
323 ,p_health_insurance_number in varchar2 -- number fix for Bug 13925461
324 ,p_private_health_prov_id in number
325 ,p_private_health_contribution in number
326 ,p_voluntary_pension_prov_id in number
327 ,p_voluntary_pension_contr in number
328 ,p_voluntary_pension_number in varchar2
329 ,p_contribution_transfer_code in varchar2
330 ,p_special_care_contribution in number
331 ,p_privately_insured_flag in varchar2
332 ,p_add_insurance_provider in number default null
333 ,p_add_ins_memship_number in varchar2 default null
334 ,p_add_ins_status in varchar2 default null
335 ,p_add_ins_start_date in date default null
336 ,p_add_ins_end_date in date default null
337 ,p_add_ins_end_reason in number default null
338 ,p_attribute_category varchar2 default hr_api.g_varchar2
339 ,p_attribute1 varchar2 default hr_api.g_varchar2
340 ,p_attribute2 varchar2 default hr_api.g_varchar2
341 ,p_attribute3 varchar2 default hr_api.g_varchar2
342 ,p_attribute4 varchar2 default hr_api.g_varchar2
343 ,p_attribute5 varchar2 default hr_api.g_varchar2
344 ,p_attribute6 varchar2 default hr_api.g_varchar2
345 ,p_attribute7 varchar2 default hr_api.g_varchar2
346 ,p_attribute8 varchar2 default hr_api.g_varchar2
347 ,p_attribute9 varchar2 default hr_api.g_varchar2
348 ,p_attribute10 varchar2 default hr_api.g_varchar2
349 ,p_attribute11 varchar2 default hr_api.g_varchar2
350 ,p_attribute12 varchar2 default hr_api.g_varchar2
351 ,p_attribute13 varchar2 default hr_api.g_varchar2
352 ,p_attribute14 varchar2 default hr_api.g_varchar2
353 ,p_attribute15 varchar2 default hr_api.g_varchar2
354 ,p_attribute16 varchar2 default hr_api.g_varchar2
355 ,p_attribute17 varchar2 default hr_api.g_varchar2
356 ,p_attribute18 varchar2 default hr_api.g_varchar2
357 ,p_attribute19 varchar2 default hr_api.g_varchar2
358 ,p_attribute20 varchar2 default hr_api.g_varchar2
359 ,p_job_key_code in varchar2 --fix for Bug 13343138
360 ,p_effective_start_date out nocopy date
361 ,p_effective_end_date out nocopy date
362 ,p_element_entry_id out nocopy number
363 ,p_object_version_number out nocopy number
364 ,p_create_warning out nocopy boolean );
365
366 -- fix for Bug 13343138
367 function DECODE_LOOKUP ( p_lookup_type varchar2,
368 p_lookup_code varchar2)
369 return varchar2;
370 -- fix for Bug 13343138 ends
371
372 END PER_DE_ELE_API;