113:
114: IF p_mime_type IS NULL THEN
115: SELECT default_rendition_mime_type
116: INTO l_mime_type
117: FROM ibc_citem_versions_tl
118: WHERE citem_version_id = l_citem_ver_id
119: AND language = l_language;
120: ELSE
121: l_mime_type := p_mime_type;
227: p_language VARCHAR2)
228: IS
229: SELECT MAX(civtl.content_item_name)
230: FROM ibc_citem_versions_b civb,
231: ibc_citem_versions_tl civtl
232: WHERE civb.content_item_id = p_content_item_id
233: AND civb.citem_version_id = civtl.citem_version_id
234: AND language = p_language;
235:
370: p_language VARCHAR2)
371: IS
372: SELECT MAX(civtl.content_item_name)
373: FROM ibc_citem_versions_b civb,
374: ibc_citem_versions_tl civtl
375: WHERE civb.content_item_id = p_content_item_id
376: AND civb.citem_version_id = civtl.citem_version_id
377: AND language = p_language;
378: