eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TAT_BUS dependencies on PQH_TEMPLATES

Line 108: l_freeze_status_cd pqh_templates.freeze_status_cd%type;

104: --
105: l_proc varchar2(72) := g_package||'chk_template_id';
106: l_api_updating boolean;
107: l_dummy varchar2(1);
108: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
109: --
110: cursor c1 is
111: select freeze_status_cd
112: from pqh_templates a

Line 112: from pqh_templates a

108: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
109: --
110: cursor c1 is
111: select freeze_status_cd
112: from pqh_templates a
113: where a.template_id = p_template_id;
114: --
115: Begin
116: --

Line 128: -- check if template_id value exists in pqh_templates table

124: and nvl(p_template_id,hr_api.g_number)
125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if template_id value exists in pqh_templates table
129: --
130: open c1;
131: --
132: -- fetch c1 into l_dummy;

Line 138: -- raise error as FK does not relate to PK in pqh_templates

134: if c1%notfound then
135: --
136: close c1;
137: --
138: -- raise error as FK does not relate to PK in pqh_templates
139: -- table.
140: --
141: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK2');
142: --

Line 304: l_tem_tct pqh_templates.transaction_category_id%type;

300: --
301: l_proc varchar2(72) := g_package||'chk_att_tct';
302: l_api_updating boolean;
303: l_dummy varchar2(1);
304: l_tem_tct pqh_templates.transaction_category_id%type;
305: l_select_flag pqh_txn_category_attributes.select_flag%type;
306: --
307: cursor c1 is
308: select transaction_category_id

Line 309: from pqh_templates a

305: l_select_flag pqh_txn_category_attributes.select_flag%type;
306: --
307: cursor c1 is
308: select transaction_category_id
309: from pqh_templates a
310: where a.template_id = p_template_id;
311: --
312: cursor c2 is
313: select nvl(tca.select_flag,'N')

Line 379: from pqh_templates_vl

375: l_attribute_name varchar2(100);
376: --
377: cursor c_template_leg_code is
378: select legislation_code, template_name
379: from pqh_templates_vl
380: where template_id = p_template_id;
381: --
382: cursor c_attribute_leg_code is
383: select legislation_code, attribute_name