Some Required Codes

1.     Following Code To Filter The Records using View Objects. 

“ AM CODE”

 public void FilterRecords(String SearchVendorID1)   

    {

        OAViewObject vo = getVEDOR_VO();       

        vo.clearCache();

        vo.setWhereClauseParams(null);

        vo.setWhereClause(null);

        vo.setWhereClause("VENDOR_ID = "+SearchVendorID1);       

        vo.executeQuery();

    }

“ Controller CODE”

    if (pageContext.getParameter("Go")!=null)

    {

          String SearchVendorName1=pageContext.getParameter("VendorName");    

      String SearchVendorID1=pageContext.getParameter("SearchVendorID");       

        System.out.println("SearchVendorName1= "+SearchVendorName1);

        System.out.println("SearchVendorID1= "+SearchVendorID1);     

    Serializable[] parameters1 = { SearchVendorID1 };

        am.invokeMethod("FilterRecords", parameters1);    

       }

2.     Following Code Apply the Changes means to Commit. 

“ AM CODE”

      public void Apply()

    {

        getTransaction().commit();

    }

/***********************************************************/

“ Controller CODE”

      if (pageContext.getParameter("Apply")!=null)

      {

          am.invokeMethod("Apply");  

          String message = "Transaction Complete " +  "!"; 

          throw new OAException(message,OAException.CONFIRMATION);

      }

3.     Following Code To Create New Record in Tabular Form

  

“ AM CODE”

    public void CreateNewRecords()   

    {

        VEDOR_VOImpl vo = getVEDOR_VO();

       

        OADBTransaction tr = getOADBTransaction();

       

        VEDOR_VOImpl row = null;

        vo.setMaxFetchSize(0);

        OARow prow=(OARow)vo.createRow();

                                      vo.last();

                                      vo.next();

                       vo.insertRow(prow);

oracle.sql.NUMBER personid = tr.getSequenceValue("XX_PO_NUMBER_S");

     vo.getCurrentRow().setAttribute("VendorId", personid);

     vo.getCurrentRow().setAttribute("Segment1", personid);

    }

/***********************************************************/

“ Controller CODE”

      if (pageContext.getParameter("Create")!=null)

      {

          am.invokeMethod("CreateNewRecords");  

      }

4.     Following Code To Delete Record in Tabular Form

 “ AM CODE”

    public void deleteRecord()

      {

      OAViewObject vo = getVEDOR_VO();

    

        VEDOR_VORowImpl row = null;

        int fetchedRowCount = vo.getFetchedRowCount();

       RowSetIterator deleteIter = vo.createRowSetIterator("deleteIter");

        if (fetchedRowCount > 0)

        {  deleteIter.setRangeStart(0);

           deleteIter.setRangeSize(fetchedRowCount);

           for (int i = 0; i < fetchedRowCount; i++)

          {

            row = (VEDOR_VORowImpl)deleteIter.getRowAtRangeIndex(i);

            row.remove();

            getTransaction().commit();

            break;

          }

        }

       deleteIter.closeRowSetIterator();

}

/***********************************************************/

“ Controller CODE”

      if ("delete".equals(pageContext.getParameter(EVENT_PARAM)))

      {                     

          System.out.println("Delete Event Fire Sucessfully =");

           //Serializable[] parameters = { pvendorid };

          am.invokeMethod("deleteRecord");         

          throw new OAException("Record Deleted Succesfully",OAException.INFORMATION);

      }

 “ AM CODE”

    public void deleteRecord()

      {

      OAViewObject vo = getVEDOR_VO();

    

        VEDOR_VORowImpl row = null;

        int fetchedRowCount = vo.getFetchedRowCount();

       RowSetIterator deleteIter = vo.createRowSetIterator("deleteIter");

        if (fetchedRowCount > 0)

        {  deleteIter.setRangeStart(0);

           deleteIter.setRangeSize(fetchedRowCount);

           for (int i = 0; i < fetchedRowCount; i++)

          {

            row = (VEDOR_VORowImpl)deleteIter.getRowAtRangeIndex(i);

            row.remove();

            getTransaction().commit();

            break;

          }

        }

       deleteIter.closeRowSetIterator();

}

/***********************************************************/

“ Controller CODE”

      if ("delete".equals(pageContext.getParameter(EVENT_PARAM)))

      {                     

          System.out.println("Delete Event Fire Sucessfully =");

           //Serializable[] parameters = { pvendorid };

          am.invokeMethod("deleteRecord");         

          throw new OAException("Record Deleted Succesfully",OAException.INFORMATION);

      }

Execute The ProcessRequest Method  From ProcessFormRequest :-

pageContext.forwardImmediatelyToCurrentPage(null, true, null);

To Get Fired Action Name:-

String action = pageContext.getParameter(EVENT_PARAM);

To Get Sequence Value:-

OADBTransaction tr = getOADBTransaction();

oracle.sql.NUMBER lineid = tr.getSequenceValue("JEG_PA_BILL_RATES_DTL_S");

String to int conversion

int i = Integer.parseInt(myString);