[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hrl.lookup_code
FROM hr_lookups hrl
WHERE lookup_type = 'PQP_FISCAL_RATINGS_UOM'
AND enabled_flag = 'Y';
PROCEDURE delete_vehicle
(p_validate in number
,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
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_vehicle';
savepoint delete_vehicle_swi;
pqp_vehicle_repository_api.delete_vehicle
(p_validate => l_validate
,p_effective_date => p_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_swi;
rollback to delete_vehicle_swi;
end delete_vehicle;
PROCEDURE update_vehicle
(p_validate in number
,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
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_vehicle';
savepoint update_vehicle_swi;
pqp_vehicle_repository_api.update_vehicle
(p_validate => l_validate
,p_effective_date => p_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 => p_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_swi;
rollback to update_vehicle_swi;
end update_vehicle;