The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml(p_rec in ota_nhs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from ota_notrng_histories
where nota_history_id = p_rec.nota_history_id;
End delete_dml;
Procedure pre_delete(p_rec in ota_nhs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in ota_nhs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
ota_nhs_rkd.after_delete
(p_nota_history_id
=> p_rec.nota_history_id
,p_person_id_o
=> ota_nhs_shd.g_old_rec.person_id
,p_contact_id_o
=> ota_nhs_shd.g_old_rec.contact_id
,p_trng_title_o
=> ota_nhs_shd.g_old_rec.trng_title
,p_provider_o
=> ota_nhs_shd.g_old_rec.provider
,p_type_o
=> ota_nhs_shd.g_old_rec.type
,p_centre_o
=> ota_nhs_shd.g_old_rec.centre
,p_completion_date_o
=> ota_nhs_shd.g_old_rec.completion_date
,p_award_o
=> ota_nhs_shd.g_old_rec.award
,p_rating_o
=> ota_nhs_shd.g_old_rec.rating
,p_duration_o
=> ota_nhs_shd.g_old_rec.duration
,p_duration_units_o
=> ota_nhs_shd.g_old_rec.duration_units
,p_activity_version_id_o
=> ota_nhs_shd.g_old_rec.activity_version_id
,p_status_o
=> ota_nhs_shd.g_old_rec.status
,p_verified_by_id_o
=> ota_nhs_shd.g_old_rec.verified_by_id
,p_nth_information_category_o
=> ota_nhs_shd.g_old_rec.nth_information_category
,p_nth_information1_o
=> ota_nhs_shd.g_old_rec.nth_information1
,p_nth_information2_o
=> ota_nhs_shd.g_old_rec.nth_information2
,p_nth_information3_o
=> ota_nhs_shd.g_old_rec.nth_information3
,p_nth_information4_o
=> ota_nhs_shd.g_old_rec.nth_information4
,p_nth_information5_o
=> ota_nhs_shd.g_old_rec.nth_information5
,p_nth_information6_o
=> ota_nhs_shd.g_old_rec.nth_information6
,p_nth_information7_o
=> ota_nhs_shd.g_old_rec.nth_information7
,p_nth_information8_o
=> ota_nhs_shd.g_old_rec.nth_information8
,p_nth_information9_o
=> ota_nhs_shd.g_old_rec.nth_information9
,p_nth_information10_o
=> ota_nhs_shd.g_old_rec.nth_information10
,p_nth_information11_o
=> ota_nhs_shd.g_old_rec.nth_information11
,p_nth_information12_o
=> ota_nhs_shd.g_old_rec.nth_information12
,p_nth_information13_o
=> ota_nhs_shd.g_old_rec.nth_information13
,p_nth_information15_o
=> ota_nhs_shd.g_old_rec.nth_information15
,p_nth_information16_o
=> ota_nhs_shd.g_old_rec.nth_information16
,p_nth_information17_o
=> ota_nhs_shd.g_old_rec.nth_information17
,p_nth_information18_o
=> ota_nhs_shd.g_old_rec.nth_information18
,p_nth_information19_o
=> ota_nhs_shd.g_old_rec.nth_information19
,p_nth_information20_o
=> ota_nhs_shd.g_old_rec.nth_information20
,p_org_id_o
=> ota_nhs_shd.g_old_rec.org_id
,p_object_version_number_o
=> ota_nhs_shd.g_old_rec.object_version_number
,p_business_group_id_o
=> ota_nhs_shd.g_old_rec.business_group_id
,p_nth_information14_o
=> ota_nhs_shd.g_old_rec.nth_information14
,p_customer_id_o
=> ota_nhs_shd.g_old_rec.customer_id
,p_organization_id_o
=> ota_nhs_shd.g_old_rec.organization_id
);
End post_delete;
ota_nhs_bus.delete_validate(p_rec);
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(p_rec);