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: --
75: where option_type_id = p_rec.option_type_id;
76: --
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: begin
187: --
188:
189: hr_oty_rku.after_update
210: ,p_hook_type => 'AU');
211: --
212: end;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End post_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< convert_defs >-----------------------------|
288: --
289: l_proc varchar2(72) := g_package||'upd';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- We must lock the row which we need to update.
295: --
296: hr_oty_shd.lck
342: l_rec hr_oty_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'upd';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call conversion function to turn arguments into the
349: -- l_rec structure.
350: --
364: (l_rec
365: );
366: p_object_version_number := l_rec.object_version_number;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 10);
369: End upd;
370: --
371: end hr_oty_upd;