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_CTL_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 ota_certifications_tl row.

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

66: and language = p_rec.language;
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: ota_ctl_rkd.after_delete
166: (p_certification_id

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

196: ,p_hook_type => 'AD');
197: --
198: end;
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End post_delete;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|

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

209: --
210: l_proc varchar2(72) := g_package||'del';
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- We must lock the row which we need to delete.
216: --
217: ota_ctl_shd.lck

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

254: l_rec ota_ctl_shd.g_rec_type;
255: l_proc varchar2(72) := g_package||'del';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- As the delete procedure accepts a plsql record structure we do need to
261: -- convert the arguments into the record structure.
262: -- We don't need to call the supplied conversion argument routine as we

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

271: -- business process
272: --
273: ota_ctl_del.del(l_rec);
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: End del;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |------------------------------< del_tl >----------------------------------|

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

292: --
293: l_proc varchar2(72) := g_package||'del_tl';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc,10);
297: --
298: -- Delete all the translated rows
299: --
300: for l_lang in csr_del_langs loop

Line 307: hr_utility.set_location(' Leaving:'||l_proc,20);

303: ,p_language => l_lang.language
304: );
305: end loop;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc,20);
308: End del_tl;
309: --
310: end ota_ctl_del;