515: function GET_MESSAGE_STATUS_DISP (p_viewer_id IN NUMBER,
516: p_entry_id IN NUMBER)
517: RETURN VARCHAR2
518: AS
519: l_msg_read fnd_new_messages.message_text%TYPE;
520: l_msg_unread fnd_new_messages.message_text%TYPE;
521: l_msg_replied fnd_new_messages.message_text%TYPE;
522: l_message_status fnd_new_messages.message_text%TYPE;
523: l_module_name VARCHAR2(40) := 'GET_MESSAGE_STATUS_DISP';
516: p_entry_id IN NUMBER)
517: RETURN VARCHAR2
518: AS
519: l_msg_read fnd_new_messages.message_text%TYPE;
520: l_msg_unread fnd_new_messages.message_text%TYPE;
521: l_msg_replied fnd_new_messages.message_text%TYPE;
522: l_message_status fnd_new_messages.message_text%TYPE;
523: l_module_name VARCHAR2(40) := 'GET_MESSAGE_STATUS_DISP';
524:
517: RETURN VARCHAR2
518: AS
519: l_msg_read fnd_new_messages.message_text%TYPE;
520: l_msg_unread fnd_new_messages.message_text%TYPE;
521: l_msg_replied fnd_new_messages.message_text%TYPE;
522: l_message_status fnd_new_messages.message_text%TYPE;
523: l_module_name VARCHAR2(40) := 'GET_MESSAGE_STATUS_DISP';
524:
525: BEGIN
518: AS
519: l_msg_read fnd_new_messages.message_text%TYPE;
520: l_msg_unread fnd_new_messages.message_text%TYPE;
521: l_msg_replied fnd_new_messages.message_text%TYPE;
522: l_message_status fnd_new_messages.message_text%TYPE;
523: l_module_name VARCHAR2(40) := 'GET_MESSAGE_STATUS_DISP';
524:
525: BEGIN
526: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN