APPS.FEM_DIM_ATTR_VERSIONS_PKG dependencies on FEM_DIM_ATTR_VERSIONS_TL

Line 52: insert into FEM_DIM_ATTR_VERSIONS_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into FEM_DIM_ATTR_VERSIONS_TL (
53: VERSION_ID,
54: VERSION_NAME,
55: DESCRIPTION,
56: CREATION_DATE,

Line 78: from FEM_DIM_ATTR_VERSIONS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from FEM_DIM_ATTR_VERSIONS_TL T
79: where T.VERSION_ID = X_VERSION_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from FEM_DIM_ATTR_VERSIONS_TL

115: cursor c1 is select
116: VERSION_NAME,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from FEM_DIM_ATTR_VERSIONS_TL
120: where VERSION_ID = X_VERSION_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of VERSION_ID nowait;
123: begin

Line 192: update FEM_DIM_ATTR_VERSIONS_TL set

188: if (sql%notfound) then
189: raise no_data_found;
190: end if;
191:
192: update FEM_DIM_ATTR_VERSIONS_TL set
193: VERSION_NAME = X_VERSION_NAME,
194: DESCRIPTION = X_DESCRIPTION,
195: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
196: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 211: delete from FEM_DIM_ATTR_VERSIONS_TL

207: procedure DELETE_ROW (
208: X_VERSION_ID in NUMBER
209: ) is
210: begin
211: delete from FEM_DIM_ATTR_VERSIONS_TL
212: where VERSION_ID = X_VERSION_ID;
213:
214: if (sql%notfound) then
215: raise no_data_found;

Line 229: delete from FEM_DIM_ATTR_VERSIONS_TL T

225:
226: procedure ADD_LANGUAGE
227: is
228: begin
229: delete from FEM_DIM_ATTR_VERSIONS_TL T
230: where not exists
231: (select NULL
232: from FEM_DIM_ATTR_VERSIONS_B B
233: where B.VERSION_ID = T.VERSION_ID

Line 236: update FEM_DIM_ATTR_VERSIONS_TL T set (

232: from FEM_DIM_ATTR_VERSIONS_B B
233: where B.VERSION_ID = T.VERSION_ID
234: );
235:
236: update FEM_DIM_ATTR_VERSIONS_TL T set (
237: VERSION_NAME,
238: DESCRIPTION
239: ) = (select
240: B.VERSION_NAME,

Line 242: from FEM_DIM_ATTR_VERSIONS_TL B

238: DESCRIPTION
239: ) = (select
240: B.VERSION_NAME,
241: B.DESCRIPTION
242: from FEM_DIM_ATTR_VERSIONS_TL B
243: where B.VERSION_ID = T.VERSION_ID
244: and B.LANGUAGE = T.SOURCE_LANG)
245: where (
246: T.VERSION_ID,

Line 251: from FEM_DIM_ATTR_VERSIONS_TL SUBB, FEM_DIM_ATTR_VERSIONS_TL SUBT

247: T.LANGUAGE
248: ) in (select
249: SUBT.VERSION_ID,
250: SUBT.LANGUAGE
251: from FEM_DIM_ATTR_VERSIONS_TL SUBB, FEM_DIM_ATTR_VERSIONS_TL SUBT
252: where SUBB.VERSION_ID = SUBT.VERSION_ID
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.VERSION_NAME <> SUBT.VERSION_NAME
255: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 260: insert into FEM_DIM_ATTR_VERSIONS_TL (

256: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
257: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
258: ));
259:
260: insert into FEM_DIM_ATTR_VERSIONS_TL (
261: VERSION_ID,
262: VERSION_NAME,
263: DESCRIPTION,
264: CREATION_DATE,

Line 282: from FEM_DIM_ATTR_VERSIONS_TL B, FND_LANGUAGES L

278: B.LAST_UPDATE_DATE,
279: B.LAST_UPDATE_LOGIN,
280: L.LANGUAGE_CODE,
281: B.SOURCE_LANG
282: from FEM_DIM_ATTR_VERSIONS_TL B, FND_LANGUAGES L
283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL

Line 287: from FEM_DIM_ATTR_VERSIONS_TL T

283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL
287: from FEM_DIM_ATTR_VERSIONS_TL T
288: where T.VERSION_ID = B.VERSION_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291: PROCEDURE TRANSLATE_ROW(

Line 317: from FEM_DIM_ATTR_VERSIONS_TL

313: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
314: begin
315: select LAST_UPDATED_BY, LAST_UPDATE_DATE
316: into db_luby, db_ludate
317: from FEM_DIM_ATTR_VERSIONS_TL
318: where VERSION_ID = x_VERSION_ID
319: and LANGUAGE = userenv('LANG');
320:
321: -- Test for customization and version

Line 325: update FEM_DIM_ATTR_VERSIONS_TL set

321: -- Test for customization and version
322: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
323: db_ludate, x_custom_mode)) then
324: -- Update translations for this language
325: update FEM_DIM_ATTR_VERSIONS_TL set
326: VERSION_NAME = decode(x_VERSION_NAME,
327: fnd_load_util.null_value, null, -- Real null
328: null, x_VERSION_NAME, -- No change
329: x_VERSION_NAME),