gridParams.getOtherGridParams().put(ApplicationConsts.MANUFACTURE_VO,manVO);
res = ops.loadManufacturePhases(gridParams,serverLanguageId,username,new ArrayList());
if (res.isError())
throw new Exception(res.getErrorMessage());
java.util.List list = ((VOListResponse)res).getRows();
ManufacturePhaseVO phaseVO = null;
if (subProductsAlreadyAdded.contains(prodVO.getItemCodeItm01ITM03()))
return sequence;
subProductsAlreadyAdded.add(prodVO.getItemCodeItm01ITM03());
for(int i=0;i<list.size();i++) {
phaseVO = (ManufacturePhaseVO)list.get(i);
/*
"insert into DOC26_PRODUCTION_OPERATIONS(COMPANY_CODE_SYS01,DOC_YEAR,DOC_NUMBER,ITEM_CODE_ITM01,PHASE_NUMBER,"+
"OPERATION_CODE,OPERATION_DESCRIPTION,VALUE,DURATION,MANUFACTURE_TYPE,COMPLETION_PERC,QTY,TASK_CODE,TASK_DESCRIPTION,"+
"MACHINERY_CODE,MACHINERY_DESCRIPTION,SUBST_OPERATION_CODE,SUBST_OPERATION_DESCRIPTION,NOTE) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?"
*/
pstmt2.setString(1,prodOrderVO.getCompanyCodeSys01DOC22());
pstmt2.setBigDecimal(2,prodOrderVO.getDocYearDOC22());
pstmt2.setBigDecimal(3,prodOrderVO.getDocNumberDOC22());
pstmt2.setString(4,prodVO.getItemCodeItm01ITM03());
pstmt2.setBigDecimal(5,phaseVO.getPhaseNumberPRO02());
pstmt2.setString(6,phaseVO.getOperationCodePro04PRO02());
pstmt2.setString(7,phaseVO.getDescriptionSYS10());
pstmt2.setBigDecimal(8,phaseVO.getValuePRO02());
pstmt2.setBigDecimal(9,phaseVO.getDurationPRO02());
pstmt2.setString(10,phaseVO.getManufactureTypePRO02());
pstmt2.setBigDecimal(11,phaseVO.getCompletionPercPRO02());
pstmt2.setBigDecimal(12,phaseVO.getQtyPRO02());
pstmt2.setString(13,phaseVO.getTaskCodeReg07PRO02());
pstmt2.setString(14,phaseVO.getTaskDescriptionSYS10());
pstmt2.setString(15,phaseVO.getMachineryCodePro03PRO02());
pstmt2.setString(16,phaseVO.getMachineryDescriptionSYS10());
pstmt2.setString(17,phaseVO.getSubstOperationCodePro04PRO02());
pstmt2.setString(18,phaseVO.getDescription2());
pstmt2.setString(19,phaseVO.getNotePRO02());
pstmt2.setString(20,username);
pstmt2.setTimestamp(21,new java.sql.Timestamp(System.currentTimeMillis()));
pstmt2.execute();
try {