54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqh_asa_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: pqh_asa_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: pqh_asa_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 pqh_asa_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 pqh_asa_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: pqh_asa_shd.upd_effective_end_date
312: (p_effective_date => p_effective_date
313: ,p_base_key_value => p_rec.assignment_acco_id
314: ,p_new_effective_end_date => (p_validation_start_date - 1)
315: ,p_validation_start_date => p_validation_start_date
376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure pre_update
380: (p_rec in out nocopy pqh_asa_shd.g_rec_type
381: ,p_effective_date in date
382: ,p_datetrack_mode in varchar2
383: ,p_validation_start_date in date
384: ,p_validation_end_date in date
434: --
435: -- {End Of Comments}
436: -- ----------------------------------------------------------------------------
437: Procedure post_update
438: (p_rec in pqh_asa_shd.g_rec_type
439: ,p_effective_date in date
440: ,p_datetrack_mode in varchar2
441: ,p_validation_start_date in date
442: ,p_validation_end_date in date
617: => p_rec.reason_for_no_acco
618: ,p_indemnity_currency
619: => p_rec.indemnity_currency
620: ,p_effective_start_date_o
621: => pqh_asa_shd.g_old_rec.effective_start_date
622: ,p_effective_end_date_o
623: => pqh_asa_shd.g_old_rec.effective_end_date
624: ,p_business_group_id_o
625: => pqh_asa_shd.g_old_rec.business_group_id
619: => p_rec.indemnity_currency
620: ,p_effective_start_date_o
621: => pqh_asa_shd.g_old_rec.effective_start_date
622: ,p_effective_end_date_o
623: => pqh_asa_shd.g_old_rec.effective_end_date
624: ,p_business_group_id_o
625: => pqh_asa_shd.g_old_rec.business_group_id
626: ,p_assignment_id_o
627: => pqh_asa_shd.g_old_rec.assignment_id
621: => pqh_asa_shd.g_old_rec.effective_start_date
622: ,p_effective_end_date_o
623: => pqh_asa_shd.g_old_rec.effective_end_date
624: ,p_business_group_id_o
625: => pqh_asa_shd.g_old_rec.business_group_id
626: ,p_assignment_id_o
627: => pqh_asa_shd.g_old_rec.assignment_id
628: ,p_accommodation_given_o
629: => pqh_asa_shd.g_old_rec.accommodation_given
623: => pqh_asa_shd.g_old_rec.effective_end_date
624: ,p_business_group_id_o
625: => pqh_asa_shd.g_old_rec.business_group_id
626: ,p_assignment_id_o
627: => pqh_asa_shd.g_old_rec.assignment_id
628: ,p_accommodation_given_o
629: => pqh_asa_shd.g_old_rec.accommodation_given
630: ,p_temporary_assignment_o
631: => pqh_asa_shd.g_old_rec.temporary_assignment
625: => pqh_asa_shd.g_old_rec.business_group_id
626: ,p_assignment_id_o
627: => pqh_asa_shd.g_old_rec.assignment_id
628: ,p_accommodation_given_o
629: => pqh_asa_shd.g_old_rec.accommodation_given
630: ,p_temporary_assignment_o
631: => pqh_asa_shd.g_old_rec.temporary_assignment
632: ,p_accommodation_id_o
633: => pqh_asa_shd.g_old_rec.accommodation_id
627: => pqh_asa_shd.g_old_rec.assignment_id
628: ,p_accommodation_given_o
629: => pqh_asa_shd.g_old_rec.accommodation_given
630: ,p_temporary_assignment_o
631: => pqh_asa_shd.g_old_rec.temporary_assignment
632: ,p_accommodation_id_o
633: => pqh_asa_shd.g_old_rec.accommodation_id
634: ,p_acceptance_date_o
635: => pqh_asa_shd.g_old_rec.acceptance_date
629: => pqh_asa_shd.g_old_rec.accommodation_given
630: ,p_temporary_assignment_o
631: => pqh_asa_shd.g_old_rec.temporary_assignment
632: ,p_accommodation_id_o
633: => pqh_asa_shd.g_old_rec.accommodation_id
634: ,p_acceptance_date_o
635: => pqh_asa_shd.g_old_rec.acceptance_date
636: ,p_moving_date_o
637: => pqh_asa_shd.g_old_rec.moving_date
631: => pqh_asa_shd.g_old_rec.temporary_assignment
632: ,p_accommodation_id_o
633: => pqh_asa_shd.g_old_rec.accommodation_id
634: ,p_acceptance_date_o
635: => pqh_asa_shd.g_old_rec.acceptance_date
636: ,p_moving_date_o
637: => pqh_asa_shd.g_old_rec.moving_date
638: ,p_refusal_date_o
639: => pqh_asa_shd.g_old_rec.refusal_date
633: => pqh_asa_shd.g_old_rec.accommodation_id
634: ,p_acceptance_date_o
635: => pqh_asa_shd.g_old_rec.acceptance_date
636: ,p_moving_date_o
637: => pqh_asa_shd.g_old_rec.moving_date
638: ,p_refusal_date_o
639: => pqh_asa_shd.g_old_rec.refusal_date
640: ,p_comments_o
641: => pqh_asa_shd.g_old_rec.comments
635: => pqh_asa_shd.g_old_rec.acceptance_date
636: ,p_moving_date_o
637: => pqh_asa_shd.g_old_rec.moving_date
638: ,p_refusal_date_o
639: => pqh_asa_shd.g_old_rec.refusal_date
640: ,p_comments_o
641: => pqh_asa_shd.g_old_rec.comments
642: ,p_indemnity_entitlement_o
643: => pqh_asa_shd.g_old_rec.indemnity_entitlement
637: => pqh_asa_shd.g_old_rec.moving_date
638: ,p_refusal_date_o
639: => pqh_asa_shd.g_old_rec.refusal_date
640: ,p_comments_o
641: => pqh_asa_shd.g_old_rec.comments
642: ,p_indemnity_entitlement_o
643: => pqh_asa_shd.g_old_rec.indemnity_entitlement
644: ,p_indemnity_amount_o
645: => pqh_asa_shd.g_old_rec.indemnity_amount
639: => pqh_asa_shd.g_old_rec.refusal_date
640: ,p_comments_o
641: => pqh_asa_shd.g_old_rec.comments
642: ,p_indemnity_entitlement_o
643: => pqh_asa_shd.g_old_rec.indemnity_entitlement
644: ,p_indemnity_amount_o
645: => pqh_asa_shd.g_old_rec.indemnity_amount
646: ,p_type_of_payment_o
647: => pqh_asa_shd.g_old_rec.type_of_payment
641: => pqh_asa_shd.g_old_rec.comments
642: ,p_indemnity_entitlement_o
643: => pqh_asa_shd.g_old_rec.indemnity_entitlement
644: ,p_indemnity_amount_o
645: => pqh_asa_shd.g_old_rec.indemnity_amount
646: ,p_type_of_payment_o
647: => pqh_asa_shd.g_old_rec.type_of_payment
648: ,p_information_category_o
649: => pqh_asa_shd.g_old_rec.information_category
643: => pqh_asa_shd.g_old_rec.indemnity_entitlement
644: ,p_indemnity_amount_o
645: => pqh_asa_shd.g_old_rec.indemnity_amount
646: ,p_type_of_payment_o
647: => pqh_asa_shd.g_old_rec.type_of_payment
648: ,p_information_category_o
649: => pqh_asa_shd.g_old_rec.information_category
650: ,p_information1_o
651: => pqh_asa_shd.g_old_rec.information1
645: => pqh_asa_shd.g_old_rec.indemnity_amount
646: ,p_type_of_payment_o
647: => pqh_asa_shd.g_old_rec.type_of_payment
648: ,p_information_category_o
649: => pqh_asa_shd.g_old_rec.information_category
650: ,p_information1_o
651: => pqh_asa_shd.g_old_rec.information1
652: ,p_information2_o
653: => pqh_asa_shd.g_old_rec.information2
647: => pqh_asa_shd.g_old_rec.type_of_payment
648: ,p_information_category_o
649: => pqh_asa_shd.g_old_rec.information_category
650: ,p_information1_o
651: => pqh_asa_shd.g_old_rec.information1
652: ,p_information2_o
653: => pqh_asa_shd.g_old_rec.information2
654: ,p_information3_o
655: => pqh_asa_shd.g_old_rec.information3
649: => pqh_asa_shd.g_old_rec.information_category
650: ,p_information1_o
651: => pqh_asa_shd.g_old_rec.information1
652: ,p_information2_o
653: => pqh_asa_shd.g_old_rec.information2
654: ,p_information3_o
655: => pqh_asa_shd.g_old_rec.information3
656: ,p_information4_o
657: => pqh_asa_shd.g_old_rec.information4
651: => pqh_asa_shd.g_old_rec.information1
652: ,p_information2_o
653: => pqh_asa_shd.g_old_rec.information2
654: ,p_information3_o
655: => pqh_asa_shd.g_old_rec.information3
656: ,p_information4_o
657: => pqh_asa_shd.g_old_rec.information4
658: ,p_information5_o
659: => pqh_asa_shd.g_old_rec.information5
653: => pqh_asa_shd.g_old_rec.information2
654: ,p_information3_o
655: => pqh_asa_shd.g_old_rec.information3
656: ,p_information4_o
657: => pqh_asa_shd.g_old_rec.information4
658: ,p_information5_o
659: => pqh_asa_shd.g_old_rec.information5
660: ,p_information6_o
661: => pqh_asa_shd.g_old_rec.information6
655: => pqh_asa_shd.g_old_rec.information3
656: ,p_information4_o
657: => pqh_asa_shd.g_old_rec.information4
658: ,p_information5_o
659: => pqh_asa_shd.g_old_rec.information5
660: ,p_information6_o
661: => pqh_asa_shd.g_old_rec.information6
662: ,p_information7_o
663: => pqh_asa_shd.g_old_rec.information7
657: => pqh_asa_shd.g_old_rec.information4
658: ,p_information5_o
659: => pqh_asa_shd.g_old_rec.information5
660: ,p_information6_o
661: => pqh_asa_shd.g_old_rec.information6
662: ,p_information7_o
663: => pqh_asa_shd.g_old_rec.information7
664: ,p_information8_o
665: => pqh_asa_shd.g_old_rec.information8
659: => pqh_asa_shd.g_old_rec.information5
660: ,p_information6_o
661: => pqh_asa_shd.g_old_rec.information6
662: ,p_information7_o
663: => pqh_asa_shd.g_old_rec.information7
664: ,p_information8_o
665: => pqh_asa_shd.g_old_rec.information8
666: ,p_information9_o
667: => pqh_asa_shd.g_old_rec.information9
661: => pqh_asa_shd.g_old_rec.information6
662: ,p_information7_o
663: => pqh_asa_shd.g_old_rec.information7
664: ,p_information8_o
665: => pqh_asa_shd.g_old_rec.information8
666: ,p_information9_o
667: => pqh_asa_shd.g_old_rec.information9
668: ,p_information10_o
669: => pqh_asa_shd.g_old_rec.information10
663: => pqh_asa_shd.g_old_rec.information7
664: ,p_information8_o
665: => pqh_asa_shd.g_old_rec.information8
666: ,p_information9_o
667: => pqh_asa_shd.g_old_rec.information9
668: ,p_information10_o
669: => pqh_asa_shd.g_old_rec.information10
670: ,p_information11_o
671: => pqh_asa_shd.g_old_rec.information11
665: => pqh_asa_shd.g_old_rec.information8
666: ,p_information9_o
667: => pqh_asa_shd.g_old_rec.information9
668: ,p_information10_o
669: => pqh_asa_shd.g_old_rec.information10
670: ,p_information11_o
671: => pqh_asa_shd.g_old_rec.information11
672: ,p_information12_o
673: => pqh_asa_shd.g_old_rec.information12
667: => pqh_asa_shd.g_old_rec.information9
668: ,p_information10_o
669: => pqh_asa_shd.g_old_rec.information10
670: ,p_information11_o
671: => pqh_asa_shd.g_old_rec.information11
672: ,p_information12_o
673: => pqh_asa_shd.g_old_rec.information12
674: ,p_information13_o
675: => pqh_asa_shd.g_old_rec.information13
669: => pqh_asa_shd.g_old_rec.information10
670: ,p_information11_o
671: => pqh_asa_shd.g_old_rec.information11
672: ,p_information12_o
673: => pqh_asa_shd.g_old_rec.information12
674: ,p_information13_o
675: => pqh_asa_shd.g_old_rec.information13
676: ,p_information14_o
677: => pqh_asa_shd.g_old_rec.information14
671: => pqh_asa_shd.g_old_rec.information11
672: ,p_information12_o
673: => pqh_asa_shd.g_old_rec.information12
674: ,p_information13_o
675: => pqh_asa_shd.g_old_rec.information13
676: ,p_information14_o
677: => pqh_asa_shd.g_old_rec.information14
678: ,p_information15_o
679: => pqh_asa_shd.g_old_rec.information15
673: => pqh_asa_shd.g_old_rec.information12
674: ,p_information13_o
675: => pqh_asa_shd.g_old_rec.information13
676: ,p_information14_o
677: => pqh_asa_shd.g_old_rec.information14
678: ,p_information15_o
679: => pqh_asa_shd.g_old_rec.information15
680: ,p_information16_o
681: => pqh_asa_shd.g_old_rec.information16
675: => pqh_asa_shd.g_old_rec.information13
676: ,p_information14_o
677: => pqh_asa_shd.g_old_rec.information14
678: ,p_information15_o
679: => pqh_asa_shd.g_old_rec.information15
680: ,p_information16_o
681: => pqh_asa_shd.g_old_rec.information16
682: ,p_information17_o
683: => pqh_asa_shd.g_old_rec.information17
677: => pqh_asa_shd.g_old_rec.information14
678: ,p_information15_o
679: => pqh_asa_shd.g_old_rec.information15
680: ,p_information16_o
681: => pqh_asa_shd.g_old_rec.information16
682: ,p_information17_o
683: => pqh_asa_shd.g_old_rec.information17
684: ,p_information18_o
685: => pqh_asa_shd.g_old_rec.information18
679: => pqh_asa_shd.g_old_rec.information15
680: ,p_information16_o
681: => pqh_asa_shd.g_old_rec.information16
682: ,p_information17_o
683: => pqh_asa_shd.g_old_rec.information17
684: ,p_information18_o
685: => pqh_asa_shd.g_old_rec.information18
686: ,p_information19_o
687: => pqh_asa_shd.g_old_rec.information19
681: => pqh_asa_shd.g_old_rec.information16
682: ,p_information17_o
683: => pqh_asa_shd.g_old_rec.information17
684: ,p_information18_o
685: => pqh_asa_shd.g_old_rec.information18
686: ,p_information19_o
687: => pqh_asa_shd.g_old_rec.information19
688: ,p_information20_o
689: => pqh_asa_shd.g_old_rec.information20
683: => pqh_asa_shd.g_old_rec.information17
684: ,p_information18_o
685: => pqh_asa_shd.g_old_rec.information18
686: ,p_information19_o
687: => pqh_asa_shd.g_old_rec.information19
688: ,p_information20_o
689: => pqh_asa_shd.g_old_rec.information20
690: ,p_information21_o
691: => pqh_asa_shd.g_old_rec.information21
685: => pqh_asa_shd.g_old_rec.information18
686: ,p_information19_o
687: => pqh_asa_shd.g_old_rec.information19
688: ,p_information20_o
689: => pqh_asa_shd.g_old_rec.information20
690: ,p_information21_o
691: => pqh_asa_shd.g_old_rec.information21
692: ,p_information22_o
693: => pqh_asa_shd.g_old_rec.information22
687: => pqh_asa_shd.g_old_rec.information19
688: ,p_information20_o
689: => pqh_asa_shd.g_old_rec.information20
690: ,p_information21_o
691: => pqh_asa_shd.g_old_rec.information21
692: ,p_information22_o
693: => pqh_asa_shd.g_old_rec.information22
694: ,p_information23_o
695: => pqh_asa_shd.g_old_rec.information23
689: => pqh_asa_shd.g_old_rec.information20
690: ,p_information21_o
691: => pqh_asa_shd.g_old_rec.information21
692: ,p_information22_o
693: => pqh_asa_shd.g_old_rec.information22
694: ,p_information23_o
695: => pqh_asa_shd.g_old_rec.information23
696: ,p_information24_o
697: => pqh_asa_shd.g_old_rec.information24
691: => pqh_asa_shd.g_old_rec.information21
692: ,p_information22_o
693: => pqh_asa_shd.g_old_rec.information22
694: ,p_information23_o
695: => pqh_asa_shd.g_old_rec.information23
696: ,p_information24_o
697: => pqh_asa_shd.g_old_rec.information24
698: ,p_information25_o
699: => pqh_asa_shd.g_old_rec.information25
693: => pqh_asa_shd.g_old_rec.information22
694: ,p_information23_o
695: => pqh_asa_shd.g_old_rec.information23
696: ,p_information24_o
697: => pqh_asa_shd.g_old_rec.information24
698: ,p_information25_o
699: => pqh_asa_shd.g_old_rec.information25
700: ,p_information26_o
701: => pqh_asa_shd.g_old_rec.information26
695: => pqh_asa_shd.g_old_rec.information23
696: ,p_information24_o
697: => pqh_asa_shd.g_old_rec.information24
698: ,p_information25_o
699: => pqh_asa_shd.g_old_rec.information25
700: ,p_information26_o
701: => pqh_asa_shd.g_old_rec.information26
702: ,p_information27_o
703: => pqh_asa_shd.g_old_rec.information27
697: => pqh_asa_shd.g_old_rec.information24
698: ,p_information25_o
699: => pqh_asa_shd.g_old_rec.information25
700: ,p_information26_o
701: => pqh_asa_shd.g_old_rec.information26
702: ,p_information27_o
703: => pqh_asa_shd.g_old_rec.information27
704: ,p_information28_o
705: => pqh_asa_shd.g_old_rec.information28
699: => pqh_asa_shd.g_old_rec.information25
700: ,p_information26_o
701: => pqh_asa_shd.g_old_rec.information26
702: ,p_information27_o
703: => pqh_asa_shd.g_old_rec.information27
704: ,p_information28_o
705: => pqh_asa_shd.g_old_rec.information28
706: ,p_information29_o
707: => pqh_asa_shd.g_old_rec.information29
701: => pqh_asa_shd.g_old_rec.information26
702: ,p_information27_o
703: => pqh_asa_shd.g_old_rec.information27
704: ,p_information28_o
705: => pqh_asa_shd.g_old_rec.information28
706: ,p_information29_o
707: => pqh_asa_shd.g_old_rec.information29
708: ,p_information30_o
709: => pqh_asa_shd.g_old_rec.information30
703: => pqh_asa_shd.g_old_rec.information27
704: ,p_information28_o
705: => pqh_asa_shd.g_old_rec.information28
706: ,p_information29_o
707: => pqh_asa_shd.g_old_rec.information29
708: ,p_information30_o
709: => pqh_asa_shd.g_old_rec.information30
710: ,p_attribute_category_o
711: => pqh_asa_shd.g_old_rec.attribute_category
705: => pqh_asa_shd.g_old_rec.information28
706: ,p_information29_o
707: => pqh_asa_shd.g_old_rec.information29
708: ,p_information30_o
709: => pqh_asa_shd.g_old_rec.information30
710: ,p_attribute_category_o
711: => pqh_asa_shd.g_old_rec.attribute_category
712: ,p_attribute1_o
713: => pqh_asa_shd.g_old_rec.attribute1
707: => pqh_asa_shd.g_old_rec.information29
708: ,p_information30_o
709: => pqh_asa_shd.g_old_rec.information30
710: ,p_attribute_category_o
711: => pqh_asa_shd.g_old_rec.attribute_category
712: ,p_attribute1_o
713: => pqh_asa_shd.g_old_rec.attribute1
714: ,p_attribute2_o
715: => pqh_asa_shd.g_old_rec.attribute2
709: => pqh_asa_shd.g_old_rec.information30
710: ,p_attribute_category_o
711: => pqh_asa_shd.g_old_rec.attribute_category
712: ,p_attribute1_o
713: => pqh_asa_shd.g_old_rec.attribute1
714: ,p_attribute2_o
715: => pqh_asa_shd.g_old_rec.attribute2
716: ,p_attribute3_o
717: => pqh_asa_shd.g_old_rec.attribute3
711: => pqh_asa_shd.g_old_rec.attribute_category
712: ,p_attribute1_o
713: => pqh_asa_shd.g_old_rec.attribute1
714: ,p_attribute2_o
715: => pqh_asa_shd.g_old_rec.attribute2
716: ,p_attribute3_o
717: => pqh_asa_shd.g_old_rec.attribute3
718: ,p_attribute4_o
719: => pqh_asa_shd.g_old_rec.attribute4
713: => pqh_asa_shd.g_old_rec.attribute1
714: ,p_attribute2_o
715: => pqh_asa_shd.g_old_rec.attribute2
716: ,p_attribute3_o
717: => pqh_asa_shd.g_old_rec.attribute3
718: ,p_attribute4_o
719: => pqh_asa_shd.g_old_rec.attribute4
720: ,p_attribute5_o
721: => pqh_asa_shd.g_old_rec.attribute5
715: => pqh_asa_shd.g_old_rec.attribute2
716: ,p_attribute3_o
717: => pqh_asa_shd.g_old_rec.attribute3
718: ,p_attribute4_o
719: => pqh_asa_shd.g_old_rec.attribute4
720: ,p_attribute5_o
721: => pqh_asa_shd.g_old_rec.attribute5
722: ,p_attribute6_o
723: => pqh_asa_shd.g_old_rec.attribute6
717: => pqh_asa_shd.g_old_rec.attribute3
718: ,p_attribute4_o
719: => pqh_asa_shd.g_old_rec.attribute4
720: ,p_attribute5_o
721: => pqh_asa_shd.g_old_rec.attribute5
722: ,p_attribute6_o
723: => pqh_asa_shd.g_old_rec.attribute6
724: ,p_attribute7_o
725: => pqh_asa_shd.g_old_rec.attribute7
719: => pqh_asa_shd.g_old_rec.attribute4
720: ,p_attribute5_o
721: => pqh_asa_shd.g_old_rec.attribute5
722: ,p_attribute6_o
723: => pqh_asa_shd.g_old_rec.attribute6
724: ,p_attribute7_o
725: => pqh_asa_shd.g_old_rec.attribute7
726: ,p_attribute8_o
727: => pqh_asa_shd.g_old_rec.attribute8
721: => pqh_asa_shd.g_old_rec.attribute5
722: ,p_attribute6_o
723: => pqh_asa_shd.g_old_rec.attribute6
724: ,p_attribute7_o
725: => pqh_asa_shd.g_old_rec.attribute7
726: ,p_attribute8_o
727: => pqh_asa_shd.g_old_rec.attribute8
728: ,p_attribute9_o
729: => pqh_asa_shd.g_old_rec.attribute9
723: => pqh_asa_shd.g_old_rec.attribute6
724: ,p_attribute7_o
725: => pqh_asa_shd.g_old_rec.attribute7
726: ,p_attribute8_o
727: => pqh_asa_shd.g_old_rec.attribute8
728: ,p_attribute9_o
729: => pqh_asa_shd.g_old_rec.attribute9
730: ,p_attribute10_o
731: => pqh_asa_shd.g_old_rec.attribute10
725: => pqh_asa_shd.g_old_rec.attribute7
726: ,p_attribute8_o
727: => pqh_asa_shd.g_old_rec.attribute8
728: ,p_attribute9_o
729: => pqh_asa_shd.g_old_rec.attribute9
730: ,p_attribute10_o
731: => pqh_asa_shd.g_old_rec.attribute10
732: ,p_attribute11_o
733: => pqh_asa_shd.g_old_rec.attribute11
727: => pqh_asa_shd.g_old_rec.attribute8
728: ,p_attribute9_o
729: => pqh_asa_shd.g_old_rec.attribute9
730: ,p_attribute10_o
731: => pqh_asa_shd.g_old_rec.attribute10
732: ,p_attribute11_o
733: => pqh_asa_shd.g_old_rec.attribute11
734: ,p_attribute12_o
735: => pqh_asa_shd.g_old_rec.attribute12
729: => pqh_asa_shd.g_old_rec.attribute9
730: ,p_attribute10_o
731: => pqh_asa_shd.g_old_rec.attribute10
732: ,p_attribute11_o
733: => pqh_asa_shd.g_old_rec.attribute11
734: ,p_attribute12_o
735: => pqh_asa_shd.g_old_rec.attribute12
736: ,p_attribute13_o
737: => pqh_asa_shd.g_old_rec.attribute13
731: => pqh_asa_shd.g_old_rec.attribute10
732: ,p_attribute11_o
733: => pqh_asa_shd.g_old_rec.attribute11
734: ,p_attribute12_o
735: => pqh_asa_shd.g_old_rec.attribute12
736: ,p_attribute13_o
737: => pqh_asa_shd.g_old_rec.attribute13
738: ,p_attribute14_o
739: => pqh_asa_shd.g_old_rec.attribute14
733: => pqh_asa_shd.g_old_rec.attribute11
734: ,p_attribute12_o
735: => pqh_asa_shd.g_old_rec.attribute12
736: ,p_attribute13_o
737: => pqh_asa_shd.g_old_rec.attribute13
738: ,p_attribute14_o
739: => pqh_asa_shd.g_old_rec.attribute14
740: ,p_attribute15_o
741: => pqh_asa_shd.g_old_rec.attribute15
735: => pqh_asa_shd.g_old_rec.attribute12
736: ,p_attribute13_o
737: => pqh_asa_shd.g_old_rec.attribute13
738: ,p_attribute14_o
739: => pqh_asa_shd.g_old_rec.attribute14
740: ,p_attribute15_o
741: => pqh_asa_shd.g_old_rec.attribute15
742: ,p_attribute16_o
743: => pqh_asa_shd.g_old_rec.attribute16
737: => pqh_asa_shd.g_old_rec.attribute13
738: ,p_attribute14_o
739: => pqh_asa_shd.g_old_rec.attribute14
740: ,p_attribute15_o
741: => pqh_asa_shd.g_old_rec.attribute15
742: ,p_attribute16_o
743: => pqh_asa_shd.g_old_rec.attribute16
744: ,p_attribute17_o
745: => pqh_asa_shd.g_old_rec.attribute17
739: => pqh_asa_shd.g_old_rec.attribute14
740: ,p_attribute15_o
741: => pqh_asa_shd.g_old_rec.attribute15
742: ,p_attribute16_o
743: => pqh_asa_shd.g_old_rec.attribute16
744: ,p_attribute17_o
745: => pqh_asa_shd.g_old_rec.attribute17
746: ,p_attribute18_o
747: => pqh_asa_shd.g_old_rec.attribute18
741: => pqh_asa_shd.g_old_rec.attribute15
742: ,p_attribute16_o
743: => pqh_asa_shd.g_old_rec.attribute16
744: ,p_attribute17_o
745: => pqh_asa_shd.g_old_rec.attribute17
746: ,p_attribute18_o
747: => pqh_asa_shd.g_old_rec.attribute18
748: ,p_attribute19_o
749: => pqh_asa_shd.g_old_rec.attribute19
743: => pqh_asa_shd.g_old_rec.attribute16
744: ,p_attribute17_o
745: => pqh_asa_shd.g_old_rec.attribute17
746: ,p_attribute18_o
747: => pqh_asa_shd.g_old_rec.attribute18
748: ,p_attribute19_o
749: => pqh_asa_shd.g_old_rec.attribute19
750: ,p_attribute20_o
751: => pqh_asa_shd.g_old_rec.attribute20
745: => pqh_asa_shd.g_old_rec.attribute17
746: ,p_attribute18_o
747: => pqh_asa_shd.g_old_rec.attribute18
748: ,p_attribute19_o
749: => pqh_asa_shd.g_old_rec.attribute19
750: ,p_attribute20_o
751: => pqh_asa_shd.g_old_rec.attribute20
752: ,p_attribute21_o
753: => pqh_asa_shd.g_old_rec.attribute21
747: => pqh_asa_shd.g_old_rec.attribute18
748: ,p_attribute19_o
749: => pqh_asa_shd.g_old_rec.attribute19
750: ,p_attribute20_o
751: => pqh_asa_shd.g_old_rec.attribute20
752: ,p_attribute21_o
753: => pqh_asa_shd.g_old_rec.attribute21
754: ,p_attribute22_o
755: => pqh_asa_shd.g_old_rec.attribute22
749: => pqh_asa_shd.g_old_rec.attribute19
750: ,p_attribute20_o
751: => pqh_asa_shd.g_old_rec.attribute20
752: ,p_attribute21_o
753: => pqh_asa_shd.g_old_rec.attribute21
754: ,p_attribute22_o
755: => pqh_asa_shd.g_old_rec.attribute22
756: ,p_attribute23_o
757: => pqh_asa_shd.g_old_rec.attribute23
751: => pqh_asa_shd.g_old_rec.attribute20
752: ,p_attribute21_o
753: => pqh_asa_shd.g_old_rec.attribute21
754: ,p_attribute22_o
755: => pqh_asa_shd.g_old_rec.attribute22
756: ,p_attribute23_o
757: => pqh_asa_shd.g_old_rec.attribute23
758: ,p_attribute24_o
759: => pqh_asa_shd.g_old_rec.attribute24
753: => pqh_asa_shd.g_old_rec.attribute21
754: ,p_attribute22_o
755: => pqh_asa_shd.g_old_rec.attribute22
756: ,p_attribute23_o
757: => pqh_asa_shd.g_old_rec.attribute23
758: ,p_attribute24_o
759: => pqh_asa_shd.g_old_rec.attribute24
760: ,p_attribute25_o
761: => pqh_asa_shd.g_old_rec.attribute25
755: => pqh_asa_shd.g_old_rec.attribute22
756: ,p_attribute23_o
757: => pqh_asa_shd.g_old_rec.attribute23
758: ,p_attribute24_o
759: => pqh_asa_shd.g_old_rec.attribute24
760: ,p_attribute25_o
761: => pqh_asa_shd.g_old_rec.attribute25
762: ,p_attribute26_o
763: => pqh_asa_shd.g_old_rec.attribute26
757: => pqh_asa_shd.g_old_rec.attribute23
758: ,p_attribute24_o
759: => pqh_asa_shd.g_old_rec.attribute24
760: ,p_attribute25_o
761: => pqh_asa_shd.g_old_rec.attribute25
762: ,p_attribute26_o
763: => pqh_asa_shd.g_old_rec.attribute26
764: ,p_attribute27_o
765: => pqh_asa_shd.g_old_rec.attribute27
759: => pqh_asa_shd.g_old_rec.attribute24
760: ,p_attribute25_o
761: => pqh_asa_shd.g_old_rec.attribute25
762: ,p_attribute26_o
763: => pqh_asa_shd.g_old_rec.attribute26
764: ,p_attribute27_o
765: => pqh_asa_shd.g_old_rec.attribute27
766: ,p_attribute28_o
767: => pqh_asa_shd.g_old_rec.attribute28
761: => pqh_asa_shd.g_old_rec.attribute25
762: ,p_attribute26_o
763: => pqh_asa_shd.g_old_rec.attribute26
764: ,p_attribute27_o
765: => pqh_asa_shd.g_old_rec.attribute27
766: ,p_attribute28_o
767: => pqh_asa_shd.g_old_rec.attribute28
768: ,p_attribute29_o
769: => pqh_asa_shd.g_old_rec.attribute29
763: => pqh_asa_shd.g_old_rec.attribute26
764: ,p_attribute27_o
765: => pqh_asa_shd.g_old_rec.attribute27
766: ,p_attribute28_o
767: => pqh_asa_shd.g_old_rec.attribute28
768: ,p_attribute29_o
769: => pqh_asa_shd.g_old_rec.attribute29
770: ,p_attribute30_o
771: => pqh_asa_shd.g_old_rec.attribute30
765: => pqh_asa_shd.g_old_rec.attribute27
766: ,p_attribute28_o
767: => pqh_asa_shd.g_old_rec.attribute28
768: ,p_attribute29_o
769: => pqh_asa_shd.g_old_rec.attribute29
770: ,p_attribute30_o
771: => pqh_asa_shd.g_old_rec.attribute30
772: ,p_object_version_number_o
773: => pqh_asa_shd.g_old_rec.object_version_number
767: => pqh_asa_shd.g_old_rec.attribute28
768: ,p_attribute29_o
769: => pqh_asa_shd.g_old_rec.attribute29
770: ,p_attribute30_o
771: => pqh_asa_shd.g_old_rec.attribute30
772: ,p_object_version_number_o
773: => pqh_asa_shd.g_old_rec.object_version_number
774: ,p_reason_for_no_acco_o
775: => pqh_asa_shd.g_old_rec.reason_for_no_acco
769: => pqh_asa_shd.g_old_rec.attribute29
770: ,p_attribute30_o
771: => pqh_asa_shd.g_old_rec.attribute30
772: ,p_object_version_number_o
773: => pqh_asa_shd.g_old_rec.object_version_number
774: ,p_reason_for_no_acco_o
775: => pqh_asa_shd.g_old_rec.reason_for_no_acco
776: ,p_indemnity_currency_o
777: => pqh_asa_shd.g_old_rec.indemnity_currency
771: => pqh_asa_shd.g_old_rec.attribute30
772: ,p_object_version_number_o
773: => pqh_asa_shd.g_old_rec.object_version_number
774: ,p_reason_for_no_acco_o
775: => pqh_asa_shd.g_old_rec.reason_for_no_acco
776: ,p_indemnity_currency_o
777: => pqh_asa_shd.g_old_rec.indemnity_currency
778: );
779: --
773: => pqh_asa_shd.g_old_rec.object_version_number
774: ,p_reason_for_no_acco_o
775: => pqh_asa_shd.g_old_rec.reason_for_no_acco
776: ,p_indemnity_currency_o
777: => pqh_asa_shd.g_old_rec.indemnity_currency
778: );
779: --
780: exception
781: --
833: --
834: -- {End Of Comments}
835: -- ----------------------------------------------------------------------------
836: Procedure convert_defs
837: (p_rec in out nocopy pqh_asa_shd.g_rec_type
838: ) is
839: --
840: Begin
841: --
845: -- is being used then we must set to the 'current' argument value.
846: --
847: If (p_rec.business_group_id = hr_api.g_number) then
848: p_rec.business_group_id :=
849: pqh_asa_shd.g_old_rec.business_group_id;
850: End If;
851: If (p_rec.assignment_id = hr_api.g_number) then
852: p_rec.assignment_id :=
853: pqh_asa_shd.g_old_rec.assignment_id;
849: pqh_asa_shd.g_old_rec.business_group_id;
850: End If;
851: If (p_rec.assignment_id = hr_api.g_number) then
852: p_rec.assignment_id :=
853: pqh_asa_shd.g_old_rec.assignment_id;
854: End If;
855: If (p_rec.accommodation_given = hr_api.g_varchar2) then
856: p_rec.accommodation_given :=
857: pqh_asa_shd.g_old_rec.accommodation_given;
853: pqh_asa_shd.g_old_rec.assignment_id;
854: End If;
855: If (p_rec.accommodation_given = hr_api.g_varchar2) then
856: p_rec.accommodation_given :=
857: pqh_asa_shd.g_old_rec.accommodation_given;
858: End If;
859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then
860: p_rec.temporary_assignment :=
861: pqh_asa_shd.g_old_rec.temporary_assignment;
857: pqh_asa_shd.g_old_rec.accommodation_given;
858: End If;
859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then
860: p_rec.temporary_assignment :=
861: pqh_asa_shd.g_old_rec.temporary_assignment;
862: End If;
863: If (p_rec.accommodation_id = hr_api.g_number) then
864: p_rec.accommodation_id :=
865: pqh_asa_shd.g_old_rec.accommodation_id;
861: pqh_asa_shd.g_old_rec.temporary_assignment;
862: End If;
863: If (p_rec.accommodation_id = hr_api.g_number) then
864: p_rec.accommodation_id :=
865: pqh_asa_shd.g_old_rec.accommodation_id;
866: End If;
867: If (p_rec.acceptance_date = hr_api.g_date) then
868: p_rec.acceptance_date :=
869: pqh_asa_shd.g_old_rec.acceptance_date;
865: pqh_asa_shd.g_old_rec.accommodation_id;
866: End If;
867: If (p_rec.acceptance_date = hr_api.g_date) then
868: p_rec.acceptance_date :=
869: pqh_asa_shd.g_old_rec.acceptance_date;
870: End If;
871: If (p_rec.moving_date = hr_api.g_date) then
872: p_rec.moving_date :=
873: pqh_asa_shd.g_old_rec.moving_date;
869: pqh_asa_shd.g_old_rec.acceptance_date;
870: End If;
871: If (p_rec.moving_date = hr_api.g_date) then
872: p_rec.moving_date :=
873: pqh_asa_shd.g_old_rec.moving_date;
874: End If;
875: If (p_rec.refusal_date = hr_api.g_date) then
876: p_rec.refusal_date :=
877: pqh_asa_shd.g_old_rec.refusal_date;
873: pqh_asa_shd.g_old_rec.moving_date;
874: End If;
875: If (p_rec.refusal_date = hr_api.g_date) then
876: p_rec.refusal_date :=
877: pqh_asa_shd.g_old_rec.refusal_date;
878: End If;
879: If (p_rec.comments = hr_api.g_varchar2) then
880: p_rec.comments :=
881: pqh_asa_shd.g_old_rec.comments;
877: pqh_asa_shd.g_old_rec.refusal_date;
878: End If;
879: If (p_rec.comments = hr_api.g_varchar2) then
880: p_rec.comments :=
881: pqh_asa_shd.g_old_rec.comments;
882: End If;
883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then
884: p_rec.indemnity_entitlement :=
885: pqh_asa_shd.g_old_rec.indemnity_entitlement;
881: pqh_asa_shd.g_old_rec.comments;
882: End If;
883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then
884: p_rec.indemnity_entitlement :=
885: pqh_asa_shd.g_old_rec.indemnity_entitlement;
886: End If;
887: If (p_rec.indemnity_amount = hr_api.g_number) then
888: p_rec.indemnity_amount :=
889: pqh_asa_shd.g_old_rec.indemnity_amount;
885: pqh_asa_shd.g_old_rec.indemnity_entitlement;
886: End If;
887: If (p_rec.indemnity_amount = hr_api.g_number) then
888: p_rec.indemnity_amount :=
889: pqh_asa_shd.g_old_rec.indemnity_amount;
890: End If;
891: If (p_rec.type_of_payment = hr_api.g_varchar2) then
892: p_rec.type_of_payment :=
893: pqh_asa_shd.g_old_rec.type_of_payment;
889: pqh_asa_shd.g_old_rec.indemnity_amount;
890: End If;
891: If (p_rec.type_of_payment = hr_api.g_varchar2) then
892: p_rec.type_of_payment :=
893: pqh_asa_shd.g_old_rec.type_of_payment;
894: End If;
895: If (p_rec.information_category = hr_api.g_varchar2) then
896: p_rec.information_category :=
897: pqh_asa_shd.g_old_rec.information_category;
893: pqh_asa_shd.g_old_rec.type_of_payment;
894: End If;
895: If (p_rec.information_category = hr_api.g_varchar2) then
896: p_rec.information_category :=
897: pqh_asa_shd.g_old_rec.information_category;
898: End If;
899: If (p_rec.information1 = hr_api.g_varchar2) then
900: p_rec.information1 :=
901: pqh_asa_shd.g_old_rec.information1;
897: pqh_asa_shd.g_old_rec.information_category;
898: End If;
899: If (p_rec.information1 = hr_api.g_varchar2) then
900: p_rec.information1 :=
901: pqh_asa_shd.g_old_rec.information1;
902: End If;
903: If (p_rec.information2 = hr_api.g_varchar2) then
904: p_rec.information2 :=
905: pqh_asa_shd.g_old_rec.information2;
901: pqh_asa_shd.g_old_rec.information1;
902: End If;
903: If (p_rec.information2 = hr_api.g_varchar2) then
904: p_rec.information2 :=
905: pqh_asa_shd.g_old_rec.information2;
906: End If;
907: If (p_rec.information3 = hr_api.g_varchar2) then
908: p_rec.information3 :=
909: pqh_asa_shd.g_old_rec.information3;
905: pqh_asa_shd.g_old_rec.information2;
906: End If;
907: If (p_rec.information3 = hr_api.g_varchar2) then
908: p_rec.information3 :=
909: pqh_asa_shd.g_old_rec.information3;
910: End If;
911: If (p_rec.information4 = hr_api.g_varchar2) then
912: p_rec.information4 :=
913: pqh_asa_shd.g_old_rec.information4;
909: pqh_asa_shd.g_old_rec.information3;
910: End If;
911: If (p_rec.information4 = hr_api.g_varchar2) then
912: p_rec.information4 :=
913: pqh_asa_shd.g_old_rec.information4;
914: End If;
915: If (p_rec.information5 = hr_api.g_varchar2) then
916: p_rec.information5 :=
917: pqh_asa_shd.g_old_rec.information5;
913: pqh_asa_shd.g_old_rec.information4;
914: End If;
915: If (p_rec.information5 = hr_api.g_varchar2) then
916: p_rec.information5 :=
917: pqh_asa_shd.g_old_rec.information5;
918: End If;
919: If (p_rec.information6 = hr_api.g_varchar2) then
920: p_rec.information6 :=
921: pqh_asa_shd.g_old_rec.information6;
917: pqh_asa_shd.g_old_rec.information5;
918: End If;
919: If (p_rec.information6 = hr_api.g_varchar2) then
920: p_rec.information6 :=
921: pqh_asa_shd.g_old_rec.information6;
922: End If;
923: If (p_rec.information7 = hr_api.g_varchar2) then
924: p_rec.information7 :=
925: pqh_asa_shd.g_old_rec.information7;
921: pqh_asa_shd.g_old_rec.information6;
922: End If;
923: If (p_rec.information7 = hr_api.g_varchar2) then
924: p_rec.information7 :=
925: pqh_asa_shd.g_old_rec.information7;
926: End If;
927: If (p_rec.information8 = hr_api.g_varchar2) then
928: p_rec.information8 :=
929: pqh_asa_shd.g_old_rec.information8;
925: pqh_asa_shd.g_old_rec.information7;
926: End If;
927: If (p_rec.information8 = hr_api.g_varchar2) then
928: p_rec.information8 :=
929: pqh_asa_shd.g_old_rec.information8;
930: End If;
931: If (p_rec.information9 = hr_api.g_varchar2) then
932: p_rec.information9 :=
933: pqh_asa_shd.g_old_rec.information9;
929: pqh_asa_shd.g_old_rec.information8;
930: End If;
931: If (p_rec.information9 = hr_api.g_varchar2) then
932: p_rec.information9 :=
933: pqh_asa_shd.g_old_rec.information9;
934: End If;
935: If (p_rec.information10 = hr_api.g_varchar2) then
936: p_rec.information10 :=
937: pqh_asa_shd.g_old_rec.information10;
933: pqh_asa_shd.g_old_rec.information9;
934: End If;
935: If (p_rec.information10 = hr_api.g_varchar2) then
936: p_rec.information10 :=
937: pqh_asa_shd.g_old_rec.information10;
938: End If;
939: If (p_rec.information11 = hr_api.g_varchar2) then
940: p_rec.information11 :=
941: pqh_asa_shd.g_old_rec.information11;
937: pqh_asa_shd.g_old_rec.information10;
938: End If;
939: If (p_rec.information11 = hr_api.g_varchar2) then
940: p_rec.information11 :=
941: pqh_asa_shd.g_old_rec.information11;
942: End If;
943: If (p_rec.information12 = hr_api.g_varchar2) then
944: p_rec.information12 :=
945: pqh_asa_shd.g_old_rec.information12;
941: pqh_asa_shd.g_old_rec.information11;
942: End If;
943: If (p_rec.information12 = hr_api.g_varchar2) then
944: p_rec.information12 :=
945: pqh_asa_shd.g_old_rec.information12;
946: End If;
947: If (p_rec.information13 = hr_api.g_varchar2) then
948: p_rec.information13 :=
949: pqh_asa_shd.g_old_rec.information13;
945: pqh_asa_shd.g_old_rec.information12;
946: End If;
947: If (p_rec.information13 = hr_api.g_varchar2) then
948: p_rec.information13 :=
949: pqh_asa_shd.g_old_rec.information13;
950: End If;
951: If (p_rec.information14 = hr_api.g_varchar2) then
952: p_rec.information14 :=
953: pqh_asa_shd.g_old_rec.information14;
949: pqh_asa_shd.g_old_rec.information13;
950: End If;
951: If (p_rec.information14 = hr_api.g_varchar2) then
952: p_rec.information14 :=
953: pqh_asa_shd.g_old_rec.information14;
954: End If;
955: If (p_rec.information15 = hr_api.g_varchar2) then
956: p_rec.information15 :=
957: pqh_asa_shd.g_old_rec.information15;
953: pqh_asa_shd.g_old_rec.information14;
954: End If;
955: If (p_rec.information15 = hr_api.g_varchar2) then
956: p_rec.information15 :=
957: pqh_asa_shd.g_old_rec.information15;
958: End If;
959: If (p_rec.information16 = hr_api.g_varchar2) then
960: p_rec.information16 :=
961: pqh_asa_shd.g_old_rec.information16;
957: pqh_asa_shd.g_old_rec.information15;
958: End If;
959: If (p_rec.information16 = hr_api.g_varchar2) then
960: p_rec.information16 :=
961: pqh_asa_shd.g_old_rec.information16;
962: End If;
963: If (p_rec.information17 = hr_api.g_varchar2) then
964: p_rec.information17 :=
965: pqh_asa_shd.g_old_rec.information17;
961: pqh_asa_shd.g_old_rec.information16;
962: End If;
963: If (p_rec.information17 = hr_api.g_varchar2) then
964: p_rec.information17 :=
965: pqh_asa_shd.g_old_rec.information17;
966: End If;
967: If (p_rec.information18 = hr_api.g_varchar2) then
968: p_rec.information18 :=
969: pqh_asa_shd.g_old_rec.information18;
965: pqh_asa_shd.g_old_rec.information17;
966: End If;
967: If (p_rec.information18 = hr_api.g_varchar2) then
968: p_rec.information18 :=
969: pqh_asa_shd.g_old_rec.information18;
970: End If;
971: If (p_rec.information19 = hr_api.g_varchar2) then
972: p_rec.information19 :=
973: pqh_asa_shd.g_old_rec.information19;
969: pqh_asa_shd.g_old_rec.information18;
970: End If;
971: If (p_rec.information19 = hr_api.g_varchar2) then
972: p_rec.information19 :=
973: pqh_asa_shd.g_old_rec.information19;
974: End If;
975: If (p_rec.information20 = hr_api.g_varchar2) then
976: p_rec.information20 :=
977: pqh_asa_shd.g_old_rec.information20;
973: pqh_asa_shd.g_old_rec.information19;
974: End If;
975: If (p_rec.information20 = hr_api.g_varchar2) then
976: p_rec.information20 :=
977: pqh_asa_shd.g_old_rec.information20;
978: End If;
979: If (p_rec.information21 = hr_api.g_varchar2) then
980: p_rec.information21 :=
981: pqh_asa_shd.g_old_rec.information21;
977: pqh_asa_shd.g_old_rec.information20;
978: End If;
979: If (p_rec.information21 = hr_api.g_varchar2) then
980: p_rec.information21 :=
981: pqh_asa_shd.g_old_rec.information21;
982: End If;
983: If (p_rec.information22 = hr_api.g_varchar2) then
984: p_rec.information22 :=
985: pqh_asa_shd.g_old_rec.information22;
981: pqh_asa_shd.g_old_rec.information21;
982: End If;
983: If (p_rec.information22 = hr_api.g_varchar2) then
984: p_rec.information22 :=
985: pqh_asa_shd.g_old_rec.information22;
986: End If;
987: If (p_rec.information23 = hr_api.g_varchar2) then
988: p_rec.information23 :=
989: pqh_asa_shd.g_old_rec.information23;
985: pqh_asa_shd.g_old_rec.information22;
986: End If;
987: If (p_rec.information23 = hr_api.g_varchar2) then
988: p_rec.information23 :=
989: pqh_asa_shd.g_old_rec.information23;
990: End If;
991: If (p_rec.information24 = hr_api.g_varchar2) then
992: p_rec.information24 :=
993: pqh_asa_shd.g_old_rec.information24;
989: pqh_asa_shd.g_old_rec.information23;
990: End If;
991: If (p_rec.information24 = hr_api.g_varchar2) then
992: p_rec.information24 :=
993: pqh_asa_shd.g_old_rec.information24;
994: End If;
995: If (p_rec.information25 = hr_api.g_varchar2) then
996: p_rec.information25 :=
997: pqh_asa_shd.g_old_rec.information25;
993: pqh_asa_shd.g_old_rec.information24;
994: End If;
995: If (p_rec.information25 = hr_api.g_varchar2) then
996: p_rec.information25 :=
997: pqh_asa_shd.g_old_rec.information25;
998: End If;
999: If (p_rec.information26 = hr_api.g_varchar2) then
1000: p_rec.information26 :=
1001: pqh_asa_shd.g_old_rec.information26;
997: pqh_asa_shd.g_old_rec.information25;
998: End If;
999: If (p_rec.information26 = hr_api.g_varchar2) then
1000: p_rec.information26 :=
1001: pqh_asa_shd.g_old_rec.information26;
1002: End If;
1003: If (p_rec.information27 = hr_api.g_varchar2) then
1004: p_rec.information27 :=
1005: pqh_asa_shd.g_old_rec.information27;
1001: pqh_asa_shd.g_old_rec.information26;
1002: End If;
1003: If (p_rec.information27 = hr_api.g_varchar2) then
1004: p_rec.information27 :=
1005: pqh_asa_shd.g_old_rec.information27;
1006: End If;
1007: If (p_rec.information28 = hr_api.g_varchar2) then
1008: p_rec.information28 :=
1009: pqh_asa_shd.g_old_rec.information28;
1005: pqh_asa_shd.g_old_rec.information27;
1006: End If;
1007: If (p_rec.information28 = hr_api.g_varchar2) then
1008: p_rec.information28 :=
1009: pqh_asa_shd.g_old_rec.information28;
1010: End If;
1011: If (p_rec.information29 = hr_api.g_varchar2) then
1012: p_rec.information29 :=
1013: pqh_asa_shd.g_old_rec.information29;
1009: pqh_asa_shd.g_old_rec.information28;
1010: End If;
1011: If (p_rec.information29 = hr_api.g_varchar2) then
1012: p_rec.information29 :=
1013: pqh_asa_shd.g_old_rec.information29;
1014: End If;
1015: If (p_rec.information30 = hr_api.g_varchar2) then
1016: p_rec.information30 :=
1017: pqh_asa_shd.g_old_rec.information30;
1013: pqh_asa_shd.g_old_rec.information29;
1014: End If;
1015: If (p_rec.information30 = hr_api.g_varchar2) then
1016: p_rec.information30 :=
1017: pqh_asa_shd.g_old_rec.information30;
1018: End If;
1019: If (p_rec.attribute_category = hr_api.g_varchar2) then
1020: p_rec.attribute_category :=
1021: pqh_asa_shd.g_old_rec.attribute_category;
1017: pqh_asa_shd.g_old_rec.information30;
1018: End If;
1019: If (p_rec.attribute_category = hr_api.g_varchar2) then
1020: p_rec.attribute_category :=
1021: pqh_asa_shd.g_old_rec.attribute_category;
1022: End If;
1023: If (p_rec.attribute1 = hr_api.g_varchar2) then
1024: p_rec.attribute1 :=
1025: pqh_asa_shd.g_old_rec.attribute1;
1021: pqh_asa_shd.g_old_rec.attribute_category;
1022: End If;
1023: If (p_rec.attribute1 = hr_api.g_varchar2) then
1024: p_rec.attribute1 :=
1025: pqh_asa_shd.g_old_rec.attribute1;
1026: End If;
1027: If (p_rec.attribute2 = hr_api.g_varchar2) then
1028: p_rec.attribute2 :=
1029: pqh_asa_shd.g_old_rec.attribute2;
1025: pqh_asa_shd.g_old_rec.attribute1;
1026: End If;
1027: If (p_rec.attribute2 = hr_api.g_varchar2) then
1028: p_rec.attribute2 :=
1029: pqh_asa_shd.g_old_rec.attribute2;
1030: End If;
1031: If (p_rec.attribute3 = hr_api.g_varchar2) then
1032: p_rec.attribute3 :=
1033: pqh_asa_shd.g_old_rec.attribute3;
1029: pqh_asa_shd.g_old_rec.attribute2;
1030: End If;
1031: If (p_rec.attribute3 = hr_api.g_varchar2) then
1032: p_rec.attribute3 :=
1033: pqh_asa_shd.g_old_rec.attribute3;
1034: End If;
1035: If (p_rec.attribute4 = hr_api.g_varchar2) then
1036: p_rec.attribute4 :=
1037: pqh_asa_shd.g_old_rec.attribute4;
1033: pqh_asa_shd.g_old_rec.attribute3;
1034: End If;
1035: If (p_rec.attribute4 = hr_api.g_varchar2) then
1036: p_rec.attribute4 :=
1037: pqh_asa_shd.g_old_rec.attribute4;
1038: End If;
1039: If (p_rec.attribute5 = hr_api.g_varchar2) then
1040: p_rec.attribute5 :=
1041: pqh_asa_shd.g_old_rec.attribute5;
1037: pqh_asa_shd.g_old_rec.attribute4;
1038: End If;
1039: If (p_rec.attribute5 = hr_api.g_varchar2) then
1040: p_rec.attribute5 :=
1041: pqh_asa_shd.g_old_rec.attribute5;
1042: End If;
1043: If (p_rec.attribute6 = hr_api.g_varchar2) then
1044: p_rec.attribute6 :=
1045: pqh_asa_shd.g_old_rec.attribute6;
1041: pqh_asa_shd.g_old_rec.attribute5;
1042: End If;
1043: If (p_rec.attribute6 = hr_api.g_varchar2) then
1044: p_rec.attribute6 :=
1045: pqh_asa_shd.g_old_rec.attribute6;
1046: End If;
1047: If (p_rec.attribute7 = hr_api.g_varchar2) then
1048: p_rec.attribute7 :=
1049: pqh_asa_shd.g_old_rec.attribute7;
1045: pqh_asa_shd.g_old_rec.attribute6;
1046: End If;
1047: If (p_rec.attribute7 = hr_api.g_varchar2) then
1048: p_rec.attribute7 :=
1049: pqh_asa_shd.g_old_rec.attribute7;
1050: End If;
1051: If (p_rec.attribute8 = hr_api.g_varchar2) then
1052: p_rec.attribute8 :=
1053: pqh_asa_shd.g_old_rec.attribute8;
1049: pqh_asa_shd.g_old_rec.attribute7;
1050: End If;
1051: If (p_rec.attribute8 = hr_api.g_varchar2) then
1052: p_rec.attribute8 :=
1053: pqh_asa_shd.g_old_rec.attribute8;
1054: End If;
1055: If (p_rec.attribute9 = hr_api.g_varchar2) then
1056: p_rec.attribute9 :=
1057: pqh_asa_shd.g_old_rec.attribute9;
1053: pqh_asa_shd.g_old_rec.attribute8;
1054: End If;
1055: If (p_rec.attribute9 = hr_api.g_varchar2) then
1056: p_rec.attribute9 :=
1057: pqh_asa_shd.g_old_rec.attribute9;
1058: End If;
1059: If (p_rec.attribute10 = hr_api.g_varchar2) then
1060: p_rec.attribute10 :=
1061: pqh_asa_shd.g_old_rec.attribute10;
1057: pqh_asa_shd.g_old_rec.attribute9;
1058: End If;
1059: If (p_rec.attribute10 = hr_api.g_varchar2) then
1060: p_rec.attribute10 :=
1061: pqh_asa_shd.g_old_rec.attribute10;
1062: End If;
1063: If (p_rec.attribute11 = hr_api.g_varchar2) then
1064: p_rec.attribute11 :=
1065: pqh_asa_shd.g_old_rec.attribute11;
1061: pqh_asa_shd.g_old_rec.attribute10;
1062: End If;
1063: If (p_rec.attribute11 = hr_api.g_varchar2) then
1064: p_rec.attribute11 :=
1065: pqh_asa_shd.g_old_rec.attribute11;
1066: End If;
1067: If (p_rec.attribute12 = hr_api.g_varchar2) then
1068: p_rec.attribute12 :=
1069: pqh_asa_shd.g_old_rec.attribute12;
1065: pqh_asa_shd.g_old_rec.attribute11;
1066: End If;
1067: If (p_rec.attribute12 = hr_api.g_varchar2) then
1068: p_rec.attribute12 :=
1069: pqh_asa_shd.g_old_rec.attribute12;
1070: End If;
1071: If (p_rec.attribute13 = hr_api.g_varchar2) then
1072: p_rec.attribute13 :=
1073: pqh_asa_shd.g_old_rec.attribute13;
1069: pqh_asa_shd.g_old_rec.attribute12;
1070: End If;
1071: If (p_rec.attribute13 = hr_api.g_varchar2) then
1072: p_rec.attribute13 :=
1073: pqh_asa_shd.g_old_rec.attribute13;
1074: End If;
1075: If (p_rec.attribute14 = hr_api.g_varchar2) then
1076: p_rec.attribute14 :=
1077: pqh_asa_shd.g_old_rec.attribute14;
1073: pqh_asa_shd.g_old_rec.attribute13;
1074: End If;
1075: If (p_rec.attribute14 = hr_api.g_varchar2) then
1076: p_rec.attribute14 :=
1077: pqh_asa_shd.g_old_rec.attribute14;
1078: End If;
1079: If (p_rec.attribute15 = hr_api.g_varchar2) then
1080: p_rec.attribute15 :=
1081: pqh_asa_shd.g_old_rec.attribute15;
1077: pqh_asa_shd.g_old_rec.attribute14;
1078: End If;
1079: If (p_rec.attribute15 = hr_api.g_varchar2) then
1080: p_rec.attribute15 :=
1081: pqh_asa_shd.g_old_rec.attribute15;
1082: End If;
1083: If (p_rec.attribute16 = hr_api.g_varchar2) then
1084: p_rec.attribute16 :=
1085: pqh_asa_shd.g_old_rec.attribute16;
1081: pqh_asa_shd.g_old_rec.attribute15;
1082: End If;
1083: If (p_rec.attribute16 = hr_api.g_varchar2) then
1084: p_rec.attribute16 :=
1085: pqh_asa_shd.g_old_rec.attribute16;
1086: End If;
1087: If (p_rec.attribute17 = hr_api.g_varchar2) then
1088: p_rec.attribute17 :=
1089: pqh_asa_shd.g_old_rec.attribute17;
1085: pqh_asa_shd.g_old_rec.attribute16;
1086: End If;
1087: If (p_rec.attribute17 = hr_api.g_varchar2) then
1088: p_rec.attribute17 :=
1089: pqh_asa_shd.g_old_rec.attribute17;
1090: End If;
1091: If (p_rec.attribute18 = hr_api.g_varchar2) then
1092: p_rec.attribute18 :=
1093: pqh_asa_shd.g_old_rec.attribute18;
1089: pqh_asa_shd.g_old_rec.attribute17;
1090: End If;
1091: If (p_rec.attribute18 = hr_api.g_varchar2) then
1092: p_rec.attribute18 :=
1093: pqh_asa_shd.g_old_rec.attribute18;
1094: End If;
1095: If (p_rec.attribute19 = hr_api.g_varchar2) then
1096: p_rec.attribute19 :=
1097: pqh_asa_shd.g_old_rec.attribute19;
1093: pqh_asa_shd.g_old_rec.attribute18;
1094: End If;
1095: If (p_rec.attribute19 = hr_api.g_varchar2) then
1096: p_rec.attribute19 :=
1097: pqh_asa_shd.g_old_rec.attribute19;
1098: End If;
1099: If (p_rec.attribute20 = hr_api.g_varchar2) then
1100: p_rec.attribute20 :=
1101: pqh_asa_shd.g_old_rec.attribute20;
1097: pqh_asa_shd.g_old_rec.attribute19;
1098: End If;
1099: If (p_rec.attribute20 = hr_api.g_varchar2) then
1100: p_rec.attribute20 :=
1101: pqh_asa_shd.g_old_rec.attribute20;
1102: End If;
1103: If (p_rec.attribute21 = hr_api.g_varchar2) then
1104: p_rec.attribute21 :=
1105: pqh_asa_shd.g_old_rec.attribute21;
1101: pqh_asa_shd.g_old_rec.attribute20;
1102: End If;
1103: If (p_rec.attribute21 = hr_api.g_varchar2) then
1104: p_rec.attribute21 :=
1105: pqh_asa_shd.g_old_rec.attribute21;
1106: End If;
1107: If (p_rec.attribute22 = hr_api.g_varchar2) then
1108: p_rec.attribute22 :=
1109: pqh_asa_shd.g_old_rec.attribute22;
1105: pqh_asa_shd.g_old_rec.attribute21;
1106: End If;
1107: If (p_rec.attribute22 = hr_api.g_varchar2) then
1108: p_rec.attribute22 :=
1109: pqh_asa_shd.g_old_rec.attribute22;
1110: End If;
1111: If (p_rec.attribute23 = hr_api.g_varchar2) then
1112: p_rec.attribute23 :=
1113: pqh_asa_shd.g_old_rec.attribute23;
1109: pqh_asa_shd.g_old_rec.attribute22;
1110: End If;
1111: If (p_rec.attribute23 = hr_api.g_varchar2) then
1112: p_rec.attribute23 :=
1113: pqh_asa_shd.g_old_rec.attribute23;
1114: End If;
1115: If (p_rec.attribute24 = hr_api.g_varchar2) then
1116: p_rec.attribute24 :=
1117: pqh_asa_shd.g_old_rec.attribute24;
1113: pqh_asa_shd.g_old_rec.attribute23;
1114: End If;
1115: If (p_rec.attribute24 = hr_api.g_varchar2) then
1116: p_rec.attribute24 :=
1117: pqh_asa_shd.g_old_rec.attribute24;
1118: End If;
1119: If (p_rec.attribute25 = hr_api.g_varchar2) then
1120: p_rec.attribute25 :=
1121: pqh_asa_shd.g_old_rec.attribute25;
1117: pqh_asa_shd.g_old_rec.attribute24;
1118: End If;
1119: If (p_rec.attribute25 = hr_api.g_varchar2) then
1120: p_rec.attribute25 :=
1121: pqh_asa_shd.g_old_rec.attribute25;
1122: End If;
1123: If (p_rec.attribute26 = hr_api.g_varchar2) then
1124: p_rec.attribute26 :=
1125: pqh_asa_shd.g_old_rec.attribute26;
1121: pqh_asa_shd.g_old_rec.attribute25;
1122: End If;
1123: If (p_rec.attribute26 = hr_api.g_varchar2) then
1124: p_rec.attribute26 :=
1125: pqh_asa_shd.g_old_rec.attribute26;
1126: End If;
1127: If (p_rec.attribute27 = hr_api.g_varchar2) then
1128: p_rec.attribute27 :=
1129: pqh_asa_shd.g_old_rec.attribute27;
1125: pqh_asa_shd.g_old_rec.attribute26;
1126: End If;
1127: If (p_rec.attribute27 = hr_api.g_varchar2) then
1128: p_rec.attribute27 :=
1129: pqh_asa_shd.g_old_rec.attribute27;
1130: End If;
1131: If (p_rec.attribute28 = hr_api.g_varchar2) then
1132: p_rec.attribute28 :=
1133: pqh_asa_shd.g_old_rec.attribute28;
1129: pqh_asa_shd.g_old_rec.attribute27;
1130: End If;
1131: If (p_rec.attribute28 = hr_api.g_varchar2) then
1132: p_rec.attribute28 :=
1133: pqh_asa_shd.g_old_rec.attribute28;
1134: End If;
1135: If (p_rec.attribute29 = hr_api.g_varchar2) then
1136: p_rec.attribute29 :=
1137: pqh_asa_shd.g_old_rec.attribute29;
1133: pqh_asa_shd.g_old_rec.attribute28;
1134: End If;
1135: If (p_rec.attribute29 = hr_api.g_varchar2) then
1136: p_rec.attribute29 :=
1137: pqh_asa_shd.g_old_rec.attribute29;
1138: End If;
1139: If (p_rec.attribute30 = hr_api.g_varchar2) then
1140: p_rec.attribute30 :=
1141: pqh_asa_shd.g_old_rec.attribute30;
1137: pqh_asa_shd.g_old_rec.attribute29;
1138: End If;
1139: If (p_rec.attribute30 = hr_api.g_varchar2) then
1140: p_rec.attribute30 :=
1141: pqh_asa_shd.g_old_rec.attribute30;
1142: End If;
1143: If (p_rec.reason_for_no_acco = hr_api.g_varchar2) then
1144: p_rec.reason_for_no_acco :=
1145: pqh_asa_shd.g_old_rec.reason_for_no_acco;
1141: pqh_asa_shd.g_old_rec.attribute30;
1142: End If;
1143: If (p_rec.reason_for_no_acco = hr_api.g_varchar2) then
1144: p_rec.reason_for_no_acco :=
1145: pqh_asa_shd.g_old_rec.reason_for_no_acco;
1146: End If;
1147: If (p_rec.indemnity_currency = hr_api.g_varchar2) then
1148: p_rec.indemnity_currency :=
1149: pqh_asa_shd.g_old_rec.indemnity_currency;
1145: pqh_asa_shd.g_old_rec.reason_for_no_acco;
1146: End If;
1147: If (p_rec.indemnity_currency = hr_api.g_varchar2) then
1148: p_rec.indemnity_currency :=
1149: pqh_asa_shd.g_old_rec.indemnity_currency;
1150: End If;
1151: --
1152: End convert_defs;
1153: --
1156: -- ----------------------------------------------------------------------------
1157: Procedure upd
1158: (p_effective_date in date
1159: ,p_datetrack_mode in varchar2
1160: ,p_rec in out nocopy pqh_asa_shd.g_rec_type
1161: ) is
1162: --
1163: l_proc varchar2(72) := g_package||'upd';
1164: l_validation_start_date date;
1172: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1173: --
1174: -- We must lock the row which we need to update.
1175: --
1176: pqh_asa_shd.lck
1177: (p_effective_date => p_effective_date
1178: ,p_datetrack_mode => p_datetrack_mode
1179: ,p_assignment_acco_id => p_rec.assignment_acco_id
1180: ,p_object_version_number => p_rec.object_version_number
1322: ,p_effective_start_date out nocopy date
1323: ,p_effective_end_date out nocopy date
1324: ) is
1325: --
1326: l_rec pqh_asa_shd.g_rec_type;
1327: l_proc varchar2(72) := g_package||'upd';
1328: --
1329: Begin
1330: hr_utility.set_location('Entering:'||l_proc, 5);
1332: -- Call conversion function to turn arguments into the
1333: -- l_rec structure.
1334: --
1335: l_rec :=
1336: pqh_asa_shd.convert_args
1337: (p_assignment_acco_id
1338: ,null
1339: ,null
1340: ,p_business_group_id