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: --
103: and category_usage_id = p_rec.category_usage_id;
104: --
105: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
165: --
166: l_proc varchar2(72) := g_package||'pre_update';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: End pre_update;
173: --
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: End pre_update;
173: --
174: -- ----------------------------------------------------------------------------
175: -- |-----------------------------< post_update >------------------------------|
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: begin
216: --
217: ota_aci_rku.after_update
218: (p_effective_date => p_effective_date
343: ,p_hook_type => 'AU');
344: --
345: end;
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 10);
348: End post_update;
349: --
350: -- ----------------------------------------------------------------------------
351: -- |-----------------------------< convert_defs >-----------------------------|
522: --
523: l_proc varchar2(72) := g_package||'upd';
524: --
525: Begin
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- We must lock the row which we need to update.
529: --
530: ota_aci_shd.lck
607: l_rec ota_aci_shd.g_rec_type;
608: l_proc varchar2(72) := g_package||'upd';
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Call conversion function to turn arguments into the
614: -- l_rec structure.
615: --
656: ,l_rec
657: );
658: p_object_version_number := l_rec.object_version_number;
659: --
660: hr_utility.set_location(' Leaving:'||l_proc, 10);
661: End upd;
662: --
663: end ota_aci_upd;