APPS.PQH_TTL_UPD dependencies on PQH_TEMPLATES_TL

Line 57: -- Update the pqh_templates_tl Row

53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: --
57: -- Update the pqh_templates_tl Row
58: --
59: update pqh_templates_tl
60: set
61: template_id = p_rec.template_id,

Line 59: update pqh_templates_tl

55: --
56: --
57: -- Update the pqh_templates_tl Row
58: --
59: update pqh_templates_tl
60: set
61: template_id = p_rec.template_id,
62: template_name = p_rec.template_name,
63: language = p_rec.language,

Line 190: (p_module_name => 'pqh_templates_tl'

186: --
187: when hr_api.cannot_find_prog_unit then
188: --
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'pqh_templates_tl'
191: ,p_hook_type => 'AU');
192: --
193: end;
194: --

Line 367: from pqh_templates_tl ttl

363: )is
364:
365: Cursor csr_upd_langs is
366: select ttl.language
367: from pqh_templates_tl ttl
368: where ttl.template_id = p_template_id
369: AND p_language_code in (ttl.language,ttl.source_lang);
370: --
371: l_proc varchar2(72) := g_package||'upd_tl';

Line 445: UPDATE pqh_templates_tl

441: l_last_update_login := 0;
442: --
443: -- update the tl table
444: --
445: UPDATE pqh_templates_tl
446: SET template_name = p_template_name,
447: last_updated_by = l_last_updated_by,
448: last_update_date = l_last_update_date,
449: last_update_login = l_last_update_login,