50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_cty_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
93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ben_cty_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
150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ben_cty_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
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := ben_cty_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
175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_cty_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.comptncy_rt_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy ben_cty_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
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in ben_cty_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
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_cty_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_cty_shd.g_old_rec.effective_end_date
320: ,p_competence_id_o
321: => ben_cty_shd.g_old_rec.competence_id
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => ben_cty_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_cty_shd.g_old_rec.effective_end_date
320: ,p_competence_id_o
321: => ben_cty_shd.g_old_rec.competence_id
322: ,p_rating_level_id_o
323: => ben_cty_shd.g_old_rec.rating_level_id
317: => ben_cty_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => ben_cty_shd.g_old_rec.effective_end_date
320: ,p_competence_id_o
321: => ben_cty_shd.g_old_rec.competence_id
322: ,p_rating_level_id_o
323: => ben_cty_shd.g_old_rec.rating_level_id
324: ,p_excld_flag_o
325: => ben_cty_shd.g_old_rec.excld_flag
319: => ben_cty_shd.g_old_rec.effective_end_date
320: ,p_competence_id_o
321: => ben_cty_shd.g_old_rec.competence_id
322: ,p_rating_level_id_o
323: => ben_cty_shd.g_old_rec.rating_level_id
324: ,p_excld_flag_o
325: => ben_cty_shd.g_old_rec.excld_flag
326: ,p_business_group_id_o
327: => ben_cty_shd.g_old_rec.business_group_id
321: => ben_cty_shd.g_old_rec.competence_id
322: ,p_rating_level_id_o
323: => ben_cty_shd.g_old_rec.rating_level_id
324: ,p_excld_flag_o
325: => ben_cty_shd.g_old_rec.excld_flag
326: ,p_business_group_id_o
327: => ben_cty_shd.g_old_rec.business_group_id
328: ,p_vrbl_rt_prfl_id_o
329: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
323: => ben_cty_shd.g_old_rec.rating_level_id
324: ,p_excld_flag_o
325: => ben_cty_shd.g_old_rec.excld_flag
326: ,p_business_group_id_o
327: => ben_cty_shd.g_old_rec.business_group_id
328: ,p_vrbl_rt_prfl_id_o
329: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
330: ,p_object_version_number_o
331: => ben_cty_shd.g_old_rec.object_version_number
325: => ben_cty_shd.g_old_rec.excld_flag
326: ,p_business_group_id_o
327: => ben_cty_shd.g_old_rec.business_group_id
328: ,p_vrbl_rt_prfl_id_o
329: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
330: ,p_object_version_number_o
331: => ben_cty_shd.g_old_rec.object_version_number
332: ,p_ordr_num_o
333: => ben_cty_shd.g_old_rec.ordr_num
327: => ben_cty_shd.g_old_rec.business_group_id
328: ,p_vrbl_rt_prfl_id_o
329: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
330: ,p_object_version_number_o
331: => ben_cty_shd.g_old_rec.object_version_number
332: ,p_ordr_num_o
333: => ben_cty_shd.g_old_rec.ordr_num
334: ,p_cty_attribute_category_o
335: => ben_cty_shd.g_old_rec.cty_attribute_category
329: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
330: ,p_object_version_number_o
331: => ben_cty_shd.g_old_rec.object_version_number
332: ,p_ordr_num_o
333: => ben_cty_shd.g_old_rec.ordr_num
334: ,p_cty_attribute_category_o
335: => ben_cty_shd.g_old_rec.cty_attribute_category
336: ,p_cty_attribute1_o
337: => ben_cty_shd.g_old_rec.cty_attribute1
331: => ben_cty_shd.g_old_rec.object_version_number
332: ,p_ordr_num_o
333: => ben_cty_shd.g_old_rec.ordr_num
334: ,p_cty_attribute_category_o
335: => ben_cty_shd.g_old_rec.cty_attribute_category
336: ,p_cty_attribute1_o
337: => ben_cty_shd.g_old_rec.cty_attribute1
338: ,p_cty_attribute2_o
339: => ben_cty_shd.g_old_rec.cty_attribute2
333: => ben_cty_shd.g_old_rec.ordr_num
334: ,p_cty_attribute_category_o
335: => ben_cty_shd.g_old_rec.cty_attribute_category
336: ,p_cty_attribute1_o
337: => ben_cty_shd.g_old_rec.cty_attribute1
338: ,p_cty_attribute2_o
339: => ben_cty_shd.g_old_rec.cty_attribute2
340: ,p_cty_attribute3_o
341: => ben_cty_shd.g_old_rec.cty_attribute3
335: => ben_cty_shd.g_old_rec.cty_attribute_category
336: ,p_cty_attribute1_o
337: => ben_cty_shd.g_old_rec.cty_attribute1
338: ,p_cty_attribute2_o
339: => ben_cty_shd.g_old_rec.cty_attribute2
340: ,p_cty_attribute3_o
341: => ben_cty_shd.g_old_rec.cty_attribute3
342: ,p_cty_attribute4_o
343: => ben_cty_shd.g_old_rec.cty_attribute4
337: => ben_cty_shd.g_old_rec.cty_attribute1
338: ,p_cty_attribute2_o
339: => ben_cty_shd.g_old_rec.cty_attribute2
340: ,p_cty_attribute3_o
341: => ben_cty_shd.g_old_rec.cty_attribute3
342: ,p_cty_attribute4_o
343: => ben_cty_shd.g_old_rec.cty_attribute4
344: ,p_cty_attribute5_o
345: => ben_cty_shd.g_old_rec.cty_attribute5
339: => ben_cty_shd.g_old_rec.cty_attribute2
340: ,p_cty_attribute3_o
341: => ben_cty_shd.g_old_rec.cty_attribute3
342: ,p_cty_attribute4_o
343: => ben_cty_shd.g_old_rec.cty_attribute4
344: ,p_cty_attribute5_o
345: => ben_cty_shd.g_old_rec.cty_attribute5
346: ,p_cty_attribute6_o
347: => ben_cty_shd.g_old_rec.cty_attribute6
341: => ben_cty_shd.g_old_rec.cty_attribute3
342: ,p_cty_attribute4_o
343: => ben_cty_shd.g_old_rec.cty_attribute4
344: ,p_cty_attribute5_o
345: => ben_cty_shd.g_old_rec.cty_attribute5
346: ,p_cty_attribute6_o
347: => ben_cty_shd.g_old_rec.cty_attribute6
348: ,p_cty_attribute7_o
349: => ben_cty_shd.g_old_rec.cty_attribute7
343: => ben_cty_shd.g_old_rec.cty_attribute4
344: ,p_cty_attribute5_o
345: => ben_cty_shd.g_old_rec.cty_attribute5
346: ,p_cty_attribute6_o
347: => ben_cty_shd.g_old_rec.cty_attribute6
348: ,p_cty_attribute7_o
349: => ben_cty_shd.g_old_rec.cty_attribute7
350: ,p_cty_attribute8_o
351: => ben_cty_shd.g_old_rec.cty_attribute8
345: => ben_cty_shd.g_old_rec.cty_attribute5
346: ,p_cty_attribute6_o
347: => ben_cty_shd.g_old_rec.cty_attribute6
348: ,p_cty_attribute7_o
349: => ben_cty_shd.g_old_rec.cty_attribute7
350: ,p_cty_attribute8_o
351: => ben_cty_shd.g_old_rec.cty_attribute8
352: ,p_cty_attribute9_o
353: => ben_cty_shd.g_old_rec.cty_attribute9
347: => ben_cty_shd.g_old_rec.cty_attribute6
348: ,p_cty_attribute7_o
349: => ben_cty_shd.g_old_rec.cty_attribute7
350: ,p_cty_attribute8_o
351: => ben_cty_shd.g_old_rec.cty_attribute8
352: ,p_cty_attribute9_o
353: => ben_cty_shd.g_old_rec.cty_attribute9
354: ,p_cty_attribute10_o
355: => ben_cty_shd.g_old_rec.cty_attribute10
349: => ben_cty_shd.g_old_rec.cty_attribute7
350: ,p_cty_attribute8_o
351: => ben_cty_shd.g_old_rec.cty_attribute8
352: ,p_cty_attribute9_o
353: => ben_cty_shd.g_old_rec.cty_attribute9
354: ,p_cty_attribute10_o
355: => ben_cty_shd.g_old_rec.cty_attribute10
356: ,p_cty_attribute11_o
357: => ben_cty_shd.g_old_rec.cty_attribute11
351: => ben_cty_shd.g_old_rec.cty_attribute8
352: ,p_cty_attribute9_o
353: => ben_cty_shd.g_old_rec.cty_attribute9
354: ,p_cty_attribute10_o
355: => ben_cty_shd.g_old_rec.cty_attribute10
356: ,p_cty_attribute11_o
357: => ben_cty_shd.g_old_rec.cty_attribute11
358: ,p_cty_attribute12_o
359: => ben_cty_shd.g_old_rec.cty_attribute12
353: => ben_cty_shd.g_old_rec.cty_attribute9
354: ,p_cty_attribute10_o
355: => ben_cty_shd.g_old_rec.cty_attribute10
356: ,p_cty_attribute11_o
357: => ben_cty_shd.g_old_rec.cty_attribute11
358: ,p_cty_attribute12_o
359: => ben_cty_shd.g_old_rec.cty_attribute12
360: ,p_cty_attribute13_o
361: => ben_cty_shd.g_old_rec.cty_attribute13
355: => ben_cty_shd.g_old_rec.cty_attribute10
356: ,p_cty_attribute11_o
357: => ben_cty_shd.g_old_rec.cty_attribute11
358: ,p_cty_attribute12_o
359: => ben_cty_shd.g_old_rec.cty_attribute12
360: ,p_cty_attribute13_o
361: => ben_cty_shd.g_old_rec.cty_attribute13
362: ,p_cty_attribute14_o
363: => ben_cty_shd.g_old_rec.cty_attribute14
357: => ben_cty_shd.g_old_rec.cty_attribute11
358: ,p_cty_attribute12_o
359: => ben_cty_shd.g_old_rec.cty_attribute12
360: ,p_cty_attribute13_o
361: => ben_cty_shd.g_old_rec.cty_attribute13
362: ,p_cty_attribute14_o
363: => ben_cty_shd.g_old_rec.cty_attribute14
364: ,p_cty_attribute15_o
365: => ben_cty_shd.g_old_rec.cty_attribute15
359: => ben_cty_shd.g_old_rec.cty_attribute12
360: ,p_cty_attribute13_o
361: => ben_cty_shd.g_old_rec.cty_attribute13
362: ,p_cty_attribute14_o
363: => ben_cty_shd.g_old_rec.cty_attribute14
364: ,p_cty_attribute15_o
365: => ben_cty_shd.g_old_rec.cty_attribute15
366: ,p_cty_attribute16_o
367: => ben_cty_shd.g_old_rec.cty_attribute16
361: => ben_cty_shd.g_old_rec.cty_attribute13
362: ,p_cty_attribute14_o
363: => ben_cty_shd.g_old_rec.cty_attribute14
364: ,p_cty_attribute15_o
365: => ben_cty_shd.g_old_rec.cty_attribute15
366: ,p_cty_attribute16_o
367: => ben_cty_shd.g_old_rec.cty_attribute16
368: ,p_cty_attribute17_o
369: => ben_cty_shd.g_old_rec.cty_attribute17
363: => ben_cty_shd.g_old_rec.cty_attribute14
364: ,p_cty_attribute15_o
365: => ben_cty_shd.g_old_rec.cty_attribute15
366: ,p_cty_attribute16_o
367: => ben_cty_shd.g_old_rec.cty_attribute16
368: ,p_cty_attribute17_o
369: => ben_cty_shd.g_old_rec.cty_attribute17
370: ,p_cty_attribute18_o
371: => ben_cty_shd.g_old_rec.cty_attribute18
365: => ben_cty_shd.g_old_rec.cty_attribute15
366: ,p_cty_attribute16_o
367: => ben_cty_shd.g_old_rec.cty_attribute16
368: ,p_cty_attribute17_o
369: => ben_cty_shd.g_old_rec.cty_attribute17
370: ,p_cty_attribute18_o
371: => ben_cty_shd.g_old_rec.cty_attribute18
372: ,p_cty_attribute19_o
373: => ben_cty_shd.g_old_rec.cty_attribute19
367: => ben_cty_shd.g_old_rec.cty_attribute16
368: ,p_cty_attribute17_o
369: => ben_cty_shd.g_old_rec.cty_attribute17
370: ,p_cty_attribute18_o
371: => ben_cty_shd.g_old_rec.cty_attribute18
372: ,p_cty_attribute19_o
373: => ben_cty_shd.g_old_rec.cty_attribute19
374: ,p_cty_attribute20_o
375: => ben_cty_shd.g_old_rec.cty_attribute20
369: => ben_cty_shd.g_old_rec.cty_attribute17
370: ,p_cty_attribute18_o
371: => ben_cty_shd.g_old_rec.cty_attribute18
372: ,p_cty_attribute19_o
373: => ben_cty_shd.g_old_rec.cty_attribute19
374: ,p_cty_attribute20_o
375: => ben_cty_shd.g_old_rec.cty_attribute20
376: ,p_cty_attribute21_o
377: => ben_cty_shd.g_old_rec.cty_attribute21
371: => ben_cty_shd.g_old_rec.cty_attribute18
372: ,p_cty_attribute19_o
373: => ben_cty_shd.g_old_rec.cty_attribute19
374: ,p_cty_attribute20_o
375: => ben_cty_shd.g_old_rec.cty_attribute20
376: ,p_cty_attribute21_o
377: => ben_cty_shd.g_old_rec.cty_attribute21
378: ,p_cty_attribute22_o
379: => ben_cty_shd.g_old_rec.cty_attribute22
373: => ben_cty_shd.g_old_rec.cty_attribute19
374: ,p_cty_attribute20_o
375: => ben_cty_shd.g_old_rec.cty_attribute20
376: ,p_cty_attribute21_o
377: => ben_cty_shd.g_old_rec.cty_attribute21
378: ,p_cty_attribute22_o
379: => ben_cty_shd.g_old_rec.cty_attribute22
380: ,p_cty_attribute23_o
381: => ben_cty_shd.g_old_rec.cty_attribute23
375: => ben_cty_shd.g_old_rec.cty_attribute20
376: ,p_cty_attribute21_o
377: => ben_cty_shd.g_old_rec.cty_attribute21
378: ,p_cty_attribute22_o
379: => ben_cty_shd.g_old_rec.cty_attribute22
380: ,p_cty_attribute23_o
381: => ben_cty_shd.g_old_rec.cty_attribute23
382: ,p_cty_attribute24_o
383: => ben_cty_shd.g_old_rec.cty_attribute24
377: => ben_cty_shd.g_old_rec.cty_attribute21
378: ,p_cty_attribute22_o
379: => ben_cty_shd.g_old_rec.cty_attribute22
380: ,p_cty_attribute23_o
381: => ben_cty_shd.g_old_rec.cty_attribute23
382: ,p_cty_attribute24_o
383: => ben_cty_shd.g_old_rec.cty_attribute24
384: ,p_cty_attribute25_o
385: => ben_cty_shd.g_old_rec.cty_attribute25
379: => ben_cty_shd.g_old_rec.cty_attribute22
380: ,p_cty_attribute23_o
381: => ben_cty_shd.g_old_rec.cty_attribute23
382: ,p_cty_attribute24_o
383: => ben_cty_shd.g_old_rec.cty_attribute24
384: ,p_cty_attribute25_o
385: => ben_cty_shd.g_old_rec.cty_attribute25
386: ,p_cty_attribute26_o
387: => ben_cty_shd.g_old_rec.cty_attribute26
381: => ben_cty_shd.g_old_rec.cty_attribute23
382: ,p_cty_attribute24_o
383: => ben_cty_shd.g_old_rec.cty_attribute24
384: ,p_cty_attribute25_o
385: => ben_cty_shd.g_old_rec.cty_attribute25
386: ,p_cty_attribute26_o
387: => ben_cty_shd.g_old_rec.cty_attribute26
388: ,p_cty_attribute27_o
389: => ben_cty_shd.g_old_rec.cty_attribute27
383: => ben_cty_shd.g_old_rec.cty_attribute24
384: ,p_cty_attribute25_o
385: => ben_cty_shd.g_old_rec.cty_attribute25
386: ,p_cty_attribute26_o
387: => ben_cty_shd.g_old_rec.cty_attribute26
388: ,p_cty_attribute27_o
389: => ben_cty_shd.g_old_rec.cty_attribute27
390: ,p_cty_attribute28_o
391: => ben_cty_shd.g_old_rec.cty_attribute28
385: => ben_cty_shd.g_old_rec.cty_attribute25
386: ,p_cty_attribute26_o
387: => ben_cty_shd.g_old_rec.cty_attribute26
388: ,p_cty_attribute27_o
389: => ben_cty_shd.g_old_rec.cty_attribute27
390: ,p_cty_attribute28_o
391: => ben_cty_shd.g_old_rec.cty_attribute28
392: ,p_cty_attribute29_o
393: => ben_cty_shd.g_old_rec.cty_attribute29
387: => ben_cty_shd.g_old_rec.cty_attribute26
388: ,p_cty_attribute27_o
389: => ben_cty_shd.g_old_rec.cty_attribute27
390: ,p_cty_attribute28_o
391: => ben_cty_shd.g_old_rec.cty_attribute28
392: ,p_cty_attribute29_o
393: => ben_cty_shd.g_old_rec.cty_attribute29
394: ,p_cty_attribute30_o
395: => ben_cty_shd.g_old_rec.cty_attribute30
389: => ben_cty_shd.g_old_rec.cty_attribute27
390: ,p_cty_attribute28_o
391: => ben_cty_shd.g_old_rec.cty_attribute28
392: ,p_cty_attribute29_o
393: => ben_cty_shd.g_old_rec.cty_attribute29
394: ,p_cty_attribute30_o
395: => ben_cty_shd.g_old_rec.cty_attribute30
396: );
397: --
391: => ben_cty_shd.g_old_rec.cty_attribute28
392: ,p_cty_attribute29_o
393: => ben_cty_shd.g_old_rec.cty_attribute29
394: ,p_cty_attribute30_o
395: => ben_cty_shd.g_old_rec.cty_attribute30
396: );
397: --
398: exception
399: --
413: -- ----------------------------------------------------------------------------
414: Procedure del
415: (p_effective_date in date
416: ,p_datetrack_mode in varchar2
417: ,p_rec in out nocopy ben_cty_shd.g_rec_type
418: ) is
419: --
420: l_proc varchar2(72) := g_package||'del';
421: l_validation_start_date date;
429: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
430: --
431: -- We must lock the row which we need to delete.
432: --
433: ben_cty_shd.lck
434: (p_effective_date => p_effective_date
435: ,p_datetrack_mode => p_datetrack_mode
436: ,p_comptncy_rt_id => p_rec.comptncy_rt_id
437: ,p_object_version_number => p_rec.object_version_number
498: ,p_effective_start_date out nocopy date
499: ,p_effective_end_date out nocopy date
500: ) is
501: --
502: l_rec ben_cty_shd.g_rec_type;
503: l_proc varchar2(72) := g_package||'del';
504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);