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: --
120: where comp_element_outcome_id = p_rec.comp_element_outcome_id;
121: --
122: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End pre_update;
190: --
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End pre_update;
190: --
191: -- ----------------------------------------------------------------------------
192: -- |-----------------------------< post_update >------------------------------|
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: begin
233: --
234: per_ceo_rku.after_update
235: (p_effective_date => p_effective_date
434: ,p_hook_type => 'AU');
435: --
436: end;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: End post_update;
440: --
441: -- ----------------------------------------------------------------------------
442: -- |-----------------------------< convert_defs >-----------------------------|
689: --
690: l_proc varchar2(72) := g_package||'upd';
691: --
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- We must lock the row which we need to update.
696: --
697: per_ceo_shd.lck
791: l_rec per_ceo_shd.g_rec_type;
792: l_proc varchar2(72) := g_package||'upd';
793: --
794: Begin
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: -- Call conversion function to turn arguments into the
798: -- l_rec structure.
799: --
858: ,l_rec
859: );
860: p_object_version_number := l_rec.object_version_number;
861: --
862: hr_utility.set_location(' Leaving:'||l_proc, 10);
863: End upd;
864: --
865: end per_ceo_upd;