APPS.PQP_VAL_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 165: When hr_api.check_integrity_violated Then

161: End If;
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 15);
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));

Line 169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
173: pqp_val_shd.constraint_error

Line 170: When hr_api.unique_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: --
173: pqp_val_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 174: (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;
178: End dt_update_dml;

Line 291: If (p_datetrack_mode <> hr_api.g_correction) then

287: l_dummy_version_number number;
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
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

Line 304: If (p_datetrack_mode = hr_api.g_update_override) then

300: ,p_validation_end_date => p_validation_end_date
301: ,p_object_version_number => l_dummy_version_number
302: );
303: --
304: If (p_datetrack_mode = hr_api.g_update_override) then
305: --
306: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
307: -- delete any future rows
308: --

Line 701: when hr_api.cannot_find_prog_unit then

697: );
698: --
699: exception
700: --
701: when hr_api.cannot_find_prog_unit then
702: --
703: hr_api.cannot_find_prog_unit_error
704: (p_module_name => 'PQP_VEHICLE_ALLOCATIONS_F'
705: ,p_hook_type => 'AU');

Line 703: hr_api.cannot_find_prog_unit_error

699: exception
700: --
701: when hr_api.cannot_find_prog_unit then
702: --
703: hr_api.cannot_find_prog_unit_error
704: (p_module_name => 'PQP_VEHICLE_ALLOCATIONS_F'
705: ,p_hook_type => 'AU');
706: --
707: end;

Line 766: If (p_rec.assignment_id = hr_api.g_number) then

762: -- p_rec plsql record structure
763: -- to see if a system default is being used. If a system default
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

Line 770: If (p_rec.business_group_id = hr_api.g_number) then

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;
773: End If;
774: If (p_rec.across_assignments = hr_api.g_varchar2) then

Line 774: If (p_rec.across_assignments = hr_api.g_varchar2) then

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;
777: End If;
778: If (p_rec.vehicle_repository_id = hr_api.g_number) then

Line 778: If (p_rec.vehicle_repository_id = hr_api.g_number) then

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;
781: End If;
782: If (p_rec.usage_type = hr_api.g_varchar2) then

Line 782: If (p_rec.usage_type = hr_api.g_varchar2) then

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;
785: End If;
786: If (p_rec.capital_contribution = hr_api.g_number) then

Line 786: If (p_rec.capital_contribution = hr_api.g_number) then

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;
789: End If;
790: If (p_rec.private_contribution = hr_api.g_number) then

Line 790: If (p_rec.private_contribution = hr_api.g_number) then

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;
793: End If;
794: If (p_rec.default_vehicle = hr_api.g_varchar2) then

Line 794: If (p_rec.default_vehicle = hr_api.g_varchar2) then

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;
797: End If;
798: If (p_rec.fuel_card = hr_api.g_varchar2) then

Line 798: If (p_rec.fuel_card = hr_api.g_varchar2) then

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;
801: End If;
802: If (p_rec.fuel_card_number = hr_api.g_varchar2) then

Line 802: If (p_rec.fuel_card_number = hr_api.g_varchar2) then

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;
805: End If;
806: If (p_rec.calculation_method = hr_api.g_varchar2) then

Line 806: If (p_rec.calculation_method = hr_api.g_varchar2) then

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;
809: End If;
810: If (p_rec.rates_table_id = hr_api.g_number) then

Line 810: If (p_rec.rates_table_id = hr_api.g_number) then

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;
813: End If;
814: If (p_rec.element_type_id = hr_api.g_number) then

Line 814: If (p_rec.element_type_id = hr_api.g_number) then

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;
817: End If;
818: If (p_rec.private_use_flag = hr_api.g_varchar2) then

Line 818: If (p_rec.private_use_flag = hr_api.g_varchar2) then

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;
821: End If;
822: If (p_rec.insurance_number = hr_api.g_varchar2) then

Line 822: If (p_rec.insurance_number = hr_api.g_varchar2) then

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;
825: End If;
826: If (p_rec.insurance_expiry_date = hr_api.g_date) then

