The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in ghr_cca_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from ghr_compl_appeals
where compl_appeal_id = p_rec.compl_appeal_id;
End delete_dml;
Procedure pre_delete(p_rec in ghr_cca_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in ghr_cca_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
ghr_cca_rkd.after_delete
(p_compl_appeal_id => p_rec.compl_appeal_id
,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
,p_decision_o => ghr_cca_shd.g_old_rec.decision
,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
);
End post_delete;
ghr_cca_bus.delete_validate(p_rec);
ghr_cca_del.pre_delete(p_rec);
ghr_cca_del.delete_dml(p_rec);
ghr_cca_del.post_delete(p_rec);