24: X_STORED_IN_COLUMN IN VARCHAR2,
25: X_SECTION_TAG IN NUMBER) IS
26: CURSOR C IS
27: SELECT ROWID
28: FROM ICX_CAT_ATTRIBUTES_TL
29: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID
30: AND LANGUAGE = userenv('LANG');
31: BEGIN
32: INSERT INTO ICX_CAT_ATTRIBUTES_TL
28: FROM ICX_CAT_ATTRIBUTES_TL
29: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID
30: AND LANGUAGE = userenv('LANG');
31: BEGIN
32: INSERT INTO ICX_CAT_ATTRIBUTES_TL
33: (ATTRIBUTE_ID,
34: KEY,
35: ATTRIBUTE_NAME,
36: DESCRIPTION,
79: FROM FND_LANGUAGES L
80: WHERE L.INSTALLED_FLAG IN ('I', 'B')
81: AND NOT EXISTS
82: (SELECT NULL
83: FROM ICX_CAT_ATTRIBUTES_TL T
84: WHERE T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
85: AND T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: OPEN c;
120: decode(LANGUAGE,
121: userenv('LANG'),
122: 'Y',
123: 'N') BASELANG
124: FROM ICX_CAT_ATTRIBUTES_TL
125: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID
126: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
127: FOR UPDATE OF ATTRIBUTE_ID NOWAIT;
128: BEGIN
189: --be no row with the last_updated_by <> -1.
190: --and the secpnd sql updates the translated values, for the descriptors
191: --which were not already translated by the customers
192: --due the clause (userenv('LANG') in (LANGUAGE, SOURCE_LANG))
193: UPDATE ICX_CAT_ATTRIBUTES_TL o
194: SET KEY = X_KEY,
195: RT_CATEGORY_ID = X_RT_CATEGORY_ID,
196: TYPE = X_TYPE,
197: SEARCH_RESULTS_VISIBLE = X_SEARCH_RESULTS_VISIBLE,
208: STORED_IN_COLUMN = X_STORED_IN_COLUMN,
209: SECTION_TAG = X_SECTION_TAG
210: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID
211: AND NOT EXISTS (SELECT NULL
212: FROM ICX_CAT_ATTRIBUTES_TL i
213: WHERE i.ATTRIBUTE_ID = o.ATTRIBUTE_ID
214: AND i.LAST_UPDATED_BY <> -1);
215:
216: UPDATE ICX_CAT_ATTRIBUTES_TL
212: FROM ICX_CAT_ATTRIBUTES_TL i
213: WHERE i.ATTRIBUTE_ID = o.ATTRIBUTE_ID
214: AND i.LAST_UPDATED_BY <> -1);
215:
216: UPDATE ICX_CAT_ATTRIBUTES_TL
217: SET ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
218: DESCRIPTION = X_DESCRIPTION,
219: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
220: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
233: END UPDATE_ROW;
234:
235: PROCEDURE DELETE_ROW(X_ATTRIBUTE_ID IN NUMBER) IS
236: BEGIN
237: DELETE FROM ICX_CAT_ATTRIBUTES_TL
238: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID;
239:
240: IF (SQL%NOTFOUND)
241: THEN
267: SELECT LAST_UPDATED_BY,
268: LAST_UPDATE_DATE
269: INTO db_luby,
270: db_ludate
271: FROM ICX_CAT_ATTRIBUTES_TL
272: WHERE LANGUAGE = userenv('LANG')
273: AND ATTRIBUTE_ID = to_number(X_ATTRIBUTE_ID);
274:
275: -- Update record, honoring customization mode.
282: p_db_id => db_luby,
283: p_db_lud => db_ludate,
284: p_custom_mode => X_CUSTOM_MODE))
285: THEN
286: UPDATE ICX_CAT_ATTRIBUTES_TL
287: SET ATTRIBUTE_NAME = nvl(X_ATTRIBUTE_NAME,
288: ATTRIBUTE_NAME),
289: description = nvl(X_DESCRIPTION,
290: DESCRIPTION),
335: SELECT LAST_UPDATED_BY,
336: LAST_UPDATE_DATE
337: INTO db_luby,
338: db_ludate
339: FROM ICX_CAT_ATTRIBUTES_TL
340: WHERE LANGUAGE = userenv('LANG')
341: AND ATTRIBUTE_ID = to_number(X_ATTRIBUTE_ID);
342:
343:
401:
402:
403: PROCEDURE ADD_LANGUAGE IS
404: BEGIN
405: INSERT INTO ICX_CAT_ATTRIBUTES_TL
406: (ATTRIBUTE_ID,
407: KEY,
408: ATTRIBUTE_NAME,
409: DESCRIPTION,
448: L.LANGUAGE_CODE,
449: B.SOURCE_LANG,
450: B.STORED_IN_TABLE,
451: B.STORED_IN_COLUMN
452: FROM ICX_CAT_ATTRIBUTES_TL B,
453: FND_LANGUAGES L
454: WHERE L.INSTALLED_FLAG IN ('I', 'B')
455: AND B.LANGUAGE = userenv('LANG')
456: AND NOT EXISTS
454: WHERE L.INSTALLED_FLAG IN ('I', 'B')
455: AND B.LANGUAGE = userenv('LANG')
456: AND NOT EXISTS
457: (SELECT NULL
458: FROM ICX_CAT_ATTRIBUTES_TL T
459: WHERE T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
460: AND T.LANGUAGE = L.LANGUAGE_CODE);
461:
462: END ADD_LANGUAGE;