DBA Data[Home] [Help]

APPS.OKE_POOLS_PARTIES_PUB SQL Statements

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

Line: 50

	OKE_POOL_PVT.Insert_Row(
	    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_pool_rec		=> l_pool_rec,
            x_pool_rec		=> x_pool_rec);
Line: 137

    OKE_POOL_PVT.Insert_Row(
      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_pool_tbl		=> p_pool_tbl,
      x_pool_tbl		=> x_pool_tbl);
Line: 186

  PROCEDURE update_pool(
    p_api_version       IN NUMBER,
    p_init_msg_list     IN VARCHAR2 ,
    x_return_status     OUT NOCOPY VARCHAR2,
    x_msg_count         OUT NOCOPY NUMBER,
    x_msg_data          OUT NOCOPY VARCHAR2,
    p_pool_rec		IN oke_pool_pvt.pool_rec_type,
    x_pool_rec		OUT NOCOPY oke_pool_pvt.pool_rec_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
Line: 222

    OKE_POOL_PVT.Update_Row(
      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_pool_rec			=> p_pool_rec,
      x_pool_rec			=> x_pool_rec);
Line: 270

  END update_pool;
Line: 273

 PROCEDURE update_pool(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_tbl			   IN  oke_pool_pvt.pool_tbl_type,
    x_pool_tbl			   OUT NOCOPY  oke_pool_pvt.pool_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
Line: 312

    OKE_POOL_PVT.Update_Row(
	 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_pool_tbl			=> p_pool_tbl,
      x_pool_tbl			=> x_pool_tbl);
Line: 359

  END update_pool;
Line: 362

  PROCEDURE delete_pool(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_funding_pool_id		   IN NUMBER) IS

    l_pool_rec		oke_pool_pvt.pool_rec_type;
Line: 372

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_POOL';
Line: 380

	SELECT POOL_PARTY_ID
	FROM OKE_POOL_PARTIES
	WHERE FUNDING_POOL_ID = p_funding_pool_id;
Line: 385

	select funding_pool_id
	from oke_funding_pools
	where funding_pool_id=p_funding_pool_id;
Line: 431

	delete_party(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_pool_party_id		=> l_current_id);
Line: 451

    	OKE_POOL_PVT.delete_row(
	 	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_pool_rec		=> l_pool_rec);
Line: 497

  END delete_pool;
Line: 500

  PROCEDURE delete_pool(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_rec			   IN oke_pool_pvt.pool_rec_type) IS

    l_pool_rec		oke_pool_pvt.pool_rec_type;
Line: 510

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_POOL';
Line: 536

    	delete_pool(
	 	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_funding_pool_id	=> p_pool_rec.funding_pool_id);
Line: 582

  END delete_pool;
Line: 584

  PROCEDURE delete_pool(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_tbl			   IN  oke_pool_pvt.pool_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_POOL';
Line: 621

      Delete_Pool(
      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_funding_pool_id	=> p_pool_tbl(i).funding_pool_id);
Line: 680

  END delete_pool;
Line: 905

	OKE_PARTY_PVT.Insert_Row(
	    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_party_rec		=> l_party_rec,
            x_party_rec		=> x_party_rec);
Line: 991

    OKE_PARTY_PVT.Insert_Row(
      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_party_tbl		=> p_party_tbl,
      x_party_tbl		=> x_party_tbl);
Line: 1040

  PROCEDURE update_party(
    p_api_version       IN NUMBER,
    p_init_msg_list     IN VARCHAR2 ,
    x_return_status     OUT NOCOPY VARCHAR2,
    x_msg_count         OUT NOCOPY NUMBER,
    x_msg_data          OUT NOCOPY VARCHAR2,
    p_party_rec		IN oke_party_pvt.party_rec_type,
    x_party_rec		OUT NOCOPY oke_party_pvt.party_rec_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
Line: 1056

	SELECT 'x'
	FROM OKE_K_FUNDING_SOURCES
	WHERE POOL_PARTY_ID = p_party_rec.POOL_PARTY_ID;
Line: 1085

    OKE_PARTY_PVT.Update_Row(
      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_party_rec			=> p_party_rec,
      x_party_rec			=> x_party_rec);
Line: 1132

  END update_party;
Line: 1135

 PROCEDURE update_party(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_party_tbl			   IN  oke_party_pvt.party_tbl_type,
    x_party_tbl			   OUT NOCOPY  oke_party_pvt.party_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
Line: 1153

	SELECT 'x'
	FROM OKE_K_FUNDING_SOURCES
	WHERE POOL_PARTY_ID = p_party_tbl(p_row).POOL_PARTY_ID;
Line: 1182

    OKE_PARTY_PVT.Update_Row(
	 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_party_tbl			=> p_party_tbl,
      x_party_tbl			=> x_party_tbl);
Line: 1230

  END update_party;
Line: 1233

  PROCEDURE delete_party(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_party_rec			   IN oke_party_pvt.party_rec_type) IS

    l_party_rec		oke_party_pvt.party_rec_type;
Line: 1243

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
Line: 1269

    	delete_party(
	 	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_pool_party_id		=> p_party_rec.pool_party_id);
Line: 1315

  END delete_party;
Line: 1319

  PROCEDURE delete_party(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_party_id		   IN NUMBER) IS

    l_party_rec		oke_party_pvt.party_rec_type;
Line: 1329

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
Line: 1336

	SELECT FUNDING_SOURCE_ID
	FROM OKE_K_FUNDING_SOURCES
	WHERE POOL_PARTY_ID = p_pool_party_id;
Line: 1341

	select pool_party_id
	from oke_pool_parties
	where pool_party_id=p_pool_party_id;
Line: 1386

	oke_funding_pub.delete_funding(
		p_api_version		=> p_api_version,
	 	p_init_msg_list		=> p_init_msg_list,
		p_commit		=> OKE_API.G_FALSE,
      		x_return_status 	=> x_return_status,
      		x_msg_count     	=> x_msg_count,
      		x_msg_data      	=> x_msg_data,
		p_funding_source_id	=> l_current_id);
Line: 1409

    	OKE_PARTY_PVT.delete_row(
	 	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_party_rec		=> l_party_rec);
Line: 1455

  END delete_party;
Line: 1459

  PROCEDURE delete_party(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_party_tbl			   IN  oke_party_pvt.party_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
Line: 1495

      Delete_Party(
      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_pool_party_id	=> p_party_tbl(i).pool_party_id);
Line: 1554

  END delete_party;