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:
805: v_cz_rule_count:=v_cz_rule_count+1;

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

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

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

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

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

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

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

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;
947: l_mod_ref cz_expression_nodes.MODEL_REF_EXPL_ID%type;
948: l_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
949: BEGIN
950: IF initialvalue IS NOT NULL THEN
951:
952: -- Insert AddTo expression record;

Line 1004: 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) ;

1000: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1001:
1002: IF p_model_ref_expl_id IS NULL THEN
1003: l_ps_node_id :=ps_node_id;
1004: 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) ;
1005: ELSE
1006: l_mod_ref:=p_model_ref_expl_id; -- use model_ref_expl_id from parent contribute / consume rule .
1007: END IF;
1008:

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

1043: END createAccumulatorRule;
1044:
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

Line 1048: p_ps_node_type IN cz_ps_nodes.ps_node_type%TYPE, feature_type IN cz_ps_nodes.feature_type%TYPE,

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

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

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

Line 1065: cz_ps_nodes ps

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
1066: WHERE r.deleted_flag = '0'
1067: AND e.deleted_flag = '0'
1068: AND e1.deleted_flag = '0'
1069: AND p.deleted_flag = '0'

Line 1085: l_ps_node_name cz_ps_nodes.name%type;

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

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

1168: l_rule_class := RULE_CLASS_CONSTRAINT;
1169: --defaults
1170: -- create one additional Accumulator Rule to add the initial value to the target
1171: createAccumulatorRule(p_devl_project_id, p_ps_node_id, p_ps_node_type, initialvalue, minvalue, l_rule_id , null, feature_type);
1172: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;
1173: 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 );
1174: END IF;
1175: END IF;
1176:

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

1186:
1187: --refer section 4..1.3.3 for Boolean features
1188: insertImpliesRuleRecords(p_devl_project_id, p_ps_node_id, p_ps_node_type, l_rule_id, initialvalue );
1189: IF initialvalue IS NOT NULL THEN
1190: select name into l_ps_node_name from cz_ps_nodes where ps_node_id =p_ps_node_id;
1191: 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 );
1192: END IF;
1193: END IF;
1194: END IF;

Line 1208: UPDATE cz_ps_nodes

1204: PROCEDURE clearinitialvalues(p_dev_project_id IN cz_devl_projects.devl_project_id%TYPE) AS
1205: l_msg VARCHAR2(2000);
1206: l_api_name constant VARCHAR2(30) := 'ClearInitialValues';
1207: BEGIN
1208: UPDATE cz_ps_nodes
1209: SET initial_num_value = NULL
1210: WHERE devl_project_id = p_dev_project_id
1211: AND initial_num_value IS NOT NULL
1212: AND(ps_node_type IN(PS_TYPE_TOTAL, PS_TYPE_RESOURCE)

Line 1232: FROM cz_ps_nodes

1228: l_api_name constant VARCHAR2(30) := 'assignDefaultMinMaxvalues';
1229: BEGIN
1230: FOR c_processing IN
1231: (SELECT ps_node_id , feature_type
1232: FROM cz_ps_nodes
1233: WHERE devl_project_id = p_dev_project_id
1234: AND minimum IS NULL
1235: AND(ps_node_type = PS_TYPE_FEATURE
1236: AND feature_type IN(FEATURE_TYPE_INTEGER , FEATURE_TYPE_FLOAT)))

Line 1245: UPDATE cz_ps_nodes

1241: 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);
1242: END IF;
1243: END IF;
1244: END LOOP;
1245: UPDATE cz_ps_nodes
1246: SET minimum = decode(feature_type, FEATURE_TYPE_INTEGER, INTEGER_MIN_VAL, FEATURE_TYPE_FLOAT, -SOLVER_MAX_DOUBLE)
1247: WHERE devl_project_id = p_dev_project_id
1248: AND minimum IS NULL
1249: AND(ps_node_type = PS_TYPE_FEATURE

Line 1257: FROM cz_ps_nodes

1253: --
1254:
1255: FOR c_processing IN
1256: (SELECT ps_node_id
1257: FROM cz_ps_nodes
1258: WHERE devl_project_id = p_dev_project_id
1259: AND ps_node_type = PS_TYPE_FEATURE
1260: AND feature_type=FEATURE_TYPE_LIST_OF_OPTIONS
1261: AND counted_options_flag='1')

Line 1266: UPDATE cz_ps_nodes

1262: LOOP
1263: 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);
1264: END LOOP;
1265:
1266: UPDATE cz_ps_nodes
1267: SET MAX_QTY_PER_OPTION = fnd_profile.value('CZ_DEFAULT_MAX_QTY_INT')
1268: WHERE devl_project_id = p_dev_project_id
1269: AND ps_node_type = PS_TYPE_FEATURE
1270: AND feature_type=FEATURE_TYPE_LIST_OF_OPTIONS

Line 1277: FROM cz_ps_nodes

1273: --
1274:
1275: FOR c_processing IN
1276: (SELECT ps_node_id, feature_type
1277: FROM cz_ps_nodes
1278: WHERE devl_project_id = p_dev_project_id
1279: AND maximum IS NULL
1280: AND(ps_node_type = PS_TYPE_FEATURE
1281: AND feature_type IN(FEATURE_TYPE_INTEGER , FEATURE_TYPE_FLOAT , FEATURE_TYPE_LIST_OF_OPTIONS)))

Line 1291: UPDATE cz_ps_nodes

1287: 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);
1288: END IF;
1289: END IF;
1290: END LOOP;
1291: UPDATE cz_ps_nodes
1292: 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)
1293: WHERE devl_project_id = p_dev_project_id
1294: AND maximum IS NULL
1295: AND(ps_node_type = PS_TYPE_FEATURE

Line 1301: FROM cz_ps_nodes

1297:
1298: --
1299: FOR c_processing IN
1300: (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
1301: FROM cz_ps_nodes
1302: WHERE devl_project_id = p_dev_project_id
1303: AND ((maximum IS NULL OR maximum =-1)
1304: AND(ps_node_type IN(PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM)))
1305: )

Line 1310: UPDATE cz_ps_nodes

1306: LOOP
1307: 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);
1308: END LOOP;
1309:
1310: UPDATE cz_ps_nodes
1311: SET maximum = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE))
1312: WHERE devl_project_id = p_dev_project_id
1313: AND (maximum IS NULL OR maximum =-1)
1314: AND(ps_node_type IN(PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM));

Line 1318: UPDATE cz_ps_nodes

1314: AND(ps_node_type IN(PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM));
1315:
1316: ---Changed for bug 6737779
1317:
1318: UPDATE cz_ps_nodes
1319: SET minimum = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0 ,1 ))
1320: WHERE devl_project_id = p_dev_project_id
1321: AND (minimum IS NULL OR minimum =0)
1322: AND(ps_node_type IN(PS_TYPE_BOM_MODEL, PS_TYPE_BOM_OPTION_CLASS, PS_TYPE_BOM_STD_ITEM))

Line 1335: UPDATE cz_ps_nodes psout

1331: v_cz_ids_tbl.DELETE;
1332: v_cz_num_tbl.DELETE;
1333: END IF;
1334:
1335: UPDATE cz_ps_nodes psout
1336: SET minimum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0,1 ))
1337: WHERE devl_project_id = p_dev_project_id
1338: AND (minimum_selected IS NULL OR minimum_selected =0)
1339: AND(ps_node_type =PS_TYPE_REFERENCE)

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

1336: SET minimum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1,0,1 ))
1337: WHERE devl_project_id = p_dev_project_id
1338: AND (minimum_selected IS NULL OR minimum_selected =0)
1339: AND(ps_node_type =PS_TYPE_REFERENCE)
1340: AND EXISTS( SELECT 1 FROM cz_ps_nodes WHERE ps_node_id= psout.component_id
1341: AND ps_node_type =PS_TYPE_BOM_MODEL )
1342: RETURNING ps_node_id , minimum_selected BULK COLLECT INTO v_cz_ids_tbl , v_cz_num_tbl;
1343:
1344:

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

1353:
1354:
1355: --
1356:
1357: 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
1358: WHERE devl_project_id = p_dev_project_id
1359: AND (maximum_selected IS NULL OR maximum_selected =-1)
1360: AND(ps_node_type =PS_TYPE_REFERENCE)
1361: and item_id is not null

Line 1367: UPDATE cz_ps_nodes

