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_CPE_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_cert_prd_enrollments row.

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

65: where cert_prd_enrollment_id = p_rec.cert_prd_enrollment_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 119: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

233: ,p_hook_type => 'AD');
234: --
235: end;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: End post_delete;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |---------------------------------< del >----------------------------------|

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

246: --
247: l_proc varchar2(72) := g_package||'del';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: -- We must lock the row which we need to delete.
253: --
254: ota_cpe_shd.lck

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

291: l_rec ota_cpe_shd.g_rec_type;
292: l_proc varchar2(72) := g_package||'del';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- As the delete procedure accepts a plsql record structure we do need to
298: -- convert the arguments into the record structure.
299: -- We don't need to call the supplied conversion argument routine as we

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

307: -- business process
308: --
309: ota_cpe_del.del(l_rec);
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End del;
313: --
314: end ota_cpe_del;