APPS.FEM_OBJECT_TYPES_PKG dependencies on FEM_OBJECT_TYPES_TL

Line 88: insert into FEM_OBJECT_TYPES_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into FEM_OBJECT_TYPES_TL (
89: OBJECT_TYPE_CODE,
90: OBJECT_TYPE_NAME,
91: DESCRIPTION,
92: CREATION_DATE,

Line 114: from FEM_OBJECT_TYPES_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from FEM_OBJECT_TYPES_TL T
115: where T.OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from FEM_OBJECT_TYPES_TL

175: cursor c1 is select
176: OBJECT_TYPE_NAME,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from FEM_OBJECT_TYPES_TL
180: where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of OBJECT_TYPE_CODE nowait;
183: begin

Line 294: update FEM_OBJECT_TYPES_TL set

290: if (sql%notfound) then
291: raise no_data_found;
292: end if;
293:
294: update FEM_OBJECT_TYPES_TL set
295: OBJECT_TYPE_NAME = X_OBJECT_TYPE_NAME,
296: DESCRIPTION = X_DESCRIPTION,
297: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
298: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 313: delete from FEM_OBJECT_TYPES_TL

309: procedure DELETE_ROW (
310: X_OBJECT_TYPE_CODE in VARCHAR2
311: ) is
312: begin
313: delete from FEM_OBJECT_TYPES_TL
314: where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE;
315:
316: if (sql%notfound) then
317: raise no_data_found;

Line 331: delete from FEM_OBJECT_TYPES_TL T

327:
328: procedure ADD_LANGUAGE
329: is
330: begin
331: delete from FEM_OBJECT_TYPES_TL T
332: where not exists
333: (select NULL
334: from FEM_OBJECT_TYPES_B B
335: where B.OBJECT_TYPE_CODE = T.OBJECT_TYPE_CODE

Line 338: update FEM_OBJECT_TYPES_TL T set (

334: from FEM_OBJECT_TYPES_B B
335: where B.OBJECT_TYPE_CODE = T.OBJECT_TYPE_CODE
336: );
337:
338: update FEM_OBJECT_TYPES_TL T set (
339: OBJECT_TYPE_NAME,
340: DESCRIPTION
341: ) = (select
342: B.OBJECT_TYPE_NAME,

Line 344: from FEM_OBJECT_TYPES_TL B

340: DESCRIPTION
341: ) = (select
342: B.OBJECT_TYPE_NAME,
343: B.DESCRIPTION
344: from FEM_OBJECT_TYPES_TL B
345: where B.OBJECT_TYPE_CODE = T.OBJECT_TYPE_CODE
346: and B.LANGUAGE = T.SOURCE_LANG)
347: where (
348: T.OBJECT_TYPE_CODE,

Line 353: from FEM_OBJECT_TYPES_TL SUBB, FEM_OBJECT_TYPES_TL SUBT

349: T.LANGUAGE
350: ) in (select
351: SUBT.OBJECT_TYPE_CODE,
352: SUBT.LANGUAGE
353: from FEM_OBJECT_TYPES_TL SUBB, FEM_OBJECT_TYPES_TL SUBT
354: where SUBB.OBJECT_TYPE_CODE = SUBT.OBJECT_TYPE_CODE
355: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
356: and (SUBB.OBJECT_TYPE_NAME <> SUBT.OBJECT_TYPE_NAME
357: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 362: insert into FEM_OBJECT_TYPES_TL (

358: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
359: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
360: ));
361:
362: insert into FEM_OBJECT_TYPES_TL (
363: OBJECT_TYPE_CODE,
364: OBJECT_TYPE_NAME,
365: DESCRIPTION,
366: CREATION_DATE,

Line 384: from FEM_OBJECT_TYPES_TL B, FND_LANGUAGES L

380: B.LAST_UPDATE_DATE,
381: B.LAST_UPDATE_LOGIN,
382: L.LANGUAGE_CODE,
383: B.SOURCE_LANG
384: from FEM_OBJECT_TYPES_TL B, FND_LANGUAGES L
385: where L.INSTALLED_FLAG in ('I', 'B')
386: and B.LANGUAGE = userenv('LANG')
387: and not exists
388: (select NULL

Line 389: from FEM_OBJECT_TYPES_TL T

385: where L.INSTALLED_FLAG in ('I', 'B')
386: and B.LANGUAGE = userenv('LANG')
387: and not exists
388: (select NULL
389: from FEM_OBJECT_TYPES_TL T
390: where T.OBJECT_TYPE_CODE = B.OBJECT_TYPE_CODE
391: and T.LANGUAGE = L.LANGUAGE_CODE);
392: end ADD_LANGUAGE;
393: PROCEDURE TRANSLATE_ROW(

Line 419: from FEM_OBJECT_TYPES_TL

415: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
416: begin
417: select LAST_UPDATED_BY, LAST_UPDATE_DATE
418: into db_luby, db_ludate
419: from FEM_OBJECT_TYPES_TL
420: where OBJECT_TYPE_CODE = x_OBJECT_TYPE_CODE
421: and LANGUAGE = userenv('LANG');
422:
423: -- Test for customization and version

Line 427: update FEM_OBJECT_TYPES_TL set

423: -- Test for customization and version
424: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
425: db_ludate, x_custom_mode)) then
426: -- Update translations for this language
427: update FEM_OBJECT_TYPES_TL set
428: OBJECT_TYPE_NAME = decode(x_OBJECT_TYPE_NAME,
429: fnd_load_util.null_value, null, -- Real null
430: null, x_OBJECT_TYPE_NAME, -- No change
431: x_OBJECT_TYPE_NAME),