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_ATTRIBUTE_RANGES_PKG dependencies on PQH_ATTRIBUTES

Line 78: from pqh_txn_category_attributes tca,pqh_attributes_vl att

74: --
75: Cursor c1 is
76: select att.attribute_name,tca.attribute_id,
77: att.column_type,tca.value_style_cd,tca.value_set_id
78: from pqh_txn_category_attributes tca,pqh_attributes_vl att
79: where tca.transaction_category_id = p_transaction_category_id
80: and tca.attribute_id = att.attribute_id
81: and tca.list_identifying_flag='Y'
82: order by tca.attribute_id;

Line 87: from pqh_txn_category_attributes tca,pqh_attributes_vl att

83: --
84: Cursor c2 is
85: select att.attribute_name,tca.attribute_id,
86: att.column_type,tca.value_style_cd,tca.value_set_id
87: from pqh_txn_category_attributes tca,pqh_attributes_vl att
88: where tca.transaction_category_id = p_transaction_category_id
89: and tca.attribute_id = att.attribute_id
90: and tca.member_identifying_flag='Y'
91: order by tca.attribute_id;

Line 810: -- This procedure is called from row handler for pqh_attributes.

806: -- | Delete_attribute_ranges
807: -- ----------------------------------------------------------------------------
808: --Description : Function to Delete attribute ranges for invalid list/member
809: -- flags .
810: -- This procedure is called from row handler for pqh_attributes.
811: -- When a list or member identifier is unmarked this procedure is
812: -- called .
813: --
814: Procedure Delete_attribute_ranges(p_attribute_id IN number,

Line 1257: l_column_type pqh_attributes.column_type%type;

1253: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1254: l_range_name pqh_attribute_ranges.range_name%type;
1255: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;
1256: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1257: l_column_type pqh_attributes.column_type%type;
1258: l_from_char pqh_attribute_ranges.from_char%type;
1259: l_to_char pqh_attribute_ranges.to_char%type;
1260: l_from_date pqh_attribute_ranges.from_date%type;
1261: l_to_date pqh_attribute_ranges.to_date%type;

Line 1304: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';

1300: Close csr_routing_type;
1301: --
1302: sql_stmt := 'Select rct.routing_category_id, rng.range_name , rng.attribute_range_id, rng.attribute_id, att.column_type, rng.from_char, rng.to_char, rng.from_number, rng.to_number, rng.from_date, rng.to_date ';
1303: --
1304: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';
1305: --
1306: sql_stmt := sql_stmt ||' Where rct.routing_category_id = :p_routing_category_id and rng.routing_category_id = rct.routing_category_id and rng.attribute_id IS NOT NULL and rng.attribute_id = att.attribute_id';
1307: --
1308: If l_routing_type = 'R' then

Line 1639: l_column_type pqh_attributes.column_type%type;

1635: l_range_name pqh_attribute_ranges.range_name%type;
1636: l_member_id number(30);
1637: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;
1638: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1639: l_column_type pqh_attributes.column_type%type;
1640: l_from_char pqh_attribute_ranges.from_char%type;
1641: l_to_char pqh_attribute_ranges.to_char%type;
1642: l_from_date pqh_attribute_ranges.from_date%type;
1643: l_to_date pqh_attribute_ranges.to_date%type;

Line 1701: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';

1697: End if;
1698: --
1699: sql_stmt := sql_stmt ||' rng.attribute_range_id, rng.attribute_id, att.column_type, rng.from_char, rng.to_char, rng.from_number, rng.to_number, rng.from_date, rng.to_date ';
1700: --
1701: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';
1702: --
1703: sql_stmt := sql_stmt ||' Where rct.transaction_category_id = :p_transaction_category_id and nvl(rct.default_flag,:null_value) <> :default_flag '
1704: ||' and nvl(rct.delete_flag,:null2) <> :delete_flag and rng.routing_category_id = rct.routing_category_id and rng.attribute_id = att.attribute_id';
1705: --