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,
226: IF (g_po_wf_debug = 'Y') THEN
227: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
228: END IF;
229:
230: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'DOCUMENT_TYPE');
233:
234: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
230: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'DOCUMENT_TYPE');
233:
234: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
235: itemkey => itemkey,
236: aname => 'DOCUMENT_SUBTYPE');
237:
238:
437: IF (g_po_wf_debug = 'Y') THEN
438: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
439: END IF;
440:
441: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'DOCUMENT_ID');
444:
445: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
441: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'DOCUMENT_ID');
444:
445: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'DOCUMENT_TYPE');
448:
449: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
445: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'DOCUMENT_TYPE');
448:
449: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'DOCUMENT_SUBTYPE');
452:
453: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
449: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'DOCUMENT_SUBTYPE');
452:
453: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'AME_TRANSACTION_TYPE');
456:
457:
490: IF (g_po_wf_debug = 'Y') THEN
491: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
492: END IF;
493:
494: wf_engine.SetItemAttrNumber ( itemtype => itemType,
495: itemkey => itemkey,
496: aname => 'APPROVER_EMPID',
497: avalue => l_next_approver_id);
498:
496: aname => 'APPROVER_EMPID',
497: avalue => l_next_approver_id);
498:
499:
500: wf_engine.SetItemAttrNumber ( itemtype => itemType,
501: itemkey => itemkey,
502: aname => 'FORWARD_TO_ID',
503: avalue => l_next_approver_id);
504: wf_engine.SetItemAttrText( itemtype => itemType,
500: wf_engine.SetItemAttrNumber ( itemtype => itemType,
501: itemkey => itemkey,
502: aname => 'FORWARD_TO_ID',
503: avalue => l_next_approver_id);
504: wf_engine.SetItemAttrText( itemtype => itemType,
505: itemkey => itemkey,
506: aname => 'AME_INSERTION_TYPE' ,
507: avalue => l_insertion_type);
508:
505: itemkey => itemkey,
506: aname => 'AME_INSERTION_TYPE' ,
507: avalue => l_insertion_type);
508:
509: wf_engine.SetItemAttrText( itemtype => itemType,
510: itemkey => itemkey,
511: aname => 'AME_AUTHORITY_TYPE' ,
512: avalue => l_authority_type);
513:
524: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
525: END IF;
526:
527:
528: wf_engine.SetItemAttrText( itemtype => itemType,
529: itemkey => itemkey,
530: aname => 'APPROVER_USER_NAME' ,
531: avalue => l_next_approver_user_name);
532:
529: itemkey => itemkey,
530: aname => 'APPROVER_USER_NAME' ,
531: avalue => l_next_approver_user_name);
532:
533: wf_engine.SetItemAttrText( itemtype => itemType,
534: itemkey => itemkey,
535: aname => 'APPROVER_DISPLAY_NAME' ,
536: avalue => l_next_approver_disp_name);
537:
534: itemkey => itemkey,
535: aname => 'APPROVER_DISPLAY_NAME' ,
536: avalue => l_next_approver_disp_name);
537:
538: wf_engine.SetItemAttrText( itemtype => itemType,
539: itemkey => itemkey,
540: aname => 'FORWARD_TO_USERNAME' ,
541: avalue => l_next_approver_user_name);
542:
539: itemkey => itemkey,
540: aname => 'FORWARD_TO_USERNAME' ,
541: avalue => l_next_approver_user_name);
542:
543: wf_engine.SetItemAttrText( itemtype => itemType,
544: itemkey => itemkey,
545: aname => 'FORWARD_TO_DISPLAY_NAME' ,
546: avalue => l_next_approver_disp_name);
547:
625: response =>l_value,
626: responseEndDate =>l_end_date,
627: forwardToId => l_forward_to_id);
628:
629: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
630: itemkey => itemkey,
631: aname => 'DOCUMENT_ID');
632:
633: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
629: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
630: itemkey => itemkey,
631: aname => 'DOCUMENT_ID');
632:
633: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'DOCUMENT_TYPE');
636:
637: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
633: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'DOCUMENT_TYPE');
636:
637: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'DOCUMENT_SUBTYPE');
640:
641: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
637: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'DOCUMENT_SUBTYPE');
640:
641: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
642: itemkey=>itemkey,
643: aname=>'APPROVER_EMPID');
644:
645: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
641: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
642: itemkey=>itemkey,
643: aname=>'APPROVER_EMPID');
644:
645: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'AME_INSERTION_TYPE');
648:
649: l_authority_type := wf_engine.GetItemAttrText(itemtype => itemtype,
645: l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'AME_INSERTION_TYPE');
648:
649: l_authority_type := wf_engine.GetItemAttrText(itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'AME_AUTHORITY_TYPE');
652:
653: l_progress := 'Update_Approval_List_Response: 010 APP'||
660: IF (g_po_wf_debug = 'Y') THEN
661: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
662: END IF;
663:
664: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
665: itemkey => itemkey,
666: aname => 'AME_TRANSACTION_TYPE');
667:
668: updateApprovalListResponse(itemtype=>itemtype,
742: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
743: END IF;
744:
745: IF (funcmode='RUN') THEN
746: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'DOCUMENT_ID');
749:
750: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
746: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'DOCUMENT_ID');
749:
750: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
751: itemkey => itemkey,
752: aname => 'DOCUMENT_TYPE');
753:
754: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
750: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
751: itemkey => itemkey,
752: aname => 'DOCUMENT_TYPE');
753:
754: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'DOCUMENT_SUBTYPE');
757:
758: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
754: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'DOCUMENT_SUBTYPE');
757:
758: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
759: itemkey=>itemkey,
760: aname=>'APPROVER_EMPID');
761:
762: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
758: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
759: itemkey=>itemkey,
760: aname=>'APPROVER_EMPID');
761:
762: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
763: itemkey => itemkey,
764: aname => 'AME_TRANSACTION_TYPE');
765: updateApprovalListResponse(itemtype=>itemtype,
766: itemkey=>itemkey,