[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: -- ----------------------------------------------------------------------------
143: --
144: l_proc varchar2(72) := g_package||'delete_dml';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: pay_ecu_del.dt_delete_dml
150: (p_rec => p_rec
151: ,p_effective_date => p_effective_date
153: ,p_validation_start_date => p_validation_start_date
154: ,p_validation_end_date => p_validation_end_date
155: );
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End delete_dml;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |----------------------------< dt_pre_delete >-----------------------------|
200: --
201: l_proc varchar2(72) := g_package||'dt_pre_delete';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: If (p_datetrack_mode <> hr_api.g_zap) then
207: --
208: p_rec.effective_start_date
227: Else
228: p_rec.effective_start_date := null;
229: p_rec.effective_end_date := null;
230: End If;
231: hr_utility.set_location(' Leaving:'||l_proc, 10);
232: End dt_pre_delete;
233: --
234: -- ----------------------------------------------------------------------------
235: -- |------------------------------< pre_delete >------------------------------|
276: --
277: --
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: --
283: --
284: pay_ecu_del.dt_pre_delete
288: ,p_validation_start_date => p_validation_start_date
289: ,p_validation_end_date => p_validation_end_date
290: );
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: End pre_delete;
294: --
295: -- ----------------------------------------------------------------------------
296: -- |----------------------------< post_delete >-------------------------------|
334: --
335: l_proc varchar2(72) := g_package||'post_delete';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: begin
340: --
341: -- Delete ownerships if applicable
342: delete_app_ownerships
384: ,p_hook_type => 'AD');
385: --
386: end;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End post_delete;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< del >----------------------------------|
401: l_validation_start_date date;
402: l_validation_end_date date;
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Ensure that the DateTrack delete mode is valid
408: --
409: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
463: --
464: -- Call to raise any errors on multi-message list
465: hr_multi_message.end_validation_set;
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 5);
468: End del;
469: --
470: -- ----------------------------------------------------------------------------
471: -- |--------------------------------< del >-----------------------------------|
482: l_rec pay_ecu_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
509: p_object_version_number := l_rec.object_version_number;
510: p_effective_start_date := l_rec.effective_start_date;
511: p_effective_end_date := l_rec.effective_end_date;
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 10);
514: End del;
515: --
516: end pay_ecu_del;