CI: promote changesets from pi to main
authorRM packaging bot <staff.rm@openbravo.com>
Tue, 12 Oct 2010 19:39:28 +0000
changeset 8810 813c8d5808cc
parent 8809 23d64ad8bd7b (current diff)
parent 8518 db409a855f2d (diff)
child 8811 8e8cd8bfe8c7
CI: promote changesets from pi to main
src-db/database/sourcedata/AD_MODULE.xml
--- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml	Tue Oct 12 04:33:12 2010 +0000
+++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml	Tue Oct 12 19:39:28 2010 +0000
@@ -65,6 +65,7 @@
   TYPE RECORD IS REF CURSOR;
     Cur_Parameter RECORD;
     Cur_BankstatementDebtpayment RECORD;
+    Cur_BankstatementLine RECORD;
     -- Parameter Variables
     --  Parameter Variables
     v_Processed CHAR(1) ;
@@ -80,6 +81,8 @@
     v_BS_Date DATE;
     v_AD_Org_ID VARCHAR2(32);
     v_AD_Client_ID VARCHAR2(32) ;
+    v_ValutadatePeriod_ID NUMBER(10) ;
+    v_DateacctPeriod_ID NUMBER(10) ;
     FINISH_PROCESS BOOLEAN:=false;
   BEGIN
     --  Update AD_PInstance
@@ -371,6 +374,19 @@
        RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@DebtAmountsSamemoneyNoMatch@') ;
       END IF;
     END IF;--FINISH_PROCESS
+    FOR Cur_BankstatementLine IN 
+      (SELECT valutadate, 
+              dateacct 
+      FROM C_BANKSTATEMENTLINE
+      WHERE C_BANKSTATEMENT_ID = v_Record_ID
+      AND ISACTIVE='Y')
+    LOOP
+      v_ValutadatePeriod_ID := C_CHK_OPEN_PERIOD (v_AD_Org_ID, Cur_BankstatementLine.valutadate, 'CMB',NULL);
+      v_DateacctPeriod_ID := C_CHK_OPEN_PERIOD (v_AD_Org_ID, Cur_BankstatementLine.dateacct, 'CMB',NULL);
+      IF (v_ValutadatePeriod_ID <> 1 OR v_DateacctPeriod_ID <> 1) THEN
+        RAISE_APPLICATION_ERROR(-20000, '@PeriodNotAvailable@') ;
+      END IF;
+    END LOOP;
     IF(NOT FINISH_PROCESS) THEN
       SELECT COUNT(*),
         MAX(bsl.Line)
--- a/src-db/database/sourcedata/AD_FIELD.xml	Tue Oct 12 04:33:12 2010 +0000
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Tue Oct 12 19:39:28 2010 +0000
@@ -45975,7 +45975,7 @@
 <!--3790-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--3790-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--3790-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--3790-->  <NAME><![CDATA[Create/Post Production]]></NAME>
+<!--3790-->  <NAME><![CDATA[Create/Process Production]]></NAME>
 <!--3790-->  <DESCRIPTION><![CDATA[Create production lines, if not created - otherwise process the production]]></DESCRIPTION>
 <!--3790-->  <HELP><![CDATA[Create/Post Production will generate the production lines and process the production.  If the production lines already exists, the production will be processed]]></HELP>
 <!--3790-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
--- a/src-db/database/sourcedata/AD_MODULE.xml	Tue Oct 12 04:33:12 2010 +0000
+++ b/src-db/database/sourcedata/AD_MODULE.xml	Tue Oct 12 19:39:28 2010 +0000
@@ -6,7 +6,7 @@
 <!--0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--0-->  <NAME><![CDATA[Core]]></NAME>
-<!--0-->  <VERSION><![CDATA[2.50.18525]]></VERSION>
+<!--0-->  <VERSION><![CDATA[2.50.18528]]></VERSION>
 <!--0-->  <DESCRIPTION><![CDATA[Core module is the base one]]></DESCRIPTION>
 <!--0-->  <HELP><![CDATA[Core module is the base one, all developments in core are included as part of the standard Openbravo ERP.]]></HELP>
 <!--0-->  <URL><![CDATA[www.openbravo.com]]></URL>
--- a/src-db/database/sourcedata/AD_PROCESS.xml	Tue Oct 12 04:33:12 2010 +0000
+++ b/src-db/database/sourcedata/AD_PROCESS.xml	Tue Oct 12 19:39:28 2010 +0000
@@ -692,7 +692,7 @@
 <!--137-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--137-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--137-->  <VALUE><![CDATA[M_Production]]></VALUE>
-<!--137-->  <NAME><![CDATA[Create/Post Production]]></NAME>
+<!--137-->  <NAME><![CDATA[Create/Process Production]]></NAME>
 <!--137-->  <DESCRIPTION><![CDATA[Create production lines, if not created - otherwise process the production]]></DESCRIPTION>
 <!--137-->  <HELP><![CDATA[Create/Post Production will generate the production lines and process the production.  If the production lines already exists, the production will be processed]]></HELP>
 <!--137-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
@@ -702,6 +702,7 @@
 <!--137-->  <ISDIRECTPRINT><![CDATA[N]]></ISDIRECTPRINT>
 <!--137-->  <ISBACKGROUND><![CDATA[N]]></ISBACKGROUND>
 <!--137-->  <ISJASPER><![CDATA[N]]></ISJASPER>
+<!--137-->  <ISEXTERNALSERVICE><![CDATA[N]]></ISEXTERNALSERVICE>
 <!--137-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--137-->  <UIPATTERN><![CDATA[S]]></UIPATTERN>
 <!--137--></AD_PROCESS>