DBA Data[Home] [Help]

APPS.OKL_SGN_TRANSLATIONS_PUB SQL Statements

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

Line: 11

  PROCEDURE insert_sgn_translations(
    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_sgnv_rec                     IN  sgnv_rec_type,
    x_sgnv_rec                     OUT NOCOPY sgnv_rec_type) IS

	l_sgnv_rec                        sgnv_rec_type;
Line: 22

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

    SAVEPOINT insert_sgn_translations;
Line: 32

    okl_sgt_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_sgnv_rec      => l_sgnv_rec
                          ,x_sgnv_rec      => x_sgnv_rec);
Line: 51

      ROLLBACK TO insert_sgn_translations;
Line: 59

      ROLLBACK TO insert_sgn_translations;
Line: 66

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
Line: 73

  END insert_sgn_translations;
Line: 75

  PROCEDURE insert_sgn_translations(
    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_sgnv_tbl                     IN  sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type) IS

    l_sgnv_tbl                        sgnv_tbl_type;
Line: 87

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_sgn_translations';
Line: 94

    SAVEPOINT insert_sgn_translations;
Line: 103

        insert_sgn_translations (
                           p_api_version   => p_api_version
                          ,p_init_msg_list => OKL_API.G_FALSE -- Bug Number: 3992148
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_sgnv_rec      => p_sgnv_tbl(i)
                          ,x_sgnv_rec      => x_sgnv_tbl(i)
                          );
Line: 141

      ROLLBACK TO insert_sgn_translations;
Line: 149

      ROLLBACK TO insert_sgn_translations;
Line: 156

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
Line: 163

  END insert_sgn_translations;
Line: 297

  PROCEDURE update_sgn_translations(
    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_sgnv_rec                     IN  sgnv_rec_type,
    x_sgnv_rec                     OUT NOCOPY sgnv_rec_type) IS

    l_sgnv_rec                        sgnv_rec_type;
Line: 309

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sgn_translations';
Line: 313

    SAVEPOINT update_sgn_translations;
Line: 318

    okl_sgt_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_sgnv_rec      => l_sgnv_rec
                          ,x_sgnv_rec      => x_sgnv_rec);
Line: 336

      ROLLBACK TO update_sgn_translations;
Line: 344

      ROLLBACK TO update_sgn_translations;
Line: 351

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
Line: 358

  END update_sgn_translations;
Line: 360

  PROCEDURE update_sgn_translations(
    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_sgnv_tbl                     IN  sgnv_tbl_type,
    x_sgnv_tbl                     OUT NOCOPY sgnv_tbl_type) IS

    l_sgnv_tbl                        sgnv_tbl_type;
Line: 372

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sgn_translations';
Line: 379

    SAVEPOINT update_sgn_translations;
Line: 388

        update_sgn_translations (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_sgnv_rec      => p_sgnv_tbl(i)
                                ,x_sgnv_rec      => x_sgnv_tbl(i));
Line: 424

      ROLLBACK TO update_sgn_translations;
Line: 432

      ROLLBACK TO update_sgn_translations;
Line: 439

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
Line: 446

  END update_sgn_translations;
Line: 448

  PROCEDURE delete_sgn_translations(
    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_sgnv_rec                     IN  sgnv_rec_type) IS

    l_sgnv_rec                        sgnv_rec_type;
Line: 459

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sgn_translations';
Line: 463

    SAVEPOINT delete_sgn_translations;
Line: 468

    okl_sgt_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_sgnv_rec      => l_sgnv_rec);
Line: 485

      ROLLBACK TO delete_sgn_translations;
Line: 493

      ROLLBACK TO delete_sgn_translations;
Line: 500

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
Line: 507

  END delete_sgn_translations;
Line: 509

  PROCEDURE delete_sgn_translations(
    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_sgnv_tbl                     IN  sgnv_tbl_type) IS

    l_sgnv_tbl                        sgnv_tbl_type;
Line: 520

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sgn_translations';
Line: 527

    SAVEPOINT delete_sgn_translations;
Line: 536

        delete_sgn_translations (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_sgnv_rec      => p_sgnv_tbl(i));
Line: 571

      ROLLBACK TO delete_sgn_translations;
Line: 579

      ROLLBACK TO delete_sgn_translations;
Line: 586

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
Line: 593

  END delete_sgn_translations;