eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_COLLECTION_AIA_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42


  l_update_flag     VARCHAR2(10) := 'N';

Line: 47


  l_update_check    NUMBER       := -1;

Line: 54


      SELECT employee_number
       FROM cn_salesreps
      WHERE resource_id IN
      (SELECT resource_id
         FROM jtf_rs_resource_extns
        WHERE source_number = p_employee_number
      );

Line: 64


     SELECT salesrep_id
       FROM cn_salesreps
      WHERE resource_id IN
      (SELECT resource_id
         FROM jtf_rs_resource_extns
        WHERE source_number = p_employee_number
      );

Line: 74


     SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;

Line: 78


     SELECT source_number
       FROM jtf_rs_resource_extns
      WHERE resource_id IN
      ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id
      ) ;

Line: 86


     SELECT 'Y' FLAG,
      TRANS_SEQ_ID
       FROM CN_COLLECTION_AIA
      WHERE ORDER_NUMBER = p_order_number
    AND rownum             = 1;

Line: 94


     SELECT 1 FLAG
       FROM cn_not_trx
      WHERE source_trx_line_id = l_trans_seq_num --*** Line.Primary_Key
    AND event_id               = -1020
    AND org_id                 = p_org_id;

Line: 303


      l_update_check    := -1;

Line: 304


      l_update_flag     := 'N';

Line: 412


        l_update_flag   := l_order_num_cr.FLAG;

Line: 416


      debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: l_update_flag: ' || l_update_flag);

Line: 419


      IF(l_update_flag = 'N') THEN
        debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: insert start ');

Line: 421


         INSERT
           INTO CN_COLLECTION_AIA
          (
            TRANS_SEQ_ID             ,
            SALESREP_ID              ,
            EMPLOYEE_NUMBER          ,
            PROCESSED_DATE           ,
            INVOICE_NUMBER           ,
            INVOICE_DATE             ,
            TRANSACTION_AMOUNT       ,
            TRANSACTION_CURRENCY_CODE,
            TRX_TYPE                 ,
            REVENUE_TYPE             ,
            SALESREP_NUMBER          ,
            ADJUST_COMMENTS          ,
            ADJUST_STATUS            ,
            SOURCE_DOC_ID            ,
            UPDATE_FLAG              ,
            SALES_CHANNEL            ,
            LINE_NUMBER              ,
            REASON_CODE              ,
            ATTRIBUTE_CATEGORY       ,
            ADJUST_DATE              ,
            ADJUSTED_BY              ,
            BILL_TO_ADDRESS_ID       ,
            SHIP_TO_ADDRESS_ID       ,
            BILL_TO_CONTACT_ID       ,
            SHIP_TO_CONTACT_ID       ,
            CUSTOMER_ID              ,
            INVENTORY_ITEM_ID        ,
            ORDER_NUMBER             ,
            BOOKED_DATE              ,
            SOURCE_TRX_NUMBER        ,
            DISCOUNT_PERCENTAGE      ,
            MARGIN_PERCENTAGE        ,
            EXCHANGE_RATE            ,
            TYPE                     ,
            SOURCE_TRX_SALES_LINE_ID ,
            ORG_ID                   ,
            ATTRIBUTE1               ,
            ATTRIBUTE2               ,
            ATTRIBUTE3               ,
            ATTRIBUTE4               ,
            ATTRIBUTE5               ,
            ATTRIBUTE6               ,
            ATTRIBUTE7               ,
            ATTRIBUTE8               ,
            ATTRIBUTE9               ,
            ATTRIBUTE10              ,
            ATTRIBUTE11              ,
            ATTRIBUTE12              ,
            ATTRIBUTE13              ,
            ATTRIBUTE14              ,
            ATTRIBUTE15              ,
            ATTRIBUTE16              ,
            ATTRIBUTE17              ,
            ATTRIBUTE18              ,
            ATTRIBUTE19              ,
            ATTRIBUTE20              ,
            ATTRIBUTE21              ,
            ATTRIBUTE22              ,
            ATTRIBUTE23              ,
            ATTRIBUTE24              ,
            ATTRIBUTE25              ,
            ATTRIBUTE26              ,
            ATTRIBUTE27              ,
            ATTRIBUTE28              ,
            ATTRIBUTE29              ,
            ATTRIBUTE30              ,
            ATTRIBUTE31              ,
            ATTRIBUTE32              ,
            ATTRIBUTE33              ,
            ATTRIBUTE34              ,
            ATTRIBUTE35              ,
            ATTRIBUTE36              ,
            ATTRIBUTE37              ,
            ATTRIBUTE38              ,
            ATTRIBUTE39              ,
            ATTRIBUTE40              ,
            ATTRIBUTE41              ,
            ATTRIBUTE42              ,
            ATTRIBUTE43              ,
            ATTRIBUTE44              ,
            ATTRIBUTE45              ,
            ATTRIBUTE46              ,
            ATTRIBUTE47              ,
            ATTRIBUTE48              ,
            ATTRIBUTE49              ,
            ATTRIBUTE50              ,
            ATTRIBUTE51              ,
            ATTRIBUTE52              ,
            ATTRIBUTE53              ,
            ATTRIBUTE54              ,
            ATTRIBUTE55              ,
            ATTRIBUTE56              ,
            ATTRIBUTE57              ,
            ATTRIBUTE58              ,
            ATTRIBUTE59              ,
            ATTRIBUTE60              ,
            ATTRIBUTE61              ,
            ATTRIBUTE62              ,
            ATTRIBUTE63              ,
            ATTRIBUTE64              ,
            ATTRIBUTE65              ,
            ATTRIBUTE66              ,
            ATTRIBUTE67              ,
            ATTRIBUTE68              ,
            ATTRIBUTE69              ,
            ATTRIBUTE70              ,
            ATTRIBUTE71              ,
            ATTRIBUTE72              ,
            ATTRIBUTE73              ,
            ATTRIBUTE74              ,
            ATTRIBUTE75              ,
            ATTRIBUTE76              ,
            ATTRIBUTE77              ,
            ATTRIBUTE78              ,
            ATTRIBUTE79              ,
            ATTRIBUTE80              ,
            ATTRIBUTE81              ,
            ATTRIBUTE82              ,
            ATTRIBUTE83              ,
            ATTRIBUTE84              ,
            ATTRIBUTE85              ,
            ATTRIBUTE86              ,
            ATTRIBUTE87              ,
            ATTRIBUTE88              ,
            ATTRIBUTE89              ,
            ATTRIBUTE90              ,
            ATTRIBUTE91              ,
            ATTRIBUTE92              ,
            ATTRIBUTE93              ,
            ATTRIBUTE94              ,
            ATTRIBUTE95              ,
            ATTRIBUTE96              ,
            ATTRIBUTE97              ,
            ATTRIBUTE98              ,
            ATTRIBUTE99              ,
            ATTRIBUTE100
          )
                VALUES
          (
            CN_COLLECTION_AIA_S.NextVal                        ,
            l_salesrep_id                                      ,
            l_employee_number                                  ,
            to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
            p_aia_rec_tbl(l_counter).INVOICE_NUMBER            ,
            decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
            p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT        ,
            p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
            'AIA_OM'                  ,
            decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),
            l_salesrep_number                                  ,
            p_aia_rec_tbl(l_counter).ADJUST_COMMENTS           ,
            'MANUAL'                                           ,
            p_aia_rec_tbl(l_counter).SOURCE_DOC_ID             ,
            l_update_flag                                      ,
            p_aia_rec_tbl(l_counter).SALES_CHANNEL             ,
            p_aia_rec_tbl(l_counter).LINE_NUMBER               ,
            p_aia_rec_tbl(l_counter).REASON_CODE               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE_CATEGORY        ,
            decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),
            p_aia_rec_tbl(l_counter).ADJUSTED_BY               ,
            p_aia_rec_tbl(l_counter).BILL_TO_ADDRESS_ID        ,
            p_aia_rec_tbl(l_counter).SHIP_TO_ADDRESS_ID        ,
            p_aia_rec_tbl(l_counter).BILL_TO_CONTACT_ID        ,
            p_aia_rec_tbl(l_counter).SHIP_TO_CONTACT_ID        ,
            p_aia_rec_tbl(l_counter).CUSTOMER_ID               ,
            p_aia_rec_tbl(l_counter).INVENTORY_ITEM_ID         ,
            p_aia_rec_tbl(l_counter).ORDER_NUMBER              ,
            to_date(p_aia_rec_tbl(l_counter).BOOKED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
            p_aia_rec_tbl(l_counter).SOURCE_TRX_NUMBER         ,
            p_aia_rec_tbl(l_counter).DISCOUNT_PERCENTAGE       ,
            p_aia_rec_tbl(l_counter).MARGIN_PERCENTAGE         ,
            p_aia_rec_tbl(l_counter).EXCHANGE_RATE             ,
            p_aia_rec_tbl(l_counter).TYPE                      ,
            p_aia_rec_tbl(l_counter).SOURCE_TRX_SALES_LINE_ID  ,
            p_org_id                                           ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE1                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE2                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE3                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE4                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE5                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE6                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE7                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE8                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE9                ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE10               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE11               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE12               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE13               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE14               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE15               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE16               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE17               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE18               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE19               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE20               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE21               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE22               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE23               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE24               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE25               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE26               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE27               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE28               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE29               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE30               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE31               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE32               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE33               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE34               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE35               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE36               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE37               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE38               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE39               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE40               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE41               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE42               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE43               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE44               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE45               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE46               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE47               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE48               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE49               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE50               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE51               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE52               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE53               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE54               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE55               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE56               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE57               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE58               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE59               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE60               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE61               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE62               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE63               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE64               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE65               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE66               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE67               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE68               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE69               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE70               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE71               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE72               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE73               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE74               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE75               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE76               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE77               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE78               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE79               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE80               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE81               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE82               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE83               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE84               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE85               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE86               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE87               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE88               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE89               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE90               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE91               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE92               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE93               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE94               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE95               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE96               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE97               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE98               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE99               ,
            p_aia_rec_tbl(l_counter).ATTRIBUTE100
          );

Line: 713


          'CN_COLLECTION_AIA_PUB.loadrow_om api:  ' || 'INSERTED ORDER NUMBER' || ' '
          || p_aia_rec_tbl(l_counter).ORDER_NUMBER
        )
        ;

Line: 723


          l_update_check := l_order_num_cr.FLAG;

Line: 728


          'CN_COLLECTION_AIA_PUB.loadrow_om api: l_update_check(in table cn_not_trx): ' || l_update_check
        )
        ;

Line: 734


            l_update_check = -1
          )
          THEN
          l_update_flag := 'N';

Line: 741


          'CN_COLLECTION_AIA_PUB.loadrow_om api: l_update_flag: ' || l_update_flag
        )
        ;

Line: 746


          'CN_COLLECTION_AIA_PUB.loadrow_om api: update process start '
        )
        ;

Line: 749


         UPDATE CN_COLLECTION_AIA
        SET SALESREP_ID             =l_salesrep_id               ,
          EMPLOYEE_NUMBER           =l_employee_number           ,
          PROCESSED_DATE            =to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
          INVOICE_DATE              =decode(p_aia_rec_tbl(l_counter).INVOICE_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss')),
          TRANSACTION_AMOUNT        =p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT        ,
          TRANSACTION_CURRENCY_CODE =p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
          TRX_TYPE                  ='AIA_OM'                  ,
          REVENUE_TYPE              =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',
                                        p_aia_rec_tbl(l_counter).REVENUE_TYPE)          ,
          SALESREP_NUMBER           =l_salesrep_number                                  ,
          ADJUST_COMMENTS           =p_aia_rec_tbl(l_counter).ADJUST_COMMENTS           ,
          ADJUST_STATUS             ='MANUAL'                                           ,
          SOURCE_DOC_ID             =p_aia_rec_tbl(l_counter).SOURCE_DOC_ID             ,
          UPDATE_FLAG               =l_update_flag                                      ,
          SALES_CHANNEL             =p_aia_rec_tbl(l_counter).SALES_CHANNEL             ,
          LINE_NUMBER               =p_aia_rec_tbl(l_counter).LINE_NUMBER               ,
          REASON_CODE               =p_aia_rec_tbl(l_counter).REASON_CODE               ,
          ATTRIBUTE_CATEGORY        =p_aia_rec_tbl(l_counter).ATTRIBUTE_CATEGORY        ,
          ADJUST_DATE               =decode(p_aia_rec_tbl(l_counter).ADJUST_DATE, FND_API.G_MISS_CHAR, null, to_date(p_aia_rec_tbl(l_counter).ADJUST_DATE, 'dd/mm/yyyy hh24:mi:ss')),
          ADJUSTED_BY               =p_aia_rec_tbl(l_counter).ADJUSTED_BY               ,
          BILL_TO_ADDRESS_ID        =p_aia_rec_tbl(l_counter).BILL_TO_ADDRESS_ID        ,
          SHIP_TO_ADDRESS_ID        =p_aia_rec_tbl(l_counter).SHIP_TO_ADDRESS_ID        ,
          BILL_TO_CONTACT_ID        =p_aia_rec_tbl(l_counter).BILL_TO_CONTACT_ID        ,
          SHIP_TO_CONTACT_ID        =p_aia_rec_tbl(l_counter).SHIP_TO_CONTACT_ID        ,
          CUSTOMER_ID               =p_aia_rec_tbl(l_counter).CUSTOMER_ID               ,
          INVENTORY_ITEM_ID         =p_aia_rec_tbl(l_counter).INVENTORY_ITEM_ID         ,
          ORDER_NUMBER              =p_aia_rec_tbl(l_counter).ORDER_NUMBER              ,
          BOOKED_DATE               =to_date(p_aia_rec_tbl(l_counter).BOOKED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
          SOURCE_TRX_NUMBER         =p_aia_rec_tbl(l_counter).SOURCE_TRX_NUMBER         ,
          DISCOUNT_PERCENTAGE       =p_aia_rec_tbl(l_counter).DISCOUNT_PERCENTAGE       ,
          MARGIN_PERCENTAGE         =p_aia_rec_tbl(l_counter).MARGIN_PERCENTAGE         ,
          EXCHANGE_RATE             =p_aia_rec_tbl(l_counter).EXCHANGE_RATE             ,
          TYPE                      =p_aia_rec_tbl(l_counter).TYPE                      ,
          SOURCE_TRX_SALES_LINE_ID  =p_aia_rec_tbl(l_counter).SOURCE_TRX_SALES_LINE_ID  ,
          ORG_ID                    =p_org_id                                           ,
          ATTRIBUTE1                =p_aia_rec_tbl(l_counter).ATTRIBUTE1                ,
          ATTRIBUTE2                =p_aia_rec_tbl(l_counter).ATTRIBUTE2                ,
          ATTRIBUTE3                =p_aia_rec_tbl(l_counter).ATTRIBUTE3                ,
          ATTRIBUTE4                =p_aia_rec_tbl(l_counter).ATTRIBUTE4                ,
          ATTRIBUTE5                =p_aia_rec_tbl(l_counter).ATTRIBUTE5                ,
          ATTRIBUTE6                =p_aia_rec_tbl(l_counter).ATTRIBUTE6                ,
          ATTRIBUTE7                =p_aia_rec_tbl(l_counter).ATTRIBUTE7                ,
          ATTRIBUTE8                =p_aia_rec_tbl(l_counter).ATTRIBUTE8                ,
          ATTRIBUTE9                =p_aia_rec_tbl(l_counter).ATTRIBUTE9                ,
          ATTRIBUTE10               =p_aia_rec_tbl(l_counter).ATTRIBUTE10               ,
          ATTRIBUTE11               =p_aia_rec_tbl(l_counter).ATTRIBUTE11               ,
          ATTRIBUTE12               =p_aia_rec_tbl(l_counter).ATTRIBUTE12               ,
          ATTRIBUTE13               =p_aia_rec_tbl(l_counter).ATTRIBUTE13               ,
          ATTRIBUTE14               =p_aia_rec_tbl(l_counter).ATTRIBUTE14               ,
          ATTRIBUTE15               =p_aia_rec_tbl(l_counter).ATTRIBUTE15               ,
          ATTRIBUTE16               =p_aia_rec_tbl(l_counter).ATTRIBUTE16               ,
          ATTRIBUTE17               =p_aia_rec_tbl(l_counter).ATTRIBUTE17               ,
          ATTRIBUTE18               =p_aia_rec_tbl(l_counter).ATTRIBUTE18               ,
          ATTRIBUTE19               =p_aia_rec_tbl(l_counter).ATTRIBUTE19               ,
          ATTRIBUTE20               =p_aia_rec_tbl(l_counter).ATTRIBUTE20               ,
          ATTRIBUTE21               =p_aia_rec_tbl(l_counter).ATTRIBUTE21               ,
          ATTRIBUTE22               =p_aia_rec_tbl(l_counter).ATTRIBUTE22               ,
          ATTRIBUTE23               =p_aia_rec_tbl(l_counter).ATTRIBUTE23               ,
          ATTRIBUTE24               =p_aia_rec_tbl(l_counter).ATTRIBUTE24               ,
          ATTRIBUTE25               =p_aia_rec_tbl(l_counter).ATTRIBUTE25               ,
          ATTRIBUTE26               =p_aia_rec_tbl(l_counter).ATTRIBUTE26               ,
          ATTRIBUTE27               =p_aia_rec_tbl(l_counter).ATTRIBUTE27               ,
          ATTRIBUTE28               =p_aia_rec_tbl(l_counter).ATTRIBUTE28               ,
          ATTRIBUTE29               =p_aia_rec_tbl(l_counter).ATTRIBUTE29               ,
          ATTRIBUTE30               =p_aia_rec_tbl(l_counter).ATTRIBUTE30               ,
          ATTRIBUTE31               =p_aia_rec_tbl(l_counter).ATTRIBUTE31               ,
          ATTRIBUTE32               =p_aia_rec_tbl(l_counter).ATTRIBUTE32               ,
          ATTRIBUTE33               =p_aia_rec_tbl(l_counter).ATTRIBUTE33               ,
          ATTRIBUTE34               =p_aia_rec_tbl(l_counter).ATTRIBUTE34               ,
          ATTRIBUTE35               =p_aia_rec_tbl(l_counter).ATTRIBUTE35               ,
          ATTRIBUTE36               =p_aia_rec_tbl(l_counter).ATTRIBUTE36               ,
          ATTRIBUTE37               =p_aia_rec_tbl(l_counter).ATTRIBUTE37               ,
          ATTRIBUTE38               =p_aia_rec_tbl(l_counter).ATTRIBUTE38               ,
          ATTRIBUTE39               =p_aia_rec_tbl(l_counter).ATTRIBUTE39               ,
          ATTRIBUTE40               =p_aia_rec_tbl(l_counter).ATTRIBUTE40               ,
          ATTRIBUTE41               =p_aia_rec_tbl(l_counter).ATTRIBUTE41               ,
          ATTRIBUTE42               =p_aia_rec_tbl(l_counter).ATTRIBUTE42               ,
          ATTRIBUTE43               =p_aia_rec_tbl(l_counter).ATTRIBUTE43               ,
          ATTRIBUTE44               =p_aia_rec_tbl(l_counter).ATTRIBUTE44               ,
          ATTRIBUTE45               =p_aia_rec_tbl(l_counter).ATTRIBUTE45               ,
          ATTRIBUTE46               =p_aia_rec_tbl(l_counter).ATTRIBUTE46               ,
          ATTRIBUTE47               =p_aia_rec_tbl(l_counter).ATTRIBUTE47               ,
          ATTRIBUTE48               =p_aia_rec_tbl(l_counter).ATTRIBUTE48               ,
          ATTRIBUTE49               =p_aia_rec_tbl(l_counter).ATTRIBUTE49               ,
          ATTRIBUTE50               =p_aia_rec_tbl(l_counter).ATTRIBUTE50               ,
          ATTRIBUTE51               =p_aia_rec_tbl(l_counter).ATTRIBUTE51               ,
          ATTRIBUTE52               =p_aia_rec_tbl(l_counter).ATTRIBUTE52               ,
          ATTRIBUTE53               =p_aia_rec_tbl(l_counter).ATTRIBUTE53               ,
          ATTRIBUTE54               =p_aia_rec_tbl(l_counter).ATTRIBUTE54               ,
          ATTRIBUTE55               =p_aia_rec_tbl(l_counter).ATTRIBUTE55               ,
          ATTRIBUTE56               =p_aia_rec_tbl(l_counter).ATTRIBUTE56               ,
          ATTRIBUTE57               =p_aia_rec_tbl(l_counter).ATTRIBUTE57               ,
          ATTRIBUTE58               =p_aia_rec_tbl(l_counter).ATTRIBUTE58               ,
          ATTRIBUTE59               =p_aia_rec_tbl(l_counter).ATTRIBUTE59               ,
          ATTRIBUTE60               =p_aia_rec_tbl(l_counter).ATTRIBUTE60               ,
          ATTRIBUTE61               =p_aia_rec_tbl(l_counter).ATTRIBUTE61               ,
          ATTRIBUTE62               =p_aia_rec_tbl(l_counter).ATTRIBUTE62               ,
          ATTRIBUTE63               =p_aia_rec_tbl(l_counter).ATTRIBUTE63               ,
          ATTRIBUTE64               =p_aia_rec_tbl(l_counter).ATTRIBUTE64               ,
          ATTRIBUTE65               =p_aia_rec_tbl(l_counter).ATTRIBUTE65               ,
          ATTRIBUTE66               =p_aia_rec_tbl(l_counter).ATTRIBUTE66               ,
          ATTRIBUTE67               =p_aia_rec_tbl(l_counter).ATTRIBUTE67               ,
          ATTRIBUTE68               =p_aia_rec_tbl(l_counter).ATTRIBUTE68               ,
          ATTRIBUTE69               =p_aia_rec_tbl(l_counter).ATTRIBUTE69               ,
          ATTRIBUTE70               =p_aia_rec_tbl(l_counter).ATTRIBUTE70               ,
          ATTRIBUTE71               =p_aia_rec_tbl(l_counter).ATTRIBUTE71               ,
          ATTRIBUTE72               =p_aia_rec_tbl(l_counter).ATTRIBUTE72               ,
          ATTRIBUTE73               =p_aia_rec_tbl(l_counter).ATTRIBUTE73               ,
          ATTRIBUTE74               =p_aia_rec_tbl(l_counter).ATTRIBUTE74               ,
          ATTRIBUTE75               =p_aia_rec_tbl(l_counter).ATTRIBUTE75               ,
          ATTRIBUTE76               =p_aia_rec_tbl(l_counter).ATTRIBUTE76               ,
          ATTRIBUTE77               =p_aia_rec_tbl(l_counter).ATTRIBUTE77               ,
          ATTRIBUTE78               =p_aia_rec_tbl(l_counter).ATTRIBUTE78               ,
          ATTRIBUTE79               =p_aia_rec_tbl(l_counter).ATTRIBUTE79               ,
          ATTRIBUTE80               =p_aia_rec_tbl(l_counter).ATTRIBUTE80               ,
          ATTRIBUTE81               =p_aia_rec_tbl(l_counter).ATTRIBUTE81               ,
          ATTRIBUTE82               =p_aia_rec_tbl(l_counter).ATTRIBUTE82               ,
          ATTRIBUTE83               =p_aia_rec_tbl(l_counter).ATTRIBUTE83               ,
          ATTRIBUTE84               =p_aia_rec_tbl(l_counter).ATTRIBUTE84               ,
          ATTRIBUTE85               =p_aia_rec_tbl(l_counter).ATTRIBUTE85               ,
          ATTRIBUTE86               =p_aia_rec_tbl(l_counter).ATTRIBUTE86               ,
          ATTRIBUTE87               =p_aia_rec_tbl(l_counter).ATTRIBUTE87               ,
          ATTRIBUTE88               =p_aia_rec_tbl(l_counter).ATTRIBUTE88               ,
          ATTRIBUTE89               =p_aia_rec_tbl(l_counter).ATTRIBUTE89               ,
          ATTRIBUTE90               =p_aia_rec_tbl(l_counter).ATTRIBUTE90               ,
          ATTRIBUTE91               =p_aia_rec_tbl(l_counter).ATTRIBUTE91               ,
          ATTRIBUTE92               =p_aia_rec_tbl(l_counter).ATTRIBUTE92               ,
          ATTRIBUTE93               =p_aia_rec_tbl(l_counter).ATTRIBUTE93               ,
          ATTRIBUTE94               =p_aia_rec_tbl(l_counter).ATTRIBUTE94               ,
          ATTRIBUTE95               =p_aia_rec_tbl(l_counter).ATTRIBUTE95               ,
          ATTRIBUTE96               =p_aia_rec_tbl(l_counter).ATTRIBUTE96               ,
          ATTRIBUTE97               =p_aia_rec_tbl(l_counter).ATTRIBUTE97               ,
          ATTRIBUTE98               =p_aia_rec_tbl(l_counter).ATTRIBUTE98               ,
          ATTRIBUTE99               =p_aia_rec_tbl(l_counter).ATTRIBUTE99               ,
          ATTRIBUTE100              =p_aia_rec_tbl(l_counter).ATTRIBUTE100
          WHERE ORDER_NUMBER      = p_aia_rec_tbl(l_counter).ORDER_NUMBER;

Line: 892


        debugmsg('CN_COLLECTION_AIA_PUB.loadrow_om api: ' || 'UPDATED ORDER NUMBER' || ' '
        || p_aia_rec_tbl(l_counter).ORDER_NUMBER );

Line: 959


  l_update_flag     VARCHAR2(10) := 'N';

Line: 964


  l_update_check    NUMBER       := -1;

Line: 974


      SELECT employee_number
       FROM cn_salesreps
      WHERE resource_id IN
      (SELECT resource_id
         FROM jtf_rs_resource_extns
        WHERE source_number = p_employee_number
      );

Line: 984


     SELECT salesrep_id
       FROM cn_salesreps
      WHERE resource_id IN
      (SELECT resource_id
         FROM jtf_rs_resource_extns
        WHERE source_number = p_employee_number
      );

Line: 994


     SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;

Line: 998


     SELECT source_number
       FROM jtf_rs_resource_extns
      WHERE resource_id IN
      ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id
      ) ;

Line: 1006


     SELECT 'Y' FLAG,
      TRANS_SEQ_ID
       FROM CN_COLLECTION_AIA
      WHERE INVOICE_NUMBER = p_invoice_number
    AND rownum             = 1;

Line: 1014


     SELECT 1 FLAG
       FROM cn_not_trx
      WHERE source_trx_line_id = l_trans_seq_num --*** Line.Primary_Key
    AND event_id               = -1020
    AND org_id                 = p_org_id;

Line: 1220


      l_update_check    := -1;

Line: 1221


      l_update_flag     := 'N';

Line: 1368


          l_update_flag   := l_invoice_num_cr.FLAG;

Line: 1372


        debugmsg('CN_COLLECTION_AIA_PUB.loadrow api: l_update_flag: ' || l_update_flag);

Line: 1375


        IF(l_update_flag = 'N') THEN
          debugmsg('CN_COLLECTION_AIA_PUB.loadrow api: insert start ');

Line: 1377


           INSERT
             INTO CN_COLLECTION_AIA
            (
              TRANS_SEQ_ID             ,
              SALESREP_ID              ,
              EMPLOYEE_NUMBER          ,
              PROCESSED_DATE           ,
              INVOICE_NUMBER           ,
              INVOICE_DATE             ,
              TRANSACTION_AMOUNT       ,
              TRANSACTION_CURRENCY_CODE,
              TRX_TYPE                 ,
              REVENUE_TYPE             ,
              SALESREP_NUMBER          ,
              ADJUST_COMMENTS          ,
              ADJUST_STATUS            ,
              SOURCE_DOC_ID            ,
              UPDATE_FLAG              ,
              ORG_ID                   ,
              ATTRIBUTE1               ,
              ATTRIBUTE2               ,
              ATTRIBUTE3               ,
              ATTRIBUTE4               ,
              ATTRIBUTE5               ,
              ATTRIBUTE6               ,
              ATTRIBUTE7               ,
              ATTRIBUTE8               ,
              ATTRIBUTE9               ,
              ATTRIBUTE10              ,
              ATTRIBUTE11              ,
              ATTRIBUTE12              ,
              ATTRIBUTE13              ,
              ATTRIBUTE14              ,
              ATTRIBUTE15              ,
              ATTRIBUTE16              ,
              ATTRIBUTE17              ,
              ATTRIBUTE18              ,
              ATTRIBUTE19              ,
              ATTRIBUTE20              ,
              ATTRIBUTE21              ,
              ATTRIBUTE22              ,
              ATTRIBUTE23              ,
              ATTRIBUTE24              ,
              ATTRIBUTE25              ,
              ATTRIBUTE26              ,
              ATTRIBUTE27              ,
              ATTRIBUTE28              ,
              ATTRIBUTE29              ,
              ATTRIBUTE30              ,
              ATTRIBUTE31              ,
              ATTRIBUTE32              ,
              ATTRIBUTE33              ,
              ATTRIBUTE34              ,
              ATTRIBUTE35              ,
              ATTRIBUTE36              ,
              ATTRIBUTE37              ,
              ATTRIBUTE38              ,
              ATTRIBUTE39              ,
              ATTRIBUTE40              ,
              ATTRIBUTE41              ,
              ATTRIBUTE42              ,
              ATTRIBUTE43              ,
              ATTRIBUTE44              ,
              ATTRIBUTE45              ,
              ATTRIBUTE46              ,
              ATTRIBUTE47              ,
              ATTRIBUTE48              ,
              ATTRIBUTE49              ,
              ATTRIBUTE50              ,
              ATTRIBUTE51              ,
              ATTRIBUTE52              ,
              ATTRIBUTE53              ,
              ATTRIBUTE54              ,
              ATTRIBUTE55              ,
              ATTRIBUTE56              ,
              ATTRIBUTE57              ,
              ATTRIBUTE58              ,
              ATTRIBUTE59              ,
              ATTRIBUTE60              ,
              ATTRIBUTE61              ,
              ATTRIBUTE62              ,
              ATTRIBUTE63              ,
              ATTRIBUTE64              ,
              ATTRIBUTE65              ,
              ATTRIBUTE66              ,
              ATTRIBUTE67              ,
              ATTRIBUTE68              ,
              ATTRIBUTE69              ,
              ATTRIBUTE70              ,
              ATTRIBUTE71              ,
              ATTRIBUTE72              ,
              ATTRIBUTE73              ,
              ATTRIBUTE74              ,
              ATTRIBUTE75              ,
              ATTRIBUTE76              ,
              ATTRIBUTE77              ,
              ATTRIBUTE78              ,
              ATTRIBUTE79              ,
              ATTRIBUTE80              ,
              ATTRIBUTE81              ,
              ATTRIBUTE82              ,
              ATTRIBUTE83              ,
              ATTRIBUTE84              ,
              ATTRIBUTE85              ,
              ATTRIBUTE86              ,
              ATTRIBUTE87              ,
              ATTRIBUTE88              ,
              ATTRIBUTE89              ,
              ATTRIBUTE90              ,
              ATTRIBUTE91              ,
              ATTRIBUTE92              ,
              ATTRIBUTE93              ,
              ATTRIBUTE94              ,
              ATTRIBUTE95              ,
              ATTRIBUTE96              ,
              ATTRIBUTE97              ,
              ATTRIBUTE98              ,
              ATTRIBUTE99              ,
              ATTRIBUTE100
            )
                  VALUES
            (
              CN_COLLECTION_AIA_S.NextVal                        ,
              l_salesrep_id                                      ,
              l_employee_number                                  ,
              to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
              p_aia_rec_tbl(l_counter).INVOICE_NUMBER            ,
              to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss'),
              p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT        ,
              p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
              'AIA'                  ,
              decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE', p_aia_rec_tbl(l_counter).REVENUE_TYPE),
              l_salesrep_number                                  ,
              p_aia_rec_tbl(l_counter).ADJUST_COMMENTS           ,
              'MANUAL'                                           ,
              p_aia_rec_tbl(l_counter).SOURCE_DOC_ID             ,
              l_update_flag                                      ,
              p_org_id                                           ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE1                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE2                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE3                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE4                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE5                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE6                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE7                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE8                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE9                ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE10               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE11               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE12               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE13               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE14               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE15               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE16               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE17               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE18               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE19               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE20               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE21               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE22               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE23               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE24               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE25               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE26               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE27               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE28               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE29               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE30               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE31               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE32               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE33               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE34               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE35               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE36               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE37               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE38               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE39               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE40               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE41               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE42               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE43               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE44               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE45               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE46               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE47               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE48               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE49               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE50               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE51               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE52               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE53               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE54               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE55               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE56               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE57               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE58               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE59               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE60               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE61               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE62               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE63               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE64               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE65               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE66               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE67               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE68               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE69               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE70               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE71               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE72               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE73               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE74               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE75               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE76               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE77               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE78               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE79               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE80               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE81               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE82               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE83               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE84               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE85               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE86               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE87               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE88               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE89               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE90               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE91               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE92               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE93               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE94               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE95               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE96               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE97               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE98               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE99               ,
              p_aia_rec_tbl(l_counter).ATTRIBUTE100
            );

