6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lck_upd.'; -- Global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- ----------------------------------------------------------------------------
13: -- |------------------------------< update_dml >------------------------------|
14: -- ----------------------------------------------------------------------------
63:
64:
65: if g_debug then
66: l_proc := g_package||'update_dml';
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: end if;
69: --
70: --
71: --
84: --
85: --
86: --
87: if g_debug then
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: end if;
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
151:
152:
153: if g_debug then
154: l_proc := g_package||'pre_update';
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: end if;
159: End pre_update;
153: if g_debug then
154: l_proc := g_package||'pre_update';
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: end if;
159: End pre_update;
160: --
161: -- ----------------------------------------------------------------------------
200:
201:
202: if g_debug then
203: l_proc := g_package||'post_update';
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: end if;
206: begin
207: --
208: hxc_lck_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:
314: if g_debug then
315: l_proc := g_package||'upd';
316: hr_utility.set_location('Entering:'||l_proc, 5);
312: g_debug := hr_utility.debug_enabled;
313:
314: if g_debug then
315: l_proc := g_package||'upd';
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: end if;
318: --
319: -- We must lock the row which we need to update.
320: --
366: l_rec hxc_lck_shd.g_rec_type;
367: l_proc varchar2(72);
368: --
369: Begin
370: g_debug := hr_utility.debug_enabled;
371:
372: if g_debug then
373: l_proc := g_package||'upd';
374: hr_utility.set_location('Entering:'||l_proc, 5);
370: g_debug := hr_utility.debug_enabled;
371:
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.
393: );
394: --
395: --
396: if g_debug then
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: end if;
399: End upd;
400: --
401: end hxc_lck_upd;