APPS.INV_EXTERNAL_INTERFACE_SV SQL Statements

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

Line: 41

      update_history      EXCEPTION;

Line: 85

          SELECT trading_partner_site_id
          INTO l_Party_Site_ID
          FROM mtl_client_parameters
          WHERE client_id IN (SELECT cust_account_id
                              FROM hz_cust_accounts
                              WHERE party_id = P_txn_hist_record.trading_partner_id);

Line: 225

          INV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
                                                                    l_xml_document_id,
                                                                    l_txns_id,
                                                                    l_return_status );

Line: 240

              RAISE update_history;

Line: 274

      WHEN update_history THEN
         x_return_status := rcv_error_pkg.g_ret_sts_error;

Line: 277

           inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_EXTERNAL_INTERFACE_SV', 9);