DBA Data[Home] [Help]

APPS.OKL_KBK_APPROVALS_WF dependencies on FND_USER

Line 93: CURSOR fnd_users_csr(c_user_id NUMBER)

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)
94: IS
95: SELECT USER_NAME, DESCRIPTION
96: FROM FND_USER
97: WHERE user_id = c_user_id;

Line 96: FROM FND_USER

92:
93: CURSOR fnd_users_csr(c_user_id NUMBER)
94: IS
95: SELECT USER_NAME, DESCRIPTION
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);

Line 104: OPEN fnd_users_csr(p_user_id);

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;
107: IF x_name IS NULL THEN
108: x_name := G_DEFAULT_USER_DESC;

Line 105: FETCH fnd_users_csr INTO x_name, x_description;

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;
107: IF x_name IS NULL THEN
108: x_name := G_DEFAULT_USER_DESC;
109: x_description := G_DEFAULT_USER_DESC;

Line 106: CLOSE fnd_users_csr;

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;
107: IF x_name IS NULL THEN
108: x_name := G_DEFAULT_USER_DESC;
109: x_description := G_DEFAULT_USER_DESC;
110: END IF;

Line 325: -- the FND User ID context is lost.

321: l_requester_id := FND_GLOBAL.USER_ID;
322:
323: -- Bug 13103855: For ESG Contracts, observed that during Import
324: -- AME was showing the requestor as Anonymous. This is because
325: -- the FND User ID context is lost.
326: -- Make sure that if l_requester_id is -1, reset it from OKC_K_HEADERS_ALL_B.CREATED_BY
327: IF l_requester_id = - 1
328: THEN
329: --

Line 1135: CURSOR l_fnd_users_csr(p_user_id NUMBER)

1131: actid IN NUMBER,
1132: funcmode IN VARCHAR2,
1133: resultout OUT NOCOPY VARCHAR2)
1134: IS
1135: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1136: IS
1137: SELECT USER_NAME
1138: FROM FND_USER
1139: WHERE user_id = p_user_id;

Line 1138: FROM FND_USER

1134: IS
1135: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1136: IS
1137: SELECT USER_NAME
1138: FROM FND_USER
1139: WHERE user_id = p_user_id;
1140:
1141: l_api_name VARCHAR2(200) := 'Get_Lease_Contract_Approver';
1142:

Line 1164: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

1160: aname => G_WF_ITM_CONTRACT_NUMBER);
1161:
1162: resultout := 'COMPLETE:NOT_FOUND'; -- default
1163: IF l_user_id IS NOT NULL THEN
1164: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
1165: LOOP
1166: --Start of changes by jjuneja for Bug # 16189745
1167: --Commented following by jjuneja for Bug # 16189745
1168: /*

Line 1172: avalue => l_fnd_users_rec.user_name);

1168: /*
1169: wf_engine.SetItemAttrText (itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => G_WF_ITM_APPROVER,
1172: avalue => l_fnd_users_rec.user_name);
1173: */
1174: IF (( wf_engine.GetItemAttrText (itemtype => itemtype,
1175: itemkey => itemkey,
1176: aname => G_WF_ITM_APPROVER)) IS NULL)

Line 1181: avalue => l_fnd_users_rec.user_name);

1177: THEN
1178: wf_engine.SetItemAttrText (itemtype => itemtype,
1179: itemkey => itemkey,
1180: aname => G_WF_ITM_APPROVER,
1181: avalue => l_fnd_users_rec.user_name);
1182: END IF;
1183: --End of changes by jjuneja for Bug # 16189745
1184: wf_engine.SetItemAttrText (itemtype => itemtype,
1185: itemkey => itemkey,

Line 1193: avalue => l_fnd_users_rec.user_name);

1189: --Added by jjuneja for Bug # 15991081
1190: wf_engine.SetItemAttrText (itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => G_WF_ITM_FROM_ROLE,
1193: avalue => l_fnd_users_rec.user_name);
1194: --End of addition by jjuneja
1195:
1196: resultout := 'COMPLETE:FOUND';
1197: END LOOP;