APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_LOCALIZED_TEXTS

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

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

Line 608: INSERT INTO CZ_LOCALIZED_TEXTS

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

Line 632: FROM CZ_LOCALIZED_TEXTS

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

Line 1831: UPDATE cz_localized_texts

1827: END IF;
1828:
1829: IF (i.reason_type IN (0,1) ) THEN
1830: BEGIN
1831: UPDATE cz_localized_texts
1832: SET localized_str=REPLACE(localized_str, i.NAME, i.NAME||'-'||TO_CHAR(l_new_rule_id))
1833: WHERE intl_text_id = l_new_reason_id;
1834: EXCEPTION
1835: WHEN OTHERS THEN

Line 1842: UPDATE cz_localized_texts

1838: END IF;
1839:
1840: IF (i.unsatisfied_msg_source IN (0,1)) THEN
1841: BEGIN
1842: UPDATE cz_localized_texts
1843: SET localized_str=REPLACE(localized_str, i.NAME, i.NAME||'-'||TO_CHAR(l_new_rule_id))
1844: WHERE intl_text_id = l_new_unsatisfied_msg_id;
1845: EXCEPTION
1846: WHEN OTHERS THEN

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

2969: IF((i.ps_node_type >= BOM_MODEL_TYPE AND p_label_bom = OPTION_VALUE_LABEL_DESC) OR
2970: (i.ps_node_type < BOM_MODEL_TYPE AND p_label_nonbom = OPTION_VALUE_LABEL_DESC))THEN
2971:
2972: BEGIN
2973: SELECT text_str INTO l_name FROM cz_localized_texts_vl WHERE intl_text_id = i.intl_text_id;
2974: l_name := NVL(l_name, i.name);
2975: EXCEPTION
2976: WHEN NO_DATA_FOUND THEN
2977: l_name := i.name;

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

3034:
3035: IF(v_intl_text_id IS NOT NULL)THEN
3036:
3037: BEGIN
3038: SELECT text_str INTO v_description FROM cz_localized_texts_vl WHERE intl_text_id = v_intl_text_id;
3039: EXCEPTION
3040: WHEN NO_DATA_FOUND THEN
3041: NULL;
3042: END;

Line 4015: UPDATE CZ_LOCALIZED_TEXTS

4011: UPDATE CZ_RULES
4012: SET deleted_flag = '1'
4013: WHERE ui_def_id = p_ui_def_id;
4014:
4015: UPDATE CZ_LOCALIZED_TEXTS
4016: SET deleted_flag = '1'
4017: WHERE ui_def_id = p_ui_def_id;
4018:
4019: UPDATE CZ_UI_ACTIONS

Line 4926: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;

4922: l_api_name CONSTANT VARCHAR2(30) := 'copy_property';
4923: INVALID_PROPERTY_ID_EXCP EXCEPTION;
4924: USER_IS_NULL_EXCP EXCEPTION;
4925: l_name cz_rp_entries.name%TYPE;
4926: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;
4927: l_text_id NUMBER;
4928:
4929: BEGIN
4930: