APPS.OKL_KBK_APPROVALS_WF dependencies on FND_USER

Line 92: CURSOR fnd_users_csr(c_user_id NUMBER)

88: FROM WF_USERS
89: WHERE orig_system_id = c_user_id
90: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
91:
92: CURSOR fnd_users_csr(c_user_id NUMBER)
93: IS
94: SELECT USER_NAME, DESCRIPTION
95: FROM FND_USER
96: WHERE user_id = c_user_id;

Line 95: FROM FND_USER

91:
92: CURSOR fnd_users_csr(c_user_id NUMBER)
93: IS
94: SELECT USER_NAME, DESCRIPTION
95: FROM FND_USER
96: WHERE user_id = c_user_id;
97: BEGIN
98: x_return_status := OKL_API.G_RET_STS_SUCCESS;
99: OPEN wf_users_csr(p_user_id);

Line 103: OPEN fnd_users_csr(p_user_id);

99: OPEN wf_users_csr(p_user_id);
100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);
104: FETCH fnd_users_csr INTO x_name, x_description;
105: CLOSE fnd_users_csr;
106: IF x_name IS NULL THEN
107: x_name := G_DEFAULT_USER_DESC;

Line 104: FETCH fnd_users_csr INTO x_name, x_description;

100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);
104: FETCH fnd_users_csr INTO x_name, x_description;
105: CLOSE fnd_users_csr;
106: IF x_name IS NULL THEN
107: x_name := G_DEFAULT_USER_DESC;
108: x_description := G_DEFAULT_USER_DESC;

Line 105: CLOSE fnd_users_csr;

101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);
104: FETCH fnd_users_csr INTO x_name, x_description;
105: CLOSE fnd_users_csr;
106: IF x_name IS NULL THEN
107: x_name := G_DEFAULT_USER_DESC;
108: x_description := G_DEFAULT_USER_DESC;
109: END IF;

Line 1109: CURSOR l_fnd_users_csr(p_user_id NUMBER)

1105: actid IN NUMBER,
1106: funcmode IN VARCHAR2,
1107: resultout OUT NOCOPY VARCHAR2)
1108: IS
1109: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1110: IS
1111: SELECT USER_NAME
1112: FROM FND_USER
1113: WHERE user_id = p_user_id;

Line 1112: FROM FND_USER

1108: IS
1109: CURSOR l_fnd_users_csr(p_user_id NUMBER)
1110: IS
1111: SELECT USER_NAME
1112: FROM FND_USER
1113: WHERE user_id = p_user_id;
1114:
1115: l_api_name VARCHAR2(200) := 'Get_Lease_Contract_Approver';
1116:

Line 1138: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

1134: aname => G_WF_ITM_CONTRACT_NUMBER);
1135:
1136: resultout := 'COMPLETE:NOT_FOUND'; -- default
1137: IF l_user_id IS NOT NULL THEN
1138: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
1139: LOOP
1140: wf_engine.SetItemAttrText (itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => G_WF_ITM_APPROVER,

Line 1143: avalue => l_fnd_users_rec.user_name);

1139: LOOP
1140: wf_engine.SetItemAttrText (itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => G_WF_ITM_APPROVER,
1143: avalue => l_fnd_users_rec.user_name);
1144:
1145:
1146: wf_engine.SetItemAttrText (itemtype => itemtype,
1147: itemkey => itemkey,