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

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

Line 883: FROM dual;

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

Line 902: FROM dual;

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

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

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

Line 1776: FROM dual;

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

Line 1805: FROM dual;

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