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

Line 148: (SELECT 1 FROM cz_expression_nodes x

144: AND ps_node_type IN(COMPONENT_TYPE,REFERENCE_TYPE,CONNECTOR_TYPE,BOM_MODEL_TYPE)
145: AND MINIMUM = 1
146: AND MAXIMUM = 1
147: AND NOT EXISTS
148: (SELECT 1 FROM cz_expression_nodes x
149: WHERE deleted_flag = NO_FLAG
150: AND consequent_flag =YES_FLAG
151: AND ps_node_id = nodes.ps_node_id
152: AND EXISTS

Line 334: EXISTS(SELECT NULL FROM cz_expression_nodes x

330: /* old code
331: BEGIN
332: SELECT 1 INTO v_iret FROM dual
333: WHERE
334: EXISTS(SELECT NULL FROM cz_expression_nodes x
335: WHERE deleted_flag = NO_FLAG
336: AND consequent_flag =YES_FLAG
337: AND ps_node_id = p_ps_node_id
338: AND EXISTS

Line 364: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;

360: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
361:
362: FUNCTION getExprSubType(p_expr_node_id IN INTEGER) RETURN NUMBER IS
363:
364: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
365: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
366:
367: BEGIN
368: SELECT expr_parent_id INTO v_expr_parent

Line 365: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;

361:
362: FUNCTION getExprSubType(p_expr_node_id IN INTEGER) RETURN NUMBER IS
363:
364: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
365: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
366:
367: BEGIN
368: SELECT expr_parent_id INTO v_expr_parent
369: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND

Line 369: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND

365: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
366:
367: BEGIN
368: SELECT expr_parent_id INTO v_expr_parent
369: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND
370: deleted_flag=NO_FLAG;
371:
372: SELECT expr_subtype INTO v_expr_subtype
373: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent AND ps_node_id IS NULL AND

Line 373: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent AND ps_node_id IS NULL AND

369: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND
370: deleted_flag=NO_FLAG;
371:
372: SELECT expr_subtype INTO v_expr_subtype
373: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent AND ps_node_id IS NULL AND
374: deleted_flag=NO_FLAG;
375:
376: RETURN v_expr_subtype;
377:

Line 396: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;

392: p_minimum IN INTEGER,
393: p_maximum IN INTEGER,
394: p_ps_node_type IN INTEGER) RETURN NUMBER IS
395:
396: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
397: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
398: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
399:
400: BEGIN

Line 397: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;

393: p_maximum IN INTEGER,
394: p_ps_node_type IN INTEGER) RETURN NUMBER IS
395:
396: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
397: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
398: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
399:
400: BEGIN
401: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES

Line 406: SELECT expr_parent_id INTO v_expr_parent_id FROM CZ_EXPRESSION_NODES

402: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG
403: AND deleted_flag=NO_FLAG)
404: LOOP
405: BEGIN
406: SELECT expr_parent_id INTO v_expr_parent_id FROM CZ_EXPRESSION_NODES
407: WHERE ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
408: rule_id=i.rule_id;
409:
410: SELECT expr_subtype INTO v_expr_subtype

Line 411: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent_id AND ps_node_id IS NULL AND

407: WHERE ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
408: rule_id=i.rule_id;
409:
410: SELECT expr_subtype INTO v_expr_subtype
411: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent_id AND ps_node_id IS NULL AND
412: deleted_flag=NO_FLAG;
413:
414: IF v_expr_subtype=CONTRIBUTE_TO_MIN_SUBTYPE THEN
415: IF (p_minimum=1 AND p_maximum=1) OR (p_minimum=0 AND p_maximum=1) THEN

Line 1531: FOR m IN(SELECT expr_node_id,rule_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES

1527: -- DEBUG ERROR CODE --
1528: --
1529: ERROR_CODE:=402;
1530:
1531: FOR m IN(SELECT expr_node_id,rule_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES
1532: WHERE ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1533: LOOP
1534: BEGIN
1535:

Line 1548: UPDATE CZ_EXPRESSION_NODES

1544: -- DEBUG ERROR CODE --
1545: --
1546: ERROR_CODE:=404;
1547:
1548: UPDATE CZ_EXPRESSION_NODES
1549: SET model_ref_expl_id=v_ref_id
1550: WHERE expr_node_id=m.expr_node_id AND rule_id=m.rule_id;
1551:
1552: --

Line 1561: LOG_REPORT('set_Expls','CZ_EXPRESSION_NODES ERROR CODE :'||

1557: EXCEPTION
1558: WHEN NO_DATA_FOUND THEN
1559: NULL;
1560: WHEN OTHERS THEN
1561: LOG_REPORT('set_Expls','CZ_EXPRESSION_NODES ERROR CODE :'||
1562: ERROR_CODE||' : '||SQLERRM);
1563: END;
1564: END LOOP;
1565:

Line 2076: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id

2072: FOR n IN(SELECT ps_node_id FROM CZ_PS_NODES
2073: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
2074: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
2075: LOOP
2076: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id
2077: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2078: AND ps_node_id=n.ps_node_id;
2079:
2080: UPDATE CZ_COMBO_FEATURES

Line 4226: FROM CZ_EXPRESSION_NODES

4222:
4223: FND_MSG_PUB.initialize;
4224:
4225: FOR i IN(SELECT expr_node_id,rule_id
4226: FROM CZ_EXPRESSION_NODES
4227: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES
4228: WHERE devl_project_id IN(SELECT devl_project_id FROM CZ_PS_NODES
4229: WHERE ps_node_id=p_ps_node_id) AND deleted_flag=NO_FLAG AND disabled_flag=NO_FLAG) AND
4230: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)

Line 4234: FROM CZ_EXPRESSION_NODES

4230: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)
4231: LOOP
4232: BEGIN
4233: SELECT template_id INTO l_template_id
4234: FROM CZ_EXPRESSION_NODES
4235: WHERE rule_id=i.rule_id AND expr_parent_id=i.expr_node_id AND
4236: expr_type=210 AND
4237: template_id in(43,44) AND deleted_flag=NO_FLAG;
4238:

Line 4315: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER;

4311: x_inst_flag OUT NOCOPY NUMBER,
4312: x_sys_prop OUT NOCOPY NUMBER,
4313: x_validation_flag OUT NOCOPY VARCHAR2) IS
4314:
4315: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER;
4316: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4317: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
4318:
4319: l_children_index tNumber;

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

4313: x_validation_flag OUT NOCOPY VARCHAR2) IS
4314:
4315: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER;
4316: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4317: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
4318:
4319: l_children_index tNumber;
4320: l_number_of_children tNumber;
4321: l_index_by_expr_node_id tNumber;

Line 4335: FROM cz_expression_nodes

4331:
4332: CURSOR C1 IS
4333: SELECT param_index, seq_nbr, expr_type, expr_node_id,
4334: expr_parent_id,template_id, ps_node_id
4335: FROM cz_expression_nodes
4336: WHERE rule_id = p_rule_id
4337: AND deleted_flag = '0'
4338: ORDER BY expr_parent_id, seq_nbr;
4339: