DBA Data[Home] [Help]

APPS.OKL_VERSION_FA_PUB SQL Statements

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

Line: 157

  PROCEDURE update_version_fa(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_vfav_rec      IN         vfav_rec_type,
                                 x_vfav_rec      OUT NOCOPY vfav_rec_type) IS

    l_vfav_rec                           vfav_rec_type;
Line: 167

    l_api_name                  CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_FA';
Line: 170

    savepoint update_version_fa_pub;
Line: 189

    OKL_VERSION_FA_PVT.update_version_fa(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_vfav_rec      => l_vfav_rec,
                                            x_vfav_rec      => x_vfav_rec);
Line: 208

		ROLLBACK  TO update_version_fa_pub;
Line: 213

		ROLLBACK  TO update_version_fa_pub;
Line: 218

		ROLLBACK  TO update_version_fa_pub;
Line: 220

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_version_fa_pub');
Line: 224

  END update_version_fa;
Line: 235

  PROCEDURE update_version_fa(
    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_vfav_tbl                     IN vfav_tbl_type,
    x_vfav_tbl                     OUT NOCOPY vfav_tbl_type) IS
    i                              NUMBER := 0;
Line: 250

        update_version_fa(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_vfav_rec      => p_vfav_tbl(i),
                             x_vfav_rec      => x_vfav_tbl(i));
Line: 275

    ROLLBACK  TO update_version_fa_pub;
Line: 280

    ROLLBACK  TO update_version_fa_pub;
Line: 285

    ROLLBACK  TO update_version_fa_pub;
Line: 287

    FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_version_fa_pub');
Line: 291

  END update_version_fa;
Line: 301

  PROCEDURE delete_version_fa(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_vfav_rec      IN         vfav_rec_type) IS

    l_vfav_rec                           vfav_rec_type;
Line: 310

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

    savepoint delete_version_fa_pub;
Line: 332

    OKL_VERSION_FA_PVT.delete_version_fa(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_vfav_rec      => l_vfav_rec);
Line: 349

		ROLLBACK  TO delete_version_fa_pub;
Line: 354

		ROLLBACK  TO delete_version_fa_pub;
Line: 359

		ROLLBACK  TO delete_version_fa_pub;
Line: 361

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_version_fa_pub');
Line: 365

  END delete_version_fa;
Line: 376

  PROCEDURE delete_version_fa(
    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_vfav_tbl                     IN vfav_tbl_type) IS
    i                              NUMBER := 0;
Line: 390

        delete_version_fa(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_vfav_rec      => p_vfav_tbl(i));
Line: 414

    ROLLBACK  TO delete_version_fa_pub;
Line: 419

    ROLLBACK  TO delete_version_fa_pub;
Line: 424

    ROLLBACK  TO delete_version_fa_pub;
Line: 426

    FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_version_fa_pub');
Line: 430

  END delete_version_fa;