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: --
76: where cagr_retained_right_id = p_rec.cagr_retained_right_id;
77: --
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
147: -- ----------------------------------------------------------------------------
148: -- |-----------------------------< post_update >------------------------------|
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: /*
189: begin
190: --
191: per_ret_rku.after_update
264: --
265: end;
266: */
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: End post_update;
270: --
271: -- ----------------------------------------------------------------------------
272: -- |-----------------------------< convert_defs >-----------------------------|
439: --
440: l_proc varchar2(72) := g_package||'upd';
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- We must lock the row which we need to update.
446: --
447: per_ret_shd.lck
490: l_rec per_ret_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'upd';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: -- Call conversion function to turn arguments into the
497: -- l_rec structure.
498: --
537: ,l_rec
538: );
539: p_object_version_number := l_rec.object_version_number;
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: End upd;
543: --
544: end per_ret_upd;