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

Line 217: wf_engine.createProcess ( ItemType => l_ItemType,

213: into l_seq from sys.dual;
214:
215: l_itemkey:=to_char(p_asl_id)||'-'||l_seq;
216:
217: wf_engine.createProcess ( ItemType => l_ItemType,
218: ItemKey => l_ItemKey,
219: Process => 'UPDATE_CAPACITY');
220:
221:

Line 222: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

218: ItemKey => l_ItemKey,
219: Process => 'UPDATE_CAPACITY');
220:
221:
222: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
223: itemkey => l_itemkey,
224: aname => 'ASL_ID',
225: avalue => p_asl_id);
226: wf_engine.StartProcess ( ItemType => l_ItemType,

Line 226: wf_engine.StartProcess ( ItemType => l_ItemType,

222: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
223: itemkey => l_itemkey,
224: aname => 'ASL_ID',
225: avalue => p_asl_id);
226: wf_engine.StartProcess ( ItemType => l_ItemType,
227: ItemKey => l_ItemKey );
228:
229: end StartWorkflow;
230:

Line 307: wf_engine.SetItemAttrText ( itemtype => itemtype,

303: end loop;
304:
305: l_document := l_document || '';
306:
307: wf_engine.SetItemAttrText ( itemtype => itemtype,
308: itemkey => itemkey,
309: aname => 'OLD_MFG_CAPACITY_TABLE',
310: avalue => l_document);
311:

Line 390: wf_engine.SetItemAttrText ( itemtype => itemtype,

386: end loop;
387:
388: l_document := l_document || '' || NL;
389:
390: wf_engine.SetItemAttrText ( itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'NEW_MFG_CAPACITY_TABLE',
393: avalue => l_document);
394:

Line 447: wf_engine.SetItemAttrText ( itemtype => itemtype,

443: end loop;
444:
445: l_document := l_document || '';
446:
447: wf_engine.SetItemAttrText ( itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'OLD_CAPACITY_TOLERANCE_TABLE',
450: avalue => l_document);
451:

Line 503: wf_engine.SetItemAttrText ( itemtype => itemtype,

499: end loop;
500:
501: l_document := l_document || '';
502:
503: wf_engine.SetItemAttrText ( itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'NEW_CAPACITY_TOLERANCE_TABLE',
506: avalue => l_document);
507:

Line 535: if (funcmode <> wf_engine.eng_run) then

531: l_approval_required_by varchar2(20);
532: l_progress varchar2(3):='0';
533:
534: begin
535: if (funcmode <> wf_engine.eng_run) then
536: resultout := wf_engine.eng_null;
537: return;
538: end if;
539: l_progress:='1';

Line 536: resultout := wf_engine.eng_null;

532: l_progress varchar2(3):='0';
533:
534: begin
535: if (funcmode <> wf_engine.eng_run) then
536: resultout := wf_engine.eng_null;
537: return;
538: end if;
539: l_progress:='1';
540: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 540: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

536: resultout := wf_engine.eng_null;
537: return;
538: end if;
539: l_progress:='1';
540: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
541: itemkey => itemkey,
542: aname => 'ASL_ID');
543: select DESCRIPTION,
544: BUYER_ID,

Line 561: wf_engine.SetItemAttrText ( itemtype => itemtype,

557: from POS_ORD_MODIFIERS_V
558: where asl_id=l_asl_id;
559:
560: l_progress:='2';
561: wf_engine.SetItemAttrText ( itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'ITEM_DESCRIPTION',
564: avalue => l_item_description);
565: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 565: wf_engine.SetItemAttrText ( itemtype => itemtype,

561: wf_engine.SetItemAttrText ( itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'ITEM_DESCRIPTION',
564: avalue => l_item_description);
565: wf_engine.SetItemAttrText ( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'ITEM_NUM',
568: avalue => l_item_number);
569: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 569: wf_engine.SetItemAttrText ( itemtype => itemtype,

565: wf_engine.SetItemAttrText ( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'ITEM_NUM',
568: avalue => l_item_number);
569: wf_engine.SetItemAttrText ( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'SUPPLIER_ITEM',
572: avalue => l_supplier_item_number);
573: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 573: wf_engine.SetItemAttrText ( itemtype => itemtype,

569: wf_engine.SetItemAttrText ( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'SUPPLIER_ITEM',
572: avalue => l_supplier_item_number);
573: wf_engine.SetItemAttrText ( itemtype => itemtype,
574: itemkey => itemkey,
575: aname => 'SUPPLIER_ITEM_NVL',
576: avalue => nvl(l_supplier_item_number,
577: l_item_number));

Line 578: wf_engine.SetItemAttrText ( itemtype => itemtype,

574: itemkey => itemkey,
575: aname => 'SUPPLIER_ITEM_NVL',
576: avalue => nvl(l_supplier_item_number,
577: l_item_number));
578: wf_engine.SetItemAttrText ( itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'PURCHASING_UOM',
581: avalue => l_uom);
582:

Line 600: wf_engine.SetItemAttrText ( itemtype => itemtype,

596: where vendor_id=l_vendor_id;
597: end if;
598:
599: l_progress:='6';
600: wf_engine.SetItemAttrText ( itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'SUPPLIER_ORG_NAME',
603: avalue => l_supplier_username);
604:

Line 638: wf_engine.SetItemAttrText ( itemtype => itemtype,

634: if(l_vendor_id is not null) then
635: wf_directory.GetUserName('FND_USR', l_vendor_id, l_supplier_username, l_supplier_displayname);
636: end if;
637: l_progress:='12';
638: wf_engine.SetItemAttrText ( itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'BUYER_NAME',
641: avalue => l_buyer_username);
642: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 642: wf_engine.SetItemAttrText ( itemtype => itemtype,

638: wf_engine.SetItemAttrText ( itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'BUYER_NAME',
641: avalue => l_buyer_username);
642: wf_engine.SetItemAttrText ( itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'BUYER_DISPLAY_NAME',
645: avalue => l_buyer_displayname);
646: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 646: wf_engine.SetItemAttrText ( itemtype => itemtype,

642: wf_engine.SetItemAttrText ( itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'BUYER_DISPLAY_NAME',
645: avalue => l_buyer_displayname);
646: wf_engine.SetItemAttrText ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'PLANNER_NAME',
649: avalue => l_planner_username);
650: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 650: wf_engine.SetItemAttrText ( itemtype => itemtype,

646: wf_engine.SetItemAttrText ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'PLANNER_NAME',
649: avalue => l_planner_username);
650: wf_engine.SetItemAttrText ( itemtype => itemtype,
651: itemkey => itemkey,
652: aname => 'PLANNER_DISPLAY_NAME',
653: avalue => l_planner_displayname);
654: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 654: wf_engine.SetItemAttrText ( itemtype => itemtype,

650: wf_engine.SetItemAttrText ( itemtype => itemtype,
651: itemkey => itemkey,
652: aname => 'PLANNER_DISPLAY_NAME',
653: avalue => l_planner_displayname);
654: wf_engine.SetItemAttrText ( itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'SUPPLIER_NAME',
657: avalue => l_supplier_username);
658: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 658: wf_engine.SetItemAttrText ( itemtype => itemtype,

654: wf_engine.SetItemAttrText ( itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'SUPPLIER_NAME',
657: avalue => l_supplier_username);
658: wf_engine.SetItemAttrText ( itemtype => itemtype,
659: itemkey => itemkey,
660: aname => 'SUPPLIER_DISPLAY_NAME',
661: avalue => l_supplier_displayname);
662:

Line 667: wf_engine.SetItemAttrText ( itemtype => itemtype,

663: l_progress:='13';
664: FND_PROFILE.get('POS_ASL_MOD_APPR_REQD_BY', l_approval_required_by);
665: l_progress:='14';
666: if(upper(l_approval_required_by)='BUYER') then
667: wf_engine.SetItemAttrText ( itemtype => itemtype,
668: itemkey => itemkey,
669: aname => 'APPROVAL_REQUIRED_BY',
670: avalue => 'BUYER');
671: elsif(upper(l_approval_required_by)='PLANNER') then

Line 672: wf_engine.SetItemAttrText ( itemtype => itemtype,

668: itemkey => itemkey,
669: aname => 'APPROVAL_REQUIRED_BY',
670: avalue => 'BUYER');
671: elsif(upper(l_approval_required_by)='PLANNER') then
672: wf_engine.SetItemAttrText ( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'APPROVAL_REQUIRED_BY',
675: avalue => 'PLANNER');
676: else

Line 677: wf_engine.SetItemAttrText ( itemtype => itemtype,

673: itemkey => itemkey,
674: aname => 'APPROVAL_REQUIRED_BY',
675: avalue => 'PLANNER');
676: else
677: wf_engine.SetItemAttrText ( itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'APPROVAL_REQUIRED_BY',
680: avalue => 'NONE');
681: end if;

Line 685: wf_engine.SetItemAttrText (itemtype => itemtype,

681: end if;
682:
683: l_progress:='15';
684:
685: wf_engine.SetItemAttrText (itemtype => itemtype,
686: itemkey => itemkey,
687: aname => 'POS_NOTIFY_APPROVER',
688: avalue => 'PLSQL:POS_UPDATE_CAPACITY_PKG.GENERATE_CAP_APP_NOTIF/'|| itemtype || ':' || itemkey);
689:

Line 690: wf_engine.SetItemAttrText (itemtype => itemtype,

686: itemkey => itemkey,
687: aname => 'POS_NOTIFY_APPROVER',
688: avalue => 'PLSQL:POS_UPDATE_CAPACITY_PKG.GENERATE_CAP_APP_NOTIF/'|| itemtype || ':' || itemkey);
689:
690: wf_engine.SetItemAttrText (itemtype => itemtype,
691: itemkey => itemkey,
692: aname => 'POS_SUPP_NOTIF_APPR',
693: avalue => 'PLSQL:POS_UPDATE_CAPACITY_PKG.GENERATE_SUPPL_CAP_NOTIF_APPR/'|| itemtype || ':' || itemkey);
694:

Line 695: wf_engine.SetItemAttrText (itemtype => itemtype,

691: itemkey => itemkey,
692: aname => 'POS_SUPP_NOTIF_APPR',
693: avalue => 'PLSQL:POS_UPDATE_CAPACITY_PKG.GENERATE_SUPPL_CAP_NOTIF_APPR/'|| itemtype || ':' || itemkey);
694:
695: wf_engine.SetItemAttrText (itemtype => itemtype,
696: itemkey => itemkey,
697: aname => 'POS_SUPP_NOTIF_REJ',
698: avalue => 'PLSQL:POS_UPDATE_CAPACITY_PKG.GENERATE_SUPPL_CAP_NOTIF_REJ/'|| itemtype || ':' || itemkey);
699:

Line 724: if (funcmode <> wf_engine.eng_run) then

720: actid in number,
721: funcmode in varchar2,
722: resultout out NOCOPY varchar2 ) is
723: begin
724: if (funcmode <> wf_engine.eng_run) then
725: resultout := wf_engine.eng_null;
726: return;
727: end if;
728: end;

Line 725: resultout := wf_engine.eng_null;

721: funcmode in varchar2,
722: resultout out NOCOPY varchar2 ) is
723: begin
724: if (funcmode <> wf_engine.eng_run) then
725: resultout := wf_engine.eng_null;
726: return;
727: end if;
728: end;
729:

Line 736: if (funcmode <> wf_engine.eng_run) then

732: actid in number,
733: funcmode in varchar2,
734: resultout out NOCOPY varchar2 ) is
735: begin
736: if (funcmode <> wf_engine.eng_run) then
737: resultout := wf_engine.eng_null;
738: return;
739: end if;
740: end;

Line 737: resultout := wf_engine.eng_null;

733: funcmode in varchar2,
734: resultout out NOCOPY varchar2 ) is
735: begin
736: if (funcmode <> wf_engine.eng_run) then
737: resultout := wf_engine.eng_null;
738: return;
739: end if;
740: end;
741:

Line 751: if (funcmode <> wf_engine.eng_run) then

747:
748: l_approval_required_by varchar2(20);
749: l_buyer_name varchar2(180);
750: begin
751: if (funcmode <> wf_engine.eng_run) then
752: resultout := wf_engine.eng_null;
753: return;
754: end if;
755: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 752: resultout := wf_engine.eng_null;

748: l_approval_required_by varchar2(20);
749: l_buyer_name varchar2(180);
750: begin
751: if (funcmode <> wf_engine.eng_run) then
752: resultout := wf_engine.eng_null;
753: return;
754: end if;
755: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
756: itemkey => itemkey,

Line 755: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

751: if (funcmode <> wf_engine.eng_run) then
752: resultout := wf_engine.eng_null;
753: return;
754: end if;
755: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
756: itemkey => itemkey,
757: aname => 'APPROVAL_REQUIRED_BY');
758: if(l_approval_required_by='BUYER') then
759: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 759: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

755: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
756: itemkey => itemkey,
757: aname => 'APPROVAL_REQUIRED_BY');
758: if(l_approval_required_by='BUYER') then
759: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'BUYER_NAME');
762: wf_engine.SetItemAttrText ( itemtype => itemtype,
763: itemkey => itemkey,

Line 762: wf_engine.SetItemAttrText ( itemtype => itemtype,

758: if(l_approval_required_by='BUYER') then
759: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'BUYER_NAME');
762: wf_engine.SetItemAttrText ( itemtype => itemtype,
763: itemkey => itemkey,
764: aname => 'RESPONSE_FROM_ROLE',
765: avalue => l_buyer_name);
766: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 766: resultout := wf_engine.eng_completed || ':' || 'Y';

762: wf_engine.SetItemAttrText ( itemtype => itemtype,
763: itemkey => itemkey,
764: aname => 'RESPONSE_FROM_ROLE',
765: avalue => l_buyer_name);
766: resultout := wf_engine.eng_completed || ':' || 'Y';
767: else
768: resultout := wf_engine.eng_completed || ':' || 'N';
769: end if;
770:

Line 768: resultout := wf_engine.eng_completed || ':' || 'N';

764: aname => 'RESPONSE_FROM_ROLE',
765: avalue => l_buyer_name);
766: resultout := wf_engine.eng_completed || ':' || 'Y';
767: else
768: resultout := wf_engine.eng_completed || ':' || 'N';
769: end if;
770:
771: end;
772:

Line 781: if (funcmode <> wf_engine.eng_run) then

777: resultout out NOCOPY varchar2 ) is
778:
779: l_buyer_name varchar2(100);
780: begin
781: if (funcmode <> wf_engine.eng_run) then
782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 782: resultout := wf_engine.eng_null;

778:
779: l_buyer_name varchar2(100);
780: begin
781: if (funcmode <> wf_engine.eng_run) then
782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
786: itemkey => itemkey,

Line 785: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

781: if (funcmode <> wf_engine.eng_run) then
782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
786: itemkey => itemkey,
787: aname => 'BUYER_NAME');
788: if(l_buyer_name is not null) then
789: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 789: resultout := wf_engine.eng_completed || ':' || 'Y';

785: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
786: itemkey => itemkey,
787: aname => 'BUYER_NAME');
788: if(l_buyer_name is not null) then
789: resultout := wf_engine.eng_completed || ':' || 'Y';
790: else
791: resultout := wf_engine.eng_completed || ':' || 'N';
792: end if;
793: end;

Line 791: resultout := wf_engine.eng_completed || ':' || 'N';

787: aname => 'BUYER_NAME');
788: if(l_buyer_name is not null) then
789: resultout := wf_engine.eng_completed || ':' || 'Y';
790: else
791: resultout := wf_engine.eng_completed || ':' || 'N';
792: end if;
793: end;
794:
795: procedure PLANNER_APPROVAL_REQUIRED( itemtype in varchar2,

Line 805: if (funcmode <> wf_engine.eng_run) then

801: l_approval_required_by varchar2(20);
802: l_planner_name varchar2(180);
803: l_supplier_name varchar2(180);
804: begin
805: if (funcmode <> wf_engine.eng_run) then
806: resultout := wf_engine.eng_null;
807: return;
808: end if;
809: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 806: resultout := wf_engine.eng_null;

802: l_planner_name varchar2(180);
803: l_supplier_name varchar2(180);
804: begin
805: if (funcmode <> wf_engine.eng_run) then
806: resultout := wf_engine.eng_null;
807: return;
808: end if;
809: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
810: itemkey => itemkey,

Line 809: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

805: if (funcmode <> wf_engine.eng_run) then
806: resultout := wf_engine.eng_null;
807: return;
808: end if;
809: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
810: itemkey => itemkey,
811: aname => 'APPROVAL_REQUIRED_BY');
812: if(l_approval_required_by='PLANNER') then
813: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 813: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

809: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
810: itemkey => itemkey,
811: aname => 'APPROVAL_REQUIRED_BY');
812: if(l_approval_required_by='PLANNER') then
813: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
814: itemkey => itemkey,
815: aname => 'PLANNER_NAME');
816: wf_engine.SetItemAttrText ( itemtype => itemtype,
817: itemkey => itemkey,

Line 816: wf_engine.SetItemAttrText ( itemtype => itemtype,

812: if(l_approval_required_by='PLANNER') then
813: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
814: itemkey => itemkey,
815: aname => 'PLANNER_NAME');
816: wf_engine.SetItemAttrText ( itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'RESPONSE_FROM_ROLE',
819: avalue => l_planner_name);
820: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 820: resultout := wf_engine.eng_completed || ':' || 'Y';

816: wf_engine.SetItemAttrText ( itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'RESPONSE_FROM_ROLE',
819: avalue => l_planner_name);
820: resultout := wf_engine.eng_completed || ':' || 'Y';
821: else
822: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'SUPPLIER_NAME');

Line 822: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

818: aname => 'RESPONSE_FROM_ROLE',
819: avalue => l_planner_name);
820: resultout := wf_engine.eng_completed || ':' || 'Y';
821: else
822: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'SUPPLIER_NAME');
825: wf_engine.SetItemAttrText ( itemtype => itemtype,
826: itemkey => itemkey,

Line 825: wf_engine.SetItemAttrText ( itemtype => itemtype,

821: else
822: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'SUPPLIER_NAME');
825: wf_engine.SetItemAttrText ( itemtype => itemtype,
826: itemkey => itemkey,
827: aname => 'RESPONSE_FROM_ROLE',
828: avalue => l_supplier_name);
829: resultout := wf_engine.eng_completed || ':' || 'N';

Line 829: resultout := wf_engine.eng_completed || ':' || 'N';

825: wf_engine.SetItemAttrText ( itemtype => itemtype,
826: itemkey => itemkey,
827: aname => 'RESPONSE_FROM_ROLE',
828: avalue => l_supplier_name);
829: resultout := wf_engine.eng_completed || ':' || 'N';
830: end if;
831:
832: end;
833:

Line 842: if (funcmode <> wf_engine.eng_run) then

838: resultout out NOCOPY varchar2 ) is
839:
840: l_planner_name varchar2(100);
841: begin
842: if (funcmode <> wf_engine.eng_run) then
843: resultout := wf_engine.eng_null;
844: return;
845: end if;
846: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 843: resultout := wf_engine.eng_null;

