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_LOGIC_GEN dependencies on CZ_RULES

Line 86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;

82: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
83: TYPE tExprArgSignature IS TABLE OF cz_expression_nodes.argument_signature_id%TYPE INDEX BY BINARY_INTEGER;
84: TYPE tExprParSignature IS TABLE OF cz_expression_nodes.param_signature_id%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;

Line 87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;

83: TYPE tExprArgSignature IS TABLE OF cz_expression_nodes.argument_signature_id%TYPE INDEX BY BINARY_INTEGER;
84: TYPE tExprParSignature IS TABLE OF cz_expression_nodes.param_signature_id%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;

Line 588: FROM cz_rules

584: SELECT rule_id, rule_type, antecedent_id, consequent_id, name, reason_id,
585: expr_rule_type, rule_folder_id, component_id, model_ref_expl_id,
586: effective_from, effective_until, effective_usage_mask, effectivity_set_id,
587: unsatisfied_msg_id, unsatisfied_msg_source, presentation_flag, class_name
588: FROM cz_rules
589: WHERE devl_project_id = inComponentId
590: AND deleted_flag = FLAG_NOT_DELETED
591: AND disabled_flag = FLAG_NOT_DISABLED;
592:

Line 664: nAntecedentId cz_rules.antecedent_id%TYPE;

660: PrevRuleEffFrom tDateArray;
661: PrevRuleEffUntil tDateArray;
662: PrevRuleUsageMask tUsageMask;
663:
664: nAntecedentId cz_rules.antecedent_id%TYPE;
665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;

Line 665: nConsequentId cz_rules.consequent_id%TYPE;

661: PrevRuleEffUntil tDateArray;
662: PrevRuleUsageMask tUsageMask;
663:
664: nAntecedentId cz_rules.antecedent_id%TYPE;
665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;

Line 666: nRuleId cz_rules.rule_id%TYPE;

662: PrevRuleUsageMask tUsageMask;
663:
664: nAntecedentId cz_rules.antecedent_id%TYPE;
665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;

Line 667: nRuleFolderId cz_rules.rule_folder_id%TYPE;

663:
664: nAntecedentId cz_rules.antecedent_id%TYPE;
665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;

Line 668: nRuleType cz_rules.rule_type%TYPE;

664: nAntecedentId cz_rules.antecedent_id%TYPE;
665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;

Line 669: RuleTemplateType cz_rules.rule_type%TYPE;

665: nConsequentId cz_rules.consequent_id%TYPE;
666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;

Line 670: nRuleOperator cz_rules.expr_rule_type%TYPE;

666: nRuleId cz_rules.rule_id%TYPE;
667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;

Line 671: nReasonId cz_rules.reason_id%TYPE;

667: nRuleFolderId cz_rules.rule_folder_id%TYPE;
668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;

Line 672: nComponentId cz_rules.component_id%TYPE;

668: nRuleType cz_rules.rule_type%TYPE;
669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;

Line 673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;

669: RuleTemplateType cz_rules.rule_type%TYPE;
670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;

Line 674: dEffFrom cz_rules.effective_from%TYPE;

670: nRuleOperator cz_rules.expr_rule_type%TYPE;
671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;

Line 675: dEffUntil cz_rules.effective_until%TYPE;

671: nReasonId cz_rules.reason_id%TYPE;
672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;

Line 676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;

672: nComponentId cz_rules.component_id%TYPE;
673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;

Line 677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;

673: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;

Line 678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;

674: dEffFrom cz_rules.effective_from%TYPE;
675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;

Line 679: nPresentationFlag cz_rules.presentation_flag%TYPE;

675: dEffUntil cz_rules.effective_until%TYPE;
676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;

Line 680: vRuleName cz_rules.name%TYPE;

676: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;

Line 681: vUsageMask cz_rules.effective_usage_mask%TYPE;

677: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;

Line 682: vClassName cz_rules.class_name%TYPE;

678: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;

Line 2827: sysPropName cz_rules.name%TYPE;

2823: RETURN VARCHAR2 IS
2824:
2825: optionIndex PLS_INTEGER;
2826: v_step PLS_INTEGER := p_parent_up;
2827: sysPropName cz_rules.name%TYPE;
2828: v_return VARCHAR2(4000);
2829: BEGIN
2830:
2831: sysPropName := h_SeededName(p_rule_id);

Line 7889: FROM cz_rules

7885: --This should be done only once during the generation session. The data is static and common
7886: --to all models.
7887:
7888: SELECT rule_id, signature_id, name BULK COLLECT INTO t_RuleId, t_SignatureId, t_RuleName
7889: FROM cz_rules
7890: WHERE devl_project_id = 0
7891: AND seeded_flag = FLAG_SEEDED
7892: AND deleted_flag = FLAG_NOT_DELETED
7893: AND disabled_flag = FLAG_NOT_DISABLED;

Line 7908: --project. All other rule related instances that do not reside in cz_rules can also

7904:
7905: nDebug := 1;
7906:
7907: --Make a quick and simple verification of all functional companions defined in this
7908: --project. All other rule related instances that do not reside in cz_rules can also
7909: --be processed in this section.
7910: --Added as a fix for the bug #2200481.
7911:
7912: --Restoring this block in 11.5.10+, bug #3989382.