DBA Data[Home] [Help]

APPS.QA_SPECS_PUB dependencies on FND_USER

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

9: TYPE qa_specs_table IS TABLE OF qa_specs%ROWTYPE INDEX BY BINARY_INTEGER;
10: g_qa_specs_array qa_specs_table;
11:
12: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_specs_pub';
13: g_user_name_cache fnd_user.user_name%TYPE := NULL;
14: g_user_id_cache NUMBER;
15:
16: --
17: -- General utility functions

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

18: --
19:
20: FUNCTION get_user_id(p_name VARCHAR2) RETURN NUMBER IS
21: --
22: -- Decode user name from fnd_user table.
23: --
24: id NUMBER;
25:
26: CURSOR user_cursor IS

Line 28: FROM fnd_user

24: id NUMBER;
25:
26: CURSOR user_cursor IS
27: SELECT user_id
28: FROM fnd_user
29: WHERE user_name = p_name;
30: BEGIN
31:
32: --