DBA Data[Home] [Help]

APPS.PER_ABS_UPD dependencies on HR_API

Line 167: When hr_api.check_integrity_violated Then

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));

Line 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

Line 172: When hr_api.parent_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
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 177: When hr_api.unique_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
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 659: when hr_api.cannot_find_prog_unit then

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');

Line 661: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 1142: ,p_abs_attendance_reason_id in number default hr_api.g_number

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

Line 1143: ,p_authorising_person_id in number default hr_api.g_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

Line 1144: ,p_replacement_person_id in number default hr_api.g_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

Line 1145: ,p_period_of_incapacity_id in number default hr_api.g_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
1149: --,p_comments in varchar2 default hr_api.g_varchar2

Line 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

Line 1152: ,p_date_notification 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

Line 1153: ,p_date_start 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

Line 1154: ,p_date_end in date default hr_api.g_date

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

Line 1155: ,p_date_projected_start in date default hr_api.g_date

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

Line 1156: ,p_date_projected_end in date default hr_api.g_date

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

Line 1157: ,p_time_start 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

Line 1158: ,p_time_end in varchar2 default hr_api.g_varchar2

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

Line 1159: ,p_time_projected_start 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

Line 1160: ,p_time_projected_end in varchar2 default hr_api.g_varchar2

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

Line 1161: ,p_occurrence 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

Line 1162: ,p_ssp1_issued 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
1166: ,p_program_update_date in date default hr_api.g_date

Line 1163: ,p_request_id in number default hr_api.g_number

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

Line 1164: ,p_program_application_id in number default hr_api.g_number

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

Line 1165: ,p_program_id in number default hr_api.g_number

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

Line 1166: ,p_program_update_date in date default hr_api.g_date

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

Line 1167: ,p_attribute_category 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

Line 1168: ,p_attribute1 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

Line 1169: ,p_attribute2 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

Line 1170: ,p_attribute3 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

Line 1171: ,p_attribute4 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

Line 1172: ,p_attribute5 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

Line 1173: ,p_attribute6 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

Line 1174: ,p_attribute7 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

Line 1175: ,p_attribute8 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

Line 1176: ,p_attribute9 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

Line 1177: ,p_attribute10 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

Line 1178: ,p_attribute11 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

Line 1179: ,p_attribute12 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

Line 1180: ,p_attribute13 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

Line 1181: ,p_attribute14 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

Line 1182: ,p_attribute15 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

Line 1183: ,p_attribute16 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

Line 1184: ,p_attribute17 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

Line 1185: ,p_attribute18 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
1189: ,p_sickness_start_date in date default hr_api.g_date

Line 1186: ,p_attribute19 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
1190: ,p_sickness_end_date in date default hr_api.g_date

Line 1187: ,p_attribute20 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
1191: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

Line 1188: ,p_maternity_id in number default hr_api.g_number

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

Line 1189: ,p_sickness_start_date in date default hr_api.g_date

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

Line 1190: ,p_sickness_end_date in date default hr_api.g_date

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

Line 1191: ,p_pregnancy_related_illness 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
1195: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

Line 1192: ,p_reason_for_notification_dela 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

Line 1193: ,p_accept_late_notification_fla 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

Line 1194: ,p_linked_absence_id in number default hr_api.g_number

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

Line 1195: ,p_abs_information_category 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

Line 1196: ,p_abs_information1 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

Line 1197: ,p_abs_information2 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

Line 1198: ,p_abs_information3 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

Line 1199: ,p_abs_information4 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

Line 1200: ,p_abs_information5 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

Line 1201: ,p_abs_information6 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

Line 1202: ,p_abs_information7 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

Line 1203: ,p_abs_information8 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

Line 1204: ,p_abs_information9 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

Line 1205: ,p_abs_information10 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

Line 1206: ,p_abs_information11 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

Line 1207: ,p_abs_information12 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

Line 1208: ,p_abs_information13 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

Line 1209: ,p_abs_information14 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

Line 1210: ,p_abs_information15 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

Line 1211: ,p_abs_information16 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

Line 1212: ,p_abs_information17 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

Line 1213: ,p_abs_information18 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

Line 1214: ,p_abs_information19 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

Line 1215: ,p_abs_information20 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

Line 1216: ,p_abs_information21 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

Line 1217: ,p_abs_information22 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

Line 1218: ,p_abs_information23 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

Line 1219: ,p_abs_information24 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

Line 1220: ,p_abs_information25 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

Line 1221: ,p_abs_information26 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

Line 1222: ,p_abs_information27 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

Line 1223: ,p_abs_information28 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
1227: ,p_absence_case_id in number default hr_api.g_number

Line 1224: ,p_abs_information29 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
1228: ,p_dur_dys_less_warning out nocopy boolean

Line 1225: ,p_abs_information30 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
1229: ,p_dur_hrs_less_warning out nocopy boolean

Line 1226: ,p_batch_id in number default hr_api.g_number

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

Line 1227: ,p_absence_case_id in number default hr_api.g_number

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

Line 1237: l_person_id number := hr_api.g_number;

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';

Line 1238: l_absence_attendance_type_id number := hr_api.g_number;

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: --

Line 1239: l_business_group_id number := hr_api.g_number;

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: --

Line 1268: ,hr_api.g_number -- p_occurrence

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