The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in pay_aif_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from pay_action_information
where action_information_id = p_rec.action_information_id;
End delete_dml;
Procedure pre_delete(p_rec in pay_aif_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in pay_aif_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
pay_aif_rkd.after_delete
(p_action_information_id
=> p_rec.action_information_id
,p_action_context_id_o
=> pay_aif_shd.g_old_rec.action_context_id
,p_action_context_type_o
=> pay_aif_shd.g_old_rec.action_context_type
,p_tax_unit_id_o
=> pay_aif_shd.g_old_rec.tax_unit_id
,p_jurisdiction_code_o
=> pay_aif_shd.g_old_rec.jurisdiction_code
,p_source_id_o
=> pay_aif_shd.g_old_rec.source_id
,p_source_text_o
=> pay_aif_shd.g_old_rec.source_text
,p_tax_group_o
=> pay_aif_shd.g_old_rec.tax_group
,p_object_version_number_o
=> pay_aif_shd.g_old_rec.object_version_number
,p_effective_date_o
=> pay_aif_shd.g_old_rec.effective_date
,p_assignment_id_o
=> pay_aif_shd.g_old_rec.assignment_id
,p_action_information_categor_o
=> pay_aif_shd.g_old_rec.action_information_category
,p_action_information1_o
=> pay_aif_shd.g_old_rec.action_information1
,p_action_information2_o
=> pay_aif_shd.g_old_rec.action_information2
,p_action_information3_o
=> pay_aif_shd.g_old_rec.action_information3
,p_action_information4_o
=> pay_aif_shd.g_old_rec.action_information4
,p_action_information5_o
=> pay_aif_shd.g_old_rec.action_information5
,p_action_information6_o
=> pay_aif_shd.g_old_rec.action_information6
,p_action_information7_o
=> pay_aif_shd.g_old_rec.action_information7
,p_action_information8_o
=> pay_aif_shd.g_old_rec.action_information8
,p_action_information9_o
=> pay_aif_shd.g_old_rec.action_information9
,p_action_information10_o
=> pay_aif_shd.g_old_rec.action_information10
,p_action_information11_o
=> pay_aif_shd.g_old_rec.action_information11
,p_action_information12_o
=> pay_aif_shd.g_old_rec.action_information12
,p_action_information13_o
=> pay_aif_shd.g_old_rec.action_information13
,p_action_information14_o
=> pay_aif_shd.g_old_rec.action_information14
,p_action_information15_o
=> pay_aif_shd.g_old_rec.action_information15
,p_action_information16_o
=> pay_aif_shd.g_old_rec.action_information16
,p_action_information17_o
=> pay_aif_shd.g_old_rec.action_information17
,p_action_information18_o
=> pay_aif_shd.g_old_rec.action_information18
,p_action_information19_o
=> pay_aif_shd.g_old_rec.action_information19
,p_action_information20_o
=> pay_aif_shd.g_old_rec.action_information20
,p_action_information21_o
=> pay_aif_shd.g_old_rec.action_information21
,p_action_information22_o
=> pay_aif_shd.g_old_rec.action_information22
,p_action_information23_o
=> pay_aif_shd.g_old_rec.action_information23
,p_action_information24_o
=> pay_aif_shd.g_old_rec.action_information24
,p_action_information25_o
=> pay_aif_shd.g_old_rec.action_information25
,p_action_information26_o
=> pay_aif_shd.g_old_rec.action_information26
,p_action_information27_o
=> pay_aif_shd.g_old_rec.action_information27
,p_action_information28_o
=> pay_aif_shd.g_old_rec.action_information28
,p_action_information29_o
=> pay_aif_shd.g_old_rec.action_information29
,p_action_information30_o
=> pay_aif_shd.g_old_rec.action_information30
);
End post_delete;
pay_aif_bus.delete_validate(p_rec);
pay_aif_del.pre_delete(p_rec);
pay_aif_del.delete_dml(p_rec);
pay_aif_del.post_delete(p_rec);