APPS.OKL_VP_OA_WF dependencies on WF_USERS

Line 58: CURSOR wf_users_csr(cp_user_id NUMBER)IS

54: x_return_status OUT NOCOPY VARCHAR2,
55: x_name OUT NOCOPY VARCHAR2,
56: x_description OUT NOCOPY VARCHAR2) IS
57:
58: CURSOR wf_users_csr(cp_user_id NUMBER)IS
59: SELECT name, display_name
60: FROM wf_users
61: WHERE orig_system_id = p_user_id
62: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;

Line 60: FROM wf_users

56: x_description OUT NOCOPY VARCHAR2) IS
57:
58: CURSOR wf_users_csr(cp_user_id NUMBER)IS
59: SELECT name, display_name
60: FROM wf_users
61: WHERE orig_system_id = p_user_id
62: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
63:
64: CURSOR fnd_users_csr(cp_user_id NUMBER)IS

Line 70: OPEN wf_users_csr(p_user_id);

66: FROM fnd_user
67: WHERE user_id = cp_user_id;
68: BEGIN
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70: OPEN wf_users_csr(p_user_id);
71: FETCH wf_users_csr INTO x_name, x_description;
72: CLOSE wf_users_csr;
73: IF x_name IS NULL THEN
74: OPEN fnd_users_csr(p_user_id);

Line 71: FETCH wf_users_csr INTO x_name, x_description;

67: WHERE user_id = cp_user_id;
68: BEGIN
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70: OPEN wf_users_csr(p_user_id);
71: FETCH wf_users_csr INTO x_name, x_description;
72: CLOSE wf_users_csr;
73: IF x_name IS NULL THEN
74: OPEN fnd_users_csr(p_user_id);
75: FETCH fnd_users_csr INTO x_name, x_description;

Line 72: CLOSE wf_users_csr;

68: BEGIN
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70: OPEN wf_users_csr(p_user_id);
71: FETCH wf_users_csr INTO x_name, x_description;
72: CLOSE wf_users_csr;
73: IF x_name IS NULL THEN
74: OPEN fnd_users_csr(p_user_id);
75: FETCH fnd_users_csr INTO x_name, x_description;
76: CLOSE fnd_users_csr;