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

Line 1: package body FND_DESCR_FLEX_CONTEXTS_PKG as

1: package body FND_DESCR_FLEX_CONTEXTS_PKG as
2: /* $Header: AFFFDFCB.pls 120.2.12010000.1 2008/07/25 14:13:45 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 19: cursor C is select ROWID from FND_DESCR_FLEX_CONTEXTS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FND_DESCR_FLEX_CONTEXTS
20: where APPLICATION_ID = X_APPLICATION_ID
21: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
22: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
23: ;

Line 25: insert into FND_DESCR_FLEX_CONTEXTS (

21: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
22: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
23: ;
24: begin
25: insert into FND_DESCR_FLEX_CONTEXTS (
26: APPLICATION_ID,
27: DESCRIPTIVE_FLEXFIELD_NAME,
28: DESCRIPTIVE_FLEX_CONTEXT_CODE,
29: ENABLED_FLAG,

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 107: from FND_DESCR_FLEX_CONTEXTS

103: ) is
104: cursor c is select
105: ENABLED_FLAG,
106: GLOBAL_FLAG
107: from FND_DESCR_FLEX_CONTEXTS
108: where APPLICATION_ID = X_APPLICATION_ID
109: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
110: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
111: for update of APPLICATION_ID nowait;

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 176: update FND_DESCR_FLEX_CONTEXTS set

172: X_LAST_UPDATED_BY in NUMBER,
173: X_LAST_UPDATE_LOGIN in NUMBER
174: ) is
175: begin
176: update FND_DESCR_FLEX_CONTEXTS set
177: ENABLED_FLAG = X_ENABLED_FLAG,
178: GLOBAL_FLAG = X_GLOBAL_FLAG,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

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 213: delete from FND_DESCR_FLEX_CONTEXTS

209: X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2,
210: X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2
211: ) is
212: begin
213: delete from FND_DESCR_FLEX_CONTEXTS
214: where APPLICATION_ID = X_APPLICATION_ID
215: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
216: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD;
217:

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 244: from FND_DESCR_FLEX_CONTEXTS B

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
246: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
247: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
248: );

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 340: fnd_descr_flex_contexts_pkg.update_row

336: FROM fnd_application
337: WHERE application_short_name = x_application_short_name;
338:
339: BEGIN
340: fnd_descr_flex_contexts_pkg.update_row
341: (X_APPLICATION_ID => l_application_id,
342: X_DESCRIPTIVE_FLEXFIELD_NAME => x_descriptive_flexfield_name,
343: X_DESCRIPTIVE_FLEX_CONTEXT_COD => x_descriptive_flex_context_cod,
344: X_ENABLED_FLAG => x_enabled_flag,

Line 353: fnd_descr_flex_contexts_pkg.insert_row

349: X_LAST_UPDATED_BY => x_who.last_updated_by,
350: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
351: EXCEPTION
352: WHEN no_data_found THEN
353: fnd_descr_flex_contexts_pkg.insert_row
354: (X_ROWID => l_rowid,
355: X_APPLICATION_ID => l_application_id,
356: X_DESCRIPTIVE_FLEXFIELD_NAME => x_descriptive_flexfield_name,
357: X_DESCRIPTIVE_FLEX_CONTEXT_COD => x_descriptive_flex_context_cod,

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,

Line 395: end FND_DESCR_FLEX_CONTEXTS_PKG;

391: AND descriptive_flex_context_code = x_descriptive_flex_context_cod
392: AND userenv('LANG') in (language, source_lang);
393: END translate_row;
394:
395: end FND_DESCR_FLEX_CONTEXTS_PKG;