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_ATTRIBUTE_RANGES

Line 1: package body pqh_ATTRIBUTE_RANGES_pkg as

1: package body pqh_ATTRIBUTE_RANGES_pkg as
2: /* $Header: pqrngchk.pkb 115.16 2002/12/12 22:47:59 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 186: sql_stmt := 'select attribute_range_id,attribute_id,from_char,to_char,from_date,to_date,from_number,to_number,object_version_number from pqh_attribute_ranges where routing_category_id = :p and range_name = :r and ';

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: sql_stmt := 'select attribute_range_id,attribute_id,from_char,to_char,from_date,to_date,from_number,to_number,object_version_number from pqh_attribute_ranges where routing_category_id = :p and range_name = :r and ';
187:
188: if p_primary_flag = 'Y' then
189: sql_stmt := sql_stmt || ' attribute_id IS NOT NULL and routing_list_member_id IS NULL and position_id IS NULL and assignment_id IS NULL order by attribute_id';
190:

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 819: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%type;

815: p_delete_attr_ranges_flag IN varchar2,
816: p_primary_flag IN varchar2) is
817: --
818: l_dummy varchar2(1);
819: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%type;
820: l_object_version_number pqh_attribute_ranges.object_version_number%type;
821: --
822: Cursor c1 is
823: Select attribute_range_id , object_version_number

Line 820: l_object_version_number pqh_attribute_ranges.object_version_number%type;

816: p_primary_flag IN varchar2) is
817: --
818: l_dummy varchar2(1);
819: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%type;
820: l_object_version_number pqh_attribute_ranges.object_version_number%type;
821: --
822: Cursor c1 is
823: Select attribute_range_id , object_version_number
824: from pqh_attribute_ranges

Line 824: from pqh_attribute_ranges

820: l_object_version_number pqh_attribute_ranges.object_version_number%type;
821: --
822: Cursor c1 is
823: Select attribute_range_id , object_version_number
824: from pqh_attribute_ranges
825: where attribute_id IS NOT NULL
826: AND attribute_id = p_attribute_id
827: AND routing_list_member_id is null
828: AND position_id is null

Line 833: from pqh_attribute_ranges

829: AND assignment_id is null;
830: --
831: Cursor c2 is
832: Select attribute_range_id , object_version_number
833: from pqh_attribute_ranges
834: where attribute_id IS NOT NULL
835: AND attribute_id = p_attribute_id
836: AND (routing_list_member_id is not null
837: OR position_id is not null

Line 858: -- Delete ranges from pqh_attribute_ranges for the unchecked

854: if c1%notfound then
855: exit;
856: Else
857: --
858: -- Delete ranges from pqh_attribute_ranges for the unchecked
859: -- list identifier
860: --
861: If p_delete_attr_ranges_flag = 'Y' then
862: --

Line 863: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE

859: -- list identifier
860: --
861: If p_delete_attr_ranges_flag = 'Y' then
862: --
863: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE
864: (p_validate => false
865: ,p_attribute_range_id => l_attribute_range_id
866: ,p_object_version_number => l_object_version_number
867: ,p_effective_date => sysdate);

Line 899: -- Delete ranges from pqh_attribute_ranges for the unchecked

895: if c2%notfound then
896: exit;
897: Else
898: --
899: -- Delete ranges from pqh_attribute_ranges for the unchecked
900: -- member identifier ,
901: --
902: If p_delete_attr_ranges_flag = 'Y' then
903: --

Line 904: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE

900: -- member identifier ,
901: --
902: If p_delete_attr_ranges_flag = 'Y' then
903: --
904: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE
905: (p_validate => false
906: ,p_attribute_range_id => l_attribute_range_id
907: ,p_object_version_number => l_object_version_number
908: ,p_effective_date => sysdate);

Line 937: ----------Wrapper for DML's for PQH_ATTRIBUTE_RANGES--------------------------

933: hr_utility.set_location('Leaving:'||l_proc, 10);
934: --
935: End;
936: --
937: ----------Wrapper for DML's for PQH_ATTRIBUTE_RANGES--------------------------
938: --
939: -- The following procedures are coded because a Range name created in the
940: -- form has to be inserted into the database as 1 record per attribute id
941: -- The form displays ranges for all the list / member identifiers in a

Line 1003: pqh_ATTRIBUTE_RANGES_api.create_ATTRIBUTE_RANGE

999:
1000: --
1001: for ctr in 1..p_no_attributes loop
1002: --
1003: pqh_ATTRIBUTE_RANGES_api.create_ATTRIBUTE_RANGE
1004: (p_validate => false
1005: ,p_attribute_range_id => ins_attr_ranges_table(ctr).attribute_range_id
1006: ,p_approver_flag => p_approver_flag
1007: ,p_enable_flag => p_enable_flag

Line 1088: pqh_ATTRIBUTE_RANGES_api.update_ATTRIBUTE_RANGE

1084: for ctr in 1..p_no_attributes loop
1085: --
1086: if p_attr_ranges_table(ctr).attribute_range_id IS NOT NULL then
1087: --
1088: pqh_ATTRIBUTE_RANGES_api.update_ATTRIBUTE_RANGE
1089: (p_validate => false
1090: ,p_attribute_range_id => p_attr_ranges_table(ctr).attribute_range_id
1091: ,p_approver_flag => p_approver_flag
1092: ,p_enable_flag => p_enable_flag

Line 1115: pqh_ATTRIBUTE_RANGES_api.create_ATTRIBUTE_RANGE

1111: --
1112: else
1113: --
1114: --
1115: pqh_ATTRIBUTE_RANGES_api.create_ATTRIBUTE_RANGE
1116: (p_validate => false
1117: ,p_attribute_range_id => p_attr_ranges_table(ctr).attribute_range_id
1118: ,p_approver_flag => p_approver_flag
1119: ,p_enable_flag => p_enable_flag

Line 1169: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE

1165: for ctr in 1..p_no_attributes loop
1166:
1167: if del_attr_ranges_table(ctr).attribute_range_id IS NOT NULL then
1168: --
1169: pqh_ATTRIBUTE_RANGES_api.delete_ATTRIBUTE_RANGE
1170: (p_validate => p_validate
1171: ,p_attribute_range_id => del_attr_ranges_table(ctr).attribute_range_id
1172: ,p_object_version_number => del_attr_ranges_table(ctr).ovn
1173: ,p_effective_date => sysdate);

Line 1205: exist_range_name pqh_attribute_ranges.range_name%type;

1201: --
1202: type cur_type IS REF CURSOR;
1203: range_name_cur cur_type;
1204: sql_stmt varchar2(1000);
1205: exist_range_name pqh_attribute_ranges.range_name%type;
1206:
1207: Begin
1208: --
1209: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1211: sql_stmt := 'Select distinct range_name from pqh_attribute_ranges where routing_category_id = :r AND attribute_id IS NOT NULL AND attribute_range_id not in '||p_attribute_id_list;

1207: Begin
1208: --
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211: sql_stmt := 'Select distinct range_name from pqh_attribute_ranges where routing_category_id = :r AND attribute_id IS NOT NULL AND attribute_range_id not in '||p_attribute_id_list;
1212:
1213: if p_primary_flag = 'Y' then
1214: sql_stmt := sql_stmt ||' AND routing_list_member_id is NULL AND position_id is NULL AND assignment_id is NULL';
1215: else

Line 1247: l_prev_range_name pqh_attribute_ranges.range_name%type;

1243: p_error_routing_category out nocopy varchar2,
1244: p_error_range_name out nocopy varchar2
1245: ) RETURN NUMBER is
1246: --
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;

Line 1254: l_range_name pqh_attribute_ranges.range_name%type;

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;
1258: l_from_char pqh_attribute_ranges.from_char%type;

Line 1255: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;

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;
1258: l_from_char pqh_attribute_ranges.from_char%type;
1259: l_to_char pqh_attribute_ranges.to_char%type;

Line 1256: l_attribute_id pqh_attribute_ranges.attribute_id%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;
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;

Line 1258: l_from_char pqh_attribute_ranges.from_char%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;

Line 1259: l_to_char pqh_attribute_ranges.to_char%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;
1263: l_to_number pqh_attribute_ranges.to_number%type;

Line 1260: l_from_date pqh_attribute_ranges.from_date%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;
1263: l_to_number pqh_attribute_ranges.to_number%type;
1264: --

Line 1261: l_to_date pqh_attribute_ranges.to_date%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;
1263: l_to_number pqh_attribute_ranges.to_number%type;
1264: --
1265: l_error_code number(10) := NULL;

Line 1262: l_from_number pqh_attribute_ranges.from_number%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;
1263: l_to_number pqh_attribute_ranges.to_number%type;
1264: --
1265: l_error_code number(10) := NULL;
1266: --

Line 1263: l_to_number pqh_attribute_ranges.to_number%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;
1262: l_from_number pqh_attribute_ranges.from_number%type;
1263: l_to_number pqh_attribute_ranges.to_number%type;
1264: --
1265: l_error_code number(10) := NULL;
1266: --
1267: type cur_type IS REF CURSOR;

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 1471: l_overlap_range_name pqh_attribute_ranges.range_name%type;

1467: --
1468: l_error_code number(10);
1469: --
1470: l_overlap_routing_category varchar2(200);
1471: l_overlap_range_name pqh_attribute_ranges.range_name%type;
1472: l_error_routing_category varchar2(200);
1473: l_error_range_name pqh_attribute_ranges.range_name%type;
1474: --
1475: Cursor csr_routing_type is

Line 1473: l_error_range_name pqh_attribute_ranges.range_name%type;

1469: --
1470: l_overlap_routing_category varchar2(200);
1471: l_overlap_range_name pqh_attribute_ranges.range_name%type;
1472: l_error_routing_category varchar2(200);
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

Line 1620: l_overlap_range_name pqh_attribute_ranges.range_name%type;

1616: --
1617: PROCEDURE chk_mem_overlap_on_freeze( p_transaction_category_id in number
1618: )is
1619: --
1620: l_overlap_range_name pqh_attribute_ranges.range_name%type;
1621: l_error_range_name pqh_attribute_ranges.range_name%type;
1622: l_error_routing_category varchar2(200);
1623: l_member_name varchar2(300);
1624: --

Line 1621: l_error_range_name pqh_attribute_ranges.range_name%type;

1617: PROCEDURE chk_mem_overlap_on_freeze( p_transaction_category_id in number
1618: )is
1619: --
1620: l_overlap_range_name pqh_attribute_ranges.range_name%type;
1621: l_error_range_name pqh_attribute_ranges.range_name%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;

Line 1625: l_prev_range_name pqh_attribute_ranges.range_name%type;

1621: l_error_range_name pqh_attribute_ranges.range_name%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);

Line 1635: l_range_name pqh_attribute_ranges.range_name%type;

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;
1639: l_column_type pqh_attributes.column_type%type;

Line 1637: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %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;
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;

Line 1638: l_attribute_id pqh_attribute_ranges.attribute_id%type;

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

Line 1640: l_from_char pqh_attribute_ranges.from_char%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;
1644: l_from_number pqh_attribute_ranges.from_number%type;

Line 1641: l_to_char pqh_attribute_ranges.to_char%type;

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;
1644: l_from_number pqh_attribute_ranges.from_number%type;
1645: l_to_number pqh_attribute_ranges.to_number%type;

Line 1642: l_from_date pqh_attribute_ranges.from_date%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;
1644: l_from_number pqh_attribute_ranges.from_number%type;
1645: l_to_number pqh_attribute_ranges.to_number%type;
1646: --

Line 1643: l_to_date pqh_attribute_ranges.to_date%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;
1644: l_from_number pqh_attribute_ranges.from_number%type;
1645: l_to_number pqh_attribute_ranges.to_number%type;
1646: --
1647: l_error_code number(10) := NULL;

Line 1644: l_from_number pqh_attribute_ranges.from_number%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;
1644: l_from_number pqh_attribute_ranges.from_number%type;
1645: l_to_number pqh_attribute_ranges.to_number%type;
1646: --
1647: l_error_code number(10) := NULL;
1648: --

Line 1645: l_to_number pqh_attribute_ranges.to_number%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;
1644: l_from_number pqh_attribute_ranges.from_number%type;
1645: l_to_number pqh_attribute_ranges.to_number%type;
1646: --
1647: l_error_code number(10) := NULL;
1648: --
1649: type cur_type IS REF CURSOR;

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

Line 1910: End pqh_ATTRIBUTE_RANGES_pkg;

1906: End;
1907: --
1908: --
1909:
1910: End pqh_ATTRIBUTE_RANGES_pkg;