eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_MODEL_CONVERT dependencies on CZ_RULES

Line 55: TYPE t_cz_rules IS TABLE OF cz_rules%ROWTYPE INDEX BY BINARY_INTEGER;

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 ;
57: v_cz_rule_count NUMBER(10);
58:
59:

Line 56: v_cz_rules t_cz_rules ;

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 ;
57: v_cz_rule_count NUMBER(10);
58:
59:
60: -- used for getting the next rule id since rule sequence is incremented by 20 every time

Line 123: FUNCTION findOrCreateRuleFolder(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) RETURN cz_rules.rule_folder_id%TYPE AS

119: RAISE;
120: END;
121:
122:
123: FUNCTION findOrCreateRuleFolder(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) RETURN cz_rules.rule_folder_id%TYPE AS
124: p_rule_folderid cz_rules.rule_folder_id%TYPE;
125: p_parent_rule_fldr cz_rules.rule_folder_id%TYPE;
126:
127: CURSOR c_rule_fld IS

Line 124: p_rule_folderid cz_rules.rule_folder_id%TYPE;

120: END;
121:
122:
123: FUNCTION findOrCreateRuleFolder(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) RETURN cz_rules.rule_folder_id%TYPE AS
124: p_rule_folderid cz_rules.rule_folder_id%TYPE;
125: p_parent_rule_fldr cz_rules.rule_folder_id%TYPE;
126:
127: CURSOR c_rule_fld IS
128: SELECT rule_folder_id

Line 125: p_parent_rule_fldr cz_rules.rule_folder_id%TYPE;

121:
122:
123: FUNCTION findOrCreateRuleFolder(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) RETURN cz_rules.rule_folder_id%TYPE AS
124: p_rule_folderid cz_rules.rule_folder_id%TYPE;
125: p_parent_rule_fldr cz_rules.rule_folder_id%TYPE;
126:
127: CURSOR c_rule_fld IS
128: SELECT rule_folder_id
129: FROM cz_rule_folders

Line 161: -- procedure to populate CZ tables with data in temporary tables v_cz_rules and v_cz_expression_nodes

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

Line 167: IF ((v_cz_rules.LAST IS NOT NULL and v_cz_rules.LAST >20) OR commit_all ) THEN

163: l_msg VARCHAR2(2000);
164: l_api_name constant VARCHAR2(30) := 'populate_cz_expression_table';
165: BEGIN
166:
167: IF ((v_cz_rules.LAST IS NOT NULL and v_cz_rules.LAST >20) OR commit_all ) THEN
168:
169: IF (v_cz_rules.LAST IS NOT NULL) THEN
170: for v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST Loop
171: begin

Line 169: IF (v_cz_rules.LAST IS NOT NULL) THEN

165: BEGIN
166:
167: IF ((v_cz_rules.LAST IS NOT NULL and v_cz_rules.LAST >20) OR commit_all ) THEN
168:
169: IF (v_cz_rules.LAST IS NOT NULL) THEN
170: for v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST Loop
171: begin
172: INSERT INTO cz_localized_texts (localized_str, intl_text_id, deleted_flag, language, source_lang, model_id, seeded_flag, persistent_intl_text_id)
173: VALUES (v_cz_rules(v_cz_rules_count).name, v_cz_rules(v_cz_rules_count).reason_id, 0, 'US', 'US', v_cz_rules(v_cz_rules_count).devl_project_id, 0, v_cz_rules(v_cz_rules_count).reason_id);

Line 170: for v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST Loop

166:
167: IF ((v_cz_rules.LAST IS NOT NULL and v_cz_rules.LAST >20) OR commit_all ) THEN
168:
169: IF (v_cz_rules.LAST IS NOT NULL) THEN
170: for v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST Loop
171: begin
172: INSERT INTO cz_localized_texts (localized_str, intl_text_id, deleted_flag, language, source_lang, model_id, seeded_flag, persistent_intl_text_id)
173: VALUES (v_cz_rules(v_cz_rules_count).name, v_cz_rules(v_cz_rules_count).reason_id, 0, 'US', 'US', v_cz_rules(v_cz_rules_count).devl_project_id, 0, v_cz_rules(v_cz_rules_count).reason_id);
174: exception when others then

Line 173: VALUES (v_cz_rules(v_cz_rules_count).name, v_cz_rules(v_cz_rules_count).reason_id, 0, 'US', 'US', v_cz_rules(v_cz_rules_count).devl_project_id, 0, v_cz_rules(v_cz_rules_count).reason_id);

169: IF (v_cz_rules.LAST IS NOT NULL) THEN
170: for v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST Loop
171: begin
172: INSERT INTO cz_localized_texts (localized_str, intl_text_id, deleted_flag, language, source_lang, model_id, seeded_flag, persistent_intl_text_id)
173: VALUES (v_cz_rules(v_cz_rules_count).name, v_cz_rules(v_cz_rules_count).reason_id, 0, 'US', 'US', v_cz_rules(v_cz_rules_count).devl_project_id, 0, v_cz_rules(v_cz_rules_count).reason_id);
174: exception when others then
175: null;
176: end;
177: END LOOP;

Line 179: forall v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST

175: null;
176: end;
177: END LOOP;
178: -- use FORALL statement for bulk insert.
179: forall v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST
180: INSERT INTO cz_rules
181: VALUES v_cz_rules(v_cz_rules_count);
182: END IF;
183: -- use FORALL statement for bulk insert.

Line 180: INSERT INTO cz_rules

176: end;
177: END LOOP;
178: -- use FORALL statement for bulk insert.
179: forall v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST
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

Line 181: VALUES v_cz_rules(v_cz_rules_count);

177: END LOOP;
178: -- use FORALL statement for bulk insert.
179: forall v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST
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

Line 194: IF (v_cz_rules.LAST IS NOT NULL) THEN

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
197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN
198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);

Line 196: FOR v_cz_rules_count IN v_cz_rules.FIRST .. v_cz_rules.LAST LOOP

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
197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN
198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);
199: END IF;
200: END LOOP;

Line 197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN

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
197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN
198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);
199: END IF;
200: END LOOP;
201: v_cz_rules.DELETE;

Line 198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);

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
197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN
198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);
199: END IF;
200: END LOOP;
201: v_cz_rules.DELETE;
202: END IF;

Line 201: v_cz_rules.DELETE;

197: IF v_cz_rules(v_cz_rules_count).presentation_flag=0 THEN
198: cz_rule_text_gen.parse_rules( v_cz_rules(v_cz_rules_count).devl_project_id, v_cz_rules(v_cz_rules_count).rule_id);
199: END IF;
200: END LOOP;
201: v_cz_rules.DELETE;
202: END IF;
203:
204: v_cz_rule_count:=0;
205: v_cz_expr_node_count:=0;

Line 490: cz_rules ru,

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,
494: cz_ui_templates te ,cz_ui_template_elements tempel

Line 598: cz_rules ru,

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'
602: AND ex.rule_id = ru.rule_id

Line 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')

636: */
637:
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

Line 643: cz_rules ru,

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'
647: AND ex.rule_id = ru.rule_id

Line 666: cz_rules ru,

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'
670: AND ex.rule_id = ru.rule_id

Line 683: from cz_intl_texts intl, cz_ui_defs ui , cz_rules ru where

679:
680:
681: FOR v_ui IN
682: (select intl.ui_def_id , ru.name lceprop , REPLACE(REPLACE('Definition'||ru.name ,'DefinitionMaxSelected','DefinitionMaxSelections'),'DefinitionMinSelected','DefinitionMinSelections') fceprop, intl.ui_page_element_id
683: from cz_intl_texts intl, cz_ui_defs ui , cz_rules ru where
684: ru.rule_id in (894,818,812,893,817,811,813,814,815,816)
685: and text_str like '%'||fnd_global.local_chr(38)||upper(ru.name)||'%'
686: and intl.ui_def_id = ui.ui_def_id
687: and intl.deleted_flag='0'

Line 704: SELECT 1 FROM cz_rules WHERE rule_id IN (894,818,812,893,817,811,813,814,815,816)

700: ,' '||fnd_global.local_chr(38)||'MAX' , ' '||fnd_global.local_chr(38)||'DEFINITIONMAX'),'DEFINITIONMAXSELECTED','DEFINITIONMAXSELECTIONS'),'DEFINITIONMINSELECTED','DEFINITIONMINSELECTIONS')
701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )
702: AND model_id = p_dev_project_id
703: AND EXISTS (
704: SELECT 1 FROM cz_rules WHERE rule_id IN (894,818,812,893,817,811,813,814,815,816)
705: AND localized_str LIKE '%'||fnd_global.local_chr(38)||upper(name)||'%' )
706: AND deleted_flag='0';
707:
708:

