496:
497: UPDATE cz_expression_nodes SET consequent_flag = flag_is_consequent
498: WHERE expr_node_id IN
499: (SELECT child1.expr_node_id
500: FROM cz_rules rule, cz_expression_nodes parent, cz_expression_nodes child1,
501: cz_expression_nodes child2
502: WHERE
503: --Parent is not deleted and is operator dot
504: parent.deleted_flag = flag_not_deleted
1781:
1782: CURSOR c_rules IS
1783: SELECT rule_id, rule_type, antecedent_id, consequent_id, name, reason_id,
1784: expr_rule_type, rule_folder_id
1785: FROM cz_rules
1786: WHERE devl_project_id = inComponentId
1787: AND deleted_flag = FLAG_NOT_DELETED
1788: AND disabled_flag = FLAG_NOT_DISABLED;
1789:
1835:
1836: v_LoadHeaders tHeaderId;
1837: v_LoadConditions tStringArray;
1838:
1839: nAntecedentId cz_rules.antecedent_id%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1836: v_LoadHeaders tHeaderId;
1837: v_LoadConditions tStringArray;
1838:
1839: nAntecedentId cz_rules.antecedent_id%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1837: v_LoadConditions tStringArray;
1838:
1839: nAntecedentId cz_rules.antecedent_id%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1838:
1839: nAntecedentId cz_rules.antecedent_id%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1839: nAntecedentId cz_rules.antecedent_id%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1840: nConsequentId cz_rules.consequent_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1841: nRuleId cz_rules.rule_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1842: nRuleFolderId cz_rules.rule_folder_id%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1843: nRuleType cz_rules.rule_type%TYPE;
1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
2653: END LOOP;
2654:
2655: IF(v_MarkLoadCondition.COUNT <> 0)THEN
2656:
2657: --UPDATE cz_rules SET disabled_flag = '1' WHERE rule_id = nRuleId;
2658: RAISE CZ_R_RULE_REPORTED; --This rule should be reported.
2659:
2660: END IF;
2661: END IF; --Not a rule folder or functional companion