Fixes Issue 9420: DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix)
authorharikrishnan
Tue, 30 Jun 2009 16:28:59 +0530
changeset 4076 c55fcd703033
parent 4075 1d333b902d58
child 4077 9bec250411e0
Fixes Issue 9420: DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix)
src-db/database/model/functions/C_GENERATESOFROMPROJECTORDER.xml
src-db/database/model/functions/C_REMITTANCE_POST.xml
src-db/database/model/functions/C_TAXPAYMENT_POST.xml
--- a/src-db/database/model/functions/C_GENERATESOFROMPROJECTORDER.xml	Tue Jun 30 16:23:03 2009 +0530
+++ b/src-db/database/model/functions/C_GENERATESOFROMPROJECTORDER.xml	Tue Jun 30 16:28:59 2009 +0530
@@ -31,7 +31,7 @@
     v_C_Order_ID VARCHAR2(32);
     v_C_OrderLine_ID VARCHAR2(32);
     v_C_DOCTYPE_ID VARCHAR2(32);
-    v_DocumentNo NUMBER;
+    v_DocumentNo VARCHAR(40);
   BEGIN
     --  Update AD_PInstance
     DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID) ;
--- a/src-db/database/model/functions/C_REMITTANCE_POST.xml	Tue Jun 30 16:23:03 2009 +0530
+++ b/src-db/database/model/functions/C_REMITTANCE_POST.xml	Tue Jun 30 16:28:59 2009 +0530
@@ -69,7 +69,7 @@
     v_Status_to VARCHAR(60) ;
     v_Consolidate VARCHAR(60) ;
     v_SettlementID varchar2(32) ;
-    v_DocumentNo NUMBER;
+    v_DocumentNo VARCHAR(40);
     v_DPMId varchar2(32);
     v_DPId varchar2(32);
     v_DPMLineId varchar2(32);
--- a/src-db/database/model/functions/C_TAXPAYMENT_POST.xml	Tue Jun 30 16:23:03 2009 +0530
+++ b/src-db/database/model/functions/C_TAXPAYMENT_POST.xml	Tue Jun 30 16:28:59 2009 +0530
@@ -55,7 +55,7 @@
 v_date DATE;
 v_settlementid varchar2(32);
 v_settlementdoctype_ID VARCHAR2(32);
-v_sdocumentno NUMBER;
+v_sdocumentno VARCHAR(40);
 v_debtpaymentid varchar2(32);
 v_debtpaymentbalancingid varchar2(32);
 v_paymentrule VARCHAR2(30);
@@ -63,10 +63,10 @@
 
 
 v_gl_journalbatchid varchar2(32);
-v_gljbdocumentno NUMBER;
+v_gljbdocumentno VARCHAR(40);
 v_gl_journaldoctype_ID VARCHAR2(32);
 v_gl_journalid varchar2(32);
-v_gljdocumentno NUMBER;
+v_gljdocumentno VARCHAR(40);
 v_gl_journallineid varchar2(32);
 v_line NUMBER;
 v_validcombination_ID VARCHAR2(32);