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_ONT_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_offerings_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_ont_rkd.after_delete
166: (p_offering_id

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

185: ,p_hook_type => 'AD');
186: --
187: end;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End post_delete;
191: --
192: -- ----------------------------------------------------------------------------
193: -- |---------------------------------< del >----------------------------------|

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

198: --
199: l_proc varchar2(72) := g_package||'del';
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- We must lock the row which we need to delete.
205: --
206: ota_ont_shd.lck

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

243: l_rec ota_ont_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'del';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- As the delete procedure accepts a plsql record structure we do need to
250: -- convert the arguments into the record structure.
251: -- We don't need to call the supplied conversion argument routine as we

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

260: -- business process
261: --
262: ota_ont_del.del(l_rec);
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End del;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |------------------------------< del_tl >----------------------------------|

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

281: --
282: l_proc varchar2(72) := g_package||'del_tl';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc,10);
286: --
287: -- Delete all the translated rows
288: --
289: for l_lang in csr_del_langs loop

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

292: ,p_language => l_lang.language
293: );
294: end loop;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc,20);
297: End del_tl;
298: --
299: end ota_ont_del;