APPS.ICX_CAT_ATTRIBUTES_PVT dependencies on ICX_CAT_ATTRIBUTES_TL

Line 28: FROM ICX_CAT_ATTRIBUTES_TL

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

Line 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,

Line 83: FROM ICX_CAT_ATTRIBUTES_TL T

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;

Line 124: FROM ICX_CAT_ATTRIBUTES_TL

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

Line 193: UPDATE ICX_CAT_ATTRIBUTES_TL o

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,

Line 212: FROM ICX_CAT_ATTRIBUTES_TL i

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

Line 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,

Line 237: DELETE FROM ICX_CAT_ATTRIBUTES_TL

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

Line 271: FROM ICX_CAT_ATTRIBUTES_TL

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.

Line 286: UPDATE ICX_CAT_ATTRIBUTES_TL

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),

Line 339: FROM ICX_CAT_ATTRIBUTES_TL

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:

Line 405: INSERT INTO ICX_CAT_ATTRIBUTES_TL

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,

Line 452: FROM ICX_CAT_ATTRIBUTES_TL B,

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

Line 458: FROM ICX_CAT_ATTRIBUTES_TL T

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;