APPS.GHR_CAA_UPD dependencies on HR_API

Line 108: When hr_api.check_integrity_violated Then

104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: ghr_caa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: ghr_caa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: ghr_caa_shd.constraint_error

Line 113: When hr_api.parent_integrity_violated Then

109: -- A check constraint has been violated
110: --
111: ghr_caa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: ghr_caa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: ghr_caa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: ghr_caa_shd.constraint_error

Line 118: When hr_api.unique_integrity_violated Then

114: -- Parent integrity has been violated
115: --
116: ghr_caa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: ghr_caa_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: ghr_caa_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;
126: End update_dml;

Line 278: when hr_api.cannot_find_prog_unit then

274: );
275: --
276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
282: ,p_hook_type => 'AU');

Line 280: hr_api.cannot_find_prog_unit_error

276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
282: ,p_hook_type => 'AU');
283: --
284: end;

Line 343: If (p_rec.complaint_id = hr_api.g_number) then

339: -- p_rec plsql record structure
340: -- to see if a system default is being used. If a system default
341: -- is being used then we must set to the 'current' argument value.
342: --
343: If (p_rec.complaint_id = hr_api.g_number) then
344: p_rec.complaint_id :=
345: ghr_caa_shd.g_old_rec.complaint_id;
346: End If;
347: If (p_rec.appeal_date = hr_api.g_date) then

Line 347: If (p_rec.appeal_date = hr_api.g_date) then

343: If (p_rec.complaint_id = hr_api.g_number) then
344: p_rec.complaint_id :=
345: ghr_caa_shd.g_old_rec.complaint_id;
346: End If;
347: If (p_rec.appeal_date = hr_api.g_date) then
348: p_rec.appeal_date :=
349: ghr_caa_shd.g_old_rec.appeal_date;
350: End If;
351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then

Line 351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then

347: If (p_rec.appeal_date = hr_api.g_date) then
348: p_rec.appeal_date :=
349: ghr_caa_shd.g_old_rec.appeal_date;
350: End If;
351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
352: p_rec.reason_for_appeal :=
353: ghr_caa_shd.g_old_rec.reason_for_appeal;
354: End If;
355: If (p_rec.source_decision_date = hr_api.g_date) then

Line 355: If (p_rec.source_decision_date = hr_api.g_date) then

351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
352: p_rec.reason_for_appeal :=
353: ghr_caa_shd.g_old_rec.reason_for_appeal;
354: End If;
355: If (p_rec.source_decision_date = hr_api.g_date) then
356: p_rec.source_decision_date :=
357: ghr_caa_shd.g_old_rec.source_decision_date;
358: End If;
359: If (p_rec.docket_num = hr_api.g_varchar2) then

Line 359: If (p_rec.docket_num = hr_api.g_varchar2) then

355: If (p_rec.source_decision_date = hr_api.g_date) then
356: p_rec.source_decision_date :=
357: ghr_caa_shd.g_old_rec.source_decision_date;
358: End If;
359: If (p_rec.docket_num = hr_api.g_varchar2) then
360: p_rec.docket_num :=
361: ghr_caa_shd.g_old_rec.docket_num;
362: End If;
363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then

Line 363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then

359: If (p_rec.docket_num = hr_api.g_varchar2) then
360: p_rec.docket_num :=
361: ghr_caa_shd.g_old_rec.docket_num;
362: End If;
363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
364: p_rec.agency_recvd_req_for_files :=
365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;
366: End If;
367: If (p_rec.files_due = hr_api.g_date) then

Line 367: If (p_rec.files_due = hr_api.g_date) then

363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
364: p_rec.agency_recvd_req_for_files :=
365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;
366: End If;
367: If (p_rec.files_due = hr_api.g_date) then
368: p_rec.files_due :=
369: ghr_caa_shd.g_old_rec.files_due;
370: End If;
371: If (p_rec.files_forwd = hr_api.g_date) then

Line 371: If (p_rec.files_forwd = hr_api.g_date) then

367: If (p_rec.files_due = hr_api.g_date) then
368: p_rec.files_due :=
369: ghr_caa_shd.g_old_rec.files_due;
370: End If;
371: If (p_rec.files_forwd = hr_api.g_date) then
372: p_rec.files_forwd :=
373: ghr_caa_shd.g_old_rec.files_forwd;
374: End If;
375: If (p_rec.agency_brief_due = hr_api.g_date) then

Line 375: If (p_rec.agency_brief_due = hr_api.g_date) then

371: If (p_rec.files_forwd = hr_api.g_date) then
372: p_rec.files_forwd :=
373: ghr_caa_shd.g_old_rec.files_forwd;
374: End If;
375: If (p_rec.agency_brief_due = hr_api.g_date) then
376: p_rec.agency_brief_due :=
377: ghr_caa_shd.g_old_rec.agency_brief_due;
378: End If;
379: If (p_rec.agency_brief_forwd = hr_api.g_date) then

Line 379: If (p_rec.agency_brief_forwd = hr_api.g_date) then

