DBA Data[Home] [Help]

APPS.IBC_UTILITIES_PVT dependencies on FND_LOOKUP_VALUES

Line 362: l_rendition_name FND_LOOKUP_VALUES.DESCRIPTION%TYPE;

358: l_item_label VARCHAR2(120) := '';
359:
360: l_rendition_counter NUMBER := 1;
361: l_mime_type IBC_RENDITIONS.MIME_TYPE%TYPE;
362: l_rendition_name FND_LOOKUP_VALUES.DESCRIPTION%TYPE;
363: --
364: --// p_lang_code has taken translation approval into account
365: CURSOR Get_Renditions IS
366: SELECT file_id, file_name, mime_type, language

Line 374: FROM FND_LOOKUP_VALUES

370:
371: --// p_lang_code has taken translation approval into account
372: CURSOR Get_Rendition_Name IS
373: SELECT NVL(DESCRIPTION, MEANING)
374: FROM FND_LOOKUP_VALUES
375: WHERE LOOKUP_TYPE = Ibc_Utilities_Pvt.G_REND_LOOKUP_TYPE
376: AND LANGUAGE = NVL(p_lang_code, USERENV('LANG'))
377: AND LOOKUP_CODE = l_mime_type;
378: BEGIN