61: --
62: --
63: --
64: --
65: -- Insert the row into: pqh_table_route_tl
66: --
67: insert into pqh_table_route_tl
68: (table_route_id
69: ,display_name
63: --
64: --
65: -- Insert the row into: pqh_table_route_tl
66: --
67: insert into pqh_table_route_tl
68: (table_route_id
69: ,display_name
70: ,language
71: ,source_lang
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'PQH_TABLE_ROUTE_TL'
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --
316: select l.language_code
317: from fnd_languages l
318: where l.installed_flag in ('I','B')
319: and not exists (select null
320: from pqh_table_route_tl trl
321: where trl.table_route_id = p_table_route_id
322: and trl.language = l.language_code);
323: --
324: l_proc varchar2(72) := g_package || 'ins_tl';