DBA Data[Home] [Help]

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

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

50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin
53: if g_debug then
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: end if;
56: --
57: -- Delete the hr_name_formats row.
58: --

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

59: delete from hr_name_formats
60: where name_format_id = p_rec.name_format_id;
61: --
62: if g_debug then
63: hr_utility.set_location(' Leaving:'||l_proc, 10);
64: end if;
65: --
66: Exception
67: When hr_api.child_integrity_violated then

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

109: l_proc varchar2(72) := g_package||'pre_delete';
110: --
111: Begin
112: if g_debug then
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: end if;
115: --
116: if g_debug then
117: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

113: hr_utility.set_location('Entering:'||l_proc, 5);
114: end if;
115: --
116: if g_debug then
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: end if;
119: End pre_delete;
120: --
121: -- ----------------------------------------------------------------------------

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

155: l_proc varchar2(72) := g_package||'post_delete';
156: --
157: Begin
158: if g_debug then
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: end if;
161: begin
162: --
163: hr_nmf_rkd.after_delete

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

185: --
186: end;
187: --
188: if g_debug then
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: end if;
191: End post_delete;
192: --
193: -- ----------------------------------------------------------------------------

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

200: l_proc varchar2(72) := g_package||'del';
201: --
202: Begin
203: if g_debug then
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: end if;
206: --
207: -- We must lock the row which we need to delete.
208: --

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

247: l_proc varchar2(72) := g_package||'del';
248: --
249: Begin
250: if g_debug then
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: end if;
253: --
254: -- As the delete procedure accepts a plsql record structure we do need to
255: -- convert the arguments into the record structure.

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

265: --
266: hr_nmf_del.del(l_rec);
267: --
268: if g_debug then
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: end if;
271: End del;
272: --
273: end hr_nmf_del;