The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_ca_header
(p_validate in boolean default false
,p_effective_date in date
,p_compl_ca_header_id in number
,p_object_version_number in out nocopy number
,p_complaint_id in number default hr_api.g_number
,p_ca_source in varchar2 default hr_api.g_varchar2
,p_last_compliance_report in date default hr_api.g_date
,p_compliance_closed in date default hr_api.g_date
,p_compl_docket_number in varchar2 default hr_api.g_varchar2
,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
,p_pfe_received in date default hr_api.g_date
,p_agency_brief_pfe_due in date default hr_api.g_date
,p_agency_brief_pfe_date in date default hr_api.g_date
,p_decision_pfe_date in date default hr_api.g_date
,p_decision_pfe in varchar2 default hr_api.g_varchar2
,p_agency_recvd_pfe_decision in date default hr_api.g_date
,p_agency_pfe_brief_forwd in date default hr_api.g_date
,p_agency_notified_noncom in date default hr_api.g_date
,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
,p_eeo_off_req_data_from_org in date default hr_api.g_date
,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
,p_dec_implemented in date default hr_api.g_date
,p_complaint_reinstated in date default hr_api.g_date
,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
)
is
l_proc varchar2(72) := g_package||'update_ca_header';
savepoint update_ca_header;
ghr_complaints_ca_headers_bk_2.update_ca_header_b
(p_effective_date => trunc(p_effective_date)
,p_complaint_id => p_complaint_id
,p_ca_source => p_ca_source
,p_last_compliance_report => p_last_compliance_report
,p_compliance_closed => p_compliance_closed
,p_compl_docket_number => p_compl_docket_number
,p_appeal_docket_number => p_appeal_docket_number
,p_pfe_docket_number => p_pfe_docket_number
,p_pfe_received => p_pfe_received
,p_agency_brief_pfe_due => p_agency_brief_pfe_due
,p_agency_brief_pfe_date => p_agency_brief_pfe_date
,p_decision_pfe_date => p_decision_pfe_date
,p_decision_pfe => p_decision_pfe
,p_agency_recvd_pfe_decision => p_agency_recvd_pfe_decision
,p_agency_pfe_brief_forwd => p_agency_pfe_brief_forwd
,p_agency_notified_noncom => p_agency_notified_noncom
,p_comrep_noncom_req => p_comrep_noncom_req
,p_eeo_off_req_data_from_org => p_eeo_off_req_data_from_org
,p_org_forwd_data_to_eeo_off => p_org_forwd_data_to_eeo_off
,p_dec_implemented => p_dec_implemented
,p_complaint_reinstated => p_complaint_reinstated
,p_stage_complaint_reinstated => p_stage_complaint_reinstated
,p_compl_ca_header_id => p_compl_ca_header_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'update_ca_header'
,p_hook_type => 'BP'
);
ghr_complaints_ca_headers_bk_2.update_ca_header_a
(p_effective_date => trunc(p_effective_date)
,p_complaint_id => p_complaint_id
,p_ca_source => p_ca_source
,p_last_compliance_report => p_last_compliance_report
,p_compliance_closed => p_compliance_closed
,p_compl_docket_number => p_compl_docket_number
,p_appeal_docket_number => p_appeal_docket_number
,p_pfe_docket_number => p_pfe_docket_number
,p_pfe_received => p_pfe_received
,p_agency_brief_pfe_due => p_agency_brief_pfe_due
,p_agency_brief_pfe_date => p_agency_brief_pfe_date
,p_decision_pfe_date => p_decision_pfe_date
,p_decision_pfe => p_decision_pfe
,p_agency_recvd_pfe_decision => p_agency_recvd_pfe_decision
,p_agency_pfe_brief_forwd => p_agency_pfe_brief_forwd
,p_agency_notified_noncom => p_agency_notified_noncom
,p_comrep_noncom_req => p_comrep_noncom_req
,p_eeo_off_req_data_from_org => p_eeo_off_req_data_from_org
,p_org_forwd_data_to_eeo_off => p_org_forwd_data_to_eeo_off
,p_dec_implemented => p_dec_implemented
,p_complaint_reinstated => p_complaint_reinstated
,p_stage_complaint_reinstated => p_stage_complaint_reinstated
,p_compl_ca_header_id => p_compl_ca_header_id
,p_object_version_number => l_object_version_number
);
(p_module_name => 'update_ca_header'
,p_hook_type => 'AP'
);
rollback to update_ca_header;
rollback to update_ca_header;
end update_ca_header;
procedure delete_ca_header
(p_validate in boolean default false
,p_compl_ca_header_id in number
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_ca_header';
savepoint delete_ca_header;
ghr_complaints_ca_headers_bk_3.delete_ca_header_b
(p_compl_ca_header_id => p_compl_ca_header_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_ca_header'
,p_hook_type => 'BP'
);
ghr_complaints_ca_headers_bk_3.delete_ca_header_a
(p_compl_ca_header_id => p_compl_ca_header_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_ca_header'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_ca_header;
ROLLBACK TO delete_ca_header;
end delete_ca_header;