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_MODEL_CONVERT dependencies on CZ_EXPRESSION_NODES_S

Line 661: UPDATE cz_expression_nodes SET template_id= DECODE(template_id,894,979,818,977,812,899,847,898,893,978,817,976,811,897,846,896,813,971,814,973,815,974,816,975,template_id)

657: , v_ui.name , 'EXPRESSION_OR_CONDITION', ' Display Condition ' ,'PROPERTYNAME_2', 'Definition'||v_ui.rulename);
658: END LOOP;
659:
660:
661: UPDATE cz_expression_nodes SET template_id= DECODE(template_id,894,979,818,977,812,899,847,898,893,978,817,976,811,897,846,896,813,971,814,973,815,974,816,975,template_id)
662: WHERE expr_node_id IN
663: (
664: SELECT ex.expr_node_id
665: FROM cz_expression_nodes ex,

Line 859: SELECT cz_expression_nodes_s.nextval

855: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
856: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
857: BEGIN
858:
859: SELECT cz_expression_nodes_s.nextval
860: INTO l_expression_node_id
861: FROM dual;
862: v_cz_expr_node_count := v_cz_expr_node_count + 1;
863: --insert the implies record

Line 881: SELECT cz_expression_nodes_s.nextval

877:
878:
879: v_cz_expr_node_count := v_cz_expr_node_count + 1;
880: --insert initial value record
881: SELECT cz_expression_nodes_s.nextval
882: INTO l_expression_node_id1
883: FROM dual;
884: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
885: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;

Line 900: SELECT cz_expression_nodes_s.nextval

896: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
897:
898: v_cz_expr_node_count := v_cz_expr_node_count + 1;
899: --insert boolean feature record
900: SELECT cz_expression_nodes_s.nextval
901: INTO l_expression_node_id1
902: FROM dual;
903: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
904: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;

Line 954: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;

950: IF initialvalue IS NOT NULL THEN
951:
952: -- Insert AddTo expression record;
953:
954: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;
955: v_cz_expr_node_count:=v_cz_expr_node_count+1;
956:
957: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
958: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;

Line 972: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;

968: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
969: -- Insert initial value record;
970:
971:
972: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
973: v_cz_expr_node_count:=v_cz_expr_node_count+1;
974:
975:
976:

Line 999: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;

995: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
996: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
997: -- Insert record for ps_node_id, ps_node_type;
998:
999: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
1000: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1001:
1002: IF p_model_ref_expl_id IS NULL THEN
1003: l_ps_node_id :=ps_node_id;

Line 1105: Update cz_expression_nodes set template_id=decode(template_id,708 , OPERATOR_ADDSTO , 710 , OPERATOR_SUBTRACTSFROM) where rule_id=v_contribute_consume.rule_id and template_id in (708,710);

1101: FOR v_contribute_consume IN c_contrib_consume
1102: LOOP
1103: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1104: IF v_contribute_consume.template_id IN (708,710) THEN
1105: Update cz_expression_nodes set template_id=decode(template_id,708 , OPERATOR_ADDSTO , 710 , OPERATOR_SUBTRACTSFROM) where rule_id=v_contribute_consume.rule_id and template_id in (708,710);
1106: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1107: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1108: END IF;
1109: IF(initialvalue IS NOT NULL

Line 1106: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;

1102: LOOP
1103: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1104: IF v_contribute_consume.template_id IN (708,710) THEN
1105: Update cz_expression_nodes set template_id=decode(template_id,708 , OPERATOR_ADDSTO , 710 , OPERATOR_SUBTRACTSFROM) where rule_id=v_contribute_consume.rule_id and template_id in (708,710);
1106: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1107: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1108: END IF;
1109: IF(initialvalue IS NOT NULL
1110: AND(p_ps_node_type IN(PS_TYPE_TOTAL, PS_TYPE_RESOURCE) OR(p_ps_node_type = PS_TYPE_FEATURE

Line 1688: SELECT cz_expression_nodes_s.nextval

1684: -- ATAN2 rules will be converted into ATAN.
1685: --Refer section 4.1.4.3
1686: FOR l_atan IN c_atan
1687: LOOP
1688: SELECT cz_expression_nodes_s.nextval
1689: INTO l_expression_node_id
1690: FROM dual;
1691: --Insert new ATAN record
1692:

Line 1751: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;

1747: LOOP
1748:
1749: --make this as a statement rule
1750:
1751: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1752:
1753:
1754: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1755: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))

Line 1755: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))

1751: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1752:
1753:
1754: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1755: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1756: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1757:
1758: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1759: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;

Line 1758: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))

1754: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1755: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1756: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1757:
1758: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1759: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1760:
1761:
1762: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))

Line 1762: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))

1758: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1759: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1760:
1761:
1762: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))
1763: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1764:
1765: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1766: END LOOP;

Line 1765: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;

1761:
1762: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))
1763: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1764:
1765: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1766: END LOOP;
1767:
1768: END LOOP;
1769:

Line 1774: SELECT cz_expression_nodes_s.nextval

1770:
1771:
1772: FOR l_numeric_participant IN c_numeric_participant
1773: LOOP
1774: SELECT cz_expression_nodes_s.nextval
1775: INTO l_expression_node_id
1776: FROM dual;
1777: -- > record
1778:

Line 1803: SELECT cz_expression_nodes_s.nextval

1799: SET expr_parent_id = l_expression_node_id,
1800: seq_nbr = 1
1801: WHERE expr_node_id = l_numeric_participant.exp2id;
1802: -- make count feature child of >
1803: SELECT cz_expression_nodes_s.nextval
1804: INTO l_expression_node_id1
1805: FROM dual;
1806: -- insert 0 record
1807: