DBA Data[Home] [Help]

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

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

55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: --
62: --
63: -- Delete the per_security_users row.

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

66: where security_user_id = p_rec.security_user_id;
67: --
68: --
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated

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

116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: End pre_delete;
124: --

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

118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: End pre_delete;
124: --
125: -- ----------------------------------------------------------------------------
126: -- |-----------------------------< post_delete >------------------------------|

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

162: --
163: Begin
164:
165: IF g_debug THEN
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: END IF;
168:
169: --
170: -- Set the warning flag to true if the user has static lists

Line 183: hr_utility.set_location(l_proc, 10);

179: --
180: -- Delete the static lists for this user.
181: --
182: IF g_debug THEN
183: hr_utility.set_location(l_proc, 10);
184: END IF;
185:
186: hr_security_internal.delete_static_lists_for_user
187: (p_user_id => per_seu_shd.g_old_rec.user_id

Line 193: hr_utility.set_location(l_proc, 15);

189:
190: END IF;
191:
192: IF g_debug THEN
193: hr_utility.set_location(l_proc, 15);
194: END IF;
195:
196: begin
197: --

Line 222: hr_utility.set_location('Leaving:'||l_proc, 999);

218: --
219: end;
220: --
221: IF g_debug THEN
222: hr_utility.set_location('Leaving:'||l_proc, 999);
223: END IF;
224:
225: End post_delete;
226: --

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

235: l_proc varchar2(72) := g_package||'del';
236: l_del_static_lists_warning boolean;
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: -- We must lock the row which we need to delete.
242: --
243: per_seu_shd.lck

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

288: l_proc varchar2(72) := g_package||'del';
289: l_del_static_lists_warning boolean;
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- As the delete procedure accepts a plsql record structure we do need to
295: -- convert the arguments into the record structure.
296: -- We don't need to call the supplied conversion argument routine as we

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

309: -- Set the out parameters.
310: --
311: p_del_static_lists_warning := l_del_static_lists_warning;
312:
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314:
315: End del;
316: --
317: end per_seu_del;