55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
77: where range_id = p_rec.range_id;
78: --
79: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
180: --
181: l_proc varchar2(72) := g_package||'post_update';
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
187: End post_update;
188: --
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
187: End post_update;
188: --
189: -- ----------------------------------------------------------------------------
190: -- |-----------------------------< convert_defs >-----------------------------|
234: l_proc varchar2(72) := g_package||'convert_defs';
235: --
236: Begin
237: --
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: -- We must now examine each argument value in the
241: -- p_rec plsql record structure
242: -- to see if a system default is being used. If a system default
259: ben_ran_shd.g_old_rec.ending_person_action_id;
260: End If;
261:
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: --
265: End convert_defs;
266: --
267: -- ----------------------------------------------------------------------------
275: --
276: l_proc varchar2(72) := g_package||'upd';
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- We must lock the row which we need to update.
282: --
283: ben_ran_shd.lck
327: l_rec ben_ran_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'upd';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- Call conversion function to turn arguments into the
334: -- l_rec structure.
335: --
351: upd(
352: p_effective_date,l_rec);
353: p_object_version_number := l_rec.object_version_number;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: End upd;
357: --
358: end ben_ran_upd;