[Home] [Help]
984: in_update_flag IN VARCHAR2 -- DEFAULT NO_FLAG
985: ) IS
986:
987: BEGIN
988: UPDATE CZ_UI_NODE_PROPS SET value_str=in_value WHERE ui_node_id=in_ui_node_id AND key_str=in_name;
989: IF SQL%ROWCOUNT=0 THEN
990: INSERT INTO CZ_UI_NODE_PROPS(ui_node_id,ui_def_id,key_str,value_str,deleted_flag)
991: VALUES(in_ui_node_id,in_ui_def_id,in_name,in_value,NO_FLAG);
992: END IF;
986:
987: BEGIN
988: UPDATE CZ_UI_NODE_PROPS SET value_str=in_value WHERE ui_node_id=in_ui_node_id AND key_str=in_name;
989: IF SQL%ROWCOUNT=0 THEN
990: INSERT INTO CZ_UI_NODE_PROPS(ui_node_id,ui_def_id,key_str,value_str,deleted_flag)
991: VALUES(in_ui_node_id,in_ui_def_id,in_name,in_value,NO_FLAG);
992: END IF;
993: END set_UI_NODE_PROPS;
994:
1045: in_show_all_nodes IN VARCHAR2,
1046: in_ps_node_id IN NUMBER DEFAULT NULL,
1047: in_rule_id IN NUMBER DEFAULT NULL) IS
1048:
1049: var_ui_def_id CZ_UI_NODE_PROPS.ui_def_id%TYPE;
1050: var_persistent_node_id NUMBER;
1051: var_feature_type VARCHAR2(1);
1052: var_control_type VARCHAR2(1);
1053:
1163: IF in_max IS NOT NULL THEN
1164: set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Max',in_max,in_update_flag);
1165: ELSE
1166: IF in_update_flag=YES_FLAG THEN
1167: DELETE FROM CZ_UI_NODE_PROPS WHERE ui_node_id=in_ui_node_id AND key_str='Max';
1168: END IF;
1169: END IF;
1170: set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Min',in_min,in_update_flag);
1171: END IF;
1426: in_hierarchy IN VARCHAR2, -- DEFAULT NO_FLAG,
1427: in_align IN VARCHAR2 -- DEFAULT NULL
1428: ) IS
1429:
1430: var_ui_def_id CZ_UI_NODE_PROPS.ui_def_id%TYPE;
1431: var_feature_type VARCHAR2(1);
1432: var_control_type VARCHAR2(1);
1433:
1434: BEGIN
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
2553: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
2554: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
2555: var_align CZ_UI_NODE_PROPS.value_str%TYPE;
2556: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2557: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2558: var_use_labels VARCHAR2(1);
2559: Top_Labeled BOOLEAN:=FALSE;
2630: -- because there is just one screen that contains a STANDART ITEM
2631: -- associated with the given reference
2632: -- ( the reference and the STANDART ITEM have the same ps_node_id )
2633: --
2634: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
2635: WHERE ui_node_id=var_ui_parent_id
2636: AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
2637: EXCEPTION
2638: WHEN NO_DATA_FOUND THEN
6668: WHERE component_id=var_reference_id AND ui_style=mUI_STYLE AND
6669: look_and_feel=mLOOK_AND_FEEL AND deleted_flag=NO_FLAG;
6670:
6671: BEGIN
6672: SELECT value_str INTO var_wizard_style FROM CZ_UI_NODE_PROPS
6673: WHERE ui_def_id=var_ui_def_id AND ui_node_id=
6674: (SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=var_ui_def_id AND
6675: ui_node_id=parent_id AND deleted_flag=NO_FLAG) AND key_str='WizardStyle' AND
6676: deleted_flag=NO_FLAG;
7310: fontbold,fontcolor,fontunderline,fontsize,fontname,
7311: backgroundstyle,controltype,backgroundpicture,borders,picturename,func_comp_id
7312: FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7313:
7314: INSERT INTO CZ_UI_NODE_PROPS(ui_def_id,ui_node_id,key_str,value_str,deleted_flag)
7315: SELECT in_new_def_id,new_ui_node_id,key_str,value_str,'0' FROM CZ_UI_NODE_PROPS
7316: WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7317:
7318: EXCEPTION
7311: backgroundstyle,controltype,backgroundpicture,borders,picturename,func_comp_id
7312: FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7313:
7314: INSERT INTO CZ_UI_NODE_PROPS(ui_def_id,ui_node_id,key_str,value_str,deleted_flag)
7315: SELECT in_new_def_id,new_ui_node_id,key_str,value_str,'0' FROM CZ_UI_NODE_PROPS
7316: WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7317:
7318: EXCEPTION
7319: WHEN NO_DATA_FOUND THEN
7501: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
7502:
7503: FUNCTION getUseLabelsProperty(p_ui_node_id IN NUMBER ,p_property_name IN VARCHAR2) RETURN VARCHAR2 IS
7504:
7505: v_use_labels CZ_UI_NODE_PROPS.value_str%TYPE:='1';
7506:
7507: BEGIN
7508: SELECT value_str INTO v_use_labels FROM CZ_UI_NODE_PROPS
7509: WHERE ui_node_id=p_ui_node_id AND key_str=p_property_name AND deleted_flag='0';
7504:
7505: v_use_labels CZ_UI_NODE_PROPS.value_str%TYPE:='1';
7506:
7507: BEGIN
7508: SELECT value_str INTO v_use_labels FROM CZ_UI_NODE_PROPS
7509: WHERE ui_node_id=p_ui_node_id AND key_str=p_property_name AND deleted_flag='0';
7510: RETURN v_use_labels;
7511: EXCEPTION
7512: WHEN OTHERS THEN
7814: SELECT look_and_feel INTO mLOOK_AND_FEEL FROM CZ_UI_DEFS
7815: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
7816:
7817: BEGIN
7818: SELECT value_str INTO mUSE_LABELS FROM CZ_UI_NODE_PROPS
7819: WHERE key_str='UseLabels' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
7820: EXCEPTION
7821: WHEN NO_DATA_FOUND THEN
7822: --
7825: mUSE_LABELS:='1';
7826: END;
7827:
7828: BEGIN
7829: SELECT value_str INTO mSHOW_ALL_NODES FROM CZ_UI_NODE_PROPS
7830: WHERE key_str='ShowAllNodes' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
7831: EXCEPTION
7832: WHEN NO_DATA_FOUND THEN
7833: --
7836: mSHOW_ALL_NODES:='0';
7837: END;
7838:
7839: BEGIN
7840: SELECT value_str INTO var_frame_allocation FROM CZ_UI_NODE_PROPS
7841: WHERE key_str='NavFrameAllocation' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
7842: EXCEPTION
7843: WHEN NO_DATA_FOUND THEN
7844: --
7847: var_frame_allocation:=30;
7848: END;
7849:
7850: BEGIN
7851: SELECT value_str INTO mWIZARD_STYLE FROM CZ_UI_NODE_PROPS
7852: WHERE UPPER(key_str)='WIZARDSTYLE' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
7853: EXCEPTION
7854: WHEN NO_DATA_FOUND THEN
7855: mWIZARD_STYLE:='0';
7855: mWIZARD_STYLE:='0';
7856: END;
7857:
7858: BEGIN
7859: SELECT value_str INTO mITEMS_ON_PAGE FROM CZ_UI_NODE_PROPS
7860: WHERE UPPER(key_str)='MAXBOMITEMSONPAGE'
7861: AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
7862: EXCEPTION
7863: WHEN NO_DATA_FOUND THEN
7939: UPDATE CZ_UI_NODES u
7940: SET deleted_flag=YES_FLAG
7941: WHERE u.ui_def_id=in_ui_def_id AND u.ui_node_type=UI_BUTTON_TYPE AND
7942: u.deleted_flag=NO_FLAG AND
7943: EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS p
7944: WHERE p.key_str='RuleId' AND p.ui_def_id=u.ui_def_id AND p.ui_node_id=u.ui_node_id AND p.deleted_flag=NO_FLAG AND
7945: TO_NUMBER(value_str) NOT IN
7946: (SELECT r.rule_id FROM CZ_RULES r WHERE r.devl_project_id=Project_id AND
7947: r.rule_type=CZ_EXTENTSIONS_RULE_TYPE AND r.deleted_flag=NO_FLAG));
8105: curr_node_id:=getUISeqVal;
8106: var_use_labels:= mUSE_LABELS;
8107: IF i.ps_node_type IN(OPTION_NODE_TYPE,BOM_STANDART_NODE_TYPE) THEN
8108: BEGIN
8109: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
8110: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
8111: EXCEPTION
8112: WHEN NO_DATA_FOUND THEN
8113: NULL;
8292: -- because there is just one screen that contains a STANDART ITEM
8293: -- associated with the given reference
8294: -- ( the reference and the STANDART ITEM have the same ps_node_id )
8295: --
8296: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
8297: WHERE ui_node_id=(SELECT parent_id FROM CZ_UI_NODES
8298: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG AND
8299: ui_node_type=UI_BOM_STANDART_TYPE AND parent_id<>var_limbo_id)
8300: AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
8328: --var_ref_id:=get_last_UI(i.reference_id);
8329: var_ref_id:=var_ui_def_ref_id;
8330:
8331: BEGIN
8332: SELECT value_str INTO var_curr_virtual_flag FROM CZ_UI_NODE_PROPS
8333: WHERE ui_def_id=in_ui_def_id AND
8334: ui_node_id=var_screen_ui_id AND key_str='IsVirtual' AND deleted_flag=NO_FLAG ;
8335: EXCEPTION
8336: WHEN NO_DATA_FOUND THEN
8414:
8415: --
8416: -- refresh 'IsVirtual' property of this reference --
8417: --
8418: UPDATE CZ_UI_NODE_PROPS SET value_str=i.virtual_flag
8419: WHERE ui_def_id=in_ui_def_id AND
8420: ui_node_id=var_screen_ui_id AND key_str='IsVirtual' AND deleted_flag=NO_FLAG ;
8421:
8422: --
8664: SELECT YES_FLAG INTO existsDeleteMe FROM dual WHERE
8665: EXISTS(SELECT NULL FROM CZ_UI_NODES a WHERE
8666: a.ui_def_id=var_ref_id AND a.ui_node_type=UI_BUTTON_TYPE AND a.parent_id=var_ui_root_id
8667: AND a.parent_id<>var_limbo_id AND a.deleted_flag=NO_FLAG AND a.modified_flags=0
8668: AND EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS b
8669: WHERE b.ui_def_id=var_ref_id AND b.ui_node_id=a.ui_node_id
8670: AND b.key_str='ActionType' AND b.value_str='1'));
8671:
8672: EXCEPTION
8768: END LOOP;
8769:
8770: var_use_labels:=mUSE_LABELS;
8771: BEGIN
8772: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
8773: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
8774: AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG ;
8775: EXCEPTION
8776: WHEN NO_DATA_FOUND THEN
8845: END LOOP;
8846:
8847: var_use_labels:=mUSE_LABELS;
8848: BEGIN
8849: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
8850: WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_bom_pages(x).ui_node_id
8851: AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG ;
8852: EXCEPTION
8853: WHEN NO_DATA_FOUND THEN
8903:
8904: /* *** find IsVirtual property for UI node from Component Tree which *** */
8905: /* *** is associated with screen of this Component/Products/BOM Model/BOM Class *** */
8906:
8907: SELECT value_str INTO var_curr_virtual_flag FROM CZ_UI_NODE_PROPS WHERE
8908: ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='IsVirtual'
8909: AND deleted_flag=NO_FLAG;
8910:
8911: /* ***
8908: ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='IsVirtual'
8909: AND deleted_flag=NO_FLAG;
8910:
8911: /* ***
8912: SELECT value_str INTO var_curr_max FROM CZ_UI_NODE_PROPS WHERE
8913: ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='Max'
8914: AND deleted_flag=NO_FLAG;
8915:
8916: SELECT value_str INTO var_curr_min FROM CZ_UI_NODE_PROPS WHERE
8912: SELECT value_str INTO var_curr_max FROM CZ_UI_NODE_PROPS WHERE
8913: ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='Max'
8914: AND deleted_flag=NO_FLAG;
8915:
8916: SELECT value_str INTO var_curr_min FROM CZ_UI_NODE_PROPS WHERE
8917: ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='Min'
8918: AND deleted_flag=NO_FLAG;
8919: */
8920:
9035: END IF;
9036:
9037: var_use_labels:='1';
9038: BEGIN
9039: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
9040: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id AND UPPER(key_str)='USELABELS'
9041: AND deleted_flag=NO_FLAG ;
9042: EXCEPTION
9043: WHEN NO_DATA_FOUND THEN
9122: END IF;
9123:
9124: BEGIN
9125: var_ui_max:=NULL;
9126: SELECT TO_NUMBER(value_str) INTO var_ui_max FROM CZ_UI_NODE_PROPS
9127: WHERE ui_node_id=var_screen_ui_id AND key_str='Max' AND deleted_flag=NO_FLAG;
9128: EXCEPTION
9129: WHEN NO_DATA_FOUND THEN
9130: NULL;
9131: END;
9132:
9133: BEGIN
9134: var_ui_min:=NULL;
9135: SELECT TO_NUMBER(value_str) INTO var_ui_min FROM CZ_UI_NODE_PROPS
9136: WHERE ui_node_id=var_screen_ui_id AND key_str='Min' AND deleted_flag=NO_FLAG;
9137: EXCEPTION
9138: WHEN NO_DATA_FOUND THEN
9139: NULL;
9140: END;
9141:
9142: BEGIN
9143: var_ui_counted_options:=NO_FLAG;
9144: SELECT value_str INTO var_ui_counted_options FROM CZ_UI_NODE_PROPS
9145: WHERE ui_node_id=var_screen_ui_id AND key_str='CountedOptions' AND deleted_flag=NO_FLAG;
9146: EXCEPTION
9147: WHEN NO_DATA_FOUND THEN
9148: NULL;
9149: END;
9150:
9151: var_use_labels:=mUSE_LABELS;
9152: BEGIN
9153: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
9154: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id AND UPPER(key_str)='USELABELS'
9155: AND deleted_flag=NO_FLAG;
9156: EXCEPTION
9157: WHEN NO_DATA_FOUND THEN
9248: var_feature_type:='4';
9249: var_control_type:=6;
9250: END IF;
9251:
9252: SELECT TO_NUMBER(value_str) INTO var_ui_feature_type FROM CZ_UI_NODE_PROPS
9253: WHERE ui_node_id=var_screen_ui_id AND key_str='FeatureType' AND deleted_flag=NO_FLAG;
9254:
9255: /* *** changed Feature type case *** */
9256: IF var_ui_feature_type<>var_feature_type OR
9990: -- 1100 = 12
9991: -- 1110 = 14
9992: --
9993: IF h.companion_type IN(4,6,12,14) THEN
9994: UPDATE CZ_UI_NODE_PROPS SET value_str='5' WHERE ui_def_id=in_ui_def_id
9995: AND ui_node_id=h.ui_node_id AND key_str='ActionType';
9996:
9997: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
9998: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
10012: -- 1001 = 9
10013: -- 1011 = 11
10014: --
10015: IF h.companion_type IN(1,3,9,11) THEN
10016: UPDATE CZ_UI_NODE_PROPS SET value_str='6' WHERE ui_def_id=in_ui_def_id
10017: and ui_node_id=h.ui_node_id AND key_str='ActionType';
10018:
10019: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
10020: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
10035: -- 1111 = 15
10036: --
10037: IF h.companion_type IN(5,7,13,15) THEN
10038: BEGIN
10039: SELECT value_str INTO var_action_type FROM CZ_UI_NODE_PROPS
10040: WHERE ui_def_id=in_ui_def_id AND ui_node_id=h.ui_node_id AND key_str='ActionType'
10041: AND deleted_flag=NO_FLAG;
10042:
10043: var_button_id:=getUISeqVal;