5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hav_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: -- Increment the object version
68: p_rec.object_version_number := p_rec.object_version_number + 1;
119: --
120: --
121: --
122: if g_debug then
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: end if;
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
184: --
185: Begin
186: if g_debug then
187: l_proc := g_package||'pre_update';
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: end if;
192: End pre_update;
186: if g_debug then
187: l_proc := g_package||'pre_update';
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: end if;
192: End pre_update;
193: --
194: -- ----------------------------------------------------------------------------
231: --
232: Begin
233: if g_debug then
234: l_proc := g_package||'post_update';
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: end if;
237: begin
238:
239: hxc_time_category_utils_pkg.alias_value_ref_int_chk ( p_rec.alias_value_id, 'UPDATE' );
401: --
402: end;
403: --
404: if g_debug then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: end if;
407: End post_update;
408: --
409: -- ----------------------------------------------------------------------------
616: --
617: l_proc varchar2(72);
618: --
619: Begin
620: g_debug:=hr_utility.debug_enabled;
621: if g_debug then
622: l_proc := g_package||'upd';
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: end if;
619: Begin
620: g_debug:=hr_utility.debug_enabled;
621: if g_debug then
622: l_proc := g_package||'upd';
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: end if;
625: --
626: -- We must lock the row which we need to update.
627: --
703: l_rec hxc_hav_shd.g_rec_type;
704: l_proc varchar2(72);
705: --
706: Begin
707: g_debug:=hr_utility.debug_enabled;
708: if g_debug then
709: l_proc := g_package||'upd';
710: hr_utility.set_location('Entering:'||l_proc, 5);
711: end if;
706: Begin
707: g_debug:=hr_utility.debug_enabled;
708: if g_debug then
709: l_proc := g_package||'upd';
710: hr_utility.set_location('Entering:'||l_proc, 5);
711: end if;
712: --
713: -- Call conversion function to turn arguments into the
714: -- l_rec structure.
778: );
779:
780: --
781: if g_debug then
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
783: end if;
784: End upd;
785: --
786: end hxc_hav_upd;