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_LOCALIZED_TEXTS

Line 494: var_caption CZ_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;

490: (in_name IN VARCHAR2,
491: in_label IN VARCHAR2,
492: in_use_labels IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
493:
494: var_caption CZ_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
495: var_use_labels VARCHAR2(3);
496:
497: BEGIN
498: IF in_use_labels IS NULL THEN

Line 809: var_label CZ_LOCALIZED_TEXTS.localized_str%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:
813: BEGIN

Line 827: FOR i IN(SELECT INTL_TEXT_ID,LANGUAGE,LOCALIZED_STR,SOURCE_LANG FROM CZ_LOCALIZED_TEXTS

823:
824: var_name:=in_name;
825: var_insert_flag:=FALSE;
826: IF in_intl_text_id IS NOT NULL THEN
827: FOR i IN(SELECT INTL_TEXT_ID,LANGUAGE,LOCALIZED_STR,SOURCE_LANG FROM CZ_LOCALIZED_TEXTS
828: WHERE intl_text_id=in_intl_text_id AND deleted_flag=NO_FLAG)
829: LOOP
830: var_label:=i.LOCALIZED_STR;
831: IF (in_ps_node_id IS NOT NULL AND in_ui_node_type<>UI_BUTTON_TYPE) OR in_ui_node_type=UI_COMPONENT_REF_TYPE THEN

Line 847: INSERT INTO CZ_LOCALIZED_TEXTS

843: var_label:=var_label||' '||in_page_number;
844: END IF;
845: var_insert_flag:=TRUE;
846:
847: INSERT INTO CZ_LOCALIZED_TEXTS
848: (INTL_TEXT_ID,
849: LOCALIZED_STR,
850: LANGUAGE,
851: SOURCE_LANG,

Line 867: FROM CZ_LOCALIZED_TEXTS

863: SECURITY_MASK,
864: CHECKOUT_USER,
865: MODEL_ID,
866: in_ui_def_id
867: FROM CZ_LOCALIZED_TEXTS
868: WHERE intl_text_id=i.INTL_TEXT_ID AND
869: LANGUAGE=i.LANGUAGE AND
870: SOURCE_LANG=i.SOURCE_LANG;
871: END LOOP;

Line 4577: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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

Line 4586: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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
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

Line 4594: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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
4595: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4596: EXCEPTION
4597: WHEN OTHERS THEN
4598: NULL;

Line 4745: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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
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

Line 4754: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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

Line 4762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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
4763: WHERE intl_text_id=var_temp AND var_modified_flag=0;
4764:
4765: EXCEPTION
4766: WHEN OTHERS THEN

Line 5506: INSERT INTO CZ_LOCALIZED_TEXTS

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
5507: (INTL_TEXT_ID,
5508: LOCALIZED_STR,
5509: LANGUAGE,
5510: SOURCE_LANG,

Line 8121: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)

8117: var_caption_name:=i.name;
8118:
8119: /* *** go through all languages and update captions of the reference *** */
8120:
8121: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8122: LOOP
8123: var_caption_name:=i.name;
8124: var_caption_name:=get_Caption(i.name,l.localized_str,var_use_labels);
8125: END LOOP;

Line 8313: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS

8309:
8310: /* *** go through all languages and update captions of the reference *** */
8311: var_label:=i.name;
8312: var_button_label:=var_label;
8313: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
8314: WHERE intl_text_id=i.intl_text_id)
8315: LOOP
8316: var_label:=i.name;
8317: var_label:=get_Caption(i.name,l.localized_str,var_use_labels);

Line 8323: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8319: IF l.language=mCURRENT_LANG THEN
8320: var_button_label:=var_label;
8321: END IF;
8322:
8323: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8324: WHERE intl_text_id=var_screen_caption_id AND language=l.language;
8325: END LOOP;
8326:
8327: /* *** we use current refrenced UI ( not the latest referenced UI *** */

Line 8380: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS

8376: --
8377: -- update name and caption of element associated with a Reference --
8378: --
8379: var_label:=var_ref_name;
8380: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
8381: WHERE intl_text_id=var_ref_caption_id)
8382: LOOP
8383: var_label:=var_ref_name;
8384: var_label:=get_Caption(var_ref_name,l.localized_str);

Line 8389: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8385:
8386: IF l.language=mCURRENT_LANG THEN
8387: var_button_label:=var_label;
8388: END IF;
8389: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8390: WHERE intl_text_id=var_inst_caption_id AND language=l.language;
8391: END LOOP;
8392:
8393: EXCEPTION

Line 8758: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)

8754: END IF;
8755: END IF;
8756:
8757: FOR l IN(SELECT intl_text_id,language,localized_str
8758: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8759: LOOP
8760: var_label:=i.name;
8761: var_label:=get_Caption(i.name,l.localized_str);
8762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 8762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8758: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8759: LOOP
8760: var_label:=i.name;
8761: var_label:=get_Caption(i.name,l.localized_str);
8762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8763: WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
8764: AND language=l.language AND var_modified_flags=0;
8765:
8766: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 8766: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8762: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8763: WHERE intl_text_id IN(var_label_txt_id,var_parent_item_txt_id)
8764: AND language=l.language AND var_modified_flags=0;
8765:
8766: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8767: WHERE intl_text_id=var_tree_caption_id AND language=l.language;
8768: END LOOP;
8769:
8770: var_use_labels:=mUSE_LABELS;

Line 8815: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)

8811: -- which correlates with current BOM Option Class
8812: --
8813: IF x=1 THEN
8814: FOR m IN(SELECT intl_text_id,language,localized_str
8815: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8816: LOOP
8817: var_label:=i.name;
8818: var_label:=get_Caption(i.name,m.localized_str);
8819: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 8819: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8815: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8816: LOOP
8817: var_label:=i.name;
8818: var_label:=get_Caption(i.name,m.localized_str);
8819: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8820: WHERE intl_text_id=var_parent_item_txt_id AND language=m.language;
8821: END LOOP;
8822: END IF;
8823:

Line 8828: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)

8824: END IF;
8825: END IF;
8826:
8827: FOR l IN(SELECT intl_text_id,language,localized_str
8828: FROM CZ_LOCALIZED_TEXTS WHERE intl_text_id=i.intl_text_id)
8829: LOOP
8830: var_label:=i.name;
8831: var_label:=get_Caption(i.name,l.localized_str);
8832:

Line 8833: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix

8829: LOOP
8830: var_label:=i.name;
8831: var_label:=get_Caption(i.name,l.localized_str);
8832:
8833: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
8834: WHERE intl_text_id=t_bom_pages(x).label_txt_id AND language=l.language
8835: AND var_modified_flags=0;
8836:
8837: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix

Line 8837: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix

8833: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
8834: WHERE intl_text_id=t_bom_pages(x).label_txt_id AND language=l.language
8835: AND var_modified_flags=0;
8836:
8837: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
8838: WHERE intl_text_id=t_bom_pages(x).tree_label_id AND language=l.language;
8839:
8840: IF x=1 THEN
8841: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 8841: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8837: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label||var_suffix
8838: WHERE intl_text_id=t_bom_pages(x).tree_label_id AND language=l.language;
8839:
8840: IF x=1 THEN
8841: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8842: WHERE intl_text_id=var_parent_item_txt_id AND language=l.language;
8843: END IF;
8844:
8845: END LOOP;

Line 8884: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS

8880:
8881: /* *** go through all languages and update captions of the reference *** */
8882: var_label:=i.name;
8883: var_button_label:=var_label;
8884: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
8885: WHERE intl_text_id=i.intl_text_id)
8886: LOOP
8887: var_label:=i.name;
8888: var_label:=get_Caption(i.name,l.localized_str);

Line 8889: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8885: WHERE intl_text_id=i.intl_text_id)
8886: LOOP
8887: var_label:=i.name;
8888: var_label:=get_Caption(i.name,l.localized_str);
8889: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8890: WHERE intl_text_id=var_text_label_caption_id AND language=l.language
8891: AND var_modified_flags=0;
8892:
8893: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 8893: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

8889: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
8890: WHERE intl_text_id=var_text_label_caption_id AND language=l.language
8891: AND var_modified_flags=0;
8892:
8893: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
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);

Line 9003: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a

8999: END IF;
9000:
9001: /* *** go through all languages and update captions *** */
9002: var_label:=i.name;
9003: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
9004: WHERE a.intl_text_id=i.intl_text_id)
9005:
9006: LOOP
9007: var_label:=i.name;

Line 9010: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

9006: LOOP
9007: var_label:=i.name;
9008: var_label:=get_Caption(i.name,l.localized_str);
9009:
9010: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
9011: WHERE intl_text_id=var_text_label_caption_id AND language=l.language
9012: AND var_modified_flags=0;
9013:
9014: IF l.language=mCURRENT_LANG THEN

Line 9048: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a

9044: NULL;
9045: END;
9046:
9047: var_label:=i.name;
9048: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
9049: WHERE a.intl_text_id=i.intl_text_id)
9050: LOOP
9051: var_label:=i.name;
9052: IF var_use_labels='0' THEN

Line 9061: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

9057: var_label:=i.name||mCONCAT_SYMBOL||l.localized_str;
9058: END IF;
9059:
9060:
9061: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
9062: WHERE intl_text_id=var_screen_caption_id AND language=l.language;
9063:
9064: END LOOP;
9065:

Line 9090: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS

9086: END IF;
9087:
9088: /* *** go through all languages and update captions *** */
9089: var_label:=i.name;
9090: FOR l IN(SELECT intl_text_id,language,localized_str FROM CZ_LOCALIZED_TEXTS
9091: WHERE intl_text_id=i.intl_text_id)
9092: LOOP
9093: var_label:=i.name;
9094: var_label:=get_Caption(i.name,l.localized_str);

Line 9096: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

9092: LOOP
9093: var_label:=i.name;
9094: var_label:=get_Caption(i.name,l.localized_str);
9095:
9096: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
9097: WHERE intl_text_id=var_text_label_caption_id AND language=l.language
9098: AND var_modified_flags=0;
9099:
9100: /* *** for now don't change width of label ***

Line 9194: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=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
9194: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=m.name
9195: WHERE intl_text_id=var_option_caption_id;
9196: END IF;
9197:
9198: END IF;

Line 9201: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a

9197:
9198: END IF;
9199:
9200: var_label:=m.name;
9201: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
9202: WHERE a.intl_text_id=m.intl_text_id)
9203: LOOP
9204: var_label:=get_Caption(m.name,l.localized_str,var_use_labels);
9205: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

Line 9205: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label

9201: FOR l IN(SELECT a.intl_text_id,a.language,a.localized_str FROM CZ_LOCALIZED_TEXTS a
9202: WHERE a.intl_text_id=m.intl_text_id)
9203: LOOP
9204: var_label:=get_Caption(m.name,l.localized_str,var_use_labels);
9205: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_label
9206: WHERE intl_text_id=var_option_caption_id AND language=l.language;
9207: END LOOP;
9208:
9209: ELSE

Line 9828: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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

Line 9836: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=localized_str||var_suffix

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
9837: WHERE intl_text_id=var_temp AND var_modified_flag=0;
9838:
9839: EXCEPTION
9840: WHEN OTHERS THEN

Line 10241: FROM CZ_UI_NODES a,CZ_PS_NODES b, CZ_LOCALIZED_TEXTS c

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)

Line 10258: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_name

10254: var_name:=i.name||mCONCAT_SYMBOL||i.localized_str;
10255: ELSIF in_use_labels='4' THEN
10256: var_keep_it:='1';
10257: END IF;
10258: UPDATE CZ_LOCALIZED_TEXTS SET localized_str=var_name
10259: WHERE intl_text_id=i.caption_id AND language=i.language AND var_keep_it='0';
10260: END LOOP;
10261: END update_Labels;
10262: