APPS.FEM_TAB_COLUMNS_PKG dependencies on FEM_TAB_COLUMNS_TL

Line 56: insert into FEM_TAB_COLUMNS_TL (

52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into FEM_TAB_COLUMNS_TL (
57: TABLE_NAME,
58: COLUMN_NAME,
59: DISPLAY_NAME,
60: DESCRIPTION,

Line 84: from FEM_TAB_COLUMNS_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from FEM_TAB_COLUMNS_TL T
85: where T.TABLE_NAME = X_TABLE_NAME
86: and T.COLUMN_NAME = X_COLUMN_NAME
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:

Line 128: from FEM_TAB_COLUMNS_TL

124: cursor c1 is select
125: DISPLAY_NAME,
126: DESCRIPTION,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from FEM_TAB_COLUMNS_TL
129: where TABLE_NAME = X_TABLE_NAME
130: and COLUMN_NAME = X_COLUMN_NAME
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of TABLE_NAME nowait;

Line 206: update FEM_TAB_COLUMNS_TL set

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: update FEM_TAB_COLUMNS_TL set
207: DISPLAY_NAME = X_DISPLAY_NAME,
208: DESCRIPTION = X_DESCRIPTION,
209: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
210: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 227: delete from FEM_TAB_COLUMNS_TL

223: X_TABLE_NAME in VARCHAR2,
224: X_COLUMN_NAME in VARCHAR2
225: ) is
226: begin
227: delete from FEM_TAB_COLUMNS_TL
228: where TABLE_NAME = X_TABLE_NAME
229: and COLUMN_NAME = X_COLUMN_NAME;
230:
231: if (sql%notfound) then

Line 247: delete from FEM_TAB_COLUMNS_TL T

243:
244: procedure ADD_LANGUAGE
245: is
246: begin
247: delete from FEM_TAB_COLUMNS_TL T
248: where not exists
249: (select NULL
250: from FEM_TAB_COLUMNS_B B
251: where B.TABLE_NAME = T.TABLE_NAME

Line 255: update FEM_TAB_COLUMNS_TL T set (

251: where B.TABLE_NAME = T.TABLE_NAME
252: and B.COLUMN_NAME = T.COLUMN_NAME
253: );
254:
255: update FEM_TAB_COLUMNS_TL T set (
256: DISPLAY_NAME,
257: DESCRIPTION
258: ) = (select
259: B.DISPLAY_NAME,

Line 261: from FEM_TAB_COLUMNS_TL B

257: DESCRIPTION
258: ) = (select
259: B.DISPLAY_NAME,
260: B.DESCRIPTION
261: from FEM_TAB_COLUMNS_TL B
262: where B.TABLE_NAME = T.TABLE_NAME
263: and B.COLUMN_NAME = T.COLUMN_NAME
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (

Line 273: from FEM_TAB_COLUMNS_TL SUBB, FEM_TAB_COLUMNS_TL SUBT

269: ) in (select
270: SUBT.TABLE_NAME,
271: SUBT.COLUMN_NAME,
272: SUBT.LANGUAGE
273: from FEM_TAB_COLUMNS_TL SUBB, FEM_TAB_COLUMNS_TL SUBT
274: where SUBB.TABLE_NAME = SUBT.TABLE_NAME
275: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
276: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
277: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 281: insert into FEM_TAB_COLUMNS_TL (

277: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
278: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
279: ));
280:
281: insert into FEM_TAB_COLUMNS_TL (
282: TABLE_NAME,
283: COLUMN_NAME,
284: DISPLAY_NAME,
285: DESCRIPTION,

Line 305: from FEM_TAB_COLUMNS_TL B, FND_LANGUAGES L

301: B.LAST_UPDATE_DATE,
302: B.LAST_UPDATE_LOGIN,
303: L.LANGUAGE_CODE,
304: B.SOURCE_LANG
305: from FEM_TAB_COLUMNS_TL B, FND_LANGUAGES L
306: where L.INSTALLED_FLAG in ('I', 'B')
307: and B.LANGUAGE = userenv('LANG')
308: and not exists
309: (select NULL

Line 310: from FEM_TAB_COLUMNS_TL T

306: where L.INSTALLED_FLAG in ('I', 'B')
307: and B.LANGUAGE = userenv('LANG')
308: and not exists
309: (select NULL
310: from FEM_TAB_COLUMNS_TL T
311: where T.TABLE_NAME = B.TABLE_NAME
312: and T.COLUMN_NAME = B.COLUMN_NAME
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;

Line 342: from FEM_TAB_COLUMNS_TL

338: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
339: begin
340: select LAST_UPDATED_BY, LAST_UPDATE_DATE
341: into db_luby, db_ludate
342: from FEM_TAB_COLUMNS_TL
343: where TABLE_NAME = x_TABLE_NAME
344: and COLUMN_NAME = x_COLUMN_NAME
345: and LANGUAGE = userenv('LANG');
346:

Line 351: update FEM_TAB_COLUMNS_TL set

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