5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ula_del.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
58: Begin
59:
60: if g_debug then
61: l_proc := g_package||'delete_dml';
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: end if;
64: --
65: --
66: --
71: --
72: --
73: --
74: if g_debug then
75: hr_utility.set_location(' Leaving:'||l_proc, 10);
76: end if;
77: --
78: Exception
79: When hr_api.child_integrity_violated then
125: Begin
126:
127: if g_debug then
128: l_proc := g_package||'pre_delete';
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: End pre_delete;
133: --
126:
127: if g_debug then
128: l_proc := g_package||'pre_delete';
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: End pre_delete;
133: --
134: -- ----------------------------------------------------------------------------
170: Begin
171:
172: if g_debug then
173: l_proc := g_package||'post_delete';
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: end if;
176: begin
177: --
178: hxc_ula_rkd.after_delete
204: --
205: end;
206: --
207: if g_debug then
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: end if;
210: End post_delete;
211: --
212: -- ----------------------------------------------------------------------------
218: --
219: l_proc varchar2(72) ;
220: --
221: Begin
222: g_debug :=hr_utility.debug_enabled;
223: if g_debug then
224: l_proc := g_package||'del';
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: end if;
221: Begin
222: g_debug :=hr_utility.debug_enabled;
223: if g_debug then
224: l_proc := g_package||'del';
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: end if;
227: --
228: -- We must lock the row which we need to delete.
229: --
261: l_rec hxc_ula_shd.g_rec_type;
262: l_proc varchar2(72) ;
263: --
264: Begin
265: g_debug :=hr_utility.debug_enabled;
266: if g_debug then
267: l_proc := g_package||'del';
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: end if;
264: Begin
265: g_debug :=hr_utility.debug_enabled;
266: if g_debug then
267: l_proc := g_package||'del';
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: end if;
270: --
271: -- As the delete procedure accepts a plsql record structure we do need to
272: -- convert the arguments into the record structure.
282: --
283: hxc_ula_del.del(l_rec);
284: --
285: if g_debug then
286: hr_utility.set_location(' Leaving:'||l_proc, 10);
287: end if;
288: End del;
289: --
290: end hxc_ula_del;