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.FND_DESCR_FLEX_CONTEXTS_PKG dependencies on FND_DESCR_FLEX_CONTEXTS_TL

Line 49: insert into FND_DESCR_FLEX_CONTEXTS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FND_DESCR_FLEX_CONTEXTS_TL (
50: APPLICATION_ID,
51: DESCRIPTIVE_FLEXFIELD_NAME,
52: DESCRIPTIVE_FLEX_CONTEXT_CODE,
53: DESCRIPTION,

Line 79: from FND_DESCR_FLEX_CONTEXTS_TL T

75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from FND_DESCR_FLEX_CONTEXTS_TL T
80: where T.APPLICATION_ID = X_APPLICATION_ID
81: and T.DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
82: and T.DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
83: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 117: from FND_DESCR_FLEX_CONTEXTS_TL

113:
114: cursor c1 is select
115: DESCRIPTION,
116: DESCRIPTIVE_FLEX_CONTEXT_NAME
117: from FND_DESCR_FLEX_CONTEXTS_TL
118: where APPLICATION_ID = X_APPLICATION_ID
119: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
120: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
121: and LANGUAGE = userenv('LANG')

Line 190: update FND_DESCR_FLEX_CONTEXTS_TL set

186: if (sql%notfound) then
187: raise no_data_found;
188: end if;
189:
190: update FND_DESCR_FLEX_CONTEXTS_TL set
191: DESCRIPTION = X_DESCRIPTION,
192: DESCRIPTIVE_FLEX_CONTEXT_NAME = X_DESCRIPTIVE_FLEX_CONTEXT_NAM,
193: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
194: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 222: delete from FND_DESCR_FLEX_CONTEXTS_TL

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from FND_DESCR_FLEX_CONTEXTS_TL
223: where APPLICATION_ID = X_APPLICATION_ID
224: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
225: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD;
226:

Line 241: delete from FND_DESCR_FLEX_CONTEXTS_TL T

237: /* The following delete and update statements are commented out */
238: /* as a quick workaround to fix the time-consuming table handler issue */
239: /* Eventually we'll need to turn them into a separate fix_language procedure */
240: /*
241: delete from FND_DESCR_FLEX_CONTEXTS_TL T
242: where not exists
243: (select NULL
244: from FND_DESCR_FLEX_CONTEXTS B
245: where B.APPLICATION_ID = T.APPLICATION_ID

Line 250: update FND_DESCR_FLEX_CONTEXTS_TL T set (

246: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
247: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
248: );
249:
250: update FND_DESCR_FLEX_CONTEXTS_TL T set (
251: DESCRIPTION,
252: DESCRIPTIVE_FLEX_CONTEXT_NAME
253: ) = (select
254: B.DESCRIPTION,

Line 256: from FND_DESCR_FLEX_CONTEXTS_TL B

252: DESCRIPTIVE_FLEX_CONTEXT_NAME
253: ) = (select
254: B.DESCRIPTION,
255: B.DESCRIPTIVE_FLEX_CONTEXT_NAME
256: from FND_DESCR_FLEX_CONTEXTS_TL B
257: where B.APPLICATION_ID = T.APPLICATION_ID
258: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
259: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
260: and B.LANGUAGE = T.SOURCE_LANG)

Line 271: from FND_DESCR_FLEX_CONTEXTS_TL SUBB, FND_DESCR_FLEX_CONTEXTS_TL SUBT

267: SUBT.APPLICATION_ID,
268: SUBT.DESCRIPTIVE_FLEXFIELD_NAME,
269: SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE,
270: SUBT.LANGUAGE
271: from FND_DESCR_FLEX_CONTEXTS_TL SUBB, FND_DESCR_FLEX_CONTEXTS_TL SUBT
272: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
273: and SUBB.DESCRIPTIVE_FLEXFIELD_NAME = SUBT.DESCRIPTIVE_FLEXFIELD_NAME
274: and SUBB.DESCRIPTIVE_FLEX_CONTEXT_CODE = SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE
275: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 283: insert into FND_DESCR_FLEX_CONTEXTS_TL (

279: or SUBB.DESCRIPTIVE_FLEX_CONTEXT_NAME <> SUBT.DESCRIPTIVE_FLEX_CONTEXT_NAME
280: ));
281: */
282:
283: insert into FND_DESCR_FLEX_CONTEXTS_TL (
284: APPLICATION_ID,
285: DESCRIPTIVE_FLEXFIELD_NAME,
286: DESCRIPTIVE_FLEX_CONTEXT_CODE,
287: DESCRIPTION,

Line 309: from FND_DESCR_FLEX_CONTEXTS_TL B, FND_LANGUAGES L

305: B.LAST_UPDATE_LOGIN,
306: B.DESCRIPTIVE_FLEX_CONTEXT_NAME,
307: L.LANGUAGE_CODE,
308: B.SOURCE_LANG
309: from FND_DESCR_FLEX_CONTEXTS_TL B, FND_LANGUAGES L
310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL

Line 314: from FND_DESCR_FLEX_CONTEXTS_TL T

310: where L.INSTALLED_FLAG in ('I', 'B')
311: and B.LANGUAGE = userenv('LANG')
312: and not exists
313: (select NULL
314: from FND_DESCR_FLEX_CONTEXTS_TL T
315: where T.APPLICATION_ID = B.APPLICATION_ID
316: and T.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
317: and T.DESCRIPTIVE_FLEX_CONTEXT_CODE = B.DESCRIPTIVE_FLEX_CONTEXT_CODE
318: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 379: UPDATE fnd_descr_flex_contexts_tl SET

375: x_description IN VARCHAR2,
376: x_descriptive_flex_context_nam IN VARCHAR2)
377: IS
378: BEGIN
379: UPDATE fnd_descr_flex_contexts_tl SET
380: description = Nvl(x_description, description),
381: descriptive_flex_context_name = Nvl(x_descriptive_flex_context_nam,
382: descriptive_flex_context_name),
383: last_update_date = x_who.last_update_date,