420:
421: BEGIN
422:
423:
424: wf_engine.CreateProcess( itemtype => item_type,
425: itemkey => item_key,
426: process => workflow_process);
427:
428: wf_engine.SetItemAttrNumber( itemtype => item_type,
424: wf_engine.CreateProcess( itemtype => item_type,
425: itemkey => item_key,
426: process => workflow_process);
427:
428: wf_engine.SetItemAttrNumber( itemtype => item_type,
429: itemkey => item_key,
430: aname => 'EXCEPTION_ID',
431: avalue => to_number(item_key));
432:
429: itemkey => item_key,
430: aname => 'EXCEPTION_ID',
431: avalue => to_number(item_key));
432:
433: wf_engine.SetItemAttrText( itemtype => item_type,
434: itemkey => item_key,
435: aname => 'PLAN_NAME',
436: avalue => compile_designator);
437:
434: itemkey => item_key,
435: aname => 'PLAN_NAME',
436: avalue => compile_designator);
437:
438: wf_engine.SetItemAttrNumber( itemtype => item_type,
439: itemkey => item_key,
440: aname => 'ORGANIZATION_ID',
441: avalue => organization_id);
442:
439: itemkey => item_key,
440: aname => 'ORGANIZATION_ID',
441: avalue => organization_id);
442:
443: wf_engine.SetItemAttrNumber( itemtype => item_type,
444: itemkey => item_key,
445: aname => 'INVENTORY_ITEM_ID',
446: avalue => inventory_item_id);
447:
444: itemkey => item_key,
445: aname => 'INVENTORY_ITEM_ID',
446: avalue => inventory_item_id);
447:
448: wf_engine.SetItemAttrNumber( itemtype => item_type,
449: itemkey => item_key,
450: aname => 'EXCEPTION_TYPE_ID',
451: avalue => exception_type);
452:
449: itemkey => item_key,
450: aname => 'EXCEPTION_TYPE_ID',
451: avalue => exception_type);
452:
453: wf_engine.SetItemAttrText( itemtype => item_type,
454: itemkey => item_key,
455: aname => 'ORGANIZATION_CODE',
456: avalue => organization_code);
457:
454: itemkey => item_key,
455: aname => 'ORGANIZATION_CODE',
456: avalue => organization_code);
457:
458: wf_engine.SetItemAttrText( itemtype => item_type,
459: itemkey => item_key,
460: aname => 'ITEM_DISPLAY_NAME',
461: avalue => item_segments);
462:
459: itemkey => item_key,
460: aname => 'ITEM_DISPLAY_NAME',
461: avalue => item_segments);
462:
463: wf_engine.SetItemAttrText( itemtype => item_type,
464: itemkey => item_key,
465: aname => 'EXCEPTION_DESCRIPTION',
466: avalue => exception_type_text);
467:
464: itemkey => item_key,
465: aname => 'EXCEPTION_DESCRIPTION',
466: avalue => exception_type_text);
467:
468: wf_engine.SetItemAttrText( itemtype => item_type,
469: itemkey => item_key,
470: aname => 'PROJECT_NUMBER',
471: avalue => project_number);
472:
469: itemkey => item_key,
470: aname => 'PROJECT_NUMBER',
471: avalue => project_number);
472:
473: wf_engine.SetItemAttrText( itemtype => item_type,
474: itemkey => item_key,
475: aname => 'TO_PROJECT_NUMBER',
476: avalue => to_project_number);
477:
474: itemkey => item_key,
475: aname => 'TO_PROJECT_NUMBER',
476: avalue => to_project_number);
477:
478: wf_engine.SetItemAttrText( itemtype => item_type,
479: itemkey => item_key,
480: aname => 'TASK_NUMBER',
481: avalue => task_number);
482:
479: itemkey => item_key,
480: aname => 'TASK_NUMBER',
481: avalue => task_number);
482:
483: wf_engine.SetItemAttrText( itemtype => item_type,
484: itemkey => item_key,
485: aname => 'TO_TASK_NUMBER',
486: avalue => to_task_number);
487:
484: itemkey => item_key,
485: aname => 'TO_TASK_NUMBER',
486: avalue => to_task_number);
487:
488: wf_engine.SetItemAttrText( itemtype => item_type,
489: itemkey => item_key,
490: aname => 'PLANNING_GROUP',
491: avalue => planning_group);
492:
489: itemkey => item_key,
490: aname => 'PLANNING_GROUP',
491: avalue => planning_group);
492:
493: wf_engine.SetItemAttrDate( itemtype => item_type,
494: itemkey => item_key,
495: aname => 'DUE_DATE',
496: avalue => due_date);
497:
494: itemkey => item_key,
495: aname => 'DUE_DATE',
496: avalue => due_date);
497:
498: wf_engine.SetItemAttrDate( itemtype => item_type,
499: itemkey => item_key,
500: aname => 'FROM_DATE',
501: avalue => from_date);
502:
499: itemkey => item_key,
500: aname => 'FROM_DATE',
501: avalue => from_date);
502:
503: wf_engine.SetItemAttrDate( itemtype => item_type,
504: itemkey => item_key,
505: aname => 'TO_DATE',
506: avalue => to_date);
507:
504: itemkey => item_key,
505: aname => 'TO_DATE',
506: avalue => to_date);
507:
508: wf_engine.SetItemAttrNumber( itemtype => item_type,
509: itemkey => item_key,
510: aname => 'DAYS_COMPRESSED',
511: avalue => days_compressed);
512:
509: itemkey => item_key,
510: aname => 'DAYS_COMPRESSED',
511: avalue => days_compressed);
512:
513: wf_engine.SetItemAttrText( itemtype => item_type,
514: itemkey => item_key,
515: aname => 'QUANTITY',
516: avalue => quantity);
517:
514: itemkey => item_key,
515: aname => 'QUANTITY',
516: avalue => quantity);
517:
518: wf_engine.SetItemAttrText( itemtype => item_type,
519: itemkey => item_key,
520: aname => 'LOT_NUMBER',
521: avalue => lot_number);
522:
519: itemkey => item_key,
520: aname => 'LOT_NUMBER',
521: avalue => lot_number);
522:
523: wf_engine.SetItemAttrText( itemtype => item_type,
524: itemkey => item_key,
525: aname => 'ORDER_NUMBER',
526: avalue => order_number);
527:
524: itemkey => item_key,
525: aname => 'ORDER_NUMBER',
526: avalue => order_number);
527:
528: wf_engine.SetItemAttrNumber( itemtype => item_type,
529: itemkey => item_key,
530: aname => 'ORDER_TYPE_CODE',
531: avalue => order_type_code);
532:
529: itemkey => item_key,
530: aname => 'ORDER_TYPE_CODE',
531: avalue => order_type_code);
532:
533: wf_engine.SetItemAttrText( itemtype => item_type,
534: itemkey => item_key,
535: aname => 'SUPPLY_TYPE',
536: avalue => supply_type);
537:
534: itemkey => item_key,
535: aname => 'SUPPLY_TYPE',
536: avalue => supply_type);
537:
538: wf_engine.SetItemAttrText( itemtype => item_type,
539: itemkey => item_key,
540: aname => 'END_ITEM_DISPLAY_NAME',
541: avalue => end_item_segments);
542:
539: itemkey => item_key,
540: aname => 'END_ITEM_DISPLAY_NAME',
541: avalue => end_item_segments);
542:
543: wf_engine.SetItemAttrText( itemtype => item_type,
544: itemkey => item_key,
545: aname => 'END_ORDER_NUMBER',
546: avalue => end_order_number);
547:
544: itemkey => item_key,
545: aname => 'END_ORDER_NUMBER',
546: avalue => end_order_number);
547:
548: wf_engine.SetItemAttrText( itemtype => item_type,
549: itemkey => item_key,
550: aname => 'DEPARTMENT_LINE_CODE',
551: avalue => department_line_code);
552:
549: itemkey => item_key,
550: aname => 'DEPARTMENT_LINE_CODE',
551: avalue => department_line_code);
552:
553: wf_engine.SetItemAttrText( itemtype => item_type,
554: itemkey => item_key,
555: aname => 'RESOURCE_CODE',
556: avalue => resource_code);
557:
554: itemkey => item_key,
555: aname => 'RESOURCE_CODE',
556: avalue => resource_code);
557:
558: wf_engine.SetItemAttrNumber( itemtype => item_type,
559: itemkey => item_key,
560: aname => 'UTILIZATION_RATE',
561: avalue => utilization_rate);
562:
559: itemkey => item_key,
560: aname => 'UTILIZATION_RATE',
561: avalue => utilization_rate);
562:
563: wf_engine.SetItemAttrNumber( itemtype => item_type,
564: itemkey => item_key,
565: aname => 'SUPPLIER_ID',
566: avalue => supplier_id);
567:
564: itemkey => item_key,
565: aname => 'SUPPLIER_ID',
566: avalue => supplier_id);
567:
568: wf_engine.SetItemAttrText( itemtype => item_type,
569: itemkey => item_key,
570: aname => 'SUPPLIER_NAME',
571: avalue => supplier_name);
572:
569: itemkey => item_key,
570: aname => 'SUPPLIER_NAME',
571: avalue => supplier_name);
572:
573: wf_engine.SetItemAttrNumber( itemtype => item_type,
574: itemkey => item_key,
575: aname => 'SUPPLIER_SITE_ID',
576: avalue => supplier_site_id);
577:
574: itemkey => item_key,
575: aname => 'SUPPLIER_SITE_ID',
576: avalue => supplier_site_id);
577:
578: wf_engine.SetItemAttrText( itemtype => item_type,
579: itemkey => item_key,
580: aname => 'SUPPLIER_SITE_CODE',
581: avalue => supplier_site_code);
582:
579: itemkey => item_key,
580: aname => 'SUPPLIER_SITE_CODE',
581: avalue => supplier_site_code);
582:
583: wf_engine.SetItemAttrNumber( itemtype => item_type,
584: itemkey => item_key,
585: aname => 'CUSTOMER_ID',
586: avalue => customer_id);
587:
584: itemkey => item_key,
585: aname => 'CUSTOMER_ID',
586: avalue => customer_id);
587:
588: wf_engine.SetItemAttrText( itemtype => item_type,
589: itemkey => item_key,
590: aname => 'CUSTOMER_NAME',
591: avalue => customer_name);
592:
589: itemkey => item_key,
590: aname => 'CUSTOMER_NAME',
591: avalue => customer_name);
592:
593: wf_engine.SetItemAttrText( itemtype => item_type,
594: itemkey => item_key,
595: aname => 'PLANNER_WORKBENCH',
596: avalue => (workbench_function ||
597: ': compile_designator_qf=' ||
597: ': compile_designator_qf=' ||
598: compile_designator || ' org_id=' ||
599: to_char(organization_id)) );
600:
601: wf_engine.StartProcess( itemtype => item_type,
602: itemkey => item_key);
603:
604: EXCEPTION
605:
625: WHERE planned_organization = p_organization_id
626: AND compile_designator = p_compile_designator;
627:
628: l_compile_designator varchar2(10) :=
629: wf_engine.GetItemAttrText( itemtype => itemtype,
630: itemkey => itemkey,
631: aname => 'PLAN_NAME');
632:
633: l_organization_id number :=
630: itemkey => itemkey,
631: aname => 'PLAN_NAME');
632:
633: l_organization_id number :=
634: wf_engine.GetItemAttrNumber( itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'ORGANIZATION_ID');
637:
638: l_production_flag number := 2;
707: AND items.compile_designator = p_compile_designator;
708:
709:
710: l_compile_designator varchar2(10) :=
711: wf_engine.GetItemAttrText( itemtype => itemtype,
712: itemkey => itemkey,
713: aname => 'PLAN_NAME');
714:
715: l_organization_id number :=
712: itemkey => itemkey,
713: aname => 'PLAN_NAME');
714:
715: l_organization_id number :=
716: wf_engine.GetItemAttrNumber( itemtype => itemtype,
717: itemkey => itemkey,
718: aname => 'ORGANIZATION_ID');
719:
720: l_inventory_item_id number :=
717: itemkey => itemkey,
718: aname => 'ORGANIZATION_ID');
719:
720: l_inventory_item_id number :=
721: wf_engine.GetItemAttrNumber( itemtype => itemtype,
722: itemkey => itemkey,
723: aname => 'INVENTORY_ITEM_ID');
724:
725: l_exception_type number :=
722: itemkey => itemkey,
723: aname => 'INVENTORY_ITEM_ID');
724:
725: l_exception_type number :=
726: wf_engine.GetItemAttrNumber( itemtype => itemtype,
727: itemkey => itemkey,
728: aname => 'EXCEPTION_TYPE_ID');
729:
730: l_order_type number :=
727: itemkey => itemkey,
728: aname => 'EXCEPTION_TYPE_ID');
729:
730: l_order_type number :=
731: wf_engine.GetItemAttrNumber( itemtype => itemtype,
732: itemkey => itemkey,
733: aname => 'ORDER_TYPE_CODE');
734:
735: l_person_id number;
749:
750: wf_directory.GetRoleName('PER', to_char(l_person_id),
751: l_forward_to_username, l_display_username);
752:
753: wf_engine.SetItemAttrText( itemtype => itemtype,
754: itemkey => itemkey,
755: aname => 'MESSAGE_NAME',
756: avalue => GetMessageName(l_exception_type,
757: l_order_type,
758: 'PLANNER'));
759:
760: if (l_forward_to_username is not null) then
761:
762: wf_engine.SetItemAttrText( itemtype => itemtype,
763: itemkey => itemkey,
764: aname => 'FORWARD_TO_USERNAME',
765: avalue => l_forward_to_username);
766:
815: AND organization_id = p_organization_id
816: AND compile_designator = p_compile_designator;
817:
818: l_compile_designator varchar2(10) :=
819: wf_engine.GetItemAttrText( itemtype => itemtype,
820: itemkey => itemkey,
821: aname => 'PLAN_NAME');
822:
823: l_organization_id number :=
820: itemkey => itemkey,
821: aname => 'PLAN_NAME');
822:
823: l_organization_id number :=
824: wf_engine.GetItemAttrNumber( itemtype => itemtype,
825: itemkey => itemkey,
826: aname => 'ORGANIZATION_ID');
827:
828: l_inventory_item_id number :=
825: itemkey => itemkey,
826: aname => 'ORGANIZATION_ID');
827:
828: l_inventory_item_id number :=
829: wf_engine.GetItemAttrNumber( itemtype => itemtype,
830: itemkey => itemkey,
831: aname => 'INVENTORY_ITEM_ID');
832:
833: l_exception_type number :=
830: itemkey => itemkey,
831: aname => 'INVENTORY_ITEM_ID');
832:
833: l_exception_type number :=
834: wf_engine.GetItemAttrNumber( itemtype => itemtype,
835: itemkey => itemkey,
836: aname => 'EXCEPTION_TYPE_ID');
837:
838: l_order_type number :=
835: itemkey => itemkey,
836: aname => 'EXCEPTION_TYPE_ID');
837:
838: l_order_type number :=
839: wf_engine.GetItemAttrNumber( itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'ORDER_TYPE_CODE');
842:
843: l_person_id number;
857:
858: wf_directory.GetRoleName('PER', to_char(l_person_id),
859: l_forward_to_username, l_display_username);
860:
861: wf_engine.SetItemAttrText( itemtype => itemtype,
862: itemkey => itemkey,
863: aname => 'MESSAGE_NAME',
864: avalue => GetMessageName(l_exception_type,
865: l_order_type,
866: 'BUYER'));
867:
868: if (l_forward_to_username is not null) then
869:
870: wf_engine.SetItemAttrText( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'FORWARD_TO_USERNAME',
873: avalue => l_forward_to_username);
874:
914: funcmode in varchar2,
915: resultout out NOCOPY varchar2) is
916:
917: l_supplier_id number :=
918: wf_engine.GetItemAttrNumber( itemtype => itemtype,
919: itemkey => itemkey,
920: aname => 'SUPPLIER_ID');
921:
922: l_supplier_site_id number :=
919: itemkey => itemkey,
920: aname => 'SUPPLIER_ID');
921:
922: l_supplier_site_id number :=
923: wf_engine.GetItemAttrNumber( itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'SUPPLIER_SITE_ID');
926:
927: CURSOR SUPPLIER_CONTACT_C(p_supplier_id in number,
933: WHERE fu.supplier_id = cont.vendor_contact_id
934: AND cont.vendor_site_id = p_supplier_site_id;
935:
936: l_exception_type number :=
937: wf_engine.GetItemAttrNumber( itemtype => itemtype,
938: itemkey => itemkey,
939: aname => 'EXCEPTION_TYPE_ID');
940:
941: l_person_id number;
959:
960: wf_directory.GetRoleName(l_orig_system, to_char(l_person_id),
961: l_forward_to_username, l_display_username);
962:
963: wf_engine.SetItemAttrText( itemtype => itemtype,
964: itemkey => itemkey,
965: aname => 'MESSAGE_NAME',
966: avalue => GetMessageName(l_exception_type,
967: 1, 'SUPPLIERCNT'));
967: 1, 'SUPPLIERCNT'));
968:
969: if (l_forward_to_username is not null) then
970:
971: wf_engine.SetItemAttrText( itemtype => itemtype,
972: itemkey => itemkey,
973: aname => 'FORWARD_TO_USERNAME',
974: avalue => l_forward_to_username);
975:
1039: AND mgr.demand_id = exp.demand_id
1040: AND exp.exception_id = p_exception_id;
1041:
1042: l_exception_id number :=
1043: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1044: itemkey => itemkey,
1045: aname => 'EXCEPTION_ID');
1046:
1047: l_exception_type number :=
1044: itemkey => itemkey,
1045: aname => 'EXCEPTION_ID');
1046:
1047: l_exception_type number :=
1048: wf_engine.GetitemAttrNumber( itemtype => itemtype,
1049: itemkey => itemkey,
1050: aname => 'EXCEPTION_TYPE_ID');
1051:
1052: l_person_id number;
1066:
1067: wf_directory.GetRoleName('PER', to_char(l_person_id),
1068: l_forward_to_username, l_display_username);
1069:
1070: wf_engine.SetItemAttrText( itemtype => itemtype,
1071: itemkey => itemkey,
1072: aname => 'MESSAGE_NAME',
1073: avalue => GetMessageName(l_exception_type,
1074: to_number(NULL),
1075: 'SALESREP'));
1076:
1077: if (l_forward_to_username is not null) then
1078:
1079: wf_engine.SetItemAttrText( itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'FORWARD_TO_USERNAME',
1082: avalue => l_forward_to_username);
1083:
1123: funcmode in varchar2,
1124: resultout out NOCOPY varchar2) is
1125:
1126: l_customer_id number :=
1127: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'CUSTOMER_ID');
1130:
1131: CURSOR CUSTOMER_CONTACT_C1(p_customer_id in number) IS
1175: end if;
1176:
1177: if (l_forward_to_username is not null) then
1178:
1179: wf_engine.SetItemAttrText( itemtype => itemtype,
1180: itemkey => itemkey,
1181: aname => 'FORWARD_TO_USERNAME',
1182: avalue => l_forward_to_username);
1183:
1241: AND ppp.project_id = proj.project_id
1242: AND proj.segment1 = p_project_number;
1243:
1244: l_task_mgr_number number :=
1245: wf_engine.GetActivityAttrNumber( itemtype => itemtype,
1246: itemkey => itemkey,
1247: actid => actid,
1248: aname => 'WHICH_TASK_MANAGER');
1249:
1247: actid => actid,
1248: aname => 'WHICH_TASK_MANAGER');
1249:
1250: l_project_number varchar2(4000) :=
1251: wf_engine.GetItemAttrText( itemtype => itemtype,
1252: itemkey => itemkey,
1253: aname => 'PROJECT_NUMBER');
1254:
1255: l_to_project_number varchar2(4000) :=
1252: itemkey => itemkey,
1253: aname => 'PROJECT_NUMBER');
1254:
1255: l_to_project_number varchar2(4000) :=
1256: wf_engine.GetItemAttrText( itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'TO_PROJECT_NUMBER');
1259:
1260: l_task_number varchar2(4000) :=
1257: itemkey => itemkey,
1258: aname => 'TO_PROJECT_NUMBER');
1259:
1260: l_task_number varchar2(4000) :=
1261: wf_engine.GetItemAttrText( itemtype => itemtype,
1262: itemkey => itemkey,
1263: aname => 'TASK_NUMBER');
1264:
1265: l_to_task_number varchar2(4000) :=
1262: itemkey => itemkey,
1263: aname => 'TASK_NUMBER');
1264:
1265: l_to_task_number varchar2(4000) :=
1266: wf_engine.GetItemAttrText( itemtype => itemtype,
1267: itemkey => itemkey,
1268: aname => 'TO_TASK_NUMBER');
1269:
1270: l_person_id number;
1307: end if;
1308:
1309: if (l_forward_to_username is not null) then
1310:
1311: wf_engine.SetItemAttrText( itemtype => itemtype,
1312: itemkey => itemkey,
1313: aname => 'FORWARD_TO_USERNAME',
1314: avalue => l_forward_to_username);
1315:
1503: funcmode in varchar2,
1504: resultout out NOCOPY varchar2) is
1505:
1506: l_exception_type number :=
1507: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1508: itemkey => itemkey,
1509: aname => 'EXCEPTION_TYPE_ID');
1510:
1511: BEGIN
1561: funcmode in varchar2,
1562: resultout out NOCOPY varchar2) is
1563:
1564: l_exception_id number :=
1565: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1566: itemkey => itemkey,
1567: aname => 'EXCEPTION_ID');
1568:
1569: l_order_type number :=
1566: itemkey => itemkey,
1567: aname => 'EXCEPTION_ID');
1568:
1569: l_order_type number :=
1570: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1571: itemkey => itemkey,
1572: aname => 'ORDER_TYPE_CODE');
1573:
1574:
1631: funcmode in varchar2,
1632: resultout out NOCOPY varchar2) is
1633:
1634: l_exception_id number :=
1635: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1636: itemkey => itemkey,
1637: aname => 'EXCEPTION_ID');
1638:
1639: l_compile_designator varchar2(10) :=
1636: itemkey => itemkey,
1637: aname => 'EXCEPTION_ID');
1638:
1639: l_compile_designator varchar2(10) :=
1640: wf_engine.GetItemAttrText( itemtype => itemtype,
1641: itemkey => itemkey,
1642: aname => 'PLAN_NAME');
1643:
1644: l_organization_id number :=
1641: itemkey => itemkey,
1642: aname => 'PLAN_NAME');
1643:
1644: l_organization_id number :=
1645: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'ORGANIZATION_ID');
1648:
1649: l_exception_type number :=
1646: itemkey => itemkey,
1647: aname => 'ORGANIZATION_ID');
1648:
1649: l_exception_type number :=
1650: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1651: itemkey => itemkey,
1652: aname => 'EXCEPTION_TYPE_ID');
1653:
1654: l_order_type number :=
1651: itemkey => itemkey,
1652: aname => 'EXCEPTION_TYPE_ID');
1653:
1654: l_order_type number :=
1655: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1656: itemkey => itemkey,
1657: aname => 'ORDER_TYPE_CODE');
1658:
1659: l_owning_org_id number;
1693: IF (funcmode = 'RUN') THEN
1694:
1695: /** Bug 2226979 **/
1696: IF l_user_id < 1 THEN -- get a valid responsibility for this user
1697: l_assigned_user := wf_engine.GetItemAttrText( itemtype => itemtype,
1698: itemkey => itemkey,
1699: aname => 'FORWARD_TO_USERNAME');
1700:
1701: SELECT g.responsibility_id, g.user_id, g.responsibility_application_id
1811: l_req_load_id, l_req_resched_id,
1812: 'WF', l_transaction_id);
1813:
1814: if nvl(l_wip_req_id,0) > 0 then
1815: wf_engine.additemattr(itemtype,
1816: itemkey,
1817: 'WIP_REQ_ID',
1818: null,
1819: l_wip_req_id,
1819: l_wip_req_id,
1820: null);
1821: end if;
1822: if nvl(l_req_load_id,0) > 0 then
1823: wf_engine.additemattr(itemtype,
1824: itemkey,
1825: 'REQ_LOAD_REQ_ID',
1826: null,
1827: l_req_load_id,
1827: l_req_load_id,
1828: null);
1829: end if;
1830: if nvl(l_req_resched_id,0) > 0 then
1831: wf_engine.additemattr(itemtype,
1832: itemkey,
1833: 'REQ_RESCHED_REQ_ID',
1834: null,
1835: l_req_resched_id,
1873: funcmode in varchar2,
1874: resultout out NOCOPY varchar2) is
1875:
1876: l_exception_type number :=
1877: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1878: itemkey => itemkey,
1879: aname => 'EXCEPTION_TYPE_ID');
1880:
1881: BEGIN
2026: -- AND item_key = l_item_key;
2027:
2028: -- if (l_activity_count > 0) then
2029:
2030: wf_engine.ItemStatus('MRPEXPWF', l_item_key, l_wf_status, l_wf_result);
2031:
2032: -- A process might be completed but there could be open notifications
2033:
2034: if (l_wf_status = wf_engine.eng_completed) then
2030: wf_engine.ItemStatus('MRPEXPWF', l_item_key, l_wf_status, l_wf_result);
2031:
2032: -- A process might be completed but there could be open notifications
2033:
2034: if (l_wf_status = wf_engine.eng_completed) then
2035:
2036: OPEN CANCEL_NOTIFICATIONS_C('MRPEXPWF', l_item_key);
2037: LOOP
2038: FETCH CANCEL_NOTIFICATIONS_C INTO l_notification_id;
2042: CLOSE CANCEL_NOTIFICATIONS_C;
2043:
2044: -- Cancel all notifications within process and process itself
2045: else
2046: wf_engine.AbortProcess('MRPEXPWF', l_item_key);
2047:
2048: end if;
2049:
2050: PurgeActivities('MRPEXPWF', l_item_key);