[Home] [Help]
1: PACKAGE BODY CZ_UI_GENERATOR AS
2: /* $Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $ */
3:
4: TYPE UIStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
3:
4: TYPE UIStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);
33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,
40: caption_name CZ_INTL_TEXTS.text_str%TYPE,
41: atp_flag BOOLEAN);
42:
43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,
40: caption_name CZ_INTL_TEXTS.text_str%TYPE,
41: atp_flag BOOLEAN);
42:
43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,
54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
50:
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,
54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,
54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,
54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
64: name CZ_UI_NODES.name%TYPE);
65:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
64: name CZ_UI_NODES.name%TYPE);
65:
66:
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
64: name CZ_UI_NODES.name%TYPE);
65:
66:
67: TYPE UIArray IS TABLE OF UIStructure INDEX BY VARCHAR2(15);
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
64: name CZ_UI_NODES.name%TYPE);
65:
66:
67: TYPE UIArray IS TABLE OF UIStructure INDEX BY VARCHAR2(15);
68: TYPE featureArray IS TABLE OF featureStructure INDEX BY VARCHAR2(15);
98: Project_Id CZ_PS_NODES.devl_project_id%TYPE;
99: Model_Id CZ_UI_DEFS.devl_project_id%TYPE;
100: UI_Product_Id CZ_UI_DEFS.component_id%TYPE;
101: current_UI_DEF_ID CZ_UI_DEFS.ui_def_id%TYPE;
102: currUISeqVal CZ_UI_NODES.ui_node_id%TYPE:=0;
103: currentUINode CZ_UI_NODES.ui_node_id%TYPE:=mINCREMENT;
104: currTXTSeqVal CZ_INTL_TEXTS.intl_text_id%TYPE;
105: currentTXTNode CZ_INTL_TEXTS.intl_text_id%TYPE;
106: Model_Name CZ_PS_NODES.name%TYPE;
99: Model_Id CZ_UI_DEFS.devl_project_id%TYPE;
100: UI_Product_Id CZ_UI_DEFS.component_id%TYPE;
101: current_UI_DEF_ID CZ_UI_DEFS.ui_def_id%TYPE;
102: currUISeqVal CZ_UI_NODES.ui_node_id%TYPE:=0;
103: currentUINode CZ_UI_NODES.ui_node_id%TYPE:=mINCREMENT;
104: currTXTSeqVal CZ_INTL_TEXTS.intl_text_id%TYPE;
105: currentTXTNode CZ_INTL_TEXTS.intl_text_id%TYPE;
106: Model_Name CZ_PS_NODES.name%TYPE;
107: UI_Version PLS_INTEGER:=1;
105: currentTXTNode CZ_INTL_TEXTS.intl_text_id%TYPE;
106: Model_Name CZ_PS_NODES.name%TYPE;
107: UI_Version PLS_INTEGER:=1;
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;
110: USABLE_HEIGHT CZ_UI_NODES.height%TYPE;
111: CENTER_LINE CZ_UI_NODES.width%TYPE;
112: SCREEN_HALF CZ_UI_NODES.width%TYPE;
113:
106: Model_Name CZ_PS_NODES.name%TYPE;
107: UI_Version PLS_INTEGER:=1;
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;
110: USABLE_HEIGHT CZ_UI_NODES.height%TYPE;
111: CENTER_LINE CZ_UI_NODES.width%TYPE;
112: SCREEN_HALF CZ_UI_NODES.width%TYPE;
113:
114: GLOBAL_FRAME_ALLOCATION INTEGER:=-1;
107: UI_Version PLS_INTEGER:=1;
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;
110: USABLE_HEIGHT CZ_UI_NODES.height%TYPE;
111: CENTER_LINE CZ_UI_NODES.width%TYPE;
112: SCREEN_HALF CZ_UI_NODES.width%TYPE;
113:
114: GLOBAL_FRAME_ALLOCATION INTEGER:=-1;
115:
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;
110: USABLE_HEIGHT CZ_UI_NODES.height%TYPE;
111: CENTER_LINE CZ_UI_NODES.width%TYPE;
112: SCREEN_HALF CZ_UI_NODES.width%TYPE;
113:
114: GLOBAL_FRAME_ALLOCATION INTEGER:=-1;
115:
116: CZ_EXTENTSIONS_RULE_TYPE CONSTANT NUMBER := 300;
388: UI_APPLET_TREE_NODE_TYPE CONSTANT INTEGER:=158;
389: DEFAULT_CONNECTOR_HEIGHT CONSTANT INTEGER:=24;
390: STAR_SYMBOL_WIDTH CONSTANT INTEGER:=3;
391:
392: DEFAULT_TOTAL_WIDTH CZ_UI_NODES.width%TYPE;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
389: DEFAULT_CONNECTOR_HEIGHT CONSTANT INTEGER:=24;
390: STAR_SYMBOL_WIDTH CONSTANT INTEGER:=3;
391:
392: DEFAULT_TOTAL_WIDTH CZ_UI_NODES.width%TYPE;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
390: STAR_SYMBOL_WIDTH CONSTANT INTEGER:=3;
391:
392: DEFAULT_TOTAL_WIDTH CZ_UI_NODES.width%TYPE;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
398: CONNECTOR_GAP CZ_UI_NODES.width%TYPE;
391:
392: DEFAULT_TOTAL_WIDTH CZ_UI_NODES.width%TYPE;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
398: CONNECTOR_GAP CZ_UI_NODES.width%TYPE;
399:
392: DEFAULT_TOTAL_WIDTH CZ_UI_NODES.width%TYPE;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
398: CONNECTOR_GAP CZ_UI_NODES.width%TYPE;
399:
400: GLOBAL_RUN_ID INTEGER:=0;
393: DEFAULT_RESOURCE_WIDTH CZ_UI_NODES.width%TYPE;
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
398: CONNECTOR_GAP CZ_UI_NODES.width%TYPE;
399:
400: GLOBAL_RUN_ID INTEGER:=0;
401: GLOBAL_GEN_VERSION VARCHAR2(25):='11.5.8.18.9';
394: DEFAULT_CONNECTOR_WIDTH CZ_UI_NODES.width%TYPE;
395: BOOLEAN_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
396: NUMERIC_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
397: OPTION_FEATURE_WIDTH CZ_UI_NODES.width%TYPE;
398: CONNECTOR_GAP CZ_UI_NODES.width%TYPE;
399:
400: GLOBAL_RUN_ID INTEGER:=0;
401: GLOBAL_GEN_VERSION VARCHAR2(25):='11.5.8.18.9';
402: GLOBAL_GEN_HEADER VARCHAR2(100):='$Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $';
400: GLOBAL_RUN_ID INTEGER:=0;
401: GLOBAL_GEN_VERSION VARCHAR2(25):='11.5.8.18.9';
402: GLOBAL_GEN_HEADER VARCHAR2(100):='$Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $';
403:
404: last_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE;
405: last_WIDTH CZ_UI_NODES.width%TYPE;
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
401: GLOBAL_GEN_VERSION VARCHAR2(25):='11.5.8.18.9';
402: GLOBAL_GEN_HEADER VARCHAR2(100):='$Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $';
403:
404: last_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE;
405: last_WIDTH CZ_UI_NODES.width%TYPE;
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
402: GLOBAL_GEN_HEADER VARCHAR2(100):='$Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $';
403:
404: last_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE;
405: last_WIDTH CZ_UI_NODES.width%TYPE;
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
410: DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
404: last_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE;
405: last_WIDTH CZ_UI_NODES.width%TYPE;
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
410: DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
411:
412: START_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT;
405: last_WIDTH CZ_UI_NODES.width%TYPE;
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
410: DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
411:
412: START_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT;
413:
406: last_HEIGHT CZ_UI_NODES.height%TYPE;
407:
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
410: DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
411:
412: START_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT;
413:
414: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
408: DELETE_BUTTON_LEFT_POS CZ_UI_NODES.rel_left_pos%TYPE;
409: DELETE_BUTTON_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=10;
410: DELETE_BUTTON_WIDTH CZ_UI_NODES.width%TYPE:=75;
411:
412: START_TOP_POS CZ_UI_NODES.rel_top_pos%TYPE:=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT;
413:
414: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
415: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
416:
578: --
579: IF currentUINode
581: ELSE
582: SELECT CZ_UI_NODES_S.nextval INTO currUISeqVal FROM dual;
583: currentUINode:=currUISeqVal;
584: END IF;
585: RETURN currentUINode;
586: END getUISeqVal;
636: var_height INTEGER;
637: ret INTEGER;
638:
639: BEGIN
640: SELECT NVL(MAX(rel_top_pos),50) INTO var_top_pos FROM CZ_UI_NODES
641: WHERE ui_def_id=in_ui_def_id AND parent_id=in_parent_id AND
642: deleted_flag=NO_FLAG;
643:
644: SELECT NVL(MAX(height),DEFAULT_CONTROL_HEIGHT)
641: WHERE ui_def_id=in_ui_def_id AND parent_id=in_parent_id AND
642: deleted_flag=NO_FLAG;
643:
644: SELECT NVL(MAX(height),DEFAULT_CONTROL_HEIGHT)
645: INTO var_height FROM CZ_UI_NODES
646: WHERE ui_def_id=in_ui_def_id AND parent_id=in_parent_id
647: AND rel_top_pos=var_top_pos
648: AND deleted_flag=NO_FLAG;
649:
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:
684:
685: PROCEDURE remove_UI_Subtree
686: (in_ui_node_id IN INTEGER,
687: in_ui_node_type IN INTEGER) IS
688: var_start_ui_node CZ_UI_NODES.ui_node_id%TYPE;
689: END_OPERATION1 EXCEPTION;
690: END_OPERATION2 EXCEPTION;
691: BEGIN
692: var_start_ui_node:=in_ui_node_id;
692: var_start_ui_node:=in_ui_node_id;
693: IF in_ui_node_type<>UI_COMPONENT_REF_TYPE THEN
694: BEGIN
695: BEGIN
696: SELECT ui_node_id INTO var_start_ui_node FROM CZ_UI_NODES
697: WHERE ui_node_ref_id=in_ui_node_id AND ui_node_type=UI_COMPONENT_REF_TYPE;
698: RAISE END_OPERATION1;
699: EXCEPTION
700: WHEN NO_DATA_FOUND THEN
700: WHEN NO_DATA_FOUND THEN
701: NULL;
702: END;
703:
704: FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
705: START WITH ui_node_id=in_ui_node_id
706: CONNECT BY PRIOR ui_node_id=parent_id)
707: LOOP
708: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
704: FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
705: START WITH ui_node_id=in_ui_node_id
706: CONNECT BY PRIOR ui_node_id=parent_id)
707: LOOP
708: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
709: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
710: ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
711: END LOOP;
712: RAISE END_OPERATION2;
705: START WITH ui_node_id=in_ui_node_id
706: CONNECT BY PRIOR ui_node_id=parent_id)
707: LOOP
708: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
709: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
710: ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
711: END LOOP;
712: RAISE END_OPERATION2;
713: EXCEPTION
718:
719: --
720: -- remove starting with node of UI Model Tree --
721: --
722: FOR i IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
723: START WITH ui_node_id=var_start_ui_node
724: CONNECT BY PRIOR ui_node_id=parent_id)
725: LOOP
726: FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
722: FOR i IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
723: START WITH ui_node_id=var_start_ui_node
724: CONNECT BY PRIOR ui_node_id=parent_id)
725: LOOP
726: FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
727: START WITH ui_node_id=i.ui_node_ref_id
728: CONNECT BY PRIOR ui_node_id=parent_id)
729: LOOP
730: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
726: FOR l IN (SELECT ui_node_id,ui_node_ref_id FROM CZ_UI_NODES
727: START WITH ui_node_id=i.ui_node_ref_id
728: CONNECT BY PRIOR ui_node_id=parent_id)
729: LOOP
730: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
731: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
732: ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
733: END LOOP;
734: DELETE FROM CZ_UI_NODES WHERE ui_node_id=i.ui_node_id AND deleted_flag=NO_FLAG;
727: START WITH ui_node_id=i.ui_node_ref_id
728: CONNECT BY PRIOR ui_node_id=parent_id)
729: LOOP
730: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
731: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
732: ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
733: END LOOP;
734: DELETE FROM CZ_UI_NODES WHERE ui_node_id=i.ui_node_id AND deleted_flag=NO_FLAG;
735: END LOOP;
730: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_id AND deleted_flag=NO_FLAG;
731: DELETE FROM CZ_UI_NODES WHERE ui_node_id=l.ui_node_ref_id AND
732: ui_node_type=UI_TEXT_LABEL_TYPE AND deleted_flag=NO_FLAG;
733: END LOOP;
734: DELETE FROM CZ_UI_NODES WHERE ui_node_id=i.ui_node_id AND deleted_flag=NO_FLAG;
735: END LOOP;
736:
737: EXCEPTION
738: WHEN END_OPERATION2 THEN
799: in_model_ref_expl_id IN INTEGER DEFAULT NULL,
800: in_use_labels IN VARCHAR2 DEFAULT NULL,
801: in_cx_command_name IN VARCHAR2 DEFAULT NULL ) IS
802:
803: var_caption_id CZ_UI_NODES.caption_id%TYPE;
804: var_tool_tip_id CZ_UI_NODES.tool_tip_id%TYPE;
805: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
806: var_background_color CZ_UI_NODES.background_color%TYPE;
807: var_font_color CZ_UI_NODES.fontcolor%TYPE;
800: in_use_labels IN VARCHAR2 DEFAULT NULL,
801: in_cx_command_name IN VARCHAR2 DEFAULT NULL ) IS
802:
803: var_caption_id CZ_UI_NODES.caption_id%TYPE;
804: var_tool_tip_id CZ_UI_NODES.tool_tip_id%TYPE;
805: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
806: var_background_color CZ_UI_NODES.background_color%TYPE;
807: var_font_color CZ_UI_NODES.fontcolor%TYPE;
808: var_name CZ_INTL_TEXTS.text_str%TYPE;
801: in_cx_command_name IN VARCHAR2 DEFAULT NULL ) IS
802:
803: var_caption_id CZ_UI_NODES.caption_id%TYPE;
804: var_tool_tip_id CZ_UI_NODES.tool_tip_id%TYPE;
805: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
806: var_background_color CZ_UI_NODES.background_color%TYPE;
807: var_font_color CZ_UI_NODES.fontcolor%TYPE;
808: var_name CZ_INTL_TEXTS.text_str%TYPE;
809: var_label CZ_LOCALIZED_TEXTS.localized_str%TYPE;
802:
803: var_caption_id CZ_UI_NODES.caption_id%TYPE;
804: var_tool_tip_id CZ_UI_NODES.tool_tip_id%TYPE;
805: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
806: var_background_color CZ_UI_NODES.background_color%TYPE;
807: var_font_color CZ_UI_NODES.fontcolor%TYPE;
808: var_name CZ_INTL_TEXTS.text_str%TYPE;
809: var_label CZ_LOCALIZED_TEXTS.localized_str%TYPE;
810: var_use_labels VARCHAR2(1);
803: var_caption_id CZ_UI_NODES.caption_id%TYPE;
804: var_tool_tip_id CZ_UI_NODES.tool_tip_id%TYPE;
805: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
806: var_background_color CZ_UI_NODES.background_color%TYPE;
807: var_font_color CZ_UI_NODES.fontcolor%TYPE;
808: var_name CZ_INTL_TEXTS.text_str%TYPE;
809: var_label CZ_LOCALIZED_TEXTS.localized_str%TYPE;
810: var_use_labels VARCHAR2(1);
811: var_insert_flag BOOLEAN;
931: var_background_color:=DEFAULT_BACKGROUND_COLOR;
932: var_font_color:=DEFAULT_FONT_COLOR;
933: END IF;
934:
935: INSERT INTO CZ_UI_NODES
936: (ui_node_id,
937: parent_id,
938: ui_def_id,
939: ps_node_id,
1624:
1625: PROCEDURE shift_BUTTONS
1626: (in_ui_node_id IN INTEGER) IS
1627:
1628: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1629: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1630: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1631: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1632: var_height CZ_UI_NODES.height%TYPE;
1625: PROCEDURE shift_BUTTONS
1626: (in_ui_node_id IN INTEGER) IS
1627:
1628: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1629: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1630: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1631: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1632: var_height CZ_UI_NODES.height%TYPE;
1633: exist_Latest BOOLEAN:=FALSE;
1626: (in_ui_node_id IN INTEGER) IS
1627:
1628: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1629: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1630: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1631: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1632: var_height CZ_UI_NODES.height%TYPE;
1633: exist_Latest BOOLEAN:=FALSE;
1634: END_OPERATION1 EXCEPTION;
1627:
1628: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1629: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1630: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1631: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1632: var_height CZ_UI_NODES.height%TYPE;
1633: exist_Latest BOOLEAN:=FALSE;
1634: END_OPERATION1 EXCEPTION;
1635: END_OPERATION2 EXCEPTION;
1628: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1629: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1630: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1631: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1632: var_height CZ_UI_NODES.height%TYPE;
1633: exist_Latest BOOLEAN:=FALSE;
1634: END_OPERATION1 EXCEPTION;
1635: END_OPERATION2 EXCEPTION;
1636:
1640: -- if there are no controls on the screen then --
1641: -- max = DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN --
1642: --
1643: SELECT NVL(MAX(rel_top_pos),DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN)
1644: INTO var_top_pos FROM CZ_UI_NODES
1645: WHERE parent_id=in_ui_node_id AND deleted_flag=NO_FLAG;
1646:
1647: --
1648: -- find a height of the UI control with max rel_top_pos --
1647: --
1648: -- find a height of the UI control with max rel_top_pos --
1649: --
1650: SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height
1651: FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
1652: AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
1653:
1654: last_TOP_POS:=var_top_pos+var_height+DEFAULT_SPACE_BETWEEN;
1655: var_left_pos:=LEFT_MARGIN;
1653:
1654: last_TOP_POS:=var_top_pos+var_height+DEFAULT_SPACE_BETWEEN;
1655: var_left_pos:=LEFT_MARGIN;
1656:
1657: FOR i IN (SELECT ui_node_id,width,name FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
1658: AND ui_node_type=UI_BUTTON_TYPE AND name<>CZ_DELETE_BUTTON_CAPTION AND modified_flags=0 AND
1659: deleted_flag=NO_FLAG ORDER BY ui_node_id)
1660: LOOP
1661: var_left_border:=var_left_pos+i.width;
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;
1684:
1685: PROCEDURE shift_Latest_BUTTONS
1686: (in_ui_node_id IN INTEGER) IS
1687:
1688: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1689: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1690: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1691: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1692: var_height CZ_UI_NODES.height%TYPE;
1685: PROCEDURE shift_Latest_BUTTONS
1686: (in_ui_node_id IN INTEGER) IS
1687:
1688: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1689: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1690: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1691: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1692: var_height CZ_UI_NODES.height%TYPE;
1693: exist_Latest BOOLEAN:=FALSE;
1686: (in_ui_node_id IN INTEGER) IS
1687:
1688: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1689: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1690: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1691: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1692: var_height CZ_UI_NODES.height%TYPE;
1693: exist_Latest BOOLEAN:=FALSE;
1694: END_OPERATION1 EXCEPTION;
1687:
1688: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1689: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1690: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1691: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1692: var_height CZ_UI_NODES.height%TYPE;
1693: exist_Latest BOOLEAN:=FALSE;
1694: END_OPERATION1 EXCEPTION;
1695: END_OPERATION2 EXCEPTION;
1688: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1689: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1690: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1691: var_left_border CZ_UI_NODES.rel_left_pos%TYPE;
1692: var_height CZ_UI_NODES.height%TYPE;
1693: exist_Latest BOOLEAN:=FALSE;
1694: END_OPERATION1 EXCEPTION;
1695: END_OPERATION2 EXCEPTION;
1696:
1700: RAISE END_OPERATION2;
1701: END IF;
1702:
1703: SELECT NVL(MAX(rel_top_pos),DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN)
1704: INTO var_top_pos FROM CZ_UI_NODES
1705: WHERE parent_id=in_ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
1706:
1707: SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
1708: WHERE parent_id=in_ui_node_id
1703: SELECT NVL(MAX(rel_top_pos),DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN)
1704: INTO var_top_pos FROM CZ_UI_NODES
1705: WHERE parent_id=in_ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
1706:
1707: SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
1708: WHERE parent_id=in_ui_node_id
1709: AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
1710:
1711: last_TOP_POS:=var_top_pos+var_height+DEFAULT_SPACE_BETWEEN;
1710:
1711: last_TOP_POS:=var_top_pos+var_height+DEFAULT_SPACE_BETWEEN;
1712: var_left_pos:=LEFT_MARGIN;
1713:
1714: FOR i IN (SELECT ui_node_id,width FROM CZ_UI_NODES WHERE parent_id=in_ui_node_id
1715: AND ui_node_type=UI_BUTTON_TYPE AND name<>CZ_DELETE_BUTTON_CAPTION
1716: AND modified_flags=0 AND deleted_flag=NO_FLAG ORDER BY ui_node_id)
1717: LOOP
1718: BEGIN
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:
1837: in_page_number IN VARCHAR2 DEFAULT NULL,
1838: in_width IN INTEGER DEFAULT NULL,
1839: in_ui_node_ref_id IN INTEGER DEFAULT NULL) IS
1840:
1841: var_text_width CZ_UI_NODES.width%TYPE;
1842: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1843: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1844: var_height CZ_UI_NODES.height%TYPE;
1845:
1838: in_width IN INTEGER DEFAULT NULL,
1839: in_ui_node_ref_id IN INTEGER DEFAULT NULL) IS
1840:
1841: var_text_width CZ_UI_NODES.width%TYPE;
1842: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1843: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1844: var_height CZ_UI_NODES.height%TYPE;
1845:
1846: BEGIN
1839: in_ui_node_ref_id IN INTEGER DEFAULT NULL) IS
1840:
1841: var_text_width CZ_UI_NODES.width%TYPE;
1842: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1843: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1844: var_height CZ_UI_NODES.height%TYPE;
1845:
1846: BEGIN
1847: IF in_title=YES_FLAG THEN
1840:
1841: var_text_width CZ_UI_NODES.width%TYPE;
1842: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
1843: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
1844: var_height CZ_UI_NODES.height%TYPE;
1845:
1846: BEGIN
1847: IF in_title=YES_FLAG THEN
1848: var_top_pos:=11;
1915: in_cx_command_name IN VARCHAR2 DEFAULT NULL,
1916: in_rule_id IN NUMBER DEFAULT NULL
1917: ) IS
1918:
1919: var_button_width CZ_UI_NODES.width%TYPE;
1920: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
1921:
1922: BEGIN
1923: IF in_intl_text_id IS NOT NULL THEN
1962:
1963: PROCEDURE create_ADD_BUTTONS
1964: (in_ui_def_id IN INTEGER) IS
1965:
1966: var_parent_id CZ_UI_NODES.parent_id%TYPE;
1967: k INTEGER;
1968:
1969: BEGIN
1970: IF add_buttons.Count>0 THEN
1973: IF k IS NULL THEN
1974: EXIT;
1975: END IF;
1976:
1977: SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
1978: ui_def_id=in_ui_def_id AND ps_node_id=add_buttons(k).ps_parent_id
1979: AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
1980: create_BUTTON(add_buttons(k).id,var_parent_id,in_ui_def_id,
1981: k,'Add '||add_buttons(k).name,
2032: (in_project_id IN INTEGER,
2033: in_ui_def_id IN INTEGER,
2034: in_limbo_id IN INTEGER) IS
2035:
2036: var_button_id CZ_UI_NODES.ui_node_id%TYPE;
2037: var_parent_id CZ_UI_NODES.parent_id%TYPE;
2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2033: in_ui_def_id IN INTEGER,
2034: in_limbo_id IN INTEGER) IS
2035:
2036: var_button_id CZ_UI_NODES.ui_node_id%TYPE;
2037: var_parent_id CZ_UI_NODES.parent_id%TYPE;
2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2034: in_limbo_id IN INTEGER) IS
2035:
2036: var_button_id CZ_UI_NODES.ui_node_id%TYPE;
2037: var_parent_id CZ_UI_NODES.parent_id%TYPE;
2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2043: var_component_id CZ_UI_NODES.ps_node_id%TYPE;
2044: var_button_type INTEGER;
2045: ind INTEGER;
2046: var_suff VARCHAR2(10):='';
2047: BEGIN
2057: --
2058:
2059: FOR i IN (SELECT func_comp_id,component_id,companion_type,name FROM CZ_FUNC_COMP_SPECS a
2060: WHERE devl_project_id=in_project_id AND companion_type IN(1,3,4,5,6,7,9,11,12,13,14,15) AND
2061: NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
2062: ps_node_id=a.component_id AND ui_node_type=UI_BUTTON_TYPE AND func_comp_id=a.func_comp_id
2063: AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG)
2064: LOOP
2065: BEGIN
2070: -- this means that Component( Product,BOM OC/Model ) is not visible in UI
2071: -- in this case we just go to the EXCEPTION part and
2072: -- go to the next iterration of the loop ( buttons are not generated )
2073: --
2074: SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
2075: ui_def_id=in_ui_def_id AND ps_node_id=i.component_id
2076: AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
2077:
2078: --
2181: -- this means that Component( Product,BOM OC/Model ) is not visible in UI
2182: -- in this case we just go to the EXCEPTION part and
2183: -- go to the next iterration of the loop ( buttons are not generated )
2184: --
2185: SELECT ui_node_id INTO var_parent_id FROM CZ_UI_NODES WHERE
2186: ui_def_id=in_ui_def_id AND ps_node_id=var_nearest_comp_id
2187: AND ui_node_type IN(UI_COMPONENT_TYPE,UI_PRODUCT_TYPE) AND deleted_flag=NO_FLAG;
2188:
2189: create_BUTTON(var_button_id,var_parent_id,in_ui_def_id,
2218: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2219: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
2220:
2221: --
2222: -- populate CZ_UI_NODES.model_ref_expl_id associated with References
2223: --
2224: PROCEDURE populate_RefSI(in_ui_def_id IN INTEGER) IS
2225: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;
2221: --
2222: -- populate CZ_UI_NODES.model_ref_expl_id associated with References
2223: --
2224: PROCEDURE populate_RefSI(in_ui_def_id IN INTEGER) IS
2225: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;
2227: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2228: BEGIN
2229: FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
2223: --
2224: PROCEDURE populate_RefSI(in_ui_def_id IN INTEGER) IS
2225: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;
2227: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2228: BEGIN
2229: FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
2230: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
2231: AND ui_node_type=UI_REFERENCE_REF_TYPE)
2225: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;
2227: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2228: BEGIN
2229: FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
2230: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
2231: AND ui_node_type=UI_REFERENCE_REF_TYPE)
2232: LOOP
2233: FOR k IN(SELECT ui_node_id FROM CZ_UI_NODES
2229: FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
2230: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
2231: AND ui_node_type=UI_REFERENCE_REF_TYPE)
2232: LOOP
2233: FOR k IN(SELECT ui_node_id FROM CZ_UI_NODES
2234: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
2235: AND ps_node_id=i.ps_node_id AND ui_node_type=UI_BOM_STANDART_TYPE)
2236: LOOP
2237: var_ui_node_ref_id:=NULL;
2234: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG
2235: AND ps_node_id=i.ps_node_id AND ui_node_type=UI_BOM_STANDART_TYPE)
2236: LOOP
2237: var_ui_node_ref_id:=NULL;
2238: UPDATE CZ_UI_NODES
2239: SET model_ref_expl_id=i.model_ref_expl_id
2240: WHERE ui_def_id=in_ui_def_id AND ui_node_id=k.ui_node_id
2241: RETURNING ui_node_ref_id INTO var_ui_node_ref_id;
2242:
2251: FROM CZ_MODEL_REF_EXPLS a
2252: WHERE model_id=Project_Id AND deleted_flag=NO_FLAG
2253: AND referring_node_id=i.ps_node_id AND ps_node_type=REFERENCE_NODE_TYPE AND rownum<2;
2254:
2255: SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
2256: WHERE ui_def_id=i.ui_def_ref_id AND ui_node_type=UI_SCREEN_TYPE
2257: AND ps_node_id=var_ref_model_id AND deleted_flag=NO_FLAG AND rownum<2;
2258:
2259: UPDATE CZ_UI_NODES
2255: SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
2256: WHERE ui_def_id=i.ui_def_ref_id AND ui_node_type=UI_SCREEN_TYPE
2257: AND ps_node_id=var_ref_model_id AND deleted_flag=NO_FLAG AND rownum<2;
2258:
2259: UPDATE CZ_UI_NODES
2260: SET ui_node_ref_id=var_ref_root_screen
2261: WHERE ui_def_id=in_ui_def_id
2262: AND ui_node_id=k.ui_node_id AND ui_node_ref_id IS NULL;
2263: EXCEPTION
2275: PROCEDURE create_Wizard_Style_Buttons
2276: (in_ui_def_id IN INTEGER,
2277: in_limbo_id IN INTEGER -- DEFAULT -1
2278: ) IS
2279: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2280: var_height CZ_UI_NODES.height%TYPE;
2281: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2282: var_screen_width CZ_UI_NODES.width%TYPE;
2283: var_id CZ_UI_NODES.ui_node_id%TYPE;
2276: (in_ui_def_id IN INTEGER,
2277: in_limbo_id IN INTEGER -- DEFAULT -1
2278: ) IS
2279: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2280: var_height CZ_UI_NODES.height%TYPE;
2281: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2282: var_screen_width CZ_UI_NODES.width%TYPE;
2283: var_id CZ_UI_NODES.ui_node_id%TYPE;
2284: BEGIN
2277: in_limbo_id IN INTEGER -- DEFAULT -1
2278: ) IS
2279: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2280: var_height CZ_UI_NODES.height%TYPE;
2281: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2282: var_screen_width CZ_UI_NODES.width%TYPE;
2283: var_id CZ_UI_NODES.ui_node_id%TYPE;
2284: BEGIN
2285: var_screen_width:=USABLE_WIDTH+RIGHT_MARGIN;
2278: ) IS
2279: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2280: var_height CZ_UI_NODES.height%TYPE;
2281: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2282: var_screen_width CZ_UI_NODES.width%TYPE;
2283: var_id CZ_UI_NODES.ui_node_id%TYPE;
2284: BEGIN
2285: var_screen_width:=USABLE_WIDTH+RIGHT_MARGIN;
2286: IF footer_buttons.Count>0 THEN
2279: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2280: var_height CZ_UI_NODES.height%TYPE;
2281: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2282: var_screen_width CZ_UI_NODES.width%TYPE;
2283: var_id CZ_UI_NODES.ui_node_id%TYPE;
2284: BEGIN
2285: var_screen_width:=USABLE_WIDTH+RIGHT_MARGIN;
2286: IF footer_buttons.Count>0 THEN
2287: var_top_pos:=LEFT_MARGIN;
2319: END IF;
2320: END LOOP;
2321: END IF;
2322:
2323: FOR i IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
2324: AND deleted_flag='0' AND ui_node_type=UI_COMPONENT_TYPE)
2325: LOOP
2326: SELECT NVL(MAX(rel_top_pos),0)
2327: INTO var_top_pos FROM CZ_UI_NODES
2323: FOR i IN(SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
2324: AND deleted_flag='0' AND ui_node_type=UI_COMPONENT_TYPE)
2325: LOOP
2326: SELECT NVL(MAX(rel_top_pos),0)
2327: INTO var_top_pos FROM CZ_UI_NODES
2328: WHERE parent_id=i.ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK
2329: AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG;
2330:
2331: SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
2327: INTO var_top_pos FROM CZ_UI_NODES
2328: WHERE parent_id=i.ui_node_id AND modified_flags<>CZ_NAVIGATION_MARK
2329: AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG;
2330:
2331: SELECT NVL(MAX(height),DEFAULT_SPACE_BETWEEN) INTO var_height FROM CZ_UI_NODES
2332: WHERE parent_id=i.ui_node_id
2333: AND rel_top_pos=var_top_pos AND modified_flags<>CZ_NAVIGATION_MARK AND
2334: parent_id<>in_limbo_id AND deleted_flag=NO_FLAG;
2335:
2338: ELSE
2339: var_top_pos:=var_top_pos+var_height+DEFAULT_SPACE_BETWEEN;
2340: END IF;
2341:
2342: UPDATE CZ_UI_NODES a SET rel_top_pos=var_top_pos
2343: WHERE ui_def_id=in_ui_def_id AND parent_id=i.ui_node_id AND ui_node_type=UI_TEXT_LABEL_TYPE AND
2344: modified_flags=CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
2345:
2346: var_top_pos:=var_top_pos+DEFAULT_DIVIDER_HEIGHT+DEFAULT_SPACE_BETWEEN;
2343: WHERE ui_def_id=in_ui_def_id AND parent_id=i.ui_node_id AND ui_node_type=UI_TEXT_LABEL_TYPE AND
2344: modified_flags=CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
2345:
2346: var_top_pos:=var_top_pos+DEFAULT_DIVIDER_HEIGHT+DEFAULT_SPACE_BETWEEN;
2347: UPDATE CZ_UI_NODES a SET rel_top_pos=var_top_pos
2348: WHERE ui_def_id=in_ui_def_id AND parent_id=i.ui_node_id AND ui_node_type=UI_BUTTON_TYPE AND
2349: modified_flags=CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
2350: END LOOP;
2351:
2359: in_parent_id IN INTEGER,
2360: in_ui_def_id IN INTEGER,
2361: in_arr IN UIStructure) IS
2362:
2363: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
2364: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
2365: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2366: ind INTEGER;
2367:
2360: in_ui_def_id IN INTEGER,
2361: in_arr IN UIStructure) IS
2362:
2363: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
2364: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
2365: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2366: ind INTEGER;
2367:
2368: BEGIN
2361: in_arr IN UIStructure) IS
2362:
2363: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
2364: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
2365: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2366: ind INTEGER;
2367:
2368: BEGIN
2369: last_TOP_POS:=DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN;
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,
2457: in_parent_id IN INTEGER,
2458: in_ui_def_id IN INTEGER,
2459: in_node_ref_id IN INTEGER,
2460: in_arr IN UIStructure) IS
2461: var_ps_id CZ_UI_NODES.ps_node_id%TYPE;
2462: BEGIN
2463: -- IF in_arr.virtual_flag=NO_FLAG THEN
2464: var_ps_id:=in_arr.ps_node_id;
2465: -- ELSE
2534: in_minimum IN INTEGER , -- DEFAULT 1,
2535: in_virtual_flag IN VARCHAR2 , -- DEFAULT '1',
2536: in_t_ref_uis IN IntArray) IS
2537:
2538: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2535: in_virtual_flag IN VARCHAR2 , -- DEFAULT '1',
2536: in_t_ref_uis IN IntArray) IS
2537:
2538: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2536: in_t_ref_uis IN IntArray) IS
2537:
2538: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2537:
2538: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2538: var_ui_node_id CZ_UI_NODES.ui_node_id%TYPE;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2539: var_ui_parent_id CZ_UI_NODES.parent_id%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2540: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2541: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2542: var_width CZ_UI_NODES.width%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2543: var_text_width CZ_UI_NODES.width%TYPE;
2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
2553: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
2554: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
2555: var_align CZ_UI_NODE_PROPS.value_str%TYPE;
2556: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2557: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2558: var_use_labels VARCHAR2(1);
2559: Top_Labeled BOOLEAN:=FALSE;
2560:
2559: Top_Labeled BOOLEAN:=FALSE;
2560:
2561: BEGIN
2562: SELECT ui_node_ref_id INTO var_ui_parent_id
2563: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
2564: AND ui_node_id=in_ui_parent_id;
2565:
2566: SELECT ps_node_id,name,tree_seq,intl_text_id,ps_node_type
2567: INTO var_ps_node_id,var_name,var_tree_seq,var_intl_text_id,var_root_ps_type
2600: var_text_str:=var_name;
2601: var_intl_text_id:=NULL;
2602: END;
2603:
2604: SELECT MAX(rel_top_pos) INTO var_top_pos FROM CZ_UI_NODES
2605: WHERE ui_def_id=in_ui_def_id AND parent_id=var_ui_parent_id
2606: AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
2607:
2608: SELECT NVL(max(height),DEFAULT_SPACE_BETWEEN) INTO var_prev_height FROM CZ_UI_NODES
2604: SELECT MAX(rel_top_pos) INTO var_top_pos FROM CZ_UI_NODES
2605: WHERE ui_def_id=in_ui_def_id AND parent_id=var_ui_parent_id
2606: AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
2607:
2608: SELECT NVL(max(height),DEFAULT_SPACE_BETWEEN) INTO var_prev_height FROM CZ_UI_NODES
2609: WHERE ui_def_id=in_ui_def_id AND parent_id=var_ui_parent_id
2610: AND modified_flags<>CZ_NAVIGATION_MARK AND rel_top_pos=var_top_pos AND deleted_flag=NO_FLAG;
2611:
2612: IF var_top_pos<=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT THEN
2642: var_ui_node_id:=getUISeqVal;
2643:
2644: IF in_t_ref_uis.Count>0 THEN
2645: BEGIN
2646: SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES
2647: WHERE ui_def_id=in_t_ref_uis(in_ref_ps_id) AND ui_node_type=UI_SCREEN_TYPE
2648: AND ps_node_id=in_ref_model_id AND deleted_flag=NO_FLAG AND rownum<2;
2649: EXCEPTION
2650: WHEN OTHERS THEN
2763: in_node_ref_id IN INTEGER,
2764: in_arr IN UIStructure,
2765: out_ref_ui_id OUT NOCOPY INTEGER) IS
2766:
2767: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2764: in_arr IN UIStructure,
2765: out_ref_ui_id OUT NOCOPY INTEGER) IS
2766:
2767: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2765: out_ref_ui_id OUT NOCOPY INTEGER) IS
2766:
2767: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2766:
2767: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2767: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2768: var_button_width CZ_UI_NODES.width%TYPE;
2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%TYPE;
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:
2874: var_ui_tempo:=in_node_ref_id;
2875:
2876: IF MODE_REFRESH THEN
2877:
2878: SELECT NVL(MAX(rel_top_pos),0) INTO var_butt_pos FROM CZ_UI_NODES
2879: WHERE parent_id=in_node_ref_id AND deleted_flag=NO_FLAG;
2880: ERROR_CODE:='00199';
2881:
2882: IF var_butt_pos=0 OR var_butt_pos<=DEFAULT_HEADER_HEIGHT+DEFAULT_DIVIDER_HEIGHT THEN
2908: existsDeleteMe:=NO_FLAG;
2909: ERROR_CODE:='00202';
2910:
2911: SELECT YES_FLAG INTO existsDeleteMe FROM dual
2912: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
2913: WHERE ui_def_id=in_ui_def_id AND ps_node_id=Project_Id AND
2914: name=CZ_DELETE_BUTTON_CAPTION);
2915: ERROR_CODE:='00203';
2916: EXCEPTION
2922:
2923: ERROR_CODE:='00204';
2924:
2925: -- Delete Button --
2926: SELECT ui_node_id,name INTO var_ui_tempo,var_ui_name FROM CZ_UI_NODES
2927: WHERE ui_def_id=in_ui_def_id AND ps_node_id=Project_Id AND
2928: ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
2929: ERROR_CODE:='00205';
2930:
2949: WHERE ui_def_id=out_ref_ui_id AND deleted_flag=NO_FLAG;
2950: ERROR_CODE:='00208';
2951:
2952: SELECT YES_FLAG INTO existsDeleteMe FROM dual
2953: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
2954: WHERE ui_def_id=out_ref_ui_id AND ps_node_id=var_model_Id AND
2955: name=CZ_DELETE_BUTTON_CAPTION);
2956: ERROR_CODE:='00209';
2957:
2964: BEGIN
2965: ERROR_CODE:='00210';
2966:
2967: -- Delete Button --
2968: SELECT ui_node_id,name INTO var_ui_tempo,var_ui_name FROM CZ_UI_NODES
2969: WHERE ui_def_id=out_ref_ui_id AND ps_node_id=var_model_Id AND
2970: ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
2971: ERROR_CODE:='00211';
2972:
3007: in_ui_def_id IN INTEGER,
3008: in_prod_id IN INTEGER,
3009: in_arr IN UIStructure) IS
3010:
3011: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3012: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3013: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
3014: curr_tree_seq CZ_UI_NODES.tree_seq%TYPE;
3015: ind INTEGER;
3008: in_prod_id IN INTEGER,
3009: in_arr IN UIStructure) IS
3010:
3011: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3012: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3013: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
3014: curr_tree_seq CZ_UI_NODES.tree_seq%TYPE;
3015: ind INTEGER;
3016:
3009: in_arr IN UIStructure) IS
3010:
3011: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3012: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3013: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
3014: curr_tree_seq CZ_UI_NODES.tree_seq%TYPE;
3015: ind INTEGER;
3016:
3017: BEGIN
3010:
3011: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3012: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3013: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
3014: curr_tree_seq CZ_UI_NODES.tree_seq%TYPE;
3015: ind INTEGER;
3016:
3017: BEGIN
3018:
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,
3118: in_ui_def_id IN INTEGER,
3119: in_node_ref_id IN INTEGER,
3120: in_arr IN UIStructure) IS
3121:
3122: var_ps_id CZ_UI_NODES.ps_node_id%TYPE;
3123:
3124: BEGIN
3125:
3126: -- IF in_arr.virtual_flag=NO_FLAG THEN
3162: in_parent_id IN INTEGER,
3163: in_ui_def_id IN INTEGER,
3164: in_arr IN UIStructure) IS
3165:
3166: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3167: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3168:
3169: BEGIN
3170:
3163: in_ui_def_id IN INTEGER,
3164: in_arr IN UIStructure) IS
3165:
3166: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3167: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3168:
3169: BEGIN
3170:
3171: ERROR_CODE:='00300';
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);
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);
3238:
3239: ERROR_CODE:='00305';
3254: in_ui_def_id IN INTEGER,
3255: in_node_ref_id IN INTEGER,
3256: in_arr IN UIStructure) IS
3257:
3258: curr_tree_seq CZ_UI_NODES.tree_seq%TYPE;
3259:
3260: BEGIN
3261:
3262: set_UI_NODES(in_ui_node_id =>in_node_id,
3292: in_parent_id IN INTEGER,
3293: in_ui_def_id IN INTEGER,
3294: in_arr IN UIStructure) IS
3295:
3296: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3297: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3298: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
3299:
3300: BEGIN
3293: in_ui_def_id IN INTEGER,
3294: in_arr IN UIStructure) IS
3295:
3296: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3297: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3298: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
3299:
3300: BEGIN
3301:
3294: in_arr IN UIStructure) IS
3295:
3296: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3297: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3298: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
3299:
3300: BEGIN
3301:
3302: ERROR_CODE:='00310';
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);
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);
3383:
3384: ERROR_CODE:='00315';
3496: in_tree_seq IN INTEGER,
3497: in_page_name IN VARCHAR2,
3498: in_ui_def_id IN INTEGER,
3499: in_counter IN INTEGER) RETURN INTEGER IS
3500: var_tree_node_id CZ_UI_NODES.ui_node_id%TYPE;
3501: var_screen_node_id CZ_UI_NODES.ui_node_id%TYPE:=-1;
3502: var_curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3503: var_curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3504: var_page_number VARCHAR2(50);
3497: in_page_name IN VARCHAR2,
3498: in_ui_def_id IN INTEGER,
3499: in_counter IN INTEGER) RETURN INTEGER IS
3500: var_tree_node_id CZ_UI_NODES.ui_node_id%TYPE;
3501: var_screen_node_id CZ_UI_NODES.ui_node_id%TYPE:=-1;
3502: var_curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3503: var_curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3504: var_page_number VARCHAR2(50);
3505: BEGIN
3498: in_ui_def_id IN INTEGER,
3499: in_counter IN INTEGER) RETURN INTEGER IS
3500: var_tree_node_id CZ_UI_NODES.ui_node_id%TYPE;
3501: var_screen_node_id CZ_UI_NODES.ui_node_id%TYPE:=-1;
3502: var_curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3503: var_curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3504: var_page_number VARCHAR2(50);
3505: BEGIN
3506: --
3499: in_counter IN INTEGER) RETURN INTEGER IS
3500: var_tree_node_id CZ_UI_NODES.ui_node_id%TYPE;
3501: var_screen_node_id CZ_UI_NODES.ui_node_id%TYPE:=-1;
3502: var_curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3503: var_curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
3504: var_page_number VARCHAR2(50);
3505: BEGIN
3506: --
3507: -- set suffix for the page name --
3593: in_screen_height IN INTEGER , -- DEFAULT 480,
3594: in_show_all_nodes IN VARCHAR2 -- DEFAULT '0'
3595: ) IS
3596:
3597: nIface1 CZ_UI_NODES.ui_node_id%TYPE;
3598: BEGIN
3599: IF MUID IS NOT NULL THEN
3600: nIface1:=currUISeqVal;
3601: set_UI_NODES(in_ui_node_id =>nIface1,
3677: PROCEDURE create_Footprints
3678: (in_ui_def_id IN INTEGER,
3679: in_interface_id IN INTEGER) IS
3680:
3681: var_ui_node CZ_UI_NODES.ui_node_id%TYPE;
3682:
3683: BEGIN
3684: --
3685: -- create Recycle Bin --
3752: in_new_parent_id IN INTEGER,
3753: in_ui_def_id IN INTEGER,
3754: out_counter OUT NOCOPY INTEGER) IS
3755:
3756: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
3757: var_counter INTEGER:=0;
3758: i INTEGER;
3759:
3760: BEGIN
3784: in_parent_id IN INTEGER,
3785: in_ui_def_id IN INTEGER,
3786: in_arr IN featureStructure) IS
3787:
3788: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3785: in_ui_def_id IN INTEGER,
3786: in_arr IN featureStructure) IS
3787:
3788: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3786: in_arr IN featureStructure) IS
3787:
3788: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3787:
3788: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3788: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3789: var_width CZ_UI_NODES.width%TYPE;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3790: var_height CZ_UI_NODES.height%TYPE;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3798: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3791: var_control_type CZ_UI_NODES.controltype%TYPE;
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3798: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3799: var_align VARCHAR2(10);
3792: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3798: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3799: var_align VARCHAR2(10);
3800: Top_Labeled BOOLEAN:=FALSE;
3793: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3798: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3799: var_align VARCHAR2(10);
3800: Top_Labeled BOOLEAN:=FALSE;
3801:
3794: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3795: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3796: var_text_width CZ_UI_NODES.width%TYPE;
3797: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3798: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3799: var_align VARCHAR2(10);
3800: Top_Labeled BOOLEAN:=FALSE;
3801:
3802: BEGIN
3967: in_parent_id IN INTEGER,
3968: in_ui_def_id IN INTEGER,
3969: in_arr IN featureStructure) IS
3970:
3971: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3968: in_ui_def_id IN INTEGER,
3969: in_arr IN featureStructure) IS
3970:
3971: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3969: in_arr IN featureStructure) IS
3970:
3971: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3970:
3971: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3971: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3979: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3972: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3979: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3980: var_align VARCHAR2(10):='right';
3973: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3979: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3980: var_align VARCHAR2(10):='right';
3981: Top_Labeled BOOLEAN:=FALSE;
3974: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3979: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3980: var_align VARCHAR2(10):='right';
3981: Top_Labeled BOOLEAN:=FALSE;
3982:
3975: var_text_width CZ_UI_NODES.width%TYPE;
3976: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
3977: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
3978: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
3979: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
3980: var_align VARCHAR2(10):='right';
3981: Top_Labeled BOOLEAN:=FALSE;
3982:
3983: BEGIN
4067: in_parent_id IN INTEGER,
4068: in_ui_def_id IN INTEGER,
4069: in_arr IN featureStructure) IS
4070:
4071: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4068: in_ui_def_id IN INTEGER,
4069: in_arr IN featureStructure) IS
4070:
4071: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4069: in_arr IN featureStructure) IS
4070:
4071: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4070:
4071: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4071: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4079: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4072: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4079: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4080: var_align VARCHAR2(10):='right';
4073: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4079: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4080: var_align VARCHAR2(10):='right';
4081: Top_Labeled BOOLEAN:=FALSE;
4074: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4079: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4080: var_align VARCHAR2(10):='right';
4081: Top_Labeled BOOLEAN:=FALSE;
4082:
4075: var_text_width CZ_UI_NODES.width%TYPE;
4076: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4077: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4078: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4079: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4080: var_align VARCHAR2(10):='right';
4081: Top_Labeled BOOLEAN:=FALSE;
4082:
4083: BEGIN
4169: in_parent_id IN INTEGER,
4170: in_ui_def_id IN INTEGER,
4171: in_arr IN featureStructure) IS
4172:
4173: var_curr_label_id CZ_UI_NODES.caption_id%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4170: in_ui_def_id IN INTEGER,
4171: in_arr IN featureStructure) IS
4172:
4173: var_curr_label_id CZ_UI_NODES.caption_id%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4171: in_arr IN featureStructure) IS
4172:
4173: var_curr_label_id CZ_UI_NODES.caption_id%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4172:
4173: var_curr_label_id CZ_UI_NODES.caption_id%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4173: var_curr_label_id CZ_UI_NODES.caption_id%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4174: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4175: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4176: var_left_pos_txt CZ_UI_NODES.rel_left_pos%TYPE;
4177: var_label_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4178: var_label_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4179: var_txt_id CZ_UI_NODES.caption_id%TYPE;
4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;
4186: var_text_width CZ_UI_NODES.width%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;
4186: var_text_width CZ_UI_NODES.width%TYPE;
4187: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4188: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4189: var_align VARCHAR2(10):='right';
4190: Top_Labeled BOOLEAN:=FALSE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;
4186: var_text_width CZ_UI_NODES.width%TYPE;
4187: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4188: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4189: var_align VARCHAR2(10):='right';
4190: Top_Labeled BOOLEAN:=FALSE;
4191:
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;
4186: var_text_width CZ_UI_NODES.width%TYPE;
4187: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4188: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4189: var_align VARCHAR2(10):='right';
4190: Top_Labeled BOOLEAN:=FALSE;
4191:
4192: NO_MODEL_REF_EXPL_ID EXCEPTION;
4315: in_new_parent_id IN INTEGER,
4316: in_ui_def_id IN INTEGER) IS
4317:
4318: temp featureArray;
4319: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4320: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4321: var_name CZ_UI_NODES.name%TYPE;
4322: options_number INTEGER;
4323: ind INTEGER;
4316: in_ui_def_id IN INTEGER) IS
4317:
4318: temp featureArray;
4319: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4320: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4321: var_name CZ_UI_NODES.name%TYPE;
4322: options_number INTEGER;
4323: ind INTEGER;
4324: i INTEGER;
4317:
4318: temp featureArray;
4319: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4320: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
4321: var_name CZ_UI_NODES.name%TYPE;
4322: options_number INTEGER;
4323: ind INTEGER;
4324: i INTEGER;
4325: END_OPERATION EXCEPTION;
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:
4448:
4449: opt_bom UIArray;
4450: temp_bom UIArray;
4451:
4452: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4449: opt_bom UIArray;
4450: temp_bom UIArray;
4451:
4452: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4450: temp_bom UIArray;
4451:
4452: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4451:
4452: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4452: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4453: var_component_id CZ_UI_NODES.component_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4454: var_width CZ_UI_NODES.width%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4455: var_height CZ_UI_NODES.height%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4456: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4464: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4457: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4464: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4465:
4458: var_new_parent_id CZ_UI_NODES.parent_id%TYPE;
4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4464: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4465:
4466: var_type INTEGER;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4464: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4465:
4466: var_type INTEGER;
4467: var_temp INTEGER;
4468: ind INTEGER;
4569: --
4570: IF page_counter=1 THEN
4571: BEGIN
4572: SELECT caption_id,modified_flags
4573: INTO var_temp,var_modified_flag FROM CZ_UI_NODES
4574: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_new_parent_id
4575: AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag='0';
4576:
4577: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4578: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4579:
4580: SELECT caption_id,ui_node_ref_id,modified_flags
4581: INTO var_temp,var_ui_node_ref_id,var_modified_flag
4582: FROM CZ_UI_NODES
4583: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_new_parent_id
4584: AND deleted_flag='0';
4585:
4586: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4586: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4587: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4588:
4589: SELECT caption_id,modified_flags
4590: INTO var_temp,var_modified_flag FROM CZ_UI_NODES
4591: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
4592: AND deleted_flag='0';
4593:
4594: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4625:
4626: curr_node_id :=getUISeqVal;
4627:
4628: BEGIN
4629: SELECT ui_node_id INTO var_screen_oc_id FROM CZ_UI_NODES
4630: 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
4631: AND rownum<2 AND deleted_flag=NO_FLAG;
4632: EXCEPTION
4633: WHEN OTHERS THEN
4737:
4738: IF page_counter=1 THEN
4739: BEGIN
4740: SELECT caption_id,modified_flags
4741: INTO var_temp,var_modified_flag FROM CZ_UI_NODES
4742: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_new_parent_id
4743: AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag='0';
4744:
4745: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||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;
4754: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
4755: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4756:
4757: SELECT caption_id,modified_flags
4758: INTO var_temp,var_modified_flag FROM CZ_UI_NODES
4759: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
4760: AND deleted_flag='0';
4761:
4762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
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
4884: ind INTEGER;
4885: ind_arr INTEGER;
4886: k INTEGER;
4887:
4888: var_name CZ_UI_NODES.name%TYPE;
4889: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
4890:
4891: BEGIN
4892:
5284: ERROR_CODE:='0035';
5285: --
5286: -- shift all ADD and EXECUTE buttons to the bottom of the screen --
5287: --
5288: FOR i IN (SELECT ui_node_ref_id FROM CZ_UI_NODES
5289: WHERE ui_def_id=new_ui_def_id AND
5290: ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE) AND
5291: deleted_flag=NO_FLAG)
5292: LOOP
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:
5368: var_name VARCHAR2(255);
5369: var_use_def_font VARCHAR2(1):=YES_FLAG;
5370: var_use_def_pic VARCHAR2(1):=YES_FLAG;
5371: var_use_def_color VARCHAR2(1):=YES_FLAG;
5372: var_font_name CZ_UI_NODES.fontname%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5369: var_use_def_font VARCHAR2(1):=YES_FLAG;
5370: var_use_def_pic VARCHAR2(1):=YES_FLAG;
5371: var_use_def_color VARCHAR2(1):=YES_FLAG;
5372: var_font_name CZ_UI_NODES.fontname%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5370: var_use_def_pic VARCHAR2(1):=YES_FLAG;
5371: var_use_def_color VARCHAR2(1):=YES_FLAG;
5372: var_font_name CZ_UI_NODES.fontname%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5371: var_use_def_color VARCHAR2(1):=YES_FLAG;
5372: var_font_name CZ_UI_NODES.fontname%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5372: var_font_name CZ_UI_NODES.fontname%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5380: var_picname CZ_UI_NODES.picturename%type;
5373: var_font_bold CZ_UI_NODES.fontbold%type;
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5380: var_picname CZ_UI_NODES.picturename%type;
5381:
5374: var_font_color CZ_UI_NODES.fontcolor%type;
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5380: var_picname CZ_UI_NODES.picturename%type;
5381:
5382: BEGIN
5375: var_font_italic CZ_UI_NODES.fontitalic%type;
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5380: var_picname CZ_UI_NODES.picturename%type;
5381:
5382: BEGIN
5383:
5376: var_font_size CZ_UI_NODES.fontsize%type;
5377: var_font_underline CZ_UI_NODES.fontunderline%type;
5378: var_bkgrnd_style CZ_UI_NODES.backgroundstyle%type;
5379: var_borders CZ_UI_NODES.borders%type;
5380: var_picname CZ_UI_NODES.picturename%type;
5381:
5382: BEGIN
5383:
5384: IF in_ui_type=DEF_BUTTON THEN
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
5537: PROCEDURE create_OptionsGrid
5538: (in_parent_id IN INTEGER,
5539: in_ui_def_id IN INTEGER) IS
5540:
5541: Grid_Id CZ_UI_NODES.ui_node_id%TYPE;
5542: Column_Id CZ_UI_NODES.ui_node_id%TYPE;
5543:
5544: BEGIN
5545: Grid_Id:=getUISeqVal;
5538: (in_parent_id IN INTEGER,
5539: in_ui_def_id IN INTEGER) IS
5540:
5541: Grid_Id CZ_UI_NODES.ui_node_id%TYPE;
5542: Column_Id CZ_UI_NODES.ui_node_id%TYPE;
5543:
5544: BEGIN
5545: Grid_Id:=getUISeqVal;
5546: create_UI_element(in_ui_type =>DEF_GRID,
5632: PROCEDURE create_SelectionsGrid
5633: (in_parent_id IN INTEGER,
5634: in_ui_def_id IN INTEGER) IS
5635:
5636: Grid_Id CZ_UI_NODES.ui_node_id%TYPE;
5637: Column_Id CZ_UI_NODES.ui_node_id%TYPE;
5638:
5639: BEGIN
5640:
5633: (in_parent_id IN INTEGER,
5634: in_ui_def_id IN INTEGER) IS
5635:
5636: Grid_Id CZ_UI_NODES.ui_node_id%TYPE;
5637: Column_Id CZ_UI_NODES.ui_node_id%TYPE;
5638:
5639: BEGIN
5640:
5641: Grid_Id:=getUISeqVal;
5753: in_show_all_nodes IN VARCHAR2, -- DEFAULT '0',
5754: in_use_labels IN VARCHAR2 -- DEFAULT '1'
5755: ) IS
5756:
5757: new_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5754: in_use_labels IN VARCHAR2 -- DEFAULT '1'
5755: ) IS
5756:
5757: new_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5755: ) IS
5756:
5757: new_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5756:
5757: new_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5757: new_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5758: new_parent CZ_UI_NODES.parent_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5759: new_child CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5760: var_ref_ui CZ_UI_NODES.ui_def_ref_id%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5761: new_ui_def_id CZ_UI_NODES.ui_def_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5762: new_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5763: curr_node_id CZ_UI_NODES.ui_node_id%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5764: curr_label_id CZ_UI_NODES.ui_node_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5765: curr_bitmap_id CZ_UI_NODES.ui_node_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5766: curr_button_id CZ_UI_NODES.ui_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5767: var_comp_tree_id CZ_UI_NODES.ui_node_id%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5775: var_name CZ_UI_NODES.name%TYPE;
5768: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5775: var_name CZ_UI_NODES.name%TYPE;
5776: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
5769: var_ui_root_id CZ_UI_NODES.ui_node_id%TYPE;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5775: var_name CZ_UI_NODES.name%TYPE;
5776: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
5777: ind INTEGER;
5770: default_PROD_TOP CZ_UI_NODES.rel_top_pos%TYPE;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5775: var_name CZ_UI_NODES.name%TYPE;
5776: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
5777: ind INTEGER;
5778: k INTEGER;
5771: default_PROD_LEFT CZ_UI_NODES.rel_left_pos%TYPE;
5772: var_component_id CZ_UI_NODES.component_id%TYPE;
5773: var_parent_id CZ_UI_NODES.parent_id%TYPE;
5774: temp_node CZ_UI_NODES.ps_node_id%TYPE;
5775: var_name CZ_UI_NODES.name%TYPE;
5776: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
5777: ind INTEGER;
5778: k INTEGER;
5779:
6010: ui_product_id INTEGER;
6011:
6012: var_ui_visible CZ_PS_NODES.ui_omit%TYPE;
6013:
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6011:
6012: var_ui_visible CZ_PS_NODES.ui_omit%TYPE;
6013:
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6012: var_ui_visible CZ_PS_NODES.ui_omit%TYPE;
6013:
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6013:
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6017: FrameSet4_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6018: FrameSet5_Id CZ_UI_NODES.ui_node_id%TYPE;
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6019:
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6020: Frame1_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6021: Frame2_Id CZ_UI_NODES.ui_node_id%TYPE;
6022: Frame3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6023: Frame4_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6024: Frame5_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6025: Frame6_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6026:
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6027: Panel1_Id CZ_UI_NODES.ui_node_id%TYPE;
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6028: Panel2_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6029: Panel3_Id CZ_UI_NODES.ui_node_id%TYPE;
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6037:
6030: Panel4_Id CZ_UI_NODES.ui_node_id%TYPE;
6031: Panel5_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6037:
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6032: Panel51_Id CZ_UI_NODES.ui_node_id%TYPE;
6033: Panel52_Id CZ_UI_NODES.ui_node_id%TYPE;
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6037:
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6039: TextControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6040:
6034: Panel53_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6037:
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6039: TextControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6040:
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6035:
6036: FindControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6037:
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6039: TextControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6040:
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6037:
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6039: TextControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6040:
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6044: DataSet_Id CZ_UI_NODES.ui_node_id%TYPE;
6045: ModelTree_Id CZ_UI_NODES.ui_node_id%TYPE;
6038: Text_Id CZ_UI_NODES.ui_node_id%TYPE;
6039: TextControl_Id CZ_UI_NODES.ui_node_id%TYPE;
6040:
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6044: DataSet_Id CZ_UI_NODES.ui_node_id%TYPE;
6045: ModelTree_Id CZ_UI_NODES.ui_node_id%TYPE;
6046: temp_node CZ_UI_NODES.ui_node_id%TYPE;
6040:
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6044: DataSet_Id CZ_UI_NODES.ui_node_id%TYPE;
6045: ModelTree_Id CZ_UI_NODES.ui_node_id%TYPE;
6046: temp_node CZ_UI_NODES.ui_node_id%TYPE;
6047:
6048: BEGIN
6041: Button_Id CZ_UI_NODES.ui_node_id%TYPE;
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6044: DataSet_Id CZ_UI_NODES.ui_node_id%TYPE;
6045: ModelTree_Id CZ_UI_NODES.ui_node_id%TYPE;
6046: temp_node CZ_UI_NODES.ui_node_id%TYPE;
6047:
6048: BEGIN
6049:
6042: TaggedValue_Id CZ_UI_NODES.ui_node_id%TYPE;
6043:
6044: DataSet_Id CZ_UI_NODES.ui_node_id%TYPE;
6045: ModelTree_Id CZ_UI_NODES.ui_node_id%TYPE;
6046: temp_node CZ_UI_NODES.ui_node_id%TYPE;
6047:
6048: BEGIN
6049:
6050: Initialize;
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:
6649: generate_BOM_UI(in_product_id,out_ui_def_id,in_width,in_height,
6650: in_show_all_nodes,in_use_labels);
6651: END IF;
6652:
6653: FOR i IN (SELECT ui_node_id,component_id,ui_def_ref_id,ps_node_id FROM CZ_UI_NODES
6654: WHERE ui_def_id=out_ui_def_id AND ui_def_ref_id IS NOT NULL
6655: AND ui_node_type=UI_REFERENCE_REF_TYPE
6656: AND deleted_flag='0' )
6657: LOOP
6670:
6671: BEGIN
6672: SELECT value_str INTO var_wizard_style FROM CZ_UI_NODE_PROPS
6673: WHERE ui_def_id=var_ui_def_id AND ui_node_id=
6674: (SELECT ui_node_id FROM CZ_UI_NODES WHERE ui_def_id=var_ui_def_id AND
6675: ui_node_id=parent_id AND deleted_flag=NO_FLAG) AND key_str='WizardStyle' AND
6676: deleted_flag=NO_FLAG;
6677: EXCEPTION
6678: WHEN NO_DATA_FOUND THEN
6692: END IF;
6693:
6694: IF in_ui_style=DHTML_STYLE_UI THEN
6695: BEGIN
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
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;
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
6713: IF in_ui_style=DHTML_STYLE_UI THEN
6714: BEGIN
6715: existsDeleteMe:=NO_FLAG;
6716: SELECT YES_FLAG INTO existsDeleteMe FROM dual
6717: WHERE EXISTS(SELECT 1 FROM CZ_UI_NODES
6718: WHERE ui_def_id=var_ui_def_id AND ps_node_id=var_reference_id
6719: AND ui_node_type=UI_BUTTON_TYPE AND name=CZ_DELETE_BUTTON_CAPTION);
6720: EXCEPTION
6721: WHEN NO_DATA_FOUND THEN
6725: SELECT virtual_flag INTO var_virt_flag FROM CZ_PS_NODES
6726: WHERE ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
6727:
6728: IF existsDeleteMe=NO_FLAG AND var_virt_flag=NO_FLAG THEN
6729: SELECT ui_node_id INTO var_ui_root_id FROM CZ_UI_NODES
6730: WHERE ui_def_id=var_ui_def_id AND ps_node_id=var_reference_id AND
6731: ui_node_type<>UI_COMPONENT_REF_TYPE AND ui_node_ref_id IS NOT NULL;
6732:
6733: curr_button_id:=getUISeqVal;
6857: movedOptions DragDropArray;
6858:
6859: BEGIN
6860:
6861: SELECT ui_node_id INTO var_limbo_id FROM CZ_UI_NODES
6862: WHERE ui_def_id=in_ui_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
6863:
6864: FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,tree_seq FROM CZ_PS_NODES
6865: WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)
6866: LOOP
6867: var_choose_conn:=NULL;
6868: IF i.ps_node_type=REFERENCE_NODE_TYPE THEN
6869: BEGIN
6870: 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
6871: AND ps_node_id=i.ps_node_id AND ui_node_type=UI_REFERENCE_REF_TYPE AND deleted_flag=NO_FLAG;
6872:
6873: SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6874: AND ui_node_id=var_ui_id;
6869: BEGIN
6870: 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
6871: AND ps_node_id=i.ps_node_id AND ui_node_type=UI_REFERENCE_REF_TYPE AND deleted_flag=NO_FLAG;
6872:
6873: SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6874: AND ui_node_id=var_ui_id;
6875:
6876: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6877: AND ui_node_id=var_ref_id;
6872:
6873: SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6874: AND ui_node_id=var_ui_id;
6875:
6876: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6877: AND ui_node_id=var_ref_id;
6878:
6879: IF var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL THEN
6880: SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
6876: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6877: AND ui_node_id=var_ref_id;
6878:
6879: IF var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL THEN
6880: SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
6881: 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
6882: (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
6883:
6884: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6880: SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
6881: 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
6882: (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
6883:
6884: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6885: WHERE ui_node_ref_id=var_id AND parent_id<>var_limbo_id AND ui_node_type=UI_COMPONENT_REF_TYPE AND
6886: ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6887:
6888: movedReferences(var_curr_ui_id).new_parent_id:=new_parent_id;
6902:
6903: BEGIN
6904: SELECT ui_node_id,tree_seq
6905: INTO var_ui_id,var_old_tree_seq
6906: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6907: AND parent_id<>var_limbo_id AND ps_node_id=i.ps_node_id
6908: AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE)
6909: AND deleted_flag=NO_FLAG;
6910:
6907: AND parent_id<>var_limbo_id AND ps_node_id=i.ps_node_id
6908: AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE)
6909: AND deleted_flag=NO_FLAG;
6910:
6911: SELECT ui_node_id,parent_id INTO var_curr_ui_id,var_parent_id FROM CZ_UI_NODES
6912: 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
6913: ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6914:
6915: BEGIN
6912: 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
6913: ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6914:
6915: BEGIN
6916: SELECT ui_node_type INTO var_ui_type FROM CZ_UI_NODES WHERE
6917: ui_node_id=var_parent_id AND ui_def_id=in_ui_def_id;
6918: EXCEPTION
6919: WHEN NO_DATA_FOUND THEN
6920: NULL;
6922: NULL;
6923: END;
6924:
6925: IF var_ui_type<>143 THEN
6926: SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
6927: ui_node_id=var_parent_id;
6928: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
6929: ui_node_id=var_ref_id;
6930:
6924:
6925: IF var_ui_type<>143 THEN
6926: SELECT ui_node_ref_id INTO var_ref_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
6927: ui_node_id=var_parent_id;
6928: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
6929: ui_node_id=var_ref_id;
6930:
6931: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
6932: --OR (var_old_tree_seq<>i.tree_seq*mMAX_NUMBER_PAGES AND var_old_tree_seq<>i.tree_seq) THEN --
6930:
6931: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
6932: --OR (var_old_tree_seq<>i.tree_seq*mMAX_NUMBER_PAGES AND var_old_tree_seq<>i.tree_seq) THEN --
6933:
6934: SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
6935: 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
6936: (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
6937:
6938: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6934: SELECT ui_node_id INTO var_id FROM CZ_UI_NODES
6935: 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
6936: (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE) AND deleted_flag=NO_FLAG;
6937:
6938: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6939: WHERE ui_node_ref_id=var_id AND parent_id<>var_limbo_id AND ui_node_type=UI_COMPONENT_REF_TYPE AND
6940: ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6941:
6942: movedComponents(var_curr_ui_id).new_parent_id:=new_parent_id;
6958: IF i.ps_node_type IN (FEATURE_NODE_TYPE,RESOURCE_NODE_TYPE,TOTAL_NODE_TYPE,CONNECTOR_NODE_TYPE) THEN
6959:
6960: BEGIN
6961: SELECT ui_node_id,parent_id,ui_node_ref_id,tree_seq
6962: INTO var_curr_ui_id,var_ui_id,var_ui_ref_id,var_old_tree_seq FROM CZ_UI_NODES
6963: WHERE ui_def_id=in_ui_def_id
6964: AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND ui_node_type IN
6965: (UI_FEATURE_TYPE,UI_OPTION_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_CONNECTOR_TYPE)
6966: AND deleted_flag=NO_FLAG;
6967:
6968: IF i.ps_node_type=CONNECTOR_NODE_TYPE THEN
6969: BEGIN
6970: SELECT ui_node_id INTO var_choose_conn
6971: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
6972: AND parent_id<>var_limbo_id AND
6973: ui_node_ref_id=var_curr_ui_id AND deleted_flag=NO_FLAG;
6974: EXCEPTION
6975: WHEN OTHERS THEN
6976: NULL;
6977: END;
6978: END IF;
6979:
6980: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
6981: WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6982:
6983: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
6984: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6980: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
6981: WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
6982:
6983: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
6984: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
6985: 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
6986: (UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG;
6987:
6988: movedFeatures(var_curr_ui_id).new_parent_id:=new_parent_id;
7005:
7006: IF i.ps_node_type IN(OPTION_NODE_TYPE) THEN
7007: BEGIN
7008: SELECT ui_node_id,parent_id,tree_seq
7009: INTO var_curr_ui_id,var_ui_id,var_old_tree_seq FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
7010: AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND
7011: ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG;
7012:
7013: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
7009: INTO var_curr_ui_id,var_ui_id,var_old_tree_seq FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
7010: AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND
7011: ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG;
7012:
7013: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
7014: WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
7015:
7016: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
7017: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
7013: SELECT ps_node_id INTO var_ps_id FROM CZ_UI_NODES
7014: WHERE ui_node_id=var_ui_id AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
7015:
7016: IF (var_ps_id<>i.parent_id AND var_ps_id IS NOT NULL) THEN
7017: SELECT ui_node_id INTO new_parent_id FROM CZ_UI_NODES
7018: 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
7019: (UI_FEATURE_TYPE) AND deleted_flag=NO_FLAG;
7020:
7021: movedOptions(var_curr_ui_id).new_parent_id:=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:
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:
7043: SELECT ui_node_ref_id INTO var_id FROM CZ_UI_NODES
7044: WHERE ui_def_id=in_ui_def_id AND ui_node_id=movedReferences(ind).new_parent_id AND
7045: parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7046:
7047: var_top_pos:=getNextY(in_ui_def_id,var_id);
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:
7060:
7061: IF movedComponents.Count>0 THEN
7062: ind:=movedComponents.First;
7063: LOOP
7064: UPDATE CZ_UI_NODES
7065: SET parent_id=movedComponents(ind).new_parent_id,
7066: tree_seq=movedComponents(ind).tree_seq
7067: WHERE ui_def_id=in_ui_def_id
7068: AND ui_node_id=ind AND ui_node_type=UI_COMPONENT_REF_TYPE AND
7067: WHERE ui_def_id=in_ui_def_id
7068: AND ui_node_id=ind AND ui_node_type=UI_COMPONENT_REF_TYPE AND
7069: deleted_flag=NO_FLAG;
7070: BEGIN
7071: SELECT ui_node_ref_id INTO var_id FROM CZ_UI_NODES
7072: WHERE ui_def_id=in_ui_def_id AND ui_node_id=movedComponents(ind).new_parent_id AND
7073: parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
7074:
7075: EXCEPTION
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:
7098: LOOP
7099:
7100: var_top_pos:=getNextY(in_ui_def_id,movedFeatures(ind).new_parent_id);
7101:
7102: UPDATE CZ_UI_NODES
7103: SET parent_id=movedFeatures(ind).new_parent_id,
7104: rel_top_pos=var_top_pos,
7105: tree_seq=movedFeatures(ind).tree_seq
7106: WHERE ui_def_id=in_ui_def_id
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:
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:
7115: IF movedFeatures(ind).button_id IS NOT NULL THEN
7116: UPDATE CZ_UI_NODES
7117: SET parent_id=movedFeatures(ind).new_parent_id,
7118: rel_top_pos=var_top_pos
7119: WHERE ui_def_id=in_ui_def_id
7120: AND ui_node_id=movedFeatures(ind).button_id AND ui_node_type=UI_BUTTON_TYPE AND
7130:
7131: IF movedOptions.Count>0 THEN
7132: ind:=movedOptions.First;
7133: LOOP
7134: UPDATE CZ_UI_NODES
7135: SET parent_id=movedOptions(ind).new_parent_id,
7136: tree_seq=movedOptions(ind).tree_seq
7137: WHERE ui_def_id=in_ui_def_id
7138: AND ui_node_id=ind AND ui_node_type=UI_OPTION_TYPE AND
7168: in_project_id IN INTEGER,
7169: in_replace_flag IN VARCHAR2 -- DEFAULT NO_FLAG
7170: ) IS
7171:
7172: TYPE Map_Table IS TABLE OF CZ_UI_NODES.NAME%TYPE INDEX BY VARCHAR2(15);
7173: Map Map_Table;
7174: new_ui_def_id INTEGER;
7175: var_id INTEGER;
7176: var_ui_type INTEGER;
7185: new_ui_node_id INTEGER;
7186: new_caption_id INTEGER;
7187: var_old_limbo_id INTEGER;
7188: var_new_limbo_id INTEGER;
7189: var_old_id CZ_UI_NODES%ROWTYPE;
7190: var_new_id CZ_UI_NODES%ROWTYPE;
7191: var_header CZ_UI_NODES%ROWTYPE;
7192: var_ui_name CZ_UI_DEFS.name%TYPE;
7193: var_name CZ_UI_NODES.name%TYPE;
7186: new_caption_id INTEGER;
7187: var_old_limbo_id INTEGER;
7188: var_new_limbo_id INTEGER;
7189: var_old_id CZ_UI_NODES%ROWTYPE;
7190: var_new_id CZ_UI_NODES%ROWTYPE;
7191: var_header CZ_UI_NODES%ROWTYPE;
7192: var_ui_name CZ_UI_DEFS.name%TYPE;
7193: var_name CZ_UI_NODES.name%TYPE;
7194: END_OPERATION EXCEPTION;
7187: var_old_limbo_id INTEGER;
7188: var_new_limbo_id INTEGER;
7189: var_old_id CZ_UI_NODES%ROWTYPE;
7190: var_new_id CZ_UI_NODES%ROWTYPE;
7191: var_header CZ_UI_NODES%ROWTYPE;
7192: var_ui_name CZ_UI_DEFS.name%TYPE;
7193: var_name CZ_UI_NODES.name%TYPE;
7194: END_OPERATION EXCEPTION;
7195:
7189: var_old_id CZ_UI_NODES%ROWTYPE;
7190: var_new_id CZ_UI_NODES%ROWTYPE;
7191: var_header CZ_UI_NODES%ROWTYPE;
7192: var_ui_name CZ_UI_DEFS.name%TYPE;
7193: var_name CZ_UI_NODES.name%TYPE;
7194: END_OPERATION EXCEPTION;
7195:
7196: BEGIN
7197: IF in_replace_flag=YES_FLAG THEN
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
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;
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;
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;
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;
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;
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;
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;
7216: UPDATE CZ_UI_NODES
7217: SET FONTBOLD=var_header.FONTBOLD,
7218: FONTCOLOR=var_header.FONTCOLOR,
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;
7216: UPDATE CZ_UI_NODES
7217: SET FONTBOLD=var_header.FONTBOLD,
7218: FONTCOLOR=var_header.FONTCOLOR,
7219: FONTITALIC=var_header.FONTITALIC,
7220: FONTUNDERLINE=var_header.FONTUNDERLINE,
7227: DEFAULT_FONT_FLAG=var_header.DEFAULT_FONT_FLAG
7228: WHERE ui_def_id=in_new_def_id AND ui_node_type=UI_ROOT_SYSTEM_TYPE AND deleted_flag=NO_FLAG;
7229:
7230: FOR i IN(SELECT ui_node_id,parent_id,ps_node_id,ui_node_ref_id,ui_node_type,name
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
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)
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)
7240: AND i.ps_node_id IS NOT NULL AND i.ui_node_ref_id IS NOT NULL AND i.parent_id<>var_old_limbo_id THEN
7241:
7242: SELECT name INTO var_name FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7243: AND ui_node_id=i.ui_node_ref_id;
7244: Map(i.ps_node_id):=var_name;
7245: END IF;
7246: END LOOP;
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
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
7253: ps_node_type IN(PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,
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;
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;
7261: END LOOP;
7264: LOOP
7265: IF i.ps_node_type IN (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,BOM_MODEL_NODE_TYPE,
7266: BOM_CLASS_NODE_TYPE) THEN
7267: BEGIN
7268: SELECT * INTO var_old_id FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7269: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
7270: parent_id <> var_old_limbo_id AND deleted_flag=NO_FLAG;
7271:
7272: SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7268: SELECT * INTO var_old_id FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7269: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
7270: parent_id <> var_old_limbo_id AND deleted_flag=NO_FLAG;
7271:
7272: SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7273: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
7274: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
7275:
7276: FOR k IN(SELECT * FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7272: SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7273: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND
7274: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
7275:
7276: FOR k IN(SELECT * FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7277: AND parent_id=var_old_id.ui_node_id AND parent_id<>var_old_limbo_id
7278: AND ui_node_type NOT IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,
7279: UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG)
7280: LOOP
7283: new_caption_id:=getTXTSeqVal;
7284:
7285: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
7286: SELECT new_caption_id,text_str,in_new_def_id,in_project_id,'0' FROM CZ_INTL_TEXTS
7287: WHERE intl_text_id=(SELECT caption_id FROM CZ_UI_NODES
7288: WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id);
7289:
7290: INSERT INTO CZ_UI_NODES
7291: (ui_node_id,
7286: SELECT new_caption_id,text_str,in_new_def_id,in_project_id,'0' FROM CZ_INTL_TEXTS
7287: WHERE intl_text_id=(SELECT caption_id FROM CZ_UI_NODES
7288: WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id);
7289:
7290: INSERT INTO CZ_UI_NODES
7291: (ui_node_id,
7292: parent_id,
7293: ui_def_id,
7294: ps_node_id,
7308: default_font_flag,default_bkgrnd_color_flag,default_bkgrnd_picture_flag,
7309: NO_FLAG,NO_FLAG,rel_top_pos,rel_left_pos,NO_FLAG,
7310: fontbold,fontcolor,fontunderline,fontsize,fontname,
7311: backgroundstyle,controltype,backgroundpicture,borders,picturename,func_comp_id
7312: FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7313:
7314: INSERT INTO CZ_UI_NODE_PROPS(ui_def_id,ui_node_id,key_str,value_str,deleted_flag)
7315: SELECT in_new_def_id,new_ui_node_id,key_str,value_str,'0' FROM CZ_UI_NODE_PROPS
7316: WHERE ui_def_id=in_old_def_id AND ui_node_id=k.ui_node_id;
7322: NULL;
7323: END;
7324: END LOOP;
7325:
7326: UPDATE CZ_UI_NODES
7327: SET
7328: REL_TOP_POS=var_old_id.REL_TOP_POS,
7329: REL_LEFT_POS=var_old_id.REL_LEFT_POS,
7330: CAPTION_ID=var_old_id.CAPTION_ID,
7356:
7357: IF i.ps_node_type IN (FEATURE_NODE_TYPE,RESOURCE_NODE_TYPE,
7358: TOTAL_NODE_TYPE,BOM_MODEL_NODE_TYPE) THEN
7359: BEGIN
7360: SELECT * INTO var_old_id FROM CZ_UI_NODES WHERE ui_def_id=in_old_def_id
7361: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,
7362: UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
7363: AND parent_id<>var_old_limbo_id AND deleted_flag=NO_FLAG;
7364:
7361: AND ps_node_id=i.ps_node_id AND ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,
7362: UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
7363: AND parent_id<>var_old_limbo_id AND deleted_flag=NO_FLAG;
7364:
7365: SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7366: 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)
7367: AND parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
7368:
7369: UPDATE CZ_UI_NODES
7365: SELECT * INTO var_new_id FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7366: 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)
7367: AND parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG;
7368:
7369: UPDATE CZ_UI_NODES
7370: SET
7371: REL_TOP_POS=var_old_id.REL_TOP_POS,
7372: REL_LEFT_POS=var_old_id.REL_LEFT_POS,
7373: CAPTION_ID=var_old_id.CAPTION_ID,
7398: END IF;
7399: END LOOP;
7400:
7401: FOR i IN(SELECT ui_node_id,parent_id,ui_node_ref_id,ps_node_id,ui_node_type,name
7402: FROM CZ_UI_NODES WHERE ui_def_id=in_new_def_id
7403: AND ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,
7404: UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
7405: AND ui_node_ref_id IS NOT NULL AND
7406: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
7407: LOOP
7408: BEGIN
7409: var_name:=Map(i.ps_node_id);
7410: IF i.ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) THEN
7411: FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES
7412: WHERE ui_def_id=in_new_def_id AND parent_id=i.ui_node_id AND
7413: name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
7414: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
7415: LOOP
7412: WHERE ui_def_id=in_new_def_id AND parent_id=i.ui_node_id AND
7413: name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
7414: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
7415: LOOP
7416: UPDATE CZ_UI_NODES
7417: SET ui_node_ref_id=n.ui_node_id
7418: WHERE ui_def_id=in_new_def_id
7419: AND ui_node_id=i.ui_node_id;
7420: END LOOP;
7420: END LOOP;
7421: END IF;
7422:
7423: IF i.ui_node_type IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE) THEN
7424: FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES
7425: WHERE ui_def_id=in_new_def_id AND parent_id=i.parent_id AND
7426: name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
7427: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
7428: LOOP
7425: WHERE ui_def_id=in_new_def_id AND parent_id=i.parent_id AND
7426: name=var_name AND ui_node_type=UI_TEXT_LABEL_TYPE AND
7427: parent_id<>var_new_limbo_id AND deleted_flag=NO_FLAG)
7428: LOOP
7429: UPDATE CZ_UI_NODES
7430: SET ui_node_ref_id=n.ui_node_id
7431: WHERE ui_def_id=in_new_def_id
7432: AND ui_node_id=i.ui_node_id;
7433: END LOOP;
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: --
7474:
7475: --
7476: -- remove UI subtrees --
7477: --
7478: FOR l IN (SELECT ui_node_id,ps_node_id,ui_node_ref_id,ui_node_type FROM CZ_UI_NODES
7479: 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,
7480: UI_REFERENCE_REF_TYPE) AND deleted_flag=NO_FLAG)
7481: LOOP
7482: remove_UI_Subtree(l.ui_node_id,l.ui_node_type);
7482: remove_UI_Subtree(l.ui_node_id,l.ui_node_type);
7483: END LOOP;
7484: END LOOP;
7485:
7486: FOR i IN(SELECT b.ui_node_id FROM CZ_PS_NODES a,CZ_UI_NODES b
7487: WHERE b.ui_def_id=in_ui_def_id AND a.ps_node_id=b.ps_node_id
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))
7485:
7486: FOR i IN(SELECT b.ui_node_id FROM CZ_PS_NODES a,CZ_UI_NODES b
7487: WHERE b.ui_def_id=in_ui_def_id AND a.ps_node_id=b.ps_node_id
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;
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;
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;
7676: ind_counter INTEGER;
7677: deletedNodes INTEGER:=0;
7678: counter INTEGER:=0;
7679:
7680: var_caption_id CZ_UI_NODES.caption_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7677: deletedNodes INTEGER:=0;
7678: counter INTEGER:=0;
7679:
7680: var_caption_id CZ_UI_NODES.caption_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7678: counter INTEGER:=0;
7679:
7680: var_caption_id CZ_UI_NODES.caption_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7679:
7680: var_caption_id CZ_UI_NODES.caption_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7680: var_caption_id CZ_UI_NODES.caption_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7681: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7682: var_modified_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7683: var_ui_tree_parent_id CZ_UI_NODES.ui_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7684: var_ui_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7685: var_ui_control_type CZ_UI_NODES.controltype%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7686: var_parent_item_txt_id CZ_UI_NODES.caption_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7687: var_ui_parent_item_id CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7688: var_inst_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7689: var_inst_text_label CZ_UI_NODES.ui_node_id%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7690: var_modify_ui_flag CZ_UI_NODES.modified_flags%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7691: var_screen_ps_node_id CZ_UI_NODES.ps_node_id%TYPE;
7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7710: var_option_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7710: var_option_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7711: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7710: var_option_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7711: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
7712: var_label CZ_INTL_TEXTS.text_str%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7710: var_option_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7711: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
7712: var_label CZ_INTL_TEXTS.text_str%TYPE;
7713: var_button_name CZ_INTL_TEXTS.text_str%TYPE;
7706: var_inst_tree_seq CZ_UI_NODES.tree_seq%TYPE;
7707: var_inst_caption_id CZ_UI_NODES.caption_id%TYPE;
7708: var_inst_name CZ_UI_NODES.name%TYPE;
7709: var_ref_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7710: var_option_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7711: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
7712: var_label CZ_INTL_TEXTS.text_str%TYPE;
7713: var_button_name CZ_INTL_TEXTS.text_str%TYPE;
7714:
7739: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
7740: var_name CZ_PS_NODES.name%TYPE;
7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;
7745: var_screen_name CZ_UI_NODES.NAME%TYPE;
7746: var_ui_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7747: var_modified_flags CZ_UI_NODES.MODIFIED_FLAGS%TYPE;
7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;
7745: var_screen_name CZ_UI_NODES.NAME%TYPE;
7746: var_ui_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7747: var_modified_flags CZ_UI_NODES.MODIFIED_FLAGS%TYPE;
7748: var_gen_version CZ_UI_DEFS.GEN_VERSION%TYPE;
7749: var_ui_name CZ_UI_DEFS.NAME%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;
7745: var_screen_name CZ_UI_NODES.NAME%TYPE;
7746: var_ui_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7747: var_modified_flags CZ_UI_NODES.MODIFIED_FLAGS%TYPE;
7748: var_gen_version CZ_UI_DEFS.GEN_VERSION%TYPE;
7749: var_ui_name CZ_UI_DEFS.NAME%TYPE;
7750: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;
7745: var_screen_name CZ_UI_NODES.NAME%TYPE;
7746: var_ui_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7747: var_modified_flags CZ_UI_NODES.MODIFIED_FLAGS%TYPE;
7748: var_gen_version CZ_UI_DEFS.GEN_VERSION%TYPE;
7749: var_ui_name CZ_UI_DEFS.NAME%TYPE;
7750: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
7751: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
7784: --
7785: -- Calculate usable width and height --
7786: --
7787: SELECT ui_node_id,width,height INTO var_root_id,var_screen_width,var_screen_height FROM
7788: CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ui_node_id=parent_id
7789: AND deleted_flag=NO_FLAG;
7790:
7791: USABLE_WIDTH:=FLOOR(var_screen_width*(100-DEFAULT_TREE_ALLOCATION)/100)-LEFT_MARGIN-RIGHT_MARGIN;
7792: USABLE_HEIGHT:=var_screen_height;
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;
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:
7897: RAISE BREAK_IT;
7898: END IF;
7899:
7900: BEGIN
7901: SELECT ui_node_id INTO var_comp_tree_id FROM CZ_UI_NODES
7902: WHERE ui_def_id=in_ui_def_id AND name='Components Tree' AND deleted_flag=NO_FLAG;
7903: EXCEPTION
7904: WHEN NO_DATA_FOUND THEN
7905: RAISE NO_COMPONENT_TREE_NODE;
7905: RAISE NO_COMPONENT_TREE_NODE;
7906: END;
7907:
7908: BEGIN
7909: SELECT ui_node_id INTO var_limbo_id FROM CZ_UI_NODES
7910: WHERE ui_def_id=in_ui_def_id AND name='Limbo' AND
7911: deleted_flag=NO_FLAG;
7912: EXCEPTION
7913: WHEN NO_DATA_FOUND THEN
7927:
7928: --
7929: -- delete buttons which are associated with a deleted Functional Companions --
7930: --
7931: UPDATE CZ_UI_NODES a
7932: SET deleted_flag=YES_FLAG
7933: 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
7934: 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);
7935:
7935:
7936: --
7937: -- delete buttons which are associated with a deleted CXs --
7938: --
7939: UPDATE CZ_UI_NODES u
7940: SET deleted_flag=YES_FLAG
7941: WHERE u.ui_def_id=in_ui_def_id AND u.ui_node_type=UI_BUTTON_TYPE AND
7942: u.deleted_flag=NO_FLAG AND
7943: EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS p
7947: r.rule_type=CZ_EXTENTSIONS_RULE_TYPE AND r.deleted_flag=NO_FLAG));
7948:
7949: /* *** remove all UI nodes associated with unexisting PS nodes *** */
7950:
7951: FOR i IN (SELECT ui_node_id,ui_node_type,deleted_flag FROM CZ_UI_NODES a
7952: WHERE ui_def_id=in_ui_def_id AND ps_node_id IS NOT NULL AND ui_node_type<>141
7953: AND (NOT EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=Project_Id AND
7954: ps_node_id=a.ps_node_id AND deleted_flag=NO_FLAG) OR a.deleted_flag=YES_FLAG))
7955: LOOP
7954: ps_node_id=a.ps_node_id AND deleted_flag=NO_FLAG) OR a.deleted_flag=YES_FLAG))
7955: LOOP
7956: BEGIN
7957: IF i.ui_node_type IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE) THEN
7958: UPDATE CZ_UI_NODES
7959: SET deleted_flag=YES_FLAG
7960: WHERE ui_def_id=in_ui_def_id AND ui_node_id=i.ui_node_id AND
7961: ui_node_type IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE)
7962: AND deleted_flag=NO_FLAG;
8002:
8003: FOR k IN(SELECT ui_node_id,parent_id,ui_node_ref_id,ui_def_ref_id,
8004: caption_id,height,ui_node_type,controltype,
8005: modified_flags,name,tree_seq,rel_top_pos,ps_node_id
8006: FROM CZ_UI_NODES
8007: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND
8008: ui_node_type IN
8009: (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,
8010: UI_FEATURE_TYPE,UI_OPTION_TYPE,
8017: IF i.ps_node_type=BOM_CLASS_NODE_TYPE
8018: AND k.ui_node_type=UI_BOM_OPTION_CLASS_TYPE THEN
8019:
8020: BEGIN
8021: SELECT caption_id INTO var_label_txt_id FROM CZ_UI_NODES
8022: WHERE ui_def_id=in_ui_def_id AND ui_node_id=k.ui_node_ref_id;
8023:
8024: SELECT caption_id INTO var_tree_caption_id FROM CZ_UI_NODES
8025: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=k.ui_node_id AND
8020: BEGIN
8021: SELECT caption_id INTO var_label_txt_id FROM CZ_UI_NODES
8022: WHERE ui_def_id=in_ui_def_id AND ui_node_id=k.ui_node_ref_id;
8023:
8024: SELECT caption_id INTO var_tree_caption_id FROM CZ_UI_NODES
8025: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=k.ui_node_id AND
8026: ui_node_type IN(UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE)
8027: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8028: EXCEPTION
8068: END LOOP;
8069:
8070: IF i.ps_node_type=REFERENCE_NODE_TYPE THEN
8071: BEGIN
8072: SELECT ui_node_ref_id INTO var_tempo FROM CZ_UI_NODES
8073: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id
8074: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8075:
8076: SELECT ui_node_id INTO var_parent_screen_id FROM
8073: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_parent_id
8074: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8075:
8076: SELECT ui_node_id INTO var_parent_screen_id FROM
8077: CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
8078: ui_node_id=var_tempo AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8079: EXCEPTION
8080: WHEN NO_DATA_FOUND THEN
8081: NULL;
8090: FEATURE_NODE_TYPE,TOTAL_NODE_TYPE,RESOURCE_NODE_TYPE,CONNECTOR_NODE_TYPE,
8091: BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE) THEN
8092: SELECT caption_id,modified_flags
8093: INTO var_text_label_caption_id,var_modified_flags
8094: FROM CZ_UI_NODES
8095: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_text_label_id AND
8096: deleted_flag=NO_FLAG;
8097: END IF;
8098: EXCEPTION
8215: /* *** find ui_node_id in the Component Tree associated with the ui node = var_screen_ui_id *** */
8216: BEGIN
8217: var_tree_ui_id:=NULL;
8218: SELECT ui_node_id,caption_id,parent_id
8219: INTO var_tree_ui_id,var_tree_caption_id,var_tree_parent_id FROM CZ_UI_NODES
8220: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_screen_ui_id AND
8221: ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE)
8222: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8223:
8222: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8223:
8224: /* *** find a parent screen *** */
8225: SELECT ui_node_ref_id INTO var_parent_screen_id FROM
8226: CZ_UI_NODES WHERE ui_node_id=var_tree_parent_id;
8227: EXCEPTION
8228: WHEN NO_DATA_FOUND THEN
8229: NULL;
8230: END;
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
8257: SELECT ui_node_id,parent_id,ui_def_ref_id,caption_id,name,tree_seq,ps_node_id,ui_node_type
8258: INTO var_screen_ui_id,var_screen_parent_id,var_ui_def_ref_id,
8259: var_screen_caption_id,var_screen_name,
8260: var_ui_tree_seq,var_screen_ps_node_id,var_ui_node_type
8261: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND
8262: ui_node_type=UI_REFERENCE_REF_TYPE AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8263:
8264: SELECT ui_node_ref_id
8265: INTO var_ref_parent_screen_id
8262: ui_node_type=UI_REFERENCE_REF_TYPE AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8263:
8264: SELECT ui_node_ref_id
8265: INTO var_ref_parent_screen_id
8266: FROM CZ_UI_NODES
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
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
8293: -- associated with the given reference
8294: -- ( the reference and the STANDART ITEM have the same ps_node_id )
8295: --
8296: SELECT value_str INTO var_use_labels FROM CZ_UI_NODE_PROPS
8297: WHERE ui_node_id=(SELECT parent_id FROM CZ_UI_NODES
8298: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG AND
8299: ui_node_type=UI_BOM_STANDART_TYPE AND parent_id<>var_limbo_id)
8300: AND UPPER(key_str)='USELABELS' AND deleted_flag=NO_FLAG;
8301: EXCEPTION
8368: SELECT ui_node_id,parent_id,ui_node_type,ps_node_id,
8369: rel_top_pos,tree_seq,caption_id,ui_node_ref_id,name
8370: INTO var_inst_ui_id,var_inst_parent_id,var_ui_node_type,var_inst_ps_id,
8371: var_inst_top_pos,var_inst_tree_seq,var_inst_caption_id,var_inst_node_ref_id,var_inst_name
8372: FROM CZ_UI_NODES
8373: WHERE ui_def_id=in_ui_def_id AND ps_node_id=i.ps_node_id AND parent_id<>var_limbo_id AND
8374: ui_node_type IN(UI_BOM_INST_ITEM_TYPE,UI_BOM_STANDART_TYPE) AND deleted_flag=NO_FLAG;
8375:
8376: --
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
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
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
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
8443:
8444: BEGIN
8445: var_ref_ui_id:=NULL;
8446: SELECT ui_node_id INTO var_ref_ui_id
8447: FROM CZ_UI_NODES WHERE ui_def_id = var_ui_def_ref_id
8448: AND ps_node_id=i.reference_id AND ui_node_type=UI_SCREEN_TYPE
8449: AND deleted_flag=NO_FLAG AND rownum<2;
8450: EXCEPTION
8451: WHEN OTHERS THEN
8517: -- check : is there a button that associated with this reference --
8518: --
8519: BEGIN
8520: SELECT YES_FLAG INTO existsButton FROM dual WHERE
8521: EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
8522: AND ui_node_type=UI_BUTTON_TYPE AND ps_node_id=i.ps_node_id AND
8523: deleted_flag=NO_FLAG);
8524: RAISE BUTTON_EXISTS;
8525: EXCEPTION
8555:
8556: BEGIN
8557: /*
8558: SELECT YES_FLAG INTO existsSTANDART_ITEM FROM dual WHERE
8559: EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND parent_id<>var_limbo_id
8560: AND ui_node_type=UI_BOM_INST_ITEM_TYPE AND ps_node_id=i.ps_node_id AND
8561: deleted_flag=NO_FLAG);
8562: */
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:
8655: -- check Is there "Delete" button under the root screen --
8656: -- of the referenced UI --
8657: -- ActionType='1' means that this is "Delete" action --
8658: --
8659: SELECT ui_node_id INTO var_ui_root_id FROM CZ_UI_NODES
8660: WHERE ui_def_id=var_ref_id AND ps_node_id=var_model_Id AND
8661: ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE)
8662: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8663:
8661: ui_node_type IN(UI_PRODUCT_TYPE,UI_COMPONENT_TYPE,UI_BOM_OPTION_CLASS_TYPE)
8662: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
8663:
8664: SELECT YES_FLAG INTO existsDeleteMe FROM dual WHERE
8665: EXISTS(SELECT NULL FROM CZ_UI_NODES a WHERE
8666: a.ui_def_id=var_ref_id AND a.ui_node_type=UI_BUTTON_TYPE AND a.parent_id=var_ui_root_id
8667: AND a.parent_id<>var_limbo_id AND a.deleted_flag=NO_FLAG AND a.modified_flags=0
8668: AND EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS b
8669: WHERE b.ui_def_id=var_ref_id AND b.ui_node_id=a.ui_node_id
8713: -- have the same ps_node_id
8714: --
8715: SELECT ui_node_id
8716: INTO var_ui_parent_item_id
8717: FROM CZ_UI_NODES
8718: WHERE ui_def_id=in_ui_def_id AND
8719: ui_node_type=UI_BOM_STANDART_TYPE AND parent_id=
8720: (SELECT ui_node_ref_id FROM CZ_UI_NODES
8721: WHERE ui_def_id=in_ui_def_id AND ui_node_id=
8716: INTO var_ui_parent_item_id
8717: FROM CZ_UI_NODES
8718: WHERE ui_def_id=in_ui_def_id AND
8719: ui_node_type=UI_BOM_STANDART_TYPE AND parent_id=
8720: (SELECT ui_node_ref_id FROM CZ_UI_NODES
8721: WHERE ui_def_id=in_ui_def_id AND ui_node_id=
8722: (SELECT parent_id FROM CZ_UI_NODES
8723: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=t_bom_pages(1).ui_node_id
8724: AND deleted_flag=NO_FLAG)) AND ps_node_id=t_bom_pages(1).ps_node_id;
8718: WHERE ui_def_id=in_ui_def_id AND
8719: ui_node_type=UI_BOM_STANDART_TYPE AND parent_id=
8720: (SELECT ui_node_ref_id FROM CZ_UI_NODES
8721: WHERE ui_def_id=in_ui_def_id AND ui_node_id=
8722: (SELECT parent_id FROM CZ_UI_NODES
8723: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=t_bom_pages(1).ui_node_id
8724: AND deleted_flag=NO_FLAG)) AND ps_node_id=t_bom_pages(1).ps_node_id;
8725:
8726: UPDATE CZ_UI_NODES
8722: (SELECT parent_id FROM CZ_UI_NODES
8723: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=t_bom_pages(1).ui_node_id
8724: AND deleted_flag=NO_FLAG)) AND ps_node_id=t_bom_pages(1).ps_node_id;
8725:
8726: UPDATE CZ_UI_NODES
8727: SET name=i.name
8728: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_parent_item_id
8729: AND modified_flags=0 AND deleted_flag=NO_FLAG;
8730:
8728: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_parent_item_id
8729: AND modified_flags=0 AND deleted_flag=NO_FLAG;
8730:
8731: SELECT caption_id INTO var_parent_item_txt_id
8732: FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_parent_item_id;
8733:
8734: EXCEPTION
8735: WHEN OTHERS THEN
8736: NULL;
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
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;
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;
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;
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;
8968: --
8969: -- remove non-customized buttons which have ActionType= '0'( "Add" button ) --
8970: -- or ActionType= '1'( "Delete" button ) --
8971: --
8972: UPDATE CZ_UI_NODES a SET a.deleted_flag=YES_FLAG
8973: WHERE ui_def_id=in_ui_def_id AND
8974: ps_node_id=i.ps_node_id AND
8975: ui_node_type=UI_BUTTON_TYPE AND modified_flags=0 AND deleted_flag=NO_FLAG;
8976: END IF; -- end of non-virtual --> virtual case --
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;
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:
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';
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;
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: */
9175:
9176: SELECT ui_node_id,caption_id,name,tree_seq,ps_node_id
9177: INTO var_option_ui_id,var_option_caption_id,
9178: var_option_ui_name,var_ui_tree_seq,var_option_ps_id
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
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
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
9272: -- Selection List) otherwise update Control Type
9273: -- according with current Feature Type
9274: --
9275: IF NOT(i.feature_type=0 AND var_control_type=1 AND var_ui_control_type=2) THEN
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,
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;
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 *** */
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 *** */
9301:
9302: /* *** counted/Max options case for Feature *** */
9303:
9304: IF i.feature_type in(1,2,3,4) THEN
9305: -- change height of the feature --
9306: UPDATE CZ_UI_NODES
9307: SET height=DEFAULT_CONTROL_HEIGHT
9308: WHERE ui_node_id=var_screen_ui_id AND modified_flags=0;
9309: END IF;
9310: END IF;
9340: EXCEPTION
9341: WHEN NO_DATA_FOUND THEN
9342: IF news(k).ps_node_type IN (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,REFERENCE_NODE_TYPE,
9343: BOM_CLASS_NODE_TYPE,BOM_MODEL_NODE_TYPE) THEN
9344: SELECT MAX(ui_node_id) INTO temp_node FROM CZ_UI_NODES WHERE
9345: ps_node_id=news(k).parent_id AND ui_node_ref_id IS NOT NULL AND
9346: ui_node_type IN(UI_COMPONENT_TYPE,UI_REFERENCE_REF_TYPE,BOM_CLASS_NODE_TYPE,BOM_MODEL_NODE_TYPE)
9347: AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
9348: SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES
9344: SELECT MAX(ui_node_id) INTO temp_node FROM CZ_UI_NODES WHERE
9345: ps_node_id=news(k).parent_id AND ui_node_ref_id IS NOT NULL AND
9346: ui_node_type IN(UI_COMPONENT_TYPE,UI_REFERENCE_REF_TYPE,BOM_CLASS_NODE_TYPE,BOM_MODEL_NODE_TYPE)
9347: AND ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG;
9348: SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES
9349: WHERE ui_node_ref_id=temp_node AND ui_def_id=in_ui_def_id
9350: AND ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag=NO_FLAG;
9351: END IF;
9352: END;
9368: --
9369: IF news(k).virtual_flag = NO_FLAG THEN
9370: BEGIN
9371: var_parent_id:=NULL;
9372: SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
9373: WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
9374: EXCEPTION
9375: WHEN NO_DATA_FOUND THEN
9376: IF news.EXISTS(news(k).parent_id) THEN
9412: --
9413: IF news(k).virtual_flag = NO_FLAG THEN
9414: BEGIN
9415: var_parent_id:=NULL;
9416: SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
9417: WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
9418: EXCEPTION
9419: WHEN NO_DATA_FOUND THEN
9420: IF news.EXISTS(news(k).parent_id) THEN
9450: --
9451: IF news(k).virtual_flag = NO_FLAG THEN
9452: BEGIN
9453: var_parent_id:=NULL;
9454: SELECT ui_node_ref_id INTO var_parent_id FROM CZ_UI_NODES
9455: WHERE ui_def_id=in_ui_def_id AND ui_node_id=new_parent AND deleted_flag=NO_FLAG;
9456: EXCEPTION
9457: WHEN NO_DATA_FOUND THEN
9458: IF news.EXISTS(news(k).parent_id) THEN
9512:
9513: END IF;
9514:
9515: BEGIN
9516: SELECT ui_node_ref_id INTO var_ref_to_id FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
9517: AND ui_node_id=new_parent AND ui_node_type=UI_COMPONENT_REF_TYPE AND
9518: parent_id<>var_limbo_id AND deleted_flag=NO_FLAG;
9519:
9520: create_REFERENCE_Model(new_child,new_parent,in_ui_def_id,
9577: in_tree_seq =>news(k).tree_seq);
9578:
9579: BEGIN
9580:
9581: SELECT ui_node_ref_id INTO var_temp FROM CZ_UI_NODES WHERE
9582: ui_def_id=in_ui_def_id AND ui_node_id=new_parent;
9583:
9584: SELECT MAX(rel_top_pos) INTO last_TOP_POS FROM CZ_UI_NODES
9585: WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp AND parent_id<>var_limbo_id
9580:
9581: SELECT ui_node_ref_id INTO var_temp FROM CZ_UI_NODES WHERE
9582: ui_def_id=in_ui_def_id AND ui_node_id=new_parent;
9583:
9584: SELECT MAX(rel_top_pos) INTO last_TOP_POS FROM CZ_UI_NODES
9585: WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp AND parent_id<>var_limbo_id
9586: AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
9587:
9588: var_width:=set_Text_Width(news(k).caption_name)+80;
9677: var_feature_height:=DEFAULT_CONTROL_HEIGHT;
9678: END IF;
9679: --features(k).height:=var_feature_height;
9680:
9681: SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES WHERE ps_node_id=features(k).parent_id
9682: AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG
9683: AND ui_def_id=in_ui_def_id ;
9684:
9685: SELECT NVL(MAX(rel_top_pos),-1) INTO last_TOP_POS
9682: AND ui_node_type IN (UI_PRODUCT_TYPE,UI_COMPONENT_TYPE) AND deleted_flag=NO_FLAG
9683: AND ui_def_id=in_ui_def_id ;
9684:
9685: SELECT NVL(MAX(rel_top_pos),-1) INTO last_TOP_POS
9686: FROM CZ_UI_NODES WHERE parent_id=new_parent AND deleted_flag=NO_FLAG;
9687:
9688: IF last_TOP_POS=-1 THEN
9689: last_TOP_POS:=DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN;
9690: ELSE
9687:
9688: IF last_TOP_POS=-1 THEN
9689: last_TOP_POS:=DEFAULT_HEADER_HEIGHT+DEFAULT_SPACE_BETWEEN;
9690: ELSE
9691: SELECT NVL(MAX(height),0) INTO last_HEIGHT FROM CZ_UI_NODES
9692: WHERE parent_id=new_parent AND rel_top_pos=last_TOP_POS AND
9693: ui_node_type IN (UI_FEATURE_TYPE,UI_TOTAL_TYPE,UI_RESOURCE_TYPE,
9694: UI_BOM_OPTION_CLASS_TYPE,UI_BOM_STANDART_TYPE,UI_BUTTON_TYPE)
9695: AND deleted_flag=NO_FLAG;
9747:
9748: /* *** create OPTIONS *** */
9749: IF options.EXISTS(k) AND NOT(news.EXISTS(options(k).parent_id)) AND NOT(features.EXISTS(options(k).parent_id)) THEN
9750: BEGIN
9751: SELECT ui_node_id INTO new_parent FROM CZ_UI_NODES
9752: WHERE ps_node_id=options(k).parent_id AND ui_def_id=in_ui_def_id
9753: AND deleted_flag=NO_FLAG;
9754: create_OPTION(curr_node_id,new_parent,in_ui_def_id,options(k));
9755: EXCEPTION
9773: SELECT ps_node_type INTO var_ps_node_type FROM CZ_PS_NODES
9774: WHERE ps_node_id=boms(k).parent_id;
9775:
9776: /* *** use latest page for adding new STANDART ITEMS *** */
9777: FOR e IN(SELECT ui_node_id,ps_node_id FROM CZ_UI_NODES WHERE
9778: ui_def_id=in_ui_def_id AND ps_node_id=boms(k).parent_id AND
9779: ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG
9780: ORDER BY ui_node_id)
9781: LOOP
9786: t_pages(e.ps_node_id):=1;
9787: END IF;
9788: END LOOP;
9789:
9790: SELECT parent_id INTO var_ui_tree_parent_id FROM CZ_UI_NODES
9791: WHERE ui_def_id=in_ui_def_id AND ui_node_ref_id=var_temp AND
9792: ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag=NO_FLAG;
9793:
9794: SELECT intl_text_id,tree_seq,name
9806: ELSE
9807: var_use_default_color:=NO_FLAG;
9808: END IF;
9809:
9810: SELECT COUNT(ui_node_id) INTO counter FROM CZ_UI_NODES
9811: WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp
9812: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG;
9813:
9814: IF counter>=mITEMS_ON_PAGE AND mUI_STYLE=DHTML_STYLE_UI THEN
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;
9828: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
9829: WHERE intl_text_id=var_temp AND var_modified_flag=0;
9830:
9831: SELECT caption_id,modified_flags
9832: INTO var_caption_id,var_modified_flag FROM CZ_UI_NODES
9833: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_ui_node_ref_id
9834: AND deleted_flag=NO_FLAG;
9835:
9836: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix
9867: footer_buttons(ind_arr).rel_top_pos:=0;
9868: END IF;
9869: END IF;
9870:
9871: SELECT NVL(MAX(rel_top_pos),START_TOP_POS) INTO last_TOP_POS FROM CZ_UI_NODES
9872: WHERE ui_def_id=in_ui_def_id AND parent_id=var_temp AND parent_id<>var_limbo_id
9873: AND modified_flags<>CZ_NAVIGATION_MARK AND deleted_flag=NO_FLAG;
9874:
9875: IF last_TOP_POS>START_TOP_POS THEN
9879: BEGIN
9880: v_just_OC:='0';
9881:
9882: SELECT '1' INTO v_just_OC FROM DUAL WHERE EXISTS
9883: (SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
9884: AND ui_node_ref_id IS NOT NULL
9885: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG
9886: AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
9887: WHERE model_id=Project_Id AND referring_node_id IS NOT NULL AND deleted_flag=NO_FLAG))
9885: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG
9886: AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
9887: WHERE model_id=Project_Id AND referring_node_id IS NOT NULL AND deleted_flag=NO_FLAG))
9888: AND NOT EXISTS
9889: (SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
9890: AND ui_node_ref_id IS NULL
9891: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG);
9892:
9893: IF v_just_OC='1' THEN
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 *** */
9977: OR deleted_flag=YES_FLAG);
9978:
9979: /* *** synchronize types of Functional Companions *** */
9980: FOR h IN(SELECT a.func_comp_id,a.companion_type,
9981: 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
9982: WHERE b.ui_def_id=in_ui_def_id AND b.ui_node_type=UI_BUTTON_TYPE
9983: AND a.func_comp_id=b.func_comp_id AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
9984: LOOP
9985:
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;
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:
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;
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:
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;
10079: END IF;
10080:
10081: END LOOP;
10082:
10083: FOR i IN (SELECT ui_node_id,parent_id,ps_node_id,ui_node_ref_id,controltype,name FROM CZ_UI_NODES a
10084: WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BUTTON_TYPE
10085: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG)
10086:
10087: LOOP
10084: WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BUTTON_TYPE
10085: AND parent_id<>var_limbo_id AND deleted_flag=NO_FLAG)
10086:
10087: LOOP
10088: 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
10089: parent_id=var_limbo_id AND ui_node_type NOT IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE))
10090: LOOP
10091: BEGIN
10092: SELECT ui_node_id INTO var_temp FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
10088: 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
10089: parent_id=var_limbo_id AND ui_node_type NOT IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE))
10090: LOOP
10091: BEGIN
10092: SELECT ui_node_id INTO var_temp FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
10093: AND ui_node_id=i.parent_id AND parent_id=var_limbo_id AND deleted_flag=NO_FLAG;
10094: EXCEPTION
10095: WHEN NO_DATA_FOUND THEN
10096: out_run_id:=GLOBAL_RUN_ID;
10100: FND_REPORT(CZ_UI_GEN_REMOVED_SCREEN,TOKEN_BUTTON_NAME,i.name,CZ_WARNING_URGENCY);
10101: END;
10102: END LOOP;
10103:
10104: FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES a WHERE ui_node_id=i.ui_node_ref_id AND
10105: parent_id IN(SELECT ui_node_id FROM CZ_UI_NODES b WHERE a.ui_def_id=b.ui_def_id
10106: AND name='Limbo' AND deleted_flag=NO_FLAG))
10107: LOOP
10108: out_run_id:=GLOBAL_RUN_ID;
10101: END;
10102: END LOOP;
10103:
10104: FOR n IN(SELECT ui_node_id FROM CZ_UI_NODES a WHERE ui_node_id=i.ui_node_ref_id AND
10105: parent_id IN(SELECT ui_node_id FROM CZ_UI_NODES b WHERE a.ui_def_id=b.ui_def_id
10106: AND name='Limbo' AND deleted_flag=NO_FLAG))
10107: LOOP
10108: out_run_id:=GLOBAL_RUN_ID;
10109: FND_REPORT(CZ_UI_GEN_REMOVED_SCREEN,TOKEN_BUTTON_NAME,i.name,CZ_WARNING_URGENCY);
10124: --
10125: -- shift all ADD and EXECUTE buttons to the bottom of the screen --
10126: --
10127:
10128: FOR i IN (SELECT ui_node_ref_id FROM CZ_UI_NODES
10129: WHERE ui_def_id=in_ui_def_id AND
10130: ui_node_type IN (UI_PRODUCT_REF_TYPE,UI_COMPONENT_REF_TYPE) AND
10131: deleted_flag=NO_FLAG)
10132: LOOP
10140: create_Wizard_Style_Buttons(in_ui_def_id,var_limbo_id);
10141: END IF;
10142:
10143: --
10144: -- synchronize CZ_UI_NODES.tree_seq of Component Tree nodes
10145: -- with CZ_PS_NODES.tree_seq
10146: --
10147: SELECT mMAX_NUMBER_PAGES*a.tree_seq,b.ui_node_id,b.ps_node_id,mMAX_NUMBER_PAGES*a.tree_seq-b.tree_seq
10148: BULK COLLECT INTO t_tree_seq_tbl,t_ui_node_id_tbl,t_ps_node_id_tbl,t_tree_seq_delta_tbl
10145: -- with CZ_PS_NODES.tree_seq
10146: --
10147: SELECT mMAX_NUMBER_PAGES*a.tree_seq,b.ui_node_id,b.ps_node_id,mMAX_NUMBER_PAGES*a.tree_seq-b.tree_seq
10148: BULK COLLECT INTO t_tree_seq_tbl,t_ui_node_id_tbl,t_ps_node_id_tbl,t_tree_seq_delta_tbl
10149: FROM CZ_PS_NODES a,CZ_UI_NODES b
10150: WHERE b.ui_def_id=in_ui_def_id AND a.devl_project_id=Project_Id AND
10151: a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG
10152: 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;
10153:
10157: -- update tree_seq for splitted pages
10158: --
10159: FOR i IN t_ui_node_id_tbl.First..t_ui_node_id_tbl.Last
10160: LOOP
10161: UPDATE CZ_UI_NODES a
10162: SET tree_seq=tree_seq+t_tree_seq_delta_tbl(i)
10163: WHERE a.ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG
10164: AND ps_node_id IS NULL AND ui_node_ref_id IN
10165: (SELECT ui_node_id FROM CZ_UI_NODES
10161: UPDATE CZ_UI_NODES a
10162: SET tree_seq=tree_seq+t_tree_seq_delta_tbl(i)
10163: WHERE a.ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG
10164: AND ps_node_id IS NULL AND ui_node_ref_id IN
10165: (SELECT ui_node_id FROM CZ_UI_NODES
10166: WHERE ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG AND ps_node_id=t_ps_node_id_tbl(i));
10167: END LOOP;
10168:
10169: FORALL i IN t_ui_node_id_tbl.First..t_ui_node_id_tbl.Last
10166: WHERE ui_def_id=in_ui_def_id AND a.deleted_flag=NO_FLAG AND ps_node_id=t_ps_node_id_tbl(i));
10167: END LOOP;
10168:
10169: FORALL i IN t_ui_node_id_tbl.First..t_ui_node_id_tbl.Last
10170: UPDATE CZ_UI_NODES
10171: SET tree_seq = t_tree_seq_tbl(i)
10172: WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_ui_node_id_tbl(i);
10173:
10174: END IF;
10237: var_keep_it VARCHAR2(1):=NO_FLAG;
10238:
10239: BEGIN
10240: FOR i IN (SELECT a.ui_node_id,a.ps_node_id,a.caption_id,b.name,c.localized_str,c.language
10241: FROM CZ_UI_NODES a,CZ_PS_NODES b, CZ_LOCALIZED_TEXTS c
10242: WHERE a.parent_id=in_ui_node_id AND
10243: a.ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE)
10244: AND a.deleted_flag=NO_FLAG AND a.ps_node_id=b.ps_node_id
10245: AND b.intl_text_id=c.intl_text_id)