6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_htr_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;
95: --
96: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
97: --
98: if g_debug then
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: end if;
101: --
102: Exception
103: When hr_api.check_integrity_violated Then
162:
163:
164: if g_debug then
165: l_proc := g_package||'pre_update';
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: end if;
168: --
169: if g_debug then
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: end if;
168: --
169: if g_debug then
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: end if;
172: End pre_update;
173: --
174: -- ----------------------------------------------------------------------------
214:
215:
216: if g_debug then
217: l_proc := g_package||'post_update';
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: end if;
220: begin
221: --
222: hxc_htr_rku.after_update
275: --
276: end;
277: --
278: if g_debug then
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: end if;
281: End post_update;
282: --
283: -- ----------------------------------------------------------------------------
355: --
356: l_proc varchar2(72);
357: --
358: Begin
359: g_debug := hr_utility.debug_enabled;
360:
361: if g_debug then
362: l_proc := g_package||'upd';
363: hr_utility.set_location('Entering:'||l_proc, 5);
359: g_debug := hr_utility.debug_enabled;
360:
361: if g_debug then
362: l_proc := g_package||'upd';
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: end if;
365: --
366: -- We must lock the row which we need to update.
367: --
419: l_rec hxc_htr_shd.g_rec_type;
420: l_proc varchar2(72);
421: --
422: Begin
423: g_debug := hr_utility.debug_enabled;
424:
425: if g_debug then
426: l_proc := g_package||'upd';
427: hr_utility.set_location('Entering:'||l_proc, 5);
423: g_debug := hr_utility.debug_enabled;
424:
425: if g_debug then
426: l_proc := g_package||'upd';
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: end if;
429: --
430: -- Call conversion function to turn arguments into the
431: -- l_rec structure.
456: );
457: p_object_version_number := l_rec.object_version_number;
458: --
459: if g_debug then
460: hr_utility.set_location(' Leaving:'||l_proc, 10);
461: end if;
462: End upd;
463: --
464: end hxc_htr_upd;