APPS.IBC_CITEM_PREVIEW_PVT dependencies on IBC_CONTENT_ITEMS

Line 85: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;

81: ) AS
82: l_version_number NUMBER;
83: l_start_date DATE;
84: l_end_date DATE;
85: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
86: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
87: l_encrypt_flag VARCHAR2(1);
88:
89: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;

Line 86: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;

82: l_version_number NUMBER;
83: l_start_date DATE;
84: l_end_date DATE;
85: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
86: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
87: l_encrypt_flag VARCHAR2(1);
88:
89: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
90: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

Line 108: from IBC_CONTENT_ITEMS

104: l_max_num_levels_loaded NUMBER := 0;
105: --
106: CURSOR Get_Citem IS
107: select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, ENCRYPT_FLAG
108: from IBC_CONTENT_ITEMS
109: where content_item_id = p_content_item_id;
110:
111: CURSOR Get_Version IS
112: select VERSION_NUMBER, START_DATE, END_DATE

Line 127: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

123:
124: CURSOR Get_Compound_Item_Ref IS
125: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID,
126: r.SUBITEM_VERSION_ID, c.ENCRYPT_FLAG
127: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
128: where r.CITEM_VERSION_ID = p_citem_version_id
129: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
130: order by r.SORT_ORDER;
131: