APPS.OKL_SERVICE_INTEGRATION_PUB SQL Statements

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

Line: 328

  PROCEDURE delete_service_line(
                                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_clev_rec            IN  clev_rec_type,
                                p_klev_rec            IN  klev_rec_type
                               ) IS
  l_api_name    VARCHAR2(35)    := 'delete_service_link';

Line: 338

  l_proc_name   VARCHAR2(35)    := 'DELETE_SERVICE_LINK';

Line: 364

      okl_service_integration_pvt.delete_service_line(
                                            p_api_version       => p_api_version,
                                            p_init_msg_list     => OKL_API.G_FALSE,
                                            x_return_status     => x_return_status,
                                            x_msg_count         => x_msg_count,
                                            x_msg_data          => x_msg_data,
                                            p_clev_rec          => p_clev_rec,
                                            p_klev_rec          => p_klev_rec
                                           );

Line: 413

  END delete_service_line;

Line: 425

 PROCEDURE update_service_line(
                                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_okl_chr_id          IN  OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
                                p_oks_chr_id          IN  OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
                                p_oks_service_line_id IN  OKC_K_LINES_V.ID%TYPE,   -- Service Contract Service Top Line ID
                                p_supplier_id         IN  NUMBER,
                                p_clev_rec            IN  clev_rec_type,
                                p_klev_rec            IN  klev_rec_type,
                                x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
                              ) IS
  l_api_name    VARCHAR2(35)    := 'update_service_link';

Line: 440

  l_proc_name   VARCHAR2(35)    := 'UPDATE_SERVICE_LINK';

Line: 466

      okl_service_integration_pvt.update_service_line(
                             p_api_version         => p_api_version,
                             p_init_msg_list       => OKL_API.G_TRUE,
                             x_return_status       => x_return_status,
                             x_msg_count           => x_msg_count,
                             x_msg_data            => x_msg_data,
                             p_okl_chr_id          => p_okl_chr_id,
                             p_oks_chr_id          => p_oks_chr_id,
                             p_oks_service_line_id => p_oks_service_line_id,
                             p_supplier_id         => p_supplier_id,
                             p_clev_rec            => p_clev_rec,
                             p_klev_rec            => p_klev_rec,
                             x_okl_service_line_id => x_okl_service_line_id
                            );

Line: 520

  END update_service_line;

Line: 830

 PROCEDURE update_cov_asset_line(
                                 p_api_version    IN  NUMBER,
                                 p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                                 x_return_status  OUT NOCOPY VARCHAR2,
                                 x_msg_count      OUT NOCOPY NUMBER,
                                 x_msg_data       OUT NOCOPY VARCHAR2,
                                 p_clev_tbl       IN  clev_tbl_type,
                                 p_klev_tbl       IN  klev_tbl_type,
                                 p_cimv_tbl       IN  cimv_tbl_type,
                                 p_cov_tbl        IN  srv_cov_tbl_type,
                                 x_clev_tbl       OUT NOCOPY clev_tbl_type,
                                 x_klev_tbl       OUT NOCOPY klev_tbl_type,
                                 x_cimv_tbl       OUT NOCOPY cimv_tbl_type
                                ) IS
  l_api_name    VARCHAR2(35)    := 'update_cov_asset_line';

Line: 845

  l_proc_name   VARCHAR2(35)    := 'UPDATE_COV_ASSET_LINE';

Line: 870

      OKL_SERVICE_INTEGRATION_PVT.UPDATE_COV_ASSET_LINE (
                              p_api_version    => p_api_version,
                              p_init_msg_list  => OKL_API.G_FALSE,
                              x_return_status  => x_return_status,
                              x_msg_count      => x_msg_count,
                              x_msg_data       => x_msg_data,
                              p_clev_tbl       => p_clev_tbl,
                              p_klev_tbl       => p_klev_tbl,
                              p_cimv_tbl       => p_cimv_tbl,
                              p_cov_tbl        => p_cov_tbl,
                              x_clev_tbl       => x_clev_tbl,
                              x_klev_tbl       => x_klev_tbl,
                              x_cimv_tbl       => x_cimv_tbl
                             );

Line: 922

  END update_cov_asset_line;