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_PREVIEW_PVT dependencies on IBC_CITEM_VERSIONS_TL

Line 89: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;

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;
91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
92: l_attachment_file_id NUMBER;
93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

Line 90: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%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;
91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
92: l_attachment_file_id NUMBER;
93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
94: l_attribute_file_id NUMBER;

Line 91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_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;
91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
92: l_attachment_file_id NUMBER;
93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
94: l_attribute_file_id NUMBER;
95: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

Line 93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;

89: l_content_item_name IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME%TYPE;
90: l_description IBC_CITEM_VERSIONS_TL.DESCRIPTION%TYPE;
91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
92: l_attachment_file_id NUMBER;
93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
94: l_attribute_file_id NUMBER;
95: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
96:
97: l_comp_content_item_id NUMBER;

Line 95: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;

91: l_attachment_attribute_code IBC_CITEM_VERSIONS_TL.ATTACHMENT_ATTRIBUTE_CODE%TYPE;
92: l_attachment_file_id NUMBER;
93: l_attachment_file_name IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME%TYPE;
94: l_attribute_file_id NUMBER;
95: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
96:
97: l_comp_content_item_id NUMBER;
98: l_comp_citem_version_id NUMBER;
99: l_comp_citem_version_number NUMBER;

Line 119: from IBC_CITEM_VERSIONS_TL

115:
116: CURSOR Get_Citem_Meta_Csr IS
117: select ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
118: ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
119: from IBC_CITEM_VERSIONS_TL
120: where citem_version_id = p_citem_version_id
121: and language = nvl(p_lang_code, userenv('LANG'));
122:
123: