APPS.BEN_VEP_DEL dependencies on BEN_VEP_SHD

Line 54: (p_rec in out nocopy ben_vep_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_vep_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: ben_vep_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: ben_vep_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

71: delete from BEN_VRBL_RT_ELIG_PRFL_f
72: where vrbl_rt_elig_prfl_id = p_rec.vrbl_rt_elig_prfl_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_vep_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: ben_vep_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_vep_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

82: delete from BEN_VRBL_RT_ELIG_PRFL_f
83: where vrbl_rt_elig_prfl_id = p_rec.vrbl_rt_elig_prfl_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy ben_vep_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_vep_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy ben_vep_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy ben_vep_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := ben_vep_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := ben_vep_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: ben_vep_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: ben_vep_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.vrbl_rt_elig_prfl_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy ben_vep_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy ben_vep_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in ben_vep_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in ben_vep_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 322: => ben_vep_shd.g_old_rec.effective_start_date

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => ben_vep_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_vep_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_vep_shd.g_old_rec.business_group_id

Line 324: => ben_vep_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => ben_vep_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_vep_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_vep_shd.g_old_rec.business_group_id
327: ,p_vrbl_rt_prfl_id_o
328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id

Line 326: => ben_vep_shd.g_old_rec.business_group_id

322: => ben_vep_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_vep_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_vep_shd.g_old_rec.business_group_id
327: ,p_vrbl_rt_prfl_id_o
328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
329: ,p_eligy_prfl_id_o
330: => ben_vep_shd.g_old_rec.eligy_prfl_id

Line 328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id

324: => ben_vep_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_vep_shd.g_old_rec.business_group_id
327: ,p_vrbl_rt_prfl_id_o
328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
329: ,p_eligy_prfl_id_o
330: => ben_vep_shd.g_old_rec.eligy_prfl_id
331: ,p_mndtry_flag_o
332: => ben_vep_shd.g_old_rec.mndtry_flag

Line 330: => ben_vep_shd.g_old_rec.eligy_prfl_id

326: => ben_vep_shd.g_old_rec.business_group_id
327: ,p_vrbl_rt_prfl_id_o
328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
329: ,p_eligy_prfl_id_o
330: => ben_vep_shd.g_old_rec.eligy_prfl_id
331: ,p_mndtry_flag_o
332: => ben_vep_shd.g_old_rec.mndtry_flag
333: ,p_vep_attribute_category_o
334: => ben_vep_shd.g_old_rec.vep_attribute_category

Line 332: => ben_vep_shd.g_old_rec.mndtry_flag

328: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
329: ,p_eligy_prfl_id_o
330: => ben_vep_shd.g_old_rec.eligy_prfl_id
331: ,p_mndtry_flag_o
332: => ben_vep_shd.g_old_rec.mndtry_flag
333: ,p_vep_attribute_category_o
334: => ben_vep_shd.g_old_rec.vep_attribute_category
335: ,p_vep_attribute1_o
336: => ben_vep_shd.g_old_rec.vep_attribute1

Line 334: => ben_vep_shd.g_old_rec.vep_attribute_category

330: => ben_vep_shd.g_old_rec.eligy_prfl_id
331: ,p_mndtry_flag_o
332: => ben_vep_shd.g_old_rec.mndtry_flag
333: ,p_vep_attribute_category_o
334: => ben_vep_shd.g_old_rec.vep_attribute_category
335: ,p_vep_attribute1_o
336: => ben_vep_shd.g_old_rec.vep_attribute1
337: ,p_vep_attribute2_o
338: => ben_vep_shd.g_old_rec.vep_attribute2

Line 336: => ben_vep_shd.g_old_rec.vep_attribute1

332: => ben_vep_shd.g_old_rec.mndtry_flag
333: ,p_vep_attribute_category_o
334: => ben_vep_shd.g_old_rec.vep_attribute_category
335: ,p_vep_attribute1_o
336: => ben_vep_shd.g_old_rec.vep_attribute1
337: ,p_vep_attribute2_o
338: => ben_vep_shd.g_old_rec.vep_attribute2
339: ,p_vep_attribute3_o
340: => ben_vep_shd.g_old_rec.vep_attribute3

Line 338: => ben_vep_shd.g_old_rec.vep_attribute2

334: => ben_vep_shd.g_old_rec.vep_attribute_category
335: ,p_vep_attribute1_o
336: => ben_vep_shd.g_old_rec.vep_attribute1
337: ,p_vep_attribute2_o
338: => ben_vep_shd.g_old_rec.vep_attribute2
339: ,p_vep_attribute3_o
340: => ben_vep_shd.g_old_rec.vep_attribute3
341: ,p_vep_attribute4_o
342: => ben_vep_shd.g_old_rec.vep_attribute4

Line 340: => ben_vep_shd.g_old_rec.vep_attribute3

336: => ben_vep_shd.g_old_rec.vep_attribute1
337: ,p_vep_attribute2_o
338: => ben_vep_shd.g_old_rec.vep_attribute2
339: ,p_vep_attribute3_o
340: => ben_vep_shd.g_old_rec.vep_attribute3
341: ,p_vep_attribute4_o
342: => ben_vep_shd.g_old_rec.vep_attribute4
343: ,p_vep_attribute5_o
344: => ben_vep_shd.g_old_rec.vep_attribute5

Line 342: => ben_vep_shd.g_old_rec.vep_attribute4

338: => ben_vep_shd.g_old_rec.vep_attribute2
339: ,p_vep_attribute3_o
340: => ben_vep_shd.g_old_rec.vep_attribute3
341: ,p_vep_attribute4_o
342: => ben_vep_shd.g_old_rec.vep_attribute4
343: ,p_vep_attribute5_o
344: => ben_vep_shd.g_old_rec.vep_attribute5
345: ,p_vep_attribute6_o
346: => ben_vep_shd.g_old_rec.vep_attribute6

Line 344: => ben_vep_shd.g_old_rec.vep_attribute5

340: => ben_vep_shd.g_old_rec.vep_attribute3
341: ,p_vep_attribute4_o
342: => ben_vep_shd.g_old_rec.vep_attribute4
343: ,p_vep_attribute5_o
344: => ben_vep_shd.g_old_rec.vep_attribute5
345: ,p_vep_attribute6_o
346: => ben_vep_shd.g_old_rec.vep_attribute6
347: ,p_vep_attribute7_o
348: => ben_vep_shd.g_old_rec.vep_attribute7

Line 346: => ben_vep_shd.g_old_rec.vep_attribute6

342: => ben_vep_shd.g_old_rec.vep_attribute4
343: ,p_vep_attribute5_o
344: => ben_vep_shd.g_old_rec.vep_attribute5
345: ,p_vep_attribute6_o
346: => ben_vep_shd.g_old_rec.vep_attribute6
347: ,p_vep_attribute7_o
348: => ben_vep_shd.g_old_rec.vep_attribute7
349: ,p_vep_attribute8_o
350: => ben_vep_shd.g_old_rec.vep_attribute8

Line 348: => ben_vep_shd.g_old_rec.vep_attribute7

344: => ben_vep_shd.g_old_rec.vep_attribute5
345: ,p_vep_attribute6_o
346: => ben_vep_shd.g_old_rec.vep_attribute6
347: ,p_vep_attribute7_o
348: => ben_vep_shd.g_old_rec.vep_attribute7
349: ,p_vep_attribute8_o
350: => ben_vep_shd.g_old_rec.vep_attribute8
351: ,p_vep_attribute9_o
352: => ben_vep_shd.g_old_rec.vep_attribute9

Line 350: => ben_vep_shd.g_old_rec.vep_attribute8

346: => ben_vep_shd.g_old_rec.vep_attribute6
347: ,p_vep_attribute7_o
348: => ben_vep_shd.g_old_rec.vep_attribute7
349: ,p_vep_attribute8_o
350: => ben_vep_shd.g_old_rec.vep_attribute8
351: ,p_vep_attribute9_o
352: => ben_vep_shd.g_old_rec.vep_attribute9
353: ,p_vep_attribute10_o
354: => ben_vep_shd.g_old_rec.vep_attribute10

Line 352: => ben_vep_shd.g_old_rec.vep_attribute9

348: => ben_vep_shd.g_old_rec.vep_attribute7
349: ,p_vep_attribute8_o
350: => ben_vep_shd.g_old_rec.vep_attribute8
351: ,p_vep_attribute9_o
352: => ben_vep_shd.g_old_rec.vep_attribute9
353: ,p_vep_attribute10_o
354: => ben_vep_shd.g_old_rec.vep_attribute10
355: ,p_vep_attribute11_o
356: => ben_vep_shd.g_old_rec.vep_attribute11

Line 354: => ben_vep_shd.g_old_rec.vep_attribute10

350: => ben_vep_shd.g_old_rec.vep_attribute8
351: ,p_vep_attribute9_o
352: => ben_vep_shd.g_old_rec.vep_attribute9
353: ,p_vep_attribute10_o
354: => ben_vep_shd.g_old_rec.vep_attribute10
355: ,p_vep_attribute11_o
356: => ben_vep_shd.g_old_rec.vep_attribute11
357: ,p_vep_attribute12_o
358: => ben_vep_shd.g_old_rec.vep_attribute12

Line 356: => ben_vep_shd.g_old_rec.vep_attribute11

352: => ben_vep_shd.g_old_rec.vep_attribute9
353: ,p_vep_attribute10_o
354: => ben_vep_shd.g_old_rec.vep_attribute10
355: ,p_vep_attribute11_o
356: => ben_vep_shd.g_old_rec.vep_attribute11
357: ,p_vep_attribute12_o
358: => ben_vep_shd.g_old_rec.vep_attribute12
359: ,p_vep_attribute13_o
360: => ben_vep_shd.g_old_rec.vep_attribute13

Line 358: => ben_vep_shd.g_old_rec.vep_attribute12

354: => ben_vep_shd.g_old_rec.vep_attribute10
355: ,p_vep_attribute11_o
356: => ben_vep_shd.g_old_rec.vep_attribute11
357: ,p_vep_attribute12_o
358: => ben_vep_shd.g_old_rec.vep_attribute12
359: ,p_vep_attribute13_o
360: => ben_vep_shd.g_old_rec.vep_attribute13
361: ,p_vep_attribute14_o
362: => ben_vep_shd.g_old_rec.vep_attribute14

Line 360: => ben_vep_shd.g_old_rec.vep_attribute13

356: => ben_vep_shd.g_old_rec.vep_attribute11
357: ,p_vep_attribute12_o
358: => ben_vep_shd.g_old_rec.vep_attribute12
359: ,p_vep_attribute13_o
360: => ben_vep_shd.g_old_rec.vep_attribute13
361: ,p_vep_attribute14_o
362: => ben_vep_shd.g_old_rec.vep_attribute14
363: ,p_vep_attribute15_o
364: => ben_vep_shd.g_old_rec.vep_attribute15

Line 362: => ben_vep_shd.g_old_rec.vep_attribute14

358: => ben_vep_shd.g_old_rec.vep_attribute12
359: ,p_vep_attribute13_o
360: => ben_vep_shd.g_old_rec.vep_attribute13
361: ,p_vep_attribute14_o
362: => ben_vep_shd.g_old_rec.vep_attribute14
363: ,p_vep_attribute15_o
364: => ben_vep_shd.g_old_rec.vep_attribute15
365: ,p_vep_attribute16_o
366: => ben_vep_shd.g_old_rec.vep_attribute16

Line 364: => ben_vep_shd.g_old_rec.vep_attribute15

360: => ben_vep_shd.g_old_rec.vep_attribute13
361: ,p_vep_attribute14_o
362: => ben_vep_shd.g_old_rec.vep_attribute14
363: ,p_vep_attribute15_o
364: => ben_vep_shd.g_old_rec.vep_attribute15
365: ,p_vep_attribute16_o
366: => ben_vep_shd.g_old_rec.vep_attribute16
367: ,p_vep_attribute17_o
368: => ben_vep_shd.g_old_rec.vep_attribute17

Line 366: => ben_vep_shd.g_old_rec.vep_attribute16

362: => ben_vep_shd.g_old_rec.vep_attribute14
363: ,p_vep_attribute15_o
364: => ben_vep_shd.g_old_rec.vep_attribute15
365: ,p_vep_attribute16_o
366: => ben_vep_shd.g_old_rec.vep_attribute16
367: ,p_vep_attribute17_o
368: => ben_vep_shd.g_old_rec.vep_attribute17
369: ,p_vep_attribute18_o
370: => ben_vep_shd.g_old_rec.vep_attribute18

Line 368: => ben_vep_shd.g_old_rec.vep_attribute17

364: => ben_vep_shd.g_old_rec.vep_attribute15
365: ,p_vep_attribute16_o
366: => ben_vep_shd.g_old_rec.vep_attribute16
367: ,p_vep_attribute17_o
368: => ben_vep_shd.g_old_rec.vep_attribute17
369: ,p_vep_attribute18_o
370: => ben_vep_shd.g_old_rec.vep_attribute18
371: ,p_vep_attribute19_o
372: => ben_vep_shd.g_old_rec.vep_attribute19

Line 370: => ben_vep_shd.g_old_rec.vep_attribute18

366: => ben_vep_shd.g_old_rec.vep_attribute16
367: ,p_vep_attribute17_o
368: => ben_vep_shd.g_old_rec.vep_attribute17
369: ,p_vep_attribute18_o
370: => ben_vep_shd.g_old_rec.vep_attribute18
371: ,p_vep_attribute19_o
372: => ben_vep_shd.g_old_rec.vep_attribute19
373: ,p_vep_attribute20_o
374: => ben_vep_shd.g_old_rec.vep_attribute20

Line 372: => ben_vep_shd.g_old_rec.vep_attribute19

368: => ben_vep_shd.g_old_rec.vep_attribute17
369: ,p_vep_attribute18_o
370: => ben_vep_shd.g_old_rec.vep_attribute18
371: ,p_vep_attribute19_o
372: => ben_vep_shd.g_old_rec.vep_attribute19
373: ,p_vep_attribute20_o
374: => ben_vep_shd.g_old_rec.vep_attribute20
375: ,p_vep_attribute21_o
376: => ben_vep_shd.g_old_rec.vep_attribute21

Line 374: => ben_vep_shd.g_old_rec.vep_attribute20

370: => ben_vep_shd.g_old_rec.vep_attribute18
371: ,p_vep_attribute19_o
372: => ben_vep_shd.g_old_rec.vep_attribute19
373: ,p_vep_attribute20_o
374: => ben_vep_shd.g_old_rec.vep_attribute20
375: ,p_vep_attribute21_o
376: => ben_vep_shd.g_old_rec.vep_attribute21
377: ,p_vep_attribute22_o
378: => ben_vep_shd.g_old_rec.vep_attribute22

Line 376: => ben_vep_shd.g_old_rec.vep_attribute21

372: => ben_vep_shd.g_old_rec.vep_attribute19
373: ,p_vep_attribute20_o
374: => ben_vep_shd.g_old_rec.vep_attribute20
375: ,p_vep_attribute21_o
376: => ben_vep_shd.g_old_rec.vep_attribute21
377: ,p_vep_attribute22_o
378: => ben_vep_shd.g_old_rec.vep_attribute22
379: ,p_vep_attribute23_o
380: => ben_vep_shd.g_old_rec.vep_attribute23

Line 378: => ben_vep_shd.g_old_rec.vep_attribute22

374: => ben_vep_shd.g_old_rec.vep_attribute20
375: ,p_vep_attribute21_o
376: => ben_vep_shd.g_old_rec.vep_attribute21
377: ,p_vep_attribute22_o
378: => ben_vep_shd.g_old_rec.vep_attribute22
379: ,p_vep_attribute23_o
380: => ben_vep_shd.g_old_rec.vep_attribute23
381: ,p_vep_attribute24_o
382: => ben_vep_shd.g_old_rec.vep_attribute24

Line 380: => ben_vep_shd.g_old_rec.vep_attribute23

376: => ben_vep_shd.g_old_rec.vep_attribute21
377: ,p_vep_attribute22_o
378: => ben_vep_shd.g_old_rec.vep_attribute22
379: ,p_vep_attribute23_o
380: => ben_vep_shd.g_old_rec.vep_attribute23
381: ,p_vep_attribute24_o
382: => ben_vep_shd.g_old_rec.vep_attribute24
383: ,p_vep_attribute25_o
384: => ben_vep_shd.g_old_rec.vep_attribute25

Line 382: => ben_vep_shd.g_old_rec.vep_attribute24

378: => ben_vep_shd.g_old_rec.vep_attribute22
379: ,p_vep_attribute23_o
380: => ben_vep_shd.g_old_rec.vep_attribute23
381: ,p_vep_attribute24_o
382: => ben_vep_shd.g_old_rec.vep_attribute24
383: ,p_vep_attribute25_o
384: => ben_vep_shd.g_old_rec.vep_attribute25
385: ,p_vep_attribute26_o
386: => ben_vep_shd.g_old_rec.vep_attribute26

Line 384: => ben_vep_shd.g_old_rec.vep_attribute25

380: => ben_vep_shd.g_old_rec.vep_attribute23
381: ,p_vep_attribute24_o
382: => ben_vep_shd.g_old_rec.vep_attribute24
383: ,p_vep_attribute25_o
384: => ben_vep_shd.g_old_rec.vep_attribute25
385: ,p_vep_attribute26_o
386: => ben_vep_shd.g_old_rec.vep_attribute26
387: ,p_vep_attribute27_o
388: => ben_vep_shd.g_old_rec.vep_attribute27

Line 386: => ben_vep_shd.g_old_rec.vep_attribute26

382: => ben_vep_shd.g_old_rec.vep_attribute24
383: ,p_vep_attribute25_o
384: => ben_vep_shd.g_old_rec.vep_attribute25
385: ,p_vep_attribute26_o
386: => ben_vep_shd.g_old_rec.vep_attribute26
387: ,p_vep_attribute27_o
388: => ben_vep_shd.g_old_rec.vep_attribute27
389: ,p_vep_attribute28_o
390: => ben_vep_shd.g_old_rec.vep_attribute28

Line 388: => ben_vep_shd.g_old_rec.vep_attribute27

384: => ben_vep_shd.g_old_rec.vep_attribute25
385: ,p_vep_attribute26_o
386: => ben_vep_shd.g_old_rec.vep_attribute26
387: ,p_vep_attribute27_o
388: => ben_vep_shd.g_old_rec.vep_attribute27
389: ,p_vep_attribute28_o
390: => ben_vep_shd.g_old_rec.vep_attribute28
391: ,p_vep_attribute29_o
392: => ben_vep_shd.g_old_rec.vep_attribute29

Line 390: => ben_vep_shd.g_old_rec.vep_attribute28

386: => ben_vep_shd.g_old_rec.vep_attribute26
387: ,p_vep_attribute27_o
388: => ben_vep_shd.g_old_rec.vep_attribute27
389: ,p_vep_attribute28_o
390: => ben_vep_shd.g_old_rec.vep_attribute28
391: ,p_vep_attribute29_o
392: => ben_vep_shd.g_old_rec.vep_attribute29
393: ,p_vep_attribute30_o
394: => ben_vep_shd.g_old_rec.vep_attribute30

Line 392: => ben_vep_shd.g_old_rec.vep_attribute29

388: => ben_vep_shd.g_old_rec.vep_attribute27
389: ,p_vep_attribute28_o
390: => ben_vep_shd.g_old_rec.vep_attribute28
391: ,p_vep_attribute29_o
392: => ben_vep_shd.g_old_rec.vep_attribute29
393: ,p_vep_attribute30_o
394: => ben_vep_shd.g_old_rec.vep_attribute30
395: ,p_object_version_number_o
396: => ben_vep_shd.g_old_rec.object_version_number

Line 394: => ben_vep_shd.g_old_rec.vep_attribute30

390: => ben_vep_shd.g_old_rec.vep_attribute28
391: ,p_vep_attribute29_o
392: => ben_vep_shd.g_old_rec.vep_attribute29
393: ,p_vep_attribute30_o
394: => ben_vep_shd.g_old_rec.vep_attribute30
395: ,p_object_version_number_o
396: => ben_vep_shd.g_old_rec.object_version_number
397: );
398: --

Line 396: => ben_vep_shd.g_old_rec.object_version_number

392: => ben_vep_shd.g_old_rec.vep_attribute29
393: ,p_vep_attribute30_o
394: => ben_vep_shd.g_old_rec.vep_attribute30
395: ,p_object_version_number_o
396: => ben_vep_shd.g_old_rec.object_version_number
397: );
398: --
399: exception
400: --

Line 418: ,p_rec in out nocopy ben_vep_shd.g_rec_type

414: -- ----------------------------------------------------------------------------
415: Procedure del
416: (p_effective_date in date
417: ,p_datetrack_mode in varchar2
418: ,p_rec in out nocopy ben_vep_shd.g_rec_type
419: ) is
420: --
421: l_proc varchar2(72) := g_package||'del';
422: l_validation_start_date date;

Line 434: ben_vep_shd.lck

430: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
431: --
432: -- We must lock the row which we need to delete.
433: --
434: ben_vep_shd.lck
435: (p_effective_date => p_effective_date
436: ,p_datetrack_mode => p_datetrack_mode
437: ,p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
438: ,p_object_version_number => p_rec.object_version_number

Line 497: l_rec ben_vep_shd.g_rec_type;

493: ,p_effective_start_date out nocopy date
494: ,p_effective_end_date out nocopy date
495: ) is
496: --
497: l_rec ben_vep_shd.g_rec_type;
498: l_proc varchar2(72) := g_package||'del';
499: --
500: Begin
501: hr_utility.set_location('Entering:'||l_proc, 5);