157: End If;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 15);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
162: -- A check constraint has been violated
163: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End dt_update_dml;
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
556: --
557: exception
558: --
559: when hr_api.cannot_find_prog_unit then
560: --
561: hr_api.cannot_find_prog_unit_error
562: (p_module_name => 'ben_clpse_lf_evt_f'
563: ,p_hook_type => 'AU');
557: exception
558: --
559: when hr_api.cannot_find_prog_unit then
560: --
561: hr_api.cannot_find_prog_unit_error
562: (p_module_name => 'ben_clpse_lf_evt_f'
563: ,p_hook_type => 'AU');
564: --
565: end;
626: -- p_rec plsql record structure
627: -- to see if a system default is being used. If a system default
628: -- is being used then we must set to the 'current' argument value.
629: --
630: If (p_rec.business_group_id = hr_api.g_number) then
631: p_rec.business_group_id :=
632: ben_clp_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.seq = hr_api.g_number) then
630: If (p_rec.business_group_id = hr_api.g_number) then
631: p_rec.business_group_id :=
632: ben_clp_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.seq = hr_api.g_number) then
635: p_rec.seq :=
636: ben_clp_shd.g_old_rec.seq;
637: End If;
638: If (p_rec.ler1_id = hr_api.g_number) then
634: If (p_rec.seq = hr_api.g_number) then
635: p_rec.seq :=
636: ben_clp_shd.g_old_rec.seq;
637: End If;
638: If (p_rec.ler1_id = hr_api.g_number) then
639: p_rec.ler1_id :=
640: ben_clp_shd.g_old_rec.ler1_id;
641: End If;
642: If (p_rec.bool1_cd = hr_api.g_varchar2) then
638: If (p_rec.ler1_id = hr_api.g_number) then
639: p_rec.ler1_id :=
640: ben_clp_shd.g_old_rec.ler1_id;
641: End If;
642: If (p_rec.bool1_cd = hr_api.g_varchar2) then
643: p_rec.bool1_cd :=
644: ben_clp_shd.g_old_rec.bool1_cd;
645: End If;
646: If (p_rec.ler2_id = hr_api.g_number) then
642: If (p_rec.bool1_cd = hr_api.g_varchar2) then
643: p_rec.bool1_cd :=
644: ben_clp_shd.g_old_rec.bool1_cd;
645: End If;
646: If (p_rec.ler2_id = hr_api.g_number) then
647: p_rec.ler2_id :=
648: ben_clp_shd.g_old_rec.ler2_id;
649: End If;
650: If (p_rec.bool2_cd = hr_api.g_varchar2) then
646: If (p_rec.ler2_id = hr_api.g_number) then
647: p_rec.ler2_id :=
648: ben_clp_shd.g_old_rec.ler2_id;
649: End If;
650: If (p_rec.bool2_cd = hr_api.g_varchar2) then
651: p_rec.bool2_cd :=
652: ben_clp_shd.g_old_rec.bool2_cd;
653: End If;
654: If (p_rec.ler3_id = hr_api.g_number) then
650: If (p_rec.bool2_cd = hr_api.g_varchar2) then
651: p_rec.bool2_cd :=
652: ben_clp_shd.g_old_rec.bool2_cd;
653: End If;
654: If (p_rec.ler3_id = hr_api.g_number) then
655: p_rec.ler3_id :=
656: ben_clp_shd.g_old_rec.ler3_id;
657: End If;
658: If (p_rec.bool3_cd = hr_api.g_varchar2) then
654: If (p_rec.ler3_id = hr_api.g_number) then
655: p_rec.ler3_id :=
656: ben_clp_shd.g_old_rec.ler3_id;
657: End If;
658: If (p_rec.bool3_cd = hr_api.g_varchar2) then
659: p_rec.bool3_cd :=
660: ben_clp_shd.g_old_rec.bool3_cd;
661: End If;
662: If (p_rec.ler4_id = hr_api.g_number) then
658: If (p_rec.bool3_cd = hr_api.g_varchar2) then
659: p_rec.bool3_cd :=
660: ben_clp_shd.g_old_rec.bool3_cd;
661: End If;
662: If (p_rec.ler4_id = hr_api.g_number) then
663: p_rec.ler4_id :=
664: ben_clp_shd.g_old_rec.ler4_id;
665: End If;
666: If (p_rec.bool4_cd = hr_api.g_varchar2) then
662: If (p_rec.ler4_id = hr_api.g_number) then
663: p_rec.ler4_id :=
664: ben_clp_shd.g_old_rec.ler4_id;
665: End If;
666: If (p_rec.bool4_cd = hr_api.g_varchar2) then
667: p_rec.bool4_cd :=
668: ben_clp_shd.g_old_rec.bool4_cd;
669: End If;
670: If (p_rec.ler5_id = hr_api.g_number) then
666: If (p_rec.bool4_cd = hr_api.g_varchar2) then
667: p_rec.bool4_cd :=
668: ben_clp_shd.g_old_rec.bool4_cd;
669: End If;
670: If (p_rec.ler5_id = hr_api.g_number) then
671: p_rec.ler5_id :=
672: ben_clp_shd.g_old_rec.ler5_id;
673: End If;
674: If (p_rec.bool5_cd = hr_api.g_varchar2) then
670: If (p_rec.ler5_id = hr_api.g_number) then
671: p_rec.ler5_id :=
672: ben_clp_shd.g_old_rec.ler5_id;
673: End If;
674: If (p_rec.bool5_cd = hr_api.g_varchar2) then
675: p_rec.bool5_cd :=
676: ben_clp_shd.g_old_rec.bool5_cd;
677: End If;
678: If (p_rec.ler6_id = hr_api.g_number) then
674: If (p_rec.bool5_cd = hr_api.g_varchar2) then
675: p_rec.bool5_cd :=
676: ben_clp_shd.g_old_rec.bool5_cd;
677: End If;
678: If (p_rec.ler6_id = hr_api.g_number) then
679: p_rec.ler6_id :=
680: ben_clp_shd.g_old_rec.ler6_id;
681: End If;
682: If (p_rec.bool6_cd = hr_api.g_varchar2) then
678: If (p_rec.ler6_id = hr_api.g_number) then
679: p_rec.ler6_id :=
680: ben_clp_shd.g_old_rec.ler6_id;
681: End If;
682: If (p_rec.bool6_cd = hr_api.g_varchar2) then
683: p_rec.bool6_cd :=
684: ben_clp_shd.g_old_rec.bool6_cd;
685: End If;
686: If (p_rec.ler7_id = hr_api.g_number) then
682: If (p_rec.bool6_cd = hr_api.g_varchar2) then
683: p_rec.bool6_cd :=
684: ben_clp_shd.g_old_rec.bool6_cd;
685: End If;
686: If (p_rec.ler7_id = hr_api.g_number) then
687: p_rec.ler7_id :=
688: ben_clp_shd.g_old_rec.ler7_id;
689: End If;
690: If (p_rec.bool7_cd = hr_api.g_varchar2) then
686: If (p_rec.ler7_id = hr_api.g_number) then
687: p_rec.ler7_id :=
688: ben_clp_shd.g_old_rec.ler7_id;
689: End If;
690: If (p_rec.bool7_cd = hr_api.g_varchar2) then
691: p_rec.bool7_cd :=
692: ben_clp_shd.g_old_rec.bool7_cd;
693: End If;
694: If (p_rec.ler8_id = hr_api.g_number) then
690: If (p_rec.bool7_cd = hr_api.g_varchar2) then
691: p_rec.bool7_cd :=
692: ben_clp_shd.g_old_rec.bool7_cd;
693: End If;
694: If (p_rec.ler8_id = hr_api.g_number) then
695: p_rec.ler8_id :=
696: ben_clp_shd.g_old_rec.ler8_id;
697: End If;
698: If (p_rec.bool8_cd = hr_api.g_varchar2) then
694: If (p_rec.ler8_id = hr_api.g_number) then
695: p_rec.ler8_id :=
696: ben_clp_shd.g_old_rec.ler8_id;
697: End If;
698: If (p_rec.bool8_cd = hr_api.g_varchar2) then
699: p_rec.bool8_cd :=
700: ben_clp_shd.g_old_rec.bool8_cd;
701: End If;
702: If (p_rec.ler9_id = hr_api.g_number) then
698: If (p_rec.bool8_cd = hr_api.g_varchar2) then
699: p_rec.bool8_cd :=
700: ben_clp_shd.g_old_rec.bool8_cd;
701: End If;
702: If (p_rec.ler9_id = hr_api.g_number) then
703: p_rec.ler9_id :=
704: ben_clp_shd.g_old_rec.ler9_id;
705: End If;
706: If (p_rec.bool9_cd = hr_api.g_varchar2) then
702: If (p_rec.ler9_id = hr_api.g_number) then
703: p_rec.ler9_id :=
704: ben_clp_shd.g_old_rec.ler9_id;
705: End If;
706: If (p_rec.bool9_cd = hr_api.g_varchar2) then
707: p_rec.bool9_cd :=
708: ben_clp_shd.g_old_rec.bool9_cd;
709: End If;
710: If (p_rec.ler10_id = hr_api.g_number) then
706: If (p_rec.bool9_cd = hr_api.g_varchar2) then
707: p_rec.bool9_cd :=
708: ben_clp_shd.g_old_rec.bool9_cd;
709: End If;
710: If (p_rec.ler10_id = hr_api.g_number) then
711: p_rec.ler10_id :=
712: ben_clp_shd.g_old_rec.ler10_id;
713: End If;
714: If (p_rec.eval_cd = hr_api.g_varchar2) then
710: If (p_rec.ler10_id = hr_api.g_number) then
711: p_rec.ler10_id :=
712: ben_clp_shd.g_old_rec.ler10_id;
713: End If;
714: If (p_rec.eval_cd = hr_api.g_varchar2) then
715: p_rec.eval_cd :=
716: ben_clp_shd.g_old_rec.eval_cd;
717: End If;
718: If (p_rec.eval_rl = hr_api.g_number) then
714: If (p_rec.eval_cd = hr_api.g_varchar2) then
715: p_rec.eval_cd :=
716: ben_clp_shd.g_old_rec.eval_cd;
717: End If;
718: If (p_rec.eval_rl = hr_api.g_number) then
719: p_rec.eval_rl :=
720: ben_clp_shd.g_old_rec.eval_rl;
721: End If;
722: If (p_rec.tlrnc_dys_num = hr_api.g_number) then
718: If (p_rec.eval_rl = hr_api.g_number) then
719: p_rec.eval_rl :=
720: ben_clp_shd.g_old_rec.eval_rl;
721: End If;
722: If (p_rec.tlrnc_dys_num = hr_api.g_number) then
723: p_rec.tlrnc_dys_num :=
724: ben_clp_shd.g_old_rec.tlrnc_dys_num;
725: End If;
726: If (p_rec.eval_ler_id = hr_api.g_number) then
722: If (p_rec.tlrnc_dys_num = hr_api.g_number) then
723: p_rec.tlrnc_dys_num :=
724: ben_clp_shd.g_old_rec.tlrnc_dys_num;
725: End If;
726: If (p_rec.eval_ler_id = hr_api.g_number) then
727: p_rec.eval_ler_id :=
728: ben_clp_shd.g_old_rec.eval_ler_id;
729: End If;
730: If (p_rec.eval_ler_det_cd = hr_api.g_varchar2) then
726: If (p_rec.eval_ler_id = hr_api.g_number) then
727: p_rec.eval_ler_id :=
728: ben_clp_shd.g_old_rec.eval_ler_id;
729: End If;
730: If (p_rec.eval_ler_det_cd = hr_api.g_varchar2) then
731: p_rec.eval_ler_det_cd :=
732: ben_clp_shd.g_old_rec.eval_ler_det_cd;
733: End If;
734: If (p_rec.eval_ler_det_rl = hr_api.g_number) then
730: If (p_rec.eval_ler_det_cd = hr_api.g_varchar2) then
731: p_rec.eval_ler_det_cd :=
732: ben_clp_shd.g_old_rec.eval_ler_det_cd;
733: End If;
734: If (p_rec.eval_ler_det_rl = hr_api.g_number) then
735: p_rec.eval_ler_det_rl :=
736: ben_clp_shd.g_old_rec.eval_ler_det_rl;
737: End If;
738: If (p_rec.clp_attribute_category = hr_api.g_varchar2) then
734: If (p_rec.eval_ler_det_rl = hr_api.g_number) then
735: p_rec.eval_ler_det_rl :=
736: ben_clp_shd.g_old_rec.eval_ler_det_rl;
737: End If;
738: If (p_rec.clp_attribute_category = hr_api.g_varchar2) then
739: p_rec.clp_attribute_category :=
740: ben_clp_shd.g_old_rec.clp_attribute_category;
741: End If;
742: If (p_rec.clp_attribute1 = hr_api.g_varchar2) then
738: If (p_rec.clp_attribute_category = hr_api.g_varchar2) then
739: p_rec.clp_attribute_category :=
740: ben_clp_shd.g_old_rec.clp_attribute_category;
741: End If;
742: If (p_rec.clp_attribute1 = hr_api.g_varchar2) then
743: p_rec.clp_attribute1 :=
744: ben_clp_shd.g_old_rec.clp_attribute1;
745: End If;
746: If (p_rec.clp_attribute2 = hr_api.g_varchar2) then
742: If (p_rec.clp_attribute1 = hr_api.g_varchar2) then
743: p_rec.clp_attribute1 :=
744: ben_clp_shd.g_old_rec.clp_attribute1;
745: End If;
746: If (p_rec.clp_attribute2 = hr_api.g_varchar2) then
747: p_rec.clp_attribute2 :=
748: ben_clp_shd.g_old_rec.clp_attribute2;
749: End If;
750: If (p_rec.clp_attribute3 = hr_api.g_varchar2) then
746: If (p_rec.clp_attribute2 = hr_api.g_varchar2) then
747: p_rec.clp_attribute2 :=
748: ben_clp_shd.g_old_rec.clp_attribute2;
749: End If;
750: If (p_rec.clp_attribute3 = hr_api.g_varchar2) then
751: p_rec.clp_attribute3 :=
752: ben_clp_shd.g_old_rec.clp_attribute3;
753: End If;
754: If (p_rec.clp_attribute4 = hr_api.g_varchar2) then
750: If (p_rec.clp_attribute3 = hr_api.g_varchar2) then
751: p_rec.clp_attribute3 :=
752: ben_clp_shd.g_old_rec.clp_attribute3;
753: End If;
754: If (p_rec.clp_attribute4 = hr_api.g_varchar2) then
755: p_rec.clp_attribute4 :=
756: ben_clp_shd.g_old_rec.clp_attribute4;
757: End If;
758: If (p_rec.clp_attribute5 = hr_api.g_varchar2) then
754: If (p_rec.clp_attribute4 = hr_api.g_varchar2) then
755: p_rec.clp_attribute4 :=
756: ben_clp_shd.g_old_rec.clp_attribute4;
757: End If;
758: If (p_rec.clp_attribute5 = hr_api.g_varchar2) then
759: p_rec.clp_attribute5 :=
760: ben_clp_shd.g_old_rec.clp_attribute5;
761: End If;
762: If (p_rec.clp_attribute6 = hr_api.g_varchar2) then
758: If (p_rec.clp_attribute5 = hr_api.g_varchar2) then
759: p_rec.clp_attribute5 :=
760: ben_clp_shd.g_old_rec.clp_attribute5;
761: End If;
762: If (p_rec.clp_attribute6 = hr_api.g_varchar2) then
763: p_rec.clp_attribute6 :=
764: ben_clp_shd.g_old_rec.clp_attribute6;
765: End If;
766: If (p_rec.clp_attribute7 = hr_api.g_varchar2) then
762: If (p_rec.clp_attribute6 = hr_api.g_varchar2) then
763: p_rec.clp_attribute6 :=
764: ben_clp_shd.g_old_rec.clp_attribute6;
765: End If;
766: If (p_rec.clp_attribute7 = hr_api.g_varchar2) then
767: p_rec.clp_attribute7 :=
768: ben_clp_shd.g_old_rec.clp_attribute7;
769: End If;
770: If (p_rec.clp_attribute8 = hr_api.g_varchar2) then
766: If (p_rec.clp_attribute7 = hr_api.g_varchar2) then
767: p_rec.clp_attribute7 :=
768: ben_clp_shd.g_old_rec.clp_attribute7;
769: End If;
770: If (p_rec.clp_attribute8 = hr_api.g_varchar2) then
771: p_rec.clp_attribute8 :=
772: ben_clp_shd.g_old_rec.clp_attribute8;
773: End If;
774: If (p_rec.clp_attribute9 = hr_api.g_varchar2) then
770: If (p_rec.clp_attribute8 = hr_api.g_varchar2) then
771: p_rec.clp_attribute8 :=
772: ben_clp_shd.g_old_rec.clp_attribute8;
773: End If;
774: If (p_rec.clp_attribute9 = hr_api.g_varchar2) then
775: p_rec.clp_attribute9 :=
776: ben_clp_shd.g_old_rec.clp_attribute9;
777: End If;
778: If (p_rec.clp_attribute10 = hr_api.g_varchar2) then
774: If (p_rec.clp_attribute9 = hr_api.g_varchar2) then
775: p_rec.clp_attribute9 :=
776: ben_clp_shd.g_old_rec.clp_attribute9;
777: End If;
778: If (p_rec.clp_attribute10 = hr_api.g_varchar2) then
779: p_rec.clp_attribute10 :=
780: ben_clp_shd.g_old_rec.clp_attribute10;
781: End If;
782: If (p_rec.clp_attribute11 = hr_api.g_varchar2) then
778: If (p_rec.clp_attribute10 = hr_api.g_varchar2) then
779: p_rec.clp_attribute10 :=
780: ben_clp_shd.g_old_rec.clp_attribute10;
781: End If;
782: If (p_rec.clp_attribute11 = hr_api.g_varchar2) then
783: p_rec.clp_attribute11 :=
784: ben_clp_shd.g_old_rec.clp_attribute11;
785: End If;
786: If (p_rec.clp_attribute12 = hr_api.g_varchar2) then
782: If (p_rec.clp_attribute11 = hr_api.g_varchar2) then
783: p_rec.clp_attribute11 :=
784: ben_clp_shd.g_old_rec.clp_attribute11;
785: End If;
786: If (p_rec.clp_attribute12 = hr_api.g_varchar2) then
787: p_rec.clp_attribute12 :=
788: ben_clp_shd.g_old_rec.clp_attribute12;
789: End If;
790: If (p_rec.clp_attribute13 = hr_api.g_varchar2) then
786: If (p_rec.clp_attribute12 = hr_api.g_varchar2) then
787: p_rec.clp_attribute12 :=
788: ben_clp_shd.g_old_rec.clp_attribute12;
789: End If;
790: If (p_rec.clp_attribute13 = hr_api.g_varchar2) then
791: p_rec.clp_attribute13 :=
792: ben_clp_shd.g_old_rec.clp_attribute13;
793: End If;
794: If (p_rec.clp_attribute14 = hr_api.g_varchar2) then
790: If (p_rec.clp_attribute13 = hr_api.g_varchar2) then
791: p_rec.clp_attribute13 :=
792: ben_clp_shd.g_old_rec.clp_attribute13;
793: End If;
794: If (p_rec.clp_attribute14 = hr_api.g_varchar2) then
795: p_rec.clp_attribute14 :=
796: ben_clp_shd.g_old_rec.clp_attribute14;
797: End If;
798: If (p_rec.clp_attribute15 = hr_api.g_varchar2) then
794: If (p_rec.clp_attribute14 = hr_api.g_varchar2) then
795: p_rec.clp_attribute14 :=
796: ben_clp_shd.g_old_rec.clp_attribute14;
797: End If;
798: If (p_rec.clp_attribute15 = hr_api.g_varchar2) then
799: p_rec.clp_attribute15 :=
800: ben_clp_shd.g_old_rec.clp_attribute15;
801: End If;
802: If (p_rec.clp_attribute16 = hr_api.g_varchar2) then
798: If (p_rec.clp_attribute15 = hr_api.g_varchar2) then
799: p_rec.clp_attribute15 :=
800: ben_clp_shd.g_old_rec.clp_attribute15;
801: End If;
802: If (p_rec.clp_attribute16 = hr_api.g_varchar2) then
803: p_rec.clp_attribute16 :=
804: ben_clp_shd.g_old_rec.clp_attribute16;
805: End If;
806: If (p_rec.clp_attribute17 = hr_api.g_varchar2) then
802: If (p_rec.clp_attribute16 = hr_api.g_varchar2) then
803: p_rec.clp_attribute16 :=
804: ben_clp_shd.g_old_rec.clp_attribute16;
805: End If;
806: If (p_rec.clp_attribute17 = hr_api.g_varchar2) then
807: p_rec.clp_attribute17 :=
808: ben_clp_shd.g_old_rec.clp_attribute17;
809: End If;
810: If (p_rec.clp_attribute18 = hr_api.g_varchar2) then
806: If (p_rec.clp_attribute17 = hr_api.g_varchar2) then
807: p_rec.clp_attribute17 :=
808: ben_clp_shd.g_old_rec.clp_attribute17;
809: End If;
810: If (p_rec.clp_attribute18 = hr_api.g_varchar2) then
811: p_rec.clp_attribute18 :=
812: ben_clp_shd.g_old_rec.clp_attribute18;
813: End If;
814: If (p_rec.clp_attribute19 = hr_api.g_varchar2) then
810: If (p_rec.clp_attribute18 = hr_api.g_varchar2) then
811: p_rec.clp_attribute18 :=
812: ben_clp_shd.g_old_rec.clp_attribute18;
813: End If;
814: If (p_rec.clp_attribute19 = hr_api.g_varchar2) then
815: p_rec.clp_attribute19 :=
816: ben_clp_shd.g_old_rec.clp_attribute19;
817: End If;
818: If (p_rec.clp_attribute20 = hr_api.g_varchar2) then
814: If (p_rec.clp_attribute19 = hr_api.g_varchar2) then
815: p_rec.clp_attribute19 :=
816: ben_clp_shd.g_old_rec.clp_attribute19;
817: End If;
818: If (p_rec.clp_attribute20 = hr_api.g_varchar2) then
819: p_rec.clp_attribute20 :=
820: ben_clp_shd.g_old_rec.clp_attribute20;
821: End If;
822: If (p_rec.clp_attribute21 = hr_api.g_varchar2) then
818: If (p_rec.clp_attribute20 = hr_api.g_varchar2) then
819: p_rec.clp_attribute20 :=
820: ben_clp_shd.g_old_rec.clp_attribute20;
821: End If;
822: If (p_rec.clp_attribute21 = hr_api.g_varchar2) then
823: p_rec.clp_attribute21 :=
824: ben_clp_shd.g_old_rec.clp_attribute21;
825: End If;
826: If (p_rec.clp_attribute22 = hr_api.g_varchar2) then
822: If (p_rec.clp_attribute21 = hr_api.g_varchar2) then
823: p_rec.clp_attribute21 :=
824: ben_clp_shd.g_old_rec.clp_attribute21;
825: End If;
826: If (p_rec.clp_attribute22 = hr_api.g_varchar2) then
827: p_rec.clp_attribute22 :=
828: ben_clp_shd.g_old_rec.clp_attribute22;
829: End If;
830: If (p_rec.clp_attribute23 = hr_api.g_varchar2) then
826: If (p_rec.clp_attribute22 = hr_api.g_varchar2) then
827: p_rec.clp_attribute22 :=
828: ben_clp_shd.g_old_rec.clp_attribute22;
829: End If;
830: If (p_rec.clp_attribute23 = hr_api.g_varchar2) then
831: p_rec.clp_attribute23 :=
832: ben_clp_shd.g_old_rec.clp_attribute23;
833: End If;
834: If (p_rec.clp_attribute24 = hr_api.g_varchar2) then
830: If (p_rec.clp_attribute23 = hr_api.g_varchar2) then
831: p_rec.clp_attribute23 :=
832: ben_clp_shd.g_old_rec.clp_attribute23;
833: End If;
834: If (p_rec.clp_attribute24 = hr_api.g_varchar2) then
835: p_rec.clp_attribute24 :=
836: ben_clp_shd.g_old_rec.clp_attribute24;
837: End If;
838: If (p_rec.clp_attribute25 = hr_api.g_varchar2) then
834: If (p_rec.clp_attribute24 = hr_api.g_varchar2) then
835: p_rec.clp_attribute24 :=
836: ben_clp_shd.g_old_rec.clp_attribute24;
837: End If;
838: If (p_rec.clp_attribute25 = hr_api.g_varchar2) then
839: p_rec.clp_attribute25 :=
840: ben_clp_shd.g_old_rec.clp_attribute25;
841: End If;
842: If (p_rec.clp_attribute26 = hr_api.g_varchar2) then
838: If (p_rec.clp_attribute25 = hr_api.g_varchar2) then
839: p_rec.clp_attribute25 :=
840: ben_clp_shd.g_old_rec.clp_attribute25;
841: End If;
842: If (p_rec.clp_attribute26 = hr_api.g_varchar2) then
843: p_rec.clp_attribute26 :=
844: ben_clp_shd.g_old_rec.clp_attribute26;
845: End If;
846: If (p_rec.clp_attribute27 = hr_api.g_varchar2) then
842: If (p_rec.clp_attribute26 = hr_api.g_varchar2) then
843: p_rec.clp_attribute26 :=
844: ben_clp_shd.g_old_rec.clp_attribute26;
845: End If;
846: If (p_rec.clp_attribute27 = hr_api.g_varchar2) then
847: p_rec.clp_attribute27 :=
848: ben_clp_shd.g_old_rec.clp_attribute27;
849: End If;
850: If (p_rec.clp_attribute28 = hr_api.g_varchar2) then
846: If (p_rec.clp_attribute27 = hr_api.g_varchar2) then
847: p_rec.clp_attribute27 :=
848: ben_clp_shd.g_old_rec.clp_attribute27;
849: End If;
850: If (p_rec.clp_attribute28 = hr_api.g_varchar2) then
851: p_rec.clp_attribute28 :=
852: ben_clp_shd.g_old_rec.clp_attribute28;
853: End If;
854: If (p_rec.clp_attribute29 = hr_api.g_varchar2) then
850: If (p_rec.clp_attribute28 = hr_api.g_varchar2) then
851: p_rec.clp_attribute28 :=
852: ben_clp_shd.g_old_rec.clp_attribute28;
853: End If;
854: If (p_rec.clp_attribute29 = hr_api.g_varchar2) then
855: p_rec.clp_attribute29 :=
856: ben_clp_shd.g_old_rec.clp_attribute29;
857: End If;
858: If (p_rec.clp_attribute30 = hr_api.g_varchar2) then
854: If (p_rec.clp_attribute29 = hr_api.g_varchar2) then
855: p_rec.clp_attribute29 :=
856: ben_clp_shd.g_old_rec.clp_attribute29;
857: End If;
858: If (p_rec.clp_attribute30 = hr_api.g_varchar2) then
859: p_rec.clp_attribute30 :=
860: ben_clp_shd.g_old_rec.clp_attribute30;
861: End If;
862: --
944: (
945: p_clpse_lf_evt_id in number,
946: p_effective_start_date out nocopy date,
947: p_effective_end_date out nocopy date,
948: p_business_group_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
945: p_clpse_lf_evt_id in number,
946: p_effective_start_date out nocopy date,
947: p_effective_end_date out nocopy date,
948: p_business_group_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
946: p_effective_start_date out nocopy date,
947: p_effective_end_date out nocopy date,
948: p_business_group_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
947: p_effective_end_date out nocopy date,
948: p_business_group_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
948: p_business_group_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
949: p_seq in number default hr_api.g_number,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
950: p_ler1_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
951: p_bool1_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
952: p_ler2_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
953: p_bool2_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
954: p_ler3_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
955: p_bool3_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
956: p_ler4_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
957: p_bool4_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
958: p_ler5_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
959: p_bool5_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
960: p_ler6_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
961: p_bool6_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
962: p_ler7_id in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
963: p_bool7_cd in varchar2 default hr_api.g_varchar2,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
964: p_ler8_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
965: p_bool8_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
966: p_ler9_id in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
967: p_bool9_cd in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
968: p_ler10_id in number default hr_api.g_number,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
969: p_eval_cd in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
970: p_eval_rl in number default hr_api.g_number,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
971: p_tlrnc_dys_num in number default hr_api.g_number,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
972: p_eval_ler_id in number default hr_api.g_number,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
973: p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
974: p_eval_ler_det_rl in number default hr_api.g_number,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
975: p_clp_attribute_category in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
976: p_clp_attribute1 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
977: p_clp_attribute2 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
978: p_clp_attribute3 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
979: p_clp_attribute4 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
980: p_clp_attribute5 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
981: p_clp_attribute6 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
982: p_clp_attribute7 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
983: p_clp_attribute8 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
984: p_clp_attribute9 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
985: p_clp_attribute10 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
986: p_clp_attribute11 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
987: p_clp_attribute12 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
988: p_clp_attribute13 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
989: p_clp_attribute14 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
990: p_clp_attribute15 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
991: p_clp_attribute16 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
992: p_clp_attribute17 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
993: p_clp_attribute18 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
994: p_clp_attribute19 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
995: p_clp_attribute20 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
996: p_clp_attribute21 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
997: p_clp_attribute22 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
1005: p_clp_attribute30 in varchar2 default hr_api.g_varchar2,
998: p_clp_attribute23 in varchar2 default hr_api.g_varchar2,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
1005: p_clp_attribute30 in varchar2 default hr_api.g_varchar2,
1006: p_object_version_number in out nocopy number,
999: p_clp_attribute24 in varchar2 default hr_api.g_varchar2,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
1005: p_clp_attribute30 in varchar2 default hr_api.g_varchar2,
1006: p_object_version_number in out nocopy number,
1007: p_effective_date in date,
1000: p_clp_attribute25 in varchar2 default hr_api.g_varchar2,
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
1005: p_clp_attribute30 in varchar2 default hr_api.g_varchar2,
1006: p_object_version_number in out nocopy number,
1007: p_effective_date in date,
1008: p_datetrack_mode in varchar2
1001: p_clp_attribute26 in varchar2 default hr_api.g_varchar2,
1002: p_clp_attribute27 in varchar2 default hr_api.g_varchar2,
1003: p_clp_attribute28 in varchar2 default hr_api.g_varchar2,
1004: p_clp_attribute29 in varchar2 default hr_api.g_varchar2,
1005: p_clp_attribute30 in varchar2 default hr_api.g_varchar2,
1006: p_object_version_number in out nocopy number,
1007: p_effective_date in date,
1008: p_datetrack_mode in varchar2
1009: ) is