DBA Data[Home] [Help]

APPS.OKL_REMARKETING_COSTS_PUB SQL Statements

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

Line: 5

PROCEDURE insert_remarketing_costs(
     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_rfcv_rec                     IN   rfcv_rec_type
    ,x_rfcv_rec                     OUT  NOCOPY rfcv_rec_type) IS


l_api_version NUMBER ;
Line: 28

SAVEPOINT remarketing_costs_insert;
Line: 55

okl_rfc_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_rfcv_rec
                         ,lx_rfcv_rec);
Line: 82

      ROLLBACK TO remarketing_costs_insert;
Line: 90

      ROLLBACK TO remarketing_costs_insert;
Line: 98

      ROLLBACK TO remarketing_costs_insert;
Line: 102

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
Line: 106

END insert_remarketing_costs;
Line: 108

PROCEDURE insert_remarketing_costs(
     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_rfcv_tbl                     IN   rfcv_tbl_type
    ,x_rfcv_tbl                     OUT  NOCOPY rfcv_tbl_type) IS

l_api_version NUMBER;
Line: 128

SAVEPOINT remarketing_costs_insert;
Line: 152

 okl_rfc_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_rfcv_tbl
                         ,lx_rfcv_tbl);
Line: 180

      ROLLBACK TO remarketing_costs_insert;
Line: 188

      ROLLBACK TO remarketing_costs_insert;
Line: 196

      ROLLBACK TO remarketing_costs_insert;
Line: 200

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
Line: 204

END insert_remarketing_costs;
Line: 290

PROCEDURE update_remarketing_costs(
     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_rfcv_rec                     IN   rfcv_rec_type
    ,x_rfcv_rec                     OUT  NOCOPY rfcv_rec_type) IS

l_api_version NUMBER ;
Line: 309

SAVEPOINT remarketing_costs_update;
Line: 331

    okl_rfc_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_rfcv_rec
                             ,lx_rfcv_rec);
Line: 362

      ROLLBACK TO remarketing_costs_update;
Line: 370

      ROLLBACK TO remarketing_costs_update;
Line: 378

      ROLLBACK TO remarketing_costs_update;
Line: 382

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
Line: 386

END update_remarketing_costs;
Line: 388

PROCEDURE update_remarketing_costs(
     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_rfcv_tbl                     IN   rfcv_tbl_type
    ,x_rfcv_tbl                     OUT  NOCOPY rfcv_tbl_type) IS

l_api_version NUMBER;
Line: 407

SAVEPOINT remarketing_costs_update;
Line: 430

    okl_rfc_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_rfcv_tbl
                             ,lx_rfcv_tbl);
Line: 460

      ROLLBACK TO remarketing_costs_update;
Line: 468

      ROLLBACK TO remarketing_costs_update;
Line: 476

      ROLLBACK TO remarketing_costs_update;
Line: 480

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
Line: 484

END update_remarketing_costs;
Line: 487

PROCEDURE delete_remarketing_costs(
     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_rfcv_rec                     IN   rfcv_rec_type) IS

i	                    NUMBER :=0;
Line: 506

SAVEPOINT remarketing_costs_delete_rec;
Line: 520

okl_rfc_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_rfcv_rec);
Line: 546

      ROLLBACK TO remarketing_costs_delete_rec;
Line: 554

      ROLLBACK TO remarketing_costs_delete_rec;
Line: 562

      ROLLBACK TO remarketing_costs_delete_rec;
Line: 566

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
Line: 570

END delete_remarketing_costs;
Line: 572

PROCEDURE delete_remarketing_costs(
     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_rfcv_tbl                     IN   rfcv_tbl_type) IS

i NUMBER := 0;
Line: 591

SAVEPOINT remarketing_costs_delete_tbl;
Line: 611

          delete_remarketing_costs(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_rfcv_tbl(i));
Line: 643

      ROLLBACK TO remarketing_costs_delete_tbl;
Line: 651

      ROLLBACK TO remarketing_costs_delete_tbl;
Line: 659

      ROLLBACK TO remarketing_costs_delete_tbl;
Line: 663

      FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
Line: 667

END delete_remarketing_costs;