details: https://code.openbravo.com/erp/devel/pi/rev/3d2566d2bf35 changeset: 33169:3d2566d2bf35 user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Dec 19 15:40:18 2017 +0100 summary: Fixes Issue 37482. Remove unused variables in PL's
details: https://code.openbravo.com/erp/devel/pi/rev/68d09ac13f38 changeset: 33170:68d09ac13f38 user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Dec 19 15:40:46 2017 +0100 summary: Related to Issue 37482. Revert variables that has been removed and use them in the error message. Also updated copyrights details: https://code.openbravo.com/erp/devel/pi/rev/00155f72a180 changeset: 33171:00155f72a180 user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Dec 19 16:08:53 2017 +0100 summary: Related to Issue 37482. Removed unused variable and code in PL. The check for stock consistency is done by the call to the m_check_stock function details: https://code.openbravo.com/erp/devel/pi/rev/ad429b2b7700 changeset: 33172:ad429b2b7700 user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Dec 19 17:40:09 2017 +0100 summary: Related to Issue 37482. Removed unnecessary comment and added a deleted variable to include it in the returned error message diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml | 6 -- modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml | 6 -- src-db/database/model/functions/A_ASSET_CREATE.xml | 2 - src-db/database/model/functions/A_ASSET_POST.xml | 26 +--------- src-db/database/model/functions/C_CHANGEPROJECTSTATUS.xml | 2 - src-db/database/model/functions/C_DEBT_PAYMENT_BALANCING_REP.xml | 7 +- src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml | 3 - src-db/database/model/functions/C_INVOICELINE_TAX.xml | 7 +-- src-db/database/model/functions/C_INVOICE_CANCEL.xml | 2 - src-db/database/model/functions/C_INVOICE_CREATE.xml | 9 +-- src-db/database/model/functions/C_INVOICE_POST.xml | 13 +---- src-db/database/model/functions/C_ORDER_POST1.xml | 16 ------ src-db/database/model/functions/C_SETTLEMENT_POST.xml | 13 +--- src-db/database/model/functions/C_TAXPAYMENT_POST.xml | 5 +- src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml | 6 -- src-db/database/model/functions/FACT_ACCT_RESET.xml | 12 ---- src-db/database/model/functions/GL_JOURNAL_POST.xml | 5 +- src-db/database/model/functions/MA_PRODUCTION_COST.xml | 10 +-- src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml | 5 +- src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml | 25 +-------- src-db/database/model/functions/MA_WORKREQUIREMENT_CLOSE.xml | 2 - src-db/database/model/functions/MA_WORKREQUIREMENT_PROCESS.xml | 7 +- src-db/database/model/functions/MA_WRPHASE_CLOSE.xml | 2 - src-db/database/model/functions/M_DISCOUNTSCHEMA_RESEQ.xml | 2 - src-db/database/model/functions/M_FREIGHT_CALCULATE.xml | 4 - src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 2 - src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml | 2 - src-db/database/model/functions/M_GET_STOCK_PARAM.xml | 2 +- src-db/database/model/functions/M_INOUTEXPLODEBOMNOTSTOCK.xml | 6 +- src-db/database/model/functions/M_INOUT_CREATE.xml | 2 - src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml | 5 +- src-db/database/model/functions/M_INOUT_UPDATEQUANTITYES.xml | 8 --- src-db/database/model/functions/M_PROMOTION_ADJUSTMENT.xml | 9 +- src-db/database/model/functions/M_REQUISITION_CREATEPO.xml | 3 +- src-db/database/model/functions/M_UNIQUELOCATOR_RULE_PARAM.xml | 2 - src-db/database/model/triggers/A_ASSET_TRG.xml | 2 - src-db/database/model/triggers/C_ATTACHMENT_METHOD_MOD_TRG.xml | 3 - src-db/database/model/triggers/C_BPARTNER_TRG.xml | 4 - src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml | 2 +- src-db/database/model/triggers/C_INVOICELINE_TRG.xml | 4 - src-db/database/model/triggers/C_INVOICELINE_TRG2.xml | 5 +- src-db/database/model/triggers/C_ORDERLINE2_TRG.xml | 9 +- src-db/database/model/triggers/C_ORDERLINE_TRG2.xml | 6 +- src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml | 4 +- src-db/database/model/triggers/C_PROJECTLINE_TRG.xml | 7 +- src-db/database/model/triggers/C_PROJECT_TRG3.xml | 7 +- src-db/database/model/triggers/MA_GLOBALUSE_TRG.xml | 4 +- src-db/database/model/triggers/M_COSTADJUSTMENTLINE_CHK_TRG.xml | 3 +- src-db/database/model/triggers/M_INTERNAL_CONSUMPTIONLINE_TRG.xml | 4 +- src-db/database/model/triggers/M_INVENTORYLINE2_TRG.xml | 4 +- src-db/database/model/triggers/M_IOLINE_CHK_RESTRICTIONS_TRG.xml | 4 +- src-db/database/model/triggers/M_MOVEMENTLINE_TRG.xml | 4 +- src-db/database/model/triggers/M_OFFER_TYPE_MOD_TRG.xml | 3 - src-db/database/model/triggers/M_PRODUCTIONLINE_TRG.xml | 4 +- src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml | 4 +- src-db/database/model/triggers/M_RESERVATION_TRG.xml | 4 +- src-db/database/model/triggers/M_STORAGE_DETAIL_TRG.xml | 4 +- src-db/database/model/triggers/M_TRANSACTION_TRG2.xml | 4 +- src-db/database/model/triggers/S_TIMEEXPENSELINE_TRG.xml | 4 +- 59 files changed, 77 insertions(+), 264 deletions(-) diffs (truncated from 1564 to 300 lines): diff -r d22996575a61 -r ad429b2b7700 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml Tue Dec 19 17:40:09 2017 +0100 @@ -21,11 +21,9 @@ * Contributor(s): ______________________________________. ************************************************************************/ -p_message VARCHAR(2000); p_record_id VARCHAR(60); p_docAction VARCHAR(60); p_user VARCHAR(60); -p_result NUMBER; v_ResultStr VARCHAR2(2000):=''; v_GrandTotal NUMBER:=0; @@ -57,10 +55,6 @@ p_record_id := cur_params.p_string; ELSIF (cur_params.parametername LIKE 'User') THEN p_user := cur_params.p_string; - ELSIF (cur_params.parametername LIKE 'Message') THEN - p_message := cur_params.p_text; - ELSIF (cur_params.parametername LIKE 'Result') THEN - p_result := cur_params.p_number; END IF; END LOOP; diff -r d22996575a61 -r ad429b2b7700 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml Tue Dec 19 17:40:09 2017 +0100 @@ -26,8 +26,6 @@ p_GLItem VARCHAR2(32); p_Amount NUMBER; p_IsReceipt CHAR(1); -p_message VARCHAR(2000); -p_result NUMBER; v_TaxPaymentName VARCHAR2(60); v_FinancialAccountName VARCHAR2(60); @@ -77,10 +75,6 @@ p_amount := cur_params.p_number; ELSIF (cur_params.parametername LIKE 'IsReceipt') THEN p_isReceipt := cur_params.p_string; - ELSIF (cur_params.parametername LIKE 'Message') THEN - p_message := cur_params.p_text; - ELSIF (cur_params.parametername LIKE 'Result') THEN - p_result := cur_params.p_number; END IF; END LOOP; diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/A_ASSET_CREATE.xml --- a/src-db/database/model/functions/A_ASSET_CREATE.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/A_ASSET_CREATE.xml Tue Dec 19 17:40:09 2017 +0100 @@ -40,7 +40,6 @@ v_Message VARCHAR2(2000):=''; v_Result NUMBER:=1; -- 0=failure v_Record_ID VARCHAR2(32); - v_AD_User_ID VARCHAR2(32); -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; @@ -72,7 +71,6 @@ ) LOOP v_Record_ID:=Cur_Parameter.Record_ID; - v_AD_User_ID:=Cur_Parameter.AD_User_ID; -- IF (p.ParameterName = 'xx') THEN -- p_xx := p.P_String; -- DBMS_OUTPUT.PUT_LINE(' xx=' || p_xx); diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/A_ASSET_POST.xml --- a/src-db/database/model/functions/A_ASSET_POST.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/A_ASSET_POST.xml Tue Dec 19 17:40:09 2017 +0100 @@ -35,45 +35,33 @@ -- Record Info v_count NUMBER; v_Processing A_ASSET.Processing%TYPE; - v_Processed A_ASSET.Processed%TYPE; - v_ACCTVALUEAMT NUMBER; v_AD_CLIENT_ID VARCHAR2(32); v_AD_ORG_ID VARCHAR2(32); - v_AD_USER_ID VARCHAR2(32); - v_AMORTIZATIONENDDATE DATE; v_AMORTIZATIONSTARTDATE DATE; v_AMORTIZATIONTYPE VARCHAR2(60) ; v_AMORTIZATIONVALUEAMT NUMBER; v_AMORTIZATIONPERCENTAGE NUMBER; - v_ASSETDEPRECIATIONDATE DATE; - v_ASSETVALUEAMT NUMBER; v_C_CURRENCY_ID VARCHAR2(32); v_CREATEDBY varchar2(32); - v_ISDEPRECIATED CHAR(1) ; - v_RESIDUALASSETVALUEAMT NUMBER; v_ORIGUSELIFEMONTHS NUMBER; v_USELIFEMONTHS NUMBER; V_MONTHS NUMBER; v_USELIFEYEARS NUMBER; v_ORIGUSELIFEYEARS NUMBER; v_ASSETSCHEDULE VARCHAR2(60) ; - v_TOTAL_DAYS NUMBER; v_BEGINING_DATE DATE; v_ENDING_DATE DATE; - v_AUXAMT NUMBER; v_NEW_AMORTIZATION VARCHAR2(32); v_LINE NUMBER; v_SEQ_ASSET NUMBER; v_AMORTIZATIONLINE varchar2(32); v_FIRST_DAY_DATE DATE; - v_LAST_DAY_DATE DATE; v_PERCENTAGE NUMBER; v_AMOUNT NUMBER; v_CURRENCY_ID VARCHAR2(32); FINISH_PROCESS BOOLEAN:=false; v_DepreciatedLines NUMBER; v_DepreciatedPlan NUMBER; - v_depreciatedValue NUMBER; v_Period NUMBER; v_DEPRECIATEDPREVIOUSAMT NUMBER; v_AMORTIZATIONCALCTYPE VARCHAR2(60) ; @@ -120,8 +108,8 @@ WHERE A_asset_ID=v_Record_ID ) WHERE a_Asset_ID=v_Record_ID; - SELECT ACCTVALUEAMT, AD_CLIENT_ID, AD_ORG_ID, AD_USER_ID, AMORTIZATIONENDDATE, AMORTIZATIONSTARTDATE, AMORTIZATIONTYPE, AMORTIZATIONVALUEAMT, ANNUALAMORTIZATIONPERCENTAGE, ASSETDEPRECIATIONDATE, ASSETVALUEAMT, C_CURRENCY_ID, CREATEDBY, ISDEPRECIATED, PROCESSING, RESIDUALASSETVALUEAMT, USELIFEMONTHS, USELIFEMONTHS, USELIFEYEARS,USELIFEYEARS, ASSETSCHEDULE, PROCESSED, C_CURRENCY_ID, depreciatedPlan, COALESCE(depreciatedValue,0), COALESCE(DEPRECIATEDPREVIOUSAMT,0), AMORTIZATIONCALCTYPE, C_PROJECT_ID - INTO v_ACCTVALUEAMT, v_AD_CLIENT_ID, v_AD_ORG_ID, v_AD_USER_ID, v_AMORTIZATIONENDDATE, v_AMORTIZATIONSTARTDATE, v_AMORTIZATIONTYPE, v_AMORTIZATIONVALUEAMT, v_AMORTIZATIONPERCENTAGE, v_ASSETDEPRECIATIONDATE, v_ASSETVALUEAMT, v_C_CURRENCY_ID, v_CREATEDBY, v_ISDEPRECIATED, v_PROCESSING, v_RESIDUALASSETVALUEAMT, v_USELIFEMONTHS, v_ORIGUSELIFEMONTHS, v_USELIFEYEARS, v_ORIGUSELIFEYEARS, v_ASSETSCHEDULE, v_PROCESSED, v_CURRENCY_ID, v_DepreciatedPlan, v_depreciatedValue, v_DEPRECIATEDPREVIOUSAMT, v_AMORTIZATIONCALCTYPE, v_PROJECT_ID + SELECT AD_CLIENT_ID, AD_ORG_ID, AMORTIZATIONSTARTDATE, AMORTIZATIONTYPE, AMORTIZATIONVALUEAMT, ANNUALAMORTIZATIONPERCENTAGE, C_CURRENCY_ID, CREATEDBY, PROCESSING, USELIFEMONTHS, USELIFEMONTHS, USELIFEYEARS,USELIFEYEARS, ASSETSCHEDULE, C_CURRENCY_ID, depreciatedPlan, COALESCE(DEPRECIATEDPREVIOUSAMT,0), AMORTIZATIONCALCTYPE, C_PROJECT_ID + INTO v_AD_CLIENT_ID, v_AD_ORG_ID, v_AMORTIZATIONSTARTDATE, v_AMORTIZATIONTYPE, v_AMORTIZATIONVALUEAMT, v_AMORTIZATIONPERCENTAGE, v_C_CURRENCY_ID, v_CREATEDBY, v_PROCESSING, v_USELIFEMONTHS, v_ORIGUSELIFEMONTHS, v_USELIFEYEARS, v_ORIGUSELIFEYEARS, v_ASSETSCHEDULE, v_CURRENCY_ID, v_DepreciatedPlan, v_DEPRECIATEDPREVIOUSAMT, v_AMORTIZATIONCALCTYPE, v_PROJECT_ID FROM A_ASSET WHERE A_ASSET_ID=v_Record_ID; DBMS_OUTPUT.PUT_LINE('A_Asset_ID=' || v_Record_ID || ' - AMORTIZATIONTYPE=' || v_AMORTIZATIONTYPE) ; @@ -181,7 +169,6 @@ v_Count:=coalesce(v_depreciatedLines, 0) +1; v_BEGINING_DATE:=v_AMORTIZATIONSTARTDATE; v_FIRST_DAY_DATE:=TO_DATE('01-01-' || TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY'), 'DD-MM-YYYY') ; - v_LAST_DAY_DATE:=TO_DATE('31-12-' || TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY'), 'DD-MM-YYYY') ; if v_Count>1 then v_BEGINING_DATE:=TO_DATE('31-12-' || to_char(TO_number(to_char(v_BEGINING_DATE, 'yyyy')) +v_Count-1), 'DD-MM-YYYY') ; v_USELIFEYEARS:=v_USELIFEYEARS+ (1- (to_number(TO_DATE('31-12-' || TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY'), 'DD-MM-YYYY') - v_AMORTIZATIONSTARTDATE) / @@ -193,13 +180,9 @@ else v_PercentageGeneral := (100-(v_depreciatedPlan*100/(v_AMORTIZATIONVALUEAMT-v_DEPRECIATEDPREVIOUSAMT))) / (v_USELIFEYEARS-v_DepreciatedLines); --v_PercentageGeneral:=((v_AMORTIZATIONVALUEAMT-v_DEPRECIATEDPREVIOUSAMT-v_depreciatedPlan) *100/v_AMORTIZATIONVALUEAMT) /(v_USELIFEYEARS-v_DepreciatedLines) ; - SELECT to_number(TO_DATE(ADD_MONTHS(v_AMORTIZATIONSTARTDATE, 12*v_USELIFEYEARS)) - v_AMORTIZATIONSTARTDATE) - INTO v_TOTAL_DAYS - FROM DUAL; end if; v_AMORTIZATIONVALUEAMT:=v_AMORTIZATIONVALUEAMT-v_DEPRECIATEDPREVIOUSAMT; - v_AUXAMT:=0; v_PERCENTAGE:=0; v_TotalAmt:=coalesce(v_DepreciatedPlan, 0) ; finish:=false; @@ -301,7 +284,6 @@ v_Count:=coalesce(v_depreciatedLines, 0) +1; v_BEGINING_DATE:=v_AMORTIZATIONSTARTDATE; v_FIRST_DAY_DATE:=TO_DATE('01-'|| TO_CHAR(v_AMORTIZATIONSTARTDATE, 'MM') || '-' || TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY'), 'DD-MM-YYYY') ; - v_LAST_DAY_DATE:=TO_DATE('31-12-'|| TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY'), 'DD-MM-YYYY') ; if v_Count>1 then v_BEGINING_DATE:=TO_DATE(ADD_MONTHS(LAST_DAY(TO_DATE('01-' || TO_CHAR(v_BEGINING_DATE, 'MM') || '-' || TO_CHAR(v_BEGINING_DATE, 'yyyy'), 'DD-MM-YYYY')), v_DepreciatedLines)) ; v_USELIFEMonths:=v_USELIFEMonths + (1- (to_number(last_day(v_AMORTIZATIONSTARTDATE) - v_AMORTIZATIONSTARTDATE) / @@ -319,11 +301,7 @@ else v_PercentageGeneral:=(((v_AMORTIZATIONVALUEAMT-v_depreciatedPlan) *100/v_AMORTIZATIONVALUEAMT) /(v_USELIFEYEARS-v_DepreciatedLines)) /12; end if; - SELECT to_number(TO_DATE(ADD_MONTHS(v_AMORTIZATIONSTARTDATE, 12*v_USELIFEYEARS)) - TO_DATE(v_AMORTIZATIONSTARTDATE)) - INTO v_TOTAL_DAYS - FROM DUAL; end if; - v_AUXAMT:=0; v_PERCENTAGE:=0; v_TotalAmt:=coalesce(v_DepreciatedPlan, 0) ; finish:=false; diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_CHANGEPROJECTSTATUS.xml --- a/src-db/database/model/functions/C_CHANGEPROJECTSTATUS.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_CHANGEPROJECTSTATUS.xml Tue Dec 19 17:40:09 2017 +0100 @@ -24,7 +24,6 @@ v_message VARCHAR2 (2000) := ''; v_result NUMBER:= 1; -- 0=failure v_record_id varchar2(32); - v_ad_user_id varchar2(32); TYPE RECORD IS REF CURSOR; @@ -45,7 +44,6 @@ ORDER BY p.seqno) LOOP v_record_id := cur_parameter.record_id; - v_ad_user_id := cur_parameter.ad_user_id; IF (cur_parameter.parametername = 'ChangeProjectStatus') THEN diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_DEBT_PAYMENT_BALANCING_REP.xml --- a/src-db/database/model/functions/C_DEBT_PAYMENT_BALANCING_REP.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_DEBT_PAYMENT_BALANCING_REP.xml Tue Dec 19 17:40:09 2017 +0100 @@ -25,7 +25,6 @@ v_Message VARCHAR2(2000):=''; v_Result NUMBER:=1; -- 0=failure v_Record_ID VARCHAR2(32); - v_AD_User_ID VARCHAR2(32); TYPE RECORD IS REF CURSOR; Cur_DebtPaymentBalancing RECORD; v_C_Debt_Payment_ID VARCHAR2(32) ; @@ -44,10 +43,8 @@ v_ResultStr:='PInstanceNotFound'; AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'Y', NULL, NULL) ; BEGIN --BODY - SELECT i.Record_ID, - i.AD_User_ID - INTO v_Record_ID, - v_AD_User_ID + SELECT i.Record_ID + INTO v_Record_ID FROM AD_PINSTANCE i WHERE i.AD_PInstance_ID=p_PInstance_ID; DBMS_OUTPUT.PUT_LINE(' Record_ID=' || v_Record_ID) ; diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml --- a/src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml Tue Dec 19 17:40:09 2017 +0100 @@ -29,7 +29,6 @@ v_Result NUMBER:=1; -- 0=failure v_Record_ID VARCHAR2(32) ; v_AD_User_ID VARCHAR2(32) ; - v_AD_Client_ID VARCHAR2(32) ; v_AD_Org_ID VARCHAR2(32) ; v_PAD_User_ID VARCHAR2(32) ; v_Processed VARCHAR2(60) ; @@ -97,11 +96,9 @@ END IF; BEGIN --BODY SELECT UpdatedBy, - AD_Client_ID, Processed, Posted, AD_Org_ID, DateAcct, C_DocType_ID INTO v_AD_User_ID, - v_AD_Client_ID, v_processed, v_posted, v_AD_Org_ID, v_Date, v_DocType_ID FROM c_DP_Management diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_INVOICELINE_TAX.xml --- a/src-db/database/model/functions/C_INVOICELINE_TAX.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_INVOICELINE_TAX.xml Tue Dec 19 17:40:09 2017 +0100 @@ -20,9 +20,7 @@ * All Rights Reserved. * Contributor(s): _______________________________________. ************************************************************************/ -v_INVOICELINE_ID VARCHAR2(32) ; v_Tax_ID VARCHAR2(32) ; - v_IsTaxIncluded VARCHAR(1); v_LineNet NUMBER; v_Rate NUMBER; xTaxAmt NUMBER:=0; @@ -36,17 +34,14 @@ Cur_MultiTax RECORD; BEGIN --Calculates for each line, its tax info -SELECT l.C_INVOICELINE_ID, +SELECT l.C_Tax_ID, - i.IsTaxIncluded, COALESCE(l.LineNetAmt, 0) + COALESCE(l.ChargeAmt, 0) AS LineNet, t.Rate, t.IsSummary, c.StdPrecision INTO - v_INVOICELINE_ID, v_Tax_ID, - v_IsTaxIncluded, v_LineNet, v_Rate, v_IsSummary, diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_INVOICE_CANCEL.xml --- a/src-db/database/model/functions/C_INVOICE_CANCEL.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_INVOICE_CANCEL.xml Tue Dec 19 17:40:09 2017 +0100 @@ -33,7 +33,6 @@ v_ResultStr VARCHAR2(2000):=''; v_Message VARCHAR2(2000):=''; v_Record_ID VARCHAR2(32); - v_AD_Client_ID VARCHAR2(32); -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; @@ -63,7 +62,6 @@ ) LOOP v_Record_ID:=Cur_Parameter.Record_ID; - v_AD_Client_ID:=Cur_Parameter.AD_Client_ID; END LOOP; -- Get Parameter DBMS_OUTPUT.PUT_LINE(' Record_ID=' || v_Record_ID) ; ELSE diff -r d22996575a61 -r ad429b2b7700 src-db/database/model/functions/C_INVOICE_CREATE.xml --- a/src-db/database/model/functions/C_INVOICE_CREATE.xml Fri Dec 01 11:59:57 2017 +0100 +++ b/src-db/database/model/functions/C_INVOICE_CREATE.xml Tue Dec 19 17:40:09 2017 +0100 @@ -44,7 +44,6 @@ -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; - v_Record_ID VARCHAR2(32):=NULL; v_AD_Org_ID VARCHAR2(32):=NULL; v_C_Order_ID VARCHAR2(32):=NULL; v_BPartner_ID VARCHAR2(32):=NULL; @@ -68,7 +67,6 @@ v_Qty NUMBER; ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
