[Home] [Help]
91: X_LAST_UPDATED_BY,
92: X_LAST_UPDATE_LOGIN
93: );
94:
95: insert into FND_ID_FLEX_SEGMENTS_TL (
96: APPLICATION_ID,
97: ID_FLEX_CODE,
98: ID_FLEX_NUM,
99: APPLICATION_COLUMN_NAME,
125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from FND_ID_FLEX_SEGMENTS_TL T
130: where T.APPLICATION_ID = X_APPLICATION_ID
131: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
132: and T.ID_FLEX_NUM = X_ID_FLEX_NUM
133: and T.APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
197: FORM_LEFT_PROMPT,
198: FORM_ABOVE_PROMPT,
199: DESCRIPTION,
200: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
201: from FND_ID_FLEX_SEGMENTS_TL
202: where APPLICATION_ID = X_APPLICATION_ID
203: and ID_FLEX_CODE = X_ID_FLEX_CODE
204: and ID_FLEX_NUM = X_ID_FLEX_NUM
205: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update FND_ID_FLEX_SEGMENTS_TL set
322: FORM_LEFT_PROMPT = X_FORM_LEFT_PROMPT,
323: FORM_ABOVE_PROMPT = X_FORM_ABOVE_PROMPT,
324: DESCRIPTION = X_DESCRIPTION,
325: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
343: X_ID_FLEX_NUM in NUMBER,
344: X_APPLICATION_COLUMN_NAME in VARCHAR2
345: ) is
346: begin
347: delete from FND_ID_FLEX_SEGMENTS_TL
348: where APPLICATION_ID = X_APPLICATION_ID
349: and ID_FLEX_CODE = X_ID_FLEX_CODE
350: and ID_FLEX_NUM = X_ID_FLEX_NUM
351: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;
387: /* as a quick workaround to fix the time-consuming table handler issue */
388: /* Eventually we'll need to turn them into a separate fix_language procedure */
389: /*
390:
391: delete from FND_ID_FLEX_SEGMENTS_TL T
392: where not exists
393: (select NULL
394: from FND_ID_FLEX_SEGMENTS B
395: where B.APPLICATION_ID = T.APPLICATION_ID
397: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
398: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
399: );
400:
401: update FND_ID_FLEX_SEGMENTS_TL T set (
402: FORM_LEFT_PROMPT,
403: FORM_ABOVE_PROMPT,
404: DESCRIPTION
405: ) = (select
405: ) = (select
406: B.FORM_LEFT_PROMPT,
407: B.FORM_ABOVE_PROMPT,
408: B.DESCRIPTION
409: from FND_ID_FLEX_SEGMENTS_TL B
410: where B.APPLICATION_ID = T.APPLICATION_ID
411: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
412: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
413: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
423: SUBT.ID_FLEX_CODE,
424: SUBT.ID_FLEX_NUM,
425: SUBT.APPLICATION_COLUMN_NAME,
426: SUBT.LANGUAGE
427: from FND_ID_FLEX_SEGMENTS_TL SUBB, FND_ID_FLEX_SEGMENTS_TL SUBT
428: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
429: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
430: and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
431: and SUBB.APPLICATION_COLUMN_NAME = SUBT.APPLICATION_COLUMN_NAME
437: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
438: ));
439: */
440:
441: insert into FND_ID_FLEX_SEGMENTS_TL (
442: APPLICATION_ID,
443: ID_FLEX_CODE,
444: ID_FLEX_NUM,
445: APPLICATION_COLUMN_NAME,
467: B.FORM_ABOVE_PROMPT,
468: B.DESCRIPTION,
469: L.LANGUAGE_CODE,
470: B.SOURCE_LANG
471: from FND_ID_FLEX_SEGMENTS_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from FND_ID_FLEX_SEGMENTS_TL T
477: where T.APPLICATION_ID = B.APPLICATION_ID
478: and T.ID_FLEX_CODE = B.ID_FLEX_CODE
479: and T.ID_FLEX_NUM = B.ID_FLEX_NUM
480: and T.APPLICATION_COLUMN_NAME = B.APPLICATION_COLUMN_NAME
611: x_form_above_prompt IN VARCHAR2,
612: x_description IN VARCHAR2)
613: IS
614: BEGIN
615: UPDATE fnd_id_flex_segments_tl SET
616: form_left_prompt = Nvl(x_form_left_prompt, form_left_prompt),
617: form_above_prompt = Nvl(x_form_above_prompt, form_above_prompt),
618: description = Nvl(x_description, description),
619: last_update_date = x_who.last_update_date,