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.FEM_VALUE_SETS_PKG dependencies on FEM_VALUE_SETS_TL

Line 55: insert into FEM_VALUE_SETS_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into FEM_VALUE_SETS_TL (
56: VALUE_SET_NAME,
57: DESCRIPTION,
58: CREATION_DATE,
59: CREATED_BY,

Line 81: from FEM_VALUE_SETS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from FEM_VALUE_SETS_TL T
82: where T.VALUE_SET_ID = X_VALUE_SET_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 124: from FEM_VALUE_SETS_TL

120: cursor c1 is select
121: VALUE_SET_NAME,
122: DESCRIPTION,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from FEM_VALUE_SETS_TL
125: where VALUE_SET_ID = X_VALUE_SET_ID
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of VALUE_SET_ID nowait;
128: begin

Line 203: update FEM_VALUE_SETS_TL set

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: update FEM_VALUE_SETS_TL set
204: VALUE_SET_NAME = X_VALUE_SET_NAME,
205: DESCRIPTION = X_DESCRIPTION,
206: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
207: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 222: delete from FEM_VALUE_SETS_TL

218: procedure DELETE_ROW (
219: X_VALUE_SET_ID in NUMBER
220: ) is
221: begin
222: delete from FEM_VALUE_SETS_TL
223: where VALUE_SET_ID = X_VALUE_SET_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 240: delete from FEM_VALUE_SETS_TL T

236:
237: procedure ADD_LANGUAGE
238: is
239: begin
240: delete from FEM_VALUE_SETS_TL T
241: where not exists
242: (select NULL
243: from FEM_VALUE_SETS_B B
244: where B.VALUE_SET_ID = T.VALUE_SET_ID

Line 247: update FEM_VALUE_SETS_TL T set (

243: from FEM_VALUE_SETS_B B
244: where B.VALUE_SET_ID = T.VALUE_SET_ID
245: );
246:
247: update FEM_VALUE_SETS_TL T set (
248: VALUE_SET_NAME,
249: DESCRIPTION
250: ) = (select
251: B.VALUE_SET_NAME,

Line 253: from FEM_VALUE_SETS_TL B

249: DESCRIPTION
250: ) = (select
251: B.VALUE_SET_NAME,
252: B.DESCRIPTION
253: from FEM_VALUE_SETS_TL B
254: where B.VALUE_SET_ID = T.VALUE_SET_ID
255: and B.LANGUAGE = T.SOURCE_LANG)
256: where (
257: T.VALUE_SET_ID,

Line 262: from FEM_VALUE_SETS_TL SUBB, FEM_VALUE_SETS_TL SUBT

258: T.LANGUAGE
259: ) in (select
260: SUBT.VALUE_SET_ID,
261: SUBT.LANGUAGE
262: from FEM_VALUE_SETS_TL SUBB, FEM_VALUE_SETS_TL SUBT
263: where SUBB.VALUE_SET_ID = SUBT.VALUE_SET_ID
264: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
265: and (SUBB.VALUE_SET_NAME <> SUBT.VALUE_SET_NAME
266: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 271: insert into FEM_VALUE_SETS_TL (

267: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
268: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
269: ));
270:
271: insert into FEM_VALUE_SETS_TL (
272: VALUE_SET_NAME,
273: DESCRIPTION,
274: CREATION_DATE,
275: CREATED_BY,

Line 293: from FEM_VALUE_SETS_TL B, FND_LANGUAGES L

289: B.LAST_UPDATE_LOGIN,
290: B.VALUE_SET_ID,
291: L.LANGUAGE_CODE,
292: B.SOURCE_LANG
293: from FEM_VALUE_SETS_TL B, FND_LANGUAGES L
294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL

Line 298: from FEM_VALUE_SETS_TL T

294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL
298: from FEM_VALUE_SETS_TL T
299: where T.VALUE_SET_ID = B.VALUE_SET_ID
300: and T.LANGUAGE = L.LANGUAGE_CODE);
301: end ADD_LANGUAGE;
302: PROCEDURE TRANSLATE_ROW(

Line 328: from FEM_VALUE_SETS_TL

324: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
325: begin
326: select LAST_UPDATED_BY, LAST_UPDATE_DATE
327: into db_luby, db_ludate
328: from FEM_VALUE_SETS_TL
329: where VALUE_SET_ID = x_VALUE_SET_ID
330: and LANGUAGE = userenv('LANG');
331:
332: -- Test for customization and version

Line 336: update FEM_VALUE_SETS_TL set

332: -- Test for customization and version
333: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
334: db_ludate, x_custom_mode)) then
335: -- Update translations for this language
336: update FEM_VALUE_SETS_TL set
337: VALUE_SET_NAME = decode(x_VALUE_SET_NAME,
338: fnd_load_util.null_value, null, -- Real null
339: null, x_VALUE_SET_NAME, -- No change
340: x_VALUE_SET_NAME),