APPS.GHR_CAH_UPD dependencies on HR_API

Line 102: When hr_api.check_integrity_violated Then

98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: --
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: --
105: ghr_cah_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: --
105: ghr_cah_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: --
110: ghr_cah_shd.constraint_error

Line 107: When hr_api.parent_integrity_violated Then

103: -- A check constraint has been violated
104: --
105: ghr_cah_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: --
110: ghr_cah_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: --
110: ghr_cah_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --
115: ghr_cah_shd.constraint_error

Line 112: When hr_api.unique_integrity_violated Then

108: -- Parent integrity has been violated
109: --
110: ghr_cah_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --
115: ghr_cah_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.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --
115: ghr_cah_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When Others Then
118: --
119: Raise;
120: End update_dml;

Line 260: when hr_api.cannot_find_prog_unit then

256: );
257: --
258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'GHR_COMPL_CA_HEADERS'
264: ,p_hook_type => 'AU');

Line 262: hr_api.cannot_find_prog_unit_error

258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'GHR_COMPL_CA_HEADERS'
264: ,p_hook_type => 'AU');
265: --
266: end;

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

321: -- p_rec plsql record structure
322: -- to see if a system default is being used. If a system default
323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.complaint_id = hr_api.g_number) then
326: p_rec.complaint_id :=
327: ghr_cah_shd.g_old_rec.complaint_id;
328: End If;
329: If (p_rec.ca_source = hr_api.g_varchar2) then

Line 329: If (p_rec.ca_source = hr_api.g_varchar2) then

325: If (p_rec.complaint_id = hr_api.g_number) then
326: p_rec.complaint_id :=
327: ghr_cah_shd.g_old_rec.complaint_id;
328: End If;
329: If (p_rec.ca_source = hr_api.g_varchar2) then
330: p_rec.ca_source :=
331: ghr_cah_shd.g_old_rec.ca_source;
332: End If;
333: If (p_rec.last_compliance_report = hr_api.g_date) then

Line 333: If (p_rec.last_compliance_report = hr_api.g_date) then

329: If (p_rec.ca_source = hr_api.g_varchar2) then
330: p_rec.ca_source :=
331: ghr_cah_shd.g_old_rec.ca_source;
332: End If;
333: If (p_rec.last_compliance_report = hr_api.g_date) then
334: p_rec.last_compliance_report :=
335: ghr_cah_shd.g_old_rec.last_compliance_report;
336: End If;
337: If (p_rec.compliance_closed = hr_api.g_date) then

Line 337: If (p_rec.compliance_closed = hr_api.g_date) then

333: If (p_rec.last_compliance_report = hr_api.g_date) then
334: p_rec.last_compliance_report :=
335: ghr_cah_shd.g_old_rec.last_compliance_report;
336: End If;
337: If (p_rec.compliance_closed = hr_api.g_date) then
338: p_rec.compliance_closed :=
339: ghr_cah_shd.g_old_rec.compliance_closed;
340: End If;
341: If (p_rec.compl_docket_number = hr_api.g_varchar2) then

Line 341: If (p_rec.compl_docket_number = hr_api.g_varchar2) then

337: If (p_rec.compliance_closed = hr_api.g_date) then
338: p_rec.compliance_closed :=
339: ghr_cah_shd.g_old_rec.compliance_closed;
340: End If;
341: If (p_rec.compl_docket_number = hr_api.g_varchar2) then
342: p_rec.compl_docket_number :=
343: ghr_cah_shd.g_old_rec.compl_docket_number;
344: End If;
345: If (p_rec.appeal_docket_number = hr_api.g_varchar2) then

Line 345: If (p_rec.appeal_docket_number = hr_api.g_varchar2) then

341: If (p_rec.compl_docket_number = hr_api.g_varchar2) then
342: p_rec.compl_docket_number :=
343: ghr_cah_shd.g_old_rec.compl_docket_number;
344: End If;
345: If (p_rec.appeal_docket_number = hr_api.g_varchar2) then
346: p_rec.appeal_docket_number :=
347: ghr_cah_shd.g_old_rec.appeal_docket_number;
348: End If;
349: If (p_rec.pfe_docket_number = hr_api.g_varchar2) then

Line 349: If (p_rec.pfe_docket_number = hr_api.g_varchar2) then

345: If (p_rec.appeal_docket_number = hr_api.g_varchar2) then
346: p_rec.appeal_docket_number :=
347: ghr_cah_shd.g_old_rec.appeal_docket_number;
348: End If;
349: If (p_rec.pfe_docket_number = hr_api.g_varchar2) then
350: p_rec.pfe_docket_number :=
351: ghr_cah_shd.g_old_rec.pfe_docket_number;
352: End If;
353: If (p_rec.pfe_received = hr_api.g_date) then

Line 353: If (p_rec.pfe_received = hr_api.g_date) then

349: If (p_rec.pfe_docket_number = hr_api.g_varchar2) then
350: p_rec.pfe_docket_number :=
351: ghr_cah_shd.g_old_rec.pfe_docket_number;
352: End If;
353: If (p_rec.pfe_received = hr_api.g_date) then
354: p_rec.pfe_received :=
355: ghr_cah_shd.g_old_rec.pfe_received;
356: End If;
357: If (p_rec.agency_brief_pfe_due = hr_api.g_date) then

Line 357: If (p_rec.agency_brief_pfe_due = hr_api.g_date) then

353: If (p_rec.pfe_received = hr_api.g_date) then
354: p_rec.pfe_received :=
355: ghr_cah_shd.g_old_rec.pfe_received;
356: End If;
357: If (p_rec.agency_brief_pfe_due = hr_api.g_date) then
358: p_rec.agency_brief_pfe_due :=
359: ghr_cah_shd.g_old_rec.agency_brief_pfe_due;
360: End If;
361: If (p_rec.agency_brief_pfe_date = hr_api.g_date) then

Line 361: If (p_rec.agency_brief_pfe_date = hr_api.g_date) then

357: If (p_rec.agency_brief_pfe_due = hr_api.g_date) then
358: p_rec.agency_brief_pfe_due :=
359: ghr_cah_shd.g_old_rec.agency_brief_pfe_due;
360: End If;
361: If (p_rec.agency_brief_pfe_date = hr_api.g_date) then
362: p_rec.agency_brief_pfe_date :=
363: ghr_cah_shd.g_old_rec.agency_brief_pfe_date;
364: End If;
365: If (p_rec.decision_pfe_date = hr_api.g_date) then

Line 365: If (p_rec.decision_pfe_date = hr_api.g_date) then

361: If (p_rec.agency_brief_pfe_date = hr_api.g_date) then
362: p_rec.agency_brief_pfe_date :=
363: ghr_cah_shd.g_old_rec.agency_brief_pfe_date;
364: End If;
365: If (p_rec.decision_pfe_date = hr_api.g_date) then
366: p_rec.decision_pfe_date :=
367: ghr_cah_shd.g_old_rec.decision_pfe_date;
368: End If;
369: If (p_rec.decision_pfe = hr_api.g_varchar2) then

Line 369: If (p_rec.decision_pfe = hr_api.g_varchar2) then

365: If (p_rec.decision_pfe_date = hr_api.g_date) then
366: p_rec.decision_pfe_date :=
367: ghr_cah_shd.g_old_rec.decision_pfe_date;
368: End If;
369: If (p_rec.decision_pfe = hr_api.g_varchar2) then
370: p_rec.decision_pfe :=
371: ghr_cah_shd.g_old_rec.decision_pfe;
372: End If;
373: If (p_rec.agency_recvd_pfe_decision = hr_api.g_date) then

Line 373: If (p_rec.agency_recvd_pfe_decision = hr_api.g_date) then

369: If (p_rec.decision_pfe = hr_api.g_varchar2) then
370: p_rec.decision_pfe :=
371: ghr_cah_shd.g_old_rec.decision_pfe;
372: End If;
373: If (p_rec.agency_recvd_pfe_decision = hr_api.g_date) then
374: p_rec.agency_recvd_pfe_decision :=
375: ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision;
376: End If;
377: If (p_rec.agency_pfe_brief_forwd = hr_api.g_date) then

Line 377: If (p_rec.agency_pfe_brief_forwd = hr_api.g_date) then

373: If (p_rec.agency_recvd_pfe_decision = hr_api.g_date) then
374: p_rec.agency_recvd_pfe_decision :=
375: ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision;
376: End If;
377: If (p_rec.agency_pfe_brief_forwd = hr_api.g_date) then
378: p_rec.agency_pfe_brief_forwd :=
379: ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd;
380: End If;
381: If (p_rec.agency_notified_noncom = hr_api.g_date) then

Line 381: If (p_rec.agency_notified_noncom = hr_api.g_date) then

377: If (p_rec.agency_pfe_brief_forwd = hr_api.g_date) then
378: p_rec.agency_pfe_brief_forwd :=
379: ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd;
380: End If;
381: If (p_rec.agency_notified_noncom = hr_api.g_date) then
382: p_rec.agency_notified_noncom :=
383: ghr_cah_shd.g_old_rec.agency_notified_noncom;
384: End If;
385: If (p_rec.comrep_noncom_req = hr_api.g_varchar2) then

Line 385: If (p_rec.comrep_noncom_req = hr_api.g_varchar2) then

381: If (p_rec.agency_notified_noncom = hr_api.g_date) then
382: p_rec.agency_notified_noncom :=
383: ghr_cah_shd.g_old_rec.agency_notified_noncom;
384: End If;
385: If (p_rec.comrep_noncom_req = hr_api.g_varchar2) then
386: p_rec.comrep_noncom_req :=
387: ghr_cah_shd.g_old_rec.comrep_noncom_req;
388: End If;
389: If (p_rec.eeo_off_req_data_from_org = hr_api.g_date) then

Line 389: If (p_rec.eeo_off_req_data_from_org = hr_api.g_date) then

385: If (p_rec.comrep_noncom_req = hr_api.g_varchar2) then
386: p_rec.comrep_noncom_req :=
387: ghr_cah_shd.g_old_rec.comrep_noncom_req;
388: End If;
389: If (p_rec.eeo_off_req_data_from_org = hr_api.g_date) then
390: p_rec.eeo_off_req_data_from_org :=
391: ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org;
392: End If;
393: If (p_rec.org_forwd_data_to_eeo_off = hr_api.g_date) then

Line 393: If (p_rec.org_forwd_data_to_eeo_off = hr_api.g_date) then

389: If (p_rec.eeo_off_req_data_from_org = hr_api.g_date) then
390: p_rec.eeo_off_req_data_from_org :=
391: ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org;
392: End If;
393: If (p_rec.org_forwd_data_to_eeo_off = hr_api.g_date) then
394: p_rec.org_forwd_data_to_eeo_off :=
395: ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off;
396: End If;
397: If (p_rec.dec_implemented = hr_api.g_date) then

Line 397: If (p_rec.dec_implemented = hr_api.g_date) then

393: If (p_rec.org_forwd_data_to_eeo_off = hr_api.g_date) then
394: p_rec.org_forwd_data_to_eeo_off :=
395: ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off;
396: End If;
397: If (p_rec.dec_implemented = hr_api.g_date) then
398: p_rec.dec_implemented :=
399: ghr_cah_shd.g_old_rec.dec_implemented;
400: End If;
401: If (p_rec.complaint_reinstated = hr_api.g_date) then

Line 401: If (p_rec.complaint_reinstated = hr_api.g_date) then

397: If (p_rec.dec_implemented = hr_api.g_date) then
398: p_rec.dec_implemented :=
399: ghr_cah_shd.g_old_rec.dec_implemented;
400: End If;
401: If (p_rec.complaint_reinstated = hr_api.g_date) then
402: p_rec.complaint_reinstated :=
403: ghr_cah_shd.g_old_rec.complaint_reinstated;
404: End If;
405: If (p_rec.stage_complaint_reinstated = hr_api.g_varchar2) then

Line 405: If (p_rec.stage_complaint_reinstated = hr_api.g_varchar2) then

401: If (p_rec.complaint_reinstated = hr_api.g_date) then
402: p_rec.complaint_reinstated :=
403: ghr_cah_shd.g_old_rec.complaint_reinstated;
404: End If;
405: If (p_rec.stage_complaint_reinstated = hr_api.g_varchar2) then
406: p_rec.stage_complaint_reinstated :=
407: ghr_cah_shd.g_old_rec.stage_complaint_reinstated;
408: End If;
409: --

Line 467: ,p_complaint_id in number default hr_api.g_number

463: Procedure upd
464: (p_effective_date in date
465: ,p_compl_ca_header_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_complaint_id in number default hr_api.g_number
468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2

Line 468: ,p_ca_source in varchar2 default hr_api.g_varchar2

464: (p_effective_date in date
465: ,p_compl_ca_header_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_complaint_id in number default hr_api.g_number
468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2

Line 469: ,p_last_compliance_report in date default hr_api.g_date

465: ,p_compl_ca_header_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_complaint_id in number default hr_api.g_number
468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2

Line 470: ,p_compliance_closed in date default hr_api.g_date

466: ,p_object_version_number in out nocopy number
467: ,p_complaint_id in number default hr_api.g_number
468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date

Line 471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2

467: ,p_complaint_id in number default hr_api.g_number
468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date

Line 472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2

468: ,p_ca_source in varchar2 default hr_api.g_varchar2
469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date

Line 473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2

469: ,p_last_compliance_report in date default hr_api.g_date
470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date

Line 474: ,p_pfe_received in date default hr_api.g_date

470: ,p_compliance_closed in date default hr_api.g_date
471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2

Line 475: ,p_agency_brief_pfe_due in date default hr_api.g_date

471: ,p_compl_docket_number in varchar2 default hr_api.g_varchar2
472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date

Line 476: ,p_agency_brief_pfe_date in date default hr_api.g_date

472: ,p_appeal_docket_number in varchar2 default hr_api.g_varchar2
473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date

Line 477: ,p_decision_pfe_date in date default hr_api.g_date

473: ,p_pfe_docket_number in varchar2 default hr_api.g_varchar2
474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date

Line 478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2

474: ,p_pfe_received in date default hr_api.g_date
475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

Line 479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date

475: ,p_agency_brief_pfe_due in date default hr_api.g_date
476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date

Line 480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date

476: ,p_agency_brief_pfe_date in date default hr_api.g_date
477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date

Line 481: ,p_agency_notified_noncom in date default hr_api.g_date

477: ,p_decision_pfe_date in date default hr_api.g_date
478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date

Line 482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2

478: ,p_decision_pfe in varchar2 default hr_api.g_varchar2
479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date

Line 483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date

479: ,p_agency_recvd_pfe_decision in date default hr_api.g_date
480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date
487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2

Line 484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date

480: ,p_agency_pfe_brief_forwd in date default hr_api.g_date
481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date
487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
488: ) is

Line 485: ,p_dec_implemented in date default hr_api.g_date

481: ,p_agency_notified_noncom in date default hr_api.g_date
482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date
487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
488: ) is
489: --

Line 486: ,p_complaint_reinstated in date default hr_api.g_date

482: ,p_comrep_noncom_req in varchar2 default hr_api.g_varchar2
483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date
487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
488: ) is
489: --
490: l_rec ghr_cah_shd.g_rec_type;

Line 487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2

483: ,p_eeo_off_req_data_from_org in date default hr_api.g_date
484: ,p_org_forwd_data_to_eeo_off in date default hr_api.g_date
485: ,p_dec_implemented in date default hr_api.g_date
486: ,p_complaint_reinstated in date default hr_api.g_date
487: ,p_stage_complaint_reinstated in varchar2 default hr_api.g_varchar2
488: ) is
489: --
490: l_rec ghr_cah_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'upd';