52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: --
59: -- Delete the per_bf_balance_amounts row.
60: --
61: delete from per_bf_balance_amounts
62: where balance_amount_id = p_rec.balance_amount_id;
63: --
64: --
65: hr_utility.set_location(' Leaving:'||l_proc, 10);
66: --
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
109: --
110: l_proc varchar2(72) := g_package||'pre_delete';
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |-----------------------------< post_delete >------------------------------|
151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: begin
157: --
158: per_bba_rkd.after_delete
159: (
252: ,p_hook_type => 'AD');
253: --
254: end;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 10);
257: End post_delete;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |---------------------------------< del >----------------------------------|
266: --
267: l_proc varchar2(72) := g_package||'del';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- We must lock the row which we need to delete.
273: --
274: per_bba_shd.lck
306: l_rec per_bba_shd.g_rec_type;
307: l_proc varchar2(72) := g_package||'del';
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: -- As the delete procedure accepts a plsql record structure we do need to
313: -- convert the arguments into the record structure.
314: -- We don't need to call the supplied conversion argument routine as we
322: -- business process
323: --
324: del(l_rec);
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: End del;
328: --
329: end per_bba_del;