[Home] [Help]
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
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
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
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 >-----------------------------|
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
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 >------------------------------|
241: --
242: --
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: --
248: --
249: per_spp_del.dt_pre_delete
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 >-------------------------------|
299: --
300: l_proc varchar2(72) := g_package||'post_delete';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: begin
305: --
306: per_spp_rkd.after_delete
307: (p_effective_date
388: ,p_hook_type => 'AD');
389: --
390: end;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End post_delete;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |---------------------------------< del >----------------------------------|
405: l_validation_start_date date;
406: l_validation_end_date date;
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Ensure that the DateTrack delete mode is valid
412: --
413: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
463: ,p_validation_end_date => l_validation_end_date
464: );
465:
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 5);
468: End del;
469: --
470: -- ----------------------------------------------------------------------------
471: -- |--------------------------------< del >-----------------------------------|
482: l_rec per_spp_shd.g_rec_type;
483: l_proc varchar2(72) := g_package||'del';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);
487: --
488: -- As the delete procedure accepts a plsql record structure we do need to
489: -- convert the arguments into the record structure.
490: -- We don't need to call the supplied conversion argument routine as we
508: p_object_version_number := l_rec.object_version_number;
509: p_effective_start_date := l_rec.effective_start_date;
510: p_effective_end_date := l_rec.effective_end_date;
511: --
512: hr_utility.set_location(' Leaving:'||l_proc, 10);
513: End del;
514: --
515: end per_spp_del;