[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'
802:
803: -- INSERTING into cz_rules
804: -- BUG9176281 -
805: -- If you call populate_cz_tables() after inserting the data in v_cz_rules - it will create a Rule with
806: -- blank CDL as the v_cz_expression_nodes is not yet populated with required data.
807:
808: populate_cz_tables();
809:
810: -- End Fixing BUG9176281
856: PROCEDURE insertImpliesRuleRecords(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
857: 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
858: l_msg VARCHAR2(2000);
859: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
860: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
861: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
862: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
863: BEGIN
864:
857: 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
858: l_msg VARCHAR2(2000);
859: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
860: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
861: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
862: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
863: BEGIN
864:
865: SELECT cz_expression_nodes_s.nextval
858: l_msg VARCHAR2(2000);
859: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
860: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
861: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
862: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
863: BEGIN
864:
865: SELECT cz_expression_nodes_s.nextval
866: INTO l_expression_node_id
861: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
862: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%TYPE;
863: BEGIN
864:
865: SELECT cz_expression_nodes_s.nextval
866: INTO l_expression_node_id
867: FROM dual;
868: v_cz_expr_node_count := v_cz_expr_node_count + 1;
869: --insert the implies record
866: INTO l_expression_node_id
867: FROM dual;
868: v_cz_expr_node_count := v_cz_expr_node_count + 1;
869: --insert the implies record
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
867: FROM dual;
868: v_cz_expr_node_count := v_cz_expr_node_count + 1;
869: --insert the implies record
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
868: v_cz_expr_node_count := v_cz_expr_node_count + 1;
869: --insert the implies record
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
869: --insert the implies record
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
870: -- INSERTING into cz_expression_nodes
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
871: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
872: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
873: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 200;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
881: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
874: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 8;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
881: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
882: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
875: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
876: v_cz_expression_nodes(v_cz_expr_node_count).template_id := 1;
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
881: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
882: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
883:
877: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 0;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
881: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
882: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
883:
884:
885: v_cz_expr_node_count := v_cz_expr_node_count + 1;
878: v_cz_expression_nodes(v_cz_expr_node_count).collection_flag := 0;
879: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
880:
881: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 7;
882: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 7;
883:
884:
885: v_cz_expr_node_count := v_cz_expr_node_count + 1;
886: --insert initial value record
883:
884:
885: v_cz_expr_node_count := v_cz_expr_node_count + 1;
886: --insert initial value record
887: SELECT cz_expression_nodes_s.nextval
888: INTO l_expression_node_id1
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
886: --insert initial value record
887: SELECT cz_expression_nodes_s.nextval
888: INTO l_expression_node_id1
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
887: SELECT cz_expression_nodes_s.nextval
888: INTO l_expression_node_id1
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
888: INTO l_expression_node_id1
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
889: FROM dual;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
890: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
891: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 1;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
892: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
893: v_cz_expression_nodes(v_cz_expr_node_count).data_value := initialvalue;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
894: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 201;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
895: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 7;
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
896: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
904: v_cz_expr_node_count := v_cz_expr_node_count + 1;
897: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
904: v_cz_expr_node_count := v_cz_expr_node_count + 1;
905: --insert boolean feature record
898: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 1;
899: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 3;
900: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := 0;
901: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 1;
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
904: v_cz_expr_node_count := v_cz_expr_node_count + 1;
905: --insert boolean feature record
906: SELECT cz_expression_nodes_s.nextval
902: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 4;
903:
904: v_cz_expr_node_count := v_cz_expr_node_count + 1;
905: --insert boolean feature record
906: SELECT cz_expression_nodes_s.nextval
907: INTO l_expression_node_id1
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
905: --insert boolean feature record
906: SELECT cz_expression_nodes_s.nextval
907: INTO l_expression_node_id1
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
906: SELECT cz_expression_nodes_s.nextval
907: INTO l_expression_node_id1
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
907: INTO l_expression_node_id1
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
908: FROM dual;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
909: v_cz_expression_nodes(v_cz_expr_node_count).expr_node_id := l_expression_node_id1;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
910: v_cz_expression_nodes(v_cz_expr_node_count).seq_nbr := 2;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
911: v_cz_expression_nodes(v_cz_expr_node_count).ps_node_id := ps_node_id;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
912: v_cz_expression_nodes(v_cz_expr_node_count).expr_parent_id := l_expression_node_id;
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
913: v_cz_expression_nodes(v_cz_expr_node_count).expr_type := 205;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
914: v_cz_expression_nodes(v_cz_expr_node_count).token_list_seq := 15;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
915: v_cz_expression_nodes(v_cz_expr_node_count).rule_id := l_rule_id;
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
916: v_cz_expression_nodes(v_cz_expr_node_count).param_signature_id := 81;
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
924: 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';
917: v_cz_expression_nodes(v_cz_expr_node_count).param_index := 2;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
924: 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';
925: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
918: v_cz_expression_nodes(v_cz_expr_node_count).data_type := 502;
919: v_cz_expression_nodes(v_cz_expr_node_count).display_node_depth := 1;
920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
924: 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';
925: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
926:
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
924: 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';
925: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
926:
927: --Mark the rule as a default rule
928: populate_cz_tables(true);
929: UPDATE cz_rules
944: --This procedure adds an ADDTO rule for a contribute/consume rule where the initial value of target is not null
945:
946: PROCEDURE createAccumulatorRule(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
947: 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,
948: 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
949: l_msg VARCHAR2(2000);
950: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
952: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
947: 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,
948: 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
949: l_msg VARCHAR2(2000);
950: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
952: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
953: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
954: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
955: BEGIN
948: 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
949: l_msg VARCHAR2(2000);
950: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
952: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
953: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
954: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
955: BEGIN
956: IF initialvalue IS NOT NULL THEN
949: l_msg VARCHAR2(2000);
950: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
952: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
953: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
954: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
955: BEGIN
956: IF initialvalue IS NOT NULL THEN
957:
956: IF initialvalue IS NOT NULL THEN
957:
958: -- Insert AddTo expression record;
959:
960: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;
961: v_cz_expr_node_count:=v_cz_expr_node_count+1;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
959:
960: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;
961: v_cz_expr_node_count:=v_cz_expr_node_count+1;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
960: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id FROM dual;
961: v_cz_expr_node_count:=v_cz_expr_node_count+1;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
961: v_cz_expr_node_count:=v_cz_expr_node_count+1;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
962:
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
963: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
964: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
965: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
966: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '1' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
967: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
968: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
976:
969: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= OPERATOR_ADDSTO ;
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
976:
977:
970: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '0' ;
971: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
972: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '1' ;
973: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '10' ;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
976:
977:
978: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
974: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
975: -- Insert initial value record;
976:
977:
978: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
979: v_cz_expr_node_count:=v_cz_expr_node_count+1;
980:
981:
982:
979: v_cz_expr_node_count:=v_cz_expr_node_count+1;
980:
981:
982:
983: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
980:
981:
982:
983: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
981:
982:
983: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
982:
983: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
983: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
984: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
992:
985: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
992:
993: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
986: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '201' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
992:
993: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
994: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
987: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
988: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
989: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
992:
993: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
994: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
995: ELSE
990: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
991: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
992:
993: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
994: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
995: ELSE
996: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
997: END IF;
998:
992:
993: IF p_feature_type=FEATURE_TYPE_FLOAT THEN
994: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
995: ELSE
996: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
997: END IF;
998:
999: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
1000: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
995: ELSE
996: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
997: END IF;
998:
999: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
1000: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
996: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '1' ;
997: END IF;
998:
999: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
1000: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
1004:
997: END IF;
998:
999: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
1000: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
1004:
1005: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
998:
999: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '13' ;
1000: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '1' ;
1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
1004:
1005: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
1006: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1001: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1002: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE:= initialvalue ;
1003: -- Insert record for ps_node_id, ps_node_type;
1004:
1005: SELECT cz_expression_nodes_s.nextval INTO l_expression_node_id1 FROM dual;
1006: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1007:
1008: IF p_model_ref_expl_id IS NULL THEN
1009: l_ps_node_id :=ps_node_id;
1013: END IF;
1014:
1015:
1016:
1017: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1014:
1015:
1016:
1017: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1015:
1016:
1017: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1016:
1017: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1017: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id1 ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1018: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '2' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1019: v_cz_expression_nodes(v_cz_expr_node_count).PS_NODE_ID:= ps_node_id ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1020: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_expression_node_id ;
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1028:
1021: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '205' ;
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1028:
1029: IF ps_node_type=PS_TYPE_TOTAL THEN
1022: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '9' ;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1028:
1029: IF ps_node_type=PS_TYPE_TOTAL THEN
1030: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1023: v_cz_expression_nodes(v_cz_expr_node_count).DELETED_FLAG:= '0' ;
1024: v_cz_expression_nodes(v_cz_expr_node_count).MODEL_REF_EXPL_ID:= l_mod_ref ;
1025: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_rule_id ;
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1028:
1029: IF ps_node_type=PS_TYPE_TOTAL THEN
1030: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1031: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1026: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='96' ;
1027: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '2' ;
1028:
1029: IF ps_node_type=PS_TYPE_TOTAL THEN
1030: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1031: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1032: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1033: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1034: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1028:
1029: IF ps_node_type=PS_TYPE_TOTAL THEN
1030: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1031: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1032: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1033: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1034: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1035: END IF;
1036:
1030: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.TOTAL_TYPEID;
1031: ELSIF ps_node_type=PS_TYPE_RESOURCE THEN
1032: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.RESOURCE_TYPEID;
1033: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1034: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1035: END IF;
1036:
1037: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1038: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1033: ELSIF ps_node_type=PS_TYPE_FEATURE and p_feature_type=FEATURE_TYPE_FLOAT THEN
1034: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1035: END IF;
1036:
1037: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1038: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1039: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1040: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1041:
1034: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:=CZ_TYPES.DECIMAL_FEATURE_TYPEID;
1035: END IF;
1036:
1037: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1038: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1039: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1040: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1041:
1042:
1035: END IF;
1036:
1037: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1038: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1039: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1040: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1041:
1042:
1043: END IF;
1036:
1037: v_cz_expression_nodes(v_cz_expr_node_count).DISPLAY_NODE_DEPTH:='1' ;
1038: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '18' ;
1039: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '14' ;
1040: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '1' ;
1041:
1042:
1043: END IF;
1044: EXCEPTION
1065: r.reason_id,
1066: e1.model_ref_expl_id
1067: FROM cz_rules r,
1068: cz_devl_projects p,
1069: cz_expression_nodes e,
1070: cz_expression_nodes e1,
1071: cz_ps_nodes ps
1072: WHERE r.deleted_flag = '0'
1073: AND e.deleted_flag = '0'
1066: e1.model_ref_expl_id
1067: FROM cz_rules r,
1068: cz_devl_projects p,
1069: cz_expression_nodes e,
1070: cz_expression_nodes e1,
1071: cz_ps_nodes ps
1072: WHERE r.deleted_flag = '0'
1073: AND e.deleted_flag = '0'
1074: AND e1.deleted_flag = '0'
1092: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1093: l_has_mult_down_cont_cons boolean;
1094:
1095: l_devl_project_id cz_devl_projects.devl_project_id%type;
1096: l_model_ref_expl_id cz_expression_nodes.model_ref_expl_id%type;
1097:
1098:
1099: ACC_RULE_CREATED boolean;
1100:
1107: FOR v_contribute_consume IN c_contrib_consume
1108: LOOP
1109: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1110: IF v_contribute_consume.template_id IN (708,710) THEN
1111: Update cz_expression_nodes set template_id=decode(template_id,708 , OPERATOR_ADDSTO , 710 , OPERATOR_SUBTRACTSFROM) where rule_id=v_contribute_consume.rule_id and template_id in (708,710);
1112: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1113: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1114: END IF;
1115: IF(initialvalue IS NOT NULL
1108: LOOP
1109: displayMessage(3,p_devl_project_id , 'RULE' ,v_contribute_consume.rule_id,l_api_name,'CZ_CNV_CONT_CONS_TO_ADD_SUB');
1110: IF v_contribute_consume.template_id IN (708,710) THEN
1111: Update cz_expression_nodes set template_id=decode(template_id,708 , OPERATOR_ADDSTO , 710 , OPERATOR_SUBTRACTSFROM) where rule_id=v_contribute_consume.rule_id and template_id in (708,710);
1112: Update cz_expression_nodes set template_id=25 where rule_id=v_contribute_consume.rule_id and template_id =22;
1113: cz_rule_text_gen.parse_rules(v_contribute_consume.devl_project_id, v_contribute_consume.rule_id);
1114: END IF;
1115: IF(initialvalue IS NOT NULL
1116: AND(p_ps_node_type IN(PS_TYPE_TOTAL, PS_TYPE_RESOURCE) OR(p_ps_node_type = PS_TYPE_FEATURE
1471:
1472: -- cursor to fetch ATAN2 rules which will be converted into ATAN
1473: CURSOR c_atan IS
1474: SELECT ex.*
1475: FROM cz_expression_nodes ex,
1476: cz_rules ru
1477: WHERE ru.devl_project_id = p_dev_project_id
1478: AND ru.rule_id = ex.rule_id
1479: AND ru.deleted_flag ='0'
1485: SELECT exp1.expr_node_id exp1id,
1486: exp2.expr_node_id exp2id,
1487: exp2.expr_parent_id exp2parentid,
1488: exp2.rule_id , psnode.ps_node_id
1489: FROM cz_expression_nodes exp1,
1490: cz_expression_nodes exp2,
1491: cz_ps_nodes psnode
1492: WHERE exp1.deleted_flag ='0'
1493: AND exp2.deleted_flag ='0'
1486: exp2.expr_node_id exp2id,
1487: exp2.expr_parent_id exp2parentid,
1488: exp2.rule_id , psnode.ps_node_id
1489: FROM cz_expression_nodes exp1,
1490: cz_expression_nodes exp2,
1491: cz_ps_nodes psnode
1492: WHERE exp1.deleted_flag ='0'
1493: AND exp2.deleted_flag ='0'
1494: AND exp1.template_id IN(1, 2, 3, 4, 5)
1497: AND psnode.ps_node_type = PS_TYPE_FEATURE
1498: AND psnode.feature_type = FEATURE_TYPE_INTEGER
1499: AND psnode.minimum >= 0
1500: AND psnode.devl_project_id = p_dev_project_id
1501: AND exists (select 1 from cz_expression_nodes where
1502: expr_node_id=exp2.expr_parent_id
1503: and template_id in ( 306 ,307 ,360 ,552 ,21 ) -- All Logic operators
1504: );
1505:
1507: CURSOR c_compat IS
1508: SELECT DISTINCT cz_rules.rule_id,
1509: cz_rules.devl_project_id
1510: FROM cz_rules,
1511: cz_expression_nodes exp1,
1512: cz_expression_nodes exp2,
1513: cz_expression_nodes exp3
1514: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1515: AND exp1.rule_id = exp2.rule_id
1508: SELECT DISTINCT cz_rules.rule_id,
1509: cz_rules.devl_project_id
1510: FROM cz_rules,
1511: cz_expression_nodes exp1,
1512: cz_expression_nodes exp2,
1513: cz_expression_nodes exp3
1514: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1515: AND exp1.rule_id = exp2.rule_id
1516: AND exp1.rule_id = exp3.rule_id
1509: cz_rules.devl_project_id
1510: FROM cz_rules,
1511: cz_expression_nodes exp1,
1512: cz_expression_nodes exp2,
1513: cz_expression_nodes exp3
1514: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1515: AND exp1.rule_id = exp2.rule_id
1516: AND exp1.rule_id = exp3.rule_id
1517: AND exp3.template_id = 23
1520: AND exp2.expr_type = 207
1521: AND exp1.expr_node_id <> exp2.expr_node_id
1522: AND EXISTS
1523: (SELECT 1
1524: FROM cz_expression_nodes expin1,
1525: cz_expression_nodes expin2,
1526: cz_ps_nodes ps1,
1527: cz_ps_nodes ps2
1528: WHERE expin1.expr_node_id = exp1.expr_parent_id
1521: AND exp1.expr_node_id <> exp2.expr_node_id
1522: AND EXISTS
1523: (SELECT 1
1524: FROM cz_expression_nodes expin1,
1525: cz_expression_nodes expin2,
1526: cz_ps_nodes ps1,
1527: cz_ps_nodes ps2
1528: WHERE expin1.expr_node_id = exp1.expr_parent_id
1529: AND expin2.expr_node_id = exp2.expr_parent_id
1567: CURSOR c_bom_compat IS
1568: SELECT DISTINCT cz_rules.rule_id,
1569: cz_rules.devl_project_id
1570: FROM cz_rules,
1571: cz_expression_nodes exp1,
1572: cz_expression_nodes exp2,
1573: cz_expression_nodes exp3
1574: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1575: AND exp1.rule_id = exp2.rule_id
1568: SELECT DISTINCT cz_rules.rule_id,
1569: cz_rules.devl_project_id
1570: FROM cz_rules,
1571: cz_expression_nodes exp1,
1572: cz_expression_nodes exp2,
1573: cz_expression_nodes exp3
1574: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1575: AND exp1.rule_id = exp2.rule_id
1576: AND exp1.rule_id = exp3.rule_id
1569: cz_rules.devl_project_id
1570: FROM cz_rules,
1571: cz_expression_nodes exp1,
1572: cz_expression_nodes exp2,
1573: cz_expression_nodes exp3
1574: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1575: AND exp1.rule_id = exp2.rule_id
1576: AND exp1.rule_id = exp3.rule_id
1577: AND exp3.template_id = 23
1580: AND exp2.expr_type = 207
1581: AND exp1.expr_node_id <> exp2.expr_node_id
1582: AND EXISTS
1583: (SELECT 1
1584: FROM cz_expression_nodes expin1,
1585: cz_expression_nodes expin2,
1586: cz_ps_nodes ps1,
1587: cz_ps_nodes ps2
1588: WHERE expin1.expr_node_id = exp1.expr_parent_id
1581: AND exp1.expr_node_id <> exp2.expr_node_id
1582: AND EXISTS
1583: (SELECT 1
1584: FROM cz_expression_nodes expin1,
1585: cz_expression_nodes expin2,
1586: cz_ps_nodes ps1,
1587: cz_ps_nodes ps2
1588: WHERE expin1.expr_node_id = exp1.expr_parent_id
1589: AND expin2.expr_node_id = exp2.expr_parent_id
1609: AND rule.rule_id = cf.rule_id
1610: AND rule_type IN(24,30);
1611:
1612: l_atan c_atan % rowtype;
1613: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
1614: l_api_name constant VARCHAR2(30) := 'convertRules';
1615: l_numeric_participant c_numeric_participant%rowtype;
1616: minseq NUMBER;
1617: maxseq NUMBER;
1614: l_api_name constant VARCHAR2(30) := 'convertRules';
1615: l_numeric_participant c_numeric_participant%rowtype;
1616: minseq NUMBER;
1617: maxseq NUMBER;
1618: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
1619: l_ps_node_name cz_ps_nodes.name%type;
1620: l_msg VARCHAR2(2000);
1621: l_cz_rules_id cz_rules.rule_id%TYPE;
1622: BEGIN
1622: BEGIN
1623:
1624: --Bug 6725690 , convert ZDIV operator to divide (/) operator.
1625:
1626: UPDATE cz_expression_nodes
1627: SET template_id = 408
1628: WHERE template_id = 404
1629: AND rule_id IN
1630: (SELECT rule_id
1645:
1646: -- DEFAULTS rules will be converted into IMPLIES, with default rule type indicator
1647: --Refer section 4.1.4.1.
1648:
1649: UPDATE cz_expression_nodes
1650: SET template_id = 2
1651: WHERE template_id = 5
1652: AND rule_id IN
1653: (SELECT rule_id
1683:
1684: -- NotTrue rules will be converted into NOT.
1685: --Refer section 4.1.4.2
1686:
1687: UPDATE cz_expression_nodes
1688: SET template_id = 552
1689: WHERE template_id = 360
1690: AND rule_id IN
1691: (SELECT rule_id
1711: -- ATAN2 rules will be converted into ATAN.
1712: --Refer section 4.1.4.3
1713: FOR l_atan IN c_atan
1714: LOOP
1715: SELECT cz_expression_nodes_s.nextval
1716: INTO l_expression_node_id
1717: FROM dual;
1718: --Insert new ATAN record
1719:
1717: FROM dual;
1718: --Insert new ATAN record
1719:
1720: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1718: --Insert new ATAN record
1719:
1720: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1719:
1720: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1720: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1721: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID:= l_expression_node_id ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1722: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR:= '1' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1723: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID:= l_atan.expr_parent_id ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1724: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE:= '200' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1725: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ:= '8' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1726: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID:= l_atan.rule_id ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1727: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID:= '438' ;
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1735:
1728: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID:='91' ;
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1735:
1736:
1729: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX:= '1' ;
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1735:
1736:
1737: --update Atan2 to DIV record
1730: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE:= '2' ;
1731: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG:= '0' ;
1732: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET:= '12' ;
1733: v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH:= '4' ;
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1735:
1736:
1737: --update Atan2 to DIV record
1738: UPDATE cz_expression_nodes
1734: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG:= '0' ;
1735:
1736:
1737: --update Atan2 to DIV record
1738: UPDATE cz_expression_nodes
1739: SET template_id = 408,
1740: expr_parent_id = l_expression_node_id
1741: WHERE expr_node_id = l_atan.expr_node_id;
1742: displayMessage(2,p_dev_project_id , 'RULE' ,l_atan.rule_id,l_api_name,'CZ_CNV_WARN_ATAN2_REMOVED');
1750:
1751: ---make this logic rule a statement rule
1752: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1753: (SELECT exp2.rule_id
1754: FROM cz_expression_nodes exp1,
1755: cz_expression_nodes exp2,
1756: cz_ps_nodes psnode
1757: WHERE exp1.deleted_flag ='0'
1758: AND exp2.deleted_flag ='0'
1751: ---make this logic rule a statement rule
1752: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1753: (SELECT exp2.rule_id
1754: FROM cz_expression_nodes exp1,
1755: cz_expression_nodes exp2,
1756: cz_ps_nodes psnode
1757: WHERE exp1.deleted_flag ='0'
1758: AND exp2.deleted_flag ='0'
1759: AND exp1.template_id IN(1, 2, 3, 4, 5)
1769: FOR l_numeric_participant IN c_numeric_participant
1770: LOOP
1771:
1772:
1773: 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
1774: LOOP
1775:
1776: --make this as a statement rule
1777:
1774: LOOP
1775:
1776: --make this as a statement rule
1777:
1778: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1779:
1780:
1781: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1782: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1777:
1778: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1779:
1780:
1781: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1782: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1783: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1784:
1785: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1778: update cz_expression_nodes set expr_type=200 where expr_type=222 and rule_id=l_numeric_participant.rule_id;
1779:
1780:
1781: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1782: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1783: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1784:
1785: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1781: select min(seq_nbr) ,max(seq_nbr) into minseq, maxseq from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id in (306,307);
1782: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=minseq and template_id in (306,307))
1783: where rule_id= l_numeric_participant.rule_id and seq_nbr between minseq+1 and maxseq-2 ;
1784:
1785: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1787:
1788:
1789: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))
1785: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq and template_id in (306,307))
1786: where rule_id= l_numeric_participant.rule_id and seq_nbr >maxseq;
1787:
1788:
1789: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))
1790: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1791:
1792: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1793: END LOOP;
1788:
1789: update cz_expression_nodes set expr_parent_id=(select expr_node_id from cz_expression_nodes where rule_id= l_numeric_participant.rule_id and seq_nbr=maxseq-1 and template_id IN(1, 2, 3, 4, 5))
1790: where rule_id= l_numeric_participant.rule_id and seq_nbr in (minseq,maxseq);
1791:
1792: update cz_expression_nodes set expr_parent_id=null , seq_nbr=1 where expr_node_id=l_numeric_participant.exp1id;
1793: END LOOP;
1794:
1795: END LOOP;
1796:
1797:
1798:
1799: FOR l_numeric_participant IN c_numeric_participant
1800: LOOP
1801: SELECT cz_expression_nodes_s.nextval
1802: INTO l_expression_node_id
1803: FROM dual;
1804: -- > record
1805:
1803: FROM dual;
1804: -- > record
1805:
1806: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1804: -- > record
1805:
1806: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1805:
1806: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1806: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1807: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1808: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='1' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1809: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_numeric_participant.exp2parentid ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1810: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='200' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
1818: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1811: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1812: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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).RULE_ID :=l_numeric_participant.rule_id ;
1813: v_cz_expression_nodes(v_cz_expr_node_count).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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).TEMPLATE_ID :='350' ;
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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:
1814: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='81' ;
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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:
1822:
1815: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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:
1822:
1823:
1816: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='3' ;
1817: v_cz_expression_nodes(v_cz_expr_node_count).COLLECTION_FLAG :='0' ;
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:
1822:
1823:
1824:
1821:
1822:
1823:
1824:
1825: UPDATE cz_expression_nodes
1826: SET expr_parent_id = l_expression_node_id,
1827: seq_nbr = 1
1828: WHERE expr_node_id = l_numeric_participant.exp2id;
1829: -- make count feature child of >
1826: SET expr_parent_id = l_expression_node_id,
1827: seq_nbr = 1
1828: WHERE expr_node_id = l_numeric_participant.exp2id;
1829: -- make count feature child of >
1830: SELECT cz_expression_nodes_s.nextval
1831: INTO l_expression_node_id1
1832: FROM dual;
1833: -- insert 0 record
1834:
1832: FROM dual;
1833: -- insert 0 record
1834:
1835: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1833: -- insert 0 record
1834:
1835: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1834:
1835: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1835: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1836: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_NODE_ID :=l_expression_node_id1 ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1837: v_cz_expression_nodes(v_cz_expr_node_count).SEQ_NBR :='2' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1838: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_PARENT_ID :=l_expression_node_id ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1839: v_cz_expression_nodes(v_cz_expr_node_count).EXPR_TYPE :='201' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1840: v_cz_expression_nodes(v_cz_expr_node_count).TOKEN_LIST_SEQ :='10' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1841: v_cz_expression_nodes(v_cz_expr_node_count).RULE_ID :=l_numeric_participant.rule_id ;
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1849:
1842: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_SIGNATURE_ID :='2069' ;
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1849:
1850:
1843: v_cz_expression_nodes(v_cz_expr_node_count).PARAM_INDEX :='1' ;
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1849:
1850:
1851: -- insert record for const 0 under > record
1844: v_cz_expression_nodes(v_cz_expr_node_count).DATA_TYPE :='1' ;
1845: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_OFFSET :='4' ;
1846: -- v_cz_expression_nodes(v_cz_expr_node_count).SOURCE_LENGTH :='38' ;
1847: v_cz_expression_nodes(v_cz_expr_node_count).MUTABLE_FLAG :='0' ;
1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1849:
1850:
1851: -- insert record for const 0 under > record
1852: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1850:
1851: -- insert record for const 0 under > record
1852: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1853: 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);
1854: DELETE FROM cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id=21;
1855: populate_cz_tables(true);
1856: cz_rule_text_gen.parse_rules(p_dev_project_id, l_numeric_participant.rule_id);
1857: END LOOP;
1858:
1880:
1881:
1882: --fetch Event bindings bound to the onValidateEligibleTarget event
1883:
1884: UPDATE cz_expression_nodes
1885: SET deleted_flag = '1'
1886: WHERE expr_node_id
1887: IN (
1888: SELECT expr_node_id
1885: SET deleted_flag = '1'
1886: WHERE expr_node_id
1887: IN (
1888: SELECT expr_node_id
1889: FROM cz_rules czrules ,cz_expression_nodes EXP
1890: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1891: and expr_type = 216
1892: AND EXP.rule_id = czrules.rule_id
1893: AND EXP.argument_signature_id = 2204
1910:
1911: SELECT DISTINCT czrules.rule_id
1912: BULK COLLECT INTO v_cz_ids_tbl
1913: FROM cz_rules czrules,
1914: cz_expression_nodes exp
1915: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1916: AND expr_type = 216
1917: AND exp.rule_id = czrules.rule_id
1918: AND czrules.deleted_flag = '0'
1939: FOR v_rule_ids IN (
1940: SELECT czrules.rule_id,
1941: expout.expr_node_id
1942: FROM cz_rules czrules,
1943: cz_expression_nodes expout
1944: WHERE czrules.rule_type = RULE_TYPE_CONFIGURATION_EXT
1945: AND czrules.rule_id = expout.rule_id
1946: AND EXISTS
1947: (SELECT 1
1944: WHERE czrules.rule_type = RULE_TYPE_CONFIGURATION_EXT
1945: AND czrules.rule_id = expout.rule_id
1946: AND EXISTS
1947: (SELECT 1
1948: FROM cz_expression_nodes EXP
1949: WHERE EXP.expr_type = 216
1950: AND EXP.rule_id = czrules.rule_id
1951: AND EXP.argument_signature_id IN(2209, --postInstanceAdd
1952: 2210, --postInstanceDelete
2065: BEGIN
2066:
2067:
2068: v_cz_expr_node_count := 0;
2069: v_cz_expression_nodes.DELETE;
2070:
2071: v_cz_rule_count := 0;
2072: V_CZ_RULES.DELETE;
2073:
2162: ***************/
2163: END LOOP;
2164: --Do Cleanup
2165: v_cz_expr_node_count := 0;
2166: v_cz_expression_nodes.DELETE;
2167: v_cz_rule_count := 0;
2168: V_CZ_RULES.DELETE;
2169: v_model_conversion_set_id:=NULL;
2170: EXCEPTION
2169: v_model_conversion_set_id:=NULL;
2170: EXCEPTION
2171: WHEN others THEN
2172: v_cz_expr_node_count := 0;
2173: v_cz_expression_nodes.DELETE;
2174: v_cz_rule_count := 0;
2175: V_CZ_RULES.DELETE;
2176: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2177: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);