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_DESCRIPTIVE_FLEXS_PKG dependencies on FND_DESCRIPTIVE_FLEXS

Line 1: package body FND_DESCRIPTIVE_FLEXS_PKG as

1: package body FND_DESCRIPTIVE_FLEXS_PKG as
2: /* $Header: AFFFDFFB.pls 120.11.12010000.1 2008/07/25 14:13:48 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 33: cursor C is select ROWID from FND_DESCRIPTIVE_FLEXS

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from FND_DESCRIPTIVE_FLEXS
34: where APPLICATION_ID = X_APPLICATION_ID
35: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
36: ;
37:

Line 49: insert into FND_DESCRIPTIVE_FLEXS (

45: END IF;
46: ELSE
47: l_context_synchronization_flag := X_CONTEXT_SYNCHRONIZATION_FLAG;
48: END IF;
49: insert into FND_DESCRIPTIVE_FLEXS (
50: CONCATENATED_SEGS_VIEW_NAME,
51: APPLICATION_ID,
52: APPLICATION_TABLE_NAME,
53: DESCRIPTIVE_FLEXFIELD_NAME,

Line 99: insert into FND_DESCRIPTIVE_FLEXS_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into FND_DESCRIPTIVE_FLEXS_TL (
100: APPLICATION_ID,
101: DESCRIPTIVE_FLEXFIELD_NAME,
102: TITLE,
103: LAST_UPDATE_DATE,

Line 129: from FND_DESCRIPTIVE_FLEXS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from FND_DESCRIPTIVE_FLEXS_TL T
130: where T.APPLICATION_ID = X_APPLICATION_ID
131: and T.DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
132: and T.LANGUAGE = L.LANGUAGE_CODE);
133:

Line 184: from FND_DESCRIPTIVE_FLEXS

180: CONTEXT_DEFAULT_VALUE,
181: CONTEXT_OVERRIDE_VALUE_SET_ID,
182: CONTEXT_RUNTIME_PROPERTY_FUNCT,
183: CONTEXT_SYNCHRONIZATION_FLAG
184: from FND_DESCRIPTIVE_FLEXS
185: where APPLICATION_ID = X_APPLICATION_ID
186: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
187: for update of APPLICATION_ID nowait;
188: recinfo c%rowtype;

Line 195: from FND_DESCRIPTIVE_FLEXS_TL

191: TITLE,
192: FORM_CONTEXT_PROMPT,
193: DESCRIPTION,
194: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
195: from FND_DESCRIPTIVE_FLEXS_TL
196: where APPLICATION_ID = X_APPLICATION_ID
197: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of APPLICATION_ID nowait;

Line 294: update FND_DESCRIPTIVE_FLEXS set

290: END IF;
291: ELSE
292: l_context_synchronization_flag := X_CONTEXT_SYNCHRONIZATION_FLAG;
293: END IF;
294: update FND_DESCRIPTIVE_FLEXS set
295: CONCATENATED_SEGS_VIEW_NAME = X_CONCATENATED_SEGS_VIEW_NAME,
296: APPLICATION_TABLE_NAME = X_APPLICATION_TABLE_NAME,
297: TABLE_APPLICATION_ID = X_TABLE_APPLICATION_ID,
298: CONTEXT_REQUIRED_FLAG = X_CONTEXT_REQUIRED_FLAG,

Line 321: update FND_DESCRIPTIVE_FLEXS_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update FND_DESCRIPTIVE_FLEXS_TL set
322: TITLE = X_TITLE,
323: FORM_CONTEXT_PROMPT = X_FORM_CONTEXT_PROMPT,
324: DESCRIPTION = X_DESCRIPTION,
325: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 343: delete from FND_DESCRIPTIVE_FLEXS_TL

339: X_APPLICATION_ID in NUMBER,
340: X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2
341: ) is
342: begin
343: delete from FND_DESCRIPTIVE_FLEXS_TL
344: where APPLICATION_ID = X_APPLICATION_ID
345: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME;
346:
347: if (sql%notfound) then

Line 351: delete from FND_DESCRIPTIVE_FLEXS

347: if (sql%notfound) then
348: raise no_data_found;
349: end if;
350:
351: delete from FND_DESCRIPTIVE_FLEXS
352: where APPLICATION_ID = X_APPLICATION_ID
353: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME;
354:
355: if (sql%notfound) then

Line 369: delete from FND_DESCRIPTIVE_FLEXS_TL T

365: /* The following delete and update statements are commented out */
366: /* as a quick workaround to fix the time-consuming table handler issue */
367: /* Eventually we'll need to turn them into a separate fix_language procedure */
368: /*
369: delete from FND_DESCRIPTIVE_FLEXS_TL T
370: where not exists
371: (select NULL
372: from FND_DESCRIPTIVE_FLEXS B
373: where B.APPLICATION_ID = T.APPLICATION_ID

Line 372: from FND_DESCRIPTIVE_FLEXS B

368: /*
369: delete from FND_DESCRIPTIVE_FLEXS_TL T
370: where not exists
371: (select NULL
372: from FND_DESCRIPTIVE_FLEXS B
373: where B.APPLICATION_ID = T.APPLICATION_ID
374: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
375: );
376:

Line 377: update FND_DESCRIPTIVE_FLEXS_TL T set (

373: where B.APPLICATION_ID = T.APPLICATION_ID
374: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
375: );
376:
377: update FND_DESCRIPTIVE_FLEXS_TL T set (
378: TITLE,
379: FORM_CONTEXT_PROMPT,
380: DESCRIPTION
381: ) = (select

Line 385: from FND_DESCRIPTIVE_FLEXS_TL B

381: ) = (select
382: B.TITLE,
383: B.FORM_CONTEXT_PROMPT,
384: B.DESCRIPTION
385: from FND_DESCRIPTIVE_FLEXS_TL B
386: where B.APPLICATION_ID = T.APPLICATION_ID
387: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
388: and B.LANGUAGE = T.SOURCE_LANG)
389: where (

Line 397: from FND_DESCRIPTIVE_FLEXS_TL SUBB, FND_DESCRIPTIVE_FLEXS_TL SUBT

393: ) in (select
394: SUBT.APPLICATION_ID,
395: SUBT.DESCRIPTIVE_FLEXFIELD_NAME,
396: SUBT.LANGUAGE
397: from FND_DESCRIPTIVE_FLEXS_TL SUBB, FND_DESCRIPTIVE_FLEXS_TL SUBT
398: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
399: and SUBB.DESCRIPTIVE_FLEXFIELD_NAME = SUBT.DESCRIPTIVE_FLEXFIELD_NAME
400: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
401: and (SUBB.TITLE <> SUBT.TITLE

Line 409: insert into FND_DESCRIPTIVE_FLEXS_TL (

405: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
406: ));
407: */
408:
409: insert into FND_DESCRIPTIVE_FLEXS_TL (
410: APPLICATION_ID,
411: DESCRIPTIVE_FLEXFIELD_NAME,
412: TITLE,
413: LAST_UPDATE_DATE,

Line 435: from FND_DESCRIPTIVE_FLEXS_TL B, FND_LANGUAGES L

431: B.FORM_CONTEXT_PROMPT,
432: B.DESCRIPTION,
433: L.LANGUAGE_CODE,
434: B.SOURCE_LANG
435: from FND_DESCRIPTIVE_FLEXS_TL B, FND_LANGUAGES L
436: where L.INSTALLED_FLAG in ('I', 'B')
437: and B.LANGUAGE = userenv('LANG')
438: and not exists
439: (select NULL

Line 440: from FND_DESCRIPTIVE_FLEXS_TL T

436: where L.INSTALLED_FLAG in ('I', 'B')
437: and B.LANGUAGE = userenv('LANG')
438: and not exists
439: (select NULL
440: from FND_DESCRIPTIVE_FLEXS_TL T
441: where T.APPLICATION_ID = B.APPLICATION_ID
442: and T.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
443: and T.LANGUAGE = L.LANGUAGE_CODE);
444: end ADD_LANGUAGE;

Line 493: fnd_descriptive_flexs_pkg.update_row

489: WHERE flex_value_set_name = x_context_override_value_set_n;
490: END IF;
491:
492: BEGIN
493: fnd_descriptive_flexs_pkg.update_row
494: (X_APPLICATION_ID => l_application_id,
495: X_DESCRIPTIVE_FLEXFIELD_NAME => x_descriptive_flexfield_name,
496: X_APPLICATION_TABLE_NAME => x_application_table_name,
497: X_TABLE_APPLICATION_ID => l_table_application_id,

Line 520: fnd_descriptive_flexs_pkg.insert_row

516: X_LAST_UPDATED_BY => x_who.last_updated_by,
517: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
518: EXCEPTION
519: WHEN no_data_found THEN
520: fnd_descriptive_flexs_pkg.insert_row
521: (X_ROWID => l_rowid,
522: X_APPLICATION_ID => l_application_id,
523: X_DESCRIPTIVE_FLEXFIELD_NAME => x_descriptive_flexfield_name,
524: X_APPLICATION_TABLE_NAME => x_application_table_name,

Line 560: UPDATE fnd_descriptive_flexs_tl SET

556: x_form_context_prompt IN VARCHAR2,
557: x_description IN VARCHAR2)
558: IS
559: BEGIN
560: UPDATE fnd_descriptive_flexs_tl SET
561: title = Nvl(x_title, title),
562: form_context_prompt = Nvl(x_form_context_prompt, form_context_prompt),
563: description = Nvl(x_description, description),
564: last_update_date = x_who.last_update_date,

Line 575: end FND_DESCRIPTIVE_FLEXS_PKG;

571: AND descriptive_flexfield_name = x_descriptive_flexfield_name
572: AND userenv('LANG') in (language, source_lang);
573: END translate_row;
574:
575: end FND_DESCRIPTIVE_FLEXS_PKG;