Line 768: -- function to get rule id values . As cz_rules_s sequence is incremented by 20 everytime hence we need this function

764:
765:
766:
767:
768: -- function to get rule id values . As cz_rules_s sequence is incremented by 20 everytime hence we need this function
769: FUNCTION next_rule_id RETURN NUMBER IS
770: id_to_return NUMBER;
771: BEGIN
772: IF((last_id_allocated IS NULL) OR

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

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

Line 786: FUNCTION createConstraintRuleRecord(p_rulefolderid IN cz_rules.rule_folder_id%TYPE, p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,

782: END next_rule_id;
783:
784:
785:
786: FUNCTION createConstraintRuleRecord(p_rulefolderid IN cz_rules.rule_folder_id%TYPE, p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
787: p_devl_project_id IN cz_devl_projects.devl_project_id%TYPE , p_default_rule boolean DEFAULT FALSE) RETURN cz_rules.rule_id%TYPE AS
788: l_rule_id cz_rules.rule_id%TYPE;
789: l_msg VARCHAR2(2000);
790: l_api_name constant VARCHAR2(30) := 'createConstraintRuleRecord';

Line 787: p_devl_project_id IN cz_devl_projects.devl_project_id%TYPE , p_default_rule boolean DEFAULT FALSE) RETURN cz_rules.rule_id%TYPE AS

783:
784:
785:
786: FUNCTION createConstraintRuleRecord(p_rulefolderid IN cz_rules.rule_folder_id%TYPE, p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
787: p_devl_project_id IN cz_devl_projects.devl_project_id%TYPE , p_default_rule boolean DEFAULT FALSE) RETURN cz_rules.rule_id%TYPE AS
788: l_rule_id cz_rules.rule_id%TYPE;
789: l_msg VARCHAR2(2000);
790: l_api_name constant VARCHAR2(30) := 'createConstraintRuleRecord';
791: l_ps_node_name cz_ps_nodes.name%type;

Line 788: l_rule_id cz_rules.rule_id%TYPE;

784:
785:
786: FUNCTION createConstraintRuleRecord(p_rulefolderid IN cz_rules.rule_folder_id%TYPE, p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
787: p_devl_project_id IN cz_devl_projects.devl_project_id%TYPE , p_default_rule boolean DEFAULT FALSE) RETURN cz_rules.rule_id%TYPE AS
788: l_rule_id cz_rules.rule_id%TYPE;
789: l_msg VARCHAR2(2000);
790: l_api_name constant VARCHAR2(30) := 'createConstraintRuleRecord';
791: l_ps_node_name cz_ps_nodes.name%type;
792: l_intl_text_id CZ_LOCALIZED_TEXTS.intl_text_id%type;

Line 803: -- INSERTING into cz_rules

799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;
800:
801: SELECT name , nvl(initial_value, initial_num_value ) INTO l_ps_node_name , initialvalue from cz_ps_nodes where ps_node_id=p_ps_node_id;
802:
803: -- INSERTING into cz_rules
804:
805: v_cz_rule_count:=v_cz_rule_count+1;
806: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;

Line 806: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;

802:
803: -- INSERTING into cz_rules
804:
805: v_cz_rule_count:=v_cz_rule_count+1;
806: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
808: IF p_rulefolderid IS NULL THEN
809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
810: ELSE

Line 807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;

803: -- INSERTING into cz_rules
804:
805: v_cz_rule_count:=v_cz_rule_count+1;
806: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
808: IF p_rulefolderid IS NULL THEN
809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
810: ELSE
811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;

Line 809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;

805: v_cz_rule_count:=v_cz_rule_count+1;
806: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
808: IF p_rulefolderid IS NULL THEN
809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
810: ELSE
811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
812: END IF;
813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;

Line 811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;

807: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
808: IF p_rulefolderid IS NULL THEN
809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
810: ELSE
811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
812: END IF;
813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
815: IF p_default_rule THEN

Line 813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;

809: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
810: ELSE
811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
812: END IF;
813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
815: IF p_default_rule THEN
816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
817: ELSE

Line 814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';

810: ELSE
811: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
812: END IF;
813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
815: IF p_default_rule THEN
816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
817: ELSE
818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;

Line 816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;

812: END IF;
813: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
815: IF p_default_rule THEN
816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
817: ELSE
818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';

Line 818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;

814: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
815: IF p_default_rule THEN
816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
817: ELSE
818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;

Line 820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';

816: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
817: ELSE
818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';

Line 821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;

817: ELSE
818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';

Line 822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;

818: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;

Line 823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;

819: END IF;
820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;

Line 824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';

820: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;

Line 825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';

821: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';

Line 826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;

822: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';

Line 827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;

823: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';

Line 828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;

824: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:

Line 829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';

825: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:
833: -- INSERTING into cz_rules -- rule folder entry

Line 830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';

826: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:
833: -- INSERTING into cz_rules -- rule folder entry
834:

Line 831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';

827: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
828: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:
833: -- INSERTING into cz_rules -- rule folder entry
834:
835: INSERT INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)

