DBA Data[Home] [Help]

APPS.IBE_WFNOTIFICATION_PVT dependencies on WF_ENGINE

Line 28: wf_engine.CreateProcess (

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: );

Line 33: wf_engine.SetItemUserKey (

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: );

Line 38: wf_engine.SetItemAttrText (

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

Line 44: wf_engine.SetItemAttrText (

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

Line 50: wf_engine.SetItemAttrText (

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

Line 56: wf_engine.SetItemOwner (

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: );

Line 61: wf_engine.StartProcess (

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:

Line 118: wf_engine.CreateProcess (

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: );

Line 123: wf_engine.SetItemUserKey (

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: );

Line 128: wf_engine.SetItemAttrText (

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

Line 134: wf_engine.SetItemAttrText (

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

Line 140: wf_engine.SetItemAttrText (

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

Line 146: wf_engine.SetItemOwner (

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: );

Line 151: wf_engine.StartProcess (

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:

Line 209: wf_engine.CreateProcess (

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: );

Line 214: wf_engine.SetItemUserKey (

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: );

Line 219: wf_engine.SetItemAttrText (

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

Line 225: wf_engine.SetItemAttrText (

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

Line 231: wf_engine.SetItemAttrText (

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

Line 237: wf_engine.SetItemOwner (

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: );

Line 242: wf_engine.StartProcess (

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: