5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hat_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;
85: --
86: --
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
150: --
151: Begin
152: if g_debug then
153: l_proc := g_package||'pre_update';
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: end if;
158: End pre_update;
152: if g_debug then
153: l_proc := g_package||'pre_update';
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: end if;
158: End pre_update;
159: --
160: -- ----------------------------------------------------------------------------
197: --
198: Begin
199: if g_debug then
200: l_proc := g_package||'post_update';
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: end if;
203: begin
204: --
205: hxc_hat_rku.after_update
229: --
230: end;
231: --
232: if g_debug then
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: end if;
235: End post_update;
236: --
237: -- ----------------------------------------------------------------------------
308: --
309: l_proc varchar2(72);
310: --
311: Begin
312: g_debug:=hr_utility.debug_enabled;
313: if g_debug then
314: l_proc := g_package||'upd';
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: end if;
311: Begin
312: g_debug:=hr_utility.debug_enabled;
313: if g_debug then
314: l_proc := g_package||'upd';
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: end if;
317: --
318: -- We must lock the row which we need to update.
319: --
367: l_rec hxc_hat_shd.g_rec_type;
368: l_proc varchar2(72);
369: --
370: Begin
371: g_debug:=hr_utility.debug_enabled;
372: if g_debug then
373: l_proc := g_package||'upd';
374: hr_utility.set_location('Entering:'||l_proc, 5);
375: end if;
370: Begin
371: g_debug:=hr_utility.debug_enabled;
372: if g_debug then
373: l_proc := g_package||'upd';
374: hr_utility.set_location('Entering:'||l_proc, 5);
375: end if;
376: --
377: -- Call conversion function to turn arguments into the
378: -- l_rec structure.
394: );
395: p_object_version_number := l_rec.object_version_number;
396: --
397: if g_debug then
398: hr_utility.set_location(' Leaving:'||l_proc, 10);
399: end if;
400: End upd;
401: --
402: end hxc_hat_upd;