DBA Data[Home] [Help]

APPS.QA_DEVICE_PUB dependencies on FND_USER

Line 7: g_user_name_cache fnd_user.user_name%TYPE := NULL;

3:
4: --
5: -- Safe Globals
6: --
7: g_user_name_cache fnd_user.user_name%TYPE := NULL;
8: g_user_id_cache NUMBER;
9: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_device_pub';
10:
11: --

Line 17: -- Decode user name from fnd_user table.

13: --
14:
15: FUNCTION get_user_id(p_name IN VARCHAR2) RETURN NUMBER IS
16: --
17: -- Decode user name from fnd_user table.
18: --
19: id NUMBER;
20:
21: CURSOR user_cursor IS

Line 23: FROM fnd_user

19: id NUMBER;
20:
21: CURSOR user_cursor IS
22: SELECT user_id
23: FROM fnd_user
24: WHERE user_name = p_name;
25: BEGIN
26: IF p_name IS NULL THEN
27: RETURN nvl(fnd_global.user_id, -1);