eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_DESCRIPTORS_PKG dependencies on ICX_CAT_DESCRIPTORS_TL

Line 37: cursor C is select ROWID from ICX_CAT_DESCRIPTORS_TL

33: X_STORED_IN_COLUMN in VARCHAR2,
34: X_SECTION_TAG in NUMBER,
35: X_CLASS in VARCHAR2
36: ) is
37: cursor C is select ROWID from ICX_CAT_DESCRIPTORS_TL
38: where RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID
39: and LANGUAGE = userenv('LANG')
40: ;
41: begin

Line 42: insert into ICX_CAT_DESCRIPTORS_TL (

38: where RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID
39: and LANGUAGE = userenv('LANG')
40: ;
41: begin
42: insert into ICX_CAT_DESCRIPTORS_TL (
43: RT_DESCRIPTOR_ID,
44: KEY,
45: DESCRIPTOR_NAME,
46: DESCRIPTION,

Line 112: from ICX_CAT_DESCRIPTORS_TL T

108: from FND_LANGUAGES L
109: where L.INSTALLED_FLAG in ('I', 'B')
110: and not exists
111: (select NULL
112: from ICX_CAT_DESCRIPTORS_TL T
113: where T.RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:
116: open c;

Line 164: from ICX_CAT_DESCRIPTORS_TL

160: DEFAULTVALUE,
161: MULTI_VALUE_TYPE,
162: MULTI_VALUE_KEY,
163: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
164: from ICX_CAT_DESCRIPTORS_TL
165: where RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID
166: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
167: for update of RT_DESCRIPTOR_ID nowait;
168: begin

Line 254: update ICX_CAT_DESCRIPTORS_TL o set

250: --be no row with the last_updated_by <> -1.
251: --and the secpnd sql updates the translated values, for the descriptors
252: --which were not already translated by the customers
253: --due the clause (userenv('LANG') in (LANGUAGE, SOURCE_LANG))
254: update ICX_CAT_DESCRIPTORS_TL o set
255: KEY = X_KEY,
256: RT_CATEGORY_ID = X_RT_CATEGORY_ID,
257: TYPE = X_TYPE,
258: SEARCH_RESULTS_VISIBLE = X_SEARCH_RESULTS_VISIBLE,

Line 276: and not exists ( select null from ICX_CAT_DESCRIPTORS_TL i

272: STORED_IN_COLUMN = X_STORED_IN_COLUMN,
273: SECTION_TAG = X_SECTION_TAG,
274: CLASS = X_CLASS
275: where RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID
276: and not exists ( select null from ICX_CAT_DESCRIPTORS_TL i
277: where i.RT_DESCRIPTOR_ID = o.RT_DESCRIPTOR_ID
278: and i.LAST_UPDATED_BY <> -1);
279:
280: update ICX_CAT_DESCRIPTORS_TL set

Line 280: update ICX_CAT_DESCRIPTORS_TL set

276: and not exists ( select null from ICX_CAT_DESCRIPTORS_TL i
277: where i.RT_DESCRIPTOR_ID = o.RT_DESCRIPTOR_ID
278: and i.LAST_UPDATED_BY <> -1);
279:
280: update ICX_CAT_DESCRIPTORS_TL set
281: DESCRIPTOR_NAME = X_DESCRIPTOR_NAME,
282: DESCRIPTION = X_DESCRIPTION,
283: VALIDATED = X_VALIDATED,
284: TITLE = X_TITLE,

Line 308: delete from ICX_CAT_DESCRIPTORS_TL

304: procedure DELETE_ROW (
305: X_RT_DESCRIPTOR_ID in NUMBER
306: ) is
307: begin
308: delete from ICX_CAT_DESCRIPTORS_TL
309: where RT_DESCRIPTOR_ID = X_RT_DESCRIPTOR_ID;
310:
311: if (sql%notfound) then
312: raise no_data_found;

Line 325: update icx_cat_descriptors_tl set

321: X_DESCRIPTOR_NAME in VARCHAR2,
322: X_DESCRIPTION in VARCHAR2) is
323: begin
324:
325: update icx_cat_descriptors_tl set
326: descriptor_name = nvl(X_DESCRIPTOR_NAME, DESCRIPTOR_NAME),
327: description = nvl(X_DESCRIPTION, DESCRIPTION),
328: source_lang = userenv('LANG'),
329: last_update_date = sysdate,

Line 448: update ICX_CAT_DESCRIPTORS_TL T set (

444: procedure ADD_LANGUAGE
445: is
446: begin
447: /* comment out for bug 2085107
448: update ICX_CAT_DESCRIPTORS_TL T set (
449: DESCRIPTOR_NAME,
450: DESCRIPTION
451: ) = (select
452: B.DESCRIPTOR_NAME,

Line 454: from ICX_CAT_DESCRIPTORS_TL B

450: DESCRIPTION
451: ) = (select
452: B.DESCRIPTOR_NAME,
453: B.DESCRIPTION
454: from ICX_CAT_DESCRIPTORS_TL B
455: where B.RT_DESCRIPTOR_ID = T.RT_DESCRIPTOR_ID
456: and B.LANGUAGE = T.SOURCE_LANG)
457: where (
458: T.RT_DESCRIPTOR_ID,

Line 463: from ICX_CAT_DESCRIPTORS_TL SUBB, ICX_POR_DESCRIPTORS_TL SUBT

459: T.LANGUAGE
460: ) in (select
461: SUBT.RT_DESCRIPTOR_ID,
462: SUBT.LANGUAGE
463: from ICX_CAT_DESCRIPTORS_TL SUBB, ICX_POR_DESCRIPTORS_TL SUBT
464: where SUBB.RT_DESCRIPTOR_ID = SUBT.RT_DESCRIPTOR_ID
465: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
466: and (SUBB.DESCRIPTOR_NAME <> SUBT.DESCRIPTOR_NAME
467: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 474: insert into ICX_CAT_DESCRIPTORS_TL (

470: ));
471: */
472:
473:
474: insert into ICX_CAT_DESCRIPTORS_TL (
475: RT_DESCRIPTOR_ID,
476: KEY,
477: DESCRIPTOR_NAME,
478: DESCRIPTION,

Line 542: from ICX_CAT_DESCRIPTORS_TL B, FND_LANGUAGES L

538: L.LANGUAGE_CODE,
539: B.SOURCE_LANG,
540: B.STORED_IN_TABLE,
541: B.STORED_IN_COLUMN
542: from ICX_CAT_DESCRIPTORS_TL B, FND_LANGUAGES L
543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL

Line 547: from ICX_CAT_DESCRIPTORS_TL T

543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL
547: from ICX_CAT_DESCRIPTORS_TL T
548: where T.RT_DESCRIPTOR_ID = B.RT_DESCRIPTOR_ID
549: and T.LANGUAGE = L.LANGUAGE_CODE);
550:
551: end ADD_LANGUAGE;