The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE dt_delete_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_delete_dml';
IF (p_datetrack_mode = hr_api.g_delete_next_change) THEN
--
--
-- Delete the where the effective start date is equal
-- to the validation end date.
--
DELETE
FROM pqp_vehicle_repository_f
WHERE vehicle_repository_id = p_rec.vehicle_repository_id
AND effective_start_date = p_validation_start_date;
delete from pqp_vehicle_repository_f
where vehicle_repository_id = p_rec.vehicle_repository_id
and effective_start_date >= p_validation_start_date;
End dt_delete_dml;
PROCEDURE delete_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||'delete_dml';
pqp_vre_del.dt_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
);
END delete_dml;
PROCEDURE dt_pre_delete
(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_delete';
IF (p_datetrack_mode = hr_api.g_delete) THEN
p_rec.effective_end_date := p_validation_start_date - 1;
END dt_pre_delete;
PROCEDURE pre_delete
(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_delete';
select pve.veh_repos_extra_info_id
,pve.object_version_number
from pqp_veh_repos_extra_info pve
where pve.vehicle_repository_id = cp_vehicle_repository_id;
pqp_vre_del.dt_pre_delete
(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_veh_repos_extra_info_api.delete_veh_repos_extra_info
(p_veh_repos_extra_info_id => vri_rec.veh_repos_extra_info_id
,p_object_version_number => vri_rec.object_version_number
);
END pre_delete;
PROCEDURE post_delete
(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_delete';
pqp_vre_rkd.after_delete
(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_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_delete;
pqp_vre_bus.delete_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
);
pqp_vre_del.pre_delete
(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
);
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 => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pqp_vre_del.post_delete
(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
);