eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PROCESS_REQUISITION_PVT dependencies on WF_ENGINE

Line 151: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);

147:
148: l_process_name := 'ISO_CANCEL';
149:
150: -- Create the Notification flow for Header Cancellation
151: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
152: l_flow_created := TRUE;
153:
154: -- Set the resolving role for the notification.
155: WF_Engine.SetItemAttrText( l_chgord_item_type

Line 155: WF_Engine.SetItemAttrText( l_chgord_item_type

151: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
152: l_flow_created := TRUE;
153:
154: -- Set the resolving role for the notification.
155: WF_Engine.SetItemAttrText( l_chgord_item_type
156: , l_wf_item_key
157: , 'RESOLVING_ROLE'
158: , p_performer);
159:

Line 161: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

157: , 'RESOLVING_ROLE'
158: , p_performer);
159:
160: -- Set the Sales Order Number
161: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
162: , l_wf_item_key
163: , 'ORDER_NUMBER'
164: , g_sales_order_number);
165:

Line 167: WF_ENGINE.SetItemAttrText( l_chgord_item_type

163: , 'ORDER_NUMBER'
164: , g_sales_order_number);
165:
166: -- Set the Requisition Header Number
167: WF_ENGINE.SetItemAttrText( l_chgord_item_type
168: , l_wf_item_key
169: , 'REQ_HDR_NUMBER'
170: , g_requisition_number);
171:

Line 173: WF_Engine.SetItemAttrDate( l_chgord_item_type

169: , 'REQ_HDR_NUMBER'
170: , g_requisition_number);
171:
172: -- Set the Sales Order Cancellation Date
173: WF_Engine.SetItemAttrDate( l_chgord_item_type
174: , l_wf_item_key
175: , 'ORDER_CANCEL_DATE'
176: , g_order_cancellation_date);
177:

Line 179: WF_Engine.SetItemAttrText( l_chgord_item_type

175: , 'ORDER_CANCEL_DATE'
176: , g_order_cancellation_date);
177:
178: /* -- Set the Sales Order cancellation Reason
179: WF_Engine.SetItemAttrText( l_chgord_item_type
180: , l_wf_item_key
181: , 'REASON'
182: , g_reason);
183: */

Line 192: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);

188:
189: l_process_name := 'ISO_QTY_UPDATE';
190:
191: -- Create the Notification flow for Line Quantity update
192: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
193: l_flow_created := TRUE;
194:
195: -- Set the resolving role for the notification.
196: WF_Engine.SetItemAttrText( l_chgord_item_type

Line 196: WF_Engine.SetItemAttrText( l_chgord_item_type

192: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
193: l_flow_created := TRUE;
194:
195: -- Set the resolving role for the notification.
196: WF_Engine.SetItemAttrText( l_chgord_item_type
197: , l_wf_item_key
198: , 'RESOLVING_ROLE'
199: , p_performer);
200:

Line 202: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

198: , 'RESOLVING_ROLE'
199: , p_performer);
200:
201: -- Set the Sales Order Number
202: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
203: , l_wf_item_key
204: , 'ORDER_NUMBER'
205: , g_sales_order_number);
206:

Line 208: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

204: , 'ORDER_NUMBER'
205: , g_sales_order_number);
206:
207: -- Set the Sales Line Number
208: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
209: , l_wf_item_key
210: , 'LINE_NUMBER'
211: , g_sales_ord_line_num);
212:

Line 214: WF_ENGINE.SetItemAttrText( l_chgord_item_type

210: , 'LINE_NUMBER'
211: , g_sales_ord_line_num);
212:
213: -- Set the Requisition Header Number
214: WF_ENGINE.SetItemAttrText( l_chgord_item_type
215: , l_wf_item_key
216: , 'REQ_HDR_NUMBER'
217: , g_requisition_number);
218:

Line 220: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

216: , 'REQ_HDR_NUMBER'
217: , g_requisition_number);
218:
219: -- Set the Requisition Line Number
220: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
221: , l_wf_item_key
222: , 'REQ_LINE_NUMBER'
223: , g_requisition_line_number);
224:

Line 226: WF_Engine.SetItemAttrText( l_chgord_item_type

222: , 'REQ_LINE_NUMBER'
223: , g_requisition_line_number);
224:
225: -- Set the Sales Order Line Inventory Item Name
226: WF_Engine.SetItemAttrText( l_chgord_item_type
227: , l_wf_item_key
228: , 'INVENTORY_ITEM'
229: , g_inventory_item_name);
230:

Line 232: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

228: , 'INVENTORY_ITEM'
229: , g_inventory_item_name);
230:
231: -- Set the Requisition Line Requested Quantity
232: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
233: , l_wf_item_key
234: , 'REQUESTED_QTY'
235: , g_requested_quantity);
236:

Line 238: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

234: , 'REQUESTED_QTY'
235: , g_requested_quantity);
236:
237: -- Set the Sales Order Line updated Quantity
238: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
239: , l_wf_item_key
240: , 'UPDATED_QTY'
241: , g_updated_quantity);
242:

Line 244: WF_Engine.SetItemAttrDate( l_chgord_item_type

240: , 'UPDATED_QTY'
241: , g_updated_quantity);
242:
243: -- Set the Sales Order Line update Date
244: WF_Engine.SetItemAttrDate( l_chgord_item_type
245: , l_wf_item_key
246: , 'LINE_UPDATE_DATE'
247: , g_line_updated_date);
248:

Line 251: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

247: , g_line_updated_date);
248:
249: --Bug 14211120 Start
250: -- Set the Requisition Line Secondary Requested Quantity
251: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
252: , l_wf_item_key
253: , 'REQUESTED_QTY2'
254: , g_requested_quantity2);
255:

Line 257: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

253: , 'REQUESTED_QTY2'
254: , g_requested_quantity2);
255:
256: -- Set the Sales Order Line Secondary updated Quantity
257: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
258: , l_wf_item_key
259: , 'UPDATED_QTY2'
260: , g_updated_quantity2);
261: --Bug 14211120 End

Line 264: WF_Engine.SetItemAttrText( l_chgord_item_type

260: , g_updated_quantity2);
261: --Bug 14211120 End
262:
263: /* -- Set the Sales Order cancellation Reason
264: WF_Engine.SetItemAttrText( l_chgord_item_type
265: , l_wf_item_key
266: , 'REASON'
267: , g_reason);
268: */

Line 277: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);

273:
274: l_process_name := 'ISO_SCH_DATE_UPDATE';
275:
276: -- Create the Notification flow for Line Schedule Ship Date update
277: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
278: l_flow_created := TRUE;
279:
280: -- Set the resolving role for the notification.
281: WF_Engine.SetItemAttrText( l_chgord_item_type

Line 281: WF_Engine.SetItemAttrText( l_chgord_item_type

277: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
278: l_flow_created := TRUE;
279:
280: -- Set the resolving role for the notification.
281: WF_Engine.SetItemAttrText( l_chgord_item_type
282: , l_wf_item_key
283: , 'RESOLVING_ROLE'
284: , p_performer);
285:

Line 287: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

283: , 'RESOLVING_ROLE'
284: , p_performer);
285:
286: -- Set the Sales Order Number
287: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
288: , l_wf_item_key
289: , 'ORDER_NUMBER'
290: , g_sales_order_number);
291:

Line 293: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

289: , 'ORDER_NUMBER'
290: , g_sales_order_number);
291:
292: -- Set the Sales Line Number
293: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
294: , l_wf_item_key
295: , 'LINE_NUMBER'
296: , g_sales_ord_line_num);
297:

Line 299: WF_ENGINE.SetItemAttrText( l_chgord_item_type

295: , 'LINE_NUMBER'
296: , g_sales_ord_line_num);
297:
298: -- Set the Requisition Header Number
299: WF_ENGINE.SetItemAttrText( l_chgord_item_type
300: , l_wf_item_key
301: , 'REQ_HDR_NUMBER'
302: , g_requisition_number);
303:

Line 305: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

301: , 'REQ_HDR_NUMBER'
302: , g_requisition_number);
303:
304: -- Set the Requisition Line Number
305: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
306: , l_wf_item_key
307: , 'REQ_LINE_NUMBER'
308: , g_requisition_line_number);
309:

Line 311: WF_Engine.SetItemAttrText( l_chgord_item_type

307: , 'REQ_LINE_NUMBER'
308: , g_requisition_line_number);
309:
310: -- Set the Sales Order Line Inventory Item Name
311: WF_Engine.SetItemAttrText( l_chgord_item_type
312: , l_wf_item_key
313: , 'INVENTORY_ITEM'
314: , g_inventory_item_name);
315:

Line 317: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

313: , 'INVENTORY_ITEM'
314: , g_inventory_item_name);
315:
316: -- Set the Requisition Line Requested Quantity
317: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
318: , l_wf_item_key
319: , 'REQUESTED_QTY'
320: , g_requested_quantity);
321:

Line 323: WF_Engine.SetItemAttrDate( l_chgord_item_type

319: , 'REQUESTED_QTY'
320: , g_requested_quantity);
321:
322: -- Set the Requisition Line Need By Date
323: WF_Engine.SetItemAttrDate( l_chgord_item_type
324: , l_wf_item_key
325: , 'REQ_LIN_NEED_BY_DATE'
326: , g_need_by_date);
327:

Line 329: WF_Engine.SetItemAttrDate( l_chgord_item_type

325: , 'REQ_LIN_NEED_BY_DATE'
326: , g_need_by_date);
327:
328: -- Set the Sales Order Line Schedule Ship Date
329: WF_Engine.SetItemAttrDate( l_chgord_item_type
330: , l_wf_item_key
331: , 'LINE_SCH_ARRIVAL_DATE'
332: , g_schedule_arrival_date);
333:

Line 335: WF_Engine.SetItemAttrDate( l_chgord_item_type

331: , 'LINE_SCH_ARRIVAL_DATE'
332: , g_schedule_arrival_date);
333:
334: -- Set the Sales Order Line update Date
335: WF_Engine.SetItemAttrDate( l_chgord_item_type
336: , l_wf_item_key
337: , 'LINE_UPDATE_DATE'
338: , g_line_updated_date);
339:

Line 341: WF_Engine.SetItemAttrText( l_chgord_item_type

337: , 'LINE_UPDATE_DATE'
338: , g_line_updated_date);
339:
340: /* -- Set the Sales Order cancellation Reason
341: WF_Engine.SetItemAttrText( l_chgord_item_type
342: , l_wf_item_key
343: , 'REASON'
344: , g_reason);
345: */

Line 354: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);

350:
351: l_process_name := 'ISO_QTY_SCH_DATE_UPDATE';
352:
353: -- Create the Notification flow for Line Quantity and Schedule Ship Date update
354: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
355: l_flow_created := TRUE;
356:
357: -- Set the resolving role for the notification.
358: WF_Engine.SetItemAttrText( l_chgord_item_type

Line 358: WF_Engine.SetItemAttrText( l_chgord_item_type

354: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
355: l_flow_created := TRUE;
356:
357: -- Set the resolving role for the notification.
358: WF_Engine.SetItemAttrText( l_chgord_item_type
359: , l_wf_item_key
360: , 'RESOLVING_ROLE'
361: , p_performer);
362:

Line 364: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

360: , 'RESOLVING_ROLE'
361: , p_performer);
362:
363: -- Set the Sales Order Number
364: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
365: , l_wf_item_key
366: , 'ORDER_NUMBER'
367: , g_sales_order_number);
368:

Line 370: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

366: , 'ORDER_NUMBER'
367: , g_sales_order_number);
368:
369: -- Set the Sales Line Number
370: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
371: , l_wf_item_key
372: , 'LINE_NUMBER'
373: , g_sales_ord_line_num);
374:

Line 376: WF_ENGINE.SetItemAttrText( l_chgord_item_type

372: , 'LINE_NUMBER'
373: , g_sales_ord_line_num);
374:
375: -- Set the Requisition Header Number
376: WF_ENGINE.SetItemAttrText( l_chgord_item_type
377: , l_wf_item_key
378: , 'REQ_HDR_NUMBER'
379: , g_requisition_number);
380:

Line 382: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

378: , 'REQ_HDR_NUMBER'
379: , g_requisition_number);
380:
381: -- Set the Requisition Line Number
382: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
383: , l_wf_item_key
384: , 'REQ_LINE_NUMBER'
385: , g_requisition_line_number);
386:

Line 388: WF_Engine.SetItemAttrText( l_chgord_item_type

384: , 'REQ_LINE_NUMBER'
385: , g_requisition_line_number);
386:
387: -- Set the Sales Order Line Inventory Item Name
388: WF_Engine.SetItemAttrText( l_chgord_item_type
389: , l_wf_item_key
390: , 'INVENTORY_ITEM'
391: , g_inventory_item_name);
392:

Line 394: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

390: , 'INVENTORY_ITEM'
391: , g_inventory_item_name);
392:
393: -- Set the Requisition Line Requested Quantity
394: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
395: , l_wf_item_key
396: , 'REQUESTED_QTY'
397: , g_requested_quantity);
398:

Line 400: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

396: , 'REQUESTED_QTY'
397: , g_requested_quantity);
398:
399: -- Set the Sales Order Line updated Quantity
400: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
401: , l_wf_item_key
402: , 'UPDATED_QTY'
403: , g_updated_quantity);
404:

Line 406: WF_Engine.SetItemAttrDate( l_chgord_item_type

402: , 'UPDATED_QTY'
403: , g_updated_quantity);
404:
405: -- Set the Requisition Line Need By Date
406: WF_Engine.SetItemAttrDate( l_chgord_item_type
407: , l_wf_item_key
408: , 'REQ_LIN_NEED_BY_DATE'
409: , g_need_by_date);
410:

Line 412: WF_Engine.SetItemAttrDate( l_chgord_item_type

408: , 'REQ_LIN_NEED_BY_DATE'
409: , g_need_by_date);
410:
411: -- Set the Sales Order Line Schedule Ship Date
412: WF_Engine.SetItemAttrDate( l_chgord_item_type
413: , l_wf_item_key
414: , 'LINE_SCH_ARRIVAL_DATE'
415: , g_schedule_arrival_date);
416:

Line 418: WF_Engine.SetItemAttrDate( l_chgord_item_type

414: , 'LINE_SCH_ARRIVAL_DATE'
415: , g_schedule_arrival_date);
416:
417: -- Set the Sales Order Line update Date
418: WF_Engine.SetItemAttrDate( l_chgord_item_type
419: , l_wf_item_key
420: , 'LINE_UPDATE_DATE'
421: , g_line_updated_date);
422:

Line 425: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

421: , g_line_updated_date);
422:
423: --Bug 14211120 Start
424: -- Set the Requisition Line Secondary Requested Quantity
425: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
426: , l_wf_item_key
427: , 'REQUESTED_QTY2'
428: , g_requested_quantity2);
429:

Line 431: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

427: , 'REQUESTED_QTY2'
428: , g_requested_quantity2);
429:
430: -- Set the Sales Order Line Secondary updated Quantity
431: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
432: , l_wf_item_key
433: , 'UPDATED_QTY2'
434: , g_updated_quantity2);
435: --Bug 14211120 End

Line 438: WF_Engine.SetItemAttrText( l_chgord_item_type

434: , g_updated_quantity2);
435: --Bug 14211120 End
436:
437: /* -- Set the Sales Order cancellation Reason
438: WF_Engine.SetItemAttrText( l_chgord_item_type
439: , l_wf_item_key
440: , 'REASON'
441: , g_reason);
442: */

Line 451: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);

447:
448: l_process_name := 'ISO_LINE_CANCEL';
449:
450: -- Create the Notification flow for Line Cancellation
451: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
452: l_flow_created := TRUE;
453:
454: -- Set the resolving role for the notification.
455: WF_Engine.SetItemAttrText( l_chgord_item_type

Line 455: WF_Engine.SetItemAttrText( l_chgord_item_type

451: WF_ENGINE.CreateProcess(l_chgord_item_type, l_wf_item_key, l_process_name);
452: l_flow_created := TRUE;
453:
454: -- Set the resolving role for the notification.
455: WF_Engine.SetItemAttrText( l_chgord_item_type
456: , l_wf_item_key
457: , 'RESOLVING_ROLE'
458: , p_performer);
459:

Line 461: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

457: , 'RESOLVING_ROLE'
458: , p_performer);
459:
460: -- Set the Sales Order Number
461: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
462: , l_wf_item_key
463: , 'ORDER_NUMBER'
464: , g_sales_order_number);
465:

Line 467: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

463: , 'ORDER_NUMBER'
464: , g_sales_order_number);
465:
466: -- Set the Sales Line Number
467: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
468: , l_wf_item_key
469: , 'LINE_NUMBER'
470: , g_sales_ord_line_num);
471:

Line 473: WF_ENGINE.SetItemAttrText( l_chgord_item_type

469: , 'LINE_NUMBER'
470: , g_sales_ord_line_num);
471:
472: -- Set the Requisition Header Number
473: WF_ENGINE.SetItemAttrText( l_chgord_item_type
474: , l_wf_item_key
475: , 'REQ_HDR_NUMBER'
476: , g_requisition_number);
477:

Line 479: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

475: , 'REQ_HDR_NUMBER'
476: , g_requisition_number);
477:
478: -- Set the Requisition Line Number
479: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
480: , l_wf_item_key
481: , 'REQ_LINE_NUMBER'
482: , g_requisition_line_number);
483:

Line 485: WF_Engine.SetItemAttrText( l_chgord_item_type

481: , 'REQ_LINE_NUMBER'
482: , g_requisition_line_number);
483:
484: -- Set the Sales Order Line Inventory Item Name
485: WF_Engine.SetItemAttrText( l_chgord_item_type
486: , l_wf_item_key
487: , 'INVENTORY_ITEM'
488: , g_inventory_item_name);
489:

Line 491: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

487: , 'INVENTORY_ITEM'
488: , g_inventory_item_name);
489:
490: -- Set the Requisition Line Requested Quantity
491: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
492: , l_wf_item_key
493: , 'REQUESTED_QTY'
494: , g_requested_quantity);
495:

Line 497: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type

493: , 'REQUESTED_QTY'
494: , g_requested_quantity);
495:
496: -- Set the Sales Order Line Cancelled Quantity
497: WF_ENGINE.SetItemAttrNumber( l_chgord_item_type
498: , l_wf_item_key
499: , 'CANCELLED_QTY'
500: , g_ISO_cancelled_quantity);
501:

Line 503: WF_Engine.SetItemAttrDate( l_chgord_item_type

499: , 'CANCELLED_QTY'
500: , g_ISO_cancelled_quantity);
501:
502: -- Set the Sales Order Line Cancel Date
503: WF_Engine.SetItemAttrDate( l_chgord_item_type
504: , l_wf_item_key
505: , 'LINE_CANCEL_DATE'
506: , g_line_cancellation_date);
507:

Line 509: WF_Engine.SetItemAttrText( l_chgord_item_type

505: , 'LINE_CANCEL_DATE'
506: , g_line_cancellation_date);
507:
508: /* -- Set the Sales Order cancellation Reason
509: WF_Engine.SetItemAttrText( l_chgord_item_type
510: , l_wf_item_key
511: , 'REASON'
512: , g_reason);
513: */

Line 532: WF_ENGINE.SetItemAttrText( l_chgord_item_type

528: l_user_name := null; -- do not set FROM_ROLE then
529: END;
530:
531: IF (l_user_name is not NULL) THEN
532: WF_ENGINE.SetItemAttrText( l_chgord_item_type
533: , l_wf_item_key
534: , 'NOTIFICATION_FROM_ROLE'
535: , l_user_name);
536: END IF;

Line 538: WF_ENGINE.StartProcess(l_chgord_item_type, l_wf_item_key);

534: , 'NOTIFICATION_FROM_ROLE'
535: , l_user_name);
536: END IF;
537:
538: WF_ENGINE.StartProcess(l_chgord_item_type, l_wf_item_key);
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add(' Workflow process is successfully started',5);
541: END IF;
542: END IF;