Connection conn = null;
try {
if (this.conn==null) conn = getConn(); else conn = this.conn;
stmt = conn.createStatement();
InventoryVO vo = null;
for(int i=0;i<list.size();i++) {
vo = (InventoryVO)list.get(i);
// phisically delete records in WAR07...
stmt.execute(
"delete from WAR08_INVENTORY_S_N where PROGRESSIVE_WAR06="+vo.getProgressiveWAR06()
);
// phisically delete records in WAR07...
stmt.execute(
"delete from WAR07_INVENTORY_ITEMS where PROGRESSIVE_WAR06="+vo.getProgressiveWAR06()
);
// phisically delete the record in WAR06...
stmt.execute(
"delete from WAR06_INVENTORIES "+
"where COMPANY_CODE_SYS01='"+vo.getCompanyCodeSys01WAR06()+"' and PROGRESSIVE="+vo.getProgressiveWAR06()
);
}
return new VOResponse(new Boolean(true));
}