eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UPGRADE dependencies on CZ_RULES

Line 500: FROM cz_rules rule, cz_expression_nodes parent, cz_expression_nodes child1,

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

Line 1785: FROM cz_rules

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:

Line 1839: nAntecedentId cz_rules.antecedent_id%TYPE;

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;

Line 1840: nConsequentId cz_rules.consequent_id%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;

Line 1841: nRuleId cz_rules.rule_id%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;

Line 1842: nRuleFolderId cz_rules.rule_folder_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;

Line 1843: nRuleType cz_rules.rule_type%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;

Line 1844: nRuleOperator cz_rules.expr_rule_type%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;

Line 1845: nReasonId cz_rules.reason_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;

Line 1846: vRuleName cz_rules.name%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;

Line 1847: vUsageMask cz_rules.effective_usage_mask%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;

Line 2657: --UPDATE cz_rules SET disabled_flag = '1' WHERE rule_id = nRuleId;

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