[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: pqh_rmr_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: pqh_rmr_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
392: ,p_hook_type => 'AD');
393: --
394: end;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 10);
397: End post_delete;
398: --
399: -- ----------------------------------------------------------------------------
400: -- |---------------------------------< del >----------------------------------|
409: l_validation_start_date date;
410: l_validation_end_date date;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415: -- Ensure that the DateTrack delete mode is valid
416: --
417: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
471: --
472: -- Call to raise any errors on multi-message list
473: hr_multi_message.end_validation_set;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 5);
476: End del;
477: --
478: -- ----------------------------------------------------------------------------
479: -- |--------------------------------< del >-----------------------------------|
490: l_rec pqh_rmr_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'del';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: -- As the delete procedure accepts a plsql record structure we do need to
497: -- convert the arguments into the record structure.
498: -- We don't need to call the supplied conversion argument routine as we
517: p_object_version_number := l_rec.object_version_number;
518: p_effective_start_date := l_rec.effective_start_date;
519: p_effective_end_date := l_rec.effective_end_date;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 10);
522: End del;
523: --
524: end pqh_rmr_del;