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 DUAL

Line 251: FROM dual

247: ,0
248: ,'0'
249: ,'0'
250: ,'0'
251: FROM dual
252: WHERE NOT EXISTS
253: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS
254: WHERE ui_def_id=i.ui_def_id AND content_type=l_cont_types_tbl(j));
255: END LOOP;

Line 775: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM DUAL;

771: BEGIN
772: IF((last_id_allocated IS NULL) OR
773: (next_id_to_use = (NVL(last_id_allocated, 0) + CZ_SEQUENCE_INCREMENT)))THEN
774:
775: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM DUAL;
776: next_id_to_use := last_id_allocated;
777: END IF;
778:
779: id_to_return := next_id_to_use;

Line 799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;

795:
796: l_rule_id:=next_rule_id;
797:
798: -- kdande; 10-Jan-2008; Bug 6730553; Changed cz_localized_texts_s to cz_intl_texts_s as cz_localized_texts_s is obsolete.
799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;
800:
801: SELECT name , nvl(initial_value, initial_num_value ) INTO l_ps_node_name , initialvalue from cz_ps_nodes where ps_node_id=p_ps_node_id;
802:
803: -- INSERTING into cz_rules

Line 867: FROM dual;

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
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;

Line 889: FROM dual;

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;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;

Line 908: FROM dual;

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;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;

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 1717: FROM dual;

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:
1720: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;

Line 1803: FROM dual;

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:
1806: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;

Line 1832: FROM dual;

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:
1835: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;