6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_mpc_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;
90: --
91: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: if g_debug then
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
157:
158:
159: if g_debug then
160: l_proc := g_package||'pre_update';
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: end if;
165: End pre_update;
159: if g_debug then
160: l_proc := g_package||'pre_update';
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: end if;
165: End pre_update;
166: --
167: -- ----------------------------------------------------------------------------
206:
207:
208: if g_debug then
209: l_proc := g_package||'post_update';
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: end if;
212: begin
213: --
214: hxc_mpc_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: -- ----------------------------------------------------------------------------
333: --
334: l_proc varchar2(72);
335: --
336: Begin
337: g_debug := hr_utility.debug_enabled;
338:
339: if g_debug then
340: l_proc := g_package||'upd';
341: hr_utility.set_location('Entering:'||l_proc, 5);
337: g_debug := hr_utility.debug_enabled;
338:
339: if g_debug then
340: l_proc := g_package||'upd';
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: end if;
343: --
344: -- We must lock the row which we need to update.
345: --
389: l_rec hxc_mpc_shd.g_rec_type;
390: l_proc varchar2(72);
391: --
392: Begin
393: g_debug := hr_utility.debug_enabled;
394:
395: if g_debug then
396: l_proc := g_package||'upd';
397: hr_utility.set_location('Entering:'||l_proc, 5);
393: g_debug := hr_utility.debug_enabled;
394:
395: if g_debug then
396: l_proc := g_package||'upd';
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: end if;
399: --
400: -- Call conversion function to turn arguments into the
401: -- l_rec structure.
419: );
420: p_object_version_number := l_rec.object_version_number;
421: --
422: if g_debug then
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424: end if;
425: End upd;
426: --
427: end hxc_mpc_upd;