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_DEVELOPER_UTILS_PVT dependencies on CZ_EXPRESSION_NODES

Line 542: ps_node_id,property_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES

538:
539: l_rule_text_str := get_String_From_CLOB();
540:
541: FOR i IN(SELECT source_offset,source_length,display_node_depth,
542: ps_node_id,property_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES
543: WHERE rule_id = p_rule_id AND expr_type IN(205,207)
544: AND deleted_flag='0' ORDER BY -source_offset)
545: LOOP
546:

Line 1212: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p

1208: -- cursor to load all participating ps nodes in a expression or CX rule
1209: ------------------------------------------------------------------------
1210: CURSOR l_rule_nodes_csr (iRuleId NUMBER) IS
1211: SELECT DISTINCT e.ps_node_id, p.devl_project_id, e.model_ref_expl_id
1212: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p
1213: WHERE e.deleted_flag = '0'
1214: AND r.deleted_flag = '0'
1215: AND p.deleted_flag = '0'
1216: AND p.ps_node_id = e.ps_node_id

Line 1420: UPDATE cz_expression_nodes

1416: IF l_index IS NULL THEN
1417: EXIT;
1418: END IF;
1419:
1420: UPDATE cz_expression_nodes
1421: SET ps_node_id = l_ps_nodes_tbl(l_index)
1422: WHERE ps_node_id = l_index
1423: AND rule_id = l_new_rule_id;
1424:

Line 1439: UPDATE cz_expression_nodes

1435: LOOP
1436: IF l_index IS NULL THEN
1437: EXIT;
1438: END IF;
1439: UPDATE cz_expression_nodes
1440: SET relative_node_path = REPLACE(relative_node_path,TO_CHAR(l_index),TO_CHAR(l_persistent_tbl(l_index)))
1441: WHERE rule_id = l_new_rule_id
1442: AND relative_node_path IS NOT NULL;
1443: l_index := l_persistent_tbl.NEXT(l_index);

Line 1477: UPDATE cz_expression_nodes

1473: IF l_index IS NULL THEN
1474: EXIT;
1475: END IF;
1476:
1477: UPDATE cz_expression_nodes
1478: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1479: WHERE model_ref_expl_id = l_index
1480: AND rule_id = l_new_rule_id;
1481:

Line 1514: UPDATE cz_expression_nodes

1510: IF l_index IS NULL THEN
1511: EXIT;
1512: END IF;
1513:
1514: UPDATE cz_expression_nodes
1515: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1516: WHERE model_ref_expl_id = l_index
1517: AND rule_id = l_new_rule_id;
1518:

Line 1524: UPDATE cz_expression_nodes

1520: END LOOP;
1521:
1522: -- also update those nodes in subtree under the non-virtual root
1523:
1524: UPDATE cz_expression_nodes
1525: SET model_ref_expl_id = l_new_expl_id
1526: WHERE rule_id=l_new_rule_id
1527: AND model_ref_expl_id=l_expl_id;
1528:

Line 2263: FROM CZ_EXPRESSION_NODES

2259: l_new_parent_exprnode_tbl.delete;
2260:
2261: FOR i IN (
2262: SELECT expr_node_id, expr_parent_id
2263: FROM CZ_EXPRESSION_NODES
2264: WHERE rule_id=p_rule_id AND deleted_flag='0') LOOP
2265: l_new_exprnode_tbl(i.expr_node_id) := allocateId('CZ_EXPRESSION_NODES_S');
2266: l_parent_exprnode_tbl(i.expr_node_id) := i.expr_parent_id;
2267: END LOOP;

Line 2265: l_new_exprnode_tbl(i.expr_node_id) := allocateId('CZ_EXPRESSION_NODES_S');

2261: FOR i IN (
2262: SELECT expr_node_id, expr_parent_id
2263: FROM CZ_EXPRESSION_NODES
2264: WHERE rule_id=p_rule_id AND deleted_flag='0') LOOP
2265: l_new_exprnode_tbl(i.expr_node_id) := allocateId('CZ_EXPRESSION_NODES_S');
2266: l_parent_exprnode_tbl(i.expr_node_id) := i.expr_parent_id;
2267: END LOOP;
2268:
2269: l_key := l_new_exprnode_tbl.FIRST;

Line 2280: INSERT INTO CZ_EXPRESSION_NODES

2276: ELSE
2277: l_new_parent := NULL;
2278: END IF;
2279:
2280: INSERT INTO CZ_EXPRESSION_NODES
2281: (
2282: EXPR_NODE_ID
2283: ,EXPRESS_ID
2284: ,SEQ_NBR

Line 2368: FROM CZ_EXPRESSION_NODES

2364: ,RELATIVE_NODE_PATH
2365: ,EVENT_EXECUTION_SCOPE
2366: ,DATA_NUM_VALUE
2367: ,SEEDED_FLAG
2368: FROM CZ_EXPRESSION_NODES
2369: WHERE expr_node_id=l_key;
2370: l_key := l_new_exprnode_tbl.NEXT(l_key);
2371: END LOOP;
2372:

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

8651: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8652:
8653: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8654: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

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

8652:
8653: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8654: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;

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

8653: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8654: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;

Line 8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;

8654: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;

Line 8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;

Line 8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;

8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;

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

8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;

Line 8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;

8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;

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

8659: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;

Line 8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;

8660: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8668:

Line 8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;

8661: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8668:
8669: h_PsNodeName tPsNodeName;

Line 8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;

8662: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8668:
8669: h_PsNodeName tPsNodeName;
8670: h_PropertyName tPropertyName;

Line 8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;

8663: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8664: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8665: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8666: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8667: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8668:
8669: h_PsNodeName tPsNodeName;
8670: h_PropertyName tPropertyName;
8671: h_FullName tIntegerTable;

Line 8913: --the end, we physically update the columns in cz_expression_nodes.

8909:
8910: --First correct a data_type upgrade problem from czrules1.sql. This is an operator, its children
8911: --has not been generated into text yet. We will update data_type and data_num_value for children
8912: --in memory, if necessary, so that children will or will not be enclosed in quotes correctly. At
8913: --the end, we physically update the columns in cz_expression_nodes.
8914:
8915: IF(v_ExprTemplateId(j) IN
8916: (318,320,321,322,323,350,351,352,353,399,401,402,403,
8917: 404,405,406,407,408,409,410,411,412,413,414,415,416,

Line 9317: FROM cz_expression_nodes

9313: argument_name, data_num_value, data_type
9314: BULK COLLECT INTO v_tTmplNodeId, v_tTmplType, v_tTmplId, v_tTmplParentId, v_tTmplTemplateId,
9315: v_tTmplPsNodeId, v_tTmplDataValue, v_tTmplPropertyId,
9316: v_tTmplArgumentIndex, v_tTmplArgumentName, v_tTmplDataNumValue, v_tTmplDataType
9317: FROM cz_expression_nodes
9318: WHERE rule_id = p_template_id
9319: AND expr_type <> EXPR_PUNCT
9320: AND deleted_flag = '0'
9321: ORDER BY expr_parent_id, seq_nbr;

Line 9782: FROM cz_expression_nodes

9778: param_index, argument_name
9779: BULK COLLECT INTO v_ExprId, v_ExprParentId, v_ExprType, v_ExprTemplateId,
9780: v_ExprPsNodeId, v_ExplNodeId, v_ExprPropertyId, v_ExprDataType, v_ExprDataValue, v_ExprDataNumValue,
9781: v_ExprParamIndex, v_ExprArgumentName
9782: FROM cz_expression_nodes
9783: WHERE rule_id = p_rule_id
9784: AND expr_type <> EXPR_PUNCT
9785: AND deleted_flag = '0'
9786: ORDER BY expr_parent_id, seq_nbr;

Line 10707: FROM cz_expression_nodes

10703: BULK COLLECT INTO v_tExprId, v_tExprParentId, v_tExplNodeId, v_tExprType, v_tExprSubtype, v_tExprPsNodeId,
10704: v_tExprArgSignature, v_tExprParSignature, v_tExprParamIndex, v_tExprDataValue,
10705: v_tExprDataNumValue, v_tExprArgumentName, v_tExprDataType, v_tExprArgumentIndex,
10706: v_tPropertyId, v_ExistingRelativePath
10707: FROM cz_expression_nodes
10708: WHERE rule_id = p_rule_id
10709: AND expr_type <> EXPR_NODE_TYPE_PUNCT
10710: AND deleted_flag = '0';
10711:

Line 11051: UPDATE cz_expression_nodes SET relative_node_path = v_RelativeNodePath(i)

11047:
11048: IF(NVL(v_ExistingRelativePath(i),'X') <> NVL(v_RelativeNodePath(i),'X'))THEN
11049:
11050: FORALL i IN expressionStart..expressionEnd
11051: UPDATE cz_expression_nodes SET relative_node_path = v_RelativeNodePath(i)
11052: WHERE expr_node_id = v_tExprId(i);
11053:
11054: EXIT; --If we find one mismatch for a rule then exit of the compare loop
11055:

Line 12017: CZ_EXPRESSION_NODES expr,

12013: x_msg_data := '';
12014:
12015: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
12016: FROM CZ_RULES rul,
12017: CZ_EXPRESSION_NODES expr,
12018: CZ_SIGNATURE_ARGUMENTS args
12019: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
12020: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND
12021: expr.param_signature_id = args.argument_signature_id AND