APPS.PQH_TCT_WIZARD_PKG dependencies on PQH_ATTRIBUTE_RANGES_PKG

Line 3191: l_error_code := pqh_attribute_ranges_pkg.chk_enable_routing_category

3187: Close csr_chk_rule_overlap;
3188: exit;
3189: End if;
3190: --
3191: l_error_code := pqh_attribute_ranges_pkg.chk_enable_routing_category
3192: (p_routing_category_id => l_routing_category_id,
3193: p_transaction_category_id => p_transaction_category_id,
3194: p_overlap_range_name => l_overlap_range_name,
3195: p_error_routing_category => l_error_routing_category,

Line 3258: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;

3254: type cur_type IS REF CURSOR;
3255: csr_mem_overlap cur_type;
3256: sql_stmt varchar2(2000);
3257: --
3258: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;
3259: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;
3260: --
3261: Cursor csr_mem_ident_cnt is
3262: Select count(*)

Line 3259: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;

3255: csr_mem_overlap cur_type;
3256: sql_stmt varchar2(2000);
3257: --
3258: all_routing_rules pqh_attribute_ranges_pkg.rule_attr_tab;
3259: all_attributes_tab pqh_attribute_ranges_pkg.rule_attr_tab;
3260: --
3261: Cursor csr_mem_ident_cnt is
3262: Select count(*)
3263: from pqh_txn_category_attributes

Line 3385: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap

3381: -- overlaps with any other routing rules under that
3382: -- transaction category.
3383: --
3384: hr_utility.set_location('Calling chk_member_range_overlap:'||l_proc, 6);
3385: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap
3386: (tab1 => all_routing_rules ,
3387: tab2 => all_attributes_tab,
3388: p_transaction_category_id => p_transaction_category_id,
3389: p_routing_category_id => l_prev_routing_category_id,

Line 3408: pqh_attribute_ranges_pkg.get_member_name

3404: pqh_tct_bus.get_routing_category_name(
3405: p_routing_category_id => l_prev_routing_category_id,
3406: p_routing_category_name => l_error_routing_category);
3407: --
3408: pqh_attribute_ranges_pkg.get_member_name
3409: (p_member_id => l_prev_member_id,
3410: p_routing_type => p_routing_type,
3411: p_member_name => l_member_name);
3412: --

Line 3467: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap

3463: -- transaction category.
3464: --
3465: hr_utility.set_location('Calling chk_routing_range_overlap:'||l_proc, 6);
3466: --
3467: l_error_code := pqh_attribute_ranges_pkg.chk_member_range_overlap
3468: (tab1 => all_routing_rules ,
3469: tab2 => all_attributes_tab,
3470: p_transaction_category_id => p_transaction_category_id,
3471: p_routing_category_id => l_prev_routing_category_id,

Line 3493: pqh_attribute_ranges_pkg.get_member_name

3489: pqh_tct_bus.get_routing_category_name(
3490: p_routing_category_id => l_prev_routing_category_id,
3491: p_routing_category_name => l_error_routing_category);
3492: --
3493: pqh_attribute_ranges_pkg.get_member_name
3494: (p_member_id => l_prev_member_id,
3495: p_routing_type => p_routing_type,
3496: p_member_name => l_member_name);
3497: --