APPS.PQH_TTL_INS dependencies on PQH_TEMPLATES_TL

Line 58: p_entity_name=>'PQH_TEMPLATES_TL',

54: -- Added the following code as a part of Zero Downtime Patching Project.
55: -- Code Starts Here.
56: --
57: per_ric_pkg.Chk_integrity(
58: p_entity_name=>'PQH_TEMPLATES_TL',
59: p_ref_entity=>'PQH_TEMPLATES',
60: p_ref_column_name=>'TEMPLATE_ID',
61: p_ref_col_value_number=>p_rec.template_id,
62: p_ref_col_value_varchar=>NULL,

Line 69: -- Insert the row into: pqh_templates_tl

65: --
66: -- Code Ends Here
67: --
68: --
69: -- Insert the row into: pqh_templates_tl
70: --
71: insert into pqh_templates_tl
72: ( template_id,
73: template_name,

Line 71: insert into pqh_templates_tl

67: --
68: --
69: -- Insert the row into: pqh_templates_tl
70: --
71: insert into pqh_templates_tl
72: ( template_id,
73: template_name,
74: language,
75: source_lang

Line 214: (p_module_name => 'pqh_templates_tl'

210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'pqh_templates_tl'
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --

Line 318: from pqh_templates_tl ttl

314: select l.language_code
315: from fnd_languages l
316: where l.installed_flag in ('I','B')
317: and not exists (select null
318: from pqh_templates_tl ttl
319: where ttl.template_id = p_template_id
320: and ttl.language = l.language_code );
321: --
322: l_proc varchar2(72) := g_package||'ins_tl';