Line 833: -- INSERTING into cz_rules -- rule folder entry

829: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
830: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:
833: -- INSERTING into cz_rules -- rule folder entry
834:
835: INSERT INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)
836: VALUES(l_rule_id, 'Constraint-' || l_ps_node_name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
837:

Line 836: VALUES(l_rule_id, 'Constraint-' || l_ps_node_name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );

832:
833: -- INSERTING into cz_rules -- rule folder entry
834:
835: INSERT INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)
836: VALUES(l_rule_id, 'Constraint-' || l_ps_node_name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
837:
838: populate_cz_tables();
839:
840: RETURN l_rule_id;

Line 851: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, l_rule_id IN cz_rules.rule_id%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE) AS

847:
848:
849: --Create implies rule for initial values on Boolean features .refer section 4..1.3.3 for Boolean features
850: PROCEDURE insertImpliesRuleRecords(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
851: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, l_rule_id IN cz_rules.rule_id%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE) AS
852: l_msg VARCHAR2(2000);
853: l_api_name constant VARCHAR2(30) := 'insertImpliesRuleRecords';
854: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
855: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;

Line 923: UPDATE cz_rules

919: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
920:
921: --Mark the rule as a default rule
922: populate_cz_tables(true);
923: UPDATE cz_rules
924: SET rule_class = RULE_CLASS_DEFAULT
925: WHERE rule_id = l_rule_id;
926:
927:

Line 942: l_rule_id IN cz_rules.rule_id%TYPE ,p_model_ref_expl_id IN cz_expression_nodes.model_ref_expl_id%TYPE,p_feature_type IN cz_ps_nodes.feature_type%TYPE) AS

938: --This procedure adds an ADDTO rule for a contribute/consume rule where the initial value of target is not null
939:
940: PROCEDURE createAccumulatorRule(dev_project_id IN cz_devl_projects.devl_project_id%TYPE, ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
941: ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.minimum%TYPE,
942: l_rule_id IN cz_rules.rule_id%TYPE ,p_model_ref_expl_id IN cz_expression_nodes.model_ref_expl_id%TYPE,p_feature_type IN cz_ps_nodes.feature_type%TYPE) AS
943: l_msg VARCHAR2(2000);
944: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
945: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
946: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;

Line 1049: initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.maximum%TYPE, rulefolderid IN cz_rules.rule_folder_id%TYPE,

1045:
1046: --Procedure to create accumulator rule records for contribute/consume rule initial values
1047: PROCEDURE createRules(p_devl_project_id IN cz_devl_projects.devl_project_id%TYPE, p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE,
1048: p_ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, feature_type IN cz_ps_nodes.feature_type%TYPE,
1049: initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.maximum%TYPE, rulefolderid IN cz_rules.rule_folder_id%TYPE,
1050: maxvalue IN cz_ps_nodes.maximum%TYPE) AS
1051: --cursor to find all contribute/consume sources for a given target
1052: CURSOR c_contrib_consume IS
1053: SELECT DISTINCT r.devl_project_id,

Line 1061: FROM cz_rules r,

1057: ps.name,
1058: p.name devname,
1059: r.reason_id,
1060: e1.model_ref_expl_id
1061: FROM cz_rules r,
1062: cz_devl_projects p,
1063: cz_expression_nodes e,
1064: cz_expression_nodes e1,
1065: cz_ps_nodes ps

Line 1082: l_rule_id cz_rules.rule_id%TYPE;

1078: ORDER BY r.devl_project_id , e1.model_ref_expl_id;
1079:
1080: l_msg VARCHAR2(2000);
1081: l_api_name constant VARCHAR2(30) := 'createRules';
1082: l_rule_id cz_rules.rule_id%TYPE;
1083: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1084: l_rule_class cz_rules.rule_class%TYPE;
1085: l_ps_node_name cz_ps_nodes.name%type;
1086: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;

Line 1083: l_rulefolderid cz_rules.rule_folder_id%TYPE;

1079:
1080: l_msg VARCHAR2(2000);
1081: l_api_name constant VARCHAR2(30) := 'createRules';
1082: l_rule_id cz_rules.rule_id%TYPE;
1083: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1084: l_rule_class cz_rules.rule_class%TYPE;
1085: l_ps_node_name cz_ps_nodes.name%type;
1086: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1087: l_has_mult_down_cont_cons boolean;

Line 1084: l_rule_class cz_rules.rule_class%TYPE;

1080: l_msg VARCHAR2(2000);
1081: l_api_name constant VARCHAR2(30) := 'createRules';
1082: l_rule_id cz_rules.rule_id%TYPE;
1083: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1084: l_rule_class cz_rules.rule_class%TYPE;
1085: l_ps_node_name cz_ps_nodes.name%type;
1086: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1087: l_has_mult_down_cont_cons boolean;
1088:

Line 1123: --Create a new rule record in cz_rules in folder specified by l_rulefolderID with Name "Constraint-<>" get its value in l_rule_id

1119: -- Total/resource/Num feature
1120: --Create a new Rule Folder in model dev_project_id and get its id in l_rulefolderID
1121: l_rulefolderid := findOrCreateRuleFolder(v_contribute_consume.devl_project_id);
1122:
1123: --Create a new rule record in cz_rules in folder specified by l_rulefolderID with Name "Constraint-<>" get its value in l_rule_id
1124: l_rule_id := createConstraintRuleRecord(l_rulefolderid, p_ps_node_id, v_contribute_consume.devl_project_id);
1125:
1126: l_rule_class := RULE_CLASS_CONSTRAINT;
1127: -- create one additional Accumulator Rule to add the initial value to the target

Line 1142: UPDATE cz_rules SET reason_id=null WHERE rule_id=v_contribute_consume.rule_id;

1138:
1139: END IF;
1140:
1141: UPDATE cz_localized_texts SET deleted_flag =1 WHERE intl_text_id=v_contribute_consume.reason_id;
1142: UPDATE cz_rules SET reason_id=null WHERE rule_id=v_contribute_consume.rule_id;
1143:
1144:
1145: IF(l_previous_devl_project_id IS NULL) THEN
1146: l_previous_devl_project_id := v_contribute_consume.devl_project_id;

Line 1166: --Create a new rule record in cz_rules in folder specified by l_rulefolderID with Name "Constraint-<>" get its value in l_rule_id

1162: AND feature_type IN(FEATURE_TYPE_INTEGER , FEATURE_TYPE_FLOAT)) OR p_ps_node_type = PS_TYPE_TOTAL OR p_ps_node_type = PS_TYPE_RESOURCE THEN
1163: -- Total/resource/Num feature
1164: --Create a new Rule Folder in model dev_project_id and get its id in l_rulefolderID
1165: l_rulefolderid := findOrCreateRuleFolder(p_devl_project_id);
1166: --Create a new rule record in cz_rules in folder specified by l_rulefolderID with Name "Constraint-<>" get its value in l_rule_id
1167: l_rule_id := createConstraintRuleRecord(l_rulefolderid, p_ps_node_id, p_devl_project_id);
1168: l_rule_class := RULE_CLASS_CONSTRAINT;
1169: --defaults
1170: -- create one additional Accumulator Rule to add the initial value to the target

Line 1183: --Create a new rule record in cz_rules in folder specified by rulefolderID with Name "Constraint-<>" get its value in l_rule_id

1179: AND feature_type = FEATURE_TYPE_BOOLEAN) THEN
1180: -- Boolean
1181: --Create a new Rule Folder in model dev_project_id and get its id in l_rulefolderID
1182: l_rulefolderid := findOrCreateRuleFolder(p_devl_project_id);
1183: --Create a new rule record in cz_rules in folder specified by rulefolderID with Name "Constraint-<>" get its value in l_rule_id
1184: l_rule_id := createConstraintRuleRecord(l_rulefolderid, p_ps_node_id, p_devl_project_id, true );
1185:
1186:
1187: --refer section 4..1.3.3 for Boolean features

Line 1443: PROCEDURE convertRules(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rulefolderid IN cz_rules.rule_folder_id%TYPE) AS

1439:
1440:
1441: --procedure to convert existing rules to those suitable for the FCE
1442: --Refer section 4.1.4 rule requirements
1443: PROCEDURE convertRules(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rulefolderid IN cz_rules.rule_folder_id%TYPE) AS
1444:
1445: -- cursor to fetch ATAN2 rules which will be converted into ATAN
1446: CURSOR c_atan IS
1447: SELECT ex.*

Line 1449: cz_rules ru

1445: -- cursor to fetch ATAN2 rules which will be converted into ATAN
1446: CURSOR c_atan IS
1447: SELECT ex.*
1448: FROM cz_expression_nodes ex,
1449: cz_rules ru
1450: WHERE ru.devl_project_id = p_dev_project_id
1451: AND ru.rule_id = ex.rule_id
1452: AND ru.deleted_flag ='0'
1453: AND ex.template_id = 430

Line 1481: SELECT DISTINCT cz_rules.rule_id,

1477: );
1478:
1479: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
1480: CURSOR c_compat IS
1481: SELECT DISTINCT cz_rules.rule_id,
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,

Line 1482: cz_rules.devl_project_id

1478:
1479: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
1480: CURSOR c_compat IS
1481: SELECT DISTINCT cz_rules.rule_id,
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,
1486: cz_expression_nodes exp3

Line 1483: FROM cz_rules,

1479: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
1480: CURSOR c_compat IS
1481: SELECT DISTINCT cz_rules.rule_id,
1482: cz_rules.devl_project_id
1483: FROM cz_rules,
1484: cz_expression_nodes exp1,
1485: cz_expression_nodes exp2,
1486: cz_expression_nodes exp3
1487: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)

Line 1491: AND exp1.rule_id = cz_rules.rule_id

1487: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1488: AND exp1.rule_id = exp2.rule_id
1489: AND exp1.rule_id = exp3.rule_id
1490: AND exp3.template_id = 23
1491: AND exp1.rule_id = cz_rules.rule_id
1492: AND exp1.expr_type = 207
1493: AND exp2.expr_type = 207
1494: AND exp1.expr_node_id <> exp2.expr_node_id
1495: AND EXISTS

Line 1514: AND cz_rules.devl_project_id = p_dev_project_id

1510: AND ps2.maximum > 1
1511: )
1512: )
1513: )
1514: AND cz_rules.devl_project_id = p_dev_project_id
1515: UNION ALL
1516: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1517: FROM cz_des_chart_features cf,
1518: cz_des_chart_features cf1,

Line 1521: cz_rules rule

1517: FROM cz_des_chart_features cf,
1518: cz_des_chart_features cf1,
1519: cz_ps_nodes ps,
1520: cz_ps_nodes ps1,
1521: cz_rules rule
1522: WHERE cf.rule_id = cf1.rule_id
1523: AND cf.feature_id = ps.ps_node_id
1524: AND cf1.feature_id = ps1.ps_node_id
1525: AND cf1.feature_id <> cf.feature_id

Line 1541: SELECT DISTINCT cz_rules.rule_id,

1537:
1538:
1539: --cursor to fetch compatibility rule where one participant is a BOM Node
1540: CURSOR c_bom_compat IS
1541: SELECT DISTINCT cz_rules.rule_id,
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,

Line 1542: cz_rules.devl_project_id

1538:
1539: --cursor to fetch compatibility rule where one participant is a BOM Node
1540: CURSOR c_bom_compat IS
1541: SELECT DISTINCT cz_rules.rule_id,
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,
1546: cz_expression_nodes exp3

Line 1543: FROM cz_rules,

1539: --cursor to fetch compatibility rule where one participant is a BOM Node
1540: CURSOR c_bom_compat IS
1541: SELECT DISTINCT cz_rules.rule_id,
1542: cz_rules.devl_project_id
1543: FROM cz_rules,
1544: cz_expression_nodes exp1,
1545: cz_expression_nodes exp2,
1546: cz_expression_nodes exp3
1547: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)

Line 1551: AND exp1.rule_id = cz_rules.rule_id

1547: WHERE rule_type IN(RULE_TYPE_COMPAT_TABLE, RULE_TYPE_DESIGN_CHART_RULE, RULE_TEMPLATE_FREEFORM_RULE)
1548: AND exp1.rule_id = exp2.rule_id
1549: AND exp1.rule_id = exp3.rule_id
1550: AND exp3.template_id = 23
1551: AND exp1.rule_id = cz_rules.rule_id
1552: AND exp1.expr_type = 207
1553: AND exp2.expr_type = 207
1554: AND exp1.expr_node_id <> exp2.expr_node_id
1555: AND EXISTS

Line 1568: AND cz_rules.devl_project_id = p_dev_project_id

1564: AND expin1.ps_node_id = ps1.ps_node_id
1565: AND (ps1.ps_node_type =PS_TYPE_BOM_MODEL
1566: OR ps2.ps_node_type =PS_TYPE_BOM_MODEL)
1567: )
1568: AND cz_rules.devl_project_id = p_dev_project_id
1569: UNION ALL
1570: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1571: FROM cz_des_chart_features cf,
1572: cz_des_chart_features cf1,

Line 1575: cz_rules rule

1571: FROM cz_des_chart_features cf,
1572: cz_des_chart_features cf1,
1573: cz_ps_nodes ps,
1574: cz_ps_nodes ps1,
1575: cz_rules rule
1576: WHERE cf.rule_id = cf1.rule_id
1577: AND cf.feature_id = ps.ps_node_id
1578: AND cf1.feature_id = ps1.ps_node_id
1579: AND cf1.feature_id <> cf.feature_id

Line 1594: l_cz_rules_id cz_rules.rule_id%TYPE;

1590: maxseq NUMBER;
1591: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
1592: l_ps_node_name cz_ps_nodes.name%type;
1593: l_msg VARCHAR2(2000);
1594: l_cz_rules_id cz_rules.rule_id%TYPE;
1595: BEGIN
1596:
1597: --Bug 6725690 , convert ZDIV operator to divide (/) operator.
1598:

Line 1604: FROM cz_rules

1600: SET template_id = 408
1601: WHERE template_id = 404
1602: AND rule_id IN
1603: (SELECT rule_id
1604: FROM cz_rules
1605: WHERE devl_project_id = p_dev_project_id
1606: AND deleted_flag ='0')
1607: AND deleted_flag ='0'
1608: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

Line 1627: FROM cz_rules

1623: SET template_id = 2
1624: WHERE template_id = 5
1625: AND rule_id IN
1626: (SELECT rule_id
1627: FROM cz_rules
1628: WHERE devl_project_id = p_dev_project_id
1629: AND deleted_flag ='0')
1630: AND deleted_flag ='0'
1631: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

Line 1635: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST

1631: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;
1632:
1633:
1634:
1635: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1637: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1638:
1639:

Line 1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT

1632:
1633:
1634:
1635: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1637: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1638:
1639:
1640: IF v_cz_ids_tbl.COUNT>0 THEN

Line 1637: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;

1633:
1634:
1635: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1636: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1637: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1638:
1639:
1640: IF v_cz_ids_tbl.COUNT>0 THEN
1641: FOR i IN v_cz_ids_tbl.FIRST ..v_cz_ids_tbl.LAST

Line 1665: FROM cz_rules

1661: SET template_id = 552
1662: WHERE template_id = 360
1663: AND rule_id IN
1664: (SELECT rule_id
1665: FROM cz_rules
1666: WHERE devl_project_id = p_dev_project_id
1667: AND deleted_flag ='0')
1668: AND deleted_flag ='0'
1669: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

Line 1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in

1721: --Any numeric participants in existing logic rules will be mapped to "expr > 0".
1722: --Refer section 4.1.4.6
1723:
1724: ---make this logic rule a statement rule
1725: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1726: (SELECT exp2.rule_id
1727: FROM cz_expression_nodes exp1,
1728: cz_expression_nodes exp2,
1729: cz_ps_nodes psnode

Line 1862: FROM cz_rules czrules ,cz_expression_nodes EXP

1858: SET deleted_flag = '1'
1859: WHERE expr_node_id
1860: IN (
1861: SELECT expr_node_id
1862: FROM cz_rules czrules ,cz_expression_nodes EXP
1863: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1864: and expr_type = 216
1865: AND EXP.rule_id = czrules.rule_id
1866: AND EXP.argument_signature_id = 2204

Line 1886: FROM cz_rules czrules,

1882: --Arguments to Configurator Extension event bindings now require the use of new Java interfaces.
1883:
1884: SELECT DISTINCT czrules.rule_id
1885: BULK COLLECT INTO v_cz_ids_tbl
1886: FROM cz_rules czrules,
1887: cz_expression_nodes exp
1888: WHERE rule_type = RULE_TYPE_CONFIGURATION_EXT
1889: AND expr_type = 216
1890: AND exp.rule_id = czrules.rule_id

Line 1915: FROM cz_rules czrules,

1911:
1912: FOR v_rule_ids IN (
1913: SELECT czrules.rule_id,
1914: expout.expr_node_id
1915: FROM cz_rules czrules,
1916: cz_expression_nodes expout
1917: WHERE czrules.rule_type = RULE_TYPE_CONFIGURATION_EXT
1918: AND czrules.rule_id = expout.rule_id
1919: AND EXISTS

Line 1950: PROCEDURE processModel(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rule_folderid cz_rules.rule_folder_id%TYPE) AS

1946:
1947:
1948: --This procedure removes effectivity info and displays messages for conversion of total and resources to float and
1949: -- also messages for contribute/consume rule conversion.
1950: PROCEDURE processModel(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rule_folderid cz_rules.rule_folder_id%TYPE) AS
1951: --Cursor to fetch Multi-Instantiable BOM Model Reference
1952: CURSOR c_bom_minmax IS
1953: SELECT ps_node_id
1954: FROM cz_ps_nodes psout

Line 2045: V_CZ_RULES.DELETE;

2041: v_cz_expr_node_count := 0;
2042: v_cz_expression_nodes.DELETE;
2043:
2044: v_cz_rule_count := 0;
2045: V_CZ_RULES.DELETE;
2046:
2047: v_model_conversion_set_id:=p_model_conversion_set_id;
2048: FOR v_models IN
2049: ( SELECT remote_model_id

Line 2085: UPDATE cz_rules

2081:
2082: --Dump rules data for newly created rules to the database tables .
2083: populate_cz_tables(true);
2084: --Mark rule_class=0 and config_engine_type='F' for all rules having null values for these fields
2085: UPDATE cz_rules
2086: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2087: WHERE deleted_flag='0'
2088: AND devl_project_id IN( SELECT remote_model_id
2089: FROM cz_model_publications p , cz_pb_model_exports z

Line 2136: V_CZ_RULES.DELETE;

2132: --Do Cleanup
2133: v_cz_expr_node_count := 0;
2134: v_cz_expression_nodes.DELETE;
2135: v_cz_rule_count := 0;
2136: V_CZ_RULES.DELETE;
2137: v_model_conversion_set_id:=NULL;
2138: EXCEPTION
2139: WHEN others THEN
2140: v_cz_expr_node_count := 0;

Line 2143: V_CZ_RULES.DELETE;

2139: WHEN others THEN
2140: v_cz_expr_node_count := 0;
2141: v_cz_expression_nodes.DELETE;
2142: v_cz_rule_count := 0;
2143: V_CZ_RULES.DELETE;
2144: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2145: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
2146: v_model_conversion_set_id:=NULL;
2147: RAISE;