APPS.OKL_VP_CR_WF dependencies on FND_USER

Line 70: CURSOR fnd_users_csr(cp_user_id NUMBER)IS

66: FROM wf_users
67: WHERE orig_system_id = p_user_id
68: AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
69:
70: CURSOR fnd_users_csr(cp_user_id NUMBER)IS
71: SELECT user_name, description
72: FROM fnd_user
73: WHERE user_id = cp_user_id;
74: BEGIN

Line 72: FROM fnd_user

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

Line 80: OPEN fnd_users_csr(p_user_id);

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

Line 81: FETCH fnd_users_csr INTO x_name, x_description;

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

Line 82: CLOSE fnd_users_csr;

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

Line 490: CURSOR l_fnd_users_csr(p_user_id NUMBER)

486: ,itemkey IN VARCHAR2
487: ,actid IN NUMBER
488: ,funcmode IN VARCHAR2
489: ,resultout OUT NOCOPY VARCHAR2) IS
490: CURSOR l_fnd_users_csr(p_user_id NUMBER)
491: IS
492: SELECT USER_NAME
493: FROM FND_USER
494: WHERE user_id = p_user_id;

Line 493: FROM FND_USER

489: ,resultout OUT NOCOPY VARCHAR2) IS
490: CURSOR l_fnd_users_csr(p_user_id NUMBER)
491: IS
492: SELECT USER_NAME
493: FROM FND_USER
494: WHERE user_id = p_user_id;
495:
496: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'get_agrmnt_approver';
497:

Line 517: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP

513: aname => G_WF_ITM_REQUESTER_ID);
514:
515: resultout := 'COMPLETE:N'; -- default
516: IF l_user_id IS NOT NULL THEN
517: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
518: wf_engine.SetItemAttrText (itemtype => itemtype,
519: itemkey => itemkey,
520: aname => G_WF_ITM_APPROVER,
521: avalue => l_fnd_users_rec.user_name);

Line 521: avalue => l_fnd_users_rec.user_name);

517: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
518: wf_engine.SetItemAttrText (itemtype => itemtype,
519: itemkey => itemkey,
520: aname => G_WF_ITM_APPROVER,
521: avalue => l_fnd_users_rec.user_name);
522:
523: -- Message: "Change Request requires approval"
524: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVAL_SUB', G_WF_ITM_MESSAGE_SUBJECT);
525: