[Home] [Help]
46: , X_VIEW_APPL_ID
47: , X_LOOKUP_TYPE
48: );
49:
50: INSERT INTO OKE_TERMS_TL
51: ( TERM_CODE
52: , CREATION_DATE
53: , CREATED_BY
54: , LAST_UPDATE_DATE
73: FROM FND_LANGUAGES L
74: WHERE L.INSTALLED_FLAG IN ('I', 'B')
75: AND NOT EXISTS
76: (SELECT NULL
77: FROM OKE_TERMS_TL T
78: WHERE T.TERM_CODE = X_TERM_CODE
79: AND T.LANGUAGE = L.LANGUAGE_CODE
80: );
81:
113: CURSOR c1 IS
114: SELECT TERM_NAME
115: , DESCRIPTION
116: , DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
117: FROM OKE_TERMS_TL
118: WHERE TERM_CODE = X_TERM_CODE
119: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
120: FOR UPDATE OF TERM_CODE NOWAIT;
121:
195: IF (sql%notfound) THEN
196: RAISE no_data_found;
197: END IF;
198:
199: UPDATE OKE_TERMS_TL
200: SET TERM_NAME = X_TERM_NAME
201: , DESCRIPTION = X_DESCRIPTION
202: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
203: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
217: ( X_TERM_CODE IN VARCHAR2
218: ) IS
219:
220: BEGIN
221: DELETE FROM OKE_TERMS_TL
222: WHERE TERM_CODE = X_TERM_CODE;
223:
224: IF (sql%notfound) THEN
225: RAISE no_data_found;
238: PROCEDURE ADD_LANGUAGE
239: IS
240: BEGIN
241:
242: DELETE FROM OKE_TERMS_TL T
243: WHERE NOT EXISTS (
244: SELECT NULL
245: FROM OKE_TERMS_B B
246: WHERE B.TERM_CODE = T.TERM_CODE
245: FROM OKE_TERMS_B B
246: WHERE B.TERM_CODE = T.TERM_CODE
247: );
248:
249: UPDATE OKE_TERMS_TL T
250: SET ( TERM_NAME , DESCRIPTION ) = (
251: SELECT B.TERM_NAME
252: , B.DESCRIPTION
253: FROM OKE_TERMS_TL B
249: UPDATE OKE_TERMS_TL T
250: SET ( TERM_NAME , DESCRIPTION ) = (
251: SELECT B.TERM_NAME
252: , B.DESCRIPTION
253: FROM OKE_TERMS_TL B
254: WHERE B.TERM_CODE = T.TERM_CODE
255: AND B.LANGUAGE = T.SOURCE_LANG)
256: WHERE ( T.TERM_CODE , T.LANGUAGE ) IN (
257: SELECT SUBT.TERM_CODE
255: AND B.LANGUAGE = T.SOURCE_LANG)
256: WHERE ( T.TERM_CODE , T.LANGUAGE ) IN (
257: SELECT SUBT.TERM_CODE
258: , SUBT.LANGUAGE
259: FROM OKE_TERMS_TL SUBB
260: , OKE_TERMS_TL SUBT
261: WHERE SUBB.TERM_CODE = SUBT.TERM_CODE
262: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
263: AND ( SUBB.TERM_NAME <> SUBT.TERM_NAME
256: WHERE ( T.TERM_CODE , T.LANGUAGE ) IN (
257: SELECT SUBT.TERM_CODE
258: , SUBT.LANGUAGE
259: FROM OKE_TERMS_TL SUBB
260: , OKE_TERMS_TL SUBT
261: WHERE SUBB.TERM_CODE = SUBT.TERM_CODE
262: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
263: AND ( SUBB.TERM_NAME <> SUBT.TERM_NAME
264: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
269: AND SUBT.DESCRIPTION IS NULL)
270: )
271: );
272:
273: INSERT INTO OKE_TERMS_TL
274: ( TERM_CODE
275: , CREATION_DATE
276: , CREATED_BY
277: , LAST_UPDATE_DATE
292: , B.TERM_NAME
293: , B.DESCRIPTION
294: , L.LANGUAGE_CODE
295: , B.SOURCE_LANG
296: FROM OKE_TERMS_TL B
297: , FND_LANGUAGES L
298: WHERE L.INSTALLED_FLAG IN ('I', 'B')
299: AND B.LANGUAGE = USERENV('LANG')
300: AND NOT EXISTS (
298: WHERE L.INSTALLED_FLAG IN ('I', 'B')
299: AND B.LANGUAGE = USERENV('LANG')
300: AND NOT EXISTS (
301: SELECT NULL
302: FROM OKE_TERMS_TL T
303: WHERE T.TERM_CODE = B.TERM_CODE
304: AND T.LANGUAGE = L.LANGUAGE_CODE
305: );
306:
360: );
361:
362: END IF;
363:
364: UPDATE OKE_TERMS_TL
365: SET TERM_NAME = X_TERM_NAME
366: , DESCRIPTION = X_DESCRIPTION
367: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
368: , LAST_UPDATED_BY = f_luby
371: AND USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG );
372:
373: IF ( sql%notfound ) THEN
374:
375: INSERT INTO OKE_TERMS_TL
376: ( TERM_CODE
377: , CREATION_DATE
378: , CREATED_BY
379: , LAST_UPDATE_DATE
398: FROM FND_LANGUAGES L
399: WHERE L.INSTALLED_FLAG IN ('I', 'B')
400: AND NOT EXISTS
401: (SELECT NULL
402: FROM OKE_TERMS_TL T
403: WHERE T.TERM_CODE = X_TERM_CODE
404: AND T.LANGUAGE = L.LANGUAGE_CODE
405: );
406:
424: -- Translate owner and last_update_date
425: --
426: f_luby := FND_LOAD_UTIL.Owner_ID(X_OWNER);
427:
428: UPDATE OKE_TERMS_TL
429: SET TERM_NAME = X_TERM_NAME
430: , DESCRIPTION = X_DESCRIPTION
431: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
432: , LAST_UPDATED_BY = f_luby