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: --
81: and object_type = p_rec.object_type;
82: --
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------< post_update >------------------------------|
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: begin
194: --
195: ota_coi_rku.after_update
196: (p_effective_date => p_effective_date
227: ,p_hook_type => 'AU');
228: --
229: end;
230: --
231: hr_utility.set_location(' Leaving:'||l_proc, 10);
232: End post_update;
233: --
234: -- ----------------------------------------------------------------------------
235: -- |-----------------------------< convert_defs >-----------------------------|
310: --
311: l_proc varchar2(72) := g_package||'upd';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- We must lock the row which we need to update.
317: --
318: ota_coi_shd.lck
373: l_rec ota_coi_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call conversion function to turn arguments into the
380: -- l_rec structure.
381: --
399: ,l_rec
400: );
401: p_object_version_number := l_rec.object_version_number;
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 10);
404: End upd;
405: --
406: end ota_coi_upd;