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 compl_appeal_id = p_rec.compl_appeal_id;
106: --
107: --
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: ghr_cca_rku.after_update
220: (p_effective_date => p_effective_date
294: ,p_hook_type => 'AU');
295: --
296: end;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End post_update;
300: --
301: -- ----------------------------------------------------------------------------
302: -- |-----------------------------< convert_defs >-----------------------------|
489: --
490: l_proc varchar2(72) := g_package||'upd';
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- We must lock the row which we need to update.
496: --
497: ghr_cca_shd.lck
570: l_rec ghr_cca_shd.g_rec_type;
571: l_proc varchar2(72) := g_package||'upd';
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call conversion function to turn arguments into the
577: -- l_rec structure.
578: --
622: ,l_rec
623: );
624: p_object_version_number := l_rec.object_version_number;
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End upd;
628: --
629: end ghr_cca_upd;