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 7955: l_display_name wf_roles.display_name%TYPE;

7951: hdrxml varchar2(32000);
7952: hdrxmlPos integer;
7953:
7954:
7955: l_display_name wf_roles.display_name%TYPE;
7956: l_to_emailaddress wf_roles.email_address%TYPE;
7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;
7958: l_language wf_roles.LANGUAGE %TYPE;
7959: l_territory wf_roles.territory%TYPE;

Line 7956: l_to_emailaddress wf_roles.email_address%TYPE;

7952: hdrxmlPos integer;
7953:
7954:
7955: l_display_name wf_roles.display_name%TYPE;
7956: l_to_emailaddress wf_roles.email_address%TYPE;
7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;
7958: l_language wf_roles.LANGUAGE %TYPE;
7959: l_territory wf_roles.territory%TYPE;
7960:

Line 7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;

7953:
7954:
7955: l_display_name wf_roles.display_name%TYPE;
7956: l_to_emailaddress wf_roles.email_address%TYPE;
7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;
7958: l_language wf_roles.LANGUAGE %TYPE;
7959: l_territory wf_roles.territory%TYPE;
7960:
7961: CURSOR c_ques IS

Line 7958: l_language wf_roles.LANGUAGE %TYPE;

7954:
7955: l_display_name wf_roles.display_name%TYPE;
7956: l_to_emailaddress wf_roles.email_address%TYPE;
7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;
7958: l_language wf_roles.LANGUAGE %TYPE;
7959: l_territory wf_roles.territory%TYPE;
7960:
7961: CURSOR c_ques IS
7962: SELECT from_role, to_role, user_comment

Line 7959: l_territory wf_roles.territory%TYPE;

7955: l_display_name wf_roles.display_name%TYPE;
7956: l_to_emailaddress wf_roles.email_address%TYPE;
7957: l_to_ntf_pref wf_roles.notification_preference%TYPE;
7958: l_language wf_roles.LANGUAGE %TYPE;
7959: l_territory wf_roles.territory%TYPE;
7960:
7961: CURSOR c_ques IS
7962: SELECT from_role, to_role, user_comment
7963: FROM wf_comments