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: --
114: where lp_member_enrollment_id = p_rec.lp_member_enrollment_id;
115: --
116: --
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End pre_update;
184: --
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End pre_update;
184: --
185: -- ----------------------------------------------------------------------------
186: -- |-----------------------------< post_update >------------------------------|
221: --
222: l_proc varchar2(72) := g_package||'post_update';
223: --
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: begin
227: --
228: ota_lme_rku.after_update
229: (p_effective_date => p_effective_date
404: ,p_hook_type => 'AU');
405: --
406: end;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: End post_update;
410: --
411: -- ----------------------------------------------------------------------------
412: -- |-----------------------------< convert_defs >-----------------------------|
635: --
636: l_proc varchar2(72) := g_package||'upd';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- We must lock the row which we need to update.
642: --
643: ota_lme_shd.lck
731: l_rec ota_lme_shd.g_rec_type;
732: l_proc varchar2(72) := g_package||'upd';
733: --
734: Begin
735: hr_utility.set_location('Entering:'||l_proc, 5);
736: --
737: -- Call conversion function to turn arguments into the
738: -- l_rec structure.
739: --
792: ,l_rec
793: );
794: p_object_version_number := l_rec.object_version_number;
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: End upd;
798: --
799: end ota_lme_upd;