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 539: ps_node_id,property_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES

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

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

1180: -- cursor to load all participating ps nodes in a expression or CX rule
1181: ------------------------------------------------------------------------
1182: CURSOR l_rule_nodes_csr (iRuleId NUMBER) IS
1183: SELECT DISTINCT e.ps_node_id, p.devl_project_id, e.model_ref_expl_id
1184: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p
1185: WHERE e.deleted_flag = '0'
1186: AND r.deleted_flag = '0'
1187: AND p.deleted_flag = '0'
1188: AND p.ps_node_id = e.ps_node_id

Line 1392: UPDATE cz_expression_nodes

1388: IF l_index IS NULL THEN
1389: EXIT;
1390: END IF;
1391:
1392: UPDATE cz_expression_nodes
1393: SET ps_node_id = l_ps_nodes_tbl(l_index)
1394: WHERE ps_node_id = l_index
1395: AND rule_id = l_new_rule_id;
1396:

Line 1411: UPDATE cz_expression_nodes

1407: LOOP
1408: IF l_index IS NULL THEN
1409: EXIT;
1410: END IF;
1411: UPDATE cz_expression_nodes
1412: SET relative_node_path = REPLACE(relative_node_path,TO_CHAR(l_index),TO_CHAR(l_persistent_tbl(l_index)))
1413: WHERE rule_id = l_new_rule_id
1414: AND relative_node_path IS NOT NULL;
1415: l_index := l_persistent_tbl.NEXT(l_index);

Line 1449: UPDATE cz_expression_nodes

1445: IF l_index IS NULL THEN
1446: EXIT;
1447: END IF;
1448:
1449: UPDATE cz_expression_nodes
1450: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1451: WHERE model_ref_expl_id = l_index
1452: AND rule_id = l_new_rule_id;
1453:

Line 1486: UPDATE cz_expression_nodes

1482: IF l_index IS NULL THEN
1483: EXIT;
1484: END IF;
1485:
1486: UPDATE cz_expression_nodes
1487: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1488: WHERE model_ref_expl_id = l_index
1489: AND rule_id = l_new_rule_id;
1490:

Line 1496: UPDATE cz_expression_nodes

1492: END LOOP;
1493:
1494: -- also update those nodes in subtree under the non-virtual root
1495:
1496: UPDATE cz_expression_nodes
1497: SET model_ref_expl_id = l_new_expl_id
1498: WHERE rule_id=l_new_rule_id
1499: AND model_ref_expl_id=l_expl_id;
1500:

Line 2235: FROM CZ_EXPRESSION_NODES

2231: l_new_parent_exprnode_tbl.delete;
2232:
2233: FOR i IN (
2234: SELECT expr_node_id, expr_parent_id
2235: FROM CZ_EXPRESSION_NODES
2236: WHERE rule_id=p_rule_id AND deleted_flag='0') LOOP
2237: l_new_exprnode_tbl(i.expr_node_id) := allocateId('CZ_EXPRESSION_NODES_S');
2238: l_parent_exprnode_tbl(i.expr_node_id) := i.expr_parent_id;
2239: END LOOP;

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

2233: FOR i IN (
2234: SELECT expr_node_id, expr_parent_id
2235: FROM CZ_EXPRESSION_NODES
2236: WHERE rule_id=p_rule_id AND deleted_flag='0') LOOP
2237: l_new_exprnode_tbl(i.expr_node_id) := allocateId('CZ_EXPRESSION_NODES_S');
2238: l_parent_exprnode_tbl(i.expr_node_id) := i.expr_parent_id;
2239: END LOOP;
2240:
2241: l_key := l_new_exprnode_tbl.FIRST;

Line 2252: INSERT INTO CZ_EXPRESSION_NODES

2248: ELSE
2249: l_new_parent := NULL;
2250: END IF;
2251:
2252: INSERT INTO CZ_EXPRESSION_NODES
2253: (
2254: EXPR_NODE_ID
2255: ,EXPRESS_ID
2256: ,SEQ_NBR

Line 2340: FROM CZ_EXPRESSION_NODES

2336: ,RELATIVE_NODE_PATH
2337: ,EVENT_EXECUTION_SCOPE
2338: ,DATA_NUM_VALUE
2339: ,SEEDED_FLAG
2340: FROM CZ_EXPRESSION_NODES
2341: WHERE expr_node_id=l_key;
2342: l_key := l_new_exprnode_tbl.NEXT(l_key);
2343: END LOOP;
2344:

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

8600: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8601:
8602: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

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

8601:
8602: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;

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

8602: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;

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

8603: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;

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

8604: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;

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

8605: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;

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

8606: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;

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

8607: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;

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

8608: TYPE tExprPsNodeId IS TABLE OF cz_expression_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8616: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;

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

8609: TYPE tExplNodeId IS TABLE OF cz_expression_nodes.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8616: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8617:

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

8610: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%TYPE INDEX BY BINARY_INTEGER;
8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8616: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8617:
8618: h_PsNodeName tPsNodeName;

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

8611: TYPE tExprDataType IS TABLE OF cz_expression_nodes.data_type%TYPE INDEX BY BINARY_INTEGER;
8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8616: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8617:
8618: h_PsNodeName tPsNodeName;
8619: h_PropertyName tPropertyName;

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

8612: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
8613: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER;
8614: TYPE tExprParamIndex IS TABLE OF cz_expression_nodes.param_index%TYPE INDEX BY BINARY_INTEGER;
8615: TYPE tExprArgumentName IS TABLE OF cz_expression_nodes.argument_name%TYPE INDEX BY BINARY_INTEGER;
8616: TYPE tExprArgumentIndex IS TABLE OF cz_expression_nodes.argument_index%TYPE INDEX BY BINARY_INTEGER;
8617:
8618: h_PsNodeName tPsNodeName;
8619: h_PropertyName tPropertyName;
8620: h_FullName tIntegerTable;

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

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

Line 9266: FROM cz_expression_nodes

9262: argument_name, data_num_value, data_type
9263: BULK COLLECT INTO v_tTmplNodeId, v_tTmplType, v_tTmplId, v_tTmplParentId, v_tTmplTemplateId,
9264: v_tTmplPsNodeId, v_tTmplDataValue, v_tTmplPropertyId,
9265: v_tTmplArgumentIndex, v_tTmplArgumentName, v_tTmplDataNumValue, v_tTmplDataType
9266: FROM cz_expression_nodes
9267: WHERE rule_id = p_template_id
9268: AND expr_type <> EXPR_PUNCT
9269: AND deleted_flag = '0'
9270: ORDER BY expr_parent_id, seq_nbr;

Line 9731: FROM cz_expression_nodes

9727: param_index, argument_name
9728: BULK COLLECT INTO v_ExprId, v_ExprParentId, v_ExprType, v_ExprTemplateId,
9729: v_ExprPsNodeId, v_ExplNodeId, v_ExprPropertyId, v_ExprDataType, v_ExprDataValue, v_ExprDataNumValue,
9730: v_ExprParamIndex, v_ExprArgumentName
9731: FROM cz_expression_nodes
9732: WHERE rule_id = p_rule_id
9733: AND expr_type <> EXPR_PUNCT
9734: AND deleted_flag = '0'
9735: ORDER BY expr_parent_id, seq_nbr;

Line 10655: FROM cz_expression_nodes

10651: BULK COLLECT INTO v_tExprId, v_tExprParentId, v_tExplNodeId, v_tExprType, v_tExprSubtype, v_tExprPsNodeId,
10652: v_tExprArgSignature, v_tExprParSignature, v_tExprParamIndex, v_tExprDataValue,
10653: v_tExprDataNumValue, v_tExprArgumentName, v_tExprDataType, v_tExprArgumentIndex,
10654: v_tPropertyId
10655: FROM cz_expression_nodes
10656: WHERE rule_id = p_rule_id
10657: AND expr_type <> EXPR_NODE_TYPE_PUNCT
10658: AND deleted_flag = '0';
10659:

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

10986:
10987: IF(flagInvalidCX = 0)THEN
10988:
10989: FORALL i IN expressionStart..expressionEnd
10990: UPDATE cz_expression_nodes SET relative_node_path = v_RelativeNodePath(i)
10991: WHERE expr_node_id = v_tExprId(i);
10992:
10993: IF(initRuleStatus = '1')THEN
10994:

Line 11943: CZ_EXPRESSION_NODES expr,

11939: x_msg_data := '';
11940:
11941: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
11942: FROM CZ_RULES rul,
11943: CZ_EXPRESSION_NODES expr,
11944: CZ_SIGNATURE_ARGUMENTS args
11945: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
11946: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND
11947: expr.param_signature_id = args.argument_signature_id AND