APPS.GMD_SPEC_GRP dependencies on FND_USER

Line 117: FROM fnd_user

113:
114:
115: CURSOR c_owner(p_owner_id NUMBER) IS
116: SELECT user_name
117: FROM fnd_user
118: WHERE user_id = p_owner_id
119: AND start_date <= SYSDATE
120: AND nvl(end_date, SYSDATE + 1) >= SYSDATE;
121:

Line 2831: ( p_user_name IN fnd_user.user_name%TYPE

2827: --| HISTORY |
2828: --| Saikiran Vankadari 02-May-2005 Created as part of Convergence changes
2829: --+=========================================================================+
2830: PROCEDURE Get_Who
2831: ( p_user_name IN fnd_user.user_name%TYPE
2832: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2833: )
2834: IS
2835: CURSOR fnd_user_c1 IS

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

2828: --| Saikiran Vankadari 02-May-2005 Created as part of Convergence changes
2829: --+=========================================================================+
2830: PROCEDURE Get_Who
2831: ( p_user_name IN fnd_user.user_name%TYPE
2832: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2833: )
2834: IS
2835: CURSOR fnd_user_c1 IS
2836: SELECT

Line 2835: CURSOR fnd_user_c1 IS

2831: ( p_user_name IN fnd_user.user_name%TYPE
2832: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
2833: )
2834: IS
2835: CURSOR fnd_user_c1 IS
2836: SELECT
2837: user_id
2838: FROM
2839: fnd_user

Line 2839: fnd_user

2835: CURSOR fnd_user_c1 IS
2836: SELECT
2837: user_id
2838: FROM
2839: fnd_user
2840: WHERE
2841: user_name = p_user_name;
2842:
2843: BEGIN

Line 2845: OPEN fnd_user_c1;

2841: user_name = p_user_name;
2842:
2843: BEGIN
2844:
2845: OPEN fnd_user_c1;
2846:
2847: FETCH fnd_user_c1 INTO x_user_id;
2848:
2849: -- TKW B2476518 7/23/2002

Line 2847: FETCH fnd_user_c1 INTO x_user_id;

2843: BEGIN
2844:
2845: OPEN fnd_user_c1;
2846:
2847: FETCH fnd_user_c1 INTO x_user_id;
2848:
2849: -- TKW B2476518 7/23/2002
2850: -- If user not found, return -1 instead of 0.
2851: IF (fnd_user_c1%NOTFOUND)

Line 2851: IF (fnd_user_c1%NOTFOUND)

2847: FETCH fnd_user_c1 INTO x_user_id;
2848:
2849: -- TKW B2476518 7/23/2002
2850: -- If user not found, return -1 instead of 0.
2851: IF (fnd_user_c1%NOTFOUND)
2852: THEN
2853: x_user_id := -1;
2854: END IF;
2855:

Line 2856: CLOSE fnd_user_c1;

2852: THEN
2853: x_user_id := -1;
2854: END IF;
2855:
2856: CLOSE fnd_user_c1;
2857:
2858: EXCEPTION
2859: WHEN OTHERS THEN
2860: RAISE;