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.UMX_LOGIN_HELP_PVT dependencies on WF_LOCAL_ROLES

Line 76: l_role_name wf_local_roles.name%type;

72: actid in number,
73: funcmode in varchar2,
74: resultout in out NOCOPY varchar2) is
75:
76: l_role_name wf_local_roles.name%type;
77: l_notification_preference wf_local_roles.notification_preference%type;
78: l_username fnd_user.user_name%type;
79: l_display_name varchar2(4000);
80: begin

Line 77: l_notification_preference wf_local_roles.notification_preference%type;

73: funcmode in varchar2,
74: resultout in out NOCOPY varchar2) is
75:
76: l_role_name wf_local_roles.name%type;
77: l_notification_preference wf_local_roles.notification_preference%type;
78: l_username fnd_user.user_name%type;
79: l_display_name varchar2(4000);
80: begin
81:

Line 191: -- 1) WF local roles

187:
188:
189:
190: -- Private function to get the email address of the active user from
191: -- 1) WF local roles
192: -- 2) FND User
193: -- 3) The first TCA party
194: procedure Get_email_address (p_user_name in fnd_user.user_name%type,
195: x_role_name out nocopy varchar2,

Line 202: l_role_display_name wf_local_roles.display_name%type;

198: x_message_name out nocopy varchar2) is
199:
200: -- TCA Party declares email address as varchar2 2000, largest amount the
201: -- three schema.
202: l_role_display_name wf_local_roles.display_name%type;
203: l_language wf_local_roles.language%type;
204: l_territory wf_local_roles.territory%type;
205:
206: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is

Line 203: l_language wf_local_roles.language%type;

199:
200: -- TCA Party declares email address as varchar2 2000, largest amount the
201: -- three schema.
202: l_role_display_name wf_local_roles.display_name%type;
203: l_language wf_local_roles.language%type;
204: l_territory wf_local_roles.territory%type;
205:
206: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
207: SELECT email_address

Line 204: l_territory wf_local_roles.territory%type;

200: -- TCA Party declares email address as varchar2 2000, largest amount the
201: -- three schema.
202: l_role_display_name wf_local_roles.display_name%type;
203: l_language wf_local_roles.language%type;
204: l_territory wf_local_roles.territory%type;
205:
206: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
207: SELECT email_address
208: FROM fnd_user

Line 273: l_role_display_name wf_local_roles.display_name%type;

269: x_message_name out nocopy varchar2) is
270:
271: -- TCA Party declares email address as varchar2 2000, largest amount the
272: -- three schema.
273: l_role_display_name wf_local_roles.display_name%type;
274: l_language wf_local_roles.language%type;
275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:

Line 274: l_language wf_local_roles.language%type;

270:
271: -- TCA Party declares email address as varchar2 2000, largest amount the
272: -- three schema.
273: l_role_display_name wf_local_roles.display_name%type;
274: l_language wf_local_roles.language%type;
275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:
278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is

Line 275: l_territory wf_local_roles.territory%type;

271: -- TCA Party declares email address as varchar2 2000, largest amount the
272: -- three schema.
273: l_role_display_name wf_local_roles.display_name%type;
274: l_language wf_local_roles.language%type;
275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:
278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
279: SELECT user_name FROM fnd_user

Line 344: l_role_display_name wf_local_roles.display_name%type;

340: x_users out NOCOPY UsersWEmail ) is
341:
342: -- TCA Party declares email address as varchar2 2000, largest amount the
343: -- three schema.
344: l_role_display_name wf_local_roles.display_name%type;
345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;

Line 345: l_language wf_local_roles.language%type;

341:
342: -- TCA Party declares email address as varchar2 2000, largest amount the
343: -- three schema.
344: l_role_display_name wf_local_roles.display_name%type;
345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;

Line 346: l_territory wf_local_roles.territory%type;

342: -- TCA Party declares email address as varchar2 2000, largest amount the
343: -- three schema.
344: l_role_display_name wf_local_roles.display_name%type;
345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;

Line 349: l_notification_preference wf_local_roles.notification_preference%type;

345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;
351:
352: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
353: SELECT user_name FROM fnd_user

Line 483: l_role_name wf_local_roles.name%type;

479: x_message_name out NOCOPY varchar2) is
480:
481: l_user_name fnd_user.user_name%type := upper(p_username);
482: l_email_address varchar2(2000);
483: l_role_name wf_local_roles.name%type;
484: l_password varchar2(40);
485: l_notification_preference wf_local_roles.notification_preference%type;
486: l_result wf_item_activity_statuses.activity_result_code%type;
487: l_status wf_item_activity_statuses.activity_status%type;

Line 485: l_notification_preference wf_local_roles.notification_preference%type;

481: l_user_name fnd_user.user_name%type := upper(p_username);
482: l_email_address varchar2(2000);
483: l_role_name wf_local_roles.name%type;
484: l_password varchar2(40);
485: l_notification_preference wf_local_roles.notification_preference%type;
486: l_result wf_item_activity_statuses.activity_result_code%type;
487: l_status wf_item_activity_statuses.activity_status%type;
488: l_itemkey wf_items.item_key%type;
489: l_pwdChangeable boolean := null;

Line 593: l_role_name wf_local_roles.name%type;

589: x_return_status out NOCOPY varchar2,
590: x_message_name out NOCOPY varchar2) is
591:
592: l_email_address varchar2(2000) := p_email;
593: l_role_name wf_local_roles.name%type;
594: l_notification_preference wf_local_roles.notification_preference%type;
595: l_result wf_item_activity_statuses.activity_result_code%type;
596: l_status wf_item_activity_statuses.activity_status%type;
597: l_itemkey wf_items.item_key%type;

Line 594: l_notification_preference wf_local_roles.notification_preference%type;

590: x_message_name out NOCOPY varchar2) is
591:
592: l_email_address varchar2(2000) := p_email;
593: l_role_name wf_local_roles.name%type;
594: l_notification_preference wf_local_roles.notification_preference%type;
595: l_result wf_item_activity_statuses.activity_result_code%type;
596: l_status wf_item_activity_statuses.activity_status%type;
597: l_itemkey wf_items.item_key%type;
598: l_user_name fnd_user.user_name%type;

Line 949: l_notification_preference wf_local_roles.notification_preference%type;

945: x_message_name out NOCOPY varchar2)
946: IS
947: l_user_name fnd_user.user_name%type;
948: l_authkey varchar2(400);
949: l_notification_preference wf_local_roles.notification_preference%type;
950: l_email_address varchar2(2000);
951: l_pwd_changeable boolean := true;
952: l_role_name wf_local_roles.name%type;
953: l_item_status varchar2(8);

Line 952: l_role_name wf_local_roles.name%type;

948: l_authkey varchar2(400);
949: l_notification_preference wf_local_roles.notification_preference%type;
950: l_email_address varchar2(2000);
951: l_pwd_changeable boolean := true;
952: l_role_name wf_local_roles.name%type;
953: l_item_status varchar2(8);
954: l_item_result varchar2(30);
955:
956: BEGIN

Line 1029: l_notification_preference wf_local_roles.notification_preference%type;

1025: x_message_name out NOCOPY varchar2)
1026: IS
1027: l_user_name fnd_user.user_name%type;
1028: l_authkey varchar2(400);
1029: l_notification_preference wf_local_roles.notification_preference%type;
1030: l_email_address varchar2(2000);
1031: l_pwd_changeable boolean := true;
1032: l_role_name wf_local_roles.name%type;
1033: l_item_status varchar2(8);

Line 1032: l_role_name wf_local_roles.name%type;

1028: l_authkey varchar2(400);
1029: l_notification_preference wf_local_roles.notification_preference%type;
1030: l_email_address varchar2(2000);
1031: l_pwd_changeable boolean := true;
1032: l_role_name wf_local_roles.name%type;
1033: l_item_status varchar2(8);
1034: l_item_result varchar2(30);
1035:
1036: BEGIN

Line 1200: -- l_role_name wf_local_roles.name%type;

1196: x_message_data out NOCOPY varchar2) IS
1197:
1198: l_user_name fnd_user.user_name%type := upper(p_username);
1199: -- l_email_address varchar2(2000);
1200: -- l_role_name wf_local_roles.name%type;
1201: l_password varchar2(40) := p_password;
1202: -- l_notification_preference wf_local_roles.notification_preference%type;
1203: l_result wf_item_activity_statuses.activity_result_code%type;
1204: -- l_status wf_item_activity_statuses.activity_status%type;

Line 1202: -- l_notification_preference wf_local_roles.notification_preference%type;

1198: l_user_name fnd_user.user_name%type := upper(p_username);
1199: -- l_email_address varchar2(2000);
1200: -- l_role_name wf_local_roles.name%type;
1201: l_password varchar2(40) := p_password;
1202: -- l_notification_preference wf_local_roles.notification_preference%type;
1203: l_result wf_item_activity_statuses.activity_result_code%type;
1204: -- l_status wf_item_activity_statuses.activity_status%type;
1205: -- l_itemkey wf_items.item_key%type;
1206: l_pwdChangeable boolean := null;

Line 1332: l_orig_system wf_local_roles.orig_system%TYPE;

1328: l_item_status varchar2(8);
1329: l_item_result varchar2(30);
1330: l_role_name varchar2(200);
1331: -- changes to figure out if role is a ad hoc role,7445188
1332: l_orig_system wf_local_roles.orig_system%TYPE;
1333: l_orig_system_id wf_local_roles.orig_system_id%type;
1334: begin
1335:
1336: x_return_status := 'S';

Line 1333: l_orig_system_id wf_local_roles.orig_system_id%type;

1329: l_item_result varchar2(30);
1330: l_role_name varchar2(200);
1331: -- changes to figure out if role is a ad hoc role,7445188
1332: l_orig_system wf_local_roles.orig_system%TYPE;
1333: l_orig_system_id wf_local_roles.orig_system_id%type;
1334: begin
1335:
1336: x_return_status := 'S';
1337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 1349: if l_orig_system ='WF_LOCAL_ROLES' then

1345: itemkey => p_itemKey,
1346: aname => 'X_USER_ROLE');
1347: -- get orig system info and check if this is an ad-hoc role ,7445188
1348: wf_directory.getroleOrigsysinfo(l_role_name,l_orig_system,l_orig_system_id);
1349: if l_orig_system ='WF_LOCAL_ROLES' then
1350: wf_directory.setAdHocRoleExpiration(l_role_name);
1351: end if;
1352:
1353: wf_engine.abortprocess(