APPS.OKL_CREDIT_LINE_WF dependencies on FND_USER

Line 102: CURSOR fnd_users_csr(c_user_id NUMBER)

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

Line 105: FROM FND_USER

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

Line 113: OPEN fnd_users_csr(p_user_id);

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

Line 114: FETCH fnd_users_csr INTO x_name, x_description;

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

Line 115: CLOSE fnd_users_csr;

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

Line 905: CURSOR l_fnd_users_csr(p_user_id NUMBER)

901: actid IN NUMBER,
902: funcmode IN VARCHAR2,
903: resultout OUT NOCOPY VARCHAR2)
904: IS
905: CURSOR l_fnd_users_csr(p_user_id NUMBER)
906: IS
907: SELECT USER_NAME
908: FROM FND_USER
909: WHERE user_id = p_user_id;

Line 908: FROM FND_USER

904: IS
905: CURSOR l_fnd_users_csr(p_user_id NUMBER)
906: IS
907: SELECT USER_NAME
908: FROM FND_USER
909: WHERE user_id = p_user_id;
910:
911: l_api_name CONSTANT VARCHAR2(200) := 'get_credit_line_approver';
912: l_user_id VARCHAR2(200);

Line 932: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

928: aname => G_WF_ITM_CONTRACT_NUMBER);
929:
930: resultout := 'COMPLETE:NOT_FOUND'; -- default
931: IF l_user_id IS NOT NULL THEN
932: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
933: LOOP
934: wf_engine.SetItemAttrText (itemtype => itemtype,
935: itemkey => itemkey,
936: aname => G_WF_ITM_APPROVER,

Line 937: avalue => l_fnd_users_rec.user_name);

933: LOOP
934: wf_engine.SetItemAttrText (itemtype => itemtype,
935: itemkey => itemkey,
936: aname => G_WF_ITM_APPROVER,
937: avalue => l_fnd_users_rec.user_name);
938:
939:
940: wf_engine.SetItemAttrText (itemtype => itemtype,
941: itemkey => itemkey,