0038754: Add extension point in MA_PRODUCTION_COST procedure

diff --git a/src-db/database/model/functions/MA_PRODUCTION_COST.xml b/src-db/database/model/functions/MA_PRODUCTION_COST.xml
--- a/src-db/database/model/functions/MA_PRODUCTION_COST.xml
+++ b/src-db/database/model/functions/MA_PRODUCTION_COST.xml
@@ -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 --git a/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml b/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
--- a/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
+++ b/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
@@ -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>