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_CCA_UPD dependencies on GHR_CCA_SHD

Line 55: (p_rec in out nocopy ghr_cca_shd.g_rec_type

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

Line 115: ghr_cca_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ghr_cca_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --

Line 120: ghr_cca_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ghr_cca_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --

Line 125: ghr_cca_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ghr_cca_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;

Line 165: (p_rec in ghr_cca_shd.g_rec_type

161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_update
165: (p_rec in ghr_cca_shd.g_rec_type
166: ) is
167: --
168: l_proc varchar2(72) := g_package||'pre_update';
169: --

Line 210: ,p_rec in ghr_cca_shd.g_rec_type

206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_update
209: (p_effective_date in date
210: ,p_rec in ghr_cca_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --

Line 254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id

250: ,p_rfr_decision_date => p_rec.rfr_decision_date
251: ,p_agency_recvd_rfr_dec => p_rec.agency_recvd_rfr_dec
252: ,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
253: ,p_object_version_number => p_rec.object_version_number
254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date

Line 255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date

251: ,p_agency_recvd_rfr_dec => p_rec.agency_recvd_rfr_dec
252: ,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
253: ,p_object_version_number => p_rec.object_version_number
254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num

Line 256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to

252: ,p_rfr_decision_forwd_to_org => p_rec.rfr_decision_forwd_to_org
253: ,p_object_version_number => p_rec.object_version_number
254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal

Line 257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal

253: ,p_object_version_number => p_rec.object_version_number
254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files

Line 258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date

254: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due

Line 259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num

255: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd

Line 260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal

256: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief

Line 261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files

257: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due

Line 262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due

258: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org

Line 263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd

259: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency

Line 264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief

260: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd

Line 265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due

261: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date

Line 266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org

262: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency

Line 267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency

263: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision

Line 268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd

264: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org

Line 269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date

265: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense

Line 270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency

266: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr

Line 271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision

267: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num

Line 272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org

268: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by

Line 273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense

269: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due

Line 274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr

270: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org

Line 275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num

271: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency

Line 276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by

272: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo

Line 277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due

273: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision

Line 278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org

274: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date

Line 279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency

275: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec

Line 280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo

276: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org

Line 281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision

277: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number

Line 282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date

278: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
286: );

Line 283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec

279: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
286: );
287: --

Line 284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org

280: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
286: );
287: --
288: exception

Line 285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number

281: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
282: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
283: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
284: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
285: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
286: );
287: --
288: exception
289: --

Line 345: (p_rec in out nocopy ghr_cca_shd.g_rec_type

341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure convert_defs
345: (p_rec in out nocopy ghr_cca_shd.g_rec_type
346: ) is
347: --
348: Begin
349: --

Line 357: ghr_cca_shd.g_old_rec.complaint_id;

353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.complaint_id = hr_api.g_number) then
356: p_rec.complaint_id :=
357: ghr_cca_shd.g_old_rec.complaint_id;
358: End If;
359: If (p_rec.appeal_date = hr_api.g_date) then
360: p_rec.appeal_date :=
361: ghr_cca_shd.g_old_rec.appeal_date;

Line 361: ghr_cca_shd.g_old_rec.appeal_date;

357: ghr_cca_shd.g_old_rec.complaint_id;
358: End If;
359: If (p_rec.appeal_date = hr_api.g_date) then
360: p_rec.appeal_date :=
361: ghr_cca_shd.g_old_rec.appeal_date;
362: End If;
363: If (p_rec.appealed_to = hr_api.g_varchar2) then
364: p_rec.appealed_to :=
365: ghr_cca_shd.g_old_rec.appealed_to;

Line 365: ghr_cca_shd.g_old_rec.appealed_to;

361: ghr_cca_shd.g_old_rec.appeal_date;
362: End If;
363: If (p_rec.appealed_to = hr_api.g_varchar2) then
364: p_rec.appealed_to :=
365: ghr_cca_shd.g_old_rec.appealed_to;
366: End If;
367: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
368: p_rec.reason_for_appeal :=
369: ghr_cca_shd.g_old_rec.reason_for_appeal;

Line 369: ghr_cca_shd.g_old_rec.reason_for_appeal;

