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_CAA_DEL dependencies on GHR_CAA_SHD

Line 52: (p_rec in ghr_caa_shd.g_rec_type

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

Line 75: ghr_caa_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ghr_caa_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_caa_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_caa_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_caa_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_caa_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_caa_shd.g_old_rec.complaint_id

162: begin
163: --
164: ghr_caa_rkd.after_delete
165: (p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
166: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num

Line 167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date

163: --
164: ghr_caa_rkd.after_delete
165: (p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
166: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files

Line 168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal

164: ghr_caa_rkd.after_delete
165: (p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
166: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due

Line 169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date

165: (p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
166: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd

Line 170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num

166: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due

Line 171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files

167: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd

Line 172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due

168: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief

Line 173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd

169: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date

Line 174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due

170: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency

Line 175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd

171: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision

Line 176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief

172: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org

Line 177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date

173: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense

Line 178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency

174: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr

Line 179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision

175: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num

Line 180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org

176: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by

Line 181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense

177: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due

Line 182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr

178: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org

Line 183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num

179: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency

Line 184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by

180: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo

Line 185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due

181: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date

Line 186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org

182: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec

Line 187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency

183: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org

Line 188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo

184: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision

Line 189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date

185: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number

Line 190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec

186: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
194: );

Line 191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org

187: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
194: );
195: --

Line 192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision

188: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
194: );
195: --
196: exception

Line 193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number

189: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
190: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
191: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
192: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
193: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
194: );
195: --
196: exception
197: --

Line 213: (p_rec in ghr_caa_shd.g_rec_type

209: -- ----------------------------------------------------------------------------
210: -- |---------------------------------< del >----------------------------------|
211: -- ----------------------------------------------------------------------------
212: Procedure del
213: (p_rec in ghr_caa_shd.g_rec_type
214: ) is
215: --
216: l_proc varchar2(72) := g_package||'del';
217: --

Line 223: ghr_caa_shd.lck

219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: -- We must lock the row which we need to delete.
222: --
223: ghr_caa_shd.lck
224: (p_rec.compl_agency_appeal_id
225: ,p_rec.object_version_number
226: );
227: --

Line 254: l_rec ghr_caa_shd.g_rec_type;

250: (p_compl_agency_appeal_id in number
251: ,p_object_version_number in number
252: ) is
253: --
254: l_rec ghr_caa_shd.g_rec_type;
255: l_proc varchar2(72) := g_package||'del';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);