5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tkgqc_del.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
57:
58: if g_debug then
59: l_proc := g_package||'delete_dml';
60:
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status
65: --
70: --
71: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
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: if g_debug then
125: l_proc := g_package||'pre_delete';
126:
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: end if;
130: End pre_delete;
131: --
124: if g_debug then
125: l_proc := g_package||'pre_delete';
126:
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: end if;
130: End pre_delete;
131: --
132: -- ----------------------------------------------------------------------------
167:
168: if g_debug then
169: l_proc := g_package||'post_delete';
170:
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: end if;
173: begin
174: --
175: hxc_tkgqc_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:
217: hr_utility.set_location('Entering:'||l_proc, 5);
213: g_debug :=hr_utility.debug_enabled;
214: if g_debug then
215: l_proc := g_package||'del';
216:
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: end if;
219: --
220: -- We must lock the row which we need to delete.
221: --
253: l_rec hxc_tkgqc_shd.g_rec_type;
254: l_proc varchar2(72) ;
255: --
256: Begin
257: g_debug :=hr_utility.debug_enabled;
258: if g_debug then
259: l_proc := g_package||'del';
260:
261: hr_utility.set_location('Entering:'||l_proc, 5);
257: g_debug :=hr_utility.debug_enabled;
258: if g_debug then
259: l_proc := g_package||'del';
260:
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: end if;
263: --
264: -- As the delete procedure accepts a plsql record structure we do need to
265: -- convert the arguments into the record structure.
275: --
276: hxc_tkgqc_del.del(l_rec);
277: --
278: if g_debug then
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: end if;
281: End del;
282: --
283: end hxc_tkgqc_del;