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: where wrkplc_vldtn_lvlnum_id = p_rec.wrkplc_vldtn_lvlnum_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 >------------------------------|
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: begin
191: --
192: pqh_lvl_rku.after_update
193: (p_effective_date => p_effective_date
224: ,p_hook_type => 'AU');
225: --
226: end;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End post_update;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |-----------------------------< convert_defs >-----------------------------|
311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must lock the row which we need to update.
318: --
319: pqh_lvl_shd.lck
371: l_rec pqh_lvl_shd.g_rec_type;
372: l_proc varchar2(72) := g_package||'upd';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- Call conversion function to turn arguments into the
378: -- l_rec structure.
379: --
396: ,l_rec
397: );
398: p_object_version_number := l_rec.object_version_number;
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: End upd;
402: --
403: end pqh_lvl_upd;