PACKAGE BODY: APPS.GMF_FND_GET_USERS

Source

1 PACKAGE BODY GMF_FND_GET_USERS as
2 /* $Header: gmfusrnb.pls 115.0 99/07/16 04:25:50 porting shi $ */
3     function FND_GET_USERS (userid   number) return varchar2 is
4 
5         username   varchar2(100);
6 
7         begin
8              select USR.USER_NAME
9              into   username
10              from   FND_USER USR
11              where  USR.user_id = userid;
12 
13              return(username);
14 
15 	exception
16 		when NO_DATA_FOUND THEN
17 			return('ORAF');
18 
19         end;
20 
21 END GMF_FND_GET_USERS;