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

Line 424: wf_engine.CreateProcess( itemtype => item_type,

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,

Line 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:

Line 433: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 438: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 443: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 448: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 453: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 458: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 463: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 468: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 473: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 478: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 483: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 488: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 493: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 498: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 503: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 508: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 513: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 518: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 523: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 528: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 533: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 538: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 543: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 548: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 553: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 558: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 563: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 568: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 573: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

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

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:

Line 583: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 588: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 593: wf_engine.SetItemAttrText( itemtype => item_type,

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=' ||

Line 601: wf_engine.StartProcess( itemtype => item_type,

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:

Line 629: wf_engine.GetItemAttrText( itemtype => itemtype,

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 :=

Line 634: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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;

Line 711: wf_engine.GetItemAttrText( itemtype => itemtype,

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 :=

Line 716: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 721: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 726: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 731: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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;

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

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,

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

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:

Line 819: wf_engine.GetItemAttrText( itemtype => itemtype,

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 :=

Line 824: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 829: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 834: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 839: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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;

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

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,

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

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:

Line 918: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 923: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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,

Line 937: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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;

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

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'));

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

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:

Line 1043: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 1048: wf_engine.GetitemAttrNumber( itemtype => itemtype,

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;

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

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),

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

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:

Line 1127: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

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

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:

Line 1245: wf_engine.GetActivityAttrNumber( itemtype => itemtype,

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:

Line 1251: wf_engine.GetItemAttrText( itemtype => itemtype,

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) :=

Line 1256: wf_engine.GetItemAttrText( itemtype => itemtype,

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) :=

Line 1261: wf_engine.GetItemAttrText( itemtype => itemtype,

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) :=

Line 1266: wf_engine.GetItemAttrText( itemtype => itemtype,

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;

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

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:

Line 1507: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

Line 1565: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 1570: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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:

Line 1635: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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) :=

Line 1640: wf_engine.GetItemAttrText( itemtype => itemtype,

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 :=

Line 1645: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 1650: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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 :=

Line 1655: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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;

Line 1697: l_assigned_user := wf_engine.GetItemAttrText( itemtype => itemtype,

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

Line 1815: wf_engine.additemattr(itemtype,

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,

Line 1823: wf_engine.additemattr(itemtype,

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,

Line 1831: wf_engine.additemattr(itemtype,

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,

Line 1877: wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

Line 2030: wf_engine.ItemStatus('MRPEXPWF', l_item_key, l_wf_status, l_wf_result);

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

Line 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;

Line 2046: wf_engine.AbortProcess('MRPEXPWF', l_item_key);

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);