DBA Data[Home] [Help]

APPS.PER_SPP_DEL dependencies on HR_UTILITY

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

60: --
61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: per_spp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal

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

85: --
86: per_spp_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: per_spp_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: per_spp_del.dt_delete_dml
115: (p_rec => p_rec
116: ,p_effective_date => p_effective_date

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

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

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

165: --
166: l_proc varchar2(72) := g_package||'dt_pre_delete';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date

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

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

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

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

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

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

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

317: and effective_start_date > p_rec.effective_start_date;
318: -- changes end for 7457065
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322:
323: -- Code changes start for bug 7457065
324: If (p_datetrack_mode <> hr_api.g_zap) then
325: open c_step_end_date;

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

434: ,p_hook_type => 'AD');
435: --
436: end;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: End post_delete;
440: --
441: -- ----------------------------------------------------------------------------
442: -- |---------------------------------< del >----------------------------------|

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

451: l_validation_start_date date;
452: l_validation_end_date date;
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the DateTrack delete mode is valid
458: --
459: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 513: hr_utility.set_location(' Leaving:'||l_proc, 5);

509: ,p_validation_end_date => l_validation_end_date
510: );
511:
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 5);
514: End del;
515: --
516: -- ----------------------------------------------------------------------------
517: -- |--------------------------------< del >-----------------------------------|

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

528: l_rec per_spp_shd.g_rec_type;
529: l_proc varchar2(72) := g_package||'del';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: -- As the delete procedure accepts a plsql record structure we do need to
535: -- convert the arguments into the record structure.
536: -- We don't need to call the supplied conversion argument routine as we

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

554: p_object_version_number := l_rec.object_version_number;
555: p_effective_start_date := l_rec.effective_start_date;
556: p_effective_end_date := l_rec.effective_end_date;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End del;
560: --
561: end per_spp_del;