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_ROUTING_CATEGORIES

Line 425: ||' from pqh_attribute_ranges a,pqh_routing_categories b '

421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: sql_stmt := 'Select a.routing_category_id,a.range_name,a.attribute_id,a.from_char,a.to_char,a.from_number,a.to_number,a.from_date,a.to_date '
425: ||' from pqh_attribute_ranges a,pqh_routing_categories b '
426: ||' where a.routing_category_id = :p_routing_category_id AND a.routing_category_id = b.routing_category_id AND b.transaction_category_id = :p_transaction_category_id and a.attribute_id IS NOT NULL'
427: ||' AND a.enable_flag ='
428: ||''''
429: ||'Y'

Line 510: ||' from pqh_attribute_ranges rng,pqh_routing_categories rct ';

506: -- The foll cursor selects all other routing rules under the transcation
507: -- category against which the current rule will be checked for overlap.
508: --
509: sql_stmt := 'Select rng.routing_category_id,rng.range_name,rng.attribute_id,rng.from_char,rng.to_char,rng.from_number,rng.to_number,rng.from_date,rng.to_date '
510: ||' from pqh_attribute_ranges rng,pqh_routing_categories rct ';
511:
512: If p_routing_type = 'R' then
513: sql_stmt := sql_stmt || ' Where rct.routing_list_id is not null ';
514: Elsif p_routing_type = 'P' then

Line 1253: l_routing_category_id pqh_routing_categories.routing_category_id%type;

1249: l_attribute_range_id_list varchar2(2000);
1250: l_no_list_identifiers number(10);
1251: l_routing_type pqh_transaction_categories.member_cd%type;
1252: --
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;

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 1462: l_routing_category_id pqh_routing_categories.routing_category_id%type;

1458: ) is
1459: --
1460: l_routing_type pqh_transaction_categories.member_cd%type;
1461: --
1462: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1463: --
1464: type cur_type IS REF CURSOR;
1465: csr_chk_rule_overlap cur_type;
1466: sql_stmt varchar2(2000);

Line 1496: sql_stmt := 'Select rct.routing_category_id From pqh_routing_categories rct ';

1492: --
1493: -- Select all routing categories under the transaction category that
1494: -- belong to the current routing type
1495: --
1496: sql_stmt := 'Select rct.routing_category_id From pqh_routing_categories rct ';
1497: --
1498: sql_stmt := sql_stmt ||' Where rct.transaction_category_id = :p_transaction_category_id and rct.enable_flag = :p_enable_flag and nvl(rct.default_flag,:null_value1) <> :default_flag and nvl(rct.delete_flag,:null_value2) <> :delete_flag';
1499: --
1500: If l_routing_type = 'R' then

Line 1626: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;

1622: l_error_routing_category varchar2(200);
1623: l_member_name varchar2(300);
1624: --
1625: l_prev_range_name pqh_attribute_ranges.range_name%type;
1626: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;
1627: l_prev_member_id number(30);
1628: --
1629: cnt number(10);
1630: l_attribute_range_id_list varchar2(2000);

Line 1634: l_routing_category_id pqh_routing_categories.routing_category_id%type;

1630: l_attribute_range_id_list varchar2(2000);
1631: l_no_mem_identifiers number(10);
1632: l_routing_type pqh_transaction_categories.member_cd%type;
1633: --
1634: l_routing_category_id pqh_routing_categories.routing_category_id%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;

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: --