DBA Data[Home] [Help]

APPS.PER_PAC_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_pac_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_allocated_checklists row.

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

66: where allocated_checklist_id = p_rec.allocated_checklist_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 162: hr_utility.set_location('Entering:'||l_proc, 5);

158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: begin
164: --
165: per_pac_rkd.after_delete
166: (p_allocated_checklist_id

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

274: ,p_hook_type => 'AD');
275: --
276: end;
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: End post_delete;
280: --
281: -- ----------------------------------------------------------------------------
282: -- |---------------------------------< del >----------------------------------|

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

287: --
288: l_proc varchar2(72) := g_package||'del';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- We must lock the row which we need to delete.
294: --
295: per_pac_shd.lck

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

332: l_rec per_pac_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'del';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- As the delete procedure accepts a plsql record structure we do need to
339: -- convert the arguments into the record structure.
340: -- We don't need to call the supplied conversion argument routine as we

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

348: -- business process
349: --
350: per_pac_del.del(l_rec);
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End del;
354: --
355: end per_pac_del;