600: ,p_process_name => p_processName );
601:
602:
603: -- Kick off the workflow process.
604: wf_engine.CreateProcess (p_itemtype,l_itemkey,p_processName);
605:
606:
607: if p_currentUser is not null then
608: wf_engine.SetItemOwner(p_itemtype,l_itemkey,p_currentUser);
604: wf_engine.CreateProcess (p_itemtype,l_itemkey,p_processName);
605:
606:
607: if p_currentUser is not null then
608: wf_engine.SetItemOwner(p_itemtype,l_itemkey,p_currentUser);
609: end if;
610:
611: -- Get Process Display Name
612: Open csr_prc;
612: Open csr_prc;
613: Fetch csr_prc into l_processDisplayName;
614: Close csr_prc;
615:
616: wf_engine.SetItemAttrText (
617: itemtype => p_itemType
618: ,itemkey => l_ItemKey
619: ,aname => 'TRANSACTION_NAME'
620: ,avalue => l_processDisplayName);
619: ,aname => 'TRANSACTION_NAME'
620: ,avalue => l_processDisplayName);
621:
622: -- Set the route by user (appears in from on worklist)
623: wf_engine.SetItemAttrText (
624: itemtype => p_itemType
625: ,itemkey => l_ItemKey
626: ,aname => 'ROUTED_BY_USER'
627: ,avalue => p_currentUser);
626: ,aname => 'ROUTED_BY_USER'
627: ,avalue => p_currentUser);
628:
629: -- Set the electable choice id
630: wf_engine.SetItemAttrText (
631: itemtype => p_itemType
632: ,itemkey => l_ItemKey
633: ,aname => 'PARAMETER1_VALUE'
634: ,avalue => p_elctbl_chc_id);
634: ,avalue => p_elctbl_chc_id);
635:
636: -- set the comments entered -- 9654222
637:
638: wf_engine.SetItemAttrText (
639: itemtype => p_itemType
640: ,itemkey => l_ItemKey
641: ,aname => 'APPROVAL_COMMENT_COPY'
642: ,avalue => p_comments);
641: ,aname => 'APPROVAL_COMMENT_COPY'
642: ,avalue => p_comments);
643:
644: -- Set the person Id
645: wf_engine.SetItemAttrText (
646: itemtype => p_itemType
647: ,itemkey => l_ItemKey
648: ,aname => 'PERSON_ID'
649: ,avalue => p_person_id );
648: ,aname => 'PERSON_ID'
649: ,avalue => p_person_id );
650:
651: -- Set the person name
652: wf_engine.SetItemAttrText (
653: itemtype => p_itemType
654: ,itemkey => l_ItemKey
655: ,aname => 'PSV_PERSON_NAME'
656: ,avalue => p_person_name );
655: ,aname => 'PSV_PERSON_NAME'
656: ,avalue => p_person_name );
657:
658: -- Set the AME Transaction Type
659: wf_engine.SetItemAttrText (
660: itemtype => p_itemType
661: ,itemkey => l_ItemKey
662: ,aname => 'PARAMETER2_VALUE'
663: ,avalue => p_AMETranType );
662: ,aname => 'PARAMETER2_VALUE'
663: ,avalue => p_AMETranType );
664:
665: -- Set the AME Application Id
666: wf_engine.SetItemAttrText (
667: itemtype => p_itemType
668: ,itemkey => l_ItemKey
669: ,aname => 'PARAMETER3_VALUE'
670: ,avalue => p_AMEAppId );
668: ,itemkey => l_ItemKey
669: ,aname => 'PARAMETER3_VALUE'
670: ,avalue => p_AMEAppId );
671:
672: wf_engine.StartProcess (p_itemtype,l_itemkey);
673:
674: end if;
675: Exception
676: When Others Then