DBA Data[Home] [Help]

APPS.BEN_LER_DEL dependencies on HR_UTILITY

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

59: --
60: l_proc varchar2(72) := g_package||'dt_delete_dml';
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_ler_shd.g_api_dml := true; -- Set the api dml status
67: --

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

61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_ler_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.

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

77: and effective_start_date = p_validation_start_date;
78: --
79: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
80: Else
81: hr_utility.set_location(l_proc, 15);
82: ben_ler_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Delete the row(s) where the effective start date is greater than
85: -- or equal to the validation start date.

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

94: --
95: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
96: End If;
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
99: --
100: Exception
101: When Others Then
102: ben_ler_shd.g_api_dml := false; -- Unset the api dml status

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

115: --
116: l_proc varchar2(72) := g_package||'delete_dml';
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: dt_delete_dml(p_rec => p_rec,
122: p_effective_date => p_effective_date,
123: p_datetrack_mode => p_datetrack_mode,

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

123: p_datetrack_mode => p_datetrack_mode,
124: p_validation_start_date => p_validation_start_date,
125: p_validation_end_date => p_validation_end_date);
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: End delete_dml;
129: --
130: -- ----------------------------------------------------------------------------
131: -- |----------------------------< dt_pre_delete >-----------------------------|

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

169: --
170: l_proc varchar2(72) := g_package||'dt_pre_delete';
171: --
172: Begin
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: If (p_datetrack_mode <> 'ZAP') then
176: --
177: p_rec.effective_start_date := ben_ler_shd.g_old_rec.effective_start_date;

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

194: Else
195: p_rec.effective_start_date := null;
196: p_rec.effective_end_date := null;
197: End If;
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End dt_pre_delete;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |------------------------------< pre_delete >------------------------------|

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

242: --
243: --
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: --
249: --
250: dt_pre_delete

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

253: p_datetrack_mode => p_datetrack_mode,
254: p_validation_start_date => p_validation_start_date,
255: p_validation_end_date => p_validation_end_date);
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End pre_delete;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |-----------------------------< post_delete >------------------------------|

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

298: --
299: l_proc varchar2(72) := g_package||'post_delete';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: --
305: -- Start of API User Hook for post_delete.
306: --

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

384: --
385: -- End of API User Hook for post_delete.
386: --
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End post_delete;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< del >----------------------------------|

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

402: l_validation_start_date date;
403: l_validation_end_date date;
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Ensure that the DateTrack delete mode is valid
409: --
410: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

472: l_rec ben_ler_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'del';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: -- As the delete procedure accepts a plsql record structure we do need to
479: -- convert the arguments into the record structure.
480: -- We don't need to call the supplied conversion argument routine as we

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

494: p_object_version_number := l_rec.object_version_number;
495: p_effective_start_date := l_rec.effective_start_date;
496: p_effective_end_date := l_rec.effective_end_date;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: End del;
500: --
501: end ben_ler_del;