DBA Data[Home] [Help]

APPS.EGO_ITEM_UTIL_PVT dependencies on EGO_USER_V

Line 27: l_user_name EGO_USER_V.PARTY_NAME%TYPE;

23: /*
24: * This function returns the user name for given user_id
25: */
26: FUNCTION GET_USER_NAME(p_user_id IN NUMBER) RETURN VARCHAR2 AS
27: l_user_name EGO_USER_V.PARTY_NAME%TYPE;
28: BEGIN
29: SELECT PARTY_NAME INTO l_user_name
30: FROM EGO_USER_V
31: WHERE USER_ID = p_user_id;

Line 30: FROM EGO_USER_V

26: FUNCTION GET_USER_NAME(p_user_id IN NUMBER) RETURN VARCHAR2 AS
27: l_user_name EGO_USER_V.PARTY_NAME%TYPE;
28: BEGIN
29: SELECT PARTY_NAME INTO l_user_name
30: FROM EGO_USER_V
31: WHERE USER_ID = p_user_id;
32:
33: RETURN l_user_name;
34: EXCEPTION WHEN OTHERS THEN