APPS.OKC_ASSENT_PVT SQL Statements

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

Line: 23

     OKC_AST_PVT.Insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_rec,
                         x_astv_rec);

Line: 45

     OKC_AST_PVT.Insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_tbl,
                         x_astv_tbl);

Line: 58

  PROCEDURE update_assent(
     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_astv_rec                     IN  astv_rec_type,
     x_astv_rec                     OUT NOCOPY astv_rec_type) IS
  BEGIN
     OKC_AST_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_rec,
                         x_astv_rec);

Line: 75

  END update_assent;

Line: 80

  PROCEDURE update_assent(
     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_astv_tbl                     IN  astv_tbl_type,
     x_astv_tbl                     OUT NOCOPY astv_tbl_type) IS
  BEGIN
     OKC_AST_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_tbl,
                         x_astv_tbl);

Line: 97

  END update_assent;

Line: 102

  PROCEDURE delete_assent(
     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_astv_rec                     IN  astv_rec_type) IS
  BEGIN
     OKC_AST_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_rec);

Line: 117

  END delete_assent;

Line: 122

  PROCEDURE delete_assent(
     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_astv_tbl                     IN astv_tbl_type) IS
  BEGIN
     OKC_AST_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_tbl);

Line: 137

  END delete_assent;

Line: 261

     OKC_STS_PVT.Insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_rec,
                         x_stsv_rec);

Line: 283

     OKC_STS_PVT.Insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_tbl,
                         x_stsv_tbl);

Line: 296

  PROCEDURE update_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_stsv_rec                     IN stsv_rec_type,
     x_stsv_rec                     OUT NOCOPY stsv_rec_type) IS
  BEGIN
     OKC_STS_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_rec,
                         x_stsv_rec);

Line: 313

  END update_status;

Line: 318

  PROCEDURE update_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_stsv_tbl                     IN  stsv_tbl_type,
     x_stsv_tbl                     OUT NOCOPY stsv_tbl_type) IS
  BEGIN
     OKC_STS_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_tbl,
                         x_stsv_tbl);

Line: 335

  END update_status;

Line: 340

  PROCEDURE delete_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_stsv_rec                     IN stsv_rec_type) IS
  BEGIN
     OKC_STS_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_rec);

Line: 355

  END delete_status;

Line: 360

  PROCEDURE delete_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_stsv_tbl                     IN  stsv_tbl_type) IS
  BEGIN
     OKC_STS_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_tbl);

Line: 375

  END delete_status;