# HG changeset patch # User Stefan Hühner # Date 1441181413 -7200 # Wed Sep 02 10:10:13 2015 +0200 # Node ID e1ebf46e79ec168eb90d2ba923f1fb0ebeff37a6 # Parent f41aa6109535a38a4d9161649f2fd1de4d987390 Fixed 27432. Remove most unused variables from pl functions & triggers. That takes care of the big bunch of those warnings keeping only the ones having some special case to be looked at in more detail. All found using plpgsql_check tool. diff -r f41aa6109535 -r e1ebf46e79ec modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml Wed Sep 02 10:10:13 2015 +0200 @@ -61,8 +61,6 @@ v_delete_paymentplan BOOLEAN := FALSE; v_Financial_Account_ID FIN_FINANCIAL_ACCOUNT.FIN_FINANCIAL_ACCOUNT_ID%TYPE; v_Financial_Account_Org VARCHAR2(32); -v_CreatePayment CHAR(1):='N'; -v_CreateFinTransaction CHAR(1):='N'; v_PaymentDocType_ID FIN_PAYMENT.C_DOCTYPE_ID%TYPE; v_PaymentDocumentNo FIN_PAYMENT.DOCUMENTNO%TYPE; v_FIN_PAYMENT_ID FIN_PAYMENT.FIN_PAYMENT_ID%TYPE; @@ -93,7 +91,6 @@ cur_PaymentScheduleOrder RECORD; cur_linktopayment_scheddetails RECORD; cur_update_scheddetails RECORD; -cur_invoicepaid RECORD; v_paymentamt NUMBER:=0; v_depositamt NUMBER:=0; diff -r f41aa6109535 -r e1ebf46e79ec modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml Wed Sep 02 10:10:13 2015 +0200 @@ -26,13 +26,11 @@ v_Sql VARCHAR2(2000); v_count NUMBER; v_module VARCHAR2(32); - v_dbprefix VARCHAR2(7); v_isPaymentConfirmed CHAR(1) := 'N'; v_isinvoicepaid CHAR(1):= 'N'; v_referencelist VARCHAR2(32):='575BCB88A4694C27BC013DE9C73E6FE7'; TYPE RECORD IS REF CURSOR; Cur_Dbprefix RECORD; - v_invoicepaidstatus VARCHAR2(32); v_fin_payment_schedule_order VARCHAR(32); v_fin_payment_schedule_invoice VARCHAR(32); v_p_fin_psd_id VARCHAR(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/A_ASSET_CREATE.xml --- a/src-db/database/model/functions/A_ASSET_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/A_ASSET_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -49,7 +49,6 @@ Cur_ShipLine RECORD; -- v_A_Asset_ID VARCHAR2(32) ; - v_A_Asset_Delivery_ID VARCHAR2(32) ; v_DocumentNo VARCHAR2(40) ; v_Value VARCHAR2(60) ; v_Name VARCHAR2(80) ; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/A_ASSET_POST.xml --- a/src-db/database/model/functions/A_ASSET_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/A_ASSET_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,12 +34,8 @@ Cur_Parameter RECORD; -- Record Info v_count NUMBER; - v_UpdatedBy A_ASSET.UpdatedBy%TYPE; v_Processing A_ASSET.Processing%TYPE; v_Processed A_ASSET.Processed%TYPE; - v_DateAcct DATE; - v_DocumentNo A_ASSET.DocumentNo%TYPE; - BPartner_ID VARCHAR2(32); v_ACCTVALUEAMT NUMBER; v_AD_CLIENT_ID VARCHAR2(32); v_AD_ORG_ID VARCHAR2(32); @@ -62,11 +58,9 @@ v_ORIGUSELIFEYEARS NUMBER; v_ASSETSCHEDULE VARCHAR2(60) ; v_TOTAL_DAYS NUMBER; - v_THIS_YEAR_DAYS NUMBER; v_BEGINING_DATE DATE; v_ENDING_DATE DATE; v_AUXAMT NUMBER; - v_AMORTIZATIONAMT NUMBER; v_NEW_AMORTIZATION VARCHAR2(32); v_LINE NUMBER; v_SEQ_ASSET NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_AGING_GET_SCOPE.xml --- a/src-db/database/model/functions/C_AGING_GET_SCOPE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_AGING_GET_SCOPE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -37,7 +37,6 @@ * In case the DATE is i.e. 28/02/2007 this function will return 28/03/2007 * while add_moths returns 31/03/2007 ************************************************************************/ - pDateAux DATE; BEGIN if (pDate 64.72 ************************************************************************/ - v_Rate NUMBER; BEGIN RETURN C_CURRENCY_CONVERT_PRECISION(p_amount, p_curfrom_id, p_curto_id, p_convdate, p_ratetype, p_client_id, p_org_id, 'A'); EXCEPTION diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_CURRENCY_CONVERT_RATE.xml --- a/src-db/database/model/functions/C_CURRENCY_CONVERT_RATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_CURRENCY_CONVERT_RATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -40,7 +40,6 @@ * All portions are Copyright (C) 2012 Openbravo SLU * All Rights Reserved. ************************************************************************/ - v_Rate NUMBER; BEGIN IF (p_convrate IS NULL) THEN RETURN C_CURRENCY_CONVERT_PRECISION(p_amount, p_curfrom_id, p_curto_id, p_convdate, p_ratetype, p_client_id, p_org_id, 'A'); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_CURRENCY_RATE.xml --- a/src-db/database/model/functions/C_CURRENCY_RATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_CURRENCY_RATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -49,11 +49,9 @@ * SELECT C_Currency_Rate(116, 100, null, null) FROM DUAL; => .647169 ************************************************************************/ -- Currency From variables - v_cf_IsEuro char(1); -- Triangle v_CurrencyFrom VARCHAR(32); v_CurrencyTo VARCHAR(32); - v_CurrencyEuro VARCHAR(32); -- v_ConvDate DATE := now(); v_RateType VARCHAR(60) := 'S'; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_DB_PERCENTAGE_PAID.xml --- a/src-db/database/model/functions/C_DB_PERCENTAGE_PAID.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_DB_PERCENTAGE_PAID.xml Wed Sep 02 10:10:13 2015 +0200 @@ -23,7 +23,6 @@ v_percentaje NUMBER; v_Status CHAR; TYPE RECORD IS REF CURSOR; - CUR_SETTLEMENT RECORD; BEGIN v_Status := C_DEBT_PAYMENT_STATUS0(p_Debt_Payment_ID); IF (v_Status IN ('C', 'A')) THEN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml --- a/src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,15 +34,11 @@ v_PAD_User_ID VARCHAR2(32) ; v_Processed VARCHAR2(60) ; v_Posted VARCHAR2(60) ; - v_Currency VARCHAR2(32); v_Date DATE; - v_CashBook_ISO_Code VARCHAR(10) ; - v_Record_Description VARCHAR2(2000):=''; v_Debt_Payment_ID VARCHAR2(32) ; --Addesd by PSarobe 12062007 v_line NUMBER; v_DpManagementline_ID VARCHAR2(32); - v_Remittanceline_ID VARCHAR2(32); v_documentno_Settlement VARCHAR2(40); v_dateSettlement DATE; v_Cancel_Processed CHAR(1); @@ -66,11 +62,6 @@ Cur_Parameter RECORD; -- Parameter Variables v_Aux NUMBER; - v_CanceledNotChargeAmt NUMBER:=0; - v_GeneratedAmt NUMBER:=0; - v_ChargedAmt NUMBER:=0; - v_ForcedOrg NUMBER; - v_ManualAmt NUMBER:=0; Cur_Lines RECORD; Cur_Line_DP RECORD; Cur_DPDebtpayment RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_GENERATEPOFROMPROJECT.xml --- a/src-db/database/model/functions/C_GENERATEPOFROMPROJECT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_GENERATEPOFROMPROJECT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -71,7 +71,6 @@ v_PriceList NUMBER; v_PriceLimit NUMBER; v_C_UOM_ID VARCHAR2(32); - v_C_Currency_ID VARCHAR2(32); v_PriceActual NUMBER; v_Discount NUMBER; v_Tax_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_GENERATESOFROMPROJECT.xml --- a/src-db/database/model/functions/C_GENERATESOFROMPROJECT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_GENERATESOFROMPROJECT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -70,8 +70,6 @@ v_PriceList NUMBER; v_PriceLimit NUMBER; v_C_UOM_ID VARCHAR2(32); - v_C_Currency_ID VARCHAR2(32); - v_M_PriceList_ID VARCHAR2(32); v_Billto_ID VARCHAR2(32); v_InvoiceRule CHAR; v_M_PriceList_Version_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml --- a/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -60,8 +60,6 @@ v_PriceList NUMBER; v_PriceLimit NUMBER; v_C_UOM_ID VARCHAR2(32); - v_C_Currency_ID VARCHAR2(32); - v_M_PriceList_ID VARCHAR2(32); v_Billto_ID VARCHAR2(32); v_InvoiceRule CHAR; v_M_PriceList_Version_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_GET_IBAN_DISPLAYED_ACCOUNT.xml --- a/src-db/database/model/functions/C_GET_IBAN_DISPLAYED_ACCOUNT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_GET_IBAN_DISPLAYED_ACCOUNT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -28,9 +28,6 @@ * In case the IBAN format is not correct, it raises an exception ************************************************************************/ v_IBAN_check NUMBER; - v_Bank NVARCHAR2(4); - v_Branch NVARCHAR2(4); - v_DigitBank NVARCHAR2(1); v_CountryId NVARCHAR2(2); v_Length NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_GET_NET_PRICE_FROM_GROSS.xml --- a/src-db/database/model/functions/C_GET_NET_PRICE_FROM_GROSS.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_GET_NET_PRICE_FROM_GROSS.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,7 +34,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR(2000):=''; - v_message VARCHAR2(2000):=''; v_NetPrice NUMBER; v_TaxAmount NUMBER; v_calcPrecision NUMBER:=50; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml --- a/src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -46,23 +46,17 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_IsSummary C_TAX.ISSUMMARY%TYPE; v_Cascade C_TAX.CASCADE%TYPE; v_TaxBaseAmount NUMBER; v_BaseAmount C_TAX.BASEAMOUNT%TYPE; - v_AlreadyExists NUMBER; v_C_TaxBase_ID C_TAX.C_TAXBASE_ID%TYPE; - v_LineNet NUMBER; - v_AlternateTaxBaseAmt NUMBER; v_LineNo C_INVOICETAX.LINE%TYPE; v_Rate C_TAX.RATE%TYPE; v_Client_ID VARCHAR2(32) ; V_istaxincluded CHAR(1); TYPE RECORD IS REF CURSOR; Cur_Taxes RECORD; - FINISH_PROCESS BOOLEAN:=false; BEGIN --BODY v_TaxBaseAmount:=0; SELECT ISSUMMARY, CASCADE, RATE, BASEAMOUNT, AD_CLIENT_ID, C_TAXBASE_ID diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_INVOICELINETAX_ROUNDING.xml --- a/src-db/database/model/functions/C_INVOICELINETAX_ROUNDING.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_INVOICELINETAX_ROUNDING.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,7 +33,6 @@ v_ResultStr VARCHAR(2000):=''; v_expected_tax_amt NUMBER ; v_current_tax_amt NUMBER ; - v_description VARCHAR(2000) ; TYPE RECORD IS REF CURSOR; cur_invoicelinetax RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_INVOICE_POST.xml --- a/src-db/database/model/functions/C_INVOICE_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -59,7 +59,6 @@ Cur_LastContact RECORD; Cur_lineqty RECORD; Cur_InvoiceTax RECORD; - Cur_TaxMAct RECORD; Cur_Offer RECORD; -- Record Info @@ -1526,7 +1525,6 @@ -- Generate C_Debt_Payment linked to this invoice DECLARE v_totalCash NUMBER:=0; - v_processed CHAR(1):='N'; v_debtPaymentID varchar2(32) ; v_amount NUMBER; v_cashBook VARCHAR2(32) ; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml --- a/src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -46,23 +46,17 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_IsSummary C_TAX.ISSUMMARY%TYPE; v_Cascade C_TAX.CASCADE%TYPE; v_TaxBaseAmount NUMBER; v_BaseAmount C_TAX.BASEAMOUNT%TYPE; - v_AlreadyExists NUMBER; v_C_TaxBase_ID C_TAX.C_TAXBASE_ID%TYPE; - v_LineNet NUMBER; - v_AlternateTaxBaseAmt NUMBER; v_LineNo C_INVOICETAX.LINE%TYPE; v_Rate C_TAX.RATE%TYPE; v_Client_ID VARCHAR2(32) ; v_istaxincluded CHAR(1); TYPE RECORD IS REF CURSOR; Cur_Taxes RECORD; - FINISH_PROCESS BOOLEAN:=false; BEGIN --BODY v_TaxBaseAmount:=0; SELECT ISSUMMARY, CASCADE, RATE, BASEAMOUNT, AD_CLIENT_ID, C_TAXBASE_ID diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_ORDERLINETAX_ROUNDING.xml --- a/src-db/database/model/functions/C_ORDERLINETAX_ROUNDING.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_ORDERLINETAX_ROUNDING.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,7 +33,6 @@ v_ResultStr VARCHAR(2000):=''; v_expected_tax_amt NUMBER ; v_current_tax_amt NUMBER ; - v_description VARCHAR(2000) ; TYPE RECORD IS REF CURSOR; cur_orderlinetax RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_ORDER_POST1.xml --- a/src-db/database/model/functions/C_ORDER_POST1.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_ORDER_POST1.xml Wed Sep 02 10:10:13 2015 +0200 @@ -56,7 +56,6 @@ v_DocTypeTarget_ID VARCHAR2(32); v_DocSubTypeSO VARCHAR(60) ; v_DocSubTypeSOTarget VARCHAR(60) ; - v_DocBaseTypeTarget VARCHAR(60); v_IsReturnDocType CHAR(1); v_IsBinding CHAR(1):='Y'; v_istaxincluded CHAR(1); @@ -77,7 +76,6 @@ v_dateCash DATE; v_Bankstatementline_ID VARCHAR2(32); --Finish added by P.Sarobe - v_AuxCashLine_ID VARCHAR2(32); v_CashLine_ID VARCHAR2(32); v_ispaid CHAR(1); v_Settlement_Cancel_ID VARCHAR2(32); @@ -91,7 +89,6 @@ v_Multiplier NUMBER:=1; v_Date DATE; v_WarehouseName VARCHAR2(60) ; - v_CashProcessed NUMBER; v_count NUMBER; v_isSoTrx CHAR(1) ; v_Aux NUMBER; @@ -1073,8 +1070,6 @@ DECLARE -- Order Lines with non-stocked BOMs CUR_BOM_Line RECORD; - -- BOM Product List - CountNo NUMBER; BEGIN FOR CUR_BOM_Line IN (SELECT l.c_orderline_id diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_ORDER_PO_CREATE.xml --- a/src-db/database/model/functions/C_ORDER_PO_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_ORDER_PO_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -47,8 +47,6 @@ -- v_Created NUMBER:=0; FINISH_PROCESS BOOLEAN:=false; - v_PInstance_Log_ID VARCHAR2(32); - v_Client_ID VARCHAR2(32); BEGIN -- Update AD_PInstance diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_PAYINADVANCE_CREATE.xml --- a/src-db/database/model/functions/C_PAYINADVANCE_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_PAYINADVANCE_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -47,8 +47,6 @@ v_SDocumentNo C_SETTLEMENT.DocumentNo%TYPE; v_debtPaymentID VARCHAR(32) ; v_CBankAccount_ID C_BankStatement.C_BankAccount_ID%TYPE; - v_C_BankCurrency VARCHAR(32); - v_BS_Date DATE; BEGIN -- Update AD_PInstance DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID) ; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_PERIOD_PROCESS.xml --- a/src-db/database/model/functions/C_PERIOD_PROCESS.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_PERIOD_PROCESS.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,7 +34,6 @@ v_Message VARCHAR2(2000):=''; v_Record_ID VARCHAR2(32); v_Record_ID_Log VARCHAR2(32); - v_Count NUMBER:=0; v_Count2 NUMBER:=0; -- Parameter TYPE RECORD IS REF CURSOR; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_REMITTANCE_POST.xml --- a/src-db/database/model/functions/C_REMITTANCE_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_REMITTANCE_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -35,12 +35,8 @@ v_Posted CHAR(1) ; v_Processing CHAR(1); v_Currency VARCHAR2(32); - v_Date DATE; - v_CashBook_ISO_Code VARCHAR(10) ; - v_Record_Description VARCHAR2(2000):=''; v_SettlementDocType_ID VARCHAR2(32) ; v_DPManagementDocType_ID VARCHAR2(32) ; - v_Debt_Payment_ID VARCHAR2(32) ; --Addesd by PSarobe 12062007 v_Remittanceline_ID VARCHAR2(32); v_documentno_Settlement VARCHAR2(40); @@ -64,7 +60,6 @@ -- Parameter -- Parameter Variables v_Aux NUMBER; - v_CanceledNotChargeAmt NUMBER:=0; v_DateTrx DATE; v_DueDate DATE; v_Status_to VARCHAR(60) ; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_SETTLEMENT_POST.xml --- a/src-db/database/model/functions/C_SETTLEMENT_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_SETTLEMENT_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -38,7 +38,6 @@ v_Date DATE; v_DateAcct DATE; v_CashBook_ISO_Code VARCHAR(10) ; - v_Record_Description VARCHAR2(2000):=''; v_Debt_Payment_ID VARCHAR2(32) ; v_isGenerated char(1) ; --Added by Psarobe @@ -75,8 +74,6 @@ v_GeneratedAmt_WH NUMBER:=0; v_ChargedAmt_WH NUMBER:=0; -- - v_ForcedOrg NUMBER; - v_ManualAmt NUMBER:=0; FINISH_PROCESS BOOLEAN:=false; BEGIN IF(p_PInstance_ID IS NOT NULL) THEN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_TAXPAYMENT_POST.xml --- a/src-db/database/model/functions/C_TAXPAYMENT_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_TAXPAYMENT_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -25,12 +25,9 @@ v_record_ID VARCHAR2(32); v_result NUMBER:= 1; -- Success -v_total NUMBER; -v_c_settlement_cancel_ID VARCHAR2(32); -- Parameter TYPE record IS REF CURSOR; cur_parameter record; -cur_registertype record; cur_line record; -- Record Info v_client_ID VARCHAR2(32); @@ -50,8 +47,6 @@ v_taxamtfromreglines NUMBER; -v_taxregistertotal NUMBER; - v_date DATE; v_settlementid varchar2(32); v_settlementdoctype_ID VARCHAR2(32); @@ -69,7 +64,6 @@ v_gljdocumentno VARCHAR(40); v_gl_journallineid varchar2(32); v_line NUMBER; -v_validcombination_ID VARCHAR2(32); v_glitem_acct VARCHAR2(32); v_glitem_ID VARCHAR2(32); @@ -91,18 +85,9 @@ v_name NVARCHAR2(255); v_TRTcountY NUMBER; v_TRTcountN NUMBER; -v_DBA_ErrorLog_ID VARCHAR2(32); v_dummy VARCHAR2(2000); v_count NUMBER:=0; v_FIN_PAYMENT_ID VARCHAR2(32); -v_FIN_PAYMENT_DETAIL_ID VARCHAR2(32); -v_FIN_FINACC_TRANSACTION_ID VARCHAR2(32); -v_PaymentDocType_ID VARCHAR2(32); -v_PaymentDocumentNo FIN_PAYMENT.DOCUMENTNO%TYPE; -v_Financial_Account_ID VARCHAR2(32); -v_PaymentMethod_ID VARCHAR2(32); -v_CreateFinTransaction FIN_FINACC_PAYMENTMETHOD.AUTOMATIC_RECEIPT%TYPE; -v_ExecutionType FIN_FINACC_PAYMENTMETHOD.PAYIN_EXECUTION_TYPE%TYPE; BEGIN -- Update AD_PInstance diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_TAX_GET_LEVEL.xml --- a/src-db/database/model/functions/C_TAX_GET_LEVEL.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_TAX_GET_LEVEL.xml Wed Sep 02 10:10:13 2015 +0200 @@ -30,7 +30,6 @@ /* * For the given target tax, it returns level. Level indicates the sequence NUMBER for the calculation of the given tax in its tree */ -v_ParentTax C_TAX.C_TAX_ID%TYPE; TYPE RECORD IS REF CURSOR; Cur_taxes RECORD; v_Level NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml --- a/src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -39,10 +39,7 @@ v_AD_TREE_ID VARCHAR(32) :=null; v_PARENT_ID VARCHAR(32) :=null; v_SeqNo NUMBER(38); - v_Next_Sequence_No VARCHAR(32) :=null; - v_Account_No VARCHAR(32) :=null; v_Acct_No_For_SubAccount VARCHAR(32) :=null; - v_Subacct_No VARCHAR(32) :=null; v_New_SubAccount_No VARCHAR(32) :=null; v_Default_Account_No VARCHAR(32) :=null; v_Seq_No_For_Subaccount_No VARCHAR(32) :=null; @@ -50,10 +47,7 @@ v_Default_Account_Desc CHARACTER VARYING(255); v_Default_Account_Client_ID VARCHAR(32); v_Org_ID VARCHAR(32); - v_Account_ID VARCHAR(32); - v_seq_name CHARACTER VARYING(255); v_C_AcctSchema_ID VARCHAR(32) :=null; - v_UpdateSequence CHAR; tmp_Subaccout_no VARCHAR(32) :=null; v_C_ElementValue_ID VARCHAR(32) :=null; v_Exist NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/FACT_ACCT_RESET.xml --- a/src-db/database/model/functions/FACT_ACCT_RESET.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/FACT_ACCT_RESET.xml Wed Sep 02 10:10:13 2015 +0200 @@ -59,7 +59,6 @@ c_commitInterval NUMBER:= 1000; v_count NUMBER; - v_DocAction VARCHAR2(60); v_UpdatedBy AD_PINSTANCE.UpdatedBy%TYPE; v_DeleteFact varchar2(1):='Y'; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_COPY_VERSION.xml --- a/src-db/database/model/functions/MA_COPY_VERSION.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_COPY_VERSION.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,7 +34,6 @@ v_Client_ID VARCHAR2(32); v_Org_ID VARCHAR2(32); v_User_ID VARCHAR2(32); - v_UpdatedBy VARCHAR2(32); v_DocumentNo NUMBER; v_Sequence_ID VARCHAR2(32); v_Product_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml --- a/src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -32,12 +32,9 @@ -- Logistice v_ResultStr VARCHAR2(2000):=''; v_Message VARCHAR2(2000):=''; - v_Record_ID VARCHAR2(32); - v_Result NUMBER:=1; -- Success -- Parameter TYPE RECORD IS REF CURSOR; -- Record Info - v_UpdatedBy VARCHAR2(32); -- v_Processing CHAR; -- v_Processed CHAR; v_Count NUMBER; @@ -48,7 +45,6 @@ v_ProductName VARCHAR2(100); Cur_GlobalUse RECORD; Cur_ProductionPlan RECORD; - v_AD_Client_ID VARCHAR2(32); BEGIN -- Get Parameters v_ResultStr:='ReadingParameters'; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml --- a/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -61,7 +61,6 @@ v_InsertCount NUMBER:=0; v_MA_Maint_Scheduled VARCHAR2(32); v_Maint MA_Maintenance%ROWTYPE; - v_InitDay NUMBER; BEGIN IF(p_PInstance_ID IS NOT NULL) THEN -- Update AD_PInstance diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_MEASURE_SHIFT_EXPLODE.xml --- a/src-db/database/model/functions/MA_MEASURE_SHIFT_EXPLODE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_MEASURE_SHIFT_EXPLODE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,8 +33,6 @@ v_Org_ID VARCHAR2(32); v_User_ID VARCHAR2(32); v_Shift VARCHAR2(60); - v_CCP_Group NUMBER; - v_Line NUMBER; v_Processed CHAR; v_Time DATE; v_Measure_Group VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_MEASURE_TIME_EXPLODE.xml --- a/src-db/database/model/functions/MA_MEASURE_TIME_EXPLODE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_MEASURE_TIME_EXPLODE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -35,7 +35,6 @@ v_Client_ID VARCHAR2(32); v_Org_ID VARCHAR2(32); v_User_ID VARCHAR2(32); - v_CCP_Group NUMBER; v_MeasureQty NUMBER; v_Line NUMBER; v_Processed CHAR; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_PC_CASE_CREATE.xml --- a/src-db/database/model/functions/MA_PC_CASE_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_PC_CASE_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -37,7 +37,6 @@ v_User_ID VARCHAR2(32); v_Client_ID VARCHAR2(32); v_Org_ID VARCHAR2(32); - v_Result NUMBER:=1; BEGIN -- Process Parameters IF(p_PInstance_ID IS NOT NULL) THEN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml --- a/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml Wed Sep 02 10:10:13 2015 +0200 @@ -55,7 +55,6 @@ v_StdPrecision NUMBER:=0; v_UseStdPrecisionInProduction CHAR(1); v_PlanLine NUMBER; - v_CostCenterCost NUMBER; v_CostCenterUse NUMBER; v_allownegativestock CHAR(1); v_Calculated CHAR(1); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_PRODUCTION_COST.xml --- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -31,7 +31,6 @@ --v_Message VARCHAR2(2000) := ''; -- Parameter TYPE RECORD IS REF CURSOR; - Cur_Parameter RECORD; v_Org_ID varchar2(32); v_Client_ID varchar2(32); @@ -42,7 +41,6 @@ v_productName M_Product.Name%TYPE; v_ProductionDate DATE; v_CostingDate DATE; - v_Result NUMBER:= 1; v_ProductionCost NUMBER; v_ProductionCost_Tmp NUMBER; v_ProducedKg NUMBER; @@ -55,9 +53,6 @@ v_Qty NUMBER; v_DateTo DATE; v_Costing_ID varchar2(32); - v_CostCenter_ID varchar2(32); - v_IC_Value NUMBER; - v_Cost_UOM CHAR; v_NextNo VARCHAR2(32); v_ProductionNo M_Production.DocumentNo%TYPE; v_iscostmigrated CHAR; @@ -69,7 +64,6 @@ Cur_Machine RECORD; Cur_IndirectCost RECORD; Cur_IndirectCostPorc RECORD; - FINISH_PROCESS BOOLEAN := FALSE; BEGIN BEGIN --BODY v_ResultStr := 'Update productionline calculated'; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml --- a/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -36,7 +36,6 @@ * Contributor(s): ______________________________________. ************************************************************************/ v_ResultStr VARCHAR2(2000) := ''; - v_Result NUMBER:= 1; v_CostCenterUse NUMBER; v_Multiplier NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PROCESSPLAN.xml --- a/src-db/database/model/functions/MRP_PROCESSPLAN.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PROCESSPLAN.xml Wed Sep 02 10:10:13 2015 +0200 @@ -44,14 +44,11 @@ -- Logistice v_ResultStr VARCHAR2(2000):=''; v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Count NUMBER; v_Count_Aux NUMBER; - v_Aux_ID VARCHAR2(32); v_planned CHAR(1) := 'N'; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_PlanProduct RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml --- a/src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml Wed Sep 02 10:10:13 2015 +0200 @@ -37,8 +37,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Stock NUMBER:= 0; v_AvailableStock NUMBER:= 0; @@ -46,7 +44,6 @@ v_NeededQty_New NUMBER; v_PlannedOrderDate_New DATE; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Lines RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE.xml --- a/src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,8 +34,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Qty NUMBER; v_PlannedDate DATE; @@ -53,7 +51,6 @@ v_QtyMin NUMBER; v_QtyStd NUMBER; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Childs RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE0.xml --- a/src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE0.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PROCESSPLAN_RECALCULATE0.xml Wed Sep 02 10:10:13 2015 +0200 @@ -30,8 +30,6 @@ v_PlanningDate DATE; v_SecurityMargin NUMBER; - - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PRODUCTION_RUN.xml --- a/src-db/database/model/functions/MRP_PRODUCTION_RUN.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PRODUCTION_RUN.xml Wed Sep 02 10:10:13 2015 +0200 @@ -37,8 +37,6 @@ v_PlanningDate DATE; v_SecurityMargin NUMBER; - - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PURCHASEORDER.xml --- a/src-db/database/model/functions/MRP_PURCHASEORDER.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PURCHASEORDER.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,8 +33,6 @@ v_COrder_ID VARCHAR2(32); v_COrderLine_ID VARCHAR2(32); v_DocumentNo NVARCHAR2(60); - v_created BOOLEAN := FALSE; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; v_M_Warehouse_ID VARCHAR2(32); v_Description nvarchar2(255); @@ -47,7 +45,6 @@ v_CDocTypeID varchar2(32); v_BPartner_Location_ID VARCHAR2(32); v_BillTo_ID VARCHAR2(32); - v_PriceListVersion NUMBER; v_PriceStd NUMBER; v_TaxId varchar2(32); v_ProductName NVARCHAR2(90); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PURCHASEPLAN.xml --- a/src-db/database/model/functions/MRP_PURCHASEPLAN.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PURCHASEPLAN.xml Wed Sep 02 10:10:13 2015 +0200 @@ -46,8 +46,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Aux_New VARCHAR2(32); @@ -62,7 +60,6 @@ v_planneddate_new DATE; v_planneddate_old DATE; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_PlanProduct RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_PURCHASE_RUN.xml --- a/src-db/database/model/functions/MRP_PURCHASE_RUN.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_PURCHASE_RUN.xml Wed Sep 02 10:10:13 2015 +0200 @@ -38,8 +38,6 @@ v_PlanningDate DATE; v_SecurityMargin NUMBER; - - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_REQUISITION.xml --- a/src-db/database/model/functions/MRP_REQUISITION.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_REQUISITION.xml Wed Sep 02 10:10:13 2015 +0200 @@ -36,7 +36,6 @@ v_DocumentNo NVARCHAR2(60); v_Line NUMBER:= 0; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_RUN_EXPLODE.xml --- a/src-db/database/model/functions/MRP_RUN_EXPLODE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_RUN_EXPLODE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -43,8 +43,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Count NUMBER; v_NewCount NUMBER; @@ -53,7 +51,6 @@ v_lastProductID VARCHAR2(32); v_qty NUMBER; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Run_Lines RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_RUN_INITIALIZE.xml --- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -58,8 +58,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(4000):=''; - v_Message VARCHAR2(4000):=''; - v_Result NUMBER:=1; -- 0=failure v_Count NUMBER; v_Aux_ID VARCHAR2(32); @@ -67,7 +65,6 @@ v_AD_Pinstance_ID VARCHAR2(32); v_QtyOnHand NUMBER; - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Product RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/MRP_WORKREQUIREMENT.xml --- a/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -23,19 +23,14 @@ -- Logistice v_ResultStr VARCHAR2(2000):=''; v_Message VARCHAR2(2000):=''; - v_Result NUMBER:=1; -- 0=failure v_Record_ID VARCHAR2(32); v_User_ID VARCHAR2(32):='0'; v_Client_ID VARCHAR2(32); v_Org_ID VARCHAR2(32); - v_TimeHorizon NUMBER; - v_PlanningDate DATE; - v_SecurityMargin NUMBER; v_WR_ID VARCHAR2(32); v_DocumentNo NVARCHAR2(60); - FINISH_PROCESS BOOLEAN DEFAULT FALSE; -- Parameter TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Wed Sep 02 10:10:13 2015 +0200 @@ -38,7 +38,6 @@ v_CheckResultStr VARCHAR2(2000):=''; v_CumQty NUMBER; v_PermanentQty NUMBER; - v_Processed VARCHAR2(60) ; v_count NUMBER; v_Deleted NUMBER; v_ProductOld VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml --- a/src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GENERATE_STANDARD_COSTS.xml Wed Sep 02 10:10:13 2015 +0200 @@ -28,7 +28,6 @@ ************************************************************************/ -- Logistice v_ResultStr VARCHAR2(2000):=''; - v_Result NUMBER; v_Message VARCHAR2(2000):=''; v_Record_ID VARCHAR2(32); v_User VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GET_OFFERS_NAME.xml --- a/src-db/database/model/functions/M_GET_OFFERS_NAME.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GET_OFFERS_NAME.xml Wed Sep 02 10:10:13 2015 +0200 @@ -26,7 +26,6 @@ * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ - v_Offer_ID VARCHAR2(32); TYPE RECORD IS REF CURSOR; Cur_Offer RECORD; v_Names varchar2(10000) := ''; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GET_PARETO_ABC.xml --- a/src-db/database/model/functions/M_GET_PARETO_ABC.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GET_PARETO_ABC.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,7 +33,6 @@ * Contributor(s): ______________________________________. ************************************************************************/ - v_orgList VARCHAR2(4000) ; VARaCUM NUMBER:=0; VARaCUMB NUMBER:=0; v_limitA NUMBER:=80; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GET_PARETO_ABC_LEGACY.xml --- a/src-db/database/model/functions/M_GET_PARETO_ABC_LEGACY.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GET_PARETO_ABC_LEGACY.xml Wed Sep 02 10:10:13 2015 +0200 @@ -30,7 +30,6 @@ * Contributor(s): ______________________________________. ************************************************************************/ - v_orgList VARCHAR2(4000) ; VARaCUM NUMBER:=0; VARaCUMB NUMBER:=0; v_limitA NUMBER:=80; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GET_STOCK.xml --- a/src-db/database/model/functions/M_GET_STOCK.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GET_STOCK.xml Wed Sep 02 10:10:13 2015 +0200 @@ -49,7 +49,6 @@ v_TableID VARCHAR2(32):='-1'; v_AuxID VARCHAR2(32):='-1'; v_LineNo NUMBER; - v_Count NUMBER:=1; v_ProcessID VARCHAR2(32) ; v_Reservation_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_GET_STOCK_PARAM.xml --- a/src-db/database/model/functions/M_GET_STOCK_PARAM.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_GET_STOCK_PARAM.xml Wed Sep 02 10:10:13 2015 +0200 @@ -84,16 +84,13 @@ * Contributor(s): ______________________________________. ************************************************************************/ -- Logistice - v_ResultStr VARCHAR2(2000):=''; v_Message VARCHAR2(2000):=''; v_Record_ID VARCHAR2(32); -- Parameter TYPE RECORD IS REF CURSOR; - Cur_Parameter RECORD; Cur_Stock RECORD; - Cur_MStock RECORD; cur_warehouse RECORD; cur_allocated RECORD; @@ -392,7 +389,6 @@ END IF; DECLARE v_sql VARCHAR2(2000); - v_applyrule CHAR(1); v_finalqty NUMBER; v_totalqty NUMBER; v_availableqty NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INOUTEXPLODEBOMNOTSTOCK.xml --- a/src-db/database/model/functions/M_INOUTEXPLODEBOMNOTSTOCK.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INOUTEXPLODEBOMNOTSTOCK.xml Wed Sep 02 10:10:13 2015 +0200 @@ -27,12 +27,9 @@ v_explode CHAR(1); v_inoutID VARCHAR2(32); v_CBPartner_ID VARCHAR2(32); - v_PriceList_ID VARCHAR2(32); - v_PriceList_Version_ID VARCHAR2(32); v_Record_ID VARCHAR2(32); TYPE RECORD IS REF CURSOR; Cur_Parameter RECORD; - Cur_MPriceListVersion RECORD; CUR_BOM_Line RECORD; CUR_BOM RECORD; v_Line NUMBER:=0; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INOUT_CANCEL.xml --- a/src-db/database/model/functions/M_INOUT_CANCEL.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INOUT_CANCEL.xml Wed Sep 02 10:10:13 2015 +0200 @@ -45,7 +45,6 @@ -- Parameter Variables -- Cur_InOut RECORD; - v_AD_Client_ID VARCHAR2(32); BEGIN -- Update AD_PInstance diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INOUT_CREATE.xml --- a/src-db/database/model/functions/M_INOUT_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -132,7 +132,6 @@ v_QtyOrder NUMBER; v_ProductUOM VARCHAR2(32); v_ActualQty NUMBER; - v_QtyAux NUMBER; -- v_lines NUMBER:=0; v_lines_per_orderline NUMBER:=0; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml --- a/src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -90,7 +90,6 @@ v_Invoice_ID VARCHAR2(32) ; v_NextNo VARCHAR2(32) ; v_DocType_ID VARCHAR2(32) ; - v_InvoiceNo NUMBER(10) ; v_DocumentNo C_INVOICE.DocumentNo%TYPE; v_IsDiscountPrinted CHAR(1) ; v_PaymentRule VARCHAR2(60) ; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INOUT_POST.xml --- a/src-db/database/model/functions/M_INOUT_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INOUT_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -73,7 +73,6 @@ -- v_Result NUMBER:=1; v_AD_Org_ID VARCHAR2(32); - v_Locator_Org_ID VARCHAR2(32); v_Warehouse_Org VARCHAR2(32); v_AD_Client_ID VARCHAR2(32); v_NextNo VARCHAR2(32); @@ -88,15 +87,10 @@ v_IsStocked NUMBER; v_DoctypeReversed_ID VARCHAR2(32); --MODIFIED BY F.IRIAZABAL - v_QtyOrder NUMBER; - v_ProductUOM NUMBER; - v_BreakDown VARCHAR2(60) ; - v_ActualQty NUMBER; v_QtyAux NUMBER; v_Count NUMBER:=0; v_Line VARCHAR2(10) ; v_OrderID_old VARCHAR2(32); - Cur_MILines RECORD; FINISH_PROCESS BOOLEAN:=false; v_Aux NUMBER; v_isSoTrx CHAR(1); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST1.xml --- a/src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST1.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST1.xml Wed Sep 02 10:10:13 2015 +0200 @@ -180,7 +180,6 @@ */ DECLARE v_voidintconsumption_id VARCHAR2(32); - cur_intcons_line RECORD; BEGIN -- Checks IF (v_status <> 'CO') THEN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_INVENTORY_POST.xml --- a/src-db/database/model/functions/M_INVENTORY_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_INVENTORY_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -39,7 +39,6 @@ v_User VARCHAR2(32); v_IsProcessing CHAR(1) ; v_IsProcessed VARCHAR2(60) ; - v_NoProcessed NUMBER:=0; v_is_included NUMBER:=0; v_available_period NUMBER:=0; v_is_ready AD_Org.IsReady%TYPE; @@ -62,7 +61,6 @@ PROCESS_ERROR BOOLEAN:=false; END_PROCESS BOOLEAN:=false; END_PROCESSING BOOLEAN:=false; - rowcount NUMBER; v_productname m_product.name%TYPE; BEGIN -- Update AD_PInstance diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_MOVEMENT_POST.xml --- a/src-db/database/model/functions/M_MOVEMENT_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_MOVEMENT_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -42,7 +42,6 @@ -- Parameter Variables v_IsProcessing CHAR(1) ; v_IsProcessed VARCHAR2(60) ; - v_NoProcessed NUMBER:=0; v_MoveDate DATE; v_Client_ID VARCHAR2(32) ; v_Org_ID VARCHAR2(32); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml --- a/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,8 +33,6 @@ v_invoiceId varchar2(32):=NULL; v_rappelInvoiceId varchar2(32):=NULL; v_invoicelineId varchar2(32):=NULL; - v_NoRecords NUMBER:=0; - v_DocType_ID VARCHAR2(32); v_DocumentNo VARCHAR2(40) ; v_seqno NUMBER(10) ; v_line NUMBER(10):=0; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_REQUISITION_CREATEPO.xml --- a/src-db/database/model/functions/M_REQUISITION_CREATEPO.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_REQUISITION_CREATEPO.xml Wed Sep 02 10:10:13 2015 +0200 @@ -28,7 +28,6 @@ v_User_ID VARCHAR2(32):='0'; v_Client_ID VARCHAR2(32); v_sales_rep_ID VARCHAR2(32); - v_Count NUMBER; v_C_DOCTYPE_ID VARCHAR2(32); v_C_Order_ID VARCHAR2(32); v_DocumentNo NVARCHAR2(60); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml --- a/src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -66,10 +66,8 @@ v_qtytounreserve NUMBER; v_qtytounreserve_aux NUMBER; v_qtyavailabletoreserve NUMBER; - v_qtyfromother NUMBER; v_newreservedqty NUMBER; v_availablestock NUMBER; - v_dummy VARCHAR2(2000); v_attr_description VARCHAR2(255); v_product_value VARCHAR2(40); v_locator_value VARCHAR2(40); diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml --- a/src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_UNIQUELOCATOR_RULE.xml Wed Sep 02 10:10:13 2015 +0200 @@ -33,7 +33,6 @@ v_quantity NUMBER; v_ProductID VARCHAR2(32); v_SelectedLocatorID VARCHAR2(32) ; - v_ProductName M_Product.NAME%TYPE; BEGIN v_ResultStr:='ReadingParameters'; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml --- a/src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml Wed Sep 02 10:10:13 2015 +0200 @@ -44,7 +44,6 @@ TYPE RECORD IS REF CURSOR; Cur_Cursor RECORD; Cur_Parameter RECORD; - v_AD_Client_ID VARCHAR2(32); v_totalCost NUMBER; BEGIN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT_LEGACY.xml --- a/src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT_LEGACY.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT_LEGACY.xml Wed Sep 02 10:10:13 2015 +0200 @@ -43,7 +43,6 @@ TYPE RECORD IS REF CURSOR; Cur_Cursor RECORD; Cur_Parameter RECORD; - v_AD_Client_ID VARCHAR2(32); BEGIN IF(p_PInstance_ID IS NOT NULL) THEN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/functions/S_TIMEEXPENSE_POST.xml --- a/src-db/database/model/functions/S_TIMEEXPENSE_POST.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/functions/S_TIMEEXPENSE_POST.xml Wed Sep 02 10:10:13 2015 +0200 @@ -35,7 +35,6 @@ v_Result NUMBER:=1; -- 0=failure v_Record_ID VARCHAR2(32); v_AD_User_ID VARCHAR2(32); - v_DayHours NUMBER; v_Processed VARCHAR2(60); v_CInvoicelineId varchar2(32); v_COrderlineId varchar2(32); @@ -78,7 +77,6 @@ DBMS_OUTPUT.PUT_LINE(' Record_ID=' || v_Record_ID) ; DECLARE CUR_te RECORD; - v_Hours NUMBER; BEGIN /* Check if there are expense lines to process */ diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_ACTIVITY_TRG.xml --- a/src-db/database/model/triggers/C_ACTIVITY_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_ACTIVITY_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -20,7 +20,6 @@ ************************************************************************/ v_xTree_ID VARCHAR2(32); v_xParent_ID VARCHAR2(32); - v_NextNo VARCHAR2(32); BEGIN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_CASHLINE_TRG.xml --- a/src-db/database/model/triggers/C_CASHLINE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_CASHLINE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -37,7 +37,6 @@ UPDATE C_CashLine cl SET C_Currency_ID = (SELECT b.C_Currency_ID FROM C_Cash c, C_CashBook b WHERE c.C_Cash_ID=cl.C_Cash_ID AND c.C_CashBook_ID=b.C_CashBook_ID) WHERE C_Currency_ID IS NULL; ************************************************************************/ - v_NextNo VARCHAR2(32); v_Currency_ID varchar2(32) := NULL; -- CashBook v_CB_Currency_ID varchar2(32); @@ -48,7 +47,6 @@ v_Org_ID varchar2(32); v_Cash_ID varchar2(32); v_Debt_Payment_ID varchar2(32) := NULL; - v_RO NUMBER; -- v_Trace VARCHAR2(2000) := 'CashLine: '; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml --- a/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -24,7 +24,6 @@ v_xTree_ID VARCHAR2(32); v_xParent_ID VARCHAR2(32); - v_NextNo VARCHAR2(32); v_count NUMBER; TYPE RECORD IS REF CURSOR; cur_AcctSchema RECORD; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_INVOICELINETAX_TRG.xml --- a/src-db/database/model/triggers/C_INVOICELINETAX_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_INVOICELINETAX_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -34,8 +34,6 @@ v_Processed VARCHAR(60); v_Increment_Amount C_ORDERTAX.TAXAMT%TYPE ; v_Increment_Base C_ORDERTAX.TAXBASEAMT%TYPE ; -v_totallines NUMBER:=0; -v_grandtotal NUMBER:=0; v_istaxincluded CHAR(1); BEGIN diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_INVOICELINE_BEFORE_TRG.xml --- a/src-db/database/model/triggers/C_INVOICELINE_BEFORE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_INVOICELINE_BEFORE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -21,7 +21,6 @@ v_std_prec NUMBER:=2; v_price_prec NUMBER:=2; - v_invoiceline_id VARCHAR2(32); v_invoice_id VARCHAR2(32); v_istaxincluded CHAR(1); v_PriceActual NUMBER; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_INVOICELINE_TRG.xml --- a/src-db/database/model/triggers/C_INVOICELINE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_INVOICELINE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -22,21 +22,8 @@ - v_newTaxBaseAmt NUMBER; - v_oldTaxBaseAmt NUMBER; - v_oldLine NUMBER:= 0; - v_newLine NUMBER:= 0; - v_taxAmt NUMBER:= 0; - v_HasTaxLine BOOLEAN := FALSE; - v_isPosted VARCHAR(60); v_ID varchar2(32); - v_Processed VARCHAR(60); - v_Prec NUMBER:=2; v_UOM_ID varchar2(32); - v_Currency VARCHAR2(32); - v_ChargeAmt NUMBER; - v_LineNetAmt NUMBER; - v_CinvoiceTaxID varchar2(32); v_AttrSetValueType M_Product.AttrSetValueType%TYPE; v_count NUMBER; v_IsCashVAT_Tax C_Tax.IsCashVAT%TYPE; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml --- a/src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -26,7 +26,6 @@ /************************************************************************* * Title: Check the introduced BP is the same as the Invoice ************************************************************************/ - v_n NUMBER; v_isprocessed C_Invoice.Processed%TYPE; v_bpheader_id C_Invoice.C_BPARTNER_ID%TYPE; v_bpreversed_id C_Invoice.C_BPARTNER_ID%TYPE; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_ORDERLINE_TRG.xml --- a/src-db/database/model/triggers/C_ORDERLINE_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_ORDERLINE_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -30,7 +30,6 @@ v_IsSOTrx CHAR(1); v_Count NUMBER; v_reservation_id VARCHAR2(32); - v_prereservedqty NUMBER; v_IsWithholding_Tax C_Tax.IsWithholdingTax%TYPE; v_IsCashVAT_Tax C_Tax.IsCashVAT%TYPE; v_IsCashVAT_Order C_Order.IsCashVAT%TYPE; diff -r f41aa6109535 -r e1ebf46e79ec src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml --- a/src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml Tue Sep 01 16:28:36 2015 +0200 +++ b/src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml Wed Sep 02 10:10:13 2015 +0200 @@ -3,11 +3,7 @@