5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hrp_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;
88: --
89: --
90: --
91: if g_debug then
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: end if;
94: --
95: Exception
96: When hr_api.check_integrity_violated Then
153: --
154: Begin
155: if g_debug then
156: l_proc := g_package||'pre_update';
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: end if;
161: End pre_update;
155: if g_debug then
156: l_proc := g_package||'pre_update';
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: end if;
161: End pre_update;
162: --
163: -- ----------------------------------------------------------------------------
201: --
202: Begin
203: if g_debug then
204: l_proc := g_package||'post_update';
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: end if;
207: begin
208: --
209: hxc_hrp_rku.after_update
246: --
247: end;
248: --
249: if g_debug then
250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: end if;
252: End post_update;
253: --
254: -- ----------------------------------------------------------------------------
338: --
339: l_proc varchar2(72);
340: --
341: Begin
342: g_debug:=hr_utility.debug_enabled;
343: if g_debug then
344: l_proc := g_package||'upd';
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: end if;
341: Begin
342: g_debug:=hr_utility.debug_enabled;
343: if g_debug then
344: l_proc := g_package||'upd';
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: end if;
347: --
348: -- We must lock the row which we need to update.
349: --
397: l_rec hxc_hrp_shd.g_rec_type;
398: l_proc varchar2(72);
399: --
400: Begin
401: g_debug:=hr_utility.debug_enabled;
402: if g_debug then
403: l_proc := g_package||'upd';
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: end if;
400: Begin
401: g_debug:=hr_utility.debug_enabled;
402: if g_debug then
403: l_proc := g_package||'upd';
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: end if;
406: --
407: -- Call conversion function to turn arguments into the
408: -- l_rec structure.
428: );
429: p_object_version_number := l_rec.object_version_number;
430: --
431: if g_debug then
432: hr_utility.set_location(' Leaving:'||l_proc, 10);
433: end if;
434: End upd;
435: --
436: end hxc_hrp_upd;