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: --
110: where learning_path_id = p_rec.learning_path_id;
111: --
112: --
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End pre_update;
180: --
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End pre_update;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |-----------------------------< post_update >------------------------------|
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
220: Begin
221: hr_utility.set_location('Entering:'||l_proc, 5);
222:
223: begin
224: --
225: ota_lps_rku.after_update
386: --
387: end;
388: --
389:
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: End post_update;
392: --
393: -- ----------------------------------------------------------------------------
394: -- |-----------------------------< convert_defs >-----------------------------|
601: --
602: l_proc varchar2(72) := g_package||'upd';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- We must lock the row which we need to update.
608: --
609: ota_lps_shd.lck
693: l_rec ota_lps_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'upd';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Call conversion function to turn arguments into the
700: -- l_rec structure.
701: --
750: ,l_rec
751: );
752: p_object_version_number := l_rec.object_version_number;
753: --
754: hr_utility.set_location(' Leaving:'||l_proc, 10);
755: End upd;
756: --
757: end ota_lps_upd;