5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_atc_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: --
70: --
71: --
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;
76: --
77: Exception
78: When hr_api.child_integrity_violated then
123: --
124: Begin
125: if g_debug then
126: l_proc := g_package||'pre_delete';
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: end if;
131: End pre_delete;
125: if g_debug then
126: l_proc := g_package||'pre_delete';
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: end if;
131: End pre_delete;
132: --
133: -- ----------------------------------------------------------------------------
168: --
169: Begin
170: if g_debug then
171: l_proc := g_package||'post_delete';
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: end if;
174: begin
175: --
176: hxc_atc_rkd.after_delete
200: --
201: end;
202: --
203: if g_debug then
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: end if;
206: End post_delete;
207: --
208: -- ----------------------------------------------------------------------------
214: --
215: l_proc varchar2(72);
216: --
217: Begin
218: g_debug:=hr_utility.debug_enabled;
219: if g_debug then
220: l_proc:= g_package||'del';
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: end if;
217: Begin
218: g_debug:=hr_utility.debug_enabled;
219: if g_debug then
220: l_proc:= g_package||'del';
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: end if;
223: --
224: -- We must lock the row which we need to delete.
225: --
263: l_rec hxc_atc_shd.g_rec_type;
264: l_proc varchar2(72);
265: --
266: Begin
267: g_debug:=hr_utility.debug_enabled;
268: if g_debug then
269: l_proc := g_package||'del';
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: end if;
266: Begin
267: g_debug:=hr_utility.debug_enabled;
268: if g_debug then
269: l_proc := g_package||'del';
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: end if;
272: --
273: -- As the delete procedure accepts a plsql record structure we do need to
274: -- convert the arguments into the record structure.
284: --
285: hxc_atc_del.del(l_rec);
286: --
287: if g_debug then
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: end if;
290: End del;
291: --
292: end hxc_atc_del;