[Home] [Help]
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;
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';
8270: IF i.name<>var_screen_name THEN
8271: UPDATE CZ_UI_NODES SET name=i.name
8272: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id;
8273: IF i.intl_text_id IS NULL THEN
8274: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8275: WHERE intl_text_id=var_screen_caption_id
8276: AND var_modified_flags=0;
8277: END IF;
8278: END IF;
8743: UPDATE CZ_UI_NODES SET name=i.name
8744: WHERE ui_def_id=in_ui_def_id
8745: AND ui_node_id=var_screen_ui_id;
8746:
8747: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8748: WHERE intl_text_id=var_screen_caption_id;
8749:
8750: IF i.intl_text_id IS NULL THEN
8751: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8747: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8748: WHERE intl_text_id=var_screen_caption_id;
8749:
8750: IF i.intl_text_id IS NULL THEN
8751: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8752: WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
8753: AND var_modified_flags=0;
8754: END IF;
8755: END IF;
8796: IF i.name<>t_bom_pages(x).name THEN
8797: UPDATE CZ_UI_NODES SET name=i.name||var_suffix
8798: WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_bom_pages(x).ui_node_id;
8799:
8800: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8801: WHERE intl_text_id=t_bom_pages(x).text_id;
8802:
8803: IF i.intl_text_id IS NULL THEN
8804: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8800: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8801: WHERE intl_text_id=t_bom_pages(x).text_id;
8802:
8803: IF i.intl_text_id IS NULL THEN
8804: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8805: WHERE intl_text_id=t_bom_pages(x).label_txt_id
8806: AND var_modified_flags=0;
8807:
8808: --
8868: IF i.name<>var_screen_name THEN
8869: UPDATE CZ_UI_NODES SET name=i.name
8870: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
8871: AND modified_flags=0;
8872: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8873: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8874: IF i.intl_text_id IS NULL THEN
8875: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8876: WHERE intl_text_id=var_text_label_caption_id
8871: AND modified_flags=0;
8872: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8873: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8874: IF i.intl_text_id IS NULL THEN
8875: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8876: WHERE intl_text_id=var_text_label_caption_id
8877: AND var_modified_flags=0;
8878: END IF;
8879: END IF;
8988: IF i.name<>var_screen_name THEN
8989: UPDATE CZ_UI_NODES SET name=i.name
8990: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
8991: AND modified_flags=0;
8992: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8993: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8994: IF i.intl_text_id IS NULL THEN
8995: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8996: WHERE intl_text_id=var_text_label_caption_id
8991: AND modified_flags=0;
8992: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8993: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8994: IF i.intl_text_id IS NULL THEN
8995: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8996: WHERE intl_text_id=var_text_label_caption_id
8997: AND var_modified_flags=0;
8998: END IF;
8999: END IF;
9075: IF i.name<>var_screen_name THEN
9076: UPDATE CZ_UI_NODES SET name=i.name
9077: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
9078: AND modified_flags=0 ;
9079: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9080: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
9081: IF i.intl_text_id IS NULL THEN
9082: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9083: WHERE intl_text_id=var_text_label_caption_id
9078: AND modified_flags=0 ;
9079: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9080: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
9081: IF i.intl_text_id IS NULL THEN
9082: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9083: WHERE intl_text_id=var_text_label_caption_id
9084: AND var_modified_flags=0;
9085: END IF;
9086: END IF;
9207: END LOOP;
9208:
9209: ELSE
9210: var_label:=getTextByProperty(var_option_ps_id,var_screen_ui_id);
9211: UPDATE CZ_INTL_TEXTS SET text_str=var_label
9212: WHERE intl_text_id=var_option_caption_id;
9213: END IF;
9214:
9215: EXCEPTION
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;
9999: IF SQL%ROWCOUNT>0 THEN
10000: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
10001: END IF;
10002:
10003: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
10004: func_comp_id=h.func_comp_id and ui_node_id>h.ui_node_id AND
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;
10021: IF SQL%ROWCOUNT>0 THEN
10022: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
10023: END IF;
10024:
10025: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
10026: func_comp_id=h.func_comp_id AND ui_node_id>h.ui_node_id AND