[Home] [Help]
55: X_LAST_UPDATED_BY,
56: X_LAST_UPDATE_LOGIN
57: );
58:
59: insert into FND_FLEX_VDATION_RULES_TL (
60: DESCRIPTION,
61: APPLICATION_ID,
62: ID_FLEX_CODE,
63: ID_FLEX_NUM,
87: from FND_LANGUAGES L
88: where L.INSTALLED_FLAG in ('I', 'B')
89: and not exists
90: (select NULL
91: from FND_FLEX_VDATION_RULES_TL T
92: where T.APPLICATION_ID = X_APPLICATION_ID
93: and T.ID_FLEX_CODE = X_ID_FLEX_CODE
94: and T.ID_FLEX_NUM = X_ID_FLEX_NUM
95: and T.FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME
133: cursor c1 is select
134: ERROR_MESSAGE_TEXT,
135: DESCRIPTION,
136: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
137: from FND_FLEX_VDATION_RULES_TL
138: where APPLICATION_ID = X_APPLICATION_ID
139: and ID_FLEX_CODE = X_ID_FLEX_CODE
140: and ID_FLEX_NUM = X_ID_FLEX_NUM
141: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME
212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: update FND_FLEX_VDATION_RULES_TL set
217: ERROR_MESSAGE_TEXT = X_ERROR_MESSAGE_TEXT,
218: DESCRIPTION = X_DESCRIPTION,
219: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
220: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
237: X_ID_FLEX_NUM in NUMBER,
238: X_FLEX_VALIDATION_RULE_NAME in VARCHAR2
239: ) is
240: begin
241: delete from FND_FLEX_VDATION_RULES_TL
242: where APPLICATION_ID = X_APPLICATION_ID
243: and ID_FLEX_CODE = X_ID_FLEX_CODE
244: and ID_FLEX_NUM = X_ID_FLEX_NUM
245: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME;
267: /* as a quick workaround to fix the time-consuming table handler issue */
268: /* Eventually we'll need to turn them into a separate fix_language procedure */
269: /*
270:
271: delete from FND_FLEX_VDATION_RULES_TL T
272: where not exists
273: (select NULL
274: from FND_FLEX_VALIDATION_RULES B
275: where B.APPLICATION_ID = T.APPLICATION_ID
277: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
278: and B.FLEX_VALIDATION_RULE_NAME = T.FLEX_VALIDATION_RULE_NAME
279: );
280:
281: update FND_FLEX_VDATION_RULES_TL T set (
282: ERROR_MESSAGE_TEXT,
283: DESCRIPTION
284: ) = (select
285: B.ERROR_MESSAGE_TEXT,
283: DESCRIPTION
284: ) = (select
285: B.ERROR_MESSAGE_TEXT,
286: B.DESCRIPTION
287: from FND_FLEX_VDATION_RULES_TL B
288: where B.APPLICATION_ID = T.APPLICATION_ID
289: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
290: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
291: and B.FLEX_VALIDATION_RULE_NAME = T.FLEX_VALIDATION_RULE_NAME
301: SUBT.ID_FLEX_CODE,
302: SUBT.ID_FLEX_NUM,
303: SUBT.FLEX_VALIDATION_RULE_NAME,
304: SUBT.LANGUAGE
305: from FND_FLEX_VDATION_RULES_TL SUBB, FND_FLEX_VDATION_RULES_TL SUBT
306: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
307: and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
308: and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
309: and SUBB.FLEX_VALIDATION_RULE_NAME = SUBT.FLEX_VALIDATION_RULE_NAME
314: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
315: ));
316: */
317:
318: insert /*+ append parallel(tt) */ into FND_FLEX_VDATION_RULES_TL tt (
319: DESCRIPTION,
320: APPLICATION_ID,
321: ID_FLEX_CODE,
322: ID_FLEX_NUM,
344: B.LAST_UPDATE_LOGIN,
345: B.ERROR_MESSAGE_TEXT,
346: L.LANGUAGE_CODE,
347: B.SOURCE_LANG
348: from FND_FLEX_VDATION_RULES_TL B, FND_LANGUAGES L
349: where L.INSTALLED_FLAG in ('I', 'B')
350: and B.LANGUAGE = userenv('LANG')
351: ) v, FND_FLEX_VDATION_RULES_TL t
352: where t.application_id(+) = v.application_id
347: B.SOURCE_LANG
348: from FND_FLEX_VDATION_RULES_TL B, FND_LANGUAGES L
349: where L.INSTALLED_FLAG in ('I', 'B')
350: and B.LANGUAGE = userenv('LANG')
351: ) v, FND_FLEX_VDATION_RULES_TL t
352: where t.application_id(+) = v.application_id
353: and t.id_flex_code(+) = v.id_flex_code
354: and t.id_flex_num(+) = v.id_flex_num
355: and t.flex_validation_rule_name(+) = v.flex_validation_rule_name
436: x_error_message_text IN VARCHAR2,
437: x_description IN VARCHAR2)
438: IS
439: BEGIN
440: UPDATE fnd_flex_vdation_rules_tl SET
441: error_message_text = Nvl(x_error_message_text, error_message_text),
442: description = Nvl(x_description, description),
443: last_update_date = x_who.last_update_date,
444: last_updated_by = x_who.last_updated_by,