1363:
1364: 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);
1365: END LOOP;
1366:
1367: UPDATE cz_ps_nodes
1368: SET maximum_selected = decode(USE_BOM_DEFAULT_QTY,'TRUE',initial_num_value,decode(decimal_qty_flag, 1, SOLVER_MAX_DOUBLE, INTEGER_MAX_VALUE))
1369: WHERE devl_project_id = p_dev_project_id
1370: AND (maximum_selected IS NULL OR maximum_selected =-1)
1371: AND(ps_node_type =PS_TYPE_REFERENCE)

Line 1379: UPDATE cz_ps_nodes

1375:
1376: ---
1377:
1378:
1379: UPDATE cz_ps_nodes
1380: SET maximum = INTEGER_MAX_VALUE
1381: WHERE devl_project_id = p_dev_project_id
1382: AND maximum IS NULL
1383: AND(ps_node_type IN(232))

Line 1398: UPDATE cz_ps_nodes

1394:
1395:
1396: ----- Update default maximum values for total and resource .
1397:
1398: UPDATE cz_ps_nodes
1399: SET maximum = DECODE(SIGN(nvl(initial_num_value,0) - SOLVER_MAX_DOUBLE), -1 , SOLVER_MAX_DOUBLE, 0 , SOLVER_MAX_DOUBLE , 1 , initial_num_value)
1400: WHERE devl_project_id = p_dev_project_id
1401: AND maximum IS NULL
1402: AND ps_node_type IN(PS_TYPE_TOTAL,PS_TYPE_RESOURCE)

Line 1416: UPDATE cz_ps_nodes

1412: END IF;
1413:
1414: ----
1415:
1416: UPDATE cz_ps_nodes
1417: SET minimum = -SOLVER_MAX_DOUBLE
1418: WHERE devl_project_id = p_dev_project_id
1419: AND minimum IS NULL
1420: AND ps_node_type IN(PS_TYPE_TOTAL,PS_TYPE_RESOURCE)

Line 1464: cz_ps_nodes psnode

1460: exp2.expr_parent_id exp2parentid,
1461: exp2.rule_id , psnode.ps_node_id
1462: FROM cz_expression_nodes exp1,
1463: cz_expression_nodes exp2,
1464: cz_ps_nodes psnode
1465: WHERE exp1.deleted_flag ='0'
1466: AND exp2.deleted_flag ='0'
1467: AND exp1.template_id IN(1, 2, 3, 4, 5)
1468: AND exp2.ps_node_id = psnode.ps_node_id

Line 1499: cz_ps_nodes ps1,

1495: AND EXISTS
1496: (SELECT 1
1497: FROM cz_expression_nodes expin1,
1498: cz_expression_nodes expin2,
1499: cz_ps_nodes ps1,
1500: cz_ps_nodes ps2
1501: WHERE expin1.expr_node_id = exp1.expr_parent_id
1502: AND expin2.expr_node_id = exp2.expr_parent_id
1503: AND expin2.ps_node_id = ps2.ps_node_id

Line 1500: cz_ps_nodes ps2

1496: (SELECT 1
1497: FROM cz_expression_nodes expin1,
1498: cz_expression_nodes expin2,
1499: cz_ps_nodes ps1,
1500: cz_ps_nodes ps2
1501: WHERE expin1.expr_node_id = exp1.expr_parent_id
1502: AND expin2.expr_node_id = exp2.expr_parent_id
1503: AND expin2.ps_node_id = ps2.ps_node_id
1504: AND expin1.ps_node_id = ps1.ps_node_id

Line 1519: cz_ps_nodes ps,

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

Line 1520: cz_ps_nodes ps1,

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

Line 1559: cz_ps_nodes ps1,

1555: AND EXISTS
1556: (SELECT 1
1557: FROM cz_expression_nodes expin1,
1558: cz_expression_nodes expin2,
1559: cz_ps_nodes ps1,
1560: cz_ps_nodes ps2
1561: WHERE expin1.expr_node_id = exp1.expr_parent_id
1562: AND expin2.expr_node_id = exp2.expr_parent_id
1563: AND expin2.ps_node_id = ps2.ps_node_id

Line 1560: cz_ps_nodes ps2

1556: (SELECT 1
1557: FROM cz_expression_nodes expin1,
1558: cz_expression_nodes expin2,
1559: cz_ps_nodes ps1,
1560: cz_ps_nodes ps2
1561: WHERE expin1.expr_node_id = exp1.expr_parent_id
1562: AND expin2.expr_node_id = exp2.expr_parent_id
1563: AND expin2.ps_node_id = ps2.ps_node_id
1564: AND expin1.ps_node_id = ps1.ps_node_id

Line 1573: cz_ps_nodes ps,

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

Line 1574: cz_ps_nodes ps1,

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

Line 1592: l_ps_node_name cz_ps_nodes.name%type;

1588: l_numeric_participant c_numeric_participant%rowtype;
1589: minseq NUMBER;
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:

Line 1729: cz_ps_nodes psnode

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
1730: WHERE exp1.deleted_flag ='0'
1731: AND exp2.deleted_flag ='0'
1732: AND exp1.template_id IN(1, 2, 3, 4, 5)
1733: AND exp2.ps_node_id = psnode.ps_node_id

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

1821: v_cz_expression_nodes(v_cz_expr_node_count).DATA_NUM_VALUE :='0' ;
1822:
1823:
1824: -- insert record for const 0 under > record
1825: SELECT name INTO l_ps_node_name from cz_ps_nodes where ps_node_id=l_numeric_participant.ps_node_id;
1826: 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);
1827: DELETE FROM cz_expression_nodes where rule_id= l_numeric_participant.rule_id and template_id=21;
1828: populate_cz_tables(true);
1829: cz_rule_text_gen.parse_rules(p_dev_project_id, l_numeric_participant.rule_id);

Line 1954: FROM cz_ps_nodes psout

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
1955: WHERE ps_node_type = PS_TYPE_REFERENCE
1956: AND devl_project_id = p_dev_project_id
1957: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
1958: AND component_id IN

Line 1960: FROM cz_ps_nodes psin

1956: AND devl_project_id = p_dev_project_id
1957: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
1958: AND component_id IN
1959: (SELECT ps_node_id
1960: FROM cz_ps_nodes psin
1961: WHERE ps_node_type = PS_TYPE_BOM_MODEL)
1962: ;
1963: l_msg VARCHAR2(2000);
1964: l_api_name constant VARCHAR2(30) := 'processModel';

Line 1975: FROM cz_ps_nodes

1971: nvl(initial_value,initial_num_value ) initial_value,
1972: minimum,
1973: maximum,
1974: virtual_flag,name, ROWID
1975: FROM cz_ps_nodes
1976: 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)
1977: OR(ps_node_type = PS_TYPE_COMPONENT AND virtual_flag = 1)) AND devl_project_id = p_dev_project_id)
1978: LOOP
1979: -- kdande; 09-Jan-2008; Bug 6722494

Line 1981: UPDATE cz_ps_nodes

1977: OR(ps_node_type = PS_TYPE_COMPONENT AND virtual_flag = 1)) AND devl_project_id = p_dev_project_id)
1978: LOOP
1979: -- kdande; 09-Jan-2008; Bug 6722494
1980: 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
1981: UPDATE cz_ps_nodes
1982: SET user_input_required_flag = DECODE (v_ps_node.minimum, 1, '1', '0')
1983: WHERE ROWID = v_ps_node.ROWID;
1984: END IF;
1985:

Line 2006: UPDATE cz_ps_nodes psout

2002: removeEffectivityInfo(p_dev_project_id);
2003: -- Settings for Initial Minimum and Maximum Instances removed; BOM Maximum Quantity setting now defines the
2004: --total Quantity allowed across all Instances.
2005:
2006: UPDATE cz_ps_nodes psout
2007: SET maximum = NULL,
2008: minimum = NULL
2009: WHERE ps_node_type = PS_TYPE_REFERENCE
2010: AND devl_project_id = p_dev_project_id

Line 2013: FROM cz_ps_nodes psin

2009: WHERE ps_node_type = PS_TYPE_REFERENCE
2010: AND devl_project_id = p_dev_project_id
2011: AND instantiable_flag = NODE_INSTANTIABILITY_MULTIPLE
2012: AND component_id IN (SELECT ps_node_id
2013: FROM cz_ps_nodes psin
2014: WHERE ps_node_type = PS_TYPE_BOM_MODEL);
2015:
2016: FOR v_ps_node_id IN c_bom_minmax
2017: LOOP