5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hph_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
60: --
61: Begin
62: if g_debug then
63: l_proc := g_package||'update_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: --
67: -- Increment the object version
68: p_rec.object_version_number := p_rec.object_version_number + 1;
126: --
127: --
128: --
129: if g_debug then
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
211: --
212: Begin
213: if g_debug then
214: l_proc := g_package||'pre_update';
215: hr_utility.set_location('Entering:'||l_proc, 10);
216: end if;
217: --
218: --
219: if (p_rec.pref_definition_id is not null) then
236: p_rec.code := null;
237: end if;
238:
239: if g_debug then
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: end if;
242: End pre_update;
243: --
244: -- ----------------------------------------------------------------------------
283: --
284: Begin
285: if g_debug then
286: l_proc:= g_package||'post_update';
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: end if;
289: begin
290: --
291: hxc_hph_rku.after_update
476: --
477: end;
478: --
479: if g_debug then
480: hr_utility.set_location(' Leaving:'||l_proc, 10);
481: end if;
482: End post_update;
483: --
484: -- ----------------------------------------------------------------------------
720: --
721: l_proc varchar2(72);
722: --
723: Begin
724: g_debug:=hr_utility.debug_enabled;
725: if g_debug then
726: l_proc := g_package||'upd';
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: end if;
723: Begin
724: g_debug:=hr_utility.debug_enabled;
725: if g_debug then
726: l_proc := g_package||'upd';
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: end if;
729: --
730: -- We must lock the row which we need to update.
731: --
817: l_rec hxc_hph_shd.g_rec_type;
818: l_proc varchar2(72);
819: --
820: Begin
821: g_debug:=hr_utility.debug_enabled;
822: if g_debug then
823: l_proc := g_package||'upd';
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: end if;
820: Begin
821: g_debug:=hr_utility.debug_enabled;
822: if g_debug then
823: l_proc := g_package||'upd';
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: end if;
826: --
827: -- Call conversion function to turn arguments into the
828: -- l_rec structure.
886: );
887: p_object_version_number := l_rec.object_version_number;
888: --
889: if g_debug then
890: hr_utility.set_location(' Leaving:'||l_proc, 10);
891: end if;
892: End upd;
893: --
894: end hxc_hph_upd;