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 1050: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;

1046: l_version_number NUMBER;
1047: l_start_date DATE;
1048: l_end_date DATE;
1049:
1050: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1051: l_lang_code VARCHAR2(4);
1052:
1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

Line 1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;

1049:
1050: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1051: l_lang_code VARCHAR2(4);
1052:
1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1056: l_attachment_file_id NUMBER;
1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

Line 1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;

1050: l_translation_status IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS%TYPE;
1051: l_lang_code VARCHAR2(4);
1052:
1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1056: l_attachment_file_id NUMBER;
1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1058: l_attribute_file_id NUMBER;

Line 1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;

1051: l_lang_code VARCHAR2(4);
1052:
1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1056: l_attachment_file_id NUMBER;
1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1058: l_attribute_file_id NUMBER;
1059: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

Line 1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

1053: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
1054: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1056: l_attachment_file_id NUMBER;
1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1058: l_attribute_file_id NUMBER;
1059: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
1060:
1061: l_comp_content_item_id NUMBER;

Line 1059: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

1055: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
1056: l_attachment_file_id NUMBER;
1057: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
1058: l_attribute_file_id NUMBER;
1059: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
1060:
1061: l_comp_content_item_id NUMBER;
1062: l_tmp_num_levels NUMBER;
1063: l_has_component_items VARCHAR2(1) := FND_API.g_false;

Line 1077: from IBC_CITEM_VERSIONS_TL

1073: -- // retrieve citem version in the specified language
1074: CURSOR Get_Citem_Meta_Csr IS
1075: select CITEM_TRANSLATION_STATUS, ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
1076: ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
1077: from IBC_CITEM_VERSIONS_TL
1078: where citem_version_id =p_citem_version_id
1079: and language = nvl(p_lang_code, userenv('LANG'));
1080:
1081: -- // retrieve the based language version translation

Line 1085: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

1081: -- // retrieve the based language version translation
1082: CURSOR Get_Citem_Meta_BLang IS
1083: select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
1084: t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
1085: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
1086: where i.CONTENT_ITEM_ID = p_content_item_id
1087: and t.citem_version_id = p_citem_version_id
1088: and t.language = i.BASE_LANGUAGE;
1089: