DBA Data[Home] [Help]

APPS.OKL_SIF_RET_STRMS_PUB SQL Statements

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

Line: 11

  PROCEDURE insert_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_rec                     IN  srsv_rec_type
                        ,x_srsv_rec                     OUT NOCOPY srsv_rec_type
                        ) IS
    l_srsv_rec                        srsv_rec_type;
Line: 22

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_sif_ret_strms';
Line: 27

    SAVEPOINT insert_sif_ret_strms;
Line: 32

    okl_srs_pvt.insert_row(
                               p_api_version   => p_api_version
                              ,p_init_msg_list => p_init_msg_list
                              ,x_return_status => l_return_status
                              ,x_msg_count     => x_msg_count
                              ,x_msg_data      => x_msg_data
                              ,p_srsv_rec      => l_srsv_rec
                              ,x_srsv_rec      => x_srsv_rec
                              );
Line: 53

      ROLLBACK TO insert_sif_ret_strms;
Line: 61

      ROLLBACK TO insert_sif_ret_strms;
Line: 68

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','insert_sif_ret_strms');
Line: 75

  END insert_sif_ret_strms;
Line: 78

  PROCEDURE insert_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_tbl                     IN  srsv_tbl_type
                        ,x_srsv_tbl                     OUT NOCOPY srsv_tbl_type
                        ) IS
    l_srsv_tbl                        srsv_tbl_type;
Line: 90

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_sif_ret_strms';
Line: 97

    SAVEPOINT insert_sif_ret_strms;
Line: 106

        insert_sif_ret_strms (
                           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_srsv_rec      => p_srsv_tbl(i)
                          ,x_srsv_rec      => x_srsv_tbl(i)
                          );
Line: 144

      ROLLBACK TO insert_sif_ret_strms;
Line: 152

      ROLLBACK TO insert_sif_ret_strms;
Line: 159

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','insert_sif_ret_strms');
Line: 166

  END insert_sif_ret_strms;
Line: 306

  PROCEDURE update_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_rec                     IN  srsv_rec_type
                        ,x_srsv_rec                     OUT NOCOPY srsv_rec_type
                        ) IS
    l_srsv_rec                        srsv_rec_type;
Line: 318

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sif_ret_strms';
Line: 322

    SAVEPOINT update_sif_ret_strms;
Line: 327

    okl_srs_pvt.update_row(
                               p_api_version   => p_api_version
                              ,p_init_msg_list => p_init_msg_list
                              ,x_return_status => l_return_status
                              ,x_msg_count     => x_msg_count
                              ,x_msg_data      => x_msg_data
                              ,p_srsv_rec      => l_srsv_rec
                              ,x_srsv_rec      => x_srsv_rec
                              );
Line: 347

      ROLLBACK TO update_sif_ret_strms;
Line: 355

      ROLLBACK TO update_sif_ret_strms;
Line: 362

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','update_sif_ret_strms');
Line: 369

  END update_sif_ret_strms;
Line: 372

  PROCEDURE update_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_tbl                     IN  srsv_tbl_type
                        ,x_srsv_tbl                     OUT NOCOPY srsv_tbl_type
                        ) IS
    l_srsv_tbl                        srsv_tbl_type;
Line: 384

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sif_ret_strms';
Line: 391

    SAVEPOINT update_sif_ret_strms;
Line: 400

        update_sif_ret_strms (
                           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_srsv_rec      => p_srsv_tbl(i)
                          ,x_srsv_rec      => x_srsv_tbl(i)
                          );
Line: 438

      ROLLBACK TO update_sif_ret_strms;
Line: 446

      ROLLBACK TO update_sif_ret_strms;
Line: 453

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','update_sif_ret_strms');
Line: 460

  END update_sif_ret_strms;
Line: 462

  PROCEDURE delete_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_rec                     IN  srsv_rec_type
                        ,x_srsv_rec                     OUT NOCOPY srsv_rec_type
                        ) IS
    l_srsv_rec                        srsv_rec_type;
Line: 474

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sif_ret_strms';
Line: 478

    SAVEPOINT delete_sif_ret_strms;
Line: 483

    okl_srs_pvt.delete_row(
                               p_api_version   => p_api_version
                              ,p_init_msg_list => p_init_msg_list
                              ,x_return_status => l_return_status
                              ,x_msg_count     => x_msg_count
                              ,x_msg_data      => x_msg_data
                              ,p_srsv_rec      => l_srsv_rec
                              );
Line: 502

      ROLLBACK TO delete_sif_ret_strms;
Line: 510

      ROLLBACK TO delete_sif_ret_strms;
Line: 517

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','delete_sif_ret_strms');
Line: 524

  END delete_sif_ret_strms;
Line: 527

  PROCEDURE delete_sif_ret_strms(
                         p_api_version                  IN  NUMBER
                        ,p_init_msg_list                IN  VARCHAR2
                        ,x_return_status                OUT NOCOPY VARCHAR2
                        ,x_msg_count                    OUT NOCOPY NUMBER
                        ,x_msg_data                     OUT NOCOPY VARCHAR2
                        ,p_srsv_tbl                     IN  srsv_tbl_type
                        ,x_srsv_tbl                     OUT NOCOPY srsv_tbl_type
                        ) IS
    l_srsv_tbl                        srsv_tbl_type;
Line: 539

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sif_ret_strms';
Line: 546

    SAVEPOINT delete_sif_ret_strms;
Line: 555

        delete_sif_ret_strms (
                           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_srsv_rec      => p_srsv_tbl(i)
                          ,x_srsv_rec      => x_srsv_tbl(i)
                          );
Line: 593

      ROLLBACK TO delete_sif_ret_strms;
Line: 601

      ROLLBACK TO delete_sif_ret_strms;
Line: 608

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','delete_sif_ret_strms');
Line: 615

  END delete_sif_ret_strms;
Line: 786

  PROCEDURE insert_sif_ret_strms_per(
                        p_api_version      IN  NUMBER,
                        p_init_msg_list    IN  VARCHAR2,
                        x_return_status    OUT NOCOPY VARCHAR2,
                        x_msg_count        OUT NOCOPY NUMBER,
                        x_msg_data         OUT NOCOPY VARCHAR2,
                        p_srsv_rec         IN  srsv_rec_type,
                        x_srsv_rec         OUT NOCOPY srsv_rec_type) IS
    l_srsv_rec               srsv_rec_type;
Line: 796

    l_api_name      CONSTANT VARCHAR2(30)  := 'INSERT_SIF_RET_STRMS_PER';
Line: 801

    SAVEPOINT insert_sif_ret_strms_per;
Line: 806

    okl_srs_pvt.insert_row_per(
                 p_api_version   => p_api_version,
                 p_init_msg_list => p_init_msg_list,
                 x_return_status => l_return_status,
                 x_msg_count     => x_msg_count,
                 x_msg_data      => x_msg_data,
                 p_srsv_rec      => l_srsv_rec,
                 x_srsv_rec      => x_srsv_rec);
Line: 823

      ROLLBACK TO insert_sif_ret_strms_per;
Line: 831

      ROLLBACK TO insert_sif_ret_strms_per;
Line: 839

                              'insert_sif_ret_strms_per');
Line: 846

  END insert_sif_ret_strms_per;
Line: 857

  PROCEDURE mass_insert_sif_ret(p_srsv_tbl   IN  srsv_tbl_type    ) IS
    l_srsv_tbl               srsv_tbl_type;
Line: 860

    l_api_name      CONSTANT VARCHAR2(30)  := 'MASS_INSERT_SIF_RET';
Line: 864

    SAVEPOINT mass_insert_sif_ret;
Line: 866

    okl_srs_pvt.insert_row_upg(p_srsv_tbl => l_srsv_tbl);
Line: 867

  END mass_insert_sif_ret;