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