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: --
76: and language = p_rec.language;
77: --
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
147: -- ----------------------------------------------------------------------------
148: -- |-----------------------------< post_update >------------------------------|
182: --
183: l_proc varchar2(72) := g_package||'post_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: begin
188: --
189: pay_btt_rku.after_update
190: (p_balance_type_id
214: ,p_hook_type => 'AU');
215: --
216: end;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: End post_update;
220: --
221: -- ----------------------------------------------------------------------------
222: -- |-----------------------------< convert_defs >-----------------------------|
296: --
297: l_proc varchar2(72) := g_package||'upd';
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: -- We must lock the row which we need to update.
303: --
304: pay_btt_shd.lck
352: l_rec pay_btt_shd.g_rec_type;
353: l_proc varchar2(72) := g_package||'upd';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: -- Call conversion function to turn arguments into the
359: -- l_rec structure.
360: --
375: (l_rec
376: );
377: --
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End upd;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |------------------------------< upd_tl >----------------------------------|
401: --
402: l_proc varchar2(72) := g_package||'upd_tl';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc,10);
406: --
407: -- Update the translated values for every matching row
408: -- setting SOURCE_LANG to the specified language.
409: --
416: ,p_reporting_name => p_reporting_name
417: );
418: end loop;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc,20);
421: End upd_tl;
422: --
423: end pay_btt_upd;