5: -- Private Global Variables
6: --
7: G_Emp_ID per_all_people_f.person_id%type := NULL;
8: G_Emp_Name per_all_people_f.full_name%type := NULL;
9: G_User_ID fnd_user.user_id%type := NULL;
10: G_Yes VARCHAR2(80) := NULL;
11: G_No VARCHAR2(80) := NULL;
12:
13: G_K_Hdr_ID_Curr NUMBER := NULL;
47: RETURN NUMBER IS
48:
49: CURSOR csr ( c_user_id number ) IS
50: SELECT employee_id
51: FROM fnd_user
52: WHERE user_id = c_user_id;
53:
54: BEGIN
55: --