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: --
78: and user_id = p_rec.user_id;
79: --
80: --
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End pre_update;
148: --
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End pre_update;
148: --
149: -- ----------------------------------------------------------------------------
150: -- |-----------------------------< post_update >------------------------------|
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: begin
190: --
191: per_sos_rku.after_update
192: (p_solution_id
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 >-----------------------------|
281: --
282: l_proc varchar2(72) := g_package||'upd';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- We must lock the row which we need to update.
288: --
289: per_sos_shd.lck
338: l_rec per_sos_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
360: (l_rec
361: );
362: p_object_version_number := l_rec.object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End upd;
366: --
367: end per_sos_upd;