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_CUS_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_chat_users row.

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

67: and (contact_id is null or contact_id = p_rec.contact_id);
68: --
69: --
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated

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

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

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

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

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

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

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

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

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

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

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

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

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

267: -- business process
268: --
269: ota_cus_del.del(l_rec);
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End del;
273: --
274: end ota_cus_del;