The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy ghr_cca_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ghr_compl_appeals
set
compl_appeal_id = p_rec.compl_appeal_id
,complaint_id = p_rec.complaint_id
,appeal_date = p_rec.appeal_date
,appealed_to = p_rec.appealed_to
,reason_for_appeal = p_rec.reason_for_appeal
,source_decision_date = p_rec.source_decision_date
,docket_num = p_rec.docket_num
,org_notified_of_appeal = p_rec.org_notified_of_appeal
,agency_recvd_req_for_files = p_rec.agency_recvd_req_for_files
,files_due = p_rec.files_due
,files_forwd = p_rec.files_forwd
,agcy_recvd_appellant_brief = p_rec.agcy_recvd_appellant_brief
,agency_brief_due = p_rec.agency_brief_due
,appellant_brief_forwd_org = p_rec.appellant_brief_forwd_org
,org_forwd_brief_to_agency = p_rec.org_forwd_brief_to_agency
,agency_brief_forwd = p_rec.agency_brief_forwd
,decision_date = p_rec.decision_date
,dec_recvd_by_agency = p_rec.dec_recvd_by_agency
,decision = p_rec.decision
,dec_forwd_to_org = p_rec.dec_forwd_to_org
,agency_rfr_suspense = p_rec.agency_rfr_suspense
,request_for_rfr = p_rec.request_for_rfr
,rfr_docket_num = p_rec.rfr_docket_num
,rfr_requested_by = p_rec.rfr_requested_by
,agency_rfr_due = p_rec.agency_rfr_due
,rfr_forwd_to_org = p_rec.rfr_forwd_to_org
,org_forwd_rfr_to_agency = p_rec.org_forwd_rfr_to_agency
,agency_forwd_rfr_ofo = p_rec.agency_forwd_rfr_ofo
,rfr_decision = p_rec.rfr_decision
,rfr_decision_date = p_rec.rfr_decision_date
,agency_recvd_rfr_dec = p_rec.agency_recvd_rfr_dec
,rfr_decision_forwd_to_org = p_rec.rfr_decision_forwd_to_org
,object_version_number = p_rec.object_version_number
where compl_appeal_id = p_rec.compl_appeal_id;
End update_dml;
Procedure pre_update
(p_rec in ghr_cca_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in ghr_cca_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
ghr_cca_rku.after_update
(p_effective_date => p_effective_date
,p_compl_appeal_id => p_rec.compl_appeal_id
,p_complaint_id => p_rec.complaint_id
,p_appeal_date => p_rec.appeal_date
,p_appealed_to => p_rec.appealed_to
,p_reason_for_appeal => p_rec.reason_for_appeal
,p_source_decision_date => p_rec.source_decision_date
,p_docket_num => p_rec.docket_num
,p_org_notified_of_appeal => p_rec.org_notified_of_appeal
,p_agency_recvd_req_for_files => p_rec.agency_recvd_req_for_files
,p_files_due => p_rec.files_due
,p_files_forwd => p_rec.files_forwd
,p_agcy_recvd_appellant_brief => p_rec.agcy_recvd_appellant_brief
,p_agency_brief_due => p_rec.agency_brief_due
,p_appellant_brief_forwd_org => p_rec.appellant_brief_forwd_org
,p_org_forwd_brief_to_agency => p_rec.org_forwd_brief_to_agency
,p_agency_brief_forwd => p_rec.agency_brief_forwd
,p_decision_date => p_rec.decision_date
,p_dec_recvd_by_agency => p_rec.dec_recvd_by_agency
,p_decision => p_rec.decision
,p_dec_forwd_to_org => p_rec.dec_forwd_to_org
,p_agency_rfr_suspense => p_rec.agency_rfr_suspense
,p_request_for_rfr => p_rec.request_for_rfr
,p_rfr_docket_num => p_rec.rfr_docket_num
,p_rfr_requested_by => p_rec.rfr_requested_by
,p_agency_rfr_due => p_rec.agency_rfr_due
,p_rfr_forwd_to_org => p_rec.rfr_forwd_to_org
,p_org_forwd_rfr_to_agency => p_rec.org_forwd_rfr_to_agency
,p_agency_forwd_rfr_ofo => p_rec.agency_forwd_rfr_ofo
,p_rfr_decision => p_rec.rfr_decision
,p_rfr_decision_date => p_rec.rfr_decision_date
,p_agency_recvd_rfr_dec => p_rec.agency_recvd_rfr_dec
,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
,p_object_version_number => p_rec.object_version_number
,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_update;
ghr_cca_bus.update_validate
(p_effective_date
,p_rec
);
ghr_cca_upd.pre_update(p_rec);
ghr_cca_upd.update_dml(p_rec);
ghr_cca_upd.post_update
(p_effective_date
,p_rec
);