54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqp_val_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
164: Exception
165: When hr_api.check_integrity_violated Then
166: -- A check constraint has been violated
167: --
168: pqp_val_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: pqp_val_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: --
177: Raise;
208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure update_dml
212: (p_rec in out nocopy pqp_val_shd.g_rec_type
213: ,p_effective_date in date
214: ,p_datetrack_mode in varchar2
215: ,p_validation_start_date in date
216: ,p_validation_end_date in date
275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure dt_pre_update
279: (p_rec in out nocopy pqp_val_shd.g_rec_type
280: ,p_effective_date in date
281: ,p_datetrack_mode in varchar2
282: ,p_validation_start_date in date
283: ,p_validation_end_date in date
291: If (p_datetrack_mode <> hr_api.g_correction) then
292: --
293: -- Update the current effective end date
294: --
295: pqp_val_shd.upd_effective_end_date
296: (p_effective_date => p_effective_date
297: ,p_base_key_value => p_rec.vehicle_allocation_id
298: ,p_new_effective_end_date => (p_validation_start_date - 1)
299: ,p_validation_start_date => p_validation_start_date
360: --
361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure pre_update
364: (p_rec in out nocopy pqp_val_shd.g_rec_type
365: ,p_effective_date in date
366: ,p_datetrack_mode in varchar2
367: ,p_validation_start_date in date
368: ,p_validation_end_date in date
418: --
419: -- {End Of Comments}
420: -- ----------------------------------------------------------------------------
421: Procedure post_update
422: (p_rec in pqp_val_shd.g_rec_type
423: ,p_effective_date in date
424: ,p_datetrack_mode in varchar2
425: ,p_validation_start_date in date
426: ,p_validation_end_date in date
567: => p_rec.object_version_number
568: ,p_fuel_benefit
569: => p_rec.fuel_benefit
570: ,p_effective_start_date_o
571: => pqp_val_shd.g_old_rec.effective_start_date
572: ,p_effective_end_date_o
573: => pqp_val_shd.g_old_rec.effective_end_date
574: ,p_assignment_id_o
575: => pqp_val_shd.g_old_rec.assignment_id
569: => p_rec.fuel_benefit
570: ,p_effective_start_date_o
571: => pqp_val_shd.g_old_rec.effective_start_date
572: ,p_effective_end_date_o
573: => pqp_val_shd.g_old_rec.effective_end_date
574: ,p_assignment_id_o
575: => pqp_val_shd.g_old_rec.assignment_id
576: ,p_business_group_id_o
577: => pqp_val_shd.g_old_rec.business_group_id
571: => pqp_val_shd.g_old_rec.effective_start_date
572: ,p_effective_end_date_o
573: => pqp_val_shd.g_old_rec.effective_end_date
574: ,p_assignment_id_o
575: => pqp_val_shd.g_old_rec.assignment_id
576: ,p_business_group_id_o
577: => pqp_val_shd.g_old_rec.business_group_id
578: ,p_across_assignments_o
579: => pqp_val_shd.g_old_rec.across_assignments
573: => pqp_val_shd.g_old_rec.effective_end_date
574: ,p_assignment_id_o
575: => pqp_val_shd.g_old_rec.assignment_id
576: ,p_business_group_id_o
577: => pqp_val_shd.g_old_rec.business_group_id
578: ,p_across_assignments_o
579: => pqp_val_shd.g_old_rec.across_assignments
580: ,p_vehicle_repository_id_o
581: => pqp_val_shd.g_old_rec.vehicle_repository_id
575: => pqp_val_shd.g_old_rec.assignment_id
576: ,p_business_group_id_o
577: => pqp_val_shd.g_old_rec.business_group_id
578: ,p_across_assignments_o
579: => pqp_val_shd.g_old_rec.across_assignments
580: ,p_vehicle_repository_id_o
581: => pqp_val_shd.g_old_rec.vehicle_repository_id
582: ,p_usage_type_o
583: => pqp_val_shd.g_old_rec.usage_type
577: => pqp_val_shd.g_old_rec.business_group_id
578: ,p_across_assignments_o
579: => pqp_val_shd.g_old_rec.across_assignments
580: ,p_vehicle_repository_id_o
581: => pqp_val_shd.g_old_rec.vehicle_repository_id
582: ,p_usage_type_o
583: => pqp_val_shd.g_old_rec.usage_type
584: ,p_capital_contribution_o
585: => pqp_val_shd.g_old_rec.capital_contribution
579: => pqp_val_shd.g_old_rec.across_assignments
580: ,p_vehicle_repository_id_o
581: => pqp_val_shd.g_old_rec.vehicle_repository_id
582: ,p_usage_type_o
583: => pqp_val_shd.g_old_rec.usage_type
584: ,p_capital_contribution_o
585: => pqp_val_shd.g_old_rec.capital_contribution
586: ,p_private_contribution_o
587: => pqp_val_shd.g_old_rec.private_contribution
581: => pqp_val_shd.g_old_rec.vehicle_repository_id
582: ,p_usage_type_o
583: => pqp_val_shd.g_old_rec.usage_type
584: ,p_capital_contribution_o
585: => pqp_val_shd.g_old_rec.capital_contribution
586: ,p_private_contribution_o
587: => pqp_val_shd.g_old_rec.private_contribution
588: ,p_default_vehicle_o
589: => pqp_val_shd.g_old_rec.default_vehicle
583: => pqp_val_shd.g_old_rec.usage_type
584: ,p_capital_contribution_o
585: => pqp_val_shd.g_old_rec.capital_contribution
586: ,p_private_contribution_o
587: => pqp_val_shd.g_old_rec.private_contribution
588: ,p_default_vehicle_o
589: => pqp_val_shd.g_old_rec.default_vehicle
590: ,p_fuel_card_o
591: => pqp_val_shd.g_old_rec.fuel_card
585: => pqp_val_shd.g_old_rec.capital_contribution
586: ,p_private_contribution_o
587: => pqp_val_shd.g_old_rec.private_contribution
588: ,p_default_vehicle_o
589: => pqp_val_shd.g_old_rec.default_vehicle
590: ,p_fuel_card_o
591: => pqp_val_shd.g_old_rec.fuel_card
592: ,p_fuel_card_number_o
593: => pqp_val_shd.g_old_rec.fuel_card_number
587: => pqp_val_shd.g_old_rec.private_contribution
588: ,p_default_vehicle_o
589: => pqp_val_shd.g_old_rec.default_vehicle
590: ,p_fuel_card_o
591: => pqp_val_shd.g_old_rec.fuel_card
592: ,p_fuel_card_number_o
593: => pqp_val_shd.g_old_rec.fuel_card_number
594: ,p_calculation_method_o
595: => pqp_val_shd.g_old_rec.calculation_method
589: => pqp_val_shd.g_old_rec.default_vehicle
590: ,p_fuel_card_o
591: => pqp_val_shd.g_old_rec.fuel_card
592: ,p_fuel_card_number_o
593: => pqp_val_shd.g_old_rec.fuel_card_number
594: ,p_calculation_method_o
595: => pqp_val_shd.g_old_rec.calculation_method
596: ,p_rates_table_id_o
597: => pqp_val_shd.g_old_rec.rates_table_id
591: => pqp_val_shd.g_old_rec.fuel_card
592: ,p_fuel_card_number_o
593: => pqp_val_shd.g_old_rec.fuel_card_number
594: ,p_calculation_method_o
595: => pqp_val_shd.g_old_rec.calculation_method
596: ,p_rates_table_id_o
597: => pqp_val_shd.g_old_rec.rates_table_id
598: ,p_element_type_id_o
599: => pqp_val_shd.g_old_rec.element_type_id
593: => pqp_val_shd.g_old_rec.fuel_card_number
594: ,p_calculation_method_o
595: => pqp_val_shd.g_old_rec.calculation_method
596: ,p_rates_table_id_o
597: => pqp_val_shd.g_old_rec.rates_table_id
598: ,p_element_type_id_o
599: => pqp_val_shd.g_old_rec.element_type_id
600: ,p_private_use_flag_o
601: => pqp_val_shd.g_old_rec.private_use_flag
595: => pqp_val_shd.g_old_rec.calculation_method
596: ,p_rates_table_id_o
597: => pqp_val_shd.g_old_rec.rates_table_id
598: ,p_element_type_id_o
599: => pqp_val_shd.g_old_rec.element_type_id
600: ,p_private_use_flag_o
601: => pqp_val_shd.g_old_rec.private_use_flag
602: ,p_insurance_number_o
603: => pqp_val_shd.g_old_rec.insurance_number
597: => pqp_val_shd.g_old_rec.rates_table_id
598: ,p_element_type_id_o
599: => pqp_val_shd.g_old_rec.element_type_id
600: ,p_private_use_flag_o
601: => pqp_val_shd.g_old_rec.private_use_flag
602: ,p_insurance_number_o
603: => pqp_val_shd.g_old_rec.insurance_number
604: ,p_insurance_expiry_date_o
605: => pqp_val_shd.g_old_rec.insurance_expiry_date
599: => pqp_val_shd.g_old_rec.element_type_id
600: ,p_private_use_flag_o
601: => pqp_val_shd.g_old_rec.private_use_flag
602: ,p_insurance_number_o
603: => pqp_val_shd.g_old_rec.insurance_number
604: ,p_insurance_expiry_date_o
605: => pqp_val_shd.g_old_rec.insurance_expiry_date
606: ,p_val_attribute_category_o
607: => pqp_val_shd.g_old_rec.val_attribute_category
601: => pqp_val_shd.g_old_rec.private_use_flag
602: ,p_insurance_number_o
603: => pqp_val_shd.g_old_rec.insurance_number
604: ,p_insurance_expiry_date_o
605: => pqp_val_shd.g_old_rec.insurance_expiry_date
606: ,p_val_attribute_category_o
607: => pqp_val_shd.g_old_rec.val_attribute_category
608: ,p_val_attribute1_o
609: => pqp_val_shd.g_old_rec.val_attribute1
603: => pqp_val_shd.g_old_rec.insurance_number
604: ,p_insurance_expiry_date_o
605: => pqp_val_shd.g_old_rec.insurance_expiry_date
606: ,p_val_attribute_category_o
607: => pqp_val_shd.g_old_rec.val_attribute_category
608: ,p_val_attribute1_o
609: => pqp_val_shd.g_old_rec.val_attribute1
610: ,p_val_attribute2_o
611: => pqp_val_shd.g_old_rec.val_attribute2
605: => pqp_val_shd.g_old_rec.insurance_expiry_date
606: ,p_val_attribute_category_o
607: => pqp_val_shd.g_old_rec.val_attribute_category
608: ,p_val_attribute1_o
609: => pqp_val_shd.g_old_rec.val_attribute1
610: ,p_val_attribute2_o
611: => pqp_val_shd.g_old_rec.val_attribute2
612: ,p_val_attribute3_o
613: => pqp_val_shd.g_old_rec.val_attribute3
607: => pqp_val_shd.g_old_rec.val_attribute_category
608: ,p_val_attribute1_o
609: => pqp_val_shd.g_old_rec.val_attribute1
610: ,p_val_attribute2_o
611: => pqp_val_shd.g_old_rec.val_attribute2
612: ,p_val_attribute3_o
613: => pqp_val_shd.g_old_rec.val_attribute3
614: ,p_val_attribute4_o
615: => pqp_val_shd.g_old_rec.val_attribute4
609: => pqp_val_shd.g_old_rec.val_attribute1
610: ,p_val_attribute2_o
611: => pqp_val_shd.g_old_rec.val_attribute2
612: ,p_val_attribute3_o
613: => pqp_val_shd.g_old_rec.val_attribute3
614: ,p_val_attribute4_o
615: => pqp_val_shd.g_old_rec.val_attribute4
616: ,p_val_attribute5_o
617: => pqp_val_shd.g_old_rec.val_attribute5
611: => pqp_val_shd.g_old_rec.val_attribute2
612: ,p_val_attribute3_o
613: => pqp_val_shd.g_old_rec.val_attribute3
614: ,p_val_attribute4_o
615: => pqp_val_shd.g_old_rec.val_attribute4
616: ,p_val_attribute5_o
617: => pqp_val_shd.g_old_rec.val_attribute5
618: ,p_val_attribute6_o
619: => pqp_val_shd.g_old_rec.val_attribute6
613: => pqp_val_shd.g_old_rec.val_attribute3
614: ,p_val_attribute4_o
615: => pqp_val_shd.g_old_rec.val_attribute4
616: ,p_val_attribute5_o
617: => pqp_val_shd.g_old_rec.val_attribute5
618: ,p_val_attribute6_o
619: => pqp_val_shd.g_old_rec.val_attribute6
620: ,p_val_attribute7_o
621: => pqp_val_shd.g_old_rec.val_attribute7
615: => pqp_val_shd.g_old_rec.val_attribute4
616: ,p_val_attribute5_o
617: => pqp_val_shd.g_old_rec.val_attribute5
618: ,p_val_attribute6_o
619: => pqp_val_shd.g_old_rec.val_attribute6
620: ,p_val_attribute7_o
621: => pqp_val_shd.g_old_rec.val_attribute7
622: ,p_val_attribute8_o
623: => pqp_val_shd.g_old_rec.val_attribute8
617: => pqp_val_shd.g_old_rec.val_attribute5
618: ,p_val_attribute6_o
619: => pqp_val_shd.g_old_rec.val_attribute6
620: ,p_val_attribute7_o
621: => pqp_val_shd.g_old_rec.val_attribute7
622: ,p_val_attribute8_o
623: => pqp_val_shd.g_old_rec.val_attribute8
624: ,p_val_attribute9_o
625: => pqp_val_shd.g_old_rec.val_attribute9
619: => pqp_val_shd.g_old_rec.val_attribute6
620: ,p_val_attribute7_o
621: => pqp_val_shd.g_old_rec.val_attribute7
622: ,p_val_attribute8_o
623: => pqp_val_shd.g_old_rec.val_attribute8
624: ,p_val_attribute9_o
625: => pqp_val_shd.g_old_rec.val_attribute9
626: ,p_val_attribute10_o
627: => pqp_val_shd.g_old_rec.val_attribute10
621: => pqp_val_shd.g_old_rec.val_attribute7
622: ,p_val_attribute8_o
623: => pqp_val_shd.g_old_rec.val_attribute8
624: ,p_val_attribute9_o
625: => pqp_val_shd.g_old_rec.val_attribute9
626: ,p_val_attribute10_o
627: => pqp_val_shd.g_old_rec.val_attribute10
628: ,p_val_attribute11_o
629: => pqp_val_shd.g_old_rec.val_attribute11
623: => pqp_val_shd.g_old_rec.val_attribute8
624: ,p_val_attribute9_o
625: => pqp_val_shd.g_old_rec.val_attribute9
626: ,p_val_attribute10_o
627: => pqp_val_shd.g_old_rec.val_attribute10
628: ,p_val_attribute11_o
629: => pqp_val_shd.g_old_rec.val_attribute11
630: ,p_val_attribute12_o
631: => pqp_val_shd.g_old_rec.val_attribute12
625: => pqp_val_shd.g_old_rec.val_attribute9
626: ,p_val_attribute10_o
627: => pqp_val_shd.g_old_rec.val_attribute10
628: ,p_val_attribute11_o
629: => pqp_val_shd.g_old_rec.val_attribute11
630: ,p_val_attribute12_o
631: => pqp_val_shd.g_old_rec.val_attribute12
632: ,p_val_attribute13_o
633: => pqp_val_shd.g_old_rec.val_attribute13
627: => pqp_val_shd.g_old_rec.val_attribute10
628: ,p_val_attribute11_o
629: => pqp_val_shd.g_old_rec.val_attribute11
630: ,p_val_attribute12_o
631: => pqp_val_shd.g_old_rec.val_attribute12
632: ,p_val_attribute13_o
633: => pqp_val_shd.g_old_rec.val_attribute13
634: ,p_val_attribute14_o
635: => pqp_val_shd.g_old_rec.val_attribute14
629: => pqp_val_shd.g_old_rec.val_attribute11
630: ,p_val_attribute12_o
631: => pqp_val_shd.g_old_rec.val_attribute12
632: ,p_val_attribute13_o
633: => pqp_val_shd.g_old_rec.val_attribute13
634: ,p_val_attribute14_o
635: => pqp_val_shd.g_old_rec.val_attribute14
636: ,p_val_attribute15_o
637: => pqp_val_shd.g_old_rec.val_attribute15
631: => pqp_val_shd.g_old_rec.val_attribute12
632: ,p_val_attribute13_o
633: => pqp_val_shd.g_old_rec.val_attribute13
634: ,p_val_attribute14_o
635: => pqp_val_shd.g_old_rec.val_attribute14
636: ,p_val_attribute15_o
637: => pqp_val_shd.g_old_rec.val_attribute15
638: ,p_val_attribute16_o
639: => pqp_val_shd.g_old_rec.val_attribute16
633: => pqp_val_shd.g_old_rec.val_attribute13
634: ,p_val_attribute14_o
635: => pqp_val_shd.g_old_rec.val_attribute14
636: ,p_val_attribute15_o
637: => pqp_val_shd.g_old_rec.val_attribute15
638: ,p_val_attribute16_o
639: => pqp_val_shd.g_old_rec.val_attribute16
640: ,p_val_attribute17_o
641: => pqp_val_shd.g_old_rec.val_attribute17
635: => pqp_val_shd.g_old_rec.val_attribute14
636: ,p_val_attribute15_o
637: => pqp_val_shd.g_old_rec.val_attribute15
638: ,p_val_attribute16_o
639: => pqp_val_shd.g_old_rec.val_attribute16
640: ,p_val_attribute17_o
641: => pqp_val_shd.g_old_rec.val_attribute17
642: ,p_val_attribute18_o
643: => pqp_val_shd.g_old_rec.val_attribute18
637: => pqp_val_shd.g_old_rec.val_attribute15
638: ,p_val_attribute16_o
639: => pqp_val_shd.g_old_rec.val_attribute16
640: ,p_val_attribute17_o
641: => pqp_val_shd.g_old_rec.val_attribute17
642: ,p_val_attribute18_o
643: => pqp_val_shd.g_old_rec.val_attribute18
644: ,p_val_attribute19_o
645: => pqp_val_shd.g_old_rec.val_attribute19
639: => pqp_val_shd.g_old_rec.val_attribute16
640: ,p_val_attribute17_o
641: => pqp_val_shd.g_old_rec.val_attribute17
642: ,p_val_attribute18_o
643: => pqp_val_shd.g_old_rec.val_attribute18
644: ,p_val_attribute19_o
645: => pqp_val_shd.g_old_rec.val_attribute19
646: ,p_val_attribute20_o
647: => pqp_val_shd.g_old_rec.val_attribute20
641: => pqp_val_shd.g_old_rec.val_attribute17
642: ,p_val_attribute18_o
643: => pqp_val_shd.g_old_rec.val_attribute18
644: ,p_val_attribute19_o
645: => pqp_val_shd.g_old_rec.val_attribute19
646: ,p_val_attribute20_o
647: => pqp_val_shd.g_old_rec.val_attribute20
648: ,p_val_information_category_o
649: => pqp_val_shd.g_old_rec.val_information_category
643: => pqp_val_shd.g_old_rec.val_attribute18
644: ,p_val_attribute19_o
645: => pqp_val_shd.g_old_rec.val_attribute19
646: ,p_val_attribute20_o
647: => pqp_val_shd.g_old_rec.val_attribute20
648: ,p_val_information_category_o
649: => pqp_val_shd.g_old_rec.val_information_category
650: ,p_val_information1_o
651: => pqp_val_shd.g_old_rec.val_information1
645: => pqp_val_shd.g_old_rec.val_attribute19
646: ,p_val_attribute20_o
647: => pqp_val_shd.g_old_rec.val_attribute20
648: ,p_val_information_category_o
649: => pqp_val_shd.g_old_rec.val_information_category
650: ,p_val_information1_o
651: => pqp_val_shd.g_old_rec.val_information1
652: ,p_val_information2_o
653: => pqp_val_shd.g_old_rec.val_information2
647: => pqp_val_shd.g_old_rec.val_attribute20
648: ,p_val_information_category_o
649: => pqp_val_shd.g_old_rec.val_information_category
650: ,p_val_information1_o
651: => pqp_val_shd.g_old_rec.val_information1
652: ,p_val_information2_o
653: => pqp_val_shd.g_old_rec.val_information2
654: ,p_val_information3_o
655: => pqp_val_shd.g_old_rec.val_information3
649: => pqp_val_shd.g_old_rec.val_information_category
650: ,p_val_information1_o
651: => pqp_val_shd.g_old_rec.val_information1
652: ,p_val_information2_o
653: => pqp_val_shd.g_old_rec.val_information2
654: ,p_val_information3_o
655: => pqp_val_shd.g_old_rec.val_information3
656: ,p_val_information4_o
657: => pqp_val_shd.g_old_rec.val_information4
651: => pqp_val_shd.g_old_rec.val_information1
652: ,p_val_information2_o
653: => pqp_val_shd.g_old_rec.val_information2
654: ,p_val_information3_o
655: => pqp_val_shd.g_old_rec.val_information3
656: ,p_val_information4_o
657: => pqp_val_shd.g_old_rec.val_information4
658: ,p_val_information5_o
659: => pqp_val_shd.g_old_rec.val_information5
653: => pqp_val_shd.g_old_rec.val_information2
654: ,p_val_information3_o
655: => pqp_val_shd.g_old_rec.val_information3
656: ,p_val_information4_o
657: => pqp_val_shd.g_old_rec.val_information4
658: ,p_val_information5_o
659: => pqp_val_shd.g_old_rec.val_information5
660: ,p_val_information6_o
661: => pqp_val_shd.g_old_rec.val_information6
655: => pqp_val_shd.g_old_rec.val_information3
656: ,p_val_information4_o
657: => pqp_val_shd.g_old_rec.val_information4
658: ,p_val_information5_o
659: => pqp_val_shd.g_old_rec.val_information5
660: ,p_val_information6_o
661: => pqp_val_shd.g_old_rec.val_information6
662: ,p_val_information7_o
663: => pqp_val_shd.g_old_rec.val_information7
657: => pqp_val_shd.g_old_rec.val_information4
658: ,p_val_information5_o
659: => pqp_val_shd.g_old_rec.val_information5
660: ,p_val_information6_o
661: => pqp_val_shd.g_old_rec.val_information6
662: ,p_val_information7_o
663: => pqp_val_shd.g_old_rec.val_information7
664: ,p_val_information8_o
665: => pqp_val_shd.g_old_rec.val_information8
659: => pqp_val_shd.g_old_rec.val_information5
660: ,p_val_information6_o
661: => pqp_val_shd.g_old_rec.val_information6
662: ,p_val_information7_o
663: => pqp_val_shd.g_old_rec.val_information7
664: ,p_val_information8_o
665: => pqp_val_shd.g_old_rec.val_information8
666: ,p_val_information9_o
667: => pqp_val_shd.g_old_rec.val_information9
661: => pqp_val_shd.g_old_rec.val_information6
662: ,p_val_information7_o
663: => pqp_val_shd.g_old_rec.val_information7
664: ,p_val_information8_o
665: => pqp_val_shd.g_old_rec.val_information8
666: ,p_val_information9_o
667: => pqp_val_shd.g_old_rec.val_information9
668: ,p_val_information10_o
669: => pqp_val_shd.g_old_rec.val_information10
663: => pqp_val_shd.g_old_rec.val_information7
664: ,p_val_information8_o
665: => pqp_val_shd.g_old_rec.val_information8
666: ,p_val_information9_o
667: => pqp_val_shd.g_old_rec.val_information9
668: ,p_val_information10_o
669: => pqp_val_shd.g_old_rec.val_information10
670: ,p_val_information11_o
671: => pqp_val_shd.g_old_rec.val_information11
665: => pqp_val_shd.g_old_rec.val_information8
666: ,p_val_information9_o
667: => pqp_val_shd.g_old_rec.val_information9
668: ,p_val_information10_o
669: => pqp_val_shd.g_old_rec.val_information10
670: ,p_val_information11_o
671: => pqp_val_shd.g_old_rec.val_information11
672: ,p_val_information12_o
673: => pqp_val_shd.g_old_rec.val_information12
667: => pqp_val_shd.g_old_rec.val_information9
668: ,p_val_information10_o
669: => pqp_val_shd.g_old_rec.val_information10
670: ,p_val_information11_o
671: => pqp_val_shd.g_old_rec.val_information11
672: ,p_val_information12_o
673: => pqp_val_shd.g_old_rec.val_information12
674: ,p_val_information13_o
675: => pqp_val_shd.g_old_rec.val_information13
669: => pqp_val_shd.g_old_rec.val_information10
670: ,p_val_information11_o
671: => pqp_val_shd.g_old_rec.val_information11
672: ,p_val_information12_o
673: => pqp_val_shd.g_old_rec.val_information12
674: ,p_val_information13_o
675: => pqp_val_shd.g_old_rec.val_information13
676: ,p_val_information14_o
677: => pqp_val_shd.g_old_rec.val_information14
671: => pqp_val_shd.g_old_rec.val_information11
672: ,p_val_information12_o
673: => pqp_val_shd.g_old_rec.val_information12
674: ,p_val_information13_o
675: => pqp_val_shd.g_old_rec.val_information13
676: ,p_val_information14_o
677: => pqp_val_shd.g_old_rec.val_information14
678: ,p_val_information15_o
679: => pqp_val_shd.g_old_rec.val_information15
673: => pqp_val_shd.g_old_rec.val_information12
674: ,p_val_information13_o
675: => pqp_val_shd.g_old_rec.val_information13
676: ,p_val_information14_o
677: => pqp_val_shd.g_old_rec.val_information14
678: ,p_val_information15_o
679: => pqp_val_shd.g_old_rec.val_information15
680: ,p_val_information16_o
681: => pqp_val_shd.g_old_rec.val_information16
675: => pqp_val_shd.g_old_rec.val_information13
676: ,p_val_information14_o
677: => pqp_val_shd.g_old_rec.val_information14
678: ,p_val_information15_o
679: => pqp_val_shd.g_old_rec.val_information15
680: ,p_val_information16_o
681: => pqp_val_shd.g_old_rec.val_information16
682: ,p_val_information17_o
683: => pqp_val_shd.g_old_rec.val_information17
677: => pqp_val_shd.g_old_rec.val_information14
678: ,p_val_information15_o
679: => pqp_val_shd.g_old_rec.val_information15
680: ,p_val_information16_o
681: => pqp_val_shd.g_old_rec.val_information16
682: ,p_val_information17_o
683: => pqp_val_shd.g_old_rec.val_information17
684: ,p_val_information18_o
685: => pqp_val_shd.g_old_rec.val_information18
679: => pqp_val_shd.g_old_rec.val_information15
680: ,p_val_information16_o
681: => pqp_val_shd.g_old_rec.val_information16
682: ,p_val_information17_o
683: => pqp_val_shd.g_old_rec.val_information17
684: ,p_val_information18_o
685: => pqp_val_shd.g_old_rec.val_information18
686: ,p_val_information19_o
687: => pqp_val_shd.g_old_rec.val_information19
681: => pqp_val_shd.g_old_rec.val_information16
682: ,p_val_information17_o
683: => pqp_val_shd.g_old_rec.val_information17
684: ,p_val_information18_o
685: => pqp_val_shd.g_old_rec.val_information18
686: ,p_val_information19_o
687: => pqp_val_shd.g_old_rec.val_information19
688: ,p_val_information20_o
689: => pqp_val_shd.g_old_rec.val_information20
683: => pqp_val_shd.g_old_rec.val_information17
684: ,p_val_information18_o
685: => pqp_val_shd.g_old_rec.val_information18
686: ,p_val_information19_o
687: => pqp_val_shd.g_old_rec.val_information19
688: ,p_val_information20_o
689: => pqp_val_shd.g_old_rec.val_information20
690: ,p_object_version_number_o
691: => pqp_val_shd.g_old_rec.object_version_number
685: => pqp_val_shd.g_old_rec.val_information18
686: ,p_val_information19_o
687: => pqp_val_shd.g_old_rec.val_information19
688: ,p_val_information20_o
689: => pqp_val_shd.g_old_rec.val_information20
690: ,p_object_version_number_o
691: => pqp_val_shd.g_old_rec.object_version_number
692: ,p_fuel_benefit_o
693: => pqp_val_shd.g_old_rec.fuel_benefit
687: => pqp_val_shd.g_old_rec.val_information19
688: ,p_val_information20_o
689: => pqp_val_shd.g_old_rec.val_information20
690: ,p_object_version_number_o
691: => pqp_val_shd.g_old_rec.object_version_number
692: ,p_fuel_benefit_o
693: => pqp_val_shd.g_old_rec.fuel_benefit
694:
695: ,p_sliding_rates_info_o
689: => pqp_val_shd.g_old_rec.val_information20
690: ,p_object_version_number_o
691: => pqp_val_shd.g_old_rec.object_version_number
692: ,p_fuel_benefit_o
693: => pqp_val_shd.g_old_rec.fuel_benefit
694:
695: ,p_sliding_rates_info_o
696: => pqp_val_shd.g_old_rec.sliding_rates_info
697: );
692: ,p_fuel_benefit_o
693: => pqp_val_shd.g_old_rec.fuel_benefit
694:
695: ,p_sliding_rates_info_o
696: => pqp_val_shd.g_old_rec.sliding_rates_info
697: );
698: --
699: exception
700: --
752: --
753: -- {End Of Comments}
754: -- ----------------------------------------------------------------------------
755: Procedure convert_defs
756: (p_rec in out nocopy pqp_val_shd.g_rec_type
757: ) is
758: --
759: Begin
760: --
764: -- is being used then we must set to the 'current' argument value.
765: --
766: If (p_rec.assignment_id = hr_api.g_number) then
767: p_rec.assignment_id :=
768: pqp_val_shd.g_old_rec.assignment_id;
769: End If;
770: If (p_rec.business_group_id = hr_api.g_number) then
771: p_rec.business_group_id :=
772: pqp_val_shd.g_old_rec.business_group_id;
768: pqp_val_shd.g_old_rec.assignment_id;
769: End If;
770: If (p_rec.business_group_id = hr_api.g_number) then
771: p_rec.business_group_id :=
772: pqp_val_shd.g_old_rec.business_group_id;
773: End If;
774: If (p_rec.across_assignments = hr_api.g_varchar2) then
775: p_rec.across_assignments :=
776: pqp_val_shd.g_old_rec.across_assignments;
772: pqp_val_shd.g_old_rec.business_group_id;
773: End If;
774: If (p_rec.across_assignments = hr_api.g_varchar2) then
775: p_rec.across_assignments :=
776: pqp_val_shd.g_old_rec.across_assignments;
777: End If;
778: If (p_rec.vehicle_repository_id = hr_api.g_number) then
779: p_rec.vehicle_repository_id :=
780: pqp_val_shd.g_old_rec.vehicle_repository_id;
776: pqp_val_shd.g_old_rec.across_assignments;
777: End If;
778: If (p_rec.vehicle_repository_id = hr_api.g_number) then
779: p_rec.vehicle_repository_id :=
780: pqp_val_shd.g_old_rec.vehicle_repository_id;
781: End If;
782: If (p_rec.usage_type = hr_api.g_varchar2) then
783: p_rec.usage_type :=
784: pqp_val_shd.g_old_rec.usage_type;
780: pqp_val_shd.g_old_rec.vehicle_repository_id;
781: End If;
782: If (p_rec.usage_type = hr_api.g_varchar2) then
783: p_rec.usage_type :=
784: pqp_val_shd.g_old_rec.usage_type;
785: End If;
786: If (p_rec.capital_contribution = hr_api.g_number) then
787: p_rec.capital_contribution :=
788: pqp_val_shd.g_old_rec.capital_contribution;
784: pqp_val_shd.g_old_rec.usage_type;
785: End If;
786: If (p_rec.capital_contribution = hr_api.g_number) then
787: p_rec.capital_contribution :=
788: pqp_val_shd.g_old_rec.capital_contribution;
789: End If;
790: If (p_rec.private_contribution = hr_api.g_number) then
791: p_rec.private_contribution :=
792: pqp_val_shd.g_old_rec.private_contribution;
788: pqp_val_shd.g_old_rec.capital_contribution;
789: End If;
790: If (p_rec.private_contribution = hr_api.g_number) then
791: p_rec.private_contribution :=
792: pqp_val_shd.g_old_rec.private_contribution;
793: End If;
794: If (p_rec.default_vehicle = hr_api.g_varchar2) then
795: p_rec.default_vehicle :=
796: pqp_val_shd.g_old_rec.default_vehicle;
792: pqp_val_shd.g_old_rec.private_contribution;
793: End If;
794: If (p_rec.default_vehicle = hr_api.g_varchar2) then
795: p_rec.default_vehicle :=
796: pqp_val_shd.g_old_rec.default_vehicle;
797: End If;
798: If (p_rec.fuel_card = hr_api.g_varchar2) then
799: p_rec.fuel_card :=
800: pqp_val_shd.g_old_rec.fuel_card;
796: pqp_val_shd.g_old_rec.default_vehicle;
797: End If;
798: If (p_rec.fuel_card = hr_api.g_varchar2) then
799: p_rec.fuel_card :=
800: pqp_val_shd.g_old_rec.fuel_card;
801: End If;
802: If (p_rec.fuel_card_number = hr_api.g_varchar2) then
803: p_rec.fuel_card_number :=
804: pqp_val_shd.g_old_rec.fuel_card_number;
800: pqp_val_shd.g_old_rec.fuel_card;
801: End If;
802: If (p_rec.fuel_card_number = hr_api.g_varchar2) then
803: p_rec.fuel_card_number :=
804: pqp_val_shd.g_old_rec.fuel_card_number;
805: End If;
806: If (p_rec.calculation_method = hr_api.g_varchar2) then
807: p_rec.calculation_method :=
808: pqp_val_shd.g_old_rec.calculation_method;
804: pqp_val_shd.g_old_rec.fuel_card_number;
805: End If;
806: If (p_rec.calculation_method = hr_api.g_varchar2) then
807: p_rec.calculation_method :=
808: pqp_val_shd.g_old_rec.calculation_method;
809: End If;
810: If (p_rec.rates_table_id = hr_api.g_number) then
811: p_rec.rates_table_id :=
812: pqp_val_shd.g_old_rec.rates_table_id;
808: pqp_val_shd.g_old_rec.calculation_method;
809: End If;
810: If (p_rec.rates_table_id = hr_api.g_number) then
811: p_rec.rates_table_id :=
812: pqp_val_shd.g_old_rec.rates_table_id;
813: End If;
814: If (p_rec.element_type_id = hr_api.g_number) then
815: p_rec.element_type_id :=
816: pqp_val_shd.g_old_rec.element_type_id;
812: pqp_val_shd.g_old_rec.rates_table_id;
813: End If;
814: If (p_rec.element_type_id = hr_api.g_number) then
815: p_rec.element_type_id :=
816: pqp_val_shd.g_old_rec.element_type_id;
817: End If;
818: If (p_rec.private_use_flag = hr_api.g_varchar2) then
819: p_rec.private_use_flag :=
820: pqp_val_shd.g_old_rec.private_use_flag;
816: pqp_val_shd.g_old_rec.element_type_id;
817: End If;
818: If (p_rec.private_use_flag = hr_api.g_varchar2) then
819: p_rec.private_use_flag :=
820: pqp_val_shd.g_old_rec.private_use_flag;
821: End If;
822: If (p_rec.insurance_number = hr_api.g_varchar2) then
823: p_rec.insurance_number :=
824: pqp_val_shd.g_old_rec.insurance_number;
820: pqp_val_shd.g_old_rec.private_use_flag;
821: End If;
822: If (p_rec.insurance_number = hr_api.g_varchar2) then
823: p_rec.insurance_number :=
824: pqp_val_shd.g_old_rec.insurance_number;
825: End If;
826: If (p_rec.insurance_expiry_date = hr_api.g_date) then
827: p_rec.insurance_expiry_date :=
828: pqp_val_shd.g_old_rec.insurance_expiry_date;
824: pqp_val_shd.g_old_rec.insurance_number;
825: End If;
826: If (p_rec.insurance_expiry_date = hr_api.g_date) then
827: p_rec.insurance_expiry_date :=
828: pqp_val_shd.g_old_rec.insurance_expiry_date;
829: End If;
830: If (p_rec.val_attribute_category = hr_api.g_varchar2) then
831: p_rec.val_attribute_category :=
832: pqp_val_shd.g_old_rec.val_attribute_category;
828: pqp_val_shd.g_old_rec.insurance_expiry_date;
829: End If;
830: If (p_rec.val_attribute_category = hr_api.g_varchar2) then
831: p_rec.val_attribute_category :=
832: pqp_val_shd.g_old_rec.val_attribute_category;
833: End If;
834: If (p_rec.val_attribute1 = hr_api.g_varchar2) then
835: p_rec.val_attribute1 :=
836: pqp_val_shd.g_old_rec.val_attribute1;
832: pqp_val_shd.g_old_rec.val_attribute_category;
833: End If;
834: If (p_rec.val_attribute1 = hr_api.g_varchar2) then
835: p_rec.val_attribute1 :=
836: pqp_val_shd.g_old_rec.val_attribute1;
837: End If;
838: If (p_rec.val_attribute2 = hr_api.g_varchar2) then
839: p_rec.val_attribute2 :=
840: pqp_val_shd.g_old_rec.val_attribute2;
836: pqp_val_shd.g_old_rec.val_attribute1;
837: End If;
838: If (p_rec.val_attribute2 = hr_api.g_varchar2) then
839: p_rec.val_attribute2 :=
840: pqp_val_shd.g_old_rec.val_attribute2;
841: End If;
842: If (p_rec.val_attribute3 = hr_api.g_varchar2) then
843: p_rec.val_attribute3 :=
844: pqp_val_shd.g_old_rec.val_attribute3;
840: pqp_val_shd.g_old_rec.val_attribute2;
841: End If;
842: If (p_rec.val_attribute3 = hr_api.g_varchar2) then
843: p_rec.val_attribute3 :=
844: pqp_val_shd.g_old_rec.val_attribute3;
845: End If;
846: If (p_rec.val_attribute4 = hr_api.g_varchar2) then
847: p_rec.val_attribute4 :=
848: pqp_val_shd.g_old_rec.val_attribute4;
844: pqp_val_shd.g_old_rec.val_attribute3;
845: End If;
846: If (p_rec.val_attribute4 = hr_api.g_varchar2) then
847: p_rec.val_attribute4 :=
848: pqp_val_shd.g_old_rec.val_attribute4;
849: End If;
850: If (p_rec.val_attribute5 = hr_api.g_varchar2) then
851: p_rec.val_attribute5 :=
852: pqp_val_shd.g_old_rec.val_attribute5;
848: pqp_val_shd.g_old_rec.val_attribute4;
849: End If;
850: If (p_rec.val_attribute5 = hr_api.g_varchar2) then
851: p_rec.val_attribute5 :=
852: pqp_val_shd.g_old_rec.val_attribute5;
853: End If;
854: If (p_rec.val_attribute6 = hr_api.g_varchar2) then
855: p_rec.val_attribute6 :=
856: pqp_val_shd.g_old_rec.val_attribute6;
852: pqp_val_shd.g_old_rec.val_attribute5;
853: End If;
854: If (p_rec.val_attribute6 = hr_api.g_varchar2) then
855: p_rec.val_attribute6 :=
856: pqp_val_shd.g_old_rec.val_attribute6;
857: End If;
858: If (p_rec.val_attribute7 = hr_api.g_varchar2) then
859: p_rec.val_attribute7 :=
860: pqp_val_shd.g_old_rec.val_attribute7;
856: pqp_val_shd.g_old_rec.val_attribute6;
857: End If;
858: If (p_rec.val_attribute7 = hr_api.g_varchar2) then
859: p_rec.val_attribute7 :=
860: pqp_val_shd.g_old_rec.val_attribute7;
861: End If;
862: If (p_rec.val_attribute8 = hr_api.g_varchar2) then
863: p_rec.val_attribute8 :=
864: pqp_val_shd.g_old_rec.val_attribute8;
860: pqp_val_shd.g_old_rec.val_attribute7;
861: End If;
862: If (p_rec.val_attribute8 = hr_api.g_varchar2) then
863: p_rec.val_attribute8 :=
864: pqp_val_shd.g_old_rec.val_attribute8;
865: End If;
866: If (p_rec.val_attribute9 = hr_api.g_varchar2) then
867: p_rec.val_attribute9 :=
868: pqp_val_shd.g_old_rec.val_attribute9;
864: pqp_val_shd.g_old_rec.val_attribute8;
865: End If;
866: If (p_rec.val_attribute9 = hr_api.g_varchar2) then
867: p_rec.val_attribute9 :=
868: pqp_val_shd.g_old_rec.val_attribute9;
869: End If;
870: If (p_rec.val_attribute10 = hr_api.g_varchar2) then
871: p_rec.val_attribute10 :=
872: pqp_val_shd.g_old_rec.val_attribute10;
868: pqp_val_shd.g_old_rec.val_attribute9;
869: End If;
870: If (p_rec.val_attribute10 = hr_api.g_varchar2) then
871: p_rec.val_attribute10 :=
872: pqp_val_shd.g_old_rec.val_attribute10;
873: End If;
874: If (p_rec.val_attribute11 = hr_api.g_varchar2) then
875: p_rec.val_attribute11 :=
876: pqp_val_shd.g_old_rec.val_attribute11;
872: pqp_val_shd.g_old_rec.val_attribute10;
873: End If;
874: If (p_rec.val_attribute11 = hr_api.g_varchar2) then
875: p_rec.val_attribute11 :=
876: pqp_val_shd.g_old_rec.val_attribute11;
877: End If;
878: If (p_rec.val_attribute12 = hr_api.g_varchar2) then
879: p_rec.val_attribute12 :=
880: pqp_val_shd.g_old_rec.val_attribute12;
876: pqp_val_shd.g_old_rec.val_attribute11;
877: End If;
878: If (p_rec.val_attribute12 = hr_api.g_varchar2) then
879: p_rec.val_attribute12 :=
880: pqp_val_shd.g_old_rec.val_attribute12;
881: End If;
882: If (p_rec.val_attribute13 = hr_api.g_varchar2) then
883: p_rec.val_attribute13 :=
884: pqp_val_shd.g_old_rec.val_attribute13;
880: pqp_val_shd.g_old_rec.val_attribute12;
881: End If;
882: If (p_rec.val_attribute13 = hr_api.g_varchar2) then
883: p_rec.val_attribute13 :=
884: pqp_val_shd.g_old_rec.val_attribute13;
885: End If;
886: If (p_rec.val_attribute14 = hr_api.g_varchar2) then
887: p_rec.val_attribute14 :=
888: pqp_val_shd.g_old_rec.val_attribute14;
884: pqp_val_shd.g_old_rec.val_attribute13;
885: End If;
886: If (p_rec.val_attribute14 = hr_api.g_varchar2) then
887: p_rec.val_attribute14 :=
888: pqp_val_shd.g_old_rec.val_attribute14;
889: End If;
890: If (p_rec.val_attribute15 = hr_api.g_varchar2) then
891: p_rec.val_attribute15 :=
892: pqp_val_shd.g_old_rec.val_attribute15;
888: pqp_val_shd.g_old_rec.val_attribute14;
889: End If;
890: If (p_rec.val_attribute15 = hr_api.g_varchar2) then
891: p_rec.val_attribute15 :=
892: pqp_val_shd.g_old_rec.val_attribute15;
893: End If;
894: If (p_rec.val_attribute16 = hr_api.g_varchar2) then
895: p_rec.val_attribute16 :=
896: pqp_val_shd.g_old_rec.val_attribute16;
892: pqp_val_shd.g_old_rec.val_attribute15;
893: End If;
894: If (p_rec.val_attribute16 = hr_api.g_varchar2) then
895: p_rec.val_attribute16 :=
896: pqp_val_shd.g_old_rec.val_attribute16;
897: End If;
898: If (p_rec.val_attribute17 = hr_api.g_varchar2) then
899: p_rec.val_attribute17 :=
900: pqp_val_shd.g_old_rec.val_attribute17;
896: pqp_val_shd.g_old_rec.val_attribute16;
897: End If;
898: If (p_rec.val_attribute17 = hr_api.g_varchar2) then
899: p_rec.val_attribute17 :=
900: pqp_val_shd.g_old_rec.val_attribute17;
901: End If;
902: If (p_rec.val_attribute18 = hr_api.g_varchar2) then
903: p_rec.val_attribute18 :=
904: pqp_val_shd.g_old_rec.val_attribute18;
900: pqp_val_shd.g_old_rec.val_attribute17;
901: End If;
902: If (p_rec.val_attribute18 = hr_api.g_varchar2) then
903: p_rec.val_attribute18 :=
904: pqp_val_shd.g_old_rec.val_attribute18;
905: End If;
906: If (p_rec.val_attribute19 = hr_api.g_varchar2) then
907: p_rec.val_attribute19 :=
908: pqp_val_shd.g_old_rec.val_attribute19;
904: pqp_val_shd.g_old_rec.val_attribute18;
905: End If;
906: If (p_rec.val_attribute19 = hr_api.g_varchar2) then
907: p_rec.val_attribute19 :=
908: pqp_val_shd.g_old_rec.val_attribute19;
909: End If;
910: If (p_rec.val_attribute20 = hr_api.g_varchar2) then
911: p_rec.val_attribute20 :=
912: pqp_val_shd.g_old_rec.val_attribute20;
908: pqp_val_shd.g_old_rec.val_attribute19;
909: End If;
910: If (p_rec.val_attribute20 = hr_api.g_varchar2) then
911: p_rec.val_attribute20 :=
912: pqp_val_shd.g_old_rec.val_attribute20;
913: End If;
914: If (p_rec.val_information_category = hr_api.g_varchar2) then
915: p_rec.val_information_category :=
916: pqp_val_shd.g_old_rec.val_information_category;
912: pqp_val_shd.g_old_rec.val_attribute20;
913: End If;
914: If (p_rec.val_information_category = hr_api.g_varchar2) then
915: p_rec.val_information_category :=
916: pqp_val_shd.g_old_rec.val_information_category;
917: End If;
918: If (p_rec.val_information1 = hr_api.g_varchar2) then
919: p_rec.val_information1 :=
920: pqp_val_shd.g_old_rec.val_information1;
916: pqp_val_shd.g_old_rec.val_information_category;
917: End If;
918: If (p_rec.val_information1 = hr_api.g_varchar2) then
919: p_rec.val_information1 :=
920: pqp_val_shd.g_old_rec.val_information1;
921: End If;
922: If (p_rec.val_information2 = hr_api.g_varchar2) then
923: p_rec.val_information2 :=
924: pqp_val_shd.g_old_rec.val_information2;
920: pqp_val_shd.g_old_rec.val_information1;
921: End If;
922: If (p_rec.val_information2 = hr_api.g_varchar2) then
923: p_rec.val_information2 :=
924: pqp_val_shd.g_old_rec.val_information2;
925: End If;
926: If (p_rec.val_information3 = hr_api.g_varchar2) then
927: p_rec.val_information3 :=
928: pqp_val_shd.g_old_rec.val_information3;
924: pqp_val_shd.g_old_rec.val_information2;
925: End If;
926: If (p_rec.val_information3 = hr_api.g_varchar2) then
927: p_rec.val_information3 :=
928: pqp_val_shd.g_old_rec.val_information3;
929: End If;
930: If (p_rec.val_information4 = hr_api.g_varchar2) then
931: p_rec.val_information4 :=
932: pqp_val_shd.g_old_rec.val_information4;
928: pqp_val_shd.g_old_rec.val_information3;
929: End If;
930: If (p_rec.val_information4 = hr_api.g_varchar2) then
931: p_rec.val_information4 :=
932: pqp_val_shd.g_old_rec.val_information4;
933: End If;
934: If (p_rec.val_information5 = hr_api.g_varchar2) then
935: p_rec.val_information5 :=
936: pqp_val_shd.g_old_rec.val_information5;
932: pqp_val_shd.g_old_rec.val_information4;
933: End If;
934: If (p_rec.val_information5 = hr_api.g_varchar2) then
935: p_rec.val_information5 :=
936: pqp_val_shd.g_old_rec.val_information5;
937: End If;
938: If (p_rec.val_information6 = hr_api.g_varchar2) then
939: p_rec.val_information6 :=
940: pqp_val_shd.g_old_rec.val_information6;
936: pqp_val_shd.g_old_rec.val_information5;
937: End If;
938: If (p_rec.val_information6 = hr_api.g_varchar2) then
939: p_rec.val_information6 :=
940: pqp_val_shd.g_old_rec.val_information6;
941: End If;
942: If (p_rec.val_information7 = hr_api.g_varchar2) then
943: p_rec.val_information7 :=
944: pqp_val_shd.g_old_rec.val_information7;
940: pqp_val_shd.g_old_rec.val_information6;
941: End If;
942: If (p_rec.val_information7 = hr_api.g_varchar2) then
943: p_rec.val_information7 :=
944: pqp_val_shd.g_old_rec.val_information7;
945: End If;
946: If (p_rec.val_information8 = hr_api.g_varchar2) then
947: p_rec.val_information8 :=
948: pqp_val_shd.g_old_rec.val_information8;
944: pqp_val_shd.g_old_rec.val_information7;
945: End If;
946: If (p_rec.val_information8 = hr_api.g_varchar2) then
947: p_rec.val_information8 :=
948: pqp_val_shd.g_old_rec.val_information8;
949: End If;
950: If (p_rec.val_information9 = hr_api.g_varchar2) then
951: p_rec.val_information9 :=
952: pqp_val_shd.g_old_rec.val_information9;
948: pqp_val_shd.g_old_rec.val_information8;
949: End If;
950: If (p_rec.val_information9 = hr_api.g_varchar2) then
951: p_rec.val_information9 :=
952: pqp_val_shd.g_old_rec.val_information9;
953: End If;
954: If (p_rec.val_information10 = hr_api.g_varchar2) then
955: p_rec.val_information10 :=
956: pqp_val_shd.g_old_rec.val_information10;
952: pqp_val_shd.g_old_rec.val_information9;
953: End If;
954: If (p_rec.val_information10 = hr_api.g_varchar2) then
955: p_rec.val_information10 :=
956: pqp_val_shd.g_old_rec.val_information10;
957: End If;
958: If (p_rec.val_information11 = hr_api.g_varchar2) then
959: p_rec.val_information11 :=
960: pqp_val_shd.g_old_rec.val_information11;
956: pqp_val_shd.g_old_rec.val_information10;
957: End If;
958: If (p_rec.val_information11 = hr_api.g_varchar2) then
959: p_rec.val_information11 :=
960: pqp_val_shd.g_old_rec.val_information11;
961: End If;
962: If (p_rec.val_information12 = hr_api.g_varchar2) then
963: p_rec.val_information12 :=
964: pqp_val_shd.g_old_rec.val_information12;
960: pqp_val_shd.g_old_rec.val_information11;
961: End If;
962: If (p_rec.val_information12 = hr_api.g_varchar2) then
963: p_rec.val_information12 :=
964: pqp_val_shd.g_old_rec.val_information12;
965: End If;
966: If (p_rec.val_information13 = hr_api.g_varchar2) then
967: p_rec.val_information13 :=
968: pqp_val_shd.g_old_rec.val_information13;
964: pqp_val_shd.g_old_rec.val_information12;
965: End If;
966: If (p_rec.val_information13 = hr_api.g_varchar2) then
967: p_rec.val_information13 :=
968: pqp_val_shd.g_old_rec.val_information13;
969: End If;
970: If (p_rec.val_information14 = hr_api.g_varchar2) then
971: p_rec.val_information14 :=
972: pqp_val_shd.g_old_rec.val_information14;
968: pqp_val_shd.g_old_rec.val_information13;
969: End If;
970: If (p_rec.val_information14 = hr_api.g_varchar2) then
971: p_rec.val_information14 :=
972: pqp_val_shd.g_old_rec.val_information14;
973: End If;
974: If (p_rec.val_information15 = hr_api.g_varchar2) then
975: p_rec.val_information15 :=
976: pqp_val_shd.g_old_rec.val_information15;
972: pqp_val_shd.g_old_rec.val_information14;
973: End If;
974: If (p_rec.val_information15 = hr_api.g_varchar2) then
975: p_rec.val_information15 :=
976: pqp_val_shd.g_old_rec.val_information15;
977: End If;
978: If (p_rec.val_information16 = hr_api.g_varchar2) then
979: p_rec.val_information16 :=
980: pqp_val_shd.g_old_rec.val_information16;
976: pqp_val_shd.g_old_rec.val_information15;
977: End If;
978: If (p_rec.val_information16 = hr_api.g_varchar2) then
979: p_rec.val_information16 :=
980: pqp_val_shd.g_old_rec.val_information16;
981: End If;
982: If (p_rec.val_information17 = hr_api.g_varchar2) then
983: p_rec.val_information17 :=
984: pqp_val_shd.g_old_rec.val_information17;
980: pqp_val_shd.g_old_rec.val_information16;
981: End If;
982: If (p_rec.val_information17 = hr_api.g_varchar2) then
983: p_rec.val_information17 :=
984: pqp_val_shd.g_old_rec.val_information17;
985: End If;
986: If (p_rec.val_information18 = hr_api.g_varchar2) then
987: p_rec.val_information18 :=
988: pqp_val_shd.g_old_rec.val_information18;
984: pqp_val_shd.g_old_rec.val_information17;
985: End If;
986: If (p_rec.val_information18 = hr_api.g_varchar2) then
987: p_rec.val_information18 :=
988: pqp_val_shd.g_old_rec.val_information18;
989: End If;
990: If (p_rec.val_information19 = hr_api.g_varchar2) then
991: p_rec.val_information19 :=
992: pqp_val_shd.g_old_rec.val_information19;
988: pqp_val_shd.g_old_rec.val_information18;
989: End If;
990: If (p_rec.val_information19 = hr_api.g_varchar2) then
991: p_rec.val_information19 :=
992: pqp_val_shd.g_old_rec.val_information19;
993: End If;
994: If (p_rec.val_information20 = hr_api.g_varchar2) then
995: p_rec.val_information20 :=
996: pqp_val_shd.g_old_rec.val_information20;
992: pqp_val_shd.g_old_rec.val_information19;
993: End If;
994: If (p_rec.val_information20 = hr_api.g_varchar2) then
995: p_rec.val_information20 :=
996: pqp_val_shd.g_old_rec.val_information20;
997: End If;
998: If (p_rec.fuel_benefit = hr_api.g_varchar2) then
999: p_rec.fuel_benefit :=
1000: pqp_val_shd.g_old_rec.fuel_benefit;
996: pqp_val_shd.g_old_rec.val_information20;
997: End If;
998: If (p_rec.fuel_benefit = hr_api.g_varchar2) then
999: p_rec.fuel_benefit :=
1000: pqp_val_shd.g_old_rec.fuel_benefit;
1001: End If;
1002: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then
1003: p_rec.sliding_rates_info :=
1004: pqp_val_shd.g_old_rec.sliding_rates_info;
1000: pqp_val_shd.g_old_rec.fuel_benefit;
1001: End If;
1002: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then
1003: p_rec.sliding_rates_info :=
1004: pqp_val_shd.g_old_rec.sliding_rates_info;
1005: End If;
1006: --
1007: End convert_defs;
1008: --
1011: -- ----------------------------------------------------------------------------
1012: Procedure upd
1013: (p_effective_date in date
1014: ,p_datetrack_mode in varchar2
1015: ,p_rec in out nocopy pqp_val_shd.g_rec_type
1016: ) is
1017: --
1018: l_proc varchar2(72) := g_package||'upd';
1019: l_validation_start_date date;
1027: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1028: --
1029: -- We must lock the row which we need to update.
1030: --
1031: pqp_val_shd.lck
1032: (p_effective_date => p_effective_date
1033: ,p_datetrack_mode => p_datetrack_mode
1034: ,p_vehicle_allocation_id => p_rec.vehicle_allocation_id
1035: ,p_object_version_number => p_rec.object_version_number
1161: ,p_effective_start_date out nocopy date
1162: ,p_effective_end_date out nocopy date
1163: ) is
1164: --
1165: l_rec pqp_val_shd.g_rec_type;
1166: l_proc varchar2(72) := g_package||'upd';
1167: --
1168: Begin
1169: hr_utility.set_location('Entering:'||l_proc, 5);
1171: -- Call conversion function to turn arguments into the
1172: -- l_rec structure.
1173: --
1174: l_rec :=
1175: pqp_val_shd.convert_args
1176: (p_vehicle_allocation_id
1177: ,null
1178: ,null
1179: ,p_assignment_id