82: x_return_status OUT NOCOPY VARCHAR2,
83: x_name OUT NOCOPY VARCHAR2,
84: x_description OUT NOCOPY VARCHAR2) IS
85:
86: CURSOR wf_users_csr(c_user_id NUMBER)
87: IS
88: SELECT NAME, DISPLAY_NAME
89: FROM WF_USERS
90: WHERE orig_system_id = c_user_id
85:
86: CURSOR wf_users_csr(c_user_id NUMBER)
87: IS
88: SELECT NAME, DISPLAY_NAME
89: FROM WF_USERS
90: WHERE orig_system_id = c_user_id
91: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
92:
93: CURSOR fnd_users_csr(c_user_id NUMBER)
96: FROM FND_USER
97: WHERE user_id = c_user_id;
98: BEGIN
99: x_return_status := OKL_API.G_RET_STS_SUCCESS;
100: OPEN wf_users_csr(p_user_id);
101: FETCH wf_users_csr INTO x_name, x_description;
102: CLOSE wf_users_csr;
103: IF x_name IS NULL THEN
104: OPEN fnd_users_csr(p_user_id);
97: WHERE user_id = c_user_id;
98: BEGIN
99: x_return_status := OKL_API.G_RET_STS_SUCCESS;
100: OPEN wf_users_csr(p_user_id);
101: FETCH wf_users_csr INTO x_name, x_description;
102: CLOSE wf_users_csr;
103: IF x_name IS NULL THEN
104: OPEN fnd_users_csr(p_user_id);
105: FETCH fnd_users_csr INTO x_name, x_description;
98: BEGIN
99: x_return_status := OKL_API.G_RET_STS_SUCCESS;
100: OPEN wf_users_csr(p_user_id);
101: FETCH wf_users_csr INTO x_name, x_description;
102: CLOSE wf_users_csr;
103: IF x_name IS NULL THEN
104: OPEN fnd_users_csr(p_user_id);
105: FETCH fnd_users_csr INTO x_name, x_description;
106: CLOSE fnd_users_csr;