APPS.GMD_QM_UOM dependencies on WF_ENGINE

Line 17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

13: p_funcmode IN VARCHAR2,
14: p_resultout OUT NOCOPY VARCHAR2)
15:
16: IS
17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
22: itemtype=>p_itemtype,
23: itemkey=>P_itemkey,
24: aname=>'EVENT_KEY');
25:

Line 450: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

446: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
447:
448: l_workflow_process:='GMDQMUOM_SUB_PROCESS';
449:
450: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
451: itemkey => l_itemkey,
452: process => l_workflow_process );
453:
454: /* Set the User Attribute */

Line 456: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

452: process => l_workflow_process );
453:
454: /* Set the User Attribute */
455:
456: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
457: aname => '#FROM_ROLE',
458: avalue => l_user );
459:
460: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

Line 460: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

456: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
457: aname => '#FROM_ROLE',
458: avalue => l_user );
459:
460: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
461: aname => 'CURRENT_APPROVER',
462: avalue => l_user);
463: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
464: aname => 'APPS_FORM',

Line 463: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

459:
460: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
461: aname => 'CURRENT_APPROVER',
462: avalue => l_user);
463: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
464: aname => 'APPS_FORM',
465: avalue =>l_form );
466: /* Set All other Attributes */
467: -- SCHANDRU INVCONV START

Line 469: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

465: avalue =>l_form );
466: /* Set All other Attributes */
467: -- SCHANDRU INVCONV START
468:
469: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
470: aname => 'ITEM_REVISION',
471: avalue =>l_item_revision );
472: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => l_itemkey,
473: aname => 'ITEM_REVISION',

Line 472: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => l_itemkey,

468:
469: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
470: aname => 'ITEM_REVISION',
471: avalue =>l_item_revision );
472: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => l_itemkey,
473: aname => 'ITEM_REVISION',
474: avalue =>l_item_revision );
475: -- SCHANDRU INVCONV END
476:

Line 477: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

473: aname => 'ITEM_REVISION',
474: avalue =>l_item_revision );
475: -- SCHANDRU INVCONV END
476:
477: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
478: aname => 'EVENT_KEY',
479: avalue =>l_event_key );
480: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
481: aname => 'EVENT_NAME',

Line 480: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

476:
477: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
478: aname => 'EVENT_KEY',
479: avalue =>l_event_key );
480: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
481: aname => 'EVENT_NAME',
482: avalue =>l_event_name );
483:
484: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 484: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

480: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
481: aname => 'EVENT_NAME',
482: avalue =>l_event_name );
483:
484: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
485: aname => 'SOURCE',
486: avalue =>l_source );
487: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
488: aname => 'SAMPLES_TAKEN',

Line 487: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

483:
484: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
485: aname => 'SOURCE',
486: avalue =>l_source );
487: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
488: aname => 'SAMPLES_TAKEN',
489: avalue =>l_samples_taken );
490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
491: aname => 'SAMPLE_GRP_DISP',

Line 490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

486: avalue =>l_source );
487: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
488: aname => 'SAMPLES_TAKEN',
489: avalue =>l_samples_taken );
490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
491: aname => 'SAMPLE_GRP_DISP',
492: avalue =>l_disposition );
493: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
494: aname => 'ITEM_NO',

Line 493: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

489: avalue =>l_samples_taken );
490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
491: aname => 'SAMPLE_GRP_DISP',
492: avalue =>l_disposition );
493: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
494: aname => 'ITEM_NO',
495: avalue =>l_item_no );
496: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
497: aname => 'LOT_NO',

Line 496: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

492: avalue =>l_disposition );
493: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
494: aname => 'ITEM_NO',
495: avalue =>l_item_no );
496: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
497: aname => 'LOT_NO',
498: avalue =>l_lot_no );
499:
500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

496: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
497: aname => 'LOT_NO',
498: avalue =>l_lot_no );
499:
500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
501: aname => 'ORGANIZATION',
502: avalue =>l_orgn_code );
503: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
504: aname => 'SUBINVENTORY',

Line 503: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

499:
500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
501: aname => 'ORGANIZATION',
502: avalue =>l_orgn_code );
503: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
504: aname => 'SUBINVENTORY',
505: avalue =>l_subinventory );
506: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
507: aname => 'LOCATOR',

Line 506: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

502: avalue =>l_orgn_code );
503: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
504: aname => 'SUBINVENTORY',
505: avalue =>l_subinventory );
506: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
507: aname => 'LOCATOR',
508: avalue =>l_locator );
509: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
510: aname => 'SUPPLIER',

Line 509: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

505: avalue =>l_subinventory );
506: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
507: aname => 'LOCATOR',
508: avalue =>l_locator );
509: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
510: aname => 'SUPPLIER',
511: avalue =>l_supplier );
512: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
513: aname => 'SUPPLIER_LOT',

Line 512: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

508: avalue =>l_locator );
509: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
510: aname => 'SUPPLIER',
511: avalue =>l_supplier );
512: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
513: aname => 'SUPPLIER_LOT',
514: avalue =>l_supplier_lot );
515: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
516: aname => 'PO_NUMBER',

Line 515: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

511: avalue =>l_supplier );
512: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
513: aname => 'SUPPLIER_LOT',
514: avalue =>l_supplier_lot );
515: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
516: aname => 'PO_NUMBER',
517: avalue =>l_po_num );
518: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
519: aname => 'PO_LINE_NO',

Line 518: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

514: avalue =>l_supplier_lot );
515: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
516: aname => 'PO_NUMBER',
517: avalue =>l_po_num );
518: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
519: aname => 'PO_LINE_NO',
520: avalue =>l_po_line_num );
521: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
522: aname => 'RECEIPT_NO',

Line 521: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

517: avalue =>l_po_num );
518: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
519: aname => 'PO_LINE_NO',
520: avalue =>l_po_line_num );
521: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
522: aname => 'RECEIPT_NO',
523: avalue =>l_receipt_num );
524: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
525: aname => 'RECEIPT_LINE_NO',

Line 524: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

520: avalue =>l_po_line_num );
521: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
522: aname => 'RECEIPT_NO',
523: avalue =>l_receipt_num );
524: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
525: aname => 'RECEIPT_LINE_NO',
526: avalue =>l_receipt_line_num );
527: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
528: aname => 'SPEC',

Line 527: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

523: avalue =>l_receipt_num );
524: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
525: aname => 'RECEIPT_LINE_NO',
526: avalue =>l_receipt_line_num );
527: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
528: aname => 'SPEC',
529: avalue =>l_spec_name );
530: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
531: aname => 'SPEC_VERSION',

Line 530: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

526: avalue =>l_receipt_line_num );
527: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
528: aname => 'SPEC',
529: avalue =>l_spec_name );
530: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
531: aname => 'SPEC_VERSION',
532: avalue =>l_spec_vers );
533: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
534: aname => 'TEST_NAME',

Line 533: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

529: avalue =>l_spec_name );
530: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
531: aname => 'SPEC_VERSION',
532: avalue =>l_spec_vers );
533: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
534: aname => 'TEST_NAME',
535: avalue =>l_test_name );
536: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
537: aname => 'FROM_UOM',

Line 536: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

532: avalue =>l_spec_vers );
533: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
534: aname => 'TEST_NAME',
535: avalue =>l_test_name );
536: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
537: aname => 'FROM_UOM',
538: avalue =>l_from_uom );
539: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
540: aname => 'PROPOSED_CONVERSION',

Line 539: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

535: avalue =>l_test_name );
536: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
537: aname => 'FROM_UOM',
538: avalue =>l_from_uom );
539: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
540: aname => 'PROPOSED_CONVERSION',
541: avalue =>l_propose_conv );
542: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
543: aname => 'TO_UOM',

Line 542: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

538: avalue =>l_from_uom );
539: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
540: aname => 'PROPOSED_CONVERSION',
541: avalue =>l_propose_conv );
542: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
543: aname => 'TO_UOM',
544: avalue =>l_TO_UOM );
545:
546: l_conversion := '1 '|| l_from_uom || ' = ' || l_propose_conv || ' ' || l_TO_UOM ;

Line 547: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

543: aname => 'TO_UOM',
544: avalue =>l_TO_UOM );
545:
546: l_conversion := '1 '|| l_from_uom || ' = ' || l_propose_conv || ' ' || l_TO_UOM ;
547: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
548: itemkey => l_itemkey,
549: aname => 'CONVERSION',
550: avalue => l_conversion );
551:

Line 553: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

549: aname => 'CONVERSION',
550: avalue => l_conversion );
551:
552:
553: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
554: aname => 'AME_TRANS',
555: avalue =>l_transaction_type);
556:
557:

Line 561: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,

557:
558: wf_log_pkg.string(6, 'Dummy','Setting Parent');
559:
560:
561: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
562: parent_itemtype => p_itemtype,
563: parent_itemkey=> p_itemkey,
564: parent_context=> NULL);
565:

Line 578: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

574: transactionTypeIn => l_transaction_type,
575: forwardeeIn => ame_util.emptyApproverRecord);
576:
577:
578: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
579:
580:
581: elsif(l_parent_lot_no is not null) then
582:

Line 618: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

614: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
615:
616: l_workflow_process:='GMDQMUOM_SUB_PROCESS';
617:
618: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
619: itemkey => l_itemkey,
620: process => l_workflow_process );
621:
622: /* Set the User Attribute */

Line 624: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

620: process => l_workflow_process );
621:
622: /* Set the User Attribute */
623:
624: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
625: aname => 'CURRENT_APPROVER',
626: avalue => l_user);
627: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
628: aname => 'APPS_FORM',

Line 627: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

623:
624: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
625: aname => 'CURRENT_APPROVER',
626: avalue => l_user);
627: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
628: aname => 'APPS_FORM',
629: avalue =>l_form );
630: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
631: aname => '#FROM_ROLE',

Line 630: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

626: avalue => l_user);
627: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
628: aname => 'APPS_FORM',
629: avalue =>l_form );
630: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
631: aname => '#FROM_ROLE',
632: avalue => l_user );
633:
634:

Line 637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

633:
634:
635: /* Set All other Attributes */
636: -- SCHANDRU INVCONV START
637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
638: aname => 'ITEM_REVISION',
639: avalue =>l_item_revision );
640: -- SCHANDRU INVCONV END
641: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 641: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
638: aname => 'ITEM_REVISION',
639: avalue =>l_item_revision );
640: -- SCHANDRU INVCONV END
641: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
642: aname => 'EVENT_KEY',
643: avalue =>l_event_key );
644: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
645: aname => 'EVENT_NAME',

Line 644: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

640: -- SCHANDRU INVCONV END
641: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
642: aname => 'EVENT_KEY',
643: avalue =>l_event_key );
644: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
645: aname => 'EVENT_NAME',
646: avalue =>l_event_name );
647:
648: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 648: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

644: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
645: aname => 'EVENT_NAME',
646: avalue =>l_event_name );
647:
648: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
649: aname => 'SOURCE',
650: avalue =>l_source );
651: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
652: aname => 'SAMPLES_TAKEN',

Line 651: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

647:
648: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
649: aname => 'SOURCE',
650: avalue =>l_source );
651: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
652: aname => 'SAMPLES_TAKEN',
653: avalue =>l_samples_taken );
654: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
655: aname => 'SAMPLE_GRP_DISP',

Line 654: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

650: avalue =>l_source );
651: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
652: aname => 'SAMPLES_TAKEN',
653: avalue =>l_samples_taken );
654: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
655: aname => 'SAMPLE_GRP_DISP',
656: avalue =>l_disposition );
657: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
658: aname => 'ITEM_NO',

Line 657: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

653: avalue =>l_samples_taken );
654: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
655: aname => 'SAMPLE_GRP_DISP',
656: avalue =>l_disposition );
657: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
658: aname => 'ITEM_NO',
659: avalue =>l_item_no );
660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
661: aname => 'LOT_NO',

Line 660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

656: avalue =>l_disposition );
657: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
658: aname => 'ITEM_NO',
659: avalue =>l_item_no );
660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
661: aname => 'LOT_NO',
662: avalue =>l_lot_no );
663:
664: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 664: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
661: aname => 'LOT_NO',
662: avalue =>l_lot_no );
663:
664: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
665: aname => 'ORGANIZATION',
666: avalue =>l_orgn_code );
667: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
668: aname => 'SUBINVENTORY',

Line 667: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

663:
664: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
665: aname => 'ORGANIZATION',
666: avalue =>l_orgn_code );
667: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
668: aname => 'SUBINVENTORY',
669: avalue =>l_subinventory );
670: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
671: aname => 'LOCATOR',

Line 670: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

666: avalue =>l_orgn_code );
667: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
668: aname => 'SUBINVENTORY',
669: avalue =>l_subinventory );
670: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
671: aname => 'LOCATOR',
672: avalue =>l_locator );
673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
674: aname => 'SUPPLIER',

Line 673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

669: avalue =>l_subinventory );
670: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
671: aname => 'LOCATOR',
672: avalue =>l_locator );
673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
674: aname => 'SUPPLIER',
675: avalue =>l_supplier );
676: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
677: aname => 'SUPPLIER_LOT',

Line 676: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

672: avalue =>l_locator );
673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
674: aname => 'SUPPLIER',
675: avalue =>l_supplier );
676: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
677: aname => 'SUPPLIER_LOT',
678: avalue =>l_supplier_lot );
679: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
680: aname => 'PO_NUMBER',

Line 679: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

675: avalue =>l_supplier );
676: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
677: aname => 'SUPPLIER_LOT',
678: avalue =>l_supplier_lot );
679: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
680: aname => 'PO_NUMBER',
681: avalue =>l_po_num );
682: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
683: aname => 'PO_LINE_NO',

Line 682: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

678: avalue =>l_supplier_lot );
679: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
680: aname => 'PO_NUMBER',
681: avalue =>l_po_num );
682: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
683: aname => 'PO_LINE_NO',
684: avalue =>l_po_line_num );
685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
686: aname => 'RECEIPT_NO',

Line 685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

681: avalue =>l_po_num );
682: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
683: aname => 'PO_LINE_NO',
684: avalue =>l_po_line_num );
685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
686: aname => 'RECEIPT_NO',
687: avalue =>l_receipt_num );
688: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
689: aname => 'RECEIPT_LINE_NO',

Line 688: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

684: avalue =>l_po_line_num );
685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
686: aname => 'RECEIPT_NO',
687: avalue =>l_receipt_num );
688: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
689: aname => 'RECEIPT_LINE_NO',
690: avalue =>l_receipt_line_num );
691: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
692: aname => 'SPEC',

Line 691: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

687: avalue =>l_receipt_num );
688: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
689: aname => 'RECEIPT_LINE_NO',
690: avalue =>l_receipt_line_num );
691: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
692: aname => 'SPEC',
693: avalue =>l_spec_name );
694: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
695: aname => 'SPEC_VERSION',

Line 694: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

690: avalue =>l_receipt_line_num );
691: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
692: aname => 'SPEC',
693: avalue =>l_spec_name );
694: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
695: aname => 'SPEC_VERSION',
696: avalue =>l_spec_vers );
697: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
698: aname => 'TEST_NAME',

Line 697: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

693: avalue =>l_spec_name );
694: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
695: aname => 'SPEC_VERSION',
696: avalue =>l_spec_vers );
697: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
698: aname => 'TEST_NAME',
699: avalue =>l_test_name );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
701: aname => 'FROM_UOM',

Line 700: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

696: avalue =>l_spec_vers );
697: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
698: aname => 'TEST_NAME',
699: avalue =>l_test_name );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
701: aname => 'FROM_UOM',
702: avalue =>l_from_uom );
703: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
704: aname => 'PROPOSED_CONVERSION',

Line 703: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

699: avalue =>l_test_name );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
701: aname => 'FROM_UOM',
702: avalue =>l_from_uom );
703: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
704: aname => 'PROPOSED_CONVERSION',
705: avalue =>l_propose_conv );
706: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
707: aname => 'TO_UOM',

Line 706: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

702: avalue =>l_from_uom );
703: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
704: aname => 'PROPOSED_CONVERSION',
705: avalue =>l_propose_conv );
706: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
707: aname => 'TO_UOM',
708: avalue =>l_TO_UOM );
709: l_conversion := '1 '|| l_from_uom || ' = ' || l_propose_conv
710: || ' ' || l_TO_UOM ;

Line 711: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

707: aname => 'TO_UOM',
708: avalue =>l_TO_UOM );
709: l_conversion := '1 '|| l_from_uom || ' = ' || l_propose_conv
710: || ' ' || l_TO_UOM ;
711: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
712: itemkey => l_itemkey,
713: aname => 'CONVERSION',
714: avalue => l_conversion );
715:

Line 716: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

712: itemkey => l_itemkey,
713: aname => 'CONVERSION',
714: avalue => l_conversion );
715:
716: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
717: aname => 'AME_TRANS',
718: avalue =>l_transaction_type);
719:
720:

Line 724: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,

720:
721: wf_log_pkg.string(6, 'Dummy','Setting Parent');
722:
723:
724: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
725: parent_itemtype => p_itemtype,
726: parent_itemkey=> p_itemkey,
727: parent_context=> NULL);
728:

Line 741: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

737: transactionTypeIn => l_transaction_type,
738: forwardeeIn => ame_util.emptyApproverRecord);
739:
740:
741: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
742:
743:
744: end loop ;
745: close get_child_lots;

Line 775: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

771: p_funcmode IN VARCHAR2,
772: p_resultout OUT NOCOPY VARCHAR2)
773:
774: IS
775: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
776: itemtype=>p_itemtype,
777: itemkey=>P_itemkey,
778: aname=>'EVENT_NAME');
779: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 779: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

775: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
776: itemtype=>p_itemtype,
777: itemkey=>P_itemkey,
778: aname=>'EVENT_NAME');
779: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
780: itemtype=>p_itemtype,
781: itemkey=>P_itemkey,
782: aname=>'EVENT_KEY');
783:

Line 787: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(

783:
784: l_current_approver varchar2(240);
785:
786: l_application_id number;
787: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
788: itemtype=>p_itemtype,
789: itemkey=>P_itemkey,
790: aname=>'AME_TRANS');
791: l_user varchar2(32);

Line 821: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

817: end if;
818:
819: /* Set the User Attribute */
820:
821: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
822: aname => 'CURRENT_APPROVER',
823: avalue => l_user);
824:
825: P_resultout:='COMPLETE:Y';