DBA Data[Home] [Help]

APPS.PER_CTK_DEL dependencies on HR_UTILITY

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

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

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

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

Line 145: hr_utility.set_location('Entering:'||l_proc, 10);

141: l_effective_start_date date;
142: l_effective_end_date date;
143: l_effective_date date;
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 10);
146: --
147: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
148: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
149:

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

193: end;
194: end if;
195: close c_elig_obj;
196: end if;
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_delete;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< post_delete >------------------------------|

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

233: --
234: l_proc varchar2(72) := g_package||'post_delete';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: begin
239: --
240: per_ctk_rkd.after_delete
241: (p_task_in_checklist_id

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

359: ,p_hook_type => 'AD');
360: --
361: end;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End post_delete;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |---------------------------------< del >----------------------------------|

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

372: --
373: l_proc varchar2(72) := g_package||'del';
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: -- We must lock the row which we need to delete.
379: --
380: per_ctk_shd.lck

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

417: l_rec per_ctk_shd.g_rec_type;
418: l_proc varchar2(72) := g_package||'del';
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: -- As the delete procedure accepts a plsql record structure we do need to
424: -- convert the arguments into the record structure.
425: -- We don't need to call the supplied conversion argument routine as we

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

433: -- business process
434: --
435: per_ctk_del.del(l_rec);
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: End del;
439: --
440: end per_ctk_del;