DBA Data[Home] [Help]

APPS.OKS_SUBSCR_HDR_PUB SQL Statements

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

Line: 24

  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_schv_rec                     IN schv_rec_type,
    x_schv_rec                     OUT NOCOPY schv_rec_type) IS

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

  oks_subscr_hdr_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_schv_rec         => p_schv_rec,
                                x_schv_rec         => x_schv_rec);
Line: 136

    End insert_row;
Line: 138

  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_schv_tbl                     IN schv_tbl_type,
    x_schv_tbl                     OUT NOCOPY schv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

  oks_subscr_hdr_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_schv_tbl         => p_schv_tbl,
                                x_schv_tbl         => x_schv_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 251

    End insert_row;
Line: 253

  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_schv_tbl                     IN schv_tbl_type,
    x_schv_tbl                     OUT NOCOPY schv_tbl_type) IS

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

            insert_row
            (
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_schv_tbl(l_ptr)
                       ,x_schv_tbl(l_ptr)
            );
Line: 315

    End insert_row;
Line: 568

  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_schv_rec                     IN schv_rec_type,
    x_schv_rec                     OUT NOCOPY schv_rec_type) IS

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

  oks_subscr_hdr_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_schv_rec         => p_schv_rec,
                                x_schv_rec         => x_schv_rec);
Line: 681

    End update_row;
Line: 683

  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_schv_tbl                     IN schv_tbl_type,
    x_schv_tbl                     OUT NOCOPY schv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

  oks_subscr_hdr_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_schv_tbl         => p_schv_tbl,
                                x_schv_tbl         => x_schv_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 799

    End update_row;
Line: 801

  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_schv_tbl                     IN schv_tbl_type,
    x_schv_tbl                     OUT NOCOPY schv_tbl_type) IS

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

            oks_subscr_hdr_pvt.update_row(
                                p_api_version     ,
                                p_init_msg_list   ,
                                x_return_status   ,
                                x_msg_count       ,
                                x_msg_data        ,
                                p_schv_tbl(l_ptr) ,
                                x_schv_tbl(l_ptr));
Line: 882

    End update_row;
Line: 884

  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_schv_rec                     IN schv_rec_type) IS

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

  oks_subscr_hdr_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_schv_rec         => p_schv_rec);
Line: 994

    End delete_row;
Line: 996

  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_schv_tbl                     IN schv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

  oks_subscr_hdr_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_schv_tbl         => p_schv_tbl,
                                px_error_tbl       => px_error_tbl);
Line: 1109

    End delete_row;
Line: 1111

  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_schv_tbl                     IN schv_tbl_type) IS


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

            oks_subscr_hdr_pvt.delete_row(
                                p_api_version     ,
                                p_init_msg_list   ,
                                x_return_status   ,
                                x_msg_count       ,
                                x_msg_data        ,
                                p_schv_tbl(l_ptr));
Line: 1191

    End delete_row;