DBA Data[Home] [Help]

APPS.FND_INDUSTRY_ACTIVATOR dependencies on FND_NEW_MESSAGES_IL

Line 13: from fnd_new_messages_il

9: select application_id,
10: message_name,
11: message_text,
12: language_code
13: from fnd_new_messages_il
14: where industry_id = p_industry_id;
15:
16: cursor get_original_text(p_app_id IN NUMBER,
17: p_message_name IN VARCHAR2,

Line 30: -- get the list of messages for the current industry from fnd_new_messages_il

26:
27: BEGIN
28: FND_FILE.NEW_LINE(FND_FILE.LOG);
29: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated message text.');
30: -- get the list of messages for the current industry from fnd_new_messages_il
31: for v1 in industry_message_list(v_industry_id) loop
32: -- populate the orig_message_text column
33: for v2 in get_original_text(v1.application_id,
34: v1.message_name,

Line 36: update fnd_new_messages_il

32: -- populate the orig_message_text column
33: for v2 in get_original_text(v1.application_id,
34: v1.message_name,
35: v1.language_code) loop
36: update fnd_new_messages_il
37: set orig_message_text = v2.message_text
38: where application_id = v1.application_id and
39: message_name = v1.message_name and
40: language_code = v1.language_code and

Line 194: from fnd_new_messages_il il,

190: select il.application_id,
191: il.message_name,
192: il.language_code,
193: il.orig_message_text
194: from fnd_new_messages_il il,
195: fnd_new_messages n
196: where il.industry_id = v_industry_id and
197: il.application_id = n.application_id and
198: il.language_code = n.language_code and

Line 243: -- clean up the orig_message_text column in the FND_NEW_MESSAGES_IL table

239: end if;
240: end loop;
241: commit;
242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original message text restored.');
243: -- clean up the orig_message_text column in the FND_NEW_MESSAGES_IL table
244: update fnd_new_messages_il
245: set orig_message_text = null;
246: commit;
247: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 244: update fnd_new_messages_il

240: end loop;
241: commit;
242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original message text restored.');
243: -- clean up the orig_message_text column in the FND_NEW_MESSAGES_IL table
244: update fnd_new_messages_il
245: set orig_message_text = null;
246: commit;
247: FND_FILE.NEW_LINE(FND_FILE.LOG);
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original lookup values meaning and description.');