DBA Data[Home] [Help]

APPS.HR_CLE_DEL dependencies on HR_UTILITY

Line 64: hr_utility.set_location('Entering:'||l_proc, 5);

60: --
61: l_proc varchar2(72) := g_package||'dt_delete_dml';
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: --
67: --
68: -- Delete the where the effective start date is equal

Line 89: hr_utility.set_location(' Leaving:'||l_proc, 20);

85: --
86: --
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: End dt_delete_dml;
92: --
93: -- ----------------------------------------------------------------------------

Line 107: hr_utility.set_location('Entering:'||l_proc, 5);

103: --
104: l_proc varchar2(72) := g_package||'delete_dml';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: hr_cle_del.dt_delete_dml
110: (p_rec => p_rec
111: ,p_effective_date => p_effective_date

Line 117: hr_utility.set_location(' Leaving:'||l_proc, 10);

113: ,p_validation_start_date => p_validation_start_date
114: ,p_validation_end_date => p_validation_end_date
115: );
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: End delete_dml;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |----------------------------< dt_pre_delete >-----------------------------|

Line 164: hr_utility.set_location('Entering:'||l_proc, 5);

160: --
161: l_proc varchar2(72) := g_package||'dt_pre_delete';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date

Line 191: hr_utility.set_location(' Leaving:'||l_proc, 10);

187: Else
188: p_rec.effective_start_date := null;
189: p_rec.effective_end_date := null;
190: End If;
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End dt_pre_delete;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |------------------------------< pre_delete >------------------------------|

Line 240: hr_utility.set_location('Entering:'||l_proc, 5);

236: --
237: --
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: --
243: --
244: hr_cle_del.dt_pre_delete

Line 252: hr_utility.set_location(' Leaving:'||l_proc, 10);

248: ,p_validation_start_date => p_validation_start_date
249: ,p_validation_end_date => p_validation_end_date
250: );
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End pre_delete;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |----------------------------< post_delete >-------------------------------|

Line 298: hr_utility.set_location('Entering:'||l_proc, 5);

294: --
295: l_proc varchar2(72) := g_package||'post_delete';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: begin
300: --
301: hr_cle_rkd.after_delete
302: (p_effective_date

Line 434: hr_utility.set_location(' Leaving:'||l_proc, 10);

430: ,p_hook_type => 'AD');
431: --
432: end;
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);
435: End post_delete;
436: --
437: -- ----------------------------------------------------------------------------
438: -- |---------------------------------< del >----------------------------------|

Line 451: hr_utility.set_location('Entering:'||l_proc, 5);

447: l_validation_start_date date;
448: l_validation_end_date date;
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Ensure that the DateTrack delete mode is valid
454: --
455: hr_utility.trace('object1' ||p_rec.object_version_number);

Line 455: hr_utility.trace('object1' ||p_rec.object_version_number);

451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Ensure that the DateTrack delete mode is valid
454: --
455: hr_utility.trace('object1' ||p_rec.object_version_number);
456: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
457: hr_utility.trace('object2' ||p_rec.object_version_number);
458: --
459: -- We must lock the row which we need to delete.

Line 457: hr_utility.trace('object2' ||p_rec.object_version_number);

453: -- Ensure that the DateTrack delete mode is valid
454: --
455: hr_utility.trace('object1' ||p_rec.object_version_number);
456: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
457: hr_utility.trace('object2' ||p_rec.object_version_number);
458: --
459: -- We must lock the row which we need to delete.
460: --
461: hr_cle_shd.lck

Line 509: hr_utility.set_location(' Leaving:'||l_proc, 5);

505: ,p_validation_start_date => l_validation_start_date
506: ,p_validation_end_date => l_validation_end_date
507: );
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 5);
510: End del;
511: --
512: -- ----------------------------------------------------------------------------
513: -- |--------------------------------< del >-----------------------------------|

Line 528: hr_utility.set_location('Entering:'||l_proc, 5);

524: l_rec hr_cle_shd.g_rec_type;
525: l_proc varchar2(72) := g_package||'del';
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- As the delete procedure accepts a plsql record structure we do need to
531: -- convert the arguments into the record structure.
532: -- We don't need to call the supplied conversion argument routine as we

Line 535: hr_utility.trace('passed' ||p_object_version_number);

531: -- convert the arguments into the record structure.
532: -- We don't need to call the supplied conversion argument routine as we
533: -- only need a few attributes.
534: --
535: hr_utility.trace('passed' ||p_object_version_number);
536: l_rec.soc_ins_contr_lvls_id := p_soc_ins_contr_lvls_id;
537: l_rec.object_version_number := p_object_version_number;
538: --
539: -- Having converted the arguments into the hr_cle_rec

Line 543: hr_utility.trace('object3' ||l_rec.object_version_number);

539: -- Having converted the arguments into the hr_cle_rec
540: -- plsql record structure we must call the corresponding entity
541: -- business process
542: --
543: hr_utility.trace('object3' ||l_rec.object_version_number);
544:
545: hr_cle_del.del
546: (p_effective_date
547: ,p_datetrack_mode

Line 558: hr_utility.set_location(' Leaving:'||l_proc, 10);

554: p_object_version_number := l_rec.object_version_number;
555: p_effective_start_date := l_rec.effective_start_date;
556: p_effective_end_date := l_rec.effective_end_date;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End del;
560: --
561: end hr_cle_del;