[Home] [Help]
64: X_LAST_UPDATED_BY,
65: X_LAST_UPDATE_LOGIN
66: );
67:
68: insert into FND_VAL_ATTRIBUTE_TYPES_TL (
69: APPLICATION_ID,
70: ID_FLEX_CODE,
71: SEGMENT_ATTRIBUTE_TYPE,
72: VALUE_ATTRIBUTE_TYPE,
96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from FND_VAL_ATTRIBUTE_TYPES_TL T
101: where T.APPLICATION_ID = X_APPLICATION_ID
102: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
103: and T.SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
104: and T.VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE
147:
148: cursor c1 is select
149: PROMPT,
150: DESCRIPTION
151: from FND_VAL_ATTRIBUTE_TYPES_TL
152: where APPLICATION_ID = X_APPLICATION_ID
153: and ID_FLEX_CODE = X_ID_FLEX_CODE
154: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
155: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE
243: if (sql%notfound) then
244: raise no_data_found;
245: end if;
246:
247: update FND_VAL_ATTRIBUTE_TYPES_TL set
248: PROMPT = X_PROMPT,
249: DESCRIPTION = X_DESCRIPTION,
250: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
251: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
278: if (sql%notfound) then
279: raise no_data_found;
280: end if;
281:
282: delete from FND_VAL_ATTRIBUTE_TYPES_TL
283: where APPLICATION_ID = X_APPLICATION_ID
284: and ID_FLEX_CODE = X_ID_FLEX_CODE
285: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
286: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE;
298: /* as a quick workaround to fix the time-consuming table handler issue */
299: /* Eventually we'll need to turn them into a separate fix_language procedure */
300: /*
301:
302: delete from FND_VAL_ATTRIBUTE_TYPES_TL T
303: where not exists
304: (select NULL
305: from FND_VALUE_ATTRIBUTE_TYPES B
306: where B.APPLICATION_ID = T.APPLICATION_ID
308: and B.SEGMENT_ATTRIBUTE_TYPE = T.SEGMENT_ATTRIBUTE_TYPE
309: and B.VALUE_ATTRIBUTE_TYPE = T.VALUE_ATTRIBUTE_TYPE
310: );
311:
312: update FND_VAL_ATTRIBUTE_TYPES_TL T set (
313: PROMPT,
314: DESCRIPTION
315: ) = (select
316: B.PROMPT,
314: DESCRIPTION
315: ) = (select
316: B.PROMPT,
317: B.DESCRIPTION
318: from FND_VAL_ATTRIBUTE_TYPES_TL B
319: where B.APPLICATION_ID = T.APPLICATION_ID
320: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
321: and B.SEGMENT_ATTRIBUTE_TYPE = T.SEGMENT_ATTRIBUTE_TYPE
322: and B.VALUE_ATTRIBUTE_TYPE = T.VALUE_ATTRIBUTE_TYPE
332: SUBT.ID_FLEX_CODE,
333: SUBT.SEGMENT_ATTRIBUTE_TYPE,
334: SUBT.VALUE_ATTRIBUTE_TYPE,
335: SUBT.LANGUAGE
336: from FND_VAL_ATTRIBUTE_TYPES_TL SUBB, FND_VAL_ATTRIBUTE_TYPES_TL SUBT
337: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
338: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
339: and SUBB.SEGMENT_ATTRIBUTE_TYPE = SUBT.SEGMENT_ATTRIBUTE_TYPE
340: and SUBB.VALUE_ATTRIBUTE_TYPE = SUBT.VALUE_ATTRIBUTE_TYPE
345: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
346: ));
347: */
348:
349: insert into FND_VAL_ATTRIBUTE_TYPES_TL (
350: APPLICATION_ID,
351: ID_FLEX_CODE,
352: SEGMENT_ATTRIBUTE_TYPE,
353: VALUE_ATTRIBUTE_TYPE,
373: B.LAST_UPDATE_LOGIN,
374: B.DESCRIPTION,
375: L.LANGUAGE_CODE,
376: B.SOURCE_LANG
377: from FND_VAL_ATTRIBUTE_TYPES_TL B, FND_LANGUAGES L
378: where L.INSTALLED_FLAG in ('I', 'B')
379: and B.LANGUAGE = userenv('LANG')
380: and not exists
381: (select NULL
378: where L.INSTALLED_FLAG in ('I', 'B')
379: and B.LANGUAGE = userenv('LANG')
380: and not exists
381: (select NULL
382: from FND_VAL_ATTRIBUTE_TYPES_TL T
383: where T.APPLICATION_ID = B.APPLICATION_ID
384: and T.ID_FLEX_CODE = B.ID_FLEX_CODE
385: and T.SEGMENT_ATTRIBUTE_TYPE = B.SEGMENT_ATTRIBUTE_TYPE
386: and T.VALUE_ATTRIBUTE_TYPE = B.VALUE_ATTRIBUTE_TYPE
463: x_prompt IN VARCHAR2,
464: x_description IN VARCHAR2)
465: IS
466: BEGIN
467: UPDATE fnd_val_attribute_types_tl SET
468: prompt = Nvl(x_prompt, prompt),
469: description = Nvl(x_description, description),
470: last_update_date = x_who.last_update_date,
471: last_updated_by = x_who.last_updated_by,