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 339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),
341: p_ref_type=>'INS');
342: --
343: -- Code Ends Here

Line 425: l_created_by pqh_templates.created_by%TYPE;

421: l_object_version_number number(15) := 1;
422: l_parent_template_id pqh_ref_templates.parent_template_id%type;
423: l_base_template_id pqh_ref_templates.base_template_id%type;
424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;
428: l_last_update_date pqh_templates.last_update_date%TYPE;
429: l_last_update_login pqh_templates.last_update_login%TYPE;

Line 426: l_last_updated_by pqh_templates.last_updated_by%TYPE;

422: l_parent_template_id pqh_ref_templates.parent_template_id%type;
423: l_base_template_id pqh_ref_templates.base_template_id%type;
424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;
428: l_last_update_date pqh_templates.last_update_date%TYPE;
429: l_last_update_login pqh_templates.last_update_login%TYPE;
430: --

Line 427: l_creation_date pqh_templates.creation_date%TYPE;

423: l_base_template_id pqh_ref_templates.base_template_id%type;
424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;
428: l_last_update_date pqh_templates.last_update_date%TYPE;
429: l_last_update_login pqh_templates.last_update_login%TYPE;
430: --
431: cursor c_templates(p_template_short_name varchar2) is

Line 428: l_last_update_date pqh_templates.last_update_date%TYPE;

424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;
428: l_last_update_date pqh_templates.last_update_date%TYPE;
429: l_last_update_login pqh_templates.last_update_login%TYPE;
430: --
431: cursor c_templates(p_template_short_name varchar2) is
432: select template_id

Line 429: l_last_update_login pqh_templates.last_update_login%TYPE;

425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;
428: l_last_update_date pqh_templates.last_update_date%TYPE;
429: l_last_update_login pqh_templates.last_update_login%TYPE;
430: --
431: cursor c_templates(p_template_short_name varchar2) is
432: select template_id
433: from pqh_templates_vl

Line 433: from pqh_templates_vl

429: l_last_update_login pqh_templates.last_update_login%TYPE;
430: --
431: cursor c_templates(p_template_short_name varchar2) is
432: select template_id
433: from pqh_templates_vl
434: where short_name = p_template_short_name;
435: --
436: cursor c_ref_templates(p_parent_template_id varchar2,
437: p_base_template_id varchar2) is

Line 500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

496: PER_RIC_PKG.chk_integrity(
497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');

Line 502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');
505:
506: insert into pqh_ref_templates