5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_had_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_had_rkd.after_delete
202: --
203: end;
204: --
205: if g_debug then
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: end if;
208: End post_delete;
209: --
210: -- ----------------------------------------------------------------------------
216: --
217: l_proc varchar2(72);
218: --
219: Begin
220: g_debug:=hr_utility.debug_enabled;
221: if g_debug then
222: l_proc := g_package||'del';
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: end if;
219: Begin
220: g_debug:=hr_utility.debug_enabled;
221: if g_debug then
222: l_proc := g_package||'del';
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: end if;
225: --
226: -- We must lock the row which we need to delete.
227: --
259: l_rec hxc_had_shd.g_rec_type;
260: l_proc varchar2(72);
261: --
262: Begin
263: g_debug:=hr_utility.debug_enabled;
264: if g_debug then
265: l_proc := g_package||'del';
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: end if;
262: Begin
263: g_debug:=hr_utility.debug_enabled;
264: if g_debug then
265: l_proc := g_package||'del';
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: end if;
268: --
269: -- As the delete procedure accepts a plsql record structure we do need to
270: -- convert the arguments into the record structure.
285: (p_alias_definition_id => p_alias_definition_id
286: );
287:
288: if g_debug then
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: end if;
291: End del;
292: --
293: end hxc_had_del;