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

Line 55: (p_rec in out nocopy ghr_caa_shd.g_rec_type

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

Line 111: ghr_caa_shd.constraint_error

107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: ghr_caa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --

Line 116: ghr_caa_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: ghr_caa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --

Line 121: ghr_caa_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: ghr_caa_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;

Line 161: (p_rec in ghr_caa_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_update
161: (p_rec in ghr_caa_shd.g_rec_type
162: ) is
163: --
164: l_proc varchar2(72) := g_package||'pre_update';
165: --

Line 206: ,p_rec in ghr_caa_shd.g_rec_type

202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_update
205: (p_effective_date in date
206: ,p_rec in ghr_caa_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'post_update';
210: --

Line 246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id

242: ,p_agency_recvd_rfr_dec => p_rec.agency_recvd_rfr_dec
243: ,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
244: ,p_rfr_decision => p_rec.rfr_decision
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num

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

243: ,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
244: ,p_rfr_decision => p_rec.rfr_decision
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files

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

244: ,p_rfr_decision => p_rec.rfr_decision
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due

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

245: ,p_object_version_number => p_rec.object_version_number
246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd

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

246: ,p_complaint_id_o => ghr_caa_shd.g_old_rec.complaint_id
247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due

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

247: ,p_appeal_date_o => ghr_caa_shd.g_old_rec.appeal_date
248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd

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

248: ,p_reason_for_appeal_o => ghr_caa_shd.g_old_rec.reason_for_appeal
249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief

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

249: ,p_source_decision_date_o => ghr_caa_shd.g_old_rec.source_decision_date
250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date

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

250: ,p_docket_num_o => ghr_caa_shd.g_old_rec.docket_num
251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency

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

251: ,p_agency_recvd_req_for_files_o => ghr_caa_shd.g_old_rec.agency_recvd_req_for_files
252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision

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

252: ,p_files_due_o => ghr_caa_shd.g_old_rec.files_due
253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org

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

253: ,p_files_forwd_o => ghr_caa_shd.g_old_rec.files_forwd
254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense

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

254: ,p_agency_brief_due_o => ghr_caa_shd.g_old_rec.agency_brief_due
255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr

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

255: ,p_agency_brief_forwd_o => ghr_caa_shd.g_old_rec.agency_brief_forwd
256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num

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

256: ,p_agency_recvd_appellant_bri_o => ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief
257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by

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

257: ,p_decision_date_o => ghr_caa_shd.g_old_rec.decision_date
258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due

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

258: ,p_dec_recvd_by_agency_o => ghr_caa_shd.g_old_rec.dec_recvd_by_agency
259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org

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

259: ,p_decision_o => ghr_caa_shd.g_old_rec.decision
260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency

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

260: ,p_dec_forwd_to_org_o => ghr_caa_shd.g_old_rec.dec_forwd_to_org
261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo

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

261: ,p_agency_rfr_suspense_o => ghr_caa_shd.g_old_rec.agency_rfr_suspense
262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date

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

262: ,p_request_for_rfr_o => ghr_caa_shd.g_old_rec.request_for_rfr
263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec

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

263: ,p_rfr_docket_num_o => ghr_caa_shd.g_old_rec.rfr_docket_num
264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org

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

264: ,p_rfr_requested_by_o => ghr_caa_shd.g_old_rec.rfr_requested_by
265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision

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

265: ,p_agency_rfr_due_o => ghr_caa_shd.g_old_rec.agency_rfr_due
266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
273: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number

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

266: ,p_rfr_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_forwd_to_org
267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
273: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
274: );

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

267: ,p_org_forwd_rfr_to_agency_o => ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency
268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
273: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
274: );
275: --

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

268: ,p_agency_forwd_rfr_ofo_o => ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo
269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
273: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
274: );
275: --
276: exception

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

269: ,p_rfr_decision_date_o => ghr_caa_shd.g_old_rec.rfr_decision_date
270: ,p_agency_recvd_rfr_dec_o => ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec
271: ,p_rfr_decision_forwd_to_org_o => ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org
272: ,p_rfr_decision_o => ghr_caa_shd.g_old_rec.rfr_decision
273: ,p_object_version_number_o => ghr_caa_shd.g_old_rec.object_version_number
274: );
275: --
276: exception
277: --

