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

Line 2441: select name from wf_local_roles

2437: l_procedure_name VARCHAR2(30) := '.remove_existing_user_role';
2438: l_debug_info VARCHAR2(500);
2439:
2440: CURSOR user_name_by_email_addr (p_email_address IN varchar2 DEFAULT NULL) IS
2441: select name from wf_local_roles
2442: where upper(EMAIL_ADDRESS) = UPPER(p_email_address)
2443: and ORIG_SYSTEM = 'WF_LOCAL_USERS'
2444: and STATUS ='ACTIVE'
2445: and USER_FLAG = 'Y'

Line 2452: and role_orig_system ='WF_LOCAL_ROLES';

2448: CURSOR user_role_by_email_addr (l_adhoc_user_name IN varchar2 DEFAULT NULL) IS
2449: select role_name from wf_local_user_roles
2450: where user_name = l_adhoc_user_name
2451: and user_orig_system ='WF_LOCAL_USERS'
2452: and role_orig_system ='WF_LOCAL_ROLES';
2453:
2454: user_name_by_email_addr_rec user_name_by_email_addr%ROWTYPE;
2455: user_role_by_email_addr_rec user_role_by_email_addr%ROWTYPE;
2456: