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_SS_VEHICLE_TRANSACTIONS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 183: FROM pqp_vehicle_repository_f pvr

179: ,cp_effective_date DATE
180: )
181: IS
182: SELECT pvr.object_version_number ovn
183: FROM pqp_vehicle_repository_f pvr
184: WHERE pvr.vehicle_repository_id = cp_repository_id
185: AND pvr.business_group_id = cp_business_group_id
186: AND rtrim(ltrim(cp_effective_date)) BETWEEN pvr.effective_start_date
187: AND pvr.effective_end_date;

Line 744: ,pqp_vehicle_repository_f pvr

740: IS
741: SELECT pva.assignment_id ,
742: pva.vehicle_allocation_id allocation_id
743: FROM pqp_vehicle_allocations_f pva
744: ,pqp_vehicle_repository_f pvr
745: WHERE pvr.registration_number = cp_registration_number
746: AND pvr.business_group_id = cp_business_group_id
747: AND pvr.business_group_id=pva.business_group_id
748: AND pvr.vehicle_repository_id=pva.vehicle_repository_id

Line 777: FROM pqp_vehicle_repository_f pvr

773: ,cp_effective_date DATE
774: )
775: IS
776: SELECT pvr.vehicle_repository_id
777: FROM pqp_vehicle_repository_f pvr
778: WHERE pvr.registration_number = cp_registration_number
779: AND pvr.business_group_id = cp_business_group_id
780: AND cp_effective_date BETWEEN pvr.effective_start_date
781: AND pvr.effective_end_date;

Line 796: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;

792: l_update_override NUMBER;
793: l_update_change_insert NUMBER;
794: l_effective_start_date DATE;
795: l_effective_end_date DATE;
796: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;
797: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
798: l_cnt NUMBER :=0;
799:
800:

Line 1266: FROM pqp_vehicle_repository_f pvr

1262: IS
1263: SELECT pvr.vehicle_repository_id
1264: ,pvr.object_version_number
1265: ,pvr.shared_vehicle
1266: FROM pqp_vehicle_repository_f pvr
1267: WHERE pvr.registration_number = cp_registration_number
1268: AND pvr.business_group_id = cp_business_group_id
1269: AND cp_effective_date BETWEEN pvr.effective_start_date
1270: AND pvr.effective_end_date;

Line 1273: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;

1269: AND cp_effective_date BETWEEN pvr.effective_start_date
1270: AND pvr.effective_end_date;
1271:
1272:
1273: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;
1274: l_object_version_number1 NUMBER;
1275: l_object_version_number NUMBER;
1276: l_user_info t_user_info;
1277: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

Line 1544: ,p_base_table_name => 'PQP_VEHICLE_REPOSITORY_F'

1540:
1541: l_object_version_number := l_get_repository_id.object_version_number;
1542: pqp_get_date_mode.find_dt_upd_modes
1543: (p_effective_date => p_effective_date
1544: ,p_base_table_name => 'PQP_VEHICLE_REPOSITORY_F'
1545: ,p_base_key_column => 'VEHICLE_REPOSITORY_ID'
1546: ,p_base_key_value => l_get_repository_id.vehicle_repository_id
1547: ,p_correction => l_correction
1548: ,p_update => l_update

Line 3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;

3475: l_person_id NUMBER;
3476: l_ovn NUMBER :=1;
3477: l_assignment_id NUMBER;
3478: l_effective_date DATE;
3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;

Line 3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;

3476: l_ovn NUMBER :=1;
3477: l_assignment_id NUMBER;
3478: l_effective_date DATE;
3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;

Line 3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;

3477: l_assignment_id NUMBER;
3478: l_effective_date DATE;
3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;

Line 3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;

3478: l_effective_date DATE;
3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;

Line 3483: l_make pqp_vehicle_repository_f.make%TYPE;

3479: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;

Line 3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;

3480: l_vehicle_type pqp_vehicle_repository_f.vehicle_type%TYPE;
3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;

Line 3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;

3481: l_vehicle_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;

Line 3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;

3482: l_business_group_id pqp_vehicle_repository_f.business_group_id%TYPE;
3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;

Line 3487: l_model pqp_vehicle_repository_f.model%TYPE;

3483: l_make pqp_vehicle_repository_f.make%TYPE;
3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;

Line 3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;

3484: l_engine_capacity_in_cc pqp_vehicle_repository_f.engine_capacity_in_cc%TYPE;
3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;

Line 3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;

3485: l_fuel_type pqp_vehicle_repository_f.fuel_type%TYPE;
3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;

Line 3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;

3486: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;

Line 3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;

3487: l_model pqp_vehicle_repository_f.model%TYPE;
3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;

Line 3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;

3488: l_initial_registration pqp_vehicle_repository_f.initial_registration%TYPE;
3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;

Line 3493: l_color pqp_vehicle_repository_f.color%TYPE;

3489: l_last_registration_renew_date pqp_vehicle_repository_f.last_registration_renew_date%TYPE;
3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;

Line 3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;

3490: l_fiscal_ratings pqp_vehicle_repository_f.fiscal_ratings%TYPE;
3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;

Line 3495: l_weight pqp_vehicle_repository_f.weight%TYPE;

3491: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;

Line 3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;

3492: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%TYPE;
3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;

Line 3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;

3493: l_color pqp_vehicle_repository_f.color%TYPE;
3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;

Line 3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;

3494: l_seating_capacity pqp_vehicle_repository_f.seating_capacity%TYPE;
3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;

Line 3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;

3495: l_weight pqp_vehicle_repository_f.weight%TYPE;
3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;

Line 3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;

3496: l_weight_uom pqp_vehicle_repository_f.weight_uom%TYPE;
3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;

Line 3501: l_comments pqp_vehicle_repository_f.comments%TYPE;

3497: l_model_year pqp_vehicle_repository_f.model_year%TYPE;
3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;

Line 3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;

3498: l_insurance_number pqp_vehicle_repository_f.insurance_number%TYPE;
3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;

Line 3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;

3499: l_insurance_expiry_date pqp_vehicle_repository_f.insurance_expiry_date%TYPE;
3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;

Line 3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;

3500: l_taxation_method pqp_vehicle_repository_f.taxation_method%TYPE;
3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;

Line 3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;

3501: l_comments pqp_vehicle_repository_f.comments%TYPE;
3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;

Line 3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;

3502: l_vre_attribute_category pqp_vehicle_repository_f.vre_attribute_category%TYPE;
3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;

Line 3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;

3503: l_vre_attribute1 pqp_vehicle_repository_f.vre_attribute1%TYPE;
3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;

Line 3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;

3504: l_vre_attribute2 pqp_vehicle_repository_f.vre_attribute2%TYPE;
3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;

Line 3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;

3505: l_vre_attribute3 pqp_vehicle_repository_f.vre_attribute3%TYPE;
3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;

Line 3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;

3506: l_vre_attribute4 pqp_vehicle_repository_f.vre_attribute4%TYPE;
3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;

Line 3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;

3507: l_vre_attribute5 pqp_vehicle_repository_f.vre_attribute5%TYPE;
3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;

Line 3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;

3508: l_vre_attribute6 pqp_vehicle_repository_f.vre_attribute6%TYPE;
3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;

Line 3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;

3509: l_vre_attribute7 pqp_vehicle_repository_f.vre_attribute7%TYPE;
3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;

Line 3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;

3510: l_vre_attribute8 pqp_vehicle_repository_f.vre_attribute8%TYPE;
3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;

Line 3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;

3511: l_vre_attribute9 pqp_vehicle_repository_f.vre_attribute9%TYPE;
3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;

Line 3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;

3512: l_vre_attribute10 pqp_vehicle_repository_f.vre_attribute10%TYPE;
3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;

Line 3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;

3513: l_vre_attribute11 pqp_vehicle_repository_f.vre_attribute11%TYPE;
3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;

Line 3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;

3514: l_vre_attribute12 pqp_vehicle_repository_f.vre_attribute12%TYPE;
3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;

Line 3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;

3515: l_vre_attribute13 pqp_vehicle_repository_f.vre_attribute13%TYPE;
3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;

Line 3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;

3516: l_vre_attribute14 pqp_vehicle_repository_f.vre_attribute14%TYPE;
3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;

Line 3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;

3517: l_vre_attribute15 pqp_vehicle_repository_f.vre_attribute15%TYPE;
3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;

Line 3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;

3518: l_vre_attribute16 pqp_vehicle_repository_f.vre_attribute16%TYPE;
3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;

Line 3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;

3519: l_vre_attribute17 pqp_vehicle_repository_f.vre_attribute17%TYPE;
3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;

Line 3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;

3520: l_vre_attribute18 pqp_vehicle_repository_f.vre_attribute18%TYPE;
3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;

Line 3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;

3521: l_vre_attribute19 pqp_vehicle_repository_f.vre_attribute19%TYPE;
3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;

Line 3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;

3522: l_vre_attribute20 pqp_vehicle_repository_f.vre_attribute20%TYPE;
3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;

Line 3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;

3523: l_vre_information_category pqp_vehicle_repository_f.vre_information_category%TYPE;
3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;

Line 3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;

3524: l_vre_information1 pqp_vehicle_repository_f.vre_information1%TYPE;
3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;

Line 3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;

3525: l_vre_information2 pqp_vehicle_repository_f.vre_information2%TYPE;
3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;

Line 3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;

3526: l_vre_information3 pqp_vehicle_repository_f.vre_information3%TYPE;
3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;

Line 3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;

3527: l_vre_information4 pqp_vehicle_repository_f.vre_information4%TYPE;
3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;

Line 3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;

3528: l_vre_information5 pqp_vehicle_repository_f.vre_information5%TYPE;
3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;

Line 3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;

3529: l_vre_information6 pqp_vehicle_repository_f.vre_information6%TYPE;
3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;

Line 3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;

3530: l_vre_information7 pqp_vehicle_repository_f.vre_information7%TYPE;
3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;

Line 3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;

3531: l_vre_information8 pqp_vehicle_repository_f.vre_information8%TYPE;
3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;

Line 3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;

3532: l_vre_information9 pqp_vehicle_repository_f.vre_information9%TYPE;
3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;

Line 3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;

3533: l_vre_information10 pqp_vehicle_repository_f.vre_information10%TYPE;
3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;

Line 3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;

3534: l_vre_information11 pqp_vehicle_repository_f.vre_information11%TYPE;
3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;

Line 3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;

3535: l_vre_information12 pqp_vehicle_repository_f.vre_information12%TYPE;
3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;

Line 3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;

3536: l_vre_information13 pqp_vehicle_repository_f.vre_information13%TYPE;
3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;

Line 3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;

3537: l_vre_information14 pqp_vehicle_repository_f.vre_information14%TYPE;
3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;

Line 3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;

3538: l_vre_information15 pqp_vehicle_repository_f.vre_information15%TYPE;
3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;

Line 3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;

3539: l_vre_information16 pqp_vehicle_repository_f.vre_information16%TYPE;
3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;

Line 3622: FROM pqp_vehicle_repository_f pvr

3618: l_get_other_tstep c_get_other_tstep%ROWTYPE;
3619: CURSOR c_get_details IS
3620: SELECT pvr.vehicle_repository_id
3621: ,pva.vehicle_allocation_id
3622: FROM pqp_vehicle_repository_f pvr
3623: ,pqp_vehicle_allocations_f pva
3624: WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
3625: AND pva.assignment_id =l_assignment_id
3626: AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date

Line 4342: FROM pqp_vehicle_repository_f pvr

4338: ,cp_effective_date DATE
4339: )
4340: IS
4341: SELECT pvr.object_version_number ovn
4342: FROM pqp_vehicle_repository_f pvr
4343: WHERE pvr.vehicle_repository_id = cp_repository_id
4344: AND pvr.business_group_id = cp_business_group_id
4345: AND rtrim(ltrim(cp_effective_date)) BETWEEN pvr.effective_start_date
4346: AND pvr.effective_end_date;