APPS.IBU_SUBS_EMAIL_PKG dependencies on WF_ENGINE

Line 112: mailAttrNames Wf_Engine.NameTabTyp ;

108: arr IBU_STRING_ARRAY;
109: l_content varchar2(32766);
110:
111: --outfile UTL_FILE.FILE_TYPE;
112: mailAttrNames Wf_Engine.NameTabTyp ;
113: mailAttrVals Wf_Engine.TextTabTyp ;
114:
115: begin
116:

Line 113: mailAttrVals Wf_Engine.TextTabTyp ;

109: l_content varchar2(32766);
110:
111: --outfile UTL_FILE.FILE_TYPE;
112: mailAttrNames Wf_Engine.NameTabTyp ;
113: mailAttrVals Wf_Engine.TextTabTyp ;
114:
115: begin
116:
117: /* Get schema name */

Line 138: wf_engine.CreateProcess (itemtype => ItemType,

134: execute immediate get_seq into seq;
135:
136: ItemKey := roleName || seq;
137:
138: wf_engine.CreateProcess (itemtype => ItemType,
139: itemkey => ItemKey,
140: process => WorkflowProcess );
141: wf_engine.SetItemUserKey (itemtype => Itemtype,
142: itemkey => Itemkey,

Line 141: wf_engine.SetItemUserKey (itemtype => Itemtype,

137:
138: wf_engine.CreateProcess (itemtype => ItemType,
139: itemkey => ItemKey,
140: process => WorkflowProcess );
141: wf_engine.SetItemUserKey (itemtype => Itemtype,
142: itemkey => Itemkey,
143: userkey => ItemUserKey);
144: wf_engine.SetItemAttrText (itemtype => Itemtype,
145: itemkey => Itemkey,

Line 144: wf_engine.SetItemAttrText (itemtype => Itemtype,

140: process => WorkflowProcess );
141: wf_engine.SetItemUserKey (itemtype => Itemtype,
142: itemkey => Itemkey,
143: userkey => ItemUserKey);
144: wf_engine.SetItemAttrText (itemtype => Itemtype,
145: itemkey => Itemkey,
146: aname => 'IBU_ROLE',
147: avalue => roleName);
148: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 148: wf_engine.SetItemAttrText (itemtype => Itemtype,

144: wf_engine.SetItemAttrText (itemtype => Itemtype,
145: itemkey => Itemkey,
146: aname => 'IBU_ROLE',
147: avalue => roleName);
148: wf_engine.SetItemAttrText (itemtype => Itemtype,
149: itemkey => Itemkey,
150: aname => 'IBU_SUBJECT_ITEM',
151: avalue => subject);
152: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 152: wf_engine.SetItemAttrText (itemtype => Itemtype,

148: wf_engine.SetItemAttrText (itemtype => Itemtype,
149: itemkey => Itemkey,
150: aname => 'IBU_SUBJECT_ITEM',
151: avalue => subject);
152: wf_engine.SetItemAttrText (itemtype => Itemtype,
153: itemkey => Itemkey,
154: aname => 'IBU_USER_NAME',
155: avalue => username);
156: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 156: wf_engine.SetItemAttrText (itemtype => Itemtype,

152: wf_engine.SetItemAttrText (itemtype => Itemtype,
153: itemkey => Itemkey,
154: aname => 'IBU_USER_NAME',
155: avalue => username);
156: wf_engine.SetItemAttrText (itemtype => Itemtype,
157: itemkey => Itemkey,
158: aname => 'IBU_COMPANY_NAME',
159: avalue => companyName );
160: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 160: wf_engine.SetItemAttrText (itemtype => Itemtype,

156: wf_engine.SetItemAttrText (itemtype => Itemtype,
157: itemkey => Itemkey,
158: aname => 'IBU_COMPANY_NAME',
159: avalue => companyName );
160: wf_engine.SetItemAttrText (itemtype => Itemtype,
161: itemkey => Itemkey,
162: aname => 'IBU_COMPANY_WEB_ADDR',
163: avalue => companyWebAddr );
164: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 164: wf_engine.SetItemAttrText (itemtype => Itemtype,

160: wf_engine.SetItemAttrText (itemtype => Itemtype,
161: itemkey => Itemkey,
162: aname => 'IBU_COMPANY_WEB_ADDR',
163: avalue => companyWebAddr );
164: wf_engine.SetItemAttrText (itemtype => Itemtype,
165: itemkey => Itemkey,
166: aname => 'IBU_COMPANY_EMAIL',
167: avalue => companyEmailAddr );
168: wf_engine.SetItemAttrText (itemtype => Itemtype,

Line 168: wf_engine.SetItemAttrText (itemtype => Itemtype,

164: wf_engine.SetItemAttrText (itemtype => Itemtype,
165: itemkey => Itemkey,
166: aname => 'IBU_COMPANY_EMAIL',
167: avalue => companyEmailAddr );
168: wf_engine.SetItemAttrText (itemtype => Itemtype,
169: itemkey => Itemkey,
170: aname => 'IBU_CURRENT_DATE',
171: avalue => currentDate );
172:

Line 188: wf_engine.SetItemAttrTextArray( Itemtype,

184: end loop;
185:
186: -- UTL_FILE.FCLOSE(outfile);
187:
188: wf_engine.SetItemAttrTextArray( Itemtype,
189: Itemkey,
190: mailAttrNames,
191: mailAttrVals);
192:

Line 193: wf_engine.SetItemOwner (itemtype => Itemtype,

189: Itemkey,
190: mailAttrNames,
191: mailAttrVals);
192:
193: wf_engine.SetItemOwner (itemtype => Itemtype,
194: itemkey => Itemkey,
195: owner => roleName);
196:
197: wf_engine.StartProcess (itemtype => Itemtype,

Line 197: wf_engine.StartProcess (itemtype => Itemtype,

193: wf_engine.SetItemOwner (itemtype => Itemtype,
194: itemkey => Itemkey,
195: owner => roleName);
196:
197: wf_engine.StartProcess (itemtype => Itemtype,
198: itemkey => Itemkey );
199:
200: end StartProcess;
201:

Line 251: wf_engine.SetItemAttrText (itemtype => Itemtype,

247: IF (l_administrator IS NULL) THEN
248: l_administrator := 'SYSADMIN';
249: END IF;
250:
251: wf_engine.SetItemAttrText (itemtype => Itemtype,
252: itemkey => Itemkey,
253: aname => 'IBU_ERROR_ADMIN_ROLE',
254: avalue => l_administrator);
255: