APPS.PQH_ATTRIBUTE_RANGES_PKG dependencies on PQH_TRANSACTION_CATEGORIES

Line 1251: l_routing_type pqh_transaction_categories.member_cd%type;

1247: l_prev_range_name pqh_attribute_ranges.range_name%type;
1248: cnt number(10);
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;

Line 1277: From pqh_transaction_categories

1273: --
1274: --
1275: Cursor csr_routing_type is
1276: Select member_Cd
1277: From pqh_transaction_categories
1278: Where transaction_category_id = p_transaction_category_id;
1279: --
1280: Cursor csr_list_ident_cnt is
1281: Select count(*)

Line 1460: l_routing_type pqh_transaction_categories.member_cd%type;

1456: --
1457: Procedure chk_rout_overlap_on_freeze(p_transaction_category_id in number
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;

Line 1477: From pqh_transaction_categories

1473: l_error_range_name pqh_attribute_ranges.range_name%type;
1474: --
1475: Cursor csr_routing_type is
1476: Select member_Cd
1477: From pqh_transaction_categories
1478: Where transaction_category_id = p_transaction_category_id;
1479: --
1480: l_proc varchar2(72) := g_package||'chk_overlap_on_freeze_cat';
1481: --

Line 1632: l_routing_type pqh_transaction_categories.member_cd%type;

1628: --
1629: cnt number(10);
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);

Line 1658: From pqh_transaction_categories

1654: all_attributes_tab rule_attr_tab;
1655: --
1656: Cursor csr_routing_type is
1657: Select member_Cd
1658: From pqh_transaction_categories
1659: Where transaction_category_id = p_transaction_category_id;
1660: --
1661: Cursor csr_mem_ident_cnt is
1662: Select count(*)