16: ( p_user_id IN NUMBER ) RETURN VARCHAR2 IS
17: CURSOR c_user
18: (p_user_id IN NUMBER
19: )IS SELECT user_name
20: FROM fnd_user
21: WHERE user_id = p_user_id;
22:
23: CURSOR c_resource_name
24: (p_user_id IN NUMBER
48: THEN
49:
50:
51: /*****************************************************************************
52: ** Get the UserName from FND_USER
53: *****************************************************************************/
54: IF c_user%ISOPEN
55: THEN
56: CLOSE c_user;