DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_DIRECTORY

Line 132: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)

128: -- NOTE
129: -- A role will only be resolved to one level. If a role contains has a
130: -- role associated to it, then that's as far as we go.
131: procedure GetRecipients(p_role in varchar2,
132: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)
133: is
134:
135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;

Line 176: wf_directory.GetRoleInfo(p_role, l_display_name, l_email_address,

172:
173: begin
174:
175: -- Get role details.
176: wf_directory.GetRoleInfo(p_role, l_display_name, l_email_address,
177: l_notification_preference, l_language,
178: l_territory);
179:
180: -- If the email address is NULL, then look for the members attached to

Line 201: wf_directory.GetRoleInfo(urrec.name, l_display_name,

197: -- will get a notification.
198: colon := instr(p_role, ':');
199: if colon > 0 then
200: for urrec in urc1(p_role, colon) loop
201: wf_directory.GetRoleInfo(urrec.name, l_display_name,
202: l_email_address,
203: l_notification_preference, l_language,
204: l_territory);
205: i := p_recipient_list.COUNT + 1;

Line 217: wf_directory.GetRoleInfo(urrec.name, l_display_name,

213: p_recipient_list(i).email_address := l_email_address;
214: end loop;
215: else
216: for urrec in urc2(p_role) loop
217: wf_directory.GetRoleInfo(urrec.name, l_display_name,
218: l_email_address,
219: l_notification_preference, l_language,
220: l_territory);
221: i := p_recipient_list.COUNT + 1;

Line 1448: p_recipient_list in WF_DIRECTORY.wf_local_roles_tbl_type,

1444: -- Piority for the message
1445: -- A CLOB Containing the XML encoded message.
1446: procedure GetXMLMessage (p_nid in number,
1447: p_protocol in varchar2,
1448: p_recipient_list in WF_DIRECTORY.wf_local_roles_tbl_type,
1449: p_node in varchar2,
1450: p_agent in varchar2,
1451: p_replyto in varchar2,
1452: p_nlang in varchar2,

Line 1883: l_recipient_list WF_DIRECTORY.wf_local_roles_tbl_type;

1879:
1880: l_recipient_role varchar2(320);
1881: l_ntf_pref varchar2(30);
1882: l_language varchar2(30);
1883: l_recipient_list WF_DIRECTORY.wf_local_roles_tbl_type;
1884: l_recipient_lang WF_DIRECTORY.wf_local_roles_tbl_type;
1885: l_wf_schema varchar2(320) := g_wfSchema;
1886:
1887: l_err_name varchar2(30);

Line 1884: l_recipient_lang WF_DIRECTORY.wf_local_roles_tbl_type;

1880: l_recipient_role varchar2(320);
1881: l_ntf_pref varchar2(30);
1882: l_language varchar2(30);
1883: l_recipient_list WF_DIRECTORY.wf_local_roles_tbl_type;
1884: l_recipient_lang WF_DIRECTORY.wf_local_roles_tbl_type;
1885: l_wf_schema varchar2(320) := g_wfSchema;
1886:
1887: l_err_name varchar2(30);
1888: l_err_message varchar2(2000);

Line 2961: WF_DIRECTORY.GetRoleInfoMail(role => copy_recipient_list(i),

2957: step := 'Processing role {'||copy_recipient_list(i)||'}';
2958:
2959: -- Get the qualified email address but the other details
2960: -- are not needed.
2961: WF_DIRECTORY.GetRoleInfoMail(role => copy_recipient_list(i),
2962: display_name => display_name,
2963: email_address => email,
2964: notification_preference => pref,
2965: language => dummy,

Line 2995: WF_DIRECTORY.GetRoleInfoMail(role => r.user_name,

2991: orig_system_id) loop
2992:
2993: step := 'Getting member role '||r.user_name||
2994: 'details to the document';
2995: WF_DIRECTORY.GetRoleInfoMail(role => r.user_name,
2996: display_name => display_name,
2997: email_address => email,
2998: notification_preference => pref,
2999: language => dummy,

Line 3245: WF_DIRECTORY.GetRoleInfoMail2(recipient_role, display_name, email,

3241: recipient_role := p_recipient_role;
3242:
3243: -- <> :
3244: -- Obtain recipient's NLS information by using new API
3245: WF_DIRECTORY.GetRoleInfoMail2(recipient_role, display_name, email,
3246: notification_pref,
3247: orig_system,
3248: orig_system_id,
3249: installed,

Line 4323: -- Call OLD API instead of WF_DIRECTORY.GetRoleInfoMail2

4319: return;
4320: end if;
4321:
4322: -- <>:
4323: -- Call OLD API instead of WF_DIRECTORY.GetRoleInfoMail2
4324: -- here I think we are OK as we are not using other parameters.
4325: --
4326: -- Obtain recipient information
4327: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,

Line 4327: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,

4323: -- Call OLD API instead of WF_DIRECTORY.GetRoleInfoMail2
4324: -- here I think we are OK as we are not using other parameters.
4325: --
4326: -- Obtain recipient information
4327: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,
4328: notification_pref,
4329: language, territory,
4330: orig_system, orig_system_id, installed);
4331:

Line 4491: --WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,

4487: pos := p_pos;
4488: occurance := 1;
4489:
4490: -- Obtain recipient information
4491: --WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,
4492: -- notification_pref,
4493: -- language, territory,
4494: -- orig_system, orig_system_id, installed);
4495:

Line 4497: WF_DIRECTORY.GetRoleInfoMail2(recipient_role, display_name, email,

4493: -- language, territory,
4494: -- orig_system, orig_system_id, installed);
4495:
4496: -- Obtain recipient's NLS information too
4497: WF_DIRECTORY.GetRoleInfoMail2(recipient_role, display_name, email,
4498: notification_pref,
4499: orig_system,
4500: orig_system_id,
4501: installed,

Line 4986: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,

4982: pos := length(str);
4983: dbms_lob.write(p_doc, pos, 1, str);
4984:
4985: -- Obtain recipient information
4986: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,
4987: notification_pref,
4988: language, territory,
4989: orig_system, orig_system_id, installed);
4990:

Line 5828: WHERE Wf_Directory.GetRoleNtfPref(recipient) in ('SUMMARY', 'SUMHTML');

5824: FROM wf_notifications
5825: WHERE mail_status is null
5826: AND status = 'OPEN'
5827: AND rownum > 0)
5828: WHERE Wf_Directory.GetRoleNtfPref(recipient) in ('SUMMARY', 'SUMHTML');
5829:
5830: begin
5831:
5832: l_eventkey := p_event.GetEventKey();