DBA Data[Home] [Help]

APPS.PQH_RHT_DEL dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

196: --
197: -- End of API User Hook for post_delete.
198: --
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End post_delete;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|

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

211: --
212: l_proc varchar2(72) := g_package||'del';
213: --
214: Begin
215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: -- We must lock the row which we need to delete.
218: --
219: pqh_rht_shd.lck

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

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

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

271: --
272: del(
273: p_effective_date,l_rec);
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: End del;
277: --
278: end pqh_rht_del;