details: https://code.openbravo.com/erp/devel/pi/rev/751493543c04 changeset: 35758:751493543c04 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Mon May 13 23:30:31 2019 +0530 summary: Fixes Issue 40865:Set VOLATILITY LEVEL for Database functions
** Set volatility level as IMMUTABLE for ad_isjavascriptword, ad_isjavaword, ad_mapping_format, ad_module_checked, c_add_months2, c_datedayinmonth, c_debt_payment_status, c_divide, c_get_isoweek_day, c_ignore_accent, c_invoicetodate, c_trim, last_day, m_get_offer_price, m_get_offer_std_price, m_get_offers_price, m_get_offers_std_price, m_warehouse_default_rule, m_warehouse_default_rule_param ** Rest are set with volatility level as STABLE diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml | 4 ++-- modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNOINVPAIDSTATUS.xml | 4 ++-- modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNUMBERPAYMENTSTATUS.xml | 4 ++-- src-db/database/model/functions/AD_COLUMN_IDENTIFIER.xml | 4 ++-- src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml | 4 ++-- src-db/database/model/functions/AD_COLUMN_IDENTIFIER_SQL.xml | 4 ++-- src-db/database/model/functions/AD_COLUMN_IDENTIFIER_STD.xml | 4 ++-- src-db/database/model/functions/AD_DBA_USER_CONST_SEARCHCOND.xml | 4 ++-- src-db/database/model/functions/AD_GET_DOCTYPE.xml | 4 ++-- src-db/database/model/functions/AD_GET_DOCTYPE_EXPENSES.xml | 4 ++-- src-db/database/model/functions/AD_GET_DOC_LE_BU.xml | 4 ++-- src-db/database/model/functions/AD_GET_LEVEL_NODE_TREE.xml | 4 ++-- src-db/database/model/functions/AD_GET_NODE_TREE_BYLEVEL.xml | 4 ++-- src-db/database/model/functions/AD_GET_ORG_LE_BU.xml | 4 ++-- src-db/database/model/functions/AD_GET_ORG_LE_BU_TREENODE.xml | 4 ++-- src-db/database/model/functions/AD_GET_PREFERENCE_VALUE.xml | 4 ++-- src-db/database/model/functions/AD_ISJAVASCRIPTWORD.xml | 4 ++-- src-db/database/model/functions/AD_ISJAVAWORD.xml | 4 ++-- src-db/database/model/functions/AD_ISMEMBERINCLUDED.xml | 4 ++-- src-db/database/model/functions/AD_ISORGINCLUDED.xml | 4 ++-- src-db/database/model/functions/AD_ISORGINCLUDED_TREENODE.xml | 4 ++-- src-db/database/model/functions/AD_MAPPING_FORMAT.xml | 4 ++-- src-db/database/model/functions/AD_MESSAGE_GET2.xml | 4 ++-- src-db/database/model/functions/AD_MODULE_CHECKED.xml | 4 ++-- src-db/database/model/functions/AD_MODULE_DEPENDENT.xml | 4 ++-- src-db/database/model/functions/AD_MODULE_IDENTIFIER.xml | 4 ++-- src-db/database/model/functions/AD_ORGTYPE_ISLE_ISBU.xml | 4 ++-- src-db/database/model/functions/AD_ORGTYPE_ISTRANS_ALLOWED.xml | 4 ++-- src-db/database/model/functions/AD_ORG_CHK_CALENDAR.xml | 4 ++-- src-db/database/model/functions/AD_ORG_CHK_READY.xml | 4 ++-- src-db/database/model/functions/AD_ORG_CHK_SCHEMAS.xml | 4 ++-- src-db/database/model/functions/AD_ORG_GETCALENDAROWNER.xml | 4 ++-- src-db/database/model/functions/AD_ORG_GETCALENDAROWNERTN.xml | 4 ++-- src-db/database/model/functions/AD_ORG_GETPERIODCONTROLALLOW.xml | 4 ++-- src-db/database/model/functions/AD_ORG_GETPERIODCONTROLALLOWTN.xml | 4 ++-- src-db/database/model/functions/AD_ORG_ISINNATURALTREE.xml | 4 ++-- src-db/database/model/functions/AD_PARENT_MENU_ELEMENT.xml | 4 ++-- src-db/database/model/functions/AD_PARENT_TREE.xml | 4 ++-- src-db/database/model/functions/C_ADD_MONTHS2.xml | 4 ++-- src-db/database/model/functions/C_AGING_GET_SCOPE.xml | 4 ++-- src-db/database/model/functions/C_BASE_CONVERT.xml | 4 ++-- src-db/database/model/functions/C_CALCULATECOST_CATSALARY.xml | 4 ++-- src-db/database/model/functions/C_CALCULATE_CATSALARY.xml | 4 ++-- src-db/database/model/functions/C_CHK_OPEN_PERIOD.xml | 4 ++-- src-db/database/model/functions/C_CHK_OPEN_PERIOD_GLJ.xml | 4 ++-- src-db/database/model/functions/C_CONVERT_DOC_CURRENCY.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_CONVERT.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_CONVERT0.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_CONVERT_PRECISION.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_CONVERT_RATE.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_ISOSYM.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_RATE.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_ROUND.xml | 4 ++-- src-db/database/model/functions/C_CURRENCY_SYMBOL.xml | 4 ++-- src-db/database/model/functions/C_DATEDAYINMONTH.xml | 4 ++-- src-db/database/model/functions/C_DB_PERCENTAGE_PAID.xml | 4 ++-- src-db/database/model/functions/C_DEBT_PAYMENT_PAID.xml | 4 ++-- src-db/database/model/functions/C_DEBT_PAYMENT_STATUS.xml | 4 ++-- src-db/database/model/functions/C_DEBT_PAYMENT_STATUS0.xml | 4 ++-- src-db/database/model/functions/C_DIVIDE.xml | 4 ++-- src-db/database/model/functions/C_GETBPLOCATIONID.xml | 4 ++-- src-db/database/model/functions/C_GETINVOICELINE_TAXAMOUNT.xml | 4 ++-- src-db/database/model/functions/C_GETINVOICESTATUSFROMSHIPMENT.xml | 2 +- src-db/database/model/functions/C_GETTAX.xml | 2 +- src-db/database/model/functions/C_GETWITHHOLDING.xml | 4 ++-- src-db/database/model/functions/C_GET_CURRENCY_PRECISION.xml | 4 ++-- src-db/database/model/functions/C_GET_DEFAULT_PERIOD.xml | 4 ++-- src-db/database/model/functions/C_GET_IBAN_DISPLAYED_ACCOUNT.xml | 4 ++-- src-db/database/model/functions/C_GET_ISOWEEK_DAY.xml | 4 ++-- src-db/database/model/functions/C_GET_NET_AMOUNT_FROM_GROSS.xml | 4 ++-- src-db/database/model/functions/C_GET_NET_PRICE_FROM_GROSS.xml | 4 ++-- src-db/database/model/functions/C_GET_PRODUCT_TAXCATEGORY.xml | 4 ++-- src-db/database/model/functions/C_GET_SERVICE_AMOUNT.xml | 4 ++-- src-db/database/model/functions/C_GET_TAX_AMT_FROM_NET.xml | 4 ++-- src-db/database/model/functions/C_IGNORE_ACCENT.xml | 4 ++-- src-db/database/model/functions/C_INVOICELINE_TAX.xml | 4 ++-- src-db/database/model/functions/C_INVOICETODATE.xml | 4 ++-- src-db/database/model/functions/C_INVOICE_PERCENTAGE_PAID.xml | 4 ++-- src-db/database/model/functions/C_LOCATION_DESCRIPTION.xml | 4 ++-- src-db/database/model/functions/C_LOCATION_IDENTIFIER.xml | 4 ++-- src-db/database/model/functions/C_LOCATION_NAME.xml | 4 ++-- src-db/database/model/functions/C_ORDER_STATUS.xml | 4 ++-- src-db/database/model/functions/C_PAYMENTDUEDATE.xml | 4 ++-- src-db/database/model/functions/C_TAX_GET_LEVEL.xml | 4 ++-- src-db/database/model/functions/C_TAX_GET_ROOT.xml | 4 ++-- src-db/database/model/functions/C_TAX_ISMEMBER.xml | 4 ++-- src-db/database/model/functions/C_TRIM.xml | 4 ++-- src-db/database/model/functions/C_UOM_CONVERT.xml | 4 ++-- src-db/database/model/functions/FIN_AGING_GETDOCNO.xml | 4 ++-- src-db/database/model/functions/FIN_AGING_INVOICECURRENCY_RATE.xml | 4 ++-- src-db/database/model/functions/FIN_AGING_ISDOUBTFULTDEBT.xml | 4 ++-- src-db/database/model/functions/FIN_AGING_PAYMENTCURRENCY_RATE.xml | 4 ++-- src-db/database/model/functions/MRP_CHECK_PLANNINGMETHOD.xml | 4 ++-- src-db/database/model/functions/M_BOM_PRICELIMIT.xml | 4 ++-- src-db/database/model/functions/M_BOM_PRICELIST.xml | 4 ++-- src-db/database/model/functions/M_BOM_PRICESTD.xml | 4 ++-- src-db/database/model/functions/M_BOM_QTY_AVAILABLE.xml | 4 ++-- src-db/database/model/functions/M_BOM_QTY_ONHAND.xml | 4 ++-- src-db/database/model/functions/M_BOM_QTY_ORDERED.xml | 4 ++-- src-db/database/model/functions/M_BOM_QTY_RESERVED.xml | 4 ++-- src-db/database/model/functions/M_CHECK_STOCK.xml | 4 ++-- src-db/database/model/functions/M_GETJSONDESCRIPTION.xml | 4 ++-- src-db/database/model/functions/M_GET_CONVERTED_AUMQTY.xml | 4 ++-- src-db/database/model/functions/M_GET_CONVERTED_QTY.xml | 4 ++-- src-db/database/model/functions/M_GET_COST.xml | 4 ++-- src-db/database/model/functions/M_GET_NO_TRX_PRODUCT_COST.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFER.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFERS_NAME.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFERS_PRICE.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFERS_STD_PRICE.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFER_PRICE.xml | 4 ++-- src-db/database/model/functions/M_GET_OFFER_STD_PRICE.xml | 4 ++-- src-db/database/model/functions/M_GET_PARETO_ABC.xml | 4 ++-- src-db/database/model/functions/M_GET_PARETO_ABC_LEGACY.xml | 4 ++-- src-db/database/model/functions/M_GET_PRICELIST_VERSION.xml | 4 ++-- src-db/database/model/functions/M_GET_PRODUCT_COST.xml | 4 ++-- src-db/database/model/functions/M_GET_PRODUCT_PRICE.xml | 4 ++-- src-db/database/model/functions/M_GET_PRODUCT_PRICE_DATE.xml | 4 ++-- src-db/database/model/functions/M_GET_TRANSACTION_COST.xml | 4 ++-- src-db/database/model/functions/M_GET_TRX_AND_PRODUCT_COST.xml | 4 ++-- src-db/database/model/functions/M_ISPARENT_CH_VALUE.xml | 4 ++-- src-db/database/model/functions/M_WAREHOUSE_DEFAULT_RULE.xml | 4 ++-- src-db/database/model/functions/M_WAREHOUSE_DEFAULT_RULE_PARAM.xml | 4 ++-- src-db/database/model/postscript-PostgreSql.sql | 8 ++++---- src-db/database/model/prescript-PostgreSql.sql | 4 ++-- 125 files changed, 250 insertions(+), 250 deletions(-) diffs (truncated from 2501 to 300 lines): diff -r 39feb7c05796 -r 751493543c04 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 Mon May 13 14:40:35 2019 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION APRM_ISPAYMENTCONFIRMED"> - <function name="APRM_ISPAYMENTCONFIRMED" type="VARCHAR"> + <function name="APRM_ISPAYMENTCONFIRMED" type="VARCHAR" volatility="STABLE"> <parameter name="status" type="VARCHAR" mode="in"> <default/> </parameter> @@ -19,7 +19,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) 2011-2018 Openbravo SLU +* All portions are Copyright (C) 2011-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNOINVPAIDSTATUS.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNOINVPAIDSTATUS.xml Mon May 13 14:40:35 2019 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNOINVPAIDSTATUS.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION APRM_SEQNOINVPAIDSTATUS"> - <function name="APRM_SEQNOINVPAIDSTATUS" type="VARCHAR"> + <function name="APRM_SEQNOINVPAIDSTATUS" type="VARCHAR" volatility="STABLE"> <parameter name="p_paymentmethod_id" type="VARCHAR" mode="in"> <default/> </parameter> @@ -22,7 +22,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) 2015-2018 Openbravo SLU +* All portions are Copyright (C) 2015-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNUMBERPAYMENTSTATUS.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNUMBERPAYMENTSTATUS.xml Mon May 13 14:40:35 2019 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_SEQNUMBERPAYMENTSTATUS.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION APRM_SEQNUMBERPAYMENTSTATUS"> - <function name="APRM_SEQNUMBERPAYMENTSTATUS" type="VARCHAR"> + <function name="APRM_SEQNUMBERPAYMENTSTATUS" type="VARCHAR" volatility="STABLE"> <parameter name="status" type="VARCHAR" mode="in"> <default/> </parameter> @@ -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) 2014-2018 Openbravo SLU +* All portions are Copyright (C) 2014-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_COLUMN_IDENTIFIER.xml --- a/src-db/database/model/functions/AD_COLUMN_IDENTIFIER.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_COLUMN_IDENTIFIER.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_COLUMN_IDENTIFIER"> - <function name="AD_COLUMN_IDENTIFIER" type="VARCHAR"> + <function name="AD_COLUMN_IDENTIFIER" type="VARCHAR" volatility="STABLE"> <parameter name="p_tablename" type="VARCHAR" mode="in"> <default/> </parameter> @@ -22,7 +22,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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml --- a/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_COLUMN_IDENTIFIER_REF_SQL"> - <function name="AD_COLUMN_IDENTIFIER_REF_SQL" type="VARCHAR"> + <function name="AD_COLUMN_IDENTIFIER_REF_SQL" type="VARCHAR" volatility="STABLE"> <parameter name="p_tableref" type="VARCHAR" mode="in"> <default/> </parameter> @@ -28,7 +28,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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_COLUMN_IDENTIFIER_SQL.xml --- a/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_SQL.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_SQL.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_COLUMN_IDENTIFIER_SQL"> - <function name="AD_COLUMN_IDENTIFIER_SQL" type="VARCHAR"> + <function name="AD_COLUMN_IDENTIFIER_SQL" type="VARCHAR" volatility="STABLE"> <parameter name="p_tablename" type="VARCHAR" mode="in"> <default/> </parameter> @@ -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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_COLUMN_IDENTIFIER_STD.xml --- a/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_STD.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_STD.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_COLUMN_IDENTIFIER_STD"> - <function name="AD_COLUMN_IDENTIFIER_STD" type="VARCHAR"> + <function name="AD_COLUMN_IDENTIFIER_STD" type="VARCHAR" volatility="STABLE"> <parameter name="p_tablename" type="VARCHAR" mode="in"> <default/> </parameter> @@ -19,7 +19,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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_DBA_USER_CONST_SEARCHCOND.xml --- a/src-db/database/model/functions/AD_DBA_USER_CONST_SEARCHCOND.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_DBA_USER_CONST_SEARCHCOND.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_DBA_USER_CONST_SEARCHCOND"> - <function name="AD_DBA_USER_CONST_SEARCHCOND" type="VARCHAR"> + <function name="AD_DBA_USER_CONST_SEARCHCOND" type="VARCHAR" volatility="STABLE"> <parameter name="p_constraintname" type="VARCHAR" mode="in"> <default/> </parameter> @@ -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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_DOCTYPE.xml --- a/src-db/database/model/functions/AD_GET_DOCTYPE.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_DOCTYPE.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_DOCTYPE"> - <function name="AD_GET_DOCTYPE" type="VARCHAR"> + <function name="AD_GET_DOCTYPE" type="VARCHAR" volatility="STABLE"> <parameter name="p_clientid" type="VARCHAR" mode="in"> <default/> </parameter> @@ -25,7 +25,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-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_DOCTYPE_EXPENSES.xml --- a/src-db/database/model/functions/AD_GET_DOCTYPE_EXPENSES.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_DOCTYPE_EXPENSES.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_DOCTYPE_EXPENSES"> - <function name="AD_GET_DOCTYPE_EXPENSES" type="VARCHAR"> + <function name="AD_GET_DOCTYPE_EXPENSES" type="VARCHAR" volatility="STABLE"> <parameter name="p_clientid" type="VARCHAR" mode="in"> <default/> </parameter> @@ -25,7 +25,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) 2010 Openbravo SLU +* All portions are Copyright (C) 2010-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_DOC_LE_BU.xml --- a/src-db/database/model/functions/AD_GET_DOC_LE_BU.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_DOC_LE_BU.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_DOC_LE_BU"> - <function name="AD_GET_DOC_LE_BU" type="VARCHAR"> + <function name="AD_GET_DOC_LE_BU" type="VARCHAR" volatility="STABLE"> <parameter name="p_header_table" type="VARCHAR" mode="in"> <default/> </parameter> @@ -25,7 +25,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) 2009-2012 Openbravo SLU +* All portions are Copyright (C) 2009-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_LEVEL_NODE_TREE.xml --- a/src-db/database/model/functions/AD_GET_LEVEL_NODE_TREE.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_LEVEL_NODE_TREE.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_LEVEL_NODE_TREE"> - <function name="AD_GET_LEVEL_NODE_TREE" type="NUMERIC"> + <function name="AD_GET_LEVEL_NODE_TREE" type="NUMERIC" volatility="STABLE"> <parameter name="p_tree_id" type="VARCHAR" mode="in"> <default/> </parameter> @@ -19,7 +19,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) 2012 Openbravo SLU +* All portions are Copyright (C) 2012-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_NODE_TREE_BYLEVEL.xml --- a/src-db/database/model/functions/AD_GET_NODE_TREE_BYLEVEL.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_NODE_TREE_BYLEVEL.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_NODE_TREE_BYLEVEL"> - <function name="AD_GET_NODE_TREE_BYLEVEL" type="VARCHAR"> + <function name="AD_GET_NODE_TREE_BYLEVEL" type="VARCHAR" volatility="STABLE"> <parameter name="p_tree_id" type="VARCHAR" mode="in"> <default/> </parameter> @@ -22,7 +22,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) 2012 Openbravo SLU +* All portions are Copyright (C) 2012-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_ORG_LE_BU.xml --- a/src-db/database/model/functions/AD_GET_ORG_LE_BU.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_ORG_LE_BU.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_ORG_LE_BU"> - <function name="AD_GET_ORG_LE_BU" type="VARCHAR"> + <function name="AD_GET_ORG_LE_BU" type="VARCHAR" volatility="STABLE"> <parameter name="p_org_id" type="VARCHAR" mode="in"> <default/> </parameter> @@ -19,7 +19,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) 2012-2018 Openbravo SLU +* All portions are Copyright (C) 2012-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ diff -r 39feb7c05796 -r 751493543c04 src-db/database/model/functions/AD_GET_ORG_LE_BU_TREENODE.xml --- a/src-db/database/model/functions/AD_GET_ORG_LE_BU_TREENODE.xml Mon May 13 14:40:35 2019 +0200 +++ b/src-db/database/model/functions/AD_GET_ORG_LE_BU_TREENODE.xml Mon May 13 23:30:31 2019 +0530 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="FUNCTION AD_GET_ORG_LE_BU_TREENODE"> - <function name="AD_GET_ORG_LE_BU_TREENODE" type="VARCHAR"> + <function name="AD_GET_ORG_LE_BU_TREENODE" type="VARCHAR" volatility="STABLE"> <parameter name="p_org_id" type="VARCHAR" mode="in"> <default/> </parameter> @@ -19,7 +19,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) 2018 Openbravo SLU +* All portions are Copyright (C) 2018-2019 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits