APPS.BEN_EIV_DEL dependencies on BEN_EIV_SHD

Line 52: (p_rec in ben_eiv_shd.g_rec_type

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

Line 60: ben_eiv_shd.g_api_dml := true; -- Set the api dml status

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

Line 67: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from ben_extra_input_values
65: where extra_input_value_id = p_rec.extra_input_value_id;
66: --
67: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 75: ben_eiv_shd.constraint_error

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

Line 78: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 115: ,p_rec in ben_eiv_shd.g_rec_type) is

111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_effective_date in date
115: ,p_rec in ben_eiv_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 158: ,p_rec in ben_eiv_shd.g_rec_type) is

154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_effective_date in date
158: ,p_rec in ben_eiv_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: --
162: Begin

Line 170: => ben_eiv_shd.g_old_rec.acty_base_rt_id

166: ben_eiv_rkd.after_delete
167: (p_extra_input_value_id
168: => p_rec.extra_input_value_id
169: ,p_acty_base_rt_id_o
170: => ben_eiv_shd.g_old_rec.acty_base_rt_id
171: ,p_input_value_id_o
172: => ben_eiv_shd.g_old_rec.input_value_id
173: ,p_input_text_o
174: => ben_eiv_shd.g_old_rec.input_text

Line 172: => ben_eiv_shd.g_old_rec.input_value_id

168: => p_rec.extra_input_value_id
169: ,p_acty_base_rt_id_o
170: => ben_eiv_shd.g_old_rec.acty_base_rt_id
171: ,p_input_value_id_o
172: => ben_eiv_shd.g_old_rec.input_value_id
173: ,p_input_text_o
174: => ben_eiv_shd.g_old_rec.input_text
175: ,p_upd_when_ele_ended_cd_o
176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd

Line 174: => ben_eiv_shd.g_old_rec.input_text

170: => ben_eiv_shd.g_old_rec.acty_base_rt_id
171: ,p_input_value_id_o
172: => ben_eiv_shd.g_old_rec.input_value_id
173: ,p_input_text_o
174: => ben_eiv_shd.g_old_rec.input_text
175: ,p_upd_when_ele_ended_cd_o
176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
177: ,p_return_var_name_o
178: => ben_eiv_shd.g_old_rec.return_var_name

Line 176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd

172: => ben_eiv_shd.g_old_rec.input_value_id
173: ,p_input_text_o
174: => ben_eiv_shd.g_old_rec.input_text
175: ,p_upd_when_ele_ended_cd_o
176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
177: ,p_return_var_name_o
178: => ben_eiv_shd.g_old_rec.return_var_name
179: ,p_business_group_id_o
180: => ben_eiv_shd.g_old_rec.business_group_id

Line 178: => ben_eiv_shd.g_old_rec.return_var_name

174: => ben_eiv_shd.g_old_rec.input_text
175: ,p_upd_when_ele_ended_cd_o
176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
177: ,p_return_var_name_o
178: => ben_eiv_shd.g_old_rec.return_var_name
179: ,p_business_group_id_o
180: => ben_eiv_shd.g_old_rec.business_group_id
181: ,p_eiv_attribute_category_o
182: => ben_eiv_shd.g_old_rec.eiv_attribute_category

Line 180: => ben_eiv_shd.g_old_rec.business_group_id

176: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
177: ,p_return_var_name_o
178: => ben_eiv_shd.g_old_rec.return_var_name
179: ,p_business_group_id_o
180: => ben_eiv_shd.g_old_rec.business_group_id
181: ,p_eiv_attribute_category_o
182: => ben_eiv_shd.g_old_rec.eiv_attribute_category
183: ,p_eiv_attribute1_o
184: => ben_eiv_shd.g_old_rec.eiv_attribute1

Line 182: => ben_eiv_shd.g_old_rec.eiv_attribute_category

178: => ben_eiv_shd.g_old_rec.return_var_name
179: ,p_business_group_id_o
180: => ben_eiv_shd.g_old_rec.business_group_id
181: ,p_eiv_attribute_category_o
182: => ben_eiv_shd.g_old_rec.eiv_attribute_category
183: ,p_eiv_attribute1_o
184: => ben_eiv_shd.g_old_rec.eiv_attribute1
185: ,p_eiv_attribute2_o
186: => ben_eiv_shd.g_old_rec.eiv_attribute2

Line 184: => ben_eiv_shd.g_old_rec.eiv_attribute1

180: => ben_eiv_shd.g_old_rec.business_group_id
181: ,p_eiv_attribute_category_o
182: => ben_eiv_shd.g_old_rec.eiv_attribute_category
183: ,p_eiv_attribute1_o
184: => ben_eiv_shd.g_old_rec.eiv_attribute1
185: ,p_eiv_attribute2_o
186: => ben_eiv_shd.g_old_rec.eiv_attribute2
187: ,p_eiv_attribute3_o
188: => ben_eiv_shd.g_old_rec.eiv_attribute3

Line 186: => ben_eiv_shd.g_old_rec.eiv_attribute2

182: => ben_eiv_shd.g_old_rec.eiv_attribute_category
183: ,p_eiv_attribute1_o
184: => ben_eiv_shd.g_old_rec.eiv_attribute1
185: ,p_eiv_attribute2_o
186: => ben_eiv_shd.g_old_rec.eiv_attribute2
187: ,p_eiv_attribute3_o
188: => ben_eiv_shd.g_old_rec.eiv_attribute3
189: ,p_eiv_attribute4_o
190: => ben_eiv_shd.g_old_rec.eiv_attribute4

Line 188: => ben_eiv_shd.g_old_rec.eiv_attribute3

184: => ben_eiv_shd.g_old_rec.eiv_attribute1
185: ,p_eiv_attribute2_o
186: => ben_eiv_shd.g_old_rec.eiv_attribute2
187: ,p_eiv_attribute3_o
188: => ben_eiv_shd.g_old_rec.eiv_attribute3
189: ,p_eiv_attribute4_o
190: => ben_eiv_shd.g_old_rec.eiv_attribute4
191: ,p_eiv_attribute5_o
192: => ben_eiv_shd.g_old_rec.eiv_attribute5

Line 190: => ben_eiv_shd.g_old_rec.eiv_attribute4

186: => ben_eiv_shd.g_old_rec.eiv_attribute2
187: ,p_eiv_attribute3_o
188: => ben_eiv_shd.g_old_rec.eiv_attribute3
189: ,p_eiv_attribute4_o
190: => ben_eiv_shd.g_old_rec.eiv_attribute4
191: ,p_eiv_attribute5_o
192: => ben_eiv_shd.g_old_rec.eiv_attribute5
193: ,p_eiv_attribute6_o
194: => ben_eiv_shd.g_old_rec.eiv_attribute6

Line 192: => ben_eiv_shd.g_old_rec.eiv_attribute5

188: => ben_eiv_shd.g_old_rec.eiv_attribute3
189: ,p_eiv_attribute4_o
190: => ben_eiv_shd.g_old_rec.eiv_attribute4
191: ,p_eiv_attribute5_o
192: => ben_eiv_shd.g_old_rec.eiv_attribute5
193: ,p_eiv_attribute6_o
194: => ben_eiv_shd.g_old_rec.eiv_attribute6
195: ,p_eiv_attribute7_o
196: => ben_eiv_shd.g_old_rec.eiv_attribute7

Line 194: => ben_eiv_shd.g_old_rec.eiv_attribute6

190: => ben_eiv_shd.g_old_rec.eiv_attribute4
191: ,p_eiv_attribute5_o
192: => ben_eiv_shd.g_old_rec.eiv_attribute5
193: ,p_eiv_attribute6_o
194: => ben_eiv_shd.g_old_rec.eiv_attribute6
195: ,p_eiv_attribute7_o
196: => ben_eiv_shd.g_old_rec.eiv_attribute7
197: ,p_eiv_attribute8_o
198: => ben_eiv_shd.g_old_rec.eiv_attribute8

Line 196: => ben_eiv_shd.g_old_rec.eiv_attribute7

192: => ben_eiv_shd.g_old_rec.eiv_attribute5
193: ,p_eiv_attribute6_o
194: => ben_eiv_shd.g_old_rec.eiv_attribute6
195: ,p_eiv_attribute7_o
196: => ben_eiv_shd.g_old_rec.eiv_attribute7
197: ,p_eiv_attribute8_o
198: => ben_eiv_shd.g_old_rec.eiv_attribute8
199: ,p_eiv_attribute9_o
200: => ben_eiv_shd.g_old_rec.eiv_attribute9

Line 198: => ben_eiv_shd.g_old_rec.eiv_attribute8

194: => ben_eiv_shd.g_old_rec.eiv_attribute6
195: ,p_eiv_attribute7_o
196: => ben_eiv_shd.g_old_rec.eiv_attribute7
197: ,p_eiv_attribute8_o
198: => ben_eiv_shd.g_old_rec.eiv_attribute8
199: ,p_eiv_attribute9_o
200: => ben_eiv_shd.g_old_rec.eiv_attribute9
201: ,p_eiv_attribute10_o
202: => ben_eiv_shd.g_old_rec.eiv_attribute10

Line 200: => ben_eiv_shd.g_old_rec.eiv_attribute9

196: => ben_eiv_shd.g_old_rec.eiv_attribute7
197: ,p_eiv_attribute8_o
198: => ben_eiv_shd.g_old_rec.eiv_attribute8
199: ,p_eiv_attribute9_o
200: => ben_eiv_shd.g_old_rec.eiv_attribute9
201: ,p_eiv_attribute10_o
202: => ben_eiv_shd.g_old_rec.eiv_attribute10
203: ,p_eiv_attribute11_o
204: => ben_eiv_shd.g_old_rec.eiv_attribute11

Line 202: => ben_eiv_shd.g_old_rec.eiv_attribute10

198: => ben_eiv_shd.g_old_rec.eiv_attribute8
199: ,p_eiv_attribute9_o
200: => ben_eiv_shd.g_old_rec.eiv_attribute9
201: ,p_eiv_attribute10_o
202: => ben_eiv_shd.g_old_rec.eiv_attribute10
203: ,p_eiv_attribute11_o
204: => ben_eiv_shd.g_old_rec.eiv_attribute11
205: ,p_eiv_attribute12_o
206: => ben_eiv_shd.g_old_rec.eiv_attribute12

Line 204: => ben_eiv_shd.g_old_rec.eiv_attribute11

200: => ben_eiv_shd.g_old_rec.eiv_attribute9
201: ,p_eiv_attribute10_o
202: => ben_eiv_shd.g_old_rec.eiv_attribute10
203: ,p_eiv_attribute11_o
204: => ben_eiv_shd.g_old_rec.eiv_attribute11
205: ,p_eiv_attribute12_o
206: => ben_eiv_shd.g_old_rec.eiv_attribute12
207: ,p_eiv_attribute13_o
208: => ben_eiv_shd.g_old_rec.eiv_attribute13

Line 206: => ben_eiv_shd.g_old_rec.eiv_attribute12

202: => ben_eiv_shd.g_old_rec.eiv_attribute10
203: ,p_eiv_attribute11_o
204: => ben_eiv_shd.g_old_rec.eiv_attribute11
205: ,p_eiv_attribute12_o
206: => ben_eiv_shd.g_old_rec.eiv_attribute12
207: ,p_eiv_attribute13_o
208: => ben_eiv_shd.g_old_rec.eiv_attribute13
209: ,p_eiv_attribute14_o
210: => ben_eiv_shd.g_old_rec.eiv_attribute14

Line 208: => ben_eiv_shd.g_old_rec.eiv_attribute13

204: => ben_eiv_shd.g_old_rec.eiv_attribute11
205: ,p_eiv_attribute12_o
206: => ben_eiv_shd.g_old_rec.eiv_attribute12
207: ,p_eiv_attribute13_o
208: => ben_eiv_shd.g_old_rec.eiv_attribute13
209: ,p_eiv_attribute14_o
210: => ben_eiv_shd.g_old_rec.eiv_attribute14
211: ,p_eiv_attribute15_o
212: => ben_eiv_shd.g_old_rec.eiv_attribute15

Line 210: => ben_eiv_shd.g_old_rec.eiv_attribute14

206: => ben_eiv_shd.g_old_rec.eiv_attribute12
207: ,p_eiv_attribute13_o
208: => ben_eiv_shd.g_old_rec.eiv_attribute13
209: ,p_eiv_attribute14_o
210: => ben_eiv_shd.g_old_rec.eiv_attribute14
211: ,p_eiv_attribute15_o
212: => ben_eiv_shd.g_old_rec.eiv_attribute15
213: ,p_eiv_attribute16_o
214: => ben_eiv_shd.g_old_rec.eiv_attribute16

Line 212: => ben_eiv_shd.g_old_rec.eiv_attribute15

208: => ben_eiv_shd.g_old_rec.eiv_attribute13
209: ,p_eiv_attribute14_o
210: => ben_eiv_shd.g_old_rec.eiv_attribute14
211: ,p_eiv_attribute15_o
212: => ben_eiv_shd.g_old_rec.eiv_attribute15
213: ,p_eiv_attribute16_o
214: => ben_eiv_shd.g_old_rec.eiv_attribute16
215: ,p_eiv_attribute17_o
216: => ben_eiv_shd.g_old_rec.eiv_attribute17

Line 214: => ben_eiv_shd.g_old_rec.eiv_attribute16

210: => ben_eiv_shd.g_old_rec.eiv_attribute14
211: ,p_eiv_attribute15_o
212: => ben_eiv_shd.g_old_rec.eiv_attribute15
213: ,p_eiv_attribute16_o
214: => ben_eiv_shd.g_old_rec.eiv_attribute16
215: ,p_eiv_attribute17_o
216: => ben_eiv_shd.g_old_rec.eiv_attribute17
217: ,p_eiv_attribute18_o
218: => ben_eiv_shd.g_old_rec.eiv_attribute18

Line 216: => ben_eiv_shd.g_old_rec.eiv_attribute17

212: => ben_eiv_shd.g_old_rec.eiv_attribute15
213: ,p_eiv_attribute16_o
214: => ben_eiv_shd.g_old_rec.eiv_attribute16
215: ,p_eiv_attribute17_o
216: => ben_eiv_shd.g_old_rec.eiv_attribute17
217: ,p_eiv_attribute18_o
218: => ben_eiv_shd.g_old_rec.eiv_attribute18
219: ,p_eiv_attribute19_o
220: => ben_eiv_shd.g_old_rec.eiv_attribute19

Line 218: => ben_eiv_shd.g_old_rec.eiv_attribute18

214: => ben_eiv_shd.g_old_rec.eiv_attribute16
215: ,p_eiv_attribute17_o
216: => ben_eiv_shd.g_old_rec.eiv_attribute17
217: ,p_eiv_attribute18_o
218: => ben_eiv_shd.g_old_rec.eiv_attribute18
219: ,p_eiv_attribute19_o
220: => ben_eiv_shd.g_old_rec.eiv_attribute19
221: ,p_eiv_attribute20_o
222: => ben_eiv_shd.g_old_rec.eiv_attribute20

Line 220: => ben_eiv_shd.g_old_rec.eiv_attribute19

216: => ben_eiv_shd.g_old_rec.eiv_attribute17
217: ,p_eiv_attribute18_o
218: => ben_eiv_shd.g_old_rec.eiv_attribute18
219: ,p_eiv_attribute19_o
220: => ben_eiv_shd.g_old_rec.eiv_attribute19
221: ,p_eiv_attribute20_o
222: => ben_eiv_shd.g_old_rec.eiv_attribute20
223: ,p_eiv_attribute21_o
224: => ben_eiv_shd.g_old_rec.eiv_attribute21

Line 222: => ben_eiv_shd.g_old_rec.eiv_attribute20

218: => ben_eiv_shd.g_old_rec.eiv_attribute18
219: ,p_eiv_attribute19_o
220: => ben_eiv_shd.g_old_rec.eiv_attribute19
221: ,p_eiv_attribute20_o
222: => ben_eiv_shd.g_old_rec.eiv_attribute20
223: ,p_eiv_attribute21_o
224: => ben_eiv_shd.g_old_rec.eiv_attribute21
225: ,p_eiv_attribute22_o
226: => ben_eiv_shd.g_old_rec.eiv_attribute22

Line 224: => ben_eiv_shd.g_old_rec.eiv_attribute21

220: => ben_eiv_shd.g_old_rec.eiv_attribute19
221: ,p_eiv_attribute20_o
222: => ben_eiv_shd.g_old_rec.eiv_attribute20
223: ,p_eiv_attribute21_o
224: => ben_eiv_shd.g_old_rec.eiv_attribute21
225: ,p_eiv_attribute22_o
226: => ben_eiv_shd.g_old_rec.eiv_attribute22
227: ,p_eiv_attribute23_o
228: => ben_eiv_shd.g_old_rec.eiv_attribute23

Line 226: => ben_eiv_shd.g_old_rec.eiv_attribute22

222: => ben_eiv_shd.g_old_rec.eiv_attribute20
223: ,p_eiv_attribute21_o
224: => ben_eiv_shd.g_old_rec.eiv_attribute21
225: ,p_eiv_attribute22_o
226: => ben_eiv_shd.g_old_rec.eiv_attribute22
227: ,p_eiv_attribute23_o
228: => ben_eiv_shd.g_old_rec.eiv_attribute23
229: ,p_eiv_attribute24_o
230: => ben_eiv_shd.g_old_rec.eiv_attribute24

Line 228: => ben_eiv_shd.g_old_rec.eiv_attribute23

224: => ben_eiv_shd.g_old_rec.eiv_attribute21
225: ,p_eiv_attribute22_o
226: => ben_eiv_shd.g_old_rec.eiv_attribute22
227: ,p_eiv_attribute23_o
228: => ben_eiv_shd.g_old_rec.eiv_attribute23
229: ,p_eiv_attribute24_o
230: => ben_eiv_shd.g_old_rec.eiv_attribute24
231: ,p_eiv_attribute25_o
232: => ben_eiv_shd.g_old_rec.eiv_attribute25

Line 230: => ben_eiv_shd.g_old_rec.eiv_attribute24

226: => ben_eiv_shd.g_old_rec.eiv_attribute22
227: ,p_eiv_attribute23_o
228: => ben_eiv_shd.g_old_rec.eiv_attribute23
229: ,p_eiv_attribute24_o
230: => ben_eiv_shd.g_old_rec.eiv_attribute24
231: ,p_eiv_attribute25_o
232: => ben_eiv_shd.g_old_rec.eiv_attribute25
233: ,p_eiv_attribute26_o
234: => ben_eiv_shd.g_old_rec.eiv_attribute26

Line 232: => ben_eiv_shd.g_old_rec.eiv_attribute25

228: => ben_eiv_shd.g_old_rec.eiv_attribute23
229: ,p_eiv_attribute24_o
230: => ben_eiv_shd.g_old_rec.eiv_attribute24
231: ,p_eiv_attribute25_o
232: => ben_eiv_shd.g_old_rec.eiv_attribute25
233: ,p_eiv_attribute26_o
234: => ben_eiv_shd.g_old_rec.eiv_attribute26
235: ,p_eiv_attribute27_o
236: => ben_eiv_shd.g_old_rec.eiv_attribute27

Line 234: => ben_eiv_shd.g_old_rec.eiv_attribute26

230: => ben_eiv_shd.g_old_rec.eiv_attribute24
231: ,p_eiv_attribute25_o
232: => ben_eiv_shd.g_old_rec.eiv_attribute25
233: ,p_eiv_attribute26_o
234: => ben_eiv_shd.g_old_rec.eiv_attribute26
235: ,p_eiv_attribute27_o
236: => ben_eiv_shd.g_old_rec.eiv_attribute27
237: ,p_eiv_attribute28_o
238: => ben_eiv_shd.g_old_rec.eiv_attribute28

Line 236: => ben_eiv_shd.g_old_rec.eiv_attribute27

232: => ben_eiv_shd.g_old_rec.eiv_attribute25
233: ,p_eiv_attribute26_o
234: => ben_eiv_shd.g_old_rec.eiv_attribute26
235: ,p_eiv_attribute27_o
236: => ben_eiv_shd.g_old_rec.eiv_attribute27
237: ,p_eiv_attribute28_o
238: => ben_eiv_shd.g_old_rec.eiv_attribute28
239: ,p_eiv_attribute29_o
240: => ben_eiv_shd.g_old_rec.eiv_attribute29

Line 238: => ben_eiv_shd.g_old_rec.eiv_attribute28

234: => ben_eiv_shd.g_old_rec.eiv_attribute26
235: ,p_eiv_attribute27_o
236: => ben_eiv_shd.g_old_rec.eiv_attribute27
237: ,p_eiv_attribute28_o
238: => ben_eiv_shd.g_old_rec.eiv_attribute28
239: ,p_eiv_attribute29_o
240: => ben_eiv_shd.g_old_rec.eiv_attribute29
241: ,p_eiv_attribute30_o
242: => ben_eiv_shd.g_old_rec.eiv_attribute30

Line 240: => ben_eiv_shd.g_old_rec.eiv_attribute29

236: => ben_eiv_shd.g_old_rec.eiv_attribute27
237: ,p_eiv_attribute28_o
238: => ben_eiv_shd.g_old_rec.eiv_attribute28
239: ,p_eiv_attribute29_o
240: => ben_eiv_shd.g_old_rec.eiv_attribute29
241: ,p_eiv_attribute30_o
242: => ben_eiv_shd.g_old_rec.eiv_attribute30
243: ,p_object_version_number_o
244: => ben_eiv_shd.g_old_rec.object_version_number

Line 242: => ben_eiv_shd.g_old_rec.eiv_attribute30

238: => ben_eiv_shd.g_old_rec.eiv_attribute28
239: ,p_eiv_attribute29_o
240: => ben_eiv_shd.g_old_rec.eiv_attribute29
241: ,p_eiv_attribute30_o
242: => ben_eiv_shd.g_old_rec.eiv_attribute30
243: ,p_object_version_number_o
244: => ben_eiv_shd.g_old_rec.object_version_number
245: );
246: --

Line 244: => ben_eiv_shd.g_old_rec.object_version_number

240: => ben_eiv_shd.g_old_rec.eiv_attribute29
241: ,p_eiv_attribute30_o
242: => ben_eiv_shd.g_old_rec.eiv_attribute30
243: ,p_object_version_number_o
244: => ben_eiv_shd.g_old_rec.object_version_number
245: );
246: --
247: exception
248: --

Line 265: ,p_rec in ben_eiv_shd.g_rec_type

261: -- |---------------------------------< del >----------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure del
264: (p_effective_date in date
265: ,p_rec in ben_eiv_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'del';
269: --

Line 275: ben_eiv_shd.lck

271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: -- We must lock the row which we need to delete.
274: --
275: ben_eiv_shd.lck
276: (p_rec.extra_input_value_id
277: ,p_rec.object_version_number
278: );
279: --

Line 307: l_rec ben_eiv_shd.g_rec_type;

303: ,p_extra_input_value_id in number
304: ,p_object_version_number in number
305: ) is
306: --
307: l_rec ben_eiv_shd.g_rec_type;
308: l_proc varchar2(72) := g_package||'del';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);