DBA Data[Home] [Help]

APPS.OKL_TXD_ASSETS_PUB SQL Statements

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

Line: 155

  PROCEDURE update_txd_asset_Def(
    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_adpv_rec                     IN adpv_rec_type,
    x_adpv_rec                     OUT NOCOPY adpv_rec_type) IS
  l_adpv_rec adpv_rec_type;
Line: 165

  l_api_name CONSTANT VARCHAR2(30) := 'update_txd_asset_Def';
Line: 168

    savepoint update_txd_asset_Def_pub;
Line: 187

    OKL_TXD_ASSETS_PVT.update_txd_asset_Def(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_asdv_rec      => l_adpv_rec,
                                            x_asdv_rec      => x_adpv_rec);
Line: 206

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 211

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 216

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 218

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
Line: 223

  END update_txd_asset_Def;
Line: 233

  PROCEDURE update_txd_asset_Def(
    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_adpv_tbl                     IN adpv_tbl_type,
    x_adpv_tbl                     OUT NOCOPY adpv_tbl_type) IS
    i                              NUMBER := 0;
Line: 248

        update_txd_asset_Def(
          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_adpv_rec      => p_adpv_tbl(i),
          x_adpv_rec      => x_adpv_tbl(i));
Line: 270

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 275

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 280

		ROLLBACK  TO update_txd_asset_Def_pub;
Line: 282

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
Line: 286

  END update_txd_asset_Def;
Line: 296

  PROCEDURE delete_txd_asset_Def(
    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_adpv_rec                     IN adpv_rec_type) IS

  l_adpv_rec adpv_rec_type;
Line: 306

  l_api_name CONSTANT VARCHAR2(30) := 'delete_txd_asset_Def';
Line: 309

    savepoint delete_txd_asset_Def_pub;
Line: 328

    OKL_TXD_ASSETS_PVT.delete_txd_asset_Def(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_asdv_rec      => l_adpv_rec);
Line: 345

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 350

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 355

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 357

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
Line: 361

  END delete_txd_asset_Def;
Line: 371

  PROCEDURE delete_txd_asset_Def(
    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_adpv_tbl                     IN adpv_tbl_type) IS
    i                              NUMBER := 0;
Line: 385

        delete_txd_asset_Def(
          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_adpv_rec      => p_adpv_tbl(i));
Line: 406

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 411

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 416

		ROLLBACK  TO delete_txd_asset_Def_pub;
Line: 418

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
Line: 422

  END delete_txd_asset_Def;