5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ulc_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
61: Begin
62:
63: if g_debug then
64: l_proc := g_package||'update_dml';
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: end if;
67: --
68: -- Increment the object version
69: p_rec.object_version_number := p_rec.object_version_number + 1;
102: --
103: --
104: --
105: if g_debug then
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: end if;
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
168: Begin
169:
170: if g_debug then
171: l_proc := g_package||'pre_update';
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: end if;
175: End pre_update;
176: --
169:
170: if g_debug then
171: l_proc := g_package||'pre_update';
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: end if;
175: End pre_update;
176: --
177: -- ----------------------------------------------------------------------------
215: Begin
216:
217: if g_debug then
218: l_proc := g_package||'post_update';
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: end if;
221: begin
222: --
223: hxc_ulc_rku.after_update
311: --
312: end;
313: --
314: if g_debug then
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: end if;
317: End post_update;
318: --
319: -- ----------------------------------------------------------------------------
454: --
455: l_proc varchar2(72) ;
456: --
457: Begin
458: g_debug :=hr_utility.debug_enabled;
459: if g_debug then
460: l_proc := g_package||'upd';
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: end if;
457: Begin
458: g_debug :=hr_utility.debug_enabled;
459: if g_debug then
460: l_proc := g_package||'upd';
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: end if;
463: --
464: -- We must lock the row which we need to update.
465: --
523: l_rec hxc_ulc_shd.g_rec_type;
524: l_proc varchar2(72) ;
525: --
526: Begin
527: g_debug :=hr_utility.debug_enabled;
528: if g_debug then
529: l_proc := g_package||'upd';
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: end if;
526: Begin
527: g_debug :=hr_utility.debug_enabled;
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.
566: );
567: p_object_version_number := l_rec.object_version_number;
568: --
569: if g_debug then
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: end if;
572: End upd;
573: --
574: end hxc_ulc_upd;