DBA Data[Home] [Help]

APPS.OKL_TRX_AR_INVOICES_PUB SQL Statements

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

Line: 4

PROCEDURE insert_trx_ar_invoices(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_taiv_rec              IN  taiv_rec_type
    ,x_taiv_rec              OUT  NOCOPY taiv_rec_type) IS


l_api_version NUMBER ;
Line: 24

SAVEPOINT trx_ar_invoices_insert;
Line: 44

okl_tai_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_taiv_rec
                         ,lx_taiv_rec);
Line: 75

      ROLLBACK TO trx_ar_invoices_insert;
Line: 83

      ROLLBACK TO trx_ar_invoices_insert;
Line: 91

      ROLLBACK TO trx_ar_invoices_insert;
Line: 95

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','insert_trx_ar_invoices');
Line: 99

END insert_trx_ar_invoices;
Line: 101

PROCEDURE insert_trx_ar_invoices(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_taiv_tbl              IN  taiv_tbl_type
    ,x_taiv_tbl              OUT  NOCOPY taiv_tbl_type) IS

l_api_version NUMBER;
Line: 120

SAVEPOINT trx_ar_invoices_insert;
Line: 140

okl_tai_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_taiv_tbl
                         ,lx_taiv_tbl);
Line: 170

      ROLLBACK TO trx_ar_invoices_insert;
Line: 178

      ROLLBACK TO trx_ar_invoices_insert;
Line: 186

      ROLLBACK TO trx_ar_invoices_insert;
Line: 190

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','insert_trx_ar_invoices');
Line: 194

END insert_trx_ar_invoices;
Line: 280

PROCEDURE update_trx_ar_invoices(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_taiv_rec              IN  taiv_rec_type
    ,x_taiv_rec              OUT  NOCOPY taiv_rec_type) IS

l_api_version NUMBER ;
Line: 299

SAVEPOINT trx_ar_invoices_update;
Line: 314

    okl_tai_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_taiv_rec
                             ,lx_taiv_rec);
Line: 345

      ROLLBACK TO trx_ar_invoices_update;
Line: 353

      ROLLBACK TO trx_ar_invoices_update;
Line: 361

      ROLLBACK TO trx_ar_invoices_update;
Line: 365

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','update_trx_ar_invoices');
Line: 369

END update_trx_ar_invoices;
Line: 371

PROCEDURE update_trx_ar_invoices(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_taiv_tbl              IN  taiv_tbl_type
    ,x_taiv_tbl              OUT  NOCOPY taiv_tbl_type) IS

l_api_version NUMBER;
Line: 390

SAVEPOINT trx_ar_invoices_update;
Line: 404

    okl_tai_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_taiv_tbl
                             ,lx_taiv_tbl);
Line: 434

      ROLLBACK TO trx_ar_invoices_update;
Line: 442

      ROLLBACK TO trx_ar_invoices_update;
Line: 450

      ROLLBACK TO trx_ar_invoices_update;
Line: 454

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','update_trx_ar_invoices');
Line: 458

END update_trx_ar_invoices;
Line: 461

PROCEDURE delete_trx_ar_invoices(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_taiv_rec              IN taiv_rec_type) IS

i	                    NUMBER :=0;
Line: 480

SAVEPOINT trx_ar_invoices_delete_rec;
Line: 494

okl_tai_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_taiv_rec);
Line: 520

      ROLLBACK TO trx_ar_invoices_delete_rec;
Line: 528

      ROLLBACK TO trx_ar_invoices_delete_rec;
Line: 536

      ROLLBACK TO trx_ar_invoices_delete_rec;
Line: 540

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','delete_trx_ar_invoices');
Line: 544

END delete_trx_ar_invoices;
Line: 546

PROCEDURE delete_trx_ar_invoices(
     p_api_version        IN NUMBER
    ,p_init_msg_list      IN VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status      OUT NOCOPY VARCHAR2
    ,x_msg_count          OUT NOCOPY NUMBER
    ,x_msg_data           OUT NOCOPY VARCHAR2
    ,p_taiv_tbl           IN taiv_tbl_type) IS

i NUMBER := 0;
Line: 565

SAVEPOINT trx_ar_invoices_delete_tbl;
Line: 585

          delete_trx_ar_invoices(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_taiv_tbl(i));
Line: 617

      ROLLBACK TO trx_ar_invoices_delete_tbl;
Line: 625

      ROLLBACK TO trx_ar_invoices_delete_tbl;
Line: 633

      ROLLBACK TO trx_ar_invoices_delete_tbl;
Line: 637

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_INVOICES_PUB','delete_trx_ar_invoices');
Line: 641

END delete_trx_ar_invoices;