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: --
119: where emp_stat_situation_id = p_rec.emp_stat_situation_id;
120: --
121: --
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
181: --
182: l_proc varchar2(72) := g_package||'pre_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End pre_update;
189: --
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End pre_update;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------------< post_update >------------------------------|
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: begin
232: --
233: pqh_psu_rku.after_update
234: (p_effective_date => p_effective_date
429: ,p_hook_type => 'AU');
430: --
431: end;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
434: End post_update;
435: --
436: -- ----------------------------------------------------------------------------
437: -- |-----------------------------< convert_defs >-----------------------------|
680: --
681: l_proc varchar2(72) := g_package||'upd';
682: --
683: Begin
684: hr_utility.set_location('Entering:'||l_proc, 5);
685: --
686: -- We must lock the row which we need to update.
687: --
688: pqh_psu_shd.lck
781: l_rec pqh_psu_shd.g_rec_type;
782: l_proc varchar2(72) := g_package||'upd';
783: --
784: Begin
785: hr_utility.set_location('Entering:'||l_proc, 5);
786: --
787: -- Call conversion function to turn arguments into the
788: -- l_rec structure.
789: --
847: ,l_rec
848: );
849: p_object_version_number := l_rec.object_version_number;
850: --
851: hr_utility.set_location(' Leaving:'||l_proc, 10);
852: End upd;
853: --
854: end pqh_psu_upd;