375: If (p_rec.agency_brief_due = hr_api.g_date) then
376: p_rec.agency_brief_due :=
377: ghr_caa_shd.g_old_rec.agency_brief_due;
378: End If;
379: If (p_rec.agency_brief_forwd = hr_api.g_date) then
380: p_rec.agency_brief_forwd :=
381: ghr_caa_shd.g_old_rec.agency_brief_forwd;
382: End If;
383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then

Line 383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then

379: If (p_rec.agency_brief_forwd = hr_api.g_date) then
380: p_rec.agency_brief_forwd :=
381: ghr_caa_shd.g_old_rec.agency_brief_forwd;
382: End If;
383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then
384: p_rec.agency_recvd_appellant_brief :=
385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;
386: End If;
387: If (p_rec.decision_date = hr_api.g_date) then

Line 387: If (p_rec.decision_date = hr_api.g_date) then

383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then
384: p_rec.agency_recvd_appellant_brief :=
385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;
386: End If;
387: If (p_rec.decision_date = hr_api.g_date) then
388: p_rec.decision_date :=
389: ghr_caa_shd.g_old_rec.decision_date;
390: End If;
391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then

Line 391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then

387: If (p_rec.decision_date = hr_api.g_date) then
388: p_rec.decision_date :=
389: ghr_caa_shd.g_old_rec.decision_date;
390: End If;
391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
392: p_rec.dec_recvd_by_agency :=
393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;
394: End If;
395: If (p_rec.decision = hr_api.g_varchar2) then

Line 395: If (p_rec.decision = hr_api.g_varchar2) then

391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
392: p_rec.dec_recvd_by_agency :=
393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;
394: End If;
395: If (p_rec.decision = hr_api.g_varchar2) then
396: p_rec.decision :=
397: ghr_caa_shd.g_old_rec.decision;
398: End If;
399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then

Line 399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then

395: If (p_rec.decision = hr_api.g_varchar2) then
396: p_rec.decision :=
397: ghr_caa_shd.g_old_rec.decision;
398: End If;
399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
400: p_rec.dec_forwd_to_org :=
401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;
402: End If;
403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then

Line 403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then

399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
400: p_rec.dec_forwd_to_org :=
401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;
402: End If;
403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
404: p_rec.agency_rfr_suspense :=
405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;
406: End If;
407: If (p_rec.request_for_rfr = hr_api.g_date) then

Line 407: If (p_rec.request_for_rfr = hr_api.g_date) then

403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
404: p_rec.agency_rfr_suspense :=
405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;
406: End If;
407: If (p_rec.request_for_rfr = hr_api.g_date) then
408: p_rec.request_for_rfr :=
409: ghr_caa_shd.g_old_rec.request_for_rfr;
410: End If;
411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then

Line 411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then

407: If (p_rec.request_for_rfr = hr_api.g_date) then
408: p_rec.request_for_rfr :=
409: ghr_caa_shd.g_old_rec.request_for_rfr;
410: End If;
411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
412: p_rec.rfr_docket_num :=
413: ghr_caa_shd.g_old_rec.rfr_docket_num;
414: End If;
415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then

Line 415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then

411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
412: p_rec.rfr_docket_num :=
413: ghr_caa_shd.g_old_rec.rfr_docket_num;
414: End If;
415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
416: p_rec.rfr_requested_by :=
417: ghr_caa_shd.g_old_rec.rfr_requested_by;
418: End If;
419: If (p_rec.agency_rfr_due = hr_api.g_date) then

Line 419: If (p_rec.agency_rfr_due = hr_api.g_date) then

415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
416: p_rec.rfr_requested_by :=
417: ghr_caa_shd.g_old_rec.rfr_requested_by;
418: End If;
419: If (p_rec.agency_rfr_due = hr_api.g_date) then
420: p_rec.agency_rfr_due :=
421: ghr_caa_shd.g_old_rec.agency_rfr_due;
422: End If;
423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then

Line 423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then

419: If (p_rec.agency_rfr_due = hr_api.g_date) then
420: p_rec.agency_rfr_due :=
421: ghr_caa_shd.g_old_rec.agency_rfr_due;
422: End If;
423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
424: p_rec.rfr_forwd_to_org :=
425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;
426: End If;
427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then

Line 427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then

423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
424: p_rec.rfr_forwd_to_org :=
425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;
426: End If;
427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
428: p_rec.org_forwd_rfr_to_agency :=
429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;
430: End If;
431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then

Line 431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then

427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
428: p_rec.org_forwd_rfr_to_agency :=
429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;
430: End If;
431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
432: p_rec.agency_forwd_rfr_ofo :=
433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;
434: End If;
435: If (p_rec.rfr_decision_date = hr_api.g_date) then

Line 435: If (p_rec.rfr_decision_date = hr_api.g_date) then

431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
432: p_rec.agency_forwd_rfr_ofo :=
433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;
434: End If;
435: If (p_rec.rfr_decision_date = hr_api.g_date) then
436: p_rec.rfr_decision_date :=
437: ghr_caa_shd.g_old_rec.rfr_decision_date;
438: End If;
439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then

Line 439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then

435: If (p_rec.rfr_decision_date = hr_api.g_date) then
436: p_rec.rfr_decision_date :=
437: ghr_caa_shd.g_old_rec.rfr_decision_date;
438: End If;
439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
440: p_rec.agency_recvd_rfr_dec :=
441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;
442: End If;
443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then

Line 443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then

439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
440: p_rec.agency_recvd_rfr_dec :=
441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;
442: End If;
443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
444: p_rec.rfr_decision_forwd_to_org :=
445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;
446: End If;
447: If (p_rec.rfr_decision = hr_api.g_varchar2) then

Line 447: If (p_rec.rfr_decision = hr_api.g_varchar2) then

443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
444: p_rec.rfr_decision_forwd_to_org :=
445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;
446: End If;
447: If (p_rec.rfr_decision = hr_api.g_varchar2) then
448: p_rec.rfr_decision :=
449: ghr_caa_shd.g_old_rec.rfr_decision;
450: End If;
451: --

Line 509: ,p_complaint_id in number default hr_api.g_number

505: Procedure upd
506: (p_effective_date in date
507: ,p_compl_agency_appeal_id in number
508: ,p_object_version_number in out nocopy number
509: ,p_complaint_id in number default hr_api.g_number
510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2

Line 510: ,p_appeal_date in date default hr_api.g_date

506: (p_effective_date in date
507: ,p_compl_agency_appeal_id in number
508: ,p_object_version_number in out nocopy number
509: ,p_complaint_id in number default hr_api.g_number
510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date

Line 511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

507: ,p_compl_agency_appeal_id in number
508: ,p_object_version_number in out nocopy number
509: ,p_complaint_id in number default hr_api.g_number
510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date

Line 512: ,p_source_decision_date in date default hr_api.g_date

508: ,p_object_version_number in out nocopy number
509: ,p_complaint_id in number default hr_api.g_number
510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date

Line 513: ,p_docket_num in varchar2 default hr_api.g_varchar2

509: ,p_complaint_id in number default hr_api.g_number
510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date

Line 514: ,p_agency_recvd_req_for_files in date default hr_api.g_date

510: ,p_appeal_date in date default hr_api.g_date
511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date

Line 515: ,p_files_due in date default hr_api.g_date

511: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date

Line 516: ,p_files_forwd in date default hr_api.g_date

512: ,p_source_decision_date in date default hr_api.g_date
513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date

Line 517: ,p_agency_brief_due in date default hr_api.g_date

513: ,p_docket_num in varchar2 default hr_api.g_varchar2
514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date

Line 518: ,p_agency_brief_forwd in date default hr_api.g_date

514: ,p_agency_recvd_req_for_files in date default hr_api.g_date
515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2

Line 519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date

515: ,p_files_due in date default hr_api.g_date
516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date

Line 520: ,p_decision_date in date default hr_api.g_date

516: ,p_files_forwd in date default hr_api.g_date
517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date

Line 521: ,p_dec_recvd_by_agency in date default hr_api.g_date

517: ,p_agency_brief_due in date default hr_api.g_date
518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date

Line 522: ,p_decision in varchar2 default hr_api.g_varchar2

518: ,p_agency_brief_forwd in date default hr_api.g_date
519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

Line 523: ,p_dec_forwd_to_org in date default hr_api.g_date

519: ,p_agency_recvd_appellant_brief in date default hr_api.g_date
520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

Line 524: ,p_agency_rfr_suspense in date default hr_api.g_date

520: ,p_decision_date in date default hr_api.g_date
521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date

Line 525: ,p_request_for_rfr in date default hr_api.g_date

521: ,p_dec_recvd_by_agency in date default hr_api.g_date
522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date

Line 526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

522: ,p_decision in varchar2 default hr_api.g_varchar2
523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

Line 527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

523: ,p_dec_forwd_to_org in date default hr_api.g_date
524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

Line 528: ,p_agency_rfr_due in date default hr_api.g_date

524: ,p_agency_rfr_suspense in date default hr_api.g_date
525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date

Line 529: ,p_rfr_forwd_to_org in date default hr_api.g_date

525: ,p_request_for_rfr in date default hr_api.g_date
526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

Line 530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

526: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

Line 531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

527: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

Line 532: ,p_rfr_decision_date in date default hr_api.g_date

528: ,p_agency_rfr_due in date default hr_api.g_date
529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
536: ) is

Line 533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

529: ,p_rfr_forwd_to_org in date default hr_api.g_date
530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
536: ) is
537: --

Line 534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

530: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
536: ) is
537: --
538: l_rec ghr_caa_shd.g_rec_type;

Line 535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

531: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
532: ,p_rfr_decision_date in date default hr_api.g_date
533: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
536: ) is
537: --
538: l_rec ghr_caa_shd.g_rec_type;
539: l_proc varchar2(72) := g_package||'upd';