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;
111: where popl_yr_perd_id = p_rec.popl_yr_perd_id;
112: --
113: ben_cpy_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
171: --
172: l_proc varchar2(72) := g_package||'pre_update';
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End pre_update;
179: --
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End pre_update;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |-----------------------------< post_update >------------------------------|
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: --
220: -- Start of API User Hook for post_update.
221: --
316: --
317: -- End of API User Hook for post_update.
318: --
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 10);
321: End post_update;
322: --
323: -- ----------------------------------------------------------------------------
324: -- |-----------------------------< convert_defs >-----------------------------|
368: l_proc varchar2(72) := g_package||'convert_defs';
369: --
370: Begin
371: --
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- We must now examine each argument value in the
375: -- p_rec plsql record structure
376: -- to see if a system default is being used. If a system default
528: p_rec.cpy_attribute30 :=
529: ben_cpy_shd.g_old_rec.cpy_attribute30;
530: End If;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: --
534: End convert_defs;
535: --
536: -- ----------------------------------------------------------------------------
543: --
544: l_proc varchar2(72) := g_package||'upd';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- We must lock the row which we need to update.
550: --
551: ben_cpy_shd.lck
626: l_rec ben_cpy_shd.g_rec_type;
627: l_proc varchar2(72) := g_package||'upd';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- Call conversion function to turn arguments into the
633: -- l_rec structure.
634: --
683: --
684: upd(l_rec);
685: p_object_version_number := l_rec.object_version_number;
686: --
687: hr_utility.set_location(' Leaving:'||l_proc, 10);
688: End upd;
689: --
690: end ben_cpy_upd;