[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: -- ----------------------------------------------------------------------------
140: --
141: l_proc varchar2(72) := g_package||'delete_dml';
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: pay_evc_del.dt_delete_dml
147: (p_rec => p_rec
148: ,p_effective_date => p_effective_date
150: ,p_validation_start_date => p_validation_start_date
151: ,p_validation_end_date => p_validation_end_date
152: );
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End delete_dml;
156: --
157: -- ----------------------------------------------------------------------------
158: -- |----------------------------< dt_pre_delete >-----------------------------|
197: --
198: l_proc varchar2(72) := g_package||'dt_pre_delete';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: If (p_datetrack_mode <> hr_api.g_zap) then
204: --
205: p_rec.effective_start_date
224: Else
225: p_rec.effective_start_date := null;
226: p_rec.effective_end_date := null;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End dt_pre_delete;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |------------------------------< pre_delete >------------------------------|
273: --
274: --
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: --
280: --
281: pay_evc_del.dt_pre_delete
285: ,p_validation_start_date => p_validation_start_date
286: ,p_validation_end_date => p_validation_end_date
287: );
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: End pre_delete;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |----------------------------< post_delete >-------------------------------|
331: --
332: l_proc varchar2(72) := g_package||'post_delete';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: begin
337: --
338: -- Delete ownerships if applicable
339: delete_app_ownerships
394: ,p_hook_type => 'AD');
395: --
396: end;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 10);
399: End post_delete;
400: --
401: -- ----------------------------------------------------------------------------
402: -- |---------------------------------< del >----------------------------------|
411: l_validation_start_date date;
412: l_validation_end_date date;
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Ensure that the DateTrack delete mode is valid
418: --
419: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
473: --
474: -- Call to raise any errors on multi-message list
475: hr_multi_message.end_validation_set;
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 5);
478: End del;
479: --
480: -- ----------------------------------------------------------------------------
481: -- |--------------------------------< del >-----------------------------------|
492: l_rec pay_evc_shd.g_rec_type;
493: l_proc varchar2(72) := g_package||'del';
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- As the delete procedure accepts a plsql record structure we do need to
499: -- convert the arguments into the record structure.
500: -- We don't need to call the supplied conversion argument routine as we
519: p_object_version_number := l_rec.object_version_number;
520: p_effective_start_date := l_rec.effective_start_date;
521: p_effective_end_date := l_rec.effective_end_date;
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 10);
524: End del;
525: --
526: end pay_evc_del;