DBA Data[Home] [Help]

APPS.HXC_VTL_DEL dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_vtl_del.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------

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

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

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

72: --
73: --
74: --
75: if g_debug then
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: end if;
78: --
79: Exception
80: When hr_api.child_integrity_violated then

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

126: Begin
127:
128: if g_debug then
129: l_proc := g_package||'pre_delete';
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: end if;
133: End pre_delete;
134: --

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

127:
128: if g_debug then
129: l_proc := g_package||'pre_delete';
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: end if;
133: End pre_delete;
134: --
135: -- ----------------------------------------------------------------------------

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

171: Begin
172:
173: if g_debug then
174: l_proc := g_package||'post_delete';
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: end if;
177: begin
178: --
179: hxc_vtl_rkd.after_delete

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

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

Line 215: g_debug :=hr_utility.debug_enabled;

211: --
212: l_proc varchar2(72) ;
213: --
214: Begin
215: g_debug :=hr_utility.debug_enabled;
216: if g_debug then
217: l_proc := g_package||'del';
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: end if;

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

214: Begin
215: g_debug :=hr_utility.debug_enabled;
216: if g_debug then
217: l_proc := g_package||'del';
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: end if;
220: --
221: -- We must lock the row which we need to delete.
222: --

Line 258: g_debug :=hr_utility.debug_enabled;

254: l_rec hxc_vtl_shd.g_rec_type;
255: l_proc varchar2(72) ;
256: --
257: Begin
258: g_debug :=hr_utility.debug_enabled;
259: if g_debug then
260: l_proc := g_package||'del';
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: end if;

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

257: Begin
258: g_debug :=hr_utility.debug_enabled;
259: if g_debug then
260: l_proc := g_package||'del';
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.

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

276: --
277: hxc_vtl_del.del(l_rec);
278: --
279: if g_debug then
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: end if;
282: End del;
283: --
284: -- ----------------------------------------------------------------------------

Line 301: g_debug :=hr_utility.debug_enabled;

297: --
298: l_proc varchar2(72) ;
299: --
300: Begin
301: g_debug :=hr_utility.debug_enabled;
302: if g_debug then
303: l_proc := g_package||'del_tl';
304: hr_utility.set_location('Entering:'||l_proc,10);
305: end if;

Line 304: hr_utility.set_location('Entering:'||l_proc,10);

300: Begin
301: g_debug :=hr_utility.debug_enabled;
302: if g_debug then
303: l_proc := g_package||'del_tl';
304: hr_utility.set_location('Entering:'||l_proc,10);
305: end if;
306: --
307: -- Delete all the translated rows
308: --

Line 317: hr_utility.set_location(' Leaving:'||l_proc,20);

313: );
314: end loop;
315: --
316: if g_debug then
317: hr_utility.set_location(' Leaving:'||l_proc,20);
318: end if;
319: End del_tl;
320: --
321: end hxc_vtl_del;