365: ghr_cca_shd.g_old_rec.appealed_to;
366: End If;
367: If (p_rec.reason_for_appeal = hr_api.g_varchar2) then
368: p_rec.reason_for_appeal :=
369: ghr_cca_shd.g_old_rec.reason_for_appeal;
370: End If;
371: If (p_rec.source_decision_date = hr_api.g_date) then
372: p_rec.source_decision_date :=
373: ghr_cca_shd.g_old_rec.source_decision_date;

Line 373: ghr_cca_shd.g_old_rec.source_decision_date;

369: ghr_cca_shd.g_old_rec.reason_for_appeal;
370: End If;
371: If (p_rec.source_decision_date = hr_api.g_date) then
372: p_rec.source_decision_date :=
373: ghr_cca_shd.g_old_rec.source_decision_date;
374: End If;
375: If (p_rec.docket_num = hr_api.g_varchar2) then
376: p_rec.docket_num :=
377: ghr_cca_shd.g_old_rec.docket_num;

Line 377: ghr_cca_shd.g_old_rec.docket_num;

373: ghr_cca_shd.g_old_rec.source_decision_date;
374: End If;
375: If (p_rec.docket_num = hr_api.g_varchar2) then
376: p_rec.docket_num :=
377: ghr_cca_shd.g_old_rec.docket_num;
378: End If;
379: If (p_rec.org_notified_of_appeal = hr_api.g_date) then
380: p_rec.org_notified_of_appeal :=
381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;

Line 381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;

377: ghr_cca_shd.g_old_rec.docket_num;
378: End If;
379: If (p_rec.org_notified_of_appeal = hr_api.g_date) then
380: p_rec.org_notified_of_appeal :=
381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;
382: End If;
383: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
384: p_rec.agency_recvd_req_for_files :=
385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;

Line 385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;

381: ghr_cca_shd.g_old_rec.org_notified_of_appeal;
382: End If;
383: If (p_rec.agency_recvd_req_for_files = hr_api.g_date) then
384: p_rec.agency_recvd_req_for_files :=
385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;
386: End If;
387: If (p_rec.files_due = hr_api.g_date) then
388: p_rec.files_due :=
389: ghr_cca_shd.g_old_rec.files_due;

Line 389: ghr_cca_shd.g_old_rec.files_due;

385: ghr_cca_shd.g_old_rec.agency_recvd_req_for_files;
386: End If;
387: If (p_rec.files_due = hr_api.g_date) then
388: p_rec.files_due :=
389: ghr_cca_shd.g_old_rec.files_due;
390: End If;
391: If (p_rec.files_forwd = hr_api.g_date) then
392: p_rec.files_forwd :=
393: ghr_cca_shd.g_old_rec.files_forwd;

Line 393: ghr_cca_shd.g_old_rec.files_forwd;

389: ghr_cca_shd.g_old_rec.files_due;
390: End If;
391: If (p_rec.files_forwd = hr_api.g_date) then
392: p_rec.files_forwd :=
393: ghr_cca_shd.g_old_rec.files_forwd;
394: End If;
395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then
396: p_rec.agcy_recvd_appellant_brief :=
397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;

Line 397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;

393: ghr_cca_shd.g_old_rec.files_forwd;
394: End If;
395: If (p_rec.agcy_recvd_appellant_brief = hr_api.g_date) then
396: p_rec.agcy_recvd_appellant_brief :=
397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;
398: End If;
399: If (p_rec.agency_brief_due = hr_api.g_date) then
400: p_rec.agency_brief_due :=
401: ghr_cca_shd.g_old_rec.agency_brief_due;

Line 401: ghr_cca_shd.g_old_rec.agency_brief_due;

397: ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief;
398: End If;
399: If (p_rec.agency_brief_due = hr_api.g_date) then
400: p_rec.agency_brief_due :=
401: ghr_cca_shd.g_old_rec.agency_brief_due;
402: End If;
403: If (p_rec.appellant_brief_forwd_org = hr_api.g_date) then
404: p_rec.appellant_brief_forwd_org :=
405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;

Line 405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;

401: ghr_cca_shd.g_old_rec.agency_brief_due;
402: End If;
403: If (p_rec.appellant_brief_forwd_org = hr_api.g_date) then
404: p_rec.appellant_brief_forwd_org :=
405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;
406: End If;
407: If (p_rec.org_forwd_brief_to_agency = hr_api.g_date) then
408: p_rec.org_forwd_brief_to_agency :=
409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;

Line 409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;

405: ghr_cca_shd.g_old_rec.appellant_brief_forwd_org;
406: End If;
407: If (p_rec.org_forwd_brief_to_agency = hr_api.g_date) then
408: p_rec.org_forwd_brief_to_agency :=
409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;
410: End If;
411: If (p_rec.agency_brief_forwd = hr_api.g_date) then
412: p_rec.agency_brief_forwd :=
413: ghr_cca_shd.g_old_rec.agency_brief_forwd;

Line 413: ghr_cca_shd.g_old_rec.agency_brief_forwd;

409: ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency;
410: End If;
411: If (p_rec.agency_brief_forwd = hr_api.g_date) then
412: p_rec.agency_brief_forwd :=
413: ghr_cca_shd.g_old_rec.agency_brief_forwd;
414: End If;
415: If (p_rec.decision_date = hr_api.g_date) then
416: p_rec.decision_date :=
417: ghr_cca_shd.g_old_rec.decision_date;

Line 417: ghr_cca_shd.g_old_rec.decision_date;

413: ghr_cca_shd.g_old_rec.agency_brief_forwd;
414: End If;
415: If (p_rec.decision_date = hr_api.g_date) then
416: p_rec.decision_date :=
417: ghr_cca_shd.g_old_rec.decision_date;
418: End If;
419: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
420: p_rec.dec_recvd_by_agency :=
421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;

Line 421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;

417: ghr_cca_shd.g_old_rec.decision_date;
418: End If;
419: If (p_rec.dec_recvd_by_agency = hr_api.g_date) then
420: p_rec.dec_recvd_by_agency :=
421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;
422: End If;
423: If (p_rec.decision = hr_api.g_varchar2) then
424: p_rec.decision :=
425: ghr_cca_shd.g_old_rec.decision;

Line 425: ghr_cca_shd.g_old_rec.decision;

421: ghr_cca_shd.g_old_rec.dec_recvd_by_agency;
422: End If;
423: If (p_rec.decision = hr_api.g_varchar2) then
424: p_rec.decision :=
425: ghr_cca_shd.g_old_rec.decision;
426: End If;
427: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
428: p_rec.dec_forwd_to_org :=
429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;

Line 429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;

425: ghr_cca_shd.g_old_rec.decision;
426: End If;
427: If (p_rec.dec_forwd_to_org = hr_api.g_date) then
428: p_rec.dec_forwd_to_org :=
429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;
430: End If;
431: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
432: p_rec.agency_rfr_suspense :=
433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;

Line 433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;

429: ghr_cca_shd.g_old_rec.dec_forwd_to_org;
430: End If;
431: If (p_rec.agency_rfr_suspense = hr_api.g_date) then
432: p_rec.agency_rfr_suspense :=
433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;
434: End If;
435: If (p_rec.request_for_rfr = hr_api.g_date) then
436: p_rec.request_for_rfr :=
437: ghr_cca_shd.g_old_rec.request_for_rfr;

Line 437: ghr_cca_shd.g_old_rec.request_for_rfr;

433: ghr_cca_shd.g_old_rec.agency_rfr_suspense;
434: End If;
435: If (p_rec.request_for_rfr = hr_api.g_date) then
436: p_rec.request_for_rfr :=
437: ghr_cca_shd.g_old_rec.request_for_rfr;
438: End If;
439: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
440: p_rec.rfr_docket_num :=
441: ghr_cca_shd.g_old_rec.rfr_docket_num;

Line 441: ghr_cca_shd.g_old_rec.rfr_docket_num;

437: ghr_cca_shd.g_old_rec.request_for_rfr;
438: End If;
439: If (p_rec.rfr_docket_num = hr_api.g_varchar2) then
440: p_rec.rfr_docket_num :=
441: ghr_cca_shd.g_old_rec.rfr_docket_num;
442: End If;
443: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
444: p_rec.rfr_requested_by :=
445: ghr_cca_shd.g_old_rec.rfr_requested_by;

Line 445: ghr_cca_shd.g_old_rec.rfr_requested_by;

441: ghr_cca_shd.g_old_rec.rfr_docket_num;
442: End If;
443: If (p_rec.rfr_requested_by = hr_api.g_varchar2) then
444: p_rec.rfr_requested_by :=
445: ghr_cca_shd.g_old_rec.rfr_requested_by;
446: End If;
447: If (p_rec.agency_rfr_due = hr_api.g_date) then
448: p_rec.agency_rfr_due :=
449: ghr_cca_shd.g_old_rec.agency_rfr_due;

Line 449: ghr_cca_shd.g_old_rec.agency_rfr_due;

445: ghr_cca_shd.g_old_rec.rfr_requested_by;
446: End If;
447: If (p_rec.agency_rfr_due = hr_api.g_date) then
448: p_rec.agency_rfr_due :=
449: ghr_cca_shd.g_old_rec.agency_rfr_due;
450: End If;
451: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
452: p_rec.rfr_forwd_to_org :=
453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;

Line 453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;

449: ghr_cca_shd.g_old_rec.agency_rfr_due;
450: End If;
451: If (p_rec.rfr_forwd_to_org = hr_api.g_date) then
452: p_rec.rfr_forwd_to_org :=
453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;
454: End If;
455: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
456: p_rec.org_forwd_rfr_to_agency :=
457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;

Line 457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;

453: ghr_cca_shd.g_old_rec.rfr_forwd_to_org;
454: End If;
455: If (p_rec.org_forwd_rfr_to_agency = hr_api.g_date) then
456: p_rec.org_forwd_rfr_to_agency :=
457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;
458: End If;
459: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
460: p_rec.agency_forwd_rfr_ofo :=
461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;

Line 461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;

457: ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency;
458: End If;
459: If (p_rec.agency_forwd_rfr_ofo = hr_api.g_date) then
460: p_rec.agency_forwd_rfr_ofo :=
461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;
462: End If;
463: If (p_rec.rfr_decision = hr_api.g_varchar2) then
464: p_rec.rfr_decision :=
465: ghr_cca_shd.g_old_rec.rfr_decision;

Line 465: ghr_cca_shd.g_old_rec.rfr_decision;

461: ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo;
462: End If;
463: If (p_rec.rfr_decision = hr_api.g_varchar2) then
464: p_rec.rfr_decision :=
465: ghr_cca_shd.g_old_rec.rfr_decision;
466: End If;
467: If (p_rec.rfr_decision_date = hr_api.g_date) then
468: p_rec.rfr_decision_date :=
469: ghr_cca_shd.g_old_rec.rfr_decision_date;

Line 469: ghr_cca_shd.g_old_rec.rfr_decision_date;

465: ghr_cca_shd.g_old_rec.rfr_decision;
466: End If;
467: If (p_rec.rfr_decision_date = hr_api.g_date) then
468: p_rec.rfr_decision_date :=
469: ghr_cca_shd.g_old_rec.rfr_decision_date;
470: End If;
471: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
472: p_rec.agency_recvd_rfr_dec :=
473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;

Line 473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;

469: ghr_cca_shd.g_old_rec.rfr_decision_date;
470: End If;
471: If (p_rec.agency_recvd_rfr_dec = hr_api.g_date) then
472: p_rec.agency_recvd_rfr_dec :=
473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;
474: End If;
475: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
476: p_rec.rfr_decision_forwd_to_org :=
477: ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org;

Line 477: ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org;

473: ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec;
474: End If;
475: If (p_rec.rfr_decision_forwd_to_org = hr_api.g_date) then
476: p_rec.rfr_decision_forwd_to_org :=
477: ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org;
478: End If;
479: --
480: End convert_defs;
481: --

Line 487: ,p_rec in out nocopy ghr_cca_shd.g_rec_type

483: -- |---------------------------------< upd >----------------------------------|
484: -- ----------------------------------------------------------------------------
485: Procedure upd
486: (p_effective_date in date
487: ,p_rec in out nocopy ghr_cca_shd.g_rec_type
488: ) is
489: --
490: l_proc varchar2(72) := g_package||'upd';
491: --

Line 497: ghr_cca_shd.lck

493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- We must lock the row which we need to update.
496: --
497: ghr_cca_shd.lck
498: (p_rec.compl_appeal_id
499: ,p_rec.object_version_number
500: );
501: --

Line 570: l_rec ghr_cca_shd.g_rec_type;

566: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
567: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
568: ) is
569: --
570: l_rec ghr_cca_shd.g_rec_type;
571: l_proc varchar2(72) := g_package||'upd';
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);

Line 580: ghr_cca_shd.convert_args

576: -- Call conversion function to turn arguments into the
577: -- l_rec structure.
578: --
579: l_rec :=
580: ghr_cca_shd.convert_args
581: (p_compl_appeal_id
582: ,p_complaint_id
583: ,p_appeal_date
584: ,p_appealed_to