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_UTIL dependencies on WF_ROLES

Line 1815: tempOrigSystem wf_roles.orig_system%type;

1811: itemIdIn in varchar2 default null,
1812: approverRecord2Out out nocopy ame_util.approverRecord2) as
1813: errorCode integer;
1814: errorMessage ame_util.longestStringType;
1815: tempOrigSystem wf_roles.orig_system%type;
1816: tempOrigSystemId wf_roles.orig_system_id%type;
1817: wfName wf_roles.name%type;
1818: wfDisplayName wf_roles.display_name%type;
1819: begin

Line 1816: tempOrigSystemId wf_roles.orig_system_id%type;

1812: approverRecord2Out out nocopy ame_util.approverRecord2) as
1813: errorCode integer;
1814: errorMessage ame_util.longestStringType;
1815: tempOrigSystem wf_roles.orig_system%type;
1816: tempOrigSystemId wf_roles.orig_system_id%type;
1817: wfName wf_roles.name%type;
1818: wfDisplayName wf_roles.display_name%type;
1819: begin
1820: if approverRecordIn.person_id is null then

Line 1817: wfName wf_roles.name%type;

1813: errorCode integer;
1814: errorMessage ame_util.longestStringType;
1815: tempOrigSystem wf_roles.orig_system%type;
1816: tempOrigSystemId wf_roles.orig_system_id%type;
1817: wfName wf_roles.name%type;
1818: wfDisplayName wf_roles.display_name%type;
1819: begin
1820: if approverRecordIn.person_id is null then
1821: tempOrigSystem := ame_util.fndUserOrigSystem;

Line 1818: wfDisplayName wf_roles.display_name%type;

1814: errorMessage ame_util.longestStringType;
1815: tempOrigSystem wf_roles.orig_system%type;
1816: tempOrigSystemId wf_roles.orig_system_id%type;
1817: wfName wf_roles.name%type;
1818: wfDisplayName wf_roles.display_name%type;
1819: begin
1820: if approverRecordIn.person_id is null then
1821: tempOrigSystem := ame_util.fndUserOrigSystem;
1822: tempOrigSystemId := approverRecordIn.user_id;

Line 1830: from wf_roles wf

1826: end if;
1827: if tempOrigSystem = ame_util.perOrigSystem then
1828: select name, display_name
1829: into wfName, wfDisplayName
1830: from wf_roles wf
1831: where orig_system = tempOrigSystem
1832: and orig_system_id = tempOrigSystemId
1833: and status = 'ACTIVE'
1834: and (expiration_date is null or sysdate < expiration_date)

Line 1841: select null from wf_roles wf2

1837: where u.user_name = wf.name
1838: and trunc(sysdate) between u.start_date
1839: and nvl(u.end_date,trunc(sysdate)))
1840: and not exists (
1841: select null from wf_roles wf2
1842: where wf.orig_system = wf2.orig_system
1843: and wf.orig_system_id = wf2.orig_system_id
1844: and wf.start_date > wf2.start_date
1845: )

Line 1856: from wf_roles wf

1852: into wfName
1853: ,wfDisplayName
1854: ,tempOrigSystem
1855: ,tempOrigSystemId
1856: from wf_roles wf
1857: where wf.orig_system in('FND_USR','PER')
1858: and wf.name in (select u.user_name
1859: from fnd_user u
1860: where u.user_id = tempOrigSystemId

Line 2040: wfName wf_roles.name%type;

2036: approversTable2Out out nocopy ame_util.approversTable2) is
2037: ct integer;
2038: errorCode integer;
2039: errorMessage ame_util.longestStringType;
2040: wfName wf_roles.name%type;
2041: wfDisplayName wf_roles.display_name%type;
2042: tempOrigSystem wf_roles.orig_system%type;
2043: tempOrigSystemId wf_roles.orig_system_id%type;
2044: begin

Line 2041: wfDisplayName wf_roles.display_name%type;

2037: ct integer;
2038: errorCode integer;
2039: errorMessage ame_util.longestStringType;
2040: wfName wf_roles.name%type;
2041: wfDisplayName wf_roles.display_name%type;
2042: tempOrigSystem wf_roles.orig_system%type;
2043: tempOrigSystemId wf_roles.orig_system_id%type;
2044: begin
2045: for ct in 1..approversTableIn.count loop

Line 2042: tempOrigSystem wf_roles.orig_system%type;

2038: errorCode integer;
2039: errorMessage ame_util.longestStringType;
2040: wfName wf_roles.name%type;
2041: wfDisplayName wf_roles.display_name%type;
2042: tempOrigSystem wf_roles.orig_system%type;
2043: tempOrigSystemId wf_roles.orig_system_id%type;
2044: begin
2045: for ct in 1..approversTableIn.count loop
2046: if approversTableIn(ct).person_id is null then

Line 2043: tempOrigSystemId wf_roles.orig_system_id%type;

2039: errorMessage ame_util.longestStringType;
2040: wfName wf_roles.name%type;
2041: wfDisplayName wf_roles.display_name%type;
2042: tempOrigSystem wf_roles.orig_system%type;
2043: tempOrigSystemId wf_roles.orig_system_id%type;
2044: begin
2045: for ct in 1..approversTableIn.count loop
2046: if approversTableIn(ct).person_id is null then
2047: tempOrigSystem := ame_util.fndUserOrigSystem;

Line 2066: from wf_roles wf

2062: approversTable2Out(ct).source := approversTableIn(ct).source;
2063: if tempOrigSystem = ame_util.perOrigSystem then
2064: select name, display_name
2065: into wfName, wfDisplayName
2066: from wf_roles wf
2067: where orig_system = tempOrigSystem
2068: and orig_system_id = tempOrigSystemId
2069: and status = 'ACTIVE'
2070: and (expiration_date is null or sysdate < expiration_date)

Line 2077: select null from wf_roles wf2

2073: where u.user_name = wf.name
2074: and trunc(sysdate) between u.start_date
2075: and nvl(u.end_date,trunc(sysdate)))
2076: and not exists (
2077: select null from wf_roles wf2
2078: where wf.orig_system = wf2.orig_system
2079: and wf.orig_system_id = wf2.orig_system_id
2080: and wf.start_date > wf2.start_date
2081: )

Line 2092: from wf_roles wf

2088: into wfName
2089: ,wfDisplayName
2090: ,tempOrigSystem
2091: ,tempOrigSystemId
2092: from wf_roles wf
2093: where wf.orig_system in('FND_USR','PER')
2094: and wf.name in (select u.user_name
2095: from fnd_user u
2096: where u.user_id = tempOrigSystemId