APPS.OKL_SUBSIDY_POOL_WF dependencies on FND_USER

Line 67: CURSOR fnd_users_csr(c_user_id NUMBER)

63: FROM WF_USERS
64: WHERE orig_system_id = p_user_id
65: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
66:
67: CURSOR fnd_users_csr(c_user_id NUMBER)
68: IS
69: SELECT USER_NAME, DESCRIPTION
70: FROM FND_USER
71: WHERE user_id = c_user_id;

Line 70: FROM FND_USER

66:
67: CURSOR fnd_users_csr(c_user_id NUMBER)
68: IS
69: SELECT USER_NAME, DESCRIPTION
70: FROM FND_USER
71: WHERE user_id = c_user_id;
72: BEGIN
73: x_return_status := OKL_API.G_RET_STS_SUCCESS;
74: OPEN wf_users_csr(p_user_id);

Line 78: OPEN fnd_users_csr(p_user_id);

74: OPEN wf_users_csr(p_user_id);
75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);
79: FETCH fnd_users_csr INTO x_name, x_description;
80: CLOSE fnd_users_csr;
81: IF x_name IS NULL THEN
82: x_name := G_DEFAULT_USER;

Line 79: FETCH fnd_users_csr INTO x_name, x_description;

75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);
79: FETCH fnd_users_csr INTO x_name, x_description;
80: CLOSE fnd_users_csr;
81: IF x_name IS NULL THEN
82: x_name := G_DEFAULT_USER;
83: x_description := G_DEFAULT_USER_DESC;

Line 80: CLOSE fnd_users_csr;

76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);
79: FETCH fnd_users_csr INTO x_name, x_description;
80: CLOSE fnd_users_csr;
81: IF x_name IS NULL THEN
82: x_name := G_DEFAULT_USER;
83: x_description := G_DEFAULT_USER_DESC;
84: END IF;

Line 882: CURSOR l_fnd_users_csr(p_user_id NUMBER)

878: ,itemkey IN VARCHAR2
879: ,actid IN NUMBER
880: ,funcmode IN VARCHAR2
881: ,resultout OUT NOCOPY VARCHAR2) IS
882: CURSOR l_fnd_users_csr(p_user_id NUMBER)
883: IS
884: SELECT USER_NAME
885: FROM FND_USER
886: WHERE user_id = p_user_id;

Line 885: FROM FND_USER

881: ,resultout OUT NOCOPY VARCHAR2) IS
882: CURSOR l_fnd_users_csr(p_user_id NUMBER)
883: IS
884: SELECT USER_NAME
885: FROM FND_USER
886: WHERE user_id = p_user_id;
887:
888: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'get_subsidy_pool_approver';
889:

Line 924: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP

920: aname => 'LAUNCHING_EVENT');
921:
922: resultout := 'COMPLETE:N'; -- default
923: IF l_user_id IS NOT NULL THEN
924: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
925: wf_engine.SetItemAttrText (itemtype => itemtype,
926: itemkey => itemkey,
927: aname => G_WF_ITM_APPROVER,
928: avalue => l_fnd_users_rec.user_name);

Line 928: avalue => l_fnd_users_rec.user_name);

924: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
925: wf_engine.SetItemAttrText (itemtype => itemtype,
926: itemkey => itemkey,
927: aname => G_WF_ITM_APPROVER,
928: avalue => l_fnd_users_rec.user_name);
929:
930: lv_pool_name := wf_engine.GetItemAttrText(itemtype => itemtype,
931: itemkey => itemkey,
932: aname => G_WF_ITM_SUBSIDY_POOL_NAME);