details: https://code.openbravo.com/erp/devel/pi/rev/3aa3c6a68c93
changeset: 34255:3aa3c6a68c93
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Tue Jun 26 13:15:20 2018 +0200
summary: Fixes Issue 38754. Adds extension point at the end of Production Cost
Process to allow to extend it's logic
diffstat:
src-db/database/model/functions/MA_PRODUCTION_COST.xml | 28 ++++++++++++++++++
src-db/database/sourcedata/AD_EXTENSION_POINTS.xml | 10 ++++++
2 files changed, 38 insertions(+), 0 deletions(-)
diffs (58 lines):
diff -r 8d1e45356308 -r 3aa3c6a68c93
src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml Fri Jun 29
10:18:27 2018 +0200
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml Tue Jun 26
13:15:20 2018 +0200
@@ -595,6 +595,34 @@
END IF;
END LOOP;
+ --ma_production_cost - Finish Process Extension Point
+ SELECT count(*) INTO v_count
+ FROM DUAL
+ where exists (select 1 from ad_ep_procedures where ad_extension_points_id
= '9A3AFB83226246C490EEB51352F2314F');
+ IF (v_count=1) THEN
+ DECLARE
+ v_ep_instance VARCHAR2(32);
+ v_extension_point_id VARCHAR2(32) :=
'9A3AFB83226246C490EEB51352F2314F';
+ BEGIN
+ v_ep_instance := get_uuid();
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'p_production_id',
+ p_production_id, NULL, NULL, NULL, NULL, NULL, NULL);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id, 'User',
+ p_User_ID, NULL, NULL, NULL, NULL, NULL, NULL);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'Message',
+ NULL, NULL, NULL, NULL, NULL, NULL, v_Message);
+ AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id);
+
+ SELECT p_text INTO v_Message
+ FROM ad_ep_instance_para
+ WHERE ad_ep_instance_id = v_ep_instance
+ AND parametername LIKE 'Message';
+
+ DELETE FROM ad_ep_instance_para
+ WHERE ad_ep_instance_id = v_ep_instance;
+ END;
+ END IF;
+
RETURN;
END; --BODY
diff -r 8d1e45356308 -r 3aa3c6a68c93
src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
--- a/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml Fri Jun 29
10:18:27 2018 +0200
+++ b/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml Tue Jun 26
13:15:20 2018 +0200
@@ -90,6 +90,16 @@
<!--931282171E0E4E07A946AD80D9A16E08--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--931282171E0E4E07A946AD80D9A16E08--></AD_EXTENSION_POINTS>
+<!--9A3AFB83226246C490EEB51352F2314F--><AD_EXTENSION_POINTS>
+<!--9A3AFB83226246C490EEB51352F2314F-->
<AD_EXTENSION_POINTS_ID><![CDATA[9A3AFB83226246C490EEB51352F2314F]]></AD_EXTENSION_POINTS_ID>
+<!--9A3AFB83226246C490EEB51352F2314F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A3AFB83226246C490EEB51352F2314F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A3AFB83226246C490EEB51352F2314F--> <NAME><![CDATA[MA_Production_Cost -
Finish Process]]></NAME>
+<!--9A3AFB83226246C490EEB51352F2314F--> <DESCRIPTION><![CDATA[Extension point
at the end of the MA_Production_Cost. It has 3 available parameters
M_Production_ID, User and Message]]></DESCRIPTION>
+<!--9A3AFB83226246C490EEB51352F2314F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9A3AFB83226246C490EEB51352F2314F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A3AFB83226246C490EEB51352F2314F--></AD_EXTENSION_POINTS>
+
<!--C3A4ABF2DF544F4694142DA9E79495F7--><AD_EXTENSION_POINTS>
<!--C3A4ABF2DF544F4694142DA9E79495F7-->
<AD_EXTENSION_POINTS_ID><![CDATA[C3A4ABF2DF544F4694142DA9E79495F7]]></AD_EXTENSION_POINTS_ID>
<!--C3A4ABF2DF544F4694142DA9E79495F7-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
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
