APPS.OKL_TRANSACTION_PUB SQL Statements

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

Line: 137

  PROCEDURE update_trx_status(
                              p_api_version        IN  NUMBER,
                              p_init_msg_list      IN  VARCHAR2,
                              x_return_status      OUT NOCOPY VARCHAR2,
                              x_msg_count          OUT NOCOPY NUMBER,
                              x_msg_data           OUT NOCOPY VARCHAR2,
                              p_chr_id             IN  OKC_K_HEADERS_V.ID%TYPE,
                              p_status             IN  VARCHAR2,
                              x_tcnv_rec           OUT NOCOPY tcnv_rec_type
                             ) IS

  l_api_name    VARCHAR2(35)    := 'update_trx_status';

Line: 149

  l_proc_name   VARCHAR2(35)    := 'UPDATE_TRX_STATUS';

Line: 173

      okl_transaction_pvt.update_trx_status(
                                            p_api_version        => p_api_version,
                                            p_init_msg_list      => p_init_msg_list,
                                            x_return_status      => x_return_status,
                                            x_msg_count          => x_msg_count,
                                            x_msg_data           => x_msg_data,
                                            p_chr_id             => p_chr_id,
                                            p_status             => p_status,
                                            x_tcnv_rec           => x_tcnv_rec
                                           );

Line: 219

  END update_trx_status;

Line: 241

    l_proc_name   VARCHAR2(35)    := 'UPDATE_TRX_STATUS';