APPS.OKC_K_HISTORY_PUB SQL Statements

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

Line: 226

  PROCEDURE delete_k_history(
    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_hstv_rec                     IN hstv_rec_type) IS

    l_hstv_rec          hstv_rec_type;

Line: 235

    l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_K_HISTORY';

Line: 279

    OKC_K_HISTORY_PVT.delete_k_history(
         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_hstv_rec                => l_hstv_rec);

Line: 338

  END delete_k_history;

Line: 340

  PROCEDURE delete_k_history(
    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_hstv_tbl                     IN hstv_tbl_type) IS

    l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_K_HISTORY';

Line: 376

                OKC_K_HISTORY_PVT.delete_k_history(
                        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_hstv_rec              => p_hstv_tbl(i));

Line: 435

  END delete_k_history;

Line: 437

 PROCEDURE delete_all_rows(
    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 NUMBER) IS

    l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_ALL_ROWS';

Line: 450

    OKC_K_HISTORY_PVT.delete_all_rows(
         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);

Line: 494

  END delete_all_rows;