[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE dt_update_dml
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc varchar2(72) := g_package||'dt_update_dml';
UPDATE pqp_vehicle_repository_f
SET
vehicle_repository_id = p_rec.vehicle_repository_id
,registration_number = p_rec.registration_number
,vehicle_type = p_rec.vehicle_type
,vehicle_id_number = p_rec.vehicle_id_number
,business_group_id = p_rec.business_group_id
,make = p_rec.make
,model = p_rec.model
,initial_registration = p_rec.initial_registration
,last_registration_renew_date = p_rec.last_registration_renew_date
,engine_capacity_in_cc = p_rec.engine_capacity_in_cc
,fuel_type = p_rec.fuel_type
,currency_code = p_rec.currency_code
,list_price = p_rec.list_price
,accessory_value_at_startdate = p_rec.accessory_value_at_startdate
,accessory_value_added_later = p_rec.accessory_value_added_later
,market_value_classic_car = p_rec.market_value_classic_car
,fiscal_ratings = p_rec.fiscal_ratings
,fiscal_ratings_uom = p_rec.fiscal_ratings_uom
,vehicle_provider = p_rec.vehicle_provider
,vehicle_ownership = p_rec.vehicle_ownership
,shared_vehicle = p_rec.shared_vehicle
,vehicle_status = p_rec.vehicle_status
,vehicle_inactivity_reason = p_rec.vehicle_inactivity_reason
,asset_number = p_rec.asset_number
,lease_contract_number = p_rec.lease_contract_number
,lease_contract_expiry_date = p_rec.lease_contract_expiry_date
,taxation_method = p_rec.taxation_method
,fleet_info = p_rec.fleet_info
,fleet_transfer_date = p_rec.fleet_transfer_date
,object_version_number = p_rec.object_version_number
,color = p_rec.color
,seating_capacity = p_rec.seating_capacity
,weight = p_rec.weight
,weight_uom = p_rec.weight_uom
,model_year = p_rec.model_year
,insurance_number = p_rec.insurance_number
,insurance_expiry_date = p_rec.insurance_expiry_date
,comments = p_rec.comments
,vre_attribute_category = p_rec.vre_attribute_category
,vre_attribute1 = p_rec.vre_attribute1
,vre_attribute2 = p_rec.vre_attribute2
,vre_attribute3 = p_rec.vre_attribute3
,vre_attribute4 = p_rec.vre_attribute4
,vre_attribute5 = p_rec.vre_attribute5
,vre_attribute6 = p_rec.vre_attribute6
,vre_attribute7 = p_rec.vre_attribute7
,vre_attribute8 = p_rec.vre_attribute8
,vre_attribute9 = p_rec.vre_attribute9
,vre_attribute10 = p_rec.vre_attribute10
,vre_attribute11 = p_rec.vre_attribute11
,vre_attribute12 = p_rec.vre_attribute12
,vre_attribute13 = p_rec.vre_attribute13
,vre_attribute14 = p_rec.vre_attribute14
,vre_attribute15 = p_rec.vre_attribute15
,vre_attribute16 = p_rec.vre_attribute16
,vre_attribute17 = p_rec.vre_attribute17
,vre_attribute18 = p_rec.vre_attribute18
,vre_attribute19 = p_rec.vre_attribute19
,vre_attribute20 = p_rec.vre_attribute20
,vre_information_category = p_rec.vre_information_category
,vre_information1 = p_rec.vre_information1
,vre_information2 = p_rec.vre_information2
,vre_information3 = p_rec.vre_information3
,vre_information4 = p_rec.vre_information4
,vre_information5 = p_rec.vre_information5
,vre_information6 = p_rec.vre_information6
,vre_information7 = p_rec.vre_information7
,vre_information8 = p_rec.vre_information8
,vre_information9 = p_rec.vre_information9
,vre_information10 = p_rec.vre_information10
,vre_information11 = p_rec.vre_information11
,vre_information12 = p_rec.vre_information12
,vre_information13 = p_rec.vre_information13
,vre_information14 = p_rec.vre_information14
,vre_information15 = p_rec.vre_information15
,vre_information16 = p_rec.vre_information16
,vre_information17 = p_rec.vre_information17
,vre_information18 = p_rec.vre_information18
,vre_information19 = p_rec.vre_information19
,vre_information20 = p_rec.vre_information20
WHERE vehicle_repository_id = p_rec.vehicle_repository_id
AND effective_start_date = p_validation_start_date
AND effective_end_date = p_validation_end_date;
END dt_update_dml;
PROCEDURE update_dml
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc varchar2(72) := g_package||'update_dml';
pqp_vre_upd.dt_update_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
END update_dml;
PROCEDURE dt_pre_update
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc VARCHAR2(72) := g_package||'dt_pre_update';
IF (p_datetrack_mode = hr_api.g_update_override) THEN
--
-- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
-- delete any future rows
--
pqp_vre_del.delete_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
pqp_vre_ins.insert_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
END dt_pre_update;
PROCEDURE pre_update
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc varchar2(72) := g_package||'pre_update';
dt_pre_update
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
END pre_update;
PROCEDURE post_update
(p_rec IN pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc varchar2(72) := g_package||'post_update';
pqp_vre_rku.after_update
(p_effective_date
=> p_effective_date
,p_datetrack_mode
=> p_datetrack_mode
,p_validation_start_date
=> p_validation_start_date
,p_validation_end_date
=> p_validation_end_date
,p_vehicle_repository_id
=> p_rec.vehicle_repository_id
,p_effective_start_date
=> p_rec.effective_start_date
,p_effective_end_date
=> p_rec.effective_end_date
,p_registration_number
=> p_rec.registration_number
,p_vehicle_type
=> p_rec.vehicle_type
,p_vehicle_id_number
=> p_rec.vehicle_id_number
,p_business_group_id
=> p_rec.business_group_id
,p_make
=> p_rec.make
,p_model
=> p_rec.model
,p_initial_registration
=> p_rec.initial_registration
,p_last_registration_renew_date
=> p_rec.last_registration_renew_date
,p_engine_capacity_in_cc
=> p_rec.engine_capacity_in_cc
,p_fuel_type
=> p_rec.fuel_type
,p_currency_code
=> p_rec.currency_code
,p_list_price
=> p_rec.list_price
,p_accessory_value_at_startdate
=> p_rec.accessory_value_at_startdate
,p_accessory_value_added_later
=> p_rec.accessory_value_added_later
,p_market_value_classic_car
=> p_rec.market_value_classic_car
,p_fiscal_ratings
=> p_rec.fiscal_ratings
,p_fiscal_ratings_uom
=> p_rec.fiscal_ratings_uom
,p_vehicle_provider
=> p_rec.vehicle_provider
,p_vehicle_ownership
=> p_rec.vehicle_ownership
,p_shared_vehicle
=> p_rec.shared_vehicle
,p_vehicle_status
=> p_rec.vehicle_status
,p_vehicle_inactivity_reason
=> p_rec.vehicle_inactivity_reason
,p_asset_number
=> p_rec.asset_number
,p_lease_contract_number
=> p_rec.lease_contract_number
,p_lease_contract_expiry_date
=>p_rec.lease_contract_expiry_date
,p_taxation_method
=> p_rec.taxation_method
,p_fleet_info
=> p_rec.fleet_info
,p_fleet_transfer_date
=> p_rec.fleet_transfer_date
,p_object_version_number
=> p_rec.object_version_number
,p_color
=> p_rec.color
,p_seating_capacity
=> p_rec.seating_capacity
,p_weight
=> p_rec.weight
,p_weight_uom
=> p_rec.weight_uom
,p_model_year
=> p_rec.model_year
,p_insurance_number
=> p_rec.insurance_number
,p_insurance_expiry_date
=> p_rec.insurance_expiry_date
,p_comments
=> p_rec.comments
,p_vre_attribute_category
=> p_rec.vre_attribute_category
,p_vre_attribute1
=> p_rec.vre_attribute1
,p_vre_attribute2
=> p_rec.vre_attribute2
,p_vre_attribute3
=> p_rec.vre_attribute3
,p_vre_attribute4
=> p_rec.vre_attribute4
,p_vre_attribute5
=> p_rec.vre_attribute5
,p_vre_attribute6
=> p_rec.vre_attribute6
,p_vre_attribute7
=> p_rec.vre_attribute7
,p_vre_attribute8
=> p_rec.vre_attribute8
,p_vre_attribute9
=> p_rec.vre_attribute9
,p_vre_attribute10
=> p_rec.vre_attribute10
,p_vre_attribute11
=> p_rec.vre_attribute11
,p_vre_attribute12
=> p_rec.vre_attribute12
,p_vre_attribute13
=> p_rec.vre_attribute13
,p_vre_attribute14
=> p_rec.vre_attribute14
,p_vre_attribute15
=> p_rec.vre_attribute15
,p_vre_attribute16
=> p_rec.vre_attribute16
,p_vre_attribute17
=> p_rec.vre_attribute17
,p_vre_attribute18
=> p_rec.vre_attribute18
,p_vre_attribute19
=> p_rec.vre_attribute19
,p_vre_attribute20
=> p_rec.vre_attribute20
,p_vre_information_category
=> p_rec.vre_information_category
,p_vre_information1
=> p_rec.vre_information1
,p_vre_information2
=> p_rec.vre_information2
,p_vre_information3
=> p_rec.vre_information3
,p_vre_information4
=> p_rec.vre_information4
,p_vre_information5
=> p_rec.vre_information5
,p_vre_information6
=> p_rec.vre_information6
,p_vre_information7
=> p_rec.vre_information7
,p_vre_information8
=> p_rec.vre_information8
,p_vre_information9
=> p_rec.vre_information9
,p_vre_information10
=> p_rec.vre_information10
,p_vre_information11
=> p_rec.vre_information11
,p_vre_information12
=> p_rec.vre_information12
,p_vre_information13
=> p_rec.vre_information13
,p_vre_information14
=> p_rec.vre_information14
,p_vre_information15
=> p_rec.vre_information15
,p_vre_information16
=> p_rec.vre_information16
,p_vre_information17
=> p_rec.vre_information17
,p_vre_information18
=> p_rec.vre_information18
,p_vre_information19
=> p_rec.vre_information19
,p_vre_information20
=> p_rec.vre_information20
,p_effective_start_date_o
=> pqp_vre_shd.g_old_rec.effective_start_date
,p_effective_end_date_o
=> pqp_vre_shd.g_old_rec.effective_end_date
,p_registration_number_o
=> pqp_vre_shd.g_old_rec.registration_number
,p_vehicle_type_o
=> pqp_vre_shd.g_old_rec.vehicle_type
,p_vehicle_id_number_o
=> pqp_vre_shd.g_old_rec.vehicle_id_number
,p_business_group_id_o
=> pqp_vre_shd.g_old_rec.business_group_id
,p_make_o
=> pqp_vre_shd.g_old_rec.make
,p_model_o
=> pqp_vre_shd.g_old_rec.model
,p_initial_registration_o
=> pqp_vre_shd.g_old_rec.initial_registration
,p_last_registration_renew_da_o
=> pqp_vre_shd.g_old_rec.last_registration_renew_date
,p_engine_capacity_in_cc_o
=> pqp_vre_shd.g_old_rec.engine_capacity_in_cc
,p_fuel_type_o
=> pqp_vre_shd.g_old_rec.fuel_type
,p_currency_code_o
=> pqp_vre_shd.g_old_rec.currency_code
,p_list_price_o
=> pqp_vre_shd.g_old_rec.list_price
,p_accessory_value_at_startda_o
=> pqp_vre_shd.g_old_rec.accessory_value_at_startdate
,p_accessory_value_added_late_o
=> pqp_vre_shd.g_old_rec.accessory_value_added_later
,p_market_value_classic_car_o
=> pqp_vre_shd.g_old_rec.market_value_classic_car
,p_fiscal_ratings_o
=> pqp_vre_shd.g_old_rec.fiscal_ratings
,p_fiscal_ratings_uom_o
=> pqp_vre_shd.g_old_rec.fiscal_ratings_uom
,p_vehicle_provider_o
=> pqp_vre_shd.g_old_rec.vehicle_provider
,p_vehicle_ownership_o
=> pqp_vre_shd.g_old_rec.vehicle_ownership
,p_shared_vehicle_o
=> pqp_vre_shd.g_old_rec.shared_vehicle
,p_vehicle_status_o
=> pqp_vre_shd.g_old_rec.vehicle_status
,p_vehicle_inactivity_reason_o
=> pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
,p_asset_number_o
=> pqp_vre_shd.g_old_rec.asset_number
,p_lease_contract_number_o
=> pqp_vre_shd.g_old_rec.lease_contract_number
,p_lease_contract_expiry_date_o
=> pqp_vre_shd.g_old_rec.lease_contract_expiry_date
,p_taxation_method_o
=> pqp_vre_shd.g_old_rec.taxation_method
,p_fleet_info_o
=> pqp_vre_shd.g_old_rec.fleet_info
,p_fleet_transfer_date_o
=> pqp_vre_shd.g_old_rec.fleet_transfer_date
,p_object_version_number_o
=> pqp_vre_shd.g_old_rec.object_version_number
,p_color_o
=> pqp_vre_shd.g_old_rec.color
,p_seating_capacity_o
=> pqp_vre_shd.g_old_rec.seating_capacity
,p_weight_o
=> pqp_vre_shd.g_old_rec.weight
,p_weight_uom_o
=> pqp_vre_shd.g_old_rec.weight_uom
,p_model_year_o
=> pqp_vre_shd.g_old_rec.model_year
,p_insurance_number_o
=> pqp_vre_shd.g_old_rec.insurance_number
,p_insurance_expiry_date_o
=> pqp_vre_shd.g_old_rec.insurance_expiry_date
,p_comments_o
=> pqp_vre_shd.g_old_rec.comments
,p_vre_attribute_category_o
=> pqp_vre_shd.g_old_rec.vre_attribute_category
,p_vre_attribute1_o
=> pqp_vre_shd.g_old_rec.vre_attribute1
,p_vre_attribute2_o
=> pqp_vre_shd.g_old_rec.vre_attribute2
,p_vre_attribute3_o
=> pqp_vre_shd.g_old_rec.vre_attribute3
,p_vre_attribute4_o
=> pqp_vre_shd.g_old_rec.vre_attribute4
,p_vre_attribute5_o
=> pqp_vre_shd.g_old_rec.vre_attribute5
,p_vre_attribute6_o
=> pqp_vre_shd.g_old_rec.vre_attribute6
,p_vre_attribute7_o
=> pqp_vre_shd.g_old_rec.vre_attribute7
,p_vre_attribute8_o
=> pqp_vre_shd.g_old_rec.vre_attribute8
,p_vre_attribute9_o
=> pqp_vre_shd.g_old_rec.vre_attribute9
,p_vre_attribute10_o
=> pqp_vre_shd.g_old_rec.vre_attribute10
,p_vre_attribute11_o
=> pqp_vre_shd.g_old_rec.vre_attribute11
,p_vre_attribute12_o
=> pqp_vre_shd.g_old_rec.vre_attribute12
,p_vre_attribute13_o
=> pqp_vre_shd.g_old_rec.vre_attribute13
,p_vre_attribute14_o
=> pqp_vre_shd.g_old_rec.vre_attribute14
,p_vre_attribute15_o
=> pqp_vre_shd.g_old_rec.vre_attribute15
,p_vre_attribute16_o
=> pqp_vre_shd.g_old_rec.vre_attribute16
,p_vre_attribute17_o
=> pqp_vre_shd.g_old_rec.vre_attribute17
,p_vre_attribute18_o
=> pqp_vre_shd.g_old_rec.vre_attribute18
,p_vre_attribute19_o
=> pqp_vre_shd.g_old_rec.vre_attribute19
,p_vre_attribute20_o
=> pqp_vre_shd.g_old_rec.vre_attribute20
,p_vre_information_category_o
=> pqp_vre_shd.g_old_rec.vre_information_category
,p_vre_information1_o
=> pqp_vre_shd.g_old_rec.vre_information1
,p_vre_information2_o
=> pqp_vre_shd.g_old_rec.vre_information2
,p_vre_information3_o
=> pqp_vre_shd.g_old_rec.vre_information3
,p_vre_information4_o
=> pqp_vre_shd.g_old_rec.vre_information4
,p_vre_information5_o
=> pqp_vre_shd.g_old_rec.vre_information5
,p_vre_information6_o
=> pqp_vre_shd.g_old_rec.vre_information6
,p_vre_information7_o
=> pqp_vre_shd.g_old_rec.vre_information7
,p_vre_information8_o
=> pqp_vre_shd.g_old_rec.vre_information8
,p_vre_information9_o
=> pqp_vre_shd.g_old_rec.vre_information9
,p_vre_information10_o
=> pqp_vre_shd.g_old_rec.vre_information10
,p_vre_information11_o
=> pqp_vre_shd.g_old_rec.vre_information11
,p_vre_information12_o
=> pqp_vre_shd.g_old_rec.vre_information12
,p_vre_information13_o
=> pqp_vre_shd.g_old_rec.vre_information13
,p_vre_information14_o
=> pqp_vre_shd.g_old_rec.vre_information14
,p_vre_information15_o
=> pqp_vre_shd.g_old_rec.vre_information15
,p_vre_information16_o
=> pqp_vre_shd.g_old_rec.vre_information16
,p_vre_information17_o
=> pqp_vre_shd.g_old_rec.vre_information17
,p_vre_information18_o
=> pqp_vre_shd.g_old_rec.vre_information18
,p_vre_information19_o
=> pqp_vre_shd.g_old_rec.vre_information19
,p_vre_information20_o
=> pqp_vre_shd.g_old_rec.vre_information20
);
END post_update;
pqp_vre_bus.update_validate
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pre_update
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
update_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
post_update
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);