APPS.OKL_FUNDING_WF dependencies on FND_USER

Line 101: CURSOR fnd_users_csr(c_user_id NUMBER)

97: FROM WF_USERS
98: WHERE orig_system_id = c_user_id
99: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
100:
101: CURSOR fnd_users_csr(c_user_id NUMBER)
102: IS
103: SELECT USER_NAME, DESCRIPTION
104: FROM FND_USER
105: WHERE user_id = c_user_id;

Line 104: FROM FND_USER

100:
101: CURSOR fnd_users_csr(c_user_id NUMBER)
102: IS
103: SELECT USER_NAME, DESCRIPTION
104: FROM FND_USER
105: WHERE user_id = c_user_id;
106: BEGIN
107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
108: OPEN wf_users_csr(p_user_id);

Line 112: OPEN fnd_users_csr(p_user_id);

108: OPEN wf_users_csr(p_user_id);
109: FETCH wf_users_csr INTO x_name, x_description;
110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);
113: FETCH fnd_users_csr INTO x_name, x_description;
114: CLOSE fnd_users_csr;
115: IF x_name IS NULL THEN
116: x_name := G_DEFAULT_USER_DESC;

Line 113: FETCH fnd_users_csr INTO x_name, x_description;

109: FETCH wf_users_csr INTO x_name, x_description;
110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);
113: FETCH fnd_users_csr INTO x_name, x_description;
114: CLOSE fnd_users_csr;
115: IF x_name IS NULL THEN
116: x_name := G_DEFAULT_USER_DESC;
117: x_description := G_DEFAULT_USER_DESC;

Line 114: CLOSE fnd_users_csr;

110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);
113: FETCH fnd_users_csr INTO x_name, x_description;
114: CLOSE fnd_users_csr;
115: IF x_name IS NULL THEN
116: x_name := G_DEFAULT_USER_DESC;
117: x_description := G_DEFAULT_USER_DESC;
118: END IF;

Line 1251: CURSOR l_fnd_users_csr(p_user_id NUMBER)

1247: actid IN NUMBER,
1248: funcmode IN VARCHAR2,
1249: resultout OUT NOCOPY VARCHAR2)
1250: IS
1251: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1252: IS
1253: SELECT USER_NAME
1254: FROM FND_USER
1255: WHERE user_id = p_user_id;

Line 1254: FROM FND_USER

1250: IS
1251: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1252: IS
1253: SELECT USER_NAME
1254: FROM FND_USER
1255: WHERE user_id = p_user_id;
1256:
1257: l_api_name VARCHAR2(200) := 'Get_Approver';
1258:

Line 1280: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

1276: aname => G_WF_ITM_FUNDING_NUMBER);
1277:
1278: resultout := 'COMPLETE:NOT_FOUND'; -- default
1279: IF l_user_id IS NOT NULL THEN
1280: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
1281: LOOP
1282: wf_engine.SetItemAttrText (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => G_WF_ITM_APPROVER,

Line 1285: avalue => l_fnd_users_rec.user_name);

1281: LOOP
1282: wf_engine.SetItemAttrText (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => G_WF_ITM_APPROVER,
1285: avalue => l_fnd_users_rec.user_name);
1286:
1287:
1288: wf_engine.SetItemAttrText (itemtype => itemtype,
1289: itemkey => itemkey,