DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_LOCALIZED_TEXTS_VL

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;