DBA Data[Home] [Help]

APPS.OKL_PRD_PRICE_TMPLS_PUB SQL Statements

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

Line: 11

  PROCEDURE insert_prd_price_tmpls(
                         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_pitv_rec                     IN  pitv_rec_type
                        ,x_pitv_rec                     OUT NOCOPY pitv_rec_type
                        ) IS
    l_pitv_rec                        pitv_rec_type;
Line: 22

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_prd_price_tmpls';
Line: 27

    SAVEPOINT insert_prd_price_tmpls;
Line: 32

    okl_pit_pvt.insert_row(
                               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_pitv_rec      => l_pitv_rec
                              ,x_pitv_rec      => x_pitv_rec
                              );
Line: 56

      ROLLBACK TO insert_prd_price_tmpls;
Line: 64

      ROLLBACK TO insert_prd_price_tmpls;
Line: 71

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','insert_prd_price_tmpls');
Line: 78

  END insert_prd_price_tmpls;
Line: 81

  PROCEDURE insert_prd_price_tmpls(
                         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_pitv_tbl                     IN  pitv_tbl_type
                        ,x_pitv_tbl                     OUT NOCOPY pitv_tbl_type
                        ) IS
    l_pitv_tbl                        pitv_tbl_type;
Line: 93

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_prd_price_tmpls';
Line: 100

    SAVEPOINT insert_prd_price_tmpls;
Line: 109

        insert_prd_price_tmpls (
                           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_pitv_rec      => p_pitv_tbl(i)
                          ,x_pitv_rec      => x_pitv_tbl(i)
                          );
Line: 150

      ROLLBACK TO insert_prd_price_tmpls;
Line: 158

      ROLLBACK TO insert_prd_price_tmpls;
Line: 165

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','insert_prd_price_tmpls');
Line: 172

  END insert_prd_price_tmpls;
Line: 312

  PROCEDURE update_prd_price_tmpls(
                         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_pitv_rec                     IN  pitv_rec_type
                        ,x_pitv_rec                     OUT NOCOPY pitv_rec_type
                        ) IS
    l_pitv_rec                        pitv_rec_type;
Line: 324

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_prd_price_tmpls';
Line: 328

    SAVEPOINT update_prd_price_tmpls;
Line: 333

    okl_pit_pvt.update_row(
                               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_pitv_rec      => l_pitv_rec
                              ,x_pitv_rec      => x_pitv_rec
                              );
Line: 356

      ROLLBACK TO update_prd_price_tmpls;
Line: 364

      ROLLBACK TO update_prd_price_tmpls;
Line: 371

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','update_prd_price_tmpls');
Line: 378

  END update_prd_price_tmpls;
Line: 381

  PROCEDURE update_prd_price_tmpls(
                         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_pitv_tbl                     IN  pitv_tbl_type
                        ,x_pitv_tbl                     OUT NOCOPY pitv_tbl_type
                        ) IS
    l_pitv_tbl                        pitv_tbl_type;
Line: 393

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_prd_price_tmpls';
Line: 400

    SAVEPOINT update_prd_price_tmpls;
Line: 409

        update_prd_price_tmpls (
                           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_pitv_rec      => p_pitv_tbl(i)
                          ,x_pitv_rec      => x_pitv_tbl(i)
                          );
Line: 450

      ROLLBACK TO update_prd_price_tmpls;
Line: 458

      ROLLBACK TO update_prd_price_tmpls;
Line: 465

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','update_prd_price_tmpls');
Line: 472

  END update_prd_price_tmpls;
Line: 474

  PROCEDURE delete_prd_price_tmpls(
                         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_pitv_rec                     IN  pitv_rec_type
                        ) IS
    l_pitv_rec                        pitv_rec_type;
Line: 485

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_prd_price_tmpls';
Line: 489

    SAVEPOINT delete_prd_price_tmpls;
Line: 494

    okl_pit_pvt.delete_row(
                               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_pitv_rec      => l_pitv_rec
                              );
Line: 513

      ROLLBACK TO delete_prd_price_tmpls;
Line: 521

      ROLLBACK TO delete_prd_price_tmpls;
Line: 528

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','delete_prd_price_tmpls');
Line: 535

  END delete_prd_price_tmpls;
Line: 538

  PROCEDURE delete_prd_price_tmpls(
                         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_pitv_tbl                     IN  pitv_tbl_type
                        ) IS
    l_pitv_tbl                        pitv_tbl_type;
Line: 549

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_prd_price_tmpls';
Line: 556

    SAVEPOINT delete_prd_price_tmpls;
Line: 565

        delete_prd_price_tmpls (
                           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_pitv_rec      => p_pitv_tbl(i)
                          );
Line: 602

      ROLLBACK TO delete_prd_price_tmpls;
Line: 610

      ROLLBACK TO delete_prd_price_tmpls;
Line: 617

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PRD_PRICE_TMPLS_PUB','delete_prd_price_tmpls');
Line: 624

  END delete_prd_price_tmpls;