57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
114: END IF;
115: --
116: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End pre_update;
184: --
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End pre_update;
184: --
185: -- ----------------------------------------------------------------------------
186: -- |-----------------------------< post_update >------------------------------|
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: begin
226: --
227: pqp_exr_rku.after_update (
228: p_exception_report_id => p_rec.exception_report_id
263: ,p_hook_type => 'AU');
264: --
265: end;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End post_update;
269: --
270: -- ----------------------------------------------------------------------------
271: -- |-----------------------------< convert_defs >-----------------------------|
381: --
382: l_proc varchar2(72) := g_package||'upd';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- We must lock the row which we need to update.
388: --
389: pqp_exr_shd.lck
443: l_rec pqp_exr_shd.g_rec_type;
444: l_proc varchar2(72) := g_package||'upd';
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: --
449: -- Call conversion function to turn arguments into the
450: -- l_rec structure.
451: --
473: --
474: pqp_exr_upd.upd (l_rec );
475: p_object_version_number := l_rec.object_version_number;
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: End upd;
479: --
480: end pqp_exr_upd;
481: