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 599: FROM cz_rules

595: SELECT rule_id, rule_type, antecedent_id, consequent_id, name, reason_id,
596: expr_rule_type, rule_folder_id, component_id, model_ref_expl_id,
597: effective_from, effective_until, effective_usage_mask, effectivity_set_id,
598: unsatisfied_msg_id, unsatisfied_msg_source, presentation_flag, class_name
599: FROM cz_rules
600: WHERE devl_project_id = inComponentId
601: AND deleted_flag = FLAG_NOT_DELETED
602: AND disabled_flag = FLAG_NOT_DISABLED;
603:

Line 675: nAntecedentId cz_rules.antecedent_id%TYPE;

671: PrevRuleEffFrom tDateArray;
672: PrevRuleEffUntil tDateArray;
673: PrevRuleUsageMask tUsageMask;
674:
675: nAntecedentId cz_rules.antecedent_id%TYPE;
676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;

Line 676: nConsequentId cz_rules.consequent_id%TYPE;

672: PrevRuleEffUntil tDateArray;
673: PrevRuleUsageMask tUsageMask;
674:
675: nAntecedentId cz_rules.antecedent_id%TYPE;
676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;

Line 677: nRuleId cz_rules.rule_id%TYPE;

673: PrevRuleUsageMask tUsageMask;
674:
675: nAntecedentId cz_rules.antecedent_id%TYPE;
676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;

Line 678: nRuleFolderId cz_rules.rule_folder_id%TYPE;

674:
675: nAntecedentId cz_rules.antecedent_id%TYPE;
676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;

Line 679: nRuleType cz_rules.rule_type%TYPE;

675: nAntecedentId cz_rules.antecedent_id%TYPE;
676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;

Line 680: RuleTemplateType cz_rules.rule_type%TYPE;

676: nConsequentId cz_rules.consequent_id%TYPE;
677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;

Line 681: nRuleOperator cz_rules.expr_rule_type%TYPE;

677: nRuleId cz_rules.rule_id%TYPE;
678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;

Line 682: nReasonId cz_rules.reason_id%TYPE;

678: nRuleFolderId cz_rules.rule_folder_id%TYPE;
679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;

Line 683: nComponentId cz_rules.component_id%TYPE;

679: nRuleType cz_rules.rule_type%TYPE;
680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;

Line 684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;

680: RuleTemplateType cz_rules.rule_type%TYPE;
681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;

Line 685: dEffFrom cz_rules.effective_from%TYPE;

681: nRuleOperator cz_rules.expr_rule_type%TYPE;
682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;

Line 686: dEffUntil cz_rules.effective_until%TYPE;

682: nReasonId cz_rules.reason_id%TYPE;
683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;

Line 687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;

683: nComponentId cz_rules.component_id%TYPE;
684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;

Line 688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;

684: nModelRefExplId cz_rules.model_ref_expl_id%TYPE;
685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;

Line 689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;

685: dEffFrom cz_rules.effective_from%TYPE;
686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;

Line 690: nPresentationFlag cz_rules.presentation_flag%TYPE;

686: dEffUntil cz_rules.effective_until%TYPE;
687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;

Line 691: vRuleName cz_rules.name%TYPE;

687: nRuleEffSetId cz_rules.effectivity_set_id%TYPE;
688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;

Line 692: vUsageMask cz_rules.effective_usage_mask%TYPE;

688: nUnsatisfiedId cz_rules.unsatisfied_msg_id%TYPE;
689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;

Line 693: vClassName cz_rules.class_name%TYPE;

689: nUnsatisfiedSource cz_rules.unsatisfied_msg_source%TYPE;
690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;

Line 2838: sysPropName cz_rules.name%TYPE;

2834: RETURN VARCHAR2 IS
2835:
2836: optionIndex PLS_INTEGER;
2837: v_step PLS_INTEGER := p_parent_up;
2838: sysPropName cz_rules.name%TYPE;
2839: v_return VARCHAR2(4000);
2840: BEGIN
2841:
2842: sysPropName := h_SeededName(p_rule_id);

Line 7904: FROM cz_rules

7900: --This should be done only once during the generation session. The data is static and common
7901: --to all models.
7902:
7903: SELECT rule_id, signature_id, name BULK COLLECT INTO t_RuleId, t_SignatureId, t_RuleName
7904: FROM cz_rules
7905: WHERE devl_project_id = 0
7906: AND seeded_flag = FLAG_SEEDED
7907: AND deleted_flag = FLAG_NOT_DELETED
7908: AND disabled_flag = FLAG_NOT_DISABLED;

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

7919:
7920: nDebug := 1;
7921:
7922: --Make a quick and simple verification of all functional companions defined in this
7923: --project. All other rule related instances that do not reside in cz_rules can also
7924: --be processed in this section.
7925: --Added as a fix for the bug #2200481.
7926:
7927: --Restoring this block in 11.5.10+, bug #3989382.