APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_LOCALIZED_TEXTS

Line 602: FOR i IN(SELECT intl_text_id,language,localized_str,source_lang FROM CZ_LOCALIZED_TEXTS

598: END IF;
599:
600: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
601:
602: FOR i IN(SELECT intl_text_id,language,localized_str,source_lang FROM CZ_LOCALIZED_TEXTS
603: WHERE intl_text_id=p_intl_text_id AND deleted_flag='0')
604: LOOP
605: INSERT INTO CZ_LOCALIZED_TEXTS
606: (INTL_TEXT_ID,

Line 605: INSERT INTO CZ_LOCALIZED_TEXTS

601:
602: FOR i IN(SELECT intl_text_id,language,localized_str,source_lang FROM CZ_LOCALIZED_TEXTS
603: WHERE intl_text_id=p_intl_text_id AND deleted_flag='0')
604: LOOP
605: INSERT INTO CZ_LOCALIZED_TEXTS
606: (INTL_TEXT_ID,
607: LOCALIZED_STR,
608: LANGUAGE,
609: SOURCE_LANG,

Line 629: FROM CZ_LOCALIZED_TEXTS

625: UI_DEF_ID,
626: MODEL_ID,
627: l_new_intl_text_id,
628: '0'
629: FROM CZ_LOCALIZED_TEXTS
630: WHERE intl_text_id=p_intl_text_id AND
631: language=i.LANGUAGE AND
632: source_lang=i.SOURCE_LANG AND deleted_flag='0';
633: l_counter := l_counter + 1;

Line 1803: UPDATE cz_localized_texts

1799: END IF;
1800:
1801: IF (i.reason_type IN (0,1) ) THEN
1802: BEGIN
1803: UPDATE cz_localized_texts
1804: SET localized_str=REPLACE(localized_str, i.NAME, i.NAME||'-'||TO_CHAR(l_new_rule_id))
1805: WHERE intl_text_id = l_new_reason_id;
1806: EXCEPTION
1807: WHEN OTHERS THEN

Line 1814: UPDATE cz_localized_texts

1810: END IF;
1811:
1812: IF (i.unsatisfied_msg_source IN (0,1)) THEN
1813: BEGIN
1814: UPDATE cz_localized_texts
1815: SET localized_str=REPLACE(localized_str, i.NAME, i.NAME||'-'||TO_CHAR(l_new_rule_id))
1816: WHERE intl_text_id = l_new_unsatisfied_msg_id;
1817: EXCEPTION
1818: WHEN OTHERS THEN

Line 2945: SELECT text_str INTO l_name FROM cz_localized_texts_vl WHERE intl_text_id = i.intl_text_id;

2941: IF((i.ps_node_type >= BOM_MODEL_TYPE AND p_label_bom = OPTION_VALUE_LABEL_DESC) OR
2942: (i.ps_node_type < BOM_MODEL_TYPE AND p_label_nonbom = OPTION_VALUE_LABEL_DESC))THEN
2943:
2944: BEGIN
2945: SELECT text_str INTO l_name FROM cz_localized_texts_vl WHERE intl_text_id = i.intl_text_id;
2946: l_name := NVL(l_name, i.name);
2947: EXCEPTION
2948: WHEN NO_DATA_FOUND THEN
2949: l_name := i.name;

Line 3010: SELECT text_str INTO v_description FROM cz_localized_texts_vl WHERE intl_text_id = v_intl_text_id;

3006:
3007: IF(v_intl_text_id IS NOT NULL)THEN
3008:
3009: BEGIN
3010: SELECT text_str INTO v_description FROM cz_localized_texts_vl WHERE intl_text_id = v_intl_text_id;
3011: EXCEPTION
3012: WHEN NO_DATA_FOUND THEN
3013: NULL;
3014: END;

Line 3987: UPDATE CZ_LOCALIZED_TEXTS

3983: UPDATE CZ_RULES
3984: SET deleted_flag = '1'
3985: WHERE ui_def_id = p_ui_def_id;
3986:
3987: UPDATE CZ_LOCALIZED_TEXTS
3988: SET deleted_flag = '1'
3989: WHERE ui_def_id = p_ui_def_id;
3990:
3991: UPDATE CZ_UI_ACTIONS

Line 4897: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;

4893: l_api_name CONSTANT VARCHAR2(30) := 'copy_property';
4894: INVALID_PROPERTY_ID_EXCP EXCEPTION;
4895: USER_IS_NULL_EXCP EXCEPTION;
4896: l_name cz_rp_entries.name%TYPE;
4897: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;
4898: l_text_id NUMBER;
4899:
4900: BEGIN
4901: