DBA Data[Home] [Help]

APPS.HXC_DTL_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_dtl_del.'; -- Global package name
9: g_debug boolean :=hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------

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

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

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

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

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

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;

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

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

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

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_dtl_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_dtl_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_dtl_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_dtl_del;