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.BEN_RTS_DEL dependencies on BEN_RTS_SHD

Line 53: (p_rec in ben_rts_shd.g_rec_type

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

Line 63: ben_rts_shd.g_api_dml := true; -- Set the api dml status

59: if g_debug then
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: end if;
62: --
63: ben_rts_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Delete the ben_cwb_person_rates row.
66: --
67: delete from ben_cwb_person_rates

Line 72: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

68: where group_per_in_ler_id = p_rec.group_per_in_ler_id
69: and pl_id = p_rec.pl_id
70: and oipl_id = p_rec.oipl_id;
71: --
72: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
73: --
74: if g_debug then
75: hr_utility.set_location(' Leaving:'||l_proc, 10);
76: end if;

Line 81: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

77: --
78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
82: ben_rts_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

Line 82: ben_rts_shd.constraint_error

78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
82: ben_rts_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
86: Raise;

Line 85: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

81: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
82: ben_rts_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
86: Raise;
87: End delete_dml;
88: --
89: -- ----------------------------------------------------------------------------

Line 121: Procedure pre_delete(p_rec in ben_rts_shd.g_rec_type) is

117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in ben_rts_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin

Line 167: Procedure post_delete(p_rec in ben_rts_shd.g_rec_type) is

163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- -----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in ben_rts_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_delete';
170: --
171: Begin

Line 181: => ben_rts_shd.g_old_rec.group_per_in_ler_id

177: ben_rts_rkd.after_delete
178: (p_person_rate_id
179: => p_rec.person_rate_id
180: ,p_group_per_in_ler_id_o
181: => ben_rts_shd.g_old_rec.group_per_in_ler_id
182: ,p_pl_id_o
183: => ben_rts_shd.g_old_rec.pl_id
184: ,p_oipl_id_o
185: => ben_rts_shd.g_old_rec.oipl_id

Line 183: => ben_rts_shd.g_old_rec.pl_id

179: => p_rec.person_rate_id
180: ,p_group_per_in_ler_id_o
181: => ben_rts_shd.g_old_rec.group_per_in_ler_id
182: ,p_pl_id_o
183: => ben_rts_shd.g_old_rec.pl_id
184: ,p_oipl_id_o
185: => ben_rts_shd.g_old_rec.oipl_id
186: ,p_group_pl_id_o
187: => ben_rts_shd.g_old_rec.group_pl_id

Line 185: => ben_rts_shd.g_old_rec.oipl_id

181: => ben_rts_shd.g_old_rec.group_per_in_ler_id
182: ,p_pl_id_o
183: => ben_rts_shd.g_old_rec.pl_id
184: ,p_oipl_id_o
185: => ben_rts_shd.g_old_rec.oipl_id
186: ,p_group_pl_id_o
187: => ben_rts_shd.g_old_rec.group_pl_id
188: ,p_group_oipl_id_o
189: => ben_rts_shd.g_old_rec.group_oipl_id

Line 187: => ben_rts_shd.g_old_rec.group_pl_id

183: => ben_rts_shd.g_old_rec.pl_id
184: ,p_oipl_id_o
185: => ben_rts_shd.g_old_rec.oipl_id
186: ,p_group_pl_id_o
187: => ben_rts_shd.g_old_rec.group_pl_id
188: ,p_group_oipl_id_o
189: => ben_rts_shd.g_old_rec.group_oipl_id
190: ,p_lf_evt_ocrd_dt_o
191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt

Line 189: => ben_rts_shd.g_old_rec.group_oipl_id

185: => ben_rts_shd.g_old_rec.oipl_id
186: ,p_group_pl_id_o
187: => ben_rts_shd.g_old_rec.group_pl_id
188: ,p_group_oipl_id_o
189: => ben_rts_shd.g_old_rec.group_oipl_id
190: ,p_lf_evt_ocrd_dt_o
191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
192: ,p_person_id_o
193: => ben_rts_shd.g_old_rec.person_id

Line 191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt

187: => ben_rts_shd.g_old_rec.group_pl_id
188: ,p_group_oipl_id_o
189: => ben_rts_shd.g_old_rec.group_oipl_id
190: ,p_lf_evt_ocrd_dt_o
191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
192: ,p_person_id_o
193: => ben_rts_shd.g_old_rec.person_id
194: ,p_assignment_id_o
195: => ben_rts_shd.g_old_rec.assignment_id

Line 193: => ben_rts_shd.g_old_rec.person_id

189: => ben_rts_shd.g_old_rec.group_oipl_id
190: ,p_lf_evt_ocrd_dt_o
191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
192: ,p_person_id_o
193: => ben_rts_shd.g_old_rec.person_id
194: ,p_assignment_id_o
195: => ben_rts_shd.g_old_rec.assignment_id
196: ,p_elig_flag_o
197: => ben_rts_shd.g_old_rec.elig_flag

Line 195: => ben_rts_shd.g_old_rec.assignment_id

191: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
192: ,p_person_id_o
193: => ben_rts_shd.g_old_rec.person_id
194: ,p_assignment_id_o
195: => ben_rts_shd.g_old_rec.assignment_id
196: ,p_elig_flag_o
197: => ben_rts_shd.g_old_rec.elig_flag
198: ,p_ws_val_o
199: => ben_rts_shd.g_old_rec.ws_val

Line 197: => ben_rts_shd.g_old_rec.elig_flag

193: => ben_rts_shd.g_old_rec.person_id
194: ,p_assignment_id_o
195: => ben_rts_shd.g_old_rec.assignment_id
196: ,p_elig_flag_o
197: => ben_rts_shd.g_old_rec.elig_flag
198: ,p_ws_val_o
199: => ben_rts_shd.g_old_rec.ws_val
200: ,p_ws_mn_val_o
201: => ben_rts_shd.g_old_rec.ws_mn_val

Line 199: => ben_rts_shd.g_old_rec.ws_val

195: => ben_rts_shd.g_old_rec.assignment_id
196: ,p_elig_flag_o
197: => ben_rts_shd.g_old_rec.elig_flag
198: ,p_ws_val_o
199: => ben_rts_shd.g_old_rec.ws_val
200: ,p_ws_mn_val_o
201: => ben_rts_shd.g_old_rec.ws_mn_val
202: ,p_ws_mx_val_o
203: => ben_rts_shd.g_old_rec.ws_mx_val

Line 201: => ben_rts_shd.g_old_rec.ws_mn_val

197: => ben_rts_shd.g_old_rec.elig_flag
198: ,p_ws_val_o
199: => ben_rts_shd.g_old_rec.ws_val
200: ,p_ws_mn_val_o
201: => ben_rts_shd.g_old_rec.ws_mn_val
202: ,p_ws_mx_val_o
203: => ben_rts_shd.g_old_rec.ws_mx_val
204: ,p_ws_incr_val_o
205: => ben_rts_shd.g_old_rec.ws_incr_val

Line 203: => ben_rts_shd.g_old_rec.ws_mx_val

199: => ben_rts_shd.g_old_rec.ws_val
200: ,p_ws_mn_val_o
201: => ben_rts_shd.g_old_rec.ws_mn_val
202: ,p_ws_mx_val_o
203: => ben_rts_shd.g_old_rec.ws_mx_val
204: ,p_ws_incr_val_o
205: => ben_rts_shd.g_old_rec.ws_incr_val
206: ,p_elig_sal_val_o
207: => ben_rts_shd.g_old_rec.elig_sal_val

Line 205: => ben_rts_shd.g_old_rec.ws_incr_val

201: => ben_rts_shd.g_old_rec.ws_mn_val
202: ,p_ws_mx_val_o
203: => ben_rts_shd.g_old_rec.ws_mx_val
204: ,p_ws_incr_val_o
205: => ben_rts_shd.g_old_rec.ws_incr_val
206: ,p_elig_sal_val_o
207: => ben_rts_shd.g_old_rec.elig_sal_val
208: ,p_stat_sal_val_o
209: => ben_rts_shd.g_old_rec.stat_sal_val

Line 207: => ben_rts_shd.g_old_rec.elig_sal_val

203: => ben_rts_shd.g_old_rec.ws_mx_val
204: ,p_ws_incr_val_o
205: => ben_rts_shd.g_old_rec.ws_incr_val
206: ,p_elig_sal_val_o
207: => ben_rts_shd.g_old_rec.elig_sal_val
208: ,p_stat_sal_val_o
209: => ben_rts_shd.g_old_rec.stat_sal_val
210: ,p_oth_comp_val_o
211: => ben_rts_shd.g_old_rec.oth_comp_val

Line 209: => ben_rts_shd.g_old_rec.stat_sal_val

205: => ben_rts_shd.g_old_rec.ws_incr_val
206: ,p_elig_sal_val_o
207: => ben_rts_shd.g_old_rec.elig_sal_val
208: ,p_stat_sal_val_o
209: => ben_rts_shd.g_old_rec.stat_sal_val
210: ,p_oth_comp_val_o
211: => ben_rts_shd.g_old_rec.oth_comp_val
212: ,p_tot_comp_val_o
213: => ben_rts_shd.g_old_rec.tot_comp_val

Line 211: => ben_rts_shd.g_old_rec.oth_comp_val

207: => ben_rts_shd.g_old_rec.elig_sal_val
208: ,p_stat_sal_val_o
209: => ben_rts_shd.g_old_rec.stat_sal_val
210: ,p_oth_comp_val_o
211: => ben_rts_shd.g_old_rec.oth_comp_val
212: ,p_tot_comp_val_o
213: => ben_rts_shd.g_old_rec.tot_comp_val
214: ,p_misc1_val_o
215: => ben_rts_shd.g_old_rec.misc1_val

Line 213: => ben_rts_shd.g_old_rec.tot_comp_val

209: => ben_rts_shd.g_old_rec.stat_sal_val
210: ,p_oth_comp_val_o
211: => ben_rts_shd.g_old_rec.oth_comp_val
212: ,p_tot_comp_val_o
213: => ben_rts_shd.g_old_rec.tot_comp_val
214: ,p_misc1_val_o
215: => ben_rts_shd.g_old_rec.misc1_val
216: ,p_misc2_val_o
217: => ben_rts_shd.g_old_rec.misc2_val

Line 215: => ben_rts_shd.g_old_rec.misc1_val

211: => ben_rts_shd.g_old_rec.oth_comp_val
212: ,p_tot_comp_val_o
213: => ben_rts_shd.g_old_rec.tot_comp_val
214: ,p_misc1_val_o
215: => ben_rts_shd.g_old_rec.misc1_val
216: ,p_misc2_val_o
217: => ben_rts_shd.g_old_rec.misc2_val
218: ,p_misc3_val_o
219: => ben_rts_shd.g_old_rec.misc3_val

Line 217: => ben_rts_shd.g_old_rec.misc2_val

213: => ben_rts_shd.g_old_rec.tot_comp_val
214: ,p_misc1_val_o
215: => ben_rts_shd.g_old_rec.misc1_val
216: ,p_misc2_val_o
217: => ben_rts_shd.g_old_rec.misc2_val
218: ,p_misc3_val_o
219: => ben_rts_shd.g_old_rec.misc3_val
220: ,p_rec_val_o
221: => ben_rts_shd.g_old_rec.rec_val

Line 219: => ben_rts_shd.g_old_rec.misc3_val

215: => ben_rts_shd.g_old_rec.misc1_val
216: ,p_misc2_val_o
217: => ben_rts_shd.g_old_rec.misc2_val
218: ,p_misc3_val_o
219: => ben_rts_shd.g_old_rec.misc3_val
220: ,p_rec_val_o
221: => ben_rts_shd.g_old_rec.rec_val
222: ,p_rec_mn_val_o
223: => ben_rts_shd.g_old_rec.rec_mn_val

Line 221: => ben_rts_shd.g_old_rec.rec_val

217: => ben_rts_shd.g_old_rec.misc2_val
218: ,p_misc3_val_o
219: => ben_rts_shd.g_old_rec.misc3_val
220: ,p_rec_val_o
221: => ben_rts_shd.g_old_rec.rec_val
222: ,p_rec_mn_val_o
223: => ben_rts_shd.g_old_rec.rec_mn_val
224: ,p_rec_mx_val_o
225: => ben_rts_shd.g_old_rec.rec_mx_val

Line 223: => ben_rts_shd.g_old_rec.rec_mn_val

219: => ben_rts_shd.g_old_rec.misc3_val
220: ,p_rec_val_o
221: => ben_rts_shd.g_old_rec.rec_val
222: ,p_rec_mn_val_o
223: => ben_rts_shd.g_old_rec.rec_mn_val
224: ,p_rec_mx_val_o
225: => ben_rts_shd.g_old_rec.rec_mx_val
226: ,p_rec_incr_val_o
227: => ben_rts_shd.g_old_rec.rec_incr_val

Line 225: => ben_rts_shd.g_old_rec.rec_mx_val

221: => ben_rts_shd.g_old_rec.rec_val
222: ,p_rec_mn_val_o
223: => ben_rts_shd.g_old_rec.rec_mn_val
224: ,p_rec_mx_val_o
225: => ben_rts_shd.g_old_rec.rec_mx_val
226: ,p_rec_incr_val_o
227: => ben_rts_shd.g_old_rec.rec_incr_val
228: ,p_ws_val_last_upd_date_o
229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date

Line 227: => ben_rts_shd.g_old_rec.rec_incr_val

223: => ben_rts_shd.g_old_rec.rec_mn_val
224: ,p_rec_mx_val_o
225: => ben_rts_shd.g_old_rec.rec_mx_val
226: ,p_rec_incr_val_o
227: => ben_rts_shd.g_old_rec.rec_incr_val
228: ,p_ws_val_last_upd_date_o
229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
230: ,p_ws_val_last_upd_by_o
231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by

Line 229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date

225: => ben_rts_shd.g_old_rec.rec_mx_val
226: ,p_rec_incr_val_o
227: => ben_rts_shd.g_old_rec.rec_incr_val
228: ,p_ws_val_last_upd_date_o
229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
230: ,p_ws_val_last_upd_by_o
231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
232: ,p_pay_proposal_id_o
233: => ben_rts_shd.g_old_rec.pay_proposal_id

Line 231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by

227: => ben_rts_shd.g_old_rec.rec_incr_val
228: ,p_ws_val_last_upd_date_o
229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
230: ,p_ws_val_last_upd_by_o
231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
232: ,p_pay_proposal_id_o
233: => ben_rts_shd.g_old_rec.pay_proposal_id
234: ,p_element_entry_value_id_o
235: => ben_rts_shd.g_old_rec.element_entry_value_id

Line 233: => ben_rts_shd.g_old_rec.pay_proposal_id

229: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
230: ,p_ws_val_last_upd_by_o
231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
232: ,p_pay_proposal_id_o
233: => ben_rts_shd.g_old_rec.pay_proposal_id
234: ,p_element_entry_value_id_o
235: => ben_rts_shd.g_old_rec.element_entry_value_id
236: ,p_inelig_rsn_cd_o
237: => ben_rts_shd.g_old_rec.inelig_rsn_cd

Line 235: => ben_rts_shd.g_old_rec.element_entry_value_id

231: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
232: ,p_pay_proposal_id_o
233: => ben_rts_shd.g_old_rec.pay_proposal_id
234: ,p_element_entry_value_id_o
235: => ben_rts_shd.g_old_rec.element_entry_value_id
236: ,p_inelig_rsn_cd_o
237: => ben_rts_shd.g_old_rec.inelig_rsn_cd
238: ,p_elig_ovrid_dt_o
239: => ben_rts_shd.g_old_rec.elig_ovrid_dt

Line 237: => ben_rts_shd.g_old_rec.inelig_rsn_cd

233: => ben_rts_shd.g_old_rec.pay_proposal_id
234: ,p_element_entry_value_id_o
235: => ben_rts_shd.g_old_rec.element_entry_value_id
236: ,p_inelig_rsn_cd_o
237: => ben_rts_shd.g_old_rec.inelig_rsn_cd
238: ,p_elig_ovrid_dt_o
239: => ben_rts_shd.g_old_rec.elig_ovrid_dt
240: ,p_elig_ovrid_person_id_o
241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id

Line 239: => ben_rts_shd.g_old_rec.elig_ovrid_dt

235: => ben_rts_shd.g_old_rec.element_entry_value_id
236: ,p_inelig_rsn_cd_o
237: => ben_rts_shd.g_old_rec.inelig_rsn_cd
238: ,p_elig_ovrid_dt_o
239: => ben_rts_shd.g_old_rec.elig_ovrid_dt
240: ,p_elig_ovrid_person_id_o
241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
242: ,p_copy_dist_bdgt_val_o
243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val

Line 241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id

237: => ben_rts_shd.g_old_rec.inelig_rsn_cd
238: ,p_elig_ovrid_dt_o
239: => ben_rts_shd.g_old_rec.elig_ovrid_dt
240: ,p_elig_ovrid_person_id_o
241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
242: ,p_copy_dist_bdgt_val_o
243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
244: ,p_copy_ws_bdgt_val_o
245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val

Line 243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val

239: => ben_rts_shd.g_old_rec.elig_ovrid_dt
240: ,p_elig_ovrid_person_id_o
241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
242: ,p_copy_dist_bdgt_val_o
243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
244: ,p_copy_ws_bdgt_val_o
245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
246: ,p_copy_rsrv_val_o
247: => ben_rts_shd.g_old_rec.copy_rsrv_val

Line 245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val

241: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
242: ,p_copy_dist_bdgt_val_o
243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
244: ,p_copy_ws_bdgt_val_o
245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
246: ,p_copy_rsrv_val_o
247: => ben_rts_shd.g_old_rec.copy_rsrv_val
248: ,p_copy_dist_bdgt_mn_val_o
249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val

Line 247: => ben_rts_shd.g_old_rec.copy_rsrv_val

243: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
244: ,p_copy_ws_bdgt_val_o
245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
246: ,p_copy_rsrv_val_o
247: => ben_rts_shd.g_old_rec.copy_rsrv_val
248: ,p_copy_dist_bdgt_mn_val_o
249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
250: ,p_copy_dist_bdgt_mx_val_o
251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val

Line 249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val

245: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
246: ,p_copy_rsrv_val_o
247: => ben_rts_shd.g_old_rec.copy_rsrv_val
248: ,p_copy_dist_bdgt_mn_val_o
249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
250: ,p_copy_dist_bdgt_mx_val_o
251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
252: ,p_copy_dist_bdgt_incr_val_o
253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val

Line 251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val

247: => ben_rts_shd.g_old_rec.copy_rsrv_val
248: ,p_copy_dist_bdgt_mn_val_o
249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
250: ,p_copy_dist_bdgt_mx_val_o
251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
252: ,p_copy_dist_bdgt_incr_val_o
253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
254: ,p_copy_ws_bdgt_mn_val_o
255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val

Line 253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val

249: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
250: ,p_copy_dist_bdgt_mx_val_o
251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
252: ,p_copy_dist_bdgt_incr_val_o
253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
254: ,p_copy_ws_bdgt_mn_val_o
255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
256: ,p_copy_ws_bdgt_mx_val_o
257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val

Line 255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val

251: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
252: ,p_copy_dist_bdgt_incr_val_o
253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
254: ,p_copy_ws_bdgt_mn_val_o
255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
256: ,p_copy_ws_bdgt_mx_val_o
257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
258: ,p_copy_ws_bdgt_incr_val_o
259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val

Line 257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val

253: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
254: ,p_copy_ws_bdgt_mn_val_o
255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
256: ,p_copy_ws_bdgt_mx_val_o
257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
258: ,p_copy_ws_bdgt_incr_val_o
259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
260: ,p_copy_rsrv_mn_val_o
261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val

Line 259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val

255: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
256: ,p_copy_ws_bdgt_mx_val_o
257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
258: ,p_copy_ws_bdgt_incr_val_o
259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
260: ,p_copy_rsrv_mn_val_o
261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
262: ,p_copy_rsrv_mx_val_o
263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val

Line 261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val

257: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
258: ,p_copy_ws_bdgt_incr_val_o
259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
260: ,p_copy_rsrv_mn_val_o
261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
262: ,p_copy_rsrv_mx_val_o
263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
264: ,p_copy_rsrv_incr_val_o
265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val

Line 263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val

259: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
260: ,p_copy_rsrv_mn_val_o
261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
262: ,p_copy_rsrv_mx_val_o
263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
264: ,p_copy_rsrv_incr_val_o
265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
266: ,p_copy_dist_bdgt_iss_val_o
267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val

Line 265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val

261: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
262: ,p_copy_rsrv_mx_val_o
263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
264: ,p_copy_rsrv_incr_val_o
265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
266: ,p_copy_dist_bdgt_iss_val_o
267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
268: ,p_copy_ws_bdgt_iss_val_o
269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val

Line 267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val

263: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
264: ,p_copy_rsrv_incr_val_o
265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
266: ,p_copy_dist_bdgt_iss_val_o
267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
268: ,p_copy_ws_bdgt_iss_val_o
269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
270: ,p_copy_dist_bdgt_iss_date_o
271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date

Line 269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val

265: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
266: ,p_copy_dist_bdgt_iss_val_o
267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
268: ,p_copy_ws_bdgt_iss_val_o
269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
270: ,p_copy_dist_bdgt_iss_date_o
271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
272: ,p_copy_ws_bdgt_iss_date_o
273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date

Line 271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date

267: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
268: ,p_copy_ws_bdgt_iss_val_o
269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
270: ,p_copy_dist_bdgt_iss_date_o
271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
272: ,p_copy_ws_bdgt_iss_date_o
273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
274: ,p_comp_posting_date_o
275: => ben_rts_shd.g_old_rec.comp_posting_date

Line 273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date

269: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
270: ,p_copy_dist_bdgt_iss_date_o
271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
272: ,p_copy_ws_bdgt_iss_date_o
273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
274: ,p_comp_posting_date_o
275: => ben_rts_shd.g_old_rec.comp_posting_date
276: ,p_ws_rt_start_date_o
277: => ben_rts_shd.g_old_rec.ws_rt_start_date

Line 275: => ben_rts_shd.g_old_rec.comp_posting_date

271: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
272: ,p_copy_ws_bdgt_iss_date_o
273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
274: ,p_comp_posting_date_o
275: => ben_rts_shd.g_old_rec.comp_posting_date
276: ,p_ws_rt_start_date_o
277: => ben_rts_shd.g_old_rec.ws_rt_start_date
278: ,p_currency_o
279: => ben_rts_shd.g_old_rec.currency

Line 277: => ben_rts_shd.g_old_rec.ws_rt_start_date

273: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
274: ,p_comp_posting_date_o
275: => ben_rts_shd.g_old_rec.comp_posting_date
276: ,p_ws_rt_start_date_o
277: => ben_rts_shd.g_old_rec.ws_rt_start_date
278: ,p_currency_o
279: => ben_rts_shd.g_old_rec.currency
280: ,p_object_version_number_o
281: => ben_rts_shd.g_old_rec.object_version_number

Line 279: => ben_rts_shd.g_old_rec.currency

275: => ben_rts_shd.g_old_rec.comp_posting_date
276: ,p_ws_rt_start_date_o
277: => ben_rts_shd.g_old_rec.ws_rt_start_date
278: ,p_currency_o
279: => ben_rts_shd.g_old_rec.currency
280: ,p_object_version_number_o
281: => ben_rts_shd.g_old_rec.object_version_number
282: );
283: --

Line 281: => ben_rts_shd.g_old_rec.object_version_number

277: => ben_rts_shd.g_old_rec.ws_rt_start_date
278: ,p_currency_o
279: => ben_rts_shd.g_old_rec.currency
280: ,p_object_version_number_o
281: => ben_rts_shd.g_old_rec.object_version_number
282: );
283: --
284: exception
285: --

Line 303: (p_rec in ben_rts_shd.g_rec_type

299: -- ----------------------------------------------------------------------------
300: -- |---------------------------------< del >----------------------------------|
301: -- ----------------------------------------------------------------------------
302: Procedure del
303: (p_rec in ben_rts_shd.g_rec_type
304: ) is
305: --
306: l_proc varchar2(72) := g_package||'del';
307: --

Line 315: ben_rts_shd.lck

311: end if;
312: --
313: -- We must lock the row which we need to delete.
314: --
315: ben_rts_shd.lck
316: (p_rec.group_per_in_ler_id
317: ,p_rec.pl_id
318: ,p_rec.oipl_id
319: ,p_rec.object_version_number

Line 356: l_rec ben_rts_shd.g_rec_type;

352: ,p_oipl_id in number
353: ,p_object_version_number in number
354: ) is
355: --
356: l_rec ben_rts_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'del';
358: --
359: Begin
360: if g_debug then