APPS.OKS_SRVAVL_PUB SQL Statements

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

Line: 5

  PROCEDURE insert_serv_avail
  (
    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_savv_rec                     IN savv_rec_type,
    x_savv_rec                     OUT NOCOPY savv_rec_type
  )

  Is

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

Line: 61

  oks_srvavl_pvt.insert_serv_avail
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_savv_rec                     ,
    x_savv_rec
  );

Line: 137

  PROCEDURE insert_serv_avail(
    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_savv_tbl                     IN savv_tbl_type,
    x_savv_tbl                     OUT NOCOPY savv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'insert_serv_avail';

Line: 159

            insert_serv_avail
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_savv_tbl(l_ptr)
                       ,x_savv_tbl(l_ptr)
            );

Line: 210

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

Line: 299

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

Line: 376

  PROCEDURE update_serv_avail(
    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_savv_rec                     IN savv_rec_type,
    x_savv_rec                     OUT NOCOPY savv_rec_type)
  Is

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

Line: 429

  oks_srvavl_pvt.update_serv_avail
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_savv_rec                     ,
    x_savv_rec
  );

Line: 505

  PROCEDURE update_serv_avail(
    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_savv_tbl                     IN savv_tbl_type,
    x_savv_tbl                     OUT NOCOPY savv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'update_serv_avail';

Line: 527

            update_serv_avail
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_savv_tbl(l_ptr)
                       ,x_savv_tbl(l_ptr)
            );

Line: 580

  PROCEDURE delete_serv_avail(
    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_savv_rec                     IN savv_rec_type)
  Is

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

Line: 632

  oks_srvavl_pvt.delete_serv_avail
  (
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    l_savv_rec
  );

Line: 705

  PROCEDURE delete_serv_avail(
    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_savv_tbl                     IN savv_tbl_type)
  Is
    l_api_name              CONSTANT VARCHAR2(30) := 'update_serv_avail';

Line: 726

            delete_serv_avail
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_savv_tbl(l_ptr)
            );

Line: 798

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

Line: 924

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