Line 333: (p_rec in out nocopy ghr_caa_shd.g_rec_type

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure convert_defs
333: (p_rec in out nocopy ghr_caa_shd.g_rec_type
334: ) is
335: --
336: Begin
337: --

Line 345: ghr_caa_shd.g_old_rec.complaint_id;

341: -- is being used then we must set to the 'current' argument value.
342: --
343: If (p_rec.complaint_id = hr_api.g_number) then
344: p_rec.complaint_id :=
345: ghr_caa_shd.g_old_rec.complaint_id;
346: End If;
347: If (p_rec.appeal_date = hr_api.g_date) then
348: p_rec.appeal_date :=
349: ghr_caa_shd.g_old_rec.appeal_date;

Line 349: ghr_caa_shd.g_old_rec.appeal_date;

345: ghr_caa_shd.g_old_rec.complaint_id;
346: End If;
347: If (p_rec.appeal_date = hr_api.g_date) then
348: p_rec.appeal_date :=
349: ghr_caa_shd.g_old_rec.appeal_date;
350: End If;
351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
352: p_rec.reason_for_appeal :=
353: ghr_caa_shd.g_old_rec.reason_for_appeal;

Line 353: ghr_caa_shd.g_old_rec.reason_for_appeal;

349: ghr_caa_shd.g_old_rec.appeal_date;
350: End If;
351: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
352: p_rec.reason_for_appeal :=
353: ghr_caa_shd.g_old_rec.reason_for_appeal;
354: End If;
355: If (p_rec.source_decision_date = hr_api.g_date) then
356: p_rec.source_decision_date :=
357: ghr_caa_shd.g_old_rec.source_decision_date;

Line 357: ghr_caa_shd.g_old_rec.source_decision_date;

353: ghr_caa_shd.g_old_rec.reason_for_appeal;
354: End If;
355: If (p_rec.source_decision_date = hr_api.g_date) then
356: p_rec.source_decision_date :=
357: ghr_caa_shd.g_old_rec.source_decision_date;
358: End If;
359: If (p_rec.docket_num = hr_api.g_varchar2) then
360: p_rec.docket_num :=
361: ghr_caa_shd.g_old_rec.docket_num;

Line 361: ghr_caa_shd.g_old_rec.docket_num;

357: ghr_caa_shd.g_old_rec.source_decision_date;
358: End If;
359: If (p_rec.docket_num = hr_api.g_varchar2) then
360: p_rec.docket_num :=
361: ghr_caa_shd.g_old_rec.docket_num;
362: End If;
363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
364: p_rec.agency_recvd_req_for_files :=
365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;

Line 365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;

361: ghr_caa_shd.g_old_rec.docket_num;
362: End If;
363: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
364: p_rec.agency_recvd_req_for_files :=
365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;
366: End If;
367: If (p_rec.files_due = hr_api.g_date) then
368: p_rec.files_due :=
369: ghr_caa_shd.g_old_rec.files_due;

Line 369: ghr_caa_shd.g_old_rec.files_due;

365: ghr_caa_shd.g_old_rec.agency_recvd_req_for_files;
366: End If;
367: If (p_rec.files_due = hr_api.g_date) then
368: p_rec.files_due :=
369: ghr_caa_shd.g_old_rec.files_due;
370: End If;
371: If (p_rec.files_forwd = hr_api.g_date) then
372: p_rec.files_forwd :=
373: ghr_caa_shd.g_old_rec.files_forwd;

Line 373: ghr_caa_shd.g_old_rec.files_forwd;

369: ghr_caa_shd.g_old_rec.files_due;
370: End If;
371: If (p_rec.files_forwd = hr_api.g_date) then
372: p_rec.files_forwd :=
373: ghr_caa_shd.g_old_rec.files_forwd;
374: End If;
375: If (p_rec.agency_brief_due = hr_api.g_date) then
376: p_rec.agency_brief_due :=
377: ghr_caa_shd.g_old_rec.agency_brief_due;

Line 377: ghr_caa_shd.g_old_rec.agency_brief_due;

373: ghr_caa_shd.g_old_rec.files_forwd;
374: End If;
375: If (p_rec.agency_brief_due = hr_api.g_date) then
376: p_rec.agency_brief_due :=
377: ghr_caa_shd.g_old_rec.agency_brief_due;
378: End If;
379: If (p_rec.agency_brief_forwd = hr_api.g_date) then
380: p_rec.agency_brief_forwd :=
381: ghr_caa_shd.g_old_rec.agency_brief_forwd;

Line 381: ghr_caa_shd.g_old_rec.agency_brief_forwd;

377: ghr_caa_shd.g_old_rec.agency_brief_due;
378: End If;
379: If (p_rec.agency_brief_forwd = hr_api.g_date) then
380: p_rec.agency_brief_forwd :=
381: ghr_caa_shd.g_old_rec.agency_brief_forwd;
382: End If;
383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then
384: p_rec.agency_recvd_appellant_brief :=
385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;

Line 385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;

381: ghr_caa_shd.g_old_rec.agency_brief_forwd;
382: End If;
383: If (p_rec.agency_recvd_appellant_brief = hr_api.g_date) then
384: p_rec.agency_recvd_appellant_brief :=
385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;
386: End If;
387: If (p_rec.decision_date = hr_api.g_date) then
388: p_rec.decision_date :=
389: ghr_caa_shd.g_old_rec.decision_date;

Line 389: ghr_caa_shd.g_old_rec.decision_date;

385: ghr_caa_shd.g_old_rec.agency_recvd_appellant_brief;
386: End If;
387: If (p_rec.decision_date = hr_api.g_date) then
388: p_rec.decision_date :=
389: ghr_caa_shd.g_old_rec.decision_date;
390: End If;
391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
392: p_rec.dec_recvd_by_agency :=
393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;

Line 393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;

389: ghr_caa_shd.g_old_rec.decision_date;
390: End If;
391: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
392: p_rec.dec_recvd_by_agency :=
393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;
394: End If;
395: If (p_rec.decision = hr_api.g_varchar2) then
396: p_rec.decision :=
397: ghr_caa_shd.g_old_rec.decision;

Line 397: ghr_caa_shd.g_old_rec.decision;

393: ghr_caa_shd.g_old_rec.dec_recvd_by_agency;
394: End If;
395: If (p_rec.decision = hr_api.g_varchar2) then
396: p_rec.decision :=
397: ghr_caa_shd.g_old_rec.decision;
398: End If;
399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
400: p_rec.dec_forwd_to_org :=
401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;

Line 401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;

397: ghr_caa_shd.g_old_rec.decision;
398: End If;
399: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
400: p_rec.dec_forwd_to_org :=
401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;
402: End If;
403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
404: p_rec.agency_rfr_suspense :=
405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;

Line 405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;

401: ghr_caa_shd.g_old_rec.dec_forwd_to_org;
402: End If;
403: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
404: p_rec.agency_rfr_suspense :=
405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;
406: End If;
407: If (p_rec.request_for_rfr = hr_api.g_date) then
408: p_rec.request_for_rfr :=
409: ghr_caa_shd.g_old_rec.request_for_rfr;

Line 409: ghr_caa_shd.g_old_rec.request_for_rfr;

405: ghr_caa_shd.g_old_rec.agency_rfr_suspense;
406: End If;
407: If (p_rec.request_for_rfr = hr_api.g_date) then
408: p_rec.request_for_rfr :=
409: ghr_caa_shd.g_old_rec.request_for_rfr;
410: End If;
411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
412: p_rec.rfr_docket_num :=
413: ghr_caa_shd.g_old_rec.rfr_docket_num;

Line 413: ghr_caa_shd.g_old_rec.rfr_docket_num;

409: ghr_caa_shd.g_old_rec.request_for_rfr;
410: End If;
411: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
412: p_rec.rfr_docket_num :=
413: ghr_caa_shd.g_old_rec.rfr_docket_num;
414: End If;
415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
416: p_rec.rfr_requested_by :=
417: ghr_caa_shd.g_old_rec.rfr_requested_by;

Line 417: ghr_caa_shd.g_old_rec.rfr_requested_by;

413: ghr_caa_shd.g_old_rec.rfr_docket_num;
414: End If;
415: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
416: p_rec.rfr_requested_by :=
417: ghr_caa_shd.g_old_rec.rfr_requested_by;
418: End If;
419: If (p_rec.agency_rfr_due = hr_api.g_date) then
420: p_rec.agency_rfr_due :=
421: ghr_caa_shd.g_old_rec.agency_rfr_due;

Line 421: ghr_caa_shd.g_old_rec.agency_rfr_due;

417: ghr_caa_shd.g_old_rec.rfr_requested_by;
418: End If;
419: If (p_rec.agency_rfr_due = hr_api.g_date) then
420: p_rec.agency_rfr_due :=
421: ghr_caa_shd.g_old_rec.agency_rfr_due;
422: End If;
423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
424: p_rec.rfr_forwd_to_org :=
425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;

Line 425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;

421: ghr_caa_shd.g_old_rec.agency_rfr_due;
422: End If;
423: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
424: p_rec.rfr_forwd_to_org :=
425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;
426: End If;
427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
428: p_rec.org_forwd_rfr_to_agency :=
429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;

Line 429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;

425: ghr_caa_shd.g_old_rec.rfr_forwd_to_org;
426: End If;
427: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
428: p_rec.org_forwd_rfr_to_agency :=
429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;
430: End If;
431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
432: p_rec.agency_forwd_rfr_ofo :=
433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;

Line 433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;

429: ghr_caa_shd.g_old_rec.org_forwd_rfr_to_agency;
430: End If;
431: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
432: p_rec.agency_forwd_rfr_ofo :=
433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;
434: End If;
435: If (p_rec.rfr_decision_date = hr_api.g_date) then
436: p_rec.rfr_decision_date :=
437: ghr_caa_shd.g_old_rec.rfr_decision_date;

Line 437: ghr_caa_shd.g_old_rec.rfr_decision_date;

433: ghr_caa_shd.g_old_rec.agency_forwd_rfr_ofo;
434: End If;
435: If (p_rec.rfr_decision_date = hr_api.g_date) then
436: p_rec.rfr_decision_date :=
437: ghr_caa_shd.g_old_rec.rfr_decision_date;
438: End If;
439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
440: p_rec.agency_recvd_rfr_dec :=
441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;

Line 441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;

437: ghr_caa_shd.g_old_rec.rfr_decision_date;
438: End If;
439: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
440: p_rec.agency_recvd_rfr_dec :=
441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;
442: End If;
443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
444: p_rec.rfr_decision_forwd_to_org :=
445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;

Line 445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;

441: ghr_caa_shd.g_old_rec.agency_recvd_rfr_dec;
442: End If;
443: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
444: p_rec.rfr_decision_forwd_to_org :=
445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;
446: End If;
447: If (p_rec.rfr_decision = hr_api.g_varchar2) then
448: p_rec.rfr_decision :=
449: ghr_caa_shd.g_old_rec.rfr_decision;

Line 449: ghr_caa_shd.g_old_rec.rfr_decision;

445: ghr_caa_shd.g_old_rec.rfr_decision_forwd_to_org;
446: End If;
447: If (p_rec.rfr_decision = hr_api.g_varchar2) then
448: p_rec.rfr_decision :=
449: ghr_caa_shd.g_old_rec.rfr_decision;
450: End If;
451: --
452: End convert_defs;
453: --

Line 459: ,p_rec in out nocopy ghr_caa_shd.g_rec_type

455: -- |---------------------------------< upd >----------------------------------|
456: -- ----------------------------------------------------------------------------
457: Procedure upd
458: (p_effective_date in date
459: ,p_rec in out nocopy ghr_caa_shd.g_rec_type
460: ) is
461: --
462: l_proc varchar2(72) := g_package||'upd';
463: --

Line 469: ghr_caa_shd.lck

465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- We must lock the row which we need to update.
468: --
469: ghr_caa_shd.lck
470: (p_rec.compl_agency_appeal_id
471: ,p_rec.object_version_number
472: );
473: --

Line 538: l_rec ghr_caa_shd.g_rec_type;

534: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
535: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
536: ) is
537: --
538: l_rec ghr_caa_shd.g_rec_type;
539: l_proc varchar2(72) := g_package||'upd';
540: --
541: Begin
542: hr_utility.set_location('Entering:'||l_proc, 5);

Line 548: ghr_caa_shd.convert_args

544: -- Call conversion function to turn arguments into the
545: -- l_rec structure.
546: --
547: l_rec :=
548: ghr_caa_shd.convert_args
549: (p_compl_agency_appeal_id
550: ,p_complaint_id
551: ,p_appeal_date
552: ,p_reason_for_appeal