163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: --
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
168: -- A check constraint has been violated
169: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: per_abs_shd.g_api_dml := false; -- Unset the api dml status
184: Raise;
185: End update_dml;
655: );
656: --
657: exception
658: --
659: when hr_api.cannot_find_prog_unit then
660: --
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'PER_ABSENCE_ATTENDANCES'
663: ,p_hook_type => 'AU');
657: exception
658: --
659: when hr_api.cannot_find_prog_unit then
660: --
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'PER_ABSENCE_ATTENDANCES'
663: ,p_hook_type => 'AU');
664: --
665: end;
720: -- p_rec plsql record structure
721: -- to see if a system default is being used. If a system default
722: -- is being used then we must set to the 'current' argument value.
723: --
724: If (p_rec.business_group_id = hr_api.g_number) then
725: p_rec.business_group_id :=
726: per_abs_shd.g_old_rec.business_group_id;
727: End If;
728: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
724: If (p_rec.business_group_id = hr_api.g_number) then
725: p_rec.business_group_id :=
726: per_abs_shd.g_old_rec.business_group_id;
727: End If;
728: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
729: p_rec.absence_attendance_type_id :=
730: per_abs_shd.g_old_rec.absence_attendance_type_id;
731: End If;
732: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
728: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
729: p_rec.absence_attendance_type_id :=
730: per_abs_shd.g_old_rec.absence_attendance_type_id;
731: End If;
732: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
733: p_rec.abs_attendance_reason_id :=
734: per_abs_shd.g_old_rec.abs_attendance_reason_id;
735: End If;
736: If (p_rec.person_id = hr_api.g_number) then
732: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
733: p_rec.abs_attendance_reason_id :=
734: per_abs_shd.g_old_rec.abs_attendance_reason_id;
735: End If;
736: If (p_rec.person_id = hr_api.g_number) then
737: p_rec.person_id :=
738: per_abs_shd.g_old_rec.person_id;
739: End If;
740: If (p_rec.authorising_person_id = hr_api.g_number) then
736: If (p_rec.person_id = hr_api.g_number) then
737: p_rec.person_id :=
738: per_abs_shd.g_old_rec.person_id;
739: End If;
740: If (p_rec.authorising_person_id = hr_api.g_number) then
741: p_rec.authorising_person_id :=
742: per_abs_shd.g_old_rec.authorising_person_id;
743: End If;
744: If (p_rec.replacement_person_id = hr_api.g_number) then
740: If (p_rec.authorising_person_id = hr_api.g_number) then
741: p_rec.authorising_person_id :=
742: per_abs_shd.g_old_rec.authorising_person_id;
743: End If;
744: If (p_rec.replacement_person_id = hr_api.g_number) then
745: p_rec.replacement_person_id :=
746: per_abs_shd.g_old_rec.replacement_person_id;
747: End If;
748: If (p_rec.period_of_incapacity_id = hr_api.g_number) then
744: If (p_rec.replacement_person_id = hr_api.g_number) then
745: p_rec.replacement_person_id :=
746: per_abs_shd.g_old_rec.replacement_person_id;
747: End If;
748: If (p_rec.period_of_incapacity_id = hr_api.g_number) then
749: p_rec.period_of_incapacity_id :=
750: per_abs_shd.g_old_rec.period_of_incapacity_id;
751: End If;
752: If (p_rec.absence_days = hr_api.g_number) then
748: If (p_rec.period_of_incapacity_id = hr_api.g_number) then
749: p_rec.period_of_incapacity_id :=
750: per_abs_shd.g_old_rec.period_of_incapacity_id;
751: End If;
752: If (p_rec.absence_days = hr_api.g_number) then
753: p_rec.absence_days :=
754: per_abs_shd.g_old_rec.absence_days;
755: End If;
756: If (p_rec.absence_hours = hr_api.g_number) then
752: If (p_rec.absence_days = hr_api.g_number) then
753: p_rec.absence_days :=
754: per_abs_shd.g_old_rec.absence_days;
755: End If;
756: If (p_rec.absence_hours = hr_api.g_number) then
757: p_rec.absence_hours :=
758: per_abs_shd.g_old_rec.absence_hours;
759: End If;
760: If (p_rec.comments = hr_api.g_varchar2) then
756: If (p_rec.absence_hours = hr_api.g_number) then
757: p_rec.absence_hours :=
758: per_abs_shd.g_old_rec.absence_hours;
759: End If;
760: If (p_rec.comments = hr_api.g_varchar2) then
761: p_rec.comments :=
762: per_abs_shd.g_old_rec.comments;
763: End If;
764: If (p_rec.date_end = hr_api.g_date) then
760: If (p_rec.comments = hr_api.g_varchar2) then
761: p_rec.comments :=
762: per_abs_shd.g_old_rec.comments;
763: End If;
764: If (p_rec.date_end = hr_api.g_date) then
765: p_rec.date_end :=
766: per_abs_shd.g_old_rec.date_end;
767: End If;
768: If (p_rec.date_notification = hr_api.g_date) then
764: If (p_rec.date_end = hr_api.g_date) then
765: p_rec.date_end :=
766: per_abs_shd.g_old_rec.date_end;
767: End If;
768: If (p_rec.date_notification = hr_api.g_date) then
769: p_rec.date_notification :=
770: per_abs_shd.g_old_rec.date_notification;
771: End If;
772: If (p_rec.date_projected_end = hr_api.g_date) then
768: If (p_rec.date_notification = hr_api.g_date) then
769: p_rec.date_notification :=
770: per_abs_shd.g_old_rec.date_notification;
771: End If;
772: If (p_rec.date_projected_end = hr_api.g_date) then
773: p_rec.date_projected_end :=
774: per_abs_shd.g_old_rec.date_projected_end;
775: End If;
776: If (p_rec.date_projected_start = hr_api.g_date) then
772: If (p_rec.date_projected_end = hr_api.g_date) then
773: p_rec.date_projected_end :=
774: per_abs_shd.g_old_rec.date_projected_end;
775: End If;
776: If (p_rec.date_projected_start = hr_api.g_date) then
777: p_rec.date_projected_start :=
778: per_abs_shd.g_old_rec.date_projected_start;
779: End If;
780: If (p_rec.date_start = hr_api.g_date) then
776: If (p_rec.date_projected_start = hr_api.g_date) then
777: p_rec.date_projected_start :=
778: per_abs_shd.g_old_rec.date_projected_start;
779: End If;
780: If (p_rec.date_start = hr_api.g_date) then
781: p_rec.date_start :=
782: per_abs_shd.g_old_rec.date_start;
783: End If;
784: If (p_rec.occurrence = hr_api.g_number) then
780: If (p_rec.date_start = hr_api.g_date) then
781: p_rec.date_start :=
782: per_abs_shd.g_old_rec.date_start;
783: End If;
784: If (p_rec.occurrence = hr_api.g_number) then
785: p_rec.occurrence :=
786: per_abs_shd.g_old_rec.occurrence;
787: End If;
788: If (p_rec.ssp1_issued = hr_api.g_varchar2) then
784: If (p_rec.occurrence = hr_api.g_number) then
785: p_rec.occurrence :=
786: per_abs_shd.g_old_rec.occurrence;
787: End If;
788: If (p_rec.ssp1_issued = hr_api.g_varchar2) then
789: p_rec.ssp1_issued :=
790: per_abs_shd.g_old_rec.ssp1_issued;
791: End If;
792: If (p_rec.time_end = hr_api.g_varchar2) then
788: If (p_rec.ssp1_issued = hr_api.g_varchar2) then
789: p_rec.ssp1_issued :=
790: per_abs_shd.g_old_rec.ssp1_issued;
791: End If;
792: If (p_rec.time_end = hr_api.g_varchar2) then
793: p_rec.time_end :=
794: per_abs_shd.g_old_rec.time_end;
795: End If;
796: If (p_rec.time_projected_end = hr_api.g_varchar2) then
792: If (p_rec.time_end = hr_api.g_varchar2) then
793: p_rec.time_end :=
794: per_abs_shd.g_old_rec.time_end;
795: End If;
796: If (p_rec.time_projected_end = hr_api.g_varchar2) then
797: p_rec.time_projected_end :=
798: per_abs_shd.g_old_rec.time_projected_end;
799: End If;
800: If (p_rec.time_projected_start = hr_api.g_varchar2) then
796: If (p_rec.time_projected_end = hr_api.g_varchar2) then
797: p_rec.time_projected_end :=
798: per_abs_shd.g_old_rec.time_projected_end;
799: End If;
800: If (p_rec.time_projected_start = hr_api.g_varchar2) then
801: p_rec.time_projected_start :=
802: per_abs_shd.g_old_rec.time_projected_start;
803: End If;
804: If (p_rec.time_start = hr_api.g_varchar2) then
800: If (p_rec.time_projected_start = hr_api.g_varchar2) then
801: p_rec.time_projected_start :=
802: per_abs_shd.g_old_rec.time_projected_start;
803: End If;
804: If (p_rec.time_start = hr_api.g_varchar2) then
805: p_rec.time_start :=
806: per_abs_shd.g_old_rec.time_start;
807: End If;
808: If (p_rec.request_id = hr_api.g_number) then
804: If (p_rec.time_start = hr_api.g_varchar2) then
805: p_rec.time_start :=
806: per_abs_shd.g_old_rec.time_start;
807: End If;
808: If (p_rec.request_id = hr_api.g_number) then
809: p_rec.request_id :=
810: per_abs_shd.g_old_rec.request_id;
811: End If;
812: If (p_rec.program_application_id = hr_api.g_number) then
808: If (p_rec.request_id = hr_api.g_number) then
809: p_rec.request_id :=
810: per_abs_shd.g_old_rec.request_id;
811: End If;
812: If (p_rec.program_application_id = hr_api.g_number) then
813: p_rec.program_application_id :=
814: per_abs_shd.g_old_rec.program_application_id;
815: End If;
816: If (p_rec.program_id = hr_api.g_number) then
812: If (p_rec.program_application_id = hr_api.g_number) then
813: p_rec.program_application_id :=
814: per_abs_shd.g_old_rec.program_application_id;
815: End If;
816: If (p_rec.program_id = hr_api.g_number) then
817: p_rec.program_id :=
818: per_abs_shd.g_old_rec.program_id;
819: End If;
820: If (p_rec.program_update_date = hr_api.g_date) then
816: If (p_rec.program_id = hr_api.g_number) then
817: p_rec.program_id :=
818: per_abs_shd.g_old_rec.program_id;
819: End If;
820: If (p_rec.program_update_date = hr_api.g_date) then
821: p_rec.program_update_date :=
822: per_abs_shd.g_old_rec.program_update_date;
823: End If;
824: If (p_rec.attribute_category = hr_api.g_varchar2) then
820: If (p_rec.program_update_date = hr_api.g_date) then
821: p_rec.program_update_date :=
822: per_abs_shd.g_old_rec.program_update_date;
823: End If;
824: If (p_rec.attribute_category = hr_api.g_varchar2) then
825: p_rec.attribute_category :=
826: per_abs_shd.g_old_rec.attribute_category;
827: End If;
828: If (p_rec.attribute1 = hr_api.g_varchar2) then
824: If (p_rec.attribute_category = hr_api.g_varchar2) then
825: p_rec.attribute_category :=
826: per_abs_shd.g_old_rec.attribute_category;
827: End If;
828: If (p_rec.attribute1 = hr_api.g_varchar2) then
829: p_rec.attribute1 :=
830: per_abs_shd.g_old_rec.attribute1;
831: End If;
832: If (p_rec.attribute2 = hr_api.g_varchar2) then
828: If (p_rec.attribute1 = hr_api.g_varchar2) then
829: p_rec.attribute1 :=
830: per_abs_shd.g_old_rec.attribute1;
831: End If;
832: If (p_rec.attribute2 = hr_api.g_varchar2) then
833: p_rec.attribute2 :=
834: per_abs_shd.g_old_rec.attribute2;
835: End If;
836: If (p_rec.attribute3 = hr_api.g_varchar2) then
832: If (p_rec.attribute2 = hr_api.g_varchar2) then
833: p_rec.attribute2 :=
834: per_abs_shd.g_old_rec.attribute2;
835: End If;
836: If (p_rec.attribute3 = hr_api.g_varchar2) then
837: p_rec.attribute3 :=
838: per_abs_shd.g_old_rec.attribute3;
839: End If;
840: If (p_rec.attribute4 = hr_api.g_varchar2) then
836: If (p_rec.attribute3 = hr_api.g_varchar2) then
837: p_rec.attribute3 :=
838: per_abs_shd.g_old_rec.attribute3;
839: End If;
840: If (p_rec.attribute4 = hr_api.g_varchar2) then
841: p_rec.attribute4 :=
842: per_abs_shd.g_old_rec.attribute4;
843: End If;
844: If (p_rec.attribute5 = hr_api.g_varchar2) then
840: If (p_rec.attribute4 = hr_api.g_varchar2) then
841: p_rec.attribute4 :=
842: per_abs_shd.g_old_rec.attribute4;
843: End If;
844: If (p_rec.attribute5 = hr_api.g_varchar2) then
845: p_rec.attribute5 :=
846: per_abs_shd.g_old_rec.attribute5;
847: End If;
848: If (p_rec.attribute6 = hr_api.g_varchar2) then
844: If (p_rec.attribute5 = hr_api.g_varchar2) then
845: p_rec.attribute5 :=
846: per_abs_shd.g_old_rec.attribute5;
847: End If;
848: If (p_rec.attribute6 = hr_api.g_varchar2) then
849: p_rec.attribute6 :=
850: per_abs_shd.g_old_rec.attribute6;
851: End If;
852: If (p_rec.attribute7 = hr_api.g_varchar2) then
848: If (p_rec.attribute6 = hr_api.g_varchar2) then
849: p_rec.attribute6 :=
850: per_abs_shd.g_old_rec.attribute6;
851: End If;
852: If (p_rec.attribute7 = hr_api.g_varchar2) then
853: p_rec.attribute7 :=
854: per_abs_shd.g_old_rec.attribute7;
855: End If;
856: If (p_rec.attribute8 = hr_api.g_varchar2) then
852: If (p_rec.attribute7 = hr_api.g_varchar2) then
853: p_rec.attribute7 :=
854: per_abs_shd.g_old_rec.attribute7;
855: End If;
856: If (p_rec.attribute8 = hr_api.g_varchar2) then
857: p_rec.attribute8 :=
858: per_abs_shd.g_old_rec.attribute8;
859: End If;
860: If (p_rec.attribute9 = hr_api.g_varchar2) then
856: If (p_rec.attribute8 = hr_api.g_varchar2) then
857: p_rec.attribute8 :=
858: per_abs_shd.g_old_rec.attribute8;
859: End If;
860: If (p_rec.attribute9 = hr_api.g_varchar2) then
861: p_rec.attribute9 :=
862: per_abs_shd.g_old_rec.attribute9;
863: End If;
864: If (p_rec.attribute10 = hr_api.g_varchar2) then
860: If (p_rec.attribute9 = hr_api.g_varchar2) then
861: p_rec.attribute9 :=
862: per_abs_shd.g_old_rec.attribute9;
863: End If;
864: If (p_rec.attribute10 = hr_api.g_varchar2) then
865: p_rec.attribute10 :=
866: per_abs_shd.g_old_rec.attribute10;
867: End If;
868: If (p_rec.attribute11 = hr_api.g_varchar2) then
864: If (p_rec.attribute10 = hr_api.g_varchar2) then
865: p_rec.attribute10 :=
866: per_abs_shd.g_old_rec.attribute10;
867: End If;
868: If (p_rec.attribute11 = hr_api.g_varchar2) then
869: p_rec.attribute11 :=
870: per_abs_shd.g_old_rec.attribute11;
871: End If;
872: If (p_rec.attribute12 = hr_api.g_varchar2) then
868: If (p_rec.attribute11 = hr_api.g_varchar2) then
869: p_rec.attribute11 :=
870: per_abs_shd.g_old_rec.attribute11;
871: End If;
872: If (p_rec.attribute12 = hr_api.g_varchar2) then
873: p_rec.attribute12 :=
874: per_abs_shd.g_old_rec.attribute12;
875: End If;
876: If (p_rec.attribute13 = hr_api.g_varchar2) then
872: If (p_rec.attribute12 = hr_api.g_varchar2) then
873: p_rec.attribute12 :=
874: per_abs_shd.g_old_rec.attribute12;
875: End If;
876: If (p_rec.attribute13 = hr_api.g_varchar2) then
877: p_rec.attribute13 :=
878: per_abs_shd.g_old_rec.attribute13;
879: End If;
880: If (p_rec.attribute14 = hr_api.g_varchar2) then
876: If (p_rec.attribute13 = hr_api.g_varchar2) then
877: p_rec.attribute13 :=
878: per_abs_shd.g_old_rec.attribute13;
879: End If;
880: If (p_rec.attribute14 = hr_api.g_varchar2) then
881: p_rec.attribute14 :=
882: per_abs_shd.g_old_rec.attribute14;
883: End If;
884: If (p_rec.attribute15 = hr_api.g_varchar2) then
880: If (p_rec.attribute14 = hr_api.g_varchar2) then
881: p_rec.attribute14 :=
882: per_abs_shd.g_old_rec.attribute14;
883: End If;
884: If (p_rec.attribute15 = hr_api.g_varchar2) then
885: p_rec.attribute15 :=
886: per_abs_shd.g_old_rec.attribute15;
887: End If;
888: If (p_rec.attribute16 = hr_api.g_varchar2) then
884: If (p_rec.attribute15 = hr_api.g_varchar2) then
885: p_rec.attribute15 :=
886: per_abs_shd.g_old_rec.attribute15;
887: End If;
888: If (p_rec.attribute16 = hr_api.g_varchar2) then
889: p_rec.attribute16 :=
890: per_abs_shd.g_old_rec.attribute16;
891: End If;
892: If (p_rec.attribute17 = hr_api.g_varchar2) then
888: If (p_rec.attribute16 = hr_api.g_varchar2) then
889: p_rec.attribute16 :=
890: per_abs_shd.g_old_rec.attribute16;
891: End If;
892: If (p_rec.attribute17 = hr_api.g_varchar2) then
893: p_rec.attribute17 :=
894: per_abs_shd.g_old_rec.attribute17;
895: End If;
896: If (p_rec.attribute18 = hr_api.g_varchar2) then
892: If (p_rec.attribute17 = hr_api.g_varchar2) then
893: p_rec.attribute17 :=
894: per_abs_shd.g_old_rec.attribute17;
895: End If;
896: If (p_rec.attribute18 = hr_api.g_varchar2) then
897: p_rec.attribute18 :=
898: per_abs_shd.g_old_rec.attribute18;
899: End If;
900: If (p_rec.attribute19 = hr_api.g_varchar2) then
896: If (p_rec.attribute18 = hr_api.g_varchar2) then
897: p_rec.attribute18 :=
898: per_abs_shd.g_old_rec.attribute18;
899: End If;
900: If (p_rec.attribute19 = hr_api.g_varchar2) then
901: p_rec.attribute19 :=
902: per_abs_shd.g_old_rec.attribute19;
903: End If;
904: If (p_rec.attribute20 = hr_api.g_varchar2) then
900: If (p_rec.attribute19 = hr_api.g_varchar2) then
901: p_rec.attribute19 :=
902: per_abs_shd.g_old_rec.attribute19;
903: End If;
904: If (p_rec.attribute20 = hr_api.g_varchar2) then
905: p_rec.attribute20 :=
906: per_abs_shd.g_old_rec.attribute20;
907: End If;
908: If (p_rec.maternity_id = hr_api.g_number) then
904: If (p_rec.attribute20 = hr_api.g_varchar2) then
905: p_rec.attribute20 :=
906: per_abs_shd.g_old_rec.attribute20;
907: End If;
908: If (p_rec.maternity_id = hr_api.g_number) then
909: p_rec.maternity_id :=
910: per_abs_shd.g_old_rec.maternity_id;
911: End If;
912: If (p_rec.sickness_start_date = hr_api.g_date) then
908: If (p_rec.maternity_id = hr_api.g_number) then
909: p_rec.maternity_id :=
910: per_abs_shd.g_old_rec.maternity_id;
911: End If;
912: If (p_rec.sickness_start_date = hr_api.g_date) then
913: p_rec.sickness_start_date :=
914: per_abs_shd.g_old_rec.sickness_start_date;
915: End If;
916: If (p_rec.sickness_end_date = hr_api.g_date) then
912: If (p_rec.sickness_start_date = hr_api.g_date) then
913: p_rec.sickness_start_date :=
914: per_abs_shd.g_old_rec.sickness_start_date;
915: End If;
916: If (p_rec.sickness_end_date = hr_api.g_date) then
917: p_rec.sickness_end_date :=
918: per_abs_shd.g_old_rec.sickness_end_date;
919: End If;
920: If (p_rec.pregnancy_related_illness = hr_api.g_varchar2) then
916: If (p_rec.sickness_end_date = hr_api.g_date) then
917: p_rec.sickness_end_date :=
918: per_abs_shd.g_old_rec.sickness_end_date;
919: End If;
920: If (p_rec.pregnancy_related_illness = hr_api.g_varchar2) then
921: p_rec.pregnancy_related_illness :=
922: per_abs_shd.g_old_rec.pregnancy_related_illness;
923: End If;
924: If (p_rec.reason_for_notification_delay = hr_api.g_varchar2) then
920: If (p_rec.pregnancy_related_illness = hr_api.g_varchar2) then
921: p_rec.pregnancy_related_illness :=
922: per_abs_shd.g_old_rec.pregnancy_related_illness;
923: End If;
924: If (p_rec.reason_for_notification_delay = hr_api.g_varchar2) then
925: p_rec.reason_for_notification_delay :=
926: per_abs_shd.g_old_rec.reason_for_notification_delay;
927: End If;
928: If (p_rec.accept_late_notification_flag = hr_api.g_varchar2) then
924: If (p_rec.reason_for_notification_delay = hr_api.g_varchar2) then
925: p_rec.reason_for_notification_delay :=
926: per_abs_shd.g_old_rec.reason_for_notification_delay;
927: End If;
928: If (p_rec.accept_late_notification_flag = hr_api.g_varchar2) then
929: p_rec.accept_late_notification_flag :=
930: per_abs_shd.g_old_rec.accept_late_notification_flag;
931: End If;
932: If (p_rec.linked_absence_id = hr_api.g_number) then
928: If (p_rec.accept_late_notification_flag = hr_api.g_varchar2) then
929: p_rec.accept_late_notification_flag :=
930: per_abs_shd.g_old_rec.accept_late_notification_flag;
931: End If;
932: If (p_rec.linked_absence_id = hr_api.g_number) then
933: p_rec.linked_absence_id :=
934: per_abs_shd.g_old_rec.linked_absence_id;
935: End If;
936: If (p_rec.abs_information_category = hr_api.g_varchar2) then
932: If (p_rec.linked_absence_id = hr_api.g_number) then
933: p_rec.linked_absence_id :=
934: per_abs_shd.g_old_rec.linked_absence_id;
935: End If;
936: If (p_rec.abs_information_category = hr_api.g_varchar2) then
937: p_rec.abs_information_category :=
938: per_abs_shd.g_old_rec.abs_information_category;
939: End If;
940: If (p_rec.abs_information1 = hr_api.g_varchar2) then
936: If (p_rec.abs_information_category = hr_api.g_varchar2) then
937: p_rec.abs_information_category :=
938: per_abs_shd.g_old_rec.abs_information_category;
939: End If;
940: If (p_rec.abs_information1 = hr_api.g_varchar2) then
941: p_rec.abs_information1 :=
942: per_abs_shd.g_old_rec.abs_information1;
943: End If;
944: If (p_rec.abs_information2 = hr_api.g_varchar2) then
940: If (p_rec.abs_information1 = hr_api.g_varchar2) then
941: p_rec.abs_information1 :=
942: per_abs_shd.g_old_rec.abs_information1;
943: End If;
944: If (p_rec.abs_information2 = hr_api.g_varchar2) then
945: p_rec.abs_information2 :=
946: per_abs_shd.g_old_rec.abs_information2;
947: End If;
948: If (p_rec.abs_information3 = hr_api.g_varchar2) then
944: If (p_rec.abs_information2 = hr_api.g_varchar2) then
945: p_rec.abs_information2 :=
946: per_abs_shd.g_old_rec.abs_information2;
947: End If;
948: If (p_rec.abs_information3 = hr_api.g_varchar2) then
949: p_rec.abs_information3 :=
950: per_abs_shd.g_old_rec.abs_information3;
951: End If;
952: If (p_rec.abs_information4 = hr_api.g_varchar2) then
948: If (p_rec.abs_information3 = hr_api.g_varchar2) then
949: p_rec.abs_information3 :=
950: per_abs_shd.g_old_rec.abs_information3;
951: End If;
952: If (p_rec.abs_information4 = hr_api.g_varchar2) then
953: p_rec.abs_information4 :=
954: per_abs_shd.g_old_rec.abs_information4;
955: End If;
956: If (p_rec.abs_information5 = hr_api.g_varchar2) then
952: If (p_rec.abs_information4 = hr_api.g_varchar2) then
953: p_rec.abs_information4 :=
954: per_abs_shd.g_old_rec.abs_information4;
955: End If;
956: If (p_rec.abs_information5 = hr_api.g_varchar2) then
957: p_rec.abs_information5 :=
958: per_abs_shd.g_old_rec.abs_information5;
959: End If;
960: If (p_rec.abs_information6 = hr_api.g_varchar2) then
956: If (p_rec.abs_information5 = hr_api.g_varchar2) then
957: p_rec.abs_information5 :=
958: per_abs_shd.g_old_rec.abs_information5;
959: End If;
960: If (p_rec.abs_information6 = hr_api.g_varchar2) then
961: p_rec.abs_information6 :=
962: per_abs_shd.g_old_rec.abs_information6;
963: End If;
964: If (p_rec.abs_information7 = hr_api.g_varchar2) then
960: If (p_rec.abs_information6 = hr_api.g_varchar2) then
961: p_rec.abs_information6 :=
962: per_abs_shd.g_old_rec.abs_information6;
963: End If;
964: If (p_rec.abs_information7 = hr_api.g_varchar2) then
965: p_rec.abs_information7 :=
966: per_abs_shd.g_old_rec.abs_information7;
967: End If;
968: If (p_rec.abs_information8 = hr_api.g_varchar2) then
964: If (p_rec.abs_information7 = hr_api.g_varchar2) then
965: p_rec.abs_information7 :=
966: per_abs_shd.g_old_rec.abs_information7;
967: End If;
968: If (p_rec.abs_information8 = hr_api.g_varchar2) then
969: p_rec.abs_information8 :=
970: per_abs_shd.g_old_rec.abs_information8;
971: End If;
972: If (p_rec.abs_information9 = hr_api.g_varchar2) then
968: If (p_rec.abs_information8 = hr_api.g_varchar2) then
969: p_rec.abs_information8 :=
970: per_abs_shd.g_old_rec.abs_information8;
971: End If;
972: If (p_rec.abs_information9 = hr_api.g_varchar2) then
973: p_rec.abs_information9 :=
974: per_abs_shd.g_old_rec.abs_information9;
975: End If;
976: If (p_rec.abs_information10 = hr_api.g_varchar2) then
972: If (p_rec.abs_information9 = hr_api.g_varchar2) then
973: p_rec.abs_information9 :=
974: per_abs_shd.g_old_rec.abs_information9;
975: End If;
976: If (p_rec.abs_information10 = hr_api.g_varchar2) then
977: p_rec.abs_information10 :=
978: per_abs_shd.g_old_rec.abs_information10;
979: End If;
980: If (p_rec.abs_information11 = hr_api.g_varchar2) then
976: If (p_rec.abs_information10 = hr_api.g_varchar2) then
977: p_rec.abs_information10 :=
978: per_abs_shd.g_old_rec.abs_information10;
979: End If;
980: If (p_rec.abs_information11 = hr_api.g_varchar2) then
981: p_rec.abs_information11 :=
982: per_abs_shd.g_old_rec.abs_information11;
983: End If;
984: If (p_rec.abs_information12 = hr_api.g_varchar2) then
980: If (p_rec.abs_information11 = hr_api.g_varchar2) then
981: p_rec.abs_information11 :=
982: per_abs_shd.g_old_rec.abs_information11;
983: End If;
984: If (p_rec.abs_information12 = hr_api.g_varchar2) then
985: p_rec.abs_information12 :=
986: per_abs_shd.g_old_rec.abs_information12;
987: End If;
988: If (p_rec.abs_information13 = hr_api.g_varchar2) then
984: If (p_rec.abs_information12 = hr_api.g_varchar2) then
985: p_rec.abs_information12 :=
986: per_abs_shd.g_old_rec.abs_information12;
987: End If;
988: If (p_rec.abs_information13 = hr_api.g_varchar2) then
989: p_rec.abs_information13 :=
990: per_abs_shd.g_old_rec.abs_information13;
991: End If;
992: If (p_rec.abs_information14 = hr_api.g_varchar2) then
988: If (p_rec.abs_information13 = hr_api.g_varchar2) then
989: p_rec.abs_information13 :=
990: per_abs_shd.g_old_rec.abs_information13;
991: End If;
992: If (p_rec.abs_information14 = hr_api.g_varchar2) then
993: p_rec.abs_information14 :=
994: per_abs_shd.g_old_rec.abs_information14;
995: End If;
996: If (p_rec.abs_information15 = hr_api.g_varchar2) then
992: If (p_rec.abs_information14 = hr_api.g_varchar2) then
993: p_rec.abs_information14 :=
994: per_abs_shd.g_old_rec.abs_information14;
995: End If;
996: If (p_rec.abs_information15 = hr_api.g_varchar2) then
997: p_rec.abs_information15 :=
998: per_abs_shd.g_old_rec.abs_information15;
999: End If;
1000: If (p_rec.abs_information16 = hr_api.g_varchar2) then
996: If (p_rec.abs_information15 = hr_api.g_varchar2) then
997: p_rec.abs_information15 :=
998: per_abs_shd.g_old_rec.abs_information15;
999: End If;
1000: If (p_rec.abs_information16 = hr_api.g_varchar2) then
1001: p_rec.abs_information16 :=
1002: per_abs_shd.g_old_rec.abs_information16;
1003: End If;
1004: If (p_rec.abs_information17 = hr_api.g_varchar2) then
1000: If (p_rec.abs_information16 = hr_api.g_varchar2) then
1001: p_rec.abs_information16 :=
1002: per_abs_shd.g_old_rec.abs_information16;
1003: End If;
1004: If (p_rec.abs_information17 = hr_api.g_varchar2) then
1005: p_rec.abs_information17 :=
1006: per_abs_shd.g_old_rec.abs_information17;
1007: End If;
1008: If (p_rec.abs_information18 = hr_api.g_varchar2) then
1004: If (p_rec.abs_information17 = hr_api.g_varchar2) then
1005: p_rec.abs_information17 :=
1006: per_abs_shd.g_old_rec.abs_information17;
1007: End If;
1008: If (p_rec.abs_information18 = hr_api.g_varchar2) then
1009: p_rec.abs_information18 :=
1010: per_abs_shd.g_old_rec.abs_information18;
1011: End If;
1012: If (p_rec.abs_information19 = hr_api.g_varchar2) then
1008: If (p_rec.abs_information18 = hr_api.g_varchar2) then
1009: p_rec.abs_information18 :=
1010: per_abs_shd.g_old_rec.abs_information18;
1011: End If;
1012: If (p_rec.abs_information19 = hr_api.g_varchar2) then
1013: p_rec.abs_information19 :=
1014: per_abs_shd.g_old_rec.abs_information19;
1015: End If;
1016: If (p_rec.abs_information20 = hr_api.g_varchar2) then
1012: If (p_rec.abs_information19 = hr_api.g_varchar2) then
1013: p_rec.abs_information19 :=
1014: per_abs_shd.g_old_rec.abs_information19;
1015: End If;
1016: If (p_rec.abs_information20 = hr_api.g_varchar2) then
1017: p_rec.abs_information20 :=
1018: per_abs_shd.g_old_rec.abs_information20;
1019: End If;
1020: If (p_rec.abs_information21 = hr_api.g_varchar2) then
1016: If (p_rec.abs_information20 = hr_api.g_varchar2) then
1017: p_rec.abs_information20 :=
1018: per_abs_shd.g_old_rec.abs_information20;
1019: End If;
1020: If (p_rec.abs_information21 = hr_api.g_varchar2) then
1021: p_rec.abs_information21 :=
1022: per_abs_shd.g_old_rec.abs_information21;
1023: End If;
1024: If (p_rec.abs_information22 = hr_api.g_varchar2) then
1020: If (p_rec.abs_information21 = hr_api.g_varchar2) then
1021: p_rec.abs_information21 :=
1022: per_abs_shd.g_old_rec.abs_information21;
1023: End If;
1024: If (p_rec.abs_information22 = hr_api.g_varchar2) then
1025: p_rec.abs_information22 :=
1026: per_abs_shd.g_old_rec.abs_information22;
1027: End If;
1028: If (p_rec.abs_information23 = hr_api.g_varchar2) then
1024: If (p_rec.abs_information22 = hr_api.g_varchar2) then
1025: p_rec.abs_information22 :=
1026: per_abs_shd.g_old_rec.abs_information22;
1027: End If;
1028: If (p_rec.abs_information23 = hr_api.g_varchar2) then
1029: p_rec.abs_information23 :=
1030: per_abs_shd.g_old_rec.abs_information23;
1031: End If;
1032: If (p_rec.abs_information24 = hr_api.g_varchar2) then
1028: If (p_rec.abs_information23 = hr_api.g_varchar2) then
1029: p_rec.abs_information23 :=
1030: per_abs_shd.g_old_rec.abs_information23;
1031: End If;
1032: If (p_rec.abs_information24 = hr_api.g_varchar2) then
1033: p_rec.abs_information24 :=
1034: per_abs_shd.g_old_rec.abs_information24;
1035: End If;
1036: If (p_rec.abs_information25 = hr_api.g_varchar2) then
1032: If (p_rec.abs_information24 = hr_api.g_varchar2) then
1033: p_rec.abs_information24 :=
1034: per_abs_shd.g_old_rec.abs_information24;
1035: End If;
1036: If (p_rec.abs_information25 = hr_api.g_varchar2) then
1037: p_rec.abs_information25 :=
1038: per_abs_shd.g_old_rec.abs_information25;
1039: End If;
1040: If (p_rec.abs_information26 = hr_api.g_varchar2) then
1036: If (p_rec.abs_information25 = hr_api.g_varchar2) then
1037: p_rec.abs_information25 :=
1038: per_abs_shd.g_old_rec.abs_information25;
1039: End If;
1040: If (p_rec.abs_information26 = hr_api.g_varchar2) then
1041: p_rec.abs_information26 :=
1042: per_abs_shd.g_old_rec.abs_information26;
1043: End If;
1044: If (p_rec.abs_information27 = hr_api.g_varchar2) then
1040: If (p_rec.abs_information26 = hr_api.g_varchar2) then
1041: p_rec.abs_information26 :=
1042: per_abs_shd.g_old_rec.abs_information26;
1043: End If;
1044: If (p_rec.abs_information27 = hr_api.g_varchar2) then
1045: p_rec.abs_information27 :=
1046: per_abs_shd.g_old_rec.abs_information27;
1047: End If;
1048: If (p_rec.abs_information28 = hr_api.g_varchar2) then
1044: If (p_rec.abs_information27 = hr_api.g_varchar2) then
1045: p_rec.abs_information27 :=
1046: per_abs_shd.g_old_rec.abs_information27;
1047: End If;
1048: If (p_rec.abs_information28 = hr_api.g_varchar2) then
1049: p_rec.abs_information28 :=
1050: per_abs_shd.g_old_rec.abs_information28;
1051: End If;
1052: If (p_rec.abs_information29 = hr_api.g_varchar2) then
1048: If (p_rec.abs_information28 = hr_api.g_varchar2) then
1049: p_rec.abs_information28 :=
1050: per_abs_shd.g_old_rec.abs_information28;
1051: End If;
1052: If (p_rec.abs_information29 = hr_api.g_varchar2) then
1053: p_rec.abs_information29 :=
1054: per_abs_shd.g_old_rec.abs_information29;
1055: End If;
1056: If (p_rec.abs_information30 = hr_api.g_varchar2) then
1052: If (p_rec.abs_information29 = hr_api.g_varchar2) then
1053: p_rec.abs_information29 :=
1054: per_abs_shd.g_old_rec.abs_information29;
1055: End If;
1056: If (p_rec.abs_information30 = hr_api.g_varchar2) then
1057: p_rec.abs_information30 :=
1058: per_abs_shd.g_old_rec.abs_information30;
1059: End If;
1060: If (p_rec.absence_case_id = hr_api.g_number) then
1056: If (p_rec.abs_information30 = hr_api.g_varchar2) then
1057: p_rec.abs_information30 :=
1058: per_abs_shd.g_old_rec.abs_information30;
1059: End If;
1060: If (p_rec.absence_case_id = hr_api.g_number) then
1061: p_rec.absence_case_id :=
1062: per_abs_shd.g_old_rec.absence_case_id;
1063: End If;
1064: If (p_rec.batch_id = hr_api.g_number) then
1060: If (p_rec.absence_case_id = hr_api.g_number) then
1061: p_rec.absence_case_id :=
1062: per_abs_shd.g_old_rec.absence_case_id;
1063: End If;
1064: If (p_rec.batch_id = hr_api.g_number) then
1065: p_rec.batch_id :=
1066: per_abs_shd.g_old_rec.batch_id;
1067: End If;
1068: --
1138: Procedure upd
1139: (p_effective_date in date
1140: ,p_absence_attendance_id in number
1141: ,p_object_version_number in out nocopy number
1142: ,p_abs_attendance_reason_id in number default hr_api.g_number
1143: ,p_authorising_person_id in number default hr_api.g_number
1144: ,p_replacement_person_id in number default hr_api.g_number
1145: ,p_period_of_incapacity_id in number default hr_api.g_number
1146: ,p_absence_days in out nocopy number
1139: (p_effective_date in date
1140: ,p_absence_attendance_id in number
1141: ,p_object_version_number in out nocopy number
1142: ,p_abs_attendance_reason_id in number default hr_api.g_number
1143: ,p_authorising_person_id in number default hr_api.g_number
1144: ,p_replacement_person_id in number default hr_api.g_number
1145: ,p_period_of_incapacity_id in number default hr_api.g_number
1146: ,p_absence_days in out nocopy number
1147: ,p_absence_hours in out nocopy number
1140: ,p_absence_attendance_id in number
1141: ,p_object_version_number in out nocopy number
1142: ,p_abs_attendance_reason_id in number default hr_api.g_number
1143: ,p_authorising_person_id in number default hr_api.g_number
1144: ,p_replacement_person_id in number default hr_api.g_number
1145: ,p_period_of_incapacity_id in number default hr_api.g_number
1146: ,p_absence_days in out nocopy number
1147: ,p_absence_hours in out nocopy number
1148: --start changes for bug 5987410
1141: ,p_object_version_number in out nocopy number
1142: ,p_abs_attendance_reason_id in number default hr_api.g_number
1143: ,p_authorising_person_id in number default hr_api.g_number
1144: ,p_replacement_person_id in number default hr_api.g_number
1145: ,p_period_of_incapacity_id in number default hr_api.g_number
1146: ,p_absence_days in out nocopy number
1147: ,p_absence_hours in out nocopy number
1148: --start changes for bug 5987410
1149: --,p_comments in varchar2 default hr_api.g_varchar2
1145: ,p_period_of_incapacity_id in number default hr_api.g_number
1146: ,p_absence_days in out nocopy number
1147: ,p_absence_hours in out nocopy number
1148: --start changes for bug 5987410
1149: --,p_comments in varchar2 default hr_api.g_varchar2
1150: ,p_comments in clob default NULL -- Bug#13362792
1151: --end changes for bug 5987410
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1148: --start changes for bug 5987410
1149: --,p_comments in varchar2 default hr_api.g_varchar2
1150: ,p_comments in clob default NULL -- Bug#13362792
1151: --end changes for bug 5987410
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1149: --,p_comments in varchar2 default hr_api.g_varchar2
1150: ,p_comments in clob default NULL -- Bug#13362792
1151: --end changes for bug 5987410
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1150: ,p_comments in clob default NULL -- Bug#13362792
1151: --end changes for bug 5987410
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1151: --end changes for bug 5987410
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1152: ,p_date_notification in date default hr_api.g_date
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1153: ,p_date_start in date default hr_api.g_date
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1154: ,p_date_end in date default hr_api.g_date
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1155: ,p_date_projected_start in date default hr_api.g_date
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1156: ,p_date_projected_end in date default hr_api.g_date
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1157: ,p_time_start in varchar2 default hr_api.g_varchar2
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1158: ,p_time_end in varchar2 default hr_api.g_varchar2
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1159: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1161: ,p_occurrence in number default hr_api.g_number
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1162: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1163: ,p_request_id in number default hr_api.g_number
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1164: ,p_program_application_id in number default hr_api.g_number
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1165: ,p_program_id in number default hr_api.g_number
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1166: ,p_program_update_date in date default hr_api.g_date
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1175: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1176: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1177: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1178: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1179: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1180: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1181: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1182: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1183: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1184: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1185: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1186: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1187: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1188: ,p_maternity_id in number default hr_api.g_number
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1189: ,p_sickness_start_date in date default hr_api.g_date
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1190: ,p_sickness_end_date in date default hr_api.g_date
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1192: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1193: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1194: ,p_linked_absence_id in number default hr_api.g_number
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1196: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1197: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1198: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1199: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1200: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1201: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1202: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1203: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1204: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1205: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1206: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1207: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1208: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1209: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1210: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1211: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1212: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1213: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1214: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1215: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1216: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1217: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1218: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1219: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1227: ,p_absence_case_id in number default hr_api.g_number
1220: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1227: ,p_absence_case_id in number default hr_api.g_number
1228: ,p_dur_dys_less_warning out nocopy boolean
1221: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1227: ,p_absence_case_id in number default hr_api.g_number
1228: ,p_dur_dys_less_warning out nocopy boolean
1229: ,p_dur_hrs_less_warning out nocopy boolean
1222: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1227: ,p_absence_case_id in number default hr_api.g_number
1228: ,p_dur_dys_less_warning out nocopy boolean
1229: ,p_dur_hrs_less_warning out nocopy boolean
1230: ,p_exceeds_pto_entit_warning out nocopy boolean
1223: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1224: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1225: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1226: ,p_batch_id in number default hr_api.g_number
1227: ,p_absence_case_id in number default hr_api.g_number
1228: ,p_dur_dys_less_warning out nocopy boolean
1229: ,p_dur_hrs_less_warning out nocopy boolean
1230: ,p_exceeds_pto_entit_warning out nocopy boolean
1231: ,p_exceeds_run_total_warning out nocopy boolean
1233: ,p_abs_day_after_warning out nocopy boolean
1234: ,p_dur_overwritten_warning out nocopy boolean
1235: ) is
1236: --
1237: l_person_id number := hr_api.g_number;
1238: l_absence_attendance_type_id number := hr_api.g_number;
1239: l_business_group_id number := hr_api.g_number;
1240: l_rec per_abs_shd.g_rec_type;
1241: l_proc varchar2(72) := g_package||'upd';
1234: ,p_dur_overwritten_warning out nocopy boolean
1235: ) is
1236: --
1237: l_person_id number := hr_api.g_number;
1238: l_absence_attendance_type_id number := hr_api.g_number;
1239: l_business_group_id number := hr_api.g_number;
1240: l_rec per_abs_shd.g_rec_type;
1241: l_proc varchar2(72) := g_package||'upd';
1242: --
1235: ) is
1236: --
1237: l_person_id number := hr_api.g_number;
1238: l_absence_attendance_type_id number := hr_api.g_number;
1239: l_business_group_id number := hr_api.g_number;
1240: l_rec per_abs_shd.g_rec_type;
1241: l_proc varchar2(72) := g_package||'upd';
1242: --
1243: --
1264: ,p_date_notification
1265: ,p_date_projected_end
1266: ,p_date_projected_start
1267: ,p_date_start
1268: ,hr_api.g_number -- p_occurrence
1269: ,p_ssp1_issued
1270: ,p_time_end
1271: ,p_time_projected_end
1272: ,p_time_projected_start