5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pac_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: -- Increment the object version
65: p_rec.object_version_number := p_rec.object_version_number + 1;
66: --
123: where allocated_checklist_id = p_rec.allocated_checklist_id;
124: --
125: --
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------------< post_update >------------------------------|
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: begin
236: --
237: per_pac_rku.after_update
238: (p_effective_date => p_effective_date
445: ,p_hook_type => 'AU');
446: --
447: end;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End post_update;
451: --
452: -- ----------------------------------------------------------------------------
453: -- |-----------------------------< convert_defs >-----------------------------|
708: --
709: l_proc varchar2(72) := g_package||'upd';
710: --
711: Begin
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: --
714: -- We must lock the row which we need to update.
715: --
716: per_pac_shd.lck
812: l_rec per_pac_shd.g_rec_type;
813: l_proc varchar2(72) := g_package||'upd';
814: --
815: Begin
816: hr_utility.set_location('Entering:'||l_proc, 5);
817: --
818: -- Call conversion function to turn arguments into the
819: -- l_rec structure.
820: --
881: ,l_rec
882: );
883: p_object_version_number := l_rec.object_version_number;
884: --
885: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: End upd;
887: --
888: end per_pac_upd;