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: --
153: where effort_report_detail_id = p_rec.effort_report_detail_id;
154: --
155: --
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: --
159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
215: --
216: l_proc varchar2(72) := g_package||'pre_update';
217: --
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End pre_update;
223: --
217: --
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End pre_update;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |-----------------------------< post_update >------------------------------|
259: --
260: l_proc varchar2(72) := g_package||'post_update';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: begin
265: --
266: psp_erd_rku.after_update
267: (p_effort_report_detail_id
597: ,p_hook_type => 'AU');
598: --
599: end;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End post_update;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |-----------------------------< convert_defs >-----------------------------|
983: --
984: l_proc varchar2(72) := g_package||'upd';
985: --
986: Begin
987: hr_utility.set_location('Entering:'||l_proc, 5);
988: --
989: -- We must lock the row which we need to update.
990: --
991: psp_erd_shd.lck
1115: l_rec psp_erd_shd.g_rec_type;
1116: l_proc varchar2(72) := g_package||'upd';
1117: --
1118: Begin
1119: hr_utility.set_location('Entering:'||l_proc, 5);
1120: --
1121: -- Call conversion function to turn arguments into the
1122: -- l_rec structure.
1123: --
1214: (l_rec
1215: );
1216: p_object_version_number := l_rec.object_version_number;
1217: --
1218: hr_utility.set_location(' Leaving:'||l_proc, 10);
1219: End upd;
1220: --
1221: end psp_erd_upd;