[Home] [Help]
620: From pqh_txn_category_attributes tca
621: Where tca.transaction_category_id = p_transaction_category_id
622: and tca.attribute_id in
623: (Select attribute_id
624: From pqh_attributes
625: Where master_attribute_id = p_attribute_id)
626: for update nowait;
627: --
628: l_ovn pqh_txn_category_attributes.object_version_number%type;
697: -- The following cursor determines the master attribute of the passed attribute
698: --
699: Cursor csr_master_attribute is
700: Select master_attribute_id
701: From pqh_attributes
702: Where attribute_id = p_attribute_id;
703: --
704: -- The foll cursor selects the txn_category_attribute_id of all the child
705: -- attributes of the selected master attribute
712: ) OR
713: tca.txn_category_attribute_id = p_txn_category_attribute_id
714: for update nowait;
715: --
716: l_master_attribute pqh_attributes.master_attribute_id%type;
717: --
718: l_proc varchar2(72) := 'unselect_routing_attribute';
719: --
720: Begin
785: From pqh_txn_category_attributes tca
786: Where tca.transaction_category_id = p_transaction_category_id
787: and tca.attribute_id in
788: (Select attribute_id
789: From pqh_attributes
790: Where master_attribute_id = p_attribute_id)
791: for update nowait;
792: --
793: l_ovn pqh_txn_category_attributes.object_version_number%type;
862: -- The following cursor determines the master attribute of the passed attribute
863: --
864: Cursor csr_master_attribute is
865: Select master_attribute_id
866: From pqh_attributes
867: Where attribute_id = p_attribute_id;
868: --
869: -- The foll cursor selects the txn_category_attribute_id of all the child
870: -- attributes of the selected master attribute
877: ) OR
878: tca.txn_category_attribute_id = p_txn_category_attribute_id
879: for update nowait;
880: --
881: l_master_attribute pqh_attributes.master_attribute_id%type;
882: --
883: l_proc varchar2(72) := 'unselect_auth_attribute';
884: --
885: Begin
1145: and position_id IS NULL
1146: and assignment_id IS NULL
1147: AND ATTRIBUTE_ID IS NOT NULL ;
1148: --
1149: type attr_rec is record(attribute_id pqh_attributes.attribute_id%type);
1150: type attr_tab is table of attr_rec index by binary_integer;
1151: --
1152: l_attr_tab attr_tab;
1153: l_cnt number(15) := 0;
1260: WHERE RNG.ROUTING_CATEGORY_ID = p_routing_category_id
1261: AND (ROUTING_LIST_MEMBER_ID IS NOT NULL OR POSITION_ID IS NOT NULL OR ASSIGNMENT_ID IS NOT NULL)
1262: AND ATTRIBUTE_ID IS NOT NULL ;
1263: --
1264: type attr_rec is record(attribute_id pqh_attributes.attribute_id%type);
1265: type attr_tab is table of attr_rec index by binary_integer;
1266: --
1267: l_attr_tab attr_tab;
1268: l_cnt number(15) := 0;
3219: l_range_name pqh_attribute_ranges.range_name%type;
3220: l_member_id number(30);
3221: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;
3222: l_attribute_id pqh_attribute_ranges.attribute_id%type;
3223: l_column_type pqh_attributes.column_type%type;
3224: l_from_char pqh_attribute_ranges.from_char%type;
3225: l_to_char pqh_attribute_ranges.to_char%type;
3226: l_from_date pqh_attribute_ranges.from_date%type;
3227: l_to_date pqh_attribute_ranges.to_date%type;
3270: End if;
3271: --
3272: 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 ';
3273: --
3274: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';
3275: --
3276: sql_stmt := sql_stmt ||' Where rct.transaction_category_id = :p_transaction_category_id and rct.enable_flag = :enable_flag and nvl(rct.default_flag,:null_value) <> :default_flag and nvl(rct.delete_flag,:null2) <> :delete_flag ';
3277: --
3278: -- If a routing category is passed, process only this routing category.