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;
97: where cagr_grade_structure_id = p_rec.cagr_grade_structure_id;
98: --
99: per_grs_shd.g_api_dml := false; -- Unset the api dml status
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: End pre_update;
166: --
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: End pre_update;
166: --
167: -- ----------------------------------------------------------------------------
168: -- |-----------------------------< post_update >------------------------------|
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: --
208: -- Start of API User Hook for post_update.
209: --
277: --
278: -- End of API User Hook for post_update.
279: --
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End post_update;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |-----------------------------< convert_defs >-----------------------------|
329: l_proc varchar2(72) := g_package||'convert_defs';
330: --
331: Begin
332: --
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- We must now examine each argument value in the
336: -- p_rec plsql record structure
337: -- to see if a system default is being used. If a system default
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
435: End If;
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: --
439: End convert_defs;
440: --
441: -- ----------------------------------------------------------------------------
448: --
449: l_proc varchar2(72) := g_package||'upd';
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- We must lock the row which we need to update.
455: --
456: per_grs_shd.lck
482: --
483: post_update(p_effective_date => p_effective_date,
484: p_rec => p_rec);
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: --
488: End upd;
489: --
490: -- ----------------------------------------------------------------------------
524: l_rec per_grs_shd.g_rec_type;
525: l_proc varchar2(72) := g_package||'upd';
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- Call conversion function to turn arguments into the
531: -- l_rec structure.
532: --
568: upd(p_effective_date => p_effective_date,
569: p_rec => l_rec);
570: p_object_version_number := l_rec.object_version_number;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 10);
573: End upd;
574: --
575: end per_grs_upd;