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;
88: where ext_chg_evt_log_id = p_rec.ext_chg_evt_log_id;
89: --
90: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End pre_update;
156: --
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End pre_update;
156: --
157: -- ----------------------------------------------------------------------------
158: -- |-----------------------------< post_update >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: --
198: -- Start of API User Hook for post_update.
199: --
249: --
250: -- End of API User Hook for post_update.
251: --
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: End post_update;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |-----------------------------< convert_defs >-----------------------------|
301: l_proc varchar2(72) := g_package||'convert_defs';
302: --
303: Begin
304: --
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- We must now examine each argument value in the
308: -- p_rec plsql record structure
309: -- to see if a system default is being used. If a system default
370: ben_xcl_shd.g_old_rec.business_group_id;
371: End If;
372:
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: --
376: End convert_defs;
377: --
378: -- ----------------------------------------------------------------------------
386: --
387: l_proc varchar2(72) := g_package||'upd';
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: -- We must lock the row which we need to update.
393: --
394: ben_xcl_shd.lck
449: l_rec ben_xcl_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'upd';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Call conversion function to turn arguments into the
456: -- l_rec structure.
457: --
497: upd(
498: p_effective_date,l_rec);
499: p_object_version_number := l_rec.object_version_number;
500: --
501: hr_utility.set_location(' Leaving:'||l_proc, 10);
502: End upd;
503: --
504: end ben_xcl_upd;