5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ulp_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
61: Begin
62:
63: if g_debug then
64: l_proc := g_package||'update_dml';
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: end if;
67: --
68: -- Increment the object version
69: p_rec.object_version_number := p_rec.object_version_number + 1;
91: --
92: --
93: --
94: if g_debug then
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: end if;
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
157: Begin
158:
159: if g_debug then
160: l_proc := g_package||'pre_update';
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: end if;
164: End pre_update;
165: --
158:
159: if g_debug then
160: l_proc := g_package||'pre_update';
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: end if;
164: End pre_update;
165: --
166: -- ----------------------------------------------------------------------------
204: Begin
205:
206: if g_debug then
207: l_proc := g_package||'post_update';
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: end if;
210: begin
211: --
212: hxc_ulp_rku.after_update
256: --
257: end;
258: --
259: if g_debug then
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: end if;
262: End post_update;
263: --
264: -- ----------------------------------------------------------------------------
355: --
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: -- We must lock the row which we need to update.
366: --
413: l_rec hxc_ulp_shd.g_rec_type;
414: l_proc varchar2(72) ;
415: --
416: Begin
417: g_debug :=hr_utility.debug_enabled;
418: if g_debug then
419: l_proc := g_package||'upd';
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: end if;
416: Begin
417: g_debug :=hr_utility.debug_enabled;
418: if g_debug then
419: l_proc := g_package||'upd';
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: end if;
422: --
423: -- Call conversion function to turn arguments into the
424: -- l_rec structure.
445: );
446: p_object_version_number := l_rec.object_version_number;
447: --
448: if g_debug then
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: end if;
451: End upd;
452: --
453: end hxc_ulp_upd;