APPS.CZ_MODEL_CONVERT dependencies on CZ_RULES_S

Line 768: -- function to get rule id values . As cz_rules_s sequence is incremented by 20 everytime hence we need this function

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

Line 775: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM DUAL;

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;

Line 1142: UPDATE cz_rules SET reason_id=null WHERE rule_id=v_contribute_consume.rule_id;

1138:
1139: END IF;
1140:
1141: UPDATE cz_localized_texts SET deleted_flag =1 WHERE intl_text_id=v_contribute_consume.reason_id;
1142: UPDATE cz_rules SET reason_id=null WHERE rule_id=v_contribute_consume.rule_id;
1143:
1144:
1145: IF(l_previous_devl_project_id IS NULL) THEN
1146: l_previous_devl_project_id := v_contribute_consume.devl_project_id;

Line 1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT

1632:
1633:
1634:
1635: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1637: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1638:
1639:
1640: IF v_cz_ids_tbl.COUNT>0 THEN

Line 1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in

1721: --Any numeric participants in existing logic rules will be mapped to "expr > 0".
1722: --Refer section 4.1.4.6
1723:
1724: ---make this logic rule a statement rule
1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1726: (SELECT exp2.rule_id
1727: FROM cz_expression_nodes exp1,
1728: cz_expression_nodes exp2,
1729: cz_ps_nodes psnode