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
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
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: --