eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_POOLS_PARTIES_PUB dependencies on OKE_POOL_PVT

Line 14: p_pool_rec IN oke_pool_pvt.pool_rec_type,

10: p_init_msg_list IN VARCHAR2 ,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_pool_rec IN oke_pool_pvt.pool_rec_type,
15: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS
16:
17:
18: l_pool_rec oke_pool_pvt.pool_rec_type;

Line 15: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS

11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_pool_rec IN oke_pool_pvt.pool_rec_type,
15: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS
16:
17:
18: l_pool_rec oke_pool_pvt.pool_rec_type;
19:

Line 18: l_pool_rec oke_pool_pvt.pool_rec_type;

14: p_pool_rec IN oke_pool_pvt.pool_rec_type,
15: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS
16:
17:
18: l_pool_rec oke_pool_pvt.pool_rec_type;
19:
20: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_POOL';
21: l_api_version CONSTANT NUMBER := 1.0;
22: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 49: OKE_POOL_PVT.Insert_Row(

45: l_pool_rec := p_pool_rec;
46:
47: -- call procedure in complex API
48:
49: OKE_POOL_PVT.Insert_Row(
50: p_api_version => p_api_version,
51: p_init_msg_list => p_init_msg_list,
52: x_return_status => x_return_status,
53: x_msg_count => x_msg_count,

Line 107: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,

103: p_init_msg_list IN VARCHAR2 ,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
108: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS
109:
110: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_POOL';
111: l_api_version CONSTANT NUMBER := 1.0;

Line 108: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS

104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
108: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS
109:
110: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_POOL';
111: l_api_version CONSTANT NUMBER := 1.0;
112: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 115: l_pool_tbl oke_pool_pvt.pool_tbl_type;

111: l_api_version CONSTANT NUMBER := 1.0;
112: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
113: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
114: i NUMBER;
115: l_pool_tbl oke_pool_pvt.pool_tbl_type;
116: BEGIN
117: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');
118: -- call START_ACTIVITY to create savepoint, check compatibility
119: -- and initialize message list

Line 136: OKE_POOL_PVT.Insert_Row(

132: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
133: raise OKE_API.G_EXCEPTION_ERROR;
134: End If;
135:
136: OKE_POOL_PVT.Insert_Row(
137: p_api_version => p_api_version,
138: p_init_msg_list => p_init_msg_list,
139: x_return_status => x_return_status,
140: x_msg_count => x_msg_count,

Line 191: p_pool_rec IN oke_pool_pvt.pool_rec_type,

187: p_init_msg_list IN VARCHAR2 ,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pool_rec IN oke_pool_pvt.pool_rec_type,
192: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS
193:
194: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
195: l_api_version CONSTANT NUMBER := 1.0;

Line 192: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS

188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pool_rec IN oke_pool_pvt.pool_rec_type,
192: x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type) IS
193:
194: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
195: l_api_version CONSTANT NUMBER := 1.0;
196: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 221: OKE_POOL_PVT.Update_Row(

217:
218:
219: -- call complex api
220: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call pvt_update_row');
221: OKE_POOL_PVT.Update_Row(
222: p_api_version => p_api_version,
223: p_init_msg_list => p_init_msg_list,
224: x_return_status => x_return_status,
225: x_msg_count => x_msg_count,

Line 278: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,

274: p_init_msg_list IN VARCHAR2 ,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
279: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS
280:
281: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
282: l_api_version CONSTANT NUMBER := 1.0;

Line 279: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS

275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
279: x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type) IS
280:
281: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_POOL';
282: l_api_version CONSTANT NUMBER := 1.0;
283: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 311: OKE_POOL_PVT.Update_Row(

307: End If;
308:
309: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call PVT.update_row table version');
310:
311: OKE_POOL_PVT.Update_Row(
312: p_api_version => p_api_version,
313: p_init_msg_list => p_init_msg_list,
314: x_return_status => x_return_status,
315: x_msg_count => x_msg_count,

Line 370: l_pool_rec oke_pool_pvt.pool_rec_type;

366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_funding_pool_id IN NUMBER) IS
369:
370: l_pool_rec oke_pool_pvt.pool_rec_type;
371: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_POOL';
372: l_api_version CONSTANT NUMBER := 1.0;
373: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
374:

Line 450: OKE_POOL_PVT.delete_row(

446: CLOSE l_csr;
447:
448: -- call complex api
449:
450: OKE_POOL_PVT.delete_row(
451: p_api_version => p_api_version,
452: p_init_msg_list => p_init_msg_list,
453: x_return_status => x_return_status,
454: x_msg_count => x_msg_count,

Line 506: p_pool_rec IN oke_pool_pvt.pool_rec_type) IS

502: p_init_msg_list IN VARCHAR2 ,
503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_count OUT NOCOPY NUMBER,
505: x_msg_data OUT NOCOPY VARCHAR2,
506: p_pool_rec IN oke_pool_pvt.pool_rec_type) IS
507:
508: l_pool_rec oke_pool_pvt.pool_rec_type;
509: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_POOL';
510: l_api_version CONSTANT NUMBER := 1.0;

Line 508: l_pool_rec oke_pool_pvt.pool_rec_type;

504: x_msg_count OUT NOCOPY NUMBER,
505: x_msg_data OUT NOCOPY VARCHAR2,
506: p_pool_rec IN oke_pool_pvt.pool_rec_type) IS
507:
508: l_pool_rec oke_pool_pvt.pool_rec_type;
509: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_POOL';
510: l_api_version CONSTANT NUMBER := 1.0;
511: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
512: BEGIN

Line 589: p_pool_tbl IN oke_pool_pvt.pool_tbl_type) IS

585: p_init_msg_list IN VARCHAR2 ,
586: x_return_status OUT NOCOPY VARCHAR2,
587: x_msg_count OUT NOCOPY NUMBER,
588: x_msg_data OUT NOCOPY VARCHAR2,
589: p_pool_tbl IN oke_pool_pvt.pool_tbl_type) IS
590:
591: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_POOL';
592: l_api_version CONSTANT NUMBER := 1.0;
593: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 688: p_pool_rec IN OKE_POOL_PVT.pool_rec_type) IS

684: p_init_msg_list IN VARCHAR2 ,
685: x_return_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2,
688: p_pool_rec IN OKE_POOL_PVT.pool_rec_type) IS
689:
690:
691: l_del_rec oke_deliverable_pvt.del_rec_type;
692: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_POOL';

Line 713: OKE_POOL_PVT.Lock_Row(

709: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
710: raise OKE_API.G_EXCEPTION_ERROR;
711: End If;
712:
713: OKE_POOL_PVT.Lock_Row(
714: p_api_version => p_api_version,
715: p_init_msg_list => p_init_msg_list,
716: x_return_status => x_return_status,
717: x_msg_count => x_msg_count,

Line 766: p_pool_tbl IN oke_pool_pvt.pool_tbl_type) IS

762: p_init_msg_list IN VARCHAR2 ,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,
765: x_msg_data OUT NOCOPY VARCHAR2,
766: p_pool_tbl IN oke_pool_pvt.pool_tbl_type) IS
767:
768: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_POOL';
769: l_api_version CONSTANT NUMBER := 1.0;
770: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 796: OKE_POOL_PVT.lock_row(

792: If (p_pool_tbl.COUNT > 0) Then
793: i := p_pool_tbl.FIRST;
794: LOOP
795: -- call procedure in complex API
796: OKE_POOL_PVT.lock_row(
797: p_api_version => p_api_version,
798: p_init_msg_list => p_init_msg_list,
799: x_return_status => x_return_status,
800: x_msg_count => x_msg_count,