APPS.OKL_SETUPPRODUCTS_PVT dependencies on WF_USERS

Line 1203: CURSOR wf_users_csr(c_user_id NUMBER)

1199: x_return_status OUT NOCOPY VARCHAR2,
1200: x_name OUT NOCOPY VARCHAR2,
1201: x_description OUT NOCOPY VARCHAR2) IS
1202:
1203: CURSOR wf_users_csr(c_user_id NUMBER)
1204: IS
1205: SELECT NAME, DISPLAY_NAME
1206: FROM WF_USERS
1207: WHERE orig_system_id = c_user_id

Line 1206: FROM WF_USERS

1202:
1203: CURSOR wf_users_csr(c_user_id NUMBER)
1204: IS
1205: SELECT NAME, DISPLAY_NAME
1206: FROM WF_USERS
1207: WHERE orig_system_id = c_user_id
1208: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
1209:
1210: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 1218: OPEN wf_users_csr(p_user_id);

1214: FROM FND_USER
1215: WHERE user_id = c_user_id;
1216: BEGIN
1217: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1218: OPEN wf_users_csr(p_user_id);
1219: FETCH wf_users_csr INTO x_name, x_description;
1220: CLOSE wf_users_csr;
1221: IF x_name IS NULL THEN
1222: OPEN fnd_users_csr(p_user_id);

Line 1219: FETCH wf_users_csr INTO x_name, x_description;

1215: WHERE user_id = c_user_id;
1216: BEGIN
1217: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1218: OPEN wf_users_csr(p_user_id);
1219: FETCH wf_users_csr INTO x_name, x_description;
1220: CLOSE wf_users_csr;
1221: IF x_name IS NULL THEN
1222: OPEN fnd_users_csr(p_user_id);
1223: FETCH fnd_users_csr INTO x_name, x_description;

Line 1220: CLOSE wf_users_csr;

1216: BEGIN
1217: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1218: OPEN wf_users_csr(p_user_id);
1219: FETCH wf_users_csr INTO x_name, x_description;
1220: CLOSE wf_users_csr;
1221: IF x_name IS NULL THEN
1222: OPEN fnd_users_csr(p_user_id);
1223: FETCH fnd_users_csr INTO x_name, x_description;
1224: CLOSE fnd_users_csr;