5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hsd_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
60: --
61: Begin
62: if g_debug then
63: l_proc := g_package||'update_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: --
67: --
68: --
80: --
81: --
82: --
83: if g_debug then
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: end if;
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
145: --
146: Begin
147: if g_debug then
148: l_proc:= g_package||'pre_update';
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: end if;
153: End pre_update;
147: if g_debug then
148: l_proc:= g_package||'pre_update';
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: end if;
153: End pre_update;
154: --
155: -- ----------------------------------------------------------------------------
192: --
193: Begin
194: if g_debug then
195: l_proc := g_package||'post_update';
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: end if;
198: begin
199: --
200: hxc_hsd_rku.after_update
222: --
223: end;
224: --
225: if g_debug then
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: end if;
228: End post_update;
229: --
230: -- ----------------------------------------------------------------------------
301: --
302: l_proc varchar2(72);
303: --
304: Begin
305: g_debug:=hr_utility.debug_enabled;
306: if g_debug then
307: l_proc := g_package||'upd';
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: end if;
304: Begin
305: g_debug:=hr_utility.debug_enabled;
306: if g_debug then
307: l_proc := g_package||'upd';
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: end if;
310: --
311: -- We must lock the row which we need to update.
312: --
360: l_rec hxc_hsd_shd.g_rec_type;
361: l_proc varchar2(72);
362: --
363: Begin
364: g_debug:=hr_utility.debug_enabled;
365: if g_debug then
366: l_proc := g_package||'upd';
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: end if;
363: Begin
364: g_debug:=hr_utility.debug_enabled;
365: if g_debug then
366: l_proc := g_package||'upd';
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: end if;
369: --
370: -- Call conversion function to turn arguments into the
371: -- l_rec structure.
387: );
388: --
389: --
390: if g_debug then
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: end if;
393: End upd;
394: --
395: end hxc_hsd_upd;