62: --
63: --
64: --
65: --
66: -- Update the pay_balance_dimensions_tl Row
67: --
68: update pay_balance_dimensions_tl
69: set
70: balance_dimension_id = p_rec.balance_dimension_id
64: --
65: --
66: -- Update the pay_balance_dimensions_tl Row
67: --
68: update pay_balance_dimensions_tl
69: set
70: balance_dimension_id = p_rec.balance_dimension_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'PAY_BALANCE_DIMENSIONS_TL'
219: ,p_hook_type => 'AU');
220: --
221: end;
222: --
405: --
406: cursor csr_upd_langs is
407: select bdt.language
408: , bdt.database_item_suffix
409: from pay_balance_dimensions_tl bdt
410: where bdt.balance_dimension_id = p_balance_dimension_id
411: and p_language_code in (bdt.language
412: ,bdt.source_lang);
413: --