APPS.FEM_OBJECT_DEFINITION_PKG dependencies on FEM_OBJECT_DEFINITION_TL

Line 64: insert into FEM_OBJECT_DEFINITION_TL (

60: X_LAST_UPDATED_BY,
61: X_LAST_UPDATE_LOGIN
62: );
63:
64: insert into FEM_OBJECT_DEFINITION_TL (
65: OBJECT_DEFINITION_ID,
66: OBJECT_ID,
67: OLD_APPROVED_COPY_FLAG,
68: DISPLAY_NAME,

Line 94: from FEM_OBJECT_DEFINITION_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from FEM_OBJECT_DEFINITION_TL T
95: where T.OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97:
98: open c;

Line 143: from FEM_OBJECT_DEFINITION_TL

139: cursor c1 is select
140: DISPLAY_NAME,
141: DESCRIPTION,
142: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
143: from FEM_OBJECT_DEFINITION_TL
144: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
145: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
146: for update of OBJECT_DEFINITION_ID nowait;
147: begin

Line 231: update FEM_OBJECT_DEFINITION_TL set

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: update FEM_OBJECT_DEFINITION_TL set
232: DISPLAY_NAME = X_DISPLAY_NAME,
233: DESCRIPTION = X_DESCRIPTION,
234: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 250: delete from FEM_OBJECT_DEFINITION_TL

246: procedure DELETE_ROW (
247: X_OBJECT_DEFINITION_ID in NUMBER
248: ) is
249: begin
250: delete from FEM_OBJECT_DEFINITION_TL
251: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID;
252:
253: if (sql%notfound) then
254: raise no_data_found;

Line 268: delete from FEM_OBJECT_DEFINITION_TL T

264:
265: procedure ADD_LANGUAGE
266: is
267: begin
268: delete from FEM_OBJECT_DEFINITION_TL T
269: where not exists
270: (select NULL
271: from FEM_OBJECT_DEFINITION_B B
272: where B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID

Line 275: update FEM_OBJECT_DEFINITION_TL T set (

271: from FEM_OBJECT_DEFINITION_B B
272: where B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
273: );
274:
275: update FEM_OBJECT_DEFINITION_TL T set (
276: DISPLAY_NAME,
277: DESCRIPTION
278: ) = (select
279: B.DISPLAY_NAME,

Line 281: from FEM_OBJECT_DEFINITION_TL B

277: DESCRIPTION
278: ) = (select
279: B.DISPLAY_NAME,
280: B.DESCRIPTION
281: from FEM_OBJECT_DEFINITION_TL B
282: where B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
283: and B.LANGUAGE = T.SOURCE_LANG)
284: where (
285: T.OBJECT_DEFINITION_ID,

Line 290: from FEM_OBJECT_DEFINITION_TL SUBB, FEM_OBJECT_DEFINITION_TL SUBT

286: T.LANGUAGE
287: ) in (select
288: SUBT.OBJECT_DEFINITION_ID,
289: SUBT.LANGUAGE
290: from FEM_OBJECT_DEFINITION_TL SUBB, FEM_OBJECT_DEFINITION_TL SUBT
291: where SUBB.OBJECT_DEFINITION_ID = SUBT.OBJECT_DEFINITION_ID
292: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
293: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
294: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 299: insert into FEM_OBJECT_DEFINITION_TL (

295: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
296: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
297: ));
298:
299: insert into FEM_OBJECT_DEFINITION_TL (
300: OBJECT_DEFINITION_ID,
301: OBJECT_ID,
302: OLD_APPROVED_COPY_FLAG,
303: DISPLAY_NAME,

Line 325: from FEM_OBJECT_DEFINITION_TL B, FND_LANGUAGES L

321: B.LAST_UPDATE_DATE,
322: B.LAST_UPDATE_LOGIN,
323: L.LANGUAGE_CODE,
324: B.SOURCE_LANG
325: from FEM_OBJECT_DEFINITION_TL B, FND_LANGUAGES L
326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL

Line 330: from FEM_OBJECT_DEFINITION_TL T

326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL
330: from FEM_OBJECT_DEFINITION_TL T
331: where T.OBJECT_DEFINITION_ID = B.OBJECT_DEFINITION_ID
332: and T.LANGUAGE = L.LANGUAGE_CODE);
333: end ADD_LANGUAGE;
334: PROCEDURE TRANSLATE_ROW(

Line 360: from FEM_OBJECT_DEFINITION_TL

356: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
357: begin
358: select LAST_UPDATED_BY, LAST_UPDATE_DATE
359: into db_luby, db_ludate
360: from FEM_OBJECT_DEFINITION_TL
361: where OBJECT_DEFINITION_ID = x_OBJECT_DEFINITION_ID
362: and LANGUAGE = userenv('LANG');
363:
364: -- Test for customization and version

Line 368: update FEM_OBJECT_DEFINITION_TL set

364: -- Test for customization and version
365: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
366: db_ludate, x_custom_mode)) then
367: -- Update translations for this language
368: update FEM_OBJECT_DEFINITION_TL set
369: DISPLAY_NAME = decode(x_DISPLAY_NAME,
370: fnd_load_util.null_value, null, -- Real null
371: null, x_DISPLAY_NAME, -- No change
372: x_DISPLAY_NAME),