DBA Data[Home] [Help]

APPS.PQH_CPD_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) := ' pqh_cpd_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: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status
65: --

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

70: --
71: pqh_cpd_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

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

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: end if;
129: --
130: if g_debug then
131: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

298: --
299: end;
300: --
301: if g_debug then
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: end if;
304: End post_delete;
305: --
306: -- ----------------------------------------------------------------------------

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

314: --
315: Begin
316: if g_debug then
317: l_proc := g_package||'del';
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: end if;
320: --
321: -- We must lock the row which we need to delete.
322: --

Line 364: g_debug := hr_utility.debug_enabled;

360: l_rec pqh_cpd_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'del';
362: --
363: Begin
364: g_debug := hr_utility.debug_enabled;
365: if g_debug then
366: l_proc := g_package||'del';
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: end if;

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

363: Begin
364: g_debug := hr_utility.debug_enabled;
365: if g_debug then
366: l_proc := g_package||'del';
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: end if;
369: --
370: -- As the delete procedure accepts a plsql record structure we do need to
371: -- convert the arguments into the record structure.

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

381: --
382: pqh_cpd_del.del(l_rec);
383: --
384: if g_debug then
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: end if;
387: End del;
388: --
389: end pqh_cpd_del;