APPS.IBC_UTILITIES_PVT dependencies on IBC_CONTENT_ITEMS

Line 357: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE := '';

353: p_is_preview IN VARCHAR2,
354: p_xml_clob_loc IN OUT NOCOPY CLOB
355: ) AS
356: l_buffer VARCHAR2(9000);
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;

Line 621: FROM IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

617: l_item_label VARCHAR2(100) := '';
618: --
619: CURSOR Get_Compound_Item_Ref IS
620: SELECT r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG
621: FROM IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
622: WHERE r.CITEM_VERSION_ID = p_citem_version_id
623: AND r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
624: ORDER BY r.SORT_ORDER;
625: BEGIN

Line 668: FROM IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

664: l_component_version_id NUMBER;
665: --
666: CURSOR Get_Compound_Item_Ref IS
667: SELECT r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG
668: FROM IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
669: WHERE r.CITEM_VERSION_ID = p_citem_version_id
670: AND r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
671: ORDER BY r.SORT_ORDER;
672:

Line 1448: FROM ibc_content_items

1444: WHERE civb.citem_version_id = civtl.citem_version_id
1445: AND language = NVL(p_language, USERENV('lang'))
1446: AND civb.content_item_id <> NVL(p_chk_content_item_id, -1)
1447: AND EXISTS (SELECT 'X'
1448: FROM ibc_content_items
1449: WHERE directory_node_id = l_dir_node_id
1450: AND content_item_id = civb.content_item_id
1451: )
1452: AND UPPER(civtl.content_item_name) = UPPER(p_name)

Line 1477: FROM ibc_content_items

1473: WHERE child_dir_node_id = p_chk_dir_node_id;
1474: ELSIF p_chk_content_item_id IS NOT NULL THEN
1475: SELECT directory_node_id
1476: INTO l_dir_node_id
1477: FROM ibc_content_items
1478: WHERE content_item_id = p_chk_content_item_id;
1479: END IF;
1480: END IF;
1481: