61: --
62: --
63: --
64: --
65: -- Insert the row into: pay_element_types_f_tl
66: --
67: insert into pay_element_types_f_tl
68: (element_type_id
69: ,element_name
63: --
64: --
65: -- Insert the row into: pay_element_types_f_tl
66: --
67: insert into pay_element_types_f_tl
68: (element_type_id
69: ,element_name
70: ,reporting_name
71: ,description
218: --
219: when hr_api.cannot_find_prog_unit then
220: --
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'PAY_ELEMENT_TYPES_F_TL'
223: ,p_hook_type => 'AI');
224: --
225: end;
226: --
337: select l.language_code
338: from fnd_languages l
339: where l.installed_flag in ('I','B')
340: and not exists (select null
341: from pay_element_types_f_tl ett
342: where ett.element_type_id = p_element_type_id
343: and ett.language = l.language_code);
344: --
345: l_proc varchar2(72) := g_package || 'ins_tl';