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: --
105: WHERE rate_id = p_rec.rate_id;
106: --
107: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: EXCEPTION
112: WHEN hr_api.check_integrity_violated THEN
113: -- A check constraint has been violated
167: --
168: l_proc VARCHAR2(72) := g_package||'pre_update';
169: --
170: BEGIN
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: END pre_update;
175: --
169: --
170: BEGIN
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: END pre_update;
175: --
176: -- ----------------------------------------------------------------------------
177: -- |-----------------------------< post_update >------------------------------|
212: --
213: l_proc VARCHAR2(72) := g_package||'post_update';
214: --
215: BEGIN
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: BEGIN
218: --
219: pay_pyr_rku.after_update
220: (p_effective_date => p_effective_date
367: ,p_hook_type => 'AU');
368: --
369: END;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: END post_update;
373: --
374: -- ----------------------------------------------------------------------------
375: -- |-----------------------------< convert_defs >-----------------------------|
570: --
571: l_proc VARCHAR2(72) := g_package||'upd';
572: --
573: BEGIN
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- We must lock the row which we need to update.
577: --
578: pay_pyr_shd.lck
653: l_rec pay_pyr_shd.g_rec_type;
654: l_proc VARCHAR2(72) := g_package||'upd';
655: --
656: BEGIN
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: -- Call conversion function to turn arguments INTO the
660: -- l_rec structure.
661: --
703: ,l_rec
704: );
705: p_object_version_number := l_rec.object_version_number;
706: --
707: hr_utility.set_location(' Leaving:'||l_proc, 10);
708: END upd;
709: --
710: END pay_pyr_upd;