[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: pay_ivl_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
85: --
86: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: l_proc varchar2(72) := g_package||'delete_dml';
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: pay_ivl_del.dt_delete_dml
152: (p_rec => p_rec
153: ,p_effective_date => p_effective_date
155: ,p_validation_start_date => p_validation_start_date
156: ,p_validation_end_date => p_validation_end_date
157: );
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End delete_dml;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |----------------------------< dt_pre_delete >-----------------------------|
202: --
203: l_proc varchar2(72) := g_package||'dt_pre_delete';
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: If (p_datetrack_mode <> hr_api.g_zap) then
209: --
210: p_rec.effective_start_date
229: Else
230: p_rec.effective_start_date := null;
231: p_rec.effective_end_date := null;
232: End If;
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End dt_pre_delete;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |------------------------------< pre_delete >------------------------------|
278: --
279: --
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: --
285: --
286: pay_ivl_del.dt_pre_delete
290: ,p_validation_start_date => p_validation_start_date
291: ,p_validation_end_date => p_validation_end_date
292: );
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: End pre_delete;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |----------------------------< post_delete >-------------------------------|
336: --
337: l_proc varchar2(72) := g_package||'post_delete';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: begin
342: --
343: -- Delete ownerships if applicable
344: delete_app_ownerships
413: ,p_hook_type => 'AD');
414: --
415: end;
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: End post_delete;
419: --
420: -- ----------------------------------------------------------------------------
421: -- |---------------------------------< del >----------------------------------|
431: l_validation_start_date date;
432: l_validation_end_date date;
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Ensure that the DateTrack delete mode is valid
438: --
439: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
544: --
545: -- Call to raise any errors on multi-message list
546: hr_multi_message.end_validation_set;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 5);
549: End del;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |--------------------------------< del >-----------------------------------|
564: l_rec pay_ivl_shd.g_rec_type;
565: l_proc varchar2(72) := g_package||'del';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- As the delete procedure accepts a plsql record structure we do need to
571: -- convert the arguments into the record structure.
572: -- We don't need to call the supplied conversion argument routine as we
597: pay_ivt_del.del_tl
598: (p_input_value_id => p_input_value_id);
599: end if;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End del;
603: --
604: end pay_ivl_del;