24:
25: select IBE_WFNOTIFICATION_S1.NEXTVAL into wf_itemkey_seq from dual;
26: wf_itemkey := 'IBE_USER_' || wf_itemkey_seq;
27:
28: wf_engine.CreateProcess (
29: itemtype => 'IBE_USER',
30: itemkey => wf_itemkey,
31: process => 'IBE_NOTIFY_USER'
32: );
29: itemtype => 'IBE_USER',
30: itemkey => wf_itemkey,
31: process => 'IBE_NOTIFY_USER'
32: );
33: wf_engine.SetItemUserKey (
34: itemtype => 'IBE_USER',
35: itemkey => wf_itemkey,
36: userkey => 'IBE User Notification ' || wf_itemkey_seq
37: );
34: itemtype => 'IBE_USER',
35: itemkey => wf_itemkey,
36: userkey => 'IBE User Notification ' || wf_itemkey_seq
37: );
38: wf_engine.SetItemAttrText (
39: itemtype => 'IBE_USER',
40: itemkey => wf_itemkey,
41: aname => 'ROLE_TO_NOTIFY',
42: avalue => user_name
40: itemkey => wf_itemkey,
41: aname => 'ROLE_TO_NOTIFY',
42: avalue => user_name
43: );
44: wf_engine.SetItemAttrText (
45: itemtype => 'IBE_USER',
46: itemkey => wf_itemkey,
47: aname => 'NOTIFICATION_SUBJECT',
48: avalue => subject
46: itemkey => wf_itemkey,
47: aname => 'NOTIFICATION_SUBJECT',
48: avalue => subject
49: );
50: wf_engine.SetItemAttrText (
51: itemtype => 'IBE_USER',
52: itemkey => wf_itemkey,
53: aname => 'NOTIFICATION_BODY',
54: avalue => body
52: itemkey => wf_itemkey,
53: aname => 'NOTIFICATION_BODY',
54: avalue => body
55: );
56: wf_engine.SetItemOwner (
57: itemtype => 'IBE_USER',
58: itemkey => wf_itemkey,
59: owner => user_name
60: );
57: itemtype => 'IBE_USER',
58: itemkey => wf_itemkey,
59: owner => user_name
60: );
61: wf_engine.StartProcess (
62: itemtype => 'IBE_USER',
63: itemkey => wf_itemkey
64: );
65:
114: email_address => email_list,
115: expiration_date => sysdate + 1
116: );
117:
118: wf_engine.CreateProcess (
119: itemtype => 'IBE_MAIL',
120: itemkey => wf_itemkey,
121: process => 'IBE_SEND_EMAIL'
122: );
119: itemtype => 'IBE_MAIL',
120: itemkey => wf_itemkey,
121: process => 'IBE_SEND_EMAIL'
122: );
123: wf_engine.SetItemUserKey (
124: itemtype => 'IBE_MAIL',
125: itemkey => wf_itemkey,
126: userkey => 'IBE Email Notification' || wf_itemkey_seq
127: );
124: itemtype => 'IBE_MAIL',
125: itemkey => wf_itemkey,
126: userkey => 'IBE Email Notification' || wf_itemkey_seq
127: );
128: wf_engine.SetItemAttrText (
129: itemtype => 'IBE_MAIL',
130: itemkey => wf_itemkey,
131: aname => 'ROLE_TO_NOTIFY',
132: avalue => role_name
130: itemkey => wf_itemkey,
131: aname => 'ROLE_TO_NOTIFY',
132: avalue => role_name
133: );
134: wf_engine.SetItemAttrText (
135: itemtype => 'IBE_MAIL',
136: itemkey => wf_itemkey,
137: aname => 'NOTIFICATION_SUBJECT',
138: avalue => subject
136: itemkey => wf_itemkey,
137: aname => 'NOTIFICATION_SUBJECT',
138: avalue => subject
139: );
140: wf_engine.SetItemAttrText (
141: itemtype => 'IBE_MAIL',
142: itemkey => wf_itemkey,
143: aname => 'NOTIFICATION_BODY',
144: avalue => body
142: itemkey => wf_itemkey,
143: aname => 'NOTIFICATION_BODY',
144: avalue => body
145: );
146: wf_engine.SetItemOwner (
147: itemtype => 'IBE_MAIL',
148: itemkey => wf_itemkey,
149: owner => role_name
150: );
147: itemtype => 'IBE_MAIL',
148: itemkey => wf_itemkey,
149: owner => role_name
150: );
151: wf_engine.StartProcess (
152: itemtype => 'IBE_MAIL',
153: itemkey => wf_itemkey
154: );
155:
205: email_address => email_list,
206: expiration_date => sysdate + 1
207: );
208:
209: wf_engine.CreateProcess (
210: itemtype => 'IBE_MAIL',
211: itemkey => wf_itemkey,
212: process => 'IBE_SEND_EMAIL'
213: );
210: itemtype => 'IBE_MAIL',
211: itemkey => wf_itemkey,
212: process => 'IBE_SEND_EMAIL'
213: );
214: wf_engine.SetItemUserKey (
215: itemtype => 'IBE_MAIL',
216: itemkey => wf_itemkey,
217: userkey => 'IBE Email Notification' || wf_itemkey_seq
218: );
215: itemtype => 'IBE_MAIL',
216: itemkey => wf_itemkey,
217: userkey => 'IBE Email Notification' || wf_itemkey_seq
218: );
219: wf_engine.SetItemAttrText (
220: itemtype => 'IBE_MAIL',
221: itemkey => wf_itemkey,
222: aname => 'ROLE_TO_NOTIFY',
223: avalue => role_name
221: itemkey => wf_itemkey,
222: aname => 'ROLE_TO_NOTIFY',
223: avalue => role_name
224: );
225: wf_engine.SetItemAttrText (
226: itemtype => 'IBE_MAIL',
227: itemkey => wf_itemkey,
228: aname => 'NOTIFICATION_SUBJECT',
229: avalue => subject
227: itemkey => wf_itemkey,
228: aname => 'NOTIFICATION_SUBJECT',
229: avalue => subject
230: );
231: wf_engine.SetItemAttrText (
232: itemtype => 'IBE_MAIL',
233: itemkey => wf_itemkey,
234: aname => 'NOTIFICATION_BODY',
235: avalue => body
233: itemkey => wf_itemkey,
234: aname => 'NOTIFICATION_BODY',
235: avalue => body
236: );
237: wf_engine.SetItemOwner (
238: itemtype => 'IBE_MAIL',
239: itemkey => wf_itemkey,
240: owner => role_name
241: );
238: itemtype => 'IBE_MAIL',
239: itemkey => wf_itemkey,
240: owner => role_name
241: );
242: wf_engine.StartProcess (
243: itemtype => 'IBE_MAIL',
244: itemkey => wf_itemkey
245: );
246: