APPS.GMD_SPEC_GRP dependencies on FND_USER

Line 132: FROM fnd_user

128:
129:
130: CURSOR c_owner(p_owner_id NUMBER) IS
131: SELECT user_name
132: FROM fnd_user
133: WHERE user_id = p_owner_id
134: AND start_date <= SYSDATE
135: AND nvl(end_date, SYSDATE + 1) >= SYSDATE;
136:

Line 2903: ( p_user_name IN fnd_user.user_name%TYPE

2899: --| HISTORY |
2900: --| Saikiran Vankadari 02-May-2005 Created as part of Convergence changes
2901: --+=========================================================================+
2902: PROCEDURE Get_Who
2903: ( p_user_name IN fnd_user.user_name%TYPE
2904: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2905: )
2906: IS
2907: CURSOR fnd_user_c1 IS

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

2900: --| Saikiran Vankadari 02-May-2005 Created as part of Convergence changes
2901: --+=========================================================================+
2902: PROCEDURE Get_Who
2903: ( p_user_name IN fnd_user.user_name%TYPE
2904: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2905: )
2906: IS
2907: CURSOR fnd_user_c1 IS
2908: SELECT

Line 2907: CURSOR fnd_user_c1 IS

2903: ( p_user_name IN fnd_user.user_name%TYPE
2904: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2905: )
2906: IS
2907: CURSOR fnd_user_c1 IS
2908: SELECT
2909: user_id
2910: FROM
2911: fnd_user

Line 2911: fnd_user

2907: CURSOR fnd_user_c1 IS
2908: SELECT
2909: user_id
2910: FROM
2911: fnd_user
2912: WHERE
2913: user_name = p_user_name;
2914:
2915: BEGIN

Line 2917: OPEN fnd_user_c1;

2913: user_name = p_user_name;
2914:
2915: BEGIN
2916:
2917: OPEN fnd_user_c1;
2918:
2919: FETCH fnd_user_c1 INTO x_user_id;
2920:
2921: -- TKW B2476518 7/23/2002

Line 2919: FETCH fnd_user_c1 INTO x_user_id;

2915: BEGIN
2916:
2917: OPEN fnd_user_c1;
2918:
2919: FETCH fnd_user_c1 INTO x_user_id;
2920:
2921: -- TKW B2476518 7/23/2002
2922: -- If user not found, return -1 instead of 0.
2923: IF (fnd_user_c1%NOTFOUND)

Line 2923: IF (fnd_user_c1%NOTFOUND)

2919: FETCH fnd_user_c1 INTO x_user_id;
2920:
2921: -- TKW B2476518 7/23/2002
2922: -- If user not found, return -1 instead of 0.
2923: IF (fnd_user_c1%NOTFOUND)
2924: THEN
2925: x_user_id := -1;
2926: END IF;
2927:

Line 2928: CLOSE fnd_user_c1;

2924: THEN
2925: x_user_id := -1;
2926: END IF;
2927:
2928: CLOSE fnd_user_c1;
2929:
2930: EXCEPTION
2931: WHEN OTHERS THEN
2932: RAISE;