APPS.OKC_CLASS_PUB SQL Statements

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

Line: 10

  PROCEDURE insert_class(
    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_clsv_rec                     IN clsv_rec_type,
    x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS
  BEGIN
    okc_class_pvt.insert_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_rec,
              x_clsv_rec);

Line: 29

  PROCEDURE insert_class(
    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_clsv_tbl                     IN clsv_tbl_type,
    x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS
  BEGIN
    okc_class_pvt.insert_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_tbl,
              x_clsv_tbl);

Line: 82

  PROCEDURE update_class(
    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_clsv_rec                     IN clsv_rec_type,
    x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS
  BEGIN
    okc_class_pvt.update_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_rec,
              x_clsv_rec);

Line: 101

  PROCEDURE update_class(
    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_clsv_tbl                     IN clsv_tbl_type,
    x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS
  BEGIN
    okc_class_pvt.update_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_tbl,
              x_clsv_tbl);

Line: 120

  PROCEDURE delete_class(
    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_clsv_rec                     IN clsv_rec_type) IS
  BEGIN
    okc_class_pvt.delete_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_rec);

Line: 137

  PROCEDURE delete_class(
    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_clsv_tbl                     IN clsv_tbl_type) IS
  BEGIN
    okc_class_pvt.delete_class(
              p_api_version,
              p_init_msg_list,
              x_return_status,
              x_msg_count,
              x_msg_data,
              p_clsv_tbl);