293: PROCEDURE get_user_name(p_user_id VARCHAR2,
294: p_user_name OUT NOCOPY VARCHAR2) IS
295: CURSOR Cur_get_user_name IS
296: SELECT USER_NAME 297: FROM FND_USER 298: WHERE user_id = p_user_id;
299: BEGIN
300: OPEN Cur_get_user_name;
301: FETCH Cur_get_user_name INTO P_user_name;