"MACHINERY_CODE,MACHINERY_DESCRIPTION,SUBST_OPERATION_CODE,SUBST_OPERATION_DESCRIPTION,NOTE,CREATE_USER,CREATE_DATE) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
);
ProdOrderProductVO prodVO = null;
Response res = null;
TreeModel model = null;
DefaultMutableTreeNode root;
int sequence = 0;
HashSet subProductsAlreadyAdded = new HashSet();
for(int i=0;i<products.size();i++) {
prodVO = (ProdOrderProductVO)products.get(i);
// retrieve bill of materials for each product...
res = BillOfMaterialsUtil.getBillOfMaterials(conn,compCurr,new ItemPK(prodVO.getCompanyCodeSys01DOC23(),prodVO.getItemCodeItm01DOC23()),serverLanguageId,username,new ArrayList());
if (res.isError())
throw new Exception(res.getErrorMessage());
model = (TreeModel)((VOResponse)res).getVo();
root = (DefaultMutableTreeNode)model.getRoot();
// expand nodes to retrieve sun-products and fill in DOC25/DOC26...
sequence = expandNode(sequence,prodOrderVO,root,usedComponents,usedComponentsVO,compAltCodes,subProductsAlreadyAdded,pstmt,pstmt2,serverLanguageId,username,imagePath);
}
return new VOResponse(Boolean.TRUE);