Line: 1629


            'CN_COLLECTION_AIA_PUB.loadrow api:  ' || 'INSERTED INVOICE NUMBER' || ' '
            || p_aia_rec_tbl(l_counter).INVOICE_NUMBER
          )
          ;

Line: 1639


            l_update_check := l_invoice_num_cr.FLAG;

Line: 1644


            'CN_COLLECTION_AIA_PUB.loadrow api: l_update_check(in table cn_not_trx): ' || l_update_check
          )
          ;

Line: 1650


              l_update_check = -1
            )
            THEN
            l_update_flag := 'N';

Line: 1657


            'CN_COLLECTION_AIA_PUB.loadrow api: l_update_flag: ' || l_update_flag
          )
          ;

Line: 1662


            'CN_COLLECTION_AIA_PUB.loadrow api: update process start '
          )
          ;

Line: 1665


           UPDATE CN_COLLECTION_AIA
          SET SALESREP_ID             =l_salesrep_id               ,
            EMPLOYEE_NUMBER           =l_employee_number           ,
            PROCESSED_DATE            =to_date(p_aia_rec_tbl(l_counter).PROCESSED_DATE, 'dd/mm/yyyy hh24:mi:ss'),
            INVOICE_DATE              =to_date(p_aia_rec_tbl(l_counter).INVOICE_DATE, 'dd/mm/yyyy hh24:mi:ss'),
            TRANSACTION_AMOUNT        =p_aia_rec_tbl(l_counter).TRANSACTION_AMOUNT        ,
            TRANSACTION_CURRENCY_CODE =p_aia_rec_tbl(l_counter).TRANSACTION_CURRENCY_CODE ,
            TRX_TYPE                  ='AIA'                  ,
            REVENUE_TYPE              =decode(p_aia_rec_tbl(l_counter).REVENUE_TYPE, FND_API.G_MISS_CHAR, 'REVENUE',
                                          p_aia_rec_tbl(l_counter).REVENUE_TYPE)          ,
            SALESREP_NUMBER           =l_salesrep_number                                  ,
            ADJUST_COMMENTS           =p_aia_rec_tbl(l_counter).ADJUST_COMMENTS           ,
            ADJUST_STATUS             ='MANUAL'                                           ,
            SOURCE_DOC_ID             =p_aia_rec_tbl(l_counter).SOURCE_DOC_ID             ,
            UPDATE_FLAG               =l_update_flag                                      ,
            ORG_ID                    =p_org_id                                           ,
            ATTRIBUTE1                =p_aia_rec_tbl(l_counter).ATTRIBUTE1                ,
            ATTRIBUTE2                =p_aia_rec_tbl(l_counter).ATTRIBUTE2                ,
            ATTRIBUTE3                =p_aia_rec_tbl(l_counter).ATTRIBUTE3                ,
            ATTRIBUTE4                =p_aia_rec_tbl(l_counter).ATTRIBUTE4                ,
            ATTRIBUTE5                =p_aia_rec_tbl(l_counter).ATTRIBUTE5                ,
            ATTRIBUTE6                =p_aia_rec_tbl(l_counter).ATTRIBUTE6                ,
            ATTRIBUTE7                =p_aia_rec_tbl(l_counter).ATTRIBUTE7                ,
            ATTRIBUTE8                =p_aia_rec_tbl(l_counter).ATTRIBUTE8                ,
            ATTRIBUTE9                =p_aia_rec_tbl(l_counter).ATTRIBUTE9                ,
            ATTRIBUTE10               =p_aia_rec_tbl(l_counter).ATTRIBUTE10               ,
            ATTRIBUTE11               =p_aia_rec_tbl(l_counter).ATTRIBUTE11               ,
            ATTRIBUTE12               =p_aia_rec_tbl(l_counter).ATTRIBUTE12               ,
            ATTRIBUTE13               =p_aia_rec_tbl(l_counter).ATTRIBUTE13               ,
            ATTRIBUTE14               =p_aia_rec_tbl(l_counter).ATTRIBUTE14               ,
            ATTRIBUTE15               =p_aia_rec_tbl(l_counter).ATTRIBUTE15               ,
            ATTRIBUTE16               =p_aia_rec_tbl(l_counter).ATTRIBUTE16               ,
            ATTRIBUTE17               =p_aia_rec_tbl(l_counter).ATTRIBUTE17               ,
            ATTRIBUTE18               =p_aia_rec_tbl(l_counter).ATTRIBUTE18               ,
            ATTRIBUTE19               =p_aia_rec_tbl(l_counter).ATTRIBUTE19               ,
            ATTRIBUTE20               =p_aia_rec_tbl(l_counter).ATTRIBUTE20               ,
            ATTRIBUTE21               =p_aia_rec_tbl(l_counter).ATTRIBUTE21               ,
            ATTRIBUTE22               =p_aia_rec_tbl(l_counter).ATTRIBUTE22               ,
            ATTRIBUTE23               =p_aia_rec_tbl(l_counter).ATTRIBUTE23               ,
            ATTRIBUTE24               =p_aia_rec_tbl(l_counter).ATTRIBUTE24               ,
            ATTRIBUTE25               =p_aia_rec_tbl(l_counter).ATTRIBUTE25               ,
            ATTRIBUTE26               =p_aia_rec_tbl(l_counter).ATTRIBUTE26               ,
            ATTRIBUTE27               =p_aia_rec_tbl(l_counter).ATTRIBUTE27               ,
            ATTRIBUTE28               =p_aia_rec_tbl(l_counter).ATTRIBUTE28               ,
            ATTRIBUTE29               =p_aia_rec_tbl(l_counter).ATTRIBUTE29               ,
            ATTRIBUTE30               =p_aia_rec_tbl(l_counter).ATTRIBUTE30               ,
            ATTRIBUTE31               =p_aia_rec_tbl(l_counter).ATTRIBUTE31               ,
            ATTRIBUTE32               =p_aia_rec_tbl(l_counter).ATTRIBUTE32               ,
            ATTRIBUTE33               =p_aia_rec_tbl(l_counter).ATTRIBUTE33               ,
            ATTRIBUTE34               =p_aia_rec_tbl(l_counter).ATTRIBUTE34               ,
            ATTRIBUTE35               =p_aia_rec_tbl(l_counter).ATTRIBUTE35               ,
            ATTRIBUTE36               =p_aia_rec_tbl(l_counter).ATTRIBUTE36               ,
            ATTRIBUTE37               =p_aia_rec_tbl(l_counter).ATTRIBUTE37               ,
            ATTRIBUTE38               =p_aia_rec_tbl(l_counter).ATTRIBUTE38               ,
            ATTRIBUTE39               =p_aia_rec_tbl(l_counter).ATTRIBUTE39               ,
            ATTRIBUTE40               =p_aia_rec_tbl(l_counter).ATTRIBUTE40               ,
            ATTRIBUTE41               =p_aia_rec_tbl(l_counter).ATTRIBUTE41               ,
            ATTRIBUTE42               =p_aia_rec_tbl(l_counter).ATTRIBUTE42               ,
            ATTRIBUTE43               =p_aia_rec_tbl(l_counter).ATTRIBUTE43               ,
            ATTRIBUTE44               =p_aia_rec_tbl(l_counter).ATTRIBUTE44               ,
            ATTRIBUTE45               =p_aia_rec_tbl(l_counter).ATTRIBUTE45               ,
            ATTRIBUTE46               =p_aia_rec_tbl(l_counter).ATTRIBUTE46               ,
            ATTRIBUTE47               =p_aia_rec_tbl(l_counter).ATTRIBUTE47               ,
            ATTRIBUTE48               =p_aia_rec_tbl(l_counter).ATTRIBUTE48               ,
            ATTRIBUTE49               =p_aia_rec_tbl(l_counter).ATTRIBUTE49               ,
            ATTRIBUTE50               =p_aia_rec_tbl(l_counter).ATTRIBUTE50               ,
            ATTRIBUTE51               =p_aia_rec_tbl(l_counter).ATTRIBUTE51               ,
            ATTRIBUTE52               =p_aia_rec_tbl(l_counter).ATTRIBUTE52               ,
            ATTRIBUTE53               =p_aia_rec_tbl(l_counter).ATTRIBUTE53               ,
            ATTRIBUTE54               =p_aia_rec_tbl(l_counter).ATTRIBUTE54               ,
            ATTRIBUTE55               =p_aia_rec_tbl(l_counter).ATTRIBUTE55               ,
            ATTRIBUTE56               =p_aia_rec_tbl(l_counter).ATTRIBUTE56               ,
            ATTRIBUTE57               =p_aia_rec_tbl(l_counter).ATTRIBUTE57               ,
            ATTRIBUTE58               =p_aia_rec_tbl(l_counter).ATTRIBUTE58               ,
            ATTRIBUTE59               =p_aia_rec_tbl(l_counter).ATTRIBUTE59               ,
            ATTRIBUTE60               =p_aia_rec_tbl(l_counter).ATTRIBUTE60               ,
            ATTRIBUTE61               =p_aia_rec_tbl(l_counter).ATTRIBUTE61               ,
            ATTRIBUTE62               =p_aia_rec_tbl(l_counter).ATTRIBUTE62               ,
            ATTRIBUTE63               =p_aia_rec_tbl(l_counter).ATTRIBUTE63               ,
            ATTRIBUTE64               =p_aia_rec_tbl(l_counter).ATTRIBUTE64               ,
            ATTRIBUTE65               =p_aia_rec_tbl(l_counter).ATTRIBUTE65               ,
            ATTRIBUTE66               =p_aia_rec_tbl(l_counter).ATTRIBUTE66               ,
            ATTRIBUTE67               =p_aia_rec_tbl(l_counter).ATTRIBUTE67               ,
            ATTRIBUTE68               =p_aia_rec_tbl(l_counter).ATTRIBUTE68               ,
            ATTRIBUTE69               =p_aia_rec_tbl(l_counter).ATTRIBUTE69               ,
            ATTRIBUTE70               =p_aia_rec_tbl(l_counter).ATTRIBUTE70               ,
            ATTRIBUTE71               =p_aia_rec_tbl(l_counter).ATTRIBUTE71               ,
            ATTRIBUTE72               =p_aia_rec_tbl(l_counter).ATTRIBUTE72               ,
            ATTRIBUTE73               =p_aia_rec_tbl(l_counter).ATTRIBUTE73               ,
            ATTRIBUTE74               =p_aia_rec_tbl(l_counter).ATTRIBUTE74               ,
            ATTRIBUTE75               =p_aia_rec_tbl(l_counter).ATTRIBUTE75               ,
            ATTRIBUTE76               =p_aia_rec_tbl(l_counter).ATTRIBUTE76               ,
            ATTRIBUTE77               =p_aia_rec_tbl(l_counter).ATTRIBUTE77               ,
            ATTRIBUTE78               =p_aia_rec_tbl(l_counter).ATTRIBUTE78               ,
            ATTRIBUTE79               =p_aia_rec_tbl(l_counter).ATTRIBUTE79               ,
            ATTRIBUTE80               =p_aia_rec_tbl(l_counter).ATTRIBUTE80               ,
            ATTRIBUTE81               =p_aia_rec_tbl(l_counter).ATTRIBUTE81               ,
            ATTRIBUTE82               =p_aia_rec_tbl(l_counter).ATTRIBUTE82               ,
            ATTRIBUTE83               =p_aia_rec_tbl(l_counter).ATTRIBUTE83               ,
            ATTRIBUTE84               =p_aia_rec_tbl(l_counter).ATTRIBUTE84               ,
            ATTRIBUTE85               =p_aia_rec_tbl(l_counter).ATTRIBUTE85               ,
            ATTRIBUTE86               =p_aia_rec_tbl(l_counter).ATTRIBUTE86               ,
            ATTRIBUTE87               =p_aia_rec_tbl(l_counter).ATTRIBUTE87               ,
            ATTRIBUTE88               =p_aia_rec_tbl(l_counter).ATTRIBUTE88               ,
            ATTRIBUTE89               =p_aia_rec_tbl(l_counter).ATTRIBUTE89               ,
            ATTRIBUTE90               =p_aia_rec_tbl(l_counter).ATTRIBUTE90               ,
            ATTRIBUTE91               =p_aia_rec_tbl(l_counter).ATTRIBUTE91               ,
            ATTRIBUTE92               =p_aia_rec_tbl(l_counter).ATTRIBUTE92               ,
            ATTRIBUTE93               =p_aia_rec_tbl(l_counter).ATTRIBUTE93               ,
            ATTRIBUTE94               =p_aia_rec_tbl(l_counter).ATTRIBUTE94               ,
            ATTRIBUTE95               =p_aia_rec_tbl(l_counter).ATTRIBUTE95               ,
            ATTRIBUTE96               =p_aia_rec_tbl(l_counter).ATTRIBUTE96               ,
            ATTRIBUTE97               =p_aia_rec_tbl(l_counter).ATTRIBUTE97               ,
            ATTRIBUTE98               =p_aia_rec_tbl(l_counter).ATTRIBUTE98               ,
            ATTRIBUTE99               =p_aia_rec_tbl(l_counter).ATTRIBUTE99               ,
            ATTRIBUTE100              =p_aia_rec_tbl(l_counter).ATTRIBUTE100
            WHERE INVOICE_NUMBER      = p_aia_rec_tbl(l_counter).INVOICE_NUMBER;

