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;
93: where reporting_id = p_rec.reporting_id;
94: --
95: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
153: --
154: l_proc varchar2(72) := g_package||'pre_update';
155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_update;
161: --
155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_update;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------------< post_update >------------------------------|
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_update;
203: --
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_update;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< convert_defs >-----------------------------|
249: l_proc varchar2(72) := g_package||'convert_defs';
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- We must now examine each argument value in the
256: -- p_rec plsql record structure
257: -- to see if a system default is being used. If a system default
341: ben_bmn_shd.g_old_rec.text;
342: End If;
343:
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 10);
346: --
347: End convert_defs;
348: --
349: -- ----------------------------------------------------------------------------
356: --
357: l_proc varchar2(72) := g_package||'upd';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- We must lock the row which we need to update.
363: --
364: ben_bmn_shd.lck
421: l_rec ben_bmn_shd.g_rec_type;
422: l_proc varchar2(72) := g_package||'upd';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- Call conversion function to turn arguments into the
428: -- l_rec structure.
429: --
460: --
461: upd(l_rec);
462: p_object_version_number := l_rec.object_version_number;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
465: End upd;
466: --
467: end ben_bmn_upd;