DBA Data[Home] [Help]

APPS.PER_PTU_DEL dependencies on HR_UTILITY

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

53: --
54: l_proc varchar2(72) := g_package||'dt_delete_dml';
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 5);
58: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
59: hr_utility.set_location(l_proc, 10);
60: --
61: -- Delete the where the effective start date is equal

Line 59: hr_utility.set_location(l_proc, 10);

55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 5);
58: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
59: hr_utility.set_location(l_proc, 10);
60: --
61: -- Delete the where the effective start date is equal
62: -- to the validation end date.
63: --

Line 69: hr_utility.set_location(l_proc, 15);

65: where person_type_usage_id = p_rec.person_type_usage_id
66: and effective_start_date = p_validation_start_date;
67: --
68: Else
69: hr_utility.set_location(l_proc, 15);
70: --
71: -- Delete the row(s) where the effective start date is greater than
72: -- or equal to the validation start date.
73: --

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

76: and effective_start_date >= p_validation_start_date;
77: --
78: End If;
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 20);
81: --
82: Exception
83: When Others Then
84: Raise;

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

96: --
97: l_proc varchar2(72) := g_package||'delete_dml';
98: --
99: Begin
100: hr_utility.set_location('Entering:'||l_proc, 5);
101: --
102: dt_delete_dml(p_rec => p_rec,
103: p_effective_date => p_effective_date,
104: p_datetrack_mode => p_datetrack_mode,

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

104: p_datetrack_mode => p_datetrack_mode,
105: p_validation_start_date => p_validation_start_date,
106: p_validation_end_date => p_validation_end_date);
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: End delete_dml;
110: --
111: -- ----------------------------------------------------------------------------
112: -- |----------------------------< dt_pre_delete >-----------------------------|

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

150: --
151: l_proc varchar2(72) := g_package||'dt_pre_delete';
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: If (p_datetrack_mode <> 'ZAP') then
157: --
158: p_rec.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;

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

175: Else
176: p_rec.effective_start_date := null;
177: p_rec.effective_end_date := null;
178: End If;
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: End dt_pre_delete;
181: --
182: -- ----------------------------------------------------------------------------
183: -- |------------------------------< pre_delete >------------------------------|

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

223: --
224: --
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: --
230: --
231: dt_pre_delete

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

234: p_datetrack_mode => p_datetrack_mode,
235: p_validation_start_date => p_validation_start_date,
236: p_validation_end_date => p_validation_end_date);
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End pre_delete;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |-----------------------------< post_delete >------------------------------|

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

279: --
280: l_proc varchar2(72) := g_package||'post_delete';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: --
286: -- Start of API User Hook for post_delete.
287: begin

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

347: );
348: end;
349: -- End of API User Hook for post_delete.
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: End post_delete;
353: --
354: -- ----------------------------------------------------------------------------
355: -- |---------------------------------< del >----------------------------------|

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

365: l_validation_start_date date;
366: l_validation_end_date date;
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Ensure that the DateTrack delete mode is valid
372: --
373: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

435: l_rec per_ptu_shd.g_rec_type;
436: l_proc varchar2(72) := g_package||'del';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- As the delete procedure accepts a plsql record structure we do need to
442: -- convert the arguments into the record structure.
443: -- We don't need to call the supplied conversion argument routine as we

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

457: p_object_version_number := l_rec.object_version_number;
458: p_effective_start_date := l_rec.effective_start_date;
459: p_effective_end_date := l_rec.effective_end_date;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: End del;
463: --
464: end per_ptu_del;