APPS.FEM_OBJECT_CATALOG_PKG dependencies on FEM_OBJECT_CATALOG_TL

Line 52: insert into FEM_OBJECT_CATALOG_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into FEM_OBJECT_CATALOG_TL (
53: OBJECT_ID,
54: OBJECT_NAME,
55: DESCRIPTION,
56: CREATED_BY,

Line 78: from FEM_OBJECT_CATALOG_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_OBJECT_CATALOG_TL T
79: where T.OBJECT_ID = X_OBJECT_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from FEM_OBJECT_CATALOG_TL

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

Line 193: update FEM_OBJECT_CATALOG_TL set

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: update FEM_OBJECT_CATALOG_TL set
194: OBJECT_NAME = X_OBJECT_NAME,
195: DESCRIPTION = X_DESCRIPTION,
196: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
197: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 212: delete from FEM_OBJECT_CATALOG_TL

208: procedure DELETE_ROW (
209: X_OBJECT_ID in NUMBER
210: ) is
211: begin
212: delete from FEM_OBJECT_CATALOG_TL
213: where OBJECT_ID = X_OBJECT_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 230: delete from FEM_OBJECT_CATALOG_TL T

226:
227: procedure ADD_LANGUAGE
228: is
229: begin
230: delete from FEM_OBJECT_CATALOG_TL T
231: where not exists
232: (select NULL
233: from FEM_OBJECT_CATALOG_B B
234: where B.OBJECT_ID = T.OBJECT_ID

Line 237: update FEM_OBJECT_CATALOG_TL T set (

233: from FEM_OBJECT_CATALOG_B B
234: where B.OBJECT_ID = T.OBJECT_ID
235: );
236:
237: update FEM_OBJECT_CATALOG_TL T set (
238: OBJECT_NAME,
239: DESCRIPTION
240: ) = (select
241: B.OBJECT_NAME,

Line 243: from FEM_OBJECT_CATALOG_TL B

239: DESCRIPTION
240: ) = (select
241: B.OBJECT_NAME,
242: B.DESCRIPTION
243: from FEM_OBJECT_CATALOG_TL B
244: where B.OBJECT_ID = T.OBJECT_ID
245: and B.LANGUAGE = T.SOURCE_LANG)
246: where (
247: T.OBJECT_ID,

Line 252: from FEM_OBJECT_CATALOG_TL SUBB, FEM_OBJECT_CATALOG_TL SUBT

248: T.LANGUAGE
249: ) in (select
250: SUBT.OBJECT_ID,
251: SUBT.LANGUAGE
252: from FEM_OBJECT_CATALOG_TL SUBB, FEM_OBJECT_CATALOG_TL SUBT
253: where SUBB.OBJECT_ID = SUBT.OBJECT_ID
254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.OBJECT_NAME <> SUBT.OBJECT_NAME
256: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 261: insert into FEM_OBJECT_CATALOG_TL (

257: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
258: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
259: ));
260:
261: insert into FEM_OBJECT_CATALOG_TL (
262: OBJECT_ID,
263: OBJECT_NAME,
264: DESCRIPTION,
265: CREATED_BY,

Line 283: from FEM_OBJECT_CATALOG_TL B, FND_LANGUAGES L

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

Line 288: from FEM_OBJECT_CATALOG_TL T

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

Line 318: from FEM_OBJECT_CATALOG_TL

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

Line 326: update FEM_OBJECT_CATALOG_TL set

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