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 WF_LOCAL_ROLES

Line 42: from wf_local_roles

38: return getApproverDisplayName(nameIn => name);
39: else
40: select display_name
41: into name
42: from wf_local_roles
43: where ((orig_system = origSystemIn and
44: orig_system_id = origSystemIdIn) or
45: (origSystemIn = ame_util.fndUserOrigSystem and
46: orig_system = ame_util.perOrigSystem and

Line 55: where u.user_name = wf_local_roles.name))

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
59: and wf_local_roles.orig_system_id = wf2.orig_system_id

Line 57: select null from wf_local_roles wf2

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
59: and wf_local_roles.orig_system_id = wf2.orig_system_id
60: and wf_local_roles.start_date > wf2.start_date)
61: and rownum < 2;

Line 58: where wf_local_roles.orig_system = wf2.orig_system

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
59: and wf_local_roles.orig_system_id = wf2.orig_system_id
60: and wf_local_roles.start_date > wf2.start_date)
61: and rownum < 2;
62: end if;

Line 59: and wf_local_roles.orig_system_id = wf2.orig_system_id

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
59: and wf_local_roles.orig_system_id = wf2.orig_system_id
60: and wf_local_roles.start_date > wf2.start_date)
61: and rownum < 2;
62: end if;
63: return('Invalid Approver: ' || name);

Line 60: and wf_local_roles.start_date > wf2.start_date)

56: and not exists (
57: select null from wf_local_roles wf2
58: where wf_local_roles.orig_system = wf2.orig_system
59: and wf_local_roles.orig_system_id = wf2.orig_system_id
60: and wf_local_roles.start_date > wf2.start_date)
61: and rownum < 2;
62: end if;
63: return('Invalid Approver: ' || name);
64: exception

Line 206: from the wf_local_roles.

202: /*
203: This procedure returns the display name, origsystemid and origsystem for the given role name.
204: If the name is valid wf_roles name, validityOut is returned as true.If the name is not found,
205: validityOut is returned as false and the display name, origsystemid and origsystem are returned
206: from the wf_local_roles.
207: */
208: procedure getApproverDetails(nameIn in varchar2
209: ,validityOut out NOCOPY varchar2
210: ,displayNameOut out NOCOPY varchar2

Line 236: from WF_LOCAL_ROLES. (It may still be there, even though the approver is

232: when no_data_found then
233: begin
234: /*
235: When the approver is not valid in WF_ROLES, try to get the approver info
236: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
237: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
238: See bug 3286313.
239: */
240: select

Line 237: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.

233: begin
234: /*
235: When the approver is not valid in WF_ROLES, try to get the approver info
236: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
237: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
238: See bug 3286313.
239: */
240: select
241: display_name,

Line 248: from wf_local_roles

244: into
245: displayNameOut,
246: origSystemOut,
247: origSystemIdOut
248: from wf_local_roles
249: where
250: name = nameIn and
251: rownum < 2;
252: validityOut := 'INACTIVE';

Line 367: from WF_LOCAL_ROLES. (It may still be there, even though the approver is

363: when no_data_found then
364: begin
365: /*
366: When the approver is not valid in WF_ROLES, try to get the approver info
367: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
368: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
369: See bug 3286313.
370: */
371: select

Line 368: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.

364: begin
365: /*
366: When the approver is not valid in WF_ROLES, try to get the approver info
367: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
368: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
369: See bug 3286313.
370: */
371: select
372: orig_system

Line 375: from wf_local_roles

371: select
372: orig_system
373: into
374: origSystem
375: from wf_local_roles
376: where
377: name = nameIn and
378: rownum < 2;
379: return(origSystem);

Line 406: from WF_LOCAL_ROLES. (It may still be there, even though the approver is

402: when no_data_found then
403: begin
404: /*
405: When the approver is not valid in WF_ROLES, try to get the approver info
406: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
407: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
408: See bug 3286313.
409: */
410: select

Line 407: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.

403: begin
404: /*
405: When the approver is not valid in WF_ROLES, try to get the approver info
406: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
407: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
408: See bug 3286313.
409: */
410: select
411: orig_system

Line 414: from wf_local_roles

410: select
411: orig_system
412: into
413: origSystem
414: from wf_local_roles
415: where
416: name = nameIn and
417: rownum < 2;
418: return(origSystem);

Line 1066: from WF_LOCAL_ROLES. (It may still be there, even though the approver is

1062: when no_data_found then
1063: begin
1064: /*
1065: When the approver is not valid in WF_ROLES, try to get the approver info
1066: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
1067: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
1068: See bug 3286313.
1069: */
1070: select

Line 1067: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.

1063: begin
1064: /*
1065: When the approver is not valid in WF_ROLES, try to get the approver info
1066: from WF_LOCAL_ROLES. (It may still be there, even though the approver is
1067: invalid.) If not found in WF_LOCAL_ROLES, return nameIn in descriptionOut.
1068: See bug 3286313.
1069: */
1070: select
1071: display_name,

Line 1076: from wf_local_roles

1072: orig_system
1073: into
1074: descriptionOut,
1075: origSystem
1076: from wf_local_roles
1077: where
1078: name = nameIn and
1079: rownum < 2;
1080: exception