APPS.BEN_BEP_DEL dependencies on BEN_BEP_SHD

Line 54: (p_rec in out nocopy ben_bep_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_bep_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 97: (p_rec in out nocopy ben_bep_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ben_bep_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy ben_bep_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ben_bep_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := ben_bep_shd.g_old_rec.effective_start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := ben_bep_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_bep_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_bep_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.elig_obj_elig_prfl_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy ben_bep_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy ben_bep_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in ben_bep_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in ben_bep_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 317: => ben_bep_shd.g_old_rec.effective_start_date

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => ben_bep_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_bep_shd.g_old_rec.effective_end_date
320: ,p_elig_obj_id_o
321: => ben_bep_shd.g_old_rec.elig_obj_id

Line 319: => ben_bep_shd.g_old_rec.effective_end_date

315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => ben_bep_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_bep_shd.g_old_rec.effective_end_date
320: ,p_elig_obj_id_o
321: => ben_bep_shd.g_old_rec.elig_obj_id
322: ,p_elig_prfl_id_o
323: => ben_bep_shd.g_old_rec.elig_prfl_id

Line 321: => ben_bep_shd.g_old_rec.elig_obj_id

317: => ben_bep_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_bep_shd.g_old_rec.effective_end_date
320: ,p_elig_obj_id_o
321: => ben_bep_shd.g_old_rec.elig_obj_id
322: ,p_elig_prfl_id_o
323: => ben_bep_shd.g_old_rec.elig_prfl_id
324: ,p_mndtry_flag_o
325: => ben_bep_shd.g_old_rec.mndtry_flag

Line 323: => ben_bep_shd.g_old_rec.elig_prfl_id

319: => ben_bep_shd.g_old_rec.effective_end_date
320: ,p_elig_obj_id_o
321: => ben_bep_shd.g_old_rec.elig_obj_id
322: ,p_elig_prfl_id_o
323: => ben_bep_shd.g_old_rec.elig_prfl_id
324: ,p_mndtry_flag_o
325: => ben_bep_shd.g_old_rec.mndtry_flag
326: ,p_business_group_id_o
327: => ben_bep_shd.g_old_rec.business_group_id

Line 325: => ben_bep_shd.g_old_rec.mndtry_flag

321: => ben_bep_shd.g_old_rec.elig_obj_id
322: ,p_elig_prfl_id_o
323: => ben_bep_shd.g_old_rec.elig_prfl_id
324: ,p_mndtry_flag_o
325: => ben_bep_shd.g_old_rec.mndtry_flag
326: ,p_business_group_id_o
327: => ben_bep_shd.g_old_rec.business_group_id
328: ,p_bep_attribute_category_o
329: => ben_bep_shd.g_old_rec.bep_attribute_category

Line 327: => ben_bep_shd.g_old_rec.business_group_id

323: => ben_bep_shd.g_old_rec.elig_prfl_id
324: ,p_mndtry_flag_o
325: => ben_bep_shd.g_old_rec.mndtry_flag
326: ,p_business_group_id_o
327: => ben_bep_shd.g_old_rec.business_group_id
328: ,p_bep_attribute_category_o
329: => ben_bep_shd.g_old_rec.bep_attribute_category
330: ,p_bep_attribute1_o
331: => ben_bep_shd.g_old_rec.bep_attribute1

Line 329: => ben_bep_shd.g_old_rec.bep_attribute_category

325: => ben_bep_shd.g_old_rec.mndtry_flag
326: ,p_business_group_id_o
327: => ben_bep_shd.g_old_rec.business_group_id
328: ,p_bep_attribute_category_o
329: => ben_bep_shd.g_old_rec.bep_attribute_category
330: ,p_bep_attribute1_o
331: => ben_bep_shd.g_old_rec.bep_attribute1
332: ,p_bep_attribute2_o
333: => ben_bep_shd.g_old_rec.bep_attribute2

Line 331: => ben_bep_shd.g_old_rec.bep_attribute1

327: => ben_bep_shd.g_old_rec.business_group_id
328: ,p_bep_attribute_category_o
329: => ben_bep_shd.g_old_rec.bep_attribute_category
330: ,p_bep_attribute1_o
331: => ben_bep_shd.g_old_rec.bep_attribute1
332: ,p_bep_attribute2_o
333: => ben_bep_shd.g_old_rec.bep_attribute2
334: ,p_bep_attribute3_o
335: => ben_bep_shd.g_old_rec.bep_attribute3

Line 333: => ben_bep_shd.g_old_rec.bep_attribute2

329: => ben_bep_shd.g_old_rec.bep_attribute_category
330: ,p_bep_attribute1_o
331: => ben_bep_shd.g_old_rec.bep_attribute1
332: ,p_bep_attribute2_o
333: => ben_bep_shd.g_old_rec.bep_attribute2
334: ,p_bep_attribute3_o
335: => ben_bep_shd.g_old_rec.bep_attribute3
336: ,p_bep_attribute4_o
337: => ben_bep_shd.g_old_rec.bep_attribute4

Line 335: => ben_bep_shd.g_old_rec.bep_attribute3

331: => ben_bep_shd.g_old_rec.bep_attribute1
332: ,p_bep_attribute2_o
333: => ben_bep_shd.g_old_rec.bep_attribute2
334: ,p_bep_attribute3_o
335: => ben_bep_shd.g_old_rec.bep_attribute3
336: ,p_bep_attribute4_o
337: => ben_bep_shd.g_old_rec.bep_attribute4
338: ,p_bep_attribute5_o
339: => ben_bep_shd.g_old_rec.bep_attribute5

Line 337: => ben_bep_shd.g_old_rec.bep_attribute4

333: => ben_bep_shd.g_old_rec.bep_attribute2
334: ,p_bep_attribute3_o
335: => ben_bep_shd.g_old_rec.bep_attribute3
336: ,p_bep_attribute4_o
337: => ben_bep_shd.g_old_rec.bep_attribute4
338: ,p_bep_attribute5_o
339: => ben_bep_shd.g_old_rec.bep_attribute5
340: ,p_bep_attribute6_o
341: => ben_bep_shd.g_old_rec.bep_attribute6

Line 339: => ben_bep_shd.g_old_rec.bep_attribute5

335: => ben_bep_shd.g_old_rec.bep_attribute3
336: ,p_bep_attribute4_o
337: => ben_bep_shd.g_old_rec.bep_attribute4
338: ,p_bep_attribute5_o
339: => ben_bep_shd.g_old_rec.bep_attribute5
340: ,p_bep_attribute6_o
341: => ben_bep_shd.g_old_rec.bep_attribute6
342: ,p_bep_attribute7_o
343: => ben_bep_shd.g_old_rec.bep_attribute7

Line 341: => ben_bep_shd.g_old_rec.bep_attribute6

337: => ben_bep_shd.g_old_rec.bep_attribute4
338: ,p_bep_attribute5_o
339: => ben_bep_shd.g_old_rec.bep_attribute5
340: ,p_bep_attribute6_o
341: => ben_bep_shd.g_old_rec.bep_attribute6
342: ,p_bep_attribute7_o
343: => ben_bep_shd.g_old_rec.bep_attribute7
344: ,p_bep_attribute8_o
345: => ben_bep_shd.g_old_rec.bep_attribute8

Line 343: => ben_bep_shd.g_old_rec.bep_attribute7

339: => ben_bep_shd.g_old_rec.bep_attribute5
340: ,p_bep_attribute6_o
341: => ben_bep_shd.g_old_rec.bep_attribute6
342: ,p_bep_attribute7_o
343: => ben_bep_shd.g_old_rec.bep_attribute7
344: ,p_bep_attribute8_o
345: => ben_bep_shd.g_old_rec.bep_attribute8
346: ,p_bep_attribute9_o
347: => ben_bep_shd.g_old_rec.bep_attribute9

Line 345: => ben_bep_shd.g_old_rec.bep_attribute8

341: => ben_bep_shd.g_old_rec.bep_attribute6
342: ,p_bep_attribute7_o
343: => ben_bep_shd.g_old_rec.bep_attribute7
344: ,p_bep_attribute8_o
345: => ben_bep_shd.g_old_rec.bep_attribute8
346: ,p_bep_attribute9_o
347: => ben_bep_shd.g_old_rec.bep_attribute9
348: ,p_bep_attribute10_o
349: => ben_bep_shd.g_old_rec.bep_attribute10

Line 347: => ben_bep_shd.g_old_rec.bep_attribute9

343: => ben_bep_shd.g_old_rec.bep_attribute7
344: ,p_bep_attribute8_o
345: => ben_bep_shd.g_old_rec.bep_attribute8
346: ,p_bep_attribute9_o
347: => ben_bep_shd.g_old_rec.bep_attribute9
348: ,p_bep_attribute10_o
349: => ben_bep_shd.g_old_rec.bep_attribute10
350: ,p_bep_attribute11_o
351: => ben_bep_shd.g_old_rec.bep_attribute11

Line 349: => ben_bep_shd.g_old_rec.bep_attribute10

345: => ben_bep_shd.g_old_rec.bep_attribute8
346: ,p_bep_attribute9_o
347: => ben_bep_shd.g_old_rec.bep_attribute9
348: ,p_bep_attribute10_o
349: => ben_bep_shd.g_old_rec.bep_attribute10
350: ,p_bep_attribute11_o
351: => ben_bep_shd.g_old_rec.bep_attribute11
352: ,p_bep_attribute12_o
353: => ben_bep_shd.g_old_rec.bep_attribute12

Line 351: => ben_bep_shd.g_old_rec.bep_attribute11

347: => ben_bep_shd.g_old_rec.bep_attribute9
348: ,p_bep_attribute10_o
349: => ben_bep_shd.g_old_rec.bep_attribute10
350: ,p_bep_attribute11_o
351: => ben_bep_shd.g_old_rec.bep_attribute11
352: ,p_bep_attribute12_o
353: => ben_bep_shd.g_old_rec.bep_attribute12
354: ,p_bep_attribute13_o
355: => ben_bep_shd.g_old_rec.bep_attribute13

Line 353: => ben_bep_shd.g_old_rec.bep_attribute12

349: => ben_bep_shd.g_old_rec.bep_attribute10
350: ,p_bep_attribute11_o
351: => ben_bep_shd.g_old_rec.bep_attribute11
352: ,p_bep_attribute12_o
353: => ben_bep_shd.g_old_rec.bep_attribute12
354: ,p_bep_attribute13_o
355: => ben_bep_shd.g_old_rec.bep_attribute13
356: ,p_bep_attribute14_o
357: => ben_bep_shd.g_old_rec.bep_attribute14

Line 355: => ben_bep_shd.g_old_rec.bep_attribute13

351: => ben_bep_shd.g_old_rec.bep_attribute11
352: ,p_bep_attribute12_o
353: => ben_bep_shd.g_old_rec.bep_attribute12
354: ,p_bep_attribute13_o
355: => ben_bep_shd.g_old_rec.bep_attribute13
356: ,p_bep_attribute14_o
357: => ben_bep_shd.g_old_rec.bep_attribute14
358: ,p_bep_attribute15_o
359: => ben_bep_shd.g_old_rec.bep_attribute15

Line 357: => ben_bep_shd.g_old_rec.bep_attribute14

353: => ben_bep_shd.g_old_rec.bep_attribute12
354: ,p_bep_attribute13_o
355: => ben_bep_shd.g_old_rec.bep_attribute13
356: ,p_bep_attribute14_o
357: => ben_bep_shd.g_old_rec.bep_attribute14
358: ,p_bep_attribute15_o
359: => ben_bep_shd.g_old_rec.bep_attribute15
360: ,p_bep_attribute16_o
361: => ben_bep_shd.g_old_rec.bep_attribute16

Line 359: => ben_bep_shd.g_old_rec.bep_attribute15

355: => ben_bep_shd.g_old_rec.bep_attribute13
356: ,p_bep_attribute14_o
357: => ben_bep_shd.g_old_rec.bep_attribute14
358: ,p_bep_attribute15_o
359: => ben_bep_shd.g_old_rec.bep_attribute15
360: ,p_bep_attribute16_o
361: => ben_bep_shd.g_old_rec.bep_attribute16
362: ,p_bep_attribute17_o
363: => ben_bep_shd.g_old_rec.bep_attribute17

Line 361: => ben_bep_shd.g_old_rec.bep_attribute16

357: => ben_bep_shd.g_old_rec.bep_attribute14
358: ,p_bep_attribute15_o
359: => ben_bep_shd.g_old_rec.bep_attribute15
360: ,p_bep_attribute16_o
361: => ben_bep_shd.g_old_rec.bep_attribute16
362: ,p_bep_attribute17_o
363: => ben_bep_shd.g_old_rec.bep_attribute17
364: ,p_bep_attribute18_o
365: => ben_bep_shd.g_old_rec.bep_attribute18

Line 363: => ben_bep_shd.g_old_rec.bep_attribute17

359: => ben_bep_shd.g_old_rec.bep_attribute15
360: ,p_bep_attribute16_o
361: => ben_bep_shd.g_old_rec.bep_attribute16
362: ,p_bep_attribute17_o
363: => ben_bep_shd.g_old_rec.bep_attribute17
364: ,p_bep_attribute18_o
365: => ben_bep_shd.g_old_rec.bep_attribute18
366: ,p_bep_attribute19_o
367: => ben_bep_shd.g_old_rec.bep_attribute19

Line 365: => ben_bep_shd.g_old_rec.bep_attribute18

361: => ben_bep_shd.g_old_rec.bep_attribute16
362: ,p_bep_attribute17_o
363: => ben_bep_shd.g_old_rec.bep_attribute17
364: ,p_bep_attribute18_o
365: => ben_bep_shd.g_old_rec.bep_attribute18
366: ,p_bep_attribute19_o
367: => ben_bep_shd.g_old_rec.bep_attribute19
368: ,p_bep_attribute20_o
369: => ben_bep_shd.g_old_rec.bep_attribute20

Line 367: => ben_bep_shd.g_old_rec.bep_attribute19

363: => ben_bep_shd.g_old_rec.bep_attribute17
364: ,p_bep_attribute18_o
365: => ben_bep_shd.g_old_rec.bep_attribute18
366: ,p_bep_attribute19_o
367: => ben_bep_shd.g_old_rec.bep_attribute19
368: ,p_bep_attribute20_o
369: => ben_bep_shd.g_old_rec.bep_attribute20
370: ,p_object_version_number_o
371: => ben_bep_shd.g_old_rec.object_version_number

Line 369: => ben_bep_shd.g_old_rec.bep_attribute20

365: => ben_bep_shd.g_old_rec.bep_attribute18
366: ,p_bep_attribute19_o
367: => ben_bep_shd.g_old_rec.bep_attribute19
368: ,p_bep_attribute20_o
369: => ben_bep_shd.g_old_rec.bep_attribute20
370: ,p_object_version_number_o
371: => ben_bep_shd.g_old_rec.object_version_number
372: );
373: --

Line 371: => ben_bep_shd.g_old_rec.object_version_number

367: => ben_bep_shd.g_old_rec.bep_attribute19
368: ,p_bep_attribute20_o
369: => ben_bep_shd.g_old_rec.bep_attribute20
370: ,p_object_version_number_o
371: => ben_bep_shd.g_old_rec.object_version_number
372: );
373: --
374: exception
375: --

Line 393: ,p_rec in out nocopy ben_bep_shd.g_rec_type

389: -- ----------------------------------------------------------------------------
390: Procedure del
391: (p_effective_date in date
392: ,p_datetrack_mode in varchar2
393: ,p_rec in out nocopy ben_bep_shd.g_rec_type
394: ) is
395: --
396: l_proc varchar2(72) := g_package||'del';
397: l_validation_start_date date;

Line 409: ben_bep_shd.lck

405: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
406: --
407: -- We must lock the row which we need to delete.
408: --
409: ben_bep_shd.lck
410: (p_effective_date => p_effective_date
411: ,p_datetrack_mode => p_datetrack_mode
412: ,p_elig_obj_elig_prfl_id => p_rec.elig_obj_elig_prfl_id
413: ,p_object_version_number => p_rec.object_version_number

Line 478: l_rec ben_bep_shd.g_rec_type;

474: ,p_effective_start_date out nocopy date
475: ,p_effective_end_date out nocopy date
476: ) is
477: --
478: l_rec ben_bep_shd.g_rec_type;
479: l_proc varchar2(72) := g_package||'del';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);