[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';
CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
DEF_PRODUCT_SELECTION CONSTANT INTEGER:=4;
DEF_DELETE_BUTTON CONSTANT INTEGER:=100;
DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
INSERT INTO CZ_DB_LOGS
(RUN_ID,
LOGTIME,
LOGUSER,
URGENCY,
CALLER,
STATUSCODE,
MESSAGE)
VALUES (GLOBAL_RUN_ID,
SYSDATE,
USER,
in_urgency,
in_caller,
var_status,
in_error_message);
SELECT MESSAGE_TEXT INTO var_message_text FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME=in_message AND language_code=mCURRENT_LANG;
CZ_UPDATE_BUTTON_CAPTION :=getMessage('CZ_UPDATE_BUTTON_CAPTION');
CZ_UPDATE_BUTTON_CAPTION :='Update';
SELECT CZ_UI_NODES_S.nextval INTO currUISeqVal FROM dual;
SELECT CZ_INTL_TEXTS_S.nextval INTO currTXTSeqVal FROM dual;
SELECT NVL(MAX(rel_top_pos),50) INTO var_top_pos FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=in_parent_id AND
deleted_flag=NO_FLAG;
SELECT NVL(MAX(height),DEFAULT_CONTROL_HEIGHT)
INTO var_height FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=in_parent_id
AND rel_top_pos=var_top_pos
AND deleted_flag=NO_FLAG;
news.DELETE;
boms.DELETE;
features.DELETE;
Options.DELETE;
add_buttons.DELETE;
latest_buttons.DELETE;
footer_buttons.DELETE;
ref_boms.DELETE;
SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;
SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';
SELECT ui_node_id INTO var_start_ui_node FROM CZ_UI_NODES
WHERE ui_node_ref_id=in_ui_node_id AND ui_node_type=UI_COMPONENT_REF_TYPE;
FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
START WITH ui_node_id=in_ui_node_id
CONNECT BY PRIOR ui_node_id=parent_id)
LOOP
DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
FOR i IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
START WITH ui_node_id=var_start_ui_node
CONNECT BY PRIOR ui_node_id=parent_id)
LOOP
FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
START WITH ui_node_id=i.ui_node_ref_id
CONNECT BY PRIOR ui_node_id=parent_id)
LOOP
DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
DELETE FROM CZ_UI_NODES WHERE ui_node_id=i.ui_node_id AND deleted_flag=NO_FLAG;
var_insert_flag BOOLEAN;
var_insert_flag:=FALSE;
FOR i IN(SELECT INTL_TEXT_ID,LANGUAGE,LOCALIZED_STR,SOURCE_LANG FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=in_intl_text_id AND deleted_flag=NO_FLAG)
LOOP
var_label:=i.LOCALIZED_STR;
var_insert_flag:=TRUE;
INSERT INTO CZ_LOCALIZED_TEXTS
(INTL_TEXT_ID,
LOCALIZED_STR,
LANGUAGE,
SOURCE_LANG,
DELETED_FLAG,
SECURITY_MASK,
checkout_user,
model_id,
ui_def_id)
SELECT
var_caption_id,
var_label,
LANGUAGE,
SOURCE_LANG,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_ID,
in_ui_def_id
FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=i.INTL_TEXT_ID AND
LANGUAGE=i.LANGUAGE AND
SOURCE_LANG=i.SOURCE_LANG;
IF (in_intl_text_id IS NULL OR var_insert_flag=FALSE) THEN
--
-- if there is no particular caption --
-- then PS Node name is used --
--
IF in_caption IS NULL THEN
var_label:=var_name;
INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
VALUES(var_caption_id,var_label,in_ui_def_id,Project_Id,NO_FLAG);
INSERT INTO CZ_UI_NODES
(ui_node_id,
parent_id,
ui_def_id,
ps_node_id,
ui_node_ref_id,
name,caption_id,tool_tip_id,ui_node_type,background_color,
component_id,width,height,lce_identifier,
tree_display_flag,tree_seq,
default_font_flag,default_bkgrnd_color_flag,
default_bkgrnd_picture_flag,modified_flags,tab_order,
rel_top_pos,rel_left_pos,
deleted_flag,
fontbold,fontcolor,fontunderline,fontsize,fontname,
backgroundstyle,controltype,backgroundpicture,borders,picturename,
func_comp_id,page_number,model_ref_expl_id,cx_command_name)
VALUES(in_ui_node_id,in_parent_id,in_ui_def_id,in_ps_node_id,in_ui_node_ref_id,
in_name,var_caption_id,var_tool_tip_id,in_ui_node_type,var_background_color,
in_component_id,
NVL(in_width, 100),
NVL(in_height, 20),
in_lce_id,
NVL(in_tree_display_flag,NO_FLAG),
NVL(in_tree_seq, -1),
NVL(in_use_default_font, YES_FLAG),
var_use_default_color,
NVL(in_use_default_pic, YES_FLAG),
NVL(in_modified_flag, 0),
NO_FLAG,
NVL(in_top_pos, 0),
NVL(in_left_pos, 0),
NO_FLAG,in_font_bold,var_font_color,in_font_underline,
NVL(in_font_size, 9),
NVL(in_font_name, 'Arial'),
in_bkgrnd_style,in_controltype,in_bkgrnd_picture,
in_borders,in_picname,in_func_comp_id,
NVL(in_page_id, 1),
in_model_ref_expl_id,
in_cx_command_name);
in_update_flag IN VARCHAR2 -- DEFAULT NO_FLAG
) IS
BEGIN
UPDATE CZ_UI_NODE_PROPS SET value_str=in_value WHERE ui_node_id=in_ui_node_id AND key_str=in_name;
INSERT INTO CZ_UI_NODE_PROPS(ui_node_id,ui_def_id,key_str,value_str,deleted_flag)
VALUES(in_ui_node_id,in_ui_def_id,in_name,in_value,NO_FLAG);
INSERT INTO CZ_UI_PROPERTIES(ui_def_id,key_str,value_str,deleted_flag)
VALUES(in_ui_def_id,in_name,in_value,NO_FLAG);
INSERT INTO CZ_UI_PROPERTIES(ui_def_id,key_str,value_str,deleted_flag)
VALUES(in_ui_def_id,in_name,to_char(in_value),NO_FLAG);
in_update_flag IN VARCHAR2 DEFAULT NO_FLAG,
in_virtual_flag IN VARCHAR2 DEFAULT NO_FLAG,
in_ref_ui_def_id IN INTEGER DEFAULT 0,
in_align IN VARCHAR2 DEFAULT 'left',
in_show_all_nodes IN VARCHAR2 DEFAULT '0'
*/
PROCEDURE generateUIProps
(in_ui_node_id IN INTEGER,
in_ui_def_id IN INTEGER,
in_ui_type IN INTEGER,
in_feature_type IN INTEGER,
in_min IN VARCHAR2,
in_max IN VARCHAR2,
in_counted_options IN VARCHAR2,
in_update_flag IN VARCHAR2,
in_virtual_flag IN VARCHAR2,
in_ref_ui_def_id IN INTEGER,
in_align IN VARCHAR2,
in_show_all_nodes IN VARCHAR2,
in_ps_node_id IN NUMBER DEFAULT NULL,
in_rule_id IN NUMBER DEFAULT NULL) IS
var_ui_def_id CZ_UI_NODE_PROPS.ui_def_id%TYPE;
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'UiStyle',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLfBold', DEFAULT_LOGIC_BOLD_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLfForeColor', DEFAULT_LOGIC_COLOR_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLfPic', DEFAULT_LOGIC_LGB_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicComboLfPic', DEFAULT_LOGIC_COM_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicBooleanLfPic', DEFAULT_LOGIC_BOL_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicOptionLfPic', DEFAULT_LOGIC_OPT_LF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLtBold', DEFAULT_LOGIC_BOLD_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLtForeColor', DEFAULT_LOGIC_COLOR_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicLtPic', DEFAULT_LOGIC_LGB_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicComboLtPic', DEFAULT_LOGIC_COM_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicBooleanLtPic', DEFAULT_LOGIC_BOL_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicOptionLtPic', DEFAULT_LOGIC_OPT_LT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUfBold', DEFAULT_LOGIC_BOLD_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUfForeColor', DEFAULT_LOGIC_COLOR_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUfPic',DEFAULT_LOGIC_LGB_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicComboUfPic', DEFAULT_LOGIC_COM_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicBooleanUfPic', DEFAULT_LOGIC_BOL_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicOptionUfPic',DEFAULT_LOGIC_OPT_UF,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUnBold', DEFAULT_LOGIC_BOLD_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUnForeColor', DEFAULT_LOGIC_COLOR_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUnPic', DEFAULT_LOGIC_LGB_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicComboUnPic', DEFAULT_LOGIC_COM_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicBooleanUnPic', DEFAULT_LOGIC_BOL_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicOptionUnPic', DEFAULT_LOGIC_OPT_UN,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUtBold', DEFAULT_LOGIC_BOLD_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUtForeColor', DEFAULT_LOGIC_COLOR_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicUtPic', DEFAULT_LOGIC_LGB_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicComboUtPic', DEFAULT_LOGIC_COM_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicBooleanUtPic', DEFAULT_LOGIC_BOL_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CfgLogicOptionUtPic', DEFAULT_LOGIC_OPT_UT,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'LogicUseColors', DEFAULT_LOGIC_USE_COLORS,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'LogicUseIcons', DEFAULT_LOGIC_USE_ICONS,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'PriceUpdate','2',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'PriceDisplay','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ShowAllNodes',in_show_all_nodes,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'MaxBOMItemsOnPage',mITEMS_ON_PAGE,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WizardStyle',mWIZARD_STYLE,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'NavFrameAllocation',GLOBAL_FRAME_ALLOCATION,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'NavFrameReservation',GLOBAL_FRAME_ALLOCATION,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'UseLabels',mUSE_LABELS,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'TargetUIDef',in_ref_ui_def_id,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'SpinButtons',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'LabelEachOption',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'DisplayPictures',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'UseLabels',mUSE_LABELS,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'LabelPicture',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CountedOptions',in_counted_options,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'FeatureType',var_feature_type,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Max',in_max,in_update_flag);
IF in_update_flag=YES_FLAG THEN
DELETE FROM CZ_UI_NODE_PROPS WHERE ui_node_id=in_ui_node_id AND key_str='Max';
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Min',in_min,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','-1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'HAlign',in_align,in_update_flag);
IF in_ui_type=DEF_PRODUCT_SELECTION THEN
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'SectionType','2',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'UiStyle',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'TreeStyle','2',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'SectionType','3',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'SectionType','4',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'IsVirtual',in_virtual_flag,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Max',in_max,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Min',in_min,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'IsVirtual',in_virtual_flag,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','20',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'IsVirtual',in_virtual_flag,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Max',in_max,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Min',in_min,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'IsVirtual',in_virtual_flag,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'FormatString',NULL,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'FormatString',NULL,in_update_flag);
IF in_ui_type=DEF_DELETE_BUTTON THEN
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','0',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','3',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'MediaFile','',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','21',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'MediaFile','',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','18',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'Editable',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'DisplayConnectionPath',NO_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','6',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','5',in_update_flag);
SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES
WHERE devl_project_id=(select devl_project_id from CZ_UI_DEFS
WHERE ui_def_id=in_ui_def_id) AND ps_node_id=in_ps_node_id AND deleted_flag='0';
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','31',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CxCommandNode',TO_CHAR(var_persistent_node_id),in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'RuleId',TO_CHAR(in_rule_id),in_update_flag);
SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES
WHERE devl_project_id=(select devl_project_id from CZ_UI_DEFS
WHERE ui_def_id=in_ui_def_id) AND ps_node_id=in_ps_node_id AND deleted_flag='0';
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','32',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'CxCommandNode',TO_CHAR(var_persistent_node_id),in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'RuleId',TO_CHAR(in_rule_id),in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','17',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WizardNavigation','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','16',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ButtonStyle','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WizardNavigation','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','15',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ButtonStyle','2',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WizardNavigation','1',in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'UseLabels',mUSE_LABELS,in_update_flag);
set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','3',in_update_flag);
FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE COMPONENT_ID=in_component_id
AND deleted_flag=NO_FLAG)
LOOP
BEGIN
SELECT TO_NUMBER(value_str) INTO var_ui_version
FROM CZ_UI_PROPERTIES WHERE ui_def_id=i.ui_def_id AND UPPER(KEY_STR)='UIVERSION';
SELECT NVL(MAX(rel_top_pos),DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN)
INTO var_top_pos FROM CZ_UI_NODES
WHERE parent_id=in_ui_node_id AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height
FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
FOR i IN (SELECT ui_node_id,width,name FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
AND ui_node_type=UI_BUTTON_TYPE AND name<>CZ_DELETE_BUTTON_CAPTION AND modified_flags=0 AND
deleted_flag=NO_FLAG ORDER BY ui_node_id)
LOOP
var_left_border:=var_left_pos+i.width;
UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,
rel_left_pos=var_left_pos
WHERE ui_node_id=i.ui_node_id;
SELECT NVL(MAX(rel_top_pos),DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN)
INTO var_top_pos FROM CZ_UI_NODES
WHERE parent_id=in_ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
WHERE parent_id=in_ui_node_id
AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
FOR i IN (SELECT ui_node_id,width FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
AND ui_node_type=UI_BUTTON_TYPE AND name<>CZ_DELETE_BUTTON_CAPTION
AND modified_flags=0 AND deleted_flag=NO_FLAG ORDER BY ui_node_id)
LOOP
BEGIN
BEGIN
FOR l IN latest_buttons.First..latest_buttons.Last
LOOP
IF latest_buttons(l).id=i.ui_node_id THEN
RAISE END_OPERATION1;
UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,
rel_left_pos=var_left_pos
WHERE ui_node_id=i.ui_node_id;
var_text_width:=USABLE_WIDTH-DELETE_BUTTON_WIDTH;
SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
WHERE intl_text_id=in_intl_text_id;
var_button_width:=DELETE_BUTTON_WIDTH;
SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
ui_def_id=in_ui_def_id AND ps_node_id=add_buttons(k).ps_parent_id
AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
FOR i IN(SELECT expr_node_id,data_value,event_execution_scope FROM CZ_EXPRESSION_NODES
WHERE rule_id=p_rule_id AND deleted_flag='0'
AND argument_signature_id=EVENT_ON_COMMAND_SIGID AND data_value IS NOT NULL)
LOOP
x_action_type := RAISE_COMMAND_EVENT;
FOR i IN (SELECT func_comp_id,component_id,companion_type,name FROM CZ_FUNC_COMP_SPECS a
WHERE devl_project_id=in_project_id AND companion_type IN(1,3,4,5,6,7,9,11,12,13,14,15) AND
NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
ps_node_id=a.component_id AND ui_node_type=UI_BUTTON_TYPE AND func_comp_id=a.func_comp_id
AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG)
LOOP
BEGIN
var_button_id:=getUISeqVal;
SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
ui_def_id=in_ui_def_id AND ps_node_id=i.component_id
AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
FOR i IN(SELECT rule_id,component_id,name FROM CZ_RULES
WHERE devl_project_id=in_project_id AND
rule_type=CZ_EXTENTSIONS_RULE_TYPE AND deleted_flag=NO_FLAG AND
disabled_flag=NO_FLAG)
LOOP
check_for_CZEXT_Button(p_rule_id => i.rule_id,
x_action_type => var_button_type,
x_cx_command_name => var_cx_command_name,
x_event_scope => var_event_scope);
SELECT parent_id,ps_node_type INTO var_ps_parent_id,var_ps_node_type FROM CZ_PS_NODES
WHERE ps_node_id=i.component_id;
SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
ui_def_id=in_ui_def_id AND ps_node_id=var_nearest_comp_id
AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
AND ui_node_type=UI_REFERENCE_REF_TYPE)
LOOP
FOR k IN(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
AND ps_node_id=i.ps_node_id AND ui_node_type=UI_BOM_STANDART_TYPE)
LOOP
var_ui_node_ref_id:=NULL;
UPDATE CZ_UI_NODES
SET model_ref_expl_id=i.model_ref_expl_id
WHERE ui_def_id=in_ui_def_id AND ui_node_id=k.ui_node_id
RETURNING ui_node_ref_id INTO var_ui_node_ref_id;
SELECT component_id INTO var_ref_model_id
FROM CZ_MODEL_REF_EXPLS a
WHERE model_id=Project_Id AND deleted_flag=NO_FLAG
AND referring_node_id=i.ps_node_id AND ps_node_type=REFERENCE_NODE_TYPE AND rownum<2;
SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
WHERE ui_def_id=i.ui_def_ref_id AND ui_node_type=UI_SCREEN_TYPE
AND ps_node_id=var_ref_model_id AND deleted_flag=NO_FLAG AND rownum<2;
UPDATE CZ_UI_NODES
SET ui_node_ref_id=var_ref_root_screen
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=k.ui_node_id AND ui_node_ref_id IS NULL;
FOR i IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND deleted_flag='0' AND ui_node_type=UI_COMPONENT_TYPE)
LOOP
SELECT NVL(MAX(rel_top_pos),0)
INTO var_top_pos FROM CZ_UI_NODES
WHERE parent_id=i.ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK
AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
WHERE parent_id=i.ui_node_id
AND rel_top_pos=var_top_pos AND modified_flags<>CZ_NAVIGATION_MARK AND
parent_id<>in_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES a SET rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id AND parent_id=i.ui_node_id AND ui_node_type=UI_TEXT_LABEL_TYPE AND
modified_flags=CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES a SET rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id AND parent_id=i.ui_node_id AND ui_node_type=UI_BUTTON_TYPE AND
modified_flags=CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id
WHERE ui_node_ref_id=in_node_id;
in_arr.ps_node_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
SELECT MAX(creation_date) INTO var_date FROM CZ_UI_DEFS
WHERE component_id=in_ref_id AND ui_style=mUI_STYLE AND look_and_feel=mLOOK_AND_FEEL
AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(ui_def_id),0) INTO ret FROM CZ_UI_DEFS
WHERE component_id=in_ref_id AND ui_style=mUI_STYLE AND look_and_feel=mLOOK_AND_FEEL
AND creation_date=var_date AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_ui_parent_id
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ui_node_id=in_ui_parent_id;
SELECT ps_node_id,name,tree_seq,intl_text_id,ps_node_type
INTO var_ps_node_id,var_name,var_tree_seq,var_intl_text_id,var_root_ps_type
FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id IS NULL
AND deleted_flag=NO_FLAG;
SELECT ps_node_id,name,tree_seq,intl_text_id
INTO var_ps_node_id,var_name,var_tree_seq,var_intl_text_id
FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id=in_ref_model_id
AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag=NO_FLAG;
SELECT MIN(model_ref_expl_id) INTO var_model_ref_expl_id
FROM CZ_MODEL_REF_EXPLS a WHERE model_id=Project_Id AND component_id=in_ref_model_id
AND referring_node_id=in_ref_ps_id AND ps_node_type=REFERENCE_NODE_TYPE
AND deleted_flag=NO_FLAG;
SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
WHERE intl_text_id=var_intl_text_id;
SELECT MAX(rel_top_pos) INTO var_top_pos FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=var_ui_parent_id
AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
SELECT NVL(max(height),DEFAULT_SPACE_BETWEEN) INTO var_prev_height FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=var_ui_parent_id
AND modified_flags<>CZ_NAVIGATION_MARK AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=var_ui_parent_id
AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
WHERE ui_def_id=in_t_ref_uis(in_ref_ps_id) AND ui_node_type=UI_SCREEN_TYPE
AND ps_node_id=in_ref_model_id AND deleted_flag=NO_FLAG AND rownum<2;
SELECT text_str||' Configurations' INTO var_caption_name
FROM CZ_INTL_TEXTS WHERE intl_text_id=var_intl_text_id;
existsDeleteMe VARCHAR2(1);
SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a
WHERE referring_node_id=in_arr.ps_node_id AND model_id=Project_Id AND
deleted_flag=NO_FLAG;
SELECT name INTO var_name FROM CZ_PS_NODES
WHERE ps_node_id=in_arr.reference_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET model_ref_expl_id=var_expl_id,ui_def_ref_id=out_ref_ui_id
WHERE ui_node_id=in_node_id AND ui_def_id=in_ui_def_id;
SELECT ps_node_type INTO var_ps_node_type
FROM CZ_PS_NODES
WHERE devl_project_id=var_model_id
AND parent_id IS NULL AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(rel_top_pos),0) INTO var_butt_pos FROM CZ_UI_NODES
WHERE parent_id=in_node_ref_id AND deleted_flag=NO_FLAG;
existsDeleteMe:=NO_FLAG;
SELECT YES_FLAG INTO existsDeleteMe FROM dual
WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=Project_Id AND
name=CZ_DELETE_BUTTON_CAPTION);
IF existsDeleteMe=NO_FLAG THEN
ERROR_CODE:='00204';
SELECT ui_node_id,name INTO var_ui_tempo,var_ui_name FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=Project_Id AND
ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
Project_Id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
existsDeleteMe:=NO_FLAG;
SELECT devl_project_id INTO var_model_id FROM CZ_UI_DEFS
WHERE ui_def_id=out_ref_ui_id AND deleted_flag=NO_FLAG;
SELECT YES_FLAG INTO existsDeleteMe FROM dual
WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
WHERE ui_def_id=out_ref_ui_id AND ps_node_id=var_model_Id AND
name=CZ_DELETE_BUTTON_CAPTION);
IF existsDeleteMe=NO_FLAG THEN
BEGIN
ERROR_CODE:='00210';
SELECT ui_node_id,name INTO var_ui_tempo,var_ui_name FROM CZ_UI_NODES
WHERE ui_def_id=out_ref_ui_id AND ps_node_id=var_model_Id AND
ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
var_model_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id
WHERE ui_node_ref_id=in_node_id;
in_arr.ps_node_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id
WHERE ui_def_id=in_ui_def_id AND ui_node_id IN
(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE
AND ps_node_id=in_arr.ps_node_id AND deleted_flag=NO_FLAG);
UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id
WHERE ui_def_id=in_ui_def_id AND ui_node_id IN
(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE
AND ps_node_id=in_arr.ps_node_id AND deleted_flag=NO_FLAG);
SELECT ui_def_id FROM CZ_UI_DEFS
WHERE devl_project_id=Project_Id AND component_id IS NULL;
SELECT CZ_UI_DEFS_S.NEXTVAL INTO MUID FROM DUAL;
INSERT INTO CZ_UI_DEFS(ui_def_id,name,devl_project_id,component_id,
ui_style,gen_version,gen_header,look_and_feel,deleted_flag)
VALUES(MUID,'MUID',Project_Id,NULL,-1,GLOBAL_GEN_VERSION,GLOBAL_GEN_HEADER,NULL,NO_FLAG);
SELECT CZ_UI_DEFS_S.NEXTVAL INTO var_ui_def_id FROM DUAL;
SELECT NVL(MAX(tree_seq),0)+1 INTO var_tree_seq FROM CZ_UI_DEFS
WHERE component_id=Project_Id AND deleted_flag=NO_FLAG;
INSERT INTO CZ_UI_DEFS(ui_def_id,name,devl_project_id,component_id,ui_style,gen_version,
gen_header,look_and_feel,tree_seq,deleted_flag)
VALUES(var_ui_def_id,InterfaceName,Project_Id,Model_Id,mUI_STYLE,GLOBAL_GEN_VERSION,
GLOBAL_GEN_HEADER,mLOOK_AND_FEEL,var_tree_seq,NO_FLAG);
SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a
WHERE referring_node_id=in_arr.ps_node_id AND model_id=Project_Id
AND deleted_flag=NO_FLAG;
SELECT name,intl_text_id
INTO var_ref_name,var_ref_label_id
FROM CZ_PS_NODES
WHERE ps_node_id=in_arr.reference_id AND deleted_flag=NO_FLAG;
INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
VALUES(var_txt_id,var_button_caption,in_ui_def_id,Project_Id,NO_FLAG);
UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS
WHERE ui_def_id=in_ui_def_id AND ui_node_id=in_new_parent_id;
SELECT caption_id,modified_flags
INTO var_temp,var_modified_flag FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_new_parent_id
AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag='0';
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT caption_id,ui_node_ref_id,modified_flags
INTO var_temp,var_ui_node_ref_id,var_modified_flag
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_new_parent_id
AND deleted_flag='0';
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT caption_id,modified_flags
INTO var_temp,var_modified_flag FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
AND deleted_flag='0';
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT ui_node_id INTO var_screen_oc_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND ps_node_id=opt_bom(i).ps_node_id
AND rownum<2 AND deleted_flag=NO_FLAG;
SELECT model_ref_expl_id INTO var_model_ref_expl_id
FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
SELECT caption_id,modified_flags
INTO var_temp,var_modified_flag FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_new_parent_id
AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag='0';
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
UPDATE CZ_UI_NODES SET name=name||var_suffix
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_new_parent_id
AND deleted_flag='0'
RETURNING caption_id,ui_node_ref_id,modified_flags
INTO var_temp,var_ui_node_ref_id,var_modified_flag;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT caption_id,modified_flags
INTO var_temp,var_modified_flag FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
AND deleted_flag='0';
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
/* *** VB code needs this update for Preview *** */
/* *** if we add a new control then VB should add *** */
/* *** the control under all others control on the screen *** */
--IF mUI_STYLE=DHTML_STYLE_UI THEN
-- UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS
-- WHERE ui_def_id=in_ui_def_id AND ui_node_id=in_new_parent_id;
DELETE_BUTTON_LEFT_POS:=USABLE_WIDTH+LEFT_MARGIN-DELETE_BUTTON_WIDTH;
SELECT parent_id INTO var_model_id FROM CZ_PS_NODES
WHERE ps_node_id=in_product_id;
(SELECT ps_node_id,parent_id,name,ps_node_type,
tree_seq,counted_options_flag,maximum,minimum,
ui_omit,item_id,feature_type,intl_text_id,reference_id,virtual_flag,orig_sys_ref FROM CZ_PS_NODES
WHERE devl_project_id=Project_Id AND ps_node_type
in (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,FEATURE_NODE_TYPE,RESOURCE_NODE_TYPE,TOTAL_NODE_TYPE,OPTION_NODE_TYPE,
BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE,BOM_STANDART_NODE_TYPE,REFERENCE_NODE_TYPE,CONNECTOR_NODE_TYPE)
START WITH ps_node_id=in_product_id
CONNECT BY PRIOR ps_node_id=parent_id
AND (ui_omit=NO_FLAG OR in_show_all_nodes=YES_FLAG) AND deleted_flag=NO_FLAG)
LOOP
ERROR_CODE:='0006';
SELECT RTRIM(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS
WHERE intl_text_id=i.intl_text_id;
FOR i IN (SELECT ui_node_ref_id FROM CZ_UI_NODES
WHERE ui_def_id=new_ui_def_id AND
ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE) AND
deleted_flag=NO_FLAG)
LOOP
ERROR_CODE:='0036';
UPDATE CZ_UI_NODES SET name=InterfaceName WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
UPDATE CZ_UI_NODES SET caption_id=var_caption_id
WHERE ui_def_id=in_def_id AND ui_node_id=in_id;
FOR i IN(SELECT message_text,language_code FROM FND_NEW_MESSAGES WHERE message_name=in_caption)
LOOP
INSERT INTO CZ_LOCALIZED_TEXTS
(INTL_TEXT_ID,
LOCALIZED_STR,
LANGUAGE,
SOURCE_LANG,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
VALUES(
var_caption_id,
i.message_text,
i.language_code,
i.language_code,
'0',
NULL,
NULL);
PROCEDURE create_SelectionsGrid
(in_parent_id IN INTEGER,
in_ui_def_id IN INTEGER) IS
Grid_Id CZ_UI_NODES.ui_node_id%TYPE;
END create_SelectionsGrid;
(SELECT ps_node_id,parent_id,ps_node_type,name,counted_options_flag,tree_seq,
maximum,minimum,ui_omit,intl_text_id,reference_id FROM CZ_PS_NODES
WHERE devl_project_id=Project_Id AND ps_node_type
in (BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE,BOM_STANDART_NODE_TYPE,REFERENCE_NODE_TYPE)
START WITH ps_node_id=in_product_id
CONNECT BY PRIOR ps_node_id=parent_id AND (ui_omit=NO_FLAG OR in_show_all_nodes=YES_FLAG)
AND deleted_flag=NO_FLAG)
LOOP
ERROR_CODE:='2003';
SELECT NVL(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS
WHERE intl_text_id=i.intl_text_id;
SELECT ps_node_id INTO temp_node FROM CZ_PS_NODES
WHERE devl_project_id=i.reference_id AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag='0';
create_SelectionsGrid(in_parent_id=>Panel4_Id,in_ui_def_id=>new_ui_def_id);
in_caption =>CZ_UPDATE_BUTTON_CAPTION,
in_top_pos =>7,
in_left_pos =>155,
in_action =>'13',
in_borders =>NO_FLAG,
in_picture =>'czreload.gif');
in_caption =>CZ_UPDATE_BUTTON_CAPTION,
in_top_pos =>7,
in_left_pos =>155,
in_action =>'11',
in_borders =>NO_FLAG,
in_picture =>'czreload.gif');
UPDATE CZ_UI_NODES SET name=InterfaceName
WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
existsDeleteMe VARCHAR2(1);
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
SELECT name INTO Model_Name FROM CZ_DEVL_PROJECTS
WHERE devl_project_id=in_product_id;
FOR i IN (SELECT ui_node_id,component_id,ui_def_ref_id,ps_node_id FROM CZ_UI_NODES
WHERE ui_def_id=out_ui_def_id AND ui_def_ref_id IS NOT NULL
AND ui_node_type=UI_REFERENCE_REF_TYPE
AND deleted_flag='0' )
LOOP
--
-- find devl_project_id of referenced Model
--
SELECT reference_id INTO var_reference_id FROM CZ_PS_NODES
WHERE ps_node_id=i.component_id AND deleted_flag=NO_FLAG;
SELECT MAX(ui_def_id) INTO var_ui_def_id FROM CZ_UI_DEFS
WHERE component_id=var_reference_id AND ui_style=mUI_STYLE AND
look_and_feel=mLOOK_AND_FEEL AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_wizard_style FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=var_ui_def_id AND ui_node_id=
(SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=var_ui_def_id AND
ui_node_id=parent_id AND deleted_flag=NO_FLAG) AND key_str='WizardStyle' AND
deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
WHERE ui_def_id=var_ui_def_id AND ui_node_type=UI_SCREEN_TYPE
AND ps_node_id=var_reference_id AND deleted_flag=NO_FLAG AND rownum<2;
UPDATE CZ_UI_NODES SET ui_node_ref_id=var_ref_root_screen
WHERE ui_def_id=out_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE AND ps_node_id=i.ps_node_id
AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET ui_def_ref_id=var_ui_def_id
WHERE ui_node_id=i.ui_node_id;
existsDeleteMe:=NO_FLAG;
SELECT YES_FLAG INTO existsDeleteMe FROM dual
WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
WHERE ui_def_id=var_ui_def_id AND ps_node_id=var_reference_id
AND ui_node_type=UI_BUTTON_TYPE AND name=CZ_DELETE_BUTTON_CAPTION);
SELECT virtual_flag INTO var_virt_flag FROM CZ_PS_NODES
WHERE ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
IF existsDeleteMe=NO_FLAG AND var_virt_flag=NO_FLAG THEN
SELECT ui_node_id INTO var_ui_root_id FROM CZ_UI_NODES
WHERE ui_def_id=var_ui_def_id AND ps_node_id=var_reference_id AND
ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
var_reference_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_modified_flag => 0);
var_deleted_flag INTEGER;
SELECT ui_omit,deleted_flag,parent_id INTO var_ui_omit,var_deleted_flag,var_next_id FROM CZ_PS_NODES
WHERE ps_node_id=curr_ps_node_id;
IF var_ui_omit=YES_FLAG OR var_deleted_flag=YES_FLAG THEN
Flag:=YES_FLAG;
SELECT ui_node_id INTO var_limbo_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,tree_seq FROM CZ_PS_NODES
WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)
LOOP
var_choose_conn:=NULL;
SELECT ui_node_id,parent_id INTO var_curr_ui_id,var_ui_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
AND ps_node_id=i.ps_node_id AND ui_node_type=UI_REFERENCE_REF_TYPE AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ui_node_id=var_ui_id;
SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ui_node_id=var_ref_id;
SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.parent_id AND parent_id<>var_limbo_id AND ui_node_type IN
(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
WHERE ui_node_ref_id=var_id AND parent_id<>var_limbo_id AND ui_node_type=UI_COMPONENT_REF_TYPE AND
ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id,tree_seq
INTO var_ui_id,var_old_tree_seq
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND parent_id<>var_limbo_id AND ps_node_id=i.ps_node_id
AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE)
AND deleted_flag=NO_FLAG;
SELECT ui_node_id,parent_id INTO var_curr_ui_id,var_parent_id FROM CZ_UI_NODES
WHERE ui_node_ref_id=var_ui_id AND parent_id<>var_limbo_id AND ui_node_type NOT IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE) AND
ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_type INTO var_ui_type FROM CZ_UI_NODES WHERE
ui_node_id=var_parent_id AND ui_def_id=in_ui_def_id;
SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
ui_node_id=var_parent_id;
SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
ui_node_id=var_ref_id;
SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.parent_id AND parent_id<>var_limbo_id AND ui_node_type IN
(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
WHERE ui_node_ref_id=var_id AND parent_id<>var_limbo_id AND ui_node_type=UI_COMPONENT_REF_TYPE AND
ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id,parent_id,ui_node_ref_id,tree_seq
INTO var_curr_ui_id,var_ui_id,var_ui_ref_id,var_old_tree_seq FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id
AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND ui_node_type IN
(UI_FEATURE_TYPE,UI_OPTION_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_CONNECTOR_TYPE)
AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_choose_conn
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND parent_id<>var_limbo_id AND
ui_node_ref_id=var_curr_ui_id AND deleted_flag=NO_FLAG;
SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.parent_id AND parent_id<>var_limbo_id AND ui_node_type IN
(UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG;
SELECT ui_node_id,parent_id,tree_seq
INTO var_curr_ui_id,var_ui_id,var_old_tree_seq FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND
ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG;
SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.parent_id AND parent_id<>var_limbo_id AND ui_node_type IN
(UI_FEATURE_TYPE) AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET parent_id=movedReferences(ind).new_parent_id
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=ind AND ui_node_type=UI_REFERENCE_REF_TYPE AND
parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=movedReferences(ind).new_parent_id AND
parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id
AND ps_node_id=movedReferences(ind).ps_node_id AND ui_node_type=UI_BUTTON_TYPE
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET parent_id=movedComponents(ind).new_parent_id,
tree_seq=movedComponents(ind).tree_seq
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=ind AND ui_node_type=UI_COMPONENT_REF_TYPE AND
deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=movedComponents(ind).new_parent_id AND
parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id AND parent_id=movedComponents(ind).parent_id
AND ps_node_id=movedComponents(ind).ps_node_id AND ui_node_type=UI_BUTTON_TYPE
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET parent_id=movedFeatures(ind).new_parent_id,
rel_top_pos=var_top_pos,
tree_seq=movedFeatures(ind).tree_seq
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=ind AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_CONNECTOR_TYPE) AND
deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET parent_id=movedFeatures(ind).new_parent_id,rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=movedFeatures(ind).ui_ref_id AND ui_node_type=UI_TEXT_LABEL_TYPE AND
deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET parent_id=movedFeatures(ind).new_parent_id,
rel_top_pos=var_top_pos
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=movedFeatures(ind).button_id AND ui_node_type=UI_BUTTON_TYPE AND
deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET parent_id=movedOptions(ind).new_parent_id,
tree_seq=movedOptions(ind).tree_seq
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=ind AND ui_node_type=UI_OPTION_TYPE AND
deleted_flag=NO_FLAG;
SELECT name INTO var_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=in_old_def_id;
UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;
UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;
UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;
UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;
SELECT ui_node_id INTO var_old_limbo_id FROM CZ_UI_NODES
WHERE ui_def_id=in_old_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_new_limbo_id FROM CZ_UI_NODES
WHERE ui_def_id=in_new_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_new_def_id
AND ui_node_type=UI_BUTTON_TYPE;
SELECT * INTO var_header FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND
ui_node_type=UI_ROOT_SYSTEM_TYPE AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET FONTBOLD=var_header.FONTBOLD,
FONTCOLOR=var_header.FONTCOLOR,
FONTITALIC=var_header.FONTITALIC,
FONTUNDERLINE=var_header.FONTUNDERLINE,
FONTSIZE=var_header.FONTSIZE,
FONTNAME=var_header.FONTNAME,
BACKGROUNDSTYLE=var_header.BACKGROUNDSTYLE,
BACKGROUNDPICTURE=var_header.BACKGROUNDPICTURE,
DEFAULT_BKGRND_COLOR_FLAG=var_header.DEFAULT_BKGRND_COLOR_FLAG,
DEFAULT_BKGRND_PICTURE_FLAG=var_header.DEFAULT_BKGRND_PICTURE_FLAG,
DEFAULT_FONT_FLAG=var_header.DEFAULT_FONT_FLAG
WHERE ui_def_id=in_new_def_id AND ui_node_type=UI_ROOT_SYSTEM_TYPE AND deleted_flag=NO_FLAG;
FOR i IN(SELECT ui_node_id,parent_id,ps_node_id,ui_node_ref_id,ui_node_type,name
FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
AND deleted_flag=NO_FLAG)
LOOP
IF i.parent_id=var_old_limbo_id THEN
UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE
ui_def_id=in_new_def_id AND ps_node_id=i.ps_node_id AND ui_node_type=i.ui_node_type
AND deleted_flag=NO_FLAG;
SELECT name INTO var_name FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
AND ui_node_id=i.ui_node_ref_id;
UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE
ui_def_id=in_new_def_id AND ui_node_ref_id IN(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_new_def_id AND parent_id=var_new_limbo_id) AND ui_node_type=UI_COMPONENT_REF_TYPE;
FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND
ps_node_type IN(PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,
BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE) AND deleted_flag=NO_FLAG)
LOOP
UPDATE CZ_UI_NODES SET deleted_flag='1' WHERE ui_def_id=in_new_def_id AND
parent_id IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ps_node_id=i.ps_node_id
AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG)
AND ui_node_type NOT IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
AND parent_id<>var_new_limbo_id;
FOR i IN(SELECT * FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)
LOOP
IF i.ps_node_type IN (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,BOM_MODEL_NODE_TYPE,
BOM_CLASS_NODE_TYPE) THEN
BEGIN
SELECT * INTO var_old_id FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
parent_id <> var_old_limbo_id AND deleted_flag=NO_FLAG;
SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
FOR k IN(SELECT * FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
AND parent_id=var_old_id.ui_node_id AND parent_id<>var_old_limbo_id
AND ui_node_type NOT IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,
UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG)
LOOP
BEGIN
new_ui_node_id:=getUISeqVal;
INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
SELECT new_caption_id,text_str,in_new_def_id,in_project_id,'0' FROM CZ_INTL_TEXTS
WHERE intl_text_id=(SELECT caption_id FROM CZ_UI_NODES
WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id);
INSERT INTO CZ_UI_NODES
(ui_node_id,
parent_id,
ui_def_id,
ps_node_id,
ui_node_ref_id,
name,caption_id,tool_tip_id,ui_node_type,background_color,
component_id,width,height,lce_identifier,
tree_display_flag,tree_seq,
default_font_flag,default_bkgrnd_color_flag,
default_bkgrnd_picture_flag,modified_flags,tab_order,
rel_top_pos,rel_left_pos,
deleted_flag,
fontbold,fontcolor,fontunderline,fontsize,fontname,
backgroundstyle,controltype,backgroundpicture,borders,picturename,func_comp_id)
SELECT new_ui_node_id,var_new_id.ui_node_id,in_new_def_id,ps_node_id,ui_node_ref_id,
name,new_caption_id,tool_tip_id,ui_node_type,background_color,component_id,width,height,lce_identifier,
tree_display_flag,tree_seq,
default_font_flag,default_bkgrnd_color_flag,default_bkgrnd_picture_flag,
NO_FLAG,NO_FLAG,rel_top_pos,rel_left_pos,NO_FLAG,
fontbold,fontcolor,fontunderline,fontsize,fontname,
backgroundstyle,controltype,backgroundpicture,borders,picturename,func_comp_id
FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
INSERT INTO CZ_UI_NODE_PROPS(ui_def_id,ui_node_id,key_str,value_str,deleted_flag)
SELECT in_new_def_id,new_ui_node_id,key_str,value_str,'0' FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
UPDATE CZ_UI_NODES
SET
REL_TOP_POS=var_old_id.REL_TOP_POS,
REL_LEFT_POS=var_old_id.REL_LEFT_POS,
CAPTION_ID=var_old_id.CAPTION_ID,
WIDTH=var_old_id.WIDTH,
HEIGHT=var_old_id.HEIGHT,
FONTBOLD=var_old_id.FONTBOLD,
FONTCOLOR=var_old_id.FONTCOLOR,
FONTITALIC=var_old_id.FONTITALIC,
FONTUNDERLINE=var_old_id.FONTUNDERLINE,
FONTSIZE=var_old_id.FONTSIZE,
FONTNAME=var_old_id.FONTNAME,
BACKGROUNDSTYLE=var_old_id.BACKGROUNDSTYLE,
BACKGROUNDPICTURE=var_old_id.BACKGROUNDPICTURE,
BORDERS=var_old_id.BORDERS,
PICTURENAME=var_old_id.PICTURENAME,
MODIFIED_FLAGS=var_old_id.MODIFIED_FLAGS,
DEFAULT_BKGRND_COLOR_FLAG=var_old_id.DEFAULT_BKGRND_COLOR_FLAG,
DEFAULT_BKGRND_PICTURE_FLAG=var_old_id.DEFAULT_BKGRND_PICTURE_FLAG,
DEFAULT_FONT_FLAG=var_old_id.DEFAULT_FONT_FLAG
WHERE ui_node_id=var_new_id.ui_node_id;
SELECT * INTO var_old_id FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,
UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
AND parent_id<>var_old_limbo_id AND deleted_flag=NO_FLAG;
SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
AND parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET
REL_TOP_POS=var_old_id.REL_TOP_POS,
REL_LEFT_POS=var_old_id.REL_LEFT_POS,
CAPTION_ID=var_old_id.CAPTION_ID,
WIDTH=var_old_id.WIDTH,
HEIGHT=var_old_id.HEIGHT,
FONTBOLD=var_old_id.FONTBOLD,
FONTCOLOR=var_old_id.FONTCOLOR,
FONTITALIC=var_old_id.FONTITALIC,
FONTUNDERLINE=var_old_id.FONTUNDERLINE,
FONTSIZE=var_old_id.FONTSIZE,
FONTNAME=var_old_id.FONTNAME,
BACKGROUNDSTYLE=var_old_id.BACKGROUNDSTYLE,
BACKGROUNDPICTURE=var_old_id.BACKGROUNDPICTURE,
BORDERS=var_old_id.BORDERS,
PICTURENAME=var_old_id.PICTURENAME,
MODIFIED_FLAGS=var_old_id.MODIFIED_FLAGS,
DEFAULT_BKGRND_COLOR_FLAG=var_old_id.DEFAULT_BKGRND_COLOR_FLAG,
DEFAULT_BKGRND_PICTURE_FLAG=var_old_id.DEFAULT_BKGRND_PICTURE_FLAG,
DEFAULT_FONT_FLAG=var_old_id.DEFAULT_FONT_FLAG
WHERE ui_node_id=var_new_id.ui_node_id;
FOR i IN(SELECT ui_node_id,parent_id,ui_node_ref_id,ps_node_id,ui_node_type,name
FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,
UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
AND ui_node_ref_id IS NOT NULL AND
parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
LOOP
BEGIN
var_name:=Map(i.ps_node_id);
FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_new_def_id AND parent_id=i.ui_node_id AND
name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
LOOP
UPDATE CZ_UI_NODES
SET ui_node_ref_id=n.ui_node_id
WHERE ui_def_id=in_new_def_id
AND ui_node_id=i.ui_node_id;
FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_new_def_id AND parent_id=i.parent_id AND
name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
LOOP
UPDATE CZ_UI_NODES
SET ui_node_ref_id=n.ui_node_id
WHERE ui_def_id=in_new_def_id
AND ui_node_id=i.ui_node_id;
PROCEDURE delete_UI_NODES
(in_project_id IN INTEGER,
in_ui_def_id IN INTEGER) IS
BEGIN
--
-- deleting nodes from PS Tree case --
--
FOR i IN (SELECT ps_node_id FROM CZ_PS_NODES
WHERE devl_project_id=in_project_id
AND (deleted_flag=YES_FLAG OR (ui_omit=YES_FLAG AND mSHOW_ALL_NODES='0')))
LOOP
--
-- remove an associated buttons and references --
--
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE
ps_node_id=i.ps_node_id AND ui_node_type IN (UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE)
AND ui_def_id=in_ui_def_id;
FOR l IN (SELECT ui_node_id,ps_node_id,ui_node_ref_id,ui_node_type FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND ui_node_type NOT IN(UI_BUTTON_TYPE,
UI_REFERENCE_REF_TYPE) AND deleted_flag=NO_FLAG)
LOOP
remove_UI_Subtree(l.ui_node_id,l.ui_node_type);
FOR i IN(SELECT b.ui_node_id FROM CZ_PS_NODES a,CZ_UI_NODES b
WHERE b.ui_def_id=in_ui_def_id AND a.ps_node_id=b.ps_node_id
AND a.ps_node_type=437 AND b.ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND b.page_number<>1 AND
NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND parent_id=b.ui_node_id AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG))
LOOP
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_id=i.ui_node_id;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=i.ui_node_id;
END delete_UI_NODES;
SELECT value_str INTO v_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=p_ui_node_id AND key_str=p_property_name AND deleted_flag='0';
SELECT NVL(TO_CHAR(def_num_value), def_value) INTO v_def_value
FROM cz_properties
WHERE property_id = p_property_id AND deleted_flag = '0';
SELECT NVL(TO_CHAR(data_num_value), data_value) BULK COLLECT INTO v_tab
FROM cz_ps_prop_vals
WHERE ps_node_id = p_node_id
AND property_id = p_property_id
AND deleted_flag = '0';
SELECT NVL(TO_CHAR(property_num_value), property_value) BULK COLLECT INTO v_tab
FROM cz_item_property_values
WHERE property_id = p_property_id
AND item_id = p_item_id
AND deleted_flag = '0';
SELECT NULL BULK COLLECT INTO v_tab
FROM cz_item_type_properties t, cz_item_masters m
WHERE m.item_id = p_item_id
AND m.deleted_flag = '0'
AND t.deleted_flag = '0'
AND t.property_id = p_property_id
AND t.item_type_id = m.item_type_id;
SELECT item_id INTO v_item_id FROM CZ_PS_NODES
WHERE ps_node_id=p_ps_node_id;
var_prod_selection INTEGER;
deletedNodes INTEGER:=0;
var_deleted_flag VARCHAR2(1);
existsDeleteMe VARCHAR2(1):=NO_FLAG;
UPDATE_UI_PROPS VARCHAR2(1):=YES_FLAG;
SELECT ui_node_id,width,height INTO var_root_id,var_screen_width,var_screen_height FROM
CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ui_node_id=parent_id
AND deleted_flag=NO_FLAG;
DELETE_BUTTON_LEFT_POS:=USABLE_WIDTH+LEFT_MARGIN-DELETE_BUTTON_WIDTH;
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
SELECT look_and_feel INTO mLOOK_AND_FEEL FROM CZ_UI_DEFS
WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT value_str INTO mUSE_LABELS FROM CZ_UI_NODE_PROPS
WHERE key_str='UseLabels' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
SELECT value_str INTO mSHOW_ALL_NODES FROM CZ_UI_NODE_PROPS
WHERE key_str='ShowAllNodes' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_frame_allocation FROM CZ_UI_NODE_PROPS
WHERE key_str='NavFrameAllocation' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
SELECT value_str INTO mWIZARD_STYLE FROM CZ_UI_NODE_PROPS
WHERE UPPER(key_str)='WIZARDSTYLE' AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
SELECT value_str INTO mITEMS_ON_PAGE FROM CZ_UI_NODE_PROPS
WHERE UPPER(key_str)='MAXBOMITEMSONPAGE'
AND ui_node_id=var_root_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_DEFS SET last_update_date=SYSDATE WHERE
ui_def_id=in_ui_def_id RETURNING
component_id,ui_style,gen_version,name
INTO Project_Id,mUI_STYLE,var_gen_version,var_ui_name;
UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;
UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;
UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;
SELECT ui_node_id INTO var_comp_tree_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND name='Components Tree' AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_limbo_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND name='Limbo' AND
deleted_flag=NO_FLAG;
deletedNodes:=0;
SELECT COUNT('1') INTO deletedNodes FROM dual WHERE
EXISTS(SELECT NULL FROM CZ_PS_NODES
WHERE devl_project_id=Project_Id AND
(ui_omit=YES_FLAG OR deleted_flag=YES_FLAG));
IF deletedNodes>0 THEN
delete_UI_Nodes(Project_Id,in_ui_def_id);
UPDATE CZ_UI_NODES a
SET deleted_flag=YES_FLAG
WHERE a.ui_def_id=in_ui_def_id AND a.ui_node_type=UI_BUTTON_TYPE AND a.func_comp_id IS NOT NULL AND
NOT EXISTS(SELECT NULL FROM CZ_FUNC_COMP_SPECS b WHERE b.func_comp_id=a.func_comp_id AND b.deleted_flag=NO_FLAG);
UPDATE CZ_UI_NODES u
SET deleted_flag=YES_FLAG
WHERE u.ui_def_id=in_ui_def_id AND u.ui_node_type=UI_BUTTON_TYPE AND
u.deleted_flag=NO_FLAG AND
EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS p
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
TO_NUMBER(value_str) NOT IN
(SELECT r.rule_id FROM CZ_RULES r WHERE r.devl_project_id=Project_id AND
r.rule_type=CZ_EXTENTSIONS_RULE_TYPE AND r.deleted_flag=NO_FLAG));
FOR i IN (SELECT ui_node_id,ui_node_type,deleted_flag FROM CZ_UI_NODES a
WHERE ui_def_id=in_ui_def_id AND ps_node_id IS NOT NULL AND ui_node_type<>141
AND (NOT EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=Project_Id AND
ps_node_id=a.ps_node_id AND deleted_flag=NO_FLAG) OR a.deleted_flag=YES_FLAG))
LOOP
BEGIN
IF i.ui_node_type IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE) THEN
UPDATE CZ_UI_NODES
SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_id=i.ui_node_id AND
ui_node_type IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE)
AND deleted_flag=NO_FLAG;
LOG_REPORT('CZ_UI_GENERATOR.delete_UI_nodes',SQLERRM, CZ_ERROR_URGENCY);
FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,reference_id,
maximum,minimum,name,intl_text_id,counted_options_flag,virtual_flag,
feature_type,ui_omit,tree_seq,item_id,orig_sys_ref FROM CZ_PS_NODES
WHERE devl_project_id=Project_Id AND deleted_flag=NO_FLAG
AND ui_omit=NO_FLAG)
LOOP
BEGIN
--
-- find ui_node_id on the screen associated with i.ps_node_id --
--
BEGIN
var_text_label_id:=NULL;
t_bom_pages.Delete;
FOR k IN(SELECT ui_node_id,parent_id,ui_node_ref_id,ui_def_ref_id,
caption_id,height,ui_node_type,controltype,
modified_flags,name,tree_seq,rel_top_pos,ps_node_id
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND
ui_node_type IN
(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,
UI_FEATURE_TYPE,UI_OPTION_TYPE,
UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_REFERENCE_REF_TYPE,
UI_BOM_OPTION_CLASS_TYPE,UI_BOM_STANDART_TYPE,UI_CONNECTOR_TYPE)
AND deleted_flag=NO_FLAG ORDER BY ui_node_id)
LOOP
BEGIN
IF i.ps_node_type=BOM_CLASS_NODE_TYPE
AND k.ui_node_type=UI_BOM_OPTION_CLASS_TYPE THEN
BEGIN
SELECT caption_id INTO var_label_txt_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=k.ui_node_ref_id;
SELECT caption_id INTO var_tree_caption_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=k.ui_node_id AND
ui_node_type IN(UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE)
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_tempo FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_parent_screen_id FROM
CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
ui_node_id=var_tempo AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT caption_id,modified_flags
INTO var_text_label_caption_id,var_modified_flags
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id AND
deleted_flag=NO_FLAG;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
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;
/* *** go through all languages and update captions of the reference *** */
FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
LOOP
var_caption_name:=i.name;
SELECT ui_node_id,caption_id,parent_id
INTO var_tree_ui_id,var_tree_caption_id,var_tree_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_screen_ui_id AND
ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE)
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_parent_screen_id FROM
CZ_UI_NODES WHERE ui_node_id=var_tree_parent_id;
SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
model_id=Project_Id AND referring_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
model_id=Project_Id AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET model_ref_expl_id=var_model_ref_id WHERE ui_def_id=in_ui_def_id
AND model_ref_expl_id IS NOT NULL AND model_ref_expl_id<>var_model_ref_id
AND ps_node_id=i.ps_node_id AND deleted_flag='0';
SELECT ui_node_id,parent_id,ui_def_ref_id,caption_id,name,tree_seq,ps_node_id,ui_node_type
INTO var_screen_ui_id,var_screen_parent_id,var_ui_def_ref_id,
var_screen_caption_id,var_screen_name,
var_ui_tree_seq,var_screen_ps_node_id,var_ui_node_type
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND
ui_node_type=UI_REFERENCE_REF_TYPE AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id
INTO var_ref_parent_screen_id
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_screen_caption_id
AND var_modified_flags=0;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=(SELECT parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG AND
ui_node_type=UI_BOM_STANDART_TYPE AND parent_id<>var_limbo_id)
AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
/* *** go through all languages and update captions of the reference *** */
var_label:=i.name;
FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_screen_caption_id AND language=l.language;
SELECT value_str INTO var_curr_virtual_flag FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_ui_def_id AND
ui_node_id=var_screen_ui_id AND key_str='IsVirtual' AND deleted_flag=NO_FLAG ;
SELECT devl_project_id INTO var_ref_model_id FROM CZ_UI_DEFS
WHERE ui_def_id=var_ui_def_ref_id AND deleted_flag=NO_FLAG;
SELECT name,intl_text_id
INTO var_ref_name,var_ref_caption_id FROM CZ_PS_NODES
WHERE devl_project_id=var_ref_model_id AND parent_id IS NULL
AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=var_ref_model_id
AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG;
SELECT ui_node_id,parent_id,ui_node_type,ps_node_id,
rel_top_pos,tree_seq,caption_id,ui_node_ref_id,name
INTO var_inst_ui_id,var_inst_parent_id,var_ui_node_type,var_inst_ps_id,
var_inst_top_pos,var_inst_tree_seq,var_inst_caption_id,var_inst_node_ref_id,var_inst_name
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND
ui_node_type IN(UI_BOM_INST_ITEM_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG;
FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=var_ref_caption_id)
LOOP
var_label:=var_ref_name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_inst_caption_id AND language=l.language;
/* *** delete reference if UI and PS tree references are not synchronized *** */
IF var_ref_model_id<>i.reference_id THEN
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id
AND ps_node_id=i.ps_node_id AND ui_node_type=UI_REFERENCE_REF_TYPE;
UPDATE CZ_UI_NODE_PROPS SET value_str=i.virtual_flag
WHERE ui_def_id=in_ui_def_id AND
ui_node_id=var_screen_ui_id AND key_str='IsVirtual' AND deleted_flag=NO_FLAG ;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id
AND ui_node_type IN(UI_BUTTON_TYPE) AND modified_flags IN(0,1);
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_ui_id
AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_node_ref_id
AND ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_ref_ui_id
FROM CZ_UI_NODES WHERE ui_def_id = var_ui_def_ref_id
AND ps_node_id=i.reference_id AND ui_node_type=UI_SCREEN_TYPE
AND deleted_flag=NO_FLAG AND rownum<2;
SELECT model_ref_expl_id INTO var_model_ref_expl_id
FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
SELECT model_ref_expl_id INTO var_model_ref_expl_id
FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
SELECT YES_FLAG INTO existsButton FROM dual WHERE
EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
AND ui_node_type=UI_BUTTON_TYPE AND ps_node_id=i.ps_node_id AND
deleted_flag=NO_FLAG);
SELECT YES_FLAG INTO existsSTANDART_ITEM FROM dual WHERE
EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND ps_node_id=i.ps_node_id AND
deleted_flag=NO_FLAG);
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_ui_id AND ui_node_type=UI_BOM_STANDART_TYPE;
SELECT 'Instances of '||text_str INTO var_caption_name
FROM CZ_INTL_TEXTS WHERE intl_text_id=var_screen_caption_id;
existsDeleteMe:=NO_FLAG;
SELECT devl_project_id INTO var_model_id FROM CZ_UI_DEFS
WHERE ui_def_id=var_ref_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO var_ui_root_id FROM CZ_UI_NODES
WHERE ui_def_id=var_ref_id AND ps_node_id=var_model_Id AND
ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE)
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT YES_FLAG INTO existsDeleteMe FROM dual WHERE
EXISTS(SELECT NULL FROM CZ_UI_NODES a WHERE
a.ui_def_id=var_ref_id AND a.ui_node_type=UI_BUTTON_TYPE AND a.parent_id=var_ui_root_id
AND a.parent_id<>var_limbo_id AND a.deleted_flag=NO_FLAG AND a.modified_flags=0
AND EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS b
WHERE b.ui_def_id=var_ref_id AND b.ui_node_id=a.ui_node_id
AND b.key_str='ActionType' AND b.value_str='1'));
IF existsDeleteMe=NO_FLAG THEN
--
-- create Delete button under the root screen of the refrenced UI --
--
curr_button_id:=getUISeqVal;
var_model_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
SELECT ui_node_id
INTO var_ui_parent_item_id
FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND
ui_node_type=UI_BOM_STANDART_TYPE AND parent_id=
(SELECT ui_node_ref_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=
(SELECT parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=t_bom_pages(1).ui_node_id
AND deleted_flag=NO_FLAG)) AND ps_node_id=t_bom_pages(1).ps_node_id;
UPDATE CZ_UI_NODES
SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_parent_item_id
AND modified_flags=0 AND deleted_flag=NO_FLAG;
SELECT caption_id INTO var_parent_item_txt_id
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_parent_item_id;
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id
AND ui_node_id=var_screen_ui_id;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_screen_caption_id;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
AND var_modified_flags=0;
FOR l IN(SELECT intl_text_id,language,localized_str
FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
AND language=l.language AND var_modified_flags=0;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_tree_caption_id AND language=l.language;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG ;
update_Labels(var_screen_ui_id,var_use_labels);
UPDATE CZ_UI_NODES SET name=i.name||var_suffix
WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_bom_pages(x).ui_node_id;
UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
WHERE intl_text_id=t_bom_pages(x).text_id;
UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
WHERE intl_text_id=t_bom_pages(x).label_txt_id
AND var_modified_flags=0;
FOR m IN(SELECT intl_text_id,language,localized_str
FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_parent_item_txt_id AND language=m.language;
FOR l IN(SELECT intl_text_id,language,localized_str
FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
WHERE intl_text_id=t_bom_pages(x).label_txt_id AND language=l.language
AND var_modified_flags=0;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
WHERE intl_text_id=t_bom_pages(x).tree_label_id AND language=l.language;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_parent_item_txt_id AND language=l.language;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_bom_pages(x).ui_node_id
AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG ;
update_Labels(t_bom_pages(x).ui_node_id,var_use_labels);
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
AND modified_flags=0;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_text_label_caption_id
AND var_modified_flags=0;
/* *** go through all languages and update captions of the reference *** */
var_label:=i.name;
FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_text_label_caption_id AND language=l.language
AND var_modified_flags=0;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_tree_caption_id AND language=l.language;
UPDATE CZ_UI_NODES SET width=var_width
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
AND modified_flags=0;
SELECT value_str INTO var_curr_virtual_flag FROM CZ_UI_NODE_PROPS WHERE
ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='IsVirtual'
AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_curr_max FROM CZ_UI_NODE_PROPS WHERE
ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='Max'
AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_curr_min FROM CZ_UI_NODE_PROPS WHERE
ui_def_id=in_ui_def_id AND ui_node_id=var_tree_ui_id AND key_str='Min'
AND deleted_flag=NO_FLAG;
/* *** create "Delete" button under the screen for the current Component/Products/... *** */
curr_button_id:=getUISeqVal;
i.ps_node_id,CZ_DELETE_BUTTON_CAPTION,
in_top_pos =>DELETE_BUTTON_TOP_POS,
in_left_pos =>DELETE_BUTTON_LEFT_POS,
in_button_type=>DEF_DELETE_BUTTON,
in_width =>DELETE_BUTTON_WIDTH,
in_modified_flag => 0);
UPDATE CZ_UI_NODES SET component_id=i.ps_node_id,ps_node_id=i.ps_node_id
WHERE ui_node_id=var_tree_ui_id AND ui_def_id=in_ui_def_id AND ui_node_type=UI_COMPONENT_REF_TYPE;
UPDATE CZ_UI_NODES a SET a.deleted_flag=YES_FLAG
WHERE ui_def_id=in_ui_def_id AND
ps_node_id=i.ps_node_id AND
ui_node_type=UI_BUTTON_TYPE AND modified_flags=0 AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
AND modified_flags=0;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_text_label_caption_id
AND var_modified_flags=0;
/* *** go through all languages and update captions *** */
var_label:=i.name;
FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
WHERE a.intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_text_label_caption_id AND language=l.language
AND var_modified_flags=0;
UPDATE CZ_UI_NODES SET width=var_width
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
AND modified_flags=0;
/* ****************Update Options Labels *************** */
/*
IF i.ps_node_type=OPTION_NODE_TYPE THEN
IF i.name<>var_screen_name THEN
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
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 ;
FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
WHERE a.intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_screen_caption_id AND language=l.language;
UPDATE CZ_UI_NODES SET name=i.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
AND modified_flags=0 ;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
UPDATE CZ_INTL_TEXTS SET text_str=i.name
WHERE intl_text_id=var_text_label_caption_id
AND var_modified_flags=0;
/* *** go through all languages and update captions *** */
var_label:=i.name;
FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=i.intl_text_id)
LOOP
var_label:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_text_label_caption_id AND language=l.language
AND var_modified_flags=0;
UPDATE CZ_UI_NODES SET width=var_width
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
AND modified_flags=0;
SELECT TO_NUMBER(value_str) INTO var_ui_max FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=var_screen_ui_id AND key_str='Max' AND deleted_flag=NO_FLAG;
SELECT TO_NUMBER(value_str) INTO var_ui_min FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=var_screen_ui_id AND key_str='Min' AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_ui_counted_options FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=var_screen_ui_id AND key_str='CountedOptions' AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id AND UPPER(key_str)='USELABELS'
AND deleted_flag=NO_FLAG;
FOR m IN(SELECT ps_node_id,intl_text_id,tree_seq,name FROM CZ_PS_NODES
WHERE devl_project_id=Project_Id
AND parent_id=i.ps_node_id AND deleted_flag=NO_FLAG AND ui_omit=NO_FLAG)
LOOP
BEGIN
var_label:=NULL;
SELECT ui_node_id,caption_id,name,tree_seq,ps_node_id
INTO var_option_ui_id,var_option_caption_id,
var_option_ui_name,var_ui_tree_seq,var_option_ps_id
FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ps_node_id=m.ps_node_id
AND deleted_flag=NO_FLAG AND parent_id<>var_limbo_id AND modified_flags=0;
UPDATE CZ_UI_NODES SET tree_seq=m.tree_seq
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_option_ui_id;
UPDATE CZ_UI_NODES SET name=m.name
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_option_ui_id;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=m.name
WHERE intl_text_id=var_option_caption_id;
FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
WHERE a.intl_text_id=m.intl_text_id)
LOOP
var_label:=get_Caption(m.name,l.localized_str,var_use_labels);
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
WHERE intl_text_id=var_option_caption_id AND language=l.language;
UPDATE CZ_INTL_TEXTS SET text_str=var_label
WHERE intl_text_id=var_option_caption_id;
LOG_REPORT('CZ_UI_GENERATOR.refreshUI','Update Options Labels < ui_def_id='||TO_CHAR(in_ui_def_id)||' > : '||SQLERRM,
CZ_ERROR_URGENCY);
SELECT TO_NUMBER(value_str) INTO var_ui_feature_type FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=var_screen_ui_id AND key_str='FeatureType' AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES
SET controltype=var_control_type
WHERE ui_node_id=var_screen_ui_id AND parent_id<>var_limbo_id;
UPDATE CZ_UI_NODES SET width=var_width,
borders=var_borders
WHERE ui_node_id=var_screen_ui_id AND parent_id<>var_limbo_id
AND modified_flags=0;
/* *** delete OPTIONs - List Of Options *** */
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_node_id IN
(SELECT ui_node_id FROM CZ_UI_NODES WHERE parent_id=var_screen_ui_id
AND ui_node_type=UI_OPTION_TYPE AND deleted_flag=NO_FLAG);
UPDATE CZ_UI_NODES
SET height=DEFAULT_CONTROL_HEIGHT
WHERE ui_node_id=var_screen_ui_id AND modified_flags=0;
SELECT MAX(ui_node_id) INTO temp_node FROM CZ_UI_NODES WHERE
ps_node_id=news(k).parent_id AND ui_node_ref_id IS NOT NULL AND
ui_node_type IN(UI_COMPONENT_TYPE,UI_REFERENCE_REF_TYPE,BOM_CLASS_NODE_TYPE,BOM_MODEL_NODE_TYPE)
AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES
WHERE ui_node_ref_id=temp_node AND ui_def_id=in_ui_def_id
AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
SELECT '1' INTO existRefUI FROM dual WHERE
EXISTS(SELECT 1 FROM CZ_UI_DEFS WHERE devl_project_id=news(k).reference_id AND ui_style=mUI_STYLE
AND deleted_flag=NO_FLAG);
SELECT ui_node_ref_id INTO var_ref_to_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ui_node_id=new_parent AND ui_node_type=UI_COMPONENT_REF_TYPE AND
parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
SELECT ui_node_ref_id INTO var_temp FROM CZ_UI_NODES WHERE
ui_def_id=in_ui_def_id AND ui_node_id=new_parent;
SELECT MAX(rel_top_pos) INTO last_TOP_POS FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp AND parent_id<>var_limbo_id
AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
SELECT model_ref_expl_id INTO var_model_ref_expl_id
FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
SELECT COUNT(ps_node_id) INTO options_number FROM CZ_PS_NODES
WHERE parent_id=features(k).ps_node_id AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES WHERE ps_node_id=features(k).parent_id
AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG
AND ui_def_id=in_ui_def_id ;
SELECT NVL(MAX(rel_top_pos),-1) INTO last_TOP_POS
FROM CZ_UI_NODES WHERE parent_id=new_parent AND deleted_flag=NO_FLAG;
SELECT NVL(MAX(height),0) INTO last_HEIGHT FROM CZ_UI_NODES
WHERE parent_id=new_parent AND rel_top_pos=last_TOP_POS AND
ui_node_type IN (UI_FEATURE_TYPE,UI_TOTAL_TYPE,UI_RESOURCE_TYPE,
UI_BOM_OPTION_CLASS_TYPE,UI_BOM_STANDART_TYPE,UI_BUTTON_TYPE)
AND deleted_flag=NO_FLAG;
SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES
WHERE ps_node_id=options(k).parent_id AND ui_def_id=in_ui_def_id
AND deleted_flag=NO_FLAG;
t_pages.Delete;
SELECT ps_node_type INTO var_ps_node_type FROM CZ_PS_NODES
WHERE ps_node_id=boms(k).parent_id;
FOR e IN(SELECT ui_node_id,ps_node_id FROM CZ_UI_NODES WHERE
ui_def_id=in_ui_def_id AND ps_node_id=boms(k).parent_id AND
ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG
ORDER BY ui_node_id)
LOOP
var_temp:=e.ui_node_id;
SELECT parent_id INTO var_ui_tree_parent_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_temp AND
ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag=NO_FLAG;
SELECT intl_text_id,tree_seq,name
INTO var_intl_text_id,var_tree_seq,var_parent_name
FROM CZ_PS_NODES
WHERE ps_node_id=boms(k).parent_id;
SELECT COUNT(ui_node_id) INTO counter FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp
AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET name=name||var_suffix
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_temp
AND deleted_flag=NO_FLAG
RETURNING caption_id,ui_node_ref_id,modified_flags
INTO var_caption_id,var_ui_node_ref_id,var_modified_flag;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT caption_id,modified_flags
INTO var_caption_id,var_modified_flag FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
AND deleted_flag=NO_FLAG;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
WHERE intl_text_id=var_temp AND var_modified_flag=0;
SELECT NVL(MAX(rel_top_pos),START_TOP_POS) INTO last_TOP_POS FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp AND parent_id<>var_limbo_id
AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
SELECT '1' INTO v_just_OC FROM DUAL WHERE EXISTS
(SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
AND ui_node_ref_id IS NOT NULL
AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG
AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
WHERE model_id=Project_Id AND referring_node_id IS NOT NULL AND deleted_flag=NO_FLAG))
AND NOT EXISTS
(SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
AND ui_node_ref_id IS NULL
AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG);
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BUTTON_TYPE AND func_comp_id IN
(SELECT func_comp_id FROM CZ_FUNC_COMP_SPECS WHERE (companion_type=2 AND modified_flags=NO_FLAG)
OR deleted_flag=YES_FLAG);
FOR h IN(SELECT a.func_comp_id,a.companion_type,
b.ui_node_id,b.parent_id,a.component_id,b.caption_id,a.name FROM CZ_FUNC_COMP_SPECS a,CZ_UI_NODES b
WHERE b.ui_def_id=in_ui_def_id AND b.ui_node_type=UI_BUTTON_TYPE
AND a.func_comp_id=b.func_comp_id AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
LOOP
--
-- AUTO-CONFIG =0 OUTPUT = 1 combinations :
-- 0100 = 4
-- 0110 = 6
-- 1100 = 12
-- 1110 = 14
--
IF h.companion_type IN(4,6,12,14) THEN
UPDATE CZ_UI_NODE_PROPS SET value_str='5' WHERE ui_def_id=in_ui_def_id
AND ui_node_id=h.ui_node_id AND key_str='ActionType';
UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
func_comp_id=h.func_comp_id and ui_node_id>h.ui_node_id AND
ui_node_type=UI_BUTTON_TYPE AND modified_flags=NO_FLAG AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODE_PROPS SET value_str='6' WHERE ui_def_id=in_ui_def_id
and ui_node_id=h.ui_node_id AND key_str='ActionType';
UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
func_comp_id=h.func_comp_id AND ui_node_id>h.ui_node_id AND
ui_node_type=UI_BUTTON_TYPE AND modified_flags=NO_FLAG AND deleted_flag=NO_FLAG;
SELECT value_str INTO var_action_type FROM CZ_UI_NODE_PROPS
WHERE ui_def_id=in_ui_def_id AND ui_node_id=h.ui_node_id AND key_str='ActionType'
AND deleted_flag=NO_FLAG;
UPDATE CZ_UI_NODES SET name=name||' (1)'
WHERE ui_def_id=in_ui_def_id AND ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
FOR i IN (SELECT ui_node_id,parent_id,ps_node_id,ui_node_ref_id,controltype,name FROM CZ_UI_NODES a
WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BUTTON_TYPE
AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG)
LOOP
FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND
parent_id=var_limbo_id AND ui_node_type NOT IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE))
LOOP
BEGIN
SELECT ui_node_id INTO var_temp FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
AND ui_node_id=i.parent_id AND parent_id=var_limbo_id AND deleted_flag=NO_FLAG;
FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES a WHERE ui_node_id=i.ui_node_ref_id AND
parent_id IN(SELECT ui_node_id FROM CZ_UI_NODES b WHERE a.ui_def_id=b.ui_def_id
AND name='Limbo' AND deleted_flag=NO_FLAG))
LOOP
out_run_id:=GLOBAL_RUN_ID;
FOR i IN (SELECT ui_node_ref_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND
ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE) AND
deleted_flag=NO_FLAG)
LOOP
shift_Latest_BUTTONS(i.ui_node_ref_id);
SELECT mMAX_NUMBER_PAGES*a.tree_seq,b.ui_node_id,b.ps_node_id,mMAX_NUMBER_PAGES*a.tree_seq-b.tree_seq
BULK COLLECT INTO t_tree_seq_tbl,t_ui_node_id_tbl,t_ps_node_id_tbl,t_tree_seq_delta_tbl
FROM CZ_PS_NODES a,CZ_UI_NODES b
WHERE b.ui_def_id=in_ui_def_id AND a.devl_project_id=Project_Id AND
a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG
AND a.ps_node_id=b.ps_node_id AND b.ui_node_type IN(UI_COMPONENT_REF_TYPE,UI_REFERENCE_REF_TYPE) AND b.tree_seq <> mMAX_NUMBER_PAGES*a.tree_seq;
UPDATE CZ_UI_NODES a
SET tree_seq=tree_seq+t_tree_seq_delta_tbl(i)
WHERE a.ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG
AND ps_node_id IS NULL AND ui_node_ref_id IN
(SELECT ui_node_id FROM CZ_UI_NODES
WHERE ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG AND ps_node_id=t_ps_node_id_tbl(i));
UPDATE CZ_UI_NODES
SET tree_seq = t_tree_seq_tbl(i)
WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_ui_node_id_tbl(i);
PROCEDURE update_Labels
(in_ui_node_id IN INTEGER,
in_use_labels IN VARCHAR2) IS
var_name CZ_PS_NODES.name%TYPE;
FOR i IN (SELECT a.ui_node_id,a.ps_node_id,a.caption_id,b.name,c.localized_str,c.language
FROM CZ_UI_NODES a,CZ_PS_NODES b, CZ_LOCALIZED_TEXTS c
WHERE a.parent_id=in_ui_node_id AND
a.ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE)
AND a.deleted_flag=NO_FLAG AND a.ps_node_id=b.ps_node_id
AND b.intl_text_id=c.intl_text_id)
LOOP
var_name:=i.name;
UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_name
WHERE intl_text_id=i.caption_id AND language=i.language AND var_keep_it='0';
END update_Labels;
SELECT USERENV('LANG') INTO mCURRENT_LANG FROM dual;
SELECT VALUE INTO mCONCAT_SYMBOL FROM CZ_DB_SETTINGS
WHERE UPPER(SETTING_ID)='UI_NODE_NAME_CONCAT_CHARS' AND rownum<2;