DBA Data[Home] [Help]

APPS.IBY_EMAIL_REPORT dependencies on WF_ENGINE

Line 130: wf_engine.CreateProcess(

126: trxnSum_tbl
127: );
128:
129: -- Create the process first.
130: wf_engine.CreateProcess(
131: itemtype => c_item_type,
132: itemkey => p_item_key,
133: process => c_process
134: );

Line 136: wf_engine.SetItemUserKey(

132: itemkey => p_item_key,
133: process => c_process
134: );
135:
136: wf_engine.SetItemUserKey(
137: itemtype => c_item_type,
138: itemkey => p_item_key,
139: userkey => p_item_key
140: );

Line 142: wf_engine.SetItemAttrText(

138: itemkey => p_item_key,
139: userkey => p_item_key
140: );
141:
142: wf_engine.SetItemAttrText(
143: itemtype => c_item_type,
144: itemkey => p_item_key,
145: aname => 'TOTAL_TRXN',
146: avalue => get_str(summary_tbl(1).totalTrxn)

Line 149: wf_engine.SetItemAttrText(

145: aname => 'TOTAL_TRXN',
146: avalue => get_str(summary_tbl(1).totalTrxn)
147: );
148:
149: wf_engine.SetItemAttrText(
150: itemtype => c_item_type,
151: itemkey => p_item_key,
152: aname => 'TOTAL_TRXN_AMT',
153: avalue => get_str(summary_tbl(1).totalAmt)

Line 156: wf_engine.SetItemAttrText(

152: aname => 'TOTAL_TRXN_AMT',
153: avalue => get_str(summary_tbl(1).totalAmt)
154: );
155:
156: wf_engine.SetItemAttrText(
157: itemtype => c_item_type,
158: itemkey => p_item_key,
159: aname => 'TOTAL_AUTH',
160: avalue => get_str(summary_tbl(2).totalTrxn)

Line 163: wf_engine.SetItemAttrText(

159: aname => 'TOTAL_AUTH',
160: avalue => get_str(summary_tbl(2).totalTrxn)
161: );
162:
163: wf_engine.SetItemAttrText(
164: itemtype => c_item_type,
165: itemkey => p_item_key,
166: aname => 'TOTAL_AUTH_AMT',
167: avalue => get_str(summary_tbl(2).totalAmt)

Line 170: wf_engine.SetItemAttrText(

166: aname => 'TOTAL_AUTH_AMT',
167: avalue => get_str(summary_tbl(2).totalAmt)
168: );
169:
170: wf_engine.SetItemAttrText(
171: itemtype => c_item_type,
172: itemkey => p_item_key,
173: aname => 'TOTAL_CAPT',
174: avalue => get_str(summary_tbl(3).totalTrxn)

Line 177: wf_engine.SetItemAttrText(

173: aname => 'TOTAL_CAPT',
174: avalue => get_str(summary_tbl(3).totalTrxn)
175: );
176:
177: wf_engine.SetItemAttrText(
178: itemtype => c_item_type,
179: itemkey => p_item_key,
180: aname => 'TOTAL_CAPT_AMT',
181: avalue => get_str(summary_tbl(3).totalAmt)

Line 184: wf_engine.SetItemAttrText(

180: aname => 'TOTAL_CAPT_AMT',
181: avalue => get_str(summary_tbl(3).totalAmt)
182: );
183:
184: wf_engine.SetItemAttrText(
185: itemtype => c_item_type,
186: itemkey => p_item_key,
187: aname => 'TOTAL_RC',
188: avalue => get_str(summary_tbl(4).totalTrxn)

Line 191: wf_engine.SetItemAttrText(

187: aname => 'TOTAL_RC',
188: avalue => get_str(summary_tbl(4).totalTrxn)
189: );
190:
191: wf_engine.SetItemAttrText(
192: itemtype => c_item_type,
193: itemkey => p_item_key,
194: aname => 'TOTAL_RC_AMT',
195: avalue => get_str(summary_tbl(4).totalAmt)

Line 198: wf_engine.SetItemAttrText(

194: aname => 'TOTAL_RC_AMT',
195: avalue => get_str(summary_tbl(4).totalAmt)
196: );
197:
198: wf_engine.SetItemAttrText(
199: itemtype => c_item_type,
200: itemkey => p_item_key,
201: aname => 'TOTAL_AUTH_SET',
202: avalue => get_str(summary_tbl(5).totalTrxn)

Line 205: wf_engine.SetItemAttrText(

201: aname => 'TOTAL_AUTH_SET',
202: avalue => get_str(summary_tbl(5).totalTrxn)
203: );
204:
205: wf_engine.SetItemAttrText(
206: itemtype => c_item_type,
207: itemkey => p_item_key,
208: aname => 'TOTAL_AUTH_SET_AMT',
209: avalue => get_str(summary_tbl(5).totalAmt)

Line 212: wf_engine.SetItemAttrText(

208: aname => 'TOTAL_AUTH_SET_AMT',
209: avalue => get_str(summary_tbl(5).totalAmt)
210: );
211:
212: wf_engine.SetItemAttrText(
213: itemtype => c_item_type,
214: itemkey => p_item_key,
215: aname => 'TOTAL_AUTH_OUT',
216: avalue => get_str(summary_tbl(6).totalTrxn)

Line 219: wf_engine.SetItemAttrText(

215: aname => 'TOTAL_AUTH_OUT',
216: avalue => get_str(summary_tbl(6).totalTrxn)
217: );
218:
219: wf_engine.SetItemAttrText(
220: itemtype => c_item_type,
221: itemkey => p_item_key,
222: aname => 'TOTAL_AUTH_OUT_AMT',
223: avalue => get_str(summary_tbl(6).totalAmt)

Line 226: wf_engine.SetItemAttrText(

222: aname => 'TOTAL_AUTH_OUT_AMT',
223: avalue => get_str(summary_tbl(6).totalAmt)
224: );
225:
226: wf_engine.SetItemAttrText(
227: itemtype => c_item_type,
228: itemkey => p_item_key,
229: aname => 'TOTAL_CC_TRXN',
230: avalue => get_str(summary_tbl(7).totalTrxn)

Line 233: wf_engine.SetItemAttrText(

229: aname => 'TOTAL_CC_TRXN',
230: avalue => get_str(summary_tbl(7).totalTrxn)
231: );
232:
233: wf_engine.SetItemAttrText(
234: itemtype => c_item_type,
235: itemkey => p_item_key,
236: aname => 'TOTAL_CC_TRXN_AMT',
237: avalue => get_str(summary_tbl(7).totalAmt)

Line 240: wf_engine.SetItemAttrText(

236: aname => 'TOTAL_CC_TRXN_AMT',
237: avalue => get_str(summary_tbl(7).totalAmt)
238: );
239:
240: wf_engine.SetItemAttrText(
241: itemtype => c_item_type,
242: itemkey => p_item_key,
243: aname => 'TOTAL_PC_TRXN',
244: avalue => get_str(summary_tbl(8).totalTrxn)

Line 247: wf_engine.SetItemAttrText(

243: aname => 'TOTAL_PC_TRXN',
244: avalue => get_str(summary_tbl(8).totalTrxn)
245: );
246:
247: wf_engine.SetItemAttrText(
248: itemtype => c_item_type,
249: itemkey => p_item_key,
250: aname => 'TOTAL_PC_TRXN_AMT',
251: avalue => get_str(summary_tbl(8).totalAmt)

Line 254: wf_engine.SetItemAttrText(

250: aname => 'TOTAL_PC_TRXN_AMT',
251: avalue => get_str(summary_tbl(8).totalAmt)
252: );
253:
254: wf_engine.SetItemAttrText(
255: itemtype => c_item_type,
256: itemkey => p_item_key,
257: aname => 'SYSDATE',
258: avalue => TO_CHAR(SYSDATE, 'MON/DD/YYYY HH24:MI:SS')

Line 263: wf_engine.SetItemAttrText(

259: );
260:
261: l_login_url := FND_WEB_CONFIG.JSP_AGENT() || 'jtflogin.jsp';
262:
263: wf_engine.SetItemAttrText(
264: itemtype => c_item_type,
265: itemkey => p_item_key,
266: aname => 'LOGIN_URL',
267: avalue => l_login_url

Line 270: wf_engine.SetItemAttrText(

266: aname => 'LOGIN_URL',
267: avalue => l_login_url
268: );
269:
270: wf_engine.SetItemAttrText(
271: itemtype => c_item_type,
272: itemkey => p_item_key,
273: aname => 'RECIPIENT_USER',
274: avalue => p_user_name

Line 277: wf_engine.SetItemOwner(

273: aname => 'RECIPIENT_USER',
274: avalue => p_user_name
275: );
276:
277: wf_engine.SetItemOwner(
278: itemtype => c_item_type,
279: itemkey => p_item_key,
280: owner => 'SYSADMIN'
281: );

Line 283: wf_engine.StartProcess(

279: itemkey => p_item_key,
280: owner => 'SYSADMIN'
281: );
282:
283: wf_engine.StartProcess(
284: itemtype => c_item_type,
285: itemkey => p_item_key
286: );
287: