104: IF (g_po_wf_debug = 'Y') THEN
105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
106: END IF;
107:
108: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'DOCUMENT_ID');
111:
112: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
108: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'DOCUMENT_ID');
111:
112: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
113: itemkey => itemkey,
114: aname => 'AME_TRANSACTION_TYPE');
115:
116: l_interface_source := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
249: IF (g_po_wf_debug = 'Y') THEN
250: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
251: END IF;
252:
253: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
254: itemkey => itemkey,
255: aname => 'DOCUMENT_TYPE');
256:
257: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
253: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
254: itemkey => itemkey,
255: aname => 'DOCUMENT_TYPE');
256:
257: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
258: itemkey => itemkey,
259: aname => 'DOCUMENT_SUBTYPE');
260:
261:
460: IF (g_po_wf_debug = 'Y') THEN
461: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
462: END IF;
463:
464: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'DOCUMENT_ID');
467:
468: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
464: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'DOCUMENT_ID');
467:
468: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'DOCUMENT_TYPE');
471:
472: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
468: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'DOCUMENT_TYPE');
471:
472: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
473: itemkey => itemkey,
474: aname => 'DOCUMENT_SUBTYPE');
475:
476: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
472: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
473: itemkey => itemkey,
474: aname => 'DOCUMENT_SUBTYPE');
475:
476: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
477: itemkey => itemkey,
478: aname => 'AME_TRANSACTION_TYPE');
479:
480:
513: IF (g_po_wf_debug = 'Y') THEN
514: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
515: END IF;
516:
517: wf_engine.SetItemAttrNumber ( itemtype => itemType,
518: itemkey => itemkey,
519: aname => 'APPROVER_EMPID',
520: avalue => l_next_approver_id);
521:
519: aname => 'APPROVER_EMPID',
520: avalue => l_next_approver_id);
521:
522:
523: wf_engine.SetItemAttrNumber ( itemtype => itemType,
524: itemkey => itemkey,
525: aname => 'FORWARD_TO_ID',
526: avalue => l_next_approver_id);
527: wf_engine.SetItemAttrText( itemtype => itemType,
523: wf_engine.SetItemAttrNumber ( itemtype => itemType,
524: itemkey => itemkey,
525: aname => 'FORWARD_TO_ID',
526: avalue => l_next_approver_id);
527: wf_engine.SetItemAttrText( itemtype => itemType,
528: itemkey => itemkey,
529: aname => 'AME_INSERTION_TYPE' ,
530: avalue => l_insertion_type);
531:
528: itemkey => itemkey,
529: aname => 'AME_INSERTION_TYPE' ,
530: avalue => l_insertion_type);
531:
532: wf_engine.SetItemAttrText( itemtype => itemType,
533: itemkey => itemkey,
534: aname => 'AME_AUTHORITY_TYPE' ,
535: avalue => l_authority_type);
536:
547: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
548: END IF;
549:
550:
551: wf_engine.SetItemAttrText( itemtype => itemType,
552: itemkey => itemkey,
553: aname => 'APPROVER_USER_NAME' ,
554: avalue => l_next_approver_user_name);
555:
552: itemkey => itemkey,
553: aname => 'APPROVER_USER_NAME' ,
554: avalue => l_next_approver_user_name);
555:
556: wf_engine.SetItemAttrText( itemtype => itemType,
557: itemkey => itemkey,
558: aname => 'APPROVER_DISPLAY_NAME' ,
559: avalue => l_next_approver_disp_name);
560:
557: itemkey => itemkey,
558: aname => 'APPROVER_DISPLAY_NAME' ,
559: avalue => l_next_approver_disp_name);
560:
561: wf_engine.SetItemAttrText( itemtype => itemType,
562: itemkey => itemkey,
563: aname => 'FORWARD_TO_USERNAME' ,
564: avalue => l_next_approver_user_name);
565:
562: itemkey => itemkey,
563: aname => 'FORWARD_TO_USERNAME' ,
564: avalue => l_next_approver_user_name);
565:
566: wf_engine.SetItemAttrText( itemtype => itemType,
567: itemkey => itemkey,
568: aname => 'FORWARD_TO_DISPLAY_NAME' ,
569: avalue => l_next_approver_disp_name);
570:
648: response =>l_value,
649: responseEndDate =>l_end_date,
650: forwardToId => l_forward_to_id);
651:
652: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'DOCUMENT_ID');
655:
656: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
652: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'DOCUMENT_ID');
655:
656: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
657: itemkey => itemkey,
658: aname => 'DOCUMENT_TYPE');
659:
660: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
656: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
657: itemkey => itemkey,
658: aname => 'DOCUMENT_TYPE');
659:
660: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'DOCUMENT_SUBTYPE');
663:
664: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
660: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'DOCUMENT_SUBTYPE');
663:
664: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
665: itemkey=>itemkey,
666: aname=>'APPROVER_EMPID');
667:
668: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
664: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
665: itemkey=>itemkey,
666: aname=>'APPROVER_EMPID');
667:
668: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
669: itemkey => itemkey,
670: aname => 'AME_INSERTION_TYPE');
671:
672: l_authority_type := wf_engine.GetItemAttrText(itemtype => itemtype,
668: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
669: itemkey => itemkey,
670: aname => 'AME_INSERTION_TYPE');
671:
672: l_authority_type := wf_engine.GetItemAttrText(itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'AME_AUTHORITY_TYPE');
675:
676: l_progress := 'Update_Approval_List_Response: 010 APP'||
683: IF (g_po_wf_debug = 'Y') THEN
684: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
685: END IF;
686:
687: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'AME_TRANSACTION_TYPE');
690:
691: updateApprovalListResponse(itemtype=>itemtype,
765: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
766: END IF;
767:
768: IF (funcmode='RUN') THEN
769: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
770: itemkey => itemkey,
771: aname => 'DOCUMENT_ID');
772:
773: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
769: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
770: itemkey => itemkey,
771: aname => 'DOCUMENT_ID');
772:
773: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
774: itemkey => itemkey,
775: aname => 'DOCUMENT_TYPE');
776:
777: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
773: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
774: itemkey => itemkey,
775: aname => 'DOCUMENT_TYPE');
776:
777: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'DOCUMENT_SUBTYPE');
780:
781: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
777: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'DOCUMENT_SUBTYPE');
780:
781: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
782: itemkey=>itemkey,
783: aname=>'APPROVER_EMPID');
784:
785: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
781: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
782: itemkey=>itemkey,
783: aname=>'APPROVER_EMPID');
784:
785: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
786: itemkey => itemkey,
787: aname => 'AME_TRANSACTION_TYPE');
788: updateApprovalListResponse(itemtype=>itemtype,
789: itemkey=>itemkey,