DBA Data[Home] [Help]

APPS.PAY_CTY_UPD dependencies on HR_API

Line 182: When hr_api.check_integrity_violated Then

178: End If;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 15);
181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
185: pay_cty_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
185: pay_cty_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
190: pay_cty_shd.constraint_error

Line 187: When hr_api.unique_integrity_violated Then

183: -- A check constraint has been violated
184: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
185: pay_cty_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
190: pay_cty_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
190: pay_cty_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;
195: End dt_update_dml;

Line 497: when hr_api.cannot_find_prog_unit then

493: );
494: --
495: exception
496: --
497: when hr_api.cannot_find_prog_unit then
498: --
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'PAY_US_EMP_CITY_TAX_RULES_F
501: ,p_hook_type => 'AU');

Line 499: hr_api.cannot_find_prog_unit_error

495: exception
496: --
497: when hr_api.cannot_find_prog_unit then
498: --
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'PAY_US_EMP_CITY_TAX_RULES_F
501: ,p_hook_type => 'AU');
502: --
503: */

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

564: -- p_rec plsql record structure
565: -- to see if a system default is being used. If a system default
566: -- is being used then we must set to the 'current' argument value.
567: --
568: If (p_rec.assignment_id = hr_api.g_number) then
569: p_rec.assignment_id :=
570: pay_cty_shd.g_old_rec.assignment_id;
571: End If;
572: If (p_rec.state_code = hr_api.g_varchar2) then

Line 572: If (p_rec.state_code = hr_api.g_varchar2) then

568: If (p_rec.assignment_id = hr_api.g_number) then
569: p_rec.assignment_id :=
570: pay_cty_shd.g_old_rec.assignment_id;
571: End If;
572: If (p_rec.state_code = hr_api.g_varchar2) then
573: p_rec.state_code :=
574: pay_cty_shd.g_old_rec.state_code;
575: End If;
576: If (p_rec.county_code = hr_api.g_varchar2) then

Line 576: If (p_rec.county_code = hr_api.g_varchar2) then

572: If (p_rec.state_code = hr_api.g_varchar2) then
573: p_rec.state_code :=
574: pay_cty_shd.g_old_rec.state_code;
575: End If;
576: If (p_rec.county_code = hr_api.g_varchar2) then
577: p_rec.county_code :=
578: pay_cty_shd.g_old_rec.county_code;
579: End If;
580: If (p_rec.city_code = hr_api.g_varchar2) then

Line 580: If (p_rec.city_code = hr_api.g_varchar2) then

576: If (p_rec.county_code = hr_api.g_varchar2) then
577: p_rec.county_code :=
578: pay_cty_shd.g_old_rec.county_code;
579: End If;
580: If (p_rec.city_code = hr_api.g_varchar2) then
581: p_rec.city_code :=
582: pay_cty_shd.g_old_rec.city_code;
583: End If;
584: If (p_rec.business_group_id = hr_api.g_number) then

Line 584: If (p_rec.business_group_id = hr_api.g_number) then

580: If (p_rec.city_code = hr_api.g_varchar2) then
581: p_rec.city_code :=
582: pay_cty_shd.g_old_rec.city_code;
583: End If;
584: If (p_rec.business_group_id = hr_api.g_number) then
585: p_rec.business_group_id :=
586: pay_cty_shd.g_old_rec.business_group_id;
587: End If;
588: If (p_rec.additional_wa_rate = hr_api.g_number) then

Line 588: If (p_rec.additional_wa_rate = hr_api.g_number) then

584: If (p_rec.business_group_id = hr_api.g_number) then
585: p_rec.business_group_id :=
586: pay_cty_shd.g_old_rec.business_group_id;
587: End If;
588: If (p_rec.additional_wa_rate = hr_api.g_number) then
589: p_rec.additional_wa_rate :=
590: pay_cty_shd.g_old_rec.additional_wa_rate;
591: End If;
592: If (p_rec.filing_status_code = hr_api.g_varchar2) then

Line 592: If (p_rec.filing_status_code = hr_api.g_varchar2) then

588: If (p_rec.additional_wa_rate = hr_api.g_number) then
589: p_rec.additional_wa_rate :=
590: pay_cty_shd.g_old_rec.additional_wa_rate;
591: End If;
592: If (p_rec.filing_status_code = hr_api.g_varchar2) then
593: p_rec.filing_status_code :=
594: pay_cty_shd.g_old_rec.filing_status_code;
595: End If;
596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then

Line 596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then

592: If (p_rec.filing_status_code = hr_api.g_varchar2) then
593: p_rec.filing_status_code :=
594: pay_cty_shd.g_old_rec.filing_status_code;
595: End If;
596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
597: p_rec.jurisdiction_code :=
598: pay_cty_shd.g_old_rec.jurisdiction_code;
599: End If;
600: If (p_rec.lit_additional_tax = hr_api.g_number) then

Line 600: If (p_rec.lit_additional_tax = hr_api.g_number) then

596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
597: p_rec.jurisdiction_code :=
598: pay_cty_shd.g_old_rec.jurisdiction_code;
599: End If;
600: If (p_rec.lit_additional_tax = hr_api.g_number) then
601: p_rec.lit_additional_tax :=
602: pay_cty_shd.g_old_rec.lit_additional_tax;
603: End If;
604: If (p_rec.lit_override_amount = hr_api.g_number) then

Line 604: If (p_rec.lit_override_amount = hr_api.g_number) then

600: If (p_rec.lit_additional_tax = hr_api.g_number) then
601: p_rec.lit_additional_tax :=
602: pay_cty_shd.g_old_rec.lit_additional_tax;
603: End If;
604: If (p_rec.lit_override_amount = hr_api.g_number) then
605: p_rec.lit_override_amount :=
606: pay_cty_shd.g_old_rec.lit_override_amount;
607: End If;
608: If (p_rec.lit_override_rate = hr_api.g_number) then

Line 608: If (p_rec.lit_override_rate = hr_api.g_number) then

604: If (p_rec.lit_override_amount = hr_api.g_number) then
605: p_rec.lit_override_amount :=
606: pay_cty_shd.g_old_rec.lit_override_amount;
607: End If;
608: If (p_rec.lit_override_rate = hr_api.g_number) then
609: p_rec.lit_override_rate :=
610: pay_cty_shd.g_old_rec.lit_override_rate;
611: End If;
612: If (p_rec.withholding_allowances = hr_api.g_number) then

Line 612: If (p_rec.withholding_allowances = hr_api.g_number) then

608: If (p_rec.lit_override_rate = hr_api.g_number) then
609: p_rec.lit_override_rate :=
610: pay_cty_shd.g_old_rec.lit_override_rate;
611: End If;
612: If (p_rec.withholding_allowances = hr_api.g_number) then
613: p_rec.withholding_allowances :=
614: pay_cty_shd.g_old_rec.withholding_allowances;
615: End If;
616: If (p_rec.lit_exempt = hr_api.g_varchar2) then

Line 616: If (p_rec.lit_exempt = hr_api.g_varchar2) then

612: If (p_rec.withholding_allowances = hr_api.g_number) then
613: p_rec.withholding_allowances :=
614: pay_cty_shd.g_old_rec.withholding_allowances;
615: End If;
616: If (p_rec.lit_exempt = hr_api.g_varchar2) then
617: p_rec.lit_exempt :=
618: pay_cty_shd.g_old_rec.lit_exempt;
619: End If;
620: If (p_rec.sd_exempt = hr_api.g_varchar2) then

Line 620: If (p_rec.sd_exempt = hr_api.g_varchar2) then

616: If (p_rec.lit_exempt = hr_api.g_varchar2) then
617: p_rec.lit_exempt :=
618: pay_cty_shd.g_old_rec.lit_exempt;
619: End If;
620: If (p_rec.sd_exempt = hr_api.g_varchar2) then
621: p_rec.sd_exempt :=
622: pay_cty_shd.g_old_rec.sd_exempt;
623: End If;
624: If (p_rec.ht_exempt = hr_api.g_varchar2) then

Line 624: If (p_rec.ht_exempt = hr_api.g_varchar2) then

620: If (p_rec.sd_exempt = hr_api.g_varchar2) then
621: p_rec.sd_exempt :=
622: pay_cty_shd.g_old_rec.sd_exempt;
623: End If;
624: If (p_rec.ht_exempt = hr_api.g_varchar2) then
625: p_rec.ht_exempt :=
626: pay_cty_shd.g_old_rec.ht_exempt;
627: End If;
628: If (p_rec.wage_exempt = hr_api.g_varchar2) then

Line 628: If (p_rec.wage_exempt = hr_api.g_varchar2) then

624: If (p_rec.ht_exempt = hr_api.g_varchar2) then
625: p_rec.ht_exempt :=
626: pay_cty_shd.g_old_rec.ht_exempt;
627: End If;
628: If (p_rec.wage_exempt = hr_api.g_varchar2) then
629: p_rec.wage_exempt :=
630: pay_cty_shd.g_old_rec.wage_exempt;
631: End If;
632: If (p_rec.school_district_code = hr_api.g_varchar2) then

Line 632: If (p_rec.school_district_code = hr_api.g_varchar2) then

628: If (p_rec.wage_exempt = hr_api.g_varchar2) then
629: p_rec.wage_exempt :=
630: pay_cty_shd.g_old_rec.wage_exempt;
631: End If;
632: If (p_rec.school_district_code = hr_api.g_varchar2) then
633: p_rec.school_district_code :=
634: pay_cty_shd.g_old_rec.school_district_code;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 636: If (p_rec.attribute_category = hr_api.g_varchar2) then

632: If (p_rec.school_district_code = hr_api.g_varchar2) then
633: p_rec.school_district_code :=
634: pay_cty_shd.g_old_rec.school_district_code;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: pay_cty_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 640: If (p_rec.attribute1 = hr_api.g_varchar2) then

636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: pay_cty_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: pay_cty_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 644: If (p_rec.attribute2 = hr_api.g_varchar2) then

640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: pay_cty_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: pay_cty_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 648: If (p_rec.attribute3 = hr_api.g_varchar2) then

644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: pay_cty_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: pay_cty_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 652: If (p_rec.attribute4 = hr_api.g_varchar2) then

648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: pay_cty_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: pay_cty_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 656: If (p_rec.attribute5 = hr_api.g_varchar2) then

652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: pay_cty_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: pay_cty_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 660: If (p_rec.attribute6 = hr_api.g_varchar2) then

656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: pay_cty_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: pay_cty_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 664: If (p_rec.attribute7 = hr_api.g_varchar2) then

660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: pay_cty_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: pay_cty_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 668: If (p_rec.attribute8 = hr_api.g_varchar2) then

664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: pay_cty_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: pay_cty_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 672: If (p_rec.attribute9 = hr_api.g_varchar2) then

668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: pay_cty_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: pay_cty_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 676: If (p_rec.attribute10 = hr_api.g_varchar2) then

