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

Line 52: (p_rec in ghr_cca_shd.g_rec_type

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

Line 75: ghr_cca_shd.constraint_error

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

162: begin
163: --
164: ghr_cca_rkd.after_delete
165: (p_compl_appeal_id => p_rec.compl_appeal_id
166: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date

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

163: --
164: ghr_cca_rkd.after_delete
165: (p_compl_appeal_id => p_rec.compl_appeal_id
166: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num

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

164: ghr_cca_rkd.after_delete
165: (p_compl_appeal_id => p_rec.compl_appeal_id
166: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal

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

165: (p_compl_appeal_id => p_rec.compl_appeal_id
166: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files

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

166: ,p_complaint_id_o => ghr_cca_shd.g_old_rec.complaint_id
167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due

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

167: ,p_appeal_date_o => ghr_cca_shd.g_old_rec.appeal_date
168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd

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

168: ,p_appealed_to_o => ghr_cca_shd.g_old_rec.appealed_to
169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief

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

169: ,p_reason_for_appeal_o => ghr_cca_shd.g_old_rec.reason_for_appeal
170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due

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

170: ,p_source_decision_date_o => ghr_cca_shd.g_old_rec.source_decision_date
171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org

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

171: ,p_docket_num_o => ghr_cca_shd.g_old_rec.docket_num
172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency

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

172: ,p_org_notified_of_appeal_o => ghr_cca_shd.g_old_rec.org_notified_of_appeal
173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd

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

173: ,p_agency_recvd_req_for_files_o => ghr_cca_shd.g_old_rec.agency_recvd_req_for_files
174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date

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

174: ,p_files_due_o => ghr_cca_shd.g_old_rec.files_due
175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency

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

175: ,p_files_forwd_o => ghr_cca_shd.g_old_rec.files_forwd
176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision

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

176: ,p_agcy_recvd_appellant_brief_o => ghr_cca_shd.g_old_rec.agcy_recvd_appellant_brief
177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org

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

177: ,p_agency_brief_due_o => ghr_cca_shd.g_old_rec.agency_brief_due
178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense

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

178: ,p_appellant_brief_forwd_org_o => ghr_cca_shd.g_old_rec.appellant_brief_forwd_org
179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr

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

179: ,p_org_forwd_brief_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_brief_to_agency
180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num

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

180: ,p_agency_brief_forwd_o => ghr_cca_shd.g_old_rec.agency_brief_forwd
181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by

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

181: ,p_decision_date_o => ghr_cca_shd.g_old_rec.decision_date
182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due

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

182: ,p_dec_recvd_by_agency_o => ghr_cca_shd.g_old_rec.dec_recvd_by_agency
183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org

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

183: ,p_decision_o => ghr_cca_shd.g_old_rec.decision
184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency

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

184: ,p_dec_forwd_to_org_o => ghr_cca_shd.g_old_rec.dec_forwd_to_org
185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo

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

185: ,p_agency_rfr_suspense_o => ghr_cca_shd.g_old_rec.agency_rfr_suspense
186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision

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

186: ,p_request_for_rfr_o => ghr_cca_shd.g_old_rec.request_for_rfr
187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date

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

187: ,p_rfr_docket_num_o => ghr_cca_shd.g_old_rec.rfr_docket_num
188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec

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

188: ,p_rfr_requested_by_o => ghr_cca_shd.g_old_rec.rfr_requested_by
189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org

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

189: ,p_agency_rfr_due_o => ghr_cca_shd.g_old_rec.agency_rfr_due
190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
197: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number

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

190: ,p_rfr_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_forwd_to_org
191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
197: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
198: );

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

191: ,p_org_forwd_rfr_to_agency_o => ghr_cca_shd.g_old_rec.org_forwd_rfr_to_agency
192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
197: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
198: );
199: --

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

192: ,p_agency_forwd_rfr_ofo_o => ghr_cca_shd.g_old_rec.agency_forwd_rfr_ofo
193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
197: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
198: );
199: --
200: exception

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

193: ,p_rfr_decision_o => ghr_cca_shd.g_old_rec.rfr_decision
194: ,p_rfr_decision_date_o => ghr_cca_shd.g_old_rec.rfr_decision_date
195: ,p_agency_recvd_rfr_dec_o => ghr_cca_shd.g_old_rec.agency_recvd_rfr_dec
196: ,p_rfr_decision_forwd_to_org_o => ghr_cca_shd.g_old_rec.rfr_decision_forwd_to_org
197: ,p_object_version_number_o => ghr_cca_shd.g_old_rec.object_version_number
198: );
199: --
200: exception
201: --

Line 217: (p_rec in ghr_cca_shd.g_rec_type

213: -- ----------------------------------------------------------------------------
214: -- |---------------------------------< del >----------------------------------|
215: -- ----------------------------------------------------------------------------
216: Procedure del
217: (p_rec in ghr_cca_shd.g_rec_type
218: ) is
219: --
220: l_proc varchar2(72) := g_package||'del';
221: --

Line 227: ghr_cca_shd.lck

223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: -- We must lock the row which we need to delete.
226: --
227: ghr_cca_shd.lck
228: (p_rec.compl_appeal_id
229: ,p_rec.object_version_number
230: );
231: --

Line 258: l_rec ghr_cca_shd.g_rec_type;

254: (p_compl_appeal_id in number
255: ,p_object_version_number in number
256: ) is
257: --
258: l_rec ghr_cca_shd.g_rec_type;
259: l_proc varchar2(72) := g_package||'del';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);