6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_mcu_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: -- Increment the object version
71: p_rec.object_version_number := p_rec.object_version_number + 1;
87: --
88: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
89: --
90: if g_debug then
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: end if;
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
154:
155:
156: if g_debug then
157: l_proc := g_package||'pre_update';
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: end if;
162: End pre_update;
156: if g_debug then
157: l_proc := g_package||'pre_update';
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: end if;
162: End pre_update;
163: --
164: -- ----------------------------------------------------------------------------
203:
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_mcu_rku.after_update
235: --
236: end;
237: --
238: if g_debug then
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: end if;
241: End post_update;
242: --
243: -- ----------------------------------------------------------------------------
314: --
315: l_proc varchar2(72);
316: --
317: Begin
318: g_debug := hr_utility.debug_enabled;
319:
320: if g_debug then
321: l_proc := g_package||'upd';
322: hr_utility.set_location('Entering:'||l_proc, 5);
318: g_debug := hr_utility.debug_enabled;
319:
320: if g_debug then
321: l_proc := g_package||'upd';
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: end if;
324: --
325: -- We must lock the row which we need to update.
326: --
368: l_rec hxc_mcu_shd.g_rec_type;
369: l_proc varchar2(72);
370: --
371: Begin
372: g_debug := hr_utility.debug_enabled;
373:
374: if g_debug then
375: l_proc := g_package||'upd';
376: hr_utility.set_location('Entering:'||l_proc, 5);
372: g_debug := hr_utility.debug_enabled;
373:
374: if g_debug then
375: l_proc := g_package||'upd';
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: end if;
378: --
379: -- Call conversion function to turn arguments into the
380: -- l_rec structure.
396: );
397: p_object_version_number := l_rec.object_version_number;
398: --
399: if g_debug then
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: end if;
402: End upd;
403: --
404: end hxc_mcu_upd;