APPS.PQH_TCT_WIZARD_PKG dependencies on PQH_ATTRIBUTE_RANGES_PKG

Line 3170: l_error_code := pqh_attribute_ranges_pkg.chk_enable_routing_category

3166: Close csr_chk_rule_overlap;
3167: exit;
3168: End if;
3169: --
3170: l_error_code := pqh_attribute_ranges_pkg.chk_enable_routing_category
3171: (p_routing_category_id => l_routing_category_id,
3172: p_transaction_category_id => p_transaction_category_id,
3173: p_overlap_range_name => l_overlap_range_name,
3174: p_error_routing_category => l_error_routing_category,

Line 3237: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;

3233: type cur_type IS REF CURSOR;
3234: csr_mem_overlap cur_type;
3235: sql_stmt varchar2(2000);
3236: --
3237: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;
3238: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;
3239: --
3240: Cursor csr_mem_ident_cnt is
3241: Select count(*)

Line 3238: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;

3234: csr_mem_overlap cur_type;
3235: sql_stmt varchar2(2000);
3236: --
3237: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;
3238: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;
3239: --
3240: Cursor csr_mem_ident_cnt is
3241: Select count(*)
3242: from pqh_txn_category_attributes

Line 3364: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap

3360: -- overlaps with any other routing rules under that
3361: -- transaction category.
3362: --
3363: hr_utility.set_location('Calling chk_member_range_overlap:'||l_proc, 6);
3364: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap
3365: (tab1 => all_routing_rules ,
3366: tab2 => all_attributes_tab,
3367: p_transaction_category_id => p_transaction_category_id,
3368: p_routing_category_id => l_prev_routing_category_id,

Line 3387: pqh_attribute_ranges_pkg.get_member_name

3383: pqh_tct_bus.get_routing_category_name(
3384: p_routing_category_id => l_prev_routing_category_id,
3385: p_routing_category_name => l_error_routing_category);
3386: --
3387: pqh_attribute_ranges_pkg.get_member_name
3388: (p_member_id => l_prev_member_id,
3389: p_routing_type => p_routing_type,
3390: p_member_name => l_member_name);
3391: --

Line 3446: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap

3442: -- transaction category.
3443: --
3444: hr_utility.set_location('Calling chk_routing_range_overlap:'||l_proc, 6);
3445: --
3446: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap
3447: (tab1 => all_routing_rules ,
3448: tab2 => all_attributes_tab,
3449: p_transaction_category_id => p_transaction_category_id,
3450: p_routing_category_id => l_prev_routing_category_id,

Line 3472: pqh_attribute_ranges_pkg.get_member_name

3468: pqh_tct_bus.get_routing_category_name(
3469: p_routing_category_id => l_prev_routing_category_id,
3470: p_routing_category_name => l_error_routing_category);
3471: --
3472: pqh_attribute_ranges_pkg.get_member_name
3473: (p_member_id => l_prev_member_id,
3474: p_routing_type => p_routing_type,
3475: p_member_name => l_member_name);
3476: --