APPS.FEM_TABLES_PKG dependencies on FEM_TABLES_TL

Line 61: insert into FEM_TABLES_TL (

57: X_LAST_UPDATED_BY,
58: X_LAST_UPDATE_LOGIN
59: );
60:
61: insert into FEM_TABLES_TL (
62: TABLE_NAME,
63: DISPLAY_NAME,
64: DESCRIPTION,
65: CREATION_DATE,

Line 87: from FEM_TABLES_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from FEM_TABLES_TL T
88: where T.TABLE_NAME = X_TABLE_NAME
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:
91: open c;

Line 134: from FEM_TABLES_TL

130: cursor c1 is select
131: DISPLAY_NAME,
132: DESCRIPTION,
133: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
134: from FEM_TABLES_TL
135: where TABLE_NAME = X_TABLE_NAME
136: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
137: for update of TABLE_NAME nowait;
138: begin

Line 221: update FEM_TABLES_TL set

217: if (sql%notfound) then
218: raise no_data_found;
219: end if;
220:
221: update FEM_TABLES_TL set
222: DISPLAY_NAME = X_DISPLAY_NAME,
223: DESCRIPTION = X_DESCRIPTION,
224: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
225: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 240: delete from FEM_TABLES_TL

236: procedure DELETE_ROW (
237: X_TABLE_NAME in VARCHAR2
238: ) is
239: begin
240: delete from FEM_TABLES_TL
241: where TABLE_NAME = X_TABLE_NAME;
242:
243: if (sql%notfound) then
244: raise no_data_found;

Line 258: delete from FEM_TABLES_TL T

254:
255: procedure ADD_LANGUAGE
256: is
257: begin
258: delete from FEM_TABLES_TL T
259: where not exists
260: (select NULL
261: from FEM_TABLES_B B
262: where B.TABLE_NAME = T.TABLE_NAME

Line 265: update FEM_TABLES_TL T set (

261: from FEM_TABLES_B B
262: where B.TABLE_NAME = T.TABLE_NAME
263: );
264:
265: update FEM_TABLES_TL T set (
266: DISPLAY_NAME,
267: DESCRIPTION
268: ) = (select
269: B.DISPLAY_NAME,

Line 271: from FEM_TABLES_TL B

267: DESCRIPTION
268: ) = (select
269: B.DISPLAY_NAME,
270: B.DESCRIPTION
271: from FEM_TABLES_TL B
272: where B.TABLE_NAME = T.TABLE_NAME
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (
275: T.TABLE_NAME,

Line 280: from FEM_TABLES_TL SUBB, FEM_TABLES_TL SUBT

276: T.LANGUAGE
277: ) in (select
278: SUBT.TABLE_NAME,
279: SUBT.LANGUAGE
280: from FEM_TABLES_TL SUBB, FEM_TABLES_TL SUBT
281: where SUBB.TABLE_NAME = SUBT.TABLE_NAME
282: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
283: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
284: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 287: insert into FEM_TABLES_TL (

283: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
284: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
285: ));
286:
287: insert into FEM_TABLES_TL (
288: TABLE_NAME,
289: DISPLAY_NAME,
290: DESCRIPTION,
291: CREATION_DATE,

Line 309: from FEM_TABLES_TL B, FND_LANGUAGES L

305: B.LAST_UPDATE_DATE,
306: B.LAST_UPDATE_LOGIN,
307: L.LANGUAGE_CODE,
308: B.SOURCE_LANG
309: from FEM_TABLES_TL B, FND_LANGUAGES L
310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL

Line 314: from FEM_TABLES_TL T

310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL
314: from FEM_TABLES_TL T
315: where T.TABLE_NAME = B.TABLE_NAME
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317: end ADD_LANGUAGE;
318: PROCEDURE TRANSLATE_ROW(

Line 344: from FEM_TABLES_TL

340: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
341: begin
342: select LAST_UPDATED_BY, LAST_UPDATE_DATE
343: into db_luby, db_ludate
344: from FEM_TABLES_TL
345: where TABLE_NAME = x_TABLE_NAME
346: and LANGUAGE = userenv('LANG');
347:
348: -- Test for customization and version

Line 352: update FEM_TABLES_TL set

348: -- Test for customization and version
349: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
350: db_ludate, x_custom_mode)) then
351: -- Update translations for this language
352: update FEM_TABLES_TL set
353: DISPLAY_NAME = decode(x_DISPLAY_NAME,
354: fnd_load_util.null_value, null, -- Real null
355: null, x_DISPLAY_NAME, -- No change
356: x_DISPLAY_NAME),