APPS.FND_DESCRIPTIVE_FLEXS_PKG dependencies on FND_DESCRIPTIVE_FLEXS_TL

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 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 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 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 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 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,