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: --
81: where exception_group_id = p_rec.exception_group_id;
82: --
83: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------< post_update >------------------------------|
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: begin
193: --
194: pqp_erg_rku.after_update (
195: p_exception_group_id
233: ,p_hook_type => 'AU');
234: --
235: end;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: End post_update;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------------< convert_defs >-----------------------------|
331: --
332: l_proc varchar2(72) := g_package||'upd';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- We must lock the row which we need to update.
338: --
339: pqp_erg_shd.lck
385: l_rec pqp_erg_shd.g_rec_type;
386: l_proc varchar2(72) := g_package||'upd';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: --
391: -- Call conversion function to turn arguments into the
392: -- l_rec structure.
393: --
412: (l_rec
413: );
414: p_object_version_number := l_rec.object_version_number;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: End upd;
418: --
419: end pqp_erg_upd;