5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hsd_del.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
57: --
58: Begin
59: if g_debug then
60: l_proc:= g_package||'delete_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: --
65: --
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
124: --
125: Begin
126: if g_debug then
127: l_proc := g_package||'pre_delete';
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: End pre_delete;
126: if g_debug then
127: l_proc := g_package||'pre_delete';
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: End pre_delete;
133: --
134: -- ----------------------------------------------------------------------------
169: --
170: Begin
171: if g_debug then
172: l_proc := g_package||'post_delete';
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: end if;
175: begin
176: --
177: hxc_hsd_rkd.after_delete
195: --
196: end;
197: --
198: if g_debug then
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: end if;
201: End post_delete;
202: --
203: -- ----------------------------------------------------------------------------
209: --
210: l_proc varchar2(72);
211: --
212: Begin
213: g_debug:=hr_utility.debug_enabled;
214: if g_debug then
215: l_proc := g_package||'del';
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: end if;
212: Begin
213: g_debug:=hr_utility.debug_enabled;
214: if g_debug then
215: l_proc := g_package||'del';
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: end if;
218: --
219: -- We must lock the row which we need to delete.
220: --
258: l_rec hxc_hsd_shd.g_rec_type;
259: l_proc varchar2(72);
260: --
261: Begin
262: g_debug:=hr_utility.debug_enabled;
263: if g_debug then
264: l_proc := g_package||'del';
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: end if;
261: Begin
262: g_debug:=hr_utility.debug_enabled;
263: if g_debug then
264: l_proc := g_package||'del';
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: end if;
267: --
268: -- As the delete procedure accepts a plsql record structure we do need to
269: -- convert the arguments into the record structure.
280: --
281: hxc_hsd_del.del(l_rec);
282: --
283: if g_debug then
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: end if;
286: End del;
287: --
288: end hxc_hsd_del;