DBA Data[Home] [Help]

APPS.OKL_ACCT_EVENT_PUB SQL Statements

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

Line: 418

  PROCEDURE update_acct_event(

    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_aetv_rec              IN  aetv_rec_type,

    p_aehv_tbl              IN  aehv_tbl_type,

	p_aelv_tbl				IN	aelv_tbl_type,

    x_aetv_rec              OUT NOCOPY aetv_rec_type,

    x_aehv_tbl              OUT NOCOPY aehv_tbl_type,

	x_aelv_tbl				OUT NOCOPY aelv_tbl_type) IS

    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 444

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_acct_event';
Line: 456

    SAVEPOINT update_acct_event;
Line: 478

    okl_acct_event_pvt.update_acct_event(

                         p_api_version   => p_api_version

                        ,p_init_msg_list => p_init_msg_list

                        ,x_return_status => l_return_status

                        ,x_msg_count     => x_msg_count

                        ,x_msg_data      => x_msg_data

                        ,p_aetv_rec      => l_aetv_rec

                        ,p_aehv_tbl      => l_aehv_tbl

                        ,p_aelv_tbl => l_aelv_tbl

                        ,x_aetv_rec      => x_aetv_rec

                        ,x_aehv_tbl      => x_aehv_tbl

						,x_aelv_tbl       => x_aelv_tbl

                        );
Line: 531

      ROLLBACK TO update_acct_event;
Line: 539

      ROLLBACK TO update_acct_event;
Line: 546

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
Line: 554

  END update_acct_event;
Line: 862

  PROCEDURE update_acct_event(

     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_aetv_rec                   IN  aetv_rec_type

    ,x_aetv_rec                   OUT NOCOPY aetv_rec_type) IS

    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 880

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_acct_event';
Line: 888

    SAVEPOINT update_acct_event;
Line: 909

    okl_acct_event_pvt.update_acct_event(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aetv_rec      => l_aetv_rec

                          ,x_aetv_rec      => x_aetv_rec

                          );
Line: 952

      ROLLBACK TO update_acct_event;
Line: 960

      ROLLBACK TO update_acct_event;
Line: 967

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
Line: 975

  END update_acct_event;
Line: 979

  PROCEDURE update_acct_event(

     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_aetv_tbl                   IN  aetv_tbl_type

    ,x_aetv_tbl                   OUT NOCOPY aetv_tbl_type) IS

    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 997

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_acct_event';
Line: 1008

    SAVEPOINT update_acct_event;
Line: 1032

        update_acct_event(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => x_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aetv_rec      => l_aetv_tbl(i)

                          ,x_aetv_rec      => x_aetv_tbl(i)

                          );
Line: 1090

      ROLLBACK TO update_acct_event;
Line: 1098

      ROLLBACK TO update_acct_event;
Line: 1105

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
Line: 1113

  END update_acct_event;
Line: 1119

  PROCEDURE delete_acct_event(

     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_aetv_rec              IN  aetv_rec_type) IS

    i                        NUMBER :=0;
Line: 1137

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_acct_event';
Line: 1147

    SAVEPOINT delete_acct_event;
Line: 1167

    okl_acct_event_pvt.delete_acct_event(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aetv_rec      => l_aetv_rec

                          );
Line: 1209

      ROLLBACK TO delete_acct_event;
Line: 1217

      ROLLBACK TO delete_acct_event;
Line: 1224

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
Line: 1232

  END delete_acct_event;
Line: 1236

  PROCEDURE delete_acct_event(

     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_aetv_tbl              IN  aetv_tbl_type) IS

    i                        NUMBER :=0;
Line: 1254

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_acct_event';
Line: 1263

     SAVEPOINT delete_acct_event;
Line: 1286

        delete_acct_event(

                             p_api_version   => p_api_version

                            ,p_init_msg_list => p_init_msg_list

                            ,x_return_status => x_return_status

                            ,x_msg_count     => x_msg_count

                            ,x_msg_data      => x_msg_data

                            ,p_aetv_rec      => l_aetv_tbl(i)

                            );
Line: 1342

      ROLLBACK TO delete_acct_event;
Line: 1350

      ROLLBACK TO delete_acct_event;
Line: 1357

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
Line: 1366

  END delete_acct_event;
Line: 2055

  PROCEDURE update_acct_header(

     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_aehv_rec                       IN  aehv_rec_type

    ,x_aehv_rec                       OUT NOCOPY aehv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 2073

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_header';
Line: 2079

    SAVEPOINT update_acct_header;
Line: 2100

    okl_acct_event_pvt.update_acct_header(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aehv_rec      => l_aehv_rec

                          ,x_aehv_rec      => x_aehv_rec

                          );
Line: 2144

      ROLLBACK TO update_acct_header;
Line: 2152

      ROLLBACK TO update_acct_header;
Line: 2159

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
Line: 2167

  END update_acct_header;
Line: 2171

  PROCEDURE update_acct_header(

     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_aehv_tbl                       IN  aehv_tbl_type

    ,x_aehv_tbl                       OUT NOCOPY aehv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 2189

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_header';
Line: 2202

     SAVEPOINT update_acct_header;
Line: 2225

        update_acct_header(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => x_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aehv_rec      => l_aehv_tbl(i)

                          ,x_aehv_rec      => x_aehv_tbl(i)

                          );
Line: 2284

      ROLLBACK TO update_acct_header;
Line: 2292

      ROLLBACK TO update_acct_header;
Line: 2299

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
Line: 2307

  END update_acct_header;
Line: 2313

  PROCEDURE delete_acct_header(

     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_aehv_rec                       IN  aehv_rec_type) IS

    i                                 NUMBER :=0;
Line: 2331

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_header';
Line: 2337

    SAVEPOINT delete_acct_header;
Line: 2360

    okl_acct_event_pvt.delete_acct_header(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aehv_rec      => l_aehv_rec);
Line: 2399

      ROLLBACK TO delete_acct_header;
Line: 2407

      ROLLBACK TO delete_acct_header;
Line: 2414

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
Line: 2422

  END delete_acct_header;
Line: 2426

  PROCEDURE delete_acct_header(

     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_aehv_tbl                       IN  aehv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 2446

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_header';
Line: 2456

     SAVEPOINT delete_acct_header;
Line: 2482

        delete_acct_header(

                                  p_api_version   => p_api_version

                                 ,p_init_msg_list => p_init_msg_list

                                 ,x_return_status => x_return_status

                                 ,x_msg_count     => x_msg_count

                                 ,x_msg_data      => x_msg_data

                                 ,p_aehv_rec      => l_aehv_tbl(i));
Line: 2536

      ROLLBACK TO delete_acct_header;
Line: 2544

      ROLLBACK TO delete_acct_header;
Line: 2551

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
Line: 2559

  END delete_acct_header;
Line: 3255

  PROCEDURE update_acct_lines(

     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_aelv_rec                       IN  aelv_rec_type

    ,x_aelv_rec                       OUT NOCOPY aelv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 3273

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_lines';
Line: 3279

    SAVEPOINT update_acct_lines;
Line: 3300

    okl_acct_event_pvt.update_acct_lines(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aelv_rec      => l_aelv_rec

                          ,x_aelv_rec      => x_aelv_rec

                          );
Line: 3344

      ROLLBACK TO update_acct_lines;
Line: 3352

      ROLLBACK TO update_acct_lines;
Line: 3359

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
Line: 3367

  END update_acct_lines;
Line: 3371

  PROCEDURE update_acct_lines(

     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_aelv_tbl                       IN  aelv_tbl_type

    ,x_aelv_tbl                       OUT NOCOPY aelv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 3389

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_lines';
Line: 3399

    SAVEPOINT update_acct_lines;
Line: 3424

        update_acct_lines(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => x_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aelv_rec      => l_aelv_tbl(i)

                          ,x_aelv_rec      => x_aelv_tbl(i)

                          );
Line: 3486

      ROLLBACK TO update_acct_lines;
Line: 3494

      ROLLBACK TO update_acct_lines;
Line: 3501

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
Line: 3509

  END update_acct_lines;
Line: 3515

  PROCEDURE delete_acct_lines(

     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_aelv_rec                       IN  aelv_rec_type) IS

    i                                 NUMBER :=0;
Line: 3533

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_lines';
Line: 3539

    SAVEPOINT delete_acct_lines;
Line: 3562

    okl_acct_event_pvt.delete_acct_lines(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_aelv_rec      => l_aelv_rec);
Line: 3601

      ROLLBACK TO delete_acct_lines;
Line: 3609

      ROLLBACK TO delete_acct_lines;
Line: 3616

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
Line: 3624

  END delete_acct_lines;
Line: 3628

  PROCEDURE delete_acct_lines(

     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_aelv_tbl                       IN  aelv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 3648

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_lines';
Line: 3657

     SAVEPOINT delete_acct_lines;
Line: 3683

        delete_acct_lines(

                                  p_api_version   => p_api_version

                                 ,p_init_msg_list => p_init_msg_list

                                 ,x_return_status => x_return_status

                                 ,x_msg_count     => x_msg_count

                                 ,x_msg_data      => x_msg_data

                                 ,p_aelv_rec      => l_aelv_tbl(i));
Line: 3740

      ROLLBACK TO delete_acct_lines;
Line: 3748

      ROLLBACK TO delete_acct_lines;
Line: 3755

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
Line: 3763

  END delete_acct_lines;