DBA Data[Home] [Help]

APPS.OKL_TRANS_CONTRACTS_PUB SQL Statements

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

Line: 340

  PROCEDURE update_trx_contracts(
    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_tcnv_rec              IN  tcnv_rec_type,
    p_tclv_tbl              IN  tclv_tbl_type,
    x_tcnv_rec              OUT NOCOPY tcnv_rec_type,
    x_tclv_tbl              OUT NOCOPY tclv_tbl_type) IS

    l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Line: 352

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_trx_contracts';
Line: 360

    SAVEPOINT update_trx_contracts;
Line: 383

    OKL_TRANS_CONTRACTS_pvt.update_trx_contracts(
                         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_tcnv_rec      => l_tcnv_rec
                        ,p_tclv_tbl      => l_tclv_tbl
                        ,x_tcnv_rec      => x_tcnv_rec
                        ,x_tclv_tbl      => x_tclv_tbl
                        );
Line: 421

      ROLLBACK TO update_trx_contracts;
Line: 429

      ROLLBACK TO update_trx_contracts;
Line: 436

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','update_trx_contracts');
Line: 444

  END update_trx_contracts;
Line: 449

  PROCEDURE update_trx_contracts(
     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_tcnv_rec                   IN  tcnv_rec_type
    ,x_tcnv_rec                   OUT NOCOPY tcnv_rec_type) IS

    l_return_status               VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 460

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_trx_contracts';
Line: 466

    SAVEPOINT update_trx_contracts;
Line: 487

    OKL_TRANS_CONTRACTS_pvt.update_trx_contracts(
                           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_tcnv_rec      => l_tcnv_rec
                          ,x_tcnv_rec      => x_tcnv_rec

                          );
Line: 523

      ROLLBACK TO update_trx_contracts;
Line: 531

      ROLLBACK TO update_trx_contracts;
Line: 538

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','update_trx_contracts');
Line: 546

  END update_trx_contracts;
Line: 550

  PROCEDURE update_trx_contracts(
     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_tcnv_tbl                   IN  tcnv_tbl_type
    ,x_tcnv_tbl                   OUT NOCOPY tcnv_tbl_type) IS


   l_return_status               VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 562

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_trx_contracts';
Line: 575

	SAVEPOINT update_trx_contracts;
Line: 597

        update_trx_contracts(

                           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_tcnv_rec      => l_tcnv_tbl(i)

                          ,x_tcnv_rec      => x_tcnv_tbl(i)

                          );
Line: 657

      ROLLBACK TO update_trx_contracts;
Line: 665

      ROLLBACK TO update_trx_contracts;
Line: 672

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','update_trx_contracts');
Line: 682

  END update_trx_contracts;
Line: 688

  PROCEDURE delete_trx_contracts(

     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_tcnv_rec              IN  tcnv_rec_type) IS

    i                        NUMBER :=0;
Line: 706

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_trx_contracts';
Line: 714

    SAVEPOINT delete_trx_contracts;
Line: 735

    OKL_TRANS_CONTRACTS_pvt.delete_trx_contracts(

                           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_tcnv_rec      => l_tcnv_rec

                          );
Line: 778

      ROLLBACK TO delete_trx_contracts;
Line: 786

      ROLLBACK TO delete_trx_contracts;
Line: 793

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','delete_trx_contracts');
Line: 801

  END delete_trx_contracts;
Line: 805

  PROCEDURE delete_trx_contracts(

     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_tcnv_tbl              IN  tcnv_tbl_type) IS

    i                        NUMBER :=0;
Line: 823

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_trx_contracts';
Line: 834

	SAVEPOINT delete_trx_contracts;
Line: 856

        delete_trx_contracts(

                             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_tcnv_rec      => l_tcnv_tbl(i)

                            );
Line: 914

      ROLLBACK TO delete_trx_contracts;
Line: 922

      ROLLBACK TO delete_trx_contracts;
Line: 929

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','delete_trx_contracts');
Line: 939

  END delete_trx_contracts;
Line: 1207

  PROCEDURE update_trx_cntrct_lines(

     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_tclv_rec                       IN  tclv_rec_type

    ,x_tclv_rec                       OUT NOCOPY tclv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1225

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_trx_cntrct_lines';
Line: 1231

    SAVEPOINT update_trx_cntrct_lines;
Line: 1252

    OKL_TRANS_CONTRACTS_pvt.update_trx_cntrct_lines(

                           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_tclv_rec      => l_tclv_rec

                          ,x_tclv_rec      => x_tclv_rec

                          );
Line: 1295

      ROLLBACK TO update_trx_cntrct_lines;
Line: 1303

      ROLLBACK TO update_trx_cntrct_lines;
Line: 1310

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','update_trx_cntrct_lines');
Line: 1318

  END update_trx_cntrct_lines;
Line: 1322

  PROCEDURE update_trx_cntrct_lines(

     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_tclv_tbl                       IN  tclv_tbl_type

    ,x_tclv_tbl                       OUT NOCOPY tclv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1340

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_trx_cntrct_lines';
Line: 1351

    SAVEPOINT update_trx_cntrct_lines;
Line: 1376

        update_trx_cntrct_lines(

                           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_tclv_rec      => l_tclv_tbl(i)

                          ,x_tclv_rec      => x_tclv_tbl(i)

                          );
Line: 1435

      ROLLBACK TO update_trx_cntrct_lines;
Line: 1443

      ROLLBACK TO update_trx_cntrct_lines;
Line: 1450

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','update_trx_cntrct_lines');
Line: 1460

  END update_trx_cntrct_lines;
Line: 1466

  PROCEDURE delete_trx_cntrct_lines(

     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_tclv_rec                       IN  tclv_rec_type) IS

    i                                 NUMBER :=0;
Line: 1484

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_trx_cntrct_lines';
Line: 1490

    SAVEPOINT delete_trx_cntrct_lines;
Line: 1513

    OKL_TRANS_CONTRACTS_pvt.delete_trx_cntrct_lines(

                           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_tclv_rec      => l_tclv_rec);
Line: 1552

      ROLLBACK TO delete_trx_cntrct_lines;
Line: 1560

      ROLLBACK TO delete_trx_cntrct_lines;
Line: 1567

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','delete_trx_cntrct_lines');
Line: 1575

  END delete_trx_cntrct_lines;
Line: 1579

  PROCEDURE delete_trx_cntrct_lines(

     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_tclv_tbl                       IN  tclv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 1599

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_trx_cntrct_lines';
Line: 1608

    SAVEPOINT delete_trx_cntrct_lines;
Line: 1633

        delete_trx_cntrct_lines(

                                  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_tclv_rec      => l_tclv_tbl(i));
Line: 1688

      ROLLBACK TO delete_trx_cntrct_lines;
Line: 1696

      ROLLBACK TO delete_trx_cntrct_lines;
Line: 1703

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_CONTRACTS_PUB','delete_trx_cntrct_lines');
Line: 1711

  END delete_trx_cntrct_lines;