6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_rtr_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;
88: --
89: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
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
155:
156:
157: if g_debug then
158: l_proc := g_package||'pre_update';
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: end if;
163: End pre_update;
157: if g_debug then
158: l_proc := g_package||'pre_update';
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: end if;
163: End pre_update;
164: --
165: -- ----------------------------------------------------------------------------
205:
206:
207: if g_debug then
208: l_proc := g_package||'post_update';
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: end if;
211: begin
212: --
213: hxc_rtr_rku.after_update
238: --
239: end;
240: --
241: if g_debug then
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: end if;
244: End post_update;
245: --
246: -- ----------------------------------------------------------------------------
318: --
319: l_proc varchar2(72);
320: --
321: Begin
322: g_debug := hr_utility.debug_enabled;
323:
324: if g_debug then
325: l_proc := g_package||'upd';
326: hr_utility.set_location('Entering:'||l_proc, 5);
322: g_debug := hr_utility.debug_enabled;
323:
324: if g_debug then
325: l_proc := g_package||'upd';
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: end if;
328: --
329: -- We must lock the row which we need to update.
330: --
375: l_rec hxc_rtr_shd.g_rec_type;
376: l_proc varchar2(72);
377: --
378: Begin
379: g_debug := hr_utility.debug_enabled;
380:
381: if g_debug then
382: l_proc := g_package||'upd';
383: hr_utility.set_location('Entering:'||l_proc, 5);
379: g_debug := hr_utility.debug_enabled;
380:
381: if g_debug then
382: l_proc := g_package||'upd';
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: end if;
385: --
386: -- Call conversion function to turn arguments into the
387: -- l_rec structure.
404: );
405: p_object_version_number := l_rec.object_version_number;
406: --
407: if g_debug then
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: end if;
410: End upd;
411: --
412: end hxc_rtr_upd;