1 package pay_us_emp_dt_tax_rules as
2 /* $Header: pyusdtw4.pkh 120.5.12010000.1 2008/07/27 23:49:47 appldev ship $ */
3
4 procedure maintain_element_entry (p_assignment_id in number,
5 p_effective_start_date in date,
6 p_effective_end_date in date,
7 p_session_date in date,
8 p_jurisdiction_code in varchar2,
9 p_percentage_time in number,
10 p_mode in varchar2);
11
12 procedure maintain_wc_ele_entry (p_assignment_id in number,
13 p_effective_start_date in date,
14 p_effective_end_date in date,
15 p_session_date in date,
16 p_jurisdiction_code in varchar2,
17 p_mode in varchar2);
18
19 procedure create_tax_percentage (p_assignment_id in number,
20 p_state_code in varchar2,
21 p_county_code in varchar2,
22 p_city_code in varchar2,
23 p_time_in_state in number,
24 p_time_in_county in number,
25 p_time_in_city in number);
26
27
28 procedure insert_fed_tax_row ( p_emp_fed_tax_rule_id in out nocopy number,
29 p_effective_start_date in date,
30 p_effective_end_date in date,
31 p_assignment_id in number,
32 p_sui_state_code in varchar2,
33 p_sui_jurisdiction_code in varchar2,
34 p_business_group_id in number,
35 p_additional_wa_amount in number,
36 p_filing_status_code in varchar2,
37 p_fit_override_amount in number,
38 p_fit_override_rate in number,
39 p_withholding_allowances in number,
40 p_cumulative_taxation in varchar2,
41 p_eic_filing_status_code in varchar2,
42 p_fit_additional_tax in number,
43 p_fit_exempt in varchar2,
44 p_futa_tax_exempt in varchar2,
45 p_medicare_tax_exempt in varchar2,
46 p_ss_tax_exempt in varchar2,
47 p_wage_exempt in varchar2,
48 p_statutory_employee in varchar2,
49 p_w2_filed_year in number,
50 p_supp_tax_override_rate in number,
51 p_excessive_wa_reject_date in date,
52 p_attribute_category in varchar2,
53 p_attribute1 in varchar2,
54 p_attribute2 in varchar2,
55 p_attribute3 in varchar2,
56 p_attribute4 in varchar2,
57 p_attribute5 in varchar2,
58 p_attribute6 in varchar2,
59 p_attribute7 in varchar2,
60 p_attribute8 in varchar2,
61 p_attribute9 in varchar2,
62 p_attribute10 in varchar2,
63 p_attribute11 in varchar2,
64 p_attribute12 in varchar2,
65 p_attribute13 in varchar2,
66 p_attribute14 in varchar2,
67 p_attribute15 in varchar2,
68 p_attribute16 in varchar2,
69 p_attribute17 in varchar2,
70 p_attribute18 in varchar2,
71 p_attribute19 in varchar2,
72 p_attribute20 in varchar2,
73 p_attribute21 in varchar2,
74 p_attribute22 in varchar2,
75 p_attribute23 in varchar2,
76 p_attribute24 in varchar2,
77 p_attribute25 in varchar2,
78 p_attribute26 in varchar2,
79 p_attribute27 in varchar2,
80 p_attribute28 in varchar2,
81 p_attribute29 in varchar2,
82 p_attribute30 in varchar2,
83 p_fed_information_category in varchar2,
84 p_fed_information1 in varchar2,
85 p_fed_information2 in varchar2,
86 p_fed_information3 in varchar2,
87 p_fed_information4 in varchar2,
88 p_fed_information5 in varchar2,
89 p_fed_information6 in varchar2,
90 p_fed_information7 in varchar2,
91 p_fed_information8 in varchar2,
92 p_fed_information9 in varchar2,
93 p_fed_information10 in varchar2,
94 p_fed_information11 in varchar2,
95 p_fed_information12 in varchar2,
96 p_fed_information13 in varchar2,
97 p_fed_information14 in varchar2,
98 p_fed_information15 in varchar2,
99 p_fed_information16 in varchar2,
100 p_fed_information17 in varchar2,
101 p_fed_information18 in varchar2,
102 p_fed_information19 in varchar2,
103 p_fed_information20 in varchar2,
104 p_fed_information21 in varchar2,
105 p_fed_information22 in varchar2,
106 p_fed_information23 in varchar2,
107 p_fed_information24 in varchar2,
108 p_fed_information25 in varchar2,
109 p_fed_information26 in varchar2,
110 p_fed_information27 in varchar2,
111 p_fed_information28 in varchar2,
112 p_fed_information29 in varchar2,
113 p_fed_information30 in varchar2,
114 p_mode in varchar2);
115
116 procedure insert_state_tax_row ( p_row_id in out nocopy varchar2,
117 p_emp_state_tax_rule_id in out nocopy number,
118 p_effective_start_date in date,
119 p_effective_end_date in date,
120 p_assignment_id in number,
121 p_state_code in varchar2,
122 p_jurisdiction_code in varchar2,
123 p_business_group_id in number,
124 p_additional_wa_amount in number,
125 p_filing_status_code in varchar2,
126 p_remainder_percent in number,
127 p_secondary_wa in number,
128 p_sit_additional_tax in number,
129 p_sit_override_amount in number,
130 p_sit_override_rate in number,
131 p_withholding_allowances in number,
132 p_excessive_wa_reject_date in date,
133 p_sdi_exempt in varchar2,
134 p_sit_exempt in varchar2,
135 p_sit_optional_calc_ind in varchar2,
136 p_state_non_resident_cert in varchar2,
137 p_sui_exempt in varchar2,
138 p_wc_exempt in varchar2,
139 p_wage_exempt in varchar2,
140 p_sui_wage_base_override_amt in number,
141 p_supp_tax_override_rate in number,
142 p_time_in_state in number,
143 p_attribute_category in varchar2,
144 p_attribute1 in varchar2,
145 p_attribute2 in varchar2,
146 p_attribute3 in varchar2,
147 p_attribute4 in varchar2,
148 p_attribute5 in varchar2,
149 p_attribute6 in varchar2,
150 p_attribute7 in varchar2,
151 p_attribute8 in varchar2,
152 p_attribute9 in varchar2,
153 p_attribute10 in varchar2,
154 p_attribute11 in varchar2,
155 p_attribute12 in varchar2,
156 p_attribute13 in varchar2,
157 p_attribute14 in varchar2,
158 p_attribute15 in varchar2,
159 p_attribute16 in varchar2,
160 p_attribute17 in varchar2,
161 p_attribute18 in varchar2,
162 p_attribute19 in varchar2,
163 p_attribute20 in varchar2,
164 p_attribute21 in varchar2,
165 p_attribute22 in varchar2,
166 p_attribute23 in varchar2,
167 p_attribute24 in varchar2,
168 p_attribute25 in varchar2,
169 p_attribute26 in varchar2,
170 p_attribute27 in varchar2,
171 p_attribute28 in varchar2,
172 p_attribute29 in varchar2,
173 p_attribute30 in varchar2,
174 p_sta_information_category in varchar2,
175 p_sta_information1 in varchar2,
176 p_sta_information2 in varchar2,
177 p_sta_information3 in varchar2,
178 p_sta_information4 in varchar2,
179 p_sta_information5 in varchar2,
180 p_sta_information6 in varchar2,
181 p_sta_information7 in varchar2,
182 p_sta_information8 in varchar2,
183 p_sta_information9 in varchar2,
184 p_sta_information10 in varchar2,
185 p_sta_information11 in varchar2,
186 p_sta_information12 in varchar2,
187 p_sta_information13 in varchar2,
188 p_sta_information14 in varchar2,
189 p_sta_information15 in varchar2,
190 p_sta_information16 in varchar2,
191 p_sta_information17 in varchar2,
192 p_sta_information18 in varchar2,
193 p_sta_information19 in varchar2,
194 p_sta_information20 in varchar2,
195 p_sta_information21 in varchar2,
196 p_sta_information22 in varchar2,
197 p_sta_information23 in varchar2,
198 p_sta_information24 in varchar2,
199 p_sta_information25 in varchar2,
200 p_sta_information26 in varchar2,
201 p_sta_information27 in varchar2,
202 p_sta_information28 in varchar2,
203 p_sta_information29 in varchar2,
204 p_sta_information30 in varchar2);
205
206 procedure insert_county_tax_row ( p_row_id in out nocopy varchar2,
207 p_emp_county_tax_rule_id in out nocopy number,
208 p_effective_start_date in date,
209 p_effective_end_date in date,
210 p_assignment_id in number,
211 p_state_code in varchar2,
212 p_county_code in varchar2,
213 p_business_group_id in number,
214 p_additional_wa_rate in number,
215 p_filing_status_code in varchar2,
216 p_jurisdiction_code in varchar2,
217 p_lit_additional_tax in number,
218 p_lit_override_amount in number,
219 p_lit_override_rate in number,
220 p_withholding_allowances in number,
221 p_lit_exempt in varchar2,
222 p_sd_exempt in varchar2,
223 p_ht_exempt in varchar2,
224 p_wage_exempt in varchar2,
225 p_school_district_code in varchar2,
226 p_time_in_county in number,
227 p_attribute_category in varchar2,
228 p_attribute1 in varchar2,
229 p_attribute2 in varchar2,
230 p_attribute3 in varchar2,
231 p_attribute4 in varchar2,
232 p_attribute5 in varchar2,
233 p_attribute6 in varchar2,
234 p_attribute7 in varchar2,
235 p_attribute8 in varchar2,
236 p_attribute9 in varchar2,
237 p_attribute10 in varchar2,
238 p_attribute11 in varchar2,
239 p_attribute12 in varchar2,
240 p_attribute13 in varchar2,
241 p_attribute14 in varchar2,
242 p_attribute15 in varchar2,
243 p_attribute16 in varchar2,
244 p_attribute17 in varchar2,
248 p_attribute21 in varchar2,
245 p_attribute18 in varchar2,
246 p_attribute19 in varchar2,
247 p_attribute20 in varchar2,
249 p_attribute22 in varchar2,
250 p_attribute23 in varchar2,
251 p_attribute24 in varchar2,
252 p_attribute25 in varchar2,
253 p_attribute26 in varchar2,
254 p_attribute27 in varchar2,
255 p_attribute28 in varchar2,
256 p_attribute29 in varchar2,
257 p_attribute30 in varchar2,
258 p_cnt_information_category in varchar2,
259 p_cnt_information1 in varchar2,
260 p_cnt_information2 in varchar2,
261 p_cnt_information3 in varchar2,
262 p_cnt_information4 in varchar2,
263 p_cnt_information5 in varchar2,
264 p_cnt_information6 in varchar2,
265 p_cnt_information7 in varchar2,
266 p_cnt_information8 in varchar2,
267 p_cnt_information9 in varchar2,
268 p_cnt_information10 in varchar2,
269 p_cnt_information11 in varchar2,
270 p_cnt_information12 in varchar2,
271 p_cnt_information13 in varchar2,
272 p_cnt_information14 in varchar2,
273 p_cnt_information15 in varchar2,
274 p_cnt_information16 in varchar2,
275 p_cnt_information17 in varchar2,
276 p_cnt_information18 in varchar2,
277 p_cnt_information19 in varchar2,
278 p_cnt_information20 in varchar2,
279 p_cnt_information21 in varchar2,
280 p_cnt_information22 in varchar2,
281 p_cnt_information23 in varchar2,
282 p_cnt_information24 in varchar2,
283 p_cnt_information25 in varchar2,
284 p_cnt_information26 in varchar2,
285 p_cnt_information27 in varchar2,
286 p_cnt_information28 in varchar2,
287 p_cnt_information29 in varchar2,
288 p_cnt_information30 in varchar2);
289
290 procedure insert_city_tax_row ( p_row_id in out nocopy varchar2,
291 p_emp_city_tax_rule_id in out nocopy number,
292 p_effective_start_date in date,
293 p_effective_end_date in date,
294 p_assignment_id in number,
295 p_state_code in varchar2,
296 p_county_code in varchar2,
297 p_city_code in varchar2,
298 p_business_group_id in number,
299 p_additional_wa_rate in number,
300 p_filing_status_code in varchar2,
301 p_jurisdiction_code in varchar2,
302 p_lit_additional_tax in number,
303 p_lit_override_amount in number,
304 p_lit_override_rate in number,
305 p_withholding_allowances in number,
306 p_lit_exempt in varchar2,
307 p_sd_exempt in varchar2,
308 p_ht_exempt in varchar2,
309 p_wage_exempt in varchar2,
310 p_school_district_code in varchar2,
311 p_time_in_city in number,
312 p_attribute_category in varchar2,
313 p_attribute1 in varchar2,
314 p_attribute2 in varchar2,
315 p_attribute3 in varchar2,
316 p_attribute4 in varchar2,
317 p_attribute5 in varchar2,
318 p_attribute6 in varchar2,
319 p_attribute7 in varchar2,
320 p_attribute8 in varchar2,
321 p_attribute9 in varchar2,
322 p_attribute10 in varchar2,
323 p_attribute11 in varchar2,
327 p_attribute15 in varchar2,
324 p_attribute12 in varchar2,
325 p_attribute13 in varchar2,
326 p_attribute14 in varchar2,
328 p_attribute16 in varchar2,
329 p_attribute17 in varchar2,
330 p_attribute18 in varchar2,
331 p_attribute19 in varchar2,
332 p_attribute20 in varchar2,
333 p_attribute21 in varchar2,
334 p_attribute22 in varchar2,
335 p_attribute23 in varchar2,
336 p_attribute24 in varchar2,
337 p_attribute25 in varchar2,
338 p_attribute26 in varchar2,
339 p_attribute27 in varchar2,
340 p_attribute28 in varchar2,
341 p_attribute29 in varchar2,
342 p_attribute30 in varchar2,
343 p_cty_information_category in varchar2,
344 p_cty_information1 in varchar2,
345 p_cty_information2 in varchar2,
346 p_cty_information3 in varchar2,
347 p_cty_information4 in varchar2,
348 p_cty_information5 in varchar2,
349 p_cty_information6 in varchar2,
350 p_cty_information7 in varchar2,
351 p_cty_information8 in varchar2,
352 p_cty_information9 in varchar2,
353 p_cty_information10 in varchar2,
354 p_cty_information11 in varchar2,
355 p_cty_information12 in varchar2,
356 p_cty_information13 in varchar2,
357 p_cty_information14 in varchar2,
358 p_cty_information15 in varchar2,
359 p_cty_information16 in varchar2,
360 p_cty_information17 in varchar2,
361 p_cty_information18 in varchar2,
362 p_cty_information19 in varchar2,
363 p_cty_information20 in varchar2,
364 p_cty_information21 in varchar2,
365 p_cty_information22 in varchar2,
366 p_cty_information23 in varchar2,
367 p_cty_information24 in varchar2,
368 p_cty_information25 in varchar2,
369 p_cty_information26 in varchar2,
370 p_cty_information27 in varchar2,
371 p_cty_information28 in varchar2,
372 p_cty_information29 in varchar2,
373 p_cty_information30 in varchar2);
374
375 procedure update_fed_tax_row ( p_row_id in varchar2,
376 p_emp_fed_tax_rule_id in number,
377 p_effective_start_date in date,
378 p_effective_end_date in date,
379 p_assignment_id in number,
380 p_sui_state_code in varchar2,
381 p_sui_jurisdiction_code in varchar2,
382 p_business_group_id in number,
383 p_additional_wa_amount in number,
384 p_filing_status_code in varchar2,
385 p_fit_override_amount in number,
386 p_fit_override_rate in number,
387 p_withholding_allowances in number,
388 p_cumulative_taxation in varchar2,
389 p_eic_filing_status_code in varchar2,
390 p_fit_additional_tax in number,
391 p_fit_exempt in varchar2,
392 p_futa_tax_exempt in varchar2,
393 p_medicare_tax_exempt in varchar2,
394 p_ss_tax_exempt in varchar2,
395 p_wage_exempt in varchar2,
396 p_statutory_employee in varchar2,
397 p_w2_filed_year in number,
398 p_supp_tax_override_rate in number,
399 p_excessive_wa_reject_date in date,
400 p_session_date in date,
401 p_attribute_category in varchar2,
405 p_attribute4 in varchar2,
402 p_attribute1 in varchar2,
403 p_attribute2 in varchar2,
404 p_attribute3 in varchar2,
406 p_attribute5 in varchar2,
407 p_attribute6 in varchar2,
408 p_attribute7 in varchar2,
409 p_attribute8 in varchar2,
410 p_attribute9 in varchar2,
411 p_attribute10 in varchar2,
412 p_attribute11 in varchar2,
413 p_attribute12 in varchar2,
414 p_attribute13 in varchar2,
415 p_attribute14 in varchar2,
416 p_attribute15 in varchar2,
417 p_attribute16 in varchar2,
418 p_attribute17 in varchar2,
419 p_attribute18 in varchar2,
420 p_attribute19 in varchar2,
421 p_attribute20 in varchar2,
422 p_attribute21 in varchar2,
423 p_attribute22 in varchar2,
424 p_attribute23 in varchar2,
425 p_attribute24 in varchar2,
426 p_attribute25 in varchar2,
427 p_attribute26 in varchar2,
428 p_attribute27 in varchar2,
429 p_attribute28 in varchar2,
430 p_attribute29 in varchar2,
431 p_attribute30 in varchar2,
432 p_fed_information_category in varchar2,
433 p_fed_information1 in varchar2,
434 p_fed_information2 in varchar2,
435 p_fed_information3 in varchar2,
436 p_fed_information4 in varchar2,
437 p_fed_information5 in varchar2,
438 p_fed_information6 in varchar2,
439 p_fed_information7 in varchar2,
440 p_fed_information8 in varchar2,
441 p_fed_information9 in varchar2,
442 p_fed_information10 in varchar2,
443 p_fed_information11 in varchar2,
444 p_fed_information12 in varchar2,
445 p_fed_information13 in varchar2,
446 p_fed_information14 in varchar2,
447 p_fed_information15 in varchar2,
448 p_fed_information16 in varchar2,
449 p_fed_information17 in varchar2,
450 p_fed_information18 in varchar2,
451 p_fed_information19 in varchar2,
452 p_fed_information20 in varchar2,
453 p_fed_information21 in varchar2,
454 p_fed_information22 in varchar2,
455 p_fed_information23 in varchar2,
459 p_fed_information27 in varchar2,
456 p_fed_information24 in varchar2,
457 p_fed_information25 in varchar2,
458 p_fed_information26 in varchar2,
460 p_fed_information28 in varchar2,
461 p_fed_information29 in varchar2,
462 p_fed_information30 in varchar2,
463 p_mode in varchar2);
464
465 procedure update_state_tax_row ( p_row_id in varchar2,
466 p_emp_state_tax_rule_id in number,
467 p_effective_start_date in date,
468 p_effective_end_date in date,
469 p_assignment_id in number,
470 p_state_code in varchar2,
471 p_jurisdiction_code in varchar2,
472 p_business_group_id in number,
473 p_additional_wa_amount in number,
474 p_filing_status_code in varchar2,
475 p_remainder_percent in number,
476 p_secondary_wa in number,
477 p_sit_additional_tax in number,
478 p_sit_override_amount in number,
479 p_sit_override_rate in number,
480 p_withholding_allowances in number,
481 p_excessive_wa_reject_date in date,
482 p_sdi_exempt in varchar2,
483 p_sit_exempt in varchar2,
484 p_sit_optional_calc_ind in varchar2,
485 p_state_non_resident_cert in varchar2,
486 p_sui_exempt in varchar2,
487 p_wc_exempt in varchar2,
488 p_wage_exempt in varchar2,
489 p_sui_wage_base_override_amt in number,
490 p_supp_tax_override_rate in number,
491 p_attribute_category in varchar2,
492 p_attribute1 in varchar2,
493 p_attribute2 in varchar2,
494 p_attribute3 in varchar2,
495 p_attribute4 in varchar2,
496 p_attribute5 in varchar2,
497 p_attribute6 in varchar2,
498 p_attribute7 in varchar2,
499 p_attribute8 in varchar2,
500 p_attribute9 in varchar2,
501 p_attribute10 in varchar2,
502 p_attribute11 in varchar2,
503 p_attribute12 in varchar2,
504 p_attribute13 in varchar2,
505 p_attribute14 in varchar2,
506 p_attribute15 in varchar2,
507 p_attribute16 in varchar2,
508 p_attribute17 in varchar2,
509 p_attribute18 in varchar2,
510 p_attribute19 in varchar2,
511 p_attribute20 in varchar2,
512 p_attribute21 in varchar2,
513 p_attribute22 in varchar2,
517 p_attribute26 in varchar2,
514 p_attribute23 in varchar2,
515 p_attribute24 in varchar2,
516 p_attribute25 in varchar2,
518 p_attribute27 in varchar2,
519 p_attribute28 in varchar2,
520 p_attribute29 in varchar2,
521 p_attribute30 in varchar2,
522 p_sta_information_category in varchar2,
523 p_sta_information1 in varchar2,
524 p_sta_information2 in varchar2,
525 p_sta_information3 in varchar2,
526 p_sta_information4 in varchar2,
527 p_sta_information5 in varchar2,
528 p_sta_information6 in varchar2,
529 p_sta_information7 in varchar2,
530 p_sta_information8 in varchar2,
531 p_sta_information9 in varchar2,
532 p_sta_information10 in varchar2,
533 p_sta_information11 in varchar2,
534 p_sta_information12 in varchar2,
535 p_sta_information13 in varchar2,
536 p_sta_information14 in varchar2,
537 p_sta_information15 in varchar2,
538 p_sta_information16 in varchar2,
539 p_sta_information17 in varchar2,
540 p_sta_information18 in varchar2,
541 p_sta_information19 in varchar2,
542 p_sta_information20 in varchar2,
543 p_sta_information21 in varchar2,
544 p_sta_information22 in varchar2,
545 p_sta_information23 in varchar2,
546 p_sta_information24 in varchar2,
547 p_sta_information25 in varchar2,
548 p_sta_information26 in varchar2,
549 p_sta_information27 in varchar2,
550 p_sta_information28 in varchar2,
551 p_sta_information29 in varchar2,
552 p_sta_information30 in varchar2
553 );
554
555 procedure update_county_tax_row ( p_row_id in varchar2,
556 p_emp_county_tax_rule_id in number,
557 p_effective_start_date in date,
558 p_effective_end_date in date,
559 p_assignment_id in number,
560 p_state_code in varchar2,
561 p_county_code in varchar2,
562 p_business_group_id in number,
563 p_additional_wa_rate in number,
564 p_filing_status_code in varchar2,
565 p_jurisdiction_code in varchar2,
566 p_lit_additional_tax in number,
567 p_lit_override_amount in number,
568 p_lit_override_rate in number,
569 p_withholding_allowances in number,
570 p_lit_exempt in varchar2,
571 p_sd_exempt in varchar2,
572 p_ht_exempt in varchar2,
573 p_wage_exempt in varchar2,
574 p_school_district_code in varchar2, p_attribute_category in varchar2,
575 p_attribute1 in varchar2,
576 p_attribute2 in varchar2,
577 p_attribute3 in varchar2,
578 p_attribute4 in varchar2,
579 p_attribute5 in varchar2,
580 p_attribute6 in varchar2,
581 p_attribute7 in varchar2,
582 p_attribute8 in varchar2,
583 p_attribute9 in varchar2,
584 p_attribute10 in varchar2,
585 p_attribute11 in varchar2,
586 p_attribute12 in varchar2,
587 p_attribute13 in varchar2,
588 p_attribute14 in varchar2,
589 p_attribute15 in varchar2,
590 p_attribute16 in varchar2,
591 p_attribute17 in varchar2,
595 p_attribute21 in varchar2,
592 p_attribute18 in varchar2,
593 p_attribute19 in varchar2,
594 p_attribute20 in varchar2,
596 p_attribute22 in varchar2,
597 p_attribute23 in varchar2,
598 p_attribute24 in varchar2,
599 p_attribute25 in varchar2,
600 p_attribute26 in varchar2,
601 p_attribute27 in varchar2,
602 p_attribute28 in varchar2,
603 p_attribute29 in varchar2,
604 p_attribute30 in varchar2,
605 p_cnt_information_category in varchar2,
606 p_cnt_information1 in varchar2,
607 p_cnt_information2 in varchar2,
608 p_cnt_information3 in varchar2,
609 p_cnt_information4 in varchar2,
610 p_cnt_information5 in varchar2,
611 p_cnt_information6 in varchar2,
612 p_cnt_information7 in varchar2,
613 p_cnt_information8 in varchar2,
614 p_cnt_information9 in varchar2,
615 p_cnt_information10 in varchar2,
616 p_cnt_information11 in varchar2,
617 p_cnt_information12 in varchar2,
618 p_cnt_information13 in varchar2,
619 p_cnt_information14 in varchar2,
620 p_cnt_information15 in varchar2,
621 p_cnt_information16 in varchar2,
622 p_cnt_information17 in varchar2,
623 p_cnt_information18 in varchar2,
624 p_cnt_information19 in varchar2,
625 p_cnt_information20 in varchar2,
626 p_cnt_information21 in varchar2,
627 p_cnt_information22 in varchar2,
628 p_cnt_information23 in varchar2,
629 p_cnt_information24 in varchar2,
630 p_cnt_information25 in varchar2,
631 p_cnt_information26 in varchar2,
632 p_cnt_information27 in varchar2,
633 p_cnt_information28 in varchar2,
634 p_cnt_information29 in varchar2,
635 p_cnt_information30 in varchar2);
636
637
638 procedure update_city_tax_row ( p_row_id in varchar2,
639 p_emp_city_tax_rule_id in number,
640 p_effective_start_date in date,
641 p_effective_end_date in date,
642 p_assignment_id in number,
643 p_state_code in varchar2,
644 p_county_code in varchar2,
645 p_city_code in varchar2,
646 p_business_group_id in number,
647 p_additional_wa_rate in number,
648 p_filing_status_code in varchar2,
649 p_jurisdiction_code in varchar2,
650 p_lit_additional_tax in number,
651 p_lit_override_amount in number,
652 p_lit_override_rate in number,
653 p_withholding_allowances in number,
654 p_lit_exempt in varchar2,
655 p_sd_exempt in varchar2,
656 p_ht_exempt in varchar2,
657 p_wage_exempt in varchar2,
658 p_school_district_code in varchar2,
659 p_attribute_category in varchar2,
660 p_attribute1 in varchar2,
661 p_attribute2 in varchar2,
662 p_attribute3 in varchar2,
663 p_attribute4 in varchar2,
664 p_attribute5 in varchar2,
665 p_attribute6 in varchar2,
666 p_attribute7 in varchar2,
667 p_attribute8 in varchar2,
668 p_attribute9 in varchar2,
669 p_attribute10 in varchar2,
670 p_attribute11 in varchar2,
671 p_attribute12 in varchar2,
675 p_attribute16 in varchar2,
672 p_attribute13 in varchar2,
673 p_attribute14 in varchar2,
674 p_attribute15 in varchar2,
676 p_attribute17 in varchar2,
677 p_attribute18 in varchar2,
678 p_attribute19 in varchar2,
679 p_attribute20 in varchar2,
680 p_attribute21 in varchar2,
681 p_attribute22 in varchar2,
682 p_attribute23 in varchar2,
683 p_attribute24 in varchar2,
684 p_attribute25 in varchar2,
685 p_attribute26 in varchar2,
686 p_attribute27 in varchar2,
687 p_attribute28 in varchar2,
688 p_attribute29 in varchar2,
689 p_attribute30 in varchar2,
690 p_cty_information_category in varchar2,
691 p_cty_information1 in varchar2,
692 p_cty_information2 in varchar2,
693 p_cty_information3 in varchar2,
694 p_cty_information4 in varchar2,
695 p_cty_information5 in varchar2,
696 p_cty_information6 in varchar2,
697 p_cty_information7 in varchar2,
698 p_cty_information8 in varchar2,
699 p_cty_information9 in varchar2,
700 p_cty_information10 in varchar2,
701 p_cty_information11 in varchar2,
702 p_cty_information12 in varchar2,
703 p_cty_information13 in varchar2,
704 p_cty_information14 in varchar2,
705 p_cty_information15 in varchar2,
706 p_cty_information16 in varchar2,
707 p_cty_information17 in varchar2,
708 p_cty_information18 in varchar2,
709 p_cty_information19 in varchar2,
710 p_cty_information20 in varchar2,
711 p_cty_information21 in varchar2,
712 p_cty_information22 in varchar2,
713 p_cty_information23 in varchar2,
714 p_cty_information24 in varchar2,
715 p_cty_information25 in varchar2,
716 p_cty_information26 in varchar2,
717 p_cty_information27 in varchar2,
718 p_cty_information28 in varchar2,
719 p_cty_information29 in varchar2,
720 p_cty_information30 in varchar2);
721
722
723 procedure delete_tax_row ( p_assignment_id in number,
724 p_state_code in varchar2,
725 p_county_code in varchar2,
726 p_city_code in varchar2);
727
728
729 procedure lock_fed_tax_row ( p_row_id in varchar2,
730 p_emp_fed_tax_rule_id in number,
731 p_effective_start_date in date,
732 p_effective_end_date in date,
733 p_assignment_id in number,
734 p_sui_state_code in varchar2,
735 p_sui_jurisdiction_code in varchar2,
736 p_business_group_id in number,
737 p_additional_wa_amount in number,
738 p_filing_status_code in varchar2,
739 p_fit_override_amount in number,
740 p_fit_override_rate in number,
741 p_withholding_allowances in number,
742 p_cumulative_taxation in varchar2,
743 p_eic_filing_status_code in varchar2,
744 p_fit_additional_tax in number,
745 p_fit_exempt in varchar2,
746 p_futa_tax_exempt in varchar2,
747 p_medicare_tax_exempt in varchar2,
748 p_ss_tax_exempt in varchar2,
749 p_wage_exempt in varchar2,
750 p_statutory_employee in varchar2,
751 p_w2_filed_year in number,
752 p_supp_tax_override_rate in number,
753 p_excessive_wa_reject_date in date,
757 p_attribute3 in varchar2,
754 p_attribute_category in varchar2,
755 p_attribute1 in varchar2,
756 p_attribute2 in varchar2,
758 p_attribute4 in varchar2,
759 p_attribute5 in varchar2,
760 p_attribute6 in varchar2,
761 p_attribute7 in varchar2,
762 p_attribute8 in varchar2,
763 p_attribute9 in varchar2,
764 p_attribute10 in varchar2,
765 p_attribute11 in varchar2,
766 p_attribute12 in varchar2,
767 p_attribute13 in varchar2,
768 p_attribute14 in varchar2,
769 p_attribute15 in varchar2,
770 p_attribute16 in varchar2,
771 p_attribute17 in varchar2,
772 p_attribute18 in varchar2,
773 p_attribute19 in varchar2,
774 p_attribute20 in varchar2,
775 p_attribute21 in varchar2,
776 p_attribute22 in varchar2,
777 p_attribute23 in varchar2,
778 p_attribute24 in varchar2,
779 p_attribute25 in varchar2,
780 p_attribute26 in varchar2,
781 p_attribute27 in varchar2,
782 p_attribute28 in varchar2,
783 p_attribute29 in varchar2,
784 p_attribute30 in varchar2,
785 p_fed_information_category in varchar2,
786 p_fed_information1 in varchar2,
787 p_fed_information2 in varchar2,
788 p_fed_information3 in varchar2,
789 p_fed_information4 in varchar2,
790 p_fed_information5 in varchar2,
791 p_fed_information6 in varchar2,
792 p_fed_information7 in varchar2,
793 p_fed_information8 in varchar2,
794 p_fed_information9 in varchar2,
795 p_fed_information10 in varchar2,
796 p_fed_information11 in varchar2,
797 p_fed_information12 in varchar2,
798 p_fed_information13 in varchar2,
799 p_fed_information14 in varchar2,
800 p_fed_information15 in varchar2,
801 p_fed_information16 in varchar2,
802 p_fed_information17 in varchar2,
803 p_fed_information18 in varchar2,
804 p_fed_information19 in varchar2,
805 p_fed_information20 in varchar2,
806 p_fed_information21 in varchar2,
807 p_fed_information22 in varchar2,
808 p_fed_information23 in varchar2,
809 p_fed_information24 in varchar2,
810 p_fed_information25 in varchar2,
811 p_fed_information26 in varchar2,
812 p_fed_information27 in varchar2,
813 p_fed_information28 in varchar2,
814 p_fed_information29 in varchar2,
815 p_fed_information30 in varchar2 );
816
817
818 procedure lock_state_tax_row ( p_row_id in varchar2,
819 p_emp_state_tax_rule_id in number,
820 p_effective_start_date in date,
821 p_effective_end_date in date,
822 p_assignment_id in number,
823 p_state_code in varchar2,
824 p_jurisdiction_code in varchar2,
825 p_business_group_id in number,
826 p_additional_wa_amount in number,
827 p_filing_status_code in varchar2,
828 p_remainder_percent in number,
829 p_secondary_wa in number,
830 p_sit_additional_tax in number,
831 p_sit_override_amount in number,
832 p_sit_override_rate in number,
833 p_withholding_allowances in number,
837 p_sit_optional_calc_ind in varchar2,
834 p_excessive_wa_reject_date in date,
835 p_sdi_exempt in varchar2,
836 p_sit_exempt in varchar2,
838 p_state_non_resident_cert in varchar2,
839 p_sui_exempt in varchar2,
840 p_wc_exempt in varchar2,
841 p_wage_exempt in varchar2,
842 p_sui_wage_base_override_amt in number,
843 p_supp_tax_override_rate in number,
844 p_attribute_category in varchar2,
845 p_attribute1 in varchar2,
846 p_attribute2 in varchar2,
847 p_attribute3 in varchar2,
848 p_attribute4 in varchar2,
849 p_attribute5 in varchar2,
850 p_attribute6 in varchar2,
851 p_attribute7 in varchar2,
852 p_attribute8 in varchar2,
853 p_attribute9 in varchar2,
854 p_attribute10 in varchar2,
855 p_attribute11 in varchar2,
856 p_attribute12 in varchar2,
857 p_attribute13 in varchar2,
858 p_attribute14 in varchar2,
859 p_attribute15 in varchar2,
860 p_attribute16 in varchar2,
861 p_attribute17 in varchar2,
862 p_attribute18 in varchar2,
863 p_attribute19 in varchar2,
864 p_attribute20 in varchar2,
865 p_attribute21 in varchar2,
866 p_attribute22 in varchar2,
867 p_attribute23 in varchar2,
868 p_attribute24 in varchar2,
869 p_attribute25 in varchar2,
870 p_attribute26 in varchar2,
871 p_attribute27 in varchar2,
872 p_attribute28 in varchar2,
873 p_attribute29 in varchar2,
874 p_attribute30 in varchar2,
875 p_sta_information_category in varchar2,
876 p_sta_information1 in varchar2,
877 p_sta_information2 in varchar2,
878 p_sta_information3 in varchar2,
879 p_sta_information4 in varchar2,
880 p_sta_information5 in varchar2,
881 p_sta_information6 in varchar2,
882 p_sta_information7 in varchar2,
883 p_sta_information8 in varchar2,
884 p_sta_information9 in varchar2,
885 p_sta_information10 in varchar2,
886 p_sta_information11 in varchar2,
887 p_sta_information12 in varchar2,
888 p_sta_information13 in varchar2,
889 p_sta_information14 in varchar2,
890 p_sta_information15 in varchar2,
891 p_sta_information16 in varchar2,
892 p_sta_information17 in varchar2,
893 p_sta_information18 in varchar2,
894 p_sta_information19 in varchar2,
895 p_sta_information20 in varchar2,
896 p_sta_information21 in varchar2,
897 p_sta_information22 in varchar2,
898 p_sta_information23 in varchar2,
899 p_sta_information24 in varchar2,
900 p_sta_information25 in varchar2,
901 p_sta_information26 in varchar2,
902 p_sta_information27 in varchar2,
903 p_sta_information28 in varchar2,
904 p_sta_information29 in varchar2,
905 p_sta_information30 in varchar2 );
906
907
908 procedure lock_county_tax_row ( p_row_id in varchar2,
909 p_emp_county_tax_rule_id in number,
910 p_effective_start_date in date,
911 p_effective_end_date in date,
912 p_assignment_id in number,
913 p_state_code in varchar2,
917 p_filing_status_code in varchar2,
914 p_county_code in varchar2,
915 p_business_group_id in number,
916 p_additional_wa_rate in number,
918 p_jurisdiction_code in varchar2,
919 p_lit_additional_tax in number,
920 p_lit_override_amount in number,
921 p_lit_override_rate in number,
922 p_withholding_allowances in number,
923 p_lit_exempt in varchar2,
924 p_sd_exempt in varchar2,
925 p_ht_exempt in varchar2,
926 p_wage_exempt in varchar2,
927 p_school_district_code in varchar2,
928 p_attribute_category in varchar2,
929 p_attribute1 in varchar2,
930 p_attribute2 in varchar2,
931 p_attribute3 in varchar2,
932 p_attribute4 in varchar2,
933 p_attribute5 in varchar2,
934 p_attribute6 in varchar2,
935 p_attribute7 in varchar2,
936 p_attribute8 in varchar2,
937 p_attribute9 in varchar2,
938 p_attribute10 in varchar2,
939 p_attribute11 in varchar2,
940 p_attribute12 in varchar2,
941 p_attribute13 in varchar2,
942 p_attribute14 in varchar2,
943 p_attribute15 in varchar2,
944 p_attribute16 in varchar2,
945 p_attribute17 in varchar2,
946 p_attribute18 in varchar2,
947 p_attribute19 in varchar2,
948 p_attribute20 in varchar2,
949 p_attribute21 in varchar2,
950 p_attribute22 in varchar2,
951 p_attribute23 in varchar2,
952 p_attribute24 in varchar2,
953 p_attribute25 in varchar2,
954 p_attribute26 in varchar2,
955 p_attribute27 in varchar2,
956 p_attribute28 in varchar2,
957 p_attribute29 in varchar2,
958 p_attribute30 in varchar2,
959 p_cnt_information_category in varchar2,
960 p_cnt_information1 in varchar2,
961 p_cnt_information2 in varchar2,
962 p_cnt_information3 in varchar2,
963 p_cnt_information4 in varchar2,
964 p_cnt_information5 in varchar2,
965 p_cnt_information6 in varchar2,
966 p_cnt_information7 in varchar2,
967 p_cnt_information8 in varchar2,
968 p_cnt_information9 in varchar2,
969 p_cnt_information10 in varchar2,
970 p_cnt_information11 in varchar2,
971 p_cnt_information12 in varchar2,
972 p_cnt_information13 in varchar2,
973 p_cnt_information14 in varchar2,
974 p_cnt_information15 in varchar2,
975 p_cnt_information16 in varchar2,
976 p_cnt_information17 in varchar2,
977 p_cnt_information18 in varchar2,
978 p_cnt_information19 in varchar2,
979 p_cnt_information20 in varchar2,
980 p_cnt_information21 in varchar2,
981 p_cnt_information22 in varchar2,
982 p_cnt_information23 in varchar2,
983 p_cnt_information24 in varchar2,
984 p_cnt_information25 in varchar2,
985 p_cnt_information26 in varchar2,
986 p_cnt_information27 in varchar2,
987 p_cnt_information28 in varchar2,
988 p_cnt_information29 in varchar2,
989 p_cnt_information30 in varchar2 );
990
991 procedure lock_city_tax_row ( p_row_id in varchar2,
995 p_assignment_id in number,
992 p_emp_city_tax_rule_id in number,
993 p_effective_start_date in date,
994 p_effective_end_date in date,
996 p_state_code in varchar2,
997 p_county_code in varchar2,
998 p_city_code in varchar2,
999 p_business_group_id in number,
1000 p_additional_wa_rate in number,
1001 p_filing_status_code in varchar2,
1002 p_jurisdiction_code in varchar2,
1003 p_lit_additional_tax in number,
1004 p_lit_override_amount in number,
1005 p_lit_override_rate in number,
1006 p_withholding_allowances in number,
1007 p_lit_exempt in varchar2,
1008 p_sd_exempt in varchar2,
1009 p_ht_exempt in varchar2,
1010 p_wage_exempt in varchar2,
1011 p_school_district_code in varchar2,
1012 p_attribute_category in varchar2,
1013 p_attribute1 in varchar2,
1014 p_attribute2 in varchar2,
1015 p_attribute3 in varchar2,
1016 p_attribute4 in varchar2,
1017 p_attribute5 in varchar2,
1018 p_attribute6 in varchar2,
1019 p_attribute7 in varchar2,
1020 p_attribute8 in varchar2,
1021 p_attribute9 in varchar2,
1022 p_attribute10 in varchar2,
1023 p_attribute11 in varchar2,
1024 p_attribute12 in varchar2,
1025 p_attribute13 in varchar2,
1026 p_attribute14 in varchar2,
1027 p_attribute15 in varchar2,
1028 p_attribute16 in varchar2,
1029 p_attribute17 in varchar2,
1030 p_attribute18 in varchar2,
1031 p_attribute19 in varchar2,
1032 p_attribute20 in varchar2,
1033 p_attribute21 in varchar2,
1034 p_attribute22 in varchar2,
1035 p_attribute23 in varchar2,
1036 p_attribute24 in varchar2,
1037 p_attribute25 in varchar2,
1038 p_attribute26 in varchar2,
1039 p_attribute27 in varchar2,
1040 p_attribute28 in varchar2,
1041 p_attribute29 in varchar2,
1042 p_attribute30 in varchar2,
1043 p_cty_information_category in varchar2,
1044 p_cty_information1 in varchar2,
1045 p_cty_information2 in varchar2,
1046 p_cty_information3 in varchar2,
1047 p_cty_information4 in varchar2,
1048 p_cty_information5 in varchar2,
1049 p_cty_information6 in varchar2,
1050 p_cty_information7 in varchar2,
1051 p_cty_information8 in varchar2,
1052 p_cty_information9 in varchar2,
1053 p_cty_information10 in varchar2,
1054 p_cty_information11 in varchar2,
1055 p_cty_information12 in varchar2,
1056 p_cty_information13 in varchar2,
1057 p_cty_information14 in varchar2,
1058 p_cty_information15 in varchar2,
1059 p_cty_information16 in varchar2,
1060 p_cty_information17 in varchar2,
1061 p_cty_information18 in varchar2,
1062 p_cty_information19 in varchar2,
1063 p_cty_information20 in varchar2,
1064 p_cty_information21 in varchar2,
1065 p_cty_information22 in varchar2,
1066 p_cty_information23 in varchar2,
1067 p_cty_information24 in varchar2,
1068 p_cty_information25 in varchar2,
1069 p_cty_information26 in varchar2,
1070 p_cty_information27 in varchar2,
1074
1071 p_cty_information28 in varchar2,
1072 p_cty_information29 in varchar2,
1073 p_cty_information30 in varchar2 );
1075 function insert_def_fed_rec(p_assignment_id number,
1076 p_effective_start_date date,
1077 p_effective_end_date date,
1078 p_sui_state_code varchar2,
1079 p_business_group_id number) return number;
1080
1081 function insert_def_state_rec(p_assignment_id number,
1082 p_effective_start_date date,
1083 p_effective_end_date date,
1084 p_state_code varchar2,
1085 p_business_group_id number,
1086 p_percent_time number) return number;
1087
1088 function insert_def_county_rec(p_assignment_id number,
1089 p_effective_start_date date,
1090 p_effective_end_date date,
1091 p_state_code varchar2,
1092 p_county_code varchar2,
1093 p_business_group_id number,
1094 p_percent_time number) return number;
1095
1096
1097 function insert_def_city_rec(p_assignment_id number,
1098 p_effective_start_date date,
1099 p_effective_end_date date,
1100 p_state_code varchar2,
1101 p_county_code varchar2,
1102 p_city_code varchar2,
1103 p_business_group_id number,
1104 p_percent_time number) return number;
1105
1106 procedure zero_out_time(p_assignment_id in number,
1107 p_effective_start_date in date,
1108 p_effective_end_date in date);
1109
1110 procedure create_new_location_rec(p_assignment_id in number,
1111 p_validation_start_date in date,
1112 p_validation_end_date in date,
1113 p_session_date in date,
1114 p_new_location_id in number,
1115 p_res_state_code in varchar2,
1116 p_res_county_code in varchar2,
1117 p_res_city_code in varchar2,
1118 p_business_group in number,
1119 p_percent in number);
1120
1121 procedure del_updt_entries_for_dates (p_assignment_id in number,
1122 p_jurisdiction_code in varchar2,
1123 p_session_date in date,
1124 p_new_start_date in date,
1125 p_new_end_date in date,
1126 p_mode in varchar2);
1127
1128 procedure upd_del_entries(p_assignment_id in number,
1129 p_session_date in date,
1130 p_new_start_date in date,
1131 p_new_end_date in date,
1132 p_mode in varchar2);
1133
1134
1135 procedure del_updt_wc_entry_for_dates (p_assignment_id in number,
1136 p_session_date in date,
1137 p_new_start_date in date,
1138 p_new_end_date in date,
1139 p_mode in varchar2);
1140
1141 procedure change_entries(p_assignment_id in number,
1142 p_session_date in date,
1143 p_start_date in date,
1144 p_end_date in date,
1145 p_mode in varchar2);
1146
1147
1148 procedure pull_percentage (p_assignment_id in number,
1149 p_default_date in date,
1150 p_effective_start_date in date,
1151 p_effective_end_date in date,
1152 p_session_date in date,
1153 p_new_location_id in number,
1154 p_business_group_id in number);
1155
1156
1157 procedure correct_percentage (p_assignment_id in number,
1158 p_effective_start_date in date,
1159 p_effective_end_date in date,
1160 p_session_date in date,
1161 p_new_location_id in number,
1162 p_business_group_id in number,
1163 p_ret_code in out nocopy number,
1164 p_ret_text in out nocopy varchar2);
1165
1166 procedure update_percentage (p_assignment_id in number,
1170 p_new_location_id in number,
1167 p_effective_start_date in date,
1168 p_effective_end_date in date,
1169 p_session_date in date,
1171 p_business_group_id in number,
1172 p_mode in varchar2,
1173 p_ret_code in out nocopy number,
1174 p_ret_text in out nocopy varchar2);
1175
1176 procedure correct_wc_entry (p_assignment_id in number,
1177 p_effective_start_date in date,
1178 p_effective_end_date in date,
1179 p_session_date in date,
1180 p_new_location_id in number,
1181 p_ret_code in out nocopy number,
1182 p_ret_text in out nocopy varchar2);
1183
1184 procedure change_wc_entry (p_assignment_id in number,
1185 p_effective_start_date in date,
1186 p_effective_end_date in date,
1187 p_session_date in date,
1188 p_new_location_id in number,
1189 p_mode in varchar2,
1190 p_ret_code in out nocopy number,
1191 p_ret_text in out nocopy varchar2);
1192
1193 procedure pull_tax_records( p_assignment_id in number,
1194 p_new_start_date in date,
1195 p_default_date in date);
1196
1197 procedure default_tax ( p_assignment_id in number,
1198 p_effective_start_date in date,
1199 p_effective_end_date in date,
1200 p_business_group_id in number,
1201 p_ret_code in number,
1202 p_ret_text in varchar2);
1203
1204
1205 procedure default_tax_with_validation(p_assignment_id in number,
1206 p_person_id in number,
1207 p_effective_start_date in date,
1208 p_effective_end_date in date,
1209 p_session_date in date,
1210 p_business_group_id in number,
1211 p_from_form in varchar2,
1212 p_mode in varchar2,
1213 p_location_id in number,
1214 p_return_code in out nocopy number,
1215 p_return_text in out nocopy varchar2);
1216
1217 procedure set_sui_wage_base_override(p_assignment_id in number,
1218 p_state_code in varchar2 default null,
1219 p_session_date in date);
1220
1221 procedure check_nra_status(p_assignment_id in number,
1222 p_withholding_allowances in number,
1223 p_filing_status_code in varchar2,
1224 p_fit_exempt in varchar2,
1228
1225 p_effective_start_date in date,
1226 p_effective_end_date in date,
1227 p_returned_warning OUT NOCOPY VARCHAR2);
1229 end pay_us_emp_dt_tax_rules;
|
|
|