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: --
111: where extra_input_value_id = p_rec.extra_input_value_id;
112: --
113: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
174: --
175: l_proc varchar2(72) := g_package||'pre_update';
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: End pre_update;
182: --
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: End pre_update;
182: --
183: -- ----------------------------------------------------------------------------
184: -- |-----------------------------< post_update >------------------------------|
219: --
220: l_proc varchar2(72) := g_package||'post_update';
221: --
222: Begin
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: begin
225: --
226: ben_eiv_rku.after_update
227: (p_extra_input_value_id
391: ,p_hook_type => 'AU');
392: --
393: end;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End post_update;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |-----------------------------< convert_defs >-----------------------------|
610: --
611: l_proc varchar2(72) := g_package||'upd';
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- We must lock the row which we need to update.
617: --
618: ben_eiv_shd.lck
699: l_rec ben_eiv_shd.g_rec_type;
700: l_proc varchar2(72) := g_package||'upd';
701: --
702: Begin
703: hr_utility.set_location('Entering:'||l_proc, 5);
704: --
705: -- Call conversion function to turn arguments into the
706: -- l_rec structure.
707: --
757: ,l_rec
758: );
759: p_object_version_number := l_rec.object_version_number;
760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: End upd;
763: --
764: end ben_eiv_upd;