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_SHD dependencies on PQH_TEMPLATES

Line 253: l_tem_txn_category_id pqh_templates.transaction_category_id%type;

249: ,p_last_update_date in varchar2
250: ) is
251: l_object_version_number number(15);
252: l_template_id pqh_template_attributes.template_id%type;
253: l_tem_txn_category_id pqh_templates.transaction_category_id%type;
254: l_att_txn_category_id pqh_transaction_categories.transaction_category_id%type;
255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --

Line 258: l_created_by pqh_templates.created_by%TYPE;

254: l_att_txn_category_id pqh_transaction_categories.transaction_category_id%type;
255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;
261: l_last_update_date pqh_templates.last_update_date%TYPE;
262: l_last_update_login pqh_templates.last_update_login%TYPE;

Line 259: l_last_updated_by pqh_templates.last_updated_by%TYPE;

255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;
261: l_last_update_date pqh_templates.last_update_date%TYPE;
262: l_last_update_login pqh_templates.last_update_login%TYPE;
263: --

Line 260: l_creation_date pqh_templates.creation_date%TYPE;

256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;
261: l_last_update_date pqh_templates.last_update_date%TYPE;
262: l_last_update_login pqh_templates.last_update_login%TYPE;
263: --
264: cursor c_attributes is

Line 261: l_last_update_date pqh_templates.last_update_date%TYPE;

257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;
261: l_last_update_date pqh_templates.last_update_date%TYPE;
262: l_last_update_login pqh_templates.last_update_login%TYPE;
263: --
264: cursor c_attributes is
265: select attribute_id

Line 262: l_last_update_login pqh_templates.last_update_login%TYPE;

258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;
261: l_last_update_date pqh_templates.last_update_date%TYPE;
262: l_last_update_login pqh_templates.last_update_login%TYPE;
263: --
264: cursor c_attributes is
265: select attribute_id
266: from pqh_attributes a,pqh_table_route t

Line 274: from pqh_templates_vl

270: and nvl(a.legislation_code,'$$$$$') = nvl(p_legislation_code,'$$$$$');
271:
272: cursor c_templates is
273: select template_id, transaction_category_id
274: from pqh_templates_vl
275: where short_name = p_template_short_name;
276:
277: cursor c_att_txn_category(p_attribute_id number,p_tem_txn_category_id number) is
278: select transaction_category_id