[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_dis_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: --
184: per_dis_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
189: per_dis_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: --
193: Raise;
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure update_dml
228: (p_rec in out nocopy per_dis_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date
291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure dt_pre_update
295: (p_rec in out nocopy per_dis_shd.g_rec_type
296: ,p_effective_date in date
297: ,p_datetrack_mode in varchar2
298: ,p_validation_start_date in date
299: ,p_validation_end_date in date
307: If (p_datetrack_mode <> hr_api.g_correction) then
308: --
309: -- Update the current effective end date
310: --
311: per_dis_shd.upd_effective_end_date
312: (p_effective_date => p_effective_date
313: ,p_base_key_value => p_rec.disability_id
314: ,p_new_effective_end_date => (p_validation_start_date - 1)
315: ,p_validation_start_date => p_validation_start_date
377: --
378: -- {End Of Comments}
379: -- ----------------------------------------------------------------------------
380: Procedure pre_update
381: (p_rec in out nocopy per_dis_shd.g_rec_type
382: ,p_effective_date in date
383: ,p_datetrack_mode in varchar2
384: ,p_validation_start_date in date
385: ,p_validation_end_date in date
435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure post_update
439: (p_rec in per_dis_shd.g_rec_type
440: ,p_effective_date in date
441: ,p_datetrack_mode in varchar2
442: ,p_validation_start_date in date
443: ,p_validation_end_date in date
616: => p_rec.dis_information30
617: ,p_object_version_number
618: => p_rec.object_version_number
619: ,p_effective_start_date_o
620: => per_dis_shd.g_old_rec.effective_start_date
621: ,p_effective_end_date_o
622: => per_dis_shd.g_old_rec.effective_end_date
623: ,p_person_id_o
624: => per_dis_shd.g_old_rec.person_id
618: => p_rec.object_version_number
619: ,p_effective_start_date_o
620: => per_dis_shd.g_old_rec.effective_start_date
621: ,p_effective_end_date_o
622: => per_dis_shd.g_old_rec.effective_end_date
623: ,p_person_id_o
624: => per_dis_shd.g_old_rec.person_id
625: ,p_incident_id_o
626: => per_dis_shd.g_old_rec.incident_id
620: => per_dis_shd.g_old_rec.effective_start_date
621: ,p_effective_end_date_o
622: => per_dis_shd.g_old_rec.effective_end_date
623: ,p_person_id_o
624: => per_dis_shd.g_old_rec.person_id
625: ,p_incident_id_o
626: => per_dis_shd.g_old_rec.incident_id
627: ,p_organization_id_o
628: => per_dis_shd.g_old_rec.organization_id
622: => per_dis_shd.g_old_rec.effective_end_date
623: ,p_person_id_o
624: => per_dis_shd.g_old_rec.person_id
625: ,p_incident_id_o
626: => per_dis_shd.g_old_rec.incident_id
627: ,p_organization_id_o
628: => per_dis_shd.g_old_rec.organization_id
629: ,p_registration_id_o
630: => per_dis_shd.g_old_rec.registration_id
624: => per_dis_shd.g_old_rec.person_id
625: ,p_incident_id_o
626: => per_dis_shd.g_old_rec.incident_id
627: ,p_organization_id_o
628: => per_dis_shd.g_old_rec.organization_id
629: ,p_registration_id_o
630: => per_dis_shd.g_old_rec.registration_id
631: ,p_registration_date_o
632: => per_dis_shd.g_old_rec.registration_date
626: => per_dis_shd.g_old_rec.incident_id
627: ,p_organization_id_o
628: => per_dis_shd.g_old_rec.organization_id
629: ,p_registration_id_o
630: => per_dis_shd.g_old_rec.registration_id
631: ,p_registration_date_o
632: => per_dis_shd.g_old_rec.registration_date
633: ,p_registration_exp_date_o
634: => per_dis_shd.g_old_rec.registration_exp_date
628: => per_dis_shd.g_old_rec.organization_id
629: ,p_registration_id_o
630: => per_dis_shd.g_old_rec.registration_id
631: ,p_registration_date_o
632: => per_dis_shd.g_old_rec.registration_date
633: ,p_registration_exp_date_o
634: => per_dis_shd.g_old_rec.registration_exp_date
635: ,p_category_o
636: => per_dis_shd.g_old_rec.category
630: => per_dis_shd.g_old_rec.registration_id
631: ,p_registration_date_o
632: => per_dis_shd.g_old_rec.registration_date
633: ,p_registration_exp_date_o
634: => per_dis_shd.g_old_rec.registration_exp_date
635: ,p_category_o
636: => per_dis_shd.g_old_rec.category
637: ,p_status_o
638: => per_dis_shd.g_old_rec.status
632: => per_dis_shd.g_old_rec.registration_date
633: ,p_registration_exp_date_o
634: => per_dis_shd.g_old_rec.registration_exp_date
635: ,p_category_o
636: => per_dis_shd.g_old_rec.category
637: ,p_status_o
638: => per_dis_shd.g_old_rec.status
639: ,p_description_o
640: => per_dis_shd.g_old_rec.description
634: => per_dis_shd.g_old_rec.registration_exp_date
635: ,p_category_o
636: => per_dis_shd.g_old_rec.category
637: ,p_status_o
638: => per_dis_shd.g_old_rec.status
639: ,p_description_o
640: => per_dis_shd.g_old_rec.description
641: ,p_degree_o
642: => per_dis_shd.g_old_rec.degree
636: => per_dis_shd.g_old_rec.category
637: ,p_status_o
638: => per_dis_shd.g_old_rec.status
639: ,p_description_o
640: => per_dis_shd.g_old_rec.description
641: ,p_degree_o
642: => per_dis_shd.g_old_rec.degree
643: ,p_quota_fte_o
644: => per_dis_shd.g_old_rec.quota_fte
638: => per_dis_shd.g_old_rec.status
639: ,p_description_o
640: => per_dis_shd.g_old_rec.description
641: ,p_degree_o
642: => per_dis_shd.g_old_rec.degree
643: ,p_quota_fte_o
644: => per_dis_shd.g_old_rec.quota_fte
645: ,p_reason_o
646: => per_dis_shd.g_old_rec.reason
640: => per_dis_shd.g_old_rec.description
641: ,p_degree_o
642: => per_dis_shd.g_old_rec.degree
643: ,p_quota_fte_o
644: => per_dis_shd.g_old_rec.quota_fte
645: ,p_reason_o
646: => per_dis_shd.g_old_rec.reason
647: ,p_pre_registration_job_o
648: => per_dis_shd.g_old_rec.pre_registration_job
642: => per_dis_shd.g_old_rec.degree
643: ,p_quota_fte_o
644: => per_dis_shd.g_old_rec.quota_fte
645: ,p_reason_o
646: => per_dis_shd.g_old_rec.reason
647: ,p_pre_registration_job_o
648: => per_dis_shd.g_old_rec.pre_registration_job
649: ,p_work_restriction_o
650: => per_dis_shd.g_old_rec.work_restriction
644: => per_dis_shd.g_old_rec.quota_fte
645: ,p_reason_o
646: => per_dis_shd.g_old_rec.reason
647: ,p_pre_registration_job_o
648: => per_dis_shd.g_old_rec.pre_registration_job
649: ,p_work_restriction_o
650: => per_dis_shd.g_old_rec.work_restriction
651: ,p_attribute_category_o
652: => per_dis_shd.g_old_rec.attribute_category
646: => per_dis_shd.g_old_rec.reason
647: ,p_pre_registration_job_o
648: => per_dis_shd.g_old_rec.pre_registration_job
649: ,p_work_restriction_o
650: => per_dis_shd.g_old_rec.work_restriction
651: ,p_attribute_category_o
652: => per_dis_shd.g_old_rec.attribute_category
653: ,p_attribute1_o
654: => per_dis_shd.g_old_rec.attribute1
648: => per_dis_shd.g_old_rec.pre_registration_job
649: ,p_work_restriction_o
650: => per_dis_shd.g_old_rec.work_restriction
651: ,p_attribute_category_o
652: => per_dis_shd.g_old_rec.attribute_category
653: ,p_attribute1_o
654: => per_dis_shd.g_old_rec.attribute1
655: ,p_attribute2_o
656: => per_dis_shd.g_old_rec.attribute2
650: => per_dis_shd.g_old_rec.work_restriction
651: ,p_attribute_category_o
652: => per_dis_shd.g_old_rec.attribute_category
653: ,p_attribute1_o
654: => per_dis_shd.g_old_rec.attribute1
655: ,p_attribute2_o
656: => per_dis_shd.g_old_rec.attribute2
657: ,p_attribute3_o
658: => per_dis_shd.g_old_rec.attribute3
652: => per_dis_shd.g_old_rec.attribute_category
653: ,p_attribute1_o
654: => per_dis_shd.g_old_rec.attribute1
655: ,p_attribute2_o
656: => per_dis_shd.g_old_rec.attribute2
657: ,p_attribute3_o
658: => per_dis_shd.g_old_rec.attribute3
659: ,p_attribute4_o
660: => per_dis_shd.g_old_rec.attribute4
654: => per_dis_shd.g_old_rec.attribute1
655: ,p_attribute2_o
656: => per_dis_shd.g_old_rec.attribute2
657: ,p_attribute3_o
658: => per_dis_shd.g_old_rec.attribute3
659: ,p_attribute4_o
660: => per_dis_shd.g_old_rec.attribute4
661: ,p_attribute5_o
662: => per_dis_shd.g_old_rec.attribute5
656: => per_dis_shd.g_old_rec.attribute2
657: ,p_attribute3_o
658: => per_dis_shd.g_old_rec.attribute3
659: ,p_attribute4_o
660: => per_dis_shd.g_old_rec.attribute4
661: ,p_attribute5_o
662: => per_dis_shd.g_old_rec.attribute5
663: ,p_attribute6_o
664: => per_dis_shd.g_old_rec.attribute6
658: => per_dis_shd.g_old_rec.attribute3
659: ,p_attribute4_o
660: => per_dis_shd.g_old_rec.attribute4
661: ,p_attribute5_o
662: => per_dis_shd.g_old_rec.attribute5
663: ,p_attribute6_o
664: => per_dis_shd.g_old_rec.attribute6
665: ,p_attribute7_o
666: => per_dis_shd.g_old_rec.attribute7
660: => per_dis_shd.g_old_rec.attribute4
661: ,p_attribute5_o
662: => per_dis_shd.g_old_rec.attribute5
663: ,p_attribute6_o
664: => per_dis_shd.g_old_rec.attribute6
665: ,p_attribute7_o
666: => per_dis_shd.g_old_rec.attribute7
667: ,p_attribute8_o
668: => per_dis_shd.g_old_rec.attribute8
662: => per_dis_shd.g_old_rec.attribute5
663: ,p_attribute6_o
664: => per_dis_shd.g_old_rec.attribute6
665: ,p_attribute7_o
666: => per_dis_shd.g_old_rec.attribute7
667: ,p_attribute8_o
668: => per_dis_shd.g_old_rec.attribute8
669: ,p_attribute9_o
670: => per_dis_shd.g_old_rec.attribute9
664: => per_dis_shd.g_old_rec.attribute6
665: ,p_attribute7_o
666: => per_dis_shd.g_old_rec.attribute7
667: ,p_attribute8_o
668: => per_dis_shd.g_old_rec.attribute8
669: ,p_attribute9_o
670: => per_dis_shd.g_old_rec.attribute9
671: ,p_attribute10_o
672: => per_dis_shd.g_old_rec.attribute10
666: => per_dis_shd.g_old_rec.attribute7
667: ,p_attribute8_o
668: => per_dis_shd.g_old_rec.attribute8
669: ,p_attribute9_o
670: => per_dis_shd.g_old_rec.attribute9
671: ,p_attribute10_o
672: => per_dis_shd.g_old_rec.attribute10
673: ,p_attribute11_o
674: => per_dis_shd.g_old_rec.attribute11
668: => per_dis_shd.g_old_rec.attribute8
669: ,p_attribute9_o
670: => per_dis_shd.g_old_rec.attribute9
671: ,p_attribute10_o
672: => per_dis_shd.g_old_rec.attribute10
673: ,p_attribute11_o
674: => per_dis_shd.g_old_rec.attribute11
675: ,p_attribute12_o
676: => per_dis_shd.g_old_rec.attribute12
670: => per_dis_shd.g_old_rec.attribute9
671: ,p_attribute10_o
672: => per_dis_shd.g_old_rec.attribute10
673: ,p_attribute11_o
674: => per_dis_shd.g_old_rec.attribute11
675: ,p_attribute12_o
676: => per_dis_shd.g_old_rec.attribute12
677: ,p_attribute13_o
678: => per_dis_shd.g_old_rec.attribute13
672: => per_dis_shd.g_old_rec.attribute10
673: ,p_attribute11_o
674: => per_dis_shd.g_old_rec.attribute11
675: ,p_attribute12_o
676: => per_dis_shd.g_old_rec.attribute12
677: ,p_attribute13_o
678: => per_dis_shd.g_old_rec.attribute13
679: ,p_attribute14_o
680: => per_dis_shd.g_old_rec.attribute14
674: => per_dis_shd.g_old_rec.attribute11
675: ,p_attribute12_o
676: => per_dis_shd.g_old_rec.attribute12
677: ,p_attribute13_o
678: => per_dis_shd.g_old_rec.attribute13
679: ,p_attribute14_o
680: => per_dis_shd.g_old_rec.attribute14
681: ,p_attribute15_o
682: => per_dis_shd.g_old_rec.attribute15
676: => per_dis_shd.g_old_rec.attribute12
677: ,p_attribute13_o
678: => per_dis_shd.g_old_rec.attribute13
679: ,p_attribute14_o
680: => per_dis_shd.g_old_rec.attribute14
681: ,p_attribute15_o
682: => per_dis_shd.g_old_rec.attribute15
683: ,p_attribute16_o
684: => per_dis_shd.g_old_rec.attribute16
678: => per_dis_shd.g_old_rec.attribute13
679: ,p_attribute14_o
680: => per_dis_shd.g_old_rec.attribute14
681: ,p_attribute15_o
682: => per_dis_shd.g_old_rec.attribute15
683: ,p_attribute16_o
684: => per_dis_shd.g_old_rec.attribute16
685: ,p_attribute17_o
686: => per_dis_shd.g_old_rec.attribute17
680: => per_dis_shd.g_old_rec.attribute14
681: ,p_attribute15_o
682: => per_dis_shd.g_old_rec.attribute15
683: ,p_attribute16_o
684: => per_dis_shd.g_old_rec.attribute16
685: ,p_attribute17_o
686: => per_dis_shd.g_old_rec.attribute17
687: ,p_attribute18_o
688: => per_dis_shd.g_old_rec.attribute18
682: => per_dis_shd.g_old_rec.attribute15
683: ,p_attribute16_o
684: => per_dis_shd.g_old_rec.attribute16
685: ,p_attribute17_o
686: => per_dis_shd.g_old_rec.attribute17
687: ,p_attribute18_o
688: => per_dis_shd.g_old_rec.attribute18
689: ,p_attribute19_o
690: => per_dis_shd.g_old_rec.attribute19
684: => per_dis_shd.g_old_rec.attribute16
685: ,p_attribute17_o
686: => per_dis_shd.g_old_rec.attribute17
687: ,p_attribute18_o
688: => per_dis_shd.g_old_rec.attribute18
689: ,p_attribute19_o
690: => per_dis_shd.g_old_rec.attribute19
691: ,p_attribute20_o
692: => per_dis_shd.g_old_rec.attribute20
686: => per_dis_shd.g_old_rec.attribute17
687: ,p_attribute18_o
688: => per_dis_shd.g_old_rec.attribute18
689: ,p_attribute19_o
690: => per_dis_shd.g_old_rec.attribute19
691: ,p_attribute20_o
692: => per_dis_shd.g_old_rec.attribute20
693: ,p_attribute21_o
694: => per_dis_shd.g_old_rec.attribute21
688: => per_dis_shd.g_old_rec.attribute18
689: ,p_attribute19_o
690: => per_dis_shd.g_old_rec.attribute19
691: ,p_attribute20_o
692: => per_dis_shd.g_old_rec.attribute20
693: ,p_attribute21_o
694: => per_dis_shd.g_old_rec.attribute21
695: ,p_attribute22_o
696: => per_dis_shd.g_old_rec.attribute22
690: => per_dis_shd.g_old_rec.attribute19
691: ,p_attribute20_o
692: => per_dis_shd.g_old_rec.attribute20
693: ,p_attribute21_o
694: => per_dis_shd.g_old_rec.attribute21
695: ,p_attribute22_o
696: => per_dis_shd.g_old_rec.attribute22
697: ,p_attribute23_o
698: => per_dis_shd.g_old_rec.attribute23
692: => per_dis_shd.g_old_rec.attribute20
693: ,p_attribute21_o
694: => per_dis_shd.g_old_rec.attribute21
695: ,p_attribute22_o
696: => per_dis_shd.g_old_rec.attribute22
697: ,p_attribute23_o
698: => per_dis_shd.g_old_rec.attribute23
699: ,p_attribute24_o
700: => per_dis_shd.g_old_rec.attribute24
694: => per_dis_shd.g_old_rec.attribute21
695: ,p_attribute22_o
696: => per_dis_shd.g_old_rec.attribute22
697: ,p_attribute23_o
698: => per_dis_shd.g_old_rec.attribute23
699: ,p_attribute24_o
700: => per_dis_shd.g_old_rec.attribute24
701: ,p_attribute25_o
702: => per_dis_shd.g_old_rec.attribute25
696: => per_dis_shd.g_old_rec.attribute22
697: ,p_attribute23_o
698: => per_dis_shd.g_old_rec.attribute23
699: ,p_attribute24_o
700: => per_dis_shd.g_old_rec.attribute24
701: ,p_attribute25_o
702: => per_dis_shd.g_old_rec.attribute25
703: ,p_attribute26_o
704: => per_dis_shd.g_old_rec.attribute26
698: => per_dis_shd.g_old_rec.attribute23
699: ,p_attribute24_o
700: => per_dis_shd.g_old_rec.attribute24
701: ,p_attribute25_o
702: => per_dis_shd.g_old_rec.attribute25
703: ,p_attribute26_o
704: => per_dis_shd.g_old_rec.attribute26
705: ,p_attribute27_o
706: => per_dis_shd.g_old_rec.attribute27
700: => per_dis_shd.g_old_rec.attribute24
701: ,p_attribute25_o
702: => per_dis_shd.g_old_rec.attribute25
703: ,p_attribute26_o
704: => per_dis_shd.g_old_rec.attribute26
705: ,p_attribute27_o
706: => per_dis_shd.g_old_rec.attribute27
707: ,p_attribute28_o
708: => per_dis_shd.g_old_rec.attribute28
702: => per_dis_shd.g_old_rec.attribute25
703: ,p_attribute26_o
704: => per_dis_shd.g_old_rec.attribute26
705: ,p_attribute27_o
706: => per_dis_shd.g_old_rec.attribute27
707: ,p_attribute28_o
708: => per_dis_shd.g_old_rec.attribute28
709: ,p_attribute29_o
710: => per_dis_shd.g_old_rec.attribute29
704: => per_dis_shd.g_old_rec.attribute26
705: ,p_attribute27_o
706: => per_dis_shd.g_old_rec.attribute27
707: ,p_attribute28_o
708: => per_dis_shd.g_old_rec.attribute28
709: ,p_attribute29_o
710: => per_dis_shd.g_old_rec.attribute29
711: ,p_attribute30_o
712: => per_dis_shd.g_old_rec.attribute30
706: => per_dis_shd.g_old_rec.attribute27
707: ,p_attribute28_o
708: => per_dis_shd.g_old_rec.attribute28
709: ,p_attribute29_o
710: => per_dis_shd.g_old_rec.attribute29
711: ,p_attribute30_o
712: => per_dis_shd.g_old_rec.attribute30
713: ,p_dis_information_category_o
714: => per_dis_shd.g_old_rec.dis_information_category
708: => per_dis_shd.g_old_rec.attribute28
709: ,p_attribute29_o
710: => per_dis_shd.g_old_rec.attribute29
711: ,p_attribute30_o
712: => per_dis_shd.g_old_rec.attribute30
713: ,p_dis_information_category_o
714: => per_dis_shd.g_old_rec.dis_information_category
715: ,p_dis_information1_o
716: => per_dis_shd.g_old_rec.dis_information1
710: => per_dis_shd.g_old_rec.attribute29
711: ,p_attribute30_o
712: => per_dis_shd.g_old_rec.attribute30
713: ,p_dis_information_category_o
714: => per_dis_shd.g_old_rec.dis_information_category
715: ,p_dis_information1_o
716: => per_dis_shd.g_old_rec.dis_information1
717: ,p_dis_information2_o
718: => per_dis_shd.g_old_rec.dis_information2
712: => per_dis_shd.g_old_rec.attribute30
713: ,p_dis_information_category_o
714: => per_dis_shd.g_old_rec.dis_information_category
715: ,p_dis_information1_o
716: => per_dis_shd.g_old_rec.dis_information1
717: ,p_dis_information2_o
718: => per_dis_shd.g_old_rec.dis_information2
719: ,p_dis_information3_o
720: => per_dis_shd.g_old_rec.dis_information3
714: => per_dis_shd.g_old_rec.dis_information_category
715: ,p_dis_information1_o
716: => per_dis_shd.g_old_rec.dis_information1
717: ,p_dis_information2_o
718: => per_dis_shd.g_old_rec.dis_information2
719: ,p_dis_information3_o
720: => per_dis_shd.g_old_rec.dis_information3
721: ,p_dis_information4_o
722: => per_dis_shd.g_old_rec.dis_information4
716: => per_dis_shd.g_old_rec.dis_information1
717: ,p_dis_information2_o
718: => per_dis_shd.g_old_rec.dis_information2
719: ,p_dis_information3_o
720: => per_dis_shd.g_old_rec.dis_information3
721: ,p_dis_information4_o
722: => per_dis_shd.g_old_rec.dis_information4
723: ,p_dis_information5_o
724: => per_dis_shd.g_old_rec.dis_information5
718: => per_dis_shd.g_old_rec.dis_information2
719: ,p_dis_information3_o
720: => per_dis_shd.g_old_rec.dis_information3
721: ,p_dis_information4_o
722: => per_dis_shd.g_old_rec.dis_information4
723: ,p_dis_information5_o
724: => per_dis_shd.g_old_rec.dis_information5
725: ,p_dis_information6_o
726: => per_dis_shd.g_old_rec.dis_information6
720: => per_dis_shd.g_old_rec.dis_information3
721: ,p_dis_information4_o
722: => per_dis_shd.g_old_rec.dis_information4
723: ,p_dis_information5_o
724: => per_dis_shd.g_old_rec.dis_information5
725: ,p_dis_information6_o
726: => per_dis_shd.g_old_rec.dis_information6
727: ,p_dis_information7_o
728: => per_dis_shd.g_old_rec.dis_information7
722: => per_dis_shd.g_old_rec.dis_information4
723: ,p_dis_information5_o
724: => per_dis_shd.g_old_rec.dis_information5
725: ,p_dis_information6_o
726: => per_dis_shd.g_old_rec.dis_information6
727: ,p_dis_information7_o
728: => per_dis_shd.g_old_rec.dis_information7
729: ,p_dis_information8_o
730: => per_dis_shd.g_old_rec.dis_information8
724: => per_dis_shd.g_old_rec.dis_information5
725: ,p_dis_information6_o
726: => per_dis_shd.g_old_rec.dis_information6
727: ,p_dis_information7_o
728: => per_dis_shd.g_old_rec.dis_information7
729: ,p_dis_information8_o
730: => per_dis_shd.g_old_rec.dis_information8
731: ,p_dis_information9_o
732: => per_dis_shd.g_old_rec.dis_information9
726: => per_dis_shd.g_old_rec.dis_information6
727: ,p_dis_information7_o
728: => per_dis_shd.g_old_rec.dis_information7
729: ,p_dis_information8_o
730: => per_dis_shd.g_old_rec.dis_information8
731: ,p_dis_information9_o
732: => per_dis_shd.g_old_rec.dis_information9
733: ,p_dis_information10_o
734: => per_dis_shd.g_old_rec.dis_information10
728: => per_dis_shd.g_old_rec.dis_information7
729: ,p_dis_information8_o
730: => per_dis_shd.g_old_rec.dis_information8
731: ,p_dis_information9_o
732: => per_dis_shd.g_old_rec.dis_information9
733: ,p_dis_information10_o
734: => per_dis_shd.g_old_rec.dis_information10
735: ,p_dis_information11_o
736: => per_dis_shd.g_old_rec.dis_information11
730: => per_dis_shd.g_old_rec.dis_information8
731: ,p_dis_information9_o
732: => per_dis_shd.g_old_rec.dis_information9
733: ,p_dis_information10_o
734: => per_dis_shd.g_old_rec.dis_information10
735: ,p_dis_information11_o
736: => per_dis_shd.g_old_rec.dis_information11
737: ,p_dis_information12_o
738: => per_dis_shd.g_old_rec.dis_information12
732: => per_dis_shd.g_old_rec.dis_information9
733: ,p_dis_information10_o
734: => per_dis_shd.g_old_rec.dis_information10
735: ,p_dis_information11_o
736: => per_dis_shd.g_old_rec.dis_information11
737: ,p_dis_information12_o
738: => per_dis_shd.g_old_rec.dis_information12
739: ,p_dis_information13_o
740: => per_dis_shd.g_old_rec.dis_information13
734: => per_dis_shd.g_old_rec.dis_information10
735: ,p_dis_information11_o
736: => per_dis_shd.g_old_rec.dis_information11
737: ,p_dis_information12_o
738: => per_dis_shd.g_old_rec.dis_information12
739: ,p_dis_information13_o
740: => per_dis_shd.g_old_rec.dis_information13
741: ,p_dis_information14_o
742: => per_dis_shd.g_old_rec.dis_information14
736: => per_dis_shd.g_old_rec.dis_information11
737: ,p_dis_information12_o
738: => per_dis_shd.g_old_rec.dis_information12
739: ,p_dis_information13_o
740: => per_dis_shd.g_old_rec.dis_information13
741: ,p_dis_information14_o
742: => per_dis_shd.g_old_rec.dis_information14
743: ,p_dis_information15_o
744: => per_dis_shd.g_old_rec.dis_information15
738: => per_dis_shd.g_old_rec.dis_information12
739: ,p_dis_information13_o
740: => per_dis_shd.g_old_rec.dis_information13
741: ,p_dis_information14_o
742: => per_dis_shd.g_old_rec.dis_information14
743: ,p_dis_information15_o
744: => per_dis_shd.g_old_rec.dis_information15
745: ,p_dis_information16_o
746: => per_dis_shd.g_old_rec.dis_information16
740: => per_dis_shd.g_old_rec.dis_information13
741: ,p_dis_information14_o
742: => per_dis_shd.g_old_rec.dis_information14
743: ,p_dis_information15_o
744: => per_dis_shd.g_old_rec.dis_information15
745: ,p_dis_information16_o
746: => per_dis_shd.g_old_rec.dis_information16
747: ,p_dis_information17_o
748: => per_dis_shd.g_old_rec.dis_information17
742: => per_dis_shd.g_old_rec.dis_information14
743: ,p_dis_information15_o
744: => per_dis_shd.g_old_rec.dis_information15
745: ,p_dis_information16_o
746: => per_dis_shd.g_old_rec.dis_information16
747: ,p_dis_information17_o
748: => per_dis_shd.g_old_rec.dis_information17
749: ,p_dis_information18_o
750: => per_dis_shd.g_old_rec.dis_information18
744: => per_dis_shd.g_old_rec.dis_information15
745: ,p_dis_information16_o
746: => per_dis_shd.g_old_rec.dis_information16
747: ,p_dis_information17_o
748: => per_dis_shd.g_old_rec.dis_information17
749: ,p_dis_information18_o
750: => per_dis_shd.g_old_rec.dis_information18
751: ,p_dis_information19_o
752: => per_dis_shd.g_old_rec.dis_information19
746: => per_dis_shd.g_old_rec.dis_information16
747: ,p_dis_information17_o
748: => per_dis_shd.g_old_rec.dis_information17
749: ,p_dis_information18_o
750: => per_dis_shd.g_old_rec.dis_information18
751: ,p_dis_information19_o
752: => per_dis_shd.g_old_rec.dis_information19
753: ,p_dis_information20_o
754: => per_dis_shd.g_old_rec.dis_information20
748: => per_dis_shd.g_old_rec.dis_information17
749: ,p_dis_information18_o
750: => per_dis_shd.g_old_rec.dis_information18
751: ,p_dis_information19_o
752: => per_dis_shd.g_old_rec.dis_information19
753: ,p_dis_information20_o
754: => per_dis_shd.g_old_rec.dis_information20
755: ,p_dis_information21_o
756: => per_dis_shd.g_old_rec.dis_information21
750: => per_dis_shd.g_old_rec.dis_information18
751: ,p_dis_information19_o
752: => per_dis_shd.g_old_rec.dis_information19
753: ,p_dis_information20_o
754: => per_dis_shd.g_old_rec.dis_information20
755: ,p_dis_information21_o
756: => per_dis_shd.g_old_rec.dis_information21
757: ,p_dis_information22_o
758: => per_dis_shd.g_old_rec.dis_information22
752: => per_dis_shd.g_old_rec.dis_information19
753: ,p_dis_information20_o
754: => per_dis_shd.g_old_rec.dis_information20
755: ,p_dis_information21_o
756: => per_dis_shd.g_old_rec.dis_information21
757: ,p_dis_information22_o
758: => per_dis_shd.g_old_rec.dis_information22
759: ,p_dis_information23_o
760: => per_dis_shd.g_old_rec.dis_information23
754: => per_dis_shd.g_old_rec.dis_information20
755: ,p_dis_information21_o
756: => per_dis_shd.g_old_rec.dis_information21
757: ,p_dis_information22_o
758: => per_dis_shd.g_old_rec.dis_information22
759: ,p_dis_information23_o
760: => per_dis_shd.g_old_rec.dis_information23
761: ,p_dis_information24_o
762: => per_dis_shd.g_old_rec.dis_information24
756: => per_dis_shd.g_old_rec.dis_information21
757: ,p_dis_information22_o
758: => per_dis_shd.g_old_rec.dis_information22
759: ,p_dis_information23_o
760: => per_dis_shd.g_old_rec.dis_information23
761: ,p_dis_information24_o
762: => per_dis_shd.g_old_rec.dis_information24
763: ,p_dis_information25_o
764: => per_dis_shd.g_old_rec.dis_information25
758: => per_dis_shd.g_old_rec.dis_information22
759: ,p_dis_information23_o
760: => per_dis_shd.g_old_rec.dis_information23
761: ,p_dis_information24_o
762: => per_dis_shd.g_old_rec.dis_information24
763: ,p_dis_information25_o
764: => per_dis_shd.g_old_rec.dis_information25
765: ,p_dis_information26_o
766: => per_dis_shd.g_old_rec.dis_information26
760: => per_dis_shd.g_old_rec.dis_information23
761: ,p_dis_information24_o
762: => per_dis_shd.g_old_rec.dis_information24
763: ,p_dis_information25_o
764: => per_dis_shd.g_old_rec.dis_information25
765: ,p_dis_information26_o
766: => per_dis_shd.g_old_rec.dis_information26
767: ,p_dis_information27_o
768: => per_dis_shd.g_old_rec.dis_information27
762: => per_dis_shd.g_old_rec.dis_information24
763: ,p_dis_information25_o
764: => per_dis_shd.g_old_rec.dis_information25
765: ,p_dis_information26_o
766: => per_dis_shd.g_old_rec.dis_information26
767: ,p_dis_information27_o
768: => per_dis_shd.g_old_rec.dis_information27
769: ,p_dis_information28_o
770: => per_dis_shd.g_old_rec.dis_information28
764: => per_dis_shd.g_old_rec.dis_information25
765: ,p_dis_information26_o
766: => per_dis_shd.g_old_rec.dis_information26
767: ,p_dis_information27_o
768: => per_dis_shd.g_old_rec.dis_information27
769: ,p_dis_information28_o
770: => per_dis_shd.g_old_rec.dis_information28
771: ,p_dis_information29_o
772: => per_dis_shd.g_old_rec.dis_information29
766: => per_dis_shd.g_old_rec.dis_information26
767: ,p_dis_information27_o
768: => per_dis_shd.g_old_rec.dis_information27
769: ,p_dis_information28_o
770: => per_dis_shd.g_old_rec.dis_information28
771: ,p_dis_information29_o
772: => per_dis_shd.g_old_rec.dis_information29
773: ,p_dis_information30_o
774: => per_dis_shd.g_old_rec.dis_information30
768: => per_dis_shd.g_old_rec.dis_information27
769: ,p_dis_information28_o
770: => per_dis_shd.g_old_rec.dis_information28
771: ,p_dis_information29_o
772: => per_dis_shd.g_old_rec.dis_information29
773: ,p_dis_information30_o
774: => per_dis_shd.g_old_rec.dis_information30
775: ,p_object_version_number_o
776: => per_dis_shd.g_old_rec.object_version_number
770: => per_dis_shd.g_old_rec.dis_information28
771: ,p_dis_information29_o
772: => per_dis_shd.g_old_rec.dis_information29
773: ,p_dis_information30_o
774: => per_dis_shd.g_old_rec.dis_information30
775: ,p_object_version_number_o
776: => per_dis_shd.g_old_rec.object_version_number
777: );
778: --
772: => per_dis_shd.g_old_rec.dis_information29
773: ,p_dis_information30_o
774: => per_dis_shd.g_old_rec.dis_information30
775: ,p_object_version_number_o
776: => per_dis_shd.g_old_rec.object_version_number
777: );
778: --
779: exception
780: --
832: --
833: -- {End Of Comments}
834: -- ----------------------------------------------------------------------------
835: Procedure convert_defs
836: (p_rec in out nocopy per_dis_shd.g_rec_type
837: ) is
838: --
839: Begin
840: --
844: -- is being used then we must set to the 'current' argument value.
845: --
846: If (p_rec.person_id = hr_api.g_number) then
847: p_rec.person_id :=
848: per_dis_shd.g_old_rec.person_id;
849: End If;
850: If (p_rec.incident_id = hr_api.g_number) then
851: p_rec.incident_id :=
852: per_dis_shd.g_old_rec.incident_id;
848: per_dis_shd.g_old_rec.person_id;
849: End If;
850: If (p_rec.incident_id = hr_api.g_number) then
851: p_rec.incident_id :=
852: per_dis_shd.g_old_rec.incident_id;
853: End If;
854: If (p_rec.organization_id = hr_api.g_number) then
855: p_rec.organization_id :=
856: per_dis_shd.g_old_rec.organization_id;
852: per_dis_shd.g_old_rec.incident_id;
853: End If;
854: If (p_rec.organization_id = hr_api.g_number) then
855: p_rec.organization_id :=
856: per_dis_shd.g_old_rec.organization_id;
857: End If;
858: If (p_rec.registration_id = hr_api.g_varchar2) then
859: p_rec.registration_id :=
860: per_dis_shd.g_old_rec.registration_id;
856: per_dis_shd.g_old_rec.organization_id;
857: End If;
858: If (p_rec.registration_id = hr_api.g_varchar2) then
859: p_rec.registration_id :=
860: per_dis_shd.g_old_rec.registration_id;
861: End If;
862: If (p_rec.registration_date = hr_api.g_date) then
863: p_rec.registration_date :=
864: per_dis_shd.g_old_rec.registration_date;
860: per_dis_shd.g_old_rec.registration_id;
861: End If;
862: If (p_rec.registration_date = hr_api.g_date) then
863: p_rec.registration_date :=
864: per_dis_shd.g_old_rec.registration_date;
865: End If;
866: If (p_rec.registration_exp_date = hr_api.g_date) then
867: p_rec.registration_exp_date :=
868: per_dis_shd.g_old_rec.registration_exp_date;
864: per_dis_shd.g_old_rec.registration_date;
865: End If;
866: If (p_rec.registration_exp_date = hr_api.g_date) then
867: p_rec.registration_exp_date :=
868: per_dis_shd.g_old_rec.registration_exp_date;
869: End If;
870: If (p_rec.category = hr_api.g_varchar2) then
871: p_rec.category :=
872: per_dis_shd.g_old_rec.category;
868: per_dis_shd.g_old_rec.registration_exp_date;
869: End If;
870: If (p_rec.category = hr_api.g_varchar2) then
871: p_rec.category :=
872: per_dis_shd.g_old_rec.category;
873: End If;
874: If (p_rec.status = hr_api.g_varchar2) then
875: p_rec.status :=
876: per_dis_shd.g_old_rec.status;
872: per_dis_shd.g_old_rec.category;
873: End If;
874: If (p_rec.status = hr_api.g_varchar2) then
875: p_rec.status :=
876: per_dis_shd.g_old_rec.status;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then
879: p_rec.description :=
880: per_dis_shd.g_old_rec.description;
876: per_dis_shd.g_old_rec.status;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then
879: p_rec.description :=
880: per_dis_shd.g_old_rec.description;
881: End If;
882: If (p_rec.degree = hr_api.g_number) then
883: p_rec.degree :=
884: per_dis_shd.g_old_rec.degree;
880: per_dis_shd.g_old_rec.description;
881: End If;
882: If (p_rec.degree = hr_api.g_number) then
883: p_rec.degree :=
884: per_dis_shd.g_old_rec.degree;
885: End If;
886: If (p_rec.quota_fte = hr_api.g_number) then
887: p_rec.quota_fte :=
888: per_dis_shd.g_old_rec.quota_fte;
884: per_dis_shd.g_old_rec.degree;
885: End If;
886: If (p_rec.quota_fte = hr_api.g_number) then
887: p_rec.quota_fte :=
888: per_dis_shd.g_old_rec.quota_fte;
889: End If;
890: If (p_rec.reason = hr_api.g_varchar2) then
891: p_rec.reason :=
892: per_dis_shd.g_old_rec.reason;
888: per_dis_shd.g_old_rec.quota_fte;
889: End If;
890: If (p_rec.reason = hr_api.g_varchar2) then
891: p_rec.reason :=
892: per_dis_shd.g_old_rec.reason;
893: End If;
894: If (p_rec.pre_registration_job = hr_api.g_varchar2) then
895: p_rec.pre_registration_job :=
896: per_dis_shd.g_old_rec.pre_registration_job;
892: per_dis_shd.g_old_rec.reason;
893: End If;
894: If (p_rec.pre_registration_job = hr_api.g_varchar2) then
895: p_rec.pre_registration_job :=
896: per_dis_shd.g_old_rec.pre_registration_job;
897: End If;
898: If (p_rec.work_restriction = hr_api.g_varchar2) then
899: p_rec.work_restriction :=
900: per_dis_shd.g_old_rec.work_restriction;
896: per_dis_shd.g_old_rec.pre_registration_job;
897: End If;
898: If (p_rec.work_restriction = hr_api.g_varchar2) then
899: p_rec.work_restriction :=
900: per_dis_shd.g_old_rec.work_restriction;
901: End If;
902: If (p_rec.attribute_category = hr_api.g_varchar2) then
903: p_rec.attribute_category :=
904: per_dis_shd.g_old_rec.attribute_category;
900: per_dis_shd.g_old_rec.work_restriction;
901: End If;
902: If (p_rec.attribute_category = hr_api.g_varchar2) then
903: p_rec.attribute_category :=
904: per_dis_shd.g_old_rec.attribute_category;
905: End If;
906: If (p_rec.attribute1 = hr_api.g_varchar2) then
907: p_rec.attribute1 :=
908: per_dis_shd.g_old_rec.attribute1;
904: per_dis_shd.g_old_rec.attribute_category;
905: End If;
906: If (p_rec.attribute1 = hr_api.g_varchar2) then
907: p_rec.attribute1 :=
908: per_dis_shd.g_old_rec.attribute1;
909: End If;
910: If (p_rec.attribute2 = hr_api.g_varchar2) then
911: p_rec.attribute2 :=
912: per_dis_shd.g_old_rec.attribute2;
908: per_dis_shd.g_old_rec.attribute1;
909: End If;
910: If (p_rec.attribute2 = hr_api.g_varchar2) then
911: p_rec.attribute2 :=
912: per_dis_shd.g_old_rec.attribute2;
913: End If;
914: If (p_rec.attribute3 = hr_api.g_varchar2) then
915: p_rec.attribute3 :=
916: per_dis_shd.g_old_rec.attribute3;
912: per_dis_shd.g_old_rec.attribute2;
913: End If;
914: If (p_rec.attribute3 = hr_api.g_varchar2) then
915: p_rec.attribute3 :=
916: per_dis_shd.g_old_rec.attribute3;
917: End If;
918: If (p_rec.attribute4 = hr_api.g_varchar2) then
919: p_rec.attribute4 :=
920: per_dis_shd.g_old_rec.attribute4;
916: per_dis_shd.g_old_rec.attribute3;
917: End If;
918: If (p_rec.attribute4 = hr_api.g_varchar2) then
919: p_rec.attribute4 :=
920: per_dis_shd.g_old_rec.attribute4;
921: End If;
922: If (p_rec.attribute5 = hr_api.g_varchar2) then
923: p_rec.attribute5 :=
924: per_dis_shd.g_old_rec.attribute5;
920: per_dis_shd.g_old_rec.attribute4;
921: End If;
922: If (p_rec.attribute5 = hr_api.g_varchar2) then
923: p_rec.attribute5 :=
924: per_dis_shd.g_old_rec.attribute5;
925: End If;
926: If (p_rec.attribute6 = hr_api.g_varchar2) then
927: p_rec.attribute6 :=
928: per_dis_shd.g_old_rec.attribute6;
924: per_dis_shd.g_old_rec.attribute5;
925: End If;
926: If (p_rec.attribute6 = hr_api.g_varchar2) then
927: p_rec.attribute6 :=
928: per_dis_shd.g_old_rec.attribute6;
929: End If;
930: If (p_rec.attribute7 = hr_api.g_varchar2) then
931: p_rec.attribute7 :=
932: per_dis_shd.g_old_rec.attribute7;
928: per_dis_shd.g_old_rec.attribute6;
929: End If;
930: If (p_rec.attribute7 = hr_api.g_varchar2) then
931: p_rec.attribute7 :=
932: per_dis_shd.g_old_rec.attribute7;
933: End If;
934: If (p_rec.attribute8 = hr_api.g_varchar2) then
935: p_rec.attribute8 :=
936: per_dis_shd.g_old_rec.attribute8;
932: per_dis_shd.g_old_rec.attribute7;
933: End If;
934: If (p_rec.attribute8 = hr_api.g_varchar2) then
935: p_rec.attribute8 :=
936: per_dis_shd.g_old_rec.attribute8;
937: End If;
938: If (p_rec.attribute9 = hr_api.g_varchar2) then
939: p_rec.attribute9 :=
940: per_dis_shd.g_old_rec.attribute9;
936: per_dis_shd.g_old_rec.attribute8;
937: End If;
938: If (p_rec.attribute9 = hr_api.g_varchar2) then
939: p_rec.attribute9 :=
940: per_dis_shd.g_old_rec.attribute9;
941: End If;
942: If (p_rec.attribute10 = hr_api.g_varchar2) then
943: p_rec.attribute10 :=
944: per_dis_shd.g_old_rec.attribute10;
940: per_dis_shd.g_old_rec.attribute9;
941: End If;
942: If (p_rec.attribute10 = hr_api.g_varchar2) then
943: p_rec.attribute10 :=
944: per_dis_shd.g_old_rec.attribute10;
945: End If;
946: If (p_rec.attribute11 = hr_api.g_varchar2) then
947: p_rec.attribute11 :=
948: per_dis_shd.g_old_rec.attribute11;
944: per_dis_shd.g_old_rec.attribute10;
945: End If;
946: If (p_rec.attribute11 = hr_api.g_varchar2) then
947: p_rec.attribute11 :=
948: per_dis_shd.g_old_rec.attribute11;
949: End If;
950: If (p_rec.attribute12 = hr_api.g_varchar2) then
951: p_rec.attribute12 :=
952: per_dis_shd.g_old_rec.attribute12;
948: per_dis_shd.g_old_rec.attribute11;
949: End If;
950: If (p_rec.attribute12 = hr_api.g_varchar2) then
951: p_rec.attribute12 :=
952: per_dis_shd.g_old_rec.attribute12;
953: End If;
954: If (p_rec.attribute13 = hr_api.g_varchar2) then
955: p_rec.attribute13 :=
956: per_dis_shd.g_old_rec.attribute13;
952: per_dis_shd.g_old_rec.attribute12;
953: End If;
954: If (p_rec.attribute13 = hr_api.g_varchar2) then
955: p_rec.attribute13 :=
956: per_dis_shd.g_old_rec.attribute13;
957: End If;
958: If (p_rec.attribute14 = hr_api.g_varchar2) then
959: p_rec.attribute14 :=
960: per_dis_shd.g_old_rec.attribute14;
956: per_dis_shd.g_old_rec.attribute13;
957: End If;
958: If (p_rec.attribute14 = hr_api.g_varchar2) then
959: p_rec.attribute14 :=
960: per_dis_shd.g_old_rec.attribute14;
961: End If;
962: If (p_rec.attribute15 = hr_api.g_varchar2) then
963: p_rec.attribute15 :=
964: per_dis_shd.g_old_rec.attribute15;
960: per_dis_shd.g_old_rec.attribute14;
961: End If;
962: If (p_rec.attribute15 = hr_api.g_varchar2) then
963: p_rec.attribute15 :=
964: per_dis_shd.g_old_rec.attribute15;
965: End If;
966: If (p_rec.attribute16 = hr_api.g_varchar2) then
967: p_rec.attribute16 :=
968: per_dis_shd.g_old_rec.attribute16;
964: per_dis_shd.g_old_rec.attribute15;
965: End If;
966: If (p_rec.attribute16 = hr_api.g_varchar2) then
967: p_rec.attribute16 :=
968: per_dis_shd.g_old_rec.attribute16;
969: End If;
970: If (p_rec.attribute17 = hr_api.g_varchar2) then
971: p_rec.attribute17 :=
972: per_dis_shd.g_old_rec.attribute17;
968: per_dis_shd.g_old_rec.attribute16;
969: End If;
970: If (p_rec.attribute17 = hr_api.g_varchar2) then
971: p_rec.attribute17 :=
972: per_dis_shd.g_old_rec.attribute17;
973: End If;
974: If (p_rec.attribute18 = hr_api.g_varchar2) then
975: p_rec.attribute18 :=
976: per_dis_shd.g_old_rec.attribute18;
972: per_dis_shd.g_old_rec.attribute17;
973: End If;
974: If (p_rec.attribute18 = hr_api.g_varchar2) then
975: p_rec.attribute18 :=
976: per_dis_shd.g_old_rec.attribute18;
977: End If;
978: If (p_rec.attribute19 = hr_api.g_varchar2) then
979: p_rec.attribute19 :=
980: per_dis_shd.g_old_rec.attribute19;
976: per_dis_shd.g_old_rec.attribute18;
977: End If;
978: If (p_rec.attribute19 = hr_api.g_varchar2) then
979: p_rec.attribute19 :=
980: per_dis_shd.g_old_rec.attribute19;
981: End If;
982: If (p_rec.attribute20 = hr_api.g_varchar2) then
983: p_rec.attribute20 :=
984: per_dis_shd.g_old_rec.attribute20;
980: per_dis_shd.g_old_rec.attribute19;
981: End If;
982: If (p_rec.attribute20 = hr_api.g_varchar2) then
983: p_rec.attribute20 :=
984: per_dis_shd.g_old_rec.attribute20;
985: End If;
986: If (p_rec.attribute21 = hr_api.g_varchar2) then
987: p_rec.attribute21 :=
988: per_dis_shd.g_old_rec.attribute21;
984: per_dis_shd.g_old_rec.attribute20;
985: End If;
986: If (p_rec.attribute21 = hr_api.g_varchar2) then
987: p_rec.attribute21 :=
988: per_dis_shd.g_old_rec.attribute21;
989: End If;
990: If (p_rec.attribute22 = hr_api.g_varchar2) then
991: p_rec.attribute22 :=
992: per_dis_shd.g_old_rec.attribute22;
988: per_dis_shd.g_old_rec.attribute21;
989: End If;
990: If (p_rec.attribute22 = hr_api.g_varchar2) then
991: p_rec.attribute22 :=
992: per_dis_shd.g_old_rec.attribute22;
993: End If;
994: If (p_rec.attribute23 = hr_api.g_varchar2) then
995: p_rec.attribute23 :=
996: per_dis_shd.g_old_rec.attribute23;
992: per_dis_shd.g_old_rec.attribute22;
993: End If;
994: If (p_rec.attribute23 = hr_api.g_varchar2) then
995: p_rec.attribute23 :=
996: per_dis_shd.g_old_rec.attribute23;
997: End If;
998: If (p_rec.attribute24 = hr_api.g_varchar2) then
999: p_rec.attribute24 :=
1000: per_dis_shd.g_old_rec.attribute24;
996: per_dis_shd.g_old_rec.attribute23;
997: End If;
998: If (p_rec.attribute24 = hr_api.g_varchar2) then
999: p_rec.attribute24 :=
1000: per_dis_shd.g_old_rec.attribute24;
1001: End If;
1002: If (p_rec.attribute25 = hr_api.g_varchar2) then
1003: p_rec.attribute25 :=
1004: per_dis_shd.g_old_rec.attribute25;
1000: per_dis_shd.g_old_rec.attribute24;
1001: End If;
1002: If (p_rec.attribute25 = hr_api.g_varchar2) then
1003: p_rec.attribute25 :=
1004: per_dis_shd.g_old_rec.attribute25;
1005: End If;
1006: If (p_rec.attribute26 = hr_api.g_varchar2) then
1007: p_rec.attribute26 :=
1008: per_dis_shd.g_old_rec.attribute26;
1004: per_dis_shd.g_old_rec.attribute25;
1005: End If;
1006: If (p_rec.attribute26 = hr_api.g_varchar2) then
1007: p_rec.attribute26 :=
1008: per_dis_shd.g_old_rec.attribute26;
1009: End If;
1010: If (p_rec.attribute27 = hr_api.g_varchar2) then
1011: p_rec.attribute27 :=
1012: per_dis_shd.g_old_rec.attribute27;
1008: per_dis_shd.g_old_rec.attribute26;
1009: End If;
1010: If (p_rec.attribute27 = hr_api.g_varchar2) then
1011: p_rec.attribute27 :=
1012: per_dis_shd.g_old_rec.attribute27;
1013: End If;
1014: If (p_rec.attribute28 = hr_api.g_varchar2) then
1015: p_rec.attribute28 :=
1016: per_dis_shd.g_old_rec.attribute28;
1012: per_dis_shd.g_old_rec.attribute27;
1013: End If;
1014: If (p_rec.attribute28 = hr_api.g_varchar2) then
1015: p_rec.attribute28 :=
1016: per_dis_shd.g_old_rec.attribute28;
1017: End If;
1018: If (p_rec.attribute29 = hr_api.g_varchar2) then
1019: p_rec.attribute29 :=
1020: per_dis_shd.g_old_rec.attribute29;
1016: per_dis_shd.g_old_rec.attribute28;
1017: End If;
1018: If (p_rec.attribute29 = hr_api.g_varchar2) then
1019: p_rec.attribute29 :=
1020: per_dis_shd.g_old_rec.attribute29;
1021: End If;
1022: If (p_rec.attribute30 = hr_api.g_varchar2) then
1023: p_rec.attribute30 :=
1024: per_dis_shd.g_old_rec.attribute30;
1020: per_dis_shd.g_old_rec.attribute29;
1021: End If;
1022: If (p_rec.attribute30 = hr_api.g_varchar2) then
1023: p_rec.attribute30 :=
1024: per_dis_shd.g_old_rec.attribute30;
1025: End If;
1026: If (p_rec.dis_information_category = hr_api.g_varchar2) then
1027: p_rec.dis_information_category :=
1028: per_dis_shd.g_old_rec.dis_information_category;
1024: per_dis_shd.g_old_rec.attribute30;
1025: End If;
1026: If (p_rec.dis_information_category = hr_api.g_varchar2) then
1027: p_rec.dis_information_category :=
1028: per_dis_shd.g_old_rec.dis_information_category;
1029: End If;
1030: If (p_rec.dis_information1 = hr_api.g_varchar2) then
1031: p_rec.dis_information1 :=
1032: per_dis_shd.g_old_rec.dis_information1;
1028: per_dis_shd.g_old_rec.dis_information_category;
1029: End If;
1030: If (p_rec.dis_information1 = hr_api.g_varchar2) then
1031: p_rec.dis_information1 :=
1032: per_dis_shd.g_old_rec.dis_information1;
1033: End If;
1034: If (p_rec.dis_information2 = hr_api.g_varchar2) then
1035: p_rec.dis_information2 :=
1036: per_dis_shd.g_old_rec.dis_information2;
1032: per_dis_shd.g_old_rec.dis_information1;
1033: End If;
1034: If (p_rec.dis_information2 = hr_api.g_varchar2) then
1035: p_rec.dis_information2 :=
1036: per_dis_shd.g_old_rec.dis_information2;
1037: End If;
1038: If (p_rec.dis_information3 = hr_api.g_varchar2) then
1039: p_rec.dis_information3 :=
1040: per_dis_shd.g_old_rec.dis_information3;
1036: per_dis_shd.g_old_rec.dis_information2;
1037: End If;
1038: If (p_rec.dis_information3 = hr_api.g_varchar2) then
1039: p_rec.dis_information3 :=
1040: per_dis_shd.g_old_rec.dis_information3;
1041: End If;
1042: If (p_rec.dis_information4 = hr_api.g_varchar2) then
1043: p_rec.dis_information4 :=
1044: per_dis_shd.g_old_rec.dis_information4;
1040: per_dis_shd.g_old_rec.dis_information3;
1041: End If;
1042: If (p_rec.dis_information4 = hr_api.g_varchar2) then
1043: p_rec.dis_information4 :=
1044: per_dis_shd.g_old_rec.dis_information4;
1045: End If;
1046: If (p_rec.dis_information5 = hr_api.g_varchar2) then
1047: p_rec.dis_information5 :=
1048: per_dis_shd.g_old_rec.dis_information5;
1044: per_dis_shd.g_old_rec.dis_information4;
1045: End If;
1046: If (p_rec.dis_information5 = hr_api.g_varchar2) then
1047: p_rec.dis_information5 :=
1048: per_dis_shd.g_old_rec.dis_information5;
1049: End If;
1050: If (p_rec.dis_information6 = hr_api.g_varchar2) then
1051: p_rec.dis_information6 :=
1052: per_dis_shd.g_old_rec.dis_information6;
1048: per_dis_shd.g_old_rec.dis_information5;
1049: End If;
1050: If (p_rec.dis_information6 = hr_api.g_varchar2) then
1051: p_rec.dis_information6 :=
1052: per_dis_shd.g_old_rec.dis_information6;
1053: End If;
1054: If (p_rec.dis_information7 = hr_api.g_varchar2) then
1055: p_rec.dis_information7 :=
1056: per_dis_shd.g_old_rec.dis_information7;
1052: per_dis_shd.g_old_rec.dis_information6;
1053: End If;
1054: If (p_rec.dis_information7 = hr_api.g_varchar2) then
1055: p_rec.dis_information7 :=
1056: per_dis_shd.g_old_rec.dis_information7;
1057: End If;
1058: If (p_rec.dis_information8 = hr_api.g_varchar2) then
1059: p_rec.dis_information8 :=
1060: per_dis_shd.g_old_rec.dis_information8;
1056: per_dis_shd.g_old_rec.dis_information7;
1057: End If;
1058: If (p_rec.dis_information8 = hr_api.g_varchar2) then
1059: p_rec.dis_information8 :=
1060: per_dis_shd.g_old_rec.dis_information8;
1061: End If;
1062: If (p_rec.dis_information9 = hr_api.g_varchar2) then
1063: p_rec.dis_information9 :=
1064: per_dis_shd.g_old_rec.dis_information9;
1060: per_dis_shd.g_old_rec.dis_information8;
1061: End If;
1062: If (p_rec.dis_information9 = hr_api.g_varchar2) then
1063: p_rec.dis_information9 :=
1064: per_dis_shd.g_old_rec.dis_information9;
1065: End If;
1066: If (p_rec.dis_information10 = hr_api.g_varchar2) then
1067: p_rec.dis_information10 :=
1068: per_dis_shd.g_old_rec.dis_information10;
1064: per_dis_shd.g_old_rec.dis_information9;
1065: End If;
1066: If (p_rec.dis_information10 = hr_api.g_varchar2) then
1067: p_rec.dis_information10 :=
1068: per_dis_shd.g_old_rec.dis_information10;
1069: End If;
1070: If (p_rec.dis_information11 = hr_api.g_varchar2) then
1071: p_rec.dis_information11 :=
1072: per_dis_shd.g_old_rec.dis_information11;
1068: per_dis_shd.g_old_rec.dis_information10;
1069: End If;
1070: If (p_rec.dis_information11 = hr_api.g_varchar2) then
1071: p_rec.dis_information11 :=
1072: per_dis_shd.g_old_rec.dis_information11;
1073: End If;
1074: If (p_rec.dis_information12 = hr_api.g_varchar2) then
1075: p_rec.dis_information12 :=
1076: per_dis_shd.g_old_rec.dis_information12;
1072: per_dis_shd.g_old_rec.dis_information11;
1073: End If;
1074: If (p_rec.dis_information12 = hr_api.g_varchar2) then
1075: p_rec.dis_information12 :=
1076: per_dis_shd.g_old_rec.dis_information12;
1077: End If;
1078: If (p_rec.dis_information13 = hr_api.g_varchar2) then
1079: p_rec.dis_information13 :=
1080: per_dis_shd.g_old_rec.dis_information13;
1076: per_dis_shd.g_old_rec.dis_information12;
1077: End If;
1078: If (p_rec.dis_information13 = hr_api.g_varchar2) then
1079: p_rec.dis_information13 :=
1080: per_dis_shd.g_old_rec.dis_information13;
1081: End If;
1082: If (p_rec.dis_information14 = hr_api.g_varchar2) then
1083: p_rec.dis_information14 :=
1084: per_dis_shd.g_old_rec.dis_information14;
1080: per_dis_shd.g_old_rec.dis_information13;
1081: End If;
1082: If (p_rec.dis_information14 = hr_api.g_varchar2) then
1083: p_rec.dis_information14 :=
1084: per_dis_shd.g_old_rec.dis_information14;
1085: End If;
1086: If (p_rec.dis_information15 = hr_api.g_varchar2) then
1087: p_rec.dis_information15 :=
1088: per_dis_shd.g_old_rec.dis_information15;
1084: per_dis_shd.g_old_rec.dis_information14;
1085: End If;
1086: If (p_rec.dis_information15 = hr_api.g_varchar2) then
1087: p_rec.dis_information15 :=
1088: per_dis_shd.g_old_rec.dis_information15;
1089: End If;
1090: If (p_rec.dis_information16 = hr_api.g_varchar2) then
1091: p_rec.dis_information16 :=
1092: per_dis_shd.g_old_rec.dis_information16;
1088: per_dis_shd.g_old_rec.dis_information15;
1089: End If;
1090: If (p_rec.dis_information16 = hr_api.g_varchar2) then
1091: p_rec.dis_information16 :=
1092: per_dis_shd.g_old_rec.dis_information16;
1093: End If;
1094: If (p_rec.dis_information17 = hr_api.g_varchar2) then
1095: p_rec.dis_information17 :=
1096: per_dis_shd.g_old_rec.dis_information17;
1092: per_dis_shd.g_old_rec.dis_information16;
1093: End If;
1094: If (p_rec.dis_information17 = hr_api.g_varchar2) then
1095: p_rec.dis_information17 :=
1096: per_dis_shd.g_old_rec.dis_information17;
1097: End If;
1098: If (p_rec.dis_information18 = hr_api.g_varchar2) then
1099: p_rec.dis_information18 :=
1100: per_dis_shd.g_old_rec.dis_information18;
1096: per_dis_shd.g_old_rec.dis_information17;
1097: End If;
1098: If (p_rec.dis_information18 = hr_api.g_varchar2) then
1099: p_rec.dis_information18 :=
1100: per_dis_shd.g_old_rec.dis_information18;
1101: End If;
1102: If (p_rec.dis_information19 = hr_api.g_varchar2) then
1103: p_rec.dis_information19 :=
1104: per_dis_shd.g_old_rec.dis_information19;
1100: per_dis_shd.g_old_rec.dis_information18;
1101: End If;
1102: If (p_rec.dis_information19 = hr_api.g_varchar2) then
1103: p_rec.dis_information19 :=
1104: per_dis_shd.g_old_rec.dis_information19;
1105: End If;
1106: If (p_rec.dis_information20 = hr_api.g_varchar2) then
1107: p_rec.dis_information20 :=
1108: per_dis_shd.g_old_rec.dis_information20;
1104: per_dis_shd.g_old_rec.dis_information19;
1105: End If;
1106: If (p_rec.dis_information20 = hr_api.g_varchar2) then
1107: p_rec.dis_information20 :=
1108: per_dis_shd.g_old_rec.dis_information20;
1109: End If;
1110: If (p_rec.dis_information21 = hr_api.g_varchar2) then
1111: p_rec.dis_information21 :=
1112: per_dis_shd.g_old_rec.dis_information21;
1108: per_dis_shd.g_old_rec.dis_information20;
1109: End If;
1110: If (p_rec.dis_information21 = hr_api.g_varchar2) then
1111: p_rec.dis_information21 :=
1112: per_dis_shd.g_old_rec.dis_information21;
1113: End If;
1114: If (p_rec.dis_information22 = hr_api.g_varchar2) then
1115: p_rec.dis_information22 :=
1116: per_dis_shd.g_old_rec.dis_information22;
1112: per_dis_shd.g_old_rec.dis_information21;
1113: End If;
1114: If (p_rec.dis_information22 = hr_api.g_varchar2) then
1115: p_rec.dis_information22 :=
1116: per_dis_shd.g_old_rec.dis_information22;
1117: End If;
1118: If (p_rec.dis_information23 = hr_api.g_varchar2) then
1119: p_rec.dis_information23 :=
1120: per_dis_shd.g_old_rec.dis_information23;
1116: per_dis_shd.g_old_rec.dis_information22;
1117: End If;
1118: If (p_rec.dis_information23 = hr_api.g_varchar2) then
1119: p_rec.dis_information23 :=
1120: per_dis_shd.g_old_rec.dis_information23;
1121: End If;
1122: If (p_rec.dis_information24 = hr_api.g_varchar2) then
1123: p_rec.dis_information24 :=
1124: per_dis_shd.g_old_rec.dis_information24;
1120: per_dis_shd.g_old_rec.dis_information23;
1121: End If;
1122: If (p_rec.dis_information24 = hr_api.g_varchar2) then
1123: p_rec.dis_information24 :=
1124: per_dis_shd.g_old_rec.dis_information24;
1125: End If;
1126: If (p_rec.dis_information25 = hr_api.g_varchar2) then
1127: p_rec.dis_information25 :=
1128: per_dis_shd.g_old_rec.dis_information25;
1124: per_dis_shd.g_old_rec.dis_information24;
1125: End If;
1126: If (p_rec.dis_information25 = hr_api.g_varchar2) then
1127: p_rec.dis_information25 :=
1128: per_dis_shd.g_old_rec.dis_information25;
1129: End If;
1130: If (p_rec.dis_information26 = hr_api.g_varchar2) then
1131: p_rec.dis_information26 :=
1132: per_dis_shd.g_old_rec.dis_information26;
1128: per_dis_shd.g_old_rec.dis_information25;
1129: End If;
1130: If (p_rec.dis_information26 = hr_api.g_varchar2) then
1131: p_rec.dis_information26 :=
1132: per_dis_shd.g_old_rec.dis_information26;
1133: End If;
1134: If (p_rec.dis_information27 = hr_api.g_varchar2) then
1135: p_rec.dis_information27 :=
1136: per_dis_shd.g_old_rec.dis_information27;
1132: per_dis_shd.g_old_rec.dis_information26;
1133: End If;
1134: If (p_rec.dis_information27 = hr_api.g_varchar2) then
1135: p_rec.dis_information27 :=
1136: per_dis_shd.g_old_rec.dis_information27;
1137: End If;
1138: If (p_rec.dis_information28 = hr_api.g_varchar2) then
1139: p_rec.dis_information28 :=
1140: per_dis_shd.g_old_rec.dis_information28;
1136: per_dis_shd.g_old_rec.dis_information27;
1137: End If;
1138: If (p_rec.dis_information28 = hr_api.g_varchar2) then
1139: p_rec.dis_information28 :=
1140: per_dis_shd.g_old_rec.dis_information28;
1141: End If;
1142: If (p_rec.dis_information29 = hr_api.g_varchar2) then
1143: p_rec.dis_information29 :=
1144: per_dis_shd.g_old_rec.dis_information29;
1140: per_dis_shd.g_old_rec.dis_information28;
1141: End If;
1142: If (p_rec.dis_information29 = hr_api.g_varchar2) then
1143: p_rec.dis_information29 :=
1144: per_dis_shd.g_old_rec.dis_information29;
1145: End If;
1146: If (p_rec.dis_information30 = hr_api.g_varchar2) then
1147: p_rec.dis_information30 :=
1148: per_dis_shd.g_old_rec.dis_information30;
1144: per_dis_shd.g_old_rec.dis_information29;
1145: End If;
1146: If (p_rec.dis_information30 = hr_api.g_varchar2) then
1147: p_rec.dis_information30 :=
1148: per_dis_shd.g_old_rec.dis_information30;
1149: End If;
1150: --
1151: End convert_defs;
1152: --
1155: -- ----------------------------------------------------------------------------
1156: Procedure upd
1157: (p_effective_date in date
1158: ,p_datetrack_mode in varchar2
1159: ,p_rec in out nocopy per_dis_shd.g_rec_type
1160: ) is
1161: --
1162: l_proc varchar2(72) := g_package||'upd';
1163: l_validation_start_date date;
1171: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1172: --
1173: -- We must lock the row which we need to update.
1174: --
1175: per_dis_shd.lck
1176: (p_effective_date => p_effective_date
1177: ,p_datetrack_mode => p_datetrack_mode
1178: ,p_disability_id => p_rec.disability_id
1179: ,p_object_version_number => p_rec.object_version_number
1314: ,p_effective_start_date out nocopy date
1315: ,p_effective_end_date out nocopy date
1316: ) is
1317: --
1318: l_rec per_dis_shd.g_rec_type;
1319: l_proc varchar2(72) := g_package||'upd';
1320: --
1321: Begin
1322: hr_utility.set_location('Entering:'||l_proc, 5);
1324: -- Call conversion function to turn arguments into the
1325: -- l_rec structure.
1326: --
1327: l_rec :=
1328: per_dis_shd.convert_args
1329: (p_disability_id
1330: ,null
1331: ,null
1332: ,hr_api.g_number