DBA Data[Home] [Help]

APPS.PON_OA_UTIL_PKG dependencies on FND_NEW_MESSAGES

Line 1926: v_display_approval_status fnd_new_messages.message_text%TYPE := NULL;

1922: FUNCTION APPROVAL_CONDITION(p_user_id IN NUMBER) RETURN VARCHAR2
1923: IS
1924: v_is_manager_present NUMBER := 0;
1925: v_approval_status VARCHAR2(50) := NULL;
1926: v_display_approval_status fnd_new_messages.message_text%TYPE := NULL;
1927: BEGIN
1928:
1929: SELECT count(1)
1930: INTO v_is_manager_present

Line 1956: FROM fnd_new_messages

1952: END IF;
1953:
1954: SELECT message_text
1955: INTO v_display_approval_status
1956: FROM fnd_new_messages
1957: WHERE application_id = 396
1958: AND language_code = userenv('LANG')
1959: AND message_name = v_approval_status;
1960: