DBA Data[Home] [Help]

APPS.OTA_TIMEZONE_UPGRADE dependencies on FND_NEW_MESSAGES

Line 182: FROM fnd_new_messages

178: FUNCTION get_msg_text(l_msg_name IN VARCHAR2) RETURN VARCHAR2 IS l_msg_text VARCHAR2(2000);
179:
180: CURSOR csr_msg(msg_name VARCHAR2) IS
181: SELECT message_text
182: FROM fnd_new_messages
183: WHERE message_name = TRIM(SUBSTR(msg_name, instr(msg_name, ':', 1, 1) + 1,
184: (decode(instr(msg_name, ':', 1, 2), 0, LENGTH(msg_name),
185: instr(msg_name, ':', 1, 2) -1) -instr(msg_name, ':'))))
186: AND language_code = userenv('LANG');