APPS.FEM_DATASETS_PKG dependencies on FEM_DATASETS_TL

Line 49: insert into FEM_DATASETS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_DATASETS_TL (
50: DATASET_CODE,
51: LAST_UPDATED_BY,
52: CREATED_BY,
53: CREATION_DATE,

Line 75: from FEM_DATASETS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FEM_DATASETS_TL T
76: where T.DATASET_CODE = X_DATASET_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_DATASETS_TL

110: cursor c1 is select
111: DATASET_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FEM_DATASETS_TL
115: where DATASET_CODE = X_DATASET_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of DATASET_CODE nowait;
118: begin

Line 186: update FEM_DATASETS_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update FEM_DATASETS_TL set
187: DATASET_NAME = X_DATASET_NAME,
188: DESCRIPTION = X_DESCRIPTION,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 205: delete from FEM_DATASETS_TL

201: procedure DELETE_ROW (
202: X_DATASET_CODE in NUMBER
203: ) is
204: begin
205: delete from FEM_DATASETS_TL
206: where DATASET_CODE = X_DATASET_CODE;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from FEM_DATASETS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from FEM_DATASETS_TL T
224: where not exists
225: (select NULL
226: from FEM_DATASETS_B B
227: where B.DATASET_CODE = T.DATASET_CODE

Line 230: update FEM_DATASETS_TL T set (

226: from FEM_DATASETS_B B
227: where B.DATASET_CODE = T.DATASET_CODE
228: );
229:
230: update FEM_DATASETS_TL T set (
231: DATASET_NAME,
232: DESCRIPTION
233: ) = (select
234: B.DATASET_NAME,

Line 236: from FEM_DATASETS_TL B

232: DESCRIPTION
233: ) = (select
234: B.DATASET_NAME,
235: B.DESCRIPTION
236: from FEM_DATASETS_TL B
237: where B.DATASET_CODE = T.DATASET_CODE
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.DATASET_CODE,

Line 245: from FEM_DATASETS_TL SUBB, FEM_DATASETS_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.DATASET_CODE,
244: SUBT.LANGUAGE
245: from FEM_DATASETS_TL SUBB, FEM_DATASETS_TL SUBT
246: where SUBB.DATASET_CODE = SUBT.DATASET_CODE
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.DATASET_NAME <> SUBT.DATASET_NAME
249: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 254: insert into FEM_DATASETS_TL (

250: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
251: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
252: ));
253:
254: insert into FEM_DATASETS_TL (
255: DATASET_CODE,
256: LAST_UPDATED_BY,
257: CREATED_BY,
258: CREATION_DATE,

Line 276: from FEM_DATASETS_TL B, FND_LANGUAGES L

272: B.LAST_UPDATE_DATE,
273: B.LAST_UPDATE_LOGIN,
274: L.LANGUAGE_CODE,
275: B.SOURCE_LANG
276: from FEM_DATASETS_TL B, FND_LANGUAGES L
277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL

Line 281: from FEM_DATASETS_TL T

277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL
281: from FEM_DATASETS_TL T
282: where T.DATASET_CODE = B.DATASET_CODE
283: and T.LANGUAGE = L.LANGUAGE_CODE);
284: end ADD_LANGUAGE;
285: PROCEDURE TRANSLATE_ROW(

Line 311: from FEM_DATASETS_TL

307: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
308: begin
309: select LAST_UPDATED_BY, LAST_UPDATE_DATE
310: into db_luby, db_ludate
311: from FEM_DATASETS_TL
312: where DATASET_CODE = x_DATASET_CODE
313: and LANGUAGE = userenv('LANG');
314:
315: -- Test for customization and version

Line 319: update FEM_DATASETS_TL set

315: -- Test for customization and version
316: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
317: db_ludate, x_custom_mode)) then
318: -- Update translations for this language
319: update FEM_DATASETS_TL set
320: DATASET_NAME = decode(x_DATASET_NAME,
321: fnd_load_util.null_value, null, -- Real null
322: null, x_DATASET_NAME, -- No change
323: x_DATASET_NAME),