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: --
129: where successor_in_plan_id = p_rec.successor_in_plan_id;
130: --
131: per_sip_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
191: --
192: l_proc varchar2(72) := g_package||'pre_update';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_update;
199: --
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_update;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< post_update >------------------------------|
236: --
237: l_proc varchar2(72) := g_package||'post_update';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: begin
242: --
243: per_sip_rku.after_update
244: (p_effective_date => p_effective_date
479: ,p_hook_type => 'AU');
480: --
481: end;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 10);
484: End post_update;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |-----------------------------< convert_defs >-----------------------------|
770: --
771: l_proc varchar2(72) := g_package||'upd';
772: --
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- We must lock the row which we need to update.
777: --
778: per_sip_shd.lck
881: l_rec per_sip_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'upd';
883: --
884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);
886: --
887: -- Call conversion function to turn arguments into the
888: -- l_rec structure.
889: --
957: ,l_rec
958: );
959: p_object_version_number := l_rec.object_version_number;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);
962: End upd;
963: --
964: end per_sip_upd;