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_EXPRESSION_NODES

Line 492: UPDATE cz_expression_nodes SET consequent_flag = flag_not_consequent;

488: next_node_id := base_node_id;
489:
490: --Set the virtual_flag for all the nodes
491:
492: UPDATE cz_expression_nodes SET consequent_flag = flag_not_consequent;
493: COMMIT;
494:
495: --Updates consequent flags in a bunch for all projects in the schema
496:

Line 497: UPDATE cz_expression_nodes SET consequent_flag = flag_is_consequent

493: COMMIT;
494:
495: --Updates consequent flags in a bunch for all projects in the schema
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

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 501: cz_expression_nodes child2

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
505: AND parent.expr_type = expr_node_type_operator

Line 542: FROM cz_expressions expr, cz_expression_nodes node

538: AND (structure.ps_node_type = ps_node_type_bom_model OR (
539: (structure.minimum <> 1 OR structure.maximum <> 1 OR EXISTS
540: --Expressions are joined to bring in project
541: (SELECT NULL
542: FROM cz_expressions expr, cz_expression_nodes node
543: WHERE expr.devl_project_id = structure.devl_project_id
544: AND node.ps_node_id = structure.ps_node_id
545: AND expr.deleted_flag = flag_not_deleted
546: AND node.deleted_flag = flag_not_deleted

Line 797: UPDATE cz_expression_nodes SET model_ref_expl_id = correct_expl_id

793: CONNECT BY
794: (PRIOR virtual_flag IS NULL OR PRIOR virtual_flag = flag_virtual)
795: AND PRIOR ps_node_id = parent_id;
796:
797: UPDATE cz_expression_nodes SET model_ref_expl_id = correct_expl_id
798: WHERE ps_node_id = incomponentid AND deleted_flag = flag_not_deleted;
799:
800: UPDATE cz_func_comp_specs SET model_ref_expl_id = correct_expl_id
801: WHERE component_id = incomponentid AND deleted_flag = flag_not_deleted;

Line 821: UPDATE cz_expression_nodes SET model_ref_expl_id = correct_expl_id

817: IF(ntpsnodeid.last IS NOT NULL)THEN
818:
819: FOR i IN ntpsnodeid.first..ntpsnodeid.last LOOP
820:
821: UPDATE cz_expression_nodes SET model_ref_expl_id = correct_expl_id
822: WHERE ps_node_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;
823:
824: UPDATE cz_func_comp_specs SET model_ref_expl_id = correct_expl_id
825: WHERE component_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;

Line 1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;

1762: optionCounter PLS_INTEGER;
1763: ---------------------------------------------------------------------------------------
1764: PROCEDURE GENERATE_RULES IS
1765:
1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;

Line 1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;

1763: ---------------------------------------------------------------------------------------
1764: PROCEDURE GENERATE_RULES IS
1765:
1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;

Line 1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;

1764: PROCEDURE GENERATE_RULES IS
1765:
1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi

Line 1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;

1765:
1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;

Line 1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;

1766: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;

Line 1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;

1767: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;

Line 1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi

1768: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE tOptionId IS TABLE OF cz_grid_cells.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

Line 1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;

1769: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
1770: TYPE tExpressId IS TABLE OF cz_expression_nodes.express_id%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE tOptionId IS TABLE OF cz_grid_cells.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE tConsequentFlag IS TABLE OF cz_expression_nodes.consequent_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1777: TYPE tConsequentFlag IS TABLE OF cz_expression_nodes.consequent_flag%TYPE INDEX BY BINARY_INTEGER;

1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE tOptionId IS TABLE OF cz_grid_cells.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE tConsequentFlag IS TABLE OF cz_expression_nodes.consequent_flag%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE tDesFeatureType IS TABLE OF cz_des_chart_features.feature_type%TYPE INDEX BY BINARY_INTEGER;
1779:
1780: --The cursor returns all the rules assigned in this project (model)
1781:

Line 2077: FROM cz_expression_nodes

2073: express_id, expr_subtype, ps_node_id, data_value, data_num_value, property_id, consequent_flag
2074: BULK COLLECT INTO v_tExplNodeId, v_tExprType, v_tExprId, v_tExprParentId,
2075: v_tExpressId, v_tExprSubtype, v_tExprPsNodeId,
2076: v_tExprDataValue, v_tExprDataNumValue, v_tExprPropertyId, v_tConsequentFlag
2077: FROM cz_expression_nodes
2078: WHERE express_id IN (nAntecedentId, nConsequentId)
2079: AND expr_type <> EXPR_NODE_TYPE_PUNCT
2080: AND deleted_flag = FLAG_NOT_DELETED
2081: ORDER BY expr_parent_id, seq_nbr;

Line 2131: FROM cz_expression_nodes

2127: express_id, expr_subtype, ps_node_id, data_value, data_num_value, property_id
2128: BULK COLLECT INTO v_tExplNodeId, v_tExprType, v_tExprId, v_tExprParentId,
2129: v_tExpressId, v_tExprSubtype, v_tExprPsNodeId,
2130: v_tExprDataValue, v_tExprDataNumValue, v_tExprPropertyId
2131: FROM cz_expression_nodes
2132: WHERE express_id = nAntecedentId
2133: AND expr_type <> EXPR_NODE_TYPE_PUNCT
2134: AND deleted_flag = FLAG_NOT_DELETED
2135: ORDER BY expr_parent_id, seq_nbr;