DBA Data[Home] [Help]

APPS.OKS_REPORT_TEMPLATES_PUB SQL Statements

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

Line: 344

  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_rtmpv_rec                    IN rtmpv_rec_type,
    x_rtmpv_rec                    OUT NOCOPY rtmpv_rec_type
     ) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 355

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 383

    OKS_REPORT_TEMPLATES_PVT.insert_row(p_api_version        => l_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_rtmpv_rec           => p_rtmpv_rec,
                                      x_rtmpv_rec           => x_rtmpv_rec);
Line: 445

  END insert_row;
Line: 449

  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 460

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 489

    OKS_REPORT_TEMPLATES_PVT.insert_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl,
                                      x_rtmpv_tbl           => x_rtmpv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 551

  END insert_row;
Line: 556

  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type) IS


    l_api_version                  CONSTANT NUMBER := 1;
Line: 567

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 596

    OKS_REPORT_TEMPLATES_PVT.insert_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl,
                                      x_rtmpv_tbl           => x_rtmpv_tbl);
Line: 658

  END insert_row;
Line: 978

  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_rtmpv_rec                    IN rtmpv_rec_type,
    x_rtmpv_rec                    OUT NOCOPY rtmpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 988

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 1016

    OKS_REPORT_TEMPLATES_PVT.update_row(p_api_version        => l_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_rtmpv_rec           => p_rtmpv_rec,
                                      x_rtmpv_rec           =>  x_rtmpv_rec);
Line: 1079

  END update_row;
Line: 1083

  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1094

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 1123

    OKS_REPORT_TEMPLATES_PVT.update_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl,
                                      x_rtmpv_tbl           => x_rtmpv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 1186

  END update_row;
Line: 1191

  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_rtmpv_tbl                    IN rtmpv_tbl_type,
    x_rtmpv_tbl                    OUT NOCOPY rtmpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1201

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 1230

    OKS_REPORT_TEMPLATES_PVT.update_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl,
                                      x_rtmpv_tbl           => x_rtmpv_tbl);
Line: 1292

  END update_row;
Line: 1300

  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_rtmpv_rec                    IN rtmpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1309

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 1337

    OKS_REPORT_TEMPLATES_PVT.delete_row(p_api_version        => l_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_rtmpv_rec            => p_rtmpv_rec);
Line: 1398

  END delete_row;
Line: 1402

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

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1412

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 1441

    OKS_REPORT_TEMPLATES_PVT.delete_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 1503

  END delete_row;
Line: 1508

  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_rtmpv_tbl                    IN rtmpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1517

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 1546

    OKS_REPORT_TEMPLATES_PVT.delete_row(p_api_version        => l_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_rtmpv_tbl           => p_rtmpv_tbl);
Line: 1608

  END delete_row;