Delete Row Code in OAF

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

public void deleteEmployee(String employeeNumber)
  {
     int empToDelete = Integer.parseInt(employeeNumber);
 
    OAViewObject vo = (OAViewObject)getEmployeeSummaryVO1(); 
    EmployeeSummaryVORowImpl 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 = (EmployeeSummaryVORowImpl)deleteIter.getRowAtRangeIndex(i);
 
 
         Number primaryKey = row.getEmployeeId();
        if (primaryKey.compareTo(empToDelete) == 0)
        {
          // This performs the actual delete.
          row.remove();
          getTransaction().commit(); 
          break; // only one possible selected row in this case
        }
      }
    }
    // Always close the iterator when you're done.
    deleteIter.closeRowSetIterator();
  } // end deleteEmployee