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.

[Home] [Help]

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 865: SELECT cz_expression_nodes_s.nextval

861: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
862: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
863: BEGIN
864:
865: SELECT cz_expression_nodes_s.nextval
866: INTO l_expression_node_id
867: FROM dual;
868: v_cz_expr_node_count := v_cz_expr_node_count + 1;
869: --insert the implies record

Line 887: SELECT cz_expression_nodes_s.nextval

883:
884:
885: v_cz_expr_node_count := v_cz_expr_node_count + 1;
886: --insert initial value record
887: SELECT cz_expression_nodes_s.nextval
888: INTO l_expression_node_id1
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;

Line 906: SELECT cz_expression_nodes_s.nextval

902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
904: v_cz_expr_node_count := v_cz_expr_node_count + 1;
905: --insert boolean feature record
906: SELECT cz_expression_nodes_s.nextval
907: INTO l_expression_node_id1
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;

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

956: IF initialvalue IS NOT NULL THEN
957:
958: -- Insert AddTo expression record;
959:
960: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;
961: v_cz_expr_node_count:=v_cz_expr_node_count+1;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;

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

974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
976:
977:
978: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
979: v_cz_expr_node_count:=v_cz_expr_node_count+1;
980:
981:
982:

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

1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
1004:
1005: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
1006: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1007:
1008: IF p_model_ref_expl_id IS NULL THEN
1009: l_ps_node_id :=ps_node_id;

Line 1111: 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);

1107: FOR v_contribute_consume IN c_contrib_consume
1108: LOOP
1109: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1110: IF v_contribute_consume.template_id IN (708,710) THEN
1111: 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);
1112: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1113: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1114: END IF;
1115: IF(initialvalue IS NOT NULL

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

1108: LOOP
1109: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1110: IF v_contribute_consume.template_id IN (708,710) THEN
1111: 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);
1112: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1113: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1114: END IF;
1115: IF(initialvalue IS NOT NULL
1116: AND(p_ps_node_type IN(PS_TYPE_TOTAL, PS_TYPE_RESOURCE) OR(p_ps_node_type = PS_TYPE_FEATURE

Line 1715: SELECT cz_expression_nodes_s.nextval

1711: -- ATAN2 rules will be converted into ATAN.
1712: --Refer section 4.1.4.3
1713: FOR l_atan IN c_atan
1714: LOOP
1715: SELECT cz_expression_nodes_s.nextval
1716: INTO l_expression_node_id
1717: FROM dual;
1718: --Insert new ATAN record
1719:

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

1774: LOOP
1775:
1776: --make this as a statement rule
1777:
1778: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1779:
1780:
1781: 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);
1782: 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 1782: 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))

1778: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1779:
1780:
1781: 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);
1782: 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))
1783: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1784:
1785: 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))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;

Line 1785: 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))

1781: 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);
1782: 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))
1783: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1784:
1785: 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))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1787:
1788:
1789: 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 1789: 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))

1785: 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))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1787:
1788:
1789: 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))
1790: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1791:
1792: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1793: END LOOP;

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

1788:
1789: 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))
1790: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1791:
1792: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1793: END LOOP;
1794:
1795: END LOOP;
1796:

Line 1801: SELECT cz_expression_nodes_s.nextval

1797:
1798:
1799: FOR l_numeric_participant IN c_numeric_participant
1800: LOOP
1801: SELECT cz_expression_nodes_s.nextval
1802: INTO l_expression_node_id
1803: FROM dual;
1804: -- > record
1805:

Line 1830: SELECT cz_expression_nodes_s.nextval

1826: SET expr_parent_id = l_expression_node_id,
1827: seq_nbr = 1
1828: WHERE expr_node_id = l_numeric_participant.exp2id;
1829: -- make count feature child of >
1830: SELECT cz_expression_nodes_s.nextval
1831: INTO l_expression_node_id1
1832: FROM dual;
1833: -- insert 0 record
1834: