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.WF_MAIL dependencies on WF_ROLES

Line 447: from wf_roles r, wf_user_roles ur

443:
444: cursor c_roles(parent in varchar2)
445: is
446: select name, email_address
447: from wf_roles r, wf_user_roles ur
448: where ur.role_name = parent
449: and r.name = ur.user_name;
450:
451: begin

Line 8274: l_display_name wf_roles.display_name%TYPE;

8270: hdrxml varchar2(32000);
8271: hdrxmlPos integer;
8272:
8273:
8274: l_display_name wf_roles.display_name%TYPE;
8275: l_to_emailaddress wf_roles.email_address%TYPE;
8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;
8277: l_language wf_roles.LANGUAGE %TYPE;
8278: l_territory wf_roles.territory%TYPE;

Line 8275: l_to_emailaddress wf_roles.email_address%TYPE;

8271: hdrxmlPos integer;
8272:
8273:
8274: l_display_name wf_roles.display_name%TYPE;
8275: l_to_emailaddress wf_roles.email_address%TYPE;
8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;
8277: l_language wf_roles.LANGUAGE %TYPE;
8278: l_territory wf_roles.territory%TYPE;
8279:

Line 8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;

8272:
8273:
8274: l_display_name wf_roles.display_name%TYPE;
8275: l_to_emailaddress wf_roles.email_address%TYPE;
8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;
8277: l_language wf_roles.LANGUAGE %TYPE;
8278: l_territory wf_roles.territory%TYPE;
8279:
8280: CURSOR c_ques IS

Line 8277: l_language wf_roles.LANGUAGE %TYPE;

8273:
8274: l_display_name wf_roles.display_name%TYPE;
8275: l_to_emailaddress wf_roles.email_address%TYPE;
8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;
8277: l_language wf_roles.LANGUAGE %TYPE;
8278: l_territory wf_roles.territory%TYPE;
8279:
8280: CURSOR c_ques IS
8281: SELECT from_role, to_role, user_comment

Line 8278: l_territory wf_roles.territory%TYPE;

8274: l_display_name wf_roles.display_name%TYPE;
8275: l_to_emailaddress wf_roles.email_address%TYPE;
8276: l_to_ntf_pref wf_roles.notification_preference%TYPE;
8277: l_language wf_roles.LANGUAGE %TYPE;
8278: l_territory wf_roles.territory%TYPE;
8279:
8280: CURSOR c_ques IS
8281: SELECT from_role, to_role, user_comment
8282: FROM wf_comments