APPS.IBC_CITEM_RUNTIME_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

	select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, WD_RESTRICTED_FLAG, LIVE_CITEM_VERSION_ID,
	       CONTENT_ITEM_STATUS, ENCRYPT_FLAG, PARENT_ITEM_ID
	from IBC_CONTENT_ITEMS
	where content_item_id = p_content_item_id;

Line: 127

	select START_DATE, END_DATE, VERSION_NUMBER
	from IBC_CITEM_VERSIONS_B
	where CITEM_VERSION_ID = p_citem_version_id;

Line: 207

	select citem_version_id
	from IBC_CITEM_VERSION_LABELS
	where label_code = p_label_code and
	      content_item_id = p_content_item_id;

Line: 214

	select CITEM_TRANSLATION_STATUS, CONTENT_ITEM_NAME, DESCRIPTION, DEFAULT_RENDITION_MIME_TYPE,
	       ATTACHMENT_FILE_NAME, ATTACHMENT_FILE_ID
	from IBC_CITEM_VERSIONS_TL
        where citem_version_id = l_citem_version_id
        and language = userenv('LANG');

Line: 222

	select t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.DEFAULT_RENDITION_MIME_TYPE,
	       t.ATTACHMENT_FILE_NAME, t.ATTACHMENT_FILE_ID
	from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
	where i.CONTENT_ITEM_ID = p_content_item_id
	and t.citem_version_id = l_citem_version_id
	and t.language = i.BASE_LANGUAGE;

Line: 230

	SELECT NVL(DESCRIPTION, MEANING)
	FROM FND_LOOKUP_VALUES
	WHERE LOOKUP_TYPE = IBC_UTILITIES_PVT.G_REND_LOOKUP_TYPE
	AND LANGUAGE = userenv('LANG')
	AND LOOKUP_CODE = l_default_mime_type;

Line: 400

	select citem_version_id
	from IBC_CITEM_VERSION_LABELS
	where label_code = p_label_code and
	content_item_id = p_content_item_id;

Line: 406

	select START_DATE, END_DATE, VERSION_NUMBER
	from IBC_CITEM_VERSIONS_B
	where CITEM_VERSION_ID = l_citem_version_id;

Line: 412

	select CITEM_TRANSLATION_STATUS, ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
	       ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
	from IBC_CITEM_VERSIONS_TL
        where citem_version_id = l_citem_version_id
        and language = nvl(p_lang_code, userenv('LANG'));

Line: 420

	select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
	       t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
	from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
	where i.CONTENT_ITEM_ID = p_content_item_id
	and t.citem_version_id = l_citem_version_id
	and t.language = i.BASE_LANGUAGE;

Line: 428

	select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG
	from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
	where r.CITEM_VERSION_ID = l_citem_version_id
	and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
	order by r.SORT_ORDER;

Line: 616

		-- update max num levels
		IF (x_num_levels_loaded > l_max_num_levels_loaded) THEN
		   l_max_num_levels_loaded := x_num_levels_loaded;

Line: 685

	select LANGUAGE
	from IBC_CITEM_VERSIONS_TL
	where CITEM_VERSION_ID = l_citem_version_id
	and LANGUAGE = SOURCE_LANG;

Line: 797

	   --select IBC_TEST_CLOB2_S.NEXTVAL INTO l_id from DUAL;

Line: 800

	   --FROM IBC_TEST_CLOB WHERE ID = l_id for update;

Line: 860

	select citem_version_id
	from IBC_CITEM_VERSION_LABELS
	where label_code = p_label_code and
	      content_item_id = p_content_item_id;

Line: 866

	select VERSION_NUMBER
	from IBC_CITEM_VERSIONS_B
        where citem_version_id = l_citem_version_id;

Line: 961

	select CONTENT_ITEM_ID
	from IBC_ASSOCIATIONS
	where ASSOCIATION_TYPE_CODE = p_association_type_code
        and ASSOCIATED_OBJECT_VAL1 = p_associated_object_val1
	and NVL(ASSOCIATED_OBJECT_VAL2, '0') = NVL(p_associated_object_val2, '0')
	and NVL(ASSOCIATED_OBJECT_VAL3, '0') = NVL(p_associated_object_val3, '0')
	and NVL(ASSOCIATED_OBJECT_VAL4, '0') = NVL(p_associated_object_val4, '0')
	and NVL(ASSOCIATED_OBJECT_VAL5, '0') = NVL(p_associated_object_val5, '0');

Line: 1069

	select START_DATE, END_DATE, VERSION_NUMBER
	from IBC_CITEM_VERSIONS_B
	where CITEM_VERSION_ID =p_citem_version_id;

Line: 1075

	select CITEM_TRANSLATION_STATUS, ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
	       ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
	from IBC_CITEM_VERSIONS_TL
        where citem_version_id =p_citem_version_id
        and language = nvl(p_lang_code, userenv('LANG'));

Line: 1083

	select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
	       t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
	from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
	where i.CONTENT_ITEM_ID = p_content_item_id
	and t.citem_version_id = p_citem_version_id
	and t.language = i.BASE_LANGUAGE;

Line: 1091

	select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG,
               nvl(SUBITEM_VERSION_ID, nvl(LIVE_CITEM_VERSION_ID, (select max(VERSION_NUMBER) from IBC_CITEM_VERSIONS_B where CONTENT_ITEM_ID = r.CONTENT_ITEM_ID))) child_version_id
	from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
	where r.CITEM_VERSION_ID =p_citem_version_id
	and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
	order by r.SORT_ORDER;

Line: 1257

		-- update max num levels
		IF (x_num_levels_loaded > l_max_num_levels_loaded) THEN
		   l_max_num_levels_loaded := x_num_levels_loaded;