54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: PROCEDURE dt_update_dml
58: (p_rec IN OUT NOCOPY pqp_vre_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
182: EXCEPTION
183: WHEN hr_api.check_integrity_violated THEN
184: -- A check constraint has been violated
185: --
186: pqp_vre_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: WHEN hr_api.unique_integrity_violated THEN
189: -- Unique integrity has been violated
190: --
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: WHEN hr_api.unique_integrity_violated THEN
189: -- Unique integrity has been violated
190: --
191: pqp_vre_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: WHEN OTHERS THEN
194: --
195: RAISE;
226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_dml
230: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
231: ,p_effective_date IN DATE
232: ,p_datetrack_mode IN VARCHAR2
233: ,p_validation_start_date IN DATE
234: ,p_validation_end_date IN DATE
293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: PROCEDURE dt_pre_update
297: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
298: ,p_effective_date IN DATE
299: ,p_datetrack_mode IN VARCHAR2
300: ,p_validation_start_date IN DATE
301: ,p_validation_end_date IN DATE
309: IF (p_datetrack_mode <> hr_api.g_correction) THEN
310: --
311: -- Update the current effective end date
312: --
313: pqp_vre_shd.upd_effective_end_date
314: (p_effective_date => p_effective_date
315: ,p_base_key_value => p_rec.vehicle_repository_id
316: ,p_new_effective_end_date => (p_validation_start_date - 1)
317: ,p_validation_start_date => p_validation_start_date
378: --
379: -- {End Of Comments}
380: -- ----------------------------------------------------------------------------
381: PROCEDURE pre_update
382: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
383: ,p_effective_date IN DATE
384: ,p_datetrack_mode IN VARCHAR2
385: ,p_validation_start_date IN DATE
386: ,p_validation_end_date IN DATE
436: --
437: -- {End Of Comments}
438: -- ----------------------------------------------------------------------------
439: PROCEDURE post_update
440: (p_rec IN pqp_vre_shd.g_rec_type
441: ,p_effective_date IN DATE
442: ,p_datetrack_mode IN VARCHAR2
443: ,p_validation_start_date IN DATE
444: ,p_validation_end_date IN DATE
623: => p_rec.vre_information19
624: ,p_vre_information20
625: => p_rec.vre_information20
626: ,p_effective_start_date_o
627: => pqp_vre_shd.g_old_rec.effective_start_date
628: ,p_effective_end_date_o
629: => pqp_vre_shd.g_old_rec.effective_end_date
630: ,p_registration_number_o
631: => pqp_vre_shd.g_old_rec.registration_number
625: => p_rec.vre_information20
626: ,p_effective_start_date_o
627: => pqp_vre_shd.g_old_rec.effective_start_date
628: ,p_effective_end_date_o
629: => pqp_vre_shd.g_old_rec.effective_end_date
630: ,p_registration_number_o
631: => pqp_vre_shd.g_old_rec.registration_number
632: ,p_vehicle_type_o
633: => pqp_vre_shd.g_old_rec.vehicle_type
627: => pqp_vre_shd.g_old_rec.effective_start_date
628: ,p_effective_end_date_o
629: => pqp_vre_shd.g_old_rec.effective_end_date
630: ,p_registration_number_o
631: => pqp_vre_shd.g_old_rec.registration_number
632: ,p_vehicle_type_o
633: => pqp_vre_shd.g_old_rec.vehicle_type
634: ,p_vehicle_id_number_o
635: => pqp_vre_shd.g_old_rec.vehicle_id_number
629: => pqp_vre_shd.g_old_rec.effective_end_date
630: ,p_registration_number_o
631: => pqp_vre_shd.g_old_rec.registration_number
632: ,p_vehicle_type_o
633: => pqp_vre_shd.g_old_rec.vehicle_type
634: ,p_vehicle_id_number_o
635: => pqp_vre_shd.g_old_rec.vehicle_id_number
636: ,p_business_group_id_o
637: => pqp_vre_shd.g_old_rec.business_group_id
631: => pqp_vre_shd.g_old_rec.registration_number
632: ,p_vehicle_type_o
633: => pqp_vre_shd.g_old_rec.vehicle_type
634: ,p_vehicle_id_number_o
635: => pqp_vre_shd.g_old_rec.vehicle_id_number
636: ,p_business_group_id_o
637: => pqp_vre_shd.g_old_rec.business_group_id
638: ,p_make_o
639: => pqp_vre_shd.g_old_rec.make
633: => pqp_vre_shd.g_old_rec.vehicle_type
634: ,p_vehicle_id_number_o
635: => pqp_vre_shd.g_old_rec.vehicle_id_number
636: ,p_business_group_id_o
637: => pqp_vre_shd.g_old_rec.business_group_id
638: ,p_make_o
639: => pqp_vre_shd.g_old_rec.make
640: ,p_model_o
641: => pqp_vre_shd.g_old_rec.model
635: => pqp_vre_shd.g_old_rec.vehicle_id_number
636: ,p_business_group_id_o
637: => pqp_vre_shd.g_old_rec.business_group_id
638: ,p_make_o
639: => pqp_vre_shd.g_old_rec.make
640: ,p_model_o
641: => pqp_vre_shd.g_old_rec.model
642: ,p_initial_registration_o
643: => pqp_vre_shd.g_old_rec.initial_registration
637: => pqp_vre_shd.g_old_rec.business_group_id
638: ,p_make_o
639: => pqp_vre_shd.g_old_rec.make
640: ,p_model_o
641: => pqp_vre_shd.g_old_rec.model
642: ,p_initial_registration_o
643: => pqp_vre_shd.g_old_rec.initial_registration
644: ,p_last_registration_renew_da_o
645: => pqp_vre_shd.g_old_rec.last_registration_renew_date
639: => pqp_vre_shd.g_old_rec.make
640: ,p_model_o
641: => pqp_vre_shd.g_old_rec.model
642: ,p_initial_registration_o
643: => pqp_vre_shd.g_old_rec.initial_registration
644: ,p_last_registration_renew_da_o
645: => pqp_vre_shd.g_old_rec.last_registration_renew_date
646: ,p_engine_capacity_in_cc_o
647: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
641: => pqp_vre_shd.g_old_rec.model
642: ,p_initial_registration_o
643: => pqp_vre_shd.g_old_rec.initial_registration
644: ,p_last_registration_renew_da_o
645: => pqp_vre_shd.g_old_rec.last_registration_renew_date
646: ,p_engine_capacity_in_cc_o
647: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
648: ,p_fuel_type_o
649: => pqp_vre_shd.g_old_rec.fuel_type
643: => pqp_vre_shd.g_old_rec.initial_registration
644: ,p_last_registration_renew_da_o
645: => pqp_vre_shd.g_old_rec.last_registration_renew_date
646: ,p_engine_capacity_in_cc_o
647: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
648: ,p_fuel_type_o
649: => pqp_vre_shd.g_old_rec.fuel_type
650: ,p_currency_code_o
651: => pqp_vre_shd.g_old_rec.currency_code
645: => pqp_vre_shd.g_old_rec.last_registration_renew_date
646: ,p_engine_capacity_in_cc_o
647: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
648: ,p_fuel_type_o
649: => pqp_vre_shd.g_old_rec.fuel_type
650: ,p_currency_code_o
651: => pqp_vre_shd.g_old_rec.currency_code
652: ,p_list_price_o
653: => pqp_vre_shd.g_old_rec.list_price
647: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
648: ,p_fuel_type_o
649: => pqp_vre_shd.g_old_rec.fuel_type
650: ,p_currency_code_o
651: => pqp_vre_shd.g_old_rec.currency_code
652: ,p_list_price_o
653: => pqp_vre_shd.g_old_rec.list_price
654: ,p_accessory_value_at_startda_o
655: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
649: => pqp_vre_shd.g_old_rec.fuel_type
650: ,p_currency_code_o
651: => pqp_vre_shd.g_old_rec.currency_code
652: ,p_list_price_o
653: => pqp_vre_shd.g_old_rec.list_price
654: ,p_accessory_value_at_startda_o
655: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
656: ,p_accessory_value_added_late_o
657: => pqp_vre_shd.g_old_rec.accessory_value_added_later
651: => pqp_vre_shd.g_old_rec.currency_code
652: ,p_list_price_o
653: => pqp_vre_shd.g_old_rec.list_price
654: ,p_accessory_value_at_startda_o
655: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
656: ,p_accessory_value_added_late_o
657: => pqp_vre_shd.g_old_rec.accessory_value_added_later
658: ,p_market_value_classic_car_o
659: => pqp_vre_shd.g_old_rec.market_value_classic_car
653: => pqp_vre_shd.g_old_rec.list_price
654: ,p_accessory_value_at_startda_o
655: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
656: ,p_accessory_value_added_late_o
657: => pqp_vre_shd.g_old_rec.accessory_value_added_later
658: ,p_market_value_classic_car_o
659: => pqp_vre_shd.g_old_rec.market_value_classic_car
660: ,p_fiscal_ratings_o
661: => pqp_vre_shd.g_old_rec.fiscal_ratings
655: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
656: ,p_accessory_value_added_late_o
657: => pqp_vre_shd.g_old_rec.accessory_value_added_later
658: ,p_market_value_classic_car_o
659: => pqp_vre_shd.g_old_rec.market_value_classic_car
660: ,p_fiscal_ratings_o
661: => pqp_vre_shd.g_old_rec.fiscal_ratings
662: ,p_fiscal_ratings_uom_o
663: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
657: => pqp_vre_shd.g_old_rec.accessory_value_added_later
658: ,p_market_value_classic_car_o
659: => pqp_vre_shd.g_old_rec.market_value_classic_car
660: ,p_fiscal_ratings_o
661: => pqp_vre_shd.g_old_rec.fiscal_ratings
662: ,p_fiscal_ratings_uom_o
663: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
664: ,p_vehicle_provider_o
665: => pqp_vre_shd.g_old_rec.vehicle_provider
659: => pqp_vre_shd.g_old_rec.market_value_classic_car
660: ,p_fiscal_ratings_o
661: => pqp_vre_shd.g_old_rec.fiscal_ratings
662: ,p_fiscal_ratings_uom_o
663: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
664: ,p_vehicle_provider_o
665: => pqp_vre_shd.g_old_rec.vehicle_provider
666: ,p_vehicle_ownership_o
667: => pqp_vre_shd.g_old_rec.vehicle_ownership
661: => pqp_vre_shd.g_old_rec.fiscal_ratings
662: ,p_fiscal_ratings_uom_o
663: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
664: ,p_vehicle_provider_o
665: => pqp_vre_shd.g_old_rec.vehicle_provider
666: ,p_vehicle_ownership_o
667: => pqp_vre_shd.g_old_rec.vehicle_ownership
668: ,p_shared_vehicle_o
669: => pqp_vre_shd.g_old_rec.shared_vehicle
663: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
664: ,p_vehicle_provider_o
665: => pqp_vre_shd.g_old_rec.vehicle_provider
666: ,p_vehicle_ownership_o
667: => pqp_vre_shd.g_old_rec.vehicle_ownership
668: ,p_shared_vehicle_o
669: => pqp_vre_shd.g_old_rec.shared_vehicle
670: ,p_vehicle_status_o
671: => pqp_vre_shd.g_old_rec.vehicle_status
665: => pqp_vre_shd.g_old_rec.vehicle_provider
666: ,p_vehicle_ownership_o
667: => pqp_vre_shd.g_old_rec.vehicle_ownership
668: ,p_shared_vehicle_o
669: => pqp_vre_shd.g_old_rec.shared_vehicle
670: ,p_vehicle_status_o
671: => pqp_vre_shd.g_old_rec.vehicle_status
672: ,p_vehicle_inactivity_reason_o
673: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
667: => pqp_vre_shd.g_old_rec.vehicle_ownership
668: ,p_shared_vehicle_o
669: => pqp_vre_shd.g_old_rec.shared_vehicle
670: ,p_vehicle_status_o
671: => pqp_vre_shd.g_old_rec.vehicle_status
672: ,p_vehicle_inactivity_reason_o
673: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
674: ,p_asset_number_o
675: => pqp_vre_shd.g_old_rec.asset_number
669: => pqp_vre_shd.g_old_rec.shared_vehicle
670: ,p_vehicle_status_o
671: => pqp_vre_shd.g_old_rec.vehicle_status
672: ,p_vehicle_inactivity_reason_o
673: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
674: ,p_asset_number_o
675: => pqp_vre_shd.g_old_rec.asset_number
676: ,p_lease_contract_number_o
677: => pqp_vre_shd.g_old_rec.lease_contract_number
671: => pqp_vre_shd.g_old_rec.vehicle_status
672: ,p_vehicle_inactivity_reason_o
673: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
674: ,p_asset_number_o
675: => pqp_vre_shd.g_old_rec.asset_number
676: ,p_lease_contract_number_o
677: => pqp_vre_shd.g_old_rec.lease_contract_number
678: ,p_lease_contract_expiry_date_o
679: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
673: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
674: ,p_asset_number_o
675: => pqp_vre_shd.g_old_rec.asset_number
676: ,p_lease_contract_number_o
677: => pqp_vre_shd.g_old_rec.lease_contract_number
678: ,p_lease_contract_expiry_date_o
679: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
680: ,p_taxation_method_o
681: => pqp_vre_shd.g_old_rec.taxation_method
675: => pqp_vre_shd.g_old_rec.asset_number
676: ,p_lease_contract_number_o
677: => pqp_vre_shd.g_old_rec.lease_contract_number
678: ,p_lease_contract_expiry_date_o
679: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
680: ,p_taxation_method_o
681: => pqp_vre_shd.g_old_rec.taxation_method
682: ,p_fleet_info_o
683: => pqp_vre_shd.g_old_rec.fleet_info
677: => pqp_vre_shd.g_old_rec.lease_contract_number
678: ,p_lease_contract_expiry_date_o
679: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
680: ,p_taxation_method_o
681: => pqp_vre_shd.g_old_rec.taxation_method
682: ,p_fleet_info_o
683: => pqp_vre_shd.g_old_rec.fleet_info
684: ,p_fleet_transfer_date_o
685: => pqp_vre_shd.g_old_rec.fleet_transfer_date
679: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
680: ,p_taxation_method_o
681: => pqp_vre_shd.g_old_rec.taxation_method
682: ,p_fleet_info_o
683: => pqp_vre_shd.g_old_rec.fleet_info
684: ,p_fleet_transfer_date_o
685: => pqp_vre_shd.g_old_rec.fleet_transfer_date
686: ,p_object_version_number_o
687: => pqp_vre_shd.g_old_rec.object_version_number
681: => pqp_vre_shd.g_old_rec.taxation_method
682: ,p_fleet_info_o
683: => pqp_vre_shd.g_old_rec.fleet_info
684: ,p_fleet_transfer_date_o
685: => pqp_vre_shd.g_old_rec.fleet_transfer_date
686: ,p_object_version_number_o
687: => pqp_vre_shd.g_old_rec.object_version_number
688: ,p_color_o
689: => pqp_vre_shd.g_old_rec.color
683: => pqp_vre_shd.g_old_rec.fleet_info
684: ,p_fleet_transfer_date_o
685: => pqp_vre_shd.g_old_rec.fleet_transfer_date
686: ,p_object_version_number_o
687: => pqp_vre_shd.g_old_rec.object_version_number
688: ,p_color_o
689: => pqp_vre_shd.g_old_rec.color
690: ,p_seating_capacity_o
691: => pqp_vre_shd.g_old_rec.seating_capacity
685: => pqp_vre_shd.g_old_rec.fleet_transfer_date
686: ,p_object_version_number_o
687: => pqp_vre_shd.g_old_rec.object_version_number
688: ,p_color_o
689: => pqp_vre_shd.g_old_rec.color
690: ,p_seating_capacity_o
691: => pqp_vre_shd.g_old_rec.seating_capacity
692: ,p_weight_o
693: => pqp_vre_shd.g_old_rec.weight
687: => pqp_vre_shd.g_old_rec.object_version_number
688: ,p_color_o
689: => pqp_vre_shd.g_old_rec.color
690: ,p_seating_capacity_o
691: => pqp_vre_shd.g_old_rec.seating_capacity
692: ,p_weight_o
693: => pqp_vre_shd.g_old_rec.weight
694: ,p_weight_uom_o
695: => pqp_vre_shd.g_old_rec.weight_uom
689: => pqp_vre_shd.g_old_rec.color
690: ,p_seating_capacity_o
691: => pqp_vre_shd.g_old_rec.seating_capacity
692: ,p_weight_o
693: => pqp_vre_shd.g_old_rec.weight
694: ,p_weight_uom_o
695: => pqp_vre_shd.g_old_rec.weight_uom
696: ,p_model_year_o
697: => pqp_vre_shd.g_old_rec.model_year
691: => pqp_vre_shd.g_old_rec.seating_capacity
692: ,p_weight_o
693: => pqp_vre_shd.g_old_rec.weight
694: ,p_weight_uom_o
695: => pqp_vre_shd.g_old_rec.weight_uom
696: ,p_model_year_o
697: => pqp_vre_shd.g_old_rec.model_year
698: ,p_insurance_number_o
699: => pqp_vre_shd.g_old_rec.insurance_number
693: => pqp_vre_shd.g_old_rec.weight
694: ,p_weight_uom_o
695: => pqp_vre_shd.g_old_rec.weight_uom
696: ,p_model_year_o
697: => pqp_vre_shd.g_old_rec.model_year
698: ,p_insurance_number_o
699: => pqp_vre_shd.g_old_rec.insurance_number
700: ,p_insurance_expiry_date_o
701: => pqp_vre_shd.g_old_rec.insurance_expiry_date
695: => pqp_vre_shd.g_old_rec.weight_uom
696: ,p_model_year_o
697: => pqp_vre_shd.g_old_rec.model_year
698: ,p_insurance_number_o
699: => pqp_vre_shd.g_old_rec.insurance_number
700: ,p_insurance_expiry_date_o
701: => pqp_vre_shd.g_old_rec.insurance_expiry_date
702: ,p_comments_o
703: => pqp_vre_shd.g_old_rec.comments
697: => pqp_vre_shd.g_old_rec.model_year
698: ,p_insurance_number_o
699: => pqp_vre_shd.g_old_rec.insurance_number
700: ,p_insurance_expiry_date_o
701: => pqp_vre_shd.g_old_rec.insurance_expiry_date
702: ,p_comments_o
703: => pqp_vre_shd.g_old_rec.comments
704: ,p_vre_attribute_category_o
705: => pqp_vre_shd.g_old_rec.vre_attribute_category
699: => pqp_vre_shd.g_old_rec.insurance_number
700: ,p_insurance_expiry_date_o
701: => pqp_vre_shd.g_old_rec.insurance_expiry_date
702: ,p_comments_o
703: => pqp_vre_shd.g_old_rec.comments
704: ,p_vre_attribute_category_o
705: => pqp_vre_shd.g_old_rec.vre_attribute_category
706: ,p_vre_attribute1_o
707: => pqp_vre_shd.g_old_rec.vre_attribute1
701: => pqp_vre_shd.g_old_rec.insurance_expiry_date
702: ,p_comments_o
703: => pqp_vre_shd.g_old_rec.comments
704: ,p_vre_attribute_category_o
705: => pqp_vre_shd.g_old_rec.vre_attribute_category
706: ,p_vre_attribute1_o
707: => pqp_vre_shd.g_old_rec.vre_attribute1
708: ,p_vre_attribute2_o
709: => pqp_vre_shd.g_old_rec.vre_attribute2
703: => pqp_vre_shd.g_old_rec.comments
704: ,p_vre_attribute_category_o
705: => pqp_vre_shd.g_old_rec.vre_attribute_category
706: ,p_vre_attribute1_o
707: => pqp_vre_shd.g_old_rec.vre_attribute1
708: ,p_vre_attribute2_o
709: => pqp_vre_shd.g_old_rec.vre_attribute2
710: ,p_vre_attribute3_o
711: => pqp_vre_shd.g_old_rec.vre_attribute3
705: => pqp_vre_shd.g_old_rec.vre_attribute_category
706: ,p_vre_attribute1_o
707: => pqp_vre_shd.g_old_rec.vre_attribute1
708: ,p_vre_attribute2_o
709: => pqp_vre_shd.g_old_rec.vre_attribute2
710: ,p_vre_attribute3_o
711: => pqp_vre_shd.g_old_rec.vre_attribute3
712: ,p_vre_attribute4_o
713: => pqp_vre_shd.g_old_rec.vre_attribute4
707: => pqp_vre_shd.g_old_rec.vre_attribute1
708: ,p_vre_attribute2_o
709: => pqp_vre_shd.g_old_rec.vre_attribute2
710: ,p_vre_attribute3_o
711: => pqp_vre_shd.g_old_rec.vre_attribute3
712: ,p_vre_attribute4_o
713: => pqp_vre_shd.g_old_rec.vre_attribute4
714: ,p_vre_attribute5_o
715: => pqp_vre_shd.g_old_rec.vre_attribute5
709: => pqp_vre_shd.g_old_rec.vre_attribute2
710: ,p_vre_attribute3_o
711: => pqp_vre_shd.g_old_rec.vre_attribute3
712: ,p_vre_attribute4_o
713: => pqp_vre_shd.g_old_rec.vre_attribute4
714: ,p_vre_attribute5_o
715: => pqp_vre_shd.g_old_rec.vre_attribute5
716: ,p_vre_attribute6_o
717: => pqp_vre_shd.g_old_rec.vre_attribute6
711: => pqp_vre_shd.g_old_rec.vre_attribute3
712: ,p_vre_attribute4_o
713: => pqp_vre_shd.g_old_rec.vre_attribute4
714: ,p_vre_attribute5_o
715: => pqp_vre_shd.g_old_rec.vre_attribute5
716: ,p_vre_attribute6_o
717: => pqp_vre_shd.g_old_rec.vre_attribute6
718: ,p_vre_attribute7_o
719: => pqp_vre_shd.g_old_rec.vre_attribute7
713: => pqp_vre_shd.g_old_rec.vre_attribute4
714: ,p_vre_attribute5_o
715: => pqp_vre_shd.g_old_rec.vre_attribute5
716: ,p_vre_attribute6_o
717: => pqp_vre_shd.g_old_rec.vre_attribute6
718: ,p_vre_attribute7_o
719: => pqp_vre_shd.g_old_rec.vre_attribute7
720: ,p_vre_attribute8_o
721: => pqp_vre_shd.g_old_rec.vre_attribute8
715: => pqp_vre_shd.g_old_rec.vre_attribute5
716: ,p_vre_attribute6_o
717: => pqp_vre_shd.g_old_rec.vre_attribute6
718: ,p_vre_attribute7_o
719: => pqp_vre_shd.g_old_rec.vre_attribute7
720: ,p_vre_attribute8_o
721: => pqp_vre_shd.g_old_rec.vre_attribute8
722: ,p_vre_attribute9_o
723: => pqp_vre_shd.g_old_rec.vre_attribute9
717: => pqp_vre_shd.g_old_rec.vre_attribute6
718: ,p_vre_attribute7_o
719: => pqp_vre_shd.g_old_rec.vre_attribute7
720: ,p_vre_attribute8_o
721: => pqp_vre_shd.g_old_rec.vre_attribute8
722: ,p_vre_attribute9_o
723: => pqp_vre_shd.g_old_rec.vre_attribute9
724: ,p_vre_attribute10_o
725: => pqp_vre_shd.g_old_rec.vre_attribute10
719: => pqp_vre_shd.g_old_rec.vre_attribute7
720: ,p_vre_attribute8_o
721: => pqp_vre_shd.g_old_rec.vre_attribute8
722: ,p_vre_attribute9_o
723: => pqp_vre_shd.g_old_rec.vre_attribute9
724: ,p_vre_attribute10_o
725: => pqp_vre_shd.g_old_rec.vre_attribute10
726: ,p_vre_attribute11_o
727: => pqp_vre_shd.g_old_rec.vre_attribute11
721: => pqp_vre_shd.g_old_rec.vre_attribute8
722: ,p_vre_attribute9_o
723: => pqp_vre_shd.g_old_rec.vre_attribute9
724: ,p_vre_attribute10_o
725: => pqp_vre_shd.g_old_rec.vre_attribute10
726: ,p_vre_attribute11_o
727: => pqp_vre_shd.g_old_rec.vre_attribute11
728: ,p_vre_attribute12_o
729: => pqp_vre_shd.g_old_rec.vre_attribute12
723: => pqp_vre_shd.g_old_rec.vre_attribute9
724: ,p_vre_attribute10_o
725: => pqp_vre_shd.g_old_rec.vre_attribute10
726: ,p_vre_attribute11_o
727: => pqp_vre_shd.g_old_rec.vre_attribute11
728: ,p_vre_attribute12_o
729: => pqp_vre_shd.g_old_rec.vre_attribute12
730: ,p_vre_attribute13_o
731: => pqp_vre_shd.g_old_rec.vre_attribute13
725: => pqp_vre_shd.g_old_rec.vre_attribute10
726: ,p_vre_attribute11_o
727: => pqp_vre_shd.g_old_rec.vre_attribute11
728: ,p_vre_attribute12_o
729: => pqp_vre_shd.g_old_rec.vre_attribute12
730: ,p_vre_attribute13_o
731: => pqp_vre_shd.g_old_rec.vre_attribute13
732: ,p_vre_attribute14_o
733: => pqp_vre_shd.g_old_rec.vre_attribute14
727: => pqp_vre_shd.g_old_rec.vre_attribute11
728: ,p_vre_attribute12_o
729: => pqp_vre_shd.g_old_rec.vre_attribute12
730: ,p_vre_attribute13_o
731: => pqp_vre_shd.g_old_rec.vre_attribute13
732: ,p_vre_attribute14_o
733: => pqp_vre_shd.g_old_rec.vre_attribute14
734: ,p_vre_attribute15_o
735: => pqp_vre_shd.g_old_rec.vre_attribute15
729: => pqp_vre_shd.g_old_rec.vre_attribute12
730: ,p_vre_attribute13_o
731: => pqp_vre_shd.g_old_rec.vre_attribute13
732: ,p_vre_attribute14_o
733: => pqp_vre_shd.g_old_rec.vre_attribute14
734: ,p_vre_attribute15_o
735: => pqp_vre_shd.g_old_rec.vre_attribute15
736: ,p_vre_attribute16_o
737: => pqp_vre_shd.g_old_rec.vre_attribute16
731: => pqp_vre_shd.g_old_rec.vre_attribute13
732: ,p_vre_attribute14_o
733: => pqp_vre_shd.g_old_rec.vre_attribute14
734: ,p_vre_attribute15_o
735: => pqp_vre_shd.g_old_rec.vre_attribute15
736: ,p_vre_attribute16_o
737: => pqp_vre_shd.g_old_rec.vre_attribute16
738: ,p_vre_attribute17_o
739: => pqp_vre_shd.g_old_rec.vre_attribute17
733: => pqp_vre_shd.g_old_rec.vre_attribute14
734: ,p_vre_attribute15_o
735: => pqp_vre_shd.g_old_rec.vre_attribute15
736: ,p_vre_attribute16_o
737: => pqp_vre_shd.g_old_rec.vre_attribute16
738: ,p_vre_attribute17_o
739: => pqp_vre_shd.g_old_rec.vre_attribute17
740: ,p_vre_attribute18_o
741: => pqp_vre_shd.g_old_rec.vre_attribute18
735: => pqp_vre_shd.g_old_rec.vre_attribute15
736: ,p_vre_attribute16_o
737: => pqp_vre_shd.g_old_rec.vre_attribute16
738: ,p_vre_attribute17_o
739: => pqp_vre_shd.g_old_rec.vre_attribute17
740: ,p_vre_attribute18_o
741: => pqp_vre_shd.g_old_rec.vre_attribute18
742: ,p_vre_attribute19_o
743: => pqp_vre_shd.g_old_rec.vre_attribute19
737: => pqp_vre_shd.g_old_rec.vre_attribute16
738: ,p_vre_attribute17_o
739: => pqp_vre_shd.g_old_rec.vre_attribute17
740: ,p_vre_attribute18_o
741: => pqp_vre_shd.g_old_rec.vre_attribute18
742: ,p_vre_attribute19_o
743: => pqp_vre_shd.g_old_rec.vre_attribute19
744: ,p_vre_attribute20_o
745: => pqp_vre_shd.g_old_rec.vre_attribute20
739: => pqp_vre_shd.g_old_rec.vre_attribute17
740: ,p_vre_attribute18_o
741: => pqp_vre_shd.g_old_rec.vre_attribute18
742: ,p_vre_attribute19_o
743: => pqp_vre_shd.g_old_rec.vre_attribute19
744: ,p_vre_attribute20_o
745: => pqp_vre_shd.g_old_rec.vre_attribute20
746: ,p_vre_information_category_o
747: => pqp_vre_shd.g_old_rec.vre_information_category
741: => pqp_vre_shd.g_old_rec.vre_attribute18
742: ,p_vre_attribute19_o
743: => pqp_vre_shd.g_old_rec.vre_attribute19
744: ,p_vre_attribute20_o
745: => pqp_vre_shd.g_old_rec.vre_attribute20
746: ,p_vre_information_category_o
747: => pqp_vre_shd.g_old_rec.vre_information_category
748: ,p_vre_information1_o
749: => pqp_vre_shd.g_old_rec.vre_information1
743: => pqp_vre_shd.g_old_rec.vre_attribute19
744: ,p_vre_attribute20_o
745: => pqp_vre_shd.g_old_rec.vre_attribute20
746: ,p_vre_information_category_o
747: => pqp_vre_shd.g_old_rec.vre_information_category
748: ,p_vre_information1_o
749: => pqp_vre_shd.g_old_rec.vre_information1
750: ,p_vre_information2_o
751: => pqp_vre_shd.g_old_rec.vre_information2
745: => pqp_vre_shd.g_old_rec.vre_attribute20
746: ,p_vre_information_category_o
747: => pqp_vre_shd.g_old_rec.vre_information_category
748: ,p_vre_information1_o
749: => pqp_vre_shd.g_old_rec.vre_information1
750: ,p_vre_information2_o
751: => pqp_vre_shd.g_old_rec.vre_information2
752: ,p_vre_information3_o
753: => pqp_vre_shd.g_old_rec.vre_information3
747: => pqp_vre_shd.g_old_rec.vre_information_category
748: ,p_vre_information1_o
749: => pqp_vre_shd.g_old_rec.vre_information1
750: ,p_vre_information2_o
751: => pqp_vre_shd.g_old_rec.vre_information2
752: ,p_vre_information3_o
753: => pqp_vre_shd.g_old_rec.vre_information3
754: ,p_vre_information4_o
755: => pqp_vre_shd.g_old_rec.vre_information4
749: => pqp_vre_shd.g_old_rec.vre_information1
750: ,p_vre_information2_o
751: => pqp_vre_shd.g_old_rec.vre_information2
752: ,p_vre_information3_o
753: => pqp_vre_shd.g_old_rec.vre_information3
754: ,p_vre_information4_o
755: => pqp_vre_shd.g_old_rec.vre_information4
756: ,p_vre_information5_o
757: => pqp_vre_shd.g_old_rec.vre_information5
751: => pqp_vre_shd.g_old_rec.vre_information2
752: ,p_vre_information3_o
753: => pqp_vre_shd.g_old_rec.vre_information3
754: ,p_vre_information4_o
755: => pqp_vre_shd.g_old_rec.vre_information4
756: ,p_vre_information5_o
757: => pqp_vre_shd.g_old_rec.vre_information5
758: ,p_vre_information6_o
759: => pqp_vre_shd.g_old_rec.vre_information6
753: => pqp_vre_shd.g_old_rec.vre_information3
754: ,p_vre_information4_o
755: => pqp_vre_shd.g_old_rec.vre_information4
756: ,p_vre_information5_o
757: => pqp_vre_shd.g_old_rec.vre_information5
758: ,p_vre_information6_o
759: => pqp_vre_shd.g_old_rec.vre_information6
760: ,p_vre_information7_o
761: => pqp_vre_shd.g_old_rec.vre_information7
755: => pqp_vre_shd.g_old_rec.vre_information4
756: ,p_vre_information5_o
757: => pqp_vre_shd.g_old_rec.vre_information5
758: ,p_vre_information6_o
759: => pqp_vre_shd.g_old_rec.vre_information6
760: ,p_vre_information7_o
761: => pqp_vre_shd.g_old_rec.vre_information7
762: ,p_vre_information8_o
763: => pqp_vre_shd.g_old_rec.vre_information8
757: => pqp_vre_shd.g_old_rec.vre_information5
758: ,p_vre_information6_o
759: => pqp_vre_shd.g_old_rec.vre_information6
760: ,p_vre_information7_o
761: => pqp_vre_shd.g_old_rec.vre_information7
762: ,p_vre_information8_o
763: => pqp_vre_shd.g_old_rec.vre_information8
764: ,p_vre_information9_o
765: => pqp_vre_shd.g_old_rec.vre_information9
759: => pqp_vre_shd.g_old_rec.vre_information6
760: ,p_vre_information7_o
761: => pqp_vre_shd.g_old_rec.vre_information7
762: ,p_vre_information8_o
763: => pqp_vre_shd.g_old_rec.vre_information8
764: ,p_vre_information9_o
765: => pqp_vre_shd.g_old_rec.vre_information9
766: ,p_vre_information10_o
767: => pqp_vre_shd.g_old_rec.vre_information10
761: => pqp_vre_shd.g_old_rec.vre_information7
762: ,p_vre_information8_o
763: => pqp_vre_shd.g_old_rec.vre_information8
764: ,p_vre_information9_o
765: => pqp_vre_shd.g_old_rec.vre_information9
766: ,p_vre_information10_o
767: => pqp_vre_shd.g_old_rec.vre_information10
768: ,p_vre_information11_o
769: => pqp_vre_shd.g_old_rec.vre_information11
763: => pqp_vre_shd.g_old_rec.vre_information8
764: ,p_vre_information9_o
765: => pqp_vre_shd.g_old_rec.vre_information9
766: ,p_vre_information10_o
767: => pqp_vre_shd.g_old_rec.vre_information10
768: ,p_vre_information11_o
769: => pqp_vre_shd.g_old_rec.vre_information11
770: ,p_vre_information12_o
771: => pqp_vre_shd.g_old_rec.vre_information12
765: => pqp_vre_shd.g_old_rec.vre_information9
766: ,p_vre_information10_o
767: => pqp_vre_shd.g_old_rec.vre_information10
768: ,p_vre_information11_o
769: => pqp_vre_shd.g_old_rec.vre_information11
770: ,p_vre_information12_o
771: => pqp_vre_shd.g_old_rec.vre_information12
772: ,p_vre_information13_o
773: => pqp_vre_shd.g_old_rec.vre_information13
767: => pqp_vre_shd.g_old_rec.vre_information10
768: ,p_vre_information11_o
769: => pqp_vre_shd.g_old_rec.vre_information11
770: ,p_vre_information12_o
771: => pqp_vre_shd.g_old_rec.vre_information12
772: ,p_vre_information13_o
773: => pqp_vre_shd.g_old_rec.vre_information13
774: ,p_vre_information14_o
775: => pqp_vre_shd.g_old_rec.vre_information14
769: => pqp_vre_shd.g_old_rec.vre_information11
770: ,p_vre_information12_o
771: => pqp_vre_shd.g_old_rec.vre_information12
772: ,p_vre_information13_o
773: => pqp_vre_shd.g_old_rec.vre_information13
774: ,p_vre_information14_o
775: => pqp_vre_shd.g_old_rec.vre_information14
776: ,p_vre_information15_o
777: => pqp_vre_shd.g_old_rec.vre_information15
771: => pqp_vre_shd.g_old_rec.vre_information12
772: ,p_vre_information13_o
773: => pqp_vre_shd.g_old_rec.vre_information13
774: ,p_vre_information14_o
775: => pqp_vre_shd.g_old_rec.vre_information14
776: ,p_vre_information15_o
777: => pqp_vre_shd.g_old_rec.vre_information15
778: ,p_vre_information16_o
779: => pqp_vre_shd.g_old_rec.vre_information16
773: => pqp_vre_shd.g_old_rec.vre_information13
774: ,p_vre_information14_o
775: => pqp_vre_shd.g_old_rec.vre_information14
776: ,p_vre_information15_o
777: => pqp_vre_shd.g_old_rec.vre_information15
778: ,p_vre_information16_o
779: => pqp_vre_shd.g_old_rec.vre_information16
780: ,p_vre_information17_o
781: => pqp_vre_shd.g_old_rec.vre_information17
775: => pqp_vre_shd.g_old_rec.vre_information14
776: ,p_vre_information15_o
777: => pqp_vre_shd.g_old_rec.vre_information15
778: ,p_vre_information16_o
779: => pqp_vre_shd.g_old_rec.vre_information16
780: ,p_vre_information17_o
781: => pqp_vre_shd.g_old_rec.vre_information17
782: ,p_vre_information18_o
783: => pqp_vre_shd.g_old_rec.vre_information18
777: => pqp_vre_shd.g_old_rec.vre_information15
778: ,p_vre_information16_o
779: => pqp_vre_shd.g_old_rec.vre_information16
780: ,p_vre_information17_o
781: => pqp_vre_shd.g_old_rec.vre_information17
782: ,p_vre_information18_o
783: => pqp_vre_shd.g_old_rec.vre_information18
784: ,p_vre_information19_o
785: => pqp_vre_shd.g_old_rec.vre_information19
779: => pqp_vre_shd.g_old_rec.vre_information16
780: ,p_vre_information17_o
781: => pqp_vre_shd.g_old_rec.vre_information17
782: ,p_vre_information18_o
783: => pqp_vre_shd.g_old_rec.vre_information18
784: ,p_vre_information19_o
785: => pqp_vre_shd.g_old_rec.vre_information19
786: ,p_vre_information20_o
787: => pqp_vre_shd.g_old_rec.vre_information20
781: => pqp_vre_shd.g_old_rec.vre_information17
782: ,p_vre_information18_o
783: => pqp_vre_shd.g_old_rec.vre_information18
784: ,p_vre_information19_o
785: => pqp_vre_shd.g_old_rec.vre_information19
786: ,p_vre_information20_o
787: => pqp_vre_shd.g_old_rec.vre_information20
788: );
789: --
783: => pqp_vre_shd.g_old_rec.vre_information18
784: ,p_vre_information19_o
785: => pqp_vre_shd.g_old_rec.vre_information19
786: ,p_vre_information20_o
787: => pqp_vre_shd.g_old_rec.vre_information20
788: );
789: --
790: EXCEPTION
791: --
843: --
844: -- {End Of Comments}
845: -- ----------------------------------------------------------------------------
846: PROCEDURE convert_defs
847: (p_rec in out nocopy pqp_vre_shd.g_rec_type
848: ) IS
849: --
850: BEGIN
851: --
855: -- is being used then we must set to the 'current' argument value.
856: --
857: IF (p_rec.registration_number = hr_api.g_varchar2) THEN
858: p_rec.registration_number :=
859: pqp_vre_shd.g_old_rec.registration_number;
860: END IF;
861: IF (p_rec.vehicle_type = hr_api.g_varchar2) THEN
862: p_rec.vehicle_type :=
863: pqp_vre_shd.g_old_rec.vehicle_type;
859: pqp_vre_shd.g_old_rec.registration_number;
860: END IF;
861: IF (p_rec.vehicle_type = hr_api.g_varchar2) THEN
862: p_rec.vehicle_type :=
863: pqp_vre_shd.g_old_rec.vehicle_type;
864: END IF;
865: IF (p_rec.vehicle_id_number = hr_api.g_varchar2) THEN
866: p_rec.vehicle_id_number :=
867: pqp_vre_shd.g_old_rec.vehicle_id_number;
863: pqp_vre_shd.g_old_rec.vehicle_type;
864: END IF;
865: IF (p_rec.vehicle_id_number = hr_api.g_varchar2) THEN
866: p_rec.vehicle_id_number :=
867: pqp_vre_shd.g_old_rec.vehicle_id_number;
868: END IF;
869: IF (p_rec.business_group_id = hr_api.g_number) THEN
870: p_rec.business_group_id :=
871: pqp_vre_shd.g_old_rec.business_group_id;
867: pqp_vre_shd.g_old_rec.vehicle_id_number;
868: END IF;
869: IF (p_rec.business_group_id = hr_api.g_number) THEN
870: p_rec.business_group_id :=
871: pqp_vre_shd.g_old_rec.business_group_id;
872: END IF;
873: IF (p_rec.make = hr_api.g_varchar2) THEN
874: p_rec.make :=
875: pqp_vre_shd.g_old_rec.make;
871: pqp_vre_shd.g_old_rec.business_group_id;
872: END IF;
873: IF (p_rec.make = hr_api.g_varchar2) THEN
874: p_rec.make :=
875: pqp_vre_shd.g_old_rec.make;
876: END IF;
877: IF (p_rec.model = hr_api.g_varchar2) THEN
878: p_rec.model :=
879: pqp_vre_shd.g_old_rec.model;
875: pqp_vre_shd.g_old_rec.make;
876: END IF;
877: IF (p_rec.model = hr_api.g_varchar2) THEN
878: p_rec.model :=
879: pqp_vre_shd.g_old_rec.model;
880: END IF;
881: IF (p_rec.initial_registration = hr_api.g_date) THEN
882: p_rec.initial_registration :=
883: pqp_vre_shd.g_old_rec.initial_registration;
879: pqp_vre_shd.g_old_rec.model;
880: END IF;
881: IF (p_rec.initial_registration = hr_api.g_date) THEN
882: p_rec.initial_registration :=
883: pqp_vre_shd.g_old_rec.initial_registration;
884: END IF;
885: IF (p_rec.last_registration_renew_date = hr_api.g_date) THEN
886: p_rec.last_registration_renew_date :=
887: pqp_vre_shd.g_old_rec.last_registration_renew_date;
883: pqp_vre_shd.g_old_rec.initial_registration;
884: END IF;
885: IF (p_rec.last_registration_renew_date = hr_api.g_date) THEN
886: p_rec.last_registration_renew_date :=
887: pqp_vre_shd.g_old_rec.last_registration_renew_date;
888: END IF;
889: IF (p_rec.engine_capacity_in_cc = hr_api.g_number) THEN
890: p_rec.engine_capacity_in_cc :=
891: pqp_vre_shd.g_old_rec.engine_capacity_in_cc;
887: pqp_vre_shd.g_old_rec.last_registration_renew_date;
888: END IF;
889: IF (p_rec.engine_capacity_in_cc = hr_api.g_number) THEN
890: p_rec.engine_capacity_in_cc :=
891: pqp_vre_shd.g_old_rec.engine_capacity_in_cc;
892: END IF;
893: IF (p_rec.fuel_type = hr_api.g_varchar2) THEN
894: p_rec.fuel_type :=
895: pqp_vre_shd.g_old_rec.fuel_type;
891: pqp_vre_shd.g_old_rec.engine_capacity_in_cc;
892: END IF;
893: IF (p_rec.fuel_type = hr_api.g_varchar2) THEN
894: p_rec.fuel_type :=
895: pqp_vre_shd.g_old_rec.fuel_type;
896: END IF;
897: IF (p_rec.currency_code = hr_api.g_varchar2) THEN
898: p_rec.currency_code :=
899: pqp_vre_shd.g_old_rec.currency_code;
895: pqp_vre_shd.g_old_rec.fuel_type;
896: END IF;
897: IF (p_rec.currency_code = hr_api.g_varchar2) THEN
898: p_rec.currency_code :=
899: pqp_vre_shd.g_old_rec.currency_code;
900: END IF;
901: IF (p_rec.list_price = hr_api.g_number) THEN
902: p_rec.list_price :=
903: pqp_vre_shd.g_old_rec.list_price;
899: pqp_vre_shd.g_old_rec.currency_code;
900: END IF;
901: IF (p_rec.list_price = hr_api.g_number) THEN
902: p_rec.list_price :=
903: pqp_vre_shd.g_old_rec.list_price;
904: END IF;
905: IF (p_rec.accessory_value_at_startdate = hr_api.g_number) THEN
906: p_rec.accessory_value_at_startdate :=
907: pqp_vre_shd.g_old_rec.accessory_value_at_startdate;
903: pqp_vre_shd.g_old_rec.list_price;
904: END IF;
905: IF (p_rec.accessory_value_at_startdate = hr_api.g_number) THEN
906: p_rec.accessory_value_at_startdate :=
907: pqp_vre_shd.g_old_rec.accessory_value_at_startdate;
908: END IF;
909: IF (p_rec.accessory_value_added_later = hr_api.g_number) THEN
910: p_rec.accessory_value_added_later :=
911: pqp_vre_shd.g_old_rec.accessory_value_added_later;
907: pqp_vre_shd.g_old_rec.accessory_value_at_startdate;
908: END IF;
909: IF (p_rec.accessory_value_added_later = hr_api.g_number) THEN
910: p_rec.accessory_value_added_later :=
911: pqp_vre_shd.g_old_rec.accessory_value_added_later;
912: END IF;
913: IF (p_rec.market_value_classic_car = hr_api.g_number) THEN
914: p_rec.market_value_classic_car :=
915: pqp_vre_shd.g_old_rec.market_value_classic_car;
911: pqp_vre_shd.g_old_rec.accessory_value_added_later;
912: END IF;
913: IF (p_rec.market_value_classic_car = hr_api.g_number) THEN
914: p_rec.market_value_classic_car :=
915: pqp_vre_shd.g_old_rec.market_value_classic_car;
916: END IF;
917: IF (p_rec.fiscal_ratings = hr_api.g_number) THEN
918: p_rec.fiscal_ratings :=
919: pqp_vre_shd.g_old_rec.fiscal_ratings;
915: pqp_vre_shd.g_old_rec.market_value_classic_car;
916: END IF;
917: IF (p_rec.fiscal_ratings = hr_api.g_number) THEN
918: p_rec.fiscal_ratings :=
919: pqp_vre_shd.g_old_rec.fiscal_ratings;
920: END IF;
921: IF (p_rec.fiscal_ratings_uom = hr_api.g_varchar2) THEN
922: p_rec.fiscal_ratings_uom :=
923: pqp_vre_shd.g_old_rec.fiscal_ratings_uom;
919: pqp_vre_shd.g_old_rec.fiscal_ratings;
920: END IF;
921: IF (p_rec.fiscal_ratings_uom = hr_api.g_varchar2) THEN
922: p_rec.fiscal_ratings_uom :=
923: pqp_vre_shd.g_old_rec.fiscal_ratings_uom;
924: END IF;
925: IF (p_rec.vehicle_provider = hr_api.g_varchar2) THEN
926: p_rec.vehicle_provider :=
927: pqp_vre_shd.g_old_rec.vehicle_provider;
923: pqp_vre_shd.g_old_rec.fiscal_ratings_uom;
924: END IF;
925: IF (p_rec.vehicle_provider = hr_api.g_varchar2) THEN
926: p_rec.vehicle_provider :=
927: pqp_vre_shd.g_old_rec.vehicle_provider;
928: END IF;
929: IF (p_rec.vehicle_ownership = hr_api.g_varchar2) THEN
930: p_rec.vehicle_ownership :=
931: pqp_vre_shd.g_old_rec.vehicle_ownership;
927: pqp_vre_shd.g_old_rec.vehicle_provider;
928: END IF;
929: IF (p_rec.vehicle_ownership = hr_api.g_varchar2) THEN
930: p_rec.vehicle_ownership :=
931: pqp_vre_shd.g_old_rec.vehicle_ownership;
932: END IF;
933: IF (p_rec.shared_vehicle = hr_api.g_varchar2) THEN
934: p_rec.shared_vehicle :=
935: pqp_vre_shd.g_old_rec.shared_vehicle;
931: pqp_vre_shd.g_old_rec.vehicle_ownership;
932: END IF;
933: IF (p_rec.shared_vehicle = hr_api.g_varchar2) THEN
934: p_rec.shared_vehicle :=
935: pqp_vre_shd.g_old_rec.shared_vehicle;
936: END IF;
937: IF (p_rec.vehicle_status = hr_api.g_varchar2) THEN
938: p_rec.vehicle_status :=
939: pqp_vre_shd.g_old_rec.vehicle_status;
935: pqp_vre_shd.g_old_rec.shared_vehicle;
936: END IF;
937: IF (p_rec.vehicle_status = hr_api.g_varchar2) THEN
938: p_rec.vehicle_status :=
939: pqp_vre_shd.g_old_rec.vehicle_status;
940: END IF;
941: IF (p_rec.vehicle_inactivity_reason = hr_api.g_varchar2) THEN
942: p_rec.vehicle_inactivity_reason :=
943: pqp_vre_shd.g_old_rec.vehicle_inactivity_reason;
939: pqp_vre_shd.g_old_rec.vehicle_status;
940: END IF;
941: IF (p_rec.vehicle_inactivity_reason = hr_api.g_varchar2) THEN
942: p_rec.vehicle_inactivity_reason :=
943: pqp_vre_shd.g_old_rec.vehicle_inactivity_reason;
944: END IF;
945: IF (p_rec.asset_number = hr_api.g_varchar2) THEN
946: p_rec.asset_number :=
947: pqp_vre_shd.g_old_rec.asset_number;
943: pqp_vre_shd.g_old_rec.vehicle_inactivity_reason;
944: END IF;
945: IF (p_rec.asset_number = hr_api.g_varchar2) THEN
946: p_rec.asset_number :=
947: pqp_vre_shd.g_old_rec.asset_number;
948: END IF;
949: IF (p_rec.lease_contract_number = hr_api.g_varchar2) THEN
950: p_rec.lease_contract_number :=
951: pqp_vre_shd.g_old_rec.lease_contract_number;
947: pqp_vre_shd.g_old_rec.asset_number;
948: END IF;
949: IF (p_rec.lease_contract_number = hr_api.g_varchar2) THEN
950: p_rec.lease_contract_number :=
951: pqp_vre_shd.g_old_rec.lease_contract_number;
952: END IF;
953: IF (p_rec.lease_contract_expiry_date = hr_api.g_date) THEN
954: p_rec.lease_contract_expiry_date :=
955: pqp_vre_shd.g_old_rec.lease_contract_expiry_date;
951: pqp_vre_shd.g_old_rec.lease_contract_number;
952: END IF;
953: IF (p_rec.lease_contract_expiry_date = hr_api.g_date) THEN
954: p_rec.lease_contract_expiry_date :=
955: pqp_vre_shd.g_old_rec.lease_contract_expiry_date;
956: END IF;
957: IF (p_rec.taxation_method = hr_api.g_varchar2) THEN
958: p_rec.taxation_method :=
959: pqp_vre_shd.g_old_rec.taxation_method;
955: pqp_vre_shd.g_old_rec.lease_contract_expiry_date;
956: END IF;
957: IF (p_rec.taxation_method = hr_api.g_varchar2) THEN
958: p_rec.taxation_method :=
959: pqp_vre_shd.g_old_rec.taxation_method;
960: END IF;
961: IF (p_rec.fleet_info = hr_api.g_varchar2) THEN
962: p_rec.fleet_info :=
963: pqp_vre_shd.g_old_rec.fleet_info;
959: pqp_vre_shd.g_old_rec.taxation_method;
960: END IF;
961: IF (p_rec.fleet_info = hr_api.g_varchar2) THEN
962: p_rec.fleet_info :=
963: pqp_vre_shd.g_old_rec.fleet_info;
964: END IF;
965: IF (p_rec.fleet_transfer_date = hr_api.g_date) THEN
966: p_rec.fleet_transfer_date :=
967: pqp_vre_shd.g_old_rec.fleet_transfer_date;
963: pqp_vre_shd.g_old_rec.fleet_info;
964: END IF;
965: IF (p_rec.fleet_transfer_date = hr_api.g_date) THEN
966: p_rec.fleet_transfer_date :=
967: pqp_vre_shd.g_old_rec.fleet_transfer_date;
968: END IF;
969: IF (p_rec.color = hr_api.g_varchar2) THEN
970: p_rec.color :=
971: pqp_vre_shd.g_old_rec.color;
967: pqp_vre_shd.g_old_rec.fleet_transfer_date;
968: END IF;
969: IF (p_rec.color = hr_api.g_varchar2) THEN
970: p_rec.color :=
971: pqp_vre_shd.g_old_rec.color;
972: END IF;
973: IF (p_rec.seating_capacity = hr_api.g_number) THEN
974: p_rec.seating_capacity :=
975: pqp_vre_shd.g_old_rec.seating_capacity;
971: pqp_vre_shd.g_old_rec.color;
972: END IF;
973: IF (p_rec.seating_capacity = hr_api.g_number) THEN
974: p_rec.seating_capacity :=
975: pqp_vre_shd.g_old_rec.seating_capacity;
976: END IF;
977: IF (p_rec.weight = hr_api.g_number) THEN
978: p_rec.weight :=
979: pqp_vre_shd.g_old_rec.weight;
975: pqp_vre_shd.g_old_rec.seating_capacity;
976: END IF;
977: IF (p_rec.weight = hr_api.g_number) THEN
978: p_rec.weight :=
979: pqp_vre_shd.g_old_rec.weight;
980: END IF;
981: IF (p_rec.weight_uom = hr_api.g_varchar2) THEN
982: p_rec.weight_uom :=
983: pqp_vre_shd.g_old_rec.weight_uom;
979: pqp_vre_shd.g_old_rec.weight;
980: END IF;
981: IF (p_rec.weight_uom = hr_api.g_varchar2) THEN
982: p_rec.weight_uom :=
983: pqp_vre_shd.g_old_rec.weight_uom;
984: END IF;
985: IF (p_rec.model_year = hr_api.g_number) THEN
986: p_rec.model_year :=
987: pqp_vre_shd.g_old_rec.model_year;
983: pqp_vre_shd.g_old_rec.weight_uom;
984: END IF;
985: IF (p_rec.model_year = hr_api.g_number) THEN
986: p_rec.model_year :=
987: pqp_vre_shd.g_old_rec.model_year;
988: END IF;
989: IF (p_rec.insurance_number = hr_api.g_varchar2) THEN
990: p_rec.insurance_number :=
991: pqp_vre_shd.g_old_rec.insurance_number;
987: pqp_vre_shd.g_old_rec.model_year;
988: END IF;
989: IF (p_rec.insurance_number = hr_api.g_varchar2) THEN
990: p_rec.insurance_number :=
991: pqp_vre_shd.g_old_rec.insurance_number;
992: END IF;
993: IF (p_rec.insurance_expiry_date = hr_api.g_date) THEN
994: p_rec.insurance_expiry_date :=
995: pqp_vre_shd.g_old_rec.insurance_expiry_date;
991: pqp_vre_shd.g_old_rec.insurance_number;
992: END IF;
993: IF (p_rec.insurance_expiry_date = hr_api.g_date) THEN
994: p_rec.insurance_expiry_date :=
995: pqp_vre_shd.g_old_rec.insurance_expiry_date;
996: END IF;
997: IF (p_rec.comments = hr_api.g_varchar2) THEN
998: p_rec.comments :=
999: pqp_vre_shd.g_old_rec.comments;
995: pqp_vre_shd.g_old_rec.insurance_expiry_date;
996: END IF;
997: IF (p_rec.comments = hr_api.g_varchar2) THEN
998: p_rec.comments :=
999: pqp_vre_shd.g_old_rec.comments;
1000: END IF;
1001: IF (p_rec.vre_attribute_category = hr_api.g_varchar2) THEN
1002: p_rec.vre_attribute_category :=
1003: pqp_vre_shd.g_old_rec.vre_attribute_category;
999: pqp_vre_shd.g_old_rec.comments;
1000: END IF;
1001: IF (p_rec.vre_attribute_category = hr_api.g_varchar2) THEN
1002: p_rec.vre_attribute_category :=
1003: pqp_vre_shd.g_old_rec.vre_attribute_category;
1004: END IF;
1005: IF (p_rec.vre_attribute1 = hr_api.g_varchar2) THEN
1006: p_rec.vre_attribute1 :=
1007: pqp_vre_shd.g_old_rec.vre_attribute1;
1003: pqp_vre_shd.g_old_rec.vre_attribute_category;
1004: END IF;
1005: IF (p_rec.vre_attribute1 = hr_api.g_varchar2) THEN
1006: p_rec.vre_attribute1 :=
1007: pqp_vre_shd.g_old_rec.vre_attribute1;
1008: END IF;
1009: IF (p_rec.vre_attribute2 = hr_api.g_varchar2) THEN
1010: p_rec.vre_attribute2 :=
1011: pqp_vre_shd.g_old_rec.vre_attribute2;
1007: pqp_vre_shd.g_old_rec.vre_attribute1;
1008: END IF;
1009: IF (p_rec.vre_attribute2 = hr_api.g_varchar2) THEN
1010: p_rec.vre_attribute2 :=
1011: pqp_vre_shd.g_old_rec.vre_attribute2;
1012: END IF;
1013: IF (p_rec.vre_attribute3 = hr_api.g_varchar2) THEN
1014: p_rec.vre_attribute3 :=
1015: pqp_vre_shd.g_old_rec.vre_attribute3;
1011: pqp_vre_shd.g_old_rec.vre_attribute2;
1012: END IF;
1013: IF (p_rec.vre_attribute3 = hr_api.g_varchar2) THEN
1014: p_rec.vre_attribute3 :=
1015: pqp_vre_shd.g_old_rec.vre_attribute3;
1016: END IF;
1017: IF (p_rec.vre_attribute4 = hr_api.g_varchar2) THEN
1018: p_rec.vre_attribute4 :=
1019: pqp_vre_shd.g_old_rec.vre_attribute4;
1015: pqp_vre_shd.g_old_rec.vre_attribute3;
1016: END IF;
1017: IF (p_rec.vre_attribute4 = hr_api.g_varchar2) THEN
1018: p_rec.vre_attribute4 :=
1019: pqp_vre_shd.g_old_rec.vre_attribute4;
1020: END IF;
1021: IF (p_rec.vre_attribute5 = hr_api.g_varchar2) THEN
1022: p_rec.vre_attribute5 :=
1023: pqp_vre_shd.g_old_rec.vre_attribute5;
1019: pqp_vre_shd.g_old_rec.vre_attribute4;
1020: END IF;
1021: IF (p_rec.vre_attribute5 = hr_api.g_varchar2) THEN
1022: p_rec.vre_attribute5 :=
1023: pqp_vre_shd.g_old_rec.vre_attribute5;
1024: END IF;
1025: IF (p_rec.vre_attribute6 = hr_api.g_varchar2) THEN
1026: p_rec.vre_attribute6 :=
1027: pqp_vre_shd.g_old_rec.vre_attribute6;
1023: pqp_vre_shd.g_old_rec.vre_attribute5;
1024: END IF;
1025: IF (p_rec.vre_attribute6 = hr_api.g_varchar2) THEN
1026: p_rec.vre_attribute6 :=
1027: pqp_vre_shd.g_old_rec.vre_attribute6;
1028: END IF;
1029: IF (p_rec.vre_attribute7 = hr_api.g_varchar2) THEN
1030: p_rec.vre_attribute7 :=
1031: pqp_vre_shd.g_old_rec.vre_attribute7;
1027: pqp_vre_shd.g_old_rec.vre_attribute6;
1028: END IF;
1029: IF (p_rec.vre_attribute7 = hr_api.g_varchar2) THEN
1030: p_rec.vre_attribute7 :=
1031: pqp_vre_shd.g_old_rec.vre_attribute7;
1032: END IF;
1033: IF (p_rec.vre_attribute8 = hr_api.g_varchar2) THEN
1034: p_rec.vre_attribute8 :=
1035: pqp_vre_shd.g_old_rec.vre_attribute8;
1031: pqp_vre_shd.g_old_rec.vre_attribute7;
1032: END IF;
1033: IF (p_rec.vre_attribute8 = hr_api.g_varchar2) THEN
1034: p_rec.vre_attribute8 :=
1035: pqp_vre_shd.g_old_rec.vre_attribute8;
1036: END IF;
1037: IF (p_rec.vre_attribute9 = hr_api.g_varchar2) THEN
1038: p_rec.vre_attribute9 :=
1039: pqp_vre_shd.g_old_rec.vre_attribute9;
1035: pqp_vre_shd.g_old_rec.vre_attribute8;
1036: END IF;
1037: IF (p_rec.vre_attribute9 = hr_api.g_varchar2) THEN
1038: p_rec.vre_attribute9 :=
1039: pqp_vre_shd.g_old_rec.vre_attribute9;
1040: END IF;
1041: IF (p_rec.vre_attribute10 = hr_api.g_varchar2) THEN
1042: p_rec.vre_attribute10 :=
1043: pqp_vre_shd.g_old_rec.vre_attribute10;
1039: pqp_vre_shd.g_old_rec.vre_attribute9;
1040: END IF;
1041: IF (p_rec.vre_attribute10 = hr_api.g_varchar2) THEN
1042: p_rec.vre_attribute10 :=
1043: pqp_vre_shd.g_old_rec.vre_attribute10;
1044: END IF;
1045: IF (p_rec.vre_attribute11 = hr_api.g_varchar2) THEN
1046: p_rec.vre_attribute11 :=
1047: pqp_vre_shd.g_old_rec.vre_attribute11;
1043: pqp_vre_shd.g_old_rec.vre_attribute10;
1044: END IF;
1045: IF (p_rec.vre_attribute11 = hr_api.g_varchar2) THEN
1046: p_rec.vre_attribute11 :=
1047: pqp_vre_shd.g_old_rec.vre_attribute11;
1048: END IF;
1049: IF (p_rec.vre_attribute12 = hr_api.g_varchar2) THEN
1050: p_rec.vre_attribute12 :=
1051: pqp_vre_shd.g_old_rec.vre_attribute12;
1047: pqp_vre_shd.g_old_rec.vre_attribute11;
1048: END IF;
1049: IF (p_rec.vre_attribute12 = hr_api.g_varchar2) THEN
1050: p_rec.vre_attribute12 :=
1051: pqp_vre_shd.g_old_rec.vre_attribute12;
1052: END IF;
1053: IF (p_rec.vre_attribute13 = hr_api.g_varchar2) THEN
1054: p_rec.vre_attribute13 :=
1055: pqp_vre_shd.g_old_rec.vre_attribute13;
1051: pqp_vre_shd.g_old_rec.vre_attribute12;
1052: END IF;
1053: IF (p_rec.vre_attribute13 = hr_api.g_varchar2) THEN
1054: p_rec.vre_attribute13 :=
1055: pqp_vre_shd.g_old_rec.vre_attribute13;
1056: END IF;
1057: IF (p_rec.vre_attribute14 = hr_api.g_varchar2) THEN
1058: p_rec.vre_attribute14 :=
1059: pqp_vre_shd.g_old_rec.vre_attribute14;
1055: pqp_vre_shd.g_old_rec.vre_attribute13;
1056: END IF;
1057: IF (p_rec.vre_attribute14 = hr_api.g_varchar2) THEN
1058: p_rec.vre_attribute14 :=
1059: pqp_vre_shd.g_old_rec.vre_attribute14;
1060: END IF;
1061: IF (p_rec.vre_attribute15 = hr_api.g_varchar2) THEN
1062: p_rec.vre_attribute15 :=
1063: pqp_vre_shd.g_old_rec.vre_attribute15;
1059: pqp_vre_shd.g_old_rec.vre_attribute14;
1060: END IF;
1061: IF (p_rec.vre_attribute15 = hr_api.g_varchar2) THEN
1062: p_rec.vre_attribute15 :=
1063: pqp_vre_shd.g_old_rec.vre_attribute15;
1064: END IF;
1065: IF (p_rec.vre_attribute16 = hr_api.g_varchar2) THEN
1066: p_rec.vre_attribute16 :=
1067: pqp_vre_shd.g_old_rec.vre_attribute16;
1063: pqp_vre_shd.g_old_rec.vre_attribute15;
1064: END IF;
1065: IF (p_rec.vre_attribute16 = hr_api.g_varchar2) THEN
1066: p_rec.vre_attribute16 :=
1067: pqp_vre_shd.g_old_rec.vre_attribute16;
1068: END IF;
1069: IF (p_rec.vre_attribute17 = hr_api.g_varchar2) THEN
1070: p_rec.vre_attribute17 :=
1071: pqp_vre_shd.g_old_rec.vre_attribute17;
1067: pqp_vre_shd.g_old_rec.vre_attribute16;
1068: END IF;
1069: IF (p_rec.vre_attribute17 = hr_api.g_varchar2) THEN
1070: p_rec.vre_attribute17 :=
1071: pqp_vre_shd.g_old_rec.vre_attribute17;
1072: END IF;
1073: IF (p_rec.vre_attribute18 = hr_api.g_varchar2) THEN
1074: p_rec.vre_attribute18 :=
1075: pqp_vre_shd.g_old_rec.vre_attribute18;
1071: pqp_vre_shd.g_old_rec.vre_attribute17;
1072: END IF;
1073: IF (p_rec.vre_attribute18 = hr_api.g_varchar2) THEN
1074: p_rec.vre_attribute18 :=
1075: pqp_vre_shd.g_old_rec.vre_attribute18;
1076: END IF;
1077: IF (p_rec.vre_attribute19 = hr_api.g_varchar2) THEN
1078: p_rec.vre_attribute19 :=
1079: pqp_vre_shd.g_old_rec.vre_attribute19;
1075: pqp_vre_shd.g_old_rec.vre_attribute18;
1076: END IF;
1077: IF (p_rec.vre_attribute19 = hr_api.g_varchar2) THEN
1078: p_rec.vre_attribute19 :=
1079: pqp_vre_shd.g_old_rec.vre_attribute19;
1080: END IF;
1081: IF (p_rec.vre_attribute20 = hr_api.g_varchar2) THEN
1082: p_rec.vre_attribute20 :=
1083: pqp_vre_shd.g_old_rec.vre_attribute20;
1079: pqp_vre_shd.g_old_rec.vre_attribute19;
1080: END IF;
1081: IF (p_rec.vre_attribute20 = hr_api.g_varchar2) THEN
1082: p_rec.vre_attribute20 :=
1083: pqp_vre_shd.g_old_rec.vre_attribute20;
1084: END IF;
1085: IF (p_rec.vre_information_category = hr_api.g_varchar2) THEN
1086: p_rec.vre_information_category :=
1087: pqp_vre_shd.g_old_rec.vre_information_category;
1083: pqp_vre_shd.g_old_rec.vre_attribute20;
1084: END IF;
1085: IF (p_rec.vre_information_category = hr_api.g_varchar2) THEN
1086: p_rec.vre_information_category :=
1087: pqp_vre_shd.g_old_rec.vre_information_category;
1088: END IF;
1089: IF (p_rec.vre_information1 = hr_api.g_varchar2) THEN
1090: p_rec.vre_information1 :=
1091: pqp_vre_shd.g_old_rec.vre_information1;
1087: pqp_vre_shd.g_old_rec.vre_information_category;
1088: END IF;
1089: IF (p_rec.vre_information1 = hr_api.g_varchar2) THEN
1090: p_rec.vre_information1 :=
1091: pqp_vre_shd.g_old_rec.vre_information1;
1092: END IF;
1093: IF (p_rec.vre_information2 = hr_api.g_varchar2) THEN
1094: p_rec.vre_information2 :=
1095: pqp_vre_shd.g_old_rec.vre_information2;
1091: pqp_vre_shd.g_old_rec.vre_information1;
1092: END IF;
1093: IF (p_rec.vre_information2 = hr_api.g_varchar2) THEN
1094: p_rec.vre_information2 :=
1095: pqp_vre_shd.g_old_rec.vre_information2;
1096: END IF;
1097: IF (p_rec.vre_information3 = hr_api.g_varchar2) THEN
1098: p_rec.vre_information3 :=
1099: pqp_vre_shd.g_old_rec.vre_information3;
1095: pqp_vre_shd.g_old_rec.vre_information2;
1096: END IF;
1097: IF (p_rec.vre_information3 = hr_api.g_varchar2) THEN
1098: p_rec.vre_information3 :=
1099: pqp_vre_shd.g_old_rec.vre_information3;
1100: END IF;
1101: IF (p_rec.vre_information4 = hr_api.g_varchar2) THEN
1102: p_rec.vre_information4 :=
1103: pqp_vre_shd.g_old_rec.vre_information4;
1099: pqp_vre_shd.g_old_rec.vre_information3;
1100: END IF;
1101: IF (p_rec.vre_information4 = hr_api.g_varchar2) THEN
1102: p_rec.vre_information4 :=
1103: pqp_vre_shd.g_old_rec.vre_information4;
1104: END IF;
1105: IF (p_rec.vre_information5 = hr_api.g_varchar2) THEN
1106: p_rec.vre_information5 :=
1107: pqp_vre_shd.g_old_rec.vre_information5;
1103: pqp_vre_shd.g_old_rec.vre_information4;
1104: END IF;
1105: IF (p_rec.vre_information5 = hr_api.g_varchar2) THEN
1106: p_rec.vre_information5 :=
1107: pqp_vre_shd.g_old_rec.vre_information5;
1108: END IF;
1109: IF (p_rec.vre_information6 = hr_api.g_varchar2) THEN
1110: p_rec.vre_information6 :=
1111: pqp_vre_shd.g_old_rec.vre_information6;
1107: pqp_vre_shd.g_old_rec.vre_information5;
1108: END IF;
1109: IF (p_rec.vre_information6 = hr_api.g_varchar2) THEN
1110: p_rec.vre_information6 :=
1111: pqp_vre_shd.g_old_rec.vre_information6;
1112: END IF;
1113: IF (p_rec.vre_information7 = hr_api.g_varchar2) THEN
1114: p_rec.vre_information7 :=
1115: pqp_vre_shd.g_old_rec.vre_information7;
1111: pqp_vre_shd.g_old_rec.vre_information6;
1112: END IF;
1113: IF (p_rec.vre_information7 = hr_api.g_varchar2) THEN
1114: p_rec.vre_information7 :=
1115: pqp_vre_shd.g_old_rec.vre_information7;
1116: END IF;
1117: IF (p_rec.vre_information8 = hr_api.g_varchar2) THEN
1118: p_rec.vre_information8 :=
1119: pqp_vre_shd.g_old_rec.vre_information8;
1115: pqp_vre_shd.g_old_rec.vre_information7;
1116: END IF;
1117: IF (p_rec.vre_information8 = hr_api.g_varchar2) THEN
1118: p_rec.vre_information8 :=
1119: pqp_vre_shd.g_old_rec.vre_information8;
1120: END IF;
1121: IF (p_rec.vre_information9 = hr_api.g_varchar2) THEN
1122: p_rec.vre_information9 :=
1123: pqp_vre_shd.g_old_rec.vre_information9;
1119: pqp_vre_shd.g_old_rec.vre_information8;
1120: END IF;
1121: IF (p_rec.vre_information9 = hr_api.g_varchar2) THEN
1122: p_rec.vre_information9 :=
1123: pqp_vre_shd.g_old_rec.vre_information9;
1124: END IF;
1125: IF (p_rec.vre_information10 = hr_api.g_varchar2) THEN
1126: p_rec.vre_information10 :=
1127: pqp_vre_shd.g_old_rec.vre_information10;
1123: pqp_vre_shd.g_old_rec.vre_information9;
1124: END IF;
1125: IF (p_rec.vre_information10 = hr_api.g_varchar2) THEN
1126: p_rec.vre_information10 :=
1127: pqp_vre_shd.g_old_rec.vre_information10;
1128: END IF;
1129: IF (p_rec.vre_information11 = hr_api.g_varchar2) THEN
1130: p_rec.vre_information11 :=
1131: pqp_vre_shd.g_old_rec.vre_information11;
1127: pqp_vre_shd.g_old_rec.vre_information10;
1128: END IF;
1129: IF (p_rec.vre_information11 = hr_api.g_varchar2) THEN
1130: p_rec.vre_information11 :=
1131: pqp_vre_shd.g_old_rec.vre_information11;
1132: END IF;
1133: IF (p_rec.vre_information12 = hr_api.g_varchar2) THEN
1134: p_rec.vre_information12 :=
1135: pqp_vre_shd.g_old_rec.vre_information12;
1131: pqp_vre_shd.g_old_rec.vre_information11;
1132: END IF;
1133: IF (p_rec.vre_information12 = hr_api.g_varchar2) THEN
1134: p_rec.vre_information12 :=
1135: pqp_vre_shd.g_old_rec.vre_information12;
1136: END IF;
1137: IF (p_rec.vre_information13 = hr_api.g_varchar2) THEN
1138: p_rec.vre_information13 :=
1139: pqp_vre_shd.g_old_rec.vre_information13;
1135: pqp_vre_shd.g_old_rec.vre_information12;
1136: END IF;
1137: IF (p_rec.vre_information13 = hr_api.g_varchar2) THEN
1138: p_rec.vre_information13 :=
1139: pqp_vre_shd.g_old_rec.vre_information13;
1140: END IF;
1141: IF (p_rec.vre_information14 = hr_api.g_varchar2) THEN
1142: p_rec.vre_information14 :=
1143: pqp_vre_shd.g_old_rec.vre_information14;
1139: pqp_vre_shd.g_old_rec.vre_information13;
1140: END IF;
1141: IF (p_rec.vre_information14 = hr_api.g_varchar2) THEN
1142: p_rec.vre_information14 :=
1143: pqp_vre_shd.g_old_rec.vre_information14;
1144: END IF;
1145: IF (p_rec.vre_information15 = hr_api.g_varchar2) THEN
1146: p_rec.vre_information15 :=
1147: pqp_vre_shd.g_old_rec.vre_information15;
1143: pqp_vre_shd.g_old_rec.vre_information14;
1144: END IF;
1145: IF (p_rec.vre_information15 = hr_api.g_varchar2) THEN
1146: p_rec.vre_information15 :=
1147: pqp_vre_shd.g_old_rec.vre_information15;
1148: END IF;
1149: IF (p_rec.vre_information16 = hr_api.g_varchar2) THEN
1150: p_rec.vre_information16 :=
1151: pqp_vre_shd.g_old_rec.vre_information16;
1147: pqp_vre_shd.g_old_rec.vre_information15;
1148: END IF;
1149: IF (p_rec.vre_information16 = hr_api.g_varchar2) THEN
1150: p_rec.vre_information16 :=
1151: pqp_vre_shd.g_old_rec.vre_information16;
1152: END IF;
1153: IF (p_rec.vre_information17 = hr_api.g_varchar2) THEN
1154: p_rec.vre_information17 :=
1155: pqp_vre_shd.g_old_rec.vre_information17;
1151: pqp_vre_shd.g_old_rec.vre_information16;
1152: END IF;
1153: IF (p_rec.vre_information17 = hr_api.g_varchar2) THEN
1154: p_rec.vre_information17 :=
1155: pqp_vre_shd.g_old_rec.vre_information17;
1156: END IF;
1157: IF (p_rec.vre_information18 = hr_api.g_varchar2) THEN
1158: p_rec.vre_information18 :=
1159: pqp_vre_shd.g_old_rec.vre_information18;
1155: pqp_vre_shd.g_old_rec.vre_information17;
1156: END IF;
1157: IF (p_rec.vre_information18 = hr_api.g_varchar2) THEN
1158: p_rec.vre_information18 :=
1159: pqp_vre_shd.g_old_rec.vre_information18;
1160: END IF;
1161: IF (p_rec.vre_information19 = hr_api.g_varchar2) THEN
1162: p_rec.vre_information19 :=
1163: pqp_vre_shd.g_old_rec.vre_information19;
1159: pqp_vre_shd.g_old_rec.vre_information18;
1160: END IF;
1161: IF (p_rec.vre_information19 = hr_api.g_varchar2) THEN
1162: p_rec.vre_information19 :=
1163: pqp_vre_shd.g_old_rec.vre_information19;
1164: END IF;
1165: IF (p_rec.vre_information20 = hr_api.g_varchar2) THEN
1166: p_rec.vre_information20 :=
1167: pqp_vre_shd.g_old_rec.vre_information20;
1163: pqp_vre_shd.g_old_rec.vre_information19;
1164: END IF;
1165: IF (p_rec.vre_information20 = hr_api.g_varchar2) THEN
1166: p_rec.vre_information20 :=
1167: pqp_vre_shd.g_old_rec.vre_information20;
1168: END IF;
1169:
1170: --
1171: End convert_defs;
1175: -- ----------------------------------------------------------------------------
1176: PROCEDURE upd
1177: (p_effective_date IN DATE
1178: ,p_datetrack_mode IN VARCHAR2
1179: ,p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
1180: ) IS
1181: --
1182: l_proc VARCHAR2(72) := g_package||'upd';
1183: l_validation_start_date DATE;
1191: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1192: --
1193: -- We must lock the row which we need to update.
1194: --
1195: pqp_vre_shd.lck
1196: (p_effective_date => p_effective_date
1197: ,p_datetrack_mode => p_datetrack_mode
1198: ,p_vehicle_repository_id => p_rec.vehicle_repository_id
1199: ,p_object_version_number => p_rec.object_version_number
1345: ,p_effective_start_date OUT NOCOPY DATE
1346: ,p_effective_end_date OUT NOCOPY DATE
1347: ) IS
1348: --
1349: l_rec pqp_vre_shd.g_rec_type;
1350: l_proc varchar2(72) := g_package||'upd';
1351: --
1352: BEGIN
1353: hr_utility.set_location('Entering:'||l_proc, 5);
1355: -- Call conversion function to turn arguments into the
1356: -- l_rec structure.
1357: --
1358: l_rec :=
1359: pqp_vre_shd.convert_args
1360: (p_vehicle_repository_id
1361: ,null
1362: ,null
1363: ,p_registration_number