PACKAGE BODY: APPS.EGO_ITEM_UTIL_PVT

Source

1 PACKAGE BODY EGO_ITEM_UTIL_PVT AS
2 /* $Header: EGOIUTPB.pls 120.0 2006/03/15 04:37:04 dsakalle noship $ */
3 
4   /*
5    * This function returns the lookup meaning for given lookup_code and Type
6    */
7   FUNCTION GET_LOOKUP_MEANING(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2) RETURN VARCHAR2 AS
8     l_meaning FND_LOOKUPS.MEANING%TYPE;
9   BEGIN
10     SELECT MEANING INTO l_meaning
11     FROM FND_LOOKUP_VALUES
12     WHERE LOOKUP_TYPE = p_lookup_type
13       AND LOOKUP_CODE = p_lookup_code
14       AND LANGUAGE = USERENV('LANG')
15       AND VIEW_APPLICATION_ID = 0
16       AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(p_lookup_type, 0);
17 
18     RETURN l_meaning;
19   EXCEPTION WHEN OTHERS THEN
20     RETURN NULL;
21   END GET_LOOKUP_MEANING;
22 
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;
32 
33     RETURN l_user_name;
34   EXCEPTION WHEN OTHERS THEN
35     RETURN NULL;
36   END GET_USER_NAME;
37 
38 END EGO_ITEM_UTIL_PVT;