51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_inc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
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));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: --
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));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
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));
205: When Others Then
206: --
207: Raise;
239: --
240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure pre_update
243: (p_rec in per_inc_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'pre_update';
247: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure post_update
287: (p_effective_date in date
288: ,p_rec in per_inc_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'post_update';
292: --
505: => p_rec.inc_information30
506: ,p_object_version_number
507: => p_rec.object_version_number
508: ,p_person_id_o
509: => per_inc_shd.g_old_rec.person_id
510: ,p_incident_reference_o
511: => per_inc_shd.g_old_rec.incident_reference
512: ,p_incident_type_o
513: => per_inc_shd.g_old_rec.incident_type
507: => p_rec.object_version_number
508: ,p_person_id_o
509: => per_inc_shd.g_old_rec.person_id
510: ,p_incident_reference_o
511: => per_inc_shd.g_old_rec.incident_reference
512: ,p_incident_type_o
513: => per_inc_shd.g_old_rec.incident_type
514: ,p_incident_date_o
515: => per_inc_shd.g_old_rec.incident_date
509: => per_inc_shd.g_old_rec.person_id
510: ,p_incident_reference_o
511: => per_inc_shd.g_old_rec.incident_reference
512: ,p_incident_type_o
513: => per_inc_shd.g_old_rec.incident_type
514: ,p_incident_date_o
515: => per_inc_shd.g_old_rec.incident_date
516: ,p_incident_time_o
517: => per_inc_shd.g_old_rec.incident_time
511: => per_inc_shd.g_old_rec.incident_reference
512: ,p_incident_type_o
513: => per_inc_shd.g_old_rec.incident_type
514: ,p_incident_date_o
515: => per_inc_shd.g_old_rec.incident_date
516: ,p_incident_time_o
517: => per_inc_shd.g_old_rec.incident_time
518: ,p_org_notified_date_o
519: => per_inc_shd.g_old_rec.org_notified_date
513: => per_inc_shd.g_old_rec.incident_type
514: ,p_incident_date_o
515: => per_inc_shd.g_old_rec.incident_date
516: ,p_incident_time_o
517: => per_inc_shd.g_old_rec.incident_time
518: ,p_org_notified_date_o
519: => per_inc_shd.g_old_rec.org_notified_date
520: ,p_assignment_id_o
521: => per_inc_shd.g_old_rec.assignment_id
515: => per_inc_shd.g_old_rec.incident_date
516: ,p_incident_time_o
517: => per_inc_shd.g_old_rec.incident_time
518: ,p_org_notified_date_o
519: => per_inc_shd.g_old_rec.org_notified_date
520: ,p_assignment_id_o
521: => per_inc_shd.g_old_rec.assignment_id
522: ,p_location_o
523: => per_inc_shd.g_old_rec.location
517: => per_inc_shd.g_old_rec.incident_time
518: ,p_org_notified_date_o
519: => per_inc_shd.g_old_rec.org_notified_date
520: ,p_assignment_id_o
521: => per_inc_shd.g_old_rec.assignment_id
522: ,p_location_o
523: => per_inc_shd.g_old_rec.location
524: ,p_at_work_flag_o
525: => per_inc_shd.g_old_rec.at_work_flag
519: => per_inc_shd.g_old_rec.org_notified_date
520: ,p_assignment_id_o
521: => per_inc_shd.g_old_rec.assignment_id
522: ,p_location_o
523: => per_inc_shd.g_old_rec.location
524: ,p_at_work_flag_o
525: => per_inc_shd.g_old_rec.at_work_flag
526: ,p_report_date_o
527: => per_inc_shd.g_old_rec.report_date
521: => per_inc_shd.g_old_rec.assignment_id
522: ,p_location_o
523: => per_inc_shd.g_old_rec.location
524: ,p_at_work_flag_o
525: => per_inc_shd.g_old_rec.at_work_flag
526: ,p_report_date_o
527: => per_inc_shd.g_old_rec.report_date
528: ,p_report_time_o
529: => per_inc_shd.g_old_rec.report_time
523: => per_inc_shd.g_old_rec.location
524: ,p_at_work_flag_o
525: => per_inc_shd.g_old_rec.at_work_flag
526: ,p_report_date_o
527: => per_inc_shd.g_old_rec.report_date
528: ,p_report_time_o
529: => per_inc_shd.g_old_rec.report_time
530: ,p_report_method_o
531: => per_inc_shd.g_old_rec.report_method
525: => per_inc_shd.g_old_rec.at_work_flag
526: ,p_report_date_o
527: => per_inc_shd.g_old_rec.report_date
528: ,p_report_time_o
529: => per_inc_shd.g_old_rec.report_time
530: ,p_report_method_o
531: => per_inc_shd.g_old_rec.report_method
532: ,p_person_reported_by_o
533: => per_inc_shd.g_old_rec.person_reported_by
527: => per_inc_shd.g_old_rec.report_date
528: ,p_report_time_o
529: => per_inc_shd.g_old_rec.report_time
530: ,p_report_method_o
531: => per_inc_shd.g_old_rec.report_method
532: ,p_person_reported_by_o
533: => per_inc_shd.g_old_rec.person_reported_by
534: ,p_person_reported_to_o
535: => per_inc_shd.g_old_rec.person_reported_to
529: => per_inc_shd.g_old_rec.report_time
530: ,p_report_method_o
531: => per_inc_shd.g_old_rec.report_method
532: ,p_person_reported_by_o
533: => per_inc_shd.g_old_rec.person_reported_by
534: ,p_person_reported_to_o
535: => per_inc_shd.g_old_rec.person_reported_to
536: ,p_witness_details_o
537: => per_inc_shd.g_old_rec.witness_details
531: => per_inc_shd.g_old_rec.report_method
532: ,p_person_reported_by_o
533: => per_inc_shd.g_old_rec.person_reported_by
534: ,p_person_reported_to_o
535: => per_inc_shd.g_old_rec.person_reported_to
536: ,p_witness_details_o
537: => per_inc_shd.g_old_rec.witness_details
538: ,p_description_o
539: => per_inc_shd.g_old_rec.description
533: => per_inc_shd.g_old_rec.person_reported_by
534: ,p_person_reported_to_o
535: => per_inc_shd.g_old_rec.person_reported_to
536: ,p_witness_details_o
537: => per_inc_shd.g_old_rec.witness_details
538: ,p_description_o
539: => per_inc_shd.g_old_rec.description
540: ,p_injury_type_o
541: => per_inc_shd.g_old_rec.injury_type
535: => per_inc_shd.g_old_rec.person_reported_to
536: ,p_witness_details_o
537: => per_inc_shd.g_old_rec.witness_details
538: ,p_description_o
539: => per_inc_shd.g_old_rec.description
540: ,p_injury_type_o
541: => per_inc_shd.g_old_rec.injury_type
542: ,p_disease_type_o
543: => per_inc_shd.g_old_rec.disease_type
537: => per_inc_shd.g_old_rec.witness_details
538: ,p_description_o
539: => per_inc_shd.g_old_rec.description
540: ,p_injury_type_o
541: => per_inc_shd.g_old_rec.injury_type
542: ,p_disease_type_o
543: => per_inc_shd.g_old_rec.disease_type
544: ,p_hazard_type_o
545: => per_inc_shd.g_old_rec.hazard_type
539: => per_inc_shd.g_old_rec.description
540: ,p_injury_type_o
541: => per_inc_shd.g_old_rec.injury_type
542: ,p_disease_type_o
543: => per_inc_shd.g_old_rec.disease_type
544: ,p_hazard_type_o
545: => per_inc_shd.g_old_rec.hazard_type
546: ,p_body_part_o
547: => per_inc_shd.g_old_rec.body_part
541: => per_inc_shd.g_old_rec.injury_type
542: ,p_disease_type_o
543: => per_inc_shd.g_old_rec.disease_type
544: ,p_hazard_type_o
545: => per_inc_shd.g_old_rec.hazard_type
546: ,p_body_part_o
547: => per_inc_shd.g_old_rec.body_part
548: ,p_treatment_received_flag_o
549: => per_inc_shd.g_old_rec.treatment_received_flag
543: => per_inc_shd.g_old_rec.disease_type
544: ,p_hazard_type_o
545: => per_inc_shd.g_old_rec.hazard_type
546: ,p_body_part_o
547: => per_inc_shd.g_old_rec.body_part
548: ,p_treatment_received_flag_o
549: => per_inc_shd.g_old_rec.treatment_received_flag
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
545: => per_inc_shd.g_old_rec.hazard_type
546: ,p_body_part_o
547: => per_inc_shd.g_old_rec.body_part
548: ,p_treatment_received_flag_o
549: => per_inc_shd.g_old_rec.treatment_received_flag
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
547: => per_inc_shd.g_old_rec.body_part
548: ,p_treatment_received_flag_o
549: => per_inc_shd.g_old_rec.treatment_received_flag
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
548: ,p_treatment_received_flag_o
549: => per_inc_shd.g_old_rec.treatment_received_flag
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
549: => per_inc_shd.g_old_rec.treatment_received_flag
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
550: ,p_hospital_details_o
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
551: => per_inc_shd.g_old_rec.hospital_details
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
552: ,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
553: ,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
554: ,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
555: ,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
556: ,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
557: ,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
558: ,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
566: => per_inc_shd.g_old_rec.doctor_name
559: ,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
566: => per_inc_shd.g_old_rec.doctor_name
567: ,p_compensation_date_o
560: ,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
561: ,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
566: => per_inc_shd.g_old_rec.doctor_name
567: ,p_compensation_date_o
568: => per_inc_shd.g_old_rec.compensation_date
562: ,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
563: ,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
566: => per_inc_shd.g_old_rec.doctor_name
567: ,p_compensation_date_o
568: => per_inc_shd.g_old_rec.compensation_date
569: ,p_compensation_currency_o
570: => per_inc_shd.g_old_rec.compensation_currency
564: ,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
565: ,p_doctor_name_o
566: => per_inc_shd.g_old_rec.doctor_name
567: ,p_compensation_date_o
568: => per_inc_shd.g_old_rec.compensation_date
569: ,p_compensation_currency_o
570: => per_inc_shd.g_old_rec.compensation_currency
571: ,p_compensation_amount_o
572: => per_inc_shd.g_old_rec.compensation_amount
566: => per_inc_shd.g_old_rec.doctor_name
567: ,p_compensation_date_o
568: => per_inc_shd.g_old_rec.compensation_date
569: ,p_compensation_currency_o
570: => per_inc_shd.g_old_rec.compensation_currency
571: ,p_compensation_amount_o
572: => per_inc_shd.g_old_rec.compensation_amount
573: ,p_remedial_hs_action_o
574: => per_inc_shd.g_old_rec.remedial_hs_action
568: => per_inc_shd.g_old_rec.compensation_date
569: ,p_compensation_currency_o
570: => per_inc_shd.g_old_rec.compensation_currency
571: ,p_compensation_amount_o
572: => per_inc_shd.g_old_rec.compensation_amount
573: ,p_remedial_hs_action_o
574: => per_inc_shd.g_old_rec.remedial_hs_action
575: ,p_notified_hsrep_id_o
576: => per_inc_shd.g_old_rec.notified_hsrep_id
570: => per_inc_shd.g_old_rec.compensation_currency
571: ,p_compensation_amount_o
572: => per_inc_shd.g_old_rec.compensation_amount
573: ,p_remedial_hs_action_o
574: => per_inc_shd.g_old_rec.remedial_hs_action
575: ,p_notified_hsrep_id_o
576: => per_inc_shd.g_old_rec.notified_hsrep_id
577: ,p_notified_hsrep_date_o
578: => per_inc_shd.g_old_rec.notified_hsrep_date
572: => per_inc_shd.g_old_rec.compensation_amount
573: ,p_remedial_hs_action_o
574: => per_inc_shd.g_old_rec.remedial_hs_action
575: ,p_notified_hsrep_id_o
576: => per_inc_shd.g_old_rec.notified_hsrep_id
577: ,p_notified_hsrep_date_o
578: => per_inc_shd.g_old_rec.notified_hsrep_date
579: ,p_notified_rep_id_o
580: => per_inc_shd.g_old_rec.notified_rep_id
574: => per_inc_shd.g_old_rec.remedial_hs_action
575: ,p_notified_hsrep_id_o
576: => per_inc_shd.g_old_rec.notified_hsrep_id
577: ,p_notified_hsrep_date_o
578: => per_inc_shd.g_old_rec.notified_hsrep_date
579: ,p_notified_rep_id_o
580: => per_inc_shd.g_old_rec.notified_rep_id
581: ,p_notified_rep_date_o
582: => per_inc_shd.g_old_rec.notified_rep_date
576: => per_inc_shd.g_old_rec.notified_hsrep_id
577: ,p_notified_hsrep_date_o
578: => per_inc_shd.g_old_rec.notified_hsrep_date
579: ,p_notified_rep_id_o
580: => per_inc_shd.g_old_rec.notified_rep_id
581: ,p_notified_rep_date_o
582: => per_inc_shd.g_old_rec.notified_rep_date
583: ,p_notified_rep_org_id_o
584: => per_inc_shd.g_old_rec.notified_rep_org_id
578: => per_inc_shd.g_old_rec.notified_hsrep_date
579: ,p_notified_rep_id_o
580: => per_inc_shd.g_old_rec.notified_rep_id
581: ,p_notified_rep_date_o
582: => per_inc_shd.g_old_rec.notified_rep_date
583: ,p_notified_rep_org_id_o
584: => per_inc_shd.g_old_rec.notified_rep_org_id
585: ,p_related_incident_id_o
586: => per_inc_shd.g_old_rec.related_incident_id
580: => per_inc_shd.g_old_rec.notified_rep_id
581: ,p_notified_rep_date_o
582: => per_inc_shd.g_old_rec.notified_rep_date
583: ,p_notified_rep_org_id_o
584: => per_inc_shd.g_old_rec.notified_rep_org_id
585: ,p_related_incident_id_o
586: => per_inc_shd.g_old_rec.related_incident_id
587: ,p_over_time_flag_o
588: => per_inc_shd.g_old_rec.over_time_flag
582: => per_inc_shd.g_old_rec.notified_rep_date
583: ,p_notified_rep_org_id_o
584: => per_inc_shd.g_old_rec.notified_rep_org_id
585: ,p_related_incident_id_o
586: => per_inc_shd.g_old_rec.related_incident_id
587: ,p_over_time_flag_o
588: => per_inc_shd.g_old_rec.over_time_flag
589: ,p_absence_exists_flag_o
590: => per_inc_shd.g_old_rec.absence_exists_flag
584: => per_inc_shd.g_old_rec.notified_rep_org_id
585: ,p_related_incident_id_o
586: => per_inc_shd.g_old_rec.related_incident_id
587: ,p_over_time_flag_o
588: => per_inc_shd.g_old_rec.over_time_flag
589: ,p_absence_exists_flag_o
590: => per_inc_shd.g_old_rec.absence_exists_flag
591: ,p_attribute_category_o
592: => per_inc_shd.g_old_rec.attribute_category
586: => per_inc_shd.g_old_rec.related_incident_id
587: ,p_over_time_flag_o
588: => per_inc_shd.g_old_rec.over_time_flag
589: ,p_absence_exists_flag_o
590: => per_inc_shd.g_old_rec.absence_exists_flag
591: ,p_attribute_category_o
592: => per_inc_shd.g_old_rec.attribute_category
593: ,p_attribute1_o
594: => per_inc_shd.g_old_rec.attribute1
588: => per_inc_shd.g_old_rec.over_time_flag
589: ,p_absence_exists_flag_o
590: => per_inc_shd.g_old_rec.absence_exists_flag
591: ,p_attribute_category_o
592: => per_inc_shd.g_old_rec.attribute_category
593: ,p_attribute1_o
594: => per_inc_shd.g_old_rec.attribute1
595: ,p_attribute2_o
596: => per_inc_shd.g_old_rec.attribute2
590: => per_inc_shd.g_old_rec.absence_exists_flag
591: ,p_attribute_category_o
592: => per_inc_shd.g_old_rec.attribute_category
593: ,p_attribute1_o
594: => per_inc_shd.g_old_rec.attribute1
595: ,p_attribute2_o
596: => per_inc_shd.g_old_rec.attribute2
597: ,p_attribute3_o
598: => per_inc_shd.g_old_rec.attribute3
592: => per_inc_shd.g_old_rec.attribute_category
593: ,p_attribute1_o
594: => per_inc_shd.g_old_rec.attribute1
595: ,p_attribute2_o
596: => per_inc_shd.g_old_rec.attribute2
597: ,p_attribute3_o
598: => per_inc_shd.g_old_rec.attribute3
599: ,p_attribute4_o
600: => per_inc_shd.g_old_rec.attribute4
594: => per_inc_shd.g_old_rec.attribute1
595: ,p_attribute2_o
596: => per_inc_shd.g_old_rec.attribute2
597: ,p_attribute3_o
598: => per_inc_shd.g_old_rec.attribute3
599: ,p_attribute4_o
600: => per_inc_shd.g_old_rec.attribute4
601: ,p_attribute5_o
602: => per_inc_shd.g_old_rec.attribute5
596: => per_inc_shd.g_old_rec.attribute2
597: ,p_attribute3_o
598: => per_inc_shd.g_old_rec.attribute3
599: ,p_attribute4_o
600: => per_inc_shd.g_old_rec.attribute4
601: ,p_attribute5_o
602: => per_inc_shd.g_old_rec.attribute5
603: ,p_attribute6_o
604: => per_inc_shd.g_old_rec.attribute6
598: => per_inc_shd.g_old_rec.attribute3
599: ,p_attribute4_o
600: => per_inc_shd.g_old_rec.attribute4
601: ,p_attribute5_o
602: => per_inc_shd.g_old_rec.attribute5
603: ,p_attribute6_o
604: => per_inc_shd.g_old_rec.attribute6
605: ,p_attribute7_o
606: => per_inc_shd.g_old_rec.attribute7
600: => per_inc_shd.g_old_rec.attribute4
601: ,p_attribute5_o
602: => per_inc_shd.g_old_rec.attribute5
603: ,p_attribute6_o
604: => per_inc_shd.g_old_rec.attribute6
605: ,p_attribute7_o
606: => per_inc_shd.g_old_rec.attribute7
607: ,p_attribute8_o
608: => per_inc_shd.g_old_rec.attribute8
602: => per_inc_shd.g_old_rec.attribute5
603: ,p_attribute6_o
604: => per_inc_shd.g_old_rec.attribute6
605: ,p_attribute7_o
606: => per_inc_shd.g_old_rec.attribute7
607: ,p_attribute8_o
608: => per_inc_shd.g_old_rec.attribute8
609: ,p_attribute9_o
610: => per_inc_shd.g_old_rec.attribute9
604: => per_inc_shd.g_old_rec.attribute6
605: ,p_attribute7_o
606: => per_inc_shd.g_old_rec.attribute7
607: ,p_attribute8_o
608: => per_inc_shd.g_old_rec.attribute8
609: ,p_attribute9_o
610: => per_inc_shd.g_old_rec.attribute9
611: ,p_attribute10_o
612: => per_inc_shd.g_old_rec.attribute10
606: => per_inc_shd.g_old_rec.attribute7
607: ,p_attribute8_o
608: => per_inc_shd.g_old_rec.attribute8
609: ,p_attribute9_o
610: => per_inc_shd.g_old_rec.attribute9
611: ,p_attribute10_o
612: => per_inc_shd.g_old_rec.attribute10
613: ,p_attribute11_o
614: => per_inc_shd.g_old_rec.attribute11
608: => per_inc_shd.g_old_rec.attribute8
609: ,p_attribute9_o
610: => per_inc_shd.g_old_rec.attribute9
611: ,p_attribute10_o
612: => per_inc_shd.g_old_rec.attribute10
613: ,p_attribute11_o
614: => per_inc_shd.g_old_rec.attribute11
615: ,p_attribute12_o
616: => per_inc_shd.g_old_rec.attribute12
610: => per_inc_shd.g_old_rec.attribute9
611: ,p_attribute10_o
612: => per_inc_shd.g_old_rec.attribute10
613: ,p_attribute11_o
614: => per_inc_shd.g_old_rec.attribute11
615: ,p_attribute12_o
616: => per_inc_shd.g_old_rec.attribute12
617: ,p_attribute13_o
618: => per_inc_shd.g_old_rec.attribute13
612: => per_inc_shd.g_old_rec.attribute10
613: ,p_attribute11_o
614: => per_inc_shd.g_old_rec.attribute11
615: ,p_attribute12_o
616: => per_inc_shd.g_old_rec.attribute12
617: ,p_attribute13_o
618: => per_inc_shd.g_old_rec.attribute13
619: ,p_attribute14_o
620: => per_inc_shd.g_old_rec.attribute14
614: => per_inc_shd.g_old_rec.attribute11
615: ,p_attribute12_o
616: => per_inc_shd.g_old_rec.attribute12
617: ,p_attribute13_o
618: => per_inc_shd.g_old_rec.attribute13
619: ,p_attribute14_o
620: => per_inc_shd.g_old_rec.attribute14
621: ,p_attribute15_o
622: => per_inc_shd.g_old_rec.attribute15
616: => per_inc_shd.g_old_rec.attribute12
617: ,p_attribute13_o
618: => per_inc_shd.g_old_rec.attribute13
619: ,p_attribute14_o
620: => per_inc_shd.g_old_rec.attribute14
621: ,p_attribute15_o
622: => per_inc_shd.g_old_rec.attribute15
623: ,p_attribute16_o
624: => per_inc_shd.g_old_rec.attribute16
618: => per_inc_shd.g_old_rec.attribute13
619: ,p_attribute14_o
620: => per_inc_shd.g_old_rec.attribute14
621: ,p_attribute15_o
622: => per_inc_shd.g_old_rec.attribute15
623: ,p_attribute16_o
624: => per_inc_shd.g_old_rec.attribute16
625: ,p_attribute17_o
626: => per_inc_shd.g_old_rec.attribute17
620: => per_inc_shd.g_old_rec.attribute14
621: ,p_attribute15_o
622: => per_inc_shd.g_old_rec.attribute15
623: ,p_attribute16_o
624: => per_inc_shd.g_old_rec.attribute16
625: ,p_attribute17_o
626: => per_inc_shd.g_old_rec.attribute17
627: ,p_attribute18_o
628: => per_inc_shd.g_old_rec.attribute18
622: => per_inc_shd.g_old_rec.attribute15
623: ,p_attribute16_o
624: => per_inc_shd.g_old_rec.attribute16
625: ,p_attribute17_o
626: => per_inc_shd.g_old_rec.attribute17
627: ,p_attribute18_o
628: => per_inc_shd.g_old_rec.attribute18
629: ,p_attribute19_o
630: => per_inc_shd.g_old_rec.attribute19
624: => per_inc_shd.g_old_rec.attribute16
625: ,p_attribute17_o
626: => per_inc_shd.g_old_rec.attribute17
627: ,p_attribute18_o
628: => per_inc_shd.g_old_rec.attribute18
629: ,p_attribute19_o
630: => per_inc_shd.g_old_rec.attribute19
631: ,p_attribute20_o
632: => per_inc_shd.g_old_rec.attribute20
626: => per_inc_shd.g_old_rec.attribute17
627: ,p_attribute18_o
628: => per_inc_shd.g_old_rec.attribute18
629: ,p_attribute19_o
630: => per_inc_shd.g_old_rec.attribute19
631: ,p_attribute20_o
632: => per_inc_shd.g_old_rec.attribute20
633: ,p_attribute21_o
634: => per_inc_shd.g_old_rec.attribute21
628: => per_inc_shd.g_old_rec.attribute18
629: ,p_attribute19_o
630: => per_inc_shd.g_old_rec.attribute19
631: ,p_attribute20_o
632: => per_inc_shd.g_old_rec.attribute20
633: ,p_attribute21_o
634: => per_inc_shd.g_old_rec.attribute21
635: ,p_attribute22_o
636: => per_inc_shd.g_old_rec.attribute22
630: => per_inc_shd.g_old_rec.attribute19
631: ,p_attribute20_o
632: => per_inc_shd.g_old_rec.attribute20
633: ,p_attribute21_o
634: => per_inc_shd.g_old_rec.attribute21
635: ,p_attribute22_o
636: => per_inc_shd.g_old_rec.attribute22
637: ,p_attribute23_o
638: => per_inc_shd.g_old_rec.attribute23
632: => per_inc_shd.g_old_rec.attribute20
633: ,p_attribute21_o
634: => per_inc_shd.g_old_rec.attribute21
635: ,p_attribute22_o
636: => per_inc_shd.g_old_rec.attribute22
637: ,p_attribute23_o
638: => per_inc_shd.g_old_rec.attribute23
639: ,p_attribute24_o
640: => per_inc_shd.g_old_rec.attribute24
634: => per_inc_shd.g_old_rec.attribute21
635: ,p_attribute22_o
636: => per_inc_shd.g_old_rec.attribute22
637: ,p_attribute23_o
638: => per_inc_shd.g_old_rec.attribute23
639: ,p_attribute24_o
640: => per_inc_shd.g_old_rec.attribute24
641: ,p_attribute25_o
642: => per_inc_shd.g_old_rec.attribute25
636: => per_inc_shd.g_old_rec.attribute22
637: ,p_attribute23_o
638: => per_inc_shd.g_old_rec.attribute23
639: ,p_attribute24_o
640: => per_inc_shd.g_old_rec.attribute24
641: ,p_attribute25_o
642: => per_inc_shd.g_old_rec.attribute25
643: ,p_attribute26_o
644: => per_inc_shd.g_old_rec.attribute26
638: => per_inc_shd.g_old_rec.attribute23
639: ,p_attribute24_o
640: => per_inc_shd.g_old_rec.attribute24
641: ,p_attribute25_o
642: => per_inc_shd.g_old_rec.attribute25
643: ,p_attribute26_o
644: => per_inc_shd.g_old_rec.attribute26
645: ,p_attribute27_o
646: => per_inc_shd.g_old_rec.attribute27
640: => per_inc_shd.g_old_rec.attribute24
641: ,p_attribute25_o
642: => per_inc_shd.g_old_rec.attribute25
643: ,p_attribute26_o
644: => per_inc_shd.g_old_rec.attribute26
645: ,p_attribute27_o
646: => per_inc_shd.g_old_rec.attribute27
647: ,p_attribute28_o
648: => per_inc_shd.g_old_rec.attribute28
642: => per_inc_shd.g_old_rec.attribute25
643: ,p_attribute26_o
644: => per_inc_shd.g_old_rec.attribute26
645: ,p_attribute27_o
646: => per_inc_shd.g_old_rec.attribute27
647: ,p_attribute28_o
648: => per_inc_shd.g_old_rec.attribute28
649: ,p_attribute29_o
650: => per_inc_shd.g_old_rec.attribute29
644: => per_inc_shd.g_old_rec.attribute26
645: ,p_attribute27_o
646: => per_inc_shd.g_old_rec.attribute27
647: ,p_attribute28_o
648: => per_inc_shd.g_old_rec.attribute28
649: ,p_attribute29_o
650: => per_inc_shd.g_old_rec.attribute29
651: ,p_attribute30_o
652: => per_inc_shd.g_old_rec.attribute30
646: => per_inc_shd.g_old_rec.attribute27
647: ,p_attribute28_o
648: => per_inc_shd.g_old_rec.attribute28
649: ,p_attribute29_o
650: => per_inc_shd.g_old_rec.attribute29
651: ,p_attribute30_o
652: => per_inc_shd.g_old_rec.attribute30
653: ,p_inc_information_category_o
654: => per_inc_shd.g_old_rec.inc_information_category
648: => per_inc_shd.g_old_rec.attribute28
649: ,p_attribute29_o
650: => per_inc_shd.g_old_rec.attribute29
651: ,p_attribute30_o
652: => per_inc_shd.g_old_rec.attribute30
653: ,p_inc_information_category_o
654: => per_inc_shd.g_old_rec.inc_information_category
655: ,p_inc_information1_o
656: => per_inc_shd.g_old_rec.inc_information1
650: => per_inc_shd.g_old_rec.attribute29
651: ,p_attribute30_o
652: => per_inc_shd.g_old_rec.attribute30
653: ,p_inc_information_category_o
654: => per_inc_shd.g_old_rec.inc_information_category
655: ,p_inc_information1_o
656: => per_inc_shd.g_old_rec.inc_information1
657: ,p_inc_information2_o
658: => per_inc_shd.g_old_rec.inc_information2
652: => per_inc_shd.g_old_rec.attribute30
653: ,p_inc_information_category_o
654: => per_inc_shd.g_old_rec.inc_information_category
655: ,p_inc_information1_o
656: => per_inc_shd.g_old_rec.inc_information1
657: ,p_inc_information2_o
658: => per_inc_shd.g_old_rec.inc_information2
659: ,p_inc_information3_o
660: => per_inc_shd.g_old_rec.inc_information3
654: => per_inc_shd.g_old_rec.inc_information_category
655: ,p_inc_information1_o
656: => per_inc_shd.g_old_rec.inc_information1
657: ,p_inc_information2_o
658: => per_inc_shd.g_old_rec.inc_information2
659: ,p_inc_information3_o
660: => per_inc_shd.g_old_rec.inc_information3
661: ,p_inc_information4_o
662: => per_inc_shd.g_old_rec.inc_information4
656: => per_inc_shd.g_old_rec.inc_information1
657: ,p_inc_information2_o
658: => per_inc_shd.g_old_rec.inc_information2
659: ,p_inc_information3_o
660: => per_inc_shd.g_old_rec.inc_information3
661: ,p_inc_information4_o
662: => per_inc_shd.g_old_rec.inc_information4
663: ,p_inc_information5_o
664: => per_inc_shd.g_old_rec.inc_information5
658: => per_inc_shd.g_old_rec.inc_information2
659: ,p_inc_information3_o
660: => per_inc_shd.g_old_rec.inc_information3
661: ,p_inc_information4_o
662: => per_inc_shd.g_old_rec.inc_information4
663: ,p_inc_information5_o
664: => per_inc_shd.g_old_rec.inc_information5
665: ,p_inc_information6_o
666: => per_inc_shd.g_old_rec.inc_information6
660: => per_inc_shd.g_old_rec.inc_information3
661: ,p_inc_information4_o
662: => per_inc_shd.g_old_rec.inc_information4
663: ,p_inc_information5_o
664: => per_inc_shd.g_old_rec.inc_information5
665: ,p_inc_information6_o
666: => per_inc_shd.g_old_rec.inc_information6
667: ,p_inc_information7_o
668: => per_inc_shd.g_old_rec.inc_information7
662: => per_inc_shd.g_old_rec.inc_information4
663: ,p_inc_information5_o
664: => per_inc_shd.g_old_rec.inc_information5
665: ,p_inc_information6_o
666: => per_inc_shd.g_old_rec.inc_information6
667: ,p_inc_information7_o
668: => per_inc_shd.g_old_rec.inc_information7
669: ,p_inc_information8_o
670: => per_inc_shd.g_old_rec.inc_information8
664: => per_inc_shd.g_old_rec.inc_information5
665: ,p_inc_information6_o
666: => per_inc_shd.g_old_rec.inc_information6
667: ,p_inc_information7_o
668: => per_inc_shd.g_old_rec.inc_information7
669: ,p_inc_information8_o
670: => per_inc_shd.g_old_rec.inc_information8
671: ,p_inc_information9_o
672: => per_inc_shd.g_old_rec.inc_information9
666: => per_inc_shd.g_old_rec.inc_information6
667: ,p_inc_information7_o
668: => per_inc_shd.g_old_rec.inc_information7
669: ,p_inc_information8_o
670: => per_inc_shd.g_old_rec.inc_information8
671: ,p_inc_information9_o
672: => per_inc_shd.g_old_rec.inc_information9
673: ,p_inc_information10_o
674: => per_inc_shd.g_old_rec.inc_information10
668: => per_inc_shd.g_old_rec.inc_information7
669: ,p_inc_information8_o
670: => per_inc_shd.g_old_rec.inc_information8
671: ,p_inc_information9_o
672: => per_inc_shd.g_old_rec.inc_information9
673: ,p_inc_information10_o
674: => per_inc_shd.g_old_rec.inc_information10
675: ,p_inc_information11_o
676: => per_inc_shd.g_old_rec.inc_information11
670: => per_inc_shd.g_old_rec.inc_information8
671: ,p_inc_information9_o
672: => per_inc_shd.g_old_rec.inc_information9
673: ,p_inc_information10_o
674: => per_inc_shd.g_old_rec.inc_information10
675: ,p_inc_information11_o
676: => per_inc_shd.g_old_rec.inc_information11
677: ,p_inc_information12_o
678: => per_inc_shd.g_old_rec.inc_information12
672: => per_inc_shd.g_old_rec.inc_information9
673: ,p_inc_information10_o
674: => per_inc_shd.g_old_rec.inc_information10
675: ,p_inc_information11_o
676: => per_inc_shd.g_old_rec.inc_information11
677: ,p_inc_information12_o
678: => per_inc_shd.g_old_rec.inc_information12
679: ,p_inc_information13_o
680: => per_inc_shd.g_old_rec.inc_information13
674: => per_inc_shd.g_old_rec.inc_information10
675: ,p_inc_information11_o
676: => per_inc_shd.g_old_rec.inc_information11
677: ,p_inc_information12_o
678: => per_inc_shd.g_old_rec.inc_information12
679: ,p_inc_information13_o
680: => per_inc_shd.g_old_rec.inc_information13
681: ,p_inc_information14_o
682: => per_inc_shd.g_old_rec.inc_information14
676: => per_inc_shd.g_old_rec.inc_information11
677: ,p_inc_information12_o
678: => per_inc_shd.g_old_rec.inc_information12
679: ,p_inc_information13_o
680: => per_inc_shd.g_old_rec.inc_information13
681: ,p_inc_information14_o
682: => per_inc_shd.g_old_rec.inc_information14
683: ,p_inc_information15_o
684: => per_inc_shd.g_old_rec.inc_information15
678: => per_inc_shd.g_old_rec.inc_information12
679: ,p_inc_information13_o
680: => per_inc_shd.g_old_rec.inc_information13
681: ,p_inc_information14_o
682: => per_inc_shd.g_old_rec.inc_information14
683: ,p_inc_information15_o
684: => per_inc_shd.g_old_rec.inc_information15
685: ,p_inc_information16_o
686: => per_inc_shd.g_old_rec.inc_information16
680: => per_inc_shd.g_old_rec.inc_information13
681: ,p_inc_information14_o
682: => per_inc_shd.g_old_rec.inc_information14
683: ,p_inc_information15_o
684: => per_inc_shd.g_old_rec.inc_information15
685: ,p_inc_information16_o
686: => per_inc_shd.g_old_rec.inc_information16
687: ,p_inc_information17_o
688: => per_inc_shd.g_old_rec.inc_information17
682: => per_inc_shd.g_old_rec.inc_information14
683: ,p_inc_information15_o
684: => per_inc_shd.g_old_rec.inc_information15
685: ,p_inc_information16_o
686: => per_inc_shd.g_old_rec.inc_information16
687: ,p_inc_information17_o
688: => per_inc_shd.g_old_rec.inc_information17
689: ,p_inc_information18_o
690: => per_inc_shd.g_old_rec.inc_information18
684: => per_inc_shd.g_old_rec.inc_information15
685: ,p_inc_information16_o
686: => per_inc_shd.g_old_rec.inc_information16
687: ,p_inc_information17_o
688: => per_inc_shd.g_old_rec.inc_information17
689: ,p_inc_information18_o
690: => per_inc_shd.g_old_rec.inc_information18
691: ,p_inc_information19_o
692: => per_inc_shd.g_old_rec.inc_information19
686: => per_inc_shd.g_old_rec.inc_information16
687: ,p_inc_information17_o
688: => per_inc_shd.g_old_rec.inc_information17
689: ,p_inc_information18_o
690: => per_inc_shd.g_old_rec.inc_information18
691: ,p_inc_information19_o
692: => per_inc_shd.g_old_rec.inc_information19
693: ,p_inc_information20_o
694: => per_inc_shd.g_old_rec.inc_information20
688: => per_inc_shd.g_old_rec.inc_information17
689: ,p_inc_information18_o
690: => per_inc_shd.g_old_rec.inc_information18
691: ,p_inc_information19_o
692: => per_inc_shd.g_old_rec.inc_information19
693: ,p_inc_information20_o
694: => per_inc_shd.g_old_rec.inc_information20
695: ,p_inc_information21_o
696: => per_inc_shd.g_old_rec.inc_information21
690: => per_inc_shd.g_old_rec.inc_information18
691: ,p_inc_information19_o
692: => per_inc_shd.g_old_rec.inc_information19
693: ,p_inc_information20_o
694: => per_inc_shd.g_old_rec.inc_information20
695: ,p_inc_information21_o
696: => per_inc_shd.g_old_rec.inc_information21
697: ,p_inc_information22_o
698: => per_inc_shd.g_old_rec.inc_information22
692: => per_inc_shd.g_old_rec.inc_information19
693: ,p_inc_information20_o
694: => per_inc_shd.g_old_rec.inc_information20
695: ,p_inc_information21_o
696: => per_inc_shd.g_old_rec.inc_information21
697: ,p_inc_information22_o
698: => per_inc_shd.g_old_rec.inc_information22
699: ,p_inc_information23_o
700: => per_inc_shd.g_old_rec.inc_information23
694: => per_inc_shd.g_old_rec.inc_information20
695: ,p_inc_information21_o
696: => per_inc_shd.g_old_rec.inc_information21
697: ,p_inc_information22_o
698: => per_inc_shd.g_old_rec.inc_information22
699: ,p_inc_information23_o
700: => per_inc_shd.g_old_rec.inc_information23
701: ,p_inc_information24_o
702: => per_inc_shd.g_old_rec.inc_information24
696: => per_inc_shd.g_old_rec.inc_information21
697: ,p_inc_information22_o
698: => per_inc_shd.g_old_rec.inc_information22
699: ,p_inc_information23_o
700: => per_inc_shd.g_old_rec.inc_information23
701: ,p_inc_information24_o
702: => per_inc_shd.g_old_rec.inc_information24
703: ,p_inc_information25_o
704: => per_inc_shd.g_old_rec.inc_information25
698: => per_inc_shd.g_old_rec.inc_information22
699: ,p_inc_information23_o
700: => per_inc_shd.g_old_rec.inc_information23
701: ,p_inc_information24_o
702: => per_inc_shd.g_old_rec.inc_information24
703: ,p_inc_information25_o
704: => per_inc_shd.g_old_rec.inc_information25
705: ,p_inc_information26_o
706: => per_inc_shd.g_old_rec.inc_information26
700: => per_inc_shd.g_old_rec.inc_information23
701: ,p_inc_information24_o
702: => per_inc_shd.g_old_rec.inc_information24
703: ,p_inc_information25_o
704: => per_inc_shd.g_old_rec.inc_information25
705: ,p_inc_information26_o
706: => per_inc_shd.g_old_rec.inc_information26
707: ,p_inc_information27_o
708: => per_inc_shd.g_old_rec.inc_information27
702: => per_inc_shd.g_old_rec.inc_information24
703: ,p_inc_information25_o
704: => per_inc_shd.g_old_rec.inc_information25
705: ,p_inc_information26_o
706: => per_inc_shd.g_old_rec.inc_information26
707: ,p_inc_information27_o
708: => per_inc_shd.g_old_rec.inc_information27
709: ,p_inc_information28_o
710: => per_inc_shd.g_old_rec.inc_information28
704: => per_inc_shd.g_old_rec.inc_information25
705: ,p_inc_information26_o
706: => per_inc_shd.g_old_rec.inc_information26
707: ,p_inc_information27_o
708: => per_inc_shd.g_old_rec.inc_information27
709: ,p_inc_information28_o
710: => per_inc_shd.g_old_rec.inc_information28
711: ,p_inc_information29_o
712: => per_inc_shd.g_old_rec.inc_information29
706: => per_inc_shd.g_old_rec.inc_information26
707: ,p_inc_information27_o
708: => per_inc_shd.g_old_rec.inc_information27
709: ,p_inc_information28_o
710: => per_inc_shd.g_old_rec.inc_information28
711: ,p_inc_information29_o
712: => per_inc_shd.g_old_rec.inc_information29
713: ,p_inc_information30_o
714: => per_inc_shd.g_old_rec.inc_information30
708: => per_inc_shd.g_old_rec.inc_information27
709: ,p_inc_information28_o
710: => per_inc_shd.g_old_rec.inc_information28
711: ,p_inc_information29_o
712: => per_inc_shd.g_old_rec.inc_information29
713: ,p_inc_information30_o
714: => per_inc_shd.g_old_rec.inc_information30
715: ,p_object_version_number_o
716: => per_inc_shd.g_old_rec.object_version_number
710: => per_inc_shd.g_old_rec.inc_information28
711: ,p_inc_information29_o
712: => per_inc_shd.g_old_rec.inc_information29
713: ,p_inc_information30_o
714: => per_inc_shd.g_old_rec.inc_information30
715: ,p_object_version_number_o
716: => per_inc_shd.g_old_rec.object_version_number
717: );
718: --
712: => per_inc_shd.g_old_rec.inc_information29
713: ,p_inc_information30_o
714: => per_inc_shd.g_old_rec.inc_information30
715: ,p_object_version_number_o
716: => per_inc_shd.g_old_rec.object_version_number
717: );
718: --
719: exception
720: --
772: --
773: -- {End Of Comments}
774: -- ----------------------------------------------------------------------------
775: Procedure convert_defs
776: (p_rec in out nocopy per_inc_shd.g_rec_type
777: ) is
778: --
779: Begin
780: --
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
791: p_rec.incident_reference :=
792: per_inc_shd.g_old_rec.incident_reference;
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
795: p_rec.incident_type :=
796: per_inc_shd.g_old_rec.incident_type;
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
799: p_rec.incident_date :=
800: per_inc_shd.g_old_rec.incident_date;
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
803: p_rec.incident_time :=
804: per_inc_shd.g_old_rec.incident_time;
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
807: p_rec.org_notified_date :=
808: per_inc_shd.g_old_rec.org_notified_date;
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
811: p_rec.assignment_id :=
812: per_inc_shd.g_old_rec.assignment_id;
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
815: p_rec.location :=
816: per_inc_shd.g_old_rec.location;
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
819: p_rec.at_work_flag :=
820: per_inc_shd.g_old_rec.at_work_flag;
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
823: p_rec.report_date :=
824: per_inc_shd.g_old_rec.report_date;
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
827: p_rec.report_time :=
828: per_inc_shd.g_old_rec.report_time;
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
831: p_rec.report_method :=
832: per_inc_shd.g_old_rec.report_method;
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
835: p_rec.person_reported_by :=
836: per_inc_shd.g_old_rec.person_reported_by;
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
839: p_rec.person_reported_to :=
840: per_inc_shd.g_old_rec.person_reported_to;
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
843: p_rec.witness_details :=
844: per_inc_shd.g_old_rec.witness_details;
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
847: p_rec.description :=
848: per_inc_shd.g_old_rec.description;
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
851: p_rec.injury_type :=
852: per_inc_shd.g_old_rec.injury_type;
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
855: p_rec.disease_type :=
856: per_inc_shd.g_old_rec.disease_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
859: p_rec.hazard_type :=
860: per_inc_shd.g_old_rec.hazard_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
863: p_rec.body_part :=
864: per_inc_shd.g_old_rec.body_part;
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
867: p_rec.treatment_received_flag :=
868: per_inc_shd.g_old_rec.treatment_received_flag;
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
871: p_rec.hospital_details :=
872: per_inc_shd.g_old_rec.hospital_details;
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: --
875: --
876: --
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
883: p_rec.hospitalized_flag :=
884: per_inc_shd.g_old_rec.hospitalized_flag;
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
887: p_rec.hospital_address :=
888: per_inc_shd.g_old_rec.hospital_address;
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
891: p_rec.activity_at_time_of_work :=
892: per_inc_shd.g_old_rec.activity_at_time_of_work;
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
895: p_rec.objects_involved :=
896: per_inc_shd.g_old_rec.objects_involved;
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
899: p_rec.privacy_issue :=
900: per_inc_shd.g_old_rec.privacy_issue;
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
903: p_rec.work_start_time :=
904: per_inc_shd.g_old_rec.work_start_time;
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
907: p_rec.date_of_death :=
908: per_inc_shd.g_old_rec.date_of_death;
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
911: p_rec.report_completed_by :=
912: per_inc_shd.g_old_rec.report_completed_by;
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
915: p_rec.reporting_person_title :=
916: per_inc_shd.g_old_rec.reporting_person_title;
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
919: p_rec.reporting_person_phone :=
920: per_inc_shd.g_old_rec.reporting_person_phone;
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
923: p_rec.days_restricted_work :=
924: per_inc_shd.g_old_rec.days_restricted_work;
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
927: p_rec.days_away_from_work :=
928: per_inc_shd.g_old_rec.days_away_from_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
940: p_rec.compensation_date :=
941: per_inc_shd.g_old_rec.compensation_date;
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
944: p_rec.compensation_currency :=
945: per_inc_shd.g_old_rec.compensation_currency;
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
948: p_rec.compensation_amount :=
949: per_inc_shd.g_old_rec.compensation_amount;
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
952: p_rec.remedial_hs_action :=
953: per_inc_shd.g_old_rec.remedial_hs_action;
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
956: p_rec.notified_hsrep_id :=
957: per_inc_shd.g_old_rec.notified_hsrep_id;
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
960: p_rec.notified_hsrep_date :=
961: per_inc_shd.g_old_rec.notified_hsrep_date;
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
964: p_rec.notified_rep_id :=
965: per_inc_shd.g_old_rec.notified_rep_id;
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
968: p_rec.notified_rep_date :=
969: per_inc_shd.g_old_rec.notified_rep_date;
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
972: p_rec.notified_rep_org_id :=
973: per_inc_shd.g_old_rec.notified_rep_org_id;
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
976: p_rec.related_incident_id :=
977: per_inc_shd.g_old_rec.related_incident_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
980: p_rec.over_time_flag :=
981: per_inc_shd.g_old_rec.over_time_flag;
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
984: p_rec.absence_exists_flag :=
985: per_inc_shd.g_old_rec.absence_exists_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
988: p_rec.attribute_category :=
989: per_inc_shd.g_old_rec.attribute_category;
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
992: p_rec.attribute1 :=
993: per_inc_shd.g_old_rec.attribute1;
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
996: p_rec.attribute2 :=
997: per_inc_shd.g_old_rec.attribute2;
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
1000: p_rec.attribute3 :=
1001: per_inc_shd.g_old_rec.attribute3;
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
1004: p_rec.attribute4 :=
1005: per_inc_shd.g_old_rec.attribute4;
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
1008: p_rec.attribute5 :=
1009: per_inc_shd.g_old_rec.attribute5;
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
1012: p_rec.attribute6 :=
1013: per_inc_shd.g_old_rec.attribute6;
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
1016: p_rec.attribute7 :=
1017: per_inc_shd.g_old_rec.attribute7;
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
1020: p_rec.attribute8 :=
1021: per_inc_shd.g_old_rec.attribute8;
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
1024: p_rec.attribute9 :=
1025: per_inc_shd.g_old_rec.attribute9;
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
1028: p_rec.attribute10 :=
1029: per_inc_shd.g_old_rec.attribute10;
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
1032: p_rec.attribute11 :=
1033: per_inc_shd.g_old_rec.attribute11;
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
1036: p_rec.attribute12 :=
1037: per_inc_shd.g_old_rec.attribute12;
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
1040: p_rec.attribute13 :=
1041: per_inc_shd.g_old_rec.attribute13;
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
1044: p_rec.attribute14 :=
1045: per_inc_shd.g_old_rec.attribute14;
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
1048: p_rec.attribute15 :=
1049: per_inc_shd.g_old_rec.attribute15;
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
1052: p_rec.attribute16 :=
1053: per_inc_shd.g_old_rec.attribute16;
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
1056: p_rec.attribute17 :=
1057: per_inc_shd.g_old_rec.attribute17;
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
1060: p_rec.attribute18 :=
1061: per_inc_shd.g_old_rec.attribute18;
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
1064: p_rec.attribute19 :=
1065: per_inc_shd.g_old_rec.attribute19;
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
1068: p_rec.attribute20 :=
1069: per_inc_shd.g_old_rec.attribute20;
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
1072: p_rec.attribute21 :=
1073: per_inc_shd.g_old_rec.attribute21;
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
1076: p_rec.attribute22 :=
1077: per_inc_shd.g_old_rec.attribute22;
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
1080: p_rec.attribute23 :=
1081: per_inc_shd.g_old_rec.attribute23;
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
1084: p_rec.attribute24 :=
1085: per_inc_shd.g_old_rec.attribute24;
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
1088: p_rec.attribute25 :=
1089: per_inc_shd.g_old_rec.attribute25;
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
1092: p_rec.attribute26 :=
1093: per_inc_shd.g_old_rec.attribute26;
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
1096: p_rec.attribute27 :=
1097: per_inc_shd.g_old_rec.attribute27;
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
1100: p_rec.attribute28 :=
1101: per_inc_shd.g_old_rec.attribute28;
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
1104: p_rec.attribute29 :=
1105: per_inc_shd.g_old_rec.attribute29;
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
1108: p_rec.attribute30 :=
1109: per_inc_shd.g_old_rec.attribute30;
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
1112: p_rec.inc_information_category :=
1113: per_inc_shd.g_old_rec.inc_information_category;
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
1116: p_rec.inc_information1 :=
1117: per_inc_shd.g_old_rec.inc_information1;
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
1120: p_rec.inc_information2 :=
1121: per_inc_shd.g_old_rec.inc_information2;
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
1124: p_rec.inc_information3 :=
1125: per_inc_shd.g_old_rec.inc_information3;
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
1128: p_rec.inc_information4 :=
1129: per_inc_shd.g_old_rec.inc_information4;
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
1132: p_rec.inc_information5 :=
1133: per_inc_shd.g_old_rec.inc_information5;
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
1136: p_rec.inc_information6 :=
1137: per_inc_shd.g_old_rec.inc_information6;
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
1140: p_rec.inc_information7 :=
1141: per_inc_shd.g_old_rec.inc_information7;
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
1144: p_rec.inc_information8 :=
1145: per_inc_shd.g_old_rec.inc_information8;
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
1148: p_rec.inc_information9 :=
1149: per_inc_shd.g_old_rec.inc_information9;
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
1152: p_rec.inc_information10 :=
1153: per_inc_shd.g_old_rec.inc_information10;
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
1156: p_rec.inc_information11 :=
1157: per_inc_shd.g_old_rec.inc_information11;
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
1160: p_rec.inc_information12 :=
1161: per_inc_shd.g_old_rec.inc_information12;
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
1164: p_rec.inc_information13 :=
1165: per_inc_shd.g_old_rec.inc_information13;
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
1168: p_rec.inc_information14 :=
1169: per_inc_shd.g_old_rec.inc_information14;
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
1172: p_rec.inc_information15 :=
1173: per_inc_shd.g_old_rec.inc_information15;
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
1176: p_rec.inc_information16 :=
1177: per_inc_shd.g_old_rec.inc_information16;
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
1180: p_rec.inc_information17 :=
1181: per_inc_shd.g_old_rec.inc_information17;
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
1184: p_rec.inc_information18 :=
1185: per_inc_shd.g_old_rec.inc_information18;
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
1188: p_rec.inc_information19 :=
1189: per_inc_shd.g_old_rec.inc_information19;
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
1192: p_rec.inc_information20 :=
1193: per_inc_shd.g_old_rec.inc_information20;
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
1196: p_rec.inc_information21 :=
1197: per_inc_shd.g_old_rec.inc_information21;
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
1200: p_rec.inc_information22 :=
1201: per_inc_shd.g_old_rec.inc_information22;
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
1204: p_rec.inc_information23 :=
1205: per_inc_shd.g_old_rec.inc_information23;
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
1208: p_rec.inc_information24 :=
1209: per_inc_shd.g_old_rec.inc_information24;
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
1212: p_rec.inc_information25 :=
1213: per_inc_shd.g_old_rec.inc_information25;
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
1216: p_rec.inc_information26 :=
1217: per_inc_shd.g_old_rec.inc_information26;
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
1220: p_rec.inc_information27 :=
1221: per_inc_shd.g_old_rec.inc_information27;
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
1224: p_rec.inc_information28 :=
1225: per_inc_shd.g_old_rec.inc_information28;
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
1228: p_rec.inc_information29 :=
1229: per_inc_shd.g_old_rec.inc_information29;
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
1232: p_rec.inc_information30 :=
1233: per_inc_shd.g_old_rec.inc_information30;
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: --
1236: End convert_defs;
1237: --
1239: -- |---------------------------------< upd >----------------------------------|
1240: -- ----------------------------------------------------------------------------
1241: Procedure upd
1242: (p_effective_date in date
1243: ,p_rec in out nocopy per_inc_shd.g_rec_type
1244: ) is
1245: --
1246: l_proc varchar2(72) := g_package||'upd';
1247: --
1249: hr_utility.set_location('Entering:'||l_proc, 5);
1250: --
1251: -- We must lock the row which we need to update.
1252: --
1253: per_inc_shd.lck
1254: (p_rec.incident_id
1255: ,p_rec.object_version_number
1256: );
1257: --
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';
1406: --
1407: Begin
1408: hr_utility.set_location('Entering:'||l_proc, 5);
1409: --
1410: -- Call conversion function to turn arguments into the
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