[Home] [Help]
764:
765:
766:
767:
768: -- function to get rule id values . As cz_rules_s sequence is incremented by 20 everytime hence we need this function
769: FUNCTION next_rule_id RETURN NUMBER IS
770: id_to_return NUMBER;
771: BEGIN
772: IF((last_id_allocated IS NULL) OR
771: BEGIN
772: IF((last_id_allocated IS NULL) OR
773: (next_id_to_use = (NVL(last_id_allocated, 0) + CZ_SEQUENCE_INCREMENT)))THEN
774:
775: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM DUAL;
776: next_id_to_use := last_id_allocated;
777: END IF;
778:
779: id_to_return := next_id_to_use;
1144:
1145: END IF;
1146:
1147: UPDATE cz_localized_texts SET deleted_flag =1 WHERE intl_text_id=v_contribute_consume.reason_id;
1148: UPDATE cz_rules SET reason_id=null, reason_type=0, accumulator_flag=1 WHERE rule_id=v_contribute_consume.rule_id; -- fix for BUG7209057
1149:
1150:
1151: IF(l_previous_devl_project_id IS NULL) THEN
1152: l_previous_devl_project_id := v_contribute_consume.devl_project_id;
1659:
1660:
1661:
1662: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1663: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1664: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1665:
1666:
1667: IF v_cz_ids_tbl.COUNT>0 THEN
1748: --Any numeric participants in existing logic rules will be mapped to "expr > 0".
1749: --Refer section 4.1.4.6
1750:
1751: ---make this logic rule a statement rule
1752: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1753: (SELECT exp2.rule_id
1754: FROM cz_expression_nodes exp1,
1755: cz_expression_nodes exp2,
1756: cz_ps_nodes psnode