[Home] [Help]
643: l_proc varchar2(72) := g_package||'chk_member_cd_upd_allowed';
644: --
645: Cursor c1 is
646: Select null
647: from pqh_routing_categories a
648: where a.transaction_category_id = p_transaction_category_id
649: and nvl(a.enable_flag,'N') = 'Y';
650: Begin
651: --
858: l_no_of_list_ident number(10) := 0;
859: l_rec_count number(10) := 0;
860: l_no_of_rules number(10) := 0;
861: --
862: l_routing_category_id pqh_routing_categories.routing_category_id%type;
863: l_list_name varchar2(200);
864: --
865: l_dummy varchar2(1);
866: --
883: -- transaction category,and how many routing rules exists under each routing
884: -- category.
885: --
886: sql_stmt := 'Select rct.routing_category_id, count(rng.range_name)'
887: || ' from pqh_routing_categories rct,pqh_attribute_ranges rng'
888: || ' Where rct.transaction_category_id = :p_transaction_category_id'
889: || ' and rct.enable_flag = :p_enable_flag'
890: || ' and nvl(rct.default_flag,:dummy1) <> :yes_flag1 '
891: || ' and nvl(rct.delete_flag,:dummy2) <> :yes_flag2 ';
961: --
962: If p_routing_type = 'P' or p_routing_type = 'S' then
963: --
964: sql_stmt1 :='Select rct.routing_category_id'
965: ||' from pqh_routing_categories rct'
966: ||' Where rct.transaction_category_id=:p_transaction_category_id'
967: ||' and rct.enable_flag = :p_enable_flag'
968: ||' and nvl(rct.default_flag,:dummy1) <> :p_default_flag'
969: ||' and nvl(rct.delete_flag,:dummy2) <> :p_delete_flag';
1037: -- The foll cursor returns the name of the routing category.
1038: --
1039: Cursor csr_routing_name(p_routing_category_id in number) is
1040: Select decode(RCT.routing_list_id,NULL,decode(RCT.position_structure_id,NULL,hr_general.decode_lookup('PQH_SUPERVISORY_HIERARCHY','SUPERVISORY_HIERARCHY'),PPS.name),RLT.routing_list_name) list_name
1041: From pqh_routing_categories RCT ,
1042: pqh_routing_lists RLT,
1043: per_position_structures PPS
1044: WHERE RCT.routing_category_id = p_routing_category_id AND
1045: RCT.routing_list_id = RLT.routing_list_id(+) and