APPS.FEM_DIM_ATTRIBUTES_PKG dependencies on FEM_DIM_ATTRIBUTES_TL

Line 82: insert into FEM_DIM_ATTRIBUTES_TL (

78: X_LAST_UPDATED_BY,
79: X_LAST_UPDATE_LOGIN
80: );
81:
82: insert into FEM_DIM_ATTRIBUTES_TL (
83: ATTRIBUTE_ID,
84: ATTRIBUTE_NAME,
85: DESCRIPTION,
86: CREATION_DATE,

Line 108: from FEM_DIM_ATTRIBUTES_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from FEM_DIM_ATTRIBUTES_TL T
109: where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112: open c;

Line 169: from FEM_DIM_ATTRIBUTES_TL

165: cursor c1 is select
166: ATTRIBUTE_NAME,
167: DESCRIPTION,
168: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
169: from FEM_DIM_ATTRIBUTES_TL
170: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
171: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
172: for update of ATTRIBUTE_ID nowait;
173: begin

Line 275: update FEM_DIM_ATTRIBUTES_TL set

271: if (sql%notfound) then
272: raise no_data_found;
273: end if;
274:
275: update FEM_DIM_ATTRIBUTES_TL set
276: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
277: DESCRIPTION = X_DESCRIPTION,
278: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
279: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 294: delete from FEM_DIM_ATTRIBUTES_TL

290: procedure DELETE_ROW (
291: X_ATTRIBUTE_ID in NUMBER
292: ) is
293: begin
294: delete from FEM_DIM_ATTRIBUTES_TL
295: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
296:
297: if (sql%notfound) then
298: raise no_data_found;

Line 312: delete from FEM_DIM_ATTRIBUTES_TL T

308:
309: procedure ADD_LANGUAGE
310: is
311: begin
312: delete from FEM_DIM_ATTRIBUTES_TL T
313: where not exists
314: (select NULL
315: from FEM_DIM_ATTRIBUTES_B B
316: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 319: update FEM_DIM_ATTRIBUTES_TL T set (

315: from FEM_DIM_ATTRIBUTES_B B
316: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
317: );
318:
319: update FEM_DIM_ATTRIBUTES_TL T set (
320: ATTRIBUTE_NAME,
321: DESCRIPTION
322: ) = (select
323: B.ATTRIBUTE_NAME,

Line 325: from FEM_DIM_ATTRIBUTES_TL B

321: DESCRIPTION
322: ) = (select
323: B.ATTRIBUTE_NAME,
324: B.DESCRIPTION
325: from FEM_DIM_ATTRIBUTES_TL B
326: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
327: and B.LANGUAGE = T.SOURCE_LANG)
328: where (
329: T.ATTRIBUTE_ID,

Line 334: from FEM_DIM_ATTRIBUTES_TL SUBB, FEM_DIM_ATTRIBUTES_TL SUBT

330: T.LANGUAGE
331: ) in (select
332: SUBT.ATTRIBUTE_ID,
333: SUBT.LANGUAGE
334: from FEM_DIM_ATTRIBUTES_TL SUBB, FEM_DIM_ATTRIBUTES_TL SUBT
335: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
336: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
337: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
338: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 343: insert into FEM_DIM_ATTRIBUTES_TL (

339: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
340: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
341: ));
342:
343: insert into FEM_DIM_ATTRIBUTES_TL (
344: ATTRIBUTE_ID,
345: ATTRIBUTE_NAME,
346: DESCRIPTION,
347: CREATION_DATE,

Line 365: from FEM_DIM_ATTRIBUTES_TL B, FND_LANGUAGES L

361: B.LAST_UPDATE_DATE,
362: B.LAST_UPDATE_LOGIN,
363: L.LANGUAGE_CODE,
364: B.SOURCE_LANG
365: from FEM_DIM_ATTRIBUTES_TL B, FND_LANGUAGES L
366: where L.INSTALLED_FLAG in ('I', 'B')
367: and B.LANGUAGE = userenv('LANG')
368: and not exists
369: (select NULL

Line 370: from FEM_DIM_ATTRIBUTES_TL T

366: where L.INSTALLED_FLAG in ('I', 'B')
367: and B.LANGUAGE = userenv('LANG')
368: and not exists
369: (select NULL
370: from FEM_DIM_ATTRIBUTES_TL T
371: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
372: and T.LANGUAGE = L.LANGUAGE_CODE);
373: end ADD_LANGUAGE;
374: PROCEDURE TRANSLATE_ROW(

Line 400: from FEM_DIM_ATTRIBUTES_TL

396: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
397: begin
398: select LAST_UPDATED_BY, LAST_UPDATE_DATE
399: into db_luby, db_ludate
400: from FEM_DIM_ATTRIBUTES_TL
401: where ATTRIBUTE_ID = x_ATTRIBUTE_ID
402: and LANGUAGE = userenv('LANG');
403:
404: -- Test for customization and version

Line 408: update FEM_DIM_ATTRIBUTES_TL set

404: -- Test for customization and version
405: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
406: db_ludate, x_custom_mode)) then
407: -- Update translations for this language
408: update FEM_DIM_ATTRIBUTES_TL set
409: ATTRIBUTE_NAME = decode(x_ATTRIBUTE_NAME,
410: fnd_load_util.null_value, null, -- Real null
411: null, x_ATTRIBUTE_NAME, -- No change
412: x_ATTRIBUTE_NAME),