249: (p_validate in boolean default false
250: ,p_effective_date in date
251: ,p_compl_appeal_id in number
252: ,p_object_version_number in out nocopy number
253: ,p_complaint_id in number default hr_api.g_number
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
250: ,p_effective_date in date
251: ,p_compl_appeal_id in number
252: ,p_object_version_number in out nocopy number
253: ,p_complaint_id in number default hr_api.g_number
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
251: ,p_compl_appeal_id in number
252: ,p_object_version_number in out nocopy number
253: ,p_complaint_id in number default hr_api.g_number
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
252: ,p_object_version_number in out nocopy number
253: ,p_complaint_id in number default hr_api.g_number
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
253: ,p_complaint_id in number default hr_api.g_number
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
254: ,p_appeal_date in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
255: ,p_appealed_to in varchar2 default hr_api.g_varchar2
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
257: ,p_source_decision_date in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
258: ,p_docket_num in varchar2 default hr_api.g_varchar2
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
259: ,p_org_notified_of_appeal in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
260: ,p_agency_recvd_req_for_files in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
261: ,p_files_due in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
262: ,p_files_forwd in date default hr_api.g_date
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
263: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
264: ,p_agency_brief_due in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
265: ,p_appellant_brief_forwd_org in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
266: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
267: ,p_agency_brief_forwd in date default hr_api.g_date
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
268: ,p_decision_date in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
269: ,p_dec_recvd_by_agency in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
270: ,p_decision in varchar2 default hr_api.g_varchar2
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
271: ,p_dec_forwd_to_org in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
272: ,p_agency_rfr_suspense in date default hr_api.g_date
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
273: ,p_request_for_rfr in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
275: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
283: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
276: ,p_agency_rfr_due in date default hr_api.g_date
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
283: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
284: );
277: ,p_rfr_forwd_to_org in date default hr_api.g_date
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
283: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
284: );
285: --
278: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
283: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
284: );
285: --
286: -- ----------------------------------------------------------------------------
279: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
280: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
281: ,p_rfr_decision_date in date default hr_api.g_date
282: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
283: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
284: );
285: --
286: -- ----------------------------------------------------------------------------
287: -- |------------------------< delete_complainant_appeal >---------------------|