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: --
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
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;
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 >------------------------------|
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: --
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 >----------------------------------|
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
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
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;