The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from psp_eff_report_approvals
where effort_report_approval_id = p_rec.effort_report_approval_id;
End delete_dml;
Procedure pre_delete(p_rec in psp_era_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in psp_era_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
psp_era_rkd.after_delete
(p_effort_report_approval_id
=> p_rec.effort_report_approval_id
,p_effort_report_detail_id_o
=> psp_era_shd.g_old_rec.effort_report_detail_id
,p_wf_role_name_o
=> psp_era_shd.g_old_rec.wf_role_name
,p_wf_orig_system_id_o
=> psp_era_shd.g_old_rec.wf_orig_system_id
,p_wf_orig_system_o
=> psp_era_shd.g_old_rec.wf_orig_system
,p_approver_order_num_o
=> psp_era_shd.g_old_rec.approver_order_num
,p_approval_status_o
=> psp_era_shd.g_old_rec.approval_status
,p_response_date_o
=> psp_era_shd.g_old_rec.response_date
,p_actual_cost_share_o
=> psp_era_shd.g_old_rec.actual_cost_share
,p_overwritten_effort_percent_o
=> psp_era_shd.g_old_rec.overwritten_effort_percent
,p_wf_item_key_o
=> psp_era_shd.g_old_rec.wf_item_key
,p_comments_o
=> psp_era_shd.g_old_rec.comments
,p_pera_information_category_o
=> psp_era_shd.g_old_rec.pera_information_category
,p_pera_information1_o
=> psp_era_shd.g_old_rec.pera_information1
,p_pera_information2_o
=> psp_era_shd.g_old_rec.pera_information2
,p_pera_information3_o
=> psp_era_shd.g_old_rec.pera_information3
,p_pera_information4_o
=> psp_era_shd.g_old_rec.pera_information4
,p_pera_information5_o
=> psp_era_shd.g_old_rec.pera_information5
,p_pera_information6_o
=> psp_era_shd.g_old_rec.pera_information6
,p_pera_information7_o
=> psp_era_shd.g_old_rec.pera_information7
,p_pera_information8_o
=> psp_era_shd.g_old_rec.pera_information8
,p_pera_information9_o
=> psp_era_shd.g_old_rec.pera_information9
,p_pera_information10_o
=> psp_era_shd.g_old_rec.pera_information10
,p_pera_information11_o
=> psp_era_shd.g_old_rec.pera_information11
,p_pera_information12_o
=> psp_era_shd.g_old_rec.pera_information12
,p_pera_information13_o
=> psp_era_shd.g_old_rec.pera_information13
,p_pera_information14_o
=> psp_era_shd.g_old_rec.pera_information14
,p_pera_information15_o
=> psp_era_shd.g_old_rec.pera_information15
,p_pera_information16_o
=> psp_era_shd.g_old_rec.pera_information16
,p_pera_information17_o
=> psp_era_shd.g_old_rec.pera_information17
,p_pera_information18_o
=> psp_era_shd.g_old_rec.pera_information18
,p_pera_information19_o
=> psp_era_shd.g_old_rec.pera_information19
,p_pera_information20_o
=> psp_era_shd.g_old_rec.pera_information20
,p_wf_role_display_name_o
=> psp_era_shd.g_old_rec.wf_role_display_name
,p_object_version_number_o
=> psp_era_shd.g_old_rec.object_version_number
,p_notification_id_o
=> psp_era_shd.g_old_rec.notification_id
,p_eff_information_category_o
=> psp_era_shd.g_old_rec.eff_information_category
,p_eff_information1_o
=> psp_era_shd.g_old_rec.eff_information1
,p_eff_information2_o
=> psp_era_shd.g_old_rec.eff_information2
,p_eff_information3_o
=> psp_era_shd.g_old_rec.eff_information3
,p_eff_information4_o
=> psp_era_shd.g_old_rec.eff_information4
,p_eff_information5_o
=> psp_era_shd.g_old_rec.eff_information5
,p_eff_information6_o
=> psp_era_shd.g_old_rec.eff_information6
,p_eff_information7_o
=> psp_era_shd.g_old_rec.eff_information7
,p_eff_information8_o
=> psp_era_shd.g_old_rec.eff_information8
,p_eff_information9_o
=> psp_era_shd.g_old_rec.eff_information9
,p_eff_information10_o
=> psp_era_shd.g_old_rec.eff_information10
,p_eff_information11_o
=> psp_era_shd.g_old_rec.eff_information11
,p_eff_information12_o
=> psp_era_shd.g_old_rec.eff_information12
,p_eff_information13_o
=> psp_era_shd.g_old_rec.eff_information13
,p_eff_information14_o
=> psp_era_shd.g_old_rec.eff_information14
,p_eff_information15_o
=> psp_era_shd.g_old_rec.eff_information15
);
End post_delete;
psp_era_bus.delete_validate(p_rec);
psp_era_del.pre_delete(p_rec);
psp_era_del.delete_dml(p_rec);
psp_era_del.post_delete(p_rec);