Line: 1788


          debugmsg('CN_COLLECTION_AIA_PUB.loadrow api: ' || 'UPDATED INVOICE NUMBER' || ' '
          || p_aia_rec_tbl(l_counter).INVOICE_NUMBER );

Line: 1843


PROCEDURE updaterow_comm_api
  (
    x_return_status OUT nocopy VARCHAR2,
    x_start_period_name IN VARCHAR2,
    x_end_period_name   IN VARCHAR2 )
                        IS
  CURSOR c_update_records(l_start_date DATE,l_end_date DATE)
  IS
     SELECT *
       FROM CN_COLLECTION_AIA
      WHERE update_flag = 'Y'
    AND TRUNC(processed_date) BETWEEN to_date(l_start_date, 'dd-mm-rr') AND to_date(l_end_date, 'dd-mm-rr');

Line: 1856


    TYPE collect_aia_tbl_type IS TABLE OF c_update_records%ROWTYPE
        INDEX BY PLS_INTEGER;

Line: 1864


     SELECT period_id
       FROM cn_periods
      WHERE period_name = x_start_period_name
    AND org_id          = l_org_id ;

Line: 1871


     SELECT period_id
       FROM cn_periods
      WHERE period_name = x_end_period_name
    AND org_id          = l_org_id ;

