62: --
63: --
64: --
65: --
66: -- Update the pqh_table_route_tl Row
67: --
68: update pqh_table_route_tl
69: set
70: table_route_id = p_rec.table_route_id
64: --
65: --
66: -- Update the pqh_table_route_tl Row
67: --
68: update pqh_table_route_tl
69: set
70: table_route_id = p_rec.table_route_id
71: ,display_name = p_rec.display_name
72: ,language = p_rec.language
204: --
205: when hr_api.cannot_find_prog_unit then
206: --
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'PQH_TABLE_ROUTE_TL'
209: ,p_hook_type => 'AU');
210: --
211: end;
212: --
375: -- source_lang match the specified language.
376: --
377: cursor csr_upd_langs is
378: select trl.language
379: from pqh_table_route_tl trl
380: where trl.table_route_id = p_table_route_id
381: and p_language_code in (trl.language
382: ,trl.source_lang);
383: --