DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_DEVL_PROJECTS

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 327: PROCEDURE processUI(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS

323:
324:
325:
326: --This procedure removes the effectivity information from Total, Resource, Integer Feat, Decimal Feat, and Virtual Component.
327: PROCEDURE processUI(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS
328: l_msg VARCHAR2(2000);
329: l_api_name constant VARCHAR2(30) := 'processUI';
330: BEGIN
331:

Line 720: PROCEDURE removeEffectivityInfo(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS

716: END processUI;
717:
718:
719: --This procedure removes the effectivity information from Total, Resource, Integer Feat, Decimal Feat, and Virtual Component.
720: PROCEDURE removeEffectivityInfo(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS
721: l_msg VARCHAR2(2000);
722: l_api_name constant VARCHAR2(30) := 'removeEffectivityInfo';
723: BEGIN
724:

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

852: END;
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;

Line 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,

942:
943: --Procedure to create the expression tree for a contribute/consume target
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';

Line 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,

1049: END createAccumulatorRule;
1050:
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

Line 1068: cz_devl_projects p,

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
1072: WHERE r.deleted_flag = '0'

Line 1092: l_previous_devl_project_id cz_devl_projects.devl_project_id%type;

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:
1095: l_devl_project_id cz_devl_projects.devl_project_id%type;
1096: l_model_ref_expl_id cz_expression_nodes.model_ref_expl_id%type;

Line 1095: l_devl_project_id cz_devl_projects.devl_project_id%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:
1095: l_devl_project_id cz_devl_projects.devl_project_id%type;
1096: l_model_ref_expl_id cz_expression_nodes.model_ref_expl_id%type;
1097:
1098:
1099: ACC_RULE_CREATED boolean;

Line 1210: PROCEDURE clearinitialvalues(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS

1206: END createRules;
1207:
1208:
1209: -- procedure to remove initial values from nodes
1210: PROCEDURE clearinitialvalues(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS
1211: l_msg VARCHAR2(2000);
1212: l_api_name constant VARCHAR2(30) := 'ClearInitialValues';
1213: BEGIN
1214: UPDATE cz_ps_nodes

Line 1232: PROCEDURE assignDefaultMinMaxvalues(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS

1228:
1229:
1230: --procedure to fill in min/max domain range values per type where no value has been defined by the modeler
1231: --Reference TD section 4.1.3.2
1232: PROCEDURE assignDefaultMinMaxvalues(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS
1233: l_msg VARCHAR2(2000);
1234: l_api_name constant VARCHAR2(30) := 'assignDefaultMinMaxvalues';
1235: BEGIN
1236: FOR c_processing IN

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 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 2097: ||' UPDATE cz_devl_projects'

2093:
2094: --mark this model as a fusion model
2095: --Bug 9176281
2096: EXECUTE IMMEDIATE ' BEGIN '
2097: ||' UPDATE cz_devl_projects'
2098: ||' SET config_engine_type = ''F'','
2099: ||' post_migr_change_flag = NULL'
2100: ||' WHERE devl_project_id = :1;'
2101: ||' COMMIT;'