APPS.HXC_TKGQ_DEL dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: Package body hxc_tkgq_del as
2: /* $Header: hxctkgqrhi.pkb 120.2 2005/09/23 09:33:26 rchennur noship $ */
3: --
4: g_package varchar2(33) := ' hxc_tkgq_del.'; -- Global package name
5: g_debug boolean := hr_utility.debug_enabled;
6: -- ----------------------------------------------------------------------------
7: -- |------------------------------< delete_dml >------------------------------|
8: -- ----------------------------------------------------------------------------
9: --

Line 55: hr_utility.set_location('Entering:'||l_proc, 5);

51: Begin
52:
53: if g_debug then
54: l_proc := g_package||'delete_dml';
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: end if;
57: --
58: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status
59:

Line 77: hr_utility.set_location(' Leaving:'||l_proc, 10);

73: --
74: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: if g_debug then
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: end if;
79: --
80: Exception
81: When hr_api.child_integrity_violated then

Line 129: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 130: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 172: hr_utility.set_location('Entering:'||l_proc, 5);

168: Begin
169:
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_tkgq_rkd.after_delete

Line 202: hr_utility.set_location(' Leaving:'||l_proc, 10);

198: --
199: end;
200: --
201: if g_debug then
202: hr_utility.set_location(' Leaving:'||l_proc, 10);
203: end if;
204: End post_delete;
205: -- ----------------------------------------------------------------------------
206: -- |---------------------------------< del >----------------------------------|

Line 251: g_debug :=hr_utility.debug_enabled;

247: --
248: l_proc varchar2(72) ;
249: --
250: Begin
251: g_debug :=hr_utility.debug_enabled;
252: if g_debug then
253: l_proc := g_package||'del';
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: end if;

Line 254: hr_utility.set_location('Entering:'||l_proc, 5);

250: Begin
251: g_debug :=hr_utility.debug_enabled;
252: if g_debug then
253: l_proc := g_package||'del';
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: end if;
256: --
257: -- We must lock the row which we need to delete.
258: --

Line 325: g_debug :=hr_utility.debug_enabled;

321: l_rec hxc_tkgq_shd.g_rec_type;
322: l_proc varchar2(72) ;
323: --
324: Begin
325: g_debug :=hr_utility.debug_enabled;
326: if g_debug then
327: l_proc := g_package||'del';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: end if;

Line 328: hr_utility.set_location('Entering:'||l_proc, 5);

324: Begin
325: g_debug :=hr_utility.debug_enabled;
326: if g_debug then
327: l_proc := g_package||'del';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: end if;
330: --
331: -- As the delete procedure accepts a plsql record structure we do need to
332: -- convert the arguments into the record structure.

Line 346: hr_utility.set_location(' Leaving:'||l_proc, 10);

342: --
343: hxc_tkgq_del.del(l_rec);
344: --
345: if g_debug then
346: hr_utility.set_location(' Leaving:'||l_proc, 10);
347: end if;
348: End del;
349: --
350: end hxc_tkgq_del;