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_BPI_DEL dependencies on BEN_BPI_SHD

Line 51: Procedure delete_dml(p_rec in ben_bpi_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_bpi_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_bpi_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_bpi_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_batch_proc_info row.
61: --
62: delete from ben_batch_proc_info

Line 65: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from ben_batch_proc_info
63: where batch_proc_id = p_rec.batch_proc_id;
64: --
65: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bpi_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_bpi_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bpi_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status

72: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bpi_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_bpi_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_bpi_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in ben_bpi_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in ben_bpi_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id

164: begin
165: --
166: ben_bpi_rkd.after_delete
167: (p_batch_proc_id =>p_rec.batch_proc_id
168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id
169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm

Line 169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt

165: --
166: ben_bpi_rkd.after_delete
167: (p_batch_proc_id =>p_rec.batch_proc_id
168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id
169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm

Line 170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt

166: ben_bpi_rkd.after_delete
167: (p_batch_proc_id =>p_rec.batch_proc_id
168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id
169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd

Line 171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm

167: (p_batch_proc_id =>p_rec.batch_proc_id
168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id
169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc

Line 172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm

168: ,p_benefit_action_id_o =>ben_bpi_shd.g_old_rec.benefit_action_id
169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc

Line 173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm

169: ,p_strt_dt_o =>ben_bpi_shd.g_old_rec.strt_dt
170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ

Line 174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd

170: ,p_end_dt_o =>ben_bpi_shd.g_old_rec.end_dt
171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err

Line 175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc

171: ,p_strt_tm_o =>ben_bpi_shd.g_old_rec.strt_tm
172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id

Line 176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc

172: ,p_end_tm_o =>ben_bpi_shd.g_old_rec.end_tm
173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id
180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number

Line 177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ

173: ,p_elpsd_tm_o =>ben_bpi_shd.g_old_rec.elpsd_tm
174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id
180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number
181: );

Line 178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err

174: ,p_per_slctd_o =>ben_bpi_shd.g_old_rec.per_slctd
175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id
180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number
181: );
182: --

Line 179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id

175: ,p_per_proc_o =>ben_bpi_shd.g_old_rec.per_proc
176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id
180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number
181: );
182: --
183: exception

Line 180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number

176: ,p_per_unproc_o =>ben_bpi_shd.g_old_rec.per_unproc
177: ,p_per_proc_succ_o =>ben_bpi_shd.g_old_rec.per_proc_succ
178: ,p_per_err_o =>ben_bpi_shd.g_old_rec.per_err
179: ,p_business_group_id_o =>ben_bpi_shd.g_old_rec.business_group_id
180: ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number
181: );
182: --
183: exception
184: --

Line 204: p_rec in ben_bpi_shd.g_rec_type

200: -- |---------------------------------< del >----------------------------------|
201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (
204: p_rec in ben_bpi_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
208: --

Line 214: ben_bpi_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: ben_bpi_shd.lck
215: (
216: p_rec.batch_proc_id,
217: p_rec.object_version_number
218: );

Line 246: l_rec ben_bpi_shd.g_rec_type;

242: p_batch_proc_id in number,
243: p_object_version_number in number
244: ) is
245: --
246: l_rec ben_bpi_shd.g_rec_type;
247: l_proc varchar2(72) := g_package||'del';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);