839:
840: l_planner_name varchar2(100);
841: begin
842: if (funcmode <> wf_engine.eng_run) then
843: resultout := wf_engine.eng_null;
844: return;
845: end if;
846: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
847: itemkey => itemkey,

Line 846: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

842: if (funcmode <> wf_engine.eng_run) then
843: resultout := wf_engine.eng_null;
844: return;
845: end if;
846: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
847: itemkey => itemkey,
848: aname => 'PLANNER_NAME');
849: if(l_planner_name is not null) then
850: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 850: resultout := wf_engine.eng_completed || ':' || 'Y';

846: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
847: itemkey => itemkey,
848: aname => 'PLANNER_NAME');
849: if(l_planner_name is not null) then
850: resultout := wf_engine.eng_completed || ':' || 'Y';
851: else
852: resultout := wf_engine.eng_completed || ':' || 'N';
853: end if;
854: end;

Line 852: resultout := wf_engine.eng_completed || ':' || 'N';

848: aname => 'PLANNER_NAME');
849: if(l_planner_name is not null) then
850: resultout := wf_engine.eng_completed || ':' || 'Y';
851: else
852: resultout := wf_engine.eng_completed || ':' || 'N';
853: end if;
854: end;
855:
856: procedure UPDATE_ASL( itemtype in varchar2,

Line 886: if (funcmode <> wf_engine.eng_run) then

882: from_date, to_date, capacity_per_day, capacity_id, created_by, status
883: FROM POS_MFG_CAPACITY_TEMP
884: WHERE asl_id=id and status in ('NEW', 'OLD', 'DEL', 'MOD');
885: begin
886: if (funcmode <> wf_engine.eng_run) then
887: resultout := wf_engine.eng_null;
888: return;
889: end if;
890: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 887: resultout := wf_engine.eng_null;

883: FROM POS_MFG_CAPACITY_TEMP
884: WHERE asl_id=id and status in ('NEW', 'OLD', 'DEL', 'MOD');
885: begin
886: if (funcmode <> wf_engine.eng_run) then
887: resultout := wf_engine.eng_null;
888: return;
889: end if;
890: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
891: itemkey => itemkey,

Line 890: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

886: if (funcmode <> wf_engine.eng_run) then
887: resultout := wf_engine.eng_null;
888: return;
889: end if;
890: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
891: itemkey => itemkey,
892: aname => 'ASL_ID');
893:
894: pos_supplier_item_tol_pkg.delete(l_asl_id);

Line 984: if (funcmode <> wf_engine.eng_run) then

980: resultout out NOCOPY varchar2 ) is
981:
982: l_default_mode varchar2(20);
983: begin
984: if (funcmode <> wf_engine.eng_run) then
985: resultout := wf_engine.eng_null;
986: return;
987: end if;
988: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 985: resultout := wf_engine.eng_null;

981:
982: l_default_mode varchar2(20);
983: begin
984: if (funcmode <> wf_engine.eng_run) then
985: resultout := wf_engine.eng_null;
986: return;
987: end if;
988: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
989: itemkey => itemkey,

Line 988: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,

984: if (funcmode <> wf_engine.eng_run) then
985: resultout := wf_engine.eng_null;
986: return;
987: end if;
988: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'DEFAULT_MODE');
991: if(upper(l_default_mode)='APPROVE') then
992: resultout := wf_engine.eng_completed || ':' || 'APPROVED';

Line 992: resultout := wf_engine.eng_completed || ':' || 'APPROVED';

988: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'DEFAULT_MODE');
991: if(upper(l_default_mode)='APPROVE') then
992: resultout := wf_engine.eng_completed || ':' || 'APPROVED';
993: else
994: resultout := wf_engine.eng_completed || ':' || 'REJECTED';
995: end if;
996:

