DBA Data[Home] [Help]

APPS.BEN_REG_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_reg_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_reg_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 83: hr_utility.set_location(l_proc, 15);

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

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

98: --
99: ben_reg_shd.g_api_dml := false; -- Unset the api dml status
100: End If;
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 20);
103: --
104: Exception
105: When Others Then
106: ben_reg_shd.g_api_dml := false; -- Unset the api dml status

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

119: --
120: l_proc varchar2(72) := g_package||'delete_dml';
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: dt_delete_dml(p_rec => p_rec,
126: p_effective_date => p_effective_date,
127: p_datetrack_mode => p_datetrack_mode,

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

127: p_datetrack_mode => p_datetrack_mode,
128: p_validation_start_date => p_validation_start_date,
129: p_validation_end_date => p_validation_end_date);
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: End delete_dml;
133: --
134: -- ----------------------------------------------------------------------------
135: -- |----------------------------< dt_pre_delete >-----------------------------|

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

173: --
174: l_proc varchar2(72) := g_package||'dt_pre_delete';
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: If (p_datetrack_mode <> 'ZAP') then
180: --
181: p_rec.effective_start_date := ben_reg_shd.g_old_rec.effective_start_date;

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

198: Else
199: p_rec.effective_start_date := null;
200: p_rec.effective_end_date := null;
201: End If;
202: hr_utility.set_location(' Leaving:'||l_proc, 10);
203: End dt_pre_delete;
204: --
205: -- ----------------------------------------------------------------------------
206: -- |------------------------------< pre_delete >------------------------------|

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

246: --
247: --
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: --
253: --
254: dt_pre_delete

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

257: p_datetrack_mode => p_datetrack_mode,
258: p_validation_start_date => p_validation_start_date,
259: p_validation_end_date => p_validation_end_date);
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End pre_delete;
263: --
264: -- ----------------------------------------------------------------------------
265: -- |-----------------------------< post_delete >------------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'post_delete';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: --
309: -- Start of API User Hook for post_delete.
310: --

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

370: --
371: -- End of API User Hook for post_delete.
372: --
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: End post_delete;
376: --
377: -- ----------------------------------------------------------------------------
378: -- |---------------------------------< del >----------------------------------|

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

388: l_validation_start_date date;
389: l_validation_end_date date;
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: --
394: -- Ensure that the DateTrack delete mode is valid
395: --
396: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

458: l_rec ben_reg_shd.g_rec_type;
459: l_proc varchar2(72) := g_package||'del';
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- As the delete procedure accepts a plsql record structure we do need to
465: -- convert the arguments into the record structure.
466: -- We don't need to call the supplied conversion argument routine as we

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

480: p_object_version_number := l_rec.object_version_number;
481: p_effective_start_date := l_rec.effective_start_date;
482: p_effective_end_date := l_rec.effective_end_date;
483: --
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: End del;
486: --
487: end ben_reg_del;