eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VRE_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 183: WHEN hr_api.check_integrity_violated THEN

179: END IF;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
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));

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

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: --
191: pqp_vre_shd.constraint_error

Line 188: WHEN hr_api.unique_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: --
191: pqp_vre_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 192: (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;
196: END dt_update_dml;

Line 309: IF (p_datetrack_mode <> hr_api.g_correction) THEN

305: l_dummy_version_number NUMBER;
306: --
307: BEGIN
308: hr_utility.set_location('Entering:'||l_proc, 5);
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

Line 322: IF (p_datetrack_mode = hr_api.g_update_override) THEN

318: ,p_validation_end_date => p_validation_end_date
319: ,p_object_version_number => l_dummy_version_number
320: );
321: --
322: IF (p_datetrack_mode = hr_api.g_update_override) THEN
323: --
324: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
325: -- delete any future rows
326: --

Line 792: WHEN hr_api.cannot_find_prog_unit THEN

788: );
789: --
790: EXCEPTION
791: --
792: WHEN hr_api.cannot_find_prog_unit THEN
793: --
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'PQP_VEHICLE_REPOSITORY_F'
796: ,p_hook_type => 'AU');

Line 794: hr_api.cannot_find_prog_unit_error

790: EXCEPTION
791: --
792: WHEN hr_api.cannot_find_prog_unit THEN
793: --
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'PQP_VEHICLE_REPOSITORY_F'
796: ,p_hook_type => 'AU');
797: --
798: END;

Line 857: IF (p_rec.registration_number = hr_api.g_varchar2) THEN

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

Line 861: IF (p_rec.vehicle_type = hr_api.g_varchar2) THEN

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;
864: END IF;
865: IF (p_rec.vehicle_id_number = hr_api.g_varchar2) THEN

Line 865: IF (p_rec.vehicle_id_number = hr_api.g_varchar2) THEN

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;
868: END IF;
869: IF (p_rec.business_group_id = hr_api.g_number) THEN

Line 869: IF (p_rec.business_group_id = hr_api.g_number) THEN

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;
872: END IF;
873: IF (p_rec.make = hr_api.g_varchar2) THEN

Line 873: IF (p_rec.make = hr_api.g_varchar2) THEN

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;
876: END IF;
877: IF (p_rec.model = hr_api.g_varchar2) THEN

Line 877: IF (p_rec.model = hr_api.g_varchar2) THEN

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;
880: END IF;
881: IF (p_rec.initial_registration = hr_api.g_date) THEN

Line 881: IF (p_rec.initial_registration = hr_api.g_date) THEN

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;
884: END IF;
885: IF (p_rec.last_registration_renew_date = hr_api.g_date) THEN

Line 885: IF (p_rec.last_registration_renew_date = hr_api.g_date) THEN

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;
888: END IF;
889: IF (p_rec.engine_capacity_in_cc = hr_api.g_number) THEN

Line 889: IF (p_rec.engine_capacity_in_cc = hr_api.g_number) THEN

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;
892: END IF;
893: IF (p_rec.fuel_type = hr_api.g_varchar2) THEN

Line 893: IF (p_rec.fuel_type = hr_api.g_varchar2) THEN

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;
896: END IF;
897: IF (p_rec.currency_code = hr_api.g_varchar2) THEN

Line 897: IF (p_rec.currency_code = hr_api.g_varchar2) THEN

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;
900: END IF;
901: IF (p_rec.list_price = hr_api.g_number) THEN

Line 901: IF (p_rec.list_price = hr_api.g_number) THEN

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;
904: END IF;
905: IF (p_rec.accessory_value_at_startdate = hr_api.g_number) THEN

Line 905: IF (p_rec.accessory_value_at_startdate = hr_api.g_number) THEN

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;
908: END IF;
909: IF (p_rec.accessory_value_added_later = hr_api.g_number) THEN

Line 909: IF (p_rec.accessory_value_added_later = hr_api.g_number) THEN

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;
912: END IF;
913: IF (p_rec.market_value_classic_car = hr_api.g_number) THEN

Line 913: IF (p_rec.market_value_classic_car = hr_api.g_number) THEN

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;
916: END IF;
917: IF (p_rec.fiscal_ratings = hr_api.g_number) THEN

Line 917: IF (p_rec.fiscal_ratings = hr_api.g_number) THEN

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;
920: END IF;
921: IF (p_rec.fiscal_ratings_uom = hr_api.g_varchar2) THEN

Line 921: IF (p_rec.fiscal_ratings_uom = hr_api.g_varchar2) THEN

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;
924: END IF;
925: IF (p_rec.vehicle_provider = hr_api.g_varchar2) THEN

Line 925: IF (p_rec.vehicle_provider = hr_api.g_varchar2) THEN

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;
928: END IF;
929: IF (p_rec.vehicle_ownership = hr_api.g_varchar2) THEN

Line 929: IF (p_rec.vehicle_ownership = hr_api.g_varchar2) THEN

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;
932: END IF;
933: IF (p_rec.shared_vehicle = hr_api.g_varchar2) THEN

Line 933: IF (p_rec.shared_vehicle = hr_api.g_varchar2) THEN

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;
936: END IF;
937: IF (p_rec.vehicle_status = hr_api.g_varchar2) THEN

Line 937: IF (p_rec.vehicle_status = hr_api.g_varchar2) THEN

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;
940: END IF;
941: IF (p_rec.vehicle_inactivity_reason = hr_api.g_varchar2) THEN

Line 941: IF (p_rec.vehicle_inactivity_reason = hr_api.g_varchar2) THEN

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;
944: END IF;
945: IF (p_rec.asset_number = hr_api.g_varchar2) THEN

Line 945: IF (p_rec.asset_number = hr_api.g_varchar2) THEN

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;
948: END IF;
949: IF (p_rec.lease_contract_number = hr_api.g_varchar2) THEN

Line 949: IF (p_rec.lease_contract_number = hr_api.g_varchar2) THEN

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;
952: END IF;
953: IF (p_rec.lease_contract_expiry_date = hr_api.g_date) THEN

Line 953: IF (p_rec.lease_contract_expiry_date = hr_api.g_date) THEN

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;
956: END IF;
957: IF (p_rec.taxation_method = hr_api.g_varchar2) THEN

Line 957: IF (p_rec.taxation_method = hr_api.g_varchar2) THEN

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;
960: END IF;
961: IF (p_rec.fleet_info = hr_api.g_varchar2) THEN

Line 961: IF (p_rec.fleet_info = hr_api.g_varchar2) THEN

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;
964: END IF;
965: IF (p_rec.fleet_transfer_date = hr_api.g_date) THEN

Line 965: IF (p_rec.fleet_transfer_date = hr_api.g_date) THEN

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;
968: END IF;
969: IF (p_rec.color = hr_api.g_varchar2) THEN

Line 969: IF (p_rec.color = hr_api.g_varchar2) THEN

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;
972: END IF;
973: IF (p_rec.seating_capacity = hr_api.g_number) THEN

Line 973: IF (p_rec.seating_capacity = hr_api.g_number) THEN

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;
976: END IF;
977: IF (p_rec.weight = hr_api.g_number) THEN

Line 977: IF (p_rec.weight = hr_api.g_number) THEN

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;
980: END IF;
981: IF (p_rec.weight_uom = hr_api.g_varchar2) THEN

Line 981: IF (p_rec.weight_uom = hr_api.g_varchar2) THEN

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;
984: END IF;
985: IF (p_rec.model_year = hr_api.g_number) THEN

Line 985: IF (p_rec.model_year = hr_api.g_number) THEN

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;
988: END IF;
989: IF (p_rec.insurance_number = hr_api.g_varchar2) THEN

Line 989: IF (p_rec.insurance_number = hr_api.g_varchar2) THEN

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;
992: END IF;
993: IF (p_rec.insurance_expiry_date = hr_api.g_date) THEN

Line 993: IF (p_rec.insurance_expiry_date = hr_api.g_date) THEN

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;
996: END IF;
997: IF (p_rec.comments = hr_api.g_varchar2) THEN

Line 997: IF (p_rec.comments = hr_api.g_varchar2) THEN

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;
1000: END IF;
1001: IF (p_rec.vre_attribute_category = hr_api.g_varchar2) THEN

Line 1001: IF (p_rec.vre_attribute_category = hr_api.g_varchar2) THEN

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;
1004: END IF;
1005: IF (p_rec.vre_attribute1 = hr_api.g_varchar2) THEN

Line 1005: IF (p_rec.vre_attribute1 = hr_api.g_varchar2) THEN

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;
1008: END IF;
1009: IF (p_rec.vre_attribute2 = hr_api.g_varchar2) THEN

Line 1009: IF (p_rec.vre_attribute2 = hr_api.g_varchar2) THEN

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;
1012: END IF;
1013: IF (p_rec.vre_attribute3 = hr_api.g_varchar2) THEN

Line 1013: IF (p_rec.vre_attribute3 = hr_api.g_varchar2) THEN

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;
1016: END IF;
1017: IF (p_rec.vre_attribute4 = hr_api.g_varchar2) THEN

Line 1017: IF (p_rec.vre_attribute4 = hr_api.g_varchar2) THEN

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;
1020: END IF;
1021: IF (p_rec.vre_attribute5 = hr_api.g_varchar2) THEN

Line 1021: IF (p_rec.vre_attribute5 = hr_api.g_varchar2) THEN

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;
1024: END IF;
1025: IF (p_rec.vre_attribute6 = hr_api.g_varchar2) THEN

Line 1025: IF (p_rec.vre_attribute6 = hr_api.g_varchar2) THEN

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;
1028: END IF;
1029: IF (p_rec.vre_attribute7 = hr_api.g_varchar2) THEN

Line 1029: IF (p_rec.vre_attribute7 = hr_api.g_varchar2) THEN

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;
1032: END IF;
1033: IF (p_rec.vre_attribute8 = hr_api.g_varchar2) THEN

Line 1033: IF (p_rec.vre_attribute8 = hr_api.g_varchar2) THEN

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;
1036: END IF;
1037: IF (p_rec.vre_attribute9 = hr_api.g_varchar2) THEN

Line 1037: IF (p_rec.vre_attribute9 = hr_api.g_varchar2) THEN

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;
1040: END IF;
1041: IF (p_rec.vre_attribute10 = hr_api.g_varchar2) THEN

Line 1041: IF (p_rec.vre_attribute10 = hr_api.g_varchar2) THEN

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;
1044: END IF;
1045: IF (p_rec.vre_attribute11 = hr_api.g_varchar2) THEN

Line 1045: IF (p_rec.vre_attribute11 = hr_api.g_varchar2) THEN

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;
1048: END IF;
1049: IF (p_rec.vre_attribute12 = hr_api.g_varchar2) THEN

Line 1049: IF (p_rec.vre_attribute12 = hr_api.g_varchar2) THEN

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;
1052: END IF;
1053: IF (p_rec.vre_attribute13 = hr_api.g_varchar2) THEN

Line 1053: IF (p_rec.vre_attribute13 = hr_api.g_varchar2) THEN

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;
1056: END IF;
1057: IF (p_rec.vre_attribute14 = hr_api.g_varchar2) THEN

Line 1057: IF (p_rec.vre_attribute14 = hr_api.g_varchar2) THEN

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;
1060: END IF;
1061: IF (p_rec.vre_attribute15 = hr_api.g_varchar2) THEN

Line 1061: IF (p_rec.vre_attribute15 = hr_api.g_varchar2) THEN

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;
1064: END IF;
1065: IF (p_rec.vre_attribute16 = hr_api.g_varchar2) THEN

Line 1065: IF (p_rec.vre_attribute16 = hr_api.g_varchar2) THEN

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;
1068: END IF;
1069: IF (p_rec.vre_attribute17 = hr_api.g_varchar2) THEN

Line 1069: IF (p_rec.vre_attribute17 = hr_api.g_varchar2) THEN

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;
1072: END IF;
1073: IF (p_rec.vre_attribute18 = hr_api.g_varchar2) THEN

Line 1073: IF (p_rec.vre_attribute18 = hr_api.g_varchar2) THEN

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;
1076: END IF;
1077: IF (p_rec.vre_attribute19 = hr_api.g_varchar2) THEN

Line 1077: IF (p_rec.vre_attribute19 = hr_api.g_varchar2) THEN

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;
1080: END IF;
1081: IF (p_rec.vre_attribute20 = hr_api.g_varchar2) THEN

Line 1081: IF (p_rec.vre_attribute20 = hr_api.g_varchar2) THEN

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;
1084: END IF;
1085: IF (p_rec.vre_information_category = hr_api.g_varchar2) THEN

Line 1085: IF (p_rec.vre_information_category = hr_api.g_varchar2) THEN

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;
1088: END IF;
1089: IF (p_rec.vre_information1 = hr_api.g_varchar2) THEN

Line 1089: IF (p_rec.vre_information1 = hr_api.g_varchar2) THEN

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;
1092: END IF;
1093: IF (p_rec.vre_information2 = hr_api.g_varchar2) THEN

Line 1093: IF (p_rec.vre_information2 = hr_api.g_varchar2) THEN

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;
1096: END IF;
1097: IF (p_rec.vre_information3 = hr_api.g_varchar2) THEN

Line 1097: IF (p_rec.vre_information3 = hr_api.g_varchar2) THEN

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;
1100: END IF;
1101: IF (p_rec.vre_information4 = hr_api.g_varchar2) THEN

Line 1101: IF (p_rec.vre_information4 = hr_api.g_varchar2) THEN

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;
1104: END IF;
1105: IF (p_rec.vre_information5 = hr_api.g_varchar2) THEN

Line 1105: IF (p_rec.vre_information5 = hr_api.g_varchar2) THEN

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;
1108: END IF;
1109: IF (p_rec.vre_information6 = hr_api.g_varchar2) THEN

Line 1109: IF (p_rec.vre_information6 = hr_api.g_varchar2) THEN

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;
1112: END IF;
1113: IF (p_rec.vre_information7 = hr_api.g_varchar2) THEN

Line 1113: IF (p_rec.vre_information7 = hr_api.g_varchar2) THEN

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;
1116: END IF;
1117: IF (p_rec.vre_information8 = hr_api.g_varchar2) THEN

Line 1117: IF (p_rec.vre_information8 = hr_api.g_varchar2) THEN

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;
1120: END IF;
1121: IF (p_rec.vre_information9 = hr_api.g_varchar2) THEN

Line 1121: IF (p_rec.vre_information9 = hr_api.g_varchar2) THEN

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;
1124: END IF;
1125: IF (p_rec.vre_information10 = hr_api.g_varchar2) THEN

Line 1125: IF (p_rec.vre_information10 = hr_api.g_varchar2) THEN

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;
1128: END IF;
1129: IF (p_rec.vre_information11 = hr_api.g_varchar2) THEN

Line 1129: IF (p_rec.vre_information11 = hr_api.g_varchar2) THEN

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;
1132: END IF;
1133: IF (p_rec.vre_information12 = hr_api.g_varchar2) THEN

Line 1133: IF (p_rec.vre_information12 = hr_api.g_varchar2) THEN

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;
1136: END IF;
1137: IF (p_rec.vre_information13 = hr_api.g_varchar2) THEN

Line 1137: IF (p_rec.vre_information13 = hr_api.g_varchar2) THEN

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;
1140: END IF;
1141: IF (p_rec.vre_information14 = hr_api.g_varchar2) THEN

Line 1141: IF (p_rec.vre_information14 = hr_api.g_varchar2) THEN

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;
1144: END IF;
1145: IF (p_rec.vre_information15 = hr_api.g_varchar2) THEN

Line 1145: IF (p_rec.vre_information15 = hr_api.g_varchar2) THEN

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;
1148: END IF;
1149: IF (p_rec.vre_information16 = hr_api.g_varchar2) THEN

Line 1149: IF (p_rec.vre_information16 = hr_api.g_varchar2) THEN

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;
1152: END IF;
1153: IF (p_rec.vre_information17 = hr_api.g_varchar2) THEN

Line 1153: IF (p_rec.vre_information17 = hr_api.g_varchar2) THEN

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;
1156: END IF;
1157: IF (p_rec.vre_information18 = hr_api.g_varchar2) THEN

Line 1157: IF (p_rec.vre_information18 = hr_api.g_varchar2) THEN

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;
1160: END IF;
1161: IF (p_rec.vre_information19 = hr_api.g_varchar2) THEN

Line 1161: IF (p_rec.vre_information19 = hr_api.g_varchar2) THEN

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;
1164: END IF;
1165: IF (p_rec.vre_information20 = hr_api.g_varchar2) THEN

Line 1165: IF (p_rec.vre_information20 = hr_api.g_varchar2) THEN

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;
1168: END IF;
1169: