1 Reply Latest reply on Jan 11, 2016 2:59 PM by Srini Chavali-Oracle

    ame_api2.getnextapprovers1 does not return

    H.O

      Hi All,

       

           i need help with obtaining next approver from ame. i have created a transaction type which is working from test work bench... but when i try to execute the api to get the next approver the plsql block gets stuck..

       

       

      1. DECLARE 
      2.    l_approvalprocesscompleteynout   VARCHAR2 (100); 
      3.    l_nextapproversout               ame_util.approverstable2; 
      4.    l_itemindexesout                 ame_util.idlist; 
      5.    l_itemclassesout                 ame_util.stringlist; 
      6.    l_itemidsout                     ame_util.stringlist; 
      7.    l_itemsourcesout                 ame_util.longstringlist; 
      8.    j                                NUMBER; 
      9. BEGIN 
      10.    DBMS_OUTPUT.put_line ('1 ');   --doesn't even print this 
      11.    ame_api2.getnextapprovers1 (800, 
      12.                                'XXPOBAPAPP', 
      13.                                '1081:10012016152955', 
      14.                                ame_util.booleantrue, 
      15.                                l_approvalprocesscompleteynout, 
      16.                                l_nextapproversout, 
      17.                                l_itemindexesout, 
      18.                                l_itemclassesout, 
      19.                                l_itemidsout, 
      20.                                l_itemsourcesout 
      21.                               ); 
      22.    DBMS_OUTPUT.put_line ('2 '); 
      23.    j := l_nextapproversout.COUNT; 
      24.    DBMS_OUTPUT.put_line ('Approver Count:' || j); 
      25. END;