DBA Data[Home] [Help]

APPS.OKL_OPEN_INT_PUB SQL Statements

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

Line: 4

PROCEDURE insert_open_int(
     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_oinv_rec              IN  oinv_rec_type
    ,x_oinv_rec              OUT  NOCOPY oinv_rec_type) AS


l_api_version NUMBER ;
Line: 23

SAVEPOINT open_int_insert;
Line: 39

okl_oin_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_oinv_rec
                         ,lx_oinv_rec);
Line: 69

      ROLLBACK TO open_int_insert;
Line: 77

      ROLLBACK TO open_int_insert;
Line: 85

      ROLLBACK TO open_int_insert;
Line: 89

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
Line: 93

END insert_open_int;
Line: 95

PROCEDURE insert_open_int(
     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_oinv_tbl              IN  oinv_tbl_type
    ,x_oinv_tbl              OUT  NOCOPY oinv_tbl_type) AS

l_api_version NUMBER;
Line: 113

SAVEPOINT open_int_insert;
Line: 126

okl_oin_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_oinv_tbl
                         ,lx_oinv_tbl);
Line: 154

      ROLLBACK TO open_int_insert;
Line: 162

      ROLLBACK TO open_int_insert;
Line: 170

      ROLLBACK TO open_int_insert;
Line: 174

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
Line: 178

END insert_open_int;
Line: 261

PROCEDURE update_open_int(
     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_oinv_rec              IN  oinv_rec_type
    ,x_oinv_rec              OUT  NOCOPY oinv_rec_type) AS

l_api_version NUMBER ;
Line: 279

SAVEPOINT open_int_update;
Line: 294

    okl_oin_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_oinv_rec
                             ,lx_oinv_rec);
Line: 324

      ROLLBACK TO open_int_update;
Line: 332

      ROLLBACK TO open_int_update;
Line: 340

      ROLLBACK TO open_int_update;
Line: 344

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
Line: 348

END update_open_int;
Line: 350

PROCEDURE update_open_int(
     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_oinv_tbl              IN  oinv_tbl_type
    ,x_oinv_tbl              OUT  NOCOPY oinv_tbl_type) AS

l_api_version NUMBER;
Line: 368

SAVEPOINT open_int_update;
Line: 382

    okl_oin_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_oinv_tbl
                             ,lx_oinv_tbl);
Line: 411

      ROLLBACK TO open_int_update;
Line: 419

      ROLLBACK TO open_int_update;
Line: 427

      ROLLBACK TO open_int_update;
Line: 431

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
Line: 435

END update_open_int;
Line: 438

PROCEDURE delete_open_int(
     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_oinv_rec              IN oinv_rec_type) AS

i	                    NUMBER :=0;
Line: 456

SAVEPOINT open_int_delete_rec;
Line: 470

okl_oin_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_oinv_rec);
Line: 495

      ROLLBACK TO open_int_delete_rec;
Line: 503

      ROLLBACK TO open_int_delete_rec;
Line: 511

      ROLLBACK TO open_int_delete_rec;
Line: 515

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
Line: 519

END delete_open_int;
Line: 521

PROCEDURE delete_open_int(
     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_oinv_tbl           IN oinv_tbl_type) AS

i NUMBER := 0;
Line: 539

SAVEPOINT open_int_delete_tbl;
Line: 559

          delete_open_int(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_oinv_tbl(i));
Line: 590

      ROLLBACK TO open_int_delete_tbl;
Line: 598

      ROLLBACK TO open_int_delete_tbl;
Line: 606

      ROLLBACK TO open_int_delete_tbl;
Line: 610

      FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
Line: 614

END delete_open_int;