5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ulc_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_ulc_rkd.after_delete
228: --
229: end;
230: --
231: if g_debug then
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: end if;
234: End post_delete;
235: --
236: -- ----------------------------------------------------------------------------
242: --
243: l_proc varchar2(72) ;
244: --
245: Begin
246: g_debug :=hr_utility.debug_enabled;
247: if g_debug then
248: l_proc := g_package||'del';
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: end if;
245: Begin
246: g_debug :=hr_utility.debug_enabled;
247: if g_debug then
248: l_proc := g_package||'del';
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: end if;
251: --
252: -- We must lock the row which we need to delete.
253: --
285: l_rec hxc_ulc_shd.g_rec_type;
286: l_proc varchar2(72) ;
287: --
288: Begin
289: g_debug :=hr_utility.debug_enabled;
290: if g_debug then
291: l_proc := g_package||'del';
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: end if;
288: Begin
289: g_debug :=hr_utility.debug_enabled;
290: if g_debug then
291: l_proc := g_package||'del';
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: end if;
294: --
295: -- As the delete procedure accepts a plsql record structure we do need to
296: -- convert the arguments into the record structure.
306: --
307: hxc_ulc_del.del(l_rec);
308: --
309: if g_debug then
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: end if;
312: End del;
313: --
314: end hxc_ulc_del;