Line 994: resultout := wf_engine.eng_completed || ':' || 'REJECTED';

990: aname => 'DEFAULT_MODE');
991: if(upper(l_default_mode)='APPROVE') then
992: resultout := wf_engine.eng_completed || ':' || 'APPROVED';
993: else
994: resultout := wf_engine.eng_completed || ':' || 'REJECTED';
995: end if;
996:
997: end;
998:

Line 1007: if (funcmode <> wf_engine.eng_run) then

1003: resultout out NOCOPY varchar2 ) is
1004:
1005: l_asl_id number;
1006: begin
1007: if (funcmode <> wf_engine.eng_run) then
1008: resultout := wf_engine.eng_null;
1009: return;
1010: end if;
1011:

Line 1008: resultout := wf_engine.eng_null;

1004:
1005: l_asl_id number;
1006: begin
1007: if (funcmode <> wf_engine.eng_run) then
1008: resultout := wf_engine.eng_null;
1009: return;
1010: end if;
1011:
1012: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 1012: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

1008: resultout := wf_engine.eng_null;
1009: return;
1010: end if;
1011:
1012: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1013: itemkey => itemkey,
1014: aname => 'ASL_ID');
1015:
1016: update POS_MFG_CAPACITY_TEMP

Line 1037: if (funcmode <> wf_engine.eng_run) then

1033:
1034: l_buyer_name varchar2(100);
1035: l_planner_name varchar2(100);
1036: begin
1037: if (funcmode <> wf_engine.eng_run) then
1038: resultout := wf_engine.eng_null;
1039: return;
1040: end if;
1041: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1038: resultout := wf_engine.eng_null;

1034: l_buyer_name varchar2(100);
1035: l_planner_name varchar2(100);
1036: begin
1037: if (funcmode <> wf_engine.eng_run) then
1038: resultout := wf_engine.eng_null;
1039: return;
1040: end if;
1041: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
1042: itemkey => itemkey,

Line 1041: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

1037: if (funcmode <> wf_engine.eng_run) then
1038: resultout := wf_engine.eng_null;
1039: return;
1040: end if;
1041: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
1042: itemkey => itemkey,
1043: aname => 'BUYER_NAME');
1044: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
1045: itemkey => itemkey,

Line 1044: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

1040: end if;
1041: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
1042: itemkey => itemkey,
1043: aname => 'BUYER_NAME');
1044: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
1045: itemkey => itemkey,
1046: aname => 'PLANNER_NAME');
1047:
1048: if(l_planner_name is not null) then

Line 1050: resultout := wf_engine.eng_completed || ':' || 'Y';

1046: aname => 'PLANNER_NAME');
1047:
1048: if(l_planner_name is not null) then
1049: if(l_planner_name=l_buyer_name) then
1050: resultout := wf_engine.eng_completed || ':' || 'Y';
1051: else
1052: resultout := wf_engine.eng_completed || ':' || 'N';
1053: end if;
1054: else

Line 1052: resultout := wf_engine.eng_completed || ':' || 'N';

1048: if(l_planner_name is not null) then
1049: if(l_planner_name=l_buyer_name) then
1050: resultout := wf_engine.eng_completed || ':' || 'Y';
1051: else
1052: resultout := wf_engine.eng_completed || ':' || 'N';
1053: end if;
1054: else
1055: resultout := wf_engine.eng_completed || ':' || 'Y';
1056: end if;

Line 1055: resultout := wf_engine.eng_completed || ':' || 'Y';

1051: else
1052: resultout := wf_engine.eng_completed || ':' || 'N';
1053: end if;
1054: else
1055: resultout := wf_engine.eng_completed || ':' || 'Y';
1056: end if;
1057: end;
1058:
1059:

Line 1090: x_old_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1086:
1087: generate_header(l_document,l_item_type,l_item_key);
1088:
1089:
1090: x_old_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1091: itemkey => l_item_key,
1092: aname => 'OLD_CAPACITY_TOLERANCE_TABLE');
1093:
1094: x_new_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 1094: x_new_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1090: x_old_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1091: itemkey => l_item_key,
1092: aname => 'OLD_CAPACITY_TOLERANCE_TABLE');
1093:
1094: x_new_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1095: itemkey => l_item_key,
1096: aname => 'NEW_CAPACITY_TOLERANCE_TABLE');
1097:
1098: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 1098: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1094: x_new_capacity_tolerance := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1095: itemkey => l_item_key,
1096: aname => 'NEW_CAPACITY_TOLERANCE_TABLE');
1097:
1098: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1099: itemkey => l_item_key,
1100: aname => 'NEW_MFG_CAPACITY_TABLE');
1101:
1102: x_old_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 1102: x_old_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1098: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1099: itemkey => l_item_key,
1100: aname => 'NEW_MFG_CAPACITY_TABLE');
1101:
1102: x_old_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1103: itemkey => l_item_key,
1104: aname => 'OLD_MFG_CAPACITY_TABLE');
1105:
1106:

Line 1159: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,

1155: x_uom varchar2(25);
1156:
1157: begin
1158:
1159: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'ITEM_DESCRIPTION');
1162:
1163: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1163: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,

1159: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'ITEM_DESCRIPTION');
1162:
1163: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,
1164: itemkey => itemkey,
1165: aname => 'ITEM_NUM');
1166:
1167: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1167: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,

1163: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,
1164: itemkey => itemkey,
1165: aname => 'ITEM_NUM');
1166:
1167: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'SUPPLIER_ITEM');
1170:
1171: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1171: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,

1167: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'SUPPLIER_ITEM');
1170:
1171: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,
1172: itemkey => itemkey,
1173: aname => 'PURCHASING_UOM');
1174:
1175:

Line 1232: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1228: l_document := l_document || '' || NL;
1229:
1230: generate_header(l_document,l_item_type,l_item_key);
1231:
1232: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1233: itemkey => l_item_key,
1234: aname => 'NEW_MFG_CAPACITY_TABLE');
1235:
1236: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 1236: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1232: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1233: itemkey => l_item_key,
1234: aname => 'NEW_MFG_CAPACITY_TABLE');
1235:
1236: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1237: itemkey => l_item_key,
1238: aname => 'NEW_CAPACITY_TOLERANCE_TABLE');
1239:
1240:

Line 1299: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1295: l_document := l_document || '' || NL;
1296:
1297: generate_header(l_document,l_item_type,l_item_key);
1298:
1299: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1300: itemkey => l_item_key,
1301: aname => 'NEW_MFG_CAPACITY_TABLE');
1302:
1303: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 1303: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,

1299: x_new_mfg_capacity_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1300: itemkey => l_item_key,
1301: aname => 'NEW_MFG_CAPACITY_TABLE');
1302:
1303: x_new_capacity_tolerance_table := wf_engine.GetItemAttrText ( itemtype => l_item_type,
1304: itemkey => l_item_key,
1305: aname => 'NEW_CAPACITY_TOLERANCE_TABLE');
1306:
1307: