details: http://code.openbravo.com/erp/devel/pi/rev/c738754d7090
changeset: 3455:c738754d7090
user: Juan Pablo Aroztegi <juanpablo.aroztegi <at> openbravo.com>
date: Thu Mar 26 16:18:34 2009 +0100
summary: Fix database inconsistency
diffstat:
src-db/database/model/functions/AD_TAB_IMPORT.xml | 2 +-
src-db/database/model/functions/M_INOUT_CREATE.xml | 48 ++++++++--------
src-db/database/model/functions/M_INOUT_POST.xml | 24 ++++----
src-db/database/sourcedata/AD_TEXTINTERFACES.xml | 58 +++++++++++++++++--
4 files changed, 88 insertions(+), 44 deletions(-)
diffs (223 lines):
diff -r 6d262312282f -r c738754d7090
src-db/database/model/functions/AD_TAB_IMPORT.xml
--- a/src-db/database/model/functions/AD_TAB_IMPORT.xml Thu Mar 26 13:11:57
2009 +0100
+++ b/src-db/database/model/functions/AD_TAB_IMPORT.xml Thu Mar 26 16:18:34
2009 +0100
@@ -41,7 +41,7 @@
v_AD_User_ID VARCHAR2(32):='0';
v_module_id varchar2(32);
v_fieldModule varchar2(32);
- v_Aux number;
+ v_Aux NUMBER;
-- Parameter
TYPE RECORD IS REF CURSOR;
Cur_Parameter RECORD;
diff -r 6d262312282f -r c738754d7090
src-db/database/model/functions/M_INOUT_CREATE.xml
--- a/src-db/database/model/functions/M_INOUT_CREATE.xml Thu Mar 26
13:11:57 2009 +0100
+++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Thu Mar 26
16:18:34 2009 +0100
@@ -1,24 +1,24 @@
-<?xml version="1.0"?>
- <database name="FUNCTION M_INOUT_CREATE">
- <function name="M_INOUT_CREATE" type="NULL">
- <parameter name="p_pinstance_id" type="VARCHAR" mode="in">
- <default/>
- </parameter>
- <parameter name="p_inout_id" type="VARCHAR" mode="out">
- <default/>
- </parameter>
- <parameter name="p_order_id" type="VARCHAR" mode="in">
- <default><![CDATA[NULL]]></default>
- </parameter>
- <parameter name="p_invoice_id" type="VARCHAR" mode="in">
- <default><![CDATA[NULL]]></default>
- </parameter>
- <parameter name="p_forcedelivery" type="CHAR" mode="in">
- <default><![CDATA[N]]></default>
- </parameter>
- <parameter name="p_locator_id" type="VARCHAR" mode="in">
- <default><![CDATA[NULL]]></default>
- </parameter>
+<?xml version="1.0"?>
+ <database name="FUNCTION M_INOUT_CREATE">
+ <function name="M_INOUT_CREATE" type="NULL">
+ <parameter name="p_pinstance_id" type="VARCHAR" mode="in">
+ <default/>
+ </parameter>
+ <parameter name="p_inout_id" type="VARCHAR" mode="out">
+ <default/>
+ </parameter>
+ <parameter name="p_order_id" type="VARCHAR" mode="in">
+ <default><![CDATA[NULL]]></default>
+ </parameter>
+ <parameter name="p_invoice_id" type="VARCHAR" mode="in">
+ <default><![CDATA[NULL]]></default>
+ </parameter>
+ <parameter name="p_forcedelivery" type="CHAR" mode="in">
+ <default><![CDATA[N]]></default>
+ </parameter>
+ <parameter name="p_locator_id" type="VARCHAR" mode="in">
+ <default><![CDATA[NULL]]></default>
+ </parameter>
<body><![CDATA[/*************************************************************************
* The contents of this file are subject to the Compiere Public
* License 1.1 ("License"); You may not use this file except in
@@ -745,6 +745,6 @@
p_InOut_ID:=0; -- Error Indicator
RETURN;
END M_INOUT_CREATE
-]]></body>
- </function>
- </database>
+]]></body>
+ </function>
+ </database>
diff -r 6d262312282f -r c738754d7090
src-db/database/model/functions/M_INOUT_POST.xml
--- a/src-db/database/model/functions/M_INOUT_POST.xml Thu Mar 26 13:11:57
2009 +0100
+++ b/src-db/database/model/functions/M_INOUT_POST.xml Thu Mar 26 16:18:34
2009 +0100
@@ -1,12 +1,12 @@
-<?xml version="1.0"?>
- <database name="FUNCTION M_INOUT_POST">
- <function name="M_INOUT_POST" type="NULL">
- <parameter name="p_pinstance_id" type="VARCHAR" mode="in">
- <default/>
- </parameter>
- <parameter name="p_inout_id" type="VARCHAR" mode="in">
- <default/>
- </parameter>
+<?xml version="1.0"?>
+ <database name="FUNCTION M_INOUT_POST">
+ <function name="M_INOUT_POST" type="NULL">
+ <parameter name="p_pinstance_id" type="VARCHAR" mode="in">
+ <default/>
+ </parameter>
+ <parameter name="p_inout_id" type="VARCHAR" mode="in">
+ <default/>
+ </parameter>
<body><![CDATA[/*************************************************************************
* The contents of this file are subject to the Compiere Public
* License 1.1 ("License"); You may not use this file except in
@@ -614,6 +614,6 @@
END IF;
RETURN;
END M_INOUT_POST
-]]></body>
- </function>
- </database>
+]]></body>
+ </function>
+ </database>
diff -r 6d262312282f -r c738754d7090
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Thu Mar 26 13:11:57
2009 +0100
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Thu Mar 26 16:18:34
2009 +0100
@@ -10060,7 +10060,7 @@
<!--807192--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--807192--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--807192--> <TEXT><![CDATA[Line No]]></TEXT>
-<!--807192--> <ISUSED><![CDATA[N]]></ISUSED>
+<!--807192--> <ISUSED><![CDATA[Y]]></ISUSED>
<!--807192--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--807192--></AD_TEXTINTERFACES>
@@ -13806,7 +13806,7 @@
<!--808685--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--808685--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--808685--> <TEXT><![CDATA[90 days]]></TEXT>
-<!--808685--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--808685--> <ISUSED><![CDATA[N]]></ISUSED>
<!--808685--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--808685--></AD_TEXTINTERFACES>
@@ -14015,7 +14015,7 @@
<!--809757--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--809757--> <TEXT><![CDATA[Ordered]]></TEXT>
<!--809757-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
-<!--809757--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--809757--> <ISUSED><![CDATA[N]]></ISUSED>
<!--809757--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--809757--></AD_TEXTINTERFACES>
@@ -14026,7 +14026,7 @@
<!--809758--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--809758--> <TEXT><![CDATA[Promised]]></TEXT>
<!--809758-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
-<!--809758--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--809758--> <ISUSED><![CDATA[N]]></ISUSED>
<!--809758--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--809758--></AD_TEXTINTERFACES>
@@ -14037,7 +14037,7 @@
<!--809759--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--809759--> <TEXT><![CDATA[On hand]]></TEXT>
<!--809759-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
-<!--809759--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--809759--> <ISUSED><![CDATA[N]]></ISUSED>
<!--809759--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--809759--></AD_TEXTINTERFACES>
@@ -21809,7 +21809,7 @@
<!--06B4693E9FC911DDAB14BB995340D9FD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--06B4693E9FC911DDAB14BB995340D9FD--> <TEXT><![CDATA[Create from
shipment]]></TEXT>
<!--06B4693E9FC911DDAB14BB995340D9FD-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_actionButton/CreateFrom_ShipmentPO.html]]></FILENAME>
-<!--06B4693E9FC911DDAB14BB995340D9FD--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--06B4693E9FC911DDAB14BB995340D9FD--> <ISUSED><![CDATA[N]]></ISUSED>
<!--06B4693E9FC911DDAB14BB995340D9FD-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--06B4693E9FC911DDAB14BB995340D9FD--></AD_TEXTINTERFACES>
@@ -22329,6 +22329,50 @@
<!--4D6F7EFED00711DDBE8C001D09C4A2FE-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--4D6F7EFED00711DDBE8C001D09C4A2FE--></AD_TEXTINTERFACES>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--><AD_TEXTINTERFACES>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2-->
<AD_TEXTINTERFACES_ID><![CDATA[4EEFB2221A1611DEAEA3001EEC1F37D2]]></AD_TEXTINTERFACES_ID>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--> <TEXT><![CDATA[Ordered Date]]></TEXT>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4EEFB2221A1611DEAEA3001EEC1F37D2--></AD_TEXTINTERFACES>
+
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--><AD_TEXTINTERFACES>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2-->
<AD_TEXTINTERFACES_ID><![CDATA[4EF9B9F21A1611DEAC7A001EEC1F37D2]]></AD_TEXTINTERFACES_ID>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--> <TEXT><![CDATA[Promised Date]]></TEXT>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4EF9B9F21A1611DEAC7A001EEC1F37D2--></AD_TEXTINTERFACES>
+
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--><AD_TEXTINTERFACES>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2-->
<AD_TEXTINTERFACES_ID><![CDATA[4EFC7A201A1611DE8D83001EEC1F37D2]]></AD_TEXTINTERFACES_ID>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--> <TEXT><![CDATA[Ordered
Quantity]]></TEXT>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4EFC7A201A1611DE8D83001EEC1F37D2--></AD_TEXTINTERFACES>
+
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--><AD_TEXTINTERFACES>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2-->
<AD_TEXTINTERFACES_ID><![CDATA[4EFD44F01A1611DEAD46001EEC1F37D2]]></AD_TEXTINTERFACES_ID>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--> <TEXT><![CDATA[On hand
Quantity]]></TEXT>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml]]></FILENAME>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4EFD44F01A1611DEAD46001EEC1F37D2--></AD_TEXTINTERFACES>
+
<!--55475CE61F5C3E65E040007F01016323--><AD_TEXTINTERFACES>
<!--55475CE61F5C3E65E040007F01016323-->
<AD_TEXTINTERFACES_ID><![CDATA[55475CE61F5C3E65E040007F01016323]]></AD_TEXTINTERFACES_ID>
<!--55475CE61F5C3E65E040007F01016323-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -24799,7 +24843,7 @@
<!--62BB400C6236C615E040007F01010E78--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--62BB400C6236C615E040007F01010E78--> <TEXT><![CDATA[Copyright Openbravo
2001-2009]]></TEXT>
<!--62BB400C6236C615E040007F01010E78-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/security/Login_F1.html]]></FILENAME>
-<!--62BB400C6236C615E040007F01010E78--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--62BB400C6236C615E040007F01010E78--> <ISUSED><![CDATA[N]]></ISUSED>
<!--62BB400C6236C615E040007F01010E78-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--62BB400C6236C615E040007F01010E78--></AD_TEXTINTERFACES>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
