APPS.PAY_IPD_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 159: When hr_api.check_integrity_violated Then

155: End If;
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 15);
158: Exception
159: When hr_api.check_integrity_violated Then
160: -- A check constraint has been violated
161: --
162: pay_ipd_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

159: When hr_api.check_integrity_violated Then
160: -- A check constraint has been violated
161: --
162: pay_ipd_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: pay_ipd_shd.constraint_error

Line 164: When hr_api.unique_integrity_violated Then

160: -- A check constraint has been violated
161: --
162: pay_ipd_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: pay_ipd_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: pay_ipd_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;
172: End dt_update_dml;

Line 285: If (p_datetrack_mode <> hr_api.g_correction) then

281: l_dummy_version_number number;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: If (p_datetrack_mode <> hr_api.g_correction) then
286: --
287: -- Update the current effective end date
288: --
289: pay_ipd_shd.upd_effective_end_date

Line 298: If (p_datetrack_mode = hr_api.g_update_override) then

294: ,p_validation_end_date => p_validation_end_date
295: ,p_object_version_number => l_dummy_version_number
296: );
297: --
298: If (p_datetrack_mode = hr_api.g_update_override) then
299: --
300: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
301: -- delete any future rows
302: --

Line 520: when hr_api.cannot_find_prog_unit then

516: );
517: --
518: exception
519: --
520: when hr_api.cannot_find_prog_unit then
521: --
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'PAY_IE_PAYE_DETAILS_F'
524: ,p_hook_type => 'AU');

Line 522: hr_api.cannot_find_prog_unit_error

518: exception
519: --
520: when hr_api.cannot_find_prog_unit then
521: --
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'PAY_IE_PAYE_DETAILS_F'
524: ,p_hook_type => 'AU');
525: --
526: end;

Line 585: If (p_rec.assignment_id = hr_api.g_number) then

581: -- p_rec plsql record structure
582: -- to see if a system default is being used. If a system default
583: -- is being used then we must set to the 'current' argument value.
584: --
585: If (p_rec.assignment_id = hr_api.g_number) then
586: p_rec.assignment_id :=
587: pay_ipd_shd.g_old_rec.assignment_id;
588: End If;
589: If (p_rec.info_source = hr_api.g_varchar2) then

Line 589: If (p_rec.info_source = hr_api.g_varchar2) then

585: If (p_rec.assignment_id = hr_api.g_number) then
586: p_rec.assignment_id :=
587: pay_ipd_shd.g_old_rec.assignment_id;
588: End If;
589: If (p_rec.info_source = hr_api.g_varchar2) then
590: p_rec.info_source :=
591: pay_ipd_shd.g_old_rec.info_source;
592: End If;
593: If (p_rec.comm_period_no = hr_api.g_number) then

Line 593: If (p_rec.comm_period_no = hr_api.g_number) then

589: If (p_rec.info_source = hr_api.g_varchar2) then
590: p_rec.info_source :=
591: pay_ipd_shd.g_old_rec.info_source;
592: End If;
593: If (p_rec.comm_period_no = hr_api.g_number) then
594: p_rec.comm_period_no :=
595: pay_ipd_shd.g_old_rec.comm_period_no;
596: End If;
597: If (p_rec.tax_basis = hr_api.g_varchar2) then

Line 597: If (p_rec.tax_basis = hr_api.g_varchar2) then

593: If (p_rec.comm_period_no = hr_api.g_number) then
594: p_rec.comm_period_no :=
595: pay_ipd_shd.g_old_rec.comm_period_no;
596: End If;
597: If (p_rec.tax_basis = hr_api.g_varchar2) then
598: p_rec.tax_basis :=
599: pay_ipd_shd.g_old_rec.tax_basis;
600: End If;
601: If (p_rec.certificate_start_date = hr_api.g_date) then

Line 601: If (p_rec.certificate_start_date = hr_api.g_date) then

597: If (p_rec.tax_basis = hr_api.g_varchar2) then
598: p_rec.tax_basis :=
599: pay_ipd_shd.g_old_rec.tax_basis;
600: End If;
601: If (p_rec.certificate_start_date = hr_api.g_date) then
602: p_rec.certificate_start_date :=
603: pay_ipd_shd.g_old_rec.certificate_start_date;
604: End If;
605: If (p_rec.certificate_end_date = hr_api.g_date) then

Line 605: If (p_rec.certificate_end_date = hr_api.g_date) then

601: If (p_rec.certificate_start_date = hr_api.g_date) then
602: p_rec.certificate_start_date :=
603: pay_ipd_shd.g_old_rec.certificate_start_date;
604: End If;
605: If (p_rec.certificate_end_date = hr_api.g_date) then
606: p_rec.certificate_end_date :=
607: pay_ipd_shd.g_old_rec.certificate_end_date;
608: End If;
609: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then

Line 609: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then

605: If (p_rec.certificate_end_date = hr_api.g_date) then
606: p_rec.certificate_end_date :=
607: pay_ipd_shd.g_old_rec.certificate_end_date;
608: End If;
609: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
610: p_rec.tax_assess_basis :=
611: pay_ipd_shd.g_old_rec.tax_assess_basis;
612: End If;
613: If (p_rec.weekly_tax_credit = hr_api.g_number) then

Line 613: If (p_rec.weekly_tax_credit = hr_api.g_number) then

609: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
610: p_rec.tax_assess_basis :=
611: pay_ipd_shd.g_old_rec.tax_assess_basis;
612: End If;
613: If (p_rec.weekly_tax_credit = hr_api.g_number) then
614: p_rec.weekly_tax_credit :=
615: pay_ipd_shd.g_old_rec.weekly_tax_credit;
616: End If;
617: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then

Line 617: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then

613: If (p_rec.weekly_tax_credit = hr_api.g_number) then
614: p_rec.weekly_tax_credit :=
615: pay_ipd_shd.g_old_rec.weekly_tax_credit;
616: End If;
617: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
618: p_rec.weekly_std_rate_cut_off :=
619: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
620: End If;
621: If (p_rec.monthly_tax_credit = hr_api.g_number) then

Line 621: If (p_rec.monthly_tax_credit = hr_api.g_number) then

617: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
618: p_rec.weekly_std_rate_cut_off :=
619: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
620: End If;
621: If (p_rec.monthly_tax_credit = hr_api.g_number) then
622: p_rec.monthly_tax_credit :=
623: pay_ipd_shd.g_old_rec.monthly_tax_credit;
624: End If;
625: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then

Line 625: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then

621: If (p_rec.monthly_tax_credit = hr_api.g_number) then
622: p_rec.monthly_tax_credit :=
623: pay_ipd_shd.g_old_rec.monthly_tax_credit;
624: End If;
625: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
626: p_rec.monthly_std_rate_cut_off :=
627: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
628: End If;
629: If (p_rec.request_id = hr_api.g_number) then

Line 629: If (p_rec.request_id = hr_api.g_number) then

625: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
626: p_rec.monthly_std_rate_cut_off :=
627: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
628: End If;
629: If (p_rec.request_id = hr_api.g_number) then
630: p_rec.request_id :=
631: pay_ipd_shd.g_old_rec.request_id;
632: End If;
633: If (p_rec.program_application_id = hr_api.g_number) then

Line 633: If (p_rec.program_application_id = hr_api.g_number) then

629: If (p_rec.request_id = hr_api.g_number) then
630: p_rec.request_id :=
631: pay_ipd_shd.g_old_rec.request_id;
632: End If;
633: If (p_rec.program_application_id = hr_api.g_number) then
634: p_rec.program_application_id :=
635: pay_ipd_shd.g_old_rec.program_application_id;
636: End If;
637: If (p_rec.program_id = hr_api.g_number) then

Line 637: If (p_rec.program_id = hr_api.g_number) then

633: If (p_rec.program_application_id = hr_api.g_number) then
634: p_rec.program_application_id :=
635: pay_ipd_shd.g_old_rec.program_application_id;
636: End If;
637: If (p_rec.program_id = hr_api.g_number) then
638: p_rec.program_id :=
639: pay_ipd_shd.g_old_rec.program_id;
640: End If;
641: If (p_rec.program_update_date = hr_api.g_date) then

Line 641: If (p_rec.program_update_date = hr_api.g_date) then

637: If (p_rec.program_id = hr_api.g_number) then
638: p_rec.program_id :=
639: pay_ipd_shd.g_old_rec.program_id;
640: End If;
641: If (p_rec.program_update_date = hr_api.g_date) then
642: p_rec.program_update_date :=
643: pay_ipd_shd.g_old_rec.program_update_date;
644: End If;
645: If (p_rec.certificate_issue_date = hr_api.g_date) then

Line 645: If (p_rec.certificate_issue_date = hr_api.g_date) then

641: If (p_rec.program_update_date = hr_api.g_date) then
642: p_rec.program_update_date :=
643: pay_ipd_shd.g_old_rec.program_update_date;
644: End If;
645: If (p_rec.certificate_issue_date = hr_api.g_date) then
646: p_rec.certificate_issue_date :=
647: pay_ipd_shd.g_old_rec.certificate_issue_date;
648: End If;
649: --

Line 652: If (p_rec.yrly_tax_cred = hr_api.g_number) then

648: End If;
649: --
650:
651: --13359423
652: If (p_rec.yrly_tax_cred = hr_api.g_number) then
653: p_rec.yrly_tax_cred := pay_ipd_shd.g_old_rec.yrly_tax_cred;
654: End If;
655:
656: If (p_rec.yrly_tax_rate_1 = hr_api.g_number) then

Line 656: If (p_rec.yrly_tax_rate_1 = hr_api.g_number) then

652: If (p_rec.yrly_tax_cred = hr_api.g_number) then
653: p_rec.yrly_tax_cred := pay_ipd_shd.g_old_rec.yrly_tax_cred;
654: End If;
655:
656: If (p_rec.yrly_tax_rate_1 = hr_api.g_number) then
657: p_rec.yrly_tax_rate_1 := pay_ipd_shd.g_old_rec.yrly_tax_rate_1;
658: End if;
659:
660: If (p_rec.yrly_tax_rate_2 = hr_api.g_number) then

Line 660: If (p_rec.yrly_tax_rate_2 = hr_api.g_number) then

656: If (p_rec.yrly_tax_rate_1 = hr_api.g_number) then
657: p_rec.yrly_tax_rate_1 := pay_ipd_shd.g_old_rec.yrly_tax_rate_1;
658: End if;
659:
660: If (p_rec.yrly_tax_rate_2 = hr_api.g_number) then
661: p_rec.yrly_tax_rate_2 := pay_ipd_shd.g_old_rec.yrly_tax_rate_2;
662: End if;
663:
664: If (p_rec.mthly_tax_rate_2 = hr_api.g_number) then

Line 664: If (p_rec.mthly_tax_rate_2 = hr_api.g_number) then

660: If (p_rec.yrly_tax_rate_2 = hr_api.g_number) then
661: p_rec.yrly_tax_rate_2 := pay_ipd_shd.g_old_rec.yrly_tax_rate_2;
662: End if;
663:
664: If (p_rec.mthly_tax_rate_2 = hr_api.g_number) then
665: p_rec.mthly_tax_rate_2 := pay_ipd_shd.g_old_rec.mthly_tax_rate_2;
666: End if;
667:
668: If (p_rec.wkly_tax_rate_2 = hr_api.g_number) then

Line 668: If (p_rec.wkly_tax_rate_2 = hr_api.g_number) then

664: If (p_rec.mthly_tax_rate_2 = hr_api.g_number) then
665: p_rec.mthly_tax_rate_2 := pay_ipd_shd.g_old_rec.mthly_tax_rate_2;
666: End if;
667:
668: If (p_rec.wkly_tax_rate_2 = hr_api.g_number) then
669: p_rec.wkly_tax_rate_2 := pay_ipd_shd.g_old_rec.wkly_tax_rate_2;
670: End if;
671:
672: If (p_rec.tax_rate_3 = hr_api.g_number) then

Line 672: If (p_rec.tax_rate_3 = hr_api.g_number) then

668: If (p_rec.wkly_tax_rate_2 = hr_api.g_number) then
669: p_rec.wkly_tax_rate_2 := pay_ipd_shd.g_old_rec.wkly_tax_rate_2;
670: End if;
671:
672: If (p_rec.tax_rate_3 = hr_api.g_number) then
673: p_rec.tax_rate_3 := pay_ipd_shd.g_old_rec.tax_rate_3;
674: End if;
675:
676: If (p_rec.yrly_tax_rate_3 = hr_api.g_number) then

Line 676: If (p_rec.yrly_tax_rate_3 = hr_api.g_number) then

672: If (p_rec.tax_rate_3 = hr_api.g_number) then
673: p_rec.tax_rate_3 := pay_ipd_shd.g_old_rec.tax_rate_3;
674: End if;
675:
676: If (p_rec.yrly_tax_rate_3 = hr_api.g_number) then
677: p_rec.yrly_tax_rate_3 := pay_ipd_shd.g_old_rec.yrly_tax_rate_3;
678: End if;
679:
680: If (p_rec.mthly_tax_rate_3 = hr_api.g_number) then

Line 680: If (p_rec.mthly_tax_rate_3 = hr_api.g_number) then

676: If (p_rec.yrly_tax_rate_3 = hr_api.g_number) then
677: p_rec.yrly_tax_rate_3 := pay_ipd_shd.g_old_rec.yrly_tax_rate_3;
678: End if;
679:
680: If (p_rec.mthly_tax_rate_3 = hr_api.g_number) then
681: p_rec.mthly_tax_rate_3 := pay_ipd_shd.g_old_rec.mthly_tax_rate_3;
682: End if;
683:
684: If (p_rec.wkly_tax_rate_3 = hr_api.g_number) then

Line 684: If (p_rec.wkly_tax_rate_3 = hr_api.g_number) then

680: If (p_rec.mthly_tax_rate_3 = hr_api.g_number) then
681: p_rec.mthly_tax_rate_3 := pay_ipd_shd.g_old_rec.mthly_tax_rate_3;
682: End if;
683:
684: If (p_rec.wkly_tax_rate_3 = hr_api.g_number) then
685: p_rec.wkly_tax_rate_3 := pay_ipd_shd.g_old_rec.wkly_tax_rate_3;
686: End if;
687:
688: If (p_rec.tax_rate_4 = hr_api.g_number) then

Line 688: If (p_rec.tax_rate_4 = hr_api.g_number) then

684: If (p_rec.wkly_tax_rate_3 = hr_api.g_number) then
685: p_rec.wkly_tax_rate_3 := pay_ipd_shd.g_old_rec.wkly_tax_rate_3;
686: End if;
687:
688: If (p_rec.tax_rate_4 = hr_api.g_number) then
689: p_rec.tax_rate_4 := pay_ipd_shd.g_old_rec.tax_rate_4;
690: End if;
691:
692: If (p_rec.yrly_tax_rate_4 = hr_api.g_number) then

Line 692: If (p_rec.yrly_tax_rate_4 = hr_api.g_number) then

688: If (p_rec.tax_rate_4 = hr_api.g_number) then
689: p_rec.tax_rate_4 := pay_ipd_shd.g_old_rec.tax_rate_4;
690: End if;
691:
692: If (p_rec.yrly_tax_rate_4 = hr_api.g_number) then
693: p_rec.yrly_tax_rate_4 := pay_ipd_shd.g_old_rec.yrly_tax_rate_4;
694: End if;
695:
696: If (p_rec.mthly_tax_rate_4 = hr_api.g_number) then

Line 696: If (p_rec.mthly_tax_rate_4 = hr_api.g_number) then

692: If (p_rec.yrly_tax_rate_4 = hr_api.g_number) then
693: p_rec.yrly_tax_rate_4 := pay_ipd_shd.g_old_rec.yrly_tax_rate_4;
694: End if;
695:
696: If (p_rec.mthly_tax_rate_4 = hr_api.g_number) then
697: p_rec.mthly_tax_rate_4 := pay_ipd_shd.g_old_rec.mthly_tax_rate_4;
698: End if;
699:
700: If (p_rec.wkly_tax_rate_4 = hr_api.g_number) then

Line 700: If (p_rec.wkly_tax_rate_4 = hr_api.g_number) then

696: If (p_rec.mthly_tax_rate_4 = hr_api.g_number) then
697: p_rec.mthly_tax_rate_4 := pay_ipd_shd.g_old_rec.mthly_tax_rate_4;
698: End if;
699:
700: If (p_rec.wkly_tax_rate_4 = hr_api.g_number) then
701: p_rec.wkly_tax_rate_4 := pay_ipd_shd.g_old_rec.wkly_tax_rate_4;
702: End if;
703:
704: If (p_rec.tax_rate_5 = hr_api.g_number) then

Line 704: If (p_rec.tax_rate_5 = hr_api.g_number) then

700: If (p_rec.wkly_tax_rate_4 = hr_api.g_number) then
701: p_rec.wkly_tax_rate_4 := pay_ipd_shd.g_old_rec.wkly_tax_rate_4;
702: End if;
703:
704: If (p_rec.tax_rate_5 = hr_api.g_number) then
705: p_rec.tax_rate_5 := pay_ipd_shd.g_old_rec.tax_rate_5;
706: End if;
707:
708: If (p_rec.in_exempt_usc = hr_api.g_varchar2) then

Line 708: If (p_rec.in_exempt_usc = hr_api.g_varchar2) then

704: If (p_rec.tax_rate_5 = hr_api.g_number) then
705: p_rec.tax_rate_5 := pay_ipd_shd.g_old_rec.tax_rate_5;
706: End if;
707:
708: If (p_rec.in_exempt_usc = hr_api.g_varchar2) then
709: p_rec.in_exempt_usc := pay_ipd_shd.g_old_rec.in_exempt_usc;
710: End if;
711:
712: If (p_rec.total_usc_pay_todate = hr_api.g_number) then

Line 712: If (p_rec.total_usc_pay_todate = hr_api.g_number) then

708: If (p_rec.in_exempt_usc = hr_api.g_varchar2) then
709: p_rec.in_exempt_usc := pay_ipd_shd.g_old_rec.in_exempt_usc;
710: End if;
711:
712: If (p_rec.total_usc_pay_todate = hr_api.g_number) then
713: p_rec.total_usc_pay_todate := pay_ipd_shd.g_old_rec.total_usc_pay_todate;
714: End if;
715:
716: If (p_rec.total_usc_tax_todate = hr_api.g_number) then

Line 716: If (p_rec.total_usc_tax_todate = hr_api.g_number) then

712: If (p_rec.total_usc_pay_todate = hr_api.g_number) then
713: p_rec.total_usc_pay_todate := pay_ipd_shd.g_old_rec.total_usc_pay_todate;
714: End if;
715:
716: If (p_rec.total_usc_tax_todate = hr_api.g_number) then
717: p_rec.total_usc_tax_todate := pay_ipd_shd.g_old_rec.total_usc_tax_todate;
718: End if;
719:
720: If (p_rec.usc_rate_1 = hr_api.g_number) then

Line 720: If (p_rec.usc_rate_1 = hr_api.g_number) then

716: If (p_rec.total_usc_tax_todate = hr_api.g_number) then
717: p_rec.total_usc_tax_todate := pay_ipd_shd.g_old_rec.total_usc_tax_todate;
718: End if;
719:
720: If (p_rec.usc_rate_1 = hr_api.g_number) then
721: p_rec.usc_rate_1 := pay_ipd_shd.g_old_rec.usc_rate_1;
722: End if;
723:
724: If (p_rec.usc_yrly_cutoff_1 = hr_api.g_number) then

Line 724: If (p_rec.usc_yrly_cutoff_1 = hr_api.g_number) then

720: If (p_rec.usc_rate_1 = hr_api.g_number) then
721: p_rec.usc_rate_1 := pay_ipd_shd.g_old_rec.usc_rate_1;
722: End if;
723:
724: If (p_rec.usc_yrly_cutoff_1 = hr_api.g_number) then
725: p_rec.usc_yrly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_1;
726: End if;
727:
728: If (p_rec.usc_mthly_cutoff_1 = hr_api.g_number) then

Line 728: If (p_rec.usc_mthly_cutoff_1 = hr_api.g_number) then

724: If (p_rec.usc_yrly_cutoff_1 = hr_api.g_number) then
725: p_rec.usc_yrly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_1;
726: End if;
727:
728: If (p_rec.usc_mthly_cutoff_1 = hr_api.g_number) then
729: p_rec.usc_mthly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_1;
730: End if;
731:
732: If (p_rec.usc_wkly_cutoff_1 = hr_api.g_number) then

Line 732: If (p_rec.usc_wkly_cutoff_1 = hr_api.g_number) then

728: If (p_rec.usc_mthly_cutoff_1 = hr_api.g_number) then
729: p_rec.usc_mthly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_1;
730: End if;
731:
732: If (p_rec.usc_wkly_cutoff_1 = hr_api.g_number) then
733: p_rec.usc_wkly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_1;
734: End if;
735:
736: If (p_rec.usc_rate_2 = hr_api.g_number) then

Line 736: If (p_rec.usc_rate_2 = hr_api.g_number) then

732: If (p_rec.usc_wkly_cutoff_1 = hr_api.g_number) then
733: p_rec.usc_wkly_cutoff_1 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_1;
734: End if;
735:
736: If (p_rec.usc_rate_2 = hr_api.g_number) then
737: p_rec.usc_rate_2 := pay_ipd_shd.g_old_rec.usc_rate_2;
738: End if;
739:
740: If (p_rec.usc_yrly_cutoff_2 = hr_api.g_number) then

Line 740: If (p_rec.usc_yrly_cutoff_2 = hr_api.g_number) then

736: If (p_rec.usc_rate_2 = hr_api.g_number) then
737: p_rec.usc_rate_2 := pay_ipd_shd.g_old_rec.usc_rate_2;
738: End if;
739:
740: If (p_rec.usc_yrly_cutoff_2 = hr_api.g_number) then
741: p_rec.usc_yrly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_2;
742: End if;
743:
744: If (p_rec.usc_mthly_cutoff_2 = hr_api.g_number) then

Line 744: If (p_rec.usc_mthly_cutoff_2 = hr_api.g_number) then

740: If (p_rec.usc_yrly_cutoff_2 = hr_api.g_number) then
741: p_rec.usc_yrly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_2;
742: End if;
743:
744: If (p_rec.usc_mthly_cutoff_2 = hr_api.g_number) then
745: p_rec.usc_mthly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_2;
746: End if;
747:
748: If (p_rec.usc_wkly_cutoff_2 = hr_api.g_number) then

Line 748: If (p_rec.usc_wkly_cutoff_2 = hr_api.g_number) then

744: If (p_rec.usc_mthly_cutoff_2 = hr_api.g_number) then
745: p_rec.usc_mthly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_2;
746: End if;
747:
748: If (p_rec.usc_wkly_cutoff_2 = hr_api.g_number) then
749: p_rec.usc_wkly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_2;
750: End if;
751:
752: If (p_rec.usc_rate_3 = hr_api.g_number) then

Line 752: If (p_rec.usc_rate_3 = hr_api.g_number) then

748: If (p_rec.usc_wkly_cutoff_2 = hr_api.g_number) then
749: p_rec.usc_wkly_cutoff_2 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_2;
750: End if;
751:
752: If (p_rec.usc_rate_3 = hr_api.g_number) then
753: p_rec.usc_rate_3 := pay_ipd_shd.g_old_rec.usc_rate_3;
754: End if;
755:
756: If (p_rec.usc_yrly_cutoff_3 = hr_api.g_number) then

Line 756: If (p_rec.usc_yrly_cutoff_3 = hr_api.g_number) then

752: If (p_rec.usc_rate_3 = hr_api.g_number) then
753: p_rec.usc_rate_3 := pay_ipd_shd.g_old_rec.usc_rate_3;
754: End if;
755:
756: If (p_rec.usc_yrly_cutoff_3 = hr_api.g_number) then
757: p_rec.usc_yrly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_3;
758: End if;
759:
760: If (p_rec.usc_mthly_cutoff_3 = hr_api.g_number) then

Line 760: If (p_rec.usc_mthly_cutoff_3 = hr_api.g_number) then

756: If (p_rec.usc_yrly_cutoff_3 = hr_api.g_number) then
757: p_rec.usc_yrly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_3;
758: End if;
759:
760: If (p_rec.usc_mthly_cutoff_3 = hr_api.g_number) then
761: p_rec.usc_mthly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_3;
762: End if;
763:
764: If (p_rec.usc_wkly_cutoff_3 = hr_api.g_number) then

Line 764: If (p_rec.usc_wkly_cutoff_3 = hr_api.g_number) then

760: If (p_rec.usc_mthly_cutoff_3 = hr_api.g_number) then
761: p_rec.usc_mthly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_3;
762: End if;
763:
764: If (p_rec.usc_wkly_cutoff_3 = hr_api.g_number) then
765: p_rec.usc_wkly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_3;
766: End if;
767:
768: If (p_rec.usc_rate_4 = hr_api.g_number) then

Line 768: If (p_rec.usc_rate_4 = hr_api.g_number) then

764: If (p_rec.usc_wkly_cutoff_3 = hr_api.g_number) then
765: p_rec.usc_wkly_cutoff_3 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_3;
766: End if;
767:
768: If (p_rec.usc_rate_4 = hr_api.g_number) then
769: p_rec.usc_rate_4 := pay_ipd_shd.g_old_rec.usc_rate_4;
770: End if;
771:
772: If (p_rec.usc_yrly_cutoff_4 = hr_api.g_number) then

Line 772: If (p_rec.usc_yrly_cutoff_4 = hr_api.g_number) then

768: If (p_rec.usc_rate_4 = hr_api.g_number) then
769: p_rec.usc_rate_4 := pay_ipd_shd.g_old_rec.usc_rate_4;
770: End if;
771:
772: If (p_rec.usc_yrly_cutoff_4 = hr_api.g_number) then
773: p_rec.usc_yrly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_4;
774: End if;
775:
776: If (p_rec.usc_mthly_cutoff_4 = hr_api.g_number) then

Line 776: If (p_rec.usc_mthly_cutoff_4 = hr_api.g_number) then

772: If (p_rec.usc_yrly_cutoff_4 = hr_api.g_number) then
773: p_rec.usc_yrly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_yrly_cutoff_4;
774: End if;
775:
776: If (p_rec.usc_mthly_cutoff_4 = hr_api.g_number) then
777: p_rec.usc_mthly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_4;
778: End if;
779:
780: If (p_rec.usc_wkly_cutoff_4 = hr_api.g_number) then

Line 780: If (p_rec.usc_wkly_cutoff_4 = hr_api.g_number) then

776: If (p_rec.usc_mthly_cutoff_4 = hr_api.g_number) then
777: p_rec.usc_mthly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_mthly_cutoff_4;
778: End if;
779:
780: If (p_rec.usc_wkly_cutoff_4 = hr_api.g_number) then
781: p_rec.usc_wkly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_4;
782: End if;
783:
784: If (p_rec.usc_rate_5 = hr_api.g_number) then

Line 784: If (p_rec.usc_rate_5 = hr_api.g_number) then

780: If (p_rec.usc_wkly_cutoff_4 = hr_api.g_number) then
781: p_rec.usc_wkly_cutoff_4 := pay_ipd_shd.g_old_rec.usc_wkly_cutoff_4;
782: End if;
783:
784: If (p_rec.usc_rate_5 = hr_api.g_number) then
785: p_rec.usc_rate_5 := pay_ipd_shd.g_old_rec.usc_rate_5;
786: End if;
787:
788: If (p_rec.usc_tax_basis = hr_api.g_varchar2) then

Line 788: If (p_rec.usc_tax_basis = hr_api.g_varchar2) then

784: If (p_rec.usc_rate_5 = hr_api.g_number) then
785: p_rec.usc_rate_5 := pay_ipd_shd.g_old_rec.usc_rate_5;
786: End if;
787:
788: If (p_rec.usc_tax_basis = hr_api.g_varchar2) then
789: p_rec.usc_tax_basis := pay_ipd_shd.g_old_rec.usc_tax_basis;
790: End if;
791:
792: If (p_rec.usc_info_source = hr_api.g_varchar2) then

Line 792: If (p_rec.usc_info_source = hr_api.g_varchar2) then

788: If (p_rec.usc_tax_basis = hr_api.g_varchar2) then
789: p_rec.usc_tax_basis := pay_ipd_shd.g_old_rec.usc_tax_basis;
790: End if;
791:
792: If (p_rec.usc_info_source = hr_api.g_varchar2) then
793: p_rec.usc_info_source := pay_ipd_shd.g_old_rec.usc_info_source;
794: End if;
795: --13359423
796:

Line 885: ,p_info_source in varchar2 default hr_api.g_varchar2

881: (p_effective_date in date
882: ,p_datetrack_mode in varchar2
883: ,p_paye_details_id in number
884: ,p_object_version_number in out nocopy number
885: ,p_info_source in varchar2 default hr_api.g_varchar2
886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date

Line 886: ,p_tax_basis in varchar2 default hr_api.g_varchar2

882: ,p_datetrack_mode in varchar2
883: ,p_paye_details_id in number
884: ,p_object_version_number in out nocopy number
885: ,p_info_source in varchar2 default hr_api.g_varchar2
886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number

Line 887: ,p_certificate_start_date in date default hr_api.g_date

883: ,p_paye_details_id in number
884: ,p_object_version_number in out nocopy number
885: ,p_info_source in varchar2 default hr_api.g_varchar2
886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number

Line 888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2

884: ,p_object_version_number in out nocopy number
885: ,p_info_source in varchar2 default hr_api.g_varchar2
886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number

Line 889: ,p_certificate_end_date in date default hr_api.g_date

885: ,p_info_source in varchar2 default hr_api.g_varchar2
886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number

Line 890: ,p_weekly_tax_credit in number default hr_api.g_number

886: ,p_tax_basis in varchar2 default hr_api.g_varchar2
887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number

Line 891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number

887: ,p_certificate_start_date in date default hr_api.g_date
888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number

Line 892: ,p_monthly_tax_credit in number default hr_api.g_number

888: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number

Line 893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number

889: ,p_certificate_end_date in date default hr_api.g_date
890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date

Line 894: ,p_request_id in number default hr_api.g_number

890: ,p_weekly_tax_credit in number default hr_api.g_number
891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_certificate_issue_date in date default hr_api.g_date

Line 895: ,p_program_application_id in number default hr_api.g_number

891: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_certificate_issue_date in date default hr_api.g_date
899: ,p_effective_start_date out nocopy date

Line 896: ,p_program_id in number default hr_api.g_number

892: ,p_monthly_tax_credit in number default hr_api.g_number
893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_certificate_issue_date in date default hr_api.g_date
899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date

Line 897: ,p_program_update_date in date default hr_api.g_date

893: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_certificate_issue_date in date default hr_api.g_date
899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date
901: --13359423

Line 898: ,p_certificate_issue_date in date default hr_api.g_date

894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_certificate_issue_date in date default hr_api.g_date
899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date
901: --13359423
902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number

Line 902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number

898: ,p_certificate_issue_date in date default hr_api.g_date
899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date
901: --13359423
902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number
903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number

Line 903: ,p_yrly_tax_rate_1 in number default hr_api.g_number

899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date
901: --13359423
902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number
903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number

Line 904: ,p_yrly_tax_rate_2 in number default hr_api.g_number

900: ,p_effective_end_date out nocopy date
901: --13359423
902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number
903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number

Line 905: ,p_mthly_tax_rate_2 in number default hr_api.g_number

901: --13359423
902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number
903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number

Line 906: ,p_wkly_tax_rate_2 in number default hr_api.g_number

902: ,p_yrly_tax_cred in NUMBER default hr_api.g_number
903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number

Line 907: ,p_tax_rate_3 in number default hr_api.g_number

903: ,p_yrly_tax_rate_1 in number default hr_api.g_number
904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number

Line 908: ,p_yrly_tax_rate_3 in number default hr_api.g_number

904: ,p_yrly_tax_rate_2 in number default hr_api.g_number
905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number

Line 909: ,p_mthly_tax_rate_3 in number default hr_api.g_number

905: ,p_mthly_tax_rate_2 in number default hr_api.g_number
906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number

Line 910: ,p_wkly_tax_rate_3 in number default hr_api.g_number

906: ,p_wkly_tax_rate_2 in number default hr_api.g_number
907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number

Line 911: ,p_tax_rate_4 in number default hr_api.g_number

907: ,p_tax_rate_3 in number default hr_api.g_number
908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number

Line 912: ,p_yrly_tax_rate_4 in number default hr_api.g_number

908: ,p_yrly_tax_rate_3 in number default hr_api.g_number
909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2

Line 913: ,p_mthly_tax_rate_4 in number default hr_api.g_number

909: ,p_mthly_tax_rate_3 in number default hr_api.g_number
910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number

Line 914: ,p_wkly_tax_rate_4 in number default hr_api.g_number

910: ,p_wkly_tax_rate_3 in number default hr_api.g_number
911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number

Line 915: ,p_tax_rate_5 in number default hr_api.g_number

911: ,p_tax_rate_4 in number default hr_api.g_number
912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number

Line 916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2

912: ,p_yrly_tax_rate_4 in number default hr_api.g_number
913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number

Line 917: ,p_total_usc_pay_todate in number default hr_api.g_number

913: ,p_mthly_tax_rate_4 in number default hr_api.g_number
914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number

Line 918: ,p_total_usc_tax_todate in number default hr_api.g_number

914: ,p_wkly_tax_rate_4 in number default hr_api.g_number
915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number

Line 919: ,p_usc_rate_1 in number default hr_api.g_number

915: ,p_tax_rate_5 in number default hr_api.g_number
916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number

Line 920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number

916: ,p_in_exempt_usc in varchar2 default hr_api.g_varchar2
917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number

Line 921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number

917: ,p_total_usc_pay_todate in number default hr_api.g_number
918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number

Line 922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number

918: ,p_total_usc_tax_todate in number default hr_api.g_number
919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number

Line 923: ,p_usc_rate_2 in number default hr_api.g_number

919: ,p_usc_rate_1 in number default hr_api.g_number
920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number

Line 924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number

920: ,p_usc_yrly_cutoff_1 in number default hr_api.g_number
921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number

Line 925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number

921: ,p_usc_mthly_cutoff_1 in number default hr_api.g_number
922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number

Line 926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number

922: ,p_usc_wkly_cutoff_1 in number default hr_api.g_number
923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number

Line 927: ,p_usc_rate_3 in number default hr_api.g_number

923: ,p_usc_rate_2 in number default hr_api.g_number
924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number

Line 928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number

924: ,p_usc_yrly_cutoff_2 in number default hr_api.g_number
925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number

Line 929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number

925: ,p_usc_mthly_cutoff_2 in number default hr_api.g_number
926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number

Line 930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number

926: ,p_usc_wkly_cutoff_2 in number default hr_api.g_number
927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number

Line 931: ,p_usc_rate_4 in number default hr_api.g_number

927: ,p_usc_rate_3 in number default hr_api.g_number
928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number

Line 932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number

928: ,p_usc_yrly_cutoff_3 in number default hr_api.g_number
929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2

Line 933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number

929: ,p_usc_mthly_cutoff_3 in number default hr_api.g_number
930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2
937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2

Line 934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number

930: ,p_usc_wkly_cutoff_3 in number default hr_api.g_number
931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2
937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2
938: --13359423

Line 935: ,p_usc_rate_5 in number default hr_api.g_number

931: ,p_usc_rate_4 in number default hr_api.g_number
932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2
937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2
938: --13359423
939: ) is

Line 936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2

932: ,p_usc_yrly_cutoff_4 in number default hr_api.g_number
933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2
937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2
938: --13359423
939: ) is
940: --

Line 937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2

933: ,p_usc_mthly_cutoff_4 in number default hr_api.g_number
934: ,p_usc_wkly_cutoff_4 in number default hr_api.g_number
935: ,p_usc_rate_5 in number default hr_api.g_number
936: ,p_usc_tax_basis in varchar2 default hr_api.g_varchar2
937: ,p_usc_info_source in varchar2 default hr_api.g_varchar2
938: --13359423
939: ) is
940: --
941: l_rec pay_ipd_shd.g_rec_type;

Line 956: ,hr_api.g_number

952: (p_paye_details_id
953: ,null
954: ,null
955: ,p_object_version_number
956: ,hr_api.g_number
957: ,p_info_source
958: ,hr_api.g_number
959: ,p_tax_basis
960: ,p_certificate_start_date

Line 958: ,hr_api.g_number

954: ,null
955: ,p_object_version_number
956: ,hr_api.g_number
957: ,p_info_source
958: ,hr_api.g_number
959: ,p_tax_basis
960: ,p_certificate_start_date
961: ,p_certificate_end_date
962: ,p_tax_assess_basis