"UPDATE PRODUCT.PRODUCT " + "SET PRODNUM     = '" + Text.cleanDBString ( prodNum ) + "', " + "    DESCRIPTION     = '" + Text.cleanDBString ( description ) + "', " + "    BASEMODEL       = '" + Text.cleanDBString ( baseModel ) +
                     "', " + "    TYPECUSTOMERIND = " + customer + ", " + "    TYPEPRODUCTIND  = " + type + ", " + "    TYPEOFFERINGIND = " + offering + ", " + "    TYPEWARRANTYIND = " + warranty + ", " + "    INPUT           = '" +
                     Text.cleanDBString ( input ) + "', " + "    SOURCE          = '" + Text.cleanDBString ( source ) + "', " + "    PUBLISH         = '" + ( publish ? "Y" : "N" ) + "', " + "    CHECKEDOUTBY    = " +
                     Text.cleanNullableDBString ( checkedOutBy ) + ", " + "    IMPORTOPICM     = '" + ( opicmImport ? "Y" : "N" ) + "', " + "    LASTTOUCHEDON   = CURRENT TIMESTAMP, " + "    LASTTOUCHEDBY   = '" + Text.cleanDBString ( lastTouchedBy ) +
                     "', " + "    ENDOFLIFE     = '" + ( endOfLife ? "Y" : "N" ) + "' " + "WHERE PRODUCTIND = " + productInd;

Changes are made in ProductDraft.java for deleteOrphan method to add a update Productcategory
Ref--
ProductDraft.publish() Method calls abvove method
ProductSaver.publishDraft() Calles above method

TypeCategoryRec project

TypeCategoryRec project