APPS.PQH_CTL_INS dependencies on PQH_TRANSACTION_CATEGORIES_TL

Line 60: p_entity_name=> 'PQH_TRANSACTION_CATEGORIES_TL',

56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: per_ric_pkg.Chk_integrity(
60: p_entity_name=> 'PQH_TRANSACTION_CATEGORIES_TL',
61: p_ref_entity=>'PQH_TRANSACTION_CATEGORIES',
62: p_ref_column_name=>'TRANSACTION_CATEGORY_ID',
63: p_ref_col_value_number=>p_rec.transaction_category_id,
64: p_ref_col_value_varchar=>NULL,

Line 71: -- Insert the row into: pqh_transaction_categories_tl

67: --
68: -- Code Ends Here
69: --
70: --
71: -- Insert the row into: pqh_transaction_categories_tl
72: --
73: insert into pqh_transaction_categories_tl
74: ( transaction_category_id,
75: name,

Line 73: insert into pqh_transaction_categories_tl

69: --
70: --
71: -- Insert the row into: pqh_transaction_categories_tl
72: --
73: insert into pqh_transaction_categories_tl
74: ( transaction_category_id,
75: name,
76: language,
77: source_lang

Line 215: (p_module_name => 'pqh_transaction_categories_tl'

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

Line 310: from pqh_transaction_categories_tl ctl

306: select l.language_code
307: from fnd_languages l
308: where l.installed_flag in ('I','B')
309: and not exists (select null
310: from pqh_transaction_categories_tl ctl
311: where ctl.transaction_category_id = p_transaction_category_id
312: and ctl.language = l.language_code );
313: --
314: l_proc varchar2(72) := g_package||'ins_tl';