5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hdp_del.'; -- Global package name
9: g_debug boolean:=hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
57: --
58: Begin
59: if g_debug then
60: l_proc := g_package||'delete_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: --
65: --
70: --
71: --
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;
76: --
77: Exception
78: When hr_api.child_integrity_violated then
123: --
124: Begin
125: if g_debug then
126: l_proc := g_package||'pre_delete';
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: end if;
131: End pre_delete;
125: if g_debug then
126: l_proc := g_package||'pre_delete';
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: end if;
131: End pre_delete;
132: --
133: -- ----------------------------------------------------------------------------
168: --
169: Begin
170: if g_debug then
171: l_proc:= g_package||'post_delete';
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: end if;
174: begin
175: --
176: hxc_hdp_rkd.after_delete
196: --
197: end;
198: --
199: if g_debug then
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: end if;
202: End post_delete;
203: --
204: -- ----------------------------------------------------------------------------
210: --
211: l_proc varchar2(72);
212: --
213: Begin
214: g_debug:=hr_utility.debug_enabled;
215: if g_debug then
216: l_proc := g_package||'del';
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: end if;
213: Begin
214: g_debug:=hr_utility.debug_enabled;
215: if g_debug then
216: l_proc := g_package||'del';
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: end if;
219: --
220: -- We must lock the row which we need to delete.
221: --
253: l_rec hxc_hdp_shd.g_rec_type;
254: l_proc varchar2(72);
255: --
256: Begin
257: g_debug:=hr_utility.debug_enabled;
258: if g_debug then
259: l_proc := g_package||'del';
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: end if;
256: Begin
257: g_debug:=hr_utility.debug_enabled;
258: if g_debug then
259: l_proc := g_package||'del';
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: end if;
262: --
263: -- As the delete procedure accepts a plsql record structure we do need to
264: -- convert the arguments into the record structure.
274: --
275: hxc_hdp_del.del(l_rec);
276: --
277: if g_debug then
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: end if;
280: End del;
281: --
282: end hxc_hdp_del;