54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqh_acc_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
194: Exception
195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
197: --
198: pqh_acc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: pqh_acc_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: --
207: Raise;
238: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure update_dml
242: (p_rec in out nocopy pqh_acc_shd.g_rec_type
243: ,p_effective_date in date
244: ,p_datetrack_mode in varchar2
245: ,p_validation_start_date in date
246: ,p_validation_end_date in date
305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure dt_pre_update
309: (p_rec in out nocopy pqh_acc_shd.g_rec_type
310: ,p_effective_date in date
311: ,p_datetrack_mode in varchar2
312: ,p_validation_start_date in date
313: ,p_validation_end_date in date
321: If (p_datetrack_mode <> hr_api.g_correction) then
322: --
323: -- Update the current effective end date
324: --
325: pqh_acc_shd.upd_effective_end_date
326: (p_effective_date => p_effective_date
327: ,p_base_key_value => p_rec.accommodation_id
328: ,p_new_effective_end_date => (p_validation_start_date - 1)
329: ,p_validation_start_date => p_validation_start_date
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure pre_update
394: (p_rec in out nocopy pqh_acc_shd.g_rec_type
395: ,p_effective_date in date
396: ,p_datetrack_mode in varchar2
397: ,p_validation_start_date in date
398: ,p_validation_end_date in date
448: --
449: -- {End Of Comments}
450: -- ----------------------------------------------------------------------------
451: Procedure post_update
452: (p_rec in pqh_acc_shd.g_rec_type
453: ,p_effective_date in date
454: ,p_datetrack_mode in varchar2
455: ,p_validation_start_date in date
456: ,p_validation_end_date in date
659: => p_rec.attribute30
660: ,p_object_version_number
661: => p_rec.object_version_number
662: ,p_accommodation_name_o
663: => pqh_acc_shd.g_old_rec.accommodation_name
664: ,p_effective_start_date_o
665: => pqh_acc_shd.g_old_rec.effective_start_date
666: ,p_effective_end_date_o
667: => pqh_acc_shd.g_old_rec.effective_end_date
661: => p_rec.object_version_number
662: ,p_accommodation_name_o
663: => pqh_acc_shd.g_old_rec.accommodation_name
664: ,p_effective_start_date_o
665: => pqh_acc_shd.g_old_rec.effective_start_date
666: ,p_effective_end_date_o
667: => pqh_acc_shd.g_old_rec.effective_end_date
668: ,p_business_group_id_o
669: => pqh_acc_shd.g_old_rec.business_group_id
663: => pqh_acc_shd.g_old_rec.accommodation_name
664: ,p_effective_start_date_o
665: => pqh_acc_shd.g_old_rec.effective_start_date
666: ,p_effective_end_date_o
667: => pqh_acc_shd.g_old_rec.effective_end_date
668: ,p_business_group_id_o
669: => pqh_acc_shd.g_old_rec.business_group_id
670: ,p_location_id_o
671: => pqh_acc_shd.g_old_rec.location_id
665: => pqh_acc_shd.g_old_rec.effective_start_date
666: ,p_effective_end_date_o
667: => pqh_acc_shd.g_old_rec.effective_end_date
668: ,p_business_group_id_o
669: => pqh_acc_shd.g_old_rec.business_group_id
670: ,p_location_id_o
671: => pqh_acc_shd.g_old_rec.location_id
672: ,p_accommodation_desc_o
673: => pqh_acc_shd.g_old_rec.accommodation_desc
667: => pqh_acc_shd.g_old_rec.effective_end_date
668: ,p_business_group_id_o
669: => pqh_acc_shd.g_old_rec.business_group_id
670: ,p_location_id_o
671: => pqh_acc_shd.g_old_rec.location_id
672: ,p_accommodation_desc_o
673: => pqh_acc_shd.g_old_rec.accommodation_desc
674: ,p_accommodation_type_o
675: => pqh_acc_shd.g_old_rec.accommodation_type
669: => pqh_acc_shd.g_old_rec.business_group_id
670: ,p_location_id_o
671: => pqh_acc_shd.g_old_rec.location_id
672: ,p_accommodation_desc_o
673: => pqh_acc_shd.g_old_rec.accommodation_desc
674: ,p_accommodation_type_o
675: => pqh_acc_shd.g_old_rec.accommodation_type
676: ,p_style_o
677: => pqh_acc_shd.g_old_rec.style
671: => pqh_acc_shd.g_old_rec.location_id
672: ,p_accommodation_desc_o
673: => pqh_acc_shd.g_old_rec.accommodation_desc
674: ,p_accommodation_type_o
675: => pqh_acc_shd.g_old_rec.accommodation_type
676: ,p_style_o
677: => pqh_acc_shd.g_old_rec.style
678: ,p_address_line_1_o
679: => pqh_acc_shd.g_old_rec.address_line_1
673: => pqh_acc_shd.g_old_rec.accommodation_desc
674: ,p_accommodation_type_o
675: => pqh_acc_shd.g_old_rec.accommodation_type
676: ,p_style_o
677: => pqh_acc_shd.g_old_rec.style
678: ,p_address_line_1_o
679: => pqh_acc_shd.g_old_rec.address_line_1
680: ,p_address_line_2_o
681: => pqh_acc_shd.g_old_rec.address_line_2
675: => pqh_acc_shd.g_old_rec.accommodation_type
676: ,p_style_o
677: => pqh_acc_shd.g_old_rec.style
678: ,p_address_line_1_o
679: => pqh_acc_shd.g_old_rec.address_line_1
680: ,p_address_line_2_o
681: => pqh_acc_shd.g_old_rec.address_line_2
682: ,p_address_line_3_o
683: => pqh_acc_shd.g_old_rec.address_line_3
677: => pqh_acc_shd.g_old_rec.style
678: ,p_address_line_1_o
679: => pqh_acc_shd.g_old_rec.address_line_1
680: ,p_address_line_2_o
681: => pqh_acc_shd.g_old_rec.address_line_2
682: ,p_address_line_3_o
683: => pqh_acc_shd.g_old_rec.address_line_3
684: ,p_town_or_city_o
685: => pqh_acc_shd.g_old_rec.town_or_city
679: => pqh_acc_shd.g_old_rec.address_line_1
680: ,p_address_line_2_o
681: => pqh_acc_shd.g_old_rec.address_line_2
682: ,p_address_line_3_o
683: => pqh_acc_shd.g_old_rec.address_line_3
684: ,p_town_or_city_o
685: => pqh_acc_shd.g_old_rec.town_or_city
686: ,p_country_o
687: => pqh_acc_shd.g_old_rec.country
681: => pqh_acc_shd.g_old_rec.address_line_2
682: ,p_address_line_3_o
683: => pqh_acc_shd.g_old_rec.address_line_3
684: ,p_town_or_city_o
685: => pqh_acc_shd.g_old_rec.town_or_city
686: ,p_country_o
687: => pqh_acc_shd.g_old_rec.country
688: ,p_postal_code_o
689: => pqh_acc_shd.g_old_rec.postal_code
683: => pqh_acc_shd.g_old_rec.address_line_3
684: ,p_town_or_city_o
685: => pqh_acc_shd.g_old_rec.town_or_city
686: ,p_country_o
687: => pqh_acc_shd.g_old_rec.country
688: ,p_postal_code_o
689: => pqh_acc_shd.g_old_rec.postal_code
690: ,p_region_1_o
691: => pqh_acc_shd.g_old_rec.region_1
685: => pqh_acc_shd.g_old_rec.town_or_city
686: ,p_country_o
687: => pqh_acc_shd.g_old_rec.country
688: ,p_postal_code_o
689: => pqh_acc_shd.g_old_rec.postal_code
690: ,p_region_1_o
691: => pqh_acc_shd.g_old_rec.region_1
692: ,p_region_2_o
693: => pqh_acc_shd.g_old_rec.region_2
687: => pqh_acc_shd.g_old_rec.country
688: ,p_postal_code_o
689: => pqh_acc_shd.g_old_rec.postal_code
690: ,p_region_1_o
691: => pqh_acc_shd.g_old_rec.region_1
692: ,p_region_2_o
693: => pqh_acc_shd.g_old_rec.region_2
694: ,p_region_3_o
695: => pqh_acc_shd.g_old_rec.region_3
689: => pqh_acc_shd.g_old_rec.postal_code
690: ,p_region_1_o
691: => pqh_acc_shd.g_old_rec.region_1
692: ,p_region_2_o
693: => pqh_acc_shd.g_old_rec.region_2
694: ,p_region_3_o
695: => pqh_acc_shd.g_old_rec.region_3
696: ,p_telephone_number_1_o
697: => pqh_acc_shd.g_old_rec.telephone_number_1
691: => pqh_acc_shd.g_old_rec.region_1
692: ,p_region_2_o
693: => pqh_acc_shd.g_old_rec.region_2
694: ,p_region_3_o
695: => pqh_acc_shd.g_old_rec.region_3
696: ,p_telephone_number_1_o
697: => pqh_acc_shd.g_old_rec.telephone_number_1
698: ,p_telephone_number_2_o
699: => pqh_acc_shd.g_old_rec.telephone_number_2
693: => pqh_acc_shd.g_old_rec.region_2
694: ,p_region_3_o
695: => pqh_acc_shd.g_old_rec.region_3
696: ,p_telephone_number_1_o
697: => pqh_acc_shd.g_old_rec.telephone_number_1
698: ,p_telephone_number_2_o
699: => pqh_acc_shd.g_old_rec.telephone_number_2
700: ,p_telephone_number_3_o
701: => pqh_acc_shd.g_old_rec.telephone_number_3
695: => pqh_acc_shd.g_old_rec.region_3
696: ,p_telephone_number_1_o
697: => pqh_acc_shd.g_old_rec.telephone_number_1
698: ,p_telephone_number_2_o
699: => pqh_acc_shd.g_old_rec.telephone_number_2
700: ,p_telephone_number_3_o
701: => pqh_acc_shd.g_old_rec.telephone_number_3
702: ,p_floor_number_o
703: => pqh_acc_shd.g_old_rec.floor_number
697: => pqh_acc_shd.g_old_rec.telephone_number_1
698: ,p_telephone_number_2_o
699: => pqh_acc_shd.g_old_rec.telephone_number_2
700: ,p_telephone_number_3_o
701: => pqh_acc_shd.g_old_rec.telephone_number_3
702: ,p_floor_number_o
703: => pqh_acc_shd.g_old_rec.floor_number
704: ,p_floor_area_o
705: => pqh_acc_shd.g_old_rec.floor_area
699: => pqh_acc_shd.g_old_rec.telephone_number_2
700: ,p_telephone_number_3_o
701: => pqh_acc_shd.g_old_rec.telephone_number_3
702: ,p_floor_number_o
703: => pqh_acc_shd.g_old_rec.floor_number
704: ,p_floor_area_o
705: => pqh_acc_shd.g_old_rec.floor_area
706: ,p_floor_area_measure_unit_o
707: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
701: => pqh_acc_shd.g_old_rec.telephone_number_3
702: ,p_floor_number_o
703: => pqh_acc_shd.g_old_rec.floor_number
704: ,p_floor_area_o
705: => pqh_acc_shd.g_old_rec.floor_area
706: ,p_floor_area_measure_unit_o
707: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
708: ,p_main_rooms_o
709: => pqh_acc_shd.g_old_rec.main_rooms
703: => pqh_acc_shd.g_old_rec.floor_number
704: ,p_floor_area_o
705: => pqh_acc_shd.g_old_rec.floor_area
706: ,p_floor_area_measure_unit_o
707: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
708: ,p_main_rooms_o
709: => pqh_acc_shd.g_old_rec.main_rooms
710: ,p_family_size_o
711: => pqh_acc_shd.g_old_rec.family_size
705: => pqh_acc_shd.g_old_rec.floor_area
706: ,p_floor_area_measure_unit_o
707: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
708: ,p_main_rooms_o
709: => pqh_acc_shd.g_old_rec.main_rooms
710: ,p_family_size_o
711: => pqh_acc_shd.g_old_rec.family_size
712: ,p_suitability_disabled_o
713: => pqh_acc_shd.g_old_rec.suitability_disabled
707: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
708: ,p_main_rooms_o
709: => pqh_acc_shd.g_old_rec.main_rooms
710: ,p_family_size_o
711: => pqh_acc_shd.g_old_rec.family_size
712: ,p_suitability_disabled_o
713: => pqh_acc_shd.g_old_rec.suitability_disabled
714: ,p_rental_value_o
715: => pqh_acc_shd.g_old_rec.rental_value
709: => pqh_acc_shd.g_old_rec.main_rooms
710: ,p_family_size_o
711: => pqh_acc_shd.g_old_rec.family_size
712: ,p_suitability_disabled_o
713: => pqh_acc_shd.g_old_rec.suitability_disabled
714: ,p_rental_value_o
715: => pqh_acc_shd.g_old_rec.rental_value
716: ,p_rental_value_currency_o
717: => pqh_acc_shd.g_old_rec.rental_value_currency
711: => pqh_acc_shd.g_old_rec.family_size
712: ,p_suitability_disabled_o
713: => pqh_acc_shd.g_old_rec.suitability_disabled
714: ,p_rental_value_o
715: => pqh_acc_shd.g_old_rec.rental_value
716: ,p_rental_value_currency_o
717: => pqh_acc_shd.g_old_rec.rental_value_currency
718: ,p_owner_o
719: => pqh_acc_shd.g_old_rec.owner
713: => pqh_acc_shd.g_old_rec.suitability_disabled
714: ,p_rental_value_o
715: => pqh_acc_shd.g_old_rec.rental_value
716: ,p_rental_value_currency_o
717: => pqh_acc_shd.g_old_rec.rental_value_currency
718: ,p_owner_o
719: => pqh_acc_shd.g_old_rec.owner
720: ,p_comments_o
721: => pqh_acc_shd.g_old_rec.comments
715: => pqh_acc_shd.g_old_rec.rental_value
716: ,p_rental_value_currency_o
717: => pqh_acc_shd.g_old_rec.rental_value_currency
718: ,p_owner_o
719: => pqh_acc_shd.g_old_rec.owner
720: ,p_comments_o
721: => pqh_acc_shd.g_old_rec.comments
722: ,p_information_category_o
723: => pqh_acc_shd.g_old_rec.information_category
717: => pqh_acc_shd.g_old_rec.rental_value_currency
718: ,p_owner_o
719: => pqh_acc_shd.g_old_rec.owner
720: ,p_comments_o
721: => pqh_acc_shd.g_old_rec.comments
722: ,p_information_category_o
723: => pqh_acc_shd.g_old_rec.information_category
724: ,p_information1_o
725: => pqh_acc_shd.g_old_rec.information1
719: => pqh_acc_shd.g_old_rec.owner
720: ,p_comments_o
721: => pqh_acc_shd.g_old_rec.comments
722: ,p_information_category_o
723: => pqh_acc_shd.g_old_rec.information_category
724: ,p_information1_o
725: => pqh_acc_shd.g_old_rec.information1
726: ,p_information2_o
727: => pqh_acc_shd.g_old_rec.information2
721: => pqh_acc_shd.g_old_rec.comments
722: ,p_information_category_o
723: => pqh_acc_shd.g_old_rec.information_category
724: ,p_information1_o
725: => pqh_acc_shd.g_old_rec.information1
726: ,p_information2_o
727: => pqh_acc_shd.g_old_rec.information2
728: ,p_information3_o
729: => pqh_acc_shd.g_old_rec.information3
723: => pqh_acc_shd.g_old_rec.information_category
724: ,p_information1_o
725: => pqh_acc_shd.g_old_rec.information1
726: ,p_information2_o
727: => pqh_acc_shd.g_old_rec.information2
728: ,p_information3_o
729: => pqh_acc_shd.g_old_rec.information3
730: ,p_information4_o
731: => pqh_acc_shd.g_old_rec.information4
725: => pqh_acc_shd.g_old_rec.information1
726: ,p_information2_o
727: => pqh_acc_shd.g_old_rec.information2
728: ,p_information3_o
729: => pqh_acc_shd.g_old_rec.information3
730: ,p_information4_o
731: => pqh_acc_shd.g_old_rec.information4
732: ,p_information5_o
733: => pqh_acc_shd.g_old_rec.information5
727: => pqh_acc_shd.g_old_rec.information2
728: ,p_information3_o
729: => pqh_acc_shd.g_old_rec.information3
730: ,p_information4_o
731: => pqh_acc_shd.g_old_rec.information4
732: ,p_information5_o
733: => pqh_acc_shd.g_old_rec.information5
734: ,p_information6_o
735: => pqh_acc_shd.g_old_rec.information6
729: => pqh_acc_shd.g_old_rec.information3
730: ,p_information4_o
731: => pqh_acc_shd.g_old_rec.information4
732: ,p_information5_o
733: => pqh_acc_shd.g_old_rec.information5
734: ,p_information6_o
735: => pqh_acc_shd.g_old_rec.information6
736: ,p_information7_o
737: => pqh_acc_shd.g_old_rec.information7
731: => pqh_acc_shd.g_old_rec.information4
732: ,p_information5_o
733: => pqh_acc_shd.g_old_rec.information5
734: ,p_information6_o
735: => pqh_acc_shd.g_old_rec.information6
736: ,p_information7_o
737: => pqh_acc_shd.g_old_rec.information7
738: ,p_information8_o
739: => pqh_acc_shd.g_old_rec.information8
733: => pqh_acc_shd.g_old_rec.information5
734: ,p_information6_o
735: => pqh_acc_shd.g_old_rec.information6
736: ,p_information7_o
737: => pqh_acc_shd.g_old_rec.information7
738: ,p_information8_o
739: => pqh_acc_shd.g_old_rec.information8
740: ,p_information9_o
741: => pqh_acc_shd.g_old_rec.information9
735: => pqh_acc_shd.g_old_rec.information6
736: ,p_information7_o
737: => pqh_acc_shd.g_old_rec.information7
738: ,p_information8_o
739: => pqh_acc_shd.g_old_rec.information8
740: ,p_information9_o
741: => pqh_acc_shd.g_old_rec.information9
742: ,p_information10_o
743: => pqh_acc_shd.g_old_rec.information10
737: => pqh_acc_shd.g_old_rec.information7
738: ,p_information8_o
739: => pqh_acc_shd.g_old_rec.information8
740: ,p_information9_o
741: => pqh_acc_shd.g_old_rec.information9
742: ,p_information10_o
743: => pqh_acc_shd.g_old_rec.information10
744: ,p_information11_o
745: => pqh_acc_shd.g_old_rec.information11
739: => pqh_acc_shd.g_old_rec.information8
740: ,p_information9_o
741: => pqh_acc_shd.g_old_rec.information9
742: ,p_information10_o
743: => pqh_acc_shd.g_old_rec.information10
744: ,p_information11_o
745: => pqh_acc_shd.g_old_rec.information11
746: ,p_information12_o
747: => pqh_acc_shd.g_old_rec.information12
741: => pqh_acc_shd.g_old_rec.information9
742: ,p_information10_o
743: => pqh_acc_shd.g_old_rec.information10
744: ,p_information11_o
745: => pqh_acc_shd.g_old_rec.information11
746: ,p_information12_o
747: => pqh_acc_shd.g_old_rec.information12
748: ,p_information13_o
749: => pqh_acc_shd.g_old_rec.information13
743: => pqh_acc_shd.g_old_rec.information10
744: ,p_information11_o
745: => pqh_acc_shd.g_old_rec.information11
746: ,p_information12_o
747: => pqh_acc_shd.g_old_rec.information12
748: ,p_information13_o
749: => pqh_acc_shd.g_old_rec.information13
750: ,p_information14_o
751: => pqh_acc_shd.g_old_rec.information14
745: => pqh_acc_shd.g_old_rec.information11
746: ,p_information12_o
747: => pqh_acc_shd.g_old_rec.information12
748: ,p_information13_o
749: => pqh_acc_shd.g_old_rec.information13
750: ,p_information14_o
751: => pqh_acc_shd.g_old_rec.information14
752: ,p_information15_o
753: => pqh_acc_shd.g_old_rec.information15
747: => pqh_acc_shd.g_old_rec.information12
748: ,p_information13_o
749: => pqh_acc_shd.g_old_rec.information13
750: ,p_information14_o
751: => pqh_acc_shd.g_old_rec.information14
752: ,p_information15_o
753: => pqh_acc_shd.g_old_rec.information15
754: ,p_information16_o
755: => pqh_acc_shd.g_old_rec.information16
749: => pqh_acc_shd.g_old_rec.information13
750: ,p_information14_o
751: => pqh_acc_shd.g_old_rec.information14
752: ,p_information15_o
753: => pqh_acc_shd.g_old_rec.information15
754: ,p_information16_o
755: => pqh_acc_shd.g_old_rec.information16
756: ,p_information17_o
757: => pqh_acc_shd.g_old_rec.information17
751: => pqh_acc_shd.g_old_rec.information14
752: ,p_information15_o
753: => pqh_acc_shd.g_old_rec.information15
754: ,p_information16_o
755: => pqh_acc_shd.g_old_rec.information16
756: ,p_information17_o
757: => pqh_acc_shd.g_old_rec.information17
758: ,p_information18_o
759: => pqh_acc_shd.g_old_rec.information18
753: => pqh_acc_shd.g_old_rec.information15
754: ,p_information16_o
755: => pqh_acc_shd.g_old_rec.information16
756: ,p_information17_o
757: => pqh_acc_shd.g_old_rec.information17
758: ,p_information18_o
759: => pqh_acc_shd.g_old_rec.information18
760: ,p_information19_o
761: => pqh_acc_shd.g_old_rec.information19
755: => pqh_acc_shd.g_old_rec.information16
756: ,p_information17_o
757: => pqh_acc_shd.g_old_rec.information17
758: ,p_information18_o
759: => pqh_acc_shd.g_old_rec.information18
760: ,p_information19_o
761: => pqh_acc_shd.g_old_rec.information19
762: ,p_information20_o
763: => pqh_acc_shd.g_old_rec.information20
757: => pqh_acc_shd.g_old_rec.information17
758: ,p_information18_o
759: => pqh_acc_shd.g_old_rec.information18
760: ,p_information19_o
761: => pqh_acc_shd.g_old_rec.information19
762: ,p_information20_o
763: => pqh_acc_shd.g_old_rec.information20
764: ,p_information21_o
765: => pqh_acc_shd.g_old_rec.information21
759: => pqh_acc_shd.g_old_rec.information18
760: ,p_information19_o
761: => pqh_acc_shd.g_old_rec.information19
762: ,p_information20_o
763: => pqh_acc_shd.g_old_rec.information20
764: ,p_information21_o
765: => pqh_acc_shd.g_old_rec.information21
766: ,p_information22_o
767: => pqh_acc_shd.g_old_rec.information22
761: => pqh_acc_shd.g_old_rec.information19
762: ,p_information20_o
763: => pqh_acc_shd.g_old_rec.information20
764: ,p_information21_o
765: => pqh_acc_shd.g_old_rec.information21
766: ,p_information22_o
767: => pqh_acc_shd.g_old_rec.information22
768: ,p_information23_o
769: => pqh_acc_shd.g_old_rec.information23
763: => pqh_acc_shd.g_old_rec.information20
764: ,p_information21_o
765: => pqh_acc_shd.g_old_rec.information21
766: ,p_information22_o
767: => pqh_acc_shd.g_old_rec.information22
768: ,p_information23_o
769: => pqh_acc_shd.g_old_rec.information23
770: ,p_information24_o
771: => pqh_acc_shd.g_old_rec.information24
765: => pqh_acc_shd.g_old_rec.information21
766: ,p_information22_o
767: => pqh_acc_shd.g_old_rec.information22
768: ,p_information23_o
769: => pqh_acc_shd.g_old_rec.information23
770: ,p_information24_o
771: => pqh_acc_shd.g_old_rec.information24
772: ,p_information25_o
773: => pqh_acc_shd.g_old_rec.information25
767: => pqh_acc_shd.g_old_rec.information22
768: ,p_information23_o
769: => pqh_acc_shd.g_old_rec.information23
770: ,p_information24_o
771: => pqh_acc_shd.g_old_rec.information24
772: ,p_information25_o
773: => pqh_acc_shd.g_old_rec.information25
774: ,p_information26_o
775: => pqh_acc_shd.g_old_rec.information26
769: => pqh_acc_shd.g_old_rec.information23
770: ,p_information24_o
771: => pqh_acc_shd.g_old_rec.information24
772: ,p_information25_o
773: => pqh_acc_shd.g_old_rec.information25
774: ,p_information26_o
775: => pqh_acc_shd.g_old_rec.information26
776: ,p_information27_o
777: => pqh_acc_shd.g_old_rec.information27
771: => pqh_acc_shd.g_old_rec.information24
772: ,p_information25_o
773: => pqh_acc_shd.g_old_rec.information25
774: ,p_information26_o
775: => pqh_acc_shd.g_old_rec.information26
776: ,p_information27_o
777: => pqh_acc_shd.g_old_rec.information27
778: ,p_information28_o
779: => pqh_acc_shd.g_old_rec.information28
773: => pqh_acc_shd.g_old_rec.information25
774: ,p_information26_o
775: => pqh_acc_shd.g_old_rec.information26
776: ,p_information27_o
777: => pqh_acc_shd.g_old_rec.information27
778: ,p_information28_o
779: => pqh_acc_shd.g_old_rec.information28
780: ,p_information29_o
781: => pqh_acc_shd.g_old_rec.information29
775: => pqh_acc_shd.g_old_rec.information26
776: ,p_information27_o
777: => pqh_acc_shd.g_old_rec.information27
778: ,p_information28_o
779: => pqh_acc_shd.g_old_rec.information28
780: ,p_information29_o
781: => pqh_acc_shd.g_old_rec.information29
782: ,p_information30_o
783: => pqh_acc_shd.g_old_rec.information30
777: => pqh_acc_shd.g_old_rec.information27
778: ,p_information28_o
779: => pqh_acc_shd.g_old_rec.information28
780: ,p_information29_o
781: => pqh_acc_shd.g_old_rec.information29
782: ,p_information30_o
783: => pqh_acc_shd.g_old_rec.information30
784: ,p_attribute_category_o
785: => pqh_acc_shd.g_old_rec.attribute_category
779: => pqh_acc_shd.g_old_rec.information28
780: ,p_information29_o
781: => pqh_acc_shd.g_old_rec.information29
782: ,p_information30_o
783: => pqh_acc_shd.g_old_rec.information30
784: ,p_attribute_category_o
785: => pqh_acc_shd.g_old_rec.attribute_category
786: ,p_attribute1_o
787: => pqh_acc_shd.g_old_rec.attribute1
781: => pqh_acc_shd.g_old_rec.information29
782: ,p_information30_o
783: => pqh_acc_shd.g_old_rec.information30
784: ,p_attribute_category_o
785: => pqh_acc_shd.g_old_rec.attribute_category
786: ,p_attribute1_o
787: => pqh_acc_shd.g_old_rec.attribute1
788: ,p_attribute2_o
789: => pqh_acc_shd.g_old_rec.attribute2
783: => pqh_acc_shd.g_old_rec.information30
784: ,p_attribute_category_o
785: => pqh_acc_shd.g_old_rec.attribute_category
786: ,p_attribute1_o
787: => pqh_acc_shd.g_old_rec.attribute1
788: ,p_attribute2_o
789: => pqh_acc_shd.g_old_rec.attribute2
790: ,p_attribute3_o
791: => pqh_acc_shd.g_old_rec.attribute3
785: => pqh_acc_shd.g_old_rec.attribute_category
786: ,p_attribute1_o
787: => pqh_acc_shd.g_old_rec.attribute1
788: ,p_attribute2_o
789: => pqh_acc_shd.g_old_rec.attribute2
790: ,p_attribute3_o
791: => pqh_acc_shd.g_old_rec.attribute3
792: ,p_attribute4_o
793: => pqh_acc_shd.g_old_rec.attribute4
787: => pqh_acc_shd.g_old_rec.attribute1
788: ,p_attribute2_o
789: => pqh_acc_shd.g_old_rec.attribute2
790: ,p_attribute3_o
791: => pqh_acc_shd.g_old_rec.attribute3
792: ,p_attribute4_o
793: => pqh_acc_shd.g_old_rec.attribute4
794: ,p_attribute5_o
795: => pqh_acc_shd.g_old_rec.attribute5
789: => pqh_acc_shd.g_old_rec.attribute2
790: ,p_attribute3_o
791: => pqh_acc_shd.g_old_rec.attribute3
792: ,p_attribute4_o
793: => pqh_acc_shd.g_old_rec.attribute4
794: ,p_attribute5_o
795: => pqh_acc_shd.g_old_rec.attribute5
796: ,p_attribute6_o
797: => pqh_acc_shd.g_old_rec.attribute6
791: => pqh_acc_shd.g_old_rec.attribute3
792: ,p_attribute4_o
793: => pqh_acc_shd.g_old_rec.attribute4
794: ,p_attribute5_o
795: => pqh_acc_shd.g_old_rec.attribute5
796: ,p_attribute6_o
797: => pqh_acc_shd.g_old_rec.attribute6
798: ,p_attribute7_o
799: => pqh_acc_shd.g_old_rec.attribute7
793: => pqh_acc_shd.g_old_rec.attribute4
794: ,p_attribute5_o
795: => pqh_acc_shd.g_old_rec.attribute5
796: ,p_attribute6_o
797: => pqh_acc_shd.g_old_rec.attribute6
798: ,p_attribute7_o
799: => pqh_acc_shd.g_old_rec.attribute7
800: ,p_attribute8_o
801: => pqh_acc_shd.g_old_rec.attribute8
795: => pqh_acc_shd.g_old_rec.attribute5
796: ,p_attribute6_o
797: => pqh_acc_shd.g_old_rec.attribute6
798: ,p_attribute7_o
799: => pqh_acc_shd.g_old_rec.attribute7
800: ,p_attribute8_o
801: => pqh_acc_shd.g_old_rec.attribute8
802: ,p_attribute9_o
803: => pqh_acc_shd.g_old_rec.attribute9
797: => pqh_acc_shd.g_old_rec.attribute6
798: ,p_attribute7_o
799: => pqh_acc_shd.g_old_rec.attribute7
800: ,p_attribute8_o
801: => pqh_acc_shd.g_old_rec.attribute8
802: ,p_attribute9_o
803: => pqh_acc_shd.g_old_rec.attribute9
804: ,p_attribute10_o
805: => pqh_acc_shd.g_old_rec.attribute10
799: => pqh_acc_shd.g_old_rec.attribute7
800: ,p_attribute8_o
801: => pqh_acc_shd.g_old_rec.attribute8
802: ,p_attribute9_o
803: => pqh_acc_shd.g_old_rec.attribute9
804: ,p_attribute10_o
805: => pqh_acc_shd.g_old_rec.attribute10
806: ,p_attribute11_o
807: => pqh_acc_shd.g_old_rec.attribute11
801: => pqh_acc_shd.g_old_rec.attribute8
802: ,p_attribute9_o
803: => pqh_acc_shd.g_old_rec.attribute9
804: ,p_attribute10_o
805: => pqh_acc_shd.g_old_rec.attribute10
806: ,p_attribute11_o
807: => pqh_acc_shd.g_old_rec.attribute11
808: ,p_attribute12_o
809: => pqh_acc_shd.g_old_rec.attribute12
803: => pqh_acc_shd.g_old_rec.attribute9
804: ,p_attribute10_o
805: => pqh_acc_shd.g_old_rec.attribute10
806: ,p_attribute11_o
807: => pqh_acc_shd.g_old_rec.attribute11
808: ,p_attribute12_o
809: => pqh_acc_shd.g_old_rec.attribute12
810: ,p_attribute13_o
811: => pqh_acc_shd.g_old_rec.attribute13
805: => pqh_acc_shd.g_old_rec.attribute10
806: ,p_attribute11_o
807: => pqh_acc_shd.g_old_rec.attribute11
808: ,p_attribute12_o
809: => pqh_acc_shd.g_old_rec.attribute12
810: ,p_attribute13_o
811: => pqh_acc_shd.g_old_rec.attribute13
812: ,p_attribute14_o
813: => pqh_acc_shd.g_old_rec.attribute14
807: => pqh_acc_shd.g_old_rec.attribute11
808: ,p_attribute12_o
809: => pqh_acc_shd.g_old_rec.attribute12
810: ,p_attribute13_o
811: => pqh_acc_shd.g_old_rec.attribute13
812: ,p_attribute14_o
813: => pqh_acc_shd.g_old_rec.attribute14
814: ,p_attribute15_o
815: => pqh_acc_shd.g_old_rec.attribute15
809: => pqh_acc_shd.g_old_rec.attribute12
810: ,p_attribute13_o
811: => pqh_acc_shd.g_old_rec.attribute13
812: ,p_attribute14_o
813: => pqh_acc_shd.g_old_rec.attribute14
814: ,p_attribute15_o
815: => pqh_acc_shd.g_old_rec.attribute15
816: ,p_attribute16_o
817: => pqh_acc_shd.g_old_rec.attribute16
811: => pqh_acc_shd.g_old_rec.attribute13
812: ,p_attribute14_o
813: => pqh_acc_shd.g_old_rec.attribute14
814: ,p_attribute15_o
815: => pqh_acc_shd.g_old_rec.attribute15
816: ,p_attribute16_o
817: => pqh_acc_shd.g_old_rec.attribute16
818: ,p_attribute17_o
819: => pqh_acc_shd.g_old_rec.attribute17
813: => pqh_acc_shd.g_old_rec.attribute14
814: ,p_attribute15_o
815: => pqh_acc_shd.g_old_rec.attribute15
816: ,p_attribute16_o
817: => pqh_acc_shd.g_old_rec.attribute16
818: ,p_attribute17_o
819: => pqh_acc_shd.g_old_rec.attribute17
820: ,p_attribute18_o
821: => pqh_acc_shd.g_old_rec.attribute18
815: => pqh_acc_shd.g_old_rec.attribute15
816: ,p_attribute16_o
817: => pqh_acc_shd.g_old_rec.attribute16
818: ,p_attribute17_o
819: => pqh_acc_shd.g_old_rec.attribute17
820: ,p_attribute18_o
821: => pqh_acc_shd.g_old_rec.attribute18
822: ,p_attribute19_o
823: => pqh_acc_shd.g_old_rec.attribute19
817: => pqh_acc_shd.g_old_rec.attribute16
818: ,p_attribute17_o
819: => pqh_acc_shd.g_old_rec.attribute17
820: ,p_attribute18_o
821: => pqh_acc_shd.g_old_rec.attribute18
822: ,p_attribute19_o
823: => pqh_acc_shd.g_old_rec.attribute19
824: ,p_attribute20_o
825: => pqh_acc_shd.g_old_rec.attribute20
819: => pqh_acc_shd.g_old_rec.attribute17
820: ,p_attribute18_o
821: => pqh_acc_shd.g_old_rec.attribute18
822: ,p_attribute19_o
823: => pqh_acc_shd.g_old_rec.attribute19
824: ,p_attribute20_o
825: => pqh_acc_shd.g_old_rec.attribute20
826: ,p_attribute21_o
827: => pqh_acc_shd.g_old_rec.attribute21
821: => pqh_acc_shd.g_old_rec.attribute18
822: ,p_attribute19_o
823: => pqh_acc_shd.g_old_rec.attribute19
824: ,p_attribute20_o
825: => pqh_acc_shd.g_old_rec.attribute20
826: ,p_attribute21_o
827: => pqh_acc_shd.g_old_rec.attribute21
828: ,p_attribute22_o
829: => pqh_acc_shd.g_old_rec.attribute22
823: => pqh_acc_shd.g_old_rec.attribute19
824: ,p_attribute20_o
825: => pqh_acc_shd.g_old_rec.attribute20
826: ,p_attribute21_o
827: => pqh_acc_shd.g_old_rec.attribute21
828: ,p_attribute22_o
829: => pqh_acc_shd.g_old_rec.attribute22
830: ,p_attribute23_o
831: => pqh_acc_shd.g_old_rec.attribute23
825: => pqh_acc_shd.g_old_rec.attribute20
826: ,p_attribute21_o
827: => pqh_acc_shd.g_old_rec.attribute21
828: ,p_attribute22_o
829: => pqh_acc_shd.g_old_rec.attribute22
830: ,p_attribute23_o
831: => pqh_acc_shd.g_old_rec.attribute23
832: ,p_attribute24_o
833: => pqh_acc_shd.g_old_rec.attribute24
827: => pqh_acc_shd.g_old_rec.attribute21
828: ,p_attribute22_o
829: => pqh_acc_shd.g_old_rec.attribute22
830: ,p_attribute23_o
831: => pqh_acc_shd.g_old_rec.attribute23
832: ,p_attribute24_o
833: => pqh_acc_shd.g_old_rec.attribute24
834: ,p_attribute25_o
835: => pqh_acc_shd.g_old_rec.attribute25
829: => pqh_acc_shd.g_old_rec.attribute22
830: ,p_attribute23_o
831: => pqh_acc_shd.g_old_rec.attribute23
832: ,p_attribute24_o
833: => pqh_acc_shd.g_old_rec.attribute24
834: ,p_attribute25_o
835: => pqh_acc_shd.g_old_rec.attribute25
836: ,p_attribute26_o
837: => pqh_acc_shd.g_old_rec.attribute26
831: => pqh_acc_shd.g_old_rec.attribute23
832: ,p_attribute24_o
833: => pqh_acc_shd.g_old_rec.attribute24
834: ,p_attribute25_o
835: => pqh_acc_shd.g_old_rec.attribute25
836: ,p_attribute26_o
837: => pqh_acc_shd.g_old_rec.attribute26
838: ,p_attribute27_o
839: => pqh_acc_shd.g_old_rec.attribute27
833: => pqh_acc_shd.g_old_rec.attribute24
834: ,p_attribute25_o
835: => pqh_acc_shd.g_old_rec.attribute25
836: ,p_attribute26_o
837: => pqh_acc_shd.g_old_rec.attribute26
838: ,p_attribute27_o
839: => pqh_acc_shd.g_old_rec.attribute27
840: ,p_attribute28_o
841: => pqh_acc_shd.g_old_rec.attribute28
835: => pqh_acc_shd.g_old_rec.attribute25
836: ,p_attribute26_o
837: => pqh_acc_shd.g_old_rec.attribute26
838: ,p_attribute27_o
839: => pqh_acc_shd.g_old_rec.attribute27
840: ,p_attribute28_o
841: => pqh_acc_shd.g_old_rec.attribute28
842: ,p_attribute29_o
843: => pqh_acc_shd.g_old_rec.attribute29
837: => pqh_acc_shd.g_old_rec.attribute26
838: ,p_attribute27_o
839: => pqh_acc_shd.g_old_rec.attribute27
840: ,p_attribute28_o
841: => pqh_acc_shd.g_old_rec.attribute28
842: ,p_attribute29_o
843: => pqh_acc_shd.g_old_rec.attribute29
844: ,p_attribute30_o
845: => pqh_acc_shd.g_old_rec.attribute30
839: => pqh_acc_shd.g_old_rec.attribute27
840: ,p_attribute28_o
841: => pqh_acc_shd.g_old_rec.attribute28
842: ,p_attribute29_o
843: => pqh_acc_shd.g_old_rec.attribute29
844: ,p_attribute30_o
845: => pqh_acc_shd.g_old_rec.attribute30
846: ,p_object_version_number_o
847: => pqh_acc_shd.g_old_rec.object_version_number
841: => pqh_acc_shd.g_old_rec.attribute28
842: ,p_attribute29_o
843: => pqh_acc_shd.g_old_rec.attribute29
844: ,p_attribute30_o
845: => pqh_acc_shd.g_old_rec.attribute30
846: ,p_object_version_number_o
847: => pqh_acc_shd.g_old_rec.object_version_number
848: );
849: --
843: => pqh_acc_shd.g_old_rec.attribute29
844: ,p_attribute30_o
845: => pqh_acc_shd.g_old_rec.attribute30
846: ,p_object_version_number_o
847: => pqh_acc_shd.g_old_rec.object_version_number
848: );
849: --
850: exception
851: --
903: --
904: -- {End Of Comments}
905: -- ----------------------------------------------------------------------------
906: Procedure convert_defs
907: (p_rec in out nocopy pqh_acc_shd.g_rec_type
908: ) is
909: --
910: Begin
911: --
915: -- is being used then we must set to the 'current' argument value.
916: --
917: If (p_rec.accommodation_name = hr_api.g_varchar2) then
918: p_rec.accommodation_name :=
919: pqh_acc_shd.g_old_rec.accommodation_name;
920: End If;
921: If (p_rec.business_group_id = hr_api.g_number) then
922: p_rec.business_group_id :=
923: pqh_acc_shd.g_old_rec.business_group_id;
919: pqh_acc_shd.g_old_rec.accommodation_name;
920: End If;
921: If (p_rec.business_group_id = hr_api.g_number) then
922: p_rec.business_group_id :=
923: pqh_acc_shd.g_old_rec.business_group_id;
924: End If;
925: If (p_rec.location_id = hr_api.g_number) then
926: p_rec.location_id :=
927: pqh_acc_shd.g_old_rec.location_id;
923: pqh_acc_shd.g_old_rec.business_group_id;
924: End If;
925: If (p_rec.location_id = hr_api.g_number) then
926: p_rec.location_id :=
927: pqh_acc_shd.g_old_rec.location_id;
928: End If;
929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then
930: p_rec.accommodation_desc :=
931: pqh_acc_shd.g_old_rec.accommodation_desc;
927: pqh_acc_shd.g_old_rec.location_id;
928: End If;
929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then
930: p_rec.accommodation_desc :=
931: pqh_acc_shd.g_old_rec.accommodation_desc;
932: End If;
933: If (p_rec.accommodation_type = hr_api.g_varchar2) then
934: p_rec.accommodation_type :=
935: pqh_acc_shd.g_old_rec.accommodation_type;
931: pqh_acc_shd.g_old_rec.accommodation_desc;
932: End If;
933: If (p_rec.accommodation_type = hr_api.g_varchar2) then
934: p_rec.accommodation_type :=
935: pqh_acc_shd.g_old_rec.accommodation_type;
936: End If;
937: If (p_rec.style = hr_api.g_varchar2) then
938: p_rec.style :=
939: pqh_acc_shd.g_old_rec.style;
935: pqh_acc_shd.g_old_rec.accommodation_type;
936: End If;
937: If (p_rec.style = hr_api.g_varchar2) then
938: p_rec.style :=
939: pqh_acc_shd.g_old_rec.style;
940: End If;
941: If (p_rec.address_line_1 = hr_api.g_varchar2) then
942: p_rec.address_line_1 :=
943: pqh_acc_shd.g_old_rec.address_line_1;
939: pqh_acc_shd.g_old_rec.style;
940: End If;
941: If (p_rec.address_line_1 = hr_api.g_varchar2) then
942: p_rec.address_line_1 :=
943: pqh_acc_shd.g_old_rec.address_line_1;
944: End If;
945: If (p_rec.address_line_2 = hr_api.g_varchar2) then
946: p_rec.address_line_2 :=
947: pqh_acc_shd.g_old_rec.address_line_2;
943: pqh_acc_shd.g_old_rec.address_line_1;
944: End If;
945: If (p_rec.address_line_2 = hr_api.g_varchar2) then
946: p_rec.address_line_2 :=
947: pqh_acc_shd.g_old_rec.address_line_2;
948: End If;
949: If (p_rec.address_line_3 = hr_api.g_varchar2) then
950: p_rec.address_line_3 :=
951: pqh_acc_shd.g_old_rec.address_line_3;
947: pqh_acc_shd.g_old_rec.address_line_2;
948: End If;
949: If (p_rec.address_line_3 = hr_api.g_varchar2) then
950: p_rec.address_line_3 :=
951: pqh_acc_shd.g_old_rec.address_line_3;
952: End If;
953: If (p_rec.town_or_city = hr_api.g_varchar2) then
954: p_rec.town_or_city :=
955: pqh_acc_shd.g_old_rec.town_or_city;
951: pqh_acc_shd.g_old_rec.address_line_3;
952: End If;
953: If (p_rec.town_or_city = hr_api.g_varchar2) then
954: p_rec.town_or_city :=
955: pqh_acc_shd.g_old_rec.town_or_city;
956: End If;
957: If (p_rec.country = hr_api.g_varchar2) then
958: p_rec.country :=
959: pqh_acc_shd.g_old_rec.country;
955: pqh_acc_shd.g_old_rec.town_or_city;
956: End If;
957: If (p_rec.country = hr_api.g_varchar2) then
958: p_rec.country :=
959: pqh_acc_shd.g_old_rec.country;
960: End If;
961: If (p_rec.postal_code = hr_api.g_varchar2) then
962: p_rec.postal_code :=
963: pqh_acc_shd.g_old_rec.postal_code;
959: pqh_acc_shd.g_old_rec.country;
960: End If;
961: If (p_rec.postal_code = hr_api.g_varchar2) then
962: p_rec.postal_code :=
963: pqh_acc_shd.g_old_rec.postal_code;
964: End If;
965: If (p_rec.region_1 = hr_api.g_varchar2) then
966: p_rec.region_1 :=
967: pqh_acc_shd.g_old_rec.region_1;
963: pqh_acc_shd.g_old_rec.postal_code;
964: End If;
965: If (p_rec.region_1 = hr_api.g_varchar2) then
966: p_rec.region_1 :=
967: pqh_acc_shd.g_old_rec.region_1;
968: End If;
969: If (p_rec.region_2 = hr_api.g_varchar2) then
970: p_rec.region_2 :=
971: pqh_acc_shd.g_old_rec.region_2;
967: pqh_acc_shd.g_old_rec.region_1;
968: End If;
969: If (p_rec.region_2 = hr_api.g_varchar2) then
970: p_rec.region_2 :=
971: pqh_acc_shd.g_old_rec.region_2;
972: End If;
973: If (p_rec.region_3 = hr_api.g_varchar2) then
974: p_rec.region_3 :=
975: pqh_acc_shd.g_old_rec.region_3;
971: pqh_acc_shd.g_old_rec.region_2;
972: End If;
973: If (p_rec.region_3 = hr_api.g_varchar2) then
974: p_rec.region_3 :=
975: pqh_acc_shd.g_old_rec.region_3;
976: End If;
977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
978: p_rec.telephone_number_1 :=
979: pqh_acc_shd.g_old_rec.telephone_number_1;
975: pqh_acc_shd.g_old_rec.region_3;
976: End If;
977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
978: p_rec.telephone_number_1 :=
979: pqh_acc_shd.g_old_rec.telephone_number_1;
980: End If;
981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
982: p_rec.telephone_number_2 :=
983: pqh_acc_shd.g_old_rec.telephone_number_2;
979: pqh_acc_shd.g_old_rec.telephone_number_1;
980: End If;
981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
982: p_rec.telephone_number_2 :=
983: pqh_acc_shd.g_old_rec.telephone_number_2;
984: End If;
985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
986: p_rec.telephone_number_3 :=
987: pqh_acc_shd.g_old_rec.telephone_number_3;
983: pqh_acc_shd.g_old_rec.telephone_number_2;
984: End If;
985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
986: p_rec.telephone_number_3 :=
987: pqh_acc_shd.g_old_rec.telephone_number_3;
988: End If;
989: If (p_rec.floor_number = hr_api.g_varchar2) then
990: p_rec.floor_number :=
991: pqh_acc_shd.g_old_rec.floor_number;
987: pqh_acc_shd.g_old_rec.telephone_number_3;
988: End If;
989: If (p_rec.floor_number = hr_api.g_varchar2) then
990: p_rec.floor_number :=
991: pqh_acc_shd.g_old_rec.floor_number;
992: End If;
993: If (p_rec.floor_area = hr_api.g_number) then
994: p_rec.floor_area :=
995: pqh_acc_shd.g_old_rec.floor_area;
991: pqh_acc_shd.g_old_rec.floor_number;
992: End If;
993: If (p_rec.floor_area = hr_api.g_number) then
994: p_rec.floor_area :=
995: pqh_acc_shd.g_old_rec.floor_area;
996: End If;
997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then
998: p_rec.floor_area_measure_unit :=
999: pqh_acc_shd.g_old_rec.floor_area_measure_unit;
995: pqh_acc_shd.g_old_rec.floor_area;
996: End If;
997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then
998: p_rec.floor_area_measure_unit :=
999: pqh_acc_shd.g_old_rec.floor_area_measure_unit;
1000: End If;
1001: If (p_rec.main_rooms = hr_api.g_number) then
1002: p_rec.main_rooms :=
1003: pqh_acc_shd.g_old_rec.main_rooms;
999: pqh_acc_shd.g_old_rec.floor_area_measure_unit;
1000: End If;
1001: If (p_rec.main_rooms = hr_api.g_number) then
1002: p_rec.main_rooms :=
1003: pqh_acc_shd.g_old_rec.main_rooms;
1004: End If;
1005: If (p_rec.family_size = hr_api.g_number) then
1006: p_rec.family_size :=
1007: pqh_acc_shd.g_old_rec.family_size;
1003: pqh_acc_shd.g_old_rec.main_rooms;
1004: End If;
1005: If (p_rec.family_size = hr_api.g_number) then
1006: p_rec.family_size :=
1007: pqh_acc_shd.g_old_rec.family_size;
1008: End If;
1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then
1010: p_rec.suitability_disabled :=
1011: pqh_acc_shd.g_old_rec.suitability_disabled;
1007: pqh_acc_shd.g_old_rec.family_size;
1008: End If;
1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then
1010: p_rec.suitability_disabled :=
1011: pqh_acc_shd.g_old_rec.suitability_disabled;
1012: End If;
1013: If (p_rec.rental_value = hr_api.g_number) then
1014: p_rec.rental_value :=
1015: pqh_acc_shd.g_old_rec.rental_value;
1011: pqh_acc_shd.g_old_rec.suitability_disabled;
1012: End If;
1013: If (p_rec.rental_value = hr_api.g_number) then
1014: p_rec.rental_value :=
1015: pqh_acc_shd.g_old_rec.rental_value;
1016: End If;
1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then
1018: p_rec.rental_value_currency :=
1019: pqh_acc_shd.g_old_rec.rental_value_currency;
1015: pqh_acc_shd.g_old_rec.rental_value;
1016: End If;
1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then
1018: p_rec.rental_value_currency :=
1019: pqh_acc_shd.g_old_rec.rental_value_currency;
1020: End If;
1021: If (p_rec.owner = hr_api.g_varchar2) then
1022: p_rec.owner :=
1023: pqh_acc_shd.g_old_rec.owner;
1019: pqh_acc_shd.g_old_rec.rental_value_currency;
1020: End If;
1021: If (p_rec.owner = hr_api.g_varchar2) then
1022: p_rec.owner :=
1023: pqh_acc_shd.g_old_rec.owner;
1024: End If;
1025: If (p_rec.comments = hr_api.g_varchar2) then
1026: p_rec.comments :=
1027: pqh_acc_shd.g_old_rec.comments;
1023: pqh_acc_shd.g_old_rec.owner;
1024: End If;
1025: If (p_rec.comments = hr_api.g_varchar2) then
1026: p_rec.comments :=
1027: pqh_acc_shd.g_old_rec.comments;
1028: End If;
1029: If (p_rec.information_category = hr_api.g_varchar2) then
1030: p_rec.information_category :=
1031: pqh_acc_shd.g_old_rec.information_category;
1027: pqh_acc_shd.g_old_rec.comments;
1028: End If;
1029: If (p_rec.information_category = hr_api.g_varchar2) then
1030: p_rec.information_category :=
1031: pqh_acc_shd.g_old_rec.information_category;
1032: End If;
1033: If (p_rec.information1 = hr_api.g_varchar2) then
1034: p_rec.information1 :=
1035: pqh_acc_shd.g_old_rec.information1;
1031: pqh_acc_shd.g_old_rec.information_category;
1032: End If;
1033: If (p_rec.information1 = hr_api.g_varchar2) then
1034: p_rec.information1 :=
1035: pqh_acc_shd.g_old_rec.information1;
1036: End If;
1037: If (p_rec.information2 = hr_api.g_varchar2) then
1038: p_rec.information2 :=
1039: pqh_acc_shd.g_old_rec.information2;
1035: pqh_acc_shd.g_old_rec.information1;
1036: End If;
1037: If (p_rec.information2 = hr_api.g_varchar2) then
1038: p_rec.information2 :=
1039: pqh_acc_shd.g_old_rec.information2;
1040: End If;
1041: If (p_rec.information3 = hr_api.g_varchar2) then
1042: p_rec.information3 :=
1043: pqh_acc_shd.g_old_rec.information3;
1039: pqh_acc_shd.g_old_rec.information2;
1040: End If;
1041: If (p_rec.information3 = hr_api.g_varchar2) then
1042: p_rec.information3 :=
1043: pqh_acc_shd.g_old_rec.information3;
1044: End If;
1045: If (p_rec.information4 = hr_api.g_varchar2) then
1046: p_rec.information4 :=
1047: pqh_acc_shd.g_old_rec.information4;
1043: pqh_acc_shd.g_old_rec.information3;
1044: End If;
1045: If (p_rec.information4 = hr_api.g_varchar2) then
1046: p_rec.information4 :=
1047: pqh_acc_shd.g_old_rec.information4;
1048: End If;
1049: If (p_rec.information5 = hr_api.g_varchar2) then
1050: p_rec.information5 :=
1051: pqh_acc_shd.g_old_rec.information5;
1047: pqh_acc_shd.g_old_rec.information4;
1048: End If;
1049: If (p_rec.information5 = hr_api.g_varchar2) then
1050: p_rec.information5 :=
1051: pqh_acc_shd.g_old_rec.information5;
1052: End If;
1053: If (p_rec.information6 = hr_api.g_varchar2) then
1054: p_rec.information6 :=
1055: pqh_acc_shd.g_old_rec.information6;
1051: pqh_acc_shd.g_old_rec.information5;
1052: End If;
1053: If (p_rec.information6 = hr_api.g_varchar2) then
1054: p_rec.information6 :=
1055: pqh_acc_shd.g_old_rec.information6;
1056: End If;
1057: If (p_rec.information7 = hr_api.g_varchar2) then
1058: p_rec.information7 :=
1059: pqh_acc_shd.g_old_rec.information7;
1055: pqh_acc_shd.g_old_rec.information6;
1056: End If;
1057: If (p_rec.information7 = hr_api.g_varchar2) then
1058: p_rec.information7 :=
1059: pqh_acc_shd.g_old_rec.information7;
1060: End If;
1061: If (p_rec.information8 = hr_api.g_varchar2) then
1062: p_rec.information8 :=
1063: pqh_acc_shd.g_old_rec.information8;
1059: pqh_acc_shd.g_old_rec.information7;
1060: End If;
1061: If (p_rec.information8 = hr_api.g_varchar2) then
1062: p_rec.information8 :=
1063: pqh_acc_shd.g_old_rec.information8;
1064: End If;
1065: If (p_rec.information9 = hr_api.g_varchar2) then
1066: p_rec.information9 :=
1067: pqh_acc_shd.g_old_rec.information9;
1063: pqh_acc_shd.g_old_rec.information8;
1064: End If;
1065: If (p_rec.information9 = hr_api.g_varchar2) then
1066: p_rec.information9 :=
1067: pqh_acc_shd.g_old_rec.information9;
1068: End If;
1069: If (p_rec.information10 = hr_api.g_varchar2) then
1070: p_rec.information10 :=
1071: pqh_acc_shd.g_old_rec.information10;
1067: pqh_acc_shd.g_old_rec.information9;
1068: End If;
1069: If (p_rec.information10 = hr_api.g_varchar2) then
1070: p_rec.information10 :=
1071: pqh_acc_shd.g_old_rec.information10;
1072: End If;
1073: If (p_rec.information11 = hr_api.g_varchar2) then
1074: p_rec.information11 :=
1075: pqh_acc_shd.g_old_rec.information11;
1071: pqh_acc_shd.g_old_rec.information10;
1072: End If;
1073: If (p_rec.information11 = hr_api.g_varchar2) then
1074: p_rec.information11 :=
1075: pqh_acc_shd.g_old_rec.information11;
1076: End If;
1077: If (p_rec.information12 = hr_api.g_varchar2) then
1078: p_rec.information12 :=
1079: pqh_acc_shd.g_old_rec.information12;
1075: pqh_acc_shd.g_old_rec.information11;
1076: End If;
1077: If (p_rec.information12 = hr_api.g_varchar2) then
1078: p_rec.information12 :=
1079: pqh_acc_shd.g_old_rec.information12;
1080: End If;
1081: If (p_rec.information13 = hr_api.g_varchar2) then
1082: p_rec.information13 :=
1083: pqh_acc_shd.g_old_rec.information13;
1079: pqh_acc_shd.g_old_rec.information12;
1080: End If;
1081: If (p_rec.information13 = hr_api.g_varchar2) then
1082: p_rec.information13 :=
1083: pqh_acc_shd.g_old_rec.information13;
1084: End If;
1085: If (p_rec.information14 = hr_api.g_varchar2) then
1086: p_rec.information14 :=
1087: pqh_acc_shd.g_old_rec.information14;
1083: pqh_acc_shd.g_old_rec.information13;
1084: End If;
1085: If (p_rec.information14 = hr_api.g_varchar2) then
1086: p_rec.information14 :=
1087: pqh_acc_shd.g_old_rec.information14;
1088: End If;
1089: If (p_rec.information15 = hr_api.g_varchar2) then
1090: p_rec.information15 :=
1091: pqh_acc_shd.g_old_rec.information15;
1087: pqh_acc_shd.g_old_rec.information14;
1088: End If;
1089: If (p_rec.information15 = hr_api.g_varchar2) then
1090: p_rec.information15 :=
1091: pqh_acc_shd.g_old_rec.information15;
1092: End If;
1093: If (p_rec.information16 = hr_api.g_varchar2) then
1094: p_rec.information16 :=
1095: pqh_acc_shd.g_old_rec.information16;
1091: pqh_acc_shd.g_old_rec.information15;
1092: End If;
1093: If (p_rec.information16 = hr_api.g_varchar2) then
1094: p_rec.information16 :=
1095: pqh_acc_shd.g_old_rec.information16;
1096: End If;
1097: If (p_rec.information17 = hr_api.g_varchar2) then
1098: p_rec.information17 :=
1099: pqh_acc_shd.g_old_rec.information17;
1095: pqh_acc_shd.g_old_rec.information16;
1096: End If;
1097: If (p_rec.information17 = hr_api.g_varchar2) then
1098: p_rec.information17 :=
1099: pqh_acc_shd.g_old_rec.information17;
1100: End If;
1101: If (p_rec.information18 = hr_api.g_varchar2) then
1102: p_rec.information18 :=
1103: pqh_acc_shd.g_old_rec.information18;
1099: pqh_acc_shd.g_old_rec.information17;
1100: End If;
1101: If (p_rec.information18 = hr_api.g_varchar2) then
1102: p_rec.information18 :=
1103: pqh_acc_shd.g_old_rec.information18;
1104: End If;
1105: If (p_rec.information19 = hr_api.g_varchar2) then
1106: p_rec.information19 :=
1107: pqh_acc_shd.g_old_rec.information19;
1103: pqh_acc_shd.g_old_rec.information18;
1104: End If;
1105: If (p_rec.information19 = hr_api.g_varchar2) then
1106: p_rec.information19 :=
1107: pqh_acc_shd.g_old_rec.information19;
1108: End If;
1109: If (p_rec.information20 = hr_api.g_varchar2) then
1110: p_rec.information20 :=
1111: pqh_acc_shd.g_old_rec.information20;
1107: pqh_acc_shd.g_old_rec.information19;
1108: End If;
1109: If (p_rec.information20 = hr_api.g_varchar2) then
1110: p_rec.information20 :=
1111: pqh_acc_shd.g_old_rec.information20;
1112: End If;
1113: If (p_rec.information21 = hr_api.g_varchar2) then
1114: p_rec.information21 :=
1115: pqh_acc_shd.g_old_rec.information21;
1111: pqh_acc_shd.g_old_rec.information20;
1112: End If;
1113: If (p_rec.information21 = hr_api.g_varchar2) then
1114: p_rec.information21 :=
1115: pqh_acc_shd.g_old_rec.information21;
1116: End If;
1117: If (p_rec.information22 = hr_api.g_varchar2) then
1118: p_rec.information22 :=
1119: pqh_acc_shd.g_old_rec.information22;
1115: pqh_acc_shd.g_old_rec.information21;
1116: End If;
1117: If (p_rec.information22 = hr_api.g_varchar2) then
1118: p_rec.information22 :=
1119: pqh_acc_shd.g_old_rec.information22;
1120: End If;
1121: If (p_rec.information23 = hr_api.g_varchar2) then
1122: p_rec.information23 :=
1123: pqh_acc_shd.g_old_rec.information23;
1119: pqh_acc_shd.g_old_rec.information22;
1120: End If;
1121: If (p_rec.information23 = hr_api.g_varchar2) then
1122: p_rec.information23 :=
1123: pqh_acc_shd.g_old_rec.information23;
1124: End If;
1125: If (p_rec.information24 = hr_api.g_varchar2) then
1126: p_rec.information24 :=
1127: pqh_acc_shd.g_old_rec.information24;
1123: pqh_acc_shd.g_old_rec.information23;
1124: End If;
1125: If (p_rec.information24 = hr_api.g_varchar2) then
1126: p_rec.information24 :=
1127: pqh_acc_shd.g_old_rec.information24;
1128: End If;
1129: If (p_rec.information25 = hr_api.g_varchar2) then
1130: p_rec.information25 :=
1131: pqh_acc_shd.g_old_rec.information25;
1127: pqh_acc_shd.g_old_rec.information24;
1128: End If;
1129: If (p_rec.information25 = hr_api.g_varchar2) then
1130: p_rec.information25 :=
1131: pqh_acc_shd.g_old_rec.information25;
1132: End If;
1133: If (p_rec.information26 = hr_api.g_varchar2) then
1134: p_rec.information26 :=
1135: pqh_acc_shd.g_old_rec.information26;
1131: pqh_acc_shd.g_old_rec.information25;
1132: End If;
1133: If (p_rec.information26 = hr_api.g_varchar2) then
1134: p_rec.information26 :=
1135: pqh_acc_shd.g_old_rec.information26;
1136: End If;
1137: If (p_rec.information27 = hr_api.g_varchar2) then
1138: p_rec.information27 :=
1139: pqh_acc_shd.g_old_rec.information27;
1135: pqh_acc_shd.g_old_rec.information26;
1136: End If;
1137: If (p_rec.information27 = hr_api.g_varchar2) then
1138: p_rec.information27 :=
1139: pqh_acc_shd.g_old_rec.information27;
1140: End If;
1141: If (p_rec.information28 = hr_api.g_varchar2) then
1142: p_rec.information28 :=
1143: pqh_acc_shd.g_old_rec.information28;
1139: pqh_acc_shd.g_old_rec.information27;
1140: End If;
1141: If (p_rec.information28 = hr_api.g_varchar2) then
1142: p_rec.information28 :=
1143: pqh_acc_shd.g_old_rec.information28;
1144: End If;
1145: If (p_rec.information29 = hr_api.g_varchar2) then
1146: p_rec.information29 :=
1147: pqh_acc_shd.g_old_rec.information29;
1143: pqh_acc_shd.g_old_rec.information28;
1144: End If;
1145: If (p_rec.information29 = hr_api.g_varchar2) then
1146: p_rec.information29 :=
1147: pqh_acc_shd.g_old_rec.information29;
1148: End If;
1149: If (p_rec.information30 = hr_api.g_varchar2) then
1150: p_rec.information30 :=
1151: pqh_acc_shd.g_old_rec.information30;
1147: pqh_acc_shd.g_old_rec.information29;
1148: End If;
1149: If (p_rec.information30 = hr_api.g_varchar2) then
1150: p_rec.information30 :=
1151: pqh_acc_shd.g_old_rec.information30;
1152: End If;
1153: If (p_rec.attribute_category = hr_api.g_varchar2) then
1154: p_rec.attribute_category :=
1155: pqh_acc_shd.g_old_rec.attribute_category;
1151: pqh_acc_shd.g_old_rec.information30;
1152: End If;
1153: If (p_rec.attribute_category = hr_api.g_varchar2) then
1154: p_rec.attribute_category :=
1155: pqh_acc_shd.g_old_rec.attribute_category;
1156: End If;
1157: If (p_rec.attribute1 = hr_api.g_varchar2) then
1158: p_rec.attribute1 :=
1159: pqh_acc_shd.g_old_rec.attribute1;
1155: pqh_acc_shd.g_old_rec.attribute_category;
1156: End If;
1157: If (p_rec.attribute1 = hr_api.g_varchar2) then
1158: p_rec.attribute1 :=
1159: pqh_acc_shd.g_old_rec.attribute1;
1160: End If;
1161: If (p_rec.attribute2 = hr_api.g_varchar2) then
1162: p_rec.attribute2 :=
1163: pqh_acc_shd.g_old_rec.attribute2;
1159: pqh_acc_shd.g_old_rec.attribute1;
1160: End If;
1161: If (p_rec.attribute2 = hr_api.g_varchar2) then
1162: p_rec.attribute2 :=
1163: pqh_acc_shd.g_old_rec.attribute2;
1164: End If;
1165: If (p_rec.attribute3 = hr_api.g_varchar2) then
1166: p_rec.attribute3 :=
1167: pqh_acc_shd.g_old_rec.attribute3;
1163: pqh_acc_shd.g_old_rec.attribute2;
1164: End If;
1165: If (p_rec.attribute3 = hr_api.g_varchar2) then
1166: p_rec.attribute3 :=
1167: pqh_acc_shd.g_old_rec.attribute3;
1168: End If;
1169: If (p_rec.attribute4 = hr_api.g_varchar2) then
1170: p_rec.attribute4 :=
1171: pqh_acc_shd.g_old_rec.attribute4;
1167: pqh_acc_shd.g_old_rec.attribute3;
1168: End If;
1169: If (p_rec.attribute4 = hr_api.g_varchar2) then
1170: p_rec.attribute4 :=
1171: pqh_acc_shd.g_old_rec.attribute4;
1172: End If;
1173: If (p_rec.attribute5 = hr_api.g_varchar2) then
1174: p_rec.attribute5 :=
1175: pqh_acc_shd.g_old_rec.attribute5;
1171: pqh_acc_shd.g_old_rec.attribute4;
1172: End If;
1173: If (p_rec.attribute5 = hr_api.g_varchar2) then
1174: p_rec.attribute5 :=
1175: pqh_acc_shd.g_old_rec.attribute5;
1176: End If;
1177: If (p_rec.attribute6 = hr_api.g_varchar2) then
1178: p_rec.attribute6 :=
1179: pqh_acc_shd.g_old_rec.attribute6;
1175: pqh_acc_shd.g_old_rec.attribute5;
1176: End If;
1177: If (p_rec.attribute6 = hr_api.g_varchar2) then
1178: p_rec.attribute6 :=
1179: pqh_acc_shd.g_old_rec.attribute6;
1180: End If;
1181: If (p_rec.attribute7 = hr_api.g_varchar2) then
1182: p_rec.attribute7 :=
1183: pqh_acc_shd.g_old_rec.attribute7;
1179: pqh_acc_shd.g_old_rec.attribute6;
1180: End If;
1181: If (p_rec.attribute7 = hr_api.g_varchar2) then
1182: p_rec.attribute7 :=
1183: pqh_acc_shd.g_old_rec.attribute7;
1184: End If;
1185: If (p_rec.attribute8 = hr_api.g_varchar2) then
1186: p_rec.attribute8 :=
1187: pqh_acc_shd.g_old_rec.attribute8;
1183: pqh_acc_shd.g_old_rec.attribute7;
1184: End If;
1185: If (p_rec.attribute8 = hr_api.g_varchar2) then
1186: p_rec.attribute8 :=
1187: pqh_acc_shd.g_old_rec.attribute8;
1188: End If;
1189: If (p_rec.attribute9 = hr_api.g_varchar2) then
1190: p_rec.attribute9 :=
1191: pqh_acc_shd.g_old_rec.attribute9;
1187: pqh_acc_shd.g_old_rec.attribute8;
1188: End If;
1189: If (p_rec.attribute9 = hr_api.g_varchar2) then
1190: p_rec.attribute9 :=
1191: pqh_acc_shd.g_old_rec.attribute9;
1192: End If;
1193: If (p_rec.attribute10 = hr_api.g_varchar2) then
1194: p_rec.attribute10 :=
1195: pqh_acc_shd.g_old_rec.attribute10;
1191: pqh_acc_shd.g_old_rec.attribute9;
1192: End If;
1193: If (p_rec.attribute10 = hr_api.g_varchar2) then
1194: p_rec.attribute10 :=
1195: pqh_acc_shd.g_old_rec.attribute10;
1196: End If;
1197: If (p_rec.attribute11 = hr_api.g_varchar2) then
1198: p_rec.attribute11 :=
1199: pqh_acc_shd.g_old_rec.attribute11;
1195: pqh_acc_shd.g_old_rec.attribute10;
1196: End If;
1197: If (p_rec.attribute11 = hr_api.g_varchar2) then
1198: p_rec.attribute11 :=
1199: pqh_acc_shd.g_old_rec.attribute11;
1200: End If;
1201: If (p_rec.attribute12 = hr_api.g_varchar2) then
1202: p_rec.attribute12 :=
1203: pqh_acc_shd.g_old_rec.attribute12;
1199: pqh_acc_shd.g_old_rec.attribute11;
1200: End If;
1201: If (p_rec.attribute12 = hr_api.g_varchar2) then
1202: p_rec.attribute12 :=
1203: pqh_acc_shd.g_old_rec.attribute12;
1204: End If;
1205: If (p_rec.attribute13 = hr_api.g_varchar2) then
1206: p_rec.attribute13 :=
1207: pqh_acc_shd.g_old_rec.attribute13;
1203: pqh_acc_shd.g_old_rec.attribute12;
1204: End If;
1205: If (p_rec.attribute13 = hr_api.g_varchar2) then
1206: p_rec.attribute13 :=
1207: pqh_acc_shd.g_old_rec.attribute13;
1208: End If;
1209: If (p_rec.attribute14 = hr_api.g_varchar2) then
1210: p_rec.attribute14 :=
1211: pqh_acc_shd.g_old_rec.attribute14;
1207: pqh_acc_shd.g_old_rec.attribute13;
1208: End If;
1209: If (p_rec.attribute14 = hr_api.g_varchar2) then
1210: p_rec.attribute14 :=
1211: pqh_acc_shd.g_old_rec.attribute14;
1212: End If;
1213: If (p_rec.attribute15 = hr_api.g_varchar2) then
1214: p_rec.attribute15 :=
1215: pqh_acc_shd.g_old_rec.attribute15;
1211: pqh_acc_shd.g_old_rec.attribute14;
1212: End If;
1213: If (p_rec.attribute15 = hr_api.g_varchar2) then
1214: p_rec.attribute15 :=
1215: pqh_acc_shd.g_old_rec.attribute15;
1216: End If;
1217: If (p_rec.attribute16 = hr_api.g_varchar2) then
1218: p_rec.attribute16 :=
1219: pqh_acc_shd.g_old_rec.attribute16;
1215: pqh_acc_shd.g_old_rec.attribute15;
1216: End If;
1217: If (p_rec.attribute16 = hr_api.g_varchar2) then
1218: p_rec.attribute16 :=
1219: pqh_acc_shd.g_old_rec.attribute16;
1220: End If;
1221: If (p_rec.attribute17 = hr_api.g_varchar2) then
1222: p_rec.attribute17 :=
1223: pqh_acc_shd.g_old_rec.attribute17;
1219: pqh_acc_shd.g_old_rec.attribute16;
1220: End If;
1221: If (p_rec.attribute17 = hr_api.g_varchar2) then
1222: p_rec.attribute17 :=
1223: pqh_acc_shd.g_old_rec.attribute17;
1224: End If;
1225: If (p_rec.attribute18 = hr_api.g_varchar2) then
1226: p_rec.attribute18 :=
1227: pqh_acc_shd.g_old_rec.attribute18;
1223: pqh_acc_shd.g_old_rec.attribute17;
1224: End If;
1225: If (p_rec.attribute18 = hr_api.g_varchar2) then
1226: p_rec.attribute18 :=
1227: pqh_acc_shd.g_old_rec.attribute18;
1228: End If;
1229: If (p_rec.attribute19 = hr_api.g_varchar2) then
1230: p_rec.attribute19 :=
1231: pqh_acc_shd.g_old_rec.attribute19;
1227: pqh_acc_shd.g_old_rec.attribute18;
1228: End If;
1229: If (p_rec.attribute19 = hr_api.g_varchar2) then
1230: p_rec.attribute19 :=
1231: pqh_acc_shd.g_old_rec.attribute19;
1232: End If;
1233: If (p_rec.attribute20 = hr_api.g_varchar2) then
1234: p_rec.attribute20 :=
1235: pqh_acc_shd.g_old_rec.attribute20;
1231: pqh_acc_shd.g_old_rec.attribute19;
1232: End If;
1233: If (p_rec.attribute20 = hr_api.g_varchar2) then
1234: p_rec.attribute20 :=
1235: pqh_acc_shd.g_old_rec.attribute20;
1236: End If;
1237: If (p_rec.attribute21 = hr_api.g_varchar2) then
1238: p_rec.attribute21 :=
1239: pqh_acc_shd.g_old_rec.attribute21;
1235: pqh_acc_shd.g_old_rec.attribute20;
1236: End If;
1237: If (p_rec.attribute21 = hr_api.g_varchar2) then
1238: p_rec.attribute21 :=
1239: pqh_acc_shd.g_old_rec.attribute21;
1240: End If;
1241: If (p_rec.attribute22 = hr_api.g_varchar2) then
1242: p_rec.attribute22 :=
1243: pqh_acc_shd.g_old_rec.attribute22;
1239: pqh_acc_shd.g_old_rec.attribute21;
1240: End If;
1241: If (p_rec.attribute22 = hr_api.g_varchar2) then
1242: p_rec.attribute22 :=
1243: pqh_acc_shd.g_old_rec.attribute22;
1244: End If;
1245: If (p_rec.attribute23 = hr_api.g_varchar2) then
1246: p_rec.attribute23 :=
1247: pqh_acc_shd.g_old_rec.attribute23;
1243: pqh_acc_shd.g_old_rec.attribute22;
1244: End If;
1245: If (p_rec.attribute23 = hr_api.g_varchar2) then
1246: p_rec.attribute23 :=
1247: pqh_acc_shd.g_old_rec.attribute23;
1248: End If;
1249: If (p_rec.attribute24 = hr_api.g_varchar2) then
1250: p_rec.attribute24 :=
1251: pqh_acc_shd.g_old_rec.attribute24;
1247: pqh_acc_shd.g_old_rec.attribute23;
1248: End If;
1249: If (p_rec.attribute24 = hr_api.g_varchar2) then
1250: p_rec.attribute24 :=
1251: pqh_acc_shd.g_old_rec.attribute24;
1252: End If;
1253: If (p_rec.attribute25 = hr_api.g_varchar2) then
1254: p_rec.attribute25 :=
1255: pqh_acc_shd.g_old_rec.attribute25;
1251: pqh_acc_shd.g_old_rec.attribute24;
1252: End If;
1253: If (p_rec.attribute25 = hr_api.g_varchar2) then
1254: p_rec.attribute25 :=
1255: pqh_acc_shd.g_old_rec.attribute25;
1256: End If;
1257: If (p_rec.attribute26 = hr_api.g_varchar2) then
1258: p_rec.attribute26 :=
1259: pqh_acc_shd.g_old_rec.attribute26;
1255: pqh_acc_shd.g_old_rec.attribute25;
1256: End If;
1257: If (p_rec.attribute26 = hr_api.g_varchar2) then
1258: p_rec.attribute26 :=
1259: pqh_acc_shd.g_old_rec.attribute26;
1260: End If;
1261: If (p_rec.attribute27 = hr_api.g_varchar2) then
1262: p_rec.attribute27 :=
1263: pqh_acc_shd.g_old_rec.attribute27;
1259: pqh_acc_shd.g_old_rec.attribute26;
1260: End If;
1261: If (p_rec.attribute27 = hr_api.g_varchar2) then
1262: p_rec.attribute27 :=
1263: pqh_acc_shd.g_old_rec.attribute27;
1264: End If;
1265: If (p_rec.attribute28 = hr_api.g_varchar2) then
1266: p_rec.attribute28 :=
1267: pqh_acc_shd.g_old_rec.attribute28;
1263: pqh_acc_shd.g_old_rec.attribute27;
1264: End If;
1265: If (p_rec.attribute28 = hr_api.g_varchar2) then
1266: p_rec.attribute28 :=
1267: pqh_acc_shd.g_old_rec.attribute28;
1268: End If;
1269: If (p_rec.attribute29 = hr_api.g_varchar2) then
1270: p_rec.attribute29 :=
1271: pqh_acc_shd.g_old_rec.attribute29;
1267: pqh_acc_shd.g_old_rec.attribute28;
1268: End If;
1269: If (p_rec.attribute29 = hr_api.g_varchar2) then
1270: p_rec.attribute29 :=
1271: pqh_acc_shd.g_old_rec.attribute29;
1272: End If;
1273: If (p_rec.attribute30 = hr_api.g_varchar2) then
1274: p_rec.attribute30 :=
1275: pqh_acc_shd.g_old_rec.attribute30;
1271: pqh_acc_shd.g_old_rec.attribute29;
1272: End If;
1273: If (p_rec.attribute30 = hr_api.g_varchar2) then
1274: p_rec.attribute30 :=
1275: pqh_acc_shd.g_old_rec.attribute30;
1276: End If;
1277: --
1278: End convert_defs;
1279: --
1282: -- ----------------------------------------------------------------------------
1283: Procedure upd
1284: (p_effective_date in date
1285: ,p_datetrack_mode in varchar2
1286: ,p_rec in out nocopy pqh_acc_shd.g_rec_type
1287: ) is
1288: --
1289: l_proc varchar2(72) := g_package||'upd';
1290: l_validation_start_date date;
1298: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1299: --
1300: -- We must lock the row which we need to update.
1301: --
1302: pqh_acc_shd.lck
1303: (p_effective_date => p_effective_date
1304: ,p_datetrack_mode => p_datetrack_mode
1305: ,p_accommodation_id => p_rec.accommodation_id
1306: ,p_object_version_number => p_rec.object_version_number
1462: ,p_effective_start_date out nocopy date
1463: ,p_effective_end_date out nocopy date
1464: ) is
1465: --
1466: l_rec pqh_acc_shd.g_rec_type;
1467: l_proc varchar2(72) := g_package||'upd';
1468: --
1469: Begin
1470: hr_utility.set_location('Entering:'||l_proc, 5);
1472: -- Call conversion function to turn arguments into the
1473: -- l_rec structure.
1474: --
1475: l_rec :=
1476: pqh_acc_shd.convert_args
1477: (p_accommodation_id
1478: ,p_accommodation_name
1479: ,null
1480: ,null