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: --
101: where conference_server_id = p_rec.conference_server_id;
102: --
103: --
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
163: --
164: l_proc varchar2(72) := g_package||'pre_update';
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: End pre_update;
171: --
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: End pre_update;
171: --
172: -- ----------------------------------------------------------------------------
173: -- |-----------------------------< post_update >------------------------------|
208: --
209: l_proc varchar2(72) := g_package||'post_update';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: begin
214: --
215: ota_cfs_rku.after_update
216: (p_effective_date => p_effective_date
339: ,p_hook_type => 'AU');
340: --
341: end;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: End post_update;
345: --
346: -- ----------------------------------------------------------------------------
347: -- |-----------------------------< convert_defs >-----------------------------|
520: --
521: l_proc varchar2(72) := g_package||'upd';
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- We must lock the row which we need to update.
527: --
528: ota_cfs_shd.lck
606: l_rec ota_cfs_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'upd';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Call conversion function to turn arguments into the
613: -- l_rec structure.
614: --
657: ,p_name
658: );
659: p_object_version_number := l_rec.object_version_number;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: End upd;
663: --
664: end ota_cfs_upd;