60: x_return_status OUT NOCOPY VARCHAR2,
61: x_name OUT NOCOPY VARCHAR2,
62: x_description OUT NOCOPY VARCHAR2) IS
63:
64: CURSOR wf_users_csr(cp_user_id NUMBER)IS
65: SELECT name, display_name
66: FROM wf_users
67: WHERE orig_system_id = p_user_id
68: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
62: x_description OUT NOCOPY VARCHAR2) IS
63:
64: CURSOR wf_users_csr(cp_user_id NUMBER)IS
65: SELECT name, display_name
66: FROM wf_users
67: WHERE orig_system_id = p_user_id
68: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
69:
70: CURSOR fnd_users_csr(cp_user_id NUMBER)IS
72: FROM fnd_user
73: WHERE user_id = cp_user_id;
74: BEGIN
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76: OPEN wf_users_csr(p_user_id);
77: FETCH wf_users_csr INTO x_name, x_description;
78: CLOSE wf_users_csr;
79: IF x_name IS NULL THEN
80: OPEN fnd_users_csr(p_user_id);
73: WHERE user_id = cp_user_id;
74: BEGIN
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76: OPEN wf_users_csr(p_user_id);
77: FETCH wf_users_csr INTO x_name, x_description;
78: CLOSE wf_users_csr;
79: IF x_name IS NULL THEN
80: OPEN fnd_users_csr(p_user_id);
81: FETCH fnd_users_csr INTO x_name, x_description;
74: BEGIN
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76: OPEN wf_users_csr(p_user_id);
77: FETCH wf_users_csr INTO x_name, x_description;
78: CLOSE wf_users_csr;
79: IF x_name IS NULL THEN
80: OPEN fnd_users_csr(p_user_id);
81: FETCH fnd_users_csr INTO x_name, x_description;
82: CLOSE fnd_users_csr;