37: email_address => email_list,
38: expiration_date => sysdate + 1
39: );
40:
41: wf_engine.CreateProcess (
42: itemtype => 'JTF_MAIL',
43: itemkey => wf_itemkey,
44: process => 'JTF_SEND_MAIL'
45: );
42: itemtype => 'JTF_MAIL',
43: itemkey => wf_itemkey,
44: process => 'JTF_SEND_MAIL'
45: );
46: wf_engine.SetItemUserKey (
47: itemtype => 'JTF_MAIL',
48: itemkey => wf_itemkey,
49: userkey => 'JTF Email Notification' || wf_itemkey_seq
50: );
47: itemtype => 'JTF_MAIL',
48: itemkey => wf_itemkey,
49: userkey => 'JTF Email Notification' || wf_itemkey_seq
50: );
51: wf_engine.SetItemAttrText (
52: itemtype => 'JTF_MAIL',
53: itemkey => wf_itemkey,
54: aname => 'ROLE_TO_NOTIFY',
55: avalue => role_name
53: itemkey => wf_itemkey,
54: aname => 'ROLE_TO_NOTIFY',
55: avalue => role_name
56: );
57: wf_engine.SetItemAttrText (
58: itemtype => 'JTF_MAIL',
59: itemkey => wf_itemkey,
60: aname => 'NOTIFICATION_SUBJECT',
61: avalue => subject
59: itemkey => wf_itemkey,
60: aname => 'NOTIFICATION_SUBJECT',
61: avalue => subject
62: );
63: wf_engine.SetItemAttrText (
64: itemtype => 'JTF_MAIL',
65: itemkey => wf_itemkey,
66: aname => 'NOTIFICATION_BODY',
67: avalue => body
65: itemkey => wf_itemkey,
66: aname => 'NOTIFICATION_BODY',
67: avalue => body
68: );
69: wf_engine.SetItemOwner (
70: itemtype => 'JTF_MAIL',
71: itemkey => wf_itemkey,
72: owner => role_name
73: );
70: itemtype => 'JTF_MAIL',
71: itemkey => wf_itemkey,
72: owner => role_name
73: );
74: wf_engine.StartProcess (
75: itemtype => 'JTF_MAIL',
76: itemkey => wf_itemkey
77: );
78: