DBA Data[Home] [Help]

APPS.GHR_NLA_DEL dependencies on HR_UTILITY

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

47: l_proc varchar2(72);
48: --
49: Begin
50: l_proc := g_package||'delete_dml';
51: hr_utility.set_location('Entering:'||l_proc, 5);
52: --
53: --
54: -- Delete the ghr_noac_las row.
55: --

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

56: delete from ghr_noac_las
57: where noac_la_id = p_rec.noac_la_id;
58: --
59: --
60: hr_utility.set_location(' Leaving:'||l_proc, 10);
61: --
62: Exception
63: When hr_api.child_integrity_violated then
64: -- Child integrity has been violated

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

105: l_proc varchar2(72);
106: --
107: Begin
108: l_proc := g_package||'pre_delete';
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: End pre_delete;
113: --

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

107: Begin
108: l_proc := g_package||'pre_delete';
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: End pre_delete;
113: --
114: -- ----------------------------------------------------------------------------
115: -- |-----------------------------< post_delete >------------------------------|

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

149: l_proc varchar2(72) ;
150: --
151: Begin
152: l_proc := g_package||'post_delete';
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: --
156: -- Start of API User Hook for post_delete.
157: --

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

182: --
183: -- End of API User Hook for post_delete.
184: --
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
187: End post_delete;
188: --
189: -- ----------------------------------------------------------------------------
190: -- |---------------------------------< del >----------------------------------|

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

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

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

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

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

259: --
260: del(
261: p_effective_date,l_rec);
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End del;
265: --
266: end ghr_nla_del;