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: --
100: where cert_mbr_enrollment_id = p_rec.cert_mbr_enrollment_id;
101: --
102: --
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: End pre_update;
170: --
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: End pre_update;
170: --
171: -- ----------------------------------------------------------------------------
172: -- |-----------------------------< post_update >------------------------------|
207: --
208: l_proc varchar2(72) := g_package||'post_update';
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: begin
213: --
214: ota_cme_rku.after_update
215: (p_effective_date => p_effective_date
334: ,p_hook_type => 'AU');
335: --
336: end;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 10);
339: End post_update;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |-----------------------------< convert_defs >-----------------------------|
509: --
510: l_proc varchar2(72) := g_package||'upd';
511: --
512: Begin
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- We must lock the row which we need to update.
516: --
517: ota_cme_shd.lck
591: l_rec ota_cme_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'upd';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
596: --
597: -- Call conversion function to turn arguments into the
598: -- l_rec structure.
599: --
638: ,l_rec
639: );
640: p_object_version_number := l_rec.object_version_number;
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: End upd;
644: --
645: end ota_cme_upd;