186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: --
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: --
193: per_inc_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: --
193: per_inc_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: --
198: per_inc_shd.constraint_error
191: -- A check constraint has been violated
192: --
193: per_inc_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: --
198: per_inc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: --
198: per_inc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: per_inc_shd.constraint_error
196: -- Parent integrity has been violated
197: --
198: per_inc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: per_inc_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: per_inc_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: --
207: Raise;
208: End update_dml;
717: );
718: --
719: exception
720: --
721: when hr_api.cannot_find_prog_unit then
722: --
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'PER_WORK_INCIDENTS'
725: ,p_hook_type => 'AU');
719: exception
720: --
721: when hr_api.cannot_find_prog_unit then
722: --
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'PER_WORK_INCIDENTS'
725: ,p_hook_type => 'AU');
726: --
727: end;
782: -- p_rec plsql record structure
783: -- to see if a system default is being used. If a system default
784: -- is being used then we must set to the 'current' argument value.
785: --
786: If (p_rec.person_id = hr_api.g_number) then
787: p_rec.person_id :=
788: per_inc_shd.g_old_rec.person_id;
789: End If;
790: If (p_rec.incident_reference = hr_api.g_varchar2) then
786: If (p_rec.person_id = hr_api.g_number) then
787: p_rec.person_id :=
788: per_inc_shd.g_old_rec.person_id;
789: End If;
790: If (p_rec.incident_reference = hr_api.g_varchar2) then
791: p_rec.incident_reference :=
792: per_inc_shd.g_old_rec.incident_reference;
793: End If;
794: If (p_rec.incident_type = hr_api.g_varchar2) then
790: If (p_rec.incident_reference = hr_api.g_varchar2) then
791: p_rec.incident_reference :=
792: per_inc_shd.g_old_rec.incident_reference;
793: End If;
794: If (p_rec.incident_type = hr_api.g_varchar2) then
795: p_rec.incident_type :=
796: per_inc_shd.g_old_rec.incident_type;
797: End If;
798: If (p_rec.incident_date = hr_api.g_date) then
794: If (p_rec.incident_type = hr_api.g_varchar2) then
795: p_rec.incident_type :=
796: per_inc_shd.g_old_rec.incident_type;
797: End If;
798: If (p_rec.incident_date = hr_api.g_date) then
799: p_rec.incident_date :=
800: per_inc_shd.g_old_rec.incident_date;
801: End If;
802: If (p_rec.incident_time = hr_api.g_varchar2) then
798: If (p_rec.incident_date = hr_api.g_date) then
799: p_rec.incident_date :=
800: per_inc_shd.g_old_rec.incident_date;
801: End If;
802: If (p_rec.incident_time = hr_api.g_varchar2) then
803: p_rec.incident_time :=
804: per_inc_shd.g_old_rec.incident_time;
805: End If;
806: If (p_rec.org_notified_date = hr_api.g_date) then
802: If (p_rec.incident_time = hr_api.g_varchar2) then
803: p_rec.incident_time :=
804: per_inc_shd.g_old_rec.incident_time;
805: End If;
806: If (p_rec.org_notified_date = hr_api.g_date) then
807: p_rec.org_notified_date :=
808: per_inc_shd.g_old_rec.org_notified_date;
809: End If;
810: If (p_rec.assignment_id = hr_api.g_number) then
806: If (p_rec.org_notified_date = hr_api.g_date) then
807: p_rec.org_notified_date :=
808: per_inc_shd.g_old_rec.org_notified_date;
809: End If;
810: If (p_rec.assignment_id = hr_api.g_number) then
811: p_rec.assignment_id :=
812: per_inc_shd.g_old_rec.assignment_id;
813: End If;
814: If (p_rec.location = hr_api.g_varchar2) then
810: If (p_rec.assignment_id = hr_api.g_number) then
811: p_rec.assignment_id :=
812: per_inc_shd.g_old_rec.assignment_id;
813: End If;
814: If (p_rec.location = hr_api.g_varchar2) then
815: p_rec.location :=
816: per_inc_shd.g_old_rec.location;
817: End If;
818: If (p_rec.at_work_flag = hr_api.g_varchar2) then
814: If (p_rec.location = hr_api.g_varchar2) then
815: p_rec.location :=
816: per_inc_shd.g_old_rec.location;
817: End If;
818: If (p_rec.at_work_flag = hr_api.g_varchar2) then
819: p_rec.at_work_flag :=
820: per_inc_shd.g_old_rec.at_work_flag;
821: End If;
822: If (p_rec.report_date = hr_api.g_date) then
818: If (p_rec.at_work_flag = hr_api.g_varchar2) then
819: p_rec.at_work_flag :=
820: per_inc_shd.g_old_rec.at_work_flag;
821: End If;
822: If (p_rec.report_date = hr_api.g_date) then
823: p_rec.report_date :=
824: per_inc_shd.g_old_rec.report_date;
825: End If;
826: If (p_rec.report_time = hr_api.g_varchar2) then
822: If (p_rec.report_date = hr_api.g_date) then
823: p_rec.report_date :=
824: per_inc_shd.g_old_rec.report_date;
825: End If;
826: If (p_rec.report_time = hr_api.g_varchar2) then
827: p_rec.report_time :=
828: per_inc_shd.g_old_rec.report_time;
829: End If;
830: If (p_rec.report_method = hr_api.g_varchar2) then
826: If (p_rec.report_time = hr_api.g_varchar2) then
827: p_rec.report_time :=
828: per_inc_shd.g_old_rec.report_time;
829: End If;
830: If (p_rec.report_method = hr_api.g_varchar2) then
831: p_rec.report_method :=
832: per_inc_shd.g_old_rec.report_method;
833: End If;
834: If (p_rec.person_reported_by = hr_api.g_number) then
830: If (p_rec.report_method = hr_api.g_varchar2) then
831: p_rec.report_method :=
832: per_inc_shd.g_old_rec.report_method;
833: End If;
834: If (p_rec.person_reported_by = hr_api.g_number) then
835: p_rec.person_reported_by :=
836: per_inc_shd.g_old_rec.person_reported_by;
837: End If;
838: If (p_rec.person_reported_to = hr_api.g_varchar2) then
834: If (p_rec.person_reported_by = hr_api.g_number) then
835: p_rec.person_reported_by :=
836: per_inc_shd.g_old_rec.person_reported_by;
837: End If;
838: If (p_rec.person_reported_to = hr_api.g_varchar2) then
839: p_rec.person_reported_to :=
840: per_inc_shd.g_old_rec.person_reported_to;
841: End If;
842: If (p_rec.witness_details = hr_api.g_varchar2) then
838: If (p_rec.person_reported_to = hr_api.g_varchar2) then
839: p_rec.person_reported_to :=
840: per_inc_shd.g_old_rec.person_reported_to;
841: End If;
842: If (p_rec.witness_details = hr_api.g_varchar2) then
843: p_rec.witness_details :=
844: per_inc_shd.g_old_rec.witness_details;
845: End If;
846: If (p_rec.description = hr_api.g_varchar2) then
842: If (p_rec.witness_details = hr_api.g_varchar2) then
843: p_rec.witness_details :=
844: per_inc_shd.g_old_rec.witness_details;
845: End If;
846: If (p_rec.description = hr_api.g_varchar2) then
847: p_rec.description :=
848: per_inc_shd.g_old_rec.description;
849: End If;
850: If (p_rec.injury_type = hr_api.g_varchar2) then
846: If (p_rec.description = hr_api.g_varchar2) then
847: p_rec.description :=
848: per_inc_shd.g_old_rec.description;
849: End If;
850: If (p_rec.injury_type = hr_api.g_varchar2) then
851: p_rec.injury_type :=
852: per_inc_shd.g_old_rec.injury_type;
853: End If;
854: If (p_rec.disease_type = hr_api.g_varchar2) then
850: If (p_rec.injury_type = hr_api.g_varchar2) then
851: p_rec.injury_type :=
852: per_inc_shd.g_old_rec.injury_type;
853: End If;
854: If (p_rec.disease_type = hr_api.g_varchar2) then
855: p_rec.disease_type :=
856: per_inc_shd.g_old_rec.disease_type;
857: End If;
858: If (p_rec.hazard_type = hr_api.g_varchar2) then
854: If (p_rec.disease_type = hr_api.g_varchar2) then
855: p_rec.disease_type :=
856: per_inc_shd.g_old_rec.disease_type;
857: End If;
858: If (p_rec.hazard_type = hr_api.g_varchar2) then
859: p_rec.hazard_type :=
860: per_inc_shd.g_old_rec.hazard_type;
861: End If;
862: If (p_rec.body_part = hr_api.g_varchar2) then
858: If (p_rec.hazard_type = hr_api.g_varchar2) then
859: p_rec.hazard_type :=
860: per_inc_shd.g_old_rec.hazard_type;
861: End If;
862: If (p_rec.body_part = hr_api.g_varchar2) then
863: p_rec.body_part :=
864: per_inc_shd.g_old_rec.body_part;
865: End If;
866: If (p_rec.treatment_received_flag = hr_api.g_varchar2) then
862: If (p_rec.body_part = hr_api.g_varchar2) then
863: p_rec.body_part :=
864: per_inc_shd.g_old_rec.body_part;
865: End If;
866: If (p_rec.treatment_received_flag = hr_api.g_varchar2) then
867: p_rec.treatment_received_flag :=
868: per_inc_shd.g_old_rec.treatment_received_flag;
869: End If;
870: If (p_rec.hospital_details = hr_api.g_varchar2) then
866: If (p_rec.treatment_received_flag = hr_api.g_varchar2) then
867: p_rec.treatment_received_flag :=
868: per_inc_shd.g_old_rec.treatment_received_flag;
869: End If;
870: If (p_rec.hospital_details = hr_api.g_varchar2) then
871: p_rec.hospital_details :=
872: per_inc_shd.g_old_rec.hospital_details;
873: End If;
874: --
874: --
875: --
876: --
877: --
878: If (p_rec.emergency_code = hr_api.g_varchar2) then
879: p_rec.emergency_code :=
880: per_inc_shd.g_old_rec.emergency_code;
881: End If;
882: If (p_rec.hospitalized_flag = hr_api.g_varchar2) then
878: If (p_rec.emergency_code = hr_api.g_varchar2) then
879: p_rec.emergency_code :=
880: per_inc_shd.g_old_rec.emergency_code;
881: End If;
882: If (p_rec.hospitalized_flag = hr_api.g_varchar2) then
883: p_rec.hospitalized_flag :=
884: per_inc_shd.g_old_rec.hospitalized_flag;
885: End If;
886: If (p_rec.hospital_address = hr_api.g_varchar2) then
882: If (p_rec.hospitalized_flag = hr_api.g_varchar2) then
883: p_rec.hospitalized_flag :=
884: per_inc_shd.g_old_rec.hospitalized_flag;
885: End If;
886: If (p_rec.hospital_address = hr_api.g_varchar2) then
887: p_rec.hospital_address :=
888: per_inc_shd.g_old_rec.hospital_address;
889: End If;
890: If (p_rec.activity_at_time_of_work = hr_api.g_varchar2) then
886: If (p_rec.hospital_address = hr_api.g_varchar2) then
887: p_rec.hospital_address :=
888: per_inc_shd.g_old_rec.hospital_address;
889: End If;
890: If (p_rec.activity_at_time_of_work = hr_api.g_varchar2) then
891: p_rec.activity_at_time_of_work :=
892: per_inc_shd.g_old_rec.activity_at_time_of_work;
893: End If;
894: If (p_rec.objects_involved = hr_api.g_varchar2) then
890: If (p_rec.activity_at_time_of_work = hr_api.g_varchar2) then
891: p_rec.activity_at_time_of_work :=
892: per_inc_shd.g_old_rec.activity_at_time_of_work;
893: End If;
894: If (p_rec.objects_involved = hr_api.g_varchar2) then
895: p_rec.objects_involved :=
896: per_inc_shd.g_old_rec.objects_involved;
897: End If;
898: If (p_rec.privacy_issue = hr_api.g_varchar2) then
894: If (p_rec.objects_involved = hr_api.g_varchar2) then
895: p_rec.objects_involved :=
896: per_inc_shd.g_old_rec.objects_involved;
897: End If;
898: If (p_rec.privacy_issue = hr_api.g_varchar2) then
899: p_rec.privacy_issue :=
900: per_inc_shd.g_old_rec.privacy_issue;
901: End If;
902: If (p_rec.work_start_time = hr_api.g_varchar2) then
898: If (p_rec.privacy_issue = hr_api.g_varchar2) then
899: p_rec.privacy_issue :=
900: per_inc_shd.g_old_rec.privacy_issue;
901: End If;
902: If (p_rec.work_start_time = hr_api.g_varchar2) then
903: p_rec.work_start_time :=
904: per_inc_shd.g_old_rec.work_start_time;
905: End If;
906: If (p_rec.date_of_death = hr_api.g_date) then
902: If (p_rec.work_start_time = hr_api.g_varchar2) then
903: p_rec.work_start_time :=
904: per_inc_shd.g_old_rec.work_start_time;
905: End If;
906: If (p_rec.date_of_death = hr_api.g_date) then
907: p_rec.date_of_death :=
908: per_inc_shd.g_old_rec.date_of_death;
909: End If;
910: If (p_rec.report_completed_by = hr_api.g_varchar2) then
906: If (p_rec.date_of_death = hr_api.g_date) then
907: p_rec.date_of_death :=
908: per_inc_shd.g_old_rec.date_of_death;
909: End If;
910: If (p_rec.report_completed_by = hr_api.g_varchar2) then
911: p_rec.report_completed_by :=
912: per_inc_shd.g_old_rec.report_completed_by;
913: End If;
914: If (p_rec.reporting_person_title = hr_api.g_varchar2) then
910: If (p_rec.report_completed_by = hr_api.g_varchar2) then
911: p_rec.report_completed_by :=
912: per_inc_shd.g_old_rec.report_completed_by;
913: End If;
914: If (p_rec.reporting_person_title = hr_api.g_varchar2) then
915: p_rec.reporting_person_title :=
916: per_inc_shd.g_old_rec.reporting_person_title;
917: End If;
918: If (p_rec.reporting_person_phone = hr_api.g_varchar2) then
914: If (p_rec.reporting_person_title = hr_api.g_varchar2) then
915: p_rec.reporting_person_title :=
916: per_inc_shd.g_old_rec.reporting_person_title;
917: End If;
918: If (p_rec.reporting_person_phone = hr_api.g_varchar2) then
919: p_rec.reporting_person_phone :=
920: per_inc_shd.g_old_rec.reporting_person_phone;
921: End If;
922: If (p_rec.days_restricted_work = hr_api.g_number) then
918: If (p_rec.reporting_person_phone = hr_api.g_varchar2) then
919: p_rec.reporting_person_phone :=
920: per_inc_shd.g_old_rec.reporting_person_phone;
921: End If;
922: If (p_rec.days_restricted_work = hr_api.g_number) then
923: p_rec.days_restricted_work :=
924: per_inc_shd.g_old_rec.days_restricted_work;
925: End If;
926: If (p_rec.days_away_from_work = hr_api.g_number) then
922: If (p_rec.days_restricted_work = hr_api.g_number) then
923: p_rec.days_restricted_work :=
924: per_inc_shd.g_old_rec.days_restricted_work;
925: End If;
926: If (p_rec.days_away_from_work = hr_api.g_number) then
927: p_rec.days_away_from_work :=
928: per_inc_shd.g_old_rec.days_away_from_work;
929: End If;
930: --
931: --
932: --
933: --
934:
935: If (p_rec.doctor_name = hr_api.g_varchar2) then
936: p_rec.doctor_name :=
937: per_inc_shd.g_old_rec.doctor_name;
938: End If;
939: If (p_rec.compensation_date = hr_api.g_date) then
935: If (p_rec.doctor_name = hr_api.g_varchar2) then
936: p_rec.doctor_name :=
937: per_inc_shd.g_old_rec.doctor_name;
938: End If;
939: If (p_rec.compensation_date = hr_api.g_date) then
940: p_rec.compensation_date :=
941: per_inc_shd.g_old_rec.compensation_date;
942: End If;
943: If (p_rec.compensation_currency = hr_api.g_varchar2) then
939: If (p_rec.compensation_date = hr_api.g_date) then
940: p_rec.compensation_date :=
941: per_inc_shd.g_old_rec.compensation_date;
942: End If;
943: If (p_rec.compensation_currency = hr_api.g_varchar2) then
944: p_rec.compensation_currency :=
945: per_inc_shd.g_old_rec.compensation_currency;
946: End If;
947: If (p_rec.compensation_amount = hr_api.g_number) then
943: If (p_rec.compensation_currency = hr_api.g_varchar2) then
944: p_rec.compensation_currency :=
945: per_inc_shd.g_old_rec.compensation_currency;
946: End If;
947: If (p_rec.compensation_amount = hr_api.g_number) then
948: p_rec.compensation_amount :=
949: per_inc_shd.g_old_rec.compensation_amount;
950: End If;
951: If (p_rec.remedial_hs_action = hr_api.g_varchar2) then
947: If (p_rec.compensation_amount = hr_api.g_number) then
948: p_rec.compensation_amount :=
949: per_inc_shd.g_old_rec.compensation_amount;
950: End If;
951: If (p_rec.remedial_hs_action = hr_api.g_varchar2) then
952: p_rec.remedial_hs_action :=
953: per_inc_shd.g_old_rec.remedial_hs_action;
954: End If;
955: If (p_rec.notified_hsrep_id = hr_api.g_number) then
951: If (p_rec.remedial_hs_action = hr_api.g_varchar2) then
952: p_rec.remedial_hs_action :=
953: per_inc_shd.g_old_rec.remedial_hs_action;
954: End If;
955: If (p_rec.notified_hsrep_id = hr_api.g_number) then
956: p_rec.notified_hsrep_id :=
957: per_inc_shd.g_old_rec.notified_hsrep_id;
958: End If;
959: If (p_rec.notified_hsrep_date = hr_api.g_date) then
955: If (p_rec.notified_hsrep_id = hr_api.g_number) then
956: p_rec.notified_hsrep_id :=
957: per_inc_shd.g_old_rec.notified_hsrep_id;
958: End If;
959: If (p_rec.notified_hsrep_date = hr_api.g_date) then
960: p_rec.notified_hsrep_date :=
961: per_inc_shd.g_old_rec.notified_hsrep_date;
962: End If;
963: If (p_rec.notified_rep_id = hr_api.g_number) then
959: If (p_rec.notified_hsrep_date = hr_api.g_date) then
960: p_rec.notified_hsrep_date :=
961: per_inc_shd.g_old_rec.notified_hsrep_date;
962: End If;
963: If (p_rec.notified_rep_id = hr_api.g_number) then
964: p_rec.notified_rep_id :=
965: per_inc_shd.g_old_rec.notified_rep_id;
966: End If;
967: If (p_rec.notified_rep_date = hr_api.g_date) then
963: If (p_rec.notified_rep_id = hr_api.g_number) then
964: p_rec.notified_rep_id :=
965: per_inc_shd.g_old_rec.notified_rep_id;
966: End If;
967: If (p_rec.notified_rep_date = hr_api.g_date) then
968: p_rec.notified_rep_date :=
969: per_inc_shd.g_old_rec.notified_rep_date;
970: End If;
971: If (p_rec.notified_rep_org_id = hr_api.g_number) then
967: If (p_rec.notified_rep_date = hr_api.g_date) then
968: p_rec.notified_rep_date :=
969: per_inc_shd.g_old_rec.notified_rep_date;
970: End If;
971: If (p_rec.notified_rep_org_id = hr_api.g_number) then
972: p_rec.notified_rep_org_id :=
973: per_inc_shd.g_old_rec.notified_rep_org_id;
974: End If;
975: If (p_rec.related_incident_id = hr_api.g_number) then
971: If (p_rec.notified_rep_org_id = hr_api.g_number) then
972: p_rec.notified_rep_org_id :=
973: per_inc_shd.g_old_rec.notified_rep_org_id;
974: End If;
975: If (p_rec.related_incident_id = hr_api.g_number) then
976: p_rec.related_incident_id :=
977: per_inc_shd.g_old_rec.related_incident_id;
978: End If;
979: If (p_rec.over_time_flag = hr_api.g_varchar2) then
975: If (p_rec.related_incident_id = hr_api.g_number) then
976: p_rec.related_incident_id :=
977: per_inc_shd.g_old_rec.related_incident_id;
978: End If;
979: If (p_rec.over_time_flag = hr_api.g_varchar2) then
980: p_rec.over_time_flag :=
981: per_inc_shd.g_old_rec.over_time_flag;
982: End If;
983: If (p_rec.absence_exists_flag = hr_api.g_varchar2) then
979: If (p_rec.over_time_flag = hr_api.g_varchar2) then
980: p_rec.over_time_flag :=
981: per_inc_shd.g_old_rec.over_time_flag;
982: End If;
983: If (p_rec.absence_exists_flag = hr_api.g_varchar2) then
984: p_rec.absence_exists_flag :=
985: per_inc_shd.g_old_rec.absence_exists_flag;
986: End If;
987: If (p_rec.attribute_category = hr_api.g_varchar2) then
983: If (p_rec.absence_exists_flag = hr_api.g_varchar2) then
984: p_rec.absence_exists_flag :=
985: per_inc_shd.g_old_rec.absence_exists_flag;
986: End If;
987: If (p_rec.attribute_category = hr_api.g_varchar2) then
988: p_rec.attribute_category :=
989: per_inc_shd.g_old_rec.attribute_category;
990: End If;
991: If (p_rec.attribute1 = hr_api.g_varchar2) then
987: If (p_rec.attribute_category = hr_api.g_varchar2) then
988: p_rec.attribute_category :=
989: per_inc_shd.g_old_rec.attribute_category;
990: End If;
991: If (p_rec.attribute1 = hr_api.g_varchar2) then
992: p_rec.attribute1 :=
993: per_inc_shd.g_old_rec.attribute1;
994: End If;
995: If (p_rec.attribute2 = hr_api.g_varchar2) then
991: If (p_rec.attribute1 = hr_api.g_varchar2) then
992: p_rec.attribute1 :=
993: per_inc_shd.g_old_rec.attribute1;
994: End If;
995: If (p_rec.attribute2 = hr_api.g_varchar2) then
996: p_rec.attribute2 :=
997: per_inc_shd.g_old_rec.attribute2;
998: End If;
999: If (p_rec.attribute3 = hr_api.g_varchar2) then
995: If (p_rec.attribute2 = hr_api.g_varchar2) then
996: p_rec.attribute2 :=
997: per_inc_shd.g_old_rec.attribute2;
998: End If;
999: If (p_rec.attribute3 = hr_api.g_varchar2) then
1000: p_rec.attribute3 :=
1001: per_inc_shd.g_old_rec.attribute3;
1002: End If;
1003: If (p_rec.attribute4 = hr_api.g_varchar2) then
999: If (p_rec.attribute3 = hr_api.g_varchar2) then
1000: p_rec.attribute3 :=
1001: per_inc_shd.g_old_rec.attribute3;
1002: End If;
1003: If (p_rec.attribute4 = hr_api.g_varchar2) then
1004: p_rec.attribute4 :=
1005: per_inc_shd.g_old_rec.attribute4;
1006: End If;
1007: If (p_rec.attribute5 = hr_api.g_varchar2) then
1003: If (p_rec.attribute4 = hr_api.g_varchar2) then
1004: p_rec.attribute4 :=
1005: per_inc_shd.g_old_rec.attribute4;
1006: End If;
1007: If (p_rec.attribute5 = hr_api.g_varchar2) then
1008: p_rec.attribute5 :=
1009: per_inc_shd.g_old_rec.attribute5;
1010: End If;
1011: If (p_rec.attribute6 = hr_api.g_varchar2) then
1007: If (p_rec.attribute5 = hr_api.g_varchar2) then
1008: p_rec.attribute5 :=
1009: per_inc_shd.g_old_rec.attribute5;
1010: End If;
1011: If (p_rec.attribute6 = hr_api.g_varchar2) then
1012: p_rec.attribute6 :=
1013: per_inc_shd.g_old_rec.attribute6;
1014: End If;
1015: If (p_rec.attribute7 = hr_api.g_varchar2) then
1011: If (p_rec.attribute6 = hr_api.g_varchar2) then
1012: p_rec.attribute6 :=
1013: per_inc_shd.g_old_rec.attribute6;
1014: End If;
1015: If (p_rec.attribute7 = hr_api.g_varchar2) then
1016: p_rec.attribute7 :=
1017: per_inc_shd.g_old_rec.attribute7;
1018: End If;
1019: If (p_rec.attribute8 = hr_api.g_varchar2) then
1015: If (p_rec.attribute7 = hr_api.g_varchar2) then
1016: p_rec.attribute7 :=
1017: per_inc_shd.g_old_rec.attribute7;
1018: End If;
1019: If (p_rec.attribute8 = hr_api.g_varchar2) then
1020: p_rec.attribute8 :=
1021: per_inc_shd.g_old_rec.attribute8;
1022: End If;
1023: If (p_rec.attribute9 = hr_api.g_varchar2) then
1019: If (p_rec.attribute8 = hr_api.g_varchar2) then
1020: p_rec.attribute8 :=
1021: per_inc_shd.g_old_rec.attribute8;
1022: End If;
1023: If (p_rec.attribute9 = hr_api.g_varchar2) then
1024: p_rec.attribute9 :=
1025: per_inc_shd.g_old_rec.attribute9;
1026: End If;
1027: If (p_rec.attribute10 = hr_api.g_varchar2) then
1023: If (p_rec.attribute9 = hr_api.g_varchar2) then
1024: p_rec.attribute9 :=
1025: per_inc_shd.g_old_rec.attribute9;
1026: End If;
1027: If (p_rec.attribute10 = hr_api.g_varchar2) then
1028: p_rec.attribute10 :=
1029: per_inc_shd.g_old_rec.attribute10;
1030: End If;
1031: If (p_rec.attribute11 = hr_api.g_varchar2) then
1027: If (p_rec.attribute10 = hr_api.g_varchar2) then
1028: p_rec.attribute10 :=
1029: per_inc_shd.g_old_rec.attribute10;
1030: End If;
1031: If (p_rec.attribute11 = hr_api.g_varchar2) then
1032: p_rec.attribute11 :=
1033: per_inc_shd.g_old_rec.attribute11;
1034: End If;
1035: If (p_rec.attribute12 = hr_api.g_varchar2) then
1031: If (p_rec.attribute11 = hr_api.g_varchar2) then
1032: p_rec.attribute11 :=
1033: per_inc_shd.g_old_rec.attribute11;
1034: End If;
1035: If (p_rec.attribute12 = hr_api.g_varchar2) then
1036: p_rec.attribute12 :=
1037: per_inc_shd.g_old_rec.attribute12;
1038: End If;
1039: If (p_rec.attribute13 = hr_api.g_varchar2) then
1035: If (p_rec.attribute12 = hr_api.g_varchar2) then
1036: p_rec.attribute12 :=
1037: per_inc_shd.g_old_rec.attribute12;
1038: End If;
1039: If (p_rec.attribute13 = hr_api.g_varchar2) then
1040: p_rec.attribute13 :=
1041: per_inc_shd.g_old_rec.attribute13;
1042: End If;
1043: If (p_rec.attribute14 = hr_api.g_varchar2) then
1039: If (p_rec.attribute13 = hr_api.g_varchar2) then
1040: p_rec.attribute13 :=
1041: per_inc_shd.g_old_rec.attribute13;
1042: End If;
1043: If (p_rec.attribute14 = hr_api.g_varchar2) then
1044: p_rec.attribute14 :=
1045: per_inc_shd.g_old_rec.attribute14;
1046: End If;
1047: If (p_rec.attribute15 = hr_api.g_varchar2) then
1043: If (p_rec.attribute14 = hr_api.g_varchar2) then
1044: p_rec.attribute14 :=
1045: per_inc_shd.g_old_rec.attribute14;
1046: End If;
1047: If (p_rec.attribute15 = hr_api.g_varchar2) then
1048: p_rec.attribute15 :=
1049: per_inc_shd.g_old_rec.attribute15;
1050: End If;
1051: If (p_rec.attribute16 = hr_api.g_varchar2) then
1047: If (p_rec.attribute15 = hr_api.g_varchar2) then
1048: p_rec.attribute15 :=
1049: per_inc_shd.g_old_rec.attribute15;
1050: End If;
1051: If (p_rec.attribute16 = hr_api.g_varchar2) then
1052: p_rec.attribute16 :=
1053: per_inc_shd.g_old_rec.attribute16;
1054: End If;
1055: If (p_rec.attribute17 = hr_api.g_varchar2) then
1051: If (p_rec.attribute16 = hr_api.g_varchar2) then
1052: p_rec.attribute16 :=
1053: per_inc_shd.g_old_rec.attribute16;
1054: End If;
1055: If (p_rec.attribute17 = hr_api.g_varchar2) then
1056: p_rec.attribute17 :=
1057: per_inc_shd.g_old_rec.attribute17;
1058: End If;
1059: If (p_rec.attribute18 = hr_api.g_varchar2) then
1055: If (p_rec.attribute17 = hr_api.g_varchar2) then
1056: p_rec.attribute17 :=
1057: per_inc_shd.g_old_rec.attribute17;
1058: End If;
1059: If (p_rec.attribute18 = hr_api.g_varchar2) then
1060: p_rec.attribute18 :=
1061: per_inc_shd.g_old_rec.attribute18;
1062: End If;
1063: If (p_rec.attribute19 = hr_api.g_varchar2) then
1059: If (p_rec.attribute18 = hr_api.g_varchar2) then
1060: p_rec.attribute18 :=
1061: per_inc_shd.g_old_rec.attribute18;
1062: End If;
1063: If (p_rec.attribute19 = hr_api.g_varchar2) then
1064: p_rec.attribute19 :=
1065: per_inc_shd.g_old_rec.attribute19;
1066: End If;
1067: If (p_rec.attribute20 = hr_api.g_varchar2) then
1063: If (p_rec.attribute19 = hr_api.g_varchar2) then
1064: p_rec.attribute19 :=
1065: per_inc_shd.g_old_rec.attribute19;
1066: End If;
1067: If (p_rec.attribute20 = hr_api.g_varchar2) then
1068: p_rec.attribute20 :=
1069: per_inc_shd.g_old_rec.attribute20;
1070: End If;
1071: If (p_rec.attribute21 = hr_api.g_varchar2) then
1067: If (p_rec.attribute20 = hr_api.g_varchar2) then
1068: p_rec.attribute20 :=
1069: per_inc_shd.g_old_rec.attribute20;
1070: End If;
1071: If (p_rec.attribute21 = hr_api.g_varchar2) then
1072: p_rec.attribute21 :=
1073: per_inc_shd.g_old_rec.attribute21;
1074: End If;
1075: If (p_rec.attribute22 = hr_api.g_varchar2) then
1071: If (p_rec.attribute21 = hr_api.g_varchar2) then
1072: p_rec.attribute21 :=
1073: per_inc_shd.g_old_rec.attribute21;
1074: End If;
1075: If (p_rec.attribute22 = hr_api.g_varchar2) then
1076: p_rec.attribute22 :=
1077: per_inc_shd.g_old_rec.attribute22;
1078: End If;
1079: If (p_rec.attribute23 = hr_api.g_varchar2) then
1075: If (p_rec.attribute22 = hr_api.g_varchar2) then
1076: p_rec.attribute22 :=
1077: per_inc_shd.g_old_rec.attribute22;
1078: End If;
1079: If (p_rec.attribute23 = hr_api.g_varchar2) then
1080: p_rec.attribute23 :=
1081: per_inc_shd.g_old_rec.attribute23;
1082: End If;
1083: If (p_rec.attribute24 = hr_api.g_varchar2) then
1079: If (p_rec.attribute23 = hr_api.g_varchar2) then
1080: p_rec.attribute23 :=
1081: per_inc_shd.g_old_rec.attribute23;
1082: End If;
1083: If (p_rec.attribute24 = hr_api.g_varchar2) then
1084: p_rec.attribute24 :=
1085: per_inc_shd.g_old_rec.attribute24;
1086: End If;
1087: If (p_rec.attribute25 = hr_api.g_varchar2) then
1083: If (p_rec.attribute24 = hr_api.g_varchar2) then
1084: p_rec.attribute24 :=
1085: per_inc_shd.g_old_rec.attribute24;
1086: End If;
1087: If (p_rec.attribute25 = hr_api.g_varchar2) then
1088: p_rec.attribute25 :=
1089: per_inc_shd.g_old_rec.attribute25;
1090: End If;
1091: If (p_rec.attribute26 = hr_api.g_varchar2) then
1087: If (p_rec.attribute25 = hr_api.g_varchar2) then
1088: p_rec.attribute25 :=
1089: per_inc_shd.g_old_rec.attribute25;
1090: End If;
1091: If (p_rec.attribute26 = hr_api.g_varchar2) then
1092: p_rec.attribute26 :=
1093: per_inc_shd.g_old_rec.attribute26;
1094: End If;
1095: If (p_rec.attribute27 = hr_api.g_varchar2) then
1091: If (p_rec.attribute26 = hr_api.g_varchar2) then
1092: p_rec.attribute26 :=
1093: per_inc_shd.g_old_rec.attribute26;
1094: End If;
1095: If (p_rec.attribute27 = hr_api.g_varchar2) then
1096: p_rec.attribute27 :=
1097: per_inc_shd.g_old_rec.attribute27;
1098: End If;
1099: If (p_rec.attribute28 = hr_api.g_varchar2) then
1095: If (p_rec.attribute27 = hr_api.g_varchar2) then
1096: p_rec.attribute27 :=
1097: per_inc_shd.g_old_rec.attribute27;
1098: End If;
1099: If (p_rec.attribute28 = hr_api.g_varchar2) then
1100: p_rec.attribute28 :=
1101: per_inc_shd.g_old_rec.attribute28;
1102: End If;
1103: If (p_rec.attribute29 = hr_api.g_varchar2) then
1099: If (p_rec.attribute28 = hr_api.g_varchar2) then
1100: p_rec.attribute28 :=
1101: per_inc_shd.g_old_rec.attribute28;
1102: End If;
1103: If (p_rec.attribute29 = hr_api.g_varchar2) then
1104: p_rec.attribute29 :=
1105: per_inc_shd.g_old_rec.attribute29;
1106: End If;
1107: If (p_rec.attribute30 = hr_api.g_varchar2) then
1103: If (p_rec.attribute29 = hr_api.g_varchar2) then
1104: p_rec.attribute29 :=
1105: per_inc_shd.g_old_rec.attribute29;
1106: End If;
1107: If (p_rec.attribute30 = hr_api.g_varchar2) then
1108: p_rec.attribute30 :=
1109: per_inc_shd.g_old_rec.attribute30;
1110: End If;
1111: If (p_rec.inc_information_category = hr_api.g_varchar2) then
1107: If (p_rec.attribute30 = hr_api.g_varchar2) then
1108: p_rec.attribute30 :=
1109: per_inc_shd.g_old_rec.attribute30;
1110: End If;
1111: If (p_rec.inc_information_category = hr_api.g_varchar2) then
1112: p_rec.inc_information_category :=
1113: per_inc_shd.g_old_rec.inc_information_category;
1114: End If;
1115: If (p_rec.inc_information1 = hr_api.g_varchar2) then
1111: If (p_rec.inc_information_category = hr_api.g_varchar2) then
1112: p_rec.inc_information_category :=
1113: per_inc_shd.g_old_rec.inc_information_category;
1114: End If;
1115: If (p_rec.inc_information1 = hr_api.g_varchar2) then
1116: p_rec.inc_information1 :=
1117: per_inc_shd.g_old_rec.inc_information1;
1118: End If;
1119: If (p_rec.inc_information2 = hr_api.g_varchar2) then
1115: If (p_rec.inc_information1 = hr_api.g_varchar2) then
1116: p_rec.inc_information1 :=
1117: per_inc_shd.g_old_rec.inc_information1;
1118: End If;
1119: If (p_rec.inc_information2 = hr_api.g_varchar2) then
1120: p_rec.inc_information2 :=
1121: per_inc_shd.g_old_rec.inc_information2;
1122: End If;
1123: If (p_rec.inc_information3 = hr_api.g_varchar2) then
1119: If (p_rec.inc_information2 = hr_api.g_varchar2) then
1120: p_rec.inc_information2 :=
1121: per_inc_shd.g_old_rec.inc_information2;
1122: End If;
1123: If (p_rec.inc_information3 = hr_api.g_varchar2) then
1124: p_rec.inc_information3 :=
1125: per_inc_shd.g_old_rec.inc_information3;
1126: End If;
1127: If (p_rec.inc_information4 = hr_api.g_varchar2) then
1123: If (p_rec.inc_information3 = hr_api.g_varchar2) then
1124: p_rec.inc_information3 :=
1125: per_inc_shd.g_old_rec.inc_information3;
1126: End If;
1127: If (p_rec.inc_information4 = hr_api.g_varchar2) then
1128: p_rec.inc_information4 :=
1129: per_inc_shd.g_old_rec.inc_information4;
1130: End If;
1131: If (p_rec.inc_information5 = hr_api.g_varchar2) then
1127: If (p_rec.inc_information4 = hr_api.g_varchar2) then
1128: p_rec.inc_information4 :=
1129: per_inc_shd.g_old_rec.inc_information4;
1130: End If;
1131: If (p_rec.inc_information5 = hr_api.g_varchar2) then
1132: p_rec.inc_information5 :=
1133: per_inc_shd.g_old_rec.inc_information5;
1134: End If;
1135: If (p_rec.inc_information6 = hr_api.g_varchar2) then
1131: If (p_rec.inc_information5 = hr_api.g_varchar2) then
1132: p_rec.inc_information5 :=
1133: per_inc_shd.g_old_rec.inc_information5;
1134: End If;
1135: If (p_rec.inc_information6 = hr_api.g_varchar2) then
1136: p_rec.inc_information6 :=
1137: per_inc_shd.g_old_rec.inc_information6;
1138: End If;
1139: If (p_rec.inc_information7 = hr_api.g_varchar2) then
1135: If (p_rec.inc_information6 = hr_api.g_varchar2) then
1136: p_rec.inc_information6 :=
1137: per_inc_shd.g_old_rec.inc_information6;
1138: End If;
1139: If (p_rec.inc_information7 = hr_api.g_varchar2) then
1140: p_rec.inc_information7 :=
1141: per_inc_shd.g_old_rec.inc_information7;
1142: End If;
1143: If (p_rec.inc_information8 = hr_api.g_varchar2) then
1139: If (p_rec.inc_information7 = hr_api.g_varchar2) then
1140: p_rec.inc_information7 :=
1141: per_inc_shd.g_old_rec.inc_information7;
1142: End If;
1143: If (p_rec.inc_information8 = hr_api.g_varchar2) then
1144: p_rec.inc_information8 :=
1145: per_inc_shd.g_old_rec.inc_information8;
1146: End If;
1147: If (p_rec.inc_information9 = hr_api.g_varchar2) then
1143: If (p_rec.inc_information8 = hr_api.g_varchar2) then
1144: p_rec.inc_information8 :=
1145: per_inc_shd.g_old_rec.inc_information8;
1146: End If;
1147: If (p_rec.inc_information9 = hr_api.g_varchar2) then
1148: p_rec.inc_information9 :=
1149: per_inc_shd.g_old_rec.inc_information9;
1150: End If;
1151: If (p_rec.inc_information10 = hr_api.g_varchar2) then
1147: If (p_rec.inc_information9 = hr_api.g_varchar2) then
1148: p_rec.inc_information9 :=
1149: per_inc_shd.g_old_rec.inc_information9;
1150: End If;
1151: If (p_rec.inc_information10 = hr_api.g_varchar2) then
1152: p_rec.inc_information10 :=
1153: per_inc_shd.g_old_rec.inc_information10;
1154: End If;
1155: If (p_rec.inc_information11 = hr_api.g_varchar2) then
1151: If (p_rec.inc_information10 = hr_api.g_varchar2) then
1152: p_rec.inc_information10 :=
1153: per_inc_shd.g_old_rec.inc_information10;
1154: End If;
1155: If (p_rec.inc_information11 = hr_api.g_varchar2) then
1156: p_rec.inc_information11 :=
1157: per_inc_shd.g_old_rec.inc_information11;
1158: End If;
1159: If (p_rec.inc_information12 = hr_api.g_varchar2) then
1155: If (p_rec.inc_information11 = hr_api.g_varchar2) then
1156: p_rec.inc_information11 :=
1157: per_inc_shd.g_old_rec.inc_information11;
1158: End If;
1159: If (p_rec.inc_information12 = hr_api.g_varchar2) then
1160: p_rec.inc_information12 :=
1161: per_inc_shd.g_old_rec.inc_information12;
1162: End If;
1163: If (p_rec.inc_information13 = hr_api.g_varchar2) then
1159: If (p_rec.inc_information12 = hr_api.g_varchar2) then
1160: p_rec.inc_information12 :=
1161: per_inc_shd.g_old_rec.inc_information12;
1162: End If;
1163: If (p_rec.inc_information13 = hr_api.g_varchar2) then
1164: p_rec.inc_information13 :=
1165: per_inc_shd.g_old_rec.inc_information13;
1166: End If;
1167: If (p_rec.inc_information14 = hr_api.g_varchar2) then
1163: If (p_rec.inc_information13 = hr_api.g_varchar2) then
1164: p_rec.inc_information13 :=
1165: per_inc_shd.g_old_rec.inc_information13;
1166: End If;
1167: If (p_rec.inc_information14 = hr_api.g_varchar2) then
1168: p_rec.inc_information14 :=
1169: per_inc_shd.g_old_rec.inc_information14;
1170: End If;
1171: If (p_rec.inc_information15 = hr_api.g_varchar2) then
1167: If (p_rec.inc_information14 = hr_api.g_varchar2) then
1168: p_rec.inc_information14 :=
1169: per_inc_shd.g_old_rec.inc_information14;
1170: End If;
1171: If (p_rec.inc_information15 = hr_api.g_varchar2) then
1172: p_rec.inc_information15 :=
1173: per_inc_shd.g_old_rec.inc_information15;
1174: End If;
1175: If (p_rec.inc_information16 = hr_api.g_varchar2) then
1171: If (p_rec.inc_information15 = hr_api.g_varchar2) then
1172: p_rec.inc_information15 :=
1173: per_inc_shd.g_old_rec.inc_information15;
1174: End If;
1175: If (p_rec.inc_information16 = hr_api.g_varchar2) then
1176: p_rec.inc_information16 :=
1177: per_inc_shd.g_old_rec.inc_information16;
1178: End If;
1179: If (p_rec.inc_information17 = hr_api.g_varchar2) then
1175: If (p_rec.inc_information16 = hr_api.g_varchar2) then
1176: p_rec.inc_information16 :=
1177: per_inc_shd.g_old_rec.inc_information16;
1178: End If;
1179: If (p_rec.inc_information17 = hr_api.g_varchar2) then
1180: p_rec.inc_information17 :=
1181: per_inc_shd.g_old_rec.inc_information17;
1182: End If;
1183: If (p_rec.inc_information18 = hr_api.g_varchar2) then
1179: If (p_rec.inc_information17 = hr_api.g_varchar2) then
1180: p_rec.inc_information17 :=
1181: per_inc_shd.g_old_rec.inc_information17;
1182: End If;
1183: If (p_rec.inc_information18 = hr_api.g_varchar2) then
1184: p_rec.inc_information18 :=
1185: per_inc_shd.g_old_rec.inc_information18;
1186: End If;
1187: If (p_rec.inc_information19 = hr_api.g_varchar2) then
1183: If (p_rec.inc_information18 = hr_api.g_varchar2) then
1184: p_rec.inc_information18 :=
1185: per_inc_shd.g_old_rec.inc_information18;
1186: End If;
1187: If (p_rec.inc_information19 = hr_api.g_varchar2) then
1188: p_rec.inc_information19 :=
1189: per_inc_shd.g_old_rec.inc_information19;
1190: End If;
1191: If (p_rec.inc_information20 = hr_api.g_varchar2) then
1187: If (p_rec.inc_information19 = hr_api.g_varchar2) then
1188: p_rec.inc_information19 :=
1189: per_inc_shd.g_old_rec.inc_information19;
1190: End If;
1191: If (p_rec.inc_information20 = hr_api.g_varchar2) then
1192: p_rec.inc_information20 :=
1193: per_inc_shd.g_old_rec.inc_information20;
1194: End If;
1195: If (p_rec.inc_information21 = hr_api.g_varchar2) then
1191: If (p_rec.inc_information20 = hr_api.g_varchar2) then
1192: p_rec.inc_information20 :=
1193: per_inc_shd.g_old_rec.inc_information20;
1194: End If;
1195: If (p_rec.inc_information21 = hr_api.g_varchar2) then
1196: p_rec.inc_information21 :=
1197: per_inc_shd.g_old_rec.inc_information21;
1198: End If;
1199: If (p_rec.inc_information22 = hr_api.g_varchar2) then
1195: If (p_rec.inc_information21 = hr_api.g_varchar2) then
1196: p_rec.inc_information21 :=
1197: per_inc_shd.g_old_rec.inc_information21;
1198: End If;
1199: If (p_rec.inc_information22 = hr_api.g_varchar2) then
1200: p_rec.inc_information22 :=
1201: per_inc_shd.g_old_rec.inc_information22;
1202: End If;
1203: If (p_rec.inc_information23 = hr_api.g_varchar2) then
1199: If (p_rec.inc_information22 = hr_api.g_varchar2) then
1200: p_rec.inc_information22 :=
1201: per_inc_shd.g_old_rec.inc_information22;
1202: End If;
1203: If (p_rec.inc_information23 = hr_api.g_varchar2) then
1204: p_rec.inc_information23 :=
1205: per_inc_shd.g_old_rec.inc_information23;
1206: End If;
1207: If (p_rec.inc_information24 = hr_api.g_varchar2) then
1203: If (p_rec.inc_information23 = hr_api.g_varchar2) then
1204: p_rec.inc_information23 :=
1205: per_inc_shd.g_old_rec.inc_information23;
1206: End If;
1207: If (p_rec.inc_information24 = hr_api.g_varchar2) then
1208: p_rec.inc_information24 :=
1209: per_inc_shd.g_old_rec.inc_information24;
1210: End If;
1211: If (p_rec.inc_information25 = hr_api.g_varchar2) then
1207: If (p_rec.inc_information24 = hr_api.g_varchar2) then
1208: p_rec.inc_information24 :=
1209: per_inc_shd.g_old_rec.inc_information24;
1210: End If;
1211: If (p_rec.inc_information25 = hr_api.g_varchar2) then
1212: p_rec.inc_information25 :=
1213: per_inc_shd.g_old_rec.inc_information25;
1214: End If;
1215: If (p_rec.inc_information26 = hr_api.g_varchar2) then
1211: If (p_rec.inc_information25 = hr_api.g_varchar2) then
1212: p_rec.inc_information25 :=
1213: per_inc_shd.g_old_rec.inc_information25;
1214: End If;
1215: If (p_rec.inc_information26 = hr_api.g_varchar2) then
1216: p_rec.inc_information26 :=
1217: per_inc_shd.g_old_rec.inc_information26;
1218: End If;
1219: If (p_rec.inc_information27 = hr_api.g_varchar2) then
1215: If (p_rec.inc_information26 = hr_api.g_varchar2) then
1216: p_rec.inc_information26 :=
1217: per_inc_shd.g_old_rec.inc_information26;
1218: End If;
1219: If (p_rec.inc_information27 = hr_api.g_varchar2) then
1220: p_rec.inc_information27 :=
1221: per_inc_shd.g_old_rec.inc_information27;
1222: End If;
1223: If (p_rec.inc_information28 = hr_api.g_varchar2) then
1219: If (p_rec.inc_information27 = hr_api.g_varchar2) then
1220: p_rec.inc_information27 :=
1221: per_inc_shd.g_old_rec.inc_information27;
1222: End If;
1223: If (p_rec.inc_information28 = hr_api.g_varchar2) then
1224: p_rec.inc_information28 :=
1225: per_inc_shd.g_old_rec.inc_information28;
1226: End If;
1227: If (p_rec.inc_information29 = hr_api.g_varchar2) then
1223: If (p_rec.inc_information28 = hr_api.g_varchar2) then
1224: p_rec.inc_information28 :=
1225: per_inc_shd.g_old_rec.inc_information28;
1226: End If;
1227: If (p_rec.inc_information29 = hr_api.g_varchar2) then
1228: p_rec.inc_information29 :=
1229: per_inc_shd.g_old_rec.inc_information29;
1230: End If;
1231: If (p_rec.inc_information30 = hr_api.g_varchar2) then
1227: If (p_rec.inc_information29 = hr_api.g_varchar2) then
1228: p_rec.inc_information29 :=
1229: per_inc_shd.g_old_rec.inc_information29;
1230: End If;
1231: If (p_rec.inc_information30 = hr_api.g_varchar2) then
1232: p_rec.inc_information30 :=
1233: per_inc_shd.g_old_rec.inc_information30;
1234: End If;
1235: --
1289: Procedure upd
1290: (p_effective_date in date
1291: ,p_incident_id in number
1292: ,p_object_version_number in out nocopy number
1293: ,p_incident_reference in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1290: (p_effective_date in date
1291: ,p_incident_id in number
1292: ,p_object_version_number in out nocopy number
1293: ,p_incident_reference in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1291: ,p_incident_id in number
1292: ,p_object_version_number in out nocopy number
1293: ,p_incident_reference in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1292: ,p_object_version_number in out nocopy number
1293: ,p_incident_reference in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1293: ,p_incident_reference in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1294: ,p_incident_type in varchar2 default hr_api.g_varchar2
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1295: ,p_incident_date in date default hr_api.g_date
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1296: ,p_at_work_flag in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1297: ,p_related_incident_id in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1298: ,p_incident_time in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1299: ,p_org_notified_date in date default hr_api.g_date
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_id in number default hr_api.g_number
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1301: ,p_location in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1302: ,p_report_date in date default hr_api.g_date
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1303: ,p_report_time in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1304: ,p_report_method in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1305: ,p_person_reported_by in number default hr_api.g_number
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1306: ,p_person_reported_to in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1307: ,p_witness_details in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1308: ,p_description in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1309: ,p_injury_type in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1310: ,p_disease_type in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1311: ,p_hazard_type in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1312: ,p_body_part in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1313: ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1314: ,p_hospital_details in varchar2 default hr_api.g_varchar2
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1315: ,p_emergency_code in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1316: ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1317: ,p_hospital_address in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1318: ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1319: ,p_objects_involved in varchar2 default hr_api.g_varchar2
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1320: ,p_privacy_issue in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1321: ,p_work_start_time in varchar2 default hr_api.g_varchar2
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1322: ,p_date_of_death in date default hr_api.g_date
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1323: ,p_report_completed_by in varchar2 default hr_api.g_varchar2
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1324: ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1325: ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1326: ,p_days_restricted_work in number default hr_api.g_number
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1327: ,p_days_away_from_work in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1328: ,p_doctor_name in varchar2 default hr_api.g_varchar2
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1329: ,p_compensation_date in date default hr_api.g_date
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1330: ,p_compensation_currency in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1331: ,p_compensation_amount in number default hr_api.g_number
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1332: ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1333: ,p_notified_hsrep_id in number default hr_api.g_number
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1334: ,p_notified_hsrep_date in date default hr_api.g_date
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1335: ,p_notified_rep_id in number default hr_api.g_number
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1336: ,p_notified_rep_date in date default hr_api.g_date
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1337: ,p_notified_rep_org_id in number default hr_api.g_number
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1338: ,p_over_time_flag in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1339: ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1357: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1358: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1359: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1360: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1361: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1362: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1363: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_inc_information_category in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_inc_information1 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_inc_information2 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_inc_information3 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_inc_information4 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_inc_information5 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_inc_information6 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_inc_information7 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_inc_information8 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_inc_information9 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_inc_information10 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_inc_information11 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_inc_information12 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_inc_information13 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_inc_information14 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_inc_information15 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_inc_information16 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_inc_information17 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_inc_information18 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_inc_information19 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_inc_information20 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_inc_information21 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_inc_information22 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1401: ,p_inc_information30 in varchar2 default hr_api.g_varchar2
1394: ,p_inc_information23 in varchar2 default hr_api.g_varchar2
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1401: ,p_inc_information30 in varchar2 default hr_api.g_varchar2
1402: ) is
1395: ,p_inc_information24 in varchar2 default hr_api.g_varchar2
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1401: ,p_inc_information30 in varchar2 default hr_api.g_varchar2
1402: ) is
1403: --
1396: ,p_inc_information25 in varchar2 default hr_api.g_varchar2
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1401: ,p_inc_information30 in varchar2 default hr_api.g_varchar2
1402: ) is
1403: --
1404: l_rec per_inc_shd.g_rec_type;
1397: ,p_inc_information26 in varchar2 default hr_api.g_varchar2
1398: ,p_inc_information27 in varchar2 default hr_api.g_varchar2
1399: ,p_inc_information28 in varchar2 default hr_api.g_varchar2
1400: ,p_inc_information29 in varchar2 default hr_api.g_varchar2
1401: ,p_inc_information30 in varchar2 default hr_api.g_varchar2
1402: ) is
1403: --
1404: l_rec per_inc_shd.g_rec_type;
1405: l_proc varchar2(72) := g_package||'upd';
1411: -- l_rec structure.
1412: --
1413: l_rec := per_inc_shd.convert_args
1414: (p_incident_id
1415: ,hr_api.g_number
1416: ,p_incident_reference
1417: ,p_incident_type
1418: ,p_incident_date
1419: ,p_incident_time