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_PS_NODES

Line 726: UPDATE cz_ps_nodes

722: l_api_name constant VARCHAR2(30) := 'removeEffectivityInfo';
723: BEGIN
724:
725:
726: UPDATE cz_ps_nodes
727: SET effective_usage_mask = '0000000000000000',
728: effective_from = cz_utils.epoch_begin,
729: effective_until = cz_utils.epoch_end,
730: effectivity_set_id = NULL,

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 791: l_ps_node_name cz_ps_nodes.name%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;
793: initialvalue varchar2(2000);
794: BEGIN
795:

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

797:
798: -- kdande; 10-Jan-2008; Bug 6730553; Changed cz_localized_texts_s to cz_intl_texts_s as cz_localized_texts_s is obsolete.
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

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

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';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;

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 954: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;

950: l_api_name constant VARCHAR2(30) := 'createAccumulatorRule';
951: l_expression_node_id cz_expression_nodes.expr_node_id%TYPE;
952: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
953: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
954: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
955: BEGIN
956: IF initialvalue IS NOT NULL THEN
957:
958: -- Insert AddTo expression record;

Line 1010: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0' AND component_id=(select component_id from cz_ps_nodes ps where ps.ps_node_id=l_ps_node_id) ;

1006: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1007:
1008: IF p_model_ref_expl_id IS NULL THEN
1009: l_ps_node_id :=ps_node_id;
1010: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0' AND component_id=(select component_id from cz_ps_nodes ps where ps.ps_node_id=l_ps_node_id) ;
1011: ELSE
1012: l_mod_ref:=p_model_ref_expl_id; -- use model_ref_expl_id from parent contribute / consume rule .
1013: END IF;
1014:

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 1054: p_ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, feature_type IN cz_ps_nodes.feature_type%TYPE,

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
1058: CURSOR c_contrib_consume IS

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 1056: maxvalue IN cz_ps_nodes.maximum%TYPE) AS

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,
1060: e.template_id,

Line 1071: cz_ps_nodes ps

1067: FROM cz_rules r,
1068: cz_devl_projects p,
1069: cz_expression_nodes e,
1070: cz_expression_nodes e1,
1071: cz_ps_nodes ps
1072: WHERE r.deleted_flag = '0'
1073: AND e.deleted_flag = '0'
1074: AND e1.deleted_flag = '0'
1075: AND p.deleted_flag = '0'

Line 1091: l_ps_node_name cz_ps_nodes.name%type;

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

Line 1178: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;

1174: l_rule_class := RULE_CLASS_CONSTRAINT;
1175: --defaults
1176: -- create one additional Accumulator Rule to add the initial value to the target
1177: createAccumulatorRule(p_devl_project_id, p_ps_node_id, p_ps_node_type, initialvalue, minvalue, l_rule_id , null, feature_type);
1178: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;
1179: displayMessage(4,p_devl_project_id , 'NODE' ,p_ps_node_id,l_api_name,'CZ_CNV_INFO_ACC_INIT_VAL' , 'RULENAME', 'Constraint-'||l_ps_node_name );
1180: END IF;
1181: END IF;
1182:

Line 1196: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;

1192:
1193: --refer section 4..1.3.3 for Boolean features
1194: insertImpliesRuleRecords(p_devl_project_id, p_ps_node_id, p_ps_node_type, l_rule_id, initialvalue );
1195: IF initialvalue IS NOT NULL THEN
1196: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;
1197: displayMessage(4,p_devl_project_id , 'NODE' ,p_ps_node_id,l_api_name,'CZ_CNV_INFO_BOOL_INIT_VAL','RULENAME' , 'Constraint-'||l_ps_node_name );
1198: END IF;
1199: END IF;
1200: END IF;

Line 1214: UPDATE cz_ps_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
1215: SET initial_num_value = NULL
1216: WHERE devl_project_id = p_dev_project_id
1217: AND initial_num_value IS NOT NULL
1218: AND(ps_node_type IN(PS_TYPE_TOTAL, PS_TYPE_RESOURCE)

Line 1238: FROM cz_ps_nodes

1234: l_api_name constant VARCHAR2(30) := 'assignDefaultMinMaxvalues';
1235: BEGIN
1236: FOR c_processing IN
1237: (SELECT ps_node_id , feature_type
1238: FROM cz_ps_nodes
1239: WHERE devl_project_id = p_dev_project_id
1240: AND minimum IS NULL
1241: AND(ps_node_type = PS_TYPE_FEATURE
1242: AND feature_type IN(FEATURE_TYPE_INTEGER , FEATURE_TYPE_FLOAT)))

Line 1251: UPDATE cz_ps_nodes

1247: displayMessage(3,p_dev_project_id , 'NODE' ,c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_VAL_MIN_BOUND','MINVAL', -SOLVER_MAX_DOUBLE);
1248: END IF;
1249: END IF;
1250: END LOOP;
1251: UPDATE cz_ps_nodes
1252: SET minimum = decode(feature_type, FEATURE_TYPE_INTEGER, INTEGER_MIN_VAL, FEATURE_TYPE_FLOAT, -SOLVER_MAX_DOUBLE)
1253: WHERE devl_project_id = p_dev_project_id
1254: AND minimum IS NULL
1255: AND(ps_node_type = PS_TYPE_FEATURE

Line 1263: FROM cz_ps_nodes

1259: --
1260:
1261: FOR c_processing IN
1262: (SELECT ps_node_id
1263: FROM cz_ps_nodes
1264: WHERE devl_project_id = p_dev_project_id
1265: AND ps_node_type = PS_TYPE_FEATURE
1266: AND feature_type=FEATURE_TYPE_LIST_OF_OPTIONS
1267: AND counted_options_flag='1')

Line 1272: UPDATE cz_ps_nodes

1268: LOOP
1269: displayMessage(3,p_dev_project_id , 'NODE' , c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_OPT_QTY_MAX','MAXVAL', INTEGER_MAX_VALUE);
1270: END LOOP;
1271:
1272: UPDATE cz_ps_nodes
1273: SET MAX_QTY_PER_OPTION = fnd_profile.value('CZ_DEFAULT_MAX_QTY_INT')
1274: WHERE devl_project_id = p_dev_project_id
1275: AND ps_node_type = PS_TYPE_FEATURE
1276: AND feature_type=FEATURE_TYPE_LIST_OF_OPTIONS

Line 1283: FROM cz_ps_nodes

1279: --
1280:
1281: FOR c_processing IN
1282: (SELECT ps_node_id, feature_type
1283: FROM cz_ps_nodes
1284: WHERE devl_project_id = p_dev_project_id
1285: AND maximum IS NULL
1286: AND(ps_node_type = PS_TYPE_FEATURE
1287: AND feature_type IN(FEATURE_TYPE_INTEGER , FEATURE_TYPE_FLOAT , FEATURE_TYPE_LIST_OF_OPTIONS)))

Line 1297: UPDATE cz_ps_nodes

1293: displayMessage(3,p_dev_project_id , 'NODE' ,c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_VAL_MAX_BOUND','MAXVAL', SOLVER_MAX_DOUBLE);
1294: END IF;
1295: END IF;
1296: END LOOP;
1297: UPDATE cz_ps_nodes
1298: SET maximum = decode(feature_type, FEATURE_TYPE_INTEGER, INTEGER_MAX_VALUE, FEATURE_TYPE_LIST_OF_OPTIONS, INTEGER_MAX_VALUE, FEATURE_TYPE_FLOAT, SOLVER_MAX_DOUBLE)
1299: WHERE devl_project_id = p_dev_project_id
1300: AND maximum IS NULL
1301: AND(ps_node_type = PS_TYPE_FEATURE

Line 1307: FROM cz_ps_nodes

1303:
1304: --
1305: FOR c_processing IN
1306: (SELECT ps_node_id ,decimal_qty_flag , decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE)) changedValue
1307: FROM cz_ps_nodes
1308: WHERE devl_project_id = p_dev_project_id
1309: AND ((maximum IS NULL OR maximum =-1)
1310: AND(ps_node_type IN(PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM)))
1311: )

Line 1316: UPDATE cz_ps_nodes

1312: LOOP
1313: displayMessage(3,p_dev_project_id , 'NODE' ,c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_QTY_MAX_BOUND','MAXVAL', c_processing.changedValue);
1314: END LOOP;
1315:
1316: UPDATE cz_ps_nodes
1317: SET maximum = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE))
1318: WHERE devl_project_id = p_dev_project_id
1319: AND (maximum IS NULL OR maximum =-1)
1320: AND(ps_node_type IN( PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM)); -- Bug15986942, removed PS_TYPE_BOM_MODEL from IN clause

Line 1325: FROM cz_ps_nodes

1321:
1322: --- BUG 9467823 - Set maximum on non bom models - this is needed if MAX is not defined for the instantiable non-bom model
1323: FOR c_processing IN
1324: (SELECT ps_node_id ,decimal_qty_flag , INTEGER_MAX_VALUE changedValue
1325: FROM cz_ps_nodes
1326: WHERE devl_project_id = p_dev_project_id
1327: AND ((maximum IS NULL OR maximum =-1)
1328: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
1329: AND (ps_node_type = PS_TYPE_REFERENCE OR ps_node_type = PS_TYPE_COMPONENT)

Line 1336: UPDATE cz_ps_nodes

1332: LOOP
1333: displayMessage(3,p_dev_project_id , 'NODE' ,c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_QTY_MAX_BOUND','MAXVAL', c_processing.changedValue);
1334: END LOOP;
1335:
1336: UPDATE cz_ps_nodes
1337: SET maximum = INTEGER_MAX_VALUE
1338: WHERE devl_project_id = p_dev_project_id
1339: AND (maximum IS NULL OR maximum =-1)
1340: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE

Line 1346: UPDATE cz_ps_nodes

1342: AND item_id is null;
1343:
1344: ---Changed for bug 6737779
1345:
1346: UPDATE cz_ps_nodes
1347: SET minimum = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0 ,1 ))
1348: WHERE devl_project_id = p_dev_project_id
1349: AND (minimum IS NULL OR minimum =0)
1350: AND(ps_node_type IN( PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM)) -- Bug15986942, removed PS_TYPE_BOM_MODEL from IN clause

Line 1363: UPDATE cz_ps_nodes psout

1359: v_cz_ids_tbl.DELETE;
1360: v_cz_num_tbl.DELETE;
1361: END IF;
1362:
1363: UPDATE cz_ps_nodes psout
1364: SET minimum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0,1 ))
1365: WHERE devl_project_id = p_dev_project_id
1366: AND (minimum_selected IS NULL OR minimum_selected =0)
1367: AND(ps_node_type =PS_TYPE_REFERENCE)

Line 1368: AND EXISTS( SELECT 1 FROM cz_ps_nodes WHERE ps_node_id= psout.component_id

1364: SET minimum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0,1 ))
1365: WHERE devl_project_id = p_dev_project_id
1366: AND (minimum_selected IS NULL OR minimum_selected =0)
1367: AND(ps_node_type =PS_TYPE_REFERENCE)
1368: AND EXISTS( SELECT 1 FROM cz_ps_nodes WHERE ps_node_id= psout.component_id
1369: AND ps_node_type =PS_TYPE_BOM_MODEL )
1370: RETURNING ps_node_id , minimum_selected BULK COLLECT INTO v_cz_ids_tbl , v_cz_num_tbl;
1371:
1372:

Line 1385: FOR c_processing in ( SELECT ps_node_id ,decimal_qty_flag , initial_num_value , decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE)) changedValue FROM cz_ps_nodes

1381:
1382:
1383: --
1384:
1385: FOR c_processing in ( SELECT ps_node_id ,decimal_qty_flag , initial_num_value , decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE)) changedValue FROM cz_ps_nodes
1386: WHERE devl_project_id = p_dev_project_id
1387: AND (maximum_selected IS NULL OR maximum_selected =-1)
1388: AND(ps_node_type =PS_TYPE_REFERENCE)
1389: and item_id is not null

Line 1395: UPDATE cz_ps_nodes

1391:
1392: displayMessage(3,p_dev_project_id , 'NODE' ,c_processing.ps_node_id,l_api_name,'CZ_CNV_ADV_QTY_MAX_BOUND','MAXVAL', c_processing.changedValue);
1393: END LOOP;
1394:
1395: UPDATE cz_ps_nodes
1396: SET maximum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE))
1397: WHERE devl_project_id = p_dev_project_id
1398: AND (maximum_selected IS NULL OR maximum_selected =-1)
1399: AND(ps_node_type =PS_TYPE_REFERENCE)

Line 1407: UPDATE cz_ps_nodes

1403:
1404: ---
1405:
1406:
1407: UPDATE cz_ps_nodes
1408: SET maximum = INTEGER_MAX_VALUE
1409: WHERE devl_project_id = p_dev_project_id
1410: AND maximum IS NULL
1411: AND(ps_node_type IN(232))

Line 1426: UPDATE cz_ps_nodes

1422:
1423:
1424: ----- Update default maximum values for total and resource .
1425:
1426: UPDATE cz_ps_nodes
1427: SET maximum = DECODE(SIGN(nvl(initial_num_value,0) - SOLVER_MAX_DOUBLE), -1 , SOLVER_MAX_DOUBLE, 0 , SOLVER_MAX_DOUBLE , 1 , initial_num_value)
1428: WHERE devl_project_id = p_dev_project_id
1429: AND maximum IS NULL
1430: AND ps_node_type IN(PS_TYPE_TOTAL,PS_TYPE_RESOURCE)

Line 1444: UPDATE cz_ps_nodes

1440: END IF;
1441:
1442: ----
1443:
1444: UPDATE cz_ps_nodes
1445: SET minimum = -SOLVER_MAX_DOUBLE
1446: WHERE devl_project_id = p_dev_project_id
1447: AND minimum IS NULL
1448: AND ps_node_type IN(PS_TYPE_TOTAL,PS_TYPE_RESOURCE)

Line 1491: cz_ps_nodes psnode

1487: exp2.expr_parent_id exp2parentid,
1488: exp2.rule_id , psnode.ps_node_id
1489: FROM cz_expression_nodes exp1,
1490: cz_expression_nodes exp2,
1491: cz_ps_nodes psnode
1492: WHERE exp1.deleted_flag ='0'
1493: AND exp2.deleted_flag ='0'
1494: AND exp1.template_id IN(1, 2, 3, 4, 5)
1495: AND exp2.ps_node_id = psnode.ps_node_id

Line 1526: cz_ps_nodes ps1,

1522: AND EXISTS
1523: (SELECT 1
1524: FROM cz_expression_nodes expin1,
1525: cz_expression_nodes expin2,
1526: cz_ps_nodes ps1,
1527: cz_ps_nodes ps2
1528: WHERE expin1.expr_node_id = exp1.expr_parent_id
1529: AND expin2.expr_node_id = exp2.expr_parent_id
1530: AND expin2.ps_node_id = ps2.ps_node_id

Line 1527: cz_ps_nodes ps2

1523: (SELECT 1
1524: FROM cz_expression_nodes expin1,
1525: cz_expression_nodes expin2,
1526: cz_ps_nodes ps1,
1527: cz_ps_nodes ps2
1528: WHERE expin1.expr_node_id = exp1.expr_parent_id
1529: AND expin2.expr_node_id = exp2.expr_parent_id
1530: AND expin2.ps_node_id = ps2.ps_node_id
1531: AND expin1.ps_node_id = ps1.ps_node_id

Line 1546: cz_ps_nodes ps,

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

Line 1547: cz_ps_nodes ps1,

1543: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
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

Line 1586: cz_ps_nodes ps1,

1582: AND EXISTS
1583: (SELECT 1
1584: FROM cz_expression_nodes expin1,
1585: cz_expression_nodes expin2,
1586: cz_ps_nodes ps1,
1587: cz_ps_nodes ps2
1588: WHERE expin1.expr_node_id = exp1.expr_parent_id
1589: AND expin2.expr_node_id = exp2.expr_parent_id
1590: AND expin2.ps_node_id = ps2.ps_node_id

Line 1587: cz_ps_nodes ps2

1583: (SELECT 1
1584: FROM cz_expression_nodes expin1,
1585: cz_expression_nodes expin2,
1586: cz_ps_nodes ps1,
1587: cz_ps_nodes ps2
1588: WHERE expin1.expr_node_id = exp1.expr_parent_id
1589: AND expin2.expr_node_id = exp2.expr_parent_id
1590: AND expin2.ps_node_id = ps2.ps_node_id
1591: AND expin1.ps_node_id = ps1.ps_node_id

Line 1600: cz_ps_nodes ps,

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

Line 1601: cz_ps_nodes ps1,

1597: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
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

Line 1619: l_ps_node_name cz_ps_nodes.name%type;

1615: l_numeric_participant c_numeric_participant%rowtype;
1616: minseq NUMBER;
1617: maxseq NUMBER;
1618: l_expression_node_id1 cz_expression_nodes.expr_node_id%TYPE;
1619: l_ps_node_name cz_ps_nodes.name%type;
1620: l_msg VARCHAR2(2000);
1621: l_cz_rules_id cz_rules.rule_id%TYPE;
1622: BEGIN
1623:

Line 1756: cz_ps_nodes psnode

1752: UPDATE CZ_RULES set presentation_flag=0 where rule_id in
1753: (SELECT exp2.rule_id
1754: FROM cz_expression_nodes exp1,
1755: cz_expression_nodes exp2,
1756: cz_ps_nodes psnode
1757: WHERE exp1.deleted_flag ='0'
1758: AND exp2.deleted_flag ='0'
1759: AND exp1.template_id IN(1, 2, 3, 4, 5)
1760: AND exp2.ps_node_id = psnode.ps_node_id

Line 1852: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;

1848: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1849:
1850:
1851: -- insert record for const 0 under > record
1852: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1853: displayMessage(3,p_dev_project_id , 'RULE' ,l_numeric_participant.rule_id ,l_api_name,'CZ_CNV_ADV_NUM_IN_LOGIC','NODENAME1', l_ps_node_name,'NODENAME2', l_ps_node_name);
1854: DELETE FROM cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id=21;
1855: populate_cz_tables(true);
1856: cz_rule_text_gen.parse_rules(p_dev_project_id, l_numeric_participant.rule_id);

Line 1981: FROM cz_ps_nodes psout

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
1982: WHERE ps_node_type = PS_TYPE_REFERENCE
1983: AND devl_project_id = p_dev_project_id
1984: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
1985: AND component_id IN

Line 1987: FROM cz_ps_nodes psin

1983: AND devl_project_id = p_dev_project_id
1984: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
1985: AND component_id IN
1986: (SELECT ps_node_id
1987: FROM cz_ps_nodes psin
1988: WHERE ps_node_type = PS_TYPE_BOM_MODEL)
1989: ;
1990: l_msg VARCHAR2(2000);
1991: l_api_name constant VARCHAR2(30) := 'processModel';

Line 2002: FROM cz_ps_nodes

1998: nvl(initial_value,initial_num_value ) initial_value,
1999: minimum,
2000: maximum,
2001: virtual_flag,name, ROWID
2002: FROM cz_ps_nodes
2003: WHERE(ps_node_type IN(PS_TYPE_FEATURE, PS_TYPE_TOTAL, PS_TYPE_RESOURCE, PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM, PS_TYPE_OPTION)
2004: OR(ps_node_type = PS_TYPE_COMPONENT AND virtual_flag = 1)) AND devl_project_id = p_dev_project_id)
2005: LOOP
2006: -- kdande; 09-Jan-2008; Bug 6722494

Line 2008: UPDATE cz_ps_nodes

2004: OR(ps_node_type = PS_TYPE_COMPONENT AND virtual_flag = 1)) AND devl_project_id = p_dev_project_id)
2005: LOOP
2006: -- kdande; 09-Jan-2008; Bug 6722494
2007: IF ((v_ps_node.minimum IS NOT NULL) AND (v_ps_node.ps_node_type = PS_TYPE_FEATURE) AND (v_ps_node.feature_type = FEATURE_TYPE_TEXT)) THEN
2008: UPDATE cz_ps_nodes
2009: SET user_input_required_flag = DECODE (v_ps_node.minimum, 1, '1', '0')
2010: WHERE ROWID = v_ps_node.ROWID;
2011: END IF;
2012:

Line 2033: UPDATE cz_ps_nodes psout

2029: removeEffectivityInfo(p_dev_project_id);
2030: -- Settings for Initial Minimum and Maximum Instances removed; BOM Maximum Quantity setting now defines the
2031: --total Quantity allowed across all Instances.
2032:
2033: UPDATE cz_ps_nodes psout
2034: SET maximum = NULL,
2035: minimum = NULL
2036: WHERE ps_node_type = PS_TYPE_REFERENCE
2037: AND devl_project_id = p_dev_project_id

Line 2040: FROM cz_ps_nodes psin

2036: WHERE ps_node_type = PS_TYPE_REFERENCE
2037: AND devl_project_id = p_dev_project_id
2038: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
2039: AND component_id IN (SELECT ps_node_id
2040: FROM cz_ps_nodes psin
2041: WHERE ps_node_type = PS_TYPE_BOM_MODEL);
2042:
2043: FOR v_ps_node_id IN c_bom_minmax
2044: LOOP