Line 826: If (p_rec.insurance_expiry_date = hr_api.g_date) then

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;
829: End If;
830: If (p_rec.val_attribute_category = hr_api.g_varchar2) then

Line 830: If (p_rec.val_attribute_category = hr_api.g_varchar2) then

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;
833: End If;
834: If (p_rec.val_attribute1 = hr_api.g_varchar2) then

Line 834: If (p_rec.val_attribute1 = hr_api.g_varchar2) then

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;
837: End If;
838: If (p_rec.val_attribute2 = hr_api.g_varchar2) then

Line 838: If (p_rec.val_attribute2 = hr_api.g_varchar2) then

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;
841: End If;
842: If (p_rec.val_attribute3 = hr_api.g_varchar2) then

Line 842: If (p_rec.val_attribute3 = hr_api.g_varchar2) then

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;
845: End If;
846: If (p_rec.val_attribute4 = hr_api.g_varchar2) then

Line 846: If (p_rec.val_attribute4 = hr_api.g_varchar2) then

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;
849: End If;
850: If (p_rec.val_attribute5 = hr_api.g_varchar2) then

Line 850: If (p_rec.val_attribute5 = hr_api.g_varchar2) then

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;
853: End If;
854: If (p_rec.val_attribute6 = hr_api.g_varchar2) then

Line 854: If (p_rec.val_attribute6 = hr_api.g_varchar2) then

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;
857: End If;
858: If (p_rec.val_attribute7 = hr_api.g_varchar2) then

Line 858: If (p_rec.val_attribute7 = hr_api.g_varchar2) then

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;
861: End If;
862: If (p_rec.val_attribute8 = hr_api.g_varchar2) then

Line 862: If (p_rec.val_attribute8 = hr_api.g_varchar2) then

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;
865: End If;
866: If (p_rec.val_attribute9 = hr_api.g_varchar2) then

Line 866: If (p_rec.val_attribute9 = hr_api.g_varchar2) then

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;
869: End If;
870: If (p_rec.val_attribute10 = hr_api.g_varchar2) then

Line 870: If (p_rec.val_attribute10 = hr_api.g_varchar2) then

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;
873: End If;
874: If (p_rec.val_attribute11 = hr_api.g_varchar2) then

Line 874: If (p_rec.val_attribute11 = hr_api.g_varchar2) then

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;
877: End If;
878: If (p_rec.val_attribute12 = hr_api.g_varchar2) then

Line 878: If (p_rec.val_attribute12 = hr_api.g_varchar2) then

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;
881: End If;
882: If (p_rec.val_attribute13 = hr_api.g_varchar2) then

Line 882: If (p_rec.val_attribute13 = hr_api.g_varchar2) then

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;
885: End If;
886: If (p_rec.val_attribute14 = hr_api.g_varchar2) then

Line 886: If (p_rec.val_attribute14 = hr_api.g_varchar2) then

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;
889: End If;
890: If (p_rec.val_attribute15 = hr_api.g_varchar2) then

Line 890: If (p_rec.val_attribute15 = hr_api.g_varchar2) then

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;
893: End If;
894: If (p_rec.val_attribute16 = hr_api.g_varchar2) then

Line 894: If (p_rec.val_attribute16 = hr_api.g_varchar2) then

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;
897: End If;
898: If (p_rec.val_attribute17 = hr_api.g_varchar2) then

Line 898: If (p_rec.val_attribute17 = hr_api.g_varchar2) then

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;
901: End If;
902: If (p_rec.val_attribute18 = hr_api.g_varchar2) then

Line 902: If (p_rec.val_attribute18 = hr_api.g_varchar2) then

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;
905: End If;
906: If (p_rec.val_attribute19 = hr_api.g_varchar2) then

Line 906: If (p_rec.val_attribute19 = hr_api.g_varchar2) then

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;
909: End If;
910: If (p_rec.val_attribute20 = hr_api.g_varchar2) then

Line 910: If (p_rec.val_attribute20 = hr_api.g_varchar2) then

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;
913: End If;
914: If (p_rec.val_information_category = hr_api.g_varchar2) then

Line 914: If (p_rec.val_information_category = hr_api.g_varchar2) then

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;
917: End If;
918: If (p_rec.val_information1 = hr_api.g_varchar2) then

Line 918: If (p_rec.val_information1 = hr_api.g_varchar2) then

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;
921: End If;
922: If (p_rec.val_information2 = hr_api.g_varchar2) then

Line 922: If (p_rec.val_information2 = hr_api.g_varchar2) then

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;
925: End If;
926: If (p_rec.val_information3 = hr_api.g_varchar2) then

Line 926: If (p_rec.val_information3 = hr_api.g_varchar2) then

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;
929: End If;
930: If (p_rec.val_information4 = hr_api.g_varchar2) then

Line 930: If (p_rec.val_information4 = hr_api.g_varchar2) then

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;
933: End If;
934: If (p_rec.val_information5 = hr_api.g_varchar2) then

Line 934: If (p_rec.val_information5 = hr_api.g_varchar2) then

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;
937: End If;
938: If (p_rec.val_information6 = hr_api.g_varchar2) then

Line 938: If (p_rec.val_information6 = hr_api.g_varchar2) then

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;
941: End If;
942: If (p_rec.val_information7 = hr_api.g_varchar2) then

Line 942: If (p_rec.val_information7 = hr_api.g_varchar2) then

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;
945: End If;
946: If (p_rec.val_information8 = hr_api.g_varchar2) then

Line 946: If (p_rec.val_information8 = hr_api.g_varchar2) then

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;
949: End If;
950: If (p_rec.val_information9 = hr_api.g_varchar2) then

Line 950: If (p_rec.val_information9 = hr_api.g_varchar2) then

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;
953: End If;
954: If (p_rec.val_information10 = hr_api.g_varchar2) then

Line 954: If (p_rec.val_information10 = hr_api.g_varchar2) then

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;
957: End If;
958: If (p_rec.val_information11 = hr_api.g_varchar2) then

Line 958: If (p_rec.val_information11 = hr_api.g_varchar2) then

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;
961: End If;
962: If (p_rec.val_information12 = hr_api.g_varchar2) then

Line 962: If (p_rec.val_information12 = hr_api.g_varchar2) then

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;
965: End If;
966: If (p_rec.val_information13 = hr_api.g_varchar2) then

Line 966: If (p_rec.val_information13 = hr_api.g_varchar2) then

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;
969: End If;
970: If (p_rec.val_information14 = hr_api.g_varchar2) then

Line 970: If (p_rec.val_information14 = hr_api.g_varchar2) then

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;
973: End If;
974: If (p_rec.val_information15 = hr_api.g_varchar2) then

Line 974: If (p_rec.val_information15 = hr_api.g_varchar2) then

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;
977: End If;
978: If (p_rec.val_information16 = hr_api.g_varchar2) then

Line 978: If (p_rec.val_information16 = hr_api.g_varchar2) then

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;
981: End If;
982: If (p_rec.val_information17 = hr_api.g_varchar2) then

Line 982: If (p_rec.val_information17 = hr_api.g_varchar2) then

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;
985: End If;
986: If (p_rec.val_information18 = hr_api.g_varchar2) then

Line 986: If (p_rec.val_information18 = hr_api.g_varchar2) then

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;
989: End If;
990: If (p_rec.val_information19 = hr_api.g_varchar2) then

Line 990: If (p_rec.val_information19 = hr_api.g_varchar2) then

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;
993: End If;
994: If (p_rec.val_information20 = hr_api.g_varchar2) then

Line 994: If (p_rec.val_information20 = hr_api.g_varchar2) then

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;
997: End If;
998: If (p_rec.fuel_benefit = hr_api.g_varchar2) then

Line 998: If (p_rec.fuel_benefit = hr_api.g_varchar2) then

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;
1001: End If;
1002: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then

Line 1002: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then

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;
1005: End If;
1006: --