DBA Data[Home] [Help]

APPS.OKL_TXD_QTE_ANTCPT_BILL_PUB SQL Statements

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

Line: 31

    okl_qab_pvt.insert_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_rec       => lp_qabv_rec
                           ,x_qabv_rec       => lx_qabv_rec);
Line: 106

    okl_qab_pvt.insert_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_tbl       => lp_qabv_tbl
                           ,x_qabv_tbl       => lx_qabv_tbl);
Line: 154

 PROCEDURE update_txd_qte_ant_bill(
     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_qabv_rec                     IN  qabv_rec_type
    ,x_qabv_rec                     OUT  NOCOPY qabv_rec_type) IS

    l_api_version            NUMBER ;
Line: 172

    SAVEPOINT update_txd_qte_ant_bill;
Line: 181

    okl_qab_pvt.update_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_rec       => lp_qabv_rec
                           ,x_qabv_rec       => lx_qabv_rec);
Line: 203

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 211

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 219

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 223

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_ANTCPT_BILL_PUB','update_txd_qte_ant_bill');
Line: 227

  END update_txd_qte_ant_bill;
Line: 229

 PROCEDURE update_txd_qte_ant_bill(
     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_qabv_tbl                     IN  qabv_tbl_type
    ,x_qabv_tbl                     OUT  NOCOPY qabv_tbl_type) IS

    l_api_version            NUMBER ;
Line: 247

    SAVEPOINT update_txd_qte_ant_bill;
Line: 256

    okl_qab_pvt.update_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_tbl       => lp_qabv_tbl
                           ,x_qabv_tbl       => lx_qabv_tbl);
Line: 278

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 286

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 294

      ROLLBACK TO update_txd_qte_ant_bill;
Line: 298

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_ANTCPT_BILL_PUB','update_txd_qte_ant_bill');
Line: 302

  END update_txd_qte_ant_bill;
Line: 446

 PROCEDURE delete_txd_qte_ant_bill(
     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_qabv_rec                     IN  qabv_rec_type) IS

    l_api_version            NUMBER ;
Line: 463

    SAVEPOINT delete_txd_qte_ant_bill;
Line: 471

    okl_qab_pvt.delete_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_rec       => lp_qabv_rec);
Line: 491

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 499

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 507

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 511

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_ANTCPT_BILL_PUB','delete_txd_qte_ant_bill');
Line: 515

  END delete_txd_qte_ant_bill;
Line: 517

 PROCEDURE delete_txd_qte_ant_bill(
     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_qabv_tbl                     IN  qabv_tbl_type) IS

    l_api_version            NUMBER ;
Line: 534

    SAVEPOINT delete_txd_qte_ant_bill;
Line: 542

    okl_qab_pvt.delete_row( p_api_version    => l_api_version
                           ,p_init_msg_list  => l_init_msg_list
                           ,x_return_status  => l_return_status
                           ,x_msg_count      => l_msg_count
                           ,x_msg_data       => l_msg_data
                           ,p_qabv_tbl       => lp_qabv_tbl);
Line: 562

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 570

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 578

      ROLLBACK TO delete_txd_qte_ant_bill;
Line: 582

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_ANTCPT_BILL_PUB','delete_txd_qte_ant_bill');
Line: 586

  END delete_txd_qte_ant_bill;