57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: --
64: --
65: --
84: and taxability_rules_date_id = p_rec.taxability_rules_date_id;
85: --
86: --
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
155: -- ----------------------------------------------------------------------------
156: -- |-----------------------------< post_update >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: begin
197: --
198: pay_txr_rku.after_update
199: (p_effective_date => p_effective_date
228: ,p_hook_type => 'AU');
229: --
230: end;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: End post_update;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |-----------------------------< convert_defs >-----------------------------|
307: --
308: l_proc varchar2(72) := g_package||'upd';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- We must lock the row which we need to update.
314: --
315: pay_txr_shd.lck
373: l_rec pay_txr_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call conversion function to turn arguments into the
380: -- l_rec structure.
381: --
400: ,l_rec
401: );
402: --
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: End upd;
406: --
407: end pay_txr_upd;