APPS.OKC_K_HISTORY_PVT SQL Statements

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

Line: 19

  G_NO_UPDATE_ALLOWED_EXCEPTION exception;

Line: 20

  G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';

Line: 39

    OKC_HST_PVT.Insert_Row(
               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,
            x_hstv_rec          => x_hstv_rec);

Line: 60

    OKC_HST_PVT.Insert_Row(
         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_tbl                => p_hstv_tbl,
      x_hstv_tbl                => x_hstv_tbl);

Line: 71

  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 OKC_HST_PVT.hstv_rec_type) IS

  BEGIN

    OKC_HST_PVT.Delete_Row(
                        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_rec);

Line: 100

  END delete_k_history;

Line: 102

  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 OKC_HST_PVT.hstv_tbl_type) IS

  BEGIN
    OKC_HST_PVT.Delete_Row(
         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_tbl                => p_hstv_tbl);

Line: 118

  END delete_k_history;

Line: 120

  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

  BEGIN

    OKC_HST_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: 149

  END delete_all_rows;