APPS.GHR_CAH_UPD dependencies on GHR_CAH_SHD

Line 55: (p_rec in out nocopy ghr_cah_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ghr_cah_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 105: ghr_cah_shd.constraint_error

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));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: --

Line 110: 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));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --

Line 115: 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));
117: When Others Then
118: --
119: Raise;

Line 155: (p_rec in ghr_cah_shd.g_rec_type

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure pre_update
155: (p_rec in ghr_cah_shd.g_rec_type
156: ) is
157: --
158: l_proc varchar2(72) := g_package||'pre_update';
159: --

Line 200: ,p_rec in ghr_cah_shd.g_rec_type

196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure post_update
199: (p_effective_date in date
200: ,p_rec in ghr_cah_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'post_update';
204: --

Line 234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id

230: ,p_dec_implemented => p_rec.dec_implemented
231: ,p_complaint_reinstated => p_rec.complaint_reinstated
232: ,p_stage_complaint_reinstated => p_rec.stage_complaint_reinstated
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number

Line 235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source

231: ,p_complaint_reinstated => p_rec.complaint_reinstated
232: ,p_stage_complaint_reinstated => p_rec.stage_complaint_reinstated
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number

Line 236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report

232: ,p_stage_complaint_reinstated => p_rec.stage_complaint_reinstated
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number

Line 237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed

233: ,p_object_version_number => p_rec.object_version_number
234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received

Line 238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number

234: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due

Line 239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number

235: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date

Line 240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number

236: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date

Line 241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received

237: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe

Line 242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due

238: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision

Line 243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date

239: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd

Line 244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date

240: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom

Line 245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe

241: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req

Line 246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision

242: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org

Line 247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd

243: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off

Line 248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom

244: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented

Line 249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req

245: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated

Line 250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org

246: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated

Line 251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off

247: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number

Line 252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented

248: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
256: );

Line 253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated

249: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
256: );
257: --

Line 254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated

250: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
256: );
257: --
258: exception

Line 255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number

251: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
252: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
253: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
254: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
255: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
256: );
257: --
258: exception
259: --

Line 315: (p_rec in out nocopy ghr_cah_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure convert_defs
315: (p_rec in out nocopy ghr_cah_shd.g_rec_type
316: ) is
317: --
318: Begin
319: --

Line 327: ghr_cah_shd.g_old_rec.complaint_id;

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
330: p_rec.ca_source :=
331: ghr_cah_shd.g_old_rec.ca_source;

Line 331: ghr_cah_shd.g_old_rec.ca_source;

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
334: p_rec.last_compliance_report :=
335: ghr_cah_shd.g_old_rec.last_compliance_report;

Line 335: ghr_cah_shd.g_old_rec.last_compliance_report;

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
338: p_rec.compliance_closed :=
339: ghr_cah_shd.g_old_rec.compliance_closed;

Line 339: ghr_cah_shd.g_old_rec.compliance_closed;

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
342: p_rec.compl_docket_number :=
343: ghr_cah_shd.g_old_rec.compl_docket_number;

Line 343: ghr_cah_shd.g_old_rec.compl_docket_number;

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
346: p_rec.appeal_docket_number :=
347: ghr_cah_shd.g_old_rec.appeal_docket_number;

Line 347: ghr_cah_shd.g_old_rec.appeal_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
350: p_rec.pfe_docket_number :=
351: ghr_cah_shd.g_old_rec.pfe_docket_number;

Line 351: ghr_cah_shd.g_old_rec.pfe_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
354: p_rec.pfe_received :=
355: ghr_cah_shd.g_old_rec.pfe_received;

Line 355: ghr_cah_shd.g_old_rec.pfe_received;

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
358: p_rec.agency_brief_pfe_due :=
359: ghr_cah_shd.g_old_rec.agency_brief_pfe_due;

Line 359: ghr_cah_shd.g_old_rec.agency_brief_pfe_due;

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
362: p_rec.agency_brief_pfe_date :=
363: ghr_cah_shd.g_old_rec.agency_brief_pfe_date;

Line 363: ghr_cah_shd.g_old_rec.agency_brief_pfe_date;

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
366: p_rec.decision_pfe_date :=
367: ghr_cah_shd.g_old_rec.decision_pfe_date;

Line 367: ghr_cah_shd.g_old_rec.decision_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
370: p_rec.decision_pfe :=
371: ghr_cah_shd.g_old_rec.decision_pfe;

Line 371: ghr_cah_shd.g_old_rec.decision_pfe;

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
374: p_rec.agency_recvd_pfe_decision :=
375: ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision;

Line 375: ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision;

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
378: p_rec.agency_pfe_brief_forwd :=
379: ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd;

Line 379: ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd;

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
382: p_rec.agency_notified_noncom :=
383: ghr_cah_shd.g_old_rec.agency_notified_noncom;

Line 383: ghr_cah_shd.g_old_rec.agency_notified_noncom;

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
386: p_rec.comrep_noncom_req :=
387: ghr_cah_shd.g_old_rec.comrep_noncom_req;

Line 387: ghr_cah_shd.g_old_rec.comrep_noncom_req;

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
390: p_rec.eeo_off_req_data_from_org :=
391: ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org;

Line 391: ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org;

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
394: p_rec.org_forwd_data_to_eeo_off :=
395: ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off;

Line 395: ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off;

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
398: p_rec.dec_implemented :=
399: ghr_cah_shd.g_old_rec.dec_implemented;

Line 399: ghr_cah_shd.g_old_rec.dec_implemented;

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
402: p_rec.complaint_reinstated :=
403: ghr_cah_shd.g_old_rec.complaint_reinstated;

Line 403: ghr_cah_shd.g_old_rec.complaint_reinstated;

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
406: p_rec.stage_complaint_reinstated :=
407: ghr_cah_shd.g_old_rec.stage_complaint_reinstated;

Line 407: ghr_cah_shd.g_old_rec.stage_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: --
410: End convert_defs;
411: --

Line 417: ,p_rec in out nocopy ghr_cah_shd.g_rec_type

413: -- |---------------------------------< upd >----------------------------------|
414: -- ----------------------------------------------------------------------------
415: Procedure upd
416: (p_effective_date in date
417: ,p_rec in out nocopy ghr_cah_shd.g_rec_type
418: ) is
419: --
420: l_proc varchar2(72) := g_package||'upd';
421: --

Line 427: ghr_cah_shd.lck

423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- We must lock the row which we need to update.
426: --
427: ghr_cah_shd.lck
428: (p_rec.compl_ca_header_id
429: ,p_rec.object_version_number
430: );
431: --

Line 490: l_rec ghr_cah_shd.g_rec_type;

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';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);

Line 500: ghr_cah_shd.convert_args

496: -- Call conversion function to turn arguments into the
497: -- l_rec structure.
498: --
499: l_rec :=
500: ghr_cah_shd.convert_args
501: (p_compl_ca_header_id
502: ,p_complaint_id
503: ,p_ca_source
504: ,p_last_compliance_report