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_COL_USAGE_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 98: insert into FND_DESCR_FLEX_COL_USAGE_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into FND_DESCR_FLEX_COL_USAGE_TL (
99: APPLICATION_ID,
100: DESCRIPTIVE_FLEXFIELD_NAME,
101: DESCRIPTIVE_FLEX_CONTEXT_CODE,
102: APPLICATION_COLUMN_NAME,

Line 132: from FND_DESCR_FLEX_COL_USAGE_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from FND_DESCR_FLEX_COL_USAGE_TL T
133: where T.APPLICATION_ID = X_APPLICATION_ID
134: and T.DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
135: and T.DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
136: and T.APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 202: from FND_DESCR_FLEX_COL_USAGE_TL

198: FORM_LEFT_PROMPT,
199: FORM_ABOVE_PROMPT,
200: DESCRIPTION,
201: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
202: from FND_DESCR_FLEX_COL_USAGE_TL
203: where APPLICATION_ID = X_APPLICATION_ID
204: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
205: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
206: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 319: update FND_DESCR_FLEX_COL_USAGE_TL set

315: if (sql%notfound) then
316: raise no_data_found;
317: end if;
318:
319: update FND_DESCR_FLEX_COL_USAGE_TL set
320: FORM_LEFT_PROMPT = X_FORM_LEFT_PROMPT,
321: FORM_ABOVE_PROMPT = X_FORM_ABOVE_PROMPT,
322: DESCRIPTION = X_DESCRIPTION,
323: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 345: delete from FND_DESCR_FLEX_COL_USAGE_TL

341: X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2,
342: X_APPLICATION_COLUMN_NAME in VARCHAR2
343: ) is
344: begin
345: delete from FND_DESCR_FLEX_COL_USAGE_TL
346: where APPLICATION_ID = X_APPLICATION_ID
347: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
348: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
349: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line 375: delete from FND_DESCR_FLEX_COL_USAGE_TL T

371: /* The following delete and update statements are commented out */
372: /* as a quick workaround to fix the time-consuming table handler issue */
373: /* Eventually we'll need to turn them into a separate fix_language procedure */
374: /*
375: delete from FND_DESCR_FLEX_COL_USAGE_TL T
376: where not exists
377: (select NULL
378: from FND_DESCR_FLEX_COLUMN_USAGES B
379: where B.APPLICATION_ID = T.APPLICATION_ID

Line 385: update FND_DESCR_FLEX_COL_USAGE_TL T set (

381: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
382: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
383: );
384:
385: update FND_DESCR_FLEX_COL_USAGE_TL T set (
386: FORM_LEFT_PROMPT,
387: FORM_ABOVE_PROMPT,
388: DESCRIPTION
389: ) = (select

Line 393: from FND_DESCR_FLEX_COL_USAGE_TL B

389: ) = (select
390: B.FORM_LEFT_PROMPT,
391: B.FORM_ABOVE_PROMPT,
392: B.DESCRIPTION
393: from FND_DESCR_FLEX_COL_USAGE_TL B
394: where B.APPLICATION_ID = T.APPLICATION_ID
395: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
396: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
397: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME

Line 411: from FND_DESCR_FLEX_COL_USAGE_TL SUBB, FND_DESCR_FLEX_COL_USAGE_TL SUBT

407: SUBT.DESCRIPTIVE_FLEXFIELD_NAME,
408: SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE,
409: SUBT.APPLICATION_COLUMN_NAME,
410: SUBT.LANGUAGE
411: from FND_DESCR_FLEX_COL_USAGE_TL SUBB, FND_DESCR_FLEX_COL_USAGE_TL SUBT
412: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
413: and SUBB.DESCRIPTIVE_FLEXFIELD_NAME = SUBT.DESCRIPTIVE_FLEXFIELD_NAME
414: and SUBB.DESCRIPTIVE_FLEX_CONTEXT_CODE = SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE
415: and SUBB.APPLICATION_COLUMN_NAME = SUBT.APPLICATION_COLUMN_NAME

Line 425: insert /+ append parallel(tt) / into FND_DESCR_FLEX_COL_USAGE_TL tt (

421: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
422: ));
423: */
424:
425: insert /*+ append parallel(tt) */ into FND_DESCR_FLEX_COL_USAGE_TL tt (
426: APPLICATION_ID,
427: DESCRIPTIVE_FLEXFIELD_NAME,
428: DESCRIPTIVE_FLEX_CONTEXT_CODE,
429: APPLICATION_COLUMN_NAME,

Line 457: from FND_DESCR_FLEX_COL_USAGE_TL B, FND_LANGUAGES L

453: B.FORM_ABOVE_PROMPT,
454: B.DESCRIPTION,
455: L.LANGUAGE_CODE,
456: B.SOURCE_LANG
457: from FND_DESCR_FLEX_COL_USAGE_TL B, FND_LANGUAGES L
458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: ) v, FND_DESCR_FLEX_COL_USAGE_TL t
461: where t.application_id(+) = v.application_id

Line 460: ) v, FND_DESCR_FLEX_COL_USAGE_TL t

456: B.SOURCE_LANG
457: from FND_DESCR_FLEX_COL_USAGE_TL B, FND_LANGUAGES L
458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: ) v, FND_DESCR_FLEX_COL_USAGE_TL t
461: where t.application_id(+) = v.application_id
462: and t.descriptive_flexfield_name(+) = v.descriptive_flexfield_name
463: and t.descriptive_flex_context_code(+) = v.descriptive_flex_context_code
464: and t.application_column_name(+) = v.application_column_name

Line 600: UPDATE fnd_descr_flex_col_usage_tl SET

596: x_form_above_prompt IN VARCHAR2,
597: x_description IN VARCHAR2)
598: IS
599: BEGIN
600: UPDATE fnd_descr_flex_col_usage_tl SET
601: form_left_prompt = Nvl(x_form_left_prompt, form_left_prompt),
602: form_above_prompt = Nvl(x_form_above_prompt, form_above_prompt),
603: description = Nvl(x_description, description),
604: last_update_date = x_who.last_update_date,