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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;
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';