DBA Data[Home] [Help]

APPS.PER_CAG_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: -- Delete the per_collective_agreements row.
62: --

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

63: delete from per_collective_agreements
64: where collective_agreement_id = p_rec.collective_agreement_id;
65: --
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated

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

111: --
112: l_proc varchar2(72) := g_package||'pre_delete';
113: --
114: Begin
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: End pre_delete;
119: --

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

113: --
114: Begin
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: End pre_delete;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |-----------------------------< post_delete >------------------------------|

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

153: --
154: l_proc varchar2(72) := g_package||'post_delete';
155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: --
160: --
161: -- Start of API User Hook for post_delete.

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

235: --
236: -- End of API User Hook for post_delete.
237: --
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: End post_delete;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |---------------------------------< del >----------------------------------|

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

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

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

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

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

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