APPS.HR_JP_STANDARD_PKG dependencies on FND_NEW_MESSAGES

Line 900: l_language_code fnd_new_messages.language_code%type;

896: p_token_value4 in varchar2 default null,
897: p_token_name5 in varchar2 default null,
898: p_token_value5 in varchar2 default null) return varchar2
899: is
900: l_language_code fnd_new_messages.language_code%type;
901: l_message_text fnd_new_messages.message_text%type;
902: l_not_found boolean := false;
903: --
904: cursor csr_message_text(cp_language_code in varchar2) is

Line 901: l_message_text fnd_new_messages.message_text%type;

897: p_token_name5 in varchar2 default null,
898: p_token_value5 in varchar2 default null) return varchar2
899: is
900: l_language_code fnd_new_messages.language_code%type;
901: l_message_text fnd_new_messages.message_text%type;
902: l_not_found boolean := false;
903: --
904: cursor csr_message_text(cp_language_code in varchar2) is
905: select message_text

Line 907: fnd_new_messages m

903: --
904: cursor csr_message_text(cp_language_code in varchar2) is
905: select message_text
906: from fnd_application a,
907: fnd_new_messages m
908: where a.application_short_name = p_application_short_name
909: and m.application_id = a.application_id
910: and m.message_name = p_message_name
911: and m.language_code = cp_language_code;