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

APPS.CZ_UI_GENERATOR dependencies on CZ_INTL_TEXTS

Line 8: caption_name CZ_INTL_TEXTS.text_str%TYPE,

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,
12: minimum CZ_PS_NODES.minimum%TYPE,

Line 23: caption_name CZ_INTL_TEXTS.text_str%TYPE,

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,
27: maximum CZ_PS_NODES.maximum%TYPE,

Line 40: caption_name CZ_INTL_TEXTS.text_str%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,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,

Line 104: currTXTSeqVal CZ_INTL_TEXTS.intl_text_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;
108:

Line 105: currentTXTNode CZ_INTL_TEXTS.intl_text_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;
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;

Line 128: CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';

124: --
125: -- these variables are used in Applet style UI --
126: --
127:
128: CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';
129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';
130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';

125: -- these variables are used in Applet style UI --
126: --
127:
128: CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';
129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';
130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;

127:
128: CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';
129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';
130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

128: CZ_DELETE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Delete';
129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';
130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

129: CZ_CONNECTOR_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE:='Choose Connection';
130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

130:
131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

131: CZ_FIND_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE:=NULL;
132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

132: CZ_FIND_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

133: CZ_ORDER_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

134: CZ_TOTAL_PRC_LABEL_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

135: CZ_AVAILABILITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

136: CZ_DONE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

137: CZ_GRID_ITEM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

Line 142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

138: CZ_GRID_DESCRIPTION_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
146:

Line 143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

139: CZ_GRID_UOM_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
146:
147:

Line 144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

140: CZ_GRID_QUANTITY_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
146:
147:
148:

Line 145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;

141: CZ_GRID_UNIT_LIST_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
142: CZ_GRID_SELLING_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
143: CZ_GRID_EXTENDED_PRC_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
144: CZ_UPDATE_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
145: CZ_CANCEL_BUTTON_CAPTION CZ_INTL_TEXTS.text_str%TYPE;
146:
147:
148:
149: APPLET_STYLE_UI CONSTANT VARCHAR2(1):='3';

Line 622: SELECT CZ_INTL_TEXTS_S.nextval INTO currTXTSeqVal FROM dual;

618: BEGIN
619: IF currentTXTNode 620: currentTXTNode:=currentTXTNode+1;
621: ELSE
622: SELECT CZ_INTL_TEXTS_S.nextval INTO currTXTSeqVal FROM dual;
623: currentTXTNode:=currTXTSeqVal;
624: END IF;
625: RETURN currentTXTNode;
626: END getTXTSeqVal;

Line 670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;

666: ref_boms.DELETE;
667:
668: SELECT CZ_UI_NODES_S.NEXTVAL INTO currentUINode FROM dual;
669: currUISeqVal:=currentUINode;
670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
671: currentTXTNode:=currTXTSeqVal;
672:
673: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
674: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';

Line 808: var_name CZ_INTL_TEXTS.text_str%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;
812:

Line 910: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)

906: IF in_cx_command_name IS NOT NULL THEN
907: var_label := in_cx_command_name;
908: END IF;
909:
910: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
911: VALUES(var_caption_id,var_label,in_ui_def_id,Project_Id,NO_FLAG);
912: END IF;
913:
914: var_use_default_color:=in_use_default_color;

Line 1920: var_text_str CZ_INTL_TEXTS.text_str%TYPE;

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
1924: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS

Line 1924: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS

1920: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
1921:
1922: BEGIN
1923: IF in_intl_text_id IS NOT NULL THEN
1924: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
1925: WHERE intl_text_id=in_intl_text_id;
1926: ELSE
1927: var_text_str:=in_text;
1928: END IF;

Line 2553: var_text_str CZ_INTL_TEXTS.text_str%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;

Line 2554: var_caption_name CZ_INTL_TEXTS.text_str%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);

Line 2592: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS

2588: WHEN OTHERS THEN
2589: var_model_ref_expl_id:=NULL;
2590: END;
2591: BEGIN
2592: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
2593: WHERE intl_text_id=var_intl_text_id;
2594: EXCEPTION
2595: WHEN OTHERS THEN
2596: --

Line 2659: FROM CZ_INTL_TEXTS WHERE intl_text_id=var_intl_text_id;

2655: IF NOT (in_maximum=1 AND in_minimum=1) OR in_virtual_flag=NO_FLAG THEN
2656:
2657: BEGIN
2658: SELECT text_str||' Configurations' INTO var_caption_name
2659: FROM CZ_INTL_TEXTS WHERE intl_text_id=var_intl_text_id;
2660: var_text_width:=set_Text_Width(var_caption_name);
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: var_text_width:=0;

Line 4181: var_button_caption CZ_INTL_TEXTS.text_str%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;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;

Line 4185: var_ref_label CZ_INTL_TEXTS.text_str%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;
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';

Line 4289: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)

4285: var_button_name:=CZ_CONNECTOR_BUTTON_CAPTION||' '||var_ref_name;
4286:
4287: var_button_caption:=CZ_CONNECTOR_BUTTON_CAPTION;
4288:
4289: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)
4290: VALUES(var_txt_id,var_button_caption,in_ui_def_id,Project_Id,NO_FLAG);
4291:
4292: create_BUTTON(getUISeqVal,in_parent_id,in_ui_def_id,
4293: in_arr.ps_node_id,var_button_name,

Line 4889: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;

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:
4893: ERROR_CODE:='0000';

Line 4974: SELECT RTRIM(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS

4970: var_caption_name:=i.name;
4971:
4972: IF i.intl_text_id IS NOT NULL AND in_use_labels<>'0' THEN
4973: BEGIN
4974: SELECT RTRIM(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS
4975: WHERE intl_text_id=i.intl_text_id;
4976:
4977: -- if there is caption_id that does not point to CZ_INTL_TEXTS --
4978: -- then just ignore it and use name from PS tree --

Line 4977: -- if there is caption_id that does not point to CZ_INTL_TEXTS --

4973: BEGIN
4974: SELECT RTRIM(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS
4975: WHERE intl_text_id=i.intl_text_id;
4976:
4977: -- if there is caption_id that does not point to CZ_INTL_TEXTS --
4978: -- then just ignore it and use name from PS tree --
4979: EXCEPTION
4980: WHEN NO_DATA_FOUND THEN
4981: var_caption_name:=i.name;

Line 5776: var_caption_name CZ_INTL_TEXTS.text_str%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:
5780: BEGIN

Line 5807: SELECT NVL(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS

5803: ERROR_CODE:='2003';
5804:
5805: IF i.intl_text_id IS NOT NULL AND in_use_labels<>'0' THEN
5806: BEGIN
5807: SELECT NVL(text_str,' ') INTO var_caption_name FROM CZ_INTL_TEXTS
5808: WHERE intl_text_id=i.intl_text_id;
5809: IF in_use_labels IN('2','3') THEN
5810: var_caption_name:=i.name||mCONCAT_SYMBOL||var_caption_name;
5811: END IF;

Line 5813: -- if there is caption_id that does not point to CZ_INTL_TEXTS --

5809: IF in_use_labels IN('2','3') THEN
5810: var_caption_name:=i.name||mCONCAT_SYMBOL||var_caption_name;
5811: END IF;
5812:
5813: -- if there is caption_id that does not point to CZ_INTL_TEXTS --
5814: -- then just ignore it and use name from PS tree --
5815: EXCEPTION
5816: WHEN OTHERS THEN
5817: var_caption_name:=i.name;

Line 7285: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,ui_def_id,model_id,deleted_flag)

7281: BEGIN
7282: new_ui_node_id:=getUISeqVal;
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:

Line 7286: SELECT new_caption_id,text_str,in_new_def_id,in_project_id,'0' FROM CZ_INTL_TEXTS

7282: new_ui_node_id:=getUISeqVal;
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

Line 7711: var_caption_name CZ_INTL_TEXTS.text_str%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:
7715: Flag BOOLEAN;

Line 7712: var_label CZ_INTL_TEXTS.text_str%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:
7715: Flag BOOLEAN;
7716: existUINode BOOLEAN:=FALSE;

Line 7713: var_button_name CZ_INTL_TEXTS.text_str%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:
7715: Flag BOOLEAN;
7716: existUINode BOOLEAN:=FALSE;
7717: existUI BOOLEAN:=FALSE;

Line 7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;

7738:
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;

Line 7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%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;
7748: var_gen_version CZ_UI_DEFS.GEN_VERSION%TYPE;

Line 8274: UPDATE CZ_INTL_TEXTS SET text_str=i.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
8276: AND var_modified_flags=0;
8277: END IF;
8278: END IF;

Line 8570: FROM CZ_INTL_TEXTS WHERE intl_text_id=var_screen_caption_id;

8566: var_ui_node_id:=getUISeqVal;
8567:
8568: BEGIN
8569: SELECT 'Instances of '||text_str INTO var_caption_name
8570: FROM CZ_INTL_TEXTS WHERE intl_text_id=var_screen_caption_id;
8571: EXCEPTION
8572: WHEN OTHERS THEN
8573: NULL;
8574: END;

Line 8747: UPDATE CZ_INTL_TEXTS SET text_str=i.name

8743: UPDATE CZ_UI_NODES SET name=i.name
8744: WHERE ui_def_id=in_ui_def_id
8745: AND ui_node_id=var_screen_ui_id;
8746:
8747: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8748: WHERE intl_text_id=var_screen_caption_id;
8749:
8750: IF i.intl_text_id IS NULL THEN
8751: UPDATE CZ_INTL_TEXTS SET text_str=i.name

Line 8751: UPDATE CZ_INTL_TEXTS SET text_str=i.name

8747: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8748: WHERE intl_text_id=var_screen_caption_id;
8749:
8750: IF i.intl_text_id IS NULL THEN
8751: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8752: WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
8753: AND var_modified_flags=0;
8754: END IF;
8755: END IF;

Line 8800: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix

8796: IF i.name<>t_bom_pages(x).name THEN
8797: UPDATE CZ_UI_NODES SET name=i.name||var_suffix
8798: WHERE ui_def_id=in_ui_def_id AND ui_node_id=t_bom_pages(x).ui_node_id;
8799:
8800: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8801: WHERE intl_text_id=t_bom_pages(x).text_id;
8802:
8803: IF i.intl_text_id IS NULL THEN
8804: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix

Line 8804: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix

8800: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8801: WHERE intl_text_id=t_bom_pages(x).text_id;
8802:
8803: IF i.intl_text_id IS NULL THEN
8804: UPDATE CZ_INTL_TEXTS SET text_str=i.name||var_suffix
8805: WHERE intl_text_id=t_bom_pages(x).label_txt_id
8806: AND var_modified_flags=0;
8807:
8808: --

Line 8872: UPDATE CZ_INTL_TEXTS SET text_str=i.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;
8874: IF i.intl_text_id IS NULL THEN
8875: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8876: WHERE intl_text_id=var_text_label_caption_id

Line 8875: UPDATE CZ_INTL_TEXTS SET text_str=i.name

8871: AND modified_flags=0;
8872: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8873: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8874: IF i.intl_text_id IS NULL THEN
8875: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8876: WHERE intl_text_id=var_text_label_caption_id
8877: AND var_modified_flags=0;
8878: END IF;
8879: END IF;

Line 8992: UPDATE CZ_INTL_TEXTS SET text_str=i.name

8988: IF i.name<>var_screen_name THEN
8989: UPDATE CZ_UI_NODES SET name=i.name
8990: WHERE ui_def_id=in_ui_def_id AND ui_node_id=var_screen_ui_id
8991: AND modified_flags=0;
8992: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8993: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8994: IF i.intl_text_id IS NULL THEN
8995: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8996: WHERE intl_text_id=var_text_label_caption_id

Line 8995: UPDATE CZ_INTL_TEXTS SET text_str=i.name

8991: AND modified_flags=0;
8992: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8993: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
8994: IF i.intl_text_id IS NULL THEN
8995: UPDATE CZ_INTL_TEXTS SET text_str=i.name
8996: WHERE intl_text_id=var_text_label_caption_id
8997: AND var_modified_flags=0;
8998: END IF;
8999: END IF;

Line 9079: UPDATE CZ_INTL_TEXTS SET text_str=i.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;
9081: IF i.intl_text_id IS NULL THEN
9082: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9083: WHERE intl_text_id=var_text_label_caption_id

Line 9082: UPDATE CZ_INTL_TEXTS SET text_str=i.name

9078: AND modified_flags=0 ;
9079: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9080: WHERE intl_text_id=var_screen_caption_id AND var_modify_ui_flag=0;
9081: IF i.intl_text_id IS NULL THEN
9082: UPDATE CZ_INTL_TEXTS SET text_str=i.name
9083: WHERE intl_text_id=var_text_label_caption_id
9084: AND var_modified_flags=0;
9085: END IF;
9086: END IF;

Line 9211: UPDATE CZ_INTL_TEXTS SET text_str=var_label

9207: END LOOP;
9208:
9209: ELSE
9210: var_label:=getTextByProperty(var_option_ps_id,var_screen_ui_id);
9211: UPDATE CZ_INTL_TEXTS SET text_str=var_label
9212: WHERE intl_text_id=var_option_caption_id;
9213: END IF;
9214:
9215: EXCEPTION

Line 10000: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;

9996:
9997: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
9998: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
9999: IF SQL%ROWCOUNT>0 THEN
10000: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
10001: END IF;
10002:
10003: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
10004: func_comp_id=h.func_comp_id and ui_node_id>h.ui_node_id AND

Line 10022: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;

10018:
10019: UPDATE CZ_UI_NODES SET name=h.name WHERE ui_def_id=in_ui_def_id AND
10020: ui_node_id=h.ui_node_id AND modified_flags=NO_FLAG;
10021: IF SQL%ROWCOUNT>0 THEN
10022: UPDATE CZ_INTL_TEXTS SET text_str=h.name WHERE intl_text_id=h.caption_id;
10023: END IF;
10024:
10025: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND
10026: func_comp_id=h.func_comp_id AND ui_node_id>h.ui_node_id AND