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.AME_APPROVER_TYPE_PKG dependencies on FND_USER

Line 48: from fnd_user

44: orig_system_id = origSystemIdIn) or
45: (origSystemIn = ame_util.fndUserOrigSystem and
46: orig_system = ame_util.perOrigSystem and
47: orig_system_id = (select employee_id
48: from fnd_user
49: where user_id = origSystemIdIn)))
50: and status = 'ACTIVE'
51: and (orig_system not in (ame_util.fndUserOrigSystem,ame_util.perOrigSystem)
52: or exists

Line 54: from fnd_user u

50: and status = 'ACTIVE'
51: and (orig_system not in (ame_util.fndUserOrigSystem,ame_util.perOrigSystem)
52: or exists
53: (select null
54: from fnd_user u
55: where u.user_name = wf_local_roles.name))
56: and not exists (
57: select null from wf_local_roles wf2
58: where wf_local_roles.orig_system = wf2.orig_system

Line 137: If an fnd_user entry has a non-null employee_id (person ID) value, it gets

133: errorCode integer;
134: errorMessage ame_util.longestStringType;
135: begin
136: /*
137: If an fnd_user entry has a non-null employee_id (person ID) value, it gets
138: converted to the PER originating system in wf_roles; otherwise, it gets
139: converted to the FND_USR originating system. As just one of these will
140: happen, we can match both originating systems in a single-row query.
141: The order-by-name clause and rownum < 2 condition are necessary because we

Line 154: from fnd_user

150: orig_system_id = origSystemIdIn) or
151: (origSystemIn = ame_util.fndUserOrigSystem and
152: orig_system = ame_util.perOrigSystem and
153: orig_system_id = (select employee_id
154: from fnd_user
155: where
156: user_id = origSystemIdIn and
157: sysdate between
158: start_date and

Line 165: from fnd_user u

161: (expiration_date is null or
162: sysdate < expiration_date) and
163: (orig_system not in (ame_util.fndUserOrigSystem,ame_util.perOrigSystem)
164: or exists (select null
165: from fnd_user u
166: where u.user_name = wf_roles.name
167: and trunc(sysdate) between u.start_date
168: and nvl(u.end_date,trunc(sysdate)))) and
169: not exists (

Line 542: If an fnd_user entry has a non-null employee_id (person ID) value, it gets

538: errorMessage ame_util.longestStringType;
539: name wf_roles.name%type;
540: begin
541: /*
542: If an fnd_user entry has a non-null employee_id (person ID) value, it gets
543: converted to the PER originating system in wf_roles; otherwise, it gets
544: converted to the FND_USR originating system. As just one of these will
545: happen, we can match both originating systems in a single-row query.
546: The order-by-name clause and rownum < 2 condition are necessary because we

Line 559: from fnd_user

555: orig_system_id = origSystemIdIn) or
556: (origSystemIn = ame_util.fndUserOrigSystem and
557: orig_system = ame_util.perOrigSystem and
558: orig_system_id = (select employee_id
559: from fnd_user
560: where
561: user_id = origSystemIdIn and
562: sysdate between
563: start_date and

Line 570: from fnd_user u

566: (expiration_date is null or
567: sysdate < expiration_date) and
568: (orig_system not in (ame_util.fndUserOrigSystem,ame_util.perOrigSystem)
569: or exists (select null
570: from fnd_user u
571: where u.user_name = wf_roles.name
572: and trunc(sysdate) between u.start_date
573: and nvl(u.end_date,trunc(sysdate)))) and
574: not exists (

Line 781: fnd_user,

777: /* The compiler forces passing arguments by position in the following function calls. */
778: getWfRolesName(ame_util.fndUserOrigSystem, user_id) approver_name,
779: getApproverDescription(getWfRolesName(ame_util.fndUserOrigSystem, user_id)) approver_description
780: from
781: fnd_user,
782: wf_roles
783: where
784: wf_roles.orig_system_id = fnd_user.user_id and
785: wf_roles.orig_system = ame_util.fndUserOrigSystem and

Line 784: wf_roles.orig_system_id = fnd_user.user_id and

780: from
781: fnd_user,
782: wf_roles
783: where
784: wf_roles.orig_system_id = fnd_user.user_id and
785: wf_roles.orig_system = ame_util.fndUserOrigSystem and
786: wf_roles.status = 'ACTIVE' and
787: wf_roles.name = fnd_user.user_name and
788: (userNameIn is null or

Line 787: wf_roles.name = fnd_user.user_name and

783: where
784: wf_roles.orig_system_id = fnd_user.user_id and
785: wf_roles.orig_system = ame_util.fndUserOrigSystem and
786: wf_roles.status = 'ACTIVE' and
787: wf_roles.name = fnd_user.user_name and
788: (userNameIn is null or
789: upper(fnd_user.user_name) like upper(replace(userNameIn, '''', '''''')) || '%') and
790: (emailAddressIn is null or
791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and

Line 789: upper(fnd_user.user_name) like upper(replace(userNameIn, '''', '''''')) || '%') and

785: wf_roles.orig_system = ame_util.fndUserOrigSystem and
786: wf_roles.status = 'ACTIVE' and
787: wf_roles.name = fnd_user.user_name and
788: (userNameIn is null or
789: upper(fnd_user.user_name) like upper(replace(userNameIn, '''', '''''')) || '%') and
790: (emailAddressIn is null or
791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and
792: truncatedSysdateIn between
793: fnd_user.start_date and

Line 791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and

787: wf_roles.name = fnd_user.user_name and
788: (userNameIn is null or
789: upper(fnd_user.user_name) like upper(replace(userNameIn, '''', '''''')) || '%') and
790: (emailAddressIn is null or
791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and
792: truncatedSysdateIn between
793: fnd_user.start_date and
794: nvl(fnd_user.end_date, truncatedSysdateIn) and
795: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */

Line 793: fnd_user.start_date and

789: upper(fnd_user.user_name) like upper(replace(userNameIn, '''', '''''')) || '%') and
790: (emailAddressIn is null or
791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and
792: truncatedSysdateIn between
793: fnd_user.start_date and
794: nvl(fnd_user.end_date, truncatedSysdateIn) and
795: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
796: order by fnd_user.user_name;
797: /* local variables */

Line 794: nvl(fnd_user.end_date, truncatedSysdateIn) and

790: (emailAddressIn is null or
791: upper(fnd_user.email_address) like upper(replace(emailAddressIn, '''', '''''')) || '%') and
792: truncatedSysdateIn between
793: fnd_user.start_date and
794: nvl(fnd_user.end_date, truncatedSysdateIn) and
795: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
796: order by fnd_user.user_name;
797: /* local variables */
798: approverNames ame_util.longStringList;

Line 796: order by fnd_user.user_name;

792: truncatedSysdateIn between
793: fnd_user.start_date and
794: nvl(fnd_user.end_date, truncatedSysdateIn) and
795: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
796: order by fnd_user.user_name;
797: /* local variables */
798: approverNames ame_util.longStringList;
799: approverDescriptions ame_util.longStringList;
800: errorCode integer;

Line 1437: from fnd_user u

1433: wf_roles.orig_system_id = per_all_assignments_f.supervisor_id and
1434: wf_roles.status = 'ACTIVE' and
1435: (wf_roles.expiration_date is null or sysdate < wf_roles.expiration_date) and
1436: exists (select null
1437: from fnd_user u
1438: where u.user_name = wf_roles.name
1439: and trunc(sysdate) between u.start_date
1440: and nvl(u.end_date,trunc(sysdate))) and
1441: not exists (

Line 1480: from fnd_user u

1476: wf_roles.orig_system_id = per_all_assignments_f.supervisor_id and
1477: wf_roles.status = 'ACTIVE' and
1478: (wf_roles.expiration_date is null or sysdate < wf_roles.expiration_date) and
1479: exists (select null
1480: from fnd_user u
1481: where u.user_name = wf_roles.name
1482: and trunc(sysdate) between u.start_date
1483: and nvl(u.end_date,trunc(sysdate))) and
1484: per_all_assignments_f.person_id =

Line 1486: from fnd_user

1482: and trunc(sysdate) between u.start_date
1483: and nvl(u.end_date,trunc(sysdate))) and
1484: per_all_assignments_f.person_id =
1485: (select employee_id
1486: from fnd_user
1487: where
1488: user_id = approverIn.orig_system_id and
1489: rownum < 2) and
1490: per_all_assignments_f.primary_flag = 'Y' and

Line 1632: from fnd_user u

1628: wf_roles.orig_system_id = per_all_assignments_f.supervisor_id and
1629: wf_roles.status = 'ACTIVE' and
1630: (wf_roles.expiration_date is null or sysdate < wf_roles.expiration_date) and
1631: exists (select null
1632: from fnd_user u
1633: where u.user_name = wf_roles.name
1634: and trunc(sysdate) between u.start_date
1635: and nvl(u.end_date,trunc(sysdate))) and
1636: not exists (

Line 1673: from fnd_user u

1669: wf_roles.orig_system = ame_util.perOrigSystem and
1670: wf_roles.orig_system_id = per_all_assignments_f.supervisor_id and
1671: wf_roles.status = 'ACTIVE' and
1672: exists (select null
1673: from fnd_user u
1674: where u.user_name = wf_roles.name
1675: and trunc(sysdate) between u.start_date
1676: and nvl(u.end_date,trunc(sysdate))) and
1677: (wf_roles.expiration_date is null or sysdate < wf_roles.expiration_date) and

Line 1680: from fnd_user

1676: and nvl(u.end_date,trunc(sysdate))) and
1677: (wf_roles.expiration_date is null or sysdate < wf_roles.expiration_date) and
1678: per_all_assignments_f.person_id =
1679: (select employee_id
1680: from fnd_user
1681: where
1682: user_id = origSystemIdIn and
1683: rownum < 2) and
1684: per_all_assignments_f.primary_flag = 'Y' and

Line 1802: If an fnd_user entry has a non-null employee_id (person ID) value, it gets

1798: This procedure should select the input approver's wf_roles.display_name, NOT the
1799: display name of the input approver's orig_system.
1800: */
1801: /*
1802: If an fnd_user entry has a non-null employee_id (person ID) value, it gets
1803: converted to the PER originating system in wf_roles; otherwise, it gets
1804: converted to the FND_USR originating system. As just one of these will
1805: happen, we can match both originating systems in a single-row query.
1806: The order-by-name clause and rownum < 2 condition are necessary because we

Line 1823: from fnd_user

1819: orig_system_id = origSystemIdIn) or
1820: (origSystemIn = ame_util.fndUserOrigSystem and
1821: orig_system = ame_util.perOrigSystem and
1822: orig_system_id = (select employee_id
1823: from fnd_user
1824: where
1825: user_id = origSystemIdIn and
1826: sysdate between
1827: start_date and

Line 1834: from fnd_user u

1830: (expiration_date is null or
1831: sysdate < expiration_date) and
1832: (orig_system not in (ame_util.fndUserOrigSystem,ame_util.perOrigSystem)
1833: or exists (select null
1834: from fnd_user u
1835: where u.user_name = wf_roles.name
1836: and trunc(sysdate) between u.start_date
1837: and nvl(u.end_date,trunc(sysdate)))) and
1838: not exists (

Line 1966: from fnd_user u

1962: and wfr.orig_system_id = pap.person_id
1963: and wfr.orig_system = ame_util.perOrigSystem
1964: and wfr.status = 'ACTIVE'
1965: and exists (select null
1966: from fnd_user u
1967: where u.user_name = wfr.name
1968: and truncatedSysdateIn between u.start_date
1969: and nvl(u.end_date,truncatedSysdateIn))
1970: and (firstNameIn is null or upper(pap.first_name) like upper(replace(firstNameIn, '''', '''''')) || '%')