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.FND_MIME_TYPES_PKG dependencies on FND_MIME_TYPES_TL

Line 16: cursor C is select ROWID from FND_MIME_TYPES_TL

12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER,
14: X_ALLOW_CLIENT_ENCODING in VARCHAR2
15: ) is
16: cursor C is select ROWID from FND_MIME_TYPES_TL
17: where FILE_FORMAT_CODE = X_FILE_FORMAT_CODE
18: and MIME_TYPE = X_MIME_TYPE
19: and LANGUAGE = userenv('LANG')
20: ;

Line 22: insert into FND_MIME_TYPES_TL (

18: and MIME_TYPE = X_MIME_TYPE
19: and LANGUAGE = userenv('LANG')
20: ;
21: begin
22: insert into FND_MIME_TYPES_TL (
23: DESCRIPTION,
24: LAST_UPDATE_LOGIN,
25: FILE_FORMAT_CODE,
26: MIME_TYPE,

Line 50: from FND_MIME_TYPES_TL T

46: from FND_LANGUAGES L
47: where L.INSTALLED_FLAG in ('I', 'B')
48: and not exists
49: (select NULL
50: from FND_MIME_TYPES_TL T
51: where T.FILE_FORMAT_CODE = X_FILE_FORMAT_CODE
52: and T.MIME_TYPE = X_MIME_TYPE
53: and T.LANGUAGE = L.LANGUAGE_CODE);
54:

Line 73: from FND_MIME_TYPES_TL

69: ) is
70: cursor c1 is select
71: DESCRIPTION,
72: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
73: from FND_MIME_TYPES_TL
74: where FILE_FORMAT_CODE = X_FILE_FORMAT_CODE
75: and MIME_TYPE = X_MIME_TYPE
76: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
77: for update of FILE_FORMAT_CODE nowait;

Line 104: update FND_MIME_TYPES_TL set

100: X_LAST_UPDATE_LOGIN in NUMBER,
101: X_ALLOW_CLIENT_ENCODING in VARCHAR2
102: ) is
103: begin
104: update FND_MIME_TYPES_TL set
105: DESCRIPTION = X_DESCRIPTION,
106: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
107: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
108: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 120: update FND_MIME_TYPES_TL SET

116: -- make sure that ALLOW_CLIENT_ENCODING is updated for
117: -- all languages.
118: -- (This column should not be in a TL table)
119: -- Bug 4171265
120: update FND_MIME_TYPES_TL SET
121: ALLOW_CLIENT_ENCODING = X_ALLOW_CLIENT_ENCODING
122: where FILE_FORMAT_CODE = X_FILE_FORMAT_CODE
123: and MIME_TYPE = X_MIME_type;
124:

Line 135: delete from FND_MIME_TYPES_TL

131: X_FILE_FORMAT_CODE in VARCHAR2,
132: X_MIME_TYPE in VARCHAR2
133: ) is
134: begin
135: delete from FND_MIME_TYPES_TL
136: where FILE_FORMAT_CODE = X_FILE_FORMAT_CODE
137: and MIME_TYPE = X_MIME_TYPE;
138:
139: if (sql%notfound) then

Line 154: update FND_MIME_TYPES_TL T set (

150: /* as a quick workaround to fix the time-consuming table handler issue */
151: /* Eventually we'll need to turn them into a separate fix_language procedure */
152: /*
153:
154: update FND_MIME_TYPES_TL T set (
155: DESCRIPTION
156: ) = (select
157: B.DESCRIPTION
158: from FND_MIME_TYPES_TL B

Line 158: from FND_MIME_TYPES_TL B

154: update FND_MIME_TYPES_TL T set (
155: DESCRIPTION
156: ) = (select
157: B.DESCRIPTION
158: from FND_MIME_TYPES_TL B
159: where B.FILE_FORMAT_CODE = T.FILE_FORMAT_CODE
160: and B.MIME_TYPE = T.MIME_TYPE
161: and B.LANGUAGE = T.SOURCE_LANG)
162: where (

Line 170: from FND_MIME_TYPES_TL SUBB, FND_MIME_TYPES_TL SUBT

166: ) in (select
167: SUBT.FILE_FORMAT_CODE,
168: SUBT.MIME_TYPE,
169: SUBT.LANGUAGE
170: from FND_MIME_TYPES_TL SUBB, FND_MIME_TYPES_TL SUBT
171: where SUBB.FILE_FORMAT_CODE = SUBT.FILE_FORMAT_CODE
172: and SUBB.MIME_TYPE = SUBT.MIME_TYPE
173: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
174: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 180: insert into FND_MIME_TYPES_TL (

176: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
177: ));
178: */
179:
180: insert into FND_MIME_TYPES_TL (
181: DESCRIPTION,
182: LAST_UPDATE_LOGIN,
183: FILE_FORMAT_CODE,
184: MIME_TYPE,

Line 204: from FND_MIME_TYPES_TL B, FND_LANGUAGES L

200: B.LAST_UPDATE_DATE,
201: L.LANGUAGE_CODE,
202: B.SOURCE_LANG,
203: B.ALLOW_CLIENT_ENCODING
204: from FND_MIME_TYPES_TL B, FND_LANGUAGES L
205: where L.INSTALLED_FLAG in ('I', 'B')
206: and B.LANGUAGE = userenv('LANG')
207: and not exists
208: (select NULL

Line 209: from FND_MIME_TYPES_TL T

205: where L.INSTALLED_FLAG in ('I', 'B')
206: and B.LANGUAGE = userenv('LANG')
207: and not exists
208: (select NULL
209: from FND_MIME_TYPES_TL T
210: where T.FILE_FORMAT_CODE = B.FILE_FORMAT_CODE
211: and T.MIME_TYPE = B.MIME_TYPE
212: and T.LANGUAGE = L.LANGUAGE_CODE);
213: end ADD_LANGUAGE;

Line 275: from fnd_mime_types_tl

271: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
272:
273: select last_updated_by, last_update_date
274: into db_luby, db_ludate
275: from fnd_mime_types_tl
276: where file_format_code = X_FILE_FORMAT_CODE
277: and mime_type = X_MIME_TYPE
278: and language = userenv('LANG');
279:

Line 283: update fnd_mime_types_tl set

279:
280: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
281: db_ludate, X_CUSTOM_MODE)) then
282:
283: update fnd_mime_types_tl set
284: description = nvl(X_DESCRIPTION, description),
285: source_lang = userenv('LANG'),
286: last_updated_by = f_luby,
287: last_update_date = f_ludate,

Line 324: from fnd_mime_types_tl

320: begin
321:
322: select last_updated_by, last_update_date
323: into db_luby, db_ludate
324: from fnd_mime_types_tl
325: where file_format_code = X_FILE_FORMAT_CODE
326: and mime_type = X_MIME_TYPE
327: and language = userenv('LANG');
328: