54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_rei_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
79: ,p_base_key_column => 'contact_extra_info_id'
80: ,p_base_key_value => p_rec.contact_extra_info_id
81: );
82: --
83: per_rei_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the per_contact_extra_info_f Row
86: --
87: update per_contact_extra_info_f
149: where contact_extra_info_id = p_rec.contact_extra_info_id
150: and effective_start_date = p_validation_start_date
151: and effective_end_date = p_validation_end_date;
152: --
153: per_rei_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: -- Set the effective start and end dates
156: --
157: p_rec.effective_start_date := p_validation_start_date;
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: per_rei_shd.g_api_dml := false; -- Unset the api dml status
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: per_rei_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: per_rei_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
177: --
178: -- ----------------------------------------------------------------------------
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure update_dml
210: (p_rec in out nocopy per_rei_shd.g_rec_type
211: ,p_effective_date in date
212: ,p_datetrack_mode in varchar2
213: ,p_validation_start_date in date
214: ,p_validation_end_date in date
273: --
274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure dt_pre_update
277: (p_rec in out nocopy per_rei_shd.g_rec_type
278: ,p_effective_date in date
279: ,p_datetrack_mode in varchar2
280: ,p_validation_start_date in date
281: ,p_validation_end_date in date
289: If (p_datetrack_mode <> hr_api.g_correction) then
290: --
291: -- Update the current effective end date
292: --
293: per_rei_shd.upd_effective_end_date
294: (p_effective_date => p_effective_date
295: ,p_base_key_value => p_rec.contact_extra_info_id
296: ,p_new_effective_end_date => (p_validation_start_date - 1)
297: ,p_validation_start_date => p_validation_start_date
358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure pre_update
362: (p_rec in out nocopy per_rei_shd.g_rec_type
363: ,p_effective_date in date
364: ,p_datetrack_mode in varchar2
365: ,p_validation_start_date in date
366: ,p_validation_end_date in date
416: --
417: -- {End Of Comments}
418: -- ----------------------------------------------------------------------------
419: Procedure post_update
420: (p_rec in per_rei_shd.g_rec_type
421: ,p_effective_date in date
422: ,p_datetrack_mode in varchar2
423: ,p_validation_start_date in date
424: ,p_validation_end_date in date
563: => p_rec.program_id
564: ,p_program_update_date
565: => p_rec.program_update_date
566: ,p_effective_start_date_o
567: => per_rei_shd.g_old_rec.effective_start_date
568: ,p_effective_end_date_o
569: => per_rei_shd.g_old_rec.effective_end_date
570: ,p_contact_relationship_id_o
571: => per_rei_shd.g_old_rec.contact_relationship_id
565: => p_rec.program_update_date
566: ,p_effective_start_date_o
567: => per_rei_shd.g_old_rec.effective_start_date
568: ,p_effective_end_date_o
569: => per_rei_shd.g_old_rec.effective_end_date
570: ,p_contact_relationship_id_o
571: => per_rei_shd.g_old_rec.contact_relationship_id
572: ,p_information_type_o
573: => per_rei_shd.g_old_rec.information_type
567: => per_rei_shd.g_old_rec.effective_start_date
568: ,p_effective_end_date_o
569: => per_rei_shd.g_old_rec.effective_end_date
570: ,p_contact_relationship_id_o
571: => per_rei_shd.g_old_rec.contact_relationship_id
572: ,p_information_type_o
573: => per_rei_shd.g_old_rec.information_type
574: ,p_cei_information_category_o
575: => per_rei_shd.g_old_rec.cei_information_category
569: => per_rei_shd.g_old_rec.effective_end_date
570: ,p_contact_relationship_id_o
571: => per_rei_shd.g_old_rec.contact_relationship_id
572: ,p_information_type_o
573: => per_rei_shd.g_old_rec.information_type
574: ,p_cei_information_category_o
575: => per_rei_shd.g_old_rec.cei_information_category
576: ,p_cei_information1_o
577: => per_rei_shd.g_old_rec.cei_information1
571: => per_rei_shd.g_old_rec.contact_relationship_id
572: ,p_information_type_o
573: => per_rei_shd.g_old_rec.information_type
574: ,p_cei_information_category_o
575: => per_rei_shd.g_old_rec.cei_information_category
576: ,p_cei_information1_o
577: => per_rei_shd.g_old_rec.cei_information1
578: ,p_cei_information2_o
579: => per_rei_shd.g_old_rec.cei_information2
573: => per_rei_shd.g_old_rec.information_type
574: ,p_cei_information_category_o
575: => per_rei_shd.g_old_rec.cei_information_category
576: ,p_cei_information1_o
577: => per_rei_shd.g_old_rec.cei_information1
578: ,p_cei_information2_o
579: => per_rei_shd.g_old_rec.cei_information2
580: ,p_cei_information3_o
581: => per_rei_shd.g_old_rec.cei_information3
575: => per_rei_shd.g_old_rec.cei_information_category
576: ,p_cei_information1_o
577: => per_rei_shd.g_old_rec.cei_information1
578: ,p_cei_information2_o
579: => per_rei_shd.g_old_rec.cei_information2
580: ,p_cei_information3_o
581: => per_rei_shd.g_old_rec.cei_information3
582: ,p_cei_information4_o
583: => per_rei_shd.g_old_rec.cei_information4
577: => per_rei_shd.g_old_rec.cei_information1
578: ,p_cei_information2_o
579: => per_rei_shd.g_old_rec.cei_information2
580: ,p_cei_information3_o
581: => per_rei_shd.g_old_rec.cei_information3
582: ,p_cei_information4_o
583: => per_rei_shd.g_old_rec.cei_information4
584: ,p_cei_information5_o
585: => per_rei_shd.g_old_rec.cei_information5
579: => per_rei_shd.g_old_rec.cei_information2
580: ,p_cei_information3_o
581: => per_rei_shd.g_old_rec.cei_information3
582: ,p_cei_information4_o
583: => per_rei_shd.g_old_rec.cei_information4
584: ,p_cei_information5_o
585: => per_rei_shd.g_old_rec.cei_information5
586: ,p_cei_information6_o
587: => per_rei_shd.g_old_rec.cei_information6
581: => per_rei_shd.g_old_rec.cei_information3
582: ,p_cei_information4_o
583: => per_rei_shd.g_old_rec.cei_information4
584: ,p_cei_information5_o
585: => per_rei_shd.g_old_rec.cei_information5
586: ,p_cei_information6_o
587: => per_rei_shd.g_old_rec.cei_information6
588: ,p_cei_information7_o
589: => per_rei_shd.g_old_rec.cei_information7
583: => per_rei_shd.g_old_rec.cei_information4
584: ,p_cei_information5_o
585: => per_rei_shd.g_old_rec.cei_information5
586: ,p_cei_information6_o
587: => per_rei_shd.g_old_rec.cei_information6
588: ,p_cei_information7_o
589: => per_rei_shd.g_old_rec.cei_information7
590: ,p_cei_information8_o
591: => per_rei_shd.g_old_rec.cei_information8
585: => per_rei_shd.g_old_rec.cei_information5
586: ,p_cei_information6_o
587: => per_rei_shd.g_old_rec.cei_information6
588: ,p_cei_information7_o
589: => per_rei_shd.g_old_rec.cei_information7
590: ,p_cei_information8_o
591: => per_rei_shd.g_old_rec.cei_information8
592: ,p_cei_information9_o
593: => per_rei_shd.g_old_rec.cei_information9
587: => per_rei_shd.g_old_rec.cei_information6
588: ,p_cei_information7_o
589: => per_rei_shd.g_old_rec.cei_information7
590: ,p_cei_information8_o
591: => per_rei_shd.g_old_rec.cei_information8
592: ,p_cei_information9_o
593: => per_rei_shd.g_old_rec.cei_information9
594: ,p_cei_information10_o
595: => per_rei_shd.g_old_rec.cei_information10
589: => per_rei_shd.g_old_rec.cei_information7
590: ,p_cei_information8_o
591: => per_rei_shd.g_old_rec.cei_information8
592: ,p_cei_information9_o
593: => per_rei_shd.g_old_rec.cei_information9
594: ,p_cei_information10_o
595: => per_rei_shd.g_old_rec.cei_information10
596: ,p_cei_information11_o
597: => per_rei_shd.g_old_rec.cei_information11
591: => per_rei_shd.g_old_rec.cei_information8
592: ,p_cei_information9_o
593: => per_rei_shd.g_old_rec.cei_information9
594: ,p_cei_information10_o
595: => per_rei_shd.g_old_rec.cei_information10
596: ,p_cei_information11_o
597: => per_rei_shd.g_old_rec.cei_information11
598: ,p_cei_information12_o
599: => per_rei_shd.g_old_rec.cei_information12
593: => per_rei_shd.g_old_rec.cei_information9
594: ,p_cei_information10_o
595: => per_rei_shd.g_old_rec.cei_information10
596: ,p_cei_information11_o
597: => per_rei_shd.g_old_rec.cei_information11
598: ,p_cei_information12_o
599: => per_rei_shd.g_old_rec.cei_information12
600: ,p_cei_information13_o
601: => per_rei_shd.g_old_rec.cei_information13
595: => per_rei_shd.g_old_rec.cei_information10
596: ,p_cei_information11_o
597: => per_rei_shd.g_old_rec.cei_information11
598: ,p_cei_information12_o
599: => per_rei_shd.g_old_rec.cei_information12
600: ,p_cei_information13_o
601: => per_rei_shd.g_old_rec.cei_information13
602: ,p_cei_information14_o
603: => per_rei_shd.g_old_rec.cei_information14
597: => per_rei_shd.g_old_rec.cei_information11
598: ,p_cei_information12_o
599: => per_rei_shd.g_old_rec.cei_information12
600: ,p_cei_information13_o
601: => per_rei_shd.g_old_rec.cei_information13
602: ,p_cei_information14_o
603: => per_rei_shd.g_old_rec.cei_information14
604: ,p_cei_information15_o
605: => per_rei_shd.g_old_rec.cei_information15
599: => per_rei_shd.g_old_rec.cei_information12
600: ,p_cei_information13_o
601: => per_rei_shd.g_old_rec.cei_information13
602: ,p_cei_information14_o
603: => per_rei_shd.g_old_rec.cei_information14
604: ,p_cei_information15_o
605: => per_rei_shd.g_old_rec.cei_information15
606: ,p_cei_information16_o
607: => per_rei_shd.g_old_rec.cei_information16
601: => per_rei_shd.g_old_rec.cei_information13
602: ,p_cei_information14_o
603: => per_rei_shd.g_old_rec.cei_information14
604: ,p_cei_information15_o
605: => per_rei_shd.g_old_rec.cei_information15
606: ,p_cei_information16_o
607: => per_rei_shd.g_old_rec.cei_information16
608: ,p_cei_information17_o
609: => per_rei_shd.g_old_rec.cei_information17
603: => per_rei_shd.g_old_rec.cei_information14
604: ,p_cei_information15_o
605: => per_rei_shd.g_old_rec.cei_information15
606: ,p_cei_information16_o
607: => per_rei_shd.g_old_rec.cei_information16
608: ,p_cei_information17_o
609: => per_rei_shd.g_old_rec.cei_information17
610: ,p_cei_information18_o
611: => per_rei_shd.g_old_rec.cei_information18
605: => per_rei_shd.g_old_rec.cei_information15
606: ,p_cei_information16_o
607: => per_rei_shd.g_old_rec.cei_information16
608: ,p_cei_information17_o
609: => per_rei_shd.g_old_rec.cei_information17
610: ,p_cei_information18_o
611: => per_rei_shd.g_old_rec.cei_information18
612: ,p_cei_information19_o
613: => per_rei_shd.g_old_rec.cei_information19
607: => per_rei_shd.g_old_rec.cei_information16
608: ,p_cei_information17_o
609: => per_rei_shd.g_old_rec.cei_information17
610: ,p_cei_information18_o
611: => per_rei_shd.g_old_rec.cei_information18
612: ,p_cei_information19_o
613: => per_rei_shd.g_old_rec.cei_information19
614: ,p_cei_information20_o
615: => per_rei_shd.g_old_rec.cei_information20
609: => per_rei_shd.g_old_rec.cei_information17
610: ,p_cei_information18_o
611: => per_rei_shd.g_old_rec.cei_information18
612: ,p_cei_information19_o
613: => per_rei_shd.g_old_rec.cei_information19
614: ,p_cei_information20_o
615: => per_rei_shd.g_old_rec.cei_information20
616: ,p_cei_information21_o
617: => per_rei_shd.g_old_rec.cei_information21
611: => per_rei_shd.g_old_rec.cei_information18
612: ,p_cei_information19_o
613: => per_rei_shd.g_old_rec.cei_information19
614: ,p_cei_information20_o
615: => per_rei_shd.g_old_rec.cei_information20
616: ,p_cei_information21_o
617: => per_rei_shd.g_old_rec.cei_information21
618: ,p_cei_information22_o
619: => per_rei_shd.g_old_rec.cei_information22
613: => per_rei_shd.g_old_rec.cei_information19
614: ,p_cei_information20_o
615: => per_rei_shd.g_old_rec.cei_information20
616: ,p_cei_information21_o
617: => per_rei_shd.g_old_rec.cei_information21
618: ,p_cei_information22_o
619: => per_rei_shd.g_old_rec.cei_information22
620: ,p_cei_information23_o
621: => per_rei_shd.g_old_rec.cei_information23
615: => per_rei_shd.g_old_rec.cei_information20
616: ,p_cei_information21_o
617: => per_rei_shd.g_old_rec.cei_information21
618: ,p_cei_information22_o
619: => per_rei_shd.g_old_rec.cei_information22
620: ,p_cei_information23_o
621: => per_rei_shd.g_old_rec.cei_information23
622: ,p_cei_information24_o
623: => per_rei_shd.g_old_rec.cei_information24
617: => per_rei_shd.g_old_rec.cei_information21
618: ,p_cei_information22_o
619: => per_rei_shd.g_old_rec.cei_information22
620: ,p_cei_information23_o
621: => per_rei_shd.g_old_rec.cei_information23
622: ,p_cei_information24_o
623: => per_rei_shd.g_old_rec.cei_information24
624: ,p_cei_information25_o
625: => per_rei_shd.g_old_rec.cei_information25
619: => per_rei_shd.g_old_rec.cei_information22
620: ,p_cei_information23_o
621: => per_rei_shd.g_old_rec.cei_information23
622: ,p_cei_information24_o
623: => per_rei_shd.g_old_rec.cei_information24
624: ,p_cei_information25_o
625: => per_rei_shd.g_old_rec.cei_information25
626: ,p_cei_information26_o
627: => per_rei_shd.g_old_rec.cei_information26
621: => per_rei_shd.g_old_rec.cei_information23
622: ,p_cei_information24_o
623: => per_rei_shd.g_old_rec.cei_information24
624: ,p_cei_information25_o
625: => per_rei_shd.g_old_rec.cei_information25
626: ,p_cei_information26_o
627: => per_rei_shd.g_old_rec.cei_information26
628: ,p_cei_information27_o
629: => per_rei_shd.g_old_rec.cei_information27
623: => per_rei_shd.g_old_rec.cei_information24
624: ,p_cei_information25_o
625: => per_rei_shd.g_old_rec.cei_information25
626: ,p_cei_information26_o
627: => per_rei_shd.g_old_rec.cei_information26
628: ,p_cei_information27_o
629: => per_rei_shd.g_old_rec.cei_information27
630: ,p_cei_information28_o
631: => per_rei_shd.g_old_rec.cei_information28
625: => per_rei_shd.g_old_rec.cei_information25
626: ,p_cei_information26_o
627: => per_rei_shd.g_old_rec.cei_information26
628: ,p_cei_information27_o
629: => per_rei_shd.g_old_rec.cei_information27
630: ,p_cei_information28_o
631: => per_rei_shd.g_old_rec.cei_information28
632: ,p_cei_information29_o
633: => per_rei_shd.g_old_rec.cei_information29
627: => per_rei_shd.g_old_rec.cei_information26
628: ,p_cei_information27_o
629: => per_rei_shd.g_old_rec.cei_information27
630: ,p_cei_information28_o
631: => per_rei_shd.g_old_rec.cei_information28
632: ,p_cei_information29_o
633: => per_rei_shd.g_old_rec.cei_information29
634: ,p_cei_information30_o
635: => per_rei_shd.g_old_rec.cei_information30
629: => per_rei_shd.g_old_rec.cei_information27
630: ,p_cei_information28_o
631: => per_rei_shd.g_old_rec.cei_information28
632: ,p_cei_information29_o
633: => per_rei_shd.g_old_rec.cei_information29
634: ,p_cei_information30_o
635: => per_rei_shd.g_old_rec.cei_information30
636: ,p_cei_attribute_category_o
637: => per_rei_shd.g_old_rec.cei_attribute_category
631: => per_rei_shd.g_old_rec.cei_information28
632: ,p_cei_information29_o
633: => per_rei_shd.g_old_rec.cei_information29
634: ,p_cei_information30_o
635: => per_rei_shd.g_old_rec.cei_information30
636: ,p_cei_attribute_category_o
637: => per_rei_shd.g_old_rec.cei_attribute_category
638: ,p_cei_attribute1_o
639: => per_rei_shd.g_old_rec.cei_attribute1
633: => per_rei_shd.g_old_rec.cei_information29
634: ,p_cei_information30_o
635: => per_rei_shd.g_old_rec.cei_information30
636: ,p_cei_attribute_category_o
637: => per_rei_shd.g_old_rec.cei_attribute_category
638: ,p_cei_attribute1_o
639: => per_rei_shd.g_old_rec.cei_attribute1
640: ,p_cei_attribute2_o
641: => per_rei_shd.g_old_rec.cei_attribute2
635: => per_rei_shd.g_old_rec.cei_information30
636: ,p_cei_attribute_category_o
637: => per_rei_shd.g_old_rec.cei_attribute_category
638: ,p_cei_attribute1_o
639: => per_rei_shd.g_old_rec.cei_attribute1
640: ,p_cei_attribute2_o
641: => per_rei_shd.g_old_rec.cei_attribute2
642: ,p_cei_attribute3_o
643: => per_rei_shd.g_old_rec.cei_attribute3
637: => per_rei_shd.g_old_rec.cei_attribute_category
638: ,p_cei_attribute1_o
639: => per_rei_shd.g_old_rec.cei_attribute1
640: ,p_cei_attribute2_o
641: => per_rei_shd.g_old_rec.cei_attribute2
642: ,p_cei_attribute3_o
643: => per_rei_shd.g_old_rec.cei_attribute3
644: ,p_cei_attribute4_o
645: => per_rei_shd.g_old_rec.cei_attribute4
639: => per_rei_shd.g_old_rec.cei_attribute1
640: ,p_cei_attribute2_o
641: => per_rei_shd.g_old_rec.cei_attribute2
642: ,p_cei_attribute3_o
643: => per_rei_shd.g_old_rec.cei_attribute3
644: ,p_cei_attribute4_o
645: => per_rei_shd.g_old_rec.cei_attribute4
646: ,p_cei_attribute5_o
647: => per_rei_shd.g_old_rec.cei_attribute5
641: => per_rei_shd.g_old_rec.cei_attribute2
642: ,p_cei_attribute3_o
643: => per_rei_shd.g_old_rec.cei_attribute3
644: ,p_cei_attribute4_o
645: => per_rei_shd.g_old_rec.cei_attribute4
646: ,p_cei_attribute5_o
647: => per_rei_shd.g_old_rec.cei_attribute5
648: ,p_cei_attribute6_o
649: => per_rei_shd.g_old_rec.cei_attribute6
643: => per_rei_shd.g_old_rec.cei_attribute3
644: ,p_cei_attribute4_o
645: => per_rei_shd.g_old_rec.cei_attribute4
646: ,p_cei_attribute5_o
647: => per_rei_shd.g_old_rec.cei_attribute5
648: ,p_cei_attribute6_o
649: => per_rei_shd.g_old_rec.cei_attribute6
650: ,p_cei_attribute7_o
651: => per_rei_shd.g_old_rec.cei_attribute7
645: => per_rei_shd.g_old_rec.cei_attribute4
646: ,p_cei_attribute5_o
647: => per_rei_shd.g_old_rec.cei_attribute5
648: ,p_cei_attribute6_o
649: => per_rei_shd.g_old_rec.cei_attribute6
650: ,p_cei_attribute7_o
651: => per_rei_shd.g_old_rec.cei_attribute7
652: ,p_cei_attribute8_o
653: => per_rei_shd.g_old_rec.cei_attribute8
647: => per_rei_shd.g_old_rec.cei_attribute5
648: ,p_cei_attribute6_o
649: => per_rei_shd.g_old_rec.cei_attribute6
650: ,p_cei_attribute7_o
651: => per_rei_shd.g_old_rec.cei_attribute7
652: ,p_cei_attribute8_o
653: => per_rei_shd.g_old_rec.cei_attribute8
654: ,p_cei_attribute9_o
655: => per_rei_shd.g_old_rec.cei_attribute9
649: => per_rei_shd.g_old_rec.cei_attribute6
650: ,p_cei_attribute7_o
651: => per_rei_shd.g_old_rec.cei_attribute7
652: ,p_cei_attribute8_o
653: => per_rei_shd.g_old_rec.cei_attribute8
654: ,p_cei_attribute9_o
655: => per_rei_shd.g_old_rec.cei_attribute9
656: ,p_cei_attribute10_o
657: => per_rei_shd.g_old_rec.cei_attribute10
651: => per_rei_shd.g_old_rec.cei_attribute7
652: ,p_cei_attribute8_o
653: => per_rei_shd.g_old_rec.cei_attribute8
654: ,p_cei_attribute9_o
655: => per_rei_shd.g_old_rec.cei_attribute9
656: ,p_cei_attribute10_o
657: => per_rei_shd.g_old_rec.cei_attribute10
658: ,p_cei_attribute11_o
659: => per_rei_shd.g_old_rec.cei_attribute11
653: => per_rei_shd.g_old_rec.cei_attribute8
654: ,p_cei_attribute9_o
655: => per_rei_shd.g_old_rec.cei_attribute9
656: ,p_cei_attribute10_o
657: => per_rei_shd.g_old_rec.cei_attribute10
658: ,p_cei_attribute11_o
659: => per_rei_shd.g_old_rec.cei_attribute11
660: ,p_cei_attribute12_o
661: => per_rei_shd.g_old_rec.cei_attribute12
655: => per_rei_shd.g_old_rec.cei_attribute9
656: ,p_cei_attribute10_o
657: => per_rei_shd.g_old_rec.cei_attribute10
658: ,p_cei_attribute11_o
659: => per_rei_shd.g_old_rec.cei_attribute11
660: ,p_cei_attribute12_o
661: => per_rei_shd.g_old_rec.cei_attribute12
662: ,p_cei_attribute13_o
663: => per_rei_shd.g_old_rec.cei_attribute13
657: => per_rei_shd.g_old_rec.cei_attribute10
658: ,p_cei_attribute11_o
659: => per_rei_shd.g_old_rec.cei_attribute11
660: ,p_cei_attribute12_o
661: => per_rei_shd.g_old_rec.cei_attribute12
662: ,p_cei_attribute13_o
663: => per_rei_shd.g_old_rec.cei_attribute13
664: ,p_cei_attribute14_o
665: => per_rei_shd.g_old_rec.cei_attribute14
659: => per_rei_shd.g_old_rec.cei_attribute11
660: ,p_cei_attribute12_o
661: => per_rei_shd.g_old_rec.cei_attribute12
662: ,p_cei_attribute13_o
663: => per_rei_shd.g_old_rec.cei_attribute13
664: ,p_cei_attribute14_o
665: => per_rei_shd.g_old_rec.cei_attribute14
666: ,p_cei_attribute15_o
667: => per_rei_shd.g_old_rec.cei_attribute15
661: => per_rei_shd.g_old_rec.cei_attribute12
662: ,p_cei_attribute13_o
663: => per_rei_shd.g_old_rec.cei_attribute13
664: ,p_cei_attribute14_o
665: => per_rei_shd.g_old_rec.cei_attribute14
666: ,p_cei_attribute15_o
667: => per_rei_shd.g_old_rec.cei_attribute15
668: ,p_cei_attribute16_o
669: => per_rei_shd.g_old_rec.cei_attribute16
663: => per_rei_shd.g_old_rec.cei_attribute13
664: ,p_cei_attribute14_o
665: => per_rei_shd.g_old_rec.cei_attribute14
666: ,p_cei_attribute15_o
667: => per_rei_shd.g_old_rec.cei_attribute15
668: ,p_cei_attribute16_o
669: => per_rei_shd.g_old_rec.cei_attribute16
670: ,p_cei_attribute17_o
671: => per_rei_shd.g_old_rec.cei_attribute17
665: => per_rei_shd.g_old_rec.cei_attribute14
666: ,p_cei_attribute15_o
667: => per_rei_shd.g_old_rec.cei_attribute15
668: ,p_cei_attribute16_o
669: => per_rei_shd.g_old_rec.cei_attribute16
670: ,p_cei_attribute17_o
671: => per_rei_shd.g_old_rec.cei_attribute17
672: ,p_cei_attribute18_o
673: => per_rei_shd.g_old_rec.cei_attribute18
667: => per_rei_shd.g_old_rec.cei_attribute15
668: ,p_cei_attribute16_o
669: => per_rei_shd.g_old_rec.cei_attribute16
670: ,p_cei_attribute17_o
671: => per_rei_shd.g_old_rec.cei_attribute17
672: ,p_cei_attribute18_o
673: => per_rei_shd.g_old_rec.cei_attribute18
674: ,p_cei_attribute19_o
675: => per_rei_shd.g_old_rec.cei_attribute19
669: => per_rei_shd.g_old_rec.cei_attribute16
670: ,p_cei_attribute17_o
671: => per_rei_shd.g_old_rec.cei_attribute17
672: ,p_cei_attribute18_o
673: => per_rei_shd.g_old_rec.cei_attribute18
674: ,p_cei_attribute19_o
675: => per_rei_shd.g_old_rec.cei_attribute19
676: ,p_cei_attribute20_o
677: => per_rei_shd.g_old_rec.cei_attribute20
671: => per_rei_shd.g_old_rec.cei_attribute17
672: ,p_cei_attribute18_o
673: => per_rei_shd.g_old_rec.cei_attribute18
674: ,p_cei_attribute19_o
675: => per_rei_shd.g_old_rec.cei_attribute19
676: ,p_cei_attribute20_o
677: => per_rei_shd.g_old_rec.cei_attribute20
678: ,p_object_version_number_o
679: => per_rei_shd.g_old_rec.object_version_number
673: => per_rei_shd.g_old_rec.cei_attribute18
674: ,p_cei_attribute19_o
675: => per_rei_shd.g_old_rec.cei_attribute19
676: ,p_cei_attribute20_o
677: => per_rei_shd.g_old_rec.cei_attribute20
678: ,p_object_version_number_o
679: => per_rei_shd.g_old_rec.object_version_number
680: ,p_request_id_o
681: => per_rei_shd.g_old_rec.request_id
675: => per_rei_shd.g_old_rec.cei_attribute19
676: ,p_cei_attribute20_o
677: => per_rei_shd.g_old_rec.cei_attribute20
678: ,p_object_version_number_o
679: => per_rei_shd.g_old_rec.object_version_number
680: ,p_request_id_o
681: => per_rei_shd.g_old_rec.request_id
682: ,p_program_application_id_o
683: => per_rei_shd.g_old_rec.program_application_id
677: => per_rei_shd.g_old_rec.cei_attribute20
678: ,p_object_version_number_o
679: => per_rei_shd.g_old_rec.object_version_number
680: ,p_request_id_o
681: => per_rei_shd.g_old_rec.request_id
682: ,p_program_application_id_o
683: => per_rei_shd.g_old_rec.program_application_id
684: ,p_program_id_o
685: => per_rei_shd.g_old_rec.program_id
679: => per_rei_shd.g_old_rec.object_version_number
680: ,p_request_id_o
681: => per_rei_shd.g_old_rec.request_id
682: ,p_program_application_id_o
683: => per_rei_shd.g_old_rec.program_application_id
684: ,p_program_id_o
685: => per_rei_shd.g_old_rec.program_id
686: ,p_program_update_date_o
687: => per_rei_shd.g_old_rec.program_update_date
681: => per_rei_shd.g_old_rec.request_id
682: ,p_program_application_id_o
683: => per_rei_shd.g_old_rec.program_application_id
684: ,p_program_id_o
685: => per_rei_shd.g_old_rec.program_id
686: ,p_program_update_date_o
687: => per_rei_shd.g_old_rec.program_update_date
688: );
689: --
683: => per_rei_shd.g_old_rec.program_application_id
684: ,p_program_id_o
685: => per_rei_shd.g_old_rec.program_id
686: ,p_program_update_date_o
687: => per_rei_shd.g_old_rec.program_update_date
688: );
689: --
690: exception
691: --
743: --
744: -- {End Of Comments}
745: -- ----------------------------------------------------------------------------
746: Procedure convert_defs
747: (p_rec in out nocopy per_rei_shd.g_rec_type
748: ) is
749: --
750: Begin
751: --
755: -- is being used then we must set to the 'current' argument value.
756: --
757: If (p_rec.contact_relationship_id = hr_api.g_number) then
758: p_rec.contact_relationship_id :=
759: per_rei_shd.g_old_rec.contact_relationship_id;
760: End If;
761: If (p_rec.information_type = hr_api.g_varchar2) then
762: p_rec.information_type :=
763: per_rei_shd.g_old_rec.information_type;
759: per_rei_shd.g_old_rec.contact_relationship_id;
760: End If;
761: If (p_rec.information_type = hr_api.g_varchar2) then
762: p_rec.information_type :=
763: per_rei_shd.g_old_rec.information_type;
764: End If;
765: If (p_rec.cei_information_category = hr_api.g_varchar2) then
766: p_rec.cei_information_category :=
767: per_rei_shd.g_old_rec.cei_information_category;
763: per_rei_shd.g_old_rec.information_type;
764: End If;
765: If (p_rec.cei_information_category = hr_api.g_varchar2) then
766: p_rec.cei_information_category :=
767: per_rei_shd.g_old_rec.cei_information_category;
768: End If;
769: If (p_rec.cei_information1 = hr_api.g_varchar2) then
770: p_rec.cei_information1 :=
771: per_rei_shd.g_old_rec.cei_information1;
767: per_rei_shd.g_old_rec.cei_information_category;
768: End If;
769: If (p_rec.cei_information1 = hr_api.g_varchar2) then
770: p_rec.cei_information1 :=
771: per_rei_shd.g_old_rec.cei_information1;
772: End If;
773: If (p_rec.cei_information2 = hr_api.g_varchar2) then
774: p_rec.cei_information2 :=
775: per_rei_shd.g_old_rec.cei_information2;
771: per_rei_shd.g_old_rec.cei_information1;
772: End If;
773: If (p_rec.cei_information2 = hr_api.g_varchar2) then
774: p_rec.cei_information2 :=
775: per_rei_shd.g_old_rec.cei_information2;
776: End If;
777: If (p_rec.cei_information3 = hr_api.g_varchar2) then
778: p_rec.cei_information3 :=
779: per_rei_shd.g_old_rec.cei_information3;
775: per_rei_shd.g_old_rec.cei_information2;
776: End If;
777: If (p_rec.cei_information3 = hr_api.g_varchar2) then
778: p_rec.cei_information3 :=
779: per_rei_shd.g_old_rec.cei_information3;
780: End If;
781: If (p_rec.cei_information4 = hr_api.g_varchar2) then
782: p_rec.cei_information4 :=
783: per_rei_shd.g_old_rec.cei_information4;
779: per_rei_shd.g_old_rec.cei_information3;
780: End If;
781: If (p_rec.cei_information4 = hr_api.g_varchar2) then
782: p_rec.cei_information4 :=
783: per_rei_shd.g_old_rec.cei_information4;
784: End If;
785: If (p_rec.cei_information5 = hr_api.g_varchar2) then
786: p_rec.cei_information5 :=
787: per_rei_shd.g_old_rec.cei_information5;
783: per_rei_shd.g_old_rec.cei_information4;
784: End If;
785: If (p_rec.cei_information5 = hr_api.g_varchar2) then
786: p_rec.cei_information5 :=
787: per_rei_shd.g_old_rec.cei_information5;
788: End If;
789: If (p_rec.cei_information6 = hr_api.g_varchar2) then
790: p_rec.cei_information6 :=
791: per_rei_shd.g_old_rec.cei_information6;
787: per_rei_shd.g_old_rec.cei_information5;
788: End If;
789: If (p_rec.cei_information6 = hr_api.g_varchar2) then
790: p_rec.cei_information6 :=
791: per_rei_shd.g_old_rec.cei_information6;
792: End If;
793: If (p_rec.cei_information7 = hr_api.g_varchar2) then
794: p_rec.cei_information7 :=
795: per_rei_shd.g_old_rec.cei_information7;
791: per_rei_shd.g_old_rec.cei_information6;
792: End If;
793: If (p_rec.cei_information7 = hr_api.g_varchar2) then
794: p_rec.cei_information7 :=
795: per_rei_shd.g_old_rec.cei_information7;
796: End If;
797: If (p_rec.cei_information8 = hr_api.g_varchar2) then
798: p_rec.cei_information8 :=
799: per_rei_shd.g_old_rec.cei_information8;
795: per_rei_shd.g_old_rec.cei_information7;
796: End If;
797: If (p_rec.cei_information8 = hr_api.g_varchar2) then
798: p_rec.cei_information8 :=
799: per_rei_shd.g_old_rec.cei_information8;
800: End If;
801: If (p_rec.cei_information9 = hr_api.g_varchar2) then
802: p_rec.cei_information9 :=
803: per_rei_shd.g_old_rec.cei_information9;
799: per_rei_shd.g_old_rec.cei_information8;
800: End If;
801: If (p_rec.cei_information9 = hr_api.g_varchar2) then
802: p_rec.cei_information9 :=
803: per_rei_shd.g_old_rec.cei_information9;
804: End If;
805: If (p_rec.cei_information10 = hr_api.g_varchar2) then
806: p_rec.cei_information10 :=
807: per_rei_shd.g_old_rec.cei_information10;
803: per_rei_shd.g_old_rec.cei_information9;
804: End If;
805: If (p_rec.cei_information10 = hr_api.g_varchar2) then
806: p_rec.cei_information10 :=
807: per_rei_shd.g_old_rec.cei_information10;
808: End If;
809: If (p_rec.cei_information11 = hr_api.g_varchar2) then
810: p_rec.cei_information11 :=
811: per_rei_shd.g_old_rec.cei_information11;
807: per_rei_shd.g_old_rec.cei_information10;
808: End If;
809: If (p_rec.cei_information11 = hr_api.g_varchar2) then
810: p_rec.cei_information11 :=
811: per_rei_shd.g_old_rec.cei_information11;
812: End If;
813: If (p_rec.cei_information12 = hr_api.g_varchar2) then
814: p_rec.cei_information12 :=
815: per_rei_shd.g_old_rec.cei_information12;
811: per_rei_shd.g_old_rec.cei_information11;
812: End If;
813: If (p_rec.cei_information12 = hr_api.g_varchar2) then
814: p_rec.cei_information12 :=
815: per_rei_shd.g_old_rec.cei_information12;
816: End If;
817: If (p_rec.cei_information13 = hr_api.g_varchar2) then
818: p_rec.cei_information13 :=
819: per_rei_shd.g_old_rec.cei_information13;
815: per_rei_shd.g_old_rec.cei_information12;
816: End If;
817: If (p_rec.cei_information13 = hr_api.g_varchar2) then
818: p_rec.cei_information13 :=
819: per_rei_shd.g_old_rec.cei_information13;
820: End If;
821: If (p_rec.cei_information14 = hr_api.g_varchar2) then
822: p_rec.cei_information14 :=
823: per_rei_shd.g_old_rec.cei_information14;
819: per_rei_shd.g_old_rec.cei_information13;
820: End If;
821: If (p_rec.cei_information14 = hr_api.g_varchar2) then
822: p_rec.cei_information14 :=
823: per_rei_shd.g_old_rec.cei_information14;
824: End If;
825: If (p_rec.cei_information15 = hr_api.g_varchar2) then
826: p_rec.cei_information15 :=
827: per_rei_shd.g_old_rec.cei_information15;
823: per_rei_shd.g_old_rec.cei_information14;
824: End If;
825: If (p_rec.cei_information15 = hr_api.g_varchar2) then
826: p_rec.cei_information15 :=
827: per_rei_shd.g_old_rec.cei_information15;
828: End If;
829: If (p_rec.cei_information16 = hr_api.g_varchar2) then
830: p_rec.cei_information16 :=
831: per_rei_shd.g_old_rec.cei_information16;
827: per_rei_shd.g_old_rec.cei_information15;
828: End If;
829: If (p_rec.cei_information16 = hr_api.g_varchar2) then
830: p_rec.cei_information16 :=
831: per_rei_shd.g_old_rec.cei_information16;
832: End If;
833: If (p_rec.cei_information17 = hr_api.g_varchar2) then
834: p_rec.cei_information17 :=
835: per_rei_shd.g_old_rec.cei_information17;
831: per_rei_shd.g_old_rec.cei_information16;
832: End If;
833: If (p_rec.cei_information17 = hr_api.g_varchar2) then
834: p_rec.cei_information17 :=
835: per_rei_shd.g_old_rec.cei_information17;
836: End If;
837: If (p_rec.cei_information18 = hr_api.g_varchar2) then
838: p_rec.cei_information18 :=
839: per_rei_shd.g_old_rec.cei_information18;
835: per_rei_shd.g_old_rec.cei_information17;
836: End If;
837: If (p_rec.cei_information18 = hr_api.g_varchar2) then
838: p_rec.cei_information18 :=
839: per_rei_shd.g_old_rec.cei_information18;
840: End If;
841: If (p_rec.cei_information19 = hr_api.g_varchar2) then
842: p_rec.cei_information19 :=
843: per_rei_shd.g_old_rec.cei_information19;
839: per_rei_shd.g_old_rec.cei_information18;
840: End If;
841: If (p_rec.cei_information19 = hr_api.g_varchar2) then
842: p_rec.cei_information19 :=
843: per_rei_shd.g_old_rec.cei_information19;
844: End If;
845: If (p_rec.cei_information20 = hr_api.g_varchar2) then
846: p_rec.cei_information20 :=
847: per_rei_shd.g_old_rec.cei_information20;
843: per_rei_shd.g_old_rec.cei_information19;
844: End If;
845: If (p_rec.cei_information20 = hr_api.g_varchar2) then
846: p_rec.cei_information20 :=
847: per_rei_shd.g_old_rec.cei_information20;
848: End If;
849: If (p_rec.cei_information21 = hr_api.g_varchar2) then
850: p_rec.cei_information21 :=
851: per_rei_shd.g_old_rec.cei_information21;
847: per_rei_shd.g_old_rec.cei_information20;
848: End If;
849: If (p_rec.cei_information21 = hr_api.g_varchar2) then
850: p_rec.cei_information21 :=
851: per_rei_shd.g_old_rec.cei_information21;
852: End If;
853: If (p_rec.cei_information22 = hr_api.g_varchar2) then
854: p_rec.cei_information22 :=
855: per_rei_shd.g_old_rec.cei_information22;
851: per_rei_shd.g_old_rec.cei_information21;
852: End If;
853: If (p_rec.cei_information22 = hr_api.g_varchar2) then
854: p_rec.cei_information22 :=
855: per_rei_shd.g_old_rec.cei_information22;
856: End If;
857: If (p_rec.cei_information23 = hr_api.g_varchar2) then
858: p_rec.cei_information23 :=
859: per_rei_shd.g_old_rec.cei_information23;
855: per_rei_shd.g_old_rec.cei_information22;
856: End If;
857: If (p_rec.cei_information23 = hr_api.g_varchar2) then
858: p_rec.cei_information23 :=
859: per_rei_shd.g_old_rec.cei_information23;
860: End If;
861: If (p_rec.cei_information24 = hr_api.g_varchar2) then
862: p_rec.cei_information24 :=
863: per_rei_shd.g_old_rec.cei_information24;
859: per_rei_shd.g_old_rec.cei_information23;
860: End If;
861: If (p_rec.cei_information24 = hr_api.g_varchar2) then
862: p_rec.cei_information24 :=
863: per_rei_shd.g_old_rec.cei_information24;
864: End If;
865: If (p_rec.cei_information25 = hr_api.g_varchar2) then
866: p_rec.cei_information25 :=
867: per_rei_shd.g_old_rec.cei_information25;
863: per_rei_shd.g_old_rec.cei_information24;
864: End If;
865: If (p_rec.cei_information25 = hr_api.g_varchar2) then
866: p_rec.cei_information25 :=
867: per_rei_shd.g_old_rec.cei_information25;
868: End If;
869: If (p_rec.cei_information26 = hr_api.g_varchar2) then
870: p_rec.cei_information26 :=
871: per_rei_shd.g_old_rec.cei_information26;
867: per_rei_shd.g_old_rec.cei_information25;
868: End If;
869: If (p_rec.cei_information26 = hr_api.g_varchar2) then
870: p_rec.cei_information26 :=
871: per_rei_shd.g_old_rec.cei_information26;
872: End If;
873: If (p_rec.cei_information27 = hr_api.g_varchar2) then
874: p_rec.cei_information27 :=
875: per_rei_shd.g_old_rec.cei_information27;
871: per_rei_shd.g_old_rec.cei_information26;
872: End If;
873: If (p_rec.cei_information27 = hr_api.g_varchar2) then
874: p_rec.cei_information27 :=
875: per_rei_shd.g_old_rec.cei_information27;
876: End If;
877: If (p_rec.cei_information28 = hr_api.g_varchar2) then
878: p_rec.cei_information28 :=
879: per_rei_shd.g_old_rec.cei_information28;
875: per_rei_shd.g_old_rec.cei_information27;
876: End If;
877: If (p_rec.cei_information28 = hr_api.g_varchar2) then
878: p_rec.cei_information28 :=
879: per_rei_shd.g_old_rec.cei_information28;
880: End If;
881: If (p_rec.cei_information29 = hr_api.g_varchar2) then
882: p_rec.cei_information29 :=
883: per_rei_shd.g_old_rec.cei_information29;
879: per_rei_shd.g_old_rec.cei_information28;
880: End If;
881: If (p_rec.cei_information29 = hr_api.g_varchar2) then
882: p_rec.cei_information29 :=
883: per_rei_shd.g_old_rec.cei_information29;
884: End If;
885: If (p_rec.cei_information30 = hr_api.g_varchar2) then
886: p_rec.cei_information30 :=
887: per_rei_shd.g_old_rec.cei_information30;
883: per_rei_shd.g_old_rec.cei_information29;
884: End If;
885: If (p_rec.cei_information30 = hr_api.g_varchar2) then
886: p_rec.cei_information30 :=
887: per_rei_shd.g_old_rec.cei_information30;
888: End If;
889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then
890: p_rec.cei_attribute_category :=
891: per_rei_shd.g_old_rec.cei_attribute_category;
887: per_rei_shd.g_old_rec.cei_information30;
888: End If;
889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then
890: p_rec.cei_attribute_category :=
891: per_rei_shd.g_old_rec.cei_attribute_category;
892: End If;
893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then
894: p_rec.cei_attribute1 :=
895: per_rei_shd.g_old_rec.cei_attribute1;
891: per_rei_shd.g_old_rec.cei_attribute_category;
892: End If;
893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then
894: p_rec.cei_attribute1 :=
895: per_rei_shd.g_old_rec.cei_attribute1;
896: End If;
897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then
898: p_rec.cei_attribute2 :=
899: per_rei_shd.g_old_rec.cei_attribute2;
895: per_rei_shd.g_old_rec.cei_attribute1;
896: End If;
897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then
898: p_rec.cei_attribute2 :=
899: per_rei_shd.g_old_rec.cei_attribute2;
900: End If;
901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then
902: p_rec.cei_attribute3 :=
903: per_rei_shd.g_old_rec.cei_attribute3;
899: per_rei_shd.g_old_rec.cei_attribute2;
900: End If;
901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then
902: p_rec.cei_attribute3 :=
903: per_rei_shd.g_old_rec.cei_attribute3;
904: End If;
905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then
906: p_rec.cei_attribute4 :=
907: per_rei_shd.g_old_rec.cei_attribute4;
903: per_rei_shd.g_old_rec.cei_attribute3;
904: End If;
905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then
906: p_rec.cei_attribute4 :=
907: per_rei_shd.g_old_rec.cei_attribute4;
908: End If;
909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then
910: p_rec.cei_attribute5 :=
911: per_rei_shd.g_old_rec.cei_attribute5;
907: per_rei_shd.g_old_rec.cei_attribute4;
908: End If;
909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then
910: p_rec.cei_attribute5 :=
911: per_rei_shd.g_old_rec.cei_attribute5;
912: End If;
913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then
914: p_rec.cei_attribute6 :=
915: per_rei_shd.g_old_rec.cei_attribute6;
911: per_rei_shd.g_old_rec.cei_attribute5;
912: End If;
913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then
914: p_rec.cei_attribute6 :=
915: per_rei_shd.g_old_rec.cei_attribute6;
916: End If;
917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then
918: p_rec.cei_attribute7 :=
919: per_rei_shd.g_old_rec.cei_attribute7;
915: per_rei_shd.g_old_rec.cei_attribute6;
916: End If;
917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then
918: p_rec.cei_attribute7 :=
919: per_rei_shd.g_old_rec.cei_attribute7;
920: End If;
921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then
922: p_rec.cei_attribute8 :=
923: per_rei_shd.g_old_rec.cei_attribute8;
919: per_rei_shd.g_old_rec.cei_attribute7;
920: End If;
921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then
922: p_rec.cei_attribute8 :=
923: per_rei_shd.g_old_rec.cei_attribute8;
924: End If;
925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then
926: p_rec.cei_attribute9 :=
927: per_rei_shd.g_old_rec.cei_attribute9;
923: per_rei_shd.g_old_rec.cei_attribute8;
924: End If;
925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then
926: p_rec.cei_attribute9 :=
927: per_rei_shd.g_old_rec.cei_attribute9;
928: End If;
929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then
930: p_rec.cei_attribute10 :=
931: per_rei_shd.g_old_rec.cei_attribute10;
927: per_rei_shd.g_old_rec.cei_attribute9;
928: End If;
929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then
930: p_rec.cei_attribute10 :=
931: per_rei_shd.g_old_rec.cei_attribute10;
932: End If;
933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then
934: p_rec.cei_attribute11 :=
935: per_rei_shd.g_old_rec.cei_attribute11;
931: per_rei_shd.g_old_rec.cei_attribute10;
932: End If;
933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then
934: p_rec.cei_attribute11 :=
935: per_rei_shd.g_old_rec.cei_attribute11;
936: End If;
937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then
938: p_rec.cei_attribute12 :=
939: per_rei_shd.g_old_rec.cei_attribute12;
935: per_rei_shd.g_old_rec.cei_attribute11;
936: End If;
937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then
938: p_rec.cei_attribute12 :=
939: per_rei_shd.g_old_rec.cei_attribute12;
940: End If;
941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then
942: p_rec.cei_attribute13 :=
943: per_rei_shd.g_old_rec.cei_attribute13;
939: per_rei_shd.g_old_rec.cei_attribute12;
940: End If;
941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then
942: p_rec.cei_attribute13 :=
943: per_rei_shd.g_old_rec.cei_attribute13;
944: End If;
945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then
946: p_rec.cei_attribute14 :=
947: per_rei_shd.g_old_rec.cei_attribute14;
943: per_rei_shd.g_old_rec.cei_attribute13;
944: End If;
945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then
946: p_rec.cei_attribute14 :=
947: per_rei_shd.g_old_rec.cei_attribute14;
948: End If;
949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then
950: p_rec.cei_attribute15 :=
951: per_rei_shd.g_old_rec.cei_attribute15;
947: per_rei_shd.g_old_rec.cei_attribute14;
948: End If;
949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then
950: p_rec.cei_attribute15 :=
951: per_rei_shd.g_old_rec.cei_attribute15;
952: End If;
953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then
954: p_rec.cei_attribute16 :=
955: per_rei_shd.g_old_rec.cei_attribute16;
951: per_rei_shd.g_old_rec.cei_attribute15;
952: End If;
953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then
954: p_rec.cei_attribute16 :=
955: per_rei_shd.g_old_rec.cei_attribute16;
956: End If;
957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then
958: p_rec.cei_attribute17 :=
959: per_rei_shd.g_old_rec.cei_attribute17;
955: per_rei_shd.g_old_rec.cei_attribute16;
956: End If;
957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then
958: p_rec.cei_attribute17 :=
959: per_rei_shd.g_old_rec.cei_attribute17;
960: End If;
961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then
962: p_rec.cei_attribute18 :=
963: per_rei_shd.g_old_rec.cei_attribute18;
959: per_rei_shd.g_old_rec.cei_attribute17;
960: End If;
961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then
962: p_rec.cei_attribute18 :=
963: per_rei_shd.g_old_rec.cei_attribute18;
964: End If;
965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then
966: p_rec.cei_attribute19 :=
967: per_rei_shd.g_old_rec.cei_attribute19;
963: per_rei_shd.g_old_rec.cei_attribute18;
964: End If;
965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then
966: p_rec.cei_attribute19 :=
967: per_rei_shd.g_old_rec.cei_attribute19;
968: End If;
969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then
970: p_rec.cei_attribute20 :=
971: per_rei_shd.g_old_rec.cei_attribute20;
967: per_rei_shd.g_old_rec.cei_attribute19;
968: End If;
969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then
970: p_rec.cei_attribute20 :=
971: per_rei_shd.g_old_rec.cei_attribute20;
972: End If;
973: If (p_rec.request_id = hr_api.g_number) then
974: p_rec.request_id :=
975: per_rei_shd.g_old_rec.request_id;
971: per_rei_shd.g_old_rec.cei_attribute20;
972: End If;
973: If (p_rec.request_id = hr_api.g_number) then
974: p_rec.request_id :=
975: per_rei_shd.g_old_rec.request_id;
976: End If;
977: If (p_rec.program_application_id = hr_api.g_number) then
978: p_rec.program_application_id :=
979: per_rei_shd.g_old_rec.program_application_id;
975: per_rei_shd.g_old_rec.request_id;
976: End If;
977: If (p_rec.program_application_id = hr_api.g_number) then
978: p_rec.program_application_id :=
979: per_rei_shd.g_old_rec.program_application_id;
980: End If;
981: If (p_rec.program_id = hr_api.g_number) then
982: p_rec.program_id :=
983: per_rei_shd.g_old_rec.program_id;
979: per_rei_shd.g_old_rec.program_application_id;
980: End If;
981: If (p_rec.program_id = hr_api.g_number) then
982: p_rec.program_id :=
983: per_rei_shd.g_old_rec.program_id;
984: End If;
985: If (p_rec.program_update_date = hr_api.g_date) then
986: p_rec.program_update_date :=
987: per_rei_shd.g_old_rec.program_update_date;
983: per_rei_shd.g_old_rec.program_id;
984: End If;
985: If (p_rec.program_update_date = hr_api.g_date) then
986: p_rec.program_update_date :=
987: per_rei_shd.g_old_rec.program_update_date;
988: End If;
989: --
990: End convert_defs;
991: --
994: -- ----------------------------------------------------------------------------
995: Procedure upd
996: (p_effective_date in date
997: ,p_datetrack_mode in varchar2
998: ,p_rec in out nocopy per_rei_shd.g_rec_type
999: ) is
1000: --
1001: l_proc varchar2(72) := g_package||'upd';
1002: l_validation_start_date date;
1010: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1011: --
1012: -- We must lock the row which we need to update.
1013: --
1014: per_rei_shd.lck
1015: (p_effective_date => p_effective_date
1016: ,p_datetrack_mode => p_datetrack_mode
1017: ,p_contact_extra_info_id => p_rec.contact_extra_info_id
1018: ,p_object_version_number => p_rec.object_version_number
1142: ,p_effective_start_date out nocopy date
1143: ,p_effective_end_date out nocopy date
1144: ) is
1145: --
1146: l_rec per_rei_shd.g_rec_type;
1147: l_proc varchar2(72) := g_package||'upd';
1148: --
1149: Begin
1150: hr_utility.set_location('Entering:'||l_proc, 5);
1152: -- Call conversion function to turn arguments into the
1153: -- l_rec structure.
1154: --
1155: l_rec :=
1156: per_rei_shd.convert_args
1157: (p_contact_extra_info_id
1158: ,null
1159: ,null
1160: ,p_contact_relationship_id