DBA Data[Home] [Help]

APPS.PQH_STS_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_sts_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: --
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: End if;
64:
65: --

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

73: --
74: --
75: if g_debug then
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: --
79: End if;
80: --
81: Exception

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

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

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

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

Line 177: g_debug := hr_utility.debug_enabled;

173: l_proc varchar2(72) := g_package||'post_delete';
174: --
175: Begin
176:
177: g_debug := hr_utility.debug_enabled;
178:
179: if g_debug then
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);

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

177: g_debug := hr_utility.debug_enabled;
178:
179: if g_debug then
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: End if;
184: begin
185: --

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

263: end;
264: --
265: if g_debug then
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: --
269: End if;
270: End post_delete;
271: --

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

280: --
281: Begin
282: if g_debug then
283: --
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: End if;
287: --
288: -- We must lock the row which we need to delete.

Line 332: g_debug := hr_utility.debug_enabled;

328: l_proc varchar2(72) := g_package||'del';
329: --
330: Begin
331:
332: g_debug := hr_utility.debug_enabled;
333:
334: if g_debug then
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);

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

332: g_debug := hr_utility.debug_enabled;
333:
334: if g_debug then
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: End if;
339: --
340: -- As the delete procedure accepts a plsql record structure we do need to

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

352: pqh_sts_del.del(l_rec);
353: --
354: if g_debug then
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: --
358: End if;
359:
360: End del;