672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: pay_cty_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: pay_cty_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 680: If (p_rec.attribute11 = hr_api.g_varchar2) then

676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: pay_cty_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: pay_cty_shd.g_old_rec.attribute11;
683: End If;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 684: If (p_rec.attribute12 = hr_api.g_varchar2) then

680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: pay_cty_shd.g_old_rec.attribute11;
683: End If;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: pay_cty_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 688: If (p_rec.attribute13 = hr_api.g_varchar2) then

684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: pay_cty_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: pay_cty_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 692: If (p_rec.attribute14 = hr_api.g_varchar2) then

688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: pay_cty_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: pay_cty_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 696: If (p_rec.attribute15 = hr_api.g_varchar2) then

692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: pay_cty_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: pay_cty_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 700: If (p_rec.attribute16 = hr_api.g_varchar2) then

696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: pay_cty_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: pay_cty_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 704: If (p_rec.attribute17 = hr_api.g_varchar2) then

700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: pay_cty_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: pay_cty_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: pay_cty_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: pay_cty_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 712: If (p_rec.attribute19 = hr_api.g_varchar2) then

708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: pay_cty_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: pay_cty_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 716: If (p_rec.attribute20 = hr_api.g_varchar2) then

712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: pay_cty_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: pay_cty_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 720: If (p_rec.attribute21 = hr_api.g_varchar2) then

716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: pay_cty_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.attribute21 = hr_api.g_varchar2) then
721: p_rec.attribute21 :=
722: pay_cty_shd.g_old_rec.attribute21;
723: End If;
724: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 724: If (p_rec.attribute22 = hr_api.g_varchar2) then

720: If (p_rec.attribute21 = hr_api.g_varchar2) then
721: p_rec.attribute21 :=
722: pay_cty_shd.g_old_rec.attribute21;
723: End If;
724: If (p_rec.attribute22 = hr_api.g_varchar2) then
725: p_rec.attribute22 :=
726: pay_cty_shd.g_old_rec.attribute22;
727: End If;
728: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 728: If (p_rec.attribute23 = hr_api.g_varchar2) then

724: If (p_rec.attribute22 = hr_api.g_varchar2) then
725: p_rec.attribute22 :=
726: pay_cty_shd.g_old_rec.attribute22;
727: End If;
728: If (p_rec.attribute23 = hr_api.g_varchar2) then
729: p_rec.attribute23 :=
730: pay_cty_shd.g_old_rec.attribute23;
731: End If;
732: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 732: If (p_rec.attribute24 = hr_api.g_varchar2) then

728: If (p_rec.attribute23 = hr_api.g_varchar2) then
729: p_rec.attribute23 :=
730: pay_cty_shd.g_old_rec.attribute23;
731: End If;
732: If (p_rec.attribute24 = hr_api.g_varchar2) then
733: p_rec.attribute24 :=
734: pay_cty_shd.g_old_rec.attribute24;
735: End If;
736: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 736: If (p_rec.attribute25 = hr_api.g_varchar2) then

732: If (p_rec.attribute24 = hr_api.g_varchar2) then
733: p_rec.attribute24 :=
734: pay_cty_shd.g_old_rec.attribute24;
735: End If;
736: If (p_rec.attribute25 = hr_api.g_varchar2) then
737: p_rec.attribute25 :=
738: pay_cty_shd.g_old_rec.attribute25;
739: End If;
740: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 740: If (p_rec.attribute26 = hr_api.g_varchar2) then

736: If (p_rec.attribute25 = hr_api.g_varchar2) then
737: p_rec.attribute25 :=
738: pay_cty_shd.g_old_rec.attribute25;
739: End If;
740: If (p_rec.attribute26 = hr_api.g_varchar2) then
741: p_rec.attribute26 :=
742: pay_cty_shd.g_old_rec.attribute26;
743: End If;
744: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 744: If (p_rec.attribute27 = hr_api.g_varchar2) then

740: If (p_rec.attribute26 = hr_api.g_varchar2) then
741: p_rec.attribute26 :=
742: pay_cty_shd.g_old_rec.attribute26;
743: End If;
744: If (p_rec.attribute27 = hr_api.g_varchar2) then
745: p_rec.attribute27 :=
746: pay_cty_shd.g_old_rec.attribute27;
747: End If;
748: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 748: If (p_rec.attribute28 = hr_api.g_varchar2) then

744: If (p_rec.attribute27 = hr_api.g_varchar2) then
745: p_rec.attribute27 :=
746: pay_cty_shd.g_old_rec.attribute27;
747: End If;
748: If (p_rec.attribute28 = hr_api.g_varchar2) then
749: p_rec.attribute28 :=
750: pay_cty_shd.g_old_rec.attribute28;
751: End If;
752: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 752: If (p_rec.attribute29 = hr_api.g_varchar2) then

748: If (p_rec.attribute28 = hr_api.g_varchar2) then
749: p_rec.attribute28 :=
750: pay_cty_shd.g_old_rec.attribute28;
751: End If;
752: If (p_rec.attribute29 = hr_api.g_varchar2) then
753: p_rec.attribute29 :=
754: pay_cty_shd.g_old_rec.attribute29;
755: End If;
756: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 756: If (p_rec.attribute30 = hr_api.g_varchar2) then

752: If (p_rec.attribute29 = hr_api.g_varchar2) then
753: p_rec.attribute29 :=
754: pay_cty_shd.g_old_rec.attribute29;
755: End If;
756: If (p_rec.attribute30 = hr_api.g_varchar2) then
757: p_rec.attribute30 :=
758: pay_cty_shd.g_old_rec.attribute30;
759: End If;
760: If (p_rec.cty_information_category = hr_api.g_varchar2) then

