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_RCT_BUS dependencies on PQH_ATTRIBUTE_RANGES

Line 190: l_error_range_name pqh_attribute_ranges.range_name%type;

186: p_effective_date in date,
187: p_object_version_number in number) is
188: --
189: l_error_code number(10);
190: l_error_range_name pqh_attribute_ranges.range_name%type;
191: l_overlap_range_name pqh_attribute_ranges.range_name%type;
192: l_error_routing_category varchar2(200);
193: --
194: l_proc varchar2(72) := g_package||'chk_enable_flag';

Line 191: l_overlap_range_name pqh_attribute_ranges.range_name%type;

187: p_object_version_number in number) is
188: --
189: l_error_code number(10);
190: l_error_range_name pqh_attribute_ranges.range_name%type;
191: l_overlap_range_name pqh_attribute_ranges.range_name%type;
192: l_error_routing_category varchar2(200);
193: --
194: l_proc varchar2(72) := g_package||'chk_enable_flag';
195: l_api_updating boolean;

Line 239: l_error_code := pqh_ATTRIBUTE_RANGES_pkg.chk_enable_routing_category

235: then
236: --
237: hr_utility.set_location('Enable allow :'||l_proc,8);
238: --
239: l_error_code := pqh_ATTRIBUTE_RANGES_pkg.chk_enable_routing_category
240: (p_transaction_category_id => p_transaction_category_id,
241: p_routing_category_id => p_routing_category_id,
242: p_overlap_range_name => l_overlap_range_name,
243: p_error_routing_category => l_error_routing_category,

Line 570: from pqh_attribute_ranges

566: where a.transaction_category_id = p_transaction_category_id;
567:
568: Cursor c2 is
569: select null
570: from pqh_attribute_ranges
571: where routing_category_id = p_routing_category_id;
572:
573: Begin
574: --

Line 1244: l_prev_range_name pqh_attribute_ranges.range_name%type;

1240: --
1241: l_routing_type pqh_transaction_categories.member_cd%type;
1242: --
1243: l_prev_routing_cat pqh_routing_categories.routing_category_id%type;
1244: l_prev_range_name pqh_attribute_ranges.range_name%type;
1245: l_prev_list_name varchar2(250);
1246: null_rule_flag varchar2(1);
1247: --
1248: l_routing_category_id pqh_routing_categories.routing_category_id%type;

Line 1250: l_range_name pqh_attribute_ranges.range_name%type;

1246: null_rule_flag varchar2(1);
1247: --
1248: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1249: l_list_name varchar2(250);
1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;

Line 1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;

1247: --
1248: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1249: l_list_name varchar2(250);
1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;

Line 1252: l_from_char pqh_attribute_ranges.from_char%type;

1248: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1249: l_list_name varchar2(250);
1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;

Line 1253: l_to_char pqh_attribute_ranges.to_char%type;

1249: l_list_name varchar2(250);
1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;
1257: l_to_date pqh_attribute_ranges.to_date%type;

Line 1254: l_from_number pqh_attribute_ranges.from_number%type;

1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;
1257: l_to_date pqh_attribute_ranges.to_date%type;
1258: --

Line 1255: l_to_number pqh_attribute_ranges.to_number%type;

1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;
1257: l_to_date pqh_attribute_ranges.to_date%type;
1258: --
1259: --

Line 1256: l_from_date pqh_attribute_ranges.from_date%type;

1252: l_from_char pqh_attribute_ranges.from_char%type;
1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;
1257: l_to_date pqh_attribute_ranges.to_date%type;
1258: --
1259: --
1260: l_proc varchar2(72) := g_package||'chk_universal_routing_exists';

Line 1257: l_to_date pqh_attribute_ranges.to_date%type;

1253: l_to_char pqh_attribute_ranges.to_char%type;
1254: l_from_number pqh_attribute_ranges.from_number%type;
1255: l_to_number pqh_attribute_ranges.to_number%type;
1256: l_from_date pqh_attribute_ranges.from_date%type;
1257: l_to_date pqh_attribute_ranges.to_date%type;
1258: --
1259: --
1260: l_proc varchar2(72) := g_package||'chk_universal_routing_exists';
1261: --

Line 1292: sql_stmt := sql_stmt ||'a.range_name, a.attribute_id, a.from_char, a.to_char, a.from_number, a.to_number, a.from_date, a.to_date from pqh_attribute_ranges a,pqh_routing_categories b, pqh_routing_lists RLT, per_position_structures PPS ';

1288: ||''''||'PQH_SUPERVISORY_HIERARCHY'||''''||','
1289: ||''''||'SUPERVISORY_HIERARCHY'||''''||'),';
1290: End if;
1291:
1292: sql_stmt := sql_stmt ||'a.range_name, a.attribute_id, a.from_char, a.to_char, a.from_number, a.to_number, a.from_date, a.to_date from pqh_attribute_ranges a,pqh_routing_categories b, pqh_routing_lists RLT, per_position_structures PPS ';
1293:
1294: sql_stmt := sql_stmt ||' Where b.transaction_category_id = :p_transaction_category_id and b.enable_flag = :p_enable_flag '
1295: ||' and nvl(b.default_flag,:null_val) <> :p_default_flag and nvl(b.delete_flag,:null_val2) <> :p_delete_flag and b.routing_category_id = a.routing_category_id(+) ';
1296: