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: --
132: where veh_repos_extra_info_id = p_rec.veh_repos_extra_info_id;
133: --
134: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
194: --
195: l_proc varchar2(72) := g_package||'pre_update';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End pre_update;
202: --
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End pre_update;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------------< post_update >------------------------------|
238: --
239: l_proc varchar2(72) := g_package||'post_update';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: begin
244: --
245: pqp_vri_rku.after_update
246: (p_veh_repos_extra_info_id
492: ,p_hook_type => 'AU');
493: --
494: end;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: End post_update;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |-----------------------------< convert_defs >-----------------------------|
794: --
795: l_proc varchar2(72) := g_package||'upd';
796: --
797: Begin
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: -- We must lock the row which we need to update.
801: --
802: pqp_vri_shd.lck
905: l_rec pqp_vri_shd.g_rec_type;
906: l_proc varchar2(72) := g_package||'upd';
907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: --
911: -- Call conversion function to turn arguments into the
912: -- l_rec structure.
913: --
983: (l_rec
984: );
985: p_object_version_number := l_rec.object_version_number;
986: --
987: hr_utility.set_location(' Leaving:'||l_proc, 10);
988: End upd;
989: --
990: end pqp_vri_upd;