194: return st_count;
195: End getVersionCount;
196:
197: ----------------------------------------------------------------
198: -- Function get_user_name returns the user_name stored in FND_USER
199: -- when passed a user_id
200: --
201: FUNCTION get_user_name(l_user_id IN NUMBER)
202: RETURN VARCHAR2
200: --
201: FUNCTION get_user_name(l_user_id IN NUMBER)
202: RETURN VARCHAR2
203: IS
204: l_user_name fnd_user.user_name%TYPE := '';
205:
206: cursor l_user_cursor is
207: select user_name
208: from fnd_user
204: l_user_name fnd_user.user_name%TYPE := '';
205:
206: cursor l_user_cursor is
207: select user_name
208: from fnd_user
209: where user_id = l_user_id;
210:
211: BEGIN
212: