DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_LOCALIZED_TEXTS_VL

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;