eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CAH_DEL dependencies on GHR_CAH_SHD

Line 52: (p_rec in ghr_cah_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ghr_cah_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: ghr_cah_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ghr_cah_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ghr_cah_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ghr_cah_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in ghr_cah_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in ghr_cah_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

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

162: begin
163: --
164: ghr_cah_rkd.after_delete
165: (p_compl_ca_header_id => p_rec.compl_ca_header_id
166: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number

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

163: --
164: ghr_cah_rkd.after_delete
165: (p_compl_ca_header_id => p_rec.compl_ca_header_id
166: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number

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

164: ghr_cah_rkd.after_delete
165: (p_compl_ca_header_id => p_rec.compl_ca_header_id
166: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number

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

165: (p_compl_ca_header_id => p_rec.compl_ca_header_id
166: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received

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

166: ,p_complaint_id_o => ghr_cah_shd.g_old_rec.complaint_id
167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due

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

167: ,p_ca_source_o => ghr_cah_shd.g_old_rec.ca_source
168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date

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

168: ,p_last_compliance_report_o => ghr_cah_shd.g_old_rec.last_compliance_report
169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date

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

169: ,p_compliance_closed_o => ghr_cah_shd.g_old_rec.compliance_closed
170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe

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

170: ,p_compl_docket_number_o => ghr_cah_shd.g_old_rec.compl_docket_number
171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision

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

171: ,p_appeal_docket_number_o => ghr_cah_shd.g_old_rec.appeal_docket_number
172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd

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

172: ,p_pfe_docket_number_o => ghr_cah_shd.g_old_rec.pfe_docket_number
173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom

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

173: ,p_pfe_received_o => ghr_cah_shd.g_old_rec.pfe_received
174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req

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

174: ,p_agency_brief_pfe_due_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_due
175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org

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

175: ,p_agency_brief_pfe_date_o => ghr_cah_shd.g_old_rec.agency_brief_pfe_date
176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off

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

176: ,p_decision_pfe_date_o => ghr_cah_shd.g_old_rec.decision_pfe_date
177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented

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

177: ,p_decision_pfe_o => ghr_cah_shd.g_old_rec.decision_pfe
178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated

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

178: ,p_agency_recvd_pfe_decision_o => ghr_cah_shd.g_old_rec.agency_recvd_pfe_decision
179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated

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

179: ,p_agency_pfe_brief_forwd_o => ghr_cah_shd.g_old_rec.agency_pfe_brief_forwd
180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
187: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number

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

180: ,p_agency_notified_noncom_o => ghr_cah_shd.g_old_rec.agency_notified_noncom
181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
187: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
188: );

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

181: ,p_comrep_noncom_req_o => ghr_cah_shd.g_old_rec.comrep_noncom_req
182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
187: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
188: );
189: --

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

182: ,p_eeo_off_req_data_from_org_o => ghr_cah_shd.g_old_rec.eeo_off_req_data_from_org
183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
187: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
188: );
189: --
190: exception

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

183: ,p_org_forwd_data_to_eeo_off_o => ghr_cah_shd.g_old_rec.org_forwd_data_to_eeo_off
184: ,p_dec_implemented_o => ghr_cah_shd.g_old_rec.dec_implemented
185: ,p_complaint_reinstated_o => ghr_cah_shd.g_old_rec.complaint_reinstated
186: ,p_stage_complaint_reinstated_o => ghr_cah_shd.g_old_rec.stage_complaint_reinstated
187: ,p_object_version_number_o => ghr_cah_shd.g_old_rec.object_version_number
188: );
189: --
190: exception
191: --

Line 207: (p_rec in ghr_cah_shd.g_rec_type

203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|
205: -- ----------------------------------------------------------------------------
206: Procedure del
207: (p_rec in ghr_cah_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'del';
211: --

Line 217: ghr_cah_shd.lck

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- We must lock the row which we need to delete.
216: --
217: ghr_cah_shd.lck
218: (p_rec.compl_ca_header_id
219: ,p_rec.object_version_number
220: );
221: --

Line 248: l_rec ghr_cah_shd.g_rec_type;

244: (p_compl_ca_header_id in number
245: ,p_object_version_number in number
246: ) is
247: --
248: l_rec ghr_cah_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'del';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);