19:
20: --
21: -- Safe globals.
22: --
23: g_user_name_cache fnd_user.user_name%TYPE := NULL;
24: g_user_id_cache NUMBER;
25:
26: --
27: -- Bug 3926150.
96:
97:
98: FUNCTION get_user_id(p_name VARCHAR2) RETURN NUMBER IS
99: --
100: -- Decode user name from fnd_user table.
101: --
102: id NUMBER;
103:
104: CURSOR user_cursor IS
102: id NUMBER;
103:
104: CURSOR user_cursor IS
105: SELECT user_id
106: FROM fnd_user
107: WHERE user_name = p_name;
108: BEGIN
109:
110: --