DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_WF dependencies on FND_USER

Line 106: CURSOR fnd_users_csr(c_user_id NUMBER)

102: FROM WF_USERS
103: WHERE orig_system_id = c_user_id
104: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
105:
106: CURSOR fnd_users_csr(c_user_id NUMBER)
107: IS
108: SELECT USER_NAME, DESCRIPTION
109: FROM FND_USER
110: WHERE user_id = c_user_id;

Line 109: FROM FND_USER

105:
106: CURSOR fnd_users_csr(c_user_id NUMBER)
107: IS
108: SELECT USER_NAME, DESCRIPTION
109: FROM FND_USER
110: WHERE user_id = c_user_id;
111: BEGIN
112: x_return_status := OKL_API.G_RET_STS_SUCCESS;
113: OPEN wf_users_csr(p_user_id);

Line 117: OPEN fnd_users_csr(p_user_id);

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

Line 118: FETCH fnd_users_csr INTO x_name, x_description;

114: FETCH wf_users_csr INTO x_name, x_description;
115: CLOSE wf_users_csr;
116: IF x_name IS NULL THEN
117: OPEN fnd_users_csr(p_user_id);
118: FETCH fnd_users_csr INTO x_name, x_description;
119: CLOSE fnd_users_csr;
120: IF x_name IS NULL THEN
121: x_name := G_DEFAULT_USER_DESC;
122: x_description := G_DEFAULT_USER_DESC;

Line 119: CLOSE fnd_users_csr;

115: CLOSE wf_users_csr;
116: IF x_name IS NULL THEN
117: OPEN fnd_users_csr(p_user_id);
118: FETCH fnd_users_csr INTO x_name, x_description;
119: CLOSE fnd_users_csr;
120: IF x_name IS NULL THEN
121: x_name := G_DEFAULT_USER_DESC;
122: x_description := G_DEFAULT_USER_DESC;
123: END IF;

Line 811: CURSOR l_fnd_users_csr(p_user_id NUMBER)

807: actid IN NUMBER,
808: funcmode IN VARCHAR2,
809: resultout OUT NOCOPY VARCHAR2)
810: IS
811: CURSOR l_fnd_users_csr(p_user_id NUMBER)
812: IS
813: SELECT USER_NAME
814: FROM FND_USER
815: WHERE user_id = p_user_id;

Line 814: FROM FND_USER

810: IS
811: CURSOR l_fnd_users_csr(p_user_id NUMBER)
812: IS
813: SELECT USER_NAME
814: FROM FND_USER
815: WHERE user_id = p_user_id;
816:
817: l_api_name CONSTANT VARCHAR2(200) := 'get_add_khr_approver';
818: l_user_id VARCHAR2(200);

Line 837: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)

833: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
834:
835: resultout := 'COMPLETE:NOT_FOUND'; -- default
836: IF l_user_id IS NOT NULL THEN
837: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
838: LOOP
839: wf_engine.SetItemAttrText (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => G_WF_ITM_APPROVER,

Line 842: avalue => l_fnd_users_rec.user_name);

838: LOOP
839: wf_engine.SetItemAttrText (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => G_WF_ITM_APPROVER,
842: avalue => l_fnd_users_rec.user_name);
843:
844:
845: wf_engine.SetItemAttrText (itemtype => itemtype,
846: itemkey => itemkey,