APPS.GMA_GLOBAL_GRP dependencies on FND_USER

Line 184: ( p_user_name IN fnd_user.user_name%TYPE

180: --| a valid user_id of 0.) |
181: --| 01-NOV-2002 RTARDIO Added NOCOPY for bug 2650392 |
182: --+=========================================================================+
183: PROCEDURE Get_Who
184: ( p_user_name IN fnd_user.user_name%TYPE
185: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
186: )
187: IS
188: CURSOR fnd_user_c1 IS

Line 185: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE

181: --| 01-NOV-2002 RTARDIO Added NOCOPY for bug 2650392 |
182: --+=========================================================================+
183: PROCEDURE Get_Who
184: ( p_user_name IN fnd_user.user_name%TYPE
185: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
186: )
187: IS
188: CURSOR fnd_user_c1 IS
189: SELECT

Line 188: CURSOR fnd_user_c1 IS

184: ( p_user_name IN fnd_user.user_name%TYPE
185: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
186: )
187: IS
188: CURSOR fnd_user_c1 IS
189: SELECT
190: user_id
191: FROM
192: fnd_user

Line 192: fnd_user

188: CURSOR fnd_user_c1 IS
189: SELECT
190: user_id
191: FROM
192: fnd_user
193: WHERE
194: user_name = p_user_name;
195:
196: BEGIN

Line 198: OPEN fnd_user_c1;

194: user_name = p_user_name;
195:
196: BEGIN
197:
198: OPEN fnd_user_c1;
199:
200: FETCH fnd_user_c1 INTO x_user_id;
201:
202: -- TKW B2476518 7/23/2002

Line 200: FETCH fnd_user_c1 INTO x_user_id;

196: BEGIN
197:
198: OPEN fnd_user_c1;
199:
200: FETCH fnd_user_c1 INTO x_user_id;
201:
202: -- TKW B2476518 7/23/2002
203: -- If user not found, return -1 instead of 0.
204: IF (fnd_user_c1%NOTFOUND)

Line 204: IF (fnd_user_c1%NOTFOUND)

200: FETCH fnd_user_c1 INTO x_user_id;
201:
202: -- TKW B2476518 7/23/2002
203: -- If user not found, return -1 instead of 0.
204: IF (fnd_user_c1%NOTFOUND)
205: THEN
206: x_user_id := -1;
207: END IF;
208:

Line 209: CLOSE fnd_user_c1;

205: THEN
206: x_user_id := -1;
207: END IF;
208:
209: CLOSE fnd_user_c1;
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: RAISE;