DBA Data[Home] [Help]

APPS.IBC_UTILITIES_PVT dependencies on IBC_RENDITIONS

Line 361: l_mime_type IBC_RENDITIONS.MIME_TYPE%TYPE;

357: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%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

Line 367: FROM IBC_RENDITIONS

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
367: FROM IBC_RENDITIONS
368: WHERE CITEM_VERSION_ID = p_citem_version_id
369: AND LANGUAGE = NVL(p_lang_code, USERENV('LANG'));
370:
371: --// p_lang_code has taken translation approval into account

Line 1259: IBC_RENDITIONS ren,

1255: SELECT rendition_id, citem.citem_version_id, citem.LANGUAGE,
1256: default_rendition_mime_type,
1257: attachment_file_id
1258: FROM
1259: IBC_RENDITIONS ren,
1260: ibc_citem_versions_tl citem
1261: WHERE
1262: citem.citem_version_id = ren.citem_version_id(+) AND
1263: citem.LANGUAGE = ren.LANGUAGE(+) AND

Line 1342: Ibc_Renditions_Pkg.LOAD_ROW (

1338: FOR i_rec IN CUR_CITEM_REN(l_citem_version_id)
1339:
1340: LOOP
1341:
1342: Ibc_Renditions_Pkg.LOAD_ROW (
1343: P_RENDITION_ID => i_rec.RENDITION_ID
1344: ,P_LANGUAGE => i_rec.LANGUAGE
1345: ,P_FILE_ID => i_rec.attachment_file_id
1346: ,P_FILE_NAME => NULL