[Home] [Help]
578: --
579: IF currentUINode
581: ELSE
582: SELECT CZ_UI_NODES_S.nextval INTO currUISeqVal FROM dual;
583: currentUINode:=currUISeqVal;
584: END IF;
585: RETURN currentUINode;
586: END getUISeqVal;
618: BEGIN
619: IF currentTXTNode
621: ELSE
622: SELECT CZ_INTL_TEXTS_S.nextval INTO currTXTSeqVal FROM dual;
623: currentTXTNode:=currTXTSeqVal;
624: END IF;
625: RETURN currentTXTNode;
626: END getTXTSeqVal;
664: latest_buttons.DELETE;
665: footer_buttons.DELETE;
666: ref_boms.DELETE;
667:
668: SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;
669: currUISeqVal:=currentUINode;
670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
671: currentTXTNode:=currTXTSeqVal;
672:
666: ref_boms.DELETE;
667:
668: SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;
669: currUISeqVal:=currentUINode;
670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
671: currentTXTNode:=currTXTSeqVal;
672:
673: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
674: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';
2907: BEGIN
2908: existsDeleteMe:=NO_FLAG;
2909: ERROR_CODE:='00202';
2910:
2911: SELECT YES_FLAG INTO existsDeleteMe FROM dual
2912: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
2913: WHERE ui_def_id=in_ui_def_id AND ps_node_id=Project_Id AND
2914: name=CZ_DELETE_BUTTON_CAPTION);
2915: ERROR_CODE:='00203';
2948: SELECT devl_project_id INTO var_model_id FROM CZ_UI_DEFS
2949: WHERE ui_def_id=out_ref_ui_id AND deleted_flag=NO_FLAG;
2950: ERROR_CODE:='00208';
2951:
2952: SELECT YES_FLAG INTO existsDeleteMe FROM dual
2953: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
2954: WHERE ui_def_id=out_ref_ui_id AND ps_node_id=var_model_Id AND
2955: name=CZ_DELETE_BUTTON_CAPTION);
2956: ERROR_CODE:='00209';
3442:
3443: OPEN c1;
3444: FETCH c1 INTO var_c1;
3445: IF c1%NOTFOUND THEN
3446: SELECT CZ_UI_DEFS_S.NEXTVAL INTO MUID FROM DUAL;
3447:
3448: INSERT INTO CZ_UI_DEFS(ui_def_id,name,devl_project_id,component_id,
3449: ui_style,gen_version,gen_header,look_and_feel,deleted_flag)
3450: VALUES(MUID,'MUID',Project_Id,NULL,-1,GLOBAL_GEN_VERSION,GLOBAL_GEN_HEADER,NULL,NO_FLAG);
3451:
3452: END IF;
3453: CLOSE c1;
3454:
3455: SELECT CZ_UI_DEFS_S.NEXTVAL INTO var_ui_def_id FROM DUAL;
3456:
3457: UI_Version:=generateUIVersion(Project_id);
3458: IF UI_Version>1 THEN
3459: InterfaceName:=SUBSTR(Model_Name||' User Interface '||TO_CHAR(UI_Version),1,255);
6598: NO_PROJECT EXCEPTION;
6599:
6600: BEGIN
6601: out_run_id:=0;
6602: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
6603:
6604: mSHOW_ALL_NODES:=in_show_all_nodes;
6605: mITEMS_ON_PAGE:=in_max_bom_per_page;
6606: mWIZARD_STYLE:=in_wizard_style;
6712:
6713: IF in_ui_style=DHTML_STYLE_UI THEN
6714: BEGIN
6715: existsDeleteMe:=NO_FLAG;
6716: SELECT YES_FLAG INTO existsDeleteMe FROM dual
6717: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
6718: WHERE ui_def_id=var_ui_def_id AND ps_node_id=var_reference_id
6719: AND ui_node_type=UI_BUTTON_TYPE AND name=CZ_DELETE_BUTTON_CAPTION);
6720: EXCEPTION
7808: last_TOP_POS:=DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN;
7809: last_HEIGHT:=DEFAULT_CONTROL_HEIGHT;
7810:
7811: out_run_id:=0;
7812: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
7813:
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:
7915: END;
7916:
7917: deletedNodes:=0;
7918:
7919: SELECT COUNT('1') INTO deletedNodes FROM dual WHERE
7920: EXISTS(SELECT NULL FROM CZ_PS_NODES
7921: WHERE devl_project_id=Project_Id AND
7922: (ui_omit=YES_FLAG OR deleted_flag=YES_FLAG));
7923:
8516: --
8517: -- check : is there a button that associated with this reference --
8518: --
8519: BEGIN
8520: SELECT YES_FLAG INTO existsButton FROM dual WHERE
8521: EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
8522: AND ui_node_type=UI_BUTTON_TYPE AND ps_node_id=i.ps_node_id AND
8523: deleted_flag=NO_FLAG);
8524: RAISE BUTTON_EXISTS;
8554: IF var_ui_node_type=UI_BOM_STANDART_TYPE AND BomType=YES_FLAG THEN
8555:
8556: BEGIN
8557: /*
8558: SELECT YES_FLAG INTO existsSTANDART_ITEM FROM dual WHERE
8559: EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
8560: AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND ps_node_id=i.ps_node_id AND
8561: deleted_flag=NO_FLAG);
8562: */
8660: WHERE ui_def_id=var_ref_id AND ps_node_id=var_model_Id AND
8661: ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE)
8662: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8663:
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
9464: END IF;
9465:
9466: BEGIN
9467: existRefUI:='0';
9468: SELECT '1' INTO existRefUI FROM dual WHERE
9469: EXISTS(SELECT 1 FROM CZ_UI_DEFS WHERE devl_project_id=news(k).reference_id AND ui_style=mUI_STYLE
9470: AND deleted_flag=NO_FLAG);
9471: EXCEPTION
9472: WHEN NO_DATA_FOUND THEN
9878: /***
9879: BEGIN
9880: v_just_OC:='0';
9881:
9882: SELECT '1' INTO v_just_OC FROM DUAL WHERE EXISTS
9883: (SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
9884: AND ui_node_ref_id IS NOT NULL
9885: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG
9886: AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
10266: BEGIN
10267: --
10268: -- find Language Code of current session --
10269: --
10270: SELECT USERENV('LANG') INTO mCURRENT_LANG FROM dual;
10271:
10272: --
10273: -- find concatenation symbol - it is used for "Name and Decsription" UI labels --
10274: --