5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ula_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;
90: --
91: --
92: --
93: if g_debug then
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
156: Begin
157:
158: if g_debug then
159: l_proc := g_package||'pre_update';
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: end if;
163: End pre_update;
164: --
157:
158: if g_debug then
159: l_proc := g_package||'pre_update';
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: end if;
163: End pre_update;
164: --
165: -- ----------------------------------------------------------------------------
203: Begin
204:
205: if g_debug then
206: l_proc := g_package||'post_update';
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: end if;
209: begin
210: --
211: hxc_ula_rku.after_update
251: --
252: end;
253: --
254: if g_debug then
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: end if;
257: End post_update;
258: --
259: -- ----------------------------------------------------------------------------
346: --
347: l_proc varchar2(72) ;
348: --
349: Begin
350: g_debug :=hr_utility.debug_enabled;
351: if g_debug then
352: l_proc := g_package||'upd';
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: end if;
349: Begin
350: g_debug :=hr_utility.debug_enabled;
351: if g_debug then
352: l_proc := g_package||'upd';
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: end if;
355: --
356: -- We must lock the row which we need to update.
357: --
403: l_rec hxc_ula_shd.g_rec_type;
404: l_proc varchar2(72) ;
405: --
406: Begin
407: g_debug :=hr_utility.debug_enabled;
408: if g_debug then
409: l_proc := g_package||'upd';
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: end if;
406: Begin
407: g_debug :=hr_utility.debug_enabled;
408: if g_debug then
409: l_proc := g_package||'upd';
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: end if;
412: --
413: -- Call conversion function to turn arguments into the
414: -- l_rec structure.
434: );
435: p_object_version_number := l_rec.object_version_number;
436: --
437: if g_debug then
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: end if;
440: End upd;
441: --
442: end hxc_ula_upd;