[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: --
67: --
68: -- Delete the where the effective start date is equal
85: --
86: --
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: End dt_delete_dml;
92: --
93: -- ----------------------------------------------------------------------------
103: --
104: l_proc varchar2(72) := g_package||'delete_dml';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: ame_atr_del.dt_delete_dml
110: (p_rec => p_rec
111: ,p_effective_date => p_effective_date
113: ,p_validation_start_date => p_validation_start_date
114: ,p_validation_end_date => p_validation_end_date
115: );
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: End delete_dml;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |----------------------------< dt_pre_delete >-----------------------------|
160: --
161: l_proc varchar2(72) := g_package||'dt_pre_delete';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.start_date
185: Else
186: p_rec.start_date := null;
187: p_rec.end_date := null;
188: End If;
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End dt_pre_delete;
191: --
192: -- ----------------------------------------------------------------------------
193: -- |------------------------------< pre_delete >------------------------------|
234: --
235: --
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: --
241: --
242: ame_atr_del.dt_pre_delete
246: ,p_validation_start_date => p_validation_start_date
247: ,p_validation_end_date => p_validation_end_date
248: );
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: End pre_delete;
252: --
253: -- ----------------------------------------------------------------------------
254: -- |----------------------------< post_delete >-------------------------------|
292: --
293: l_proc varchar2(72) := g_package||'post_delete';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: begin
298: --
299: ame_atr_rkd.after_delete
300: (p_effective_date
342: ,p_hook_type => 'AD');
343: --
344: end;
345: --
346: hr_utility.set_location(' Leaving:'||l_proc, 10);
347: End post_delete;
348: --
349: -- ----------------------------------------------------------------------------
350: -- |---------------------------------< del >----------------------------------|
359: l_validation_start_date date;
360: l_validation_end_date date;
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Ensure that the DateTrack delete mode is valid
366: --
367: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
421: --
422: -- Call to raise any errors on multi-message list
423: hr_multi_message.end_validation_set;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 5);
426: End del;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |--------------------------------< del >-----------------------------------|
440: l_rec ame_atr_shd.g_rec_type;
441: l_proc varchar2(72) := g_package||'del';
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- As the delete procedure accepts a plsql record structure we do need to
447: -- convert the arguments into the record structure.
448: -- We don't need to call the supplied conversion argument routine as we
469: p_object_version_number := l_rec.object_version_number;
470: p_start_date := l_rec.start_date;
471: p_end_date := l_rec.end_date;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End del;
475: --
476: end ame_atr_del;