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.JTF_FM_UTL_V dependencies on FND_LOBS

Line 86: -- p_file_id : File id in FND_LOBS

82: -- PURPOSE
83: -- Confirm whether a file is an RTF file or not
84: --
85: -- PARAMETERS
86: -- p_file_id : File id in FND_LOBS
87: -- RETURNS
88: -- True : If the file is an RTF file
89: -- False : If the file is not an RTF file
90:

Line 107: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;

103:
104: G_MIME_TBL JTF_VARCHAR2_TABLE_100:= JTF_VARCHAR2_TABLE_100('APPLICATION/RTF', 'APPLICATION/X-RTF', 'TEXT/RICHTEXT','APPLICATION/PDF', 'APPLICATION/OCTET-STREAM' );
105:
106: BEGIN
107: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;
108: IF((UPPER(l_file_content_type) = G_MIME_TBL(1)) OR (UPPER(l_file_content_type) = G_MIME_TBL(2)) OR
109: (UPPER(l_file_content_type) = G_MIME_TBL(3)) OR
110: ((UPPER(l_file_content_type) = G_MIME_TBL(5)) AND (UPPER(Substr(l_file_name,INSTR(l_file_name,'.',1,1))) = '.RTF')) )
111: THEN

Line 132: -- p_file_id : File id in FND_LOBS

128: -- PURPOSE
129: -- Confirm whether a file is an PDF file or not
130: --
131: -- PARAMETERS
132: -- p_file_id : File id in FND_LOBS
133: -- RETURNS
134: -- True : If the file is an PDF file
135: -- False : If the file is not an PDF file
136: ---------------------------------------------------------------------

Line 149: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;

145: l_file_content_type VARCHAR2(30);
146: G_MIME_TBL JTF_VARCHAR2_TABLE_100:= JTF_VARCHAR2_TABLE_100('APPLICATION/PDF', 'APPLICATION/OCTET-STREAM' );
147:
148: BEGIN
149: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;
150: IF( (UPPER(l_file_content_type) = G_MIME_TBL(1)) OR
151: ((UPPER(l_file_content_type) = G_MIME_TBL(2)) AND (UPPER(Substr(l_file_name,INSTR(l_file_name,'.',1,1))) = '.PDF')))
152: THEN
153: return true;

Line 173: -- p_file_id : File id in FND_LOBS

169: -- PURPOSE
170: -- Confirm whether a file is an HTML or Text File
171: --
172: -- PARAMETERS
173: -- p_file_id : File id in FND_LOBS
174: -- RETURNS
175: -- True : If the file is an HTML file or Text file
176: -- False : If the file is not an HTML file or Text file
177: ------------------------------------------------------------------------

Line 189: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;

185: l_file_content_type VARCHAR2(30);
186: G_MIME_TBL JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100('TEXT/HTML', 'TEXT/PLAIN','TEXT/TEXT','APPLICATION/OCTET-STREAM');
187:
188: BEGIN
189: SELECT file_name,file_content_type INTO l_file_name, l_file_content_type FROM fnd_lobs WHERE file_id = p_file_id;
190: IF( (INSTR(UPPER(l_file_content_type),G_MIME_TBL(1))>0) OR
191: (INSTR(UPPER(l_file_content_type), G_MIME_TBL(2))>0) OR (INSTR(UPPER(l_file_content_type), G_MIME_TBL(3))>0)
192: OR ((UPPER(l_file_content_type) = G_MIME_TBL(4))
193: AND ((UPPER(Substr(l_file_name,INSTR(l_file_name,'.',1,1))) = '.TXT') OR (INSTR(UPPER(Substr(l_file_name,INSTR(l_file_name,'.',1,1))),'.HTM')>0))))