Line 760: If (p_rec.cty_information_category = hr_api.g_varchar2) then

756: If (p_rec.attribute30 = hr_api.g_varchar2) then
757: p_rec.attribute30 :=
758: pay_cty_shd.g_old_rec.attribute30;
759: End If;
760: If (p_rec.cty_information_category = hr_api.g_varchar2) then
761: p_rec.cty_information_category :=
762: pay_cty_shd.g_old_rec.cty_information_category;
763: End If;
764: If (p_rec.cty_information1 = hr_api.g_varchar2) then

Line 764: If (p_rec.cty_information1 = hr_api.g_varchar2) then

760: If (p_rec.cty_information_category = hr_api.g_varchar2) then
761: p_rec.cty_information_category :=
762: pay_cty_shd.g_old_rec.cty_information_category;
763: End If;
764: If (p_rec.cty_information1 = hr_api.g_varchar2) then
765: p_rec.cty_information1 :=
766: pay_cty_shd.g_old_rec.cty_information1;
767: End If;
768: If (p_rec.cty_information2 = hr_api.g_varchar2) then

Line 768: If (p_rec.cty_information2 = hr_api.g_varchar2) then

764: If (p_rec.cty_information1 = hr_api.g_varchar2) then
765: p_rec.cty_information1 :=
766: pay_cty_shd.g_old_rec.cty_information1;
767: End If;
768: If (p_rec.cty_information2 = hr_api.g_varchar2) then
769: p_rec.cty_information2 :=
770: pay_cty_shd.g_old_rec.cty_information2;
771: End If;
772: If (p_rec.cty_information3 = hr_api.g_varchar2) then

Line 772: If (p_rec.cty_information3 = hr_api.g_varchar2) then

768: If (p_rec.cty_information2 = hr_api.g_varchar2) then
769: p_rec.cty_information2 :=
770: pay_cty_shd.g_old_rec.cty_information2;
771: End If;
772: If (p_rec.cty_information3 = hr_api.g_varchar2) then
773: p_rec.cty_information3 :=
774: pay_cty_shd.g_old_rec.cty_information3;
775: End If;
776: If (p_rec.cty_information4 = hr_api.g_varchar2) then

Line 776: If (p_rec.cty_information4 = hr_api.g_varchar2) then

772: If (p_rec.cty_information3 = hr_api.g_varchar2) then
773: p_rec.cty_information3 :=
774: pay_cty_shd.g_old_rec.cty_information3;
775: End If;
776: If (p_rec.cty_information4 = hr_api.g_varchar2) then
777: p_rec.cty_information4 :=
778: pay_cty_shd.g_old_rec.cty_information4;
779: End If;
780: If (p_rec.cty_information5 = hr_api.g_varchar2) then

Line 780: If (p_rec.cty_information5 = hr_api.g_varchar2) then

776: If (p_rec.cty_information4 = hr_api.g_varchar2) then
777: p_rec.cty_information4 :=
778: pay_cty_shd.g_old_rec.cty_information4;
779: End If;
780: If (p_rec.cty_information5 = hr_api.g_varchar2) then
781: p_rec.cty_information5 :=
782: pay_cty_shd.g_old_rec.cty_information5;
783: End If;
784: If (p_rec.cty_information6 = hr_api.g_varchar2) then

Line 784: If (p_rec.cty_information6 = hr_api.g_varchar2) then

780: If (p_rec.cty_information5 = hr_api.g_varchar2) then
781: p_rec.cty_information5 :=
782: pay_cty_shd.g_old_rec.cty_information5;
783: End If;
784: If (p_rec.cty_information6 = hr_api.g_varchar2) then
785: p_rec.cty_information6 :=
786: pay_cty_shd.g_old_rec.cty_information6;
787: End If;
788: If (p_rec.cty_information7 = hr_api.g_varchar2) then

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

784: If (p_rec.cty_information6 = hr_api.g_varchar2) then
785: p_rec.cty_information6 :=
786: pay_cty_shd.g_old_rec.cty_information6;
787: End If;
788: If (p_rec.cty_information7 = hr_api.g_varchar2) then
789: p_rec.cty_information7 :=
790: pay_cty_shd.g_old_rec.cty_information7;
791: End If;
792: If (p_rec.cty_information8 = hr_api.g_varchar2) then

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

788: If (p_rec.cty_information7 = hr_api.g_varchar2) then
789: p_rec.cty_information7 :=
790: pay_cty_shd.g_old_rec.cty_information7;
791: End If;
792: If (p_rec.cty_information8 = hr_api.g_varchar2) then
793: p_rec.cty_information8 :=
794: pay_cty_shd.g_old_rec.cty_information8;
795: End If;
796: If (p_rec.cty_information9 = hr_api.g_varchar2) then

Line 796: If (p_rec.cty_information9 = hr_api.g_varchar2) then

792: If (p_rec.cty_information8 = hr_api.g_varchar2) then
793: p_rec.cty_information8 :=
794: pay_cty_shd.g_old_rec.cty_information8;
795: End If;
796: If (p_rec.cty_information9 = hr_api.g_varchar2) then
797: p_rec.cty_information9 :=
798: pay_cty_shd.g_old_rec.cty_information9;
799: End If;
800: If (p_rec.cty_information10 = hr_api.g_varchar2) then

Line 800: If (p_rec.cty_information10 = hr_api.g_varchar2) then

796: If (p_rec.cty_information9 = hr_api.g_varchar2) then
797: p_rec.cty_information9 :=
798: pay_cty_shd.g_old_rec.cty_information9;
799: End If;
800: If (p_rec.cty_information10 = hr_api.g_varchar2) then
801: p_rec.cty_information10 :=
802: pay_cty_shd.g_old_rec.cty_information10;
803: End If;
804: If (p_rec.cty_information11 = hr_api.g_varchar2) then

Line 804: If (p_rec.cty_information11 = hr_api.g_varchar2) then

800: If (p_rec.cty_information10 = hr_api.g_varchar2) then
801: p_rec.cty_information10 :=
802: pay_cty_shd.g_old_rec.cty_information10;
803: End If;
804: If (p_rec.cty_information11 = hr_api.g_varchar2) then
805: p_rec.cty_information11 :=
806: pay_cty_shd.g_old_rec.cty_information11;
807: End If;
808: If (p_rec.cty_information12 = hr_api.g_varchar2) then

Line 808: If (p_rec.cty_information12 = hr_api.g_varchar2) then

804: If (p_rec.cty_information11 = hr_api.g_varchar2) then
805: p_rec.cty_information11 :=
806: pay_cty_shd.g_old_rec.cty_information11;
807: End If;
808: If (p_rec.cty_information12 = hr_api.g_varchar2) then
809: p_rec.cty_information12 :=
810: pay_cty_shd.g_old_rec.cty_information12;
811: End If;
812: If (p_rec.cty_information13 = hr_api.g_varchar2) then

Line 812: If (p_rec.cty_information13 = hr_api.g_varchar2) then

808: If (p_rec.cty_information12 = hr_api.g_varchar2) then
809: p_rec.cty_information12 :=
810: pay_cty_shd.g_old_rec.cty_information12;
811: End If;
812: If (p_rec.cty_information13 = hr_api.g_varchar2) then
813: p_rec.cty_information13 :=
814: pay_cty_shd.g_old_rec.cty_information13;
815: End If;
816: If (p_rec.cty_information14 = hr_api.g_varchar2) then

Line 816: If (p_rec.cty_information14 = hr_api.g_varchar2) then

812: If (p_rec.cty_information13 = hr_api.g_varchar2) then
813: p_rec.cty_information13 :=
814: pay_cty_shd.g_old_rec.cty_information13;
815: End If;
816: If (p_rec.cty_information14 = hr_api.g_varchar2) then
817: p_rec.cty_information14 :=
818: pay_cty_shd.g_old_rec.cty_information14;
819: End If;
820: If (p_rec.cty_information15 = hr_api.g_varchar2) then

Line 820: If (p_rec.cty_information15 = hr_api.g_varchar2) then

816: If (p_rec.cty_information14 = hr_api.g_varchar2) then
817: p_rec.cty_information14 :=
818: pay_cty_shd.g_old_rec.cty_information14;
819: End If;
820: If (p_rec.cty_information15 = hr_api.g_varchar2) then
821: p_rec.cty_information15 :=
822: pay_cty_shd.g_old_rec.cty_information15;
823: End If;
824: If (p_rec.cty_information16 = hr_api.g_varchar2) then

Line 824: If (p_rec.cty_information16 = hr_api.g_varchar2) then

820: If (p_rec.cty_information15 = hr_api.g_varchar2) then
821: p_rec.cty_information15 :=
822: pay_cty_shd.g_old_rec.cty_information15;
823: End If;
824: If (p_rec.cty_information16 = hr_api.g_varchar2) then
825: p_rec.cty_information16 :=
826: pay_cty_shd.g_old_rec.cty_information16;
827: End If;
828: If (p_rec.cty_information17 = hr_api.g_varchar2) then

Line 828: If (p_rec.cty_information17 = hr_api.g_varchar2) then

824: If (p_rec.cty_information16 = hr_api.g_varchar2) then
825: p_rec.cty_information16 :=
826: pay_cty_shd.g_old_rec.cty_information16;
827: End If;
828: If (p_rec.cty_information17 = hr_api.g_varchar2) then
829: p_rec.cty_information17 :=
830: pay_cty_shd.g_old_rec.cty_information17;
831: End If;
832: If (p_rec.cty_information18 = hr_api.g_varchar2) then

Line 832: If (p_rec.cty_information18 = hr_api.g_varchar2) then

828: If (p_rec.cty_information17 = hr_api.g_varchar2) then
829: p_rec.cty_information17 :=
830: pay_cty_shd.g_old_rec.cty_information17;
831: End If;
832: If (p_rec.cty_information18 = hr_api.g_varchar2) then
833: p_rec.cty_information18 :=
834: pay_cty_shd.g_old_rec.cty_information18;
835: End If;
836: If (p_rec.cty_information19 = hr_api.g_varchar2) then

Line 836: If (p_rec.cty_information19 = hr_api.g_varchar2) then

832: If (p_rec.cty_information18 = hr_api.g_varchar2) then
833: p_rec.cty_information18 :=
834: pay_cty_shd.g_old_rec.cty_information18;
835: End If;
836: If (p_rec.cty_information19 = hr_api.g_varchar2) then
837: p_rec.cty_information19 :=
838: pay_cty_shd.g_old_rec.cty_information19;
839: End If;
840: If (p_rec.cty_information20 = hr_api.g_varchar2) then

Line 840: If (p_rec.cty_information20 = hr_api.g_varchar2) then

836: If (p_rec.cty_information19 = hr_api.g_varchar2) then
837: p_rec.cty_information19 :=
838: pay_cty_shd.g_old_rec.cty_information19;
839: End If;
840: If (p_rec.cty_information20 = hr_api.g_varchar2) then
841: p_rec.cty_information20 :=
842: pay_cty_shd.g_old_rec.cty_information20;
843: End If;
844: If (p_rec.cty_information21 = hr_api.g_varchar2) then

Line 844: If (p_rec.cty_information21 = hr_api.g_varchar2) then

840: If (p_rec.cty_information20 = hr_api.g_varchar2) then
841: p_rec.cty_information20 :=
842: pay_cty_shd.g_old_rec.cty_information20;
843: End If;
844: If (p_rec.cty_information21 = hr_api.g_varchar2) then
845: p_rec.cty_information21 :=
846: pay_cty_shd.g_old_rec.cty_information21;
847: End If;
848: If (p_rec.cty_information22 = hr_api.g_varchar2) then

Line 848: If (p_rec.cty_information22 = hr_api.g_varchar2) then

844: If (p_rec.cty_information21 = hr_api.g_varchar2) then
845: p_rec.cty_information21 :=
846: pay_cty_shd.g_old_rec.cty_information21;
847: End If;
848: If (p_rec.cty_information22 = hr_api.g_varchar2) then
849: p_rec.cty_information22 :=
850: pay_cty_shd.g_old_rec.cty_information22;
851: End If;
852: If (p_rec.cty_information23 = hr_api.g_varchar2) then

Line 852: If (p_rec.cty_information23 = hr_api.g_varchar2) then

848: If (p_rec.cty_information22 = hr_api.g_varchar2) then
849: p_rec.cty_information22 :=
850: pay_cty_shd.g_old_rec.cty_information22;
851: End If;
852: If (p_rec.cty_information23 = hr_api.g_varchar2) then
853: p_rec.cty_information23 :=
854: pay_cty_shd.g_old_rec.cty_information23;
855: End If;
856: If (p_rec.cty_information24 = hr_api.g_varchar2) then

Line 856: If (p_rec.cty_information24 = hr_api.g_varchar2) then

852: If (p_rec.cty_information23 = hr_api.g_varchar2) then
853: p_rec.cty_information23 :=
854: pay_cty_shd.g_old_rec.cty_information23;
855: End If;
856: If (p_rec.cty_information24 = hr_api.g_varchar2) then
857: p_rec.cty_information24 :=
858: pay_cty_shd.g_old_rec.cty_information24;
859: End If;
860: If (p_rec.cty_information25 = hr_api.g_varchar2) then

Line 860: If (p_rec.cty_information25 = hr_api.g_varchar2) then

856: If (p_rec.cty_information24 = hr_api.g_varchar2) then
857: p_rec.cty_information24 :=
858: pay_cty_shd.g_old_rec.cty_information24;
859: End If;
860: If (p_rec.cty_information25 = hr_api.g_varchar2) then
861: p_rec.cty_information25 :=
862: pay_cty_shd.g_old_rec.cty_information25;
863: End If;
864: If (p_rec.cty_information26 = hr_api.g_varchar2) then

Line 864: If (p_rec.cty_information26 = hr_api.g_varchar2) then

860: If (p_rec.cty_information25 = hr_api.g_varchar2) then
861: p_rec.cty_information25 :=
862: pay_cty_shd.g_old_rec.cty_information25;
863: End If;
864: If (p_rec.cty_information26 = hr_api.g_varchar2) then
865: p_rec.cty_information26 :=
866: pay_cty_shd.g_old_rec.cty_information26;
867: End If;
868: If (p_rec.cty_information27 = hr_api.g_varchar2) then

Line 868: If (p_rec.cty_information27 = hr_api.g_varchar2) then

864: If (p_rec.cty_information26 = hr_api.g_varchar2) then
865: p_rec.cty_information26 :=
866: pay_cty_shd.g_old_rec.cty_information26;
867: End If;
868: If (p_rec.cty_information27 = hr_api.g_varchar2) then
869: p_rec.cty_information27 :=
870: pay_cty_shd.g_old_rec.cty_information27;
871: End If;
872: If (p_rec.cty_information28 = hr_api.g_varchar2) then

Line 872: If (p_rec.cty_information28 = hr_api.g_varchar2) then

868: If (p_rec.cty_information27 = hr_api.g_varchar2) then
869: p_rec.cty_information27 :=
870: pay_cty_shd.g_old_rec.cty_information27;
871: End If;
872: If (p_rec.cty_information28 = hr_api.g_varchar2) then
873: p_rec.cty_information28 :=
874: pay_cty_shd.g_old_rec.cty_information28;
875: End If;
876: If (p_rec.cty_information29 = hr_api.g_varchar2) then

Line 876: If (p_rec.cty_information29 = hr_api.g_varchar2) then

872: If (p_rec.cty_information28 = hr_api.g_varchar2) then
873: p_rec.cty_information28 :=
874: pay_cty_shd.g_old_rec.cty_information28;
875: End If;
876: If (p_rec.cty_information29 = hr_api.g_varchar2) then
877: p_rec.cty_information29 :=
878: pay_cty_shd.g_old_rec.cty_information29;
879: End If;
880: If (p_rec.cty_information30 = hr_api.g_varchar2) then

Line 880: If (p_rec.cty_information30 = hr_api.g_varchar2) then

876: If (p_rec.cty_information29 = hr_api.g_varchar2) then
877: p_rec.cty_information29 :=
878: pay_cty_shd.g_old_rec.cty_information29;
879: End If;
880: If (p_rec.cty_information30 = hr_api.g_varchar2) then
881: p_rec.cty_information30 :=
882: pay_cty_shd.g_old_rec.cty_information30;
883: End If;
884:

Line 985: p_attribute_category in varchar2 default hr_api.g_varchar2,

981: p_school_district_code in varchar2,
982: p_object_version_number in out nocopy number,
983: p_effective_date in date,
984: p_datetrack_mode in varchar2,
985: p_attribute_category in varchar2 default hr_api.g_varchar2,
986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 986: p_attribute1 in varchar2 default hr_api.g_varchar2,

982: p_object_version_number in out nocopy number,
983: p_effective_date in date,
984: p_datetrack_mode in varchar2,
985: p_attribute_category in varchar2 default hr_api.g_varchar2,
986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 987: p_attribute2 in varchar2 default hr_api.g_varchar2,

983: p_effective_date in date,
984: p_datetrack_mode in varchar2,
985: p_attribute_category in varchar2 default hr_api.g_varchar2,
986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 988: p_attribute3 in varchar2 default hr_api.g_varchar2,

984: p_datetrack_mode in varchar2,
985: p_attribute_category in varchar2 default hr_api.g_varchar2,
986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 989: p_attribute4 in varchar2 default hr_api.g_varchar2,

985: p_attribute_category in varchar2 default hr_api.g_varchar2,
986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 990: p_attribute5 in varchar2 default hr_api.g_varchar2,

986: p_attribute1 in varchar2 default hr_api.g_varchar2,
987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 991: p_attribute6 in varchar2 default hr_api.g_varchar2,

987: p_attribute2 in varchar2 default hr_api.g_varchar2,
988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 992: p_attribute7 in varchar2 default hr_api.g_varchar2,

988: p_attribute3 in varchar2 default hr_api.g_varchar2,
989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 993: p_attribute8 in varchar2 default hr_api.g_varchar2,

989: p_attribute4 in varchar2 default hr_api.g_varchar2,
990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 994: p_attribute9 in varchar2 default hr_api.g_varchar2,

990: p_attribute5 in varchar2 default hr_api.g_varchar2,
991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 995: p_attribute10 in varchar2 default hr_api.g_varchar2,

991: p_attribute6 in varchar2 default hr_api.g_varchar2,
992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 996: p_attribute11 in varchar2 default hr_api.g_varchar2,

992: p_attribute7 in varchar2 default hr_api.g_varchar2,
993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 997: p_attribute12 in varchar2 default hr_api.g_varchar2,

993: p_attribute8 in varchar2 default hr_api.g_varchar2,
994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 998: p_attribute13 in varchar2 default hr_api.g_varchar2,

994: p_attribute9 in varchar2 default hr_api.g_varchar2,
995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 999: p_attribute14 in varchar2 default hr_api.g_varchar2,

995: p_attribute10 in varchar2 default hr_api.g_varchar2,
996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 1000: p_attribute15 in varchar2 default hr_api.g_varchar2,

996: p_attribute11 in varchar2 default hr_api.g_varchar2,
997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 1001: p_attribute16 in varchar2 default hr_api.g_varchar2,

997: p_attribute12 in varchar2 default hr_api.g_varchar2,
998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 1002: p_attribute17 in varchar2 default hr_api.g_varchar2,

998: p_attribute13 in varchar2 default hr_api.g_varchar2,
999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 1003: p_attribute18 in varchar2 default hr_api.g_varchar2,

999: p_attribute14 in varchar2 default hr_api.g_varchar2,
1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 1004: p_attribute19 in varchar2 default hr_api.g_varchar2,

1000: p_attribute15 in varchar2 default hr_api.g_varchar2,
1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 1005: p_attribute20 in varchar2 default hr_api.g_varchar2,

1001: p_attribute16 in varchar2 default hr_api.g_varchar2,
1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 1006: p_attribute21 in varchar2 default hr_api.g_varchar2,

1002: p_attribute17 in varchar2 default hr_api.g_varchar2,
1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 1007: p_attribute22 in varchar2 default hr_api.g_varchar2,

1003: p_attribute18 in varchar2 default hr_api.g_varchar2,
1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 1008: p_attribute23 in varchar2 default hr_api.g_varchar2,

1004: p_attribute19 in varchar2 default hr_api.g_varchar2,
1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 1009: p_attribute24 in varchar2 default hr_api.g_varchar2,

1005: p_attribute20 in varchar2 default hr_api.g_varchar2,
1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 1010: p_attribute25 in varchar2 default hr_api.g_varchar2,

1006: p_attribute21 in varchar2 default hr_api.g_varchar2,
1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 1011: p_attribute26 in varchar2 default hr_api.g_varchar2,

1007: p_attribute22 in varchar2 default hr_api.g_varchar2,
1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 1012: p_attribute27 in varchar2 default hr_api.g_varchar2,

1008: p_attribute23 in varchar2 default hr_api.g_varchar2,
1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,

Line 1013: p_attribute28 in varchar2 default hr_api.g_varchar2,

1009: p_attribute24 in varchar2 default hr_api.g_varchar2,
1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,

Line 1014: p_attribute29 in varchar2 default hr_api.g_varchar2,

1010: p_attribute25 in varchar2 default hr_api.g_varchar2,
1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,

Line 1015: p_attribute30 in varchar2 default hr_api.g_varchar2,

1011: p_attribute26 in varchar2 default hr_api.g_varchar2,
1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,

