APPS.GHR_AGENCY_APPEALS_API dependencies on HR_API

Line 236: ,p_complaint_id in number default hr_api.g_number

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

Line 237: ,p_appeal_date in date default hr_api.g_date

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

Line 238: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

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

Line 239: ,p_source_decision_date 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

Line 240: ,p_docket_num in varchar2 default hr_api.g_varchar2

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

Line 241: ,p_agency_recvd_req_for_files 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

Line 242: ,p_files_due 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

Line 243: ,p_files_forwd 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

Line 244: ,p_agency_brief_due 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

Line 245: ,p_agency_brief_forwd 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

Line 246: ,p_agency_recvd_appellant_brief 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
250: ,p_dec_forwd_to_org in date default hr_api.g_date

Line 247: ,p_decision_date 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

Line 248: ,p_dec_recvd_by_agency 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

Line 249: ,p_decision in varchar2 default hr_api.g_varchar2

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

Line 250: ,p_dec_forwd_to_org 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
254: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

Line 251: ,p_agency_rfr_suspense 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
255: ,p_agency_rfr_due in date default hr_api.g_date

Line 252: ,p_request_for_rfr 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

Line 253: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

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

Line 254: ,p_rfr_requested_by 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
258: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

Line 255: ,p_agency_rfr_due 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

Line 256: ,p_rfr_forwd_to_org 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
260: ,p_rfr_decision_date in date default hr_api.g_date

Line 257: ,p_org_forwd_rfr_to_agency 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

Line 258: ,p_agency_forwd_rfr_ofo 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

Line 259: ,p_rfr_decision 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
263: );

Line 260: ,p_rfr_decision_date 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: );
264: --

Line 261: ,p_agency_recvd_rfr_dec 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: --
265: -- ----------------------------------------------------------------------------

Line 262: ,p_rfr_decision_forwd_to_org 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: -- ----------------------------------------------------------------------------
266: -- |---------------------------< delete_agency_appeal >-----------------------|