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_CPR_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_course_prerequisites row.

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

66: and prerequisite_course_id = p_rec.prerequisite_course_id;
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_cpr_rkd.after_delete
166: (p_activity_version_id

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

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

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

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

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

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

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

263: -- business process
264: --
265: ota_cpr_del.del(l_rec);
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End del;
269: --
270: end ota_cpr_del;