DBA Data[Home] [Help]

APPS.BEN_DPNT_EDC_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_dpnt_edc_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_dpnt_edc_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 77: hr_utility.set_location(l_proc, 15);

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

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

86: --
87: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status

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

108: --
109: l_proc varchar2(72) := g_package||'delete_dml';
110: --
111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: dt_delete_dml(p_rec => p_rec,
115: p_effective_date => p_effective_date,
116: p_datetrack_mode => p_datetrack_mode,

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

116: p_datetrack_mode => p_datetrack_mode,
117: p_validation_start_date => p_validation_start_date,
118: p_validation_end_date => p_validation_end_date);
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: end delete_dml;
122: --
123: -- ----------------------------------------------------------------------------
124: -- |----------------------------< dt_pre_delete >-----------------------------|

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

162: --
163: l_proc varchar2(72) := g_package||'dt_pre_delete';
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: If (p_datetrack_mode <> 'ZAP') then
169: --
170: p_rec.effective_start_date := ben_dpnt_edc_shd.g_old_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 237: hr_utility.set_location('Entering:'||l_proc, 5);

233: --
234: l_proc varchar2(72) := g_package||'pre_delete';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: --
240: --
241: dt_pre_delete

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

244: p_datetrack_mode => p_datetrack_mode,
245: p_validation_start_date => p_validation_start_date,
246: p_validation_end_date => p_validation_end_date);
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End pre_delete;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< post_delete >------------------------------|

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

289: --
290: l_proc varchar2(72) := g_package||'post_delete';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: --
296: -- Start of API User Hook for post_delete.
297: --

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

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

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

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

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

459: l_rec ben_dpnt_edc_shd.g_rec_type;
460: l_proc varchar2(72) := g_package||'del';
461: --
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: -- As the delete procedure accepts a plsql record structure we do need to
466: -- convert the arguments into the record structure.
467: -- 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:
486: end del;
487: --
488: end ben_dpnt_edc_del;