The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy ghr_caa_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into ghr_compl_agency_appeals
(compl_agency_appeal_id
,complaint_id
,appeal_date
,reason_for_appeal
,source_decision_date
,docket_num
,agency_recvd_req_for_files
,files_due
,files_forwd
,agency_brief_due
,agency_brief_forwd
,agency_recvd_appellant_brief
,decision_date
,dec_recvd_by_agency
,decision
,dec_forwd_to_org
,agency_rfr_suspense
,request_for_rfr
,rfr_docket_num
,rfr_requested_by
,agency_rfr_due
,rfr_forwd_to_org
,org_forwd_rfr_to_agency
,agency_forwd_rfr_ofo
,rfr_decision_date
,agency_recvd_rfr_dec
,rfr_decision_forwd_to_org
,rfr_decision
,object_version_number
)
Values
(p_rec.compl_agency_appeal_id
,p_rec.complaint_id
,p_rec.appeal_date
,p_rec.reason_for_appeal
,p_rec.source_decision_date
,p_rec.docket_num
,p_rec.agency_recvd_req_for_files
,p_rec.files_due
,p_rec.files_forwd
,p_rec.agency_brief_due
,p_rec.agency_brief_forwd
,p_rec.agency_recvd_appellant_brief
,p_rec.decision_date
,p_rec.dec_recvd_by_agency
,p_rec.decision
,p_rec.dec_forwd_to_org
,p_rec.agency_rfr_suspense
,p_rec.request_for_rfr
,p_rec.rfr_docket_num
,p_rec.rfr_requested_by
,p_rec.agency_rfr_due
,p_rec.rfr_forwd_to_org
,p_rec.org_forwd_rfr_to_agency
,p_rec.agency_forwd_rfr_ofo
,p_rec.rfr_decision_date
,p_rec.agency_recvd_rfr_dec
,p_rec.rfr_decision_forwd_to_org
,p_rec.rfr_decision
,p_rec.object_version_number
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy ghr_caa_shd.g_rec_type
) is
--
Cursor C_Sel1 is select ghr_compl_agency_appeals_s.nextval from sys.dual;
Select null
from ghr_compl_agency_appeals
where compl_agency_appeal_id =
ghr_caa_ins.g_compl_agency_appeal_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in ghr_caa_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
ghr_caa_rki.after_insert
(p_effective_date => p_effective_date
,p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
,p_complaint_id => p_rec.complaint_id
,p_appeal_date => p_rec.appeal_date
,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_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_agency_brief_due => p_rec.agency_brief_due
,p_agency_brief_forwd => p_rec.agency_brief_forwd
,p_agency_recvd_appellant_brief => p_rec.agency_recvd_appellant_brief
,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_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_rfr_decision => p_rec.rfr_decision
,p_object_version_number => p_rec.object_version_number
);
End post_insert;
ghr_caa_bus.insert_validate
(p_effective_date
,p_rec
);
ghr_caa_ins.pre_insert(p_rec);
ghr_caa_ins.insert_dml(p_rec);
ghr_caa_ins.post_insert
(p_effective_date
,p_rec
);