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: -- 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:

Line 805: -- If you call populate_cz_tables() after inserting the data in v_cz_rules - it will create a Rule with

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: -- 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:

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

808: populate_cz_tables();
809:
810: -- End Fixing BUG9176281
811: v_cz_rule_count:=v_cz_rule_count+1;
812: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
813: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
814: IF p_rulefolderid IS NULL THEN
815: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
816: ELSE

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

809:
810: -- End Fixing BUG9176281
811: v_cz_rule_count:=v_cz_rule_count+1;
812: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
813: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
814: IF p_rulefolderid IS NULL THEN
815: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
816: ELSE
817: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;

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

811: v_cz_rule_count:=v_cz_rule_count+1;
812: V_CZ_RULES(v_cz_rule_count).rule_id:= l_rule_id;
813: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
814: IF p_rulefolderid IS NULL THEN
815: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
816: ELSE
817: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
818: END IF;
819: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;

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

813: V_CZ_RULES(v_cz_rule_count).reason_id:= l_intl_text_id;
814: IF p_rulefolderid IS NULL THEN
815: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
816: ELSE
817: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
818: END IF;
819: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
820: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
821: IF p_default_rule THEN

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

815: V_CZ_RULES(v_cz_rule_count).rule_folder_id:=findOrCreateRuleFolder(p_devl_project_id) ;
816: ELSE
817: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
818: END IF;
819: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
820: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
821: IF p_default_rule THEN
822: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
823: ELSE

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

816: ELSE
817: V_CZ_RULES(v_cz_rule_count).rule_folder_id:= p_rulefolderid ;
818: END IF;
819: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
820: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
821: IF p_default_rule THEN
822: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
823: ELSE
824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;

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

818: END IF;
819: V_CZ_RULES(v_cz_rule_count).devl_project_id:= p_devl_project_id;
820: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
821: IF p_default_rule THEN
822: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
823: ELSE
824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';

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

820: V_CZ_RULES(v_cz_rule_count).invalid_flag:= '0';
821: IF p_default_rule THEN
822: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
823: ELSE
824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;

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

822: V_CZ_RULES(v_cz_rule_count).name:= 'Defaults-' || l_ps_node_name;
823: ELSE
824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';

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

823: ELSE
824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';

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

824: V_CZ_RULES(v_cz_rule_count).name:= 'Constraint-' || l_ps_node_name;
825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;

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

825: END IF;
826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;

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

826: V_CZ_RULES(v_cz_rule_count).rule_type:= '200';
827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;

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

827: V_CZ_RULES(v_cz_rule_count).reason_type:= '0' ;
828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';

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

828: V_CZ_RULES(v_cz_rule_count).disabled_flag:= '0' ;
829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';

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

829: V_CZ_RULES(v_cz_rule_count).deleted_flag:= '0' ;
830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';

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

830: V_CZ_RULES(v_cz_rule_count).effective_usage_mask:='0000000000000000';
831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:

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

831: V_CZ_RULES(v_cz_rule_count).seq_nbr:= '1';
832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:
839: -- INSERTING into cz_rules -- rule folder entry

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

832: V_CZ_RULES(v_cz_rule_count).effective_from:= cz_utils.epoch_begin;
833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:
839: -- INSERTING into cz_rules -- rule folder entry
840: -- Fixing BUG9176281 - Rule name for Default Rule

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

833: V_CZ_RULES(v_cz_rule_count).effective_until:= cz_utils.epoch_end;
834: V_CZ_RULES(v_cz_rule_count).persistent_rule_id:=l_rule_id;
835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:
839: -- INSERTING into cz_rules -- rule folder entry
840: -- Fixing BUG9176281 - Rule name for Default Rule
841: 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 839: -- INSERTING into cz_rules -- rule folder entry

835: V_CZ_RULES(v_cz_rule_count).presentation_flag:= '0';
836: V_CZ_RULES(v_cz_rule_count).mutable_flag:= '0';
837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:
839: -- INSERTING into cz_rules -- rule folder entry
840: -- Fixing BUG9176281 - Rule name for Default Rule
841: 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)
842: VALUES(l_rule_id, V_CZ_RULES(v_cz_rule_count).name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
843:

Line 842: VALUES(l_rule_id, V_CZ_RULES(v_cz_rule_count).name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );

838:
839: -- INSERTING into cz_rules -- rule folder entry
840: -- Fixing BUG9176281 - Rule name for Default Rule
841: 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)
842: VALUES(l_rule_id, V_CZ_RULES(v_cz_rule_count).name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
843:
844: --populate_cz_tables(); moved prior to inserting data to v_cz_rules
845:
846: RETURN l_rule_id;

Line 844: --populate_cz_tables(); moved prior to inserting data to v_cz_rules

840: -- Fixing BUG9176281 - Rule name for Default Rule
841: 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)
842: VALUES(l_rule_id, V_CZ_RULES(v_cz_rule_count).name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
843:
844: --populate_cz_tables(); moved prior to inserting data to v_cz_rules
845:
846: RETURN l_rule_id;
847: EXCEPTION
848: WHEN others THEN

Line 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

853:
854:
855: --Create implies rule for initial values on Boolean features .refer section 4..1.3.3 for Boolean features
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;

Line 929: UPDATE cz_rules

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
930: SET rule_class = RULE_CLASS_DEFAULT
931: WHERE rule_id = l_rule_id;
932:
933:

Line 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

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;

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

1051:
1052: --Procedure to create accumulator rule records for contribute/consume rule initial values
1053: 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,
1054: p_ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, feature_type IN cz_ps_nodes.feature_type%TYPE,
1055: initialvalue IN cz_ps_nodes.initial_value%TYPE, minvalue IN cz_ps_nodes.maximum%TYPE, rulefolderid IN cz_rules.rule_folder_id%TYPE,
1056: maxvalue IN cz_ps_nodes.maximum%TYPE) AS
1057: --cursor to find all contribute/consume sources for a given target
1058: CURSOR c_contrib_consume IS
1059: SELECT DISTINCT r.devl_project_id,

Line 1067: FROM cz_rules r,

1063: ps.name,
1064: p.name devname,
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

Line 1088: l_rule_id cz_rules.rule_id%TYPE;

1084: ORDER BY r.devl_project_id , e1.model_ref_expl_id;
1085:
1086: l_msg VARCHAR2(2000);
1087: l_api_name constant VARCHAR2(30) := 'createRules';
1088: l_rule_id cz_rules.rule_id%TYPE;
1089: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1090: l_rule_class cz_rules.rule_class%TYPE;
1091: l_ps_node_name cz_ps_nodes.name%type;
1092: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;

Line 1089: l_rulefolderid cz_rules.rule_folder_id%TYPE;

1085:
1086: l_msg VARCHAR2(2000);
1087: l_api_name constant VARCHAR2(30) := 'createRules';
1088: l_rule_id cz_rules.rule_id%TYPE;
1089: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1090: l_rule_class cz_rules.rule_class%TYPE;
1091: l_ps_node_name cz_ps_nodes.name%type;
1092: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1093: l_has_mult_down_cont_cons boolean;

Line 1090: l_rule_class cz_rules.rule_class%TYPE;

1086: l_msg VARCHAR2(2000);
1087: l_api_name constant VARCHAR2(30) := 'createRules';
1088: l_rule_id cz_rules.rule_id%TYPE;
1089: l_rulefolderid cz_rules.rule_folder_id%TYPE;
1090: l_rule_class cz_rules.rule_class%TYPE;
1091: l_ps_node_name cz_ps_nodes.name%type;
1092: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;
1093: l_has_mult_down_cont_cons boolean;
1094:

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

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

Line 1148: UPDATE cz_rules SET reason_id=null, reason_type=0, accumulator_flag=1 WHERE rule_id=v_contribute_consume.rule_id; -- fix for BUG7209057

1144:
1145: END IF;
1146:
1147: UPDATE cz_localized_texts SET deleted_flag =1 WHERE intl_text_id=v_contribute_consume.reason_id;
1148: UPDATE cz_rules SET reason_id=null, reason_type=0, accumulator_flag=1 WHERE rule_id=v_contribute_consume.rule_id; -- fix for BUG7209057
1149:
1150:
1151: IF(l_previous_devl_project_id IS NULL) THEN
1152: l_previous_devl_project_id := v_contribute_consume.devl_project_id;

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

1168: 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
1169: -- Total/resource/Num feature
1170: --Create a new Rule Folder in model dev_project_id and get its id in l_rulefolderID
1171: l_rulefolderid := findOrCreateRuleFolder(p_devl_project_id);
1172: --Create a new rule record in cz_rules in folder specified by l_rulefolderID with Name "Constraint-<>" get its value in l_rule_id
1173: l_rule_id := createConstraintRuleRecord(l_rulefolderid, p_ps_node_id, p_devl_project_id);
1174: l_rule_class := RULE_CLASS_CONSTRAINT;
1175: --defaults
1176: -- create one additional Accumulator Rule to add the initial value to the target

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

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

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

1466:
1467:
1468: --procedure to convert existing rules to those suitable for the FCE
1469: --Refer section 4.1.4 rule requirements
1470: PROCEDURE convertRules(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rulefolderid IN cz_rules.rule_folder_id%TYPE) AS
1471:
1472: -- cursor to fetch ATAN2 rules which will be converted into ATAN
1473: CURSOR c_atan IS
1474: SELECT ex.*

Line 1476: cz_rules ru

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'
1480: AND ex.template_id = 430

Line 1508: SELECT DISTINCT cz_rules.rule_id,

1504: );
1505:
1506: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
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,

Line 1509: cz_rules.devl_project_id

1505:
1506: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
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

Line 1510: FROM cz_rules,

1506: --cursor to fetch compatibility rule where more than one participant feature has a maximum number of selections greater than 1
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)

Line 1518: AND exp1.rule_id = cz_rules.rule_id

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
1518: AND exp1.rule_id = cz_rules.rule_id
1519: AND exp1.expr_type = 207
1520: AND exp2.expr_type = 207
1521: AND exp1.expr_node_id <> exp2.expr_node_id
1522: AND EXISTS

Line 1541: AND cz_rules.devl_project_id = p_dev_project_id

1537: AND ps2.maximum > 1
1538: )
1539: )
1540: )
1541: AND cz_rules.devl_project_id = p_dev_project_id
1542: UNION ALL
1543: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1544: FROM cz_des_chart_features cf,
1545: cz_des_chart_features cf1,

Line 1548: cz_rules rule

1544: FROM cz_des_chart_features cf,
1545: cz_des_chart_features cf1,
1546: cz_ps_nodes ps,
1547: cz_ps_nodes ps1,
1548: cz_rules rule
1549: WHERE cf.rule_id = cf1.rule_id
1550: AND cf.feature_id = ps.ps_node_id
1551: AND cf1.feature_id = ps1.ps_node_id
1552: AND cf1.feature_id <> cf.feature_id

Line 1568: SELECT DISTINCT cz_rules.rule_id,

1564:
1565:
1566: --cursor to fetch compatibility rule where one participant is a BOM Node
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,

Line 1569: cz_rules.devl_project_id

1565:
1566: --cursor to fetch compatibility rule where one participant is a BOM Node
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

Line 1570: FROM cz_rules,

1566: --cursor to fetch compatibility rule where one participant is a BOM Node
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)

Line 1578: AND exp1.rule_id = cz_rules.rule_id

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
1578: AND exp1.rule_id = cz_rules.rule_id
1579: AND exp1.expr_type = 207
1580: AND exp2.expr_type = 207
1581: AND exp1.expr_node_id <> exp2.expr_node_id
1582: AND EXISTS

Line 1595: AND cz_rules.devl_project_id = p_dev_project_id

1591: AND expin1.ps_node_id = ps1.ps_node_id
1592: AND (ps1.ps_node_type =PS_TYPE_BOM_MODEL
1593: OR ps2.ps_node_type =PS_TYPE_BOM_MODEL)
1594: )
1595: AND cz_rules.devl_project_id = p_dev_project_id
1596: UNION ALL
1597: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1598: FROM cz_des_chart_features cf,
1599: cz_des_chart_features cf1,

Line 1602: cz_rules rule

1598: FROM cz_des_chart_features cf,
1599: cz_des_chart_features cf1,
1600: cz_ps_nodes ps,
1601: cz_ps_nodes ps1,
1602: cz_rules rule
1603: WHERE cf.rule_id = cf1.rule_id
1604: AND cf.feature_id = ps.ps_node_id
1605: AND cf1.feature_id = ps1.ps_node_id
1606: AND cf1.feature_id <> cf.feature_id

Line 1621: l_cz_rules_id cz_rules.rule_id%TYPE;

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
1623:
1624: --Bug 6725690 , convert ZDIV operator to divide (/) operator.
1625:

Line 1631: FROM cz_rules

1627: SET template_id = 408
1628: WHERE template_id = 404
1629: AND rule_id IN
1630: (SELECT rule_id
1631: FROM cz_rules
1632: WHERE devl_project_id = p_dev_project_id
1633: AND deleted_flag ='0')
1634: AND deleted_flag ='0'
1635: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

Line 1654: FROM cz_rules

1650: SET template_id = 2
1651: WHERE template_id = 5
1652: AND rule_id IN
1653: (SELECT rule_id
1654: FROM cz_rules
1655: WHERE devl_project_id = p_dev_project_id
1656: AND deleted_flag ='0')
1657: AND deleted_flag ='0'
1658: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

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

1658: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;
1659:
1660:
1661:
1662: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1663: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1664: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1665:
1666:

Line 1663: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT

1659:
1660:
1661:
1662: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1663: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1664: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1665:
1666:
1667: IF v_cz_ids_tbl.COUNT>0 THEN

Line 1664: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;

1660:
1661:
1662: FORALL l_cz_rules_id IN v_cz_ids_tbl.FIRST .. v_cz_ids_tbl.LAST
1663: UPDATE cz_rules SET RULE_CLASS=RULE_CLASS_DEFAULT
1664: WHERE rule_id=v_cz_ids_tbl(l_cz_rules_id) ;
1665:
1666:
1667: IF v_cz_ids_tbl.COUNT>0 THEN
1668: FOR i IN v_cz_ids_tbl.FIRST ..v_cz_ids_tbl.LAST

Line 1692: FROM cz_rules

1688: SET template_id = 552
1689: WHERE template_id = 360
1690: AND rule_id IN
1691: (SELECT rule_id
1692: FROM cz_rules
1693: WHERE devl_project_id = p_dev_project_id
1694: AND deleted_flag ='0')
1695: AND deleted_flag ='0'
1696: RETURNING rule_id BULK COLLECT INTO v_cz_ids_tbl;

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

1748: --Any numeric participants in existing logic rules will be mapped to "expr > 0".
1749: --Refer section 4.1.4.6
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

Line 1889: FROM cz_rules czrules ,cz_expression_nodes EXP

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

Line 1913: FROM cz_rules czrules,

1909: --Arguments to Configurator Extension event bindings now require the use of new Java interfaces.
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

Line 1942: FROM cz_rules czrules,

1938:
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

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

1973:
1974:
1975: --This procedure removes effectivity info and displays messages for conversion of total and resources to float and
1976: -- also messages for contribute/consume rule conversion.
1977: PROCEDURE processModel(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE, p_rule_folderid cz_rules.rule_folder_id%TYPE) AS
1978: --Cursor to fetch Multi-Instantiable BOM Model Reference
1979: CURSOR c_bom_minmax IS
1980: SELECT ps_node_id
1981: FROM cz_ps_nodes psout

Line 2072: V_CZ_RULES.DELETE;

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:
2074: v_model_conversion_set_id:=p_model_conversion_set_id;
2075: FOR v_models IN
2076: ( SELECT remote_model_id

Line 2117: UPDATE cz_rules

2113:
2114: --Dump rules data for newly created rules to the database tables .
2115: populate_cz_tables(true);
2116: --Mark rule_class=0 and config_engine_type='F' for all rules having null values for these fields
2117: UPDATE cz_rules
2118: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2119: WHERE deleted_flag='0'
2120: AND devl_project_id IN( SELECT remote_model_id
2121: FROM cz_model_publications p , cz_pb_model_exports z

Line 2168: V_CZ_RULES.DELETE;

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
2171: WHEN others THEN
2172: v_cz_expr_node_count := 0;

Line 2175: V_CZ_RULES.DELETE;

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);
2178: v_model_conversion_set_id:=NULL;
2179: RAISE;