The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
l_api_name CONSTANT VARCHAR2(30) := 'update_txd_asset_Def';
savepoint update_txd_asset_Def_pub;
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);
ROLLBACK TO update_txd_asset_Def_pub;
ROLLBACK TO update_txd_asset_Def_pub;
ROLLBACK TO update_txd_asset_Def_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
END update_txd_asset_Def;
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;
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));
ROLLBACK TO update_txd_asset_Def_pub;
ROLLBACK TO update_txd_asset_Def_pub;
ROLLBACK TO update_txd_asset_Def_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
END update_txd_asset_Def;
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;
l_api_name CONSTANT VARCHAR2(30) := 'delete_txd_asset_Def';
savepoint delete_txd_asset_Def_pub;
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);
ROLLBACK TO delete_txd_asset_Def_pub;
ROLLBACK TO delete_txd_asset_Def_pub;
ROLLBACK TO delete_txd_asset_Def_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
END delete_txd_asset_Def;
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;
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));
ROLLBACK TO delete_txd_asset_Def_pub;
ROLLBACK TO delete_txd_asset_Def_pub;
ROLLBACK TO delete_txd_asset_Def_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
END delete_txd_asset_Def;