5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tkg_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
59: Begin
60:
61: if g_debug then
62: l_proc := g_package||'update_dml';
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: end if;
65: --
66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
85: --
86: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: if g_debug then
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: end if;
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
149: Begin
150:
151: if g_debug then
152: l_proc := g_package||'pre_update';
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: end if;
156: End pre_update;
157: --
150:
151: if g_debug then
152: l_proc := g_package||'pre_update';
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: end if;
156: End pre_update;
157: --
158: -- ----------------------------------------------------------------------------
194: Begin
195:
196: if g_debug then
197: l_proc := g_package||'post_update';
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: end if;
200: begin
201: --
202: hxc_tkg_rku.after_update
228: --
229: end;
230: --
231: if g_debug then
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: end if;
234: End post_update;
235: --
236: -- ----------------------------------------------------------------------------
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: --
355: l_rec hxc_tkg_shd.g_rec_type;
356: l_proc varchar2(72) ;
357: --
358: Begin
359: g_debug :=hr_utility.debug_enabled;
360: if g_debug then
361: l_proc := g_package||'upd';
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: end if;
358: Begin
359: g_debug :=hr_utility.debug_enabled;
360: if g_debug then
361: l_proc := g_package||'upd';
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: end if;
364: --
365: -- Call conversion function to turn arguments into the
366: -- l_rec structure.
383: );
384: p_object_version_number := l_rec.object_version_number;
385: --
386: if g_debug then
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: end if;
389: End upd;
390: --
391: end hxc_tkg_upd;