script.sql

select count(*) from ggate.log;

CREATE OR REPLACE PROCEDURE "DUMMPY" (
   BEFORE_TICKET_AREA           IN VARCHAR2,
   AFTER_TICKET_AREA            IN VARCHAR2,
   BEFORE_AREA_UNIT             IN VARCHAR2,
   AFTER_AREA_UNIT              IN VARCHAR2,
   BEFORE_DI_FLAG               IN VARCHAR2,
   AFTER_DI_FLAG                IN VARCHAR2,
   BEFORE_SWIFT_SETTLE_2        IN VARCHAR2,
   AFTER_SWIFT_SETTLE_2         IN VARCHAR2,
   BEFORE_SWIFT_SETTLE_3        IN VARCHAR2,
   AFTER_SWIFT_SETTLE_3         IN VARCHAR2,
   BEFORE_EXTERN_NUM_DBEM       IN VARCHAR2,
   AFTER_EXTERN_NUM_DBEM        IN VARCHAR2,
   BEFORE_NDF_ORIG_TID          IN VARCHAR2,
   AFTER_NDF_ORIG_TID           IN VARCHAR2,
   BEFORE_INVERT                IN VARCHAR2,
   AFTER_INVERT                 IN VARCHAR2,
   BEFORE_BK_TYPE               IN VARCHAR2,
   AFTER_BK_TYPE                IN VARCHAR2,
   BEFORE_INVMAN                IN VARCHAR2,
   AFTER_INVMAN                 IN VARCHAR2,
   BEFORE_INVMAN_TID            IN VARCHAR2,
   AFTER_INVMAN_TID             IN VARCHAR2,
   BEFORE_POINTS                IN NUMBER,
   AFTER_POINTS                 IN NUMBER,
   BEFORE_NDF_STCCY             IN VARCHAR2,
   AFTER_NDF_STCCY              IN VARCHAR2,
   BEFORE_OTC_EXO_BARR2         IN VARCHAR2,
   AFTER_OTC_EXO_BARR2          IN VARCHAR2,
   BEFORE_OTC_EXO_FREE4         IN VARCHAR2,
   AFTER_OTC_EXO_FREE4          IN VARCHAR2,
   BEFORE_CCY1_TRADE_RATE       IN NUMBER,
   AFTER_CCY1_TRADE_RATE        IN NUMBER,
   BEFORE_CCY2_TRADE_RATE       IN NUMBER,
   AFTER_CCY2_TRADE_RATE        IN NUMBER,
   BEFORE_CLS_FLAG              IN VARCHAR2,
   AFTER_CLS_FLAG               IN VARCHAR2,
   BEFORE_CITY                  IN VARCHAR2,
   AFTER_CITY                   IN VARCHAR2,
   BEFORE_NDF_RTAREA            IN VARCHAR2,
   AFTER_NDF_RTAREA             IN VARCHAR2,
   BEFORE_NDF_FEEDT             IN DATE,
   AFTER_NDF_FEEDT              IN DATE,
   BEFORE_NDF_FEECCY            IN VARCHAR2,
   AFTER_NDF_FEECCY             IN VARCHAR2,
   BEFORE_NDF_FEEAMT            IN NUMBER,
   AFTER_NDF_FEEAMT             IN NUMBER,
   BEFORE_NDF_CONTY             IN VARCHAR2,
   AFTER_NDF_CONTY              IN VARCHAR2,
   BEFORE_CLS_SESSION_ID        IN VARCHAR2,
   AFTER_CLS_SESSION_ID         IN VARCHAR2,
   BEFORE_SPOT_MARGIN2_POINTS   IN NUMBER,
   AFTER_SPOT_MARGIN2_POINTS    IN NUMBER,
   BEFORE_SPOT_MARGIN2_AMT      IN NUMBER,
   AFTER_SPOT_MARGIN2_AMT       IN NUMBER,
   BEFORE_SPOT_MARGIN1_POINTS   IN NUMBER,
   AFTER_SPOT_MARGIN1_POINTS    IN NUMBER,
   BEFORE_SPOT_MARGIN1_AMT      IN NUMBER,
   AFTER_SPOT_MARGIN1_AMT       IN NUMBER,
   BEFORE_FWD_MARGIN2_POINTS    IN NUMBER,
   AFTER_FWD_MARGIN2_POINTS     IN NUMBER,
   BEFORE_FWD_MARGIN2_AMT       IN NUMBER,
   AFTER_FWD_MARGIN2_AMT        IN NUMBER,
   BEFORE_FWD_MARGIN1_POINTS    IN NUMBER,
   AFTER_FWD_MARGIN1_POINTS     IN NUMBER,
   BEFORE_FWD_MARGIN1_AMT       IN NUMBER,
   AFTER_FWD_MARGIN1_AMT        IN NUMBER,
   BEFORE_CONFIRMATION          IN VARCHAR2,
   AFTER_CONFIRMATION           IN VARCHAR2,
   BEFORE_MATCH_QUEUE           IN VARCHAR2,
   AFTER_MATCH_QUEUE            IN VARCHAR2,
   BEFORE_SDR_USI               IN VARCHAR2,
   AFTER_SDR_USI                IN VARCHAR2,
   BEFORE_SDR_UPI               IN VARCHAR2,
   AFTER_SDR_UPI                IN VARCHAR2,
   BEFORE_SDR_RPT_TRADE         IN VARCHAR2,
   AFTER_SDR_RPT_TRADE          IN VARCHAR2,
   BEFORE_SDR_RPT_PARTY         IN VARCHAR2,
   AFTER_SDR_RPT_PARTY          IN VARCHAR2,
   BEFORE_SDR_REPORTED          IN VARCHAR2,
   AFTER_SDR_REPORTED           IN VARCHAR2,
   BEFORE_SDR_PRIOR_USI         IN VARCHAR2,
   AFTER_SDR_PRIOR_USI          IN VARCHAR2,
   BEFORE_SDR_ORIG_USI          IN VARCHAR2,
   AFTER_SDR_ORIG_USI           IN VARCHAR2,
   BEFORE_SDR_EXECUTION_TIME    IN VARCHAR2,
   AFTER_SDR_EXECUTION_TIME     IN VARCHAR2,
   BEFORE_TRADE_SPOT_DATE       IN DATE,
   AFTER_TRADE_SPOT_DATE        IN DATE,
   BEFORE_WSS_GDP_SITE          IN VARCHAR2,
   AFTER_WSS_GDP_SITE           IN VARCHAR2,
   BEFORE_WSS_TID               IN VARCHAR2,
   AFTER_WSS_TID                IN VARCHAR2,
   BEFORE_WSS_GDP_TIME          IN DATE,
   AFTER_WSS_GDP_TIME           IN DATE,
   BEFORE_AMT_BOUGHT            IN NUMBER,
   AFTER_AMT_BOUGHT             IN NUMBER,
   BEFORE_AMT_BOUGHT_EURO       IN NUMBER,
   AFTER_AMT_BOUGHT_EURO        IN NUMBER,
   BEFORE_AMT_SOLD              IN NUMBER,
   AFTER_AMT_SOLD               IN NUMBER,
   BEFORE_AMT_SOLD_EURO         IN NUMBER,
   AFTER_AMT_SOLD_EURO          IN NUMBER,
   BEFORE_APP                   IN VARCHAR2,
   AFTER_APP                    IN VARCHAR2,
   BEFORE_ARBITRAGE_FLAG        IN VARCHAR2,
   AFTER_ARBITRAGE_FLAG         IN VARCHAR2,
   BEFORE_ARB_TID_1             IN VARCHAR2,
   AFTER_ARB_TID_1              IN VARCHAR2,
   BEFORE_ARB_TID_2             IN VARCHAR2,
   AFTER_ARB_TID_2              IN VARCHAR2,
   BEFORE_AREA_INT_NO           IN VARCHAR2,
   AFTER_AREA_INT_NO            IN VARCHAR2,
   BEFORE_AVG_TO_DATE           IN NUMBER,
   AFTER_AVG_TO_DATE            IN NUMBER,
   BEFORE_BACK_DATED            IN VARCHAR2,
   AFTER_BACK_DATED             IN VARCHAR2,
   BEFORE_BASE_CCY              IN VARCHAR2,
   AFTER_BASE_CCY               IN VARCHAR2,
   BEFORE_BASE_EQUIV_AMOUNT     IN NUMBER,
   AFTER_BASE_EQUIV_AMOUNT      IN NUMBER,
   BEFORE_BASE_EQUIV_RATE       IN NUMBER,
   AFTER_BASE_EQUIV_RATE        IN NUMBER,
   BEFORE_BREAKOUT_TID          IN VARCHAR2,
   AFTER_BREAKOUT_TID           IN VARCHAR2,
   BEFORE_BROKER_CODE           IN VARCHAR2,
   AFTER_BROKER_CODE            IN VARCHAR2,
   BEFORE_BROKER_COMM           IN NUMBER,
   AFTER_BROKER_COMM            IN NUMBER,
   BEFORE_BROKER_TID            IN VARCHAR2,
   AFTER_BROKER_TID             IN VARCHAR2,
   BEFORE_CALL_CCY              IN VARCHAR2,
   AFTER_CALL_CCY               IN VARCHAR2,
   BEFORE_CALL_CCY_AMOUNT       IN NUMBER,
   AFTER_CALL_CCY_AMOUNT        IN NUMBER,
   BEFORE_CANCEL_DATE           IN DATE,
   AFTER_CANCEL_DATE            IN DATE,
   BEFORE_CANCEL_REASON         IN VARCHAR2,
   AFTER_CANCEL_REASON          IN VARCHAR2,
   BEFORE_CASH_ADJ              IN NUMBER,
   AFTER_CASH_ADJ               IN NUMBER,
   BEFORE_CCY_BOUGHT            IN VARCHAR2,
   AFTER_CCY_BOUGHT             IN VARCHAR2,
   BEFORE_CCY_SOLD              IN VARCHAR2,
   AFTER_CCY_SOLD               IN VARCHAR2,
   BEFORE_CP_AMOUNT             IN NUMBER,
   AFTER_CP_AMOUNT              IN NUMBER,
   BEFORE_CP_TYPE               IN VARCHAR2,
   AFTER_CP_TYPE                IN VARCHAR2,
   BEFORE_CUR_SPOT_REV          IN NUMBER,
   AFTER_CUR_SPOT_REV           IN NUMBER,
   BEFORE_CUR_SPOT_TRD          IN NUMBER,
   AFTER_CUR_SPOT_TRD           IN NUMBER,
   BEFORE_CUR_VAL               IN NUMBER,
   AFTER_CUR_VAL                IN NUMBER,
   BEFORE_CUR_VAL_DIS           IN NUMBER,
   AFTER_CUR_VAL_DIS            IN NUMBER,
   BEFORE_CUSTOMER_REF          IN VARCHAR2,
   AFTER_CUSTOMER_REF           IN VARCHAR2,
   BEFORE_CUST_TID              IN VARCHAR2,
   AFTER_CUST_TID               IN VARCHAR2,
   BEFORE_DEAL_CODE             IN VARCHAR2,
   AFTER_DEAL_CODE              IN VARCHAR2,
   BEFORE_DEAL_NUMBER           IN VARCHAR2,
   AFTER_DEAL_NUMBER            IN VARCHAR2,
   BEFORE_ENTRY_DATE_TIME       IN DATE,
   AFTER_ENTRY_DATE_TIME        IN DATE,
   BEFORE_FSI_TID               IN VARCHAR2,
   AFTER_FSI_TID                IN VARCHAR2,
   BEFORE_FSI_REC_TID           IN VARCHAR2,
   AFTER_FSI_REC_TID            IN VARCHAR2,
   BEFORE_FULLY_APP             IN VARCHAR2,
   AFTER_FULLY_APP              IN VARCHAR2,
   BEFORE_FWD_FLAG              IN VARCHAR2,
   AFTER_FWD_FLAG               IN VARCHAR2,
   BEFORE_FWD_SPOT              IN VARCHAR2,
   AFTER_FWD_SPOT               IN VARCHAR2,
   BEFORE_MAR_AMT1              IN NUMBER,
   AFTER_MAR_AMT1               IN NUMBER,
   BEFORE_MAR_NPV               IN NUMBER,
   AFTER_MAR_NPV                IN NUMBER,
   BEFORE_MAR_PTS1              IN NUMBER,
   AFTER_MAR_PTS1               IN NUMBER,
   BEFORE_NDF_FIXDT             IN DATE,
   AFTER_NDF_FIXDT              IN DATE,
   BEFORE_OPTIONS_FLAG          IN VARCHAR2,
   AFTER_OPTIONS_FLAG           IN VARCHAR2,
   BEFORE_ORIG_TID              IN VARCHAR2,
   AFTER_ORIG_TID               IN VARCHAR2,
   BEFORE_OTC_CODE              IN VARCHAR2,
   AFTER_OTC_CODE               IN VARCHAR2,
   BEFORE_OTC_DEL_DATE          IN DATE,
   AFTER_OTC_DEL_DATE           IN DATE,
   BEFORE_OTC_ET                IN VARCHAR2,
   AFTER_OTC_ET                 IN VARCHAR2,
   BEFORE_OTC_EXC_DATE          IN DATE,
   AFTER_OTC_EXC_DATE           IN DATE,
   BEFORE_OTC_EXO_BARR1         IN VARCHAR2,
   AFTER_OTC_EXO_BARR1          IN VARCHAR2,
   BEFORE_OTC_EXO_DATE1         IN DATE,
   AFTER_OTC_EXO_DATE1          IN DATE,
   BEFORE_OTC_EXO_DATE2         IN DATE,
   AFTER_OTC_EXO_DATE2          IN DATE,
   BEFORE_OTC_EXO_FREE1         IN VARCHAR2,
   AFTER_OTC_EXO_FREE1          IN VARCHAR2,
   BEFORE_OTC_EXO_FREE2         IN VARCHAR2,
   AFTER_OTC_EXO_FREE2          IN VARCHAR2,
   BEFORE_OTC_EXO_FREE3         IN VARCHAR2,
   AFTER_OTC_EXO_FREE3          IN VARCHAR2,
   BEFORE_OTC_EXP_TIME          IN VARCHAR2,
   AFTER_OTC_EXP_TIME           IN VARCHAR2,
   BEFORE_OTC_FDC1              IN NUMBER,
   AFTER_OTC_FDC1               IN NUMBER,
   BEFORE_OTC_FDC2              IN NUMBER,
   AFTER_OTC_FDC2               IN NUMBER,
   BEFORE_OTC_PREM              IN NUMBER,
   AFTER_OTC_PREM               IN NUMBER,
   BEFORE_OTC_PREM_CCY          IN VARCHAR2,
   AFTER_OTC_PREM_CCY           IN VARCHAR2,
   BEFORE_OTC_PREM_CNV          IN NUMBER,
   AFTER_OTC_PREM_CNV           IN NUMBER,
   BEFORE_OTC_PREM_DD           IN DATE,
   AFTER_OTC_PREM_DD            IN DATE,
   BEFORE_OTC_PREM_NO           IN NUMBER,
   AFTER_OTC_PREM_NO            IN NUMBER,
   BEFORE_OTC_PREM_TYPE         IN VARCHAR2,
   AFTER_OTC_PREM_TYPE          IN VARCHAR2,
   BEFORE_OTC_SDC1              IN NUMBER,
   AFTER_OTC_SDC1               IN NUMBER,
   BEFORE_OTC_SDC2              IN NUMBER,
   AFTER_OTC_SDC2               IN NUMBER,
   BEFORE_OTC_SPOT_RATE         IN NUMBER,
   AFTER_OTC_SPOT_RATE          IN NUMBER,
   BEFORE_OTC_TYPE              IN VARCHAR2,
   AFTER_OTC_TYPE               IN VARCHAR2,
   BEFORE_OTC_TYPE_CODE         IN VARCHAR2,
   AFTER_OTC_TYPE_CODE          IN VARCHAR2,
   BEFORE_PAY_NOSTRO            IN VARCHAR2,
   AFTER_PAY_NOSTRO             IN VARCHAR2,
   BEFORE_PORT_TID              IN VARCHAR2,
   AFTER_PORT_TID               IN VARCHAR2,
   BEFORE_PRODUCT               IN VARCHAR2,
   AFTER_PRODUCT                IN VARCHAR2,
   BEFORE_PUT_CCY               IN VARCHAR2,
   AFTER_PUT_CCY                IN VARCHAR2,
   BEFORE_PUT_CCY_AMOUNT        IN NUMBER,
   AFTER_PUT_CCY_AMOUNT         IN NUMBER,
   BEFORE_RATE                  IN NUMBER,
   AFTER_RATE                   IN NUMBER,
   BEFORE_REASON                IN VARCHAR2,
   AFTER_REASON                 IN VARCHAR2,
   BEFORE_REC_INTL              IN VARCHAR2,
   AFTER_REC_INTL               IN VARCHAR2,
   BEFORE_REC_NOSTRO            IN VARCHAR2,
   AFTER_REC_NOSTRO             IN VARCHAR2,
   BEFORE_REMARK1               IN VARCHAR2,
   AFTER_REMARK1                IN VARCHAR2,
   BEFORE_REMARK2               IN VARCHAR2,
   AFTER_REMARK2                IN VARCHAR2,
   BEFORE_REMARK3               IN VARCHAR2,
   AFTER_REMARK3                IN VARCHAR2,
   BEFORE_REUTERS_DEAL_NO       IN VARCHAR2,
   AFTER_REUTERS_DEAL_NO        IN VARCHAR2,
   BEFORE_REUTERS_NODE          IN VARCHAR2,
   AFTER_REUTERS_NODE           IN VARCHAR2,
   BEFORE_SPOT_DATE             IN DATE,
   AFTER_SPOT_DATE              IN DATE,
   BEFORE_START_DATE            IN DATE,
   AFTER_START_DATE             IN DATE,
   BEFORE_STATUS_FLAG           IN VARCHAR2,
   AFTER_STATUS_FLAG            IN VARCHAR2,
   BEFORE_SWAP_TID              IN VARCHAR2,
   AFTER_SWAP_TID               IN VARCHAR2,
   BEFORE_SWAP_POINTS           IN NUMBER,
   AFTER_SWAP_POINTS            IN NUMBER,
   BEFORE_SWAP_SF               IN VARCHAR2,
   AFTER_SWAP_SF                IN VARCHAR2,
   BEFORE_TIME_OP               IN VARCHAR2,
   AFTER_TIME_OP                IN VARCHAR2,
   BEFORE_TO_ORIG_TID           IN VARCHAR2,
   AFTER_TO_ORIG_TID            IN VARCHAR2,
   BEFORE_TRADER                IN VARCHAR2,
   AFTER_TRADER                 IN VARCHAR2,
   BEFORE_TRADER_NAME           IN VARCHAR2,
   AFTER_TRADER_NAME            IN VARCHAR2,
   BEFORE_TRADE_DATE            IN DATE,
   AFTER_TRADE_DATE             IN DATE,
   BEFORE_TRAN_TYPE             IN VARCHAR2,
   AFTER_TRAN_TYPE              IN VARCHAR2,
   BEFORE_VALUE_DATE            IN DATE,
   AFTER_VALUE_DATE             IN DATE,
   BEFORE_AMT_1                 IN NUMBER,
   AFTER_AMT_1                  IN NUMBER,
   BEFORE_AMT_2                 IN NUMBER,
   AFTER_AMT_2                  IN NUMBER,
   BEFORE_CCY_1                 IN VARCHAR2,
   AFTER_CCY_1                  IN VARCHAR2,
   BEFORE_CCY_2                 IN VARCHAR2,
   AFTER_CCY_2                  IN VARCHAR2)
IS
   msgid        RAW (16);
   xmlContent   CLOB;
BEGIN
   -- DBMS_OUTPUT.put_line ('operation begin -- >> ');

   --    xmlContent :=
   --    '<operation numCols="149" type="" ts="'
   --    || TO_CHAR (SYSDATE, 'yyyy-MM-dd HH24:mi:ss')
   --    || '" pos="">  <col index="0" name="TICKET_AREA">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TICKET_AREA
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TICKET_AREA
   --    || ']]></after>
   --   </col>
   --   <col index="1" name="AREA_UNIT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AREA_UNIT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AREA_UNIT
   --    || ']]></after>
   --   </col>
   --   <col index="2" name="DI_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_DI_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_DI_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="3" name="SWIFT_SETTLE_2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SWIFT_SETTLE_2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SWIFT_SETTLE_2
   --    || ']]></after>
   --   </col>
   --   <col index="4" name="SWIFT_SETTLE_3">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SWIFT_SETTLE_3
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SWIFT_SETTLE_3
   --    || ']]></after>
   --   </col>
   --   <col index="5" name="EXTERN_NUM_DBEM">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_EXTERN_NUM_DBEM
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_EXTERN_NUM_DBEM
   --    || ']]></after>
   --   </col>
   --   <col index="6" name="NDF_ORIG_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_ORIG_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_ORIG_TID
   --    || ']]></after>
   --   </col>
   --   <col index="7" name="INVERT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_INVERT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_INVERT
   --    || ']]></after>
   --   </col>
   --   <col index="8" name="BK_TYPE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BK_TYPE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BK_TYPE
   --    || ']]></after>
   --   </col>
   --   <col index="9" name="INVMAN">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_INVMAN
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_INVMAN
   --    || ']]></after>
   --   </col>
   --   <col index="10" name="INVMAN_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_INVMAN_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_INVMAN_TID
   --    || ']]></after>
   --   </col>
   --   <col index="11" name="POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="12" name="NDF_STCCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_STCCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_STCCY
   --    || ']]></after>
   --   </col>
   --   <col index="13" name="OTC_EXO_BARR2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_BARR2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_BARR2
   --    || ']]></after>
   --   </col>
   --   <col index="14" name="OTC_EXO_FREE4">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_FREE4
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_FREE4
   --    || ']]></after>
   --   </col>
   --   <col index="15" name="CCY1_TRADE_RATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY1_TRADE_RATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY1_TRADE_RATE
   --    || ']]></after>
   --   </col>
   --   <col index="16" name="CCY2_TRADE_RATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY2_TRADE_RATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY2_TRADE_RATE
   --    || ']]></after>
   --   </col>
   --   <col index="17" name="CLS_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CLS_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CLS_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="18" name="CITY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CITY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CITY
   --    || ']]></after>
   --   </col>
   --   <col index="19" name="NDF_RTAREA">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_RTAREA
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_RTAREA
   --    || ']]></after>
   --   </col>
   --   <col index="20" name="NDF_FEEDT">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_NDF_FEEDT, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_NDF_FEEDT, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="21" name="NDF_FEECCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_FEECCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_FEECCY
   --    || ']]></after>
   --   </col>
   --   <col index="22" name="NDF_FEEAMT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_FEEAMT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_FEEAMT
   --    || ']]></after>
   --   </col>
   --   <col index="23" name="NDF_CONTY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_NDF_CONTY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_NDF_CONTY
   --    || ']]></after>
   --   </col>
   --   <col index="24" name="CLS_SESSION_ID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CLS_SESSION_ID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CLS_SESSION_ID
   --    || ']]></after>
   --   </col>
   --   <col index="25" name="SPOT_MARGIN2_POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SPOT_MARGIN2_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SPOT_MARGIN2_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="26" name="SPOT_MARGIN2_AMT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SPOT_MARGIN2_AMT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SPOT_MARGIN2_AMT
   --    || ']]></after>
   --   </col>
   --   <col index="27" name="SPOT_MARGIN1_POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SPOT_MARGIN1_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SPOT_MARGIN1_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="28" name="SPOT_MARGIN1_AMT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SPOT_MARGIN1_AMT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SPOT_MARGIN1_AMT
   --    || ']]></after>
   --   </col>
   --   <col index="29" name="FWD_MARGIN2_POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_MARGIN2_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_MARGIN2_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="30" name="FWD_MARGIN2_AMT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_MARGIN2_AMT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_MARGIN2_AMT
   --    || ']]></after>
   --   </col>
   --   <col index="31" name="FWD_MARGIN1_POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_MARGIN1_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_MARGIN1_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="32" name="FWD_MARGIN1_AMT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_MARGIN1_AMT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_MARGIN1_AMT
   --    || ']]></after>
   --   </col>
   --   <col index="33" name="CONFIRMATION">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CONFIRMATION
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CONFIRMATION
   --    || ']]></after>
   --   </col>
   --   <col index="34" name="MATCH_QUEUE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_MATCH_QUEUE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_MATCH_QUEUE
   --    || ']]></after>
   --   </col>
   --   <col index="35" name="SDR_USI">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_USI
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_USI
   --    || ']]></after>
   --   </col>
   --   <col index="36" name="SDR_UPI">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_UPI
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_UPI
   --    || ']]></after>
   --   </col>
   --   <col index="37" name="SDR_RPT_TRADE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_RPT_TRADE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_RPT_TRADE
   --    || ']]></after>
   --   </col>
   --   <col index="38" name="SDR_RPT_PARTY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_RPT_PARTY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_RPT_PARTY
   --    || ']]></after>
   --   </col>
   --   <col index="39" name="SDR_REPORTED">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_REPORTED
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_REPORTED
   --    || ']]></after>
   --   </col>
   --   <col index="40" name="SDR_PRIOR_USI">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_PRIOR_USI
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_PRIOR_USI
   --    || ']]></after>
   --   </col>
   --   <col index="41" name="SDR_ORIG_USI">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_ORIG_USI
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_ORIG_USI
   --    || ']]></after>
   --   </col>
   --   <col index="42" name="SDR_EXECUTION_TIME">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SDR_EXECUTION_TIME
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SDR_EXECUTION_TIME
   --    || ']]></after>
   --   </col>
   --   <col index="43" name="TRADE_SPOT_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_TRADE_SPOT_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_TRADE_SPOT_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="44" name="WSS_GDP_SITE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_WSS_GDP_SITE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_WSS_GDP_SITE
   --    || ']]></after>
   --   </col>
   --   <col index="45" name="WSS_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_WSS_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_WSS_TID
   --    || ']]></after>
   --   </col>
   --   <col index="46" name="WSS_GDP_TIME">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_WSS_GDP_TIME, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_WSS_GDP_TIME, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="47" name="AMT_BOUGHT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_BOUGHT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_BOUGHT
   --    || ']]></after>
   --   </col>
   --   <col index="48" name="AMT_BOUGHT_EURO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_BOUGHT_EURO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_BOUGHT_EURO
   --    || ']]></after>
   --   </col>
   --   <col index="49" name="AMT_SOLD">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_SOLD
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_SOLD
   --    || ']]></after>
   --   </col>
   --   <col index="50" name="AMT_SOLD_EURO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_SOLD_EURO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_SOLD_EURO
   --    || ']]></after>
   --   </col>
   --   <col index="51" name="APP">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_APP
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_APP
   --    || ']]></after>
   --   </col>
   --   <col index="52" name="ARBITRAGE_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_ARBITRAGE_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_ARBITRAGE_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="53" name="ARB_TID_1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_ARB_TID_1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_ARB_TID_1
   --    || ']]></after>
   --   </col>
   --   <col index="54" name="ARB_TID_2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_ARB_TID_2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_ARB_TID_2
   --    || ']]></after>
   --   </col>
   --   <col index="55" name="AREA_INT_NO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AREA_INT_NO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AREA_INT_NO
   --    || ']]></after>
   --   </col>
   --   <col index="56" name="AVG_TO_DATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AVG_TO_DATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AVG_TO_DATE
   --    || ']]></after>
   --   </col>
   --   <col index="57" name="BACK_DATED">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BACK_DATED
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BACK_DATED
   --    || ']]></after>
   --   </col>
   --   <col index="58" name="BASE_CCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BASE_CCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BASE_CCY
   --    || ']]></after>
   --   </col>
   --   <col index="59" name="BASE_EQUIV_AMOUNT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BASE_EQUIV_AMOUNT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BASE_EQUIV_AMOUNT
   --    || ']]></after>
   --   </col>
   --   <col index="60" name="BASE_EQUIV_RATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BASE_EQUIV_RATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BASE_EQUIV_RATE
   --    || ']]></after>
   --   </col>
   --   <col index="61" name="BREAKOUT_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BREAKOUT_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BREAKOUT_TID
   --    || ']]></after>
   --   </col>
   --   <col index="62" name="BROKER_CODE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BROKER_CODE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BROKER_CODE
   --    || ']]></after>
   --   </col>
   --   <col index="63" name="BROKER_COMM">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BROKER_COMM
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BROKER_COMM
   --    || ']]></after>
   --   </col>
   --   <col index="64" name="BROKER_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_BROKER_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_BROKER_TID
   --    || ']]></after>
   --   </col>
   --   <col index="65" name="CALL_CCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CALL_CCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CALL_CCY
   --    || ']]></after>
   --   </col>
   --   <col index="66" name="CALL_CCY_AMOUNT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CALL_CCY_AMOUNT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CALL_CCY_AMOUNT
   --    || ']]></after>
   --   </col>
   --   <col index="67" name="CANCEL_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_CANCEL_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_CANCEL_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="68" name="CANCEL_REASON">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CANCEL_REASON
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CANCEL_REASON
   --    || ']]></after>
   --   </col>
   --   <col index="69" name="CASH_ADJ">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CASH_ADJ
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CASH_ADJ
   --    || ']]></after>
   --   </col>
   --   <col index="70" name="CCY_BOUGHT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY_BOUGHT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY_BOUGHT
   --    || ']]></after>
   --   </col>
   --   <col index="71" name="CCY_SOLD">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY_SOLD
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY_SOLD
   --    || ']]></after>
   --   </col>
   --   <col index="72" name="CP_AMOUNT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CP_AMOUNT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CP_AMOUNT
   --    || ']]></after>
   --   </col>
   --   <col index="73" name="CP_TYPE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CP_TYPE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CP_TYPE
   --    || ']]></after>
   --   </col>
   --   <col index="74" name="CUR_SPOT_REV">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUR_SPOT_REV
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUR_SPOT_REV
   --    || ']]></after>
   --   </col>
   --   <col index="75" name="CUR_SPOT_TRD">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUR_SPOT_TRD
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUR_SPOT_TRD
   --    || ']]></after>
   --   </col>
   --   <col index="76" name="CUR_VAL">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUR_VAL
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUR_VAL
   --    || ']]></after>
   --   </col>
   --   <col index="77" name="CUR_VAL_DIS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUR_VAL_DIS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUR_VAL_DIS
   --    || ']]></after>
   --   </col>
   --   <col index="78" name="CUSTOMER_REF">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUSTOMER_REF
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUSTOMER_REF
   --    || ']]></after>
   --   </col>
   --   <col index="79" name="CUST_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CUST_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CUST_TID
   --    || ']]></after>
   --   </col>
   --   <col index="80" name="DEAL_CODE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_DEAL_CODE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_DEAL_CODE
   --    || ']]></after>
   --   </col>
   --   <col index="81" name="DEAL_NUMBER">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_DEAL_NUMBER
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_DEAL_NUMBER
   --    || ']]></after>
   --   </col>
   --   <col index="82" name="ENTRY_DATE_TIME">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_ENTRY_DATE_TIME, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_ENTRY_DATE_TIME, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="83" name="FSI_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FSI_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FSI_TID
   --    || ']]></after>
   --   </col>
   --   <col index="84" name="FSI_REC_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FSI_REC_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FSI_REC_TID
   --    || ']]></after>
   --   </col>
   --   <col index="85" name="FULLY_APP">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FULLY_APP
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FULLY_APP
   --    || ']]></after>
   --   </col>
   --   <col index="86" name="FWD_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="87" name="FWD_SPOT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_FWD_SPOT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_FWD_SPOT
   --    || ']]></after>
   --   </col>
   --   <col index="88" name="MAR_AMT1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_MAR_AMT1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_MAR_AMT1
   --    || ']]></after>
   --   </col>
   --   <col index="89" name="MAR_NPV">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_MAR_NPV
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_MAR_NPV
   --    || ']]></after>
   --   </col>
   --   <col index="90" name="MAR_PTS1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_MAR_PTS1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_MAR_PTS1
   --    || ']]></after>
   --   </col>
   --   <col index="91" name="NDF_FIXDT">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_NDF_FIXDT, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_NDF_FIXDT, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="92" name="OPTIONS_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OPTIONS_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OPTIONS_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="93" name="ORIG_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_ORIG_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_ORIG_TID
   --    || ']]></after>
   --   </col>
   --   <col index="94" name="OTC_CODE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_CODE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_CODE
   --    || ']]></after>
   --   </col>
   --   <col index="95" name="OTC_DEL_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_OTC_DEL_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_OTC_DEL_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="96" name="OTC_ET">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_ET
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_ET
   --    || ']]></after>
   --   </col>
   --   <col index="97" name="OTC_EXC_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_OTC_EXC_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_OTC_EXC_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="98" name="OTC_EXO_BARR1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_BARR1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_BARR1
   --    || ']]></after>
   --   </col>
   --   <col index="99" name="OTC_EXO_DATE1">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_OTC_EXO_DATE1, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_OTC_EXO_DATE1, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="100" name="OTC_EXO_DATE2">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_OTC_EXO_DATE2, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_OTC_EXO_DATE2, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="101" name="OTC_EXO_FREE1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_FREE1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_FREE1
   --    || ']]></after>
   --   </col>
   --   <col index="102" name="OTC_EXO_FREE2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_FREE2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_FREE2
   --    || ']]></after>
   --   </col>
   --   <col index="103" name="OTC_EXO_FREE3">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXO_FREE3
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXO_FREE3
   --    || ']]></after>
   --   </col>
   --   <col index="104" name="OTC_EXP_TIME">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_EXP_TIME
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_EXP_TIME
   --    || ']]></after>
   --   </col>
   --   <col index="105" name="OTC_FDC1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_FDC1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_FDC1
   --    || ']]></after>
   --   </col>
   --   <col index="106" name="OTC_FDC2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_FDC2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_FDC2
   --    || ']]></after>
   --   </col>
   --   <col index="107" name="OTC_PREM">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_PREM
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_PREM
   --    || ']]></after>
   --   </col>
   --   <col index="108" name="OTC_PREM_CCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_PREM_CCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_PREM_CCY
   --    || ']]></after>
   --   </col>
   --   <col index="109" name="OTC_PREM_CNV">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_PREM_CNV
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_PREM_CNV
   --    || ']]></after>
   --   </col>
   --   <col index="110" name="OTC_PREM_DD">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_OTC_PREM_DD, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_OTC_PREM_DD, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="111" name="OTC_PREM_NO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_PREM_NO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_PREM_NO
   --    || ']]></after>
   --   </col>
   --   <col index="112" name="OTC_PREM_TYPE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_PREM_TYPE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_PREM_TYPE
   --    || ']]></after>
   --   </col>
   --   <col index="113" name="OTC_SDC1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_SDC1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_SDC1
   --    || ']]></after>
   --   </col>
   --   <col index="114" name="OTC_SDC2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_SDC2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_SDC2
   --    || ']]></after>
   --   </col>
   --   <col index="115" name="OTC_SPOT_RATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_SPOT_RATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_SPOT_RATE
   --    || ']]></after>
   --   </col>
   --   <col index="116" name="OTC_TYPE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_TYPE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_TYPE
   --    || ']]></after>
   --   </col>
   --   <col index="117" name="OTC_TYPE_CODE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_OTC_TYPE_CODE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_OTC_TYPE_CODE
   --    || ']]></after>
   --   </col>
   --   <col index="118" name="PAY_NOSTRO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_PAY_NOSTRO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_PAY_NOSTRO
   --    || ']]></after>
   --   </col>
   --   <col index="119" name="PORT_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_PORT_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_PORT_TID
   --    || ']]></after>
   --   </col>
   --   <col index="120" name="PRODUCT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_PRODUCT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_PRODUCT
   --    || ']]></after>
   --   </col>
   --   <col index="121" name="PUT_CCY">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_PUT_CCY
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_PUT_CCY
   --    || ']]></after>
   --   </col>
   --   <col index="122" name="PUT_CCY_AMOUNT">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_PUT_CCY_AMOUNT
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_PUT_CCY_AMOUNT
   --    || ']]></after>
   --   </col>
   --   <col index="123" name="RATE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_RATE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_RATE
   --    || ']]></after>
   --   </col>
   --   <col index="124" name="REASON">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REASON
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REASON
   --    || ']]></after>
   --   </col>
   --   <col index="125" name="REC_INTL">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REC_INTL
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REC_INTL
   --    || ']]></after>
   --   </col>
   --   <col index="126" name="REC_NOSTRO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REC_NOSTRO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REC_NOSTRO
   --    || ']]></after>
   --   </col>
   --   <col index="127" name="REMARK1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REMARK1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REMARK1
   --    || ']]></after>
   --   </col>
   --   <col index="128" name="REMARK2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REMARK2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REMARK2
   --    || ']]></after>
   --   </col>
   --   <col index="129" name="REMARK3">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REMARK3
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REMARK3
   --    || ']]></after>
   --   </col>
   --   <col index="130" name="REUTERS_DEAL_NO">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REUTERS_DEAL_NO
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REUTERS_DEAL_NO
   --    || ']]></after>
   --   </col>
   --   <col index="131" name="REUTERS_NODE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_REUTERS_NODE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_REUTERS_NODE
   --    || ']]></after>
   --   </col>
   --   <col index="132" name="SPOT_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_SPOT_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_SPOT_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="133" name="START_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_START_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_START_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="134" name="STATUS_FLAG">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_STATUS_FLAG
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_STATUS_FLAG
   --    || ']]></after>
   --   </col>
   --   <col index="135" name="SWAP_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SWAP_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SWAP_TID
   --    || ']]></after>
   --   </col>
   --   <col index="136" name="SWAP_POINTS">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SWAP_POINTS
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SWAP_POINTS
   --    || ']]></after>
   --   </col>
   --   <col index="137" name="SWAP_SF">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_SWAP_SF
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_SWAP_SF
   --    || ']]></after>
   --   </col>
   --   <col index="138" name="TIME_OP">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TIME_OP
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TIME_OP
   --    || ']]></after>
   --   </col>
   --   <col index="139" name="TO_ORIG_TID">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TO_ORIG_TID
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TO_ORIG_TID
   --    || ']]></after>
   --   </col>
   --   <col index="140" name="TRADER">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TRADER
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TRADER
   --    || ']]></after>
   --   </col>
   --   <col index="141" name="TRADER_NAME">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TRADER_NAME
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TRADER_NAME
   --    || ']]></after>
   --   </col>
   --   <col index="142" name="TRADE_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_TRADE_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_TRADE_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="143" name="TRAN_TYPE">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_TRAN_TYPE
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_TRAN_TYPE
   --    || ']]></after>
   --   </col>
   --   <col index="144" name="VALUE_DATE">
   --  <before isNull="true"><![CDATA['
   --    || TO_CHAR (BEFORE_VALUE_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || TO_CHAR (AFTER_VALUE_DATE, 'YYYY-MM-DD HH24:MI:SS')
   --    || ']]></after>
   --   </col>
   --   <col index="145" name="AMT_1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_1
   --    || ']]></after>
   --   </col>
   --   <col index="146" name="AMT_2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_AMT_2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_AMT_2
   --    || ']]></after>
   --   </col>
   --   <col index="147" name="CCY_1">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY_1
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY_1
   --    || ']]></after>
   --   </col>
   --   <col index="148" name="CCY_2">
   --  <before isNull="true"><![CDATA['
   --    || BEFORE_CCY_2
   --    || ']]></before>
   --  <after isNull="true"><![CDATA['
   --    || AFTER_CCY_2
   --    || ']]></after>
   --   </col>
   --    </operation>';

   INSERT INTO LOG
        VALUES (xmlContent);
--COMMIT;
--DBMS_OUTPUT.put_line ('operation end --- <<<');
--    msgid := pkg_stm_tr.enq_msg (xmlContent, 'stmdba.ODCN_XF_Q');
END;
/


CREATE TABLE FO_ORD_FX
(
   WSS_GDP_SITE          VARCHAR2 (3),
   WSS_TID               VARCHAR2 (15),
   WSS_GDP_TIME          DATE,
   AMT_BOUGHT            NUMBER,
   AMT_BOUGHT_EURO       NUMBER,
   AMT_SOLD              NUMBER,
   AMT_SOLD_EURO         NUMBER,
   APP                   VARCHAR2 (3),
   ARBITRAGE_FLAG        VARCHAR2 (3),
   ARB_TID_1             VARCHAR2 (15),
   ARB_TID_2             VARCHAR2 (15),
   AREA_INT_NO           VARCHAR2 (4),
   AVG_TO_DATE           NUMBER,
   BACK_DATED            VARCHAR2 (1),
   BASE_CCY              VARCHAR2 (3),
   BASE_EQUIV_AMOUNT     NUMBER,
   BASE_EQUIV_RATE       NUMBER,
   BREAKOUT_TID          VARCHAR2 (15),
   BROKER_CODE           VARCHAR2 (3),
   BROKER_COMM           NUMBER,
   BROKER_TID            VARCHAR2 (15),
   CALL_CCY              VARCHAR2 (3),
   CALL_CCY_AMOUNT       NUMBER,
   CANCEL_DATE           DATE,
   CANCEL_REASON         VARCHAR2 (30),
   CASH_ADJ              NUMBER,
   CCY_BOUGHT            VARCHAR2 (3),
   CCY_SOLD              VARCHAR2 (3),
   CP_AMOUNT             NUMBER,
   CP_TYPE               VARCHAR2 (2),
   CUR_SPOT_REV          NUMBER,
   CUR_SPOT_TRD          NUMBER,
   CUR_VAL               NUMBER,
   CUR_VAL_DIS           NUMBER,
   CUSTOMER_REF          VARCHAR2 (20),
   CUST_TID              VARCHAR2 (15),
   DEAL_CODE             VARCHAR2 (2),
   DEAL_NUMBER           VARCHAR2 (13),
   ENTRY_DATE_TIME       DATE,
   FSI_TID               VARCHAR2 (15),
   FSI_REC_TID           VARCHAR2 (15),
   FULLY_APP             VARCHAR2 (1),
   FWD_FLAG              VARCHAR2 (1),
   FWD_SPOT              VARCHAR2 (3),
   MAR_AMT1              NUMBER,
   MAR_NPV               NUMBER,
   MAR_PTS1              NUMBER,
   NDF_FIXDT             DATE,
   OPTIONS_FLAG          VARCHAR2 (12),
   ORIG_TID              VARCHAR2 (15),
   OTC_CODE              VARCHAR2 (2),
   OTC_DEL_DATE          DATE,
   OTC_ET                VARCHAR2 (6),
   OTC_EXC_DATE          DATE,
   OTC_EXO_BARR1         VARCHAR2 (15),
   OTC_EXO_DATE1         DATE,
   OTC_EXO_DATE2         DATE,
   OTC_EXO_FREE1         VARCHAR2 (20),
   OTC_EXO_FREE2         VARCHAR2 (20),
   OTC_EXO_FREE3         VARCHAR2 (20),
   OTC_EXP_TIME          VARCHAR2 (5),
   OTC_FDC1              NUMBER,
   OTC_FDC2              NUMBER,
   OTC_PREM              NUMBER,
   OTC_PREM_CCY          VARCHAR2 (3),
   OTC_PREM_CNV          NUMBER,
   OTC_PREM_DD           DATE,
   OTC_PREM_NO           NUMBER,
   OTC_PREM_TYPE         VARCHAR2 (1),
   OTC_SDC1              NUMBER,
   OTC_SDC2              NUMBER,
   OTC_SPOT_RATE         NUMBER,
   OTC_TYPE              VARCHAR2 (15),
   OTC_TYPE_CODE         VARCHAR2 (4),
   PAY_NOSTRO            VARCHAR2 (10),
   PORT_TID              VARCHAR2 (15),
   PRODUCT               VARCHAR2 (5),
   PUT_CCY               VARCHAR2 (3),
   PUT_CCY_AMOUNT        NUMBER,
   RATE                  NUMBER,
   REASON                VARCHAR2 (30),
   REC_INTL              VARCHAR2 (20),
   REC_NOSTRO            VARCHAR2 (10),
   REMARK1               VARCHAR2 (30),
   REMARK2               VARCHAR2 (30),
   REMARK3               VARCHAR2 (30),
   REUTERS_DEAL_NO       VARCHAR2 (10),
   REUTERS_NODE          VARCHAR2 (4),
   SPOT_DATE             DATE,
   START_DATE            DATE,
   STATUS_FLAG           VARCHAR2 (3),
   SWAP_TID              VARCHAR2 (15),
   SWAP_POINTS           NUMBER,
   SWAP_SF               VARCHAR2 (1),
   TIME_OP               VARCHAR2 (2),
   TO_ORIG_TID           VARCHAR2 (15),
   TRADER                VARCHAR2 (3),
   TRADER_NAME           VARCHAR2 (20),
   TRADE_DATE            DATE,
   TRAN_TYPE             VARCHAR2 (3),
   VALUE_DATE            DATE,
   AMT_1                 NUMBER,
   AMT_2                 NUMBER,
   CCY_1                 VARCHAR2 (3),
   CCY_2                 VARCHAR2 (3),
   TICKET_AREA           VARCHAR2 (6),
   AREA_UNIT             VARCHAR2 (4),
   DI_FLAG               VARCHAR2 (1),
   SWIFT_SETTLE_2        VARCHAR2 (30),
   SWIFT_SETTLE_3        VARCHAR2 (30),
   EXTERN_NUM_DBEM       VARCHAR2 (15),
   NDF_ORIG_TID          VARCHAR2 (15),
   INVERT                VARCHAR2 (1),
   BK_TYPE               VARCHAR2 (2),
   INVMAN                VARCHAR2 (11),
   INVMAN_TID            VARCHAR2 (15),
   POINTS                NUMBER,
   NDF_STCCY             VARCHAR2 (3),
   OTC_EXO_BARR2         VARCHAR2 (15),
   OTC_EXO_FREE4         VARCHAR2 (20),
   CCY1_TRADE_RATE       NUMBER,
   CCY2_TRADE_RATE       NUMBER,
   CLS_FLAG              VARCHAR2 (1),
   CITY                  VARCHAR2 (6),
   NDF_RTAREA            VARCHAR2 (6),
   NDF_FEEDT             DATE,
   NDF_FEECCY            VARCHAR2 (3),
   NDF_FEEAMT            NUMBER,
   NDF_CONTY             VARCHAR2 (30),
   CLS_SESSION_ID        VARCHAR2 (2),
   SPOT_MARGIN2_POINTS   NUMBER,
   SPOT_MARGIN2_AMT      NUMBER,
   SPOT_MARGIN1_POINTS   NUMBER,
   SPOT_MARGIN1_AMT      NUMBER,
   FWD_MARGIN2_POINTS    NUMBER,
   FWD_MARGIN2_AMT       NUMBER,
   FWD_MARGIN1_POINTS    NUMBER,
   FWD_MARGIN1_AMT       NUMBER,
   CONFIRMATION          VARCHAR2 (1),
   MATCH_QUEUE           VARCHAR2 (1),
   SDR_USI               VARCHAR2 (42),
   SDR_UPI               VARCHAR2 (30),
   SDR_RPT_TRADE         VARCHAR2 (1),
   SDR_RPT_PARTY         VARCHAR2 (1),
   SDR_REPORTED          VARCHAR2 (1),
   SDR_PRIOR_USI         VARCHAR2 (42),
   SDR_ORIG_USI          VARCHAR2 (42),
   SDR_EXECUTION_TIME    VARCHAR2 (14),
   TRADE_SPOT_DATE       DATE
)
NOCACHE
LOGGING;

CREATE TABLE LOG
(
   "log"   CLOB
)
NOCACHE
LOGGING;


CREATE OR REPLACE PACKAGE PKG_STM
IS
   PROCEDURE CHNF_CALLBACK (NTFNDS IN SYS.CHNF$_DESC);

   FUNCTION CONVERTROWTOCLOB (ROW_ID           IN VARCHAR2,
                              TABLE_NAME       IN VARCHAR2,
                              OPERATION_TYPE      NUMBER)
      RETURN CLOB;

   FUNCTION ENQ_MSG (XMLCONTEXT IN CLOB, QUEUENAME IN VARCHAR2)
      RETURN RAW;
END PKG_STM;
/


CREATE OR REPLACE PACKAGE BODY PKG_STM
IS
   PROCEDURE chnf_callback (ntfnds IN SYS.CHNF$_DESC)
   IS
      regid            NUMBER;
      tbname           VARCHAR2 (60);
      event_type       NUMBER;
      numtables        NUMBER;
      operation_type   NUMBER;
      numrows          NUMBER;
      row_id           VARCHAR2 (2000);
      row_scn          NUMBER;
      rowContent       CLOB;
      msg_id           RAW (16);
      queueUser        VARCHAR (20);
   BEGIN
      regid := ntfnds.registration_id;
      numtables := ntfnds.numtables;
      event_type := ntfnds.event_type;
      queueUser := 'stmdba';

      --insert into curr_user select user from dual;
      -- commit;

      --rowContent :=convertRowToClob('AAAEu5AAAAAAGTCAAB','fo_ord_fx',4);
      --msg_id:=enq_msg(rowContent,'odcn_data_queue');
      --dbms_output.put_line(msg_id);
      --commit;

      IF (event_type = DBMS_CHANGE_NOTIFICATION.EVENT_OBJCHANGE)
      THEN
         FOR i IN 1 .. numtables
         LOOP
            tbname := ntfnds.table_desc_array (i).table_name;
            operation_type := ntfnds.table_desc_array (I).Opflags;

            -- insert into nftablechanges values(regid, tbname, operation_type);
            /* Send the table name and operation_type to  client side listener
               using UTL_HTTP */
            /* If interested in the rowids, obtain them as follows */
            IF (BITAND (operation_type, DBMS_CHANGE_NOTIFICATION.ALL_ROWS) =
                   0)
            THEN
               numrows := ntfnds.table_desc_array (i).numrows;
            ELSE
               numrows := 0;                    /* ROWID INFO NOT AVAILABLE */
            END IF;


            /* The body of the loop is not executed when numrows is ZERO */
            FOR j IN 1 .. numrows
            LOOP
               Row_id := ntfnds.table_desc_array (i).row_desc_array (j).row_id;
               operation_type :=
                  ntfnds.table_desc_array (i).row_desc_array (j).opflags;

               --execute immediate 'select ORA_ROWSCN AS scn from ' || tbname || ' WHERE rowid=:rid'
               --into  row_scn using Row_id ;
               IF operation_type != DBMS_CHANGE_NOTIFICATION.DELETEOP
               THEN
                  rowContent :=
                     convertRowToClob (Row_id, tbname, operation_type);
                  --insert into table_modification values(row_scn,sysdate,Row_id,operation_type,tbname,rowContent);
                  msg_id :=
                     enq_msg (rowContent, queueUser || '.ODCN_DATA_QUEUE');
               END IF;
            /* optionally Send out row_ids to client side listener using
               UTL_HTTP */
            END LOOP;
         END LOOP;
      END IF;

      COMMIT;
   END;

   FUNCTION convertRowToClob (row_id           IN VARCHAR2,
                              table_name       IN VARCHAR2,
                              operation_type      NUMBER)
      RETURN CLOB
   IS
      --operation_type
      --2 insert
      --4 update
      --8 delete

      l_theCursor          INTEGER DEFAULT DBMS_SQL.open_cursor;
      l_columnValue        VARCHAR2 (4000);
      l_columnValue_Date   DATE;
      l_status             INTEGER;
      l_descTbl            DBMS_SQL.desc_tab;
      l_colCnt             NUMBER;
      p_query              VARCHAR2 (32000);
      l_return_type        NUMBER;        --1:return return_str, 0:return null
      --use for contact
      head_str             VARCHAR2 (1000);
      tail_str             VARCHAR2 (1000);
      return_str           VARCHAR2 (32765);
      optype_str           VARCHAR2 (100);
   BEGIN
      p_query := 'select * from ' || table_name || ' where rowid = :row_id';
      DBMS_SQL.parse (l_theCursor, p_query, DBMS_SQL.native);
      SYS.DBMS_SQL.BIND_VARIABLE_ROWID (l_theCursor, ':row_id', row_id);
      DBMS_SQL.describe_columns (l_theCursor, l_colCnt, l_descTbl);

      FOR i IN 1 .. l_colCnt
      LOOP
         IF l_descTbl (i).col_type = 12
         THEN
            DBMS_SQL.define_column (l_theCursor, i, l_columnValue_Date);
         ELSE
            DBMS_SQL.define_column (l_theCursor,
                                    i,
                                    l_columnValue,
                                    4000);
         END IF;
      END LOOP;

      CASE
         WHEN operation_type = 2
         THEN
            optype_str := 'INSERT_FIELDCOMP_PK';
         WHEN operation_type = 4
         THEN
            optype_str := 'UPDATE_FIELDCOMP_PK';
         WHEN operation_type = 8
         THEN
            optype_str := 'DELETE_FIELDCOMP_PK';
      END CASE;

      head_str :=
            '<operation numCols="'
         || l_colCnt
         || '" type="'
         || optype_str
         || '" table="'
         || table_name
         || '" ts="'
         || TO_CHAR (SYSDATE, 'yyyy-MM-dd HH24:mi:ss')
         || '" pos="">';
      tail_str := '
  </operation>';
      return_str := head_str;
      --DBMS_OUTPUT.ENABLE(1000000);
      l_status := DBMS_SQL.execute (l_theCursor);
      l_return_type := 0;

      WHILE (DBMS_SQL.fetch_rows (l_theCursor) > 0)
      LOOP
         l_return_type := 1;

         FOR i IN 1 .. l_colCnt
         LOOP
            -- 12: DateTime type
            IF l_descTbl (i).col_type = 12
            THEN
               DBMS_SQL.COLUMN_VALUE (l_theCursor, i, l_columnValue_Date);
               --dbms_output.put_line(l_columnValue_Date);
               l_columnValue :=
                  TO_CHAR (l_columnValue_Date, 'YYYY-MM-DD HH24:MI:SS');
            ELSE
               DBMS_SQL.COLUMN_VALUE (l_theCursor, i, l_columnValue);
            END IF;

            return_str := return_str || '
          <col index="'     || i || '" name="' || l_descTbl (i).col_name || '">
            <before isNull="true"></before>
            <after isNull="true">' || l_columnValue || '</after>
          </col>';
         END LOOP;
      END LOOP;

      return_str := return_str || tail_str;

      --dbms_output.put_line(return_str);
      IF l_return_type <= 0
      THEN
         RETURN NULL;
      END IF;

      DBMS_SQL.close_cursor (l_theCursor);
      RETURN TO_CLOB (return_str);
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.PUT_LINE ('error');
         DBMS_SQL.CLOSE_CURSOR (L_THECURSOR);
         RAISE;
   END;

   FUNCTION enq_msg (xmlcontext IN CLOB, queueName IN VARCHAR2)
      RETURN RAW
   IS
      MESSAGE              SYS.aq$_jms_text_message;
      enqueue_options      DBMS_AQ.ENQUEUE_OPTIONS_T;
      message_properties   DBMS_AQ.MESSAGE_PROPERTIES_T;
      msgid                RAW (16);
      err_num              NUMBER;
      err_msg              CLOB;
   BEGIN
      --    MESSAGE := sys.aq$_jms_text_message.construct;
      --    MESSAGE.set_text (xmlcontext);
      --    message_properties.expiration := DBMS_AQ.never;
      --    DBMS_AQ.enqueue (queue_name           => queueName,
      --         enqueue_options      => enqueue_options,
      --         message_properties   => message_properties,
      --         payload              => MESSAGE,
      --         msgid                => msgid);
      --INSERT INTO exp VALUES ('msgid:'||msgid);
      COMMIT;
      RETURN msgid;
   --exception
   --    WHEN OTHERS then INSERT INTO exp VALUES (DBMS_UTILITY.format_error_stack ());
   --  COMMIT;
   END;
END PKG_STM;
/