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

Line 250: from pqh_attributes att, pqh_txn_category_attributes tct, pqh_templates tem

246: FOR UPDATE ;
247: --
248: cursor c_select_flag(p_attribute_id number, p_template_id number) is
249: select 'x'
250: from pqh_attributes att, pqh_txn_category_attributes tct, pqh_templates tem
251: where
252: att.attribute_id = p_attribute_id
253: and att.attribute_id = tct.attribute_id
254: and tem.template_id = p_template_id

Line 408: l_created_by pqh_templates.created_by%TYPE;

404: l_object_version_number number(15) := 1;
405: l_parent_template_id pqh_ref_templates.parent_template_id%type;
406: l_base_template_id pqh_ref_templates.base_template_id%type;
407: --
408: l_created_by pqh_templates.created_by%TYPE;
409: l_last_updated_by pqh_templates.last_updated_by%TYPE;
410: l_creation_date pqh_templates.creation_date%TYPE;
411: l_last_update_date pqh_templates.last_update_date%TYPE;
412: l_last_update_login pqh_templates.last_update_login%TYPE;

Line 409: l_last_updated_by pqh_templates.last_updated_by%TYPE;

405: l_parent_template_id pqh_ref_templates.parent_template_id%type;
406: l_base_template_id pqh_ref_templates.base_template_id%type;
407: --
408: l_created_by pqh_templates.created_by%TYPE;
409: l_last_updated_by pqh_templates.last_updated_by%TYPE;
410: l_creation_date pqh_templates.creation_date%TYPE;
411: l_last_update_date pqh_templates.last_update_date%TYPE;
412: l_last_update_login pqh_templates.last_update_login%TYPE;
413: --

Line 410: l_creation_date pqh_templates.creation_date%TYPE;

406: l_base_template_id pqh_ref_templates.base_template_id%type;
407: --
408: l_created_by pqh_templates.created_by%TYPE;
409: l_last_updated_by pqh_templates.last_updated_by%TYPE;
410: l_creation_date pqh_templates.creation_date%TYPE;
411: l_last_update_date pqh_templates.last_update_date%TYPE;
412: l_last_update_login pqh_templates.last_update_login%TYPE;
413: --
414: cursor c_templates(p_template_short_name varchar2) is

Line 411: l_last_update_date pqh_templates.last_update_date%TYPE;

407: --
408: l_created_by pqh_templates.created_by%TYPE;
409: l_last_updated_by pqh_templates.last_updated_by%TYPE;
410: l_creation_date pqh_templates.creation_date%TYPE;
411: l_last_update_date pqh_templates.last_update_date%TYPE;
412: l_last_update_login pqh_templates.last_update_login%TYPE;
413: --
414: cursor c_templates(p_template_short_name varchar2) is
415: select template_id

Line 412: l_last_update_login pqh_templates.last_update_login%TYPE;

408: l_created_by pqh_templates.created_by%TYPE;
409: l_last_updated_by pqh_templates.last_updated_by%TYPE;
410: l_creation_date pqh_templates.creation_date%TYPE;
411: l_last_update_date pqh_templates.last_update_date%TYPE;
412: l_last_update_login pqh_templates.last_update_login%TYPE;
413: --
414: cursor c_templates(p_template_short_name varchar2) is
415: select template_id
416: from pqh_templates_vl

Line 416: from pqh_templates_vl

412: l_last_update_login pqh_templates.last_update_login%TYPE;
413: --
414: cursor c_templates(p_template_short_name varchar2) is
415: select template_id
416: from pqh_templates_vl
417: where short_name = p_template_short_name;
418: --
419: cursor c_ref_templates(p_parent_template_id varchar2,
420: p_base_template_id varchar2) is