APPS.GHR_CCA_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ghr_cca_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ghr_cca_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ghr_cca_shd.constraint_error

Line 117: When hr_api.parent_integrity_violated Then

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

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

117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ghr_cca_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ghr_cca_shd.constraint_error

Line 122: When hr_api.unique_integrity_violated Then

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

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

122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ghr_cca_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;
130: End update_dml;

Line 290: when hr_api.cannot_find_prog_unit then

286: );
287: --
288: exception
289: --
290: when hr_api.cannot_find_prog_unit then
291: --
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'GHR_COMPL_APPEALS'
294: ,p_hook_type => 'AU');

Line 292: hr_api.cannot_find_prog_unit_error

288: exception
289: --
290: when hr_api.cannot_find_prog_unit then
291: --
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'GHR_COMPL_APPEALS'
294: ,p_hook_type => 'AU');
295: --
296: end;

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

351: -- p_rec plsql record structure
352: -- to see if a system default is being used. If a system default
353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.complaint_id = hr_api.g_number) then
356: p_rec.complaint_id :=
357: ghr_cca_shd.g_old_rec.complaint_id;
358: End If;
359: If (p_rec.appeal_date = hr_api.g_date) then

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

355: If (p_rec.complaint_id = hr_api.g_number) then
356: p_rec.complaint_id :=
357: ghr_cca_shd.g_old_rec.complaint_id;
358: End If;
359: If (p_rec.appeal_date = hr_api.g_date) then
360: p_rec.appeal_date :=
361: ghr_cca_shd.g_old_rec.appeal_date;
362: End If;
363: If (p_rec.appealed_to = hr_api.g_varchar2) then

Line 363: If (p_rec.appealed_to = hr_api.g_varchar2) then

359: If (p_rec.appeal_date = hr_api.g_date) then
360: p_rec.appeal_date :=
361: ghr_cca_shd.g_old_rec.appeal_date;
362: End If;
363: If (p_rec.appealed_to = hr_api.g_varchar2) then
364: p_rec.appealed_to :=
365: ghr_cca_shd.g_old_rec.appealed_to;
366: End If;
367: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then

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

363: If (p_rec.appealed_to = hr_api.g_varchar2) then
364: p_rec.appealed_to :=
365: ghr_cca_shd.g_old_rec.appealed_to;
366: End If;
367: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
368: p_rec.reason_for_appeal :=
369: ghr_cca_shd.g_old_rec.reason_for_appeal;
370: End If;
371: If (p_rec.source_decision_date = hr_api.g_date) then

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

367: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
368: p_rec.reason_for_appeal :=
369: ghr_cca_shd.g_old_rec.reason_for_appeal;
370: End If;
371: If (p_rec.source_decision_date = hr_api.g_date) then
372: p_rec.source_decision_date :=
373: ghr_cca_shd.g_old_rec.source_decision_date;
374: End If;
375: If (p_rec.docket_num = hr_api.g_varchar2) then

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

371: If (p_rec.source_decision_date = hr_api.g_date) then
372: p_rec.source_decision_date :=
373: ghr_cca_shd.g_old_rec.source_decision_date;
374: End If;
375: If (p_rec.docket_num = hr_api.g_varchar2) then
376: p_rec.docket_num :=
377: ghr_cca_shd.g_old_rec.docket_num;
378: End If;
379: If (p_rec.org_notified_of_appeal = hr_api.g_date) then

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

375: If (p_rec.docket_num = hr_api.g_varchar2) then
376: p_rec.docket_num :=
377: ghr_cca_shd.g_old_rec.docket_num;
378: End If;
379: If (p_rec.org_notified_of_appeal = hr_api.g_date) then
380: p_rec.org_notified_of_appeal :=
381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;
382: End If;
383: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then

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

379: If (p_rec.org_notified_of_appeal = hr_api.g_date) then
380: p_rec.org_notified_of_appeal :=
381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;
382: End If;
383: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
384: p_rec.agency_recvd_req_for_files :=
385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;
386: End If;
387: If (p_rec.files_due = hr_api.g_date) then

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

383: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
384: p_rec.agency_recvd_req_for_files :=
385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;
386: End If;
387: If (p_rec.files_due = hr_api.g_date) then
388: p_rec.files_due :=
389: ghr_cca_shd.g_old_rec.files_due;
390: End If;
391: If (p_rec.files_forwd = hr_api.g_date) then

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

387: If (p_rec.files_due = hr_api.g_date) then
388: p_rec.files_due :=
389: ghr_cca_shd.g_old_rec.files_due;
390: End If;
391: If (p_rec.files_forwd = hr_api.g_date) then
392: p_rec.files_forwd :=
393: ghr_cca_shd.g_old_rec.files_forwd;
394: End If;
395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then

Line 395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then

391: If (p_rec.files_forwd = hr_api.g_date) then
392: p_rec.files_forwd :=
393: ghr_cca_shd.g_old_rec.files_forwd;
394: End If;
395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then
396: p_rec.agcy_recvd_appellant_brief :=
397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;
398: End If;
399: If (p_rec.agency_brief_due = hr_api.g_date) then

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

395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then
396: p_rec.agcy_recvd_appellant_brief :=
397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;
398: End If;
399: If (p_rec.agency_brief_due = hr_api.g_date) then
400: p_rec.agency_brief_due :=
401: ghr_cca_shd.g_old_rec.agency_brief_due;
402: End If;
403: If (p_rec.appellant_brief_forwd_org = hr_api.g_date) then

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

399: If (p_rec.agency_brief_due = hr_api.g_date) then
400: p_rec.agency_brief_due :=
401: ghr_cca_shd.g_old_rec.agency_brief_due;
402: End If;
403: If (p_rec.appellant_brief_forwd_org = hr_api.g_date) then
404: p_rec.appellant_brief_forwd_org :=
405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;
406: End If;
407: If (p_rec.org_forwd_brief_to_agency = hr_api.g_date) then

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

403: If (p_rec.appellant_brief_forwd_org = hr_api.g_date) then
404: p_rec.appellant_brief_forwd_org :=
405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;
406: End If;
407: If (p_rec.org_forwd_brief_to_agency = hr_api.g_date) then
408: p_rec.org_forwd_brief_to_agency :=
409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;
410: End If;
411: If (p_rec.agency_brief_forwd = hr_api.g_date) then

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

407: If (p_rec.org_forwd_brief_to_agency = hr_api.g_date) then
408: p_rec.org_forwd_brief_to_agency :=
409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;
410: End If;
411: If (p_rec.agency_brief_forwd = hr_api.g_date) then
412: p_rec.agency_brief_forwd :=
413: ghr_cca_shd.g_old_rec.agency_brief_forwd;
414: End If;
415: If (p_rec.decision_date = hr_api.g_date) then

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

411: If (p_rec.agency_brief_forwd = hr_api.g_date) then
412: p_rec.agency_brief_forwd :=
413: ghr_cca_shd.g_old_rec.agency_brief_forwd;
414: End If;
415: If (p_rec.decision_date = hr_api.g_date) then
416: p_rec.decision_date :=
417: ghr_cca_shd.g_old_rec.decision_date;
418: End If;
419: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then

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

415: If (p_rec.decision_date = hr_api.g_date) then
416: p_rec.decision_date :=
417: ghr_cca_shd.g_old_rec.decision_date;
418: End If;
419: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
420: p_rec.dec_recvd_by_agency :=
421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;
422: End If;
423: If (p_rec.decision = hr_api.g_varchar2) then

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

419: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
420: p_rec.dec_recvd_by_agency :=
421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;
422: End If;
423: If (p_rec.decision = hr_api.g_varchar2) then
424: p_rec.decision :=
425: ghr_cca_shd.g_old_rec.decision;
426: End If;
427: If (p_rec.dec_forwd_to_org = hr_api.g_date) then

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

423: If (p_rec.decision = hr_api.g_varchar2) then
424: p_rec.decision :=
425: ghr_cca_shd.g_old_rec.decision;
426: End If;
427: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
428: p_rec.dec_forwd_to_org :=
429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;
430: End If;
431: If (p_rec.agency_rfr_suspense = hr_api.g_date) then

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

427: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
428: p_rec.dec_forwd_to_org :=
429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;
430: End If;
431: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
432: p_rec.agency_rfr_suspense :=
433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;
434: End If;
435: If (p_rec.request_for_rfr = hr_api.g_date) then

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

431: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
432: p_rec.agency_rfr_suspense :=
433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;
434: End If;
435: If (p_rec.request_for_rfr = hr_api.g_date) then
436: p_rec.request_for_rfr :=
437: ghr_cca_shd.g_old_rec.request_for_rfr;
438: End If;
439: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then

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

435: If (p_rec.request_for_rfr = hr_api.g_date) then
436: p_rec.request_for_rfr :=
437: ghr_cca_shd.g_old_rec.request_for_rfr;
438: End If;
439: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
440: p_rec.rfr_docket_num :=
441: ghr_cca_shd.g_old_rec.rfr_docket_num;
442: End If;
443: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then

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

439: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
440: p_rec.rfr_docket_num :=
441: ghr_cca_shd.g_old_rec.rfr_docket_num;
442: End If;
443: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
444: p_rec.rfr_requested_by :=
445: ghr_cca_shd.g_old_rec.rfr_requested_by;
446: End If;
447: If (p_rec.agency_rfr_due = hr_api.g_date) then

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

443: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
444: p_rec.rfr_requested_by :=
445: ghr_cca_shd.g_old_rec.rfr_requested_by;
446: End If;
447: If (p_rec.agency_rfr_due = hr_api.g_date) then
448: p_rec.agency_rfr_due :=
449: ghr_cca_shd.g_old_rec.agency_rfr_due;
450: End If;
451: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then

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

447: If (p_rec.agency_rfr_due = hr_api.g_date) then
448: p_rec.agency_rfr_due :=
449: ghr_cca_shd.g_old_rec.agency_rfr_due;
450: End If;
451: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
452: p_rec.rfr_forwd_to_org :=
453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;
454: End If;
455: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then

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

451: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
452: p_rec.rfr_forwd_to_org :=
453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;
454: End If;
455: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
456: p_rec.org_forwd_rfr_to_agency :=
457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;
458: End If;
459: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then

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

455: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
456: p_rec.org_forwd_rfr_to_agency :=
457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;
458: End If;
459: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
460: p_rec.agency_forwd_rfr_ofo :=
461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;
462: End If;
463: If (p_rec.rfr_decision = hr_api.g_varchar2) then

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

459: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
460: p_rec.agency_forwd_rfr_ofo :=
461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;
462: End If;
463: If (p_rec.rfr_decision = hr_api.g_varchar2) then
464: p_rec.rfr_decision :=
465: ghr_cca_shd.g_old_rec.rfr_decision;
466: End If;
467: If (p_rec.rfr_decision_date = hr_api.g_date) then

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

463: If (p_rec.rfr_decision = hr_api.g_varchar2) then
464: p_rec.rfr_decision :=
465: ghr_cca_shd.g_old_rec.rfr_decision;
466: End If;
467: If (p_rec.rfr_decision_date = hr_api.g_date) then
468: p_rec.rfr_decision_date :=
469: ghr_cca_shd.g_old_rec.rfr_decision_date;
470: End If;
471: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then

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

467: If (p_rec.rfr_decision_date = hr_api.g_date) then
468: p_rec.rfr_decision_date :=
469: ghr_cca_shd.g_old_rec.rfr_decision_date;
470: End If;
471: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
472: p_rec.agency_recvd_rfr_dec :=
473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;
474: End If;
475: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then

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

471: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
472: p_rec.agency_recvd_rfr_dec :=
473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;
474: End If;
475: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
476: p_rec.rfr_decision_forwd_to_org :=
477: ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org;
478: End If;
479: --

Line 537: ,p_complaint_id in number default hr_api.g_number

533: Procedure upd
534: (p_effective_date in date
535: ,p_compl_appeal_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_complaint_id in number default hr_api.g_number
538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date

Line 538: ,p_appeal_date in date default hr_api.g_date

534: (p_effective_date in date
535: ,p_compl_appeal_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_complaint_id in number default hr_api.g_number
538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2

Line 539: ,p_appealed_to in varchar2 default hr_api.g_varchar2

535: ,p_compl_appeal_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_complaint_id in number default hr_api.g_number
538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date

Line 540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

536: ,p_object_version_number in out nocopy number
537: ,p_complaint_id in number default hr_api.g_number
538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date

Line 541: ,p_source_decision_date in date default hr_api.g_date

537: ,p_complaint_id in number default hr_api.g_number
538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date

Line 542: ,p_docket_num in varchar2 default hr_api.g_varchar2

538: ,p_appeal_date in date default hr_api.g_date
539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date

Line 543: ,p_org_notified_of_appeal in date default hr_api.g_date

539: ,p_appealed_to in varchar2 default hr_api.g_varchar2
540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date

Line 544: ,p_agency_recvd_req_for_files in date default hr_api.g_date

540: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date

Line 545: ,p_files_due in date default hr_api.g_date

541: ,p_source_decision_date in date default hr_api.g_date
542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date

Line 546: ,p_files_forwd in date default hr_api.g_date

542: ,p_docket_num in varchar2 default hr_api.g_varchar2
543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date

Line 547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date

543: ,p_org_notified_of_appeal in date default hr_api.g_date
544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date

Line 548: ,p_agency_brief_due in date default hr_api.g_date

544: ,p_agency_recvd_req_for_files in date default hr_api.g_date
545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date

Line 549: ,p_appellant_brief_forwd_org in date default hr_api.g_date

545: ,p_files_due in date default hr_api.g_date
546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date

Line 550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date

546: ,p_files_forwd in date default hr_api.g_date
547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2

Line 551: ,p_agency_brief_forwd in date default hr_api.g_date

547: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date

Line 552: ,p_decision_date in date default hr_api.g_date

548: ,p_agency_brief_due in date default hr_api.g_date
549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date

Line 553: ,p_dec_recvd_by_agency in date default hr_api.g_date

549: ,p_appellant_brief_forwd_org in date default hr_api.g_date
550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date

Line 554: ,p_decision in varchar2 default hr_api.g_varchar2

550: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

Line 555: ,p_dec_forwd_to_org in date default hr_api.g_date

551: ,p_agency_brief_forwd in date default hr_api.g_date
552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

Line 556: ,p_agency_rfr_suspense in date default hr_api.g_date

552: ,p_decision_date in date default hr_api.g_date
553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date

Line 557: ,p_request_for_rfr in date default hr_api.g_date

553: ,p_dec_recvd_by_agency in date default hr_api.g_date
554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date

Line 558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

554: ,p_decision in varchar2 default hr_api.g_varchar2
555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

Line 559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

555: ,p_dec_forwd_to_org in date default hr_api.g_date
556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

Line 560: ,p_agency_rfr_due in date default hr_api.g_date

556: ,p_agency_rfr_suspense in date default hr_api.g_date
557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

Line 561: ,p_rfr_forwd_to_org in date default hr_api.g_date

557: ,p_request_for_rfr in date default hr_api.g_date
558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date

Line 562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

558: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

Line 563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

559: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

Line 564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

560: ,p_agency_rfr_due in date default hr_api.g_date
561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
568: ) is

Line 565: ,p_rfr_decision_date in date default hr_api.g_date

561: ,p_rfr_forwd_to_org in date default hr_api.g_date
562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
568: ) is
569: --

Line 566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

562: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
568: ) is
569: --
570: l_rec ghr_cca_shd.g_rec_type;

Line 567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

563: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
564: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
565: ,p_rfr_decision_date in date default hr_api.g_date
566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
568: ) is
569: --
570: l_rec ghr_cca_shd.g_rec_type;
571: l_proc varchar2(72) := g_package||'upd';