[Home] [Help]
49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in ben_cpg_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --
59: if g_debug then
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: end if;
62: --
63: ben_cpg_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Delete the ben_cwb_person_groups row.
66: --
67: delete from ben_cwb_person_groups
68: where group_per_in_ler_id = p_rec.group_per_in_ler_id
69: and group_pl_id = p_rec.group_pl_id
70: and group_oipl_id = p_rec.group_oipl_id;
71: --
72: ben_cpg_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;
77: --
78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
82: ben_cpg_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
82: ben_cpg_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
86: Raise;
81: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
82: ben_cpg_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
86: Raise;
87: End delete_dml;
88: --
89: -- ----------------------------------------------------------------------------
117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in ben_cpg_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin
163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- -----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in ben_cpg_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_delete';
170: --
171: Begin
181: => p_rec.group_pl_id
182: ,p_group_oipl_id
183: => p_rec.group_oipl_id
184: ,p_lf_evt_ocrd_dt_o
185: => ben_cpg_shd.g_old_rec.lf_evt_ocrd_dt
186: ,p_bdgt_pop_cd_o
187: => ben_cpg_shd.g_old_rec.bdgt_pop_cd
188: ,p_due_dt_o
189: => ben_cpg_shd.g_old_rec.due_dt
183: => p_rec.group_oipl_id
184: ,p_lf_evt_ocrd_dt_o
185: => ben_cpg_shd.g_old_rec.lf_evt_ocrd_dt
186: ,p_bdgt_pop_cd_o
187: => ben_cpg_shd.g_old_rec.bdgt_pop_cd
188: ,p_due_dt_o
189: => ben_cpg_shd.g_old_rec.due_dt
190: ,p_access_cd_o
191: => ben_cpg_shd.g_old_rec.access_cd
185: => ben_cpg_shd.g_old_rec.lf_evt_ocrd_dt
186: ,p_bdgt_pop_cd_o
187: => ben_cpg_shd.g_old_rec.bdgt_pop_cd
188: ,p_due_dt_o
189: => ben_cpg_shd.g_old_rec.due_dt
190: ,p_access_cd_o
191: => ben_cpg_shd.g_old_rec.access_cd
192: ,p_approval_cd_o
193: => ben_cpg_shd.g_old_rec.approval_cd
187: => ben_cpg_shd.g_old_rec.bdgt_pop_cd
188: ,p_due_dt_o
189: => ben_cpg_shd.g_old_rec.due_dt
190: ,p_access_cd_o
191: => ben_cpg_shd.g_old_rec.access_cd
192: ,p_approval_cd_o
193: => ben_cpg_shd.g_old_rec.approval_cd
194: ,p_approval_date_o
195: => ben_cpg_shd.g_old_rec.approval_date
189: => ben_cpg_shd.g_old_rec.due_dt
190: ,p_access_cd_o
191: => ben_cpg_shd.g_old_rec.access_cd
192: ,p_approval_cd_o
193: => ben_cpg_shd.g_old_rec.approval_cd
194: ,p_approval_date_o
195: => ben_cpg_shd.g_old_rec.approval_date
196: ,p_approval_comments_o
197: => ben_cpg_shd.g_old_rec.approval_comments
191: => ben_cpg_shd.g_old_rec.access_cd
192: ,p_approval_cd_o
193: => ben_cpg_shd.g_old_rec.approval_cd
194: ,p_approval_date_o
195: => ben_cpg_shd.g_old_rec.approval_date
196: ,p_approval_comments_o
197: => ben_cpg_shd.g_old_rec.approval_comments
198: ,p_submit_cd_o
199: => ben_cpg_shd.g_old_rec.submit_cd
193: => ben_cpg_shd.g_old_rec.approval_cd
194: ,p_approval_date_o
195: => ben_cpg_shd.g_old_rec.approval_date
196: ,p_approval_comments_o
197: => ben_cpg_shd.g_old_rec.approval_comments
198: ,p_submit_cd_o
199: => ben_cpg_shd.g_old_rec.submit_cd
200: ,p_submit_date_o
201: => ben_cpg_shd.g_old_rec.submit_date
195: => ben_cpg_shd.g_old_rec.approval_date
196: ,p_approval_comments_o
197: => ben_cpg_shd.g_old_rec.approval_comments
198: ,p_submit_cd_o
199: => ben_cpg_shd.g_old_rec.submit_cd
200: ,p_submit_date_o
201: => ben_cpg_shd.g_old_rec.submit_date
202: ,p_submit_comments_o
203: => ben_cpg_shd.g_old_rec.submit_comments
197: => ben_cpg_shd.g_old_rec.approval_comments
198: ,p_submit_cd_o
199: => ben_cpg_shd.g_old_rec.submit_cd
200: ,p_submit_date_o
201: => ben_cpg_shd.g_old_rec.submit_date
202: ,p_submit_comments_o
203: => ben_cpg_shd.g_old_rec.submit_comments
204: ,p_dist_bdgt_val_o
205: => ben_cpg_shd.g_old_rec.dist_bdgt_val
199: => ben_cpg_shd.g_old_rec.submit_cd
200: ,p_submit_date_o
201: => ben_cpg_shd.g_old_rec.submit_date
202: ,p_submit_comments_o
203: => ben_cpg_shd.g_old_rec.submit_comments
204: ,p_dist_bdgt_val_o
205: => ben_cpg_shd.g_old_rec.dist_bdgt_val
206: ,p_ws_bdgt_val_o
207: => ben_cpg_shd.g_old_rec.ws_bdgt_val
201: => ben_cpg_shd.g_old_rec.submit_date
202: ,p_submit_comments_o
203: => ben_cpg_shd.g_old_rec.submit_comments
204: ,p_dist_bdgt_val_o
205: => ben_cpg_shd.g_old_rec.dist_bdgt_val
206: ,p_ws_bdgt_val_o
207: => ben_cpg_shd.g_old_rec.ws_bdgt_val
208: ,p_rsrv_val_o
209: => ben_cpg_shd.g_old_rec.rsrv_val
203: => ben_cpg_shd.g_old_rec.submit_comments
204: ,p_dist_bdgt_val_o
205: => ben_cpg_shd.g_old_rec.dist_bdgt_val
206: ,p_ws_bdgt_val_o
207: => ben_cpg_shd.g_old_rec.ws_bdgt_val
208: ,p_rsrv_val_o
209: => ben_cpg_shd.g_old_rec.rsrv_val
210: ,p_dist_bdgt_mn_val_o
211: => ben_cpg_shd.g_old_rec.dist_bdgt_mn_val
205: => ben_cpg_shd.g_old_rec.dist_bdgt_val
206: ,p_ws_bdgt_val_o
207: => ben_cpg_shd.g_old_rec.ws_bdgt_val
208: ,p_rsrv_val_o
209: => ben_cpg_shd.g_old_rec.rsrv_val
210: ,p_dist_bdgt_mn_val_o
211: => ben_cpg_shd.g_old_rec.dist_bdgt_mn_val
212: ,p_dist_bdgt_mx_val_o
213: => ben_cpg_shd.g_old_rec.dist_bdgt_mx_val
207: => ben_cpg_shd.g_old_rec.ws_bdgt_val
208: ,p_rsrv_val_o
209: => ben_cpg_shd.g_old_rec.rsrv_val
210: ,p_dist_bdgt_mn_val_o
211: => ben_cpg_shd.g_old_rec.dist_bdgt_mn_val
212: ,p_dist_bdgt_mx_val_o
213: => ben_cpg_shd.g_old_rec.dist_bdgt_mx_val
214: ,p_dist_bdgt_incr_val_o
215: => ben_cpg_shd.g_old_rec.dist_bdgt_incr_val
209: => ben_cpg_shd.g_old_rec.rsrv_val
210: ,p_dist_bdgt_mn_val_o
211: => ben_cpg_shd.g_old_rec.dist_bdgt_mn_val
212: ,p_dist_bdgt_mx_val_o
213: => ben_cpg_shd.g_old_rec.dist_bdgt_mx_val
214: ,p_dist_bdgt_incr_val_o
215: => ben_cpg_shd.g_old_rec.dist_bdgt_incr_val
216: ,p_ws_bdgt_mn_val_o
217: => ben_cpg_shd.g_old_rec.ws_bdgt_mn_val
211: => ben_cpg_shd.g_old_rec.dist_bdgt_mn_val
212: ,p_dist_bdgt_mx_val_o
213: => ben_cpg_shd.g_old_rec.dist_bdgt_mx_val
214: ,p_dist_bdgt_incr_val_o
215: => ben_cpg_shd.g_old_rec.dist_bdgt_incr_val
216: ,p_ws_bdgt_mn_val_o
217: => ben_cpg_shd.g_old_rec.ws_bdgt_mn_val
218: ,p_ws_bdgt_mx_val_o
219: => ben_cpg_shd.g_old_rec.ws_bdgt_mx_val
213: => ben_cpg_shd.g_old_rec.dist_bdgt_mx_val
214: ,p_dist_bdgt_incr_val_o
215: => ben_cpg_shd.g_old_rec.dist_bdgt_incr_val
216: ,p_ws_bdgt_mn_val_o
217: => ben_cpg_shd.g_old_rec.ws_bdgt_mn_val
218: ,p_ws_bdgt_mx_val_o
219: => ben_cpg_shd.g_old_rec.ws_bdgt_mx_val
220: ,p_ws_bdgt_incr_val_o
221: => ben_cpg_shd.g_old_rec.ws_bdgt_incr_val
215: => ben_cpg_shd.g_old_rec.dist_bdgt_incr_val
216: ,p_ws_bdgt_mn_val_o
217: => ben_cpg_shd.g_old_rec.ws_bdgt_mn_val
218: ,p_ws_bdgt_mx_val_o
219: => ben_cpg_shd.g_old_rec.ws_bdgt_mx_val
220: ,p_ws_bdgt_incr_val_o
221: => ben_cpg_shd.g_old_rec.ws_bdgt_incr_val
222: ,p_rsrv_mn_val_o
223: => ben_cpg_shd.g_old_rec.rsrv_mn_val
217: => ben_cpg_shd.g_old_rec.ws_bdgt_mn_val
218: ,p_ws_bdgt_mx_val_o
219: => ben_cpg_shd.g_old_rec.ws_bdgt_mx_val
220: ,p_ws_bdgt_incr_val_o
221: => ben_cpg_shd.g_old_rec.ws_bdgt_incr_val
222: ,p_rsrv_mn_val_o
223: => ben_cpg_shd.g_old_rec.rsrv_mn_val
224: ,p_rsrv_mx_val_o
225: => ben_cpg_shd.g_old_rec.rsrv_mx_val
219: => ben_cpg_shd.g_old_rec.ws_bdgt_mx_val
220: ,p_ws_bdgt_incr_val_o
221: => ben_cpg_shd.g_old_rec.ws_bdgt_incr_val
222: ,p_rsrv_mn_val_o
223: => ben_cpg_shd.g_old_rec.rsrv_mn_val
224: ,p_rsrv_mx_val_o
225: => ben_cpg_shd.g_old_rec.rsrv_mx_val
226: ,p_rsrv_incr_val_o
227: => ben_cpg_shd.g_old_rec.rsrv_incr_val
221: => ben_cpg_shd.g_old_rec.ws_bdgt_incr_val
222: ,p_rsrv_mn_val_o
223: => ben_cpg_shd.g_old_rec.rsrv_mn_val
224: ,p_rsrv_mx_val_o
225: => ben_cpg_shd.g_old_rec.rsrv_mx_val
226: ,p_rsrv_incr_val_o
227: => ben_cpg_shd.g_old_rec.rsrv_incr_val
228: ,p_dist_bdgt_iss_val_o
229: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_val
223: => ben_cpg_shd.g_old_rec.rsrv_mn_val
224: ,p_rsrv_mx_val_o
225: => ben_cpg_shd.g_old_rec.rsrv_mx_val
226: ,p_rsrv_incr_val_o
227: => ben_cpg_shd.g_old_rec.rsrv_incr_val
228: ,p_dist_bdgt_iss_val_o
229: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_val
230: ,p_ws_bdgt_iss_val_o
231: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_val
225: => ben_cpg_shd.g_old_rec.rsrv_mx_val
226: ,p_rsrv_incr_val_o
227: => ben_cpg_shd.g_old_rec.rsrv_incr_val
228: ,p_dist_bdgt_iss_val_o
229: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_val
230: ,p_ws_bdgt_iss_val_o
231: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_val
232: ,p_dist_bdgt_iss_date_o
233: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_date
227: => ben_cpg_shd.g_old_rec.rsrv_incr_val
228: ,p_dist_bdgt_iss_val_o
229: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_val
230: ,p_ws_bdgt_iss_val_o
231: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_val
232: ,p_dist_bdgt_iss_date_o
233: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_date
234: ,p_ws_bdgt_iss_date_o
235: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_date
229: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_val
230: ,p_ws_bdgt_iss_val_o
231: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_val
232: ,p_dist_bdgt_iss_date_o
233: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_date
234: ,p_ws_bdgt_iss_date_o
235: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_date
236: ,p_ws_bdgt_val_last_upd_date_o
237: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date
231: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_val
232: ,p_dist_bdgt_iss_date_o
233: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_date
234: ,p_ws_bdgt_iss_date_o
235: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_date
236: ,p_ws_bdgt_val_last_upd_date_o
237: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date
238: ,p_dist_bdgt_val_last_upd_dat_o
239: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date
233: => ben_cpg_shd.g_old_rec.dist_bdgt_iss_date
234: ,p_ws_bdgt_iss_date_o
235: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_date
236: ,p_ws_bdgt_val_last_upd_date_o
237: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date
238: ,p_dist_bdgt_val_last_upd_dat_o
239: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date
240: ,p_rsrv_val_last_upd_date_o
241: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date
235: => ben_cpg_shd.g_old_rec.ws_bdgt_iss_date
236: ,p_ws_bdgt_val_last_upd_date_o
237: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date
238: ,p_dist_bdgt_val_last_upd_dat_o
239: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date
240: ,p_rsrv_val_last_upd_date_o
241: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date
242: ,p_ws_bdgt_val_last_upd_by_o
243: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by
237: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date
238: ,p_dist_bdgt_val_last_upd_dat_o
239: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date
240: ,p_rsrv_val_last_upd_date_o
241: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date
242: ,p_ws_bdgt_val_last_upd_by_o
243: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by
244: ,p_dist_bdgt_val_last_upd_by_o
245: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by
239: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date
240: ,p_rsrv_val_last_upd_date_o
241: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date
242: ,p_ws_bdgt_val_last_upd_by_o
243: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by
244: ,p_dist_bdgt_val_last_upd_by_o
245: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by
246: ,p_rsrv_val_last_upd_by_o
247: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_by
241: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date
242: ,p_ws_bdgt_val_last_upd_by_o
243: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by
244: ,p_dist_bdgt_val_last_upd_by_o
245: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by
246: ,p_rsrv_val_last_upd_by_o
247: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_by
248: ,p_object_version_number_o
249: => ben_cpg_shd.g_old_rec.object_version_number
243: => ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by
244: ,p_dist_bdgt_val_last_upd_by_o
245: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by
246: ,p_rsrv_val_last_upd_by_o
247: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_by
248: ,p_object_version_number_o
249: => ben_cpg_shd.g_old_rec.object_version_number
250: );
251: --
245: => ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by
246: ,p_rsrv_val_last_upd_by_o
247: => ben_cpg_shd.g_old_rec.rsrv_val_last_upd_by
248: ,p_object_version_number_o
249: => ben_cpg_shd.g_old_rec.object_version_number
250: );
251: --
252: exception
253: --
267: -- ----------------------------------------------------------------------------
268: -- |---------------------------------< del >----------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure del
271: (p_rec in ben_cpg_shd.g_rec_type
272: ) is
273: --
274: l_proc varchar2(72) := g_package||'del';
275: --
279: end if;
280: --
281: -- We must lock the row which we need to delete.
282: --
283: ben_cpg_shd.lck
284: (p_rec.group_per_in_ler_id
285: ,p_rec.group_pl_id
286: ,p_rec.group_oipl_id
287: ,p_rec.object_version_number
320: ,p_group_oipl_id in number
321: ,p_object_version_number in number
322: ) is
323: --
324: l_rec ben_cpg_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'del';
326: --
327: Begin
328: if g_debug then