eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TPM_DEL dependencies on HR_UTILITY

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

55: l_proc varchar2(72) := g_package||'delete_dml';
56: l_boolean boolean := null;
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: --Bug3507060
62: -- Set the Is_Per_Trng_Plan global variable
63: -- l_boolean := OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_rec.training_plan_id);

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

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

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

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

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

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

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

160: --
161: l_proc varchar2(72) := g_package||'post_delete';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: begin
166: --
167: ota_tpm_rkd.after_delete
168: (p_training_plan_member_id

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

260: ,p_hook_type => 'AD');
261: --
262: end;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End post_delete;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |---------------------------------< del >----------------------------------|

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

273: --
274: l_proc varchar2(72) := g_package||'del';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- We must lock the row which we need to delete.
280: --
281: ota_tpm_shd.lck

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

315: l_rec ota_tpm_shd.g_rec_type;
316: l_proc varchar2(72) := g_package||'del';
317: --
318: Begin
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: -- As the delete procedure accepts a plsql record structure we do need to
322: -- convert the arguments into the record structure.
323: -- We don't need to call the supplied conversion argument routine as we

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

331: -- business process
332: --
333: ota_tpm_del.del(l_rec);
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End del;
337: --
338: end ota_tpm_del;