DBA Data[Home] [Help]

APPS.OKL_TXD_QTE_LN_DTLS_PUB SQL Statements

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

Line: 30

    okl_tqd_pvt.insert_row(l_api_version
                           ,l_init_msg_list
                           ,l_return_status
                           ,l_msg_count
                           ,l_msg_data
                           ,lp_tqdv_rec
                           ,lx_tqdv_rec);
Line: 100

    okl_tqd_pvt.insert_row(l_api_version
                           ,l_init_msg_list
                           ,l_return_status
                           ,l_msg_count
                           ,l_msg_data
                           ,lp_tqdv_tbl
                           ,lx_tqdv_tbl);
Line: 276

  PROCEDURE update_txd_qte_ln_dtls(
            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_tqdv_rec       IN  tqdv_rec_type
            ,x_tqdv_rec       OUT NOCOPY tqdv_rec_type) IS

    l_api_version             NUMBER;
Line: 293

    SAVEPOINT update_txd_qte_ln_dtls;
Line: 302

    okl_tqd_pvt.update_row(l_api_version
                           ,l_init_msg_list
                           ,l_return_status
                           ,l_msg_count
                           ,l_msg_data
                           ,lp_tqdv_rec
                           ,lx_tqdv_rec);
Line: 321

      ROLLBACK TO update_txd_qte_ln_dtls;
Line: 329

      ROLLBACK TO update_txd_qte_ln_dtls;
Line: 337

      ROLLBACK TO update_txd_qte_ln_dtls;
Line: 341

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls');
Line: 345

  END update_txd_qte_ln_dtls;
Line: 347

  PROCEDURE update_txd_qte_ln_dtls(
            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_tqdv_tbl       IN  tqdv_tbl_type
            ,x_tqdv_tbl       OUT NOCOPY tqdv_tbl_type) IS

    l_api_version             NUMBER;
Line: 364

    SAVEPOINT update_txd_qte_ln_dtls_tbl;
Line: 372

    okl_tqd_pvt.update_row(l_api_version
                           ,l_init_msg_list
                           ,l_return_status
                           ,l_msg_count
                           ,l_msg_data
                           ,lp_tqdv_tbl
                           ,lx_tqdv_tbl);
Line: 391

      ROLLBACK TO update_txd_qte_ln_dtls_tbl;
Line: 399

      ROLLBACK TO update_txd_qte_ln_dtls_tbl;
Line: 407

      ROLLBACK TO update_txd_qte_ln_dtls_tbl;
Line: 411

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls_tbl');
Line: 415

  END update_txd_qte_ln_dtls;
Line: 417

  PROCEDURE delete_txd_qte_ln_dtls(
            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_tqdv_rec       IN  tqdv_rec_type) IS

    l_return_status 	    VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
Line: 432

    SAVEPOINT delete_txd_qte_ln_dtls;
Line: 440

    okl_tqd_pvt.delete_row(l_api_version
                           ,l_init_msg_list
                           ,l_return_status
                           ,l_msg_count
                           ,l_msg_data
                           ,lp_tqdv_rec);
Line: 457

      ROLLBACK TO delete_txd_qte_ln_dtls;
Line: 465

      ROLLBACK TO delete_txd_qte_ln_dtls;
Line: 473

      ROLLBACK TO delete_txd_qte_ln_dtls;
Line: 477

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls');
Line: 481

  END delete_txd_qte_ln_dtls;
Line: 483

  PROCEDURE delete_txd_qte_ln_dtls(
            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_tqdv_tbl       IN   tqdv_tbl_type) IS
    l_api_version            NUMBER ;
Line: 497

    SAVEPOINT delete_txd_qte_ln_dtls_tbl;
Line: 504

    okl_tqd_pvt.delete_row(
		    l_api_version,
		    l_init_msg_list,
		    l_return_status,
		    l_msg_count,
		    l_msg_data,
		    lp_tqdv_tbl);
Line: 522

      ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
Line: 530

      ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
Line: 538

      ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
Line: 542

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls_tbl');
Line: 546

  END delete_txd_qte_ln_dtls;