213: (p_validate in boolean default false
214: ,p_effective_date in date
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
214: ,p_effective_date in date
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
215: ,p_compl_ca_header_id in number
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
217: ,p_complaint_id in number default hr_api.g_number
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
218: ,p_ca_source in varchar2 default hr_api.g_varchar2
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
219: ,p_last_compliance_report in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
220: ,p_compliance_closed in date default hr_api.g_date
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
221: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
222: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
223: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
224: ,p_pfe_received in date default hr_api.g_date
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
225: ,p_agency_brief_pfe_due in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
226: ,p_agency_brief_pfe_date in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
227: ,p_decision_pfe_date in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
228: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
229: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
230: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: );
231: ,p_agency_notified_noncom in date default hr_api.g_date
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: );
239: --
232: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: );
239: --
240: -- ----------------------------------------------------------------------------
233: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
234: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
235: ,p_dec_implemented in date default hr_api.g_date
236: ,p_complaint_reinstated in date default hr_api.g_date
237: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
238: );
239: --
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------------< delete_ca_header >-------------------------|