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: --
124: where effort_report_approval_id = p_rec.effort_report_approval_id;
125: --
126: --
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: End pre_update;
194: --
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: End pre_update;
194: --
195: -- ----------------------------------------------------------------------------
196: -- |-----------------------------< post_update >------------------------------|
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: begin
236: --
237: psp_era_rku.after_update
238: (p_effort_report_approval_id
452: ,p_hook_type => 'AU');
453: --
454: end;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End post_update;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |-----------------------------< convert_defs >-----------------------------|
722: --
723: l_proc varchar2(72) := g_package||'upd';
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- We must lock the row which we need to update.
729: --
730: psp_era_shd.lck
825: l_rec psp_era_shd.g_rec_type;
826: l_proc varchar2(72) := g_package||'upd';
827: --
828: Begin
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Call conversion function to turn arguments into the
832: -- l_rec structure.
833: --
895: (l_rec
896: );
897: p_object_version_number := l_rec.object_version_number;
898: --
899: hr_utility.set_location(' Leaving:'||l_proc, 10);
900: End upd;
901: --
902: end psp_era_upd;