APPS.OKS_BSL_DET_PUB SQL Statements

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

Line: 4

  PROCEDURE insert_bsl_det_Pub
  (
    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_bsdv_rec                     IN bsdv_rec_type,
    x_bsdv_rec                     OUT NOCOPY bsdv_rec_type
  )

  Is

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

Line: 60

  oks_bsl_det_pvt.insert_bsl_det_Comp
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_bsdv_rec                     ,
    x_bsdv_rec
  );

Line: 136

  PROCEDURE insert_bsl_det_Pub(
    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_bsdv_tbl                     IN bsdv_tbl_type,
    x_bsdv_tbl                     OUT NOCOPY bsdv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'insert_bsl_det_Pub';

Line: 158

            insert_bsl_det_Pub
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bsdv_tbl(l_ptr)
                       ,x_bsdv_tbl(l_ptr)
            );

Line: 209

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

Line: 298

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

Line: 375

  PROCEDURE update_bsl_det_Pub(
    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_bsdv_rec                     IN bsdv_rec_type,
    x_bsdv_rec                     OUT NOCOPY bsdv_rec_type)
  Is

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

Line: 428

  oks_bsl_det_pvt.update_bsl_det_comp
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_bsdv_rec                     ,
    x_bsdv_rec
  );

Line: 504

  PROCEDURE update_bsl_det_Pub(
    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_bsdv_tbl                     IN bsdv_tbl_type,
    x_bsdv_tbl                     OUT NOCOPY bsdv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'update_bsl_det_Pub';

Line: 526

            update_bsl_det_Pub
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bsdv_tbl(l_ptr)
                       ,x_bsdv_tbl(l_ptr)
            );

Line: 579

  PROCEDURE delete_bsl_det_Pub(
    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_bsdv_rec                     IN bsdv_rec_type)
  Is

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

Line: 631

  oks_bsl_det_pvt.delete_bsl_det_Comp
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_bsdv_rec
  );

Line: 704

  PROCEDURE delete_bsl_det_Pub(
    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_bsdv_tbl                     IN bsdv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'update_bsl_det_Pub';

Line: 725

            delete_bsl_det_Pub            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bsdv_tbl(l_ptr)
            );

Line: 796

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

Line: 922

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