APPS.RCV_EXTERNAL_INTERFACE_SV SQL Statements

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

Line: 44

      update_history      EXCEPTION;

Line: 83

          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: 235

          SELECT receipt_num
          INTO l_txn_hist_record.Entity_Number
          FROM rcv_shipment_headers
          WHERE shipment_header_id = l_txn_hist_record.Entity_Number;

Line: 244

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

Line: 258

              RAISE update_history;

Line: 292

      WHEN update_history THEN
         x_return_status := rcv_error_pkg.g_ret_sts_error;

Line: 295

          asn_debug.put_line('update_history exception has occured.');