[Home] [Help]
47: v_cz_ids_tbl t_ref;
48: v_cz_names_tbl t_ref_num;
49:
50:
51: TYPE t_cz_expression_nodes IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER;
52: v_cz_expression_nodes t_cz_expression_nodes;
53: v_cz_expr_node_count NUMBER(10);
54:
55: TYPE t_cz_rules IS TABLE OF cz_rules%ROWTYPE INDEX BY BINARY_INTEGER;
48: v_cz_names_tbl t_ref_num;
49:
50:
51: TYPE t_cz_expression_nodes IS TABLE OF cz_expression_nodes%ROWTYPE INDEX BY BINARY_INTEGER;
52: v_cz_expression_nodes t_cz_expression_nodes;
53: v_cz_expr_node_count NUMBER(10);
54:
55: TYPE t_cz_rules IS TABLE OF cz_rules%ROWTYPE INDEX BY BINARY_INTEGER;
56: v_cz_rules t_cz_rules ;
157: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
158: RAISE;
159: END findOrCreateRuleFolder;
160:
161: -- procedure to populate CZ tables with data in temporary tables v_cz_rules and v_cz_expression_nodes
162: PROCEDURE populate_cz_tables (commit_all boolean default false) AS
163: l_msg VARCHAR2(2000);
164: l_api_name constant VARCHAR2(30) := 'populate_cz_expression_table';
165: BEGIN
180: INSERT INTO cz_rules
181: VALUES v_cz_rules(v_cz_rules_count);
182: END IF;
183: -- use FORALL statement for bulk insert.
184: IF (v_cz_expression_nodes.LAST IS NOT NULL) THEN
185: for v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST loop
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
181: VALUES v_cz_rules(v_cz_rules_count);
182: END IF;
183: -- use FORALL statement for bulk insert.
184: IF (v_cz_expression_nodes.LAST IS NOT NULL) THEN
185: for v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST loop
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
182: END IF;
183: -- use FORALL statement for bulk insert.
184: IF (v_cz_expression_nodes.LAST IS NOT NULL) THEN
185: for v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST loop
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
183: -- use FORALL statement for bulk insert.
184: IF (v_cz_expression_nodes.LAST IS NOT NULL) THEN
185: for v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST loop
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
191: VALUES v_cz_expression_nodes(v_cz_expr_nodes_count);
185: for v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST loop
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
191: VALUES v_cz_expression_nodes(v_cz_expr_nodes_count);
192: v_cz_expression_nodes.DELETE;
193: END IF;
186: v_cz_expression_nodes(v_cz_expr_nodes_count).seeded_flag:=0;
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
191: VALUES v_cz_expression_nodes(v_cz_expr_nodes_count);
192: v_cz_expression_nodes.DELETE;
193: END IF;
194: IF (v_cz_rules.LAST IS NOT NULL) THEN
187: v_cz_expression_nodes(v_cz_expr_nodes_count).deleted_flag:=0;
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
191: VALUES v_cz_expression_nodes(v_cz_expr_nodes_count);
192: v_cz_expression_nodes.DELETE;
193: END IF;
194: IF (v_cz_rules.LAST IS NOT NULL) THEN
195:
188: end loop;
189: forall v_cz_expr_nodes_count IN v_cz_expression_nodes.FIRST .. v_cz_expression_nodes.LAST
190: INSERT INTO cz_expression_nodes
191: VALUES v_cz_expression_nodes(v_cz_expr_nodes_count);
192: v_cz_expression_nodes.DELETE;
193: END IF;
194: IF (v_cz_rules.LAST IS NOT NULL) THEN
195:
196: FOR v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST LOOP
485: ru.name,
486: ui.ui_def_id,
487: ru.ui_page_element_id,
488: tempel.element_type
489: FROM cz_expression_nodes ex,
490: cz_rules ru,
491: cz_ui_defs ui ,
492: cz_ui_cont_type_templs ct,
493: cz_ui_defs ui2,
593:
594: FOR v_ui IN
595: (SELECT DISTINCT template_id , decode(template_id,820,'NodeUnsatisfied' ,836,'Unsatisfied',849,'SubtreeUnsatisfied') lceprop ,
596: decode(template_id,820,'InputRequired' ,836,'InputRequired',849,'InputRequiredInSubtree') fceprop,ru.name ,ui.ui_def_id, ru.ui_page_element_id
597: FROM cz_expression_nodes ex,
598: cz_rules ru,
599: cz_ui_defs ui
600: WHERE template_id IN(820, 836, 849)
601: AND ex.deleted_flag ='0'
638:
639: FOR v_ui IN
640: (SELECT template_id , (select name from cz_rules where rule_id=template_id) name , REPLACE(REPLACE((select 'Definition'||name from cz_rules where rule_id=template_id),'DefinitionMaxSelected','DefinitionMaxSelections')
641: ,'DefinitionMinSelected','DefinitionMinSelections') ruleName,ui.ui_def_id , ru.ui_page_element_id
642: FROM cz_expression_nodes ex,
643: cz_rules ru,
644: cz_ui_defs ui
645: WHERE template_id IN (894,818,812,847,893,817,811,846,813,814,815,816)
646: AND ex.deleted_flag ='0'
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,
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,
666: cz_rules ru,
667: cz_ui_defs ui
668: WHERE template_id IN (894,818,812,847,893,817,811,846,813,814,815,816)
669: AND ex.deleted_flag ='0'
850: PROCEDURE insertImpliesRuleRecords(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
851: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, l_rule_id IN cz_rules.rule_id%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE) AS
852: l_msg VARCHAR2(2000);
853: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
854: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
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:
851: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, l_rule_id IN cz_rules.rule_id%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE) AS
852: l_msg VARCHAR2(2000);
853: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
854: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
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
852: l_msg VARCHAR2(2000);
853: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
854: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
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
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
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;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
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;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
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;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 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;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
864: -- INSERTING into cz_expression_nodes
865: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
865: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
866: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
867: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
875: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
868: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
875: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
876: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
869: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
870: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
875: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
876: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
877:
871: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
875: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
876: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
877:
878:
879: v_cz_expr_node_count := v_cz_expr_node_count + 1;
872: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
873: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
874:
875: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
876: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
877:
878:
879: v_cz_expr_node_count := v_cz_expr_node_count + 1;
880: --insert initial value record
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;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
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;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
887: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
888: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
896: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
889: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
896: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
897:
890: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
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;
891: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
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
892: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
894: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
895: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
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
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;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
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;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
906: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
907: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
908: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
909: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
910: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';
911: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';
919: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
912: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
913: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';
919: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
920:
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';
919: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
920:
921: --Mark the rule as a default rule
922: populate_cz_tables(true);
923: UPDATE cz_rules
938: --This procedure adds an ADDTO rule for a contribute/consume rule where the initial value of target is not null
939:
940: PROCEDURE createAccumulatorRule(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
941: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.minimum%TYPE,
942: l_rule_id IN cz_rules.rule_id%TYPE ,p_model_ref_expl_id IN cz_expression_nodes.model_ref_expl_id%TYPE,p_feature_type IN cz_ps_nodes.feature_type%TYPE) AS
943: l_msg VARCHAR2(2000);
944: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
945: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
946: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
941: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.minimum%TYPE,
942: l_rule_id IN cz_rules.rule_id%TYPE ,p_model_ref_expl_id IN cz_expression_nodes.model_ref_expl_id%TYPE,p_feature_type IN cz_ps_nodes.feature_type%TYPE) AS
943: l_msg VARCHAR2(2000);
944: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
945: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
946: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
947: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
948: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
949: BEGIN
942: l_rule_id IN cz_rules.rule_id%TYPE ,p_model_ref_expl_id IN cz_expression_nodes.model_ref_expl_id%TYPE,p_feature_type IN cz_ps_nodes.feature_type%TYPE) AS
943: l_msg VARCHAR2(2000);
944: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
945: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
946: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
947: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
948: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
949: BEGIN
950: IF initialvalue IS NOT NULL THEN
943: l_msg VARCHAR2(2000);
944: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
945: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
946: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
947: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
948: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
949: BEGIN
950: IF initialvalue IS NOT NULL THEN
951:
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' ;
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' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
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' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
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' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
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' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
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' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
958: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
959: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
960: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
961: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
969: -- Insert initial value record;
962: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
969: -- Insert initial value record;
970:
963: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
969: -- Insert initial value record;
970:
971:
964: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
966: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
967: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
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;
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:
973: v_cz_expr_node_count:=v_cz_expr_node_count+1;
974:
975:
976:
977: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
974:
975:
976:
977: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
975:
976:
977: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
976:
977: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
977: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
978: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
986:
979: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
986:
987: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
980: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
986:
987: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
988: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
981: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
982: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
986:
987: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
988: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
989: ELSE
984: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
986:
987: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
988: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
989: ELSE
990: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
991: END IF;
992:
986:
987: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
988: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
989: ELSE
990: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
991: END IF;
992:
993: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
994: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
989: ELSE
990: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
991: END IF;
992:
993: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
994: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
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;
990: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
991: END IF;
992:
993: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
994: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
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:
991: END IF;
992:
993: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
994: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
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;
992:
993: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
994: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
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;
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;
1007: END IF;
1008:
1009:
1010:
1011: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1008:
1009:
1010:
1011: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1009:
1010:
1011: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1010:
1011: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1011: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1012: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1013: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1014: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1022:
1015: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1022:
1023: IF ps_node_type=PS_TYPE_TOTAL THEN
1016: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1022:
1023: IF ps_node_type=PS_TYPE_TOTAL THEN
1024: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1017: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1022:
1023: IF ps_node_type=PS_TYPE_TOTAL THEN
1024: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1025: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1020: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1022:
1023: IF ps_node_type=PS_TYPE_TOTAL THEN
1024: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1025: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1026: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1027: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1028: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1022:
1023: IF ps_node_type=PS_TYPE_TOTAL THEN
1024: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1025: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1026: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1027: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1028: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1029: END IF;
1030:
1024: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1025: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1026: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1027: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1028: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1029: END IF;
1030:
1031: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1032: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1027: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1028: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1029: END IF;
1030:
1031: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1032: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1033: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1034: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1035:
1028: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1029: END IF;
1030:
1031: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1032: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1033: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1034: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1035:
1036:
1029: END IF;
1030:
1031: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1032: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1033: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1034: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1035:
1036:
1037: END IF;
1030:
1031: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1032: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1033: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1034: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1035:
1036:
1037: END IF;
1038: EXCEPTION
1059: r.reason_id,
1060: e1.model_ref_expl_id
1061: FROM cz_rules r,
1062: cz_devl_projects p,
1063: cz_expression_nodes e,
1064: cz_expression_nodes e1,
1065: cz_ps_nodes ps
1066: WHERE r.deleted_flag = '0'
1067: AND e.deleted_flag = '0'
1060: e1.model_ref_expl_id
1061: FROM cz_rules r,
1062: cz_devl_projects p,
1063: cz_expression_nodes e,
1064: cz_expression_nodes e1,
1065: cz_ps_nodes ps
1066: WHERE r.deleted_flag = '0'
1067: AND e.deleted_flag = '0'
1068: AND e1.deleted_flag = '0'
1086: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1087: l_has_mult_down_cont_cons boolean;
1088:
1089: l_devl_project_id cz_devl_projects.devl_project_id%type;
1090: l_model_ref_expl_id cz_expression_nodes.model_ref_expl_id%type;
1091:
1092:
1093: ACC_RULE_CREATED boolean;
1094:
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
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
1444:
1445: -- cursor to fetch ATAN2 rules which will be converted into ATAN
1446: CURSOR c_atan IS
1447: SELECT ex.*
1448: FROM cz_expression_nodes ex,
1449: cz_rules ru
1450: WHERE ru.devl_project_id = p_dev_project_id
1451: AND ru.rule_id = ex.rule_id
1452: AND ru.deleted_flag ='0'
1458: SELECT exp1.expr_node_id exp1id,
1459: exp2.expr_node_id exp2id,
1460: exp2.expr_parent_id exp2parentid,
1461: exp2.rule_id , psnode.ps_node_id
1462: FROM cz_expression_nodes exp1,
1463: cz_expression_nodes exp2,
1464: cz_ps_nodes psnode
1465: WHERE exp1.deleted_flag ='0'
1466: AND exp2.deleted_flag ='0'
1459: exp2.expr_node_id exp2id,
1460: exp2.expr_parent_id exp2parentid,
1461: exp2.rule_id , psnode.ps_node_id
1462: FROM cz_expression_nodes exp1,
1463: cz_expression_nodes exp2,
1464: cz_ps_nodes psnode
1465: WHERE exp1.deleted_flag ='0'
1466: AND exp2.deleted_flag ='0'
1467: AND exp1.template_id IN(1, 2, 3, 4, 5)
1470: AND psnode.ps_node_type = PS_TYPE_FEATURE
1471: AND psnode.feature_type = FEATURE_TYPE_INTEGER
1472: AND psnode.minimum >= 0
1473: AND psnode.devl_project_id = p_dev_project_id
1474: AND exists (select 1 from cz_expression_nodes where
1475: expr_node_id=exp2.expr_parent_id
1476: and template_id in ( 306 ,307 ,360 ,552 ,21 ) -- All Logic operators
1477: );
1478:
1480: CURSOR c_compat IS
1481: SELECT DISTINCT cz_rules.rule_id,
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,
1486: cz_expression_nodes exp3
1487: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1488: AND exp1.rule_id = exp2.rule_id
1481: SELECT DISTINCT cz_rules.rule_id,
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,
1486: cz_expression_nodes exp3
1487: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1488: AND exp1.rule_id = exp2.rule_id
1489: AND exp1.rule_id = exp3.rule_id
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,
1486: cz_expression_nodes exp3
1487: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1488: AND exp1.rule_id = exp2.rule_id
1489: AND exp1.rule_id = exp3.rule_id
1490: AND exp3.template_id = 23
1493: AND exp2.expr_type = 207
1494: AND exp1.expr_node_id <> exp2.expr_node_id
1495: AND EXISTS
1496: (SELECT 1
1497: FROM cz_expression_nodes expin1,
1498: cz_expression_nodes expin2,
1499: cz_ps_nodes ps1,
1500: cz_ps_nodes ps2
1501: WHERE expin1.expr_node_id = exp1.expr_parent_id
1494: AND exp1.expr_node_id <> exp2.expr_node_id
1495: AND EXISTS
1496: (SELECT 1
1497: FROM cz_expression_nodes expin1,
1498: cz_expression_nodes expin2,
1499: cz_ps_nodes ps1,
1500: cz_ps_nodes ps2
1501: WHERE expin1.expr_node_id = exp1.expr_parent_id
1502: AND expin2.expr_node_id = exp2.expr_parent_id
1540: CURSOR c_bom_compat IS
1541: SELECT DISTINCT cz_rules.rule_id,
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,
1546: cz_expression_nodes exp3
1547: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1548: AND exp1.rule_id = exp2.rule_id
1541: SELECT DISTINCT cz_rules.rule_id,
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,
1546: cz_expression_nodes exp3
1547: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1548: AND exp1.rule_id = exp2.rule_id
1549: AND exp1.rule_id = exp3.rule_id
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,
1546: cz_expression_nodes exp3
1547: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1548: AND exp1.rule_id = exp2.rule_id
1549: AND exp1.rule_id = exp3.rule_id
1550: AND exp3.template_id = 23
1553: AND exp2.expr_type = 207
1554: AND exp1.expr_node_id <> exp2.expr_node_id
1555: AND EXISTS
1556: (SELECT 1
1557: FROM cz_expression_nodes expin1,
1558: cz_expression_nodes expin2,
1559: cz_ps_nodes ps1,
1560: cz_ps_nodes ps2
1561: WHERE expin1.expr_node_id = exp1.expr_parent_id
1554: AND exp1.expr_node_id <> exp2.expr_node_id
1555: AND EXISTS
1556: (SELECT 1
1557: FROM cz_expression_nodes expin1,
1558: cz_expression_nodes expin2,
1559: cz_ps_nodes ps1,
1560: cz_ps_nodes ps2
1561: WHERE expin1.expr_node_id = exp1.expr_parent_id
1562: AND expin2.expr_node_id = exp2.expr_parent_id
1582: AND rule.rule_id = cf.rule_id
1583: AND rule_type IN(24,30);
1584:
1585: l_atan c_atan % rowtype;
1586: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
1587: l_api_name constant VARCHAR2(30) := 'convertRules';
1588: l_numeric_participant c_numeric_participant%rowtype;
1589: minseq NUMBER;
1590: maxseq NUMBER;
1587: l_api_name constant VARCHAR2(30) := 'convertRules';
1588: l_numeric_participant c_numeric_participant%rowtype;
1589: minseq NUMBER;
1590: maxseq NUMBER;
1591: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
1592: l_ps_node_name cz_ps_nodes.name%type;
1593: l_msg VARCHAR2(2000);
1594: l_cz_rules_id cz_rules.rule_id%TYPE;
1595: BEGIN
1595: BEGIN
1596:
1597: --Bug 6725690 , convert ZDIV operator to divide (/) operator.
1598:
1599: UPDATE cz_expression_nodes
1600: SET template_id = 408
1601: WHERE template_id = 404
1602: AND rule_id IN
1603: (SELECT rule_id
1618:
1619: -- DEFAULTS rules will be converted into IMPLIES, with default rule type indicator
1620: --Refer section 4.1.4.1.
1621:
1622: UPDATE cz_expression_nodes
1623: SET template_id = 2
1624: WHERE template_id = 5
1625: AND rule_id IN
1626: (SELECT rule_id
1656:
1657: -- NotTrue rules will be converted into NOT.
1658: --Refer section 4.1.4.2
1659:
1660: UPDATE cz_expression_nodes
1661: SET template_id = 552
1662: WHERE template_id = 360
1663: AND rule_id IN
1664: (SELECT rule_id
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:
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 ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
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 ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
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 ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
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 ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1694: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1695: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1696: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1697: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1698: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1699: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1700: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1708:
1701: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1708:
1709:
1702: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1708:
1709:
1710: --update Atan2 to DIV record
1703: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1704: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1705: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1706: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1708:
1709:
1710: --update Atan2 to DIV record
1711: UPDATE cz_expression_nodes
1707: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1708:
1709:
1710: --update Atan2 to DIV record
1711: UPDATE cz_expression_nodes
1712: SET template_id = 408,
1713: expr_parent_id = l_expression_node_id
1714: WHERE expr_node_id = l_atan.expr_node_id;
1715: displayMessage(2,p_dev_project_id , 'RULE' ,l_atan.rule_id,l_api_name,'CZ_CNV_WARN_ATAN2_REMOVED');
1723:
1724: ---make this logic rule a statement rule
1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1726: (SELECT exp2.rule_id
1727: FROM cz_expression_nodes exp1,
1728: cz_expression_nodes exp2,
1729: cz_ps_nodes psnode
1730: WHERE exp1.deleted_flag ='0'
1731: AND exp2.deleted_flag ='0'
1724: ---make this logic rule a statement rule
1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1726: (SELECT exp2.rule_id
1727: FROM cz_expression_nodes exp1,
1728: cz_expression_nodes exp2,
1729: cz_ps_nodes psnode
1730: WHERE exp1.deleted_flag ='0'
1731: AND exp2.deleted_flag ='0'
1732: AND exp1.template_id IN(1, 2, 3, 4, 5)
1742: FOR l_numeric_participant IN c_numeric_participant
1743: LOOP
1744:
1745:
1746: FOR c_cur IN (select 1 from cz_expression_nodes czr where czr.rule_id=l_numeric_participant.rule_id and czr.template_id=21) --Just to check that this is logic rule , will loop only once
1747: LOOP
1748:
1749: --make this as a statement rule
1750:
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))
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))
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))
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;
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))
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;
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:
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:
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 ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
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 ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
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 ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
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 ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1780: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1781: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1782: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1783: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1784: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1785: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1793: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1786: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1793: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1794:
1787: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1793: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1794:
1795:
1788: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1793: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1794:
1795:
1796:
1789: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1790: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1791: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1792: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1793: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1794:
1795:
1796:
1797:
1794:
1795:
1796:
1797:
1798: UPDATE cz_expression_nodes
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 >
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:
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 ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
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 ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
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 ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
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 ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1822:
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1822:
1823:
1816: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1822:
1823:
1824: -- insert record for const 0 under > record
1817: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1819: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1820: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1822:
1823:
1824: -- insert record for const 0 under > record
1825: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1823:
1824: -- insert record for const 0 under > record
1825: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1826: displayMessage(3,p_dev_project_id , 'RULE' ,l_numeric_participant.rule_id ,l_api_name,'CZ_CNV_ADV_NUM_IN_LOGIC','NODENAME1', l_ps_node_name,'NODENAME2', l_ps_node_name);
1827: DELETE FROM cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id=21;
1828: populate_cz_tables(true);
1829: cz_rule_text_gen.parse_rules(p_dev_project_id, l_numeric_participant.rule_id);
1830: END LOOP;
1831:
1853:
1854:
1855: --fetch Event bindings bound to the onValidateEligibleTarget event
1856:
1857: UPDATE cz_expression_nodes
1858: SET deleted_flag = '1'
1859: WHERE expr_node_id
1860: IN (
1861: SELECT expr_node_id
1858: SET deleted_flag = '1'
1859: WHERE expr_node_id
1860: IN (
1861: SELECT expr_node_id
1862: FROM cz_rules czrules ,cz_expression_nodes EXP
1863: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1864: and expr_type = 216
1865: AND EXP.rule_id = czrules.rule_id
1866: AND EXP.argument_signature_id = 2204
1883:
1884: SELECT DISTINCT czrules.rule_id
1885: BULK COLLECT INTO v_cz_ids_tbl
1886: FROM cz_rules czrules,
1887: cz_expression_nodes exp
1888: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1889: AND expr_type = 216
1890: AND exp.rule_id = czrules.rule_id
1891: AND czrules.deleted_flag = '0'
1912: FOR v_rule_ids IN (
1913: SELECT czrules.rule_id,
1914: expout.expr_node_id
1915: FROM cz_rules czrules,
1916: cz_expression_nodes expout
1917: WHERE czrules.rule_type = RULE_TYPE_CONFIGURATION_EXT
1918: AND czrules.rule_id = expout.rule_id
1919: AND EXISTS
1920: (SELECT 1
1917: WHERE czrules.rule_type = RULE_TYPE_CONFIGURATION_EXT
1918: AND czrules.rule_id = expout.rule_id
1919: AND EXISTS
1920: (SELECT 1
1921: FROM cz_expression_nodes EXP
1922: WHERE EXP.expr_type = 216
1923: AND EXP.rule_id = czrules.rule_id
1924: AND EXP.argument_signature_id IN(2209, --postInstanceAdd
1925: 2210, --postInstanceDelete
2038: BEGIN
2039:
2040:
2041: v_cz_expr_node_count := 0;
2042: v_cz_expression_nodes.DELETE;
2043:
2044: v_cz_rule_count := 0;
2045: V_CZ_RULES.DELETE;
2046:
2130: ***************/
2131: END LOOP;
2132: --Do Cleanup
2133: v_cz_expr_node_count := 0;
2134: v_cz_expression_nodes.DELETE;
2135: v_cz_rule_count := 0;
2136: V_CZ_RULES.DELETE;
2137: v_model_conversion_set_id:=NULL;
2138: EXCEPTION
2137: v_model_conversion_set_id:=NULL;
2138: EXCEPTION
2139: WHEN others THEN
2140: v_cz_expr_node_count := 0;
2141: v_cz_expression_nodes.DELETE;
2142: v_cz_rule_count := 0;
2143: V_CZ_RULES.DELETE;
2144: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2145: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);