[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
87: --
88: --
89: End If;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 20);
92: --
93: End dt_delete_dml;
94: --
95: -- ----------------------------------------------------------------------------
105: --
106: l_proc varchar2(72) := g_package||'delete_dml';
107: --
108: Begin
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: ame_itu_del.dt_delete_dml
112: (p_rec => p_rec
113: ,p_effective_date => p_effective_date
115: ,p_validation_start_date => p_validation_start_date
116: ,p_validation_end_date => p_validation_end_date
117: );
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: End delete_dml;
121: --
122: -- ----------------------------------------------------------------------------
123: -- |----------------------------< dt_pre_delete >-----------------------------|
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 <> hr_api.g_zap) then
169: --
170: p_rec.start_date
190: Else
191: p_rec.start_date := null;
192: p_rec.end_date := null;
193: End If;
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: End dt_pre_delete;
196: --
197: -- ----------------------------------------------------------------------------
198: -- |------------------------------< pre_delete >------------------------------|
239: --
240: --
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: --
246: --
247: ame_itu_del.dt_pre_delete
251: ,p_validation_start_date => p_validation_start_date
252: ,p_validation_end_date => p_validation_end_date
253: );
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End pre_delete;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |----------------------------< post_delete >-------------------------------|
297: --
298: l_proc varchar2(72) := g_package||'post_delete';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: begin
303: --
304: ame_itu_rkd.after_delete
305: (p_effective_date => p_effective_date
328: ,p_hook_type => 'AD');
329: --
330: end;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: End post_delete;
334: --
335: -- ----------------------------------------------------------------------------
336: -- |---------------------------------< del >----------------------------------|
345: l_validation_start_date date;
346: l_validation_end_date date;
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Ensure that the DateTrack delete mode is valid
352: --
353: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
408: --
409: -- Call to raise any errors on multi-message list
410: hr_multi_message.end_validation_set;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 5);
413: End del;
414: --
415: -- ----------------------------------------------------------------------------
416: -- |--------------------------------< del >-----------------------------------|
428: l_rec ame_itu_shd.g_rec_type;
429: l_proc varchar2(72) := g_package||'del';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- As the delete procedure accepts a plsql record structure we do need to
435: -- convert the arguments into the record structure.
436: -- We don't need to call the supplied conversion argument routine as we
458: p_object_version_number := l_rec.object_version_number;
459: p_start_date := l_rec.start_date;
460: p_end_date := l_rec.end_date;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: End del;
464: --
465: end ame_itu_del;