APPS.OKL_FUNDING_WF dependencies on FND_USER

Line 97: FROM WF_USERS wfu, fnd_user fndu

93:
94: CURSOR wf_users_csr(c_user_id NUMBER)
95: IS
96: SELECT wfu.NAME, wfu.DISPLAY_NAME
97: FROM WF_USERS wfu, fnd_user fndu
98: WHERE wfu.orig_system_id = fndu.employee_id
99: AND fndu.employee_id = c_user_id
100: AND wfu.ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
101: -- Bug#10098094: Modified by RGOOTY

Line 104: CURSOR fnd_users_csr(c_user_id NUMBER)

100: AND wfu.ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
101: -- Bug#10098094: Modified by RGOOTY
102:
103:
104: CURSOR fnd_users_csr(c_user_id NUMBER)
105: IS
106: SELECT USER_NAME, DESCRIPTION
107: FROM FND_USER
108: WHERE user_id = c_user_id;

Line 107: FROM FND_USER

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

Line 115: OPEN fnd_users_csr(p_user_id);

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

Line 116: FETCH fnd_users_csr INTO x_name, x_description;

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

Line 117: CLOSE fnd_users_csr;

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

Line 1293: CURSOR l_fnd_users_csr(p_user_id NUMBER)

1289: actid IN NUMBER,
1290: funcmode IN VARCHAR2,
1291: resultout OUT NOCOPY VARCHAR2)
1292: IS
1293: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1294: IS
1295: SELECT USER_NAME
1296: FROM FND_USER
1297: WHERE user_id = p_user_id;

Line 1296: FROM FND_USER

1292: IS
1293: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1294: IS
1295: SELECT USER_NAME
1296: FROM FND_USER
1297: WHERE user_id = p_user_id;
1298:
1299: l_api_name VARCHAR2(200) := 'Get_Approver';
1300:

Line 1322: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

1318: aname => G_WF_ITM_FUNDING_NUMBER);
1319:
1320: resultout := 'COMPLETE:NOT_FOUND'; -- default
1321: IF l_user_id IS NOT NULL THEN
1322: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
1323: LOOP
1324: wf_engine.SetItemAttrText (itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => G_WF_ITM_APPROVER,

Line 1327: avalue => l_fnd_users_rec.user_name);

1323: LOOP
1324: wf_engine.SetItemAttrText (itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => G_WF_ITM_APPROVER,
1327: avalue => l_fnd_users_rec.user_name);
1328:
1329:
1330: wf_engine.SetItemAttrText (itemtype => itemtype,
1331: itemkey => itemkey,