[Home] [Help]
40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into FWK_TBX_LOOKUP_CODES_TL (
45: LAST_UPDATE_DATE,
46: LAST_UPDATED_BY,
47: CREATION_DATE,
48: CREATED_BY,
68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from FWK_TBX_LOOKUP_CODES_TL T
73: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
74: and T.LOOKUP_CODE = X_LOOKUP_CODE
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
104: cursor c1 is select
105: MEANING,
106: DESCRIPTION,
107: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
108: from FWK_TBX_LOOKUP_CODES_TL
109: where LOOKUP_TYPE = X_LOOKUP_TYPE
110: and LOOKUP_CODE = X_LOOKUP_CODE
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of LOOKUP_TYPE nowait;
170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: update FWK_TBX_LOOKUP_CODES_TL set
175: MEANING = X_MEANING,
176: DESCRIPTION = X_DESCRIPTION,
177: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
178: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
191: X_LOOKUP_TYPE in VARCHAR2,
192: X_LOOKUP_CODE in VARCHAR2
193: ) is
194: begin
195: delete from FWK_TBX_LOOKUP_CODES_TL
196: where LOOKUP_TYPE = X_LOOKUP_TYPE
197: and LOOKUP_CODE = X_LOOKUP_CODE;
198:
199: if (sql%notfound) then
211:
212: procedure ADD_LANGUAGE
213: is
214: begin
215: delete from FWK_TBX_LOOKUP_CODES_TL T
216: where not exists
217: (select NULL
218: from FWK_TBX_LOOKUP_CODES_B B
219: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
219: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
220: and B.LOOKUP_CODE = T.LOOKUP_CODE
221: );
222:
223: update FWK_TBX_LOOKUP_CODES_TL T set (
224: MEANING,
225: DESCRIPTION
226: ) = (select
227: B.MEANING,
225: DESCRIPTION
226: ) = (select
227: B.MEANING,
228: B.DESCRIPTION
229: from FWK_TBX_LOOKUP_CODES_TL B
230: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
231: and B.LOOKUP_CODE = T.LOOKUP_CODE
232: and B.LANGUAGE = T.SOURCE_LANG)
233: where (
237: ) in (select
238: SUBT.LOOKUP_TYPE,
239: SUBT.LOOKUP_CODE,
240: SUBT.LANGUAGE
241: from FWK_TBX_LOOKUP_CODES_TL SUBB, FWK_TBX_LOOKUP_CODES_TL SUBT
242: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
243: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.MEANING <> SUBT.MEANING
247: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
248: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
249: ));
250:
251: insert into FWK_TBX_LOOKUP_CODES_TL (
252: LAST_UPDATE_DATE,
253: LAST_UPDATED_BY,
254: CREATION_DATE,
255: CREATED_BY,
271: B.MEANING,
272: B.DESCRIPTION,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from FWK_TBX_LOOKUP_CODES_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from FWK_TBX_LOOKUP_CODES_TL T
281: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
282: and T.LOOKUP_CODE = B.LOOKUP_CODE
283: and T.LANGUAGE = L.LANGUAGE_CODE);
284: end ADD_LANGUAGE;
303: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
304:
305: select LAST_UPDATED_BY, LAST_UPDATE_DATE
306: into db_luby, db_ludate
307: from FWK_TBX_LOOKUP_CODES_TL
308: where LOOKUP_TYPE = X_LOOKUP_TYPE
309: and LOOKUP_CODE = X_LOOKUP_CODE
310: and LANGUAGE = userenv('LANG');
311:
315: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
316:
317: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
318: db_ludate, X_CUSTOM_MODE)) then
319: update FWK_TBX_LOOKUP_CODES_TL set
320: MEANING = nvl(X_MEANING, meaning),
321: DESCRIPTION = nvl(X_DESCRIPTION, description),
322: LAST_UPDATE_DATE = f_ludate,
323: LAST_UPDATED_BY = f_luby,
357: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
358:
359: select LAST_UPDATED_BY, LAST_UPDATE_DATE
360: into db_luby, db_ludate
361: from FWK_TBX_LOOKUP_CODES_TL
362: where LOOKUP_TYPE = X_LOOKUP_TYPE
363: and LOOKUP_CODE = X_LOOKUP_CODE
364: and LANGUAGE = userenv('LANG');
365: