DBA Data[Home] [Help]

APPS.JL_ZZ_FA_UTILITIES_PKG dependencies on FND_NEW_MESSAGES

Line 51: msg_num FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;

47: ------------------------------------------------------------
48: FUNCTION get_app_errnum(p_app_name IN VARCHAR2,
49: p_msg_name IN VARCHAR2)
50: return number IS
51: msg_num FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
52:
53: BEGIN
54: BEGIN
55: select message_number

Line 57: from fnd_new_messages a, fnd_application b

53: BEGIN
54: BEGIN
55: select message_number
56: into msg_num
57: from fnd_new_messages a, fnd_application b
58: where upper(a.language_code) = upper(userenv('LANG'))
59: and upper(a.message_name) = upper(p_msg_name)
60: and a.application_id = b.application_id
61: and b.application_short_name = upper(p_app_name);