eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_RUNTIME_PVT dependencies on IBC_CITEM_VERSIONS_TL

Line 202: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

198: x_msg_data OUT NOCOPY VARCHAR2
199: ) AS
200: l_live_citem_version_id NUMBER;
201: l_citem_version_id NUMBER;
202: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
203: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
204: --
205: -- // retrieve the labeled version id
206: CURSOR Get_Citem_Ver_By_Label IS

Line 203: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;

199: ) AS
200: l_live_citem_version_id NUMBER;
201: l_citem_version_id NUMBER;
202: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
203: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
204: --
205: -- // retrieve the labeled version id
206: CURSOR Get_Citem_Ver_By_Label IS
207: select citem_version_id

Line 216: from IBC_CITEM_VERSIONS_TL

212: -- // retrieve the session language version translation
213: CURSOR Get_Citem_Meta_Csr IS
214: select CITEM_TRANSLATION_STATUS, CONTENT_ITEM_NAME, DESCRIPTION, DEFAULT_RENDITION_MIME_TYPE,
215: ATTACHMENT_FILE_NAME, ATTACHMENT_FILE_ID
216: from IBC_CITEM_VERSIONS_TL
217: where citem_version_id = l_citem_version_id
218: and language = userenv('LANG');
219:
220: -- // retrieve the based language version translation

Line 224: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

220: -- // retrieve the based language version translation
221: CURSOR Get_Citem_Meta_BLang IS
222: select t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.DEFAULT_RENDITION_MIME_TYPE,
223: t.ATTACHMENT_FILE_NAME, t.ATTACHMENT_FILE_ID
224: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
225: where i.CONTENT_ITEM_ID = p_content_item_id
226: and t.citem_version_id = l_citem_version_id
227: and t.language = i.BASE_LANGUAGE;
228:

Line 382: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;

378: l_version_number NUMBER;
379: l_start_date DATE;
380: l_end_date DATE;
381:
382: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
383: l_lang_code VARCHAR2(4);
384:
385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

Line 385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;

381:
382: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
383: l_lang_code VARCHAR2(4);
384:
385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
388: l_attachment_file_id NUMBER;
389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

Line 386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

382: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
383: l_lang_code VARCHAR2(4);
384:
385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
388: l_attachment_file_id NUMBER;
389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
390: l_attribute_file_id NUMBER;

Line 387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;

383: l_lang_code VARCHAR2(4);
384:
385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
388: l_attachment_file_id NUMBER;
389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
390: l_attribute_file_id NUMBER;
391: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

Line 389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

385: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
386: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
388: l_attachment_file_id NUMBER;
389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
390: l_attribute_file_id NUMBER;
391: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
392:
393: l_comp_content_item_id NUMBER;

Line 391: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

387: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
388: l_attachment_file_id NUMBER;
389: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
390: l_attribute_file_id NUMBER;
391: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
392:
393: l_comp_content_item_id NUMBER;
394: l_tmp_num_levels NUMBER;
395: l_has_component_items VARCHAR2(1) := FND_API.g_false;

Line 414: from IBC_CITEM_VERSIONS_TL

410: -- // retrieve citem version in the specified language
411: CURSOR Get_Citem_Meta_Csr IS
412: select CITEM_TRANSLATION_STATUS, ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
413: ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
414: from IBC_CITEM_VERSIONS_TL
415: where citem_version_id = l_citem_version_id
416: and language = nvl(p_lang_code, userenv('LANG'));
417:
418: -- // retrieve the based language version translation

Line 422: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

418: -- // retrieve the based language version translation
419: CURSOR Get_Citem_Meta_BLang IS
420: select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
421: t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
422: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
423: where i.CONTENT_ITEM_ID = p_content_item_id
424: and t.citem_version_id = l_citem_version_id
425: and t.language = i.BASE_LANGUAGE;
426:

Line 686: from IBC_CITEM_VERSIONS_TL

682: l_citem_version_id NUMBER;
683: --
684: CURSOR Get_Translated_Langs IS
685: select LANGUAGE
686: from IBC_CITEM_VERSIONS_TL
687: where CITEM_VERSION_ID = l_citem_version_id
688: and LANGUAGE = SOURCE_LANG;
689:
690: BEGIN

Line 1056: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;

1052: l_version_number NUMBER;
1053: l_start_date DATE;
1054: l_end_date DATE;
1055:
1056: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1057: l_lang_code VARCHAR2(4);
1058:
1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

Line 1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;

1055:
1056: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1057: l_lang_code VARCHAR2(4);
1058:
1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1062: l_attachment_file_id NUMBER;
1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

Line 1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

1056: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1057: l_lang_code VARCHAR2(4);
1058:
1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1062: l_attachment_file_id NUMBER;
1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1064: l_attribute_file_id NUMBER;

Line 1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;

1057: l_lang_code VARCHAR2(4);
1058:
1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1062: l_attachment_file_id NUMBER;
1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1064: l_attribute_file_id NUMBER;
1065: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

Line 1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

1059: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1060: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1062: l_attachment_file_id NUMBER;
1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1064: l_attribute_file_id NUMBER;
1065: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
1066:
1067: l_comp_content_item_id NUMBER;

Line 1065: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

1061: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1062: l_attachment_file_id NUMBER;
1063: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1064: l_attribute_file_id NUMBER;
1065: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
1066:
1067: l_comp_content_item_id NUMBER;
1068: l_tmp_num_levels NUMBER;
1069: l_has_component_items VARCHAR2(1) := FND_API.g_false;

Line 1083: from IBC_CITEM_VERSIONS_TL

1079: -- // retrieve citem version in the specified language
1080: CURSOR Get_Citem_Meta_Csr IS
1081: select CITEM_TRANSLATION_STATUS, ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
1082: ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
1083: from IBC_CITEM_VERSIONS_TL
1084: where citem_version_id =p_citem_version_id
1085: and language = nvl(p_lang_code, userenv('LANG'));
1086:
1087: -- // retrieve the based language version translation

Line 1091: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

1087: -- // retrieve the based language version translation
1088: CURSOR Get_Citem_Meta_BLang IS
1089: select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
1090: t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
1091: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
1092: where i.CONTENT_ITEM_ID = p_content_item_id
1093: and t.citem_version_id = p_citem_version_id
1094: and t.language = i.BASE_LANGUAGE;
1095: