232: (p_validate in boolean default false
233: ,p_effective_date in date
234: ,p_compl_agency_appeal_id in number
235: ,p_object_version_number in out nocopy number
236: ,p_complaint_id in number default hr_api.g_number
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
233: ,p_effective_date in date
234: ,p_compl_agency_appeal_id in number
235: ,p_object_version_number in out nocopy number
236: ,p_complaint_id in number default hr_api.g_number
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
234: ,p_compl_agency_appeal_id in number
235: ,p_object_version_number in out nocopy number
236: ,p_complaint_id in number default hr_api.g_number
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
235: ,p_object_version_number in out nocopy number
236: ,p_complaint_id in number default hr_api.g_number
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
236: ,p_complaint_id in number default hr_api.g_number
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
237: ,p_appeal_date in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
239: ,p_source_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
240: ,p_docket_num in varchar2 default hr_api.g_varchar2
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
241: ,p_agency_recvd_req_for_files in date default hr_api.g_date
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
242: ,p_files_due in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
243: ,p_files_forwd in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
244: ,p_agency_brief_due in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
245: ,p_agency_brief_forwd in date default hr_api.g_date
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
246: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
247: ,p_decision_date in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
248: ,p_dec_recvd_by_agency in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
249: ,p_decision in varchar2 default hr_api.g_varchar2
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
250: ,p_dec_forwd_to_org in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
251: ,p_agency_rfr_suspense in date default hr_api.g_date
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
252: ,p_request_for_rfr in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
262: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
255: ,p_agency_rfr_due in date default hr_api.g_date
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
262: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
263: );
256: ,p_rfr_forwd_to_org in date default hr_api.g_date
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
262: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
263: );
264: --
257: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
262: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
263: );
264: --
265: -- ----------------------------------------------------------------------------
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
259: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
260: ,p_rfr_decision_date in date default hr_api.g_date
261: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
262: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
263: );
264: --
265: -- ----------------------------------------------------------------------------
266: -- |---------------------------< delete_agency_appeal >-----------------------|