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_FUNC_DIM_SETS_PKG dependencies on FEM_FUNC_DIM_SETS_TL

Line 42: insert into FEM_FUNC_DIM_SETS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into FEM_FUNC_DIM_SETS_TL (
43: FUNC_DIM_SET_ID,
44: FUNC_DIM_SET_NAME,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from FEM_FUNC_DIM_SETS_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from FEM_FUNC_DIM_SETS_TL T
67: where T.FUNC_DIM_SET_ID = X_FUNC_DIM_SET_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from FEM_FUNC_DIM_SETS_TL

95:
96: cursor c1 is select
97: FUNC_DIM_SET_NAME,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from FEM_FUNC_DIM_SETS_TL
100: where FUNC_DIM_SET_ID = X_FUNC_DIM_SET_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of FUNC_DIM_SET_ID nowait;
103: begin

Line 160: update FEM_FUNC_DIM_SETS_TL set

156: if (sql%notfound) then
157: raise no_data_found;
158: end if;
159:
160: update FEM_FUNC_DIM_SETS_TL set
161: FUNC_DIM_SET_NAME = X_FUNC_DIM_SET_NAME,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
164: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 178: delete from FEM_FUNC_DIM_SETS_TL

174: procedure DELETE_ROW (
175: X_FUNC_DIM_SET_ID in NUMBER
176: ) is
177: begin
178: delete from FEM_FUNC_DIM_SETS_TL
179: where FUNC_DIM_SET_ID = X_FUNC_DIM_SET_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 196: delete from FEM_FUNC_DIM_SETS_TL T

192:
193: procedure ADD_LANGUAGE
194: is
195: begin
196: delete from FEM_FUNC_DIM_SETS_TL T
197: where not exists
198: (select NULL
199: from FEM_FUNC_DIM_SETS_B B
200: where B.FUNC_DIM_SET_ID = T.FUNC_DIM_SET_ID

Line 203: update FEM_FUNC_DIM_SETS_TL T set (

199: from FEM_FUNC_DIM_SETS_B B
200: where B.FUNC_DIM_SET_ID = T.FUNC_DIM_SET_ID
201: );
202:
203: update FEM_FUNC_DIM_SETS_TL T set (
204: FUNC_DIM_SET_NAME
205: ) = (select
206: B.FUNC_DIM_SET_NAME
207: from FEM_FUNC_DIM_SETS_TL B

Line 207: from FEM_FUNC_DIM_SETS_TL B

203: update FEM_FUNC_DIM_SETS_TL T set (
204: FUNC_DIM_SET_NAME
205: ) = (select
206: B.FUNC_DIM_SET_NAME
207: from FEM_FUNC_DIM_SETS_TL B
208: where B.FUNC_DIM_SET_ID = T.FUNC_DIM_SET_ID
209: and B.LANGUAGE = T.SOURCE_LANG)
210: where (
211: T.FUNC_DIM_SET_ID,

Line 216: from FEM_FUNC_DIM_SETS_TL SUBB, FEM_FUNC_DIM_SETS_TL SUBT

212: T.LANGUAGE
213: ) in (select
214: SUBT.FUNC_DIM_SET_ID,
215: SUBT.LANGUAGE
216: from FEM_FUNC_DIM_SETS_TL SUBB, FEM_FUNC_DIM_SETS_TL SUBT
217: where SUBB.FUNC_DIM_SET_ID = SUBT.FUNC_DIM_SET_ID
218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.FUNC_DIM_SET_NAME <> SUBT.FUNC_DIM_SET_NAME
220: ));

Line 222: insert into FEM_FUNC_DIM_SETS_TL (

218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.FUNC_DIM_SET_NAME <> SUBT.FUNC_DIM_SET_NAME
220: ));
221:
222: insert into FEM_FUNC_DIM_SETS_TL (
223: FUNC_DIM_SET_ID,
224: FUNC_DIM_SET_NAME,
225: CREATED_BY,
226: CREATION_DATE,

Line 242: from FEM_FUNC_DIM_SETS_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_DATE,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from FEM_FUNC_DIM_SETS_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from FEM_FUNC_DIM_SETS_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from FEM_FUNC_DIM_SETS_TL T
248: where T.FUNC_DIM_SET_ID = B.FUNC_DIM_SET_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251: PROCEDURE TRANSLATE_ROW(

Line 276: from FEM_FUNC_DIM_SETS_TL

272: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
273: begin
274: select LAST_UPDATED_BY, LAST_UPDATE_DATE
275: into db_luby, db_ludate
276: from FEM_FUNC_DIM_SETS_TL
277: where FUNC_DIM_SET_ID = x_FUNC_DIM_SET_ID
278: and LANGUAGE = userenv('LANG');
279:
280: -- Test for customization and version

Line 284: update FEM_FUNC_DIM_SETS_TL set

280: -- Test for customization and version
281: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
282: db_ludate, x_custom_mode)) then
283: -- Update translations for this language
284: update FEM_FUNC_DIM_SETS_TL set
285: FUNC_DIM_SET_NAME = decode(x_FUNC_DIM_SET_NAME,
286: fnd_load_util.null_value, null, -- Real null
287: null, x_FUNC_DIM_SET_NAME, -- No change
288: x_FUNC_DIM_SET_NAME),