Line: 1901


     SELECT max(comm_lines_api_id)
       FROM cn_comm_lines_api_all
      WHERE invoice_number      = p_invoice_number
    AND employee_number         = l_employee_number
    AND NVL(adjust_status,'N') <> 'FROZEN';

Line: 1925


     SELECT comm_lines_api_id
       FROM cn_comm_lines_api_all
      WHERE order_number      = p_order_number
    AND employee_number         = l_employee_number
    AND NVL(adjust_status,'N') <> 'FROZEN';

Line: 1940


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: start: ');

Line: 1945


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_org_id: ' || x_org_id);

Line: 1946


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_start_period_name: ' || x_start_period_name);

Line: 1947


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_end_period_name: ' || x_end_period_name);

Line: 1964


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_start_date: ' || x_start_date);

Line: 1965


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_end_date: ' || x_end_date);

Line: 1969


  OPEN c_update_records(x_start_date,x_end_date);

Line: 1970


      FETCH c_update_records
            BULK COLLECT INTO l_collect_aia_tbl;

Line: 1972


  CLOSE c_update_records;

Line: 1975


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: No. of records to be updated : ' || l_collect_aia_tbl_count);

Line: 1978


	 debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api : No transactions to Update.');

Line: 1981


      debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).trx_type: ' || l_collect_aia_tbl(i).trx_type);

