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.MSC_WF_ALLOC_ATP dependencies on WF_ENGINE

Line 69: wf_engine.CreateProcess(

65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: msc_sch_wb.atp_debug('debug_wf: ' || 'CreateProcess' );
68: END IF;
69: wf_engine.CreateProcess(
70: itemtype => l_itemtype,
71: itemkey => l_itemkey,
72: process => l_process);
73:

Line 80: wf_engine.SetItemAttrNumber(

76: IF PG_DEBUG in ('Y', 'C') THEN
77: msc_sch_wb.atp_debug('debug_wf: ' || 'Setting Param' );
78: END IF;
79:
80: wf_engine.SetItemAttrNumber(
81: itemtype => l_itemtype,
82: itemkey => l_itemkey,
83: aname => 'SESSION_ID',
84: avalue => p_session_id);

Line 90: wf_engine.SetItemAttrText(

86: IF PG_DEBUG in ('Y', 'C') THEN
87: msc_sch_wb.atp_debug('debug_wf: p_session_id ' || p_session_id );
88: END IF;
89:
90: wf_engine.SetItemAttrText(
91: itemtype => l_itemtype,
92: itemkey => l_itemkey,
93: aname => 'DEBUG_LOC_SRC',
94: avalue => DEBUG_LOC_SRC);

Line 100: wf_engine.SetItemAttrNumber(

96: IF PG_DEBUG in ('Y', 'C') THEN
97: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_SRC ' || DEBUG_LOC_SRC );
98: END IF;
99:
100: wf_engine.SetItemAttrNumber(
101: itemtype => l_itemtype,
102: itemkey => l_itemkey,
103: aname => 'SPID_SRC',
104: avalue => SPID_SRC);

Line 110: wf_engine.SetItemAttrText(

106: IF PG_DEBUG in ('Y', 'C') THEN
107: msc_sch_wb.atp_debug('debug_wf: SPID_SRC ' || SPID_SRC );
108: END IF;
109:
110: wf_engine.SetItemAttrText(
111: itemtype => l_itemtype,
112: itemkey => l_itemkey,
113: aname => 'TRACE_LOC_SRC',
114: avalue => TRACE_LOC_SRC);

Line 120: wf_engine.SetItemAttrText(

116: IF PG_DEBUG in ('Y', 'C') THEN
117: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_SRC ' || TRACE_LOC_SRC );
118: END IF;
119:
120: wf_engine.SetItemAttrText(
121: itemtype => l_itemtype,
122: itemkey => l_itemkey,
123: aname => 'DEBUG_LOC_DES',
124: avalue => p_session_loc_des);

Line 130: wf_engine.SetItemAttrNumber(

126: IF PG_DEBUG in ('Y', 'C') THEN
127: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_DES ' || p_session_loc_des );
128: END IF;
129:
130: wf_engine.SetItemAttrNumber(
131: itemtype => l_itemtype,
132: itemkey => l_itemkey,
133: aname => 'SPID_DES',
134: avalue => p_spid_des);

Line 140: wf_engine.SetItemAttrText(

136: IF PG_DEBUG in ('Y', 'C') THEN
137: msc_sch_wb.atp_debug('debug_wf: SPID_DES ' || p_spid_des );
138: END IF;
139:
140: wf_engine.SetItemAttrText(
141: itemtype => l_itemtype,
142: itemkey => l_itemkey,
143: aname => 'TRACE_LOC_DES',
144: avalue => p_trace_loc_des);

Line 150: wf_engine.SetItemAttrText(

146: IF PG_DEBUG in ('Y', 'C') THEN
147: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_DES ' || p_trace_loc_des );
148: END IF;
149:
150: wf_engine.SetItemAttrText(
151: itemtype => l_itemtype,
152: itemkey => l_itemkey,
153: aname => 'LOGIN_USER',
154: avalue => p_login_user);

Line 164: wf_engine.StartProcess(

160: IF PG_DEBUG in ('Y', 'C') THEN
161: msc_sch_wb.atp_debug('debug_wf: ' || 'starting process' );
162: END IF;
163:
164: wf_engine.StartProcess(
165: itemtype => l_itemtype,
166: itemkey => l_itemkey);
167:
168: IF PG_DEBUG in ('Y', 'C') THEN

Line 236: wf_engine.CreateProcess(

232: END IF;
233: RETURN;
234: END IF;
235:
236: wf_engine.CreateProcess(
237: itemtype => l_itemtype,
238: itemkey => p_itemkey,
239: process => 'ALLOCATEDATPNOTIFY');
240:

Line 246: wf_engine.SetItemAttrNumber(

242: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || p_itemkey);
243: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
244: END IF;
245:
246: wf_engine.SetItemAttrNumber(
247: itemtype => l_itemtype,
248: itemkey => p_itemkey,
249: aname => 'INVENTORY_ITEM_ID',
250: avalue => p_inventory_item_id);

Line 252: wf_engine.SetItemAttrText(

248: itemkey => p_itemkey,
249: aname => 'INVENTORY_ITEM_ID',
250: avalue => p_inventory_item_id);
251:
252: wf_engine.SetItemAttrText(
253: itemtype => l_itemtype,
254: itemkey => p_itemkey,
255: aname => 'INVENTORY_ITEM_NAME',
256: avalue => p_inventory_item_name);

Line 258: wf_engine.SetItemAttrNumber(

254: itemkey => p_itemkey,
255: aname => 'INVENTORY_ITEM_NAME',
256: avalue => p_inventory_item_name);
257:
258: wf_engine.SetItemAttrNumber(
259: itemtype => l_itemtype,
260: itemkey => p_itemkey,
261: aname => 'PLAN_ID',
262: avalue => p_plan_id);

Line 264: wf_engine.SetItemAttrNumber(

260: itemkey => p_itemkey,
261: aname => 'PLAN_ID',
262: avalue => p_plan_id);
263:
264: wf_engine.SetItemAttrNumber(
265: itemtype => l_itemtype,
266: itemkey => p_itemkey,
267: aname => 'ORGANIZATION_ID',
268: avalue => p_organization_id);

Line 270: wf_engine.SetItemAttrText(

266: itemkey => p_itemkey,
267: aname => 'ORGANIZATION_ID',
268: avalue => p_organization_id);
269:
270: wf_engine.SetItemAttrText(
271: itemtype => l_itemtype,
272: itemkey => p_itemkey,
273: aname => 'ORGANIZATION_CODE',
274: avalue => p_organization_code);

Line 276: wf_engine.SetItemAttrNumber(

272: itemkey => p_itemkey,
273: aname => 'ORGANIZATION_CODE',
274: avalue => p_organization_code);
275:
276: wf_engine.SetItemAttrNumber(
277: itemtype => l_itemtype,
278: itemkey => p_itemkey,
279: aname => 'INSTANCE_ID',
280: avalue => p_instance_id);

Line 282: wf_engine.SetItemAttrText(

278: itemkey => p_itemkey,
279: aname => 'INSTANCE_ID',
280: avalue => p_instance_id);
281:
282: wf_engine.SetItemAttrText(
283: itemtype => l_itemtype,
284: itemkey => p_itemkey,
285: aname => 'DEMAND_CLASS',
286: avalue => p_demand_class);

Line 288: wf_engine.SetItemAttrNumber(

284: itemkey => p_itemkey,
285: aname => 'DEMAND_CLASS',
286: avalue => p_demand_class);
287:
288: wf_engine.SetItemAttrNumber(
289: itemtype => l_itemtype,
290: itemkey => p_itemkey,
291: aname => 'REQUESTED_QTY',
292: avalue => p_requested_qty);

Line 294: wf_engine.SetItemAttrDate(

290: itemkey => p_itemkey,
291: aname => 'REQUESTED_QTY',
292: avalue => p_requested_qty);
293:
294: wf_engine.SetItemAttrDate(
295: itemtype => l_itemtype,
296: itemkey => p_itemkey,
297: aname => 'REQUESTED_DATE',
298: avalue => p_request_date);

Line 300: wf_engine.SetItemAttrNumber(

296: itemkey => p_itemkey,
297: aname => 'REQUESTED_DATE',
298: avalue => p_request_date);
299:
300: wf_engine.SetItemAttrNumber(
301: itemtype => l_itemtype,
302: itemkey => p_itemkey,
303: aname => 'REQUEST_DATE_QTY',
304: avalue => p_request_date_qty);

Line 306: wf_engine.SetItemAttrNumber(

302: itemkey => p_itemkey,
303: aname => 'REQUEST_DATE_QTY',
304: avalue => p_request_date_qty);
305:
306: wf_engine.SetItemAttrNumber(
307: itemtype => l_itemtype,
308: itemkey => p_itemkey,
309: aname => 'AVAILABLE_QTY',
310: avalue => p_available_qty);

Line 312: wf_engine.SetItemAttrDate(

308: itemkey => p_itemkey,
309: aname => 'AVAILABLE_QTY',
310: avalue => p_available_qty);
311:
312: wf_engine.SetItemAttrDate(
313: itemtype => l_itemtype,
314: itemkey => p_itemkey,
315: aname => 'AVAILABLE_DATE',
316: avalue => p_available_date);

Line 318: wf_engine.SetItemAttrNumber(

314: itemkey => p_itemkey,
315: aname => 'AVAILABLE_DATE',
316: avalue => p_available_date);
317:
318: wf_engine.SetItemAttrNumber(
319: itemtype => l_itemtype,
320: itemkey => p_itemkey,
321: aname => 'STOLEN_QTY',
322: avalue => p_stolen_qty);

Line 324: wf_engine.SetItemAttrNumber(

320: itemkey => p_itemkey,
321: aname => 'STOLEN_QTY',
322: avalue => p_stolen_qty);
323:
324: wf_engine.SetItemAttrNumber(
325: itemtype => l_itemtype,
326: itemkey => p_itemkey,
327: aname => 'ALLOCATED_QTY',
328: avalue => LEAST(p_requested_qty, NVL(p_request_date_qty,0)) -

Line 350: wf_engine.SetItemAttrText(

346: AND tpslid.partner_type = 2
347: AND tp.partner_id = tplid.tp_id
348: AND tps.partner_site_id = tpslid.tp_site_id ;
349:
350: wf_engine.SetItemAttrText(
351: itemtype => l_itemtype,
352: itemkey => p_itemkey,
353: aname => 'CUST_CLASS',
354: avalue => l_customer_class);

Line 356: wf_engine.SetItemAttrText(

352: itemkey => p_itemkey,
353: aname => 'CUST_CLASS',
354: avalue => l_customer_class);
355:
356: wf_engine.SetItemAttrText(
357: itemtype => l_itemtype,
358: itemkey => p_itemkey,
359: aname => 'CUSTOMER',
360: avalue => l_customer);

Line 362: wf_engine.SetItemAttrText(

358: itemkey => p_itemkey,
359: aname => 'CUSTOMER',
360: avalue => l_customer);
361:
362: wf_engine.SetItemAttrText(
363: itemtype => l_itemtype,
364: itemkey => p_itemkey,
365: aname => 'CUST_LOCATION',
366: avalue => l_location);

Line 368: wf_engine.SetItemAttrText(

364: itemkey => p_itemkey,
365: aname => 'CUST_LOCATION',
366: avalue => l_location);
367:
368: wf_engine.SetItemAttrText(
369: itemtype => l_itemtype,
370: itemkey => p_itemkey,
371: aname => 'CUST_ADDRESS',
372: avalue => l_address);

Line 374: wf_engine.SetItemAttrNumber(

370: itemkey => p_itemkey,
371: aname => 'CUST_ADDRESS',
372: avalue => l_address);
373:
374: wf_engine.SetItemAttrNumber(
375: itemtype => l_itemtype,
376: itemkey => p_itemkey,
377: aname => 'ORDER_NUMBER',
378: avalue => p_order_number);

Line 386: wf_engine.SetItemAttrText(

382: p_organization_id, p_instance_id);
383: FETCH PLANNER_C INTO l_username, l_plan_name;
384: CLOSE PLANNER_C;
385:
386: wf_engine.SetItemAttrText(
387: itemtype => l_itemtype,
388: itemkey => p_itemkey,
389: aname => 'PLAN_NAME',
390: avalue => l_plan_name);

Line 392: wf_engine.SetItemAttrText(

388: itemkey => p_itemkey,
389: aname => 'PLAN_NAME',
390: avalue => l_plan_name);
391:
392: wf_engine.SetItemAttrText(
393: itemtype => l_itemtype,
394: itemkey => p_itemkey,
395: aname => 'USERNAME',
396: avalue => l_username);

Line 398: wf_engine.StartProcess(

394: itemkey => p_itemkey,
395: aname => 'USERNAME',
396: avalue => l_username);
397:
398: wf_engine.StartProcess(
399: itemtype => l_itemtype,
400: itemkey => p_itemkey);
401: END start_mscalloc_wf;
402:

Line 415: l_allocated_qty := wf_engine.GetItemAttrNumber(

411: l_allocated_qty NUMBER;
412: l_requested_qty NUMBER;
413: BEGIN
414:
415: l_allocated_qty := wf_engine.GetItemAttrNumber(
416: itemtype => itemtype,
417: itemkey => itemkey,
418: aname => 'ALLOCATED_QTY');
419:

Line 420: l_requested_qty := wf_engine.GetItemAttrNumber(

416: itemtype => itemtype,
417: itemkey => itemkey,
418: aname => 'ALLOCATED_QTY');
419:
420: l_requested_qty := wf_engine.GetItemAttrNumber(
421: itemtype => itemtype,
422: itemkey => itemkey,
423: aname => 'REQUESTED_QTY');
424:

Line 449: l_stolen_qty := wf_engine.GetItemAttrNumber(

445: IS
446: l_stolen_qty NUMBER;
447: BEGIN
448:
449: l_stolen_qty := wf_engine.GetItemAttrNumber(
450: itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'STOLEN_QTY');
453:

Line 478: l_request_date_qty := wf_engine.GetItemAttrNumber(

474: l_request_date_qty NUMBER;
475: l_requested_qty NUMBER;
476: BEGIN
477:
478: l_request_date_qty := wf_engine.GetItemAttrNumber(
479: itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'REQUEST_DATE_QTY');
482:

Line 483: l_requested_qty := wf_engine.GetItemAttrNumber(

479: itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'REQUEST_DATE_QTY');
482:
483: l_requested_qty := wf_engine.GetItemAttrNumber(
484: itemtype => itemtype,
485: itemkey => itemkey,
486: aname => 'REQUESTED_QTY');
487:

Line 562: wf_engine.CreateProcess(

558: END IF;
559: RETURN;
560: END IF;
561:
562: wf_engine.CreateProcess(
563: itemtype => l_itemtype,
564: itemkey => p_itemkey,
565: process => 'ATP_OVERRIDE_NOTIFY');
566:

Line 572: wf_engine.SetItemAttrText(

568: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || p_itemkey);
569: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
570: END IF;
571:
572: wf_engine.SetItemAttrText(
573: itemtype => l_itemtype,
574: itemkey => p_itemkey,
575: aname => 'INVENTORY_ITEM_NAME',
576: avalue => p_inventory_item_name);

Line 578: wf_engine.SetItemAttrText(

574: itemkey => p_itemkey,
575: aname => 'INVENTORY_ITEM_NAME',
576: avalue => p_inventory_item_name);
577:
578: wf_engine.SetItemAttrText(
579: itemtype => l_itemtype,
580: itemkey => p_itemkey,
581: aname => 'ORGANIZATION_CODE',
582: avalue => p_organization_code);

Line 584: wf_engine.SetItemAttrText(

580: itemkey => p_itemkey,
581: aname => 'ORGANIZATION_CODE',
582: avalue => p_organization_code);
583:
584: wf_engine.SetItemAttrText(
585: itemtype => l_itemtype,
586: itemkey => p_itemkey,
587: aname => 'DEMAND_CLASS',
588: avalue => p_demand_class);

Line 590: wf_engine.SetItemAttrNumber(

586: itemkey => p_itemkey,
587: aname => 'DEMAND_CLASS',
588: avalue => p_demand_class);
589:
590: wf_engine.SetItemAttrNumber(
591: itemtype => l_itemtype,
592: itemkey => p_itemkey,
593: aname => 'REQUESTED_QTY',
594: avalue => p_requested_qty);

Line 596: wf_engine.SetItemAttrDate(

592: itemkey => p_itemkey,
593: aname => 'REQUESTED_QTY',
594: avalue => p_requested_qty);
595:
596: wf_engine.SetItemAttrDate(
597: itemtype => l_itemtype,
598: itemkey => p_itemkey,
599: aname => 'REQUESTED_DATE',
600: avalue => p_request_date);

Line 602: wf_engine.SetItemAttrNumber(

598: itemkey => p_itemkey,
599: aname => 'REQUESTED_DATE',
600: avalue => p_request_date);
601:
602: wf_engine.SetItemAttrNumber(
603: itemtype => l_itemtype,
604: itemkey => p_itemkey,
605: aname => 'REQUEST_DATE_QTY',
606: avalue => p_request_date_qty);

Line 608: wf_engine.SetItemAttrNumber(

604: itemkey => p_itemkey,
605: aname => 'REQUEST_DATE_QTY',
606: avalue => p_request_date_qty);
607:
608: wf_engine.SetItemAttrNumber(
609: itemtype => l_itemtype,
610: itemkey => p_itemkey,
611: aname => 'AVAILABLE_QTY',
612: avalue => p_available_qty);

Line 614: wf_engine.SetItemAttrDate(

610: itemkey => p_itemkey,
611: aname => 'AVAILABLE_QTY',
612: avalue => p_available_qty);
613:
614: wf_engine.SetItemAttrDate(
615: itemtype => l_itemtype,
616: itemkey => p_itemkey,
617: aname => 'AVAILABLE_DATE',
618: avalue => p_available_date);

Line 640: wf_engine.SetItemAttrText(

636: AND tpslid.partner_type = 2
637: AND tp.partner_id = tplid.tp_id
638: AND tps.partner_site_id = tpslid.tp_site_id ;
639:
640: wf_engine.SetItemAttrText(
641: itemtype => l_itemtype,
642: itemkey => p_itemkey,
643: aname => 'CUST_CLASS',
644: avalue => l_customer_class);

Line 646: wf_engine.SetItemAttrText(

642: itemkey => p_itemkey,
643: aname => 'CUST_CLASS',
644: avalue => l_customer_class);
645:
646: wf_engine.SetItemAttrText(
647: itemtype => l_itemtype,
648: itemkey => p_itemkey,
649: aname => 'CUSTOMER',
650: avalue => l_customer);

Line 652: wf_engine.SetItemAttrText(

648: itemkey => p_itemkey,
649: aname => 'CUSTOMER',
650: avalue => l_customer);
651:
652: wf_engine.SetItemAttrText(
653: itemtype => l_itemtype,
654: itemkey => p_itemkey,
655: aname => 'CUST_LOCATION',
656: avalue => l_location);

Line 658: wf_engine.SetItemAttrText(

654: itemkey => p_itemkey,
655: aname => 'CUST_LOCATION',
656: avalue => l_location);
657:
658: wf_engine.SetItemAttrText(
659: itemtype => l_itemtype,
660: itemkey => p_itemkey,
661: aname => 'CUST_ADDRESS',
662: avalue => l_address);

Line 664: wf_engine.SetItemAttrNumber(

660: itemkey => p_itemkey,
661: aname => 'CUST_ADDRESS',
662: avalue => l_address);
663:
664: wf_engine.SetItemAttrNumber(
665: itemtype => l_itemtype,
666: itemkey => p_itemkey,
667: aname => 'ORDER_NUMBER',
668: avalue => p_order_number);

Line 670: wf_engine.SetItemAttrNumber(

666: itemkey => p_itemkey,
667: aname => 'ORDER_NUMBER',
668: avalue => p_order_number);
669:
670: wf_engine.SetItemAttrNumber(
671: itemtype => l_itemtype,
672: itemkey => p_itemkey,
673: aname => 'LINE_NUMBER',
674: avalue => p_line_number);

Line 681: wf_engine.SetItemAttrText(

677: OPEN PLANNER_C;
678: FETCH PLANNER_C INTO l_username, l_plan_name;
679: CLOSE PLANNER_C;
680:
681: wf_engine.SetItemAttrText(
682: itemtype => l_itemtype,
683: itemkey => p_itemkey,
684: aname => 'PLAN_NAME',
685: avalue => l_plan_name);

Line 687: wf_engine.SetItemAttrText(

683: itemkey => p_itemkey,
684: aname => 'PLAN_NAME',
685: avalue => l_plan_name);
686:
687: wf_engine.SetItemAttrText(
688: itemtype => l_itemtype,
689: itemkey => p_itemkey,
690: aname => 'USERNAME',
691: avalue => l_username);

Line 693: wf_engine.StartProcess(

689: itemkey => p_itemkey,
690: aname => 'USERNAME',
691: avalue => l_username);
692:
693: wf_engine.StartProcess(
694: itemtype => l_itemtype,
695: itemkey => p_itemkey);
696: END start_mscatp_wf;
697: