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_X_CUST_FACING_RELEASE dependencies on WF_ENGINE

Line 161: wf_engine.SetItemAttrNumber

157: /* Change the VMI release type to ATP override.
158: Next node in workflow will call the release replenishment
159: */
160:
161: wf_engine.SetItemAttrNumber
162: ( itemtype => itemtype,
163: itemkey => itemkey,
164: aname => 'VMI_RELEASE_TYPE',
165: avalue => G_PLANNER_OVERRIDE_ATP

Line 185: wf_engine.GetItemAttrNumber

181: )
182: IS
183:
184: l_schedule_date_changed NUMBER :=
185: wf_engine.GetItemAttrNumber
186: (itemtype => itemtype,
187: itemkey => itemkey,
188: aname => 'SCHEDULE_DATE_CHANGE'
189: );

Line 228: wf_engine.GetItemAttrNumber

224: )
225: IS
226:
227: lv_consigned NUMBER :=
228: wf_engine.GetItemAttrNumber
229: (itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'CONSIGNED_FLAG'
232: );

Line 279: wf_engine.GetItemAttrText

275: l_dev_status varchar2(80);
276: l_message varchar2(2048);
277:
278: l_item_name varchar2(250) :=
279: wf_engine.GetItemAttrText
280: ( itemtype => itemtype
281: , itemkey => itemkey
282: , aname => 'SUPPLIER_ITEM_NAME'
283: );

Line 286: wf_engine.GetItemAttrText

282: , aname => 'SUPPLIER_ITEM_NAME'
283: );
284:
285: l_customer_name varchar2(250) :=
286: wf_engine.GetItemAttrText
287: ( itemtype => itemtype
288: , itemkey => itemkey
289: , aname => 'CUSTOMER_NAME'
290: );

Line 293: wf_engine.GetItemAttrText

289: , aname => 'CUSTOMER_NAME'
290: );
291:
292: l_customer_site_name varchar2(250) :=
293: wf_engine.GetItemAttrText
294: ( itemtype => itemtype
295: , itemkey => itemkey
296: , aname => 'CUSTOMER_SITE_NAME'
297: );

Line 389: wf_engine.GetItemAttrNumber

385: resultout out nocopy varchar2
386: )
387: IS
388: lv_delete_release_id NUMBER :=
389: wf_engine.GetItemAttrNumber
390: (itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'RELEASE_ID'
393: );

Line 522: wf_engine.GetItemAttrNumber

518: -- Debug snippet end
519:
520:
521: l_sr_instance_id :=
522: wf_engine.GetItemAttrNumber
523: ( itemtype => itemtype
524: , itemkey => itemkey
525: , aname => 'SR_INSTANCE_ID'
526: );

Line 529: wf_engine.GetItemAttrNumber

525: , aname => 'SR_INSTANCE_ID'
526: );
527:
528: l_cust_organization_id :=
529: wf_engine.GetItemAttrNumber
530: ( itemtype => itemtype
531: , itemkey => itemkey
532: , aname => 'CUSTOMER_ORG_ID'
533: );

Line 536: wf_engine.GetItemAttrNumber

532: , aname => 'CUSTOMER_ORG_ID'
533: );
534:
535: l_source_org_id :=
536: wf_engine.GetItemAttrNumber
537: ( itemtype => itemtype
538: , itemkey => itemkey
539: , aname => 'SOURCE_ORG_ID'
540: );

Line 543: wf_engine.GetItemAttrNumber

539: , aname => 'SOURCE_ORG_ID'
540: );
541:
542: l_inventory_item_id :=
543: wf_engine.GetItemAttrNumber
544: ( itemtype => itemtype
545: , itemkey => itemkey
546: , aname => 'INVENTORY_ITEM_ID'
547: );

Line 550: wf_engine.GetItemAttrNumber

546: , aname => 'INVENTORY_ITEM_ID'
547: );
548:
549: l_sr_inventory_item_id :=
550: wf_engine.GetItemAttrNumber
551: ( itemtype => itemtype
552: , itemkey => itemkey
553: , aname => 'SR_INVENTORY_ITEM_ID'
554: );

Line 557: wf_engine.GetItemAttrNumber

553: , aname => 'SR_INVENTORY_ITEM_ID'
554: );
555:
556: l_order_quantity :=
557: wf_engine.GetItemAttrNumber
558: ( itemtype => itemtype
559: , itemkey => itemkey
560: -- , aname => 'ORDER_QUANTITY'
561: , aname => 'RELEASE_QUANTITY'

Line 565: wf_engine.GetItemAttrDate

561: , aname => 'RELEASE_QUANTITY'
562: );
563:
564: l_request_date :=
565: wf_engine.GetItemAttrDate
566: ( itemtype => itemtype
567: , itemkey => itemkey
568: , aname => 'TIME_FENCE_END_DATE'
569: );

Line 572: wf_engine.GetItemAttrDate

568: , aname => 'TIME_FENCE_END_DATE'
569: );
570:
571: l_cons_request_date :=
572: wf_engine.GetItemAttrDate
573: ( itemtype => itemtype
574: , itemkey => itemkey
575: , aname => 'REQUEST_DATE'
576: );

Line 579: wf_engine.GetItemAttrNumber

575: , aname => 'REQUEST_DATE'
576: );
577:
578: l_vmi_type :=
579: wf_engine.GetItemAttrNumber
580: ( itemtype => itemtype
581: , itemkey => itemkey
582: , aname => 'CONSIGNED_FLAG'
583: );

Line 586: wf_engine.GetItemAttrNumber

582: , aname => 'CONSIGNED_FLAG'
583: );
584:
585: l_transaction_type :=
586: wf_engine.GetItemAttrNumber
587: ( itemtype => itemtype
588: , itemkey => itemkey
589: , aname => 'VMI_RELEASE_TYPE'
590: );

Line 593: wf_engine.GetItemAttrNumber

589: , aname => 'VMI_RELEASE_TYPE'
590: );
591:
592: l_release_id :=
593: wf_engine.GetItemAttrNumber
594: ( itemtype => itemtype
595: , itemkey => itemkey
596: , aname => 'RELEASE_ID'
597: );

Line 600: wf_engine.GetItemAttrNumber

596: , aname => 'RELEASE_ID'
597: );
598:
599: l_rep_transaction_id :=
600: wf_engine.GetItemAttrNumber
601: ( itemtype => itemtype
602: , itemkey => itemkey
603: , aname => 'REP_TRANSACTION_ID'
604: );

Line 607: wf_engine.GetItemAttrText

603: , aname => 'REP_TRANSACTION_ID'
604: );
605:
606: l_item_name :=
607: wf_engine.GetItemAttrText
608: ( itemtype => itemtype
609: , itemkey => itemkey
610: , aname => 'SUPPLIER_ITEM_NAME'
611: );

Line 614: wf_engine.GetItemAttrText

610: , aname => 'SUPPLIER_ITEM_NAME'
611: );
612:
613: l_uom_code :=
614: wf_engine.GetItemAttrText
615: ( itemtype => itemtype
616: , itemkey => itemkey
617: , aname => 'UOM_CODE'
618: );

Line 623: wf_engine.GetItemAttrText

619:
620: --Consigned CVMI Enh : Bug # 4562914
621:
622: l_ORDER_NUMBER :=
623: wf_engine.GetItemAttrText
624: ( itemtype => itemtype
625: , itemkey => itemkey
626: , aname => 'ORDER_NUMBER'
627: );

Line 630: wf_engine.GetItemAttrText

626: , aname => 'ORDER_NUMBER'
627: );
628:
629: l_RELEASE_NUMBER :=
630: wf_engine.GetItemAttrText
631: ( itemtype => itemtype
632: , itemkey => itemkey
633: , aname => 'RELEASE_NUMBER'
634: );

Line 637: wf_engine.GetItemAttrText

633: , aname => 'RELEASE_NUMBER'
634: );
635:
636: l_LINE_NUMBER :=
637: wf_engine.GetItemAttrText
638: ( itemtype => itemtype
639: , itemkey => itemkey
640: , aname => 'LINE_NUMBER'
641: );

Line 644: wf_engine.GetItemAttrText

640: , aname => 'LINE_NUMBER'
641: );
642:
643: l_END_ORDER_NUMBER :=
644: wf_engine.GetItemAttrText
645: ( itemtype => itemtype
646: , itemkey => itemkey
647: , aname => 'END_ORDER_NUMBER'
648: );

Line 651: wf_engine.GetItemAttrText

647: , aname => 'END_ORDER_NUMBER'
648: );
649:
650: l_END_ORDER_REL_NUMBER :=
651: wf_engine.GetItemAttrText
652: ( itemtype => itemtype
653: , itemkey => itemkey
654: , aname => 'END_ORDER_REL_NUMBER'
655: );

Line 658: wf_engine.GetItemAttrText

654: , aname => 'END_ORDER_REL_NUMBER'
655: );
656:
657: l_END_ORDER_LINE_NUMBER :=
658: wf_engine.GetItemAttrText
659: ( itemtype => itemtype
660: , itemkey => itemkey
661: , aname => 'END_ORDER_LINE_NUMBER'
662: );

Line 799: wf_engine.SetItemAttrNumber(

795: into lv_rel_id
796: from dual;
797:
798: /* set the Release_id attribute to system-generated sequence */
799: wf_engine.SetItemAttrNumber(
800: itemtype => itemtype,
801: itemkey => itemkey,
802: aname => 'RELEASE_ID',
803: avalue => lv_rel_id

Line 1026: wf_engine.SetItemAttrNumber(

1022: and sr_tp_id = lv_ship_from_org_id;
1023: end if;
1024:
1025: /* Set the item attribute SCHEDULE_DATE_CHANGE as YES */
1026: wf_engine.SetItemAttrNumber(
1027: itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => 'SCHEDULE_DATE_CHANGE',
1030: avalue => SYS_YES

Line 1033: wf_engine.SetItemAttrText(

1029: aname => 'SCHEDULE_DATE_CHANGE',
1030: avalue => SYS_YES
1031: );
1032:
1033: wf_engine.SetItemAttrText(
1034: itemtype => itemtype,
1035: itemkey => itemkey,
1036: aname => 'SUPPLIER_SITE_NAME',
1037: avalue => lv_supplier_site_name

Line 1039: wf_engine.SetItemAttrDate(

1035: itemkey => itemkey,
1036: aname => 'SUPPLIER_SITE_NAME',
1037: avalue => lv_supplier_site_name
1038: );
1039: wf_engine.SetItemAttrDate(
1040: itemtype => itemtype,
1041: itemkey => itemkey,
1042: aname => 'SCHEDULED_DATE',
1043: avalue => lv_schedule_ship_date

Line 1045: wf_engine.SetItemAttrDate(

1041: itemkey => itemkey,
1042: aname => 'SCHEDULED_DATE',
1043: avalue => lv_schedule_ship_date
1044: );
1045: wf_engine.SetItemAttrDate(
1046: itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => 'SCHEDULED_ARRIVAL_DATE',
1049: avalue => lv_schedule_arrival_date

Line 1051: wf_engine.SetItemAttrNumber(

1047: itemkey => itemkey,
1048: aname => 'SCHEDULED_ARRIVAL_DATE',
1049: avalue => lv_schedule_arrival_date
1050: );
1051: wf_engine.SetItemAttrNumber(
1052: itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'SALES_ORDER_NUMBER',
1055: avalue => lv_sales_order_number

Line 1059: wf_engine.SetItemAttrNumber(

1055: avalue => lv_sales_order_number
1056: );
1057: else
1058:
1059: wf_engine.SetItemAttrNumber(
1060: itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'SCHEDULE_DATE_CHANGE',
1063: avalue => SYS_NO

Line 1079: wf_engine.SetItemAttrText(

1075: set error_message = lv_error_message
1076: where release_id = lv_rel_id;
1077:
1078: /* set the Release_id attribute to system-generated sequence */
1079: wf_engine.SetItemAttrText(
1080: itemtype => itemtype,
1081: itemkey => itemkey,
1082: aname => 'SO_ERROR_MESSAGE',
1083: avalue => lv_error_message