DBA Data[Home] [Help]

APPS.BEN_CCT_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_cct_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_cct_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_cct_shd.g_api_dml := false; -- Unset the api dml status
82: Else
83: hr_utility.set_location(l_proc, 15);
84: ben_cct_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 100: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

378: --
379: -- End of API User Hook for post_delete.
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: End post_delete;
384: --
385: -- ----------------------------------------------------------------------------
386: -- |---------------------------------< del >----------------------------------|

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

396: l_validation_start_date date;
397: l_validation_end_date date;
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: -- Ensure that the DateTrack delete mode is valid
403: --
404: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

466: l_rec ben_cct_shd.g_rec_type;
467: l_proc varchar2(72) := g_package||'del';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- As the delete procedure accepts a plsql record structure we do need to
473: -- convert the arguments into the record structure.
474: -- We don't need to call the supplied conversion argument routine as we

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

488: p_object_version_number := l_rec.object_version_number;
489: p_effective_start_date := l_rec.effective_start_date;
490: p_effective_end_date := l_rec.effective_end_date;
491: --
492: hr_utility.set_location(' Leaving:'||l_proc, 10);
493: End del;
494: --
495: end ben_cct_del;