APPS.OKL_VP_OA_WF dependencies on FND_USER

Line 64: CURSOR fnd_users_csr(cp_user_id NUMBER)IS

60: FROM wf_users
61: WHERE orig_system_id = p_user_id
62: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
63:
64: CURSOR fnd_users_csr(cp_user_id NUMBER)IS
65: SELECT user_name, description
66: FROM fnd_user
67: WHERE user_id = cp_user_id;
68: BEGIN

Line 66: FROM fnd_user

62: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
63:
64: CURSOR fnd_users_csr(cp_user_id NUMBER)IS
65: SELECT user_name, description
66: FROM fnd_user
67: WHERE user_id = cp_user_id;
68: BEGIN
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70: OPEN wf_users_csr(p_user_id);

Line 74: OPEN fnd_users_csr(p_user_id);

70: OPEN wf_users_csr(p_user_id);
71: FETCH wf_users_csr INTO x_name, x_description;
72: CLOSE wf_users_csr;
73: IF x_name IS NULL THEN
74: OPEN fnd_users_csr(p_user_id);
75: FETCH fnd_users_csr INTO x_name, x_description;
76: CLOSE fnd_users_csr;
77: IF x_name IS NULL THEN
78: x_name := G_DEFAULT_USER;

Line 75: FETCH fnd_users_csr INTO x_name, x_description;

71: FETCH wf_users_csr INTO x_name, x_description;
72: CLOSE wf_users_csr;
73: IF x_name IS NULL THEN
74: OPEN fnd_users_csr(p_user_id);
75: FETCH fnd_users_csr INTO x_name, x_description;
76: CLOSE fnd_users_csr;
77: IF x_name IS NULL THEN
78: x_name := G_DEFAULT_USER;
79: x_description := G_DEFAULT_USER_DESC;

Line 76: CLOSE fnd_users_csr;

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

Line 436: CURSOR l_fnd_users_csr(p_user_id NUMBER)

432: ,itemkey IN VARCHAR2
433: ,actid IN NUMBER
434: ,funcmode IN VARCHAR2
435: ,resultout OUT NOCOPY VARCHAR2) IS
436: CURSOR l_fnd_users_csr(p_user_id NUMBER)
437: IS
438: SELECT USER_NAME
439: FROM FND_USER
440: WHERE user_id = p_user_id;

Line 439: FROM FND_USER

435: ,resultout OUT NOCOPY VARCHAR2) IS
436: CURSOR l_fnd_users_csr(p_user_id NUMBER)
437: IS
438: SELECT USER_NAME
439: FROM FND_USER
440: WHERE user_id = p_user_id;
441:
442: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'get_agrmnt_approver';
443:

Line 463: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP

459: aname => G_WF_ITM_REQUESTER_ID);
460:
461: resultout := 'COMPLETE:N'; -- default
462: IF l_user_id IS NOT NULL THEN
463: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
464: wf_engine.SetItemAttrText (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => G_WF_ITM_APPROVER,
467: avalue => l_fnd_users_rec.user_name);

Line 467: avalue => l_fnd_users_rec.user_name);

463: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
464: wf_engine.SetItemAttrText (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => G_WF_ITM_APPROVER,
467: avalue => l_fnd_users_rec.user_name);
468:
469: -- Message: "Operating Agreement requires approval"
470: set_attrib_message(itemtype, itemkey, 'OKL_VN_OA_REQ_APPROVAL_SUB', G_WF_ITM_MESSAGE_SUBJECT);
471: