eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UI_GENERATOR dependencies on CZ_UI_NODES_S

Line 582: SELECT CZ_UI_NODES_S.nextval INTO currUISeqVal FROM dual;

578: --
579: IF currentUINode 580: currentUINode:=currentUINode+1;
581: ELSE
582: SELECT CZ_UI_NODES_S.nextval INTO currUISeqVal FROM dual;
583: currentUINode:=currUISeqVal;
584: END IF;
585: RETURN currentUINode;
586: END getUISeqVal;

Line 668: SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;

664: latest_buttons.DELETE;
665: footer_buttons.DELETE;
666: ref_boms.DELETE;
667:
668: SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;
669: currUISeqVal:=currentUINode;
670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
671: currentTXTNode:=currTXTSeqVal;
672:

Line 1669: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,

1665: last_HEIGHT:=DEFAULT_BUTTON_HEIGHT;
1666: var_left_border:=LEFT_MARGIN+i.width;
1667: END IF;
1668:
1669: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,
1670: rel_left_pos=var_left_pos
1671: WHERE ui_node_id=i.ui_node_id;
1672: var_left_pos:=var_left_border+SPACE_BETWEEN;
1673: END LOOP;

Line 1740: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,

1736: var_left_pos:=LEFT_MARGIN;
1737: last_HEIGHT:=DEFAULT_BUTTON_HEIGHT;
1738: var_left_border:=LEFT_MARGIN+i.width;
1739: END IF;
1740: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS,
1741: rel_left_pos=var_left_pos
1742: WHERE ui_node_id=i.ui_node_id;
1743: var_left_pos:=var_left_border+SPACE_BETWEEN;
1744:

Line 2423: UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id

2419:
2420: IF in_arr.virtual_flag=NO_FLAG AND in_arr.parent_id IS NOT NULL
2421: AND mUI_STYLE=DHTML_STYLE_UI THEN
2422:
2423: UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id
2424: WHERE ui_node_ref_id=in_node_id;
2425:
2426: -- Delete Button --
2427: create_BUTTON(getUISeqVal,in_node_id,in_ui_def_id,

Line 2830: UPDATE CZ_UI_NODES SET model_ref_expl_id=var_expl_id,ui_def_ref_id=out_ref_ui_id

2826: in_font_underline =>NO_FLAG,
2827: in_intl_text_id =>in_arr.intl_text_id);
2828: ERROR_CODE:='00194';
2829:
2830: UPDATE CZ_UI_NODES SET model_ref_expl_id=var_expl_id,ui_def_ref_id=out_ref_ui_id
2831: WHERE ui_node_id=in_node_id AND ui_def_id=in_ui_def_id;
2832:
2833: ERROR_CODE:='00195';
2834:

Line 3074: UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id

3070:
3071: IF in_arr.virtual_flag=NO_FLAG
3072: AND mUI_STYLE=DHTML_STYLE_UI THEN
3073:
3074: UPDATE CZ_UI_NODES SET component_id=in_arr.ps_node_id,ps_node_id=in_arr.ps_node_id
3075: WHERE ui_node_ref_id=in_node_id;
3076:
3077: -- Delete Button --
3078: create_BUTTON(getUISeqVal,in_node_id,in_ui_def_id,

Line 3233: UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id

3229: --
3230: -- set ui_node_ref_id for UI BOM STANDART ITEMS associted with BOM MODEL --
3231: --
3232: BEGIN
3233: UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id
3234: WHERE ui_def_id=in_ui_def_id AND ui_node_id IN
3235: (SELECT ui_node_id FROM CZ_UI_NODES
3236: WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE
3237: AND ps_node_id=in_arr.ps_node_id AND deleted_flag=NO_FLAG);

Line 3378: UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id

3374: --
3375: -- set ui_node_ref_id for UI BOM STANDART ITEMS associted with BOM MODEL --
3376: --
3377: BEGIN
3378: UPDATE CZ_UI_NODES SET ui_node_ref_id=in_node_id
3379: WHERE ui_def_id=in_ui_def_id AND ui_node_id IN
3380: (SELECT ui_node_id FROM CZ_UI_NODES
3381: WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE
3382: AND ps_node_id=in_arr.ps_node_id AND deleted_flag=NO_FLAG);

Line 4425: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS

4421: END LOOP;
4422:
4423: /* ****
4424: IF mUI_STYLE=DHTML_STYLE_UI THEN
4425: UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS
4426: WHERE ui_def_id=in_ui_def_id AND ui_node_id=in_new_parent_id;
4427: END IF;
4428: */
4429:

Line 4748: UPDATE CZ_UI_NODES SET name=name||var_suffix

4744:
4745: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4746: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4747:
4748: UPDATE CZ_UI_NODES SET name=name||var_suffix
4749: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_new_parent_id
4750: AND deleted_flag='0'
4751: RETURNING caption_id,ui_node_ref_id,modified_flags
4752: INTO var_temp,var_ui_node_ref_id,var_modified_flag;

Line 4830: -- UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS

4826: /* *** VB code needs this update for Preview *** */
4827: /* *** if we add a new control then VB should add *** */
4828: /* *** the control under all others control on the screen *** */
4829: --IF mUI_STYLE=DHTML_STYLE_UI THEN
4830: -- UPDATE CZ_UI_NODES SET rel_top_pos=last_TOP_POS
4831: -- WHERE ui_def_id=in_ui_def_id AND ui_node_id=in_new_parent_id;
4832: --END IF;
4833:
4834: EXCEPTION

Line 5315: UPDATE CZ_UI_NODES SET name=InterfaceName WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;

5311: create_Footprints(new_ui_def_id,var_ui_root_id);
5312: ERROR_CODE:='0041';
5313:
5314: /* *** OUT NOCOPY variable is ID of the generated UI *** */
5315: UPDATE CZ_UI_NODES SET name=InterfaceName WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
5316: out_ui_def_id:=new_ui_def_id;
5317:
5318: ERROR_CODE:='0042';
5319:

Line 5502: UPDATE CZ_UI_NODES SET caption_id=var_caption_id

5498: /* ***
5499: BEGIN
5500: IF in_caption IS NOT NULL THEN
5501: var_caption_id:=getTXTSeqVal;
5502: UPDATE CZ_UI_NODES SET caption_id=var_caption_id
5503: WHERE ui_def_id=in_def_id AND ui_node_id=in_id;
5504: FOR i IN(SELECT message_text,language_code FROM FND_NEW_MESSAGES WHERE message_name=in_caption)
5505: LOOP
5506: INSERT INTO CZ_LOCALIZED_TEXTS

Line 6553: UPDATE CZ_UI_NODES SET name=InterfaceName

6549: in_ui_def_id =>new_ui_def_id,
6550: in_show_all_nodes =>in_show_all_nodes,
6551: in_use_labels =>in_use_labels);
6552:
6553: UPDATE CZ_UI_NODES SET name=InterfaceName
6554: WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
6555:
6556: out_ui_def_id:=new_ui_def_id;
6557:

Line 6700: UPDATE CZ_UI_NODES SET ui_node_ref_id=var_ref_root_screen

6696: SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
6697: WHERE ui_def_id=var_ui_def_id AND ui_node_type=UI_SCREEN_TYPE
6698: AND ps_node_id=var_reference_id AND deleted_flag=NO_FLAG AND rownum<2;
6699:
6700: UPDATE CZ_UI_NODES SET ui_node_ref_id=var_ref_root_screen
6701: WHERE ui_def_id=out_ui_def_id AND ui_node_type=UI_BOM_STANDART_TYPE AND ps_node_id=i.ps_node_id
6702: AND deleted_flag=NO_FLAG;
6703: END;
6704: END IF;

Line 6709: UPDATE CZ_UI_NODES SET ui_def_ref_id=var_ui_def_id

6705:
6706: --
6707: -- update ui_def_ref_id of UI reference
6708: --
6709: UPDATE CZ_UI_NODES SET ui_def_ref_id=var_ui_def_id
6710: WHERE ui_node_id=i.ui_node_id;
6711:
6712:
6713: IF in_ui_style=DHTML_STYLE_UI THEN

Line 7038: UPDATE CZ_UI_NODES SET parent_id=movedReferences(ind).new_parent_id

7034:
7035: IF movedReferences.Count>0 THEN
7036: ind:=movedReferences.First;
7037: LOOP
7038: UPDATE CZ_UI_NODES SET parent_id=movedReferences(ind).new_parent_id
7039: WHERE ui_def_id=in_ui_def_id
7040: AND ui_node_id=ind AND ui_node_type=UI_REFERENCE_REF_TYPE AND
7041: parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7042:

Line 7049: UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos

7045: parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7046:
7047: var_top_pos:=getNextY(in_ui_def_id,var_id);
7048:
7049: UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos
7050: WHERE ui_def_id=in_ui_def_id
7051: AND ps_node_id=movedReferences(ind).ps_node_id AND ui_node_type=UI_BUTTON_TYPE
7052: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7053:

Line 7084: UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos

7080: END;
7081:
7082: var_top_pos:=getNextY(in_ui_def_id,var_id);
7083:
7084: UPDATE CZ_UI_NODES SET parent_id=var_id,rel_top_pos=var_top_pos
7085: WHERE ui_def_id=in_ui_def_id AND parent_id=movedComponents(ind).parent_id
7086: AND ps_node_id=movedComponents(ind).ps_node_id AND ui_node_type=UI_BUTTON_TYPE
7087: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7088:

Line 7110: UPDATE CZ_UI_NODES SET parent_id=movedFeatures(ind).new_parent_id,rel_top_pos=var_top_pos

7106: WHERE ui_def_id=in_ui_def_id
7107: AND ui_node_id=ind AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_CONNECTOR_TYPE) AND
7108: deleted_flag=NO_FLAG;
7109:
7110: UPDATE CZ_UI_NODES SET parent_id=movedFeatures(ind).new_parent_id,rel_top_pos=var_top_pos
7111: WHERE ui_def_id=in_ui_def_id
7112: AND ui_node_id=movedFeatures(ind).ui_ref_id AND ui_node_type=UI_TEXT_LABEL_TYPE AND
7113: deleted_flag=NO_FLAG;
7114:

Line 7201: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;

7197: IF in_replace_flag=YES_FLAG THEN
7198: SELECT name INTO var_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=in_old_def_id;
7199: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;
7200: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;
7201: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;
7202: UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;
7203: END IF;
7204:
7205: SELECT ui_node_id INTO var_old_limbo_id FROM CZ_UI_NODES

Line 7202: UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;

7198: SELECT name INTO var_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=in_old_def_id;
7199: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;
7200: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;
7201: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;
7202: UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;
7203: END IF;
7204:
7205: SELECT ui_node_id INTO var_old_limbo_id FROM CZ_UI_NODES
7206: WHERE ui_def_id=in_old_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;

Line 7211: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_new_def_id

7207:
7208: SELECT ui_node_id INTO var_new_limbo_id FROM CZ_UI_NODES
7209: WHERE ui_def_id=in_new_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
7210:
7211: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_new_def_id
7212: AND ui_node_type=UI_BUTTON_TYPE;
7213:
7214: SELECT * INTO var_header FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND
7215: ui_node_type=UI_ROOT_SYSTEM_TYPE AND deleted_flag=NO_FLAG;

Line 7235: UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE

7231: FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7232: AND deleted_flag=NO_FLAG)
7233: LOOP
7234: IF i.parent_id=var_old_limbo_id THEN
7235: UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE
7236: ui_def_id=in_new_def_id AND ps_node_id=i.ps_node_id AND ui_node_type=i.ui_node_type
7237: AND deleted_flag=NO_FLAG;
7238: END IF;
7239: IF i.ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)

Line 7248: UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE

7244: Map(i.ps_node_id):=var_name;
7245: END IF;
7246: END LOOP;
7247:
7248: UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE
7249: ui_def_id=in_new_def_id AND ui_node_ref_id IN(SELECT ui_node_id FROM CZ_UI_NODES
7250: WHERE ui_def_id=in_new_def_id AND parent_id=var_new_limbo_id) AND ui_node_type=UI_COMPONENT_REF_TYPE;
7251:
7252: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND

Line 7256: UPDATE CZ_UI_NODES SET deleted_flag='1' WHERE ui_def_id=in_new_def_id AND

7252: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND
7253: ps_node_type IN(PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,
7254: BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE) AND deleted_flag=NO_FLAG)
7255: LOOP
7256: UPDATE CZ_UI_NODES SET deleted_flag='1' WHERE ui_def_id=in_new_def_id AND
7257: parent_id IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ps_node_id=i.ps_node_id
7258: AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG)
7259: AND ui_node_type NOT IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
7260: AND parent_id<>var_new_limbo_id;

Line 7471: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE

7467: LOOP
7468: --
7469: -- remove an associated buttons and references --
7470: --
7471: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE
7472: ps_node_id=i.ps_node_id AND ui_node_type IN (UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE)
7473: AND ui_def_id=in_ui_def_id;
7474:
7475: --

Line 7492: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

7488: AND a.ps_node_type=437 AND b.ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND b.page_number<>1 AND
7489: NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
7490: AND parent_id=b.ui_node_id AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG))
7491: LOOP
7492: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
7493: WHERE ui_def_id=in_ui_def_id AND ui_node_id=i.ui_node_id;
7494: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
7495: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=i.ui_node_id;
7496: END LOOP;

Line 7494: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

7490: AND parent_id=b.ui_node_id AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG))
7491: LOOP
7492: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
7493: WHERE ui_def_id=in_ui_def_id AND ui_node_id=i.ui_node_id;
7494: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
7495: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=i.ui_node_id;
7496: END LOOP;
7497:
7498: END delete_UI_NODES;

Line 7894: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;

7890:
7891:
7892: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;
7893: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;
7894: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
7895: UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;
7896: in_ui_def_id:=new_ui_def_id;
7897: RAISE BREAK_IT;
7898: END IF;

Line 7895: UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;

7891:
7892: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;
7893: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;
7894: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
7895: UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;
7896: in_ui_def_id:=new_ui_def_id;
7897: RAISE BREAK_IT;
7898: END IF;
7899:

Line 8243: UPDATE CZ_UI_NODES SET model_ref_expl_id=var_model_ref_id WHERE ui_def_id=in_ui_def_id

8239: model_id=Project_Id AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;
8240: END IF;
8241:
8242: /* *** refresh model_ref_expl_id-s for all Components,Products,References and UI controls *** */
8243: UPDATE CZ_UI_NODES SET model_ref_expl_id=var_model_ref_id WHERE ui_def_id=in_ui_def_id
8244: AND model_ref_expl_id IS NOT NULL AND model_ref_expl_id<>var_model_ref_id
8245: AND ps_node_id=i.ps_node_id AND deleted_flag='0';
8246: EXCEPTION
8247: WHEN NO_DATA_FOUND THEN

Line 8271: UPDATE CZ_UI_NODES SET name=i.name

8267: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id AND deleted_flag=NO_FLAG;
8268:
8269: /* *** name of the reference should be = PS node's name *** */
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

Line 8402: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id

8398:
8399:
8400: /* *** delete reference if UI and PS tree references are not synchronized *** */
8401: IF var_ref_model_id<>i.reference_id THEN
8402: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id
8403: AND ps_node_id=i.ps_node_id AND ui_node_type=UI_REFERENCE_REF_TYPE;
8404: END IF;
8405:
8406: EXCEPTION

Line 8431: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

8427: IF (i.maximum=1 AND i.minimum=1 AND i.virtual_flag=YES_FLAG) THEN
8428: --
8429: -- delete an associated buttons ---
8430: --
8431: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
8432: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id
8433: AND ui_node_type IN(UI_BUTTON_TYPE) AND modified_flags IN(0,1);
8434:
8435: IF var_ui_node_type=UI_BOM_INST_ITEM_TYPE THEN

Line 8436: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

8432: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id
8433: AND ui_node_type IN(UI_BUTTON_TYPE) AND modified_flags IN(0,1);
8434:
8435: IF var_ui_node_type=UI_BOM_INST_ITEM_TYPE THEN
8436: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
8437: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_ui_id
8438: AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND deleted_flag=NO_FLAG;
8439:
8440: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

Line 8440: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

8436: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
8437: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_ui_id
8438: AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND deleted_flag=NO_FLAG;
8439:
8440: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
8441: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_node_ref_id
8442: AND ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
8443:
8444: BEGIN

Line 8563: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG

8559: EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
8560: AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND ps_node_id=i.ps_node_id AND
8561: deleted_flag=NO_FLAG);
8562: */
8563: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG
8564: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_inst_ui_id AND ui_node_type=UI_BOM_STANDART_TYPE;
8565:
8566: var_ui_node_id:=getUISeqVal;
8567:

Line 8743: UPDATE CZ_UI_NODES SET name=i.name

8739: IF t_bom_pages.Count=1 THEN
8740:
8741: /* *** name of the reference should be = PS node's name *** */
8742: IF i.name<>var_screen_name THEN
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

Line 8797: UPDATE CZ_UI_NODES SET name=i.name||var_suffix

8793: END IF;
8794:
8795: /* *** name of the reference should be = PS node's name *** */
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;

Line 8869: UPDATE CZ_UI_NODES SET name=i.name

8865: footer_buttons(ind_arr).ui_parent_id:=var_screen_ui_id;
8866:
8867: /* *** name of the reference should be = PS node's name *** */
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;

Line 8898: UPDATE CZ_UI_NODES SET width=var_width

8894: WHERE intl_text_id=var_tree_caption_id AND language=l.language;
8895: IF l.language=mCURRENT_LANG THEN
8896: var_button_label:=var_label;
8897: var_width:=set_Title_Width(var_label);
8898: UPDATE CZ_UI_NODES SET width=var_width
8899: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
8900: AND modified_flags=0;
8901: END IF;
8902: END LOOP;

Line 8942: UPDATE CZ_UI_NODES SET component_id=i.ps_node_id,ps_node_id=i.ps_node_id

8938: in_button_type=>DEF_DELETE_BUTTON,
8939: in_width =>DELETE_BUTTON_WIDTH,
8940: in_modified_flag => 0);
8941:
8942: UPDATE CZ_UI_NODES SET component_id=i.ps_node_id,ps_node_id=i.ps_node_id
8943: WHERE ui_node_id=var_tree_ui_id AND ui_def_id=in_ui_def_id AND ui_node_type=UI_COMPONENT_REF_TYPE;
8944:
8945: /* *** create "Add ..." button under the parent node's screen *** */
8946: curr_button_id:=getUISeqVal;

Line 8989: UPDATE CZ_UI_NODES SET name=i.name

8985: --
8986: -- name of the reference should be = PS node's name --
8987: --
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;

Line 9020: UPDATE CZ_UI_NODES SET width=var_width

9016: IF var_width <= SCREEN_HALF THEN
9017: var_width:=SCREEN_HALF;
9018: END IF;
9019:
9020: UPDATE CZ_UI_NODES SET width=var_width
9021: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
9022: AND modified_flags=0;
9023: END IF;
9024:

Line 9033: UPDATE CZ_UI_NODES SET name=i.name

9029: /*
9030: IF i.ps_node_type=OPTION_NODE_TYPE THEN
9031:
9032: IF i.name<>var_screen_name THEN
9033: UPDATE CZ_UI_NODES SET name=i.name
9034: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id;
9035: END IF;
9036:
9037: var_use_labels:='1';

Line 9076: UPDATE CZ_UI_NODES SET name=i.name

9072: IF i.ps_node_type=FEATURE_NODE_TYPE THEN
9073:
9074: /* *** name of the reference should be = PS node's name *** */
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;

Line 9103: UPDATE CZ_UI_NODES SET width=var_width

9099:
9100: /* *** for now don't change width of label ***
9101: IF l.language=mCURRENT_LANG THEN
9102: var_width:=set_Text_Width(var_label);
9103: UPDATE CZ_UI_NODES SET width=var_width
9104: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id
9105: AND modified_flags=0;
9106: END IF;
9107: */

Line 9183: UPDATE CZ_UI_NODES SET tree_seq=m.tree_seq

9179: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ps_node_id=m.ps_node_id
9180: AND deleted_flag=NO_FLAG AND parent_id<>var_limbo_id AND modified_flags=0;
9181:
9182: IF m.tree_seq<>var_ui_tree_seq THEN
9183: UPDATE CZ_UI_NODES SET tree_seq=m.tree_seq
9184: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_option_ui_id;
9185: END IF;
9186:
9187: IF var_use_labels<>USE_PROPERTY_DESCRIPTIONS THEN

Line 9189: UPDATE CZ_UI_NODES SET name=m.name

9185: END IF;
9186:
9187: IF var_use_labels<>USE_PROPERTY_DESCRIPTIONS THEN
9188: IF m.name<>var_option_ui_name THEN
9189: UPDATE CZ_UI_NODES SET name=m.name
9190: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_option_ui_id;
9191: var_label:=m.name;
9192:
9193: IF m.intl_text_id IS NULL THEN

Line 9280: UPDATE CZ_UI_NODES SET width=var_width,

9276: UPDATE CZ_UI_NODES
9277: SET controltype=var_control_type
9278: WHERE ui_node_id=var_screen_ui_id AND parent_id<>var_limbo_id;
9279: END IF;
9280: UPDATE CZ_UI_NODES SET width=var_width,
9281: borders=var_borders
9282: WHERE ui_node_id=var_screen_ui_id AND parent_id<>var_limbo_id
9283: AND modified_flags=0;
9284: END IF;

Line 9296: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_node_id IN

9292:
9293: IF var_ui_feature_type='0' OR i.feature_type=0 THEN
9294:
9295: /* *** delete OPTIONs - List Of Options *** */
9296: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_node_id IN
9297: (SELECT ui_node_id FROM CZ_UI_NODES WHERE parent_id=var_screen_ui_id
9298: AND ui_node_type=UI_OPTION_TYPE AND deleted_flag=NO_FLAG);
9299:
9300: END IF; /* *** end of var_ui_feature_type='0' OR i.feature_type=0 case *** */

Line 9822: UPDATE CZ_UI_NODES SET name=name||var_suffix

9818: IF t_pages(boms(k).parent_id)=1 AND var_ps_node_type = BOM_CLASS_NODE_TYPE THEN
9819: BEGIN
9820: var_suffix:=' ('||TO_CHAR(t_pages(boms(k).parent_id))||')';
9821:
9822: UPDATE CZ_UI_NODES SET name=name||var_suffix
9823: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_temp
9824: AND deleted_flag=NO_FLAG
9825: RETURNING caption_id,ui_node_ref_id,modified_flags
9826: INTO var_caption_id,var_ui_node_ref_id,var_modified_flag;

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

9971: END IF;
9972:
9973: populate_RefSI(in_ui_def_id);
9974:
9975: 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
9976: (SELECT func_comp_id FROM CZ_FUNC_COMP_SPECS WHERE (companion_type=2 AND modified_flags=NO_FLAG)
9977: OR deleted_flag=YES_FLAG);
9978:
9979: /* *** synchronize types of Functional Companions *** */

Line 9997: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND

9993: IF h.companion_type IN(4,6,12,14) THEN
9994: UPDATE CZ_UI_NODE_PROPS SET value_str='5' WHERE ui_def_id=in_ui_def_id
9995: AND ui_node_id=h.ui_node_id AND key_str='ActionType';
9996:
9997: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
9998: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
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;

Line 10003: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND

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
10005: ui_node_type=UI_BUTTON_TYPE AND modified_flags=NO_FLAG AND deleted_flag=NO_FLAG;
10006: END IF;
10007:

Line 10019: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND

10015: IF h.companion_type IN(1,3,9,11) THEN
10016: UPDATE CZ_UI_NODE_PROPS SET value_str='6' WHERE ui_def_id=in_ui_def_id
10017: and ui_node_id=h.ui_node_id AND key_str='ActionType';
10018:
10019: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
10020: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
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;

Line 10025: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND

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
10027: ui_node_type=UI_BUTTON_TYPE AND modified_flags=NO_FLAG AND deleted_flag=NO_FLAG;
10028: END IF;
10029:

Line 10061: UPDATE CZ_UI_NODES SET name=name||' (1)'

10057: in_button_type =>var_button_type,
10058: in_func_comp_id =>h.func_comp_id,
10059: in_modified_flag => 0);
10060:
10061: UPDATE CZ_UI_NODES SET name=name||' (1)'
10062: WHERE ui_def_id=in_ui_def_id AND ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
10063:
10064: IF latest_buttons.Count=0 THEN
10065: ind:=1;