DBA Data[Home] [Help]

APPS.OKS_SUBSCR_ELEMS_PUB SQL Statements

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

Line: 19

  PROCEDURE insert_row(
    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_scev_rec                     IN scev_rec_type,
    x_scev_rec                     OUT NOCOPY scev_rec_type) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'insert_row';
Line: 62

  OKS_SUBSCR_ELEMS_PVT.insert_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_rec         => p_scev_rec,
                                x_scev_rec         => x_scev_rec);
Line: 131

    End insert_row;
Line: 133

  PROCEDURE insert_row(
    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_scev_tbl                     IN scev_tbl_type,
    x_scev_tbl                     OUT NOCOPY scev_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'insert_row';
Line: 175

  OKS_SUBSCR_ELEMS_PVT.insert_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_tbl         => p_scev_tbl,
                                x_scev_tbl         => x_scev_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 246

    End insert_row;
Line: 248

  PROCEDURE insert_row(
    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_scev_tbl                     IN scev_tbl_type,
    x_scev_tbl                     OUT NOCOPY scev_tbl_type) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'insert_row';
Line: 270

            insert_row
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_scev_tbl(l_ptr)
                       ,x_scev_tbl(l_ptr)
            );
Line: 310

    End insert_row;
Line: 563

  PROCEDURE update_row(
    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_scev_rec                     IN scev_rec_type,
    x_scev_rec                     OUT NOCOPY scev_rec_type) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'update_row';
Line: 606

  OKS_SUBSCR_ELEMS_PVT.update_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_rec         => p_scev_rec,
                                x_scev_rec         => x_scev_rec);
Line: 676

    End update_row;
Line: 678

  PROCEDURE update_row(
    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_scev_tbl                     IN scev_tbl_type,
    x_scev_tbl                     OUT NOCOPY scev_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'update_row';
Line: 722

  OKS_SUBSCR_ELEMS_PVT.update_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_tbl         => p_scev_tbl,
                                x_scev_tbl         => x_scev_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 794

    End update_row;
Line: 796

  PROCEDURE update_row(
    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_scev_tbl                     IN scev_tbl_type,
    x_scev_tbl                     OUT NOCOPY scev_tbl_type) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'update_row';
Line: 818

            OKS_SUBSCR_ELEMS_PVT.update_row(
                                p_api_version     ,
                                p_init_msg_list   ,
                                x_return_status   ,
                                x_msg_count       ,
                                x_msg_data        ,
                                p_scev_tbl(l_ptr) ,
                                x_scev_tbl(l_ptr));
Line: 877

    End update_row;
Line: 879

  PROCEDURE delete_row(
    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_scev_rec                     IN scev_rec_type) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'delete_row';
Line: 921

  OKS_SUBSCR_ELEMS_PVT.delete_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_rec         => p_scev_rec);
Line: 989

    End delete_row;
Line: 991

  PROCEDURE delete_row(
    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_scev_tbl                     IN scev_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_name              CONSTANT VARCHAR2(30) := 'delete_row';
Line: 1034

  OKS_SUBSCR_ELEMS_PVT.delete_row(
                                p_api_version      => p_api_version,
                                p_init_msg_list    => p_init_msg_list,
                                x_return_status    => x_return_status,
                                x_msg_count        => x_msg_count,
                                x_msg_data         => x_msg_data,
                                p_scev_tbl         => p_scev_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 1104

    End delete_row;
Line: 1106

  PROCEDURE delete_row(
    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_scev_tbl                     IN scev_tbl_type) IS


    l_api_name              CONSTANT VARCHAR2(30) := 'delete_row';
Line: 1128

            OKS_SUBSCR_ELEMS_PVT.delete_row(
                                p_api_version     ,
                                p_init_msg_list   ,
                                x_return_status   ,
                                x_msg_count       ,
                                x_msg_data        ,
                                p_scev_tbl(l_ptr));
Line: 1186

    End delete_row;