eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_WF dependencies on WF_ROLES

Line 1532: -- and then WF_ROLES instead of WF_USERS.

1528: -- Parameters : itemtype, itemkey, actid, funcmode, resultout, p_user_id,
1529: -- x_name, x_description
1530: -- Version : 1.1
1531: -- MDOKAL : Bug 2902588, changed code to check for fnd_user info 1st
1532: -- and then WF_ROLES instead of WF_USERS.
1533: -- : 19-NOV-03 MDOKAL Bug 3262184 - changed order in which
1534: -- wf users are retrieved.
1535: -- End of comments
1536: PROCEDURE GET_NOTIFICATION_AGENT(

Line 1545: CURSOR wf_roles_csr(c_emp_id NUMBER, c_system VARCHAR2)

1541: , p_user_id IN NUMBER
1542: , x_name OUT NOCOPY VARCHAR2
1543: , x_description OUT NOCOPY VARCHAR2 ) IS
1544:
1545: CURSOR wf_roles_csr(c_emp_id NUMBER, c_system VARCHAR2)
1546: IS
1547: SELECT NAME, DISPLAY_NAME
1548: FROM WF_ROLES
1549: WHERE orig_system_id = c_emp_id

Line 1548: FROM WF_ROLES

1544:
1545: CURSOR wf_roles_csr(c_emp_id NUMBER, c_system VARCHAR2)
1546: IS
1547: SELECT NAME, DISPLAY_NAME
1548: FROM WF_ROLES
1549: WHERE orig_system_id = c_emp_id
1550: AND orig_system = c_system;
1551:
1552: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 1591: OPEN wf_roles_csr(p_user_id, 'PER');

1587: OPEN fnd_users_csr(p_user_id);
1588: FETCH fnd_users_csr INTO l_user, l_desc, l_emp;
1589: IF fnd_users_csr%notfound THEN
1590: -- 2nd check if id passed belongs to an employee rather then fnd user
1591: OPEN wf_roles_csr(p_user_id, 'PER');
1592: FETCH wf_roles_csr INTO l_user, l_desc;
1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user

Line 1592: FETCH wf_roles_csr INTO l_user, l_desc;

1588: FETCH fnd_users_csr INTO l_user, l_desc, l_emp;
1589: IF fnd_users_csr%notfound THEN
1590: -- 2nd check if id passed belongs to an employee rather then fnd user
1591: OPEN wf_roles_csr(p_user_id, 'PER');
1592: FETCH wf_roles_csr INTO l_user, l_desc;
1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');

Line 1593: IF wf_roles_csr%notfound THEN

1589: IF fnd_users_csr%notfound THEN
1590: -- 2nd check if id passed belongs to an employee rather then fnd user
1591: OPEN wf_roles_csr(p_user_id, 'PER');
1592: FETCH wf_roles_csr INTO l_user, l_desc;
1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;

Line 1594: CLOSE wf_roles_csr;

1590: -- 2nd check if id passed belongs to an employee rather then fnd user
1591: OPEN wf_roles_csr(p_user_id, 'PER');
1592: FETCH wf_roles_csr INTO l_user, l_desc;
1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;
1598: CLOSE wf_roles_csr;

Line 1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');

1592: FETCH wf_roles_csr INTO l_user, l_desc;
1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;
1598: CLOSE wf_roles_csr;
1599: ELSE
1600: CLOSE wf_roles_csr;

Line 1597: FETCH wf_roles_csr INTO l_user, l_desc;

1593: IF wf_roles_csr%notfound THEN
1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;
1598: CLOSE wf_roles_csr;
1599: ELSE
1600: CLOSE wf_roles_csr;
1601: END IF;

Line 1598: CLOSE wf_roles_csr;

1594: CLOSE wf_roles_csr;
1595: -- Maybe a HR user not attached to FND user
1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;
1598: CLOSE wf_roles_csr;
1599: ELSE
1600: CLOSE wf_roles_csr;
1601: END IF;
1602: END IF;

Line 1600: CLOSE wf_roles_csr;

1596: OPEN wf_roles_csr(p_user_id, 'HZ_PARTY');
1597: FETCH wf_roles_csr INTO l_user, l_desc;
1598: CLOSE wf_roles_csr;
1599: ELSE
1600: CLOSE wf_roles_csr;
1601: END IF;
1602: END IF;
1603: CLOSE fnd_users_csr;
1604:

Line 1608: OPEN wf_roles_csr(l_emp, 'PER');

1604:
1605: -- if l_emp is not null then the user is attached to an employee
1606: IF l_emp IS NOT NULL THEN
1607:
1608: OPEN wf_roles_csr(l_emp, 'PER');
1609: FETCH wf_roles_csr INTO l_user, l_desc;
1610: CLOSE wf_roles_csr;
1611:
1612: END IF;

Line 1609: FETCH wf_roles_csr INTO l_user, l_desc;

1605: -- if l_emp is not null then the user is attached to an employee
1606: IF l_emp IS NOT NULL THEN
1607:
1608: OPEN wf_roles_csr(l_emp, 'PER');
1609: FETCH wf_roles_csr INTO l_user, l_desc;
1610: CLOSE wf_roles_csr;
1611:
1612: END IF;
1613:

Line 1610: CLOSE wf_roles_csr;

1606: IF l_emp IS NOT NULL THEN
1607:
1608: OPEN wf_roles_csr(l_emp, 'PER');
1609: FETCH wf_roles_csr INTO l_user, l_desc;
1610: CLOSE wf_roles_csr;
1611:
1612: END IF;
1613:
1614: -- if l_user is still null, no user info was found