APPS.PV_MESSAGE dependencies on FND_NEW_MESSAGES

Line 77: from fnd_new_messages m, fnd_application a

73: function GET_STRING(APPIN in varchar2,
74: NAMEIN in varchar2) return varchar2 is
75: MSG varchar2(2000) := NULL;
76: cursor c1(NAME_ARG varchar2) is select message_text
77: from fnd_new_messages m, fnd_application a
78: where NAME_ARG = m.message_name
79: and m.language_code = userenv('LANG')
80: and APPIN = a.application_short_name
81: and m.application_id = a.application_id;

Line 83: from fnd_new_messages m, fnd_application a

79: and m.language_code = userenv('LANG')
80: and APPIN = a.application_short_name
81: and m.application_id = a.application_id;
82: cursor c2(NAME_ARG varchar2) is select message_text
83: from fnd_new_messages m, fnd_application a
84: where NAME_ARG = m.message_name
85: and 'US' = m.language_code
86: and APPIN = a.application_short_name
87: and m.application_id = a.application_id;

Line 133: from fnd_new_messages m, fnd_application a

129: function GET_NUMBER(APPIN in varchar2,
130: NAMEIN in varchar2) return NUMBER is
131: MSG_NUM NUMBER := NULL;
132: cursor c1(NAME_ARG varchar2) is select message_number
133: from fnd_new_messages m, fnd_application a
134: where NAME_ARG = m.message_name
135: and m.language_code = userenv('LANG')
136: and APPIN = a.application_short_name
137: and m.application_id = a.application_id;

Line 139: from fnd_new_messages m, fnd_application a

135: and m.language_code = userenv('LANG')
136: and APPIN = a.application_short_name
137: and m.application_id = a.application_id;
138: cursor c2(NAME_ARG varchar2) is select message_number
139: from fnd_new_messages m, fnd_application a
140: where NAME_ARG = m.message_name
141: and 'US' = m.language_code
142: and APPIN = a.application_short_name
143: and m.application_id = a.application_id;