details: https://code.openbravo.com/erp/devel/pi/rev/4ca0c8b4d182 changeset: 29701:4ca0c8b4d182 user: Sanjota <sanjota.nelagi <at> promantia.com> date: Fri Jun 10 17:52:55 2016 +0530 summary: Fixes issue 30739: pl function m_copy_product_template has datatype bug
Changed the datatype of v_documentNo from var char(30) to Numeric. details: https://code.openbravo.com/erp/devel/pi/rev/f8552f6b006e changeset: 29702:f8552f6b006e user: Sanjota <sanjota.nelagi <at> promantia.com> date: Fri Jun 10 17:30:18 2016 +0530 summary: Fixes issue 30740: pl-function ma_copy_version does not work with non Changed the datatype of v_documentNo from Numeric to var char(30). Since the function fails incase of insert MA_Processplan_Version statemment details: https://code.openbravo.com/erp/devel/pi/rev/f138f3edc459 changeset: 29703:f138f3edc459 user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Mon Jun 27 12:27:02 2016 +0200 summary: Related to issue 30740: Code review improvements diffstat: src-db/database/model/functions/MA_COPY_VERSION.xml | 4 ++-- src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diffs (42 lines): diff -r 58a17e7e4040 -r f138f3edc459 src-db/database/model/functions/MA_COPY_VERSION.xml --- a/src-db/database/model/functions/MA_COPY_VERSION.xml Fri Jun 24 23:05:23 2016 +0200 +++ b/src-db/database/model/functions/MA_COPY_VERSION.xml Mon Jun 27 12:27:02 2016 +0200 @@ -16,7 +16,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU -* All portions are Copyright (C) 2001-2011 Openbravo SLU +* All portions are Copyright (C) 2001-2016 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -35,7 +35,7 @@ v_Org_ID VARCHAR2(32); v_User_ID VARCHAR2(32); v_UpdatedBy VARCHAR2(32); - v_DocumentNo NUMBER; + v_DocumentNo MA_ProcessPlan_Version.DocumentNo%TYPE; v_Sequence_ID VARCHAR2(32); v_Product_ID VARCHAR2(32); v_ProductAtt_ID VARCHAR2(32); diff -r 58a17e7e4040 -r f138f3edc459 src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml --- a/src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml Fri Jun 24 23:05:23 2016 +0200 +++ b/src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml Mon Jun 27 12:27:02 2016 +0200 @@ -16,7 +16,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU -* All portions are Copyright (C) 2001-2006 Openbravo SLU +* All portions are Copyright (C) 2001-2016 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -44,7 +44,7 @@ v_Pricelimit NUMBER; v_Pricestd NUMBER; v_Linenetamount NUMBER; - v_Discount VARCHAR2(32); + v_Discount NUMBER; v_Tax VARCHAR2(32); v_Issotrx CHAR; v_NoOfLines NUMBER:=0; ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
