[Home] [Help]
PACKAGE BODY: APPS.PAY_US_FS_UPD_PKG
Source
1 PACKAGE BODY pay_us_fs_upd_pkg as
2 /* $Header: pyusfsup.pkb 120.0 2005/05/29 09:30 appldev noship $ */
3
4
5
6 PROCEDURE update_report_fs_rec (p_pest_state_code IN VARCHAR2,
7 p_pest_fs_code IN VARCHAR2,
8 p_pest_id IN NUMBER,
9 p_session_id IN NUMBER,
10 p_bug_number IN NUMBER,
11 p_new_fs_code IN VARCHAR2 )
12
13 IS
14
15 BEGIN
16
17 begin
18
19 insert into pay_us_rpt_totals
20 (attribute1, value1, value2, state_code, attribute2,
21 attribute3, attribute4, business_group_id, session_id,
22 tax_unit_id)
23 select ppf.full_name ,
24 paf.assignment_id ,
25 paf.person_id ,
26 taxrule.state_code ,
27 to_char(taxrule.effective_start_date, 'DD-MON-YYYY'),
28 to_char(taxrule.effective_end_date, 'DD-MON-YYYY'),
29 taxrule.filing_status_code ,
30 taxrule.business_group_id ,
31 p_session_id, p_bug_number
32 from pay_us_emp_state_tax_rules_f taxrule,
33 per_assignments_f paf,
34 per_all_people_f ppf
35 where taxrule.state_code = p_pest_state_code
36 and taxrule.filing_status_code = p_pest_fs_code
37 and emp_state_tax_rule_id = p_pest_id
38 and taxrule.assignment_id = paf.assignment_id
39 and taxrule.effective_start_date between
40 paf.effective_start_date
41 and paf.effective_end_date
42 and taxrule.business_group_id = paf.business_group_id
43 and paf.person_id = ppf.person_id
44 and taxrule.effective_start_date between
45 ppf.effective_start_date
46 and ppf.effective_end_date
47
48 -- order by paf.assignment_id
49 ;
50
51 exception
52 when no_data_found then
53 null;
54 end;
55
56
57 update pay_us_emp_state_tax_rules_f
58 set filing_status_code = p_new_fs_code
59 where state_code = p_pest_state_code
60 and filing_status_code = p_pest_fs_code
61 and emp_state_tax_rule_id = p_pest_id;
62
63 END update_report_fs_rec;
64
65 PROCEDURE update_filing_status(
66 p_tax_rule_id_start IN NUMBER,
67 p_tax_rule_id_end IN NUMBER )
68
69 IS
70 CURSOR filing_status_cur IS
71 select state_code, filing_status_code, emp_state_tax_rule_id
72 from pay_us_emp_state_tax_rules_f
73 where emp_state_tax_rule_id between
74 p_tax_rule_id_start and p_tax_rule_id_end ;
75
76 filing_status_rec filing_status_cur%ROWTYPE;
77
78 l_error_message_text varchar2(240);
79 l_session_id number ;
80 l_bug_no number;
81
82 BEGIN
83
84 l_bug_no := 2735805 ;
85
86 hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');
87
88 hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));
89 hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));
90
91 select userenv('sessionid')
92 into l_session_id
93 from dual;
94
95
96 OPEN filing_status_cur ;
97 LOOP
98 FETCH filing_status_cur into filing_status_rec;
99 EXIT WHEN filing_status_cur%NOTFOUND;
100
101 hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);
102
103
104 IF filing_status_rec.state_code = '03' and
105 filing_status_rec.filing_status_code in ( '04', '03', '02' )
106 THEN
107 hr_utility.set_location('Arizona',2);
108
109
110 update_report_fs_rec (
111 p_pest_state_code =>
112 filing_status_rec.state_code,
113 p_pest_fs_code =>
114 filing_status_rec.filing_status_code,
115 p_pest_id =>
116 filing_status_rec.emp_state_tax_rule_id,
117 p_session_id => l_session_id,
118 p_bug_number => l_bug_no,
119 p_new_fs_code => '01' ) ;
120 /* removed updates of Arkansas and Calif as they are not valid updates */
121
122 /* ELSIF filing_status_rec.state_code = '04' and
123 filing_status_rec.filing_status_code = '03'
124 THEN
125 hr_utility.set_location('Arkansas',3);
126
127 update_report_fs_rec (
128 p_pest_state_code =>
129 filing_status_rec.state_code,
130 p_pest_fs_code =>
131 filing_status_rec.filing_status_code,
132 p_pest_id =>
133 filing_status_rec.emp_state_tax_rule_id,
134 p_session_id => l_session_id,
135 p_bug_number => l_bug_no,
136 p_new_fs_code => '01' ) ;
137
138 ELSIF filing_status_rec.state_code = '05' and
139 filing_status_rec.filing_status_code = '03'
140 THEN
141 hr_utility.set_location('California',4);
142
143
144 update_report_fs_rec (
145 p_pest_state_code =>
146 filing_status_rec.state_code,
147 p_pest_fs_code =>
148 filing_status_rec.filing_status_code,
149 p_pest_id =>
150 filing_status_rec.emp_state_tax_rule_id,
151 p_session_id => l_session_id,
152 p_bug_number => l_bug_no,
153 p_new_fs_code => '01' ) ;
154 */
155
156 ELSIF filing_status_rec.state_code = '06' and
157 filing_status_rec.filing_status_code = '03'
158 THEN
159 hr_utility.set_location('Colorado ',5);
160
161 update_report_fs_rec (
162 p_pest_state_code =>
163 filing_status_rec.state_code,
164 p_pest_fs_code =>
165 filing_status_rec.filing_status_code,
166 p_pest_id =>
167 filing_status_rec.emp_state_tax_rule_id,
168 p_session_id => l_session_id,
169 p_bug_number => l_bug_no,
170 p_new_fs_code => '01' ) ;
171
172 /* No Conversion required for Connecticut
173
174 ELSIF filing_status_rec.state_code = '07' and
175 filing_status_rec.filing_status_code = '03'
176 THEN
177 hr_utility.set_location('Connecticut',6);
178
179 update_report_fs_rec (
180 p_pest_state_code =>
181 filing_status_rec.state_code,
182 p_pest_fs_code =>
183 filing_status_rec.filing_status_code,
184 p_pest_id =>
185 filing_status_rec.emp_state_tax_rule_id,
186 p_session_id => l_session_id,
187 p_bug_number => l_bug_no,
188 p_new_fs_code => '05' ) ;
189 */
190
191 ELSIF filing_status_rec.state_code = '08' and
192 filing_status_rec.filing_status_code = '03'
193 THEN
194 hr_utility.set_location('Delaware',7);
195
196 update_report_fs_rec (
197 p_pest_state_code =>
198 filing_status_rec.state_code,
199 p_pest_fs_code =>
200 filing_status_rec.filing_status_code,
201 p_pest_id =>
202 filing_status_rec.emp_state_tax_rule_id,
203 p_session_id => l_session_id,
204 p_bug_number => l_bug_no,
205 p_new_fs_code => '01' ) ;
206
207 ELSIF filing_status_rec.state_code = '11' and
208 filing_status_rec.filing_status_code = '04'
209 THEN
210 hr_utility.set_location('Georgia',8);
211
212 update_report_fs_rec (
213 p_pest_state_code =>
214 filing_status_rec.state_code,
215 p_pest_fs_code =>
216 filing_status_rec.filing_status_code,
217 p_pest_id =>
218 filing_status_rec.emp_state_tax_rule_id,
219 p_session_id => l_session_id,
220 p_bug_number => l_bug_no,
221 p_new_fs_code => '01' ) ;
222
223 ELSIF filing_status_rec.state_code = '12' and
224 filing_status_rec.filing_status_code = '03'
225 THEN
226 hr_utility.set_location('Hawaii',9);
227
228 update_report_fs_rec (
229 p_pest_state_code =>
230 filing_status_rec.state_code,
231 p_pest_fs_code =>
232 filing_status_rec.filing_status_code,
233 p_pest_id =>
234 filing_status_rec.emp_state_tax_rule_id,
235 p_session_id => l_session_id,
236 p_bug_number => l_bug_no,
237 p_new_fs_code => '01' ) ;
238
239 ELSIF filing_status_rec.state_code = '13' and
240 filing_status_rec.filing_status_code = '03'
241 THEN
242 hr_utility.set_location('Idaho',10);
243
244 update_report_fs_rec (
245 p_pest_state_code =>
246 filing_status_rec.state_code,
247 p_pest_fs_code =>
248 filing_status_rec.filing_status_code,
249 p_pest_id =>
250 filing_status_rec.emp_state_tax_rule_id,
251 p_session_id => l_session_id,
252 p_bug_number => l_bug_no,
253 p_new_fs_code => '01' ) ;
254
255 ELSIF filing_status_rec.state_code = '14' and
256 filing_status_rec.filing_status_code in ( '03', '02')
257 THEN
258 hr_utility.set_location('Illinois',11);
259
260 update_report_fs_rec (
261 p_pest_state_code =>
262 filing_status_rec.state_code,
263 p_pest_fs_code =>
264 filing_status_rec.filing_status_code,
265 p_pest_id =>
266 filing_status_rec.emp_state_tax_rule_id,
267 p_session_id => l_session_id,
268 p_bug_number => l_bug_no,
269 p_new_fs_code => '01' ) ;
270
271 ELSIF filing_status_rec.state_code = '15' and
272 filing_status_rec.filing_status_code in ( '03', '02')
273 THEN
274 hr_utility.set_location('Indiana',12);
275
276 update_report_fs_rec (
277 p_pest_state_code =>
278 filing_status_rec.state_code,
279 p_pest_fs_code =>
280 filing_status_rec.filing_status_code,
281 p_pest_id =>
282 filing_status_rec.emp_state_tax_rule_id,
283 p_session_id => l_session_id,
284 p_bug_number => l_bug_no,
285 p_new_fs_code => '01' ) ;
286
287 ELSIF filing_status_rec.state_code = '16' and
288 filing_status_rec.filing_status_code in ('03', '04')
289 THEN
290 hr_utility.set_location('Iowa',13);
291
292 update_report_fs_rec (
293 p_pest_state_code =>
294 filing_status_rec.state_code,
295 p_pest_fs_code =>
296 filing_status_rec.filing_status_code,
297 p_pest_id =>
298 filing_status_rec.emp_state_tax_rule_id,
299 p_session_id => l_session_id,
300 p_bug_number => l_bug_no,
301 p_new_fs_code => '01' ) ;
302
303 ELSIF filing_status_rec.state_code = '17' and
304 filing_status_rec.filing_status_code = '03'
305 THEN
306 hr_utility.set_location('Kansas',14);
307
308 update_report_fs_rec (
309 p_pest_state_code =>
310 filing_status_rec.state_code,
311 p_pest_fs_code =>
312 filing_status_rec.filing_status_code,
313 p_pest_id =>
314 filing_status_rec.emp_state_tax_rule_id,
315 p_session_id => l_session_id,
316 p_bug_number => l_bug_no,
317 p_new_fs_code => '01' ) ;
318
319 ELSIF filing_status_rec.state_code = '18' and
323
320 filing_status_rec.filing_status_code in ( '04', '03','02')
321 THEN
322 hr_utility.set_location('Kentucky',15);
324 update_report_fs_rec (
325 p_pest_state_code =>
326 filing_status_rec.state_code,
327 p_pest_fs_code =>
328 filing_status_rec.filing_status_code,
329 p_pest_id =>
330 filing_status_rec.emp_state_tax_rule_id,
331 p_session_id => l_session_id,
332 p_bug_number => l_bug_no,
333 p_new_fs_code => '01' ) ;
334
335 ELSIF filing_status_rec.state_code = '19' and
336 filing_status_rec.filing_status_code in ( '04', '03', '02' )
337 THEN
338 hr_utility.set_location('Louisiana',16);
339
340
341 update_report_fs_rec (
342 p_pest_state_code =>
343 filing_status_rec.state_code,
344 p_pest_fs_code =>
345 filing_status_rec.filing_status_code,
346 p_pest_id =>
347 filing_status_rec.emp_state_tax_rule_id,
348 p_session_id => l_session_id,
349 p_bug_number => l_bug_no,
350 p_new_fs_code => '01' ) ;
351
352 ELSIF filing_status_rec.state_code = '20' and
353 filing_status_rec.filing_status_code = '03'
354 THEN
355 hr_utility.set_location('Maine',17);
356
357 update_report_fs_rec (
358 p_pest_state_code =>
359 filing_status_rec.state_code,
360 p_pest_fs_code =>
361 filing_status_rec.filing_status_code,
362 p_pest_id =>
363 filing_status_rec.emp_state_tax_rule_id,
364 p_session_id => l_session_id,
365 p_bug_number => l_bug_no,
366 p_new_fs_code => '01' ) ;
367
368 ELSIF filing_status_rec.state_code = '21' and
369 filing_status_rec.filing_status_code in ( '03', '02')
370 THEN
371 hr_utility.set_location('Maryland',18);
372
373 update_report_fs_rec (
374 p_pest_state_code =>
375 filing_status_rec.state_code,
376 p_pest_fs_code =>
377 filing_status_rec.filing_status_code,
378 p_pest_id =>
379 filing_status_rec.emp_state_tax_rule_id,
380 p_session_id => l_session_id,
381 p_bug_number => l_bug_no,
382 p_new_fs_code => '01' ) ;
383
384 ELSIF filing_status_rec.state_code = '22' and
385 filing_status_rec.filing_status_code in ( '02', '04')
386 THEN
387 hr_utility.set_location('Massachusetts',19);
388
389 update_report_fs_rec (
390 p_pest_state_code =>
391 filing_status_rec.state_code,
392 p_pest_fs_code =>
393 filing_status_rec.filing_status_code,
394 p_pest_id =>
395 filing_status_rec.emp_state_tax_rule_id,
396 p_session_id => l_session_id,
397 p_bug_number => l_bug_no,
398 p_new_fs_code => '01' ) ;
399
400 ELSIF filing_status_rec.state_code = '23' and
401 filing_status_rec.filing_status_code in ( '03', '02')
402 THEN
403 hr_utility.set_location('Michigan',20);
404
405 update_report_fs_rec (
406 p_pest_state_code =>
407 filing_status_rec.state_code,
408 p_pest_fs_code =>
409 filing_status_rec.filing_status_code,
410 p_pest_id =>
411 filing_status_rec.emp_state_tax_rule_id,
412 p_session_id => l_session_id,
416 ELSIF filing_status_rec.state_code = '24' and
413 p_bug_number => l_bug_no,
414 p_new_fs_code => '01' ) ;
415
417 filing_status_rec.filing_status_code = '03'
418 THEN
419 hr_utility.set_location('Minnesota',22);
420
421 update_report_fs_rec (
422 p_pest_state_code =>
423 filing_status_rec.state_code,
424 p_pest_fs_code =>
425 filing_status_rec.filing_status_code,
426 p_pest_id =>
427 filing_status_rec.emp_state_tax_rule_id,
428 p_session_id => l_session_id,
429 p_bug_number => l_bug_no,
430 p_new_fs_code => '01' ) ;
431 /* There is no requirement to convert Head of Household FS for
432 Misourri */
433
434 /*
435 ELSIF filing_status_rec.state_code = '26' and
436 filing_status_rec.filing_status_code = '03'
437 THEN
438 hr_utility.set_location('Missouri',23);
439
440 update_report_fs_rec (
441 p_pest_state_code =>
442 filing_status_rec.state_code,
443 p_pest_fs_code =>
444 filing_status_rec.filing_status_code,
445 p_pest_id =>
446 filing_status_rec.emp_state_tax_rule_id,
447 p_session_id => l_session_id,
448 p_bug_number => l_bug_no,
449 p_new_fs_code => '01' ) ;
450 */
451
452 ELSIF filing_status_rec.state_code = '27' and
453 filing_status_rec.filing_status_code IN ( '03' )
454 THEN
455 hr_utility.set_location('Montana',24);
456
457 update_report_fs_rec (
458 p_pest_state_code =>
459 filing_status_rec.state_code,
460 p_pest_fs_code =>
461 filing_status_rec.filing_status_code,
462 p_pest_id =>
463 filing_status_rec.emp_state_tax_rule_id,
464 p_session_id => l_session_id,
465 p_bug_number => l_bug_no,
466 p_new_fs_code => '01' ) ;
467
468 ELSIF filing_status_rec.state_code = '28' and
469 filing_status_rec.filing_status_code = '03'
470 THEN
471 hr_utility.set_location('Nebraska',25);
472
473 update_report_fs_rec (
474 p_pest_state_code =>
475 filing_status_rec.state_code,
476 p_pest_fs_code =>
477 filing_status_rec.filing_status_code,
478 p_pest_id =>
479 filing_status_rec.emp_state_tax_rule_id,
480 p_session_id => l_session_id,
481 p_bug_number => l_bug_no,
482 p_new_fs_code => '01' ) ;
483 /*
484 ELSIF filing_status_rec.state_code = '31' and
485 filing_status_rec.filing_status_code = '03'
486 THEN
487 hr_utility.set_location('New Jersey',26);
488
489 update_report_fs_rec (
490 p_pest_state_code =>
491 filing_status_rec.state_code,
492 p_pest_fs_code =>
493 filing_status_rec.filing_status_code,
494 p_pest_id =>
495 filing_status_rec.emp_state_tax_rule_id,
496 p_session_id => l_session_id,
497 p_bug_number => l_bug_no,
498 p_new_fs_code => '01' ) ;
499 */
500
501 ELSIF filing_status_rec.state_code = '32' and
502 filing_status_rec.filing_status_code = '03'
503 THEN
504 hr_utility.set_location('New Mexico',27);
505
506 update_report_fs_rec (
507 p_pest_state_code =>
508 filing_status_rec.state_code,
509 p_pest_fs_code =>
510 filing_status_rec.filing_status_code,
514 p_bug_number => l_bug_no,
511 p_pest_id =>
512 filing_status_rec.emp_state_tax_rule_id,
513 p_session_id => l_session_id,
515 p_new_fs_code => '01' ) ;
516
517 ELSIF filing_status_rec.state_code = '33' and
518 filing_status_rec.filing_status_code = '03'
519 THEN
520 hr_utility.set_location('New York',28);
521
522 update_report_fs_rec (
523 p_pest_state_code =>
524 filing_status_rec.state_code,
525 p_pest_fs_code =>
526 filing_status_rec.filing_status_code,
527 p_pest_id =>
528 filing_status_rec.emp_state_tax_rule_id,
529 p_session_id => l_session_id,
530 p_bug_number => l_bug_no,
531 p_new_fs_code => '01' ) ;
532
533 /* Bug 3455165: "Qualified Widower" no longer a valid filing status for New York State */
534
535 ELSIF filing_status_rec.state_code = '33' and
536 filing_status_rec.filing_status_code = '05' --Qualifying Widower
537 THEN
538 hr_utility.set_location('New York',28);
539
540 update_report_fs_rec (
541 p_pest_state_code =>
542 filing_status_rec.state_code,
543 p_pest_fs_code =>
544 filing_status_rec.filing_status_code,
545 p_pest_id =>
546 filing_status_rec.emp_state_tax_rule_id,
547 p_session_id => l_session_id,
548 p_bug_number => l_bug_no,
549 p_new_fs_code => '01' ) ;
550
551 /* There is not requirement to convert Head of Household
552 for North Carolina */
553
554 /*
555 ELSIF filing_status_rec.state_code = '34' and
556 filing_status_rec.filing_status_code = '03'
557 THEN
558 hr_utility.set_location('North Carolina',29);
559
560 update_report_fs_rec (
561 p_pest_state_code =>
562 filing_status_rec.state_code,
563 p_pest_fs_code =>
564 filing_status_rec.filing_status_code,
565 p_pest_id =>
566 filing_status_rec.emp_state_tax_rule_id,
567 p_session_id => l_session_id,
568 p_bug_number => l_bug_no,
569 p_new_fs_code => '01' ) ;
570 */
571
572 ELSIF filing_status_rec.state_code = '35' and
573 filing_status_rec.filing_status_code = '03'
574 THEN
575 hr_utility.set_location('North Dakota',30);
576
577 update_report_fs_rec (
578 p_pest_state_code =>
579 filing_status_rec.state_code,
580 p_pest_fs_code =>
581 filing_status_rec.filing_status_code,
582 p_pest_id =>
583 filing_status_rec.emp_state_tax_rule_id,
584 p_session_id => l_session_id,
585 p_bug_number => l_bug_no,
586 p_new_fs_code => '01' ) ;
587
588 ELSIF filing_status_rec.state_code = '36' and
589 filing_status_rec.filing_status_code in ( '03', '02')
590 THEN
591 hr_utility.set_location('Ohio',31);
592
593 update_report_fs_rec (
594 p_pest_state_code =>
595 filing_status_rec.state_code,
596 p_pest_fs_code =>
597 filing_status_rec.filing_status_code,
598 p_pest_id =>
599 filing_status_rec.emp_state_tax_rule_id,
600 p_session_id => l_session_id,
601 p_bug_number => l_bug_no,
602 p_new_fs_code => '01' ) ;
603
604 ELSIF filing_status_rec.state_code = '37' and
605 filing_status_rec.filing_status_code = '03'
606 THEN
610 p_pest_state_code =>
607 hr_utility.set_location('Oklahoma',32);
608
609 update_report_fs_rec (
611 filing_status_rec.state_code,
612 p_pest_fs_code =>
613 filing_status_rec.filing_status_code,
614 p_pest_id =>
615 filing_status_rec.emp_state_tax_rule_id,
616 p_session_id => l_session_id,
617 p_bug_number => l_bug_no,
618 p_new_fs_code => '01' ) ;
619
620 ELSIF filing_status_rec.state_code = '37' and
621 filing_status_rec.filing_status_code = '04'
622 THEN
623 hr_utility.set_location('Oklahoma',32.1);
624
625 update_report_fs_rec (
626 p_pest_state_code =>
627 filing_status_rec.state_code,
628 p_pest_fs_code =>
629 filing_status_rec.filing_status_code,
630 p_pest_id =>
631 filing_status_rec.emp_state_tax_rule_id,
632 p_session_id => l_session_id,
633 p_bug_number => l_bug_no,
634 p_new_fs_code => '01' ) ;
635
636 ELSIF filing_status_rec.state_code = '39' and
637 filing_status_rec.filing_status_code in ( '03', '02')
638 THEN
639 hr_utility.set_location('Pennsylvania',33);
640
641 update_report_fs_rec (
642 p_pest_state_code =>
643 filing_status_rec.state_code,
644 p_pest_fs_code =>
645 filing_status_rec.filing_status_code,
646 p_pest_id =>
647 filing_status_rec.emp_state_tax_rule_id,
648 p_session_id => l_session_id,
649 p_bug_number => l_bug_no,
650 p_new_fs_code => '01' ) ;
651
652 ELSIF filing_status_rec.state_code = '40' and
653 filing_status_rec.filing_status_code = '03'
654 THEN
655 hr_utility.set_location('Rhode Island',34);
656
657 update_report_fs_rec (
658 p_pest_state_code =>
659 filing_status_rec.state_code,
660 p_pest_fs_code =>
661 filing_status_rec.filing_status_code,
662 p_pest_id =>
663 filing_status_rec.emp_state_tax_rule_id,
664 p_session_id => l_session_id,
665 p_bug_number => l_bug_no,
666 p_new_fs_code => '01' ) ;
667
668 ELSIF filing_status_rec.state_code = '41' and
669 filing_status_rec.filing_status_code in ( '03' )
670 THEN
671 hr_utility.set_location('South Carolina',35);
672
673 update_report_fs_rec (
674 p_pest_state_code =>
675 filing_status_rec.state_code,
676 p_pest_fs_code =>
677 filing_status_rec.filing_status_code,
678 p_pest_id =>
679 filing_status_rec.emp_state_tax_rule_id,
680 p_session_id => l_session_id,
681 p_bug_number => l_bug_no,
682 p_new_fs_code => '01' ) ;
683
684 ELSIF filing_status_rec.state_code = '46' and
685 filing_status_rec.filing_status_code = '03'
686 THEN
687 hr_utility.set_location('Vermont',36);
688
689 update_report_fs_rec (
690 p_pest_state_code =>
691 filing_status_rec.state_code,
692 p_pest_fs_code =>
693 filing_status_rec.filing_status_code,
694 p_pest_id =>
695 filing_status_rec.emp_state_tax_rule_id,
696 p_session_id => l_session_id,
697 p_bug_number => l_bug_no,
698 p_new_fs_code => '01' ) ;
699
700 ELSIF filing_status_rec.state_code = '47' and
701 filing_status_rec.filing_status_code in ( '03', '02')
702 THEN
703 hr_utility.set_location('Virginia',37);
704
705 update_report_fs_rec (
706 p_pest_state_code =>
707 filing_status_rec.state_code,
708 p_pest_fs_code =>
709 filing_status_rec.filing_status_code,
710 p_pest_id =>
711 filing_status_rec.emp_state_tax_rule_id,
712 p_session_id => l_session_id,
713 p_bug_number => l_bug_no,
714 p_new_fs_code => '01' ) ;
715
716 ELSIF filing_status_rec.state_code = '49' and
717 filing_status_rec.filing_status_code in ( '02', '03' )
718 THEN
719 hr_utility.set_location('West Virginia',38);
720
721 update_report_fs_rec (
722 p_pest_state_code =>
723 filing_status_rec.state_code,
724 p_pest_fs_code =>
725 filing_status_rec.filing_status_code,
726 p_pest_id =>
727 filing_status_rec.emp_state_tax_rule_id,
728 p_session_id => l_session_id,
729 p_bug_number => l_bug_no,
730 p_new_fs_code => '01' ) ;
731
732 END IF;
733 commit;
734
735 hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);
736
737 END LOOP ;
738 CLOSE filing_status_cur ;
739
740 hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);
741
742 EXCEPTION
743 WHEN OTHERS THEN
744 l_error_message_text := to_char(SQLCODE)||SQLERRM||
745 ' Program error contact support';
746 rollback;
747
748 hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);
749 raise_application_error(-20001,l_error_message_text);
750
751 --
752 --
753 --
754 --commit;
755 END update_filing_status ;
756 --
757 --
758 --
759 --
760
761 END pay_us_fs_upd_pkg;
762