6: -- --------------------------------------------------------------------------
7:
8: g_package varchar2(33) := ' hxc_tbb_upd.'; -- global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: -- --------------------------------------------------------------------------
13: -- |------------------------------< update_dml >----------------------------|
14: -- --------------------------------------------------------------------------
64:
65:
66: if g_debug then
67: l_proc := g_package||'update_dml';
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: end if;
70:
71: -- increment the object version
72:
100:
101: where time_building_block_id = p_rec.time_building_block_id;
102:
103: if g_debug then
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: end if;
106:
107: exception
108: when hr_api.check_integrity_violated then
165:
166:
167: if g_debug then
168: l_proc := g_package||'pre_update';
169: hr_utility.set_location('Entering:'||l_proc, 5);
170:
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: end if;
173:
167: if g_debug then
168: l_proc := g_package||'pre_update';
169: hr_utility.set_location('Entering:'||l_proc, 5);
170:
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: end if;
173:
174: end pre_update;
175:
217:
218:
219: if g_debug then
220: l_proc := g_package||'post_update';
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: end if;
223: begin
224:
225: hxc_tbb_rku.after_update
302:
303: end;
304:
305: if g_debug then
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: end if;
308:
309: end post_update;
310:
451: l_proc varchar2(72);
452:
453: begin
454:
455: g_debug := hr_utility.debug_enabled;
456:
457: if g_debug then
458: l_proc := g_package||'upd';
459: hr_utility.set_location('Entering:'||l_proc, 5);
455: g_debug := hr_utility.debug_enabled;
456:
457: if g_debug then
458: l_proc := g_package||'upd';
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: end if;
461:
462: -- we must lock the row which we need to update.
463:
522: l_proc varchar2(72);
523:
524: begin
525:
526: g_debug := hr_utility.debug_enabled;
527:
528: if g_debug then
529: l_proc := g_package||'upd';
530: hr_utility.set_location('Entering:'||l_proc, 5);
526: g_debug := hr_utility.debug_enabled;
527:
528: if g_debug then
529: l_proc := g_package||'upd';
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: end if;
532:
533: -- call conversion function to turn arguments into the
534: -- l_rec structure.
567: );
568: p_object_version_number := l_rec.object_version_number;
569:
570: if g_debug then
571: hr_utility.set_location(' Leaving:'||l_proc, 10);
572: end if;
573:
574: end upd;
575: