[Home] [Help]
70: X_LAST_UPDATED_BY,
71: X_LAST_UPDATE_LOGIN
72: );
73:
74: insert into FND_ID_FLEX_STRUCTURES_TL (
75: APPLICATION_ID,
76: ID_FLEX_CODE,
77: ID_FLEX_NUM,
78: LAST_UPDATE_DATE,
102: from FND_LANGUAGES L
103: where L.INSTALLED_FLAG in ('I', 'B')
104: and not exists
105: (select NULL
106: from FND_ID_FLEX_STRUCTURES_TL T
107: where T.APPLICATION_ID = X_APPLICATION_ID
108: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
109: and T.ID_FLEX_NUM = X_ID_FLEX_NUM
110: and T.LANGUAGE = L.LANGUAGE_CODE);
159: ID_FLEX_STRUCTURE_NAME,
160: DESCRIPTION,
161: SHORTHAND_PROMPT,
162: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
163: from FND_ID_FLEX_STRUCTURES_TL
164: where APPLICATION_ID = X_APPLICATION_ID
165: and ID_FLEX_CODE = X_ID_FLEX_CODE
166: and ID_FLEX_NUM = X_ID_FLEX_NUM
167: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
255: if (sql%notfound) then
256: raise no_data_found;
257: end if;
258:
259: update FND_ID_FLEX_STRUCTURES_TL set
260: ID_FLEX_STRUCTURE_NAME = X_ID_FLEX_STRUCTURE_NAME,
261: DESCRIPTION = X_DESCRIPTION,
262: SHORTHAND_PROMPT = X_SHORTHAND_PROMPT,
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
279: X_ID_FLEX_CODE in VARCHAR2,
280: X_ID_FLEX_NUM in NUMBER
281: ) is
282: begin
283: delete from FND_ID_FLEX_STRUCTURES_TL
284: where APPLICATION_ID = X_APPLICATION_ID
285: and ID_FLEX_CODE = X_ID_FLEX_CODE
286: and ID_FLEX_NUM = X_ID_FLEX_NUM;
287:
307: /* as a quick workaround to fix the time-consuming table handler issue */
308: /* Eventually we'll need to turn them into a separate fix_language procedure */
309: /*
310:
311: delete from FND_ID_FLEX_STRUCTURES_TL T
312: where not exists
313: (select NULL
314: from FND_ID_FLEX_STRUCTURES B
315: where B.APPLICATION_ID = T.APPLICATION_ID
316: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
317: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
318: );
319:
320: update FND_ID_FLEX_STRUCTURES_TL T set (
321: ID_FLEX_STRUCTURE_NAME,
322: DESCRIPTION,
323: SHORTHAND_PROMPT
324: ) = (select
324: ) = (select
325: B.ID_FLEX_STRUCTURE_NAME,
326: B.DESCRIPTION,
327: B.SHORTHAND_PROMPT
328: from FND_ID_FLEX_STRUCTURES_TL B
329: where B.APPLICATION_ID = T.APPLICATION_ID
330: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
331: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
332: and B.LANGUAGE = T.SOURCE_LANG)
339: SUBT.APPLICATION_ID,
340: SUBT.ID_FLEX_CODE,
341: SUBT.ID_FLEX_NUM,
342: SUBT.LANGUAGE
343: from FND_ID_FLEX_STRUCTURES_TL SUBB, FND_ID_FLEX_STRUCTURES_TL SUBT
344: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
345: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
346: and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
347: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
354: or (SUBB.SHORTHAND_PROMPT is not null and SUBT.SHORTHAND_PROMPT is null)
355: ));
356: */
357:
358: insert into FND_ID_FLEX_STRUCTURES_TL (
359: APPLICATION_ID,
360: ID_FLEX_CODE,
361: ID_FLEX_NUM,
362: LAST_UPDATE_DATE,
382: B.DESCRIPTION,
383: B.SHORTHAND_PROMPT,
384: L.LANGUAGE_CODE,
385: B.SOURCE_LANG
386: from FND_ID_FLEX_STRUCTURES_TL B, FND_LANGUAGES L
387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL
387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL
391: from FND_ID_FLEX_STRUCTURES_TL T
392: where T.APPLICATION_ID = B.APPLICATION_ID
393: and T.ID_FLEX_CODE = B.ID_FLEX_CODE
394: and T.ID_FLEX_NUM = B.ID_FLEX_NUM
395: and T.LANGUAGE = L.LANGUAGE_CODE);
498: x_description IN VARCHAR2,
499: x_shorthand_prompt IN VARCHAR2)
500: IS
501: BEGIN
502: UPDATE fnd_id_flex_structures_tl SET
503: id_flex_structure_name = Nvl(x_id_flex_structure_name,
504: id_flex_structure_name),
505: description = Nvl(x_description, description),
506: shorthand_prompt = Nvl(x_shorthand_prompt, shorthand_prompt),