Line: 2102


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_comm_lines_id: ' || l_comm_lines_id);

Line: 2103


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).invoice_number: ' || l_adj_rec_type.invoice_number);

Line: 2104


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).invoice_date: ' || l_adj_rec_type.invoice_date);

Line: 2105


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).transaction_amount: ' || l_adj_rec_type.transaction_amount);

Line: 2106


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).revenue_type: ' || l_adj_rec_type.revenue_type);

Line: 2107


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).processed_date: ' || l_adj_rec_type.processed_date);

Line: 2108


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).trx_type: ' || l_adj_rec_type.trx_type);

Line: 2109


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).transaction_currency_code: ' || l_adj_rec_type.orig_currency_code);

Line: 2110


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).salesrep_id: '     || l_adj_rec_type.direct_salesrep_id);

Line: 2111


        /*debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute1: ' || l_adj_rec_type.attribute1 );

Line: 2112


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).adjust_comments: ' || l_adj_rec_type.adjust_comments);

Line: 2113


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute2  : ' || l_adj_rec_type.attribute2 );

Line: 2114


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute3  : ' || l_adj_rec_type.attribute3 );

Line: 2115


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl.attribute4  : '    || l_adj_rec_type.attribute4 );

Line: 2116


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute5  : ' || l_adj_rec_type.attribute5 );

Line: 2117


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute6  : ' || l_adj_rec_type.attribute6 );

Line: 2118


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute7  : ' || l_adj_rec_type.attribute7 );

Line: 2119


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute8  : ' || l_adj_rec_type.attribute8 );

Line: 2120


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute9  : ' || l_adj_rec_type.attribute9  );

Line: 2121


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute10 : ' || l_adj_rec_type.attribute10 );

Line: 2122


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute11 : ' || l_adj_rec_type.attribute11 );

Line: 2123


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute12 : ' || l_adj_rec_type.attribute12 );

Line: 2124


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute13 : ' || l_adj_rec_type.attribute13 );

Line: 2125


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute14 : ' || l_adj_rec_type.attribute14 );

Line: 2126


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute15 : ' || l_adj_rec_type.attribute15 );

Line: 2127


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute16 : ' || l_adj_rec_type.attribute16 );

Line: 2128


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute17 : ' || l_adj_rec_type.attribute17 );

Line: 2129


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute18 : ' || l_adj_rec_type.attribute18 );

Line: 2130


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute19 : ' || l_adj_rec_type.attribute19 );

Line: 2131


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute20 : ' || l_adj_rec_type.attribute20 );

Line: 2132


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute21 : ' || l_adj_rec_type.attribute21 );

Line: 2133


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute22 : ' || l_adj_rec_type.attribute22 );

Line: 2134


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute23 : ' || l_adj_rec_type.attribute23 );

Line: 2135


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute24 : ' || l_adj_rec_type.attribute24 );

Line: 2136


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute25 : ' || l_adj_rec_type.attribute25 );

Line: 2137


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute26 : ' || l_adj_rec_type.attribute26 );

Line: 2138


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute27 : ' || l_adj_rec_type.attribute27 );

Line: 2139


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute28 : ' || l_adj_rec_type.attribute28 );

Line: 2140


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute29 : ' || l_adj_rec_type.attribute29 );

Line: 2141


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute30 : ' || l_adj_rec_type.attribute30 );

Line: 2142


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute31 : ' || l_adj_rec_type.attribute31 );

Line: 2143


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute32 : ' || l_adj_rec_type.attribute32 );

Line: 2144


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute33 : ' || l_adj_rec_type.attribute33 );

Line: 2145


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute34 : ' || l_adj_rec_type.attribute34 );

Line: 2146


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute35 : ' || l_adj_rec_type.attribute35 );

Line: 2147


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute36 : ' || l_adj_rec_type.attribute36 );

Line: 2148


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute37 : ' || l_adj_rec_type.attribute37 );

Line: 2149


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute38 : ' || l_adj_rec_type.attribute38 );

Line: 2150


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute39 : ' || l_adj_rec_type.attribute39 );

Line: 2151


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute40 : ' || l_adj_rec_type.attribute40 );

Line: 2152


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute41 : ' || l_adj_rec_type.attribute41 );

Line: 2153


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute42 : ' || l_adj_rec_type.attribute42 );

Line: 2154


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute43 : ' || l_adj_rec_type.attribute43 );

Line: 2155


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute44 : ' || l_adj_rec_type.attribute44 );

Line: 2156


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute45 : ' || l_adj_rec_type.attribute45 );

Line: 2157


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute46 : ' || l_adj_rec_type.attribute46 );

Line: 2158


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute47 : ' || l_adj_rec_type.attribute47 );

Line: 2159


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute48 : ' || l_adj_rec_type.attribute48 );

Line: 2160


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute49 : ' || l_adj_rec_type.attribute49 );

Line: 2161


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute50 : ' || l_adj_rec_type.attribute50 );

Line: 2162


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute51 : ' || l_adj_rec_type.attribute51 );

Line: 2163


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute52 : ' || l_adj_rec_type.attribute52 );

Line: 2164


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute53 : ' || l_adj_rec_type.attribute53 );

Line: 2165


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute54 : ' || l_adj_rec_type.attribute54 );

Line: 2166


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute55 : ' || l_adj_rec_type.attribute55 );

Line: 2167


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute56 : ' || l_adj_rec_type.attribute56 );

Line: 2168


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute57 : ' || l_adj_rec_type.attribute57 );

Line: 2169


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute58 : ' || l_adj_rec_type.attribute58 );

Line: 2170


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute59 : ' || l_adj_rec_type.attribute59 );

Line: 2171


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute60 : ' || l_adj_rec_type.attribute60 );

Line: 2172


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute61 : ' || l_adj_rec_type.attribute61 );

Line: 2173


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute62 : ' || l_adj_rec_type.attribute62 );

Line: 2174


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute63 : ' || l_adj_rec_type.attribute63 );

Line: 2175


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute64 : ' || l_adj_rec_type.attribute64 );

Line: 2176


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute65 : ' || l_adj_rec_type.attribute65 );

Line: 2177


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute66 : ' || l_adj_rec_type.attribute66 );

Line: 2178


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute67 : ' || l_adj_rec_type.attribute67 );

Line: 2179


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute68 : ' || l_adj_rec_type.attribute68 );

Line: 2180


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute69 : ' || l_adj_rec_type.attribute69 );

Line: 2181


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute70 : ' || l_adj_rec_type.attribute70 );

Line: 2182


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute71 : ' || l_adj_rec_type.attribute71 );

Line: 2183


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute72 : ' || l_adj_rec_type.attribute72 );

Line: 2184


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute73 : ' || l_adj_rec_type.attribute73 );

Line: 2185


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute74 : ' || l_adj_rec_type.attribute74 );

Line: 2186


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute75 : ' || l_adj_rec_type.attribute75 );

Line: 2187


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute76 : ' || l_adj_rec_type.attribute76 );

Line: 2188


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute77 : ' || l_adj_rec_type.attribute77 );

Line: 2189


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute78 : ' || l_adj_rec_type.attribute78 );

Line: 2190


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute79 : ' || l_adj_rec_type.attribute79 );

Line: 2191


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute80 : ' || l_adj_rec_type.attribute80 );

Line: 2192


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute81 : ' || l_adj_rec_type.attribute81 );

Line: 2193


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute82 : ' || l_adj_rec_type.attribute82 );

Line: 2194


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute83 : ' || l_adj_rec_type.attribute83 );

Line: 2195


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute84 : ' || l_adj_rec_type.attribute84 );

Line: 2196


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute85 : ' || l_adj_rec_type.attribute85 );

Line: 2197


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute86 : ' || l_adj_rec_type.attribute86 );

Line: 2198


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute87 : ' || l_adj_rec_type.attribute87 );

Line: 2199


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute88 : ' || l_adj_rec_type.attribute88 );

Line: 2200


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute89 : ' || l_adj_rec_type.attribute89 );

Line: 2201


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute90 : ' || l_adj_rec_type.attribute90 );

Line: 2202


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute91 : ' || l_adj_rec_type.attribute91 );

Line: 2203


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute92 : ' || l_adj_rec_type.attribute92 );

Line: 2204


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute93 : ' || l_adj_rec_type.attribute93 );

Line: 2205


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute94 : ' || l_adj_rec_type.attribute94 );

Line: 2206


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute95 : ' || l_adj_rec_type.attribute95 );

Line: 2207


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute96 : ' || l_adj_rec_type.attribute96 );

Line: 2208


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute97 : ' || l_adj_rec_type.attribute97 );

Line: 2209


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute98 : ' || l_adj_rec_type.attribute98 );

Line: 2210


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute99 : ' || l_adj_rec_type.attribute99 );

Line: 2211


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: l_collect_aia_tbl(i).attribute100: ' || l_adj_rec_type.attribute100);*/

Line: 2216


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api:exception in debug messages others: ' || SQLERRM(SQLCODE()) );

Line: 2218


        cn_get_tx_data_pub.update_api_record ( p_api_version => 1.0, p_newtx_rec => l_adj_rec_type, x_api_id => l_api_id, x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data, x_loading_status => l_loading_status);

Line: 2221


        debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: updating update_flag to N of CN_COLLECTION_AIA : ' );

Line: 2222


         UPDATE CN_COLLECTION_AIA
        SET update_flag        = 'N'
          WHERE invoice_number = l_collect_aia_tbl(i).invoice_number;

Line: 2231


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_return_status: ' || x_return_status);

Line: 2235


  debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api:exception others: ' || SQLERRM(SQLCODE()) );

Line: 2237


END updaterow_comm_api;