APPS.CZ_LOGIC_GEN dependencies on CZ_DES_CHART_CELLS

Line 79: TYPE tOptionId IS TABLE OF cz_des_chart_cells.secondary_opt_id%TYPE INDEX BY BINARY_INTEGER;

75: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
76: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
77: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
78: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
79: TYPE tOptionId IS TABLE OF cz_des_chart_cells.secondary_opt_id%TYPE INDEX BY BINARY_INTEGER;
80: TYPE tConsequentFlag IS TABLE OF cz_expression_nodes.consequent_flag%TYPE INDEX BY BINARY_INTEGER;
81: TYPE tDesFeatureType IS TABLE OF cz_des_chart_features.feature_type%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;

Line 7283: FROM cz_des_chart_cells

7279:
7280: nDebug := 5000002;
7281:
7282: SELECT secondary_opt_id BULK COLLECT INTO v_tOptionId
7283: FROM cz_des_chart_cells
7284: WHERE deleted_flag = FLAG_NOT_DELETED
7285: AND rule_id = nRuleId
7286: AND secondary_feature_id = v_tExprPsNodeId(i)
7287: AND secondary_feat_expl_id = v_tExplNodeId(i);

Line 7544: FROM cz_des_chart_cells

7540: --Read the list of participating options of the primary feature. Make a copy of the list
7541: --for the rule verification purposes (bug #2257421).
7542:
7543: SELECT primary_opt_id, primary_opt_id BULK COLLECT INTO v_tOptionId, v_tPrimaryOptId
7544: FROM cz_des_chart_cells
7545: WHERE rule_id = nRuleId
7546: AND secondary_feature_id = vGridColumns(2)
7547: AND secondary_feat_expl_id = v_tExplNodeId(vBackIndex(2))
7548: AND deleted_flag = FLAG_NOT_DELETED

Line 7583: FROM cz_des_chart_cells

7579:
7580: --Read the list of participating options of defining or optional feature.
7581:
7582: SELECT secondary_opt_id, primary_opt_id BULK COLLECT INTO v_tOptionId, v_tPrimaryId
7583: FROM cz_des_chart_cells
7584: WHERE rule_id = nRuleId
7585: AND secondary_feature_id = vGridColumns(i)
7586: AND secondary_feat_expl_id = v_tExplNodeId(vBackIndex(i))
7587: AND deleted_flag = FLAG_NOT_DELETED