APPS.OKL_SETUPPRODUCTS_PVT dependencies on WF_USERS

Line 1220: CURSOR wf_users_csr(c_user_id NUMBER)

1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_name OUT NOCOPY VARCHAR2,
1218: x_description OUT NOCOPY VARCHAR2) IS
1219:
1220: CURSOR wf_users_csr(c_user_id NUMBER)
1221: IS
1222: SELECT NAME, DISPLAY_NAME
1223: FROM WF_USERS
1224: WHERE orig_system_id = c_user_id

Line 1223: FROM WF_USERS

1219:
1220: CURSOR wf_users_csr(c_user_id NUMBER)
1221: IS
1222: SELECT NAME, DISPLAY_NAME
1223: FROM WF_USERS
1224: WHERE orig_system_id = c_user_id
1225: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
1226:
1227: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 1235: OPEN wf_users_csr(p_user_id);

1231: FROM FND_USER
1232: WHERE user_id = c_user_id;
1233: BEGIN
1234: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1235: OPEN wf_users_csr(p_user_id);
1236: FETCH wf_users_csr INTO x_name, x_description;
1237: CLOSE wf_users_csr;
1238: IF x_name IS NULL THEN
1239: OPEN fnd_users_csr(p_user_id);

Line 1236: FETCH wf_users_csr INTO x_name, x_description;

1232: WHERE user_id = c_user_id;
1233: BEGIN
1234: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1235: OPEN wf_users_csr(p_user_id);
1236: FETCH wf_users_csr INTO x_name, x_description;
1237: CLOSE wf_users_csr;
1238: IF x_name IS NULL THEN
1239: OPEN fnd_users_csr(p_user_id);
1240: FETCH fnd_users_csr INTO x_name, x_description;

Line 1237: CLOSE wf_users_csr;

1233: BEGIN
1234: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1235: OPEN wf_users_csr(p_user_id);
1236: FETCH wf_users_csr INTO x_name, x_description;
1237: CLOSE wf_users_csr;
1238: IF x_name IS NULL THEN
1239: OPEN fnd_users_csr(p_user_id);
1240: FETCH fnd_users_csr INTO x_name, x_description;
1241: CLOSE fnd_users_csr;