The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_vehicle
(p_validate in boolean
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_vehicle_repository_id in number
,p_object_version_number in out NOCOPY number
,p_registration_number in varchar2
,p_vehicle_type in varchar2
,p_vehicle_id_number in varchar2
,p_business_group_id in number
,p_make in varchar2
,p_engine_capacity_in_cc in number
,p_fuel_type in varchar2
,p_currency_code in varchar2
,p_vehicle_status in varchar2
,p_vehicle_inactivity_reason in varchar2
,p_model in varchar2
,p_initial_registration in date
,p_last_registration_renew_date in date
,p_list_price in number
,p_accessory_value_at_startdate in number
,p_accessory_value_added_later in number
,p_market_value_classic_car in number
,p_fiscal_ratings in number
,p_fiscal_ratings_uom in varchar2
,p_vehicle_provider in varchar2
,p_vehicle_ownership in varchar2
,p_shared_vehicle in varchar2
,p_asset_number in varchar2
,p_lease_contract_number in varchar2
,p_lease_contract_expiry_date in date
,p_taxation_method in varchar2
,p_fleet_info in varchar2
,p_fleet_transfer_date in date
,p_color in varchar2
,p_seating_capacity in number
,p_weight in number
,p_weight_uom in varchar2
,p_model_year in number
,p_insurance_number in varchar2
,p_insurance_expiry_date in date
,p_comments in varchar2
,p_vre_attribute_category in varchar2
,p_vre_attribute1 in varchar2
,p_vre_attribute2 in varchar2
,p_vre_attribute3 in varchar2
,p_vre_attribute4 in varchar2
,p_vre_attribute5 in varchar2
,p_vre_attribute6 in varchar2
,p_vre_attribute7 in varchar2
,p_vre_attribute8 in varchar2
,p_vre_attribute9 in varchar2
,p_vre_attribute10 in varchar2
,p_vre_attribute11 in varchar2
,p_vre_attribute12 in varchar2
,p_vre_attribute13 in varchar2
,p_vre_attribute14 in varchar2
,p_vre_attribute15 in varchar2
,p_vre_attribute16 in varchar2
,p_vre_attribute17 in varchar2
,p_vre_attribute18 in varchar2
,p_vre_attribute19 in varchar2
,p_vre_attribute20 in varchar2
,p_vre_information_category in varchar2
,p_vre_information1 in varchar2
,p_vre_information2 in varchar2
,p_vre_information3 in varchar2
,p_vre_information4 in varchar2
,p_vre_information5 in varchar2
,p_vre_information6 in varchar2
,p_vre_information7 in varchar2
,p_vre_information8 in varchar2
,p_vre_information9 in varchar2
,p_vre_information10 in varchar2
,p_vre_information11 in varchar2
,p_vre_information12 in varchar2
,p_vre_information13 in varchar2
,p_vre_information14 in varchar2
,p_vre_information15 in varchar2
,p_vre_information16 in varchar2
,p_vre_information17 in varchar2
,p_vre_information18 in varchar2
,p_vre_information19 in varchar2
,p_vre_information20 in varchar2
,p_effective_start_date out NOCOPY date
,p_effective_end_date out NOCOPY date
)
IS
l_proc varchar2(72) := g_package||'update_vehicle';
savepoint update_vehicle;
PQP_VEHICLE_REPOSITORY_BK2.update_vehicle_b
( p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_repository_id =>p_vehicle_repository_id
,p_object_version_number =>p_object_version_number
,p_registration_number =>p_registration_number
,p_vehicle_type =>p_vehicle_type
,p_vehicle_id_number =>p_vehicle_id_number
,p_business_group_id =>p_business_group_id
,p_make =>p_make
,p_engine_capacity_in_cc =>p_engine_capacity_in_cc
,p_fuel_type =>p_fuel_type
,p_currency_code =>l_currency_code
,p_vehicle_status =>p_vehicle_status
,p_vehicle_inactivity_reason =>p_vehicle_inactivity_reason
,p_model =>p_model
,p_initial_registration =>p_initial_registration
,p_last_registration_renew_date =>p_last_registration_renew_date
,p_list_price =>p_list_price
,p_accessory_value_at_startdate =>p_accessory_value_at_startdate
,p_accessory_value_added_later =>p_accessory_value_added_later
,p_market_value_classic_car =>p_market_value_classic_car
,p_fiscal_ratings =>p_fiscal_ratings
,p_fiscal_ratings_uom =>p_fiscal_ratings_uom
,p_vehicle_provider =>p_vehicle_provider
,p_vehicle_ownership =>p_vehicle_ownership
,p_shared_vehicle =>p_shared_vehicle
,p_asset_number =>p_asset_number
,p_lease_contract_number =>p_lease_contract_number
,p_lease_contract_expiry_date =>p_lease_contract_expiry_date
,p_taxation_method =>p_taxation_method
,p_fleet_info =>p_fleet_info
,p_fleet_transfer_date =>p_fleet_transfer_date
,p_color =>p_color
,p_seating_capacity =>p_seating_capacity
,p_weight =>p_weight
,p_weight_uom =>p_weight_uom
,p_model_year =>p_model_year
,p_insurance_number =>p_insurance_number
,p_insurance_expiry_date =>p_insurance_expiry_date
,p_comments =>p_comments
,p_vre_attribute_category =>p_vre_attribute_category
,p_vre_attribute1 =>p_vre_attribute1
,p_vre_attribute2 =>p_vre_attribute2
,p_vre_attribute3 =>p_vre_attribute3
,p_vre_attribute4 =>p_vre_attribute4
,p_vre_attribute5 =>p_vre_attribute5
,p_vre_attribute6 =>p_vre_attribute6
,p_vre_attribute7 =>p_vre_attribute7
,p_vre_attribute8 =>p_vre_attribute8
,p_vre_attribute9 =>p_vre_attribute9
,p_vre_attribute10 =>p_vre_attribute10
,p_vre_attribute11 =>p_vre_attribute11
,p_vre_attribute12 =>p_vre_attribute12
,p_vre_attribute13 =>p_vre_attribute13
,p_vre_attribute14 =>p_vre_attribute14
,p_vre_attribute15 =>p_vre_attribute15
,p_vre_attribute16 =>p_vre_attribute16
,p_vre_attribute17 =>p_vre_attribute17
,p_vre_attribute18 =>p_vre_attribute18
,p_vre_attribute19 =>p_vre_attribute19
,p_vre_attribute20 =>p_vre_attribute20
,p_vre_information_category =>p_vre_information_category
,p_vre_information1 =>p_vre_information1
,p_vre_information2 =>p_vre_information2
,p_vre_information3 =>p_vre_information3
,p_vre_information4 =>p_vre_information4
,p_vre_information5 =>p_vre_information5
,p_vre_information6 =>p_vre_information6
,p_vre_information7 =>p_vre_information7
,p_vre_information8 =>p_vre_information8
,p_vre_information9 =>p_vre_information9
,p_vre_information10 =>p_vre_information10
,p_vre_information11 =>p_vre_information11
,p_vre_information12 =>p_vre_information12
,p_vre_information13 =>p_vre_information13
,p_vre_information14 =>p_vre_information14
,p_vre_information15 =>p_vre_information15
,p_vre_information16 =>p_vre_information16
,p_vre_information17 =>p_vre_information17
,p_vre_information18 =>p_vre_information18
,p_vre_information19 =>p_vre_information19
,p_vre_information20 =>p_vre_information20
) ;
PQP_VEHICLE_REPOSITORY_BK2.update_vehicle_a
( p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_repository_id =>p_vehicle_repository_id
,p_object_version_number =>p_object_version_number
,p_registration_number =>p_registration_number
,p_vehicle_type =>p_vehicle_type
,p_vehicle_id_number =>p_vehicle_id_number
,p_business_group_id =>p_business_group_id
,p_make =>p_make
,p_engine_capacity_in_cc =>p_engine_capacity_in_cc
,p_fuel_type =>p_fuel_type
,p_currency_code =>l_currency_code
,p_vehicle_status =>p_vehicle_status
,p_vehicle_inactivity_reason =>p_vehicle_inactivity_reason
,p_model =>p_model
,p_initial_registration =>p_initial_registration
,p_last_registration_renew_date =>p_last_registration_renew_date
,p_list_price =>p_list_price
,p_accessory_value_at_startdate =>p_accessory_value_at_startdate
,p_accessory_value_added_later =>p_accessory_value_added_later
,p_market_value_classic_car =>p_market_value_classic_car
,p_fiscal_ratings =>p_fiscal_ratings
,p_fiscal_ratings_uom =>p_fiscal_ratings_uom
,p_vehicle_provider =>p_vehicle_provider
,p_vehicle_ownership =>p_vehicle_ownership
,p_shared_vehicle =>p_shared_vehicle
,p_asset_number =>p_asset_number
,p_lease_contract_number =>p_lease_contract_number
,p_lease_contract_expiry_date =>p_lease_contract_expiry_date
,p_taxation_method =>p_taxation_method
,p_fleet_info =>p_fleet_info
,p_fleet_transfer_date =>p_fleet_transfer_date
,p_color =>p_color
,p_seating_capacity =>p_seating_capacity
,p_weight =>p_weight
,p_weight_uom =>p_weight_uom
,p_model_year =>p_model_year
,p_insurance_number =>p_insurance_number
,p_insurance_expiry_date =>p_insurance_expiry_date
,p_comments =>p_comments
,p_vre_attribute_category =>p_vre_attribute_category
,p_vre_attribute1 =>p_vre_attribute1
,p_vre_attribute2 =>p_vre_attribute2
,p_vre_attribute3 =>p_vre_attribute3
,p_vre_attribute4 =>p_vre_attribute4
,p_vre_attribute5 =>p_vre_attribute5
,p_vre_attribute6 =>p_vre_attribute6
,p_vre_attribute7 =>p_vre_attribute7
,p_vre_attribute8 =>p_vre_attribute8
,p_vre_attribute9 =>p_vre_attribute9
,p_vre_attribute10 =>p_vre_attribute10
,p_vre_attribute11 =>p_vre_attribute11
,p_vre_attribute12 =>p_vre_attribute12
,p_vre_attribute13 =>p_vre_attribute13
,p_vre_attribute14 =>p_vre_attribute14
,p_vre_attribute15 =>p_vre_attribute15
,p_vre_attribute16 =>p_vre_attribute16
,p_vre_attribute17 =>p_vre_attribute17
,p_vre_attribute18 =>p_vre_attribute18
,p_vre_attribute19 =>p_vre_attribute19
,p_vre_attribute20 =>p_vre_attribute20
,p_vre_information_category =>p_vre_information_category
,p_vre_information1 =>p_vre_information1
,p_vre_information2 =>p_vre_information2
,p_vre_information3 =>p_vre_information3
,p_vre_information4 =>p_vre_information4
,p_vre_information5 =>p_vre_information5
,p_vre_information6 =>p_vre_information6
,p_vre_information7 =>p_vre_information7
,p_vre_information8 =>p_vre_information8
,p_vre_information9 =>p_vre_information9
,p_vre_information10 =>p_vre_information10
,p_vre_information11 =>p_vre_information11
,p_vre_information12 =>p_vre_information12
,p_vre_information13 =>p_vre_information13
,p_vre_information14 =>p_vre_information14
,p_vre_information15 =>p_vre_information15
,p_vre_information16 =>p_vre_information16
,p_vre_information17 =>p_vre_information17
,p_vre_information18 =>p_vre_information18
,p_vre_information19 =>p_vre_information19
,p_vre_information20 =>p_vre_information20
,p_effective_start_date =>p_effective_start_date
,p_effective_end_date =>p_effective_end_date
) ;
rollback to update_vehicle;
rollback to update_vehicle;
END update_vehicle;
Procedure delete_vehicle
(p_validate in boolean
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_vehicle_repository_id in number
,p_object_version_number in out NOCOPY number
,p_effective_start_date out NOCOPY date
,p_effective_end_date out NOCOPY date
)
IS
l_proc varchar2(72) := g_package||'delete_vehicle';
savepoint delete_vehicle;
PQP_VEHICLE_REPOSITORY_BK3.delete_vehicle_b
(p_validate =>p_validate
,p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_repository_id =>p_vehicle_repository_id
,p_object_version_number =>p_object_version_number
) ;
PQP_VEHICLE_REPOSITORY_BK3.delete_vehicle_a
(p_validate =>p_validate
,p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_repository_id =>p_vehicle_repository_id
,p_object_version_number =>p_object_version_number
,p_effective_start_date =>p_effective_start_date
,p_effective_end_date =>p_effective_end_date
) ;
rollback to delete_vehicle;
rollback to delete_vehicle;
END delete_vehicle;