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_XML dependencies on WF_ROLES

Line 140: l_display_name wf_roles.display_name%TYPE;

136: procedure GetRecipients(p_role in varchar2,
137: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)
138: is
139:
140: l_display_name wf_roles.display_name%TYPE;
141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;

Line 141: l_description wf_roles.description%TYPE;

137: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)
138: is
139:
140: l_display_name wf_roles.display_name%TYPE;
141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;
145: l_territory wf_roles.territory%TYPE;

Line 142: l_email_address wf_roles.email_address%TYPE;

138: is
139:
140: l_display_name wf_roles.display_name%TYPE;
141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;
145: l_territory wf_roles.territory%TYPE;
146:

Line 143: l_notification_preference wf_roles.notification_preference%TYPE;

139:
140: l_display_name wf_roles.display_name%TYPE;
141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;
145: l_territory wf_roles.territory%TYPE;
146:
147: cursor urc1(role varchar2, colon binary_integer) is

Line 144: l_language wf_roles.language%TYPE;

140: l_display_name wf_roles.display_name%TYPE;
141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;
145: l_territory wf_roles.territory%TYPE;
146:
147: cursor urc1(role varchar2, colon binary_integer) is
148: select name

Line 145: l_territory wf_roles.territory%TYPE;

141: l_description wf_roles.description%TYPE;
142: l_email_address wf_roles.email_address%TYPE;
143: l_notification_preference wf_roles.notification_preference%TYPE;
144: l_language wf_roles.language%TYPE;
145: l_territory wf_roles.territory%TYPE;
146:
147: cursor urc1(role varchar2, colon binary_integer) is
148: select name
149: from wf_users

Line 3114: l_nlsLanguage wf_roles.language%TYPE;

3110: l_nlsDateLanguage varchar2(120);
3111: l_nlsCalendar varchar2(120);
3112: l_nlsNumericCharacters varchar2(30);
3113: l_nlsSort varchar2(120);
3114: l_nlsLanguage wf_roles.language%TYPE;
3115: l_nlsTerritory wf_roles.territory%TYPE;
3116: l_nlsCodeset VARCHAR2(30);
3117:
3118: --

Line 3115: l_nlsTerritory wf_roles.territory%TYPE;

3111: l_nlsCalendar varchar2(120);
3112: l_nlsNumericCharacters varchar2(30);
3113: l_nlsSort varchar2(120);
3114: l_nlsLanguage wf_roles.language%TYPE;
3115: l_nlsTerritory wf_roles.territory%TYPE;
3116: l_nlsCodeset VARCHAR2(30);
3117:
3118: --
3119: l_nlsCurrency VARCHAR2(30);

Line 3130: recipient_role wf_roles.name%TYPE;

3126: hdrxmlPos integer;
3127:
3128: access_key VARCHAR2(100);
3129: priority NUMBER;
3130: recipient_role wf_roles.name%TYPE;
3131: status VARCHAR2(100);
3132: subject VARCHAR2(4000);
3133:
3134: role wf_roles.name%TYPE;

Line 3134: role wf_roles.name%TYPE;

3130: recipient_role wf_roles.name%TYPE;
3131: status VARCHAR2(100);
3132: subject VARCHAR2(4000);
3133:
3134: role wf_roles.name%TYPE;
3135: display_name wf_roles.display_name%TYPE;
3136: email wf_roles.email_address%TYPE;
3137: notification_pref wf_roles.notification_preference%TYPE;
3138:

Line 3135: display_name wf_roles.display_name%TYPE;

3131: status VARCHAR2(100);
3132: subject VARCHAR2(4000);
3133:
3134: role wf_roles.name%TYPE;
3135: display_name wf_roles.display_name%TYPE;
3136: email wf_roles.email_address%TYPE;
3137: notification_pref wf_roles.notification_preference%TYPE;
3138:
3139: occurance integer := 1;

Line 3136: email wf_roles.email_address%TYPE;

3132: subject VARCHAR2(4000);
3133:
3134: role wf_roles.name%TYPE;
3135: display_name wf_roles.display_name%TYPE;
3136: email wf_roles.email_address%TYPE;
3137: notification_pref wf_roles.notification_preference%TYPE;
3138:
3139: occurance integer := 1;
3140: attrlist wf_xml_attr_table_type;

Line 3137: notification_pref wf_roles.notification_preference%TYPE;

3133:
3134: role wf_roles.name%TYPE;
3135: display_name wf_roles.display_name%TYPE;
3136: email wf_roles.email_address%TYPE;
3137: notification_pref wf_roles.notification_preference%TYPE;
3138:
3139: occurance integer := 1;
3140: attrlist wf_xml_attr_table_type;
3141: str varchar2 (250);

Line 4191: language wf_roles.language%TYPE;

4187: pos integer;
4188: amt number;
4189:
4190: installed VARCHAR2(1);
4191: language wf_roles.language%TYPE;
4192: territory wf_roles.territory%TYPE;
4193: codeset VARCHAR2(100);
4194: orig_system VARCHAR2(100);
4195: orig_system_id number;

Line 4192: territory wf_roles.territory%TYPE;

4188: amt number;
4189:
4190: installed VARCHAR2(1);
4191: language wf_roles.language%TYPE;
4192: territory wf_roles.territory%TYPE;
4193: codeset VARCHAR2(100);
4194: orig_system VARCHAR2(100);
4195: orig_system_id number;
4196:

Line 4197: recipient_role wf_roles.name%TYPE;

4193: codeset VARCHAR2(100);
4194: orig_system VARCHAR2(100);
4195: orig_system_id number;
4196:
4197: recipient_role wf_roles.name%TYPE;
4198: status VARCHAR2(100);
4199: mail_status VARCHAR2(100);
4200: str varchar2 (2000);
4201:

Line 4202: role wf_roles.name%TYPE;

4198: status VARCHAR2(100);
4199: mail_status VARCHAR2(100);
4200: str varchar2 (2000);
4201:
4202: role wf_roles.name%TYPE;
4203: display_name wf_roles.display_name%TYPE;
4204: email wf_roles.email_address%TYPE;
4205: notification_pref wf_roles.notification_preference%TYPE;
4206:

Line 4203: display_name wf_roles.display_name%TYPE;

4199: mail_status VARCHAR2(100);
4200: str varchar2 (2000);
4201:
4202: role wf_roles.name%TYPE;
4203: display_name wf_roles.display_name%TYPE;
4204: email wf_roles.email_address%TYPE;
4205: notification_pref wf_roles.notification_preference%TYPE;
4206:
4207: attrlist wf_xml_attr_table_type;

Line 4204: email wf_roles.email_address%TYPE;

4200: str varchar2 (2000);
4201:
4202: role wf_roles.name%TYPE;
4203: display_name wf_roles.display_name%TYPE;
4204: email wf_roles.email_address%TYPE;
4205: notification_pref wf_roles.notification_preference%TYPE;
4206:
4207: attrlist wf_xml_attr_table_type;
4208:

Line 4205: notification_pref wf_roles.notification_preference%TYPE;

4201:
4202: role wf_roles.name%TYPE;
4203: display_name wf_roles.display_name%TYPE;
4204: email wf_roles.email_address%TYPE;
4205: notification_pref wf_roles.notification_preference%TYPE;
4206:
4207: attrlist wf_xml_attr_table_type;
4208:
4209: nodename varchar2(100);

Line 5742: AND rownum > 0) , wf_roles wr

5738: (SELECT distinct nvl(more_info_role,recipient_role) recipient
5739: FROM wf_notifications
5740: WHERE mail_status is null
5741: AND status = 'OPEN'
5742: AND rownum > 0) , wf_roles wr
5743: WHERE recipient = wr.NAME
5744: AND wr.notification_preference = 'QUERY';
5745:
5746:

Line 5751: FROM wf_user_roles wu, wf_roles wr

5747: -- returns the users having the notification preference of
5748: -- 'SUMMARY' or 'SUMHTML' for the given role
5749: CURSOR c_get_sum_users(p_roleName VARCHAR2) is
5750: SELECT user_name
5751: FROM wf_user_roles wu, wf_roles wr
5752: WHERE wu.role_name = p_roleName
5753: AND wr.name = wu.user_name
5754: AND wu.user_orig_system = wr.orig_system
5755: AND wu.user_orig_system_id = wr.orig_system_id