DBA Data[Home] [Help]

APPS.OKL_PDT_STYS_PUB SQL Statements

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

Line: 10

  PROCEDURE insert_pdt_stys(
                         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_psyv_rec                     IN  psyv_rec_type
                        ,x_psyv_rec                     OUT NOCOPY psyv_rec_type
                        ) IS
    l_psyv_rec                        psyv_rec_type;
Line: 21

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_pdt_stys';
Line: 26

    SAVEPOINT insert_pdt_stys;
Line: 31

    okl_psy_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_psyv_rec      => l_psyv_rec
                              ,x_psyv_rec      => x_psyv_rec
                              );
Line: 55

      ROLLBACK TO insert_pdt_stys;
Line: 63

      ROLLBACK TO insert_pdt_stys;
Line: 70

      FND_MSG_PUB.ADD_EXC_MSG('OKL_pdt_stys_PUB','insert_pdt_stys');
Line: 77

  END insert_pdt_stys;
Line: 80

  PROCEDURE insert_pdt_stys(
                         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_psyv_tbl                     IN  psyv_tbl_type
                        ,x_psyv_tbl                     OUT NOCOPY psyv_tbl_type
                        ) IS
    l_psyv_tbl                        psyv_tbl_type;
Line: 92

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_pdt_stys';
Line: 99

    SAVEPOINT insert_pdt_stys;
Line: 108

        insert_pdt_stys (
                           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_psyv_rec      => p_psyv_tbl(i)
                          ,x_psyv_rec      => x_psyv_tbl(i)
                          );
Line: 149

      ROLLBACK TO insert_pdt_stys;
Line: 157

      ROLLBACK TO insert_pdt_stys;
Line: 164

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','insert_pdt_stys');
Line: 171

  END insert_pdt_stys;
Line: 311

  PROCEDURE update_pdt_stys(
                         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_psyv_rec                     IN  psyv_rec_type
                        ,x_psyv_rec                     OUT NOCOPY psyv_rec_type
                        ) IS
    l_psyv_rec                        psyv_rec_type;
Line: 323

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pdt_stys';
Line: 327

    SAVEPOINT update_pdt_stys;
Line: 332

    okl_psy_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_psyv_rec      => l_psyv_rec
                              ,x_psyv_rec      => x_psyv_rec
                              );
Line: 355

      ROLLBACK TO update_pdt_stys;
Line: 363

      ROLLBACK TO update_pdt_stys;
Line: 370

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
Line: 377

  END update_pdt_stys;
Line: 380

  PROCEDURE update_pdt_stys(
                         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_psyv_tbl                     IN  psyv_tbl_type
                        ,x_psyv_tbl                     OUT NOCOPY psyv_tbl_type
                        ) IS
    l_psyv_tbl                        psyv_tbl_type;
Line: 392

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pdt_stys';
Line: 399

    SAVEPOINT update_pdt_stys;
Line: 408

        update_pdt_stys (
                           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_psyv_rec      => p_psyv_tbl(i)
                          ,x_psyv_rec      => x_psyv_tbl(i)
                          );
Line: 449

      ROLLBACK TO update_pdt_stys;
Line: 457

      ROLLBACK TO update_pdt_stys;
Line: 464

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
Line: 471

  END update_pdt_stys;
Line: 473

  PROCEDURE delete_pdt_stys(
                         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_psyv_rec                     IN  psyv_rec_type
                        ) IS
    l_psyv_rec                        psyv_rec_type;
Line: 484

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_pdt_stys';
Line: 488

    SAVEPOINT delete_pdt_stys;
Line: 493

    okl_psy_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_psyv_rec      => l_psyv_rec
                              );
Line: 512

      ROLLBACK TO delete_pdt_stys;
Line: 520

      ROLLBACK TO delete_pdt_stys;
Line: 527

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
Line: 534

  END delete_pdt_stys;
Line: 537

  PROCEDURE delete_pdt_stys(
                         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_psyv_tbl                     IN  psyv_tbl_type
                        ) IS
    l_psyv_tbl                        psyv_tbl_type;
Line: 548

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_pdt_stys';
Line: 555

    SAVEPOINT delete_pdt_stys;
Line: 564

        delete_pdt_stys (
                           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_psyv_rec      => p_psyv_tbl(i)
                          );
Line: 601

      ROLLBACK TO delete_pdt_stys;
Line: 609

      ROLLBACK TO delete_pdt_stys;
Line: 616

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
Line: 623

  END delete_pdt_stys;