Line 1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,

1012: p_attribute27 in varchar2 default hr_api.g_varchar2,
1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,

Line 1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,

1013: p_attribute28 in varchar2 default hr_api.g_varchar2,
1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,

Line 1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,

1014: p_attribute29 in varchar2 default hr_api.g_varchar2,
1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,

Line 1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,

1015: p_attribute30 in varchar2 default hr_api.g_varchar2,
1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,

Line 1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,

1016: p_cty_information_category in varchar2 default hr_api.g_varchar2,
1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,

Line 1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,

1017: p_cty_information1 in varchar2 default hr_api.g_varchar2,
1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,

Line 1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,

1018: p_cty_information2 in varchar2 default hr_api.g_varchar2,
1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,

Line 1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,

1019: p_cty_information3 in varchar2 default hr_api.g_varchar2,
1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,

Line 1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,

1020: p_cty_information4 in varchar2 default hr_api.g_varchar2,
1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,

Line 1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,

1021: p_cty_information5 in varchar2 default hr_api.g_varchar2,
1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,

Line 1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,

1022: p_cty_information6 in varchar2 default hr_api.g_varchar2,
1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,

Line 1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,

1023: p_cty_information7 in varchar2 default hr_api.g_varchar2,
1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,

Line 1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,

1024: p_cty_information8 in varchar2 default hr_api.g_varchar2,
1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,

Line 1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,

1025: p_cty_information9 in varchar2 default hr_api.g_varchar2,
1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,

Line 1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,

1026: p_cty_information10 in varchar2 default hr_api.g_varchar2,
1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,

Line 1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,

1027: p_cty_information11 in varchar2 default hr_api.g_varchar2,
1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,

Line 1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,

1028: p_cty_information12 in varchar2 default hr_api.g_varchar2,
1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,

Line 1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,

1029: p_cty_information13 in varchar2 default hr_api.g_varchar2,
1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,

Line 1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,

1030: p_cty_information14 in varchar2 default hr_api.g_varchar2,
1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,

Line 1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,

1031: p_cty_information15 in varchar2 default hr_api.g_varchar2,
1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,

Line 1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,

1032: p_cty_information16 in varchar2 default hr_api.g_varchar2,
1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,

Line 1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,

1033: p_cty_information17 in varchar2 default hr_api.g_varchar2,
1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,

Line 1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,

1034: p_cty_information18 in varchar2 default hr_api.g_varchar2,
1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,

Line 1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,

1035: p_cty_information19 in varchar2 default hr_api.g_varchar2,
1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,

Line 1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,

1036: p_cty_information20 in varchar2 default hr_api.g_varchar2,
1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,

Line 1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,

1037: p_cty_information21 in varchar2 default hr_api.g_varchar2,
1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,

Line 1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,

1038: p_cty_information22 in varchar2 default hr_api.g_varchar2,
1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2

Line 1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,

1039: p_cty_information23 in varchar2 default hr_api.g_varchar2,
1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2
1047: ) is

Line 1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,

1040: p_cty_information24 in varchar2 default hr_api.g_varchar2,
1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --

Line 1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,

1041: p_cty_information25 in varchar2 default hr_api.g_varchar2,
1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec pay_cty_shd.g_rec_type;

Line 1046: p_cty_information30 in varchar2 default hr_api.g_varchar2

1042: p_cty_information26 in varchar2 default hr_api.g_varchar2,
1043: p_cty_information27 in varchar2 default hr_api.g_varchar2,
1044: p_cty_information28 in varchar2 default hr_api.g_varchar2,
1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec pay_cty_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';

Line 1062: hr_api.g_date,

1058: l_rec :=
1059: pay_cty_shd.convert_args
1060: (
1061: p_emp_city_tax_rule_id,
1062: hr_api.g_date,
1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */

Line 1063: hr_api.g_date,

1059: pay_cty_shd.convert_args
1060: (
1061: p_emp_city_tax_rule_id,
1062: hr_api.g_date,
1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */

Line 1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */

1060: (
1061: p_emp_city_tax_rule_id,
1062: hr_api.g_date,
1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */

Line 1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */

1061: p_emp_city_tax_rule_id,
1062: hr_api.g_date,
1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */
1069: p_additional_wa_rate,

Line 1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */

1062: hr_api.g_date,
1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */
1069: p_additional_wa_rate,
1070: p_filing_status_code,

Line 1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */

1063: hr_api.g_date,
1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */
1069: p_additional_wa_rate,
1070: p_filing_status_code,
1071: hr_api.g_varchar2, -- p_jurisdiction_code,

Line 1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */

1064: hr_api.g_number, --/* DFGII 30 Sep 97 p_assignment_id, */
1065: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_state_code, */
1066: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_county_code, */
1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */
1069: p_additional_wa_rate,
1070: p_filing_status_code,
1071: hr_api.g_varchar2, -- p_jurisdiction_code,
1072: p_lit_additional_tax,

Line 1071: hr_api.g_varchar2, -- p_jurisdiction_code,

1067: hr_api.g_varchar2, --/* DFGII 30 Sep 97 p_city_code, */
1068: hr_api.g_number, --/* DFGII 30 Sep 97 p_business_group_id, */
1069: p_additional_wa_rate,
1070: p_filing_status_code,
1071: hr_api.g_varchar2, -- p_jurisdiction_code,
1072: p_lit_additional_tax,
1073: p_lit_override_amount,
1074: p_lit_override_rate,
1075: p_withholding_allowances,