APPS.OKL_VP_PA_WF dependencies on FND_USER

Line 67: CURSOR fnd_users_csr(cp_user_id NUMBER)IS

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(cp_user_id NUMBER)IS
68: SELECT user_name, description
69: FROM fnd_user
70: WHERE user_id = cp_user_id;
71: BEGIN

Line 69: FROM fnd_user

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

Line 77: OPEN fnd_users_csr(p_user_id);

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

Line 78: FETCH fnd_users_csr INTO x_name, x_description;

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

Line 79: CLOSE fnd_users_csr;

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

Line 437: CURSOR l_fnd_users_csr(p_user_id NUMBER)

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

Line 440: FROM FND_USER

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

Line 464: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP

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

Line 468: avalue => l_fnd_users_rec.user_name);

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