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: --
80: where salary_cap_override_id = p_rec.salary_cap_override_id;
81: --
82: --
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_update;
150: --
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_update;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |-----------------------------< post_update >------------------------------|
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: begin
192: --
193: psp_pso_rku.after_update
194: (p_salary_cap_override_id
232: ,p_hook_type => 'AU');
233: --
234: end;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End post_update;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |-----------------------------< convert_defs >-----------------------------|
326: --
327: l_proc varchar2(72) := g_package||'upd';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: -- We must lock the row which we need to update.
333: --
334: psp_pso_shd.lck
385: l_rec psp_pso_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: --
411: (l_rec
412: );
413: p_object_version_number := l_rec.object_version_number;
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 10);
416: End upd;
417: --
418: end psp_pso_upd;