APPS.GHR_AGENCY_APPEALS_API dependencies on HR_API

Line 98: when hr_api.cannot_find_prog_unit then

94: ,p_agency_recvd_rfr_dec => p_agency_recvd_rfr_dec
95: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_agency_appeal'
101: ,p_hook_type => 'BP'
102: );

Line 99: hr_api.cannot_find_prog_unit_error

95: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_agency_appeal'
101: ,p_hook_type => 'BP'
102: );
103: end;

Line 184: when hr_api.cannot_find_prog_unit then

180: ,p_compl_agency_appeal_id => p_compl_agency_appeal_id
181: ,p_object_version_number => l_object_version_number
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_agency_appeal'
187: ,p_hook_type => 'AP'
188: );

Line 185: hr_api.cannot_find_prog_unit_error

181: ,p_object_version_number => l_object_version_number
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_agency_appeal'
187: ,p_hook_type => 'AP'
188: );
189: end;

Line 197: raise hr_api.validate_enabled;

193: --
194: -- When in validation only mode raise the Validate_Enabled exception
195: --
196: if p_validate then
197: raise hr_api.validate_enabled;
198: end if;
199: --
200: -- Set all output arguments
201: --

Line 207: when hr_api.validate_enabled then

203: p_object_version_number := l_object_version_number;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 70);
206: exception
207: when hr_api.validate_enabled then
208: --
209: -- As the Validate_Enabled exception has been raised
210: -- we must rollback to the savepoint
211: --

Line 239: ,p_complaint_id in number default hr_api.g_number

235: (p_validate in boolean default false
236: ,p_effective_date in date
237: ,p_compl_agency_appeal_id in number
238: ,p_object_version_number in out nocopy number
239: ,p_complaint_id in number default hr_api.g_number
240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2

Line 240: ,p_appeal_date in date default hr_api.g_date

236: ,p_effective_date in date
237: ,p_compl_agency_appeal_id in number
238: ,p_object_version_number in out nocopy number
239: ,p_complaint_id in number default hr_api.g_number
240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date

Line 241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

237: ,p_compl_agency_appeal_id in number
238: ,p_object_version_number in out nocopy number
239: ,p_complaint_id in number default hr_api.g_number
240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date

Line 242: ,p_source_decision_date in date default hr_api.g_date

238: ,p_object_version_number in out nocopy number
239: ,p_complaint_id in number default hr_api.g_number
240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date

Line 243: ,p_docket_num in varchar2 default hr_api.g_varchar2

239: ,p_complaint_id in number default hr_api.g_number
240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date

Line 244: ,p_agency_recvd_req_for_files in date default hr_api.g_date

240: ,p_appeal_date in date default hr_api.g_date
241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date

Line 245: ,p_files_due in date default hr_api.g_date

241: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date

Line 246: ,p_files_forwd in date default hr_api.g_date

242: ,p_source_decision_date in date default hr_api.g_date
243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date

Line 247: ,p_agency_brief_due in date default hr_api.g_date

243: ,p_docket_num in varchar2 default hr_api.g_varchar2
244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date

Line 248: ,p_agency_brief_forwd in date default hr_api.g_date

244: ,p_agency_recvd_req_for_files in date default hr_api.g_date
245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2

Line 249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date

245: ,p_files_due in date default hr_api.g_date
246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date

Line 250: ,p_decision_date in date default hr_api.g_date

246: ,p_files_forwd in date default hr_api.g_date
247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date

Line 251: ,p_dec_recvd_by_agency in date default hr_api.g_date

247: ,p_agency_brief_due in date default hr_api.g_date
248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date

Line 252: ,p_decision in varchar2 default hr_api.g_varchar2

248: ,p_agency_brief_forwd in date default hr_api.g_date
249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

Line 253: ,p_dec_forwd_to_org in date default hr_api.g_date

249: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

Line 254: ,p_agency_rfr_suspense in date default hr_api.g_date

250: ,p_decision_date in date default hr_api.g_date
251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date

Line 255: ,p_request_for_rfr in date default hr_api.g_date

251: ,p_dec_recvd_by_agency in date default hr_api.g_date
252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date

Line 256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

252: ,p_decision in varchar2 default hr_api.g_varchar2
253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

Line 257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

253: ,p_dec_forwd_to_org in date default hr_api.g_date
254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

Line 258: ,p_agency_rfr_due in date default hr_api.g_date

254: ,p_agency_rfr_suspense in date default hr_api.g_date
255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

Line 259: ,p_rfr_forwd_to_org in date default hr_api.g_date

255: ,p_request_for_rfr in date default hr_api.g_date
256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date

Line 260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

256: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

Line 261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

257: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

Line 262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

258: ,p_agency_rfr_due in date default hr_api.g_date
259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
266: )

Line 263: ,p_rfr_decision_date in date default hr_api.g_date

259: ,p_rfr_forwd_to_org in date default hr_api.g_date
260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
266: )
267:

Line 264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

260: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
266: )
267:
268: is

Line 265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

261: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
262: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
263: ,p_rfr_decision_date in date default hr_api.g_date
264: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
265: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
266: )
267:
268: is
269: l_proc varchar2(72) := g_package||'update_agency_appeal';

Line 315: when hr_api.cannot_find_prog_unit then

311: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
312: ,p_object_version_number => p_object_version_number
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'update_agency_appeal'
318: ,p_hook_type => 'BP'
319: );

Line 316: hr_api.cannot_find_prog_unit_error

312: ,p_object_version_number => p_object_version_number
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'update_agency_appeal'
318: ,p_hook_type => 'BP'
319: );
320: end;

Line 399: when hr_api.cannot_find_prog_unit then

395: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
396: ,p_object_version_number => l_object_version_number
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'update_agency_appeal'
402: ,p_hook_type => 'AP'
403: );

Line 400: hr_api.cannot_find_prog_unit_error

396: ,p_object_version_number => l_object_version_number
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'update_agency_appeal'
402: ,p_hook_type => 'AP'
403: );
404: end;

Line 409: raise hr_api.validate_enabled;

405: --
406: -- When in validation only mode raise the Validate_Enabled exception
407: --
408: if p_validate then
409: raise hr_api.validate_enabled;
410: end if;
411: --
412: -- Set all output arguments
413: --

Line 418: when hr_api.validate_enabled then

414: p_object_version_number := l_object_version_number;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 70);
417: exception
418: when hr_api.validate_enabled then
419: --
420: -- As the Validate_Enabled exception has been raised
421: -- we must rollback to the savepoint
422: --

Line 474: when hr_api.cannot_find_prog_unit then

470: (p_compl_agency_appeal_id => p_compl_agency_appeal_id
471: ,p_object_version_number => p_object_version_number
472: );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'delete_agency_appeal'
477: ,p_hook_type => 'BP'
478: );

Line 475: hr_api.cannot_find_prog_unit_error

471: ,p_object_version_number => p_object_version_number
472: );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'delete_agency_appeal'
477: ,p_hook_type => 'BP'
478: );
479: end;

Line 500: when hr_api.cannot_find_prog_unit then

496: (p_compl_agency_appeal_id => p_compl_agency_appeal_id
497: ,p_object_version_number => p_object_version_number
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'delete_agency_appeal'
503: ,p_hook_type => 'AP'
504: );

Line 501: hr_api.cannot_find_prog_unit_error

497: ,p_object_version_number => p_object_version_number
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'delete_agency_appeal'
503: ,p_hook_type => 'AP'
504: );
505: end;

Line 510: raise hr_api.validate_enabled;

506: --
507: -- When in validation only mode raise the Validate_Enabled exception
508: --
509: if p_validate then
510: raise hr_api.validate_enabled;
511: end if;
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 11);
514: exception

Line 515: when hr_api.validate_enabled then

511: end if;
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 11);
514: exception
515: when hr_api.validate_enabled then
516: -- we must rollback to the savepoint
517: --
518: ROLLBACK TO delete_agency_appeal;
519: --