DBA Data[Home] [Help]

APPS.GHR_COMPLAINANT_APPEALS_API dependencies on HR_API

Line 253: ,p_complaint_id in number default hr_api.g_number

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

Line 254: ,p_appeal_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

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

Line 256: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

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

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

Line 258: ,p_docket_num in varchar2 default hr_api.g_varchar2

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

Line 259: ,p_org_notified_of_appeal 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

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

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

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

Line 263: ,p_agcy_recvd_appellant_brief 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

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

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

Line 266: ,p_org_forwd_brief_to_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

Line 267: ,p_agency_brief_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
271: ,p_dec_forwd_to_org in date default hr_api.g_date

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

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

Line 270: ,p_decision in varchar2 default hr_api.g_varchar2

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

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

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

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

Line 274: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

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

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

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

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

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

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

Line 280: ,p_rfr_decision 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
284: );

Line 281: ,p_rfr_decision_date 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: );
285: --

Line 282: ,p_agency_recvd_rfr_dec 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: --
286: -- ----------------------------------------------------------------------------

Line 283: ,p_rfr_decision_forwd_to_org 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: -- ----------------------------------------------------------------------------
287: -- |------------------------< delete_complainant_appeal >---------------------|