DBA Data[Home] [Help]

APPS.OKL_SIF_TRX_PARMS_PUB SQL Statements

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

Line: 11

  PROCEDURE insert_sif_trx_parms(
                         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_sxpv_rec                     IN  sxpv_rec_type
                        ,x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS
    l_sxpv_rec                        sxpv_rec_type;
Line: 22

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

    SAVEPOINT insert_sif_trx_parms;
Line: 32

    okl_sxp_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_sxpv_rec      => l_sxpv_rec
                              ,x_sxpv_rec      => x_sxpv_rec
                              );
Line: 53

      ROLLBACK TO insert_sif_trx_parms;
Line: 61

      ROLLBACK TO insert_sif_trx_parms;
Line: 68

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
Line: 75

  END insert_sif_trx_parms;
Line: 78

  PROCEDURE insert_sif_trx_parms(
                         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_sxpv_tbl                     IN  sxpv_tbl_type
                        ,x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type
                        ) IS
    l_sxpv_tbl                        sxpv_tbl_type;
Line: 90

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

    SAVEPOINT insert_sif_trx_parms;
Line: 106

        insert_sif_trx_parms (
                           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_sxpv_rec      => p_sxpv_tbl(i)
                          ,x_sxpv_rec      => x_sxpv_tbl(i)
                          );
Line: 144

      ROLLBACK TO insert_sif_trx_parms;
Line: 152

      ROLLBACK TO insert_sif_trx_parms;
Line: 159

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
Line: 166

  END insert_sif_trx_parms;
Line: 306

  PROCEDURE update_sif_trx_parms(
                         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_sxpv_rec                     IN  sxpv_rec_type
                        ,x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS
    l_sxpv_rec                        sxpv_rec_type;
Line: 318

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

    SAVEPOINT update_sif_trx_parms;
Line: 328

    okl_sxp_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_sxpv_rec      => l_sxpv_rec
                              ,x_sxpv_rec      => x_sxpv_rec
                              );
Line: 348

      ROLLBACK TO update_sif_trx_parms;
Line: 356

      ROLLBACK TO update_sif_trx_parms;
Line: 363

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
Line: 370

  END update_sif_trx_parms;
Line: 373

  PROCEDURE update_sif_trx_parms(
                         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_sxpv_tbl                     IN  sxpv_tbl_type
                        ,x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type
                        ) IS
    l_sxpv_tbl                        sxpv_tbl_type;
Line: 385

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sif_trx_parms';
Line: 392

    SAVEPOINT update_sif_trx_parms;
Line: 401

        update_sif_trx_parms (
                           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_sxpv_rec      => p_sxpv_tbl(i)
                          ,x_sxpv_rec      => x_sxpv_tbl(i)
                          );
Line: 439

      ROLLBACK TO update_sif_trx_parms;
Line: 447

      ROLLBACK TO update_sif_trx_parms;
Line: 454

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
Line: 461

  END update_sif_trx_parms;
Line: 463

  PROCEDURE delete_sif_trx_parms(
                         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_sxpv_rec                     IN  sxpv_rec_type
                        ,x_sxpv_rec                     OUT NOCOPY sxpv_rec_type
                        ) IS
    l_sxpv_rec                        sxpv_rec_type;
Line: 475

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sif_trx_parms';
Line: 479

    SAVEPOINT delete_sif_trx_parms;
Line: 484

    okl_sxp_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_sxpv_rec      => l_sxpv_rec
                              );
Line: 503

      ROLLBACK TO delete_sif_trx_parms;
Line: 511

      ROLLBACK TO delete_sif_trx_parms;
Line: 518

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
Line: 525

  END delete_sif_trx_parms;
Line: 528

  PROCEDURE delete_sif_trx_parms(
                         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_sxpv_tbl                     IN  sxpv_tbl_type
                        ,x_sxpv_tbl                     OUT NOCOPY sxpv_tbl_type
                        ) IS
    l_sxpv_tbl                        sxpv_tbl_type;
Line: 540

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sif_trx_parms';
Line: 547

    SAVEPOINT delete_sif_trx_parms;
Line: 556

        delete_sif_trx_parms (
                           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_sxpv_rec      => p_sxpv_tbl(i)
                          ,x_sxpv_rec      => x_sxpv_tbl(i)
                          );
Line: 594

      ROLLBACK TO delete_sif_trx_parms;
Line: 602

      ROLLBACK TO delete_sif_trx_parms;
Line: 609

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
Line: 616

  END delete_sif_trx_parms;