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 152: (SELECT 1 FROM cz_expression_nodes x

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

Line 400: EXISTS(SELECT NULL FROM cz_expression_nodes x

396: /* old code
397: BEGIN
398: SELECT 1 INTO v_iret FROM dual
399: WHERE
400: EXISTS(SELECT NULL FROM cz_expression_nodes x
401: WHERE deleted_flag = NO_FLAG
402: AND consequent_flag =YES_FLAG
403: AND ps_node_id = p_ps_node_id
404: AND EXISTS

Line 430: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;

426: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
427:
428: FUNCTION getExprSubType(p_expr_node_id IN INTEGER) RETURN NUMBER IS
429:
430: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
431: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
432:
433: BEGIN
434: SELECT expr_parent_id INTO v_expr_parent

Line 431: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;

427:
428: FUNCTION getExprSubType(p_expr_node_id IN INTEGER) RETURN NUMBER IS
429:
430: v_expr_parent CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
431: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
432:
433: BEGIN
434: SELECT expr_parent_id INTO v_expr_parent
435: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND

Line 435: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND

431: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
432:
433: BEGIN
434: SELECT expr_parent_id INTO v_expr_parent
435: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND
436: deleted_flag=NO_FLAG;
437:
438: SELECT expr_subtype INTO v_expr_subtype
439: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent AND ps_node_id IS NULL AND

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

435: FROM CZ_EXPRESSION_NODES WHERE expr_node_id=p_expr_node_id AND
436: deleted_flag=NO_FLAG;
437:
438: SELECT expr_subtype INTO v_expr_subtype
439: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent AND ps_node_id IS NULL AND
440: deleted_flag=NO_FLAG;
441:
442: RETURN v_expr_subtype;
443:

Line 462: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;

458: p_minimum IN INTEGER,
459: p_maximum IN INTEGER,
460: p_ps_node_type IN INTEGER) RETURN NUMBER IS
461:
462: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
463: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
464: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
465:
466: BEGIN

Line 463: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;

459: p_maximum IN INTEGER,
460: p_ps_node_type IN INTEGER) RETURN NUMBER IS
461:
462: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
463: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
464: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
465:
466: BEGIN
467: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES

Line 472: SELECT expr_parent_id INTO v_expr_parent_id FROM CZ_EXPRESSION_NODES

468: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG
469: AND deleted_flag=NO_FLAG)
470: LOOP
471: BEGIN
472: SELECT expr_parent_id INTO v_expr_parent_id FROM CZ_EXPRESSION_NODES
473: WHERE ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
474: rule_id=i.rule_id;
475:
476: SELECT expr_subtype INTO v_expr_subtype

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

473: WHERE ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
474: rule_id=i.rule_id;
475:
476: SELECT expr_subtype INTO v_expr_subtype
477: FROM CZ_EXPRESSION_NODES WHERE expr_parent_id=v_expr_parent_id AND ps_node_id IS NULL AND
478: deleted_flag=NO_FLAG;
479:
480: IF v_expr_subtype=CONTRIBUTE_TO_MIN_SUBTYPE THEN
481: IF (p_minimum=1 AND p_maximum=1) OR (p_minimum=0 AND p_maximum=1) THEN

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

1593: -- DEBUG ERROR CODE --
1594: --
1595: ERROR_CODE:=402;
1596:
1597: FOR m IN(SELECT expr_node_id,rule_id,model_ref_expl_id FROM CZ_EXPRESSION_NODES
1598: WHERE ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1599: LOOP
1600: BEGIN
1601:

Line 1614: UPDATE CZ_EXPRESSION_NODES

1610: -- DEBUG ERROR CODE --
1611: --
1612: ERROR_CODE:=404;
1613:
1614: UPDATE CZ_EXPRESSION_NODES
1615: SET model_ref_expl_id=v_ref_id
1616: WHERE expr_node_id=m.expr_node_id AND rule_id=m.rule_id;
1617:
1618: --

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

1623: EXCEPTION
1624: WHEN NO_DATA_FOUND THEN
1625: NULL;
1626: WHEN OTHERS THEN
1627: LOG_REPORT('set_Expls','CZ_EXPRESSION_NODES ERROR CODE :'||
1628: ERROR_CODE||' : '||SQLERRM);
1629: END;
1630: END LOOP;
1631:

Line 2142: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id

2138: FOR n IN(SELECT ps_node_id FROM CZ_PS_NODES
2139: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
2140: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
2141: LOOP
2142: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id
2143: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2144: AND ps_node_id=n.ps_node_id;
2145:
2146: UPDATE CZ_COMBO_FEATURES

Line 4304: FROM CZ_EXPRESSION_NODES

4300:
4301: FND_MSG_PUB.initialize;
4302:
4303: FOR i IN(SELECT expr_node_id,rule_id
4304: FROM CZ_EXPRESSION_NODES
4305: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES
4306: WHERE devl_project_id IN(SELECT devl_project_id FROM CZ_PS_NODES
4307: WHERE ps_node_id=p_ps_node_id) AND deleted_flag=NO_FLAG AND disabled_flag=NO_FLAG) AND
4308: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)

Line 4312: FROM CZ_EXPRESSION_NODES

4308: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)
4309: LOOP
4310: BEGIN
4311: SELECT template_id INTO l_template_id
4312: FROM CZ_EXPRESSION_NODES
4313: WHERE rule_id=i.rule_id AND expr_parent_id=i.expr_node_id AND
4314: expr_type=210 AND
4315: template_id in(43,44) AND deleted_flag=NO_FLAG;
4316:

Line 4393: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER; --Not Used Anywhere, we should remove this.

4389: x_inst_flag OUT NOCOPY NUMBER,
4390: x_sys_prop OUT NOCOPY NUMBER,
4391: x_validation_flag OUT NOCOPY VARCHAR2) IS
4392:
4393: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER; --Not Used Anywhere, we should remove this.
4394: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4395: TYPE tNumArrayVc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15); -- New Array defined
4396: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
4397:

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

4392:
4393: TYPE tExprNodeTbl IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER; --Not Used Anywhere, we should remove this.
4394: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4395: TYPE tNumArrayVc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15); -- New Array defined
4396: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
4397:
4398: l_children_index tNumArrayVc2;
4399: l_number_of_children tNumArrayVc2;
4400: l_index_by_expr_node_id tNumArrayVc2;

Line 4414: FROM cz_expression_nodes

4410:
4411: CURSOR C1 IS
4412: SELECT param_index, seq_nbr, expr_type, expr_node_id,
4413: expr_parent_id,template_id, ps_node_id
4414: FROM cz_expression_nodes
4415: WHERE rule_id = p_rule_id
4416: AND deleted_flag = '0'
4417: ORDER BY expr_parent_id, seq_nbr;
4418: