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: --
146: where range_table_id = p_rec.range_table_id;
147: --
148: --
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< post_update >------------------------------|
252: --
253: l_proc varchar2(72) := g_package||'post_update';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: begin
258: --
259: pay_prf_rku.after_update
260: (p_range_table_id
562: ,p_hook_type => 'AU');
563: --
564: end;
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 10);
567: End post_update;
568: --
569: -- ----------------------------------------------------------------------------
570: -- |-----------------------------< convert_defs >-----------------------------|
920: --
921: l_proc varchar2(72) := g_package||'upd';
922: --
923: Begin
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: -- We must lock the row which we need to update.
927: --
928: pay_prf_shd.lck
1049: l_rec pay_prf_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';
1051: --
1052: Begin
1053: hr_utility.set_location('Entering:'||l_proc, 5);
1054: --
1055: -- Call conversion function to turn arguments into the
1056: -- l_rec structure.
1057: --
1141: (l_rec
1142: );
1143: p_object_version_number := l_rec.object_version_number;
1144: --
1145: hr_utility.set_location(' Leaving:'||l_proc, 10);
1146: End upd;
1147: --
1148: end pay_prf_upd;