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_POOL_PVT dependencies on OKE_POOL_PVT

Line 1: PACKAGE BODY OKE_POOL_PVT AS

1: PACKAGE BODY OKE_POOL_PVT AS
2: /* $Header: OKEVFPLB.pls 120.0 2005/05/25 17:46:47 appldev noship $ */
3:
4: -- validate record
5:

Line 554: --oke_debug.debug('start call oke_pool_pvt.insert_row');

550: END Set_Attributes;
551:
552:
553: BEGIN -- insert
554: --oke_debug.debug('start call oke_pool_pvt.insert_row');
555:
556: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
557: G_PKG_NAME,
558: p_init_msg_list,

Line 669: --oke_debug.debug('end call oke_pool_pvt.insert_row');

665: -- Set OUT values
666: x_pool_rec := l_def_pool_rec;
667: x_pool_rec.FUNDING_POOL_ID:=l_seq;
668:
669: --oke_debug.debug('end call oke_pool_pvt.insert_row');
670: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
671:
672: EXCEPTION
673: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 726: --oke_debug.debug('start call oke_pool_pvt.insert_row');

722: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
723: i NUMBER := 0;
724: BEGIN
725:
726: --oke_debug.debug('start call oke_pool_pvt.insert_row');
727:
728: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
729: G_PKG_NAME,
730: p_init_msg_list,

Line 770: --oke_debug.debug('end call oke_pool_pvt.insert_row');

766: END LOOP;
767: -- return overall status
768: x_return_status := l_overall_status;
769: END IF;
770: --oke_debug.debug('end call oke_pool_pvt.insert_row');
771: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
772:
773: EXCEPTION
774: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 998: --oke_debug.debug('start call oke_pool_pvt.update_row');

994:
995:
996: BEGIN -- update row
997:
998: --oke_debug.debug('start call oke_pool_pvt.update_row');
999:
1000: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1001: G_PKG_NAME,
1002: p_init_msg_list,

Line 1132: --oke_debug.debug('end call oke_pool_pvt.update_row');

1128: l_def_pool_rec.ATTRIBUTE14,
1129: l_def_pool_rec.ATTRIBUTE15 );
1130:
1131: x_pool_rec := l_def_pool_rec;
1132: --oke_debug.debug('end call oke_pool_pvt.update_row');
1133: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1134:
1135: EXCEPTION
1136: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1189: --oke_debug.debug('start call oke_pool_pvt.update_row');

1185: i NUMBER := 0;
1186: BEGIN
1187:
1188:
1189: --oke_debug.debug('start call oke_pool_pvt.update_row');
1190:
1191: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1192: G_PKG_NAME,
1193: p_init_msg_list,

Line 1232: --oke_debug.debug('end call oke_pool_pvt.update_row');

1228: END LOOP;
1229: -- return overall status
1230: x_return_status := l_overall_status;
1231: END IF;
1232: --oke_debug.debug('end call oke_pool_pvt.update_row');
1233: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1234:
1235: EXCEPTION
1236: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1292: --oke_debug.debug('start call oke_pool_pvt.delete_row');

1288: from oke_funding_pools
1289: where funding_pool_id=p_pool_rec.funding_pool_id;
1290:
1291: BEGIN
1292: --oke_debug.debug('start call oke_pool_pvt.delete_row');
1293:
1294: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1295: G_PKG_NAME,
1296: p_init_msg_list,

Line 1336: --oke_debug.debug('end call oke_pool_pvt.delete_row');

1332:
1333: DELETE FROM OKE_FUNDING_POOLS
1334: WHERE FUNDING_POOL_ID = p_pool_rec.FUNDING_POOL_ID;
1335:
1336: --oke_debug.debug('end call oke_pool_pvt.delete_row');
1337: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1338:
1339: EXCEPTION
1340: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1389: --oke_debug.debug('start call oke_pool_pvt.delete_row');

1385: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1386: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1387: i NUMBER := 0;
1388: BEGIN
1389: --oke_debug.debug('start call oke_pool_pvt.delete_row');
1390:
1391: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1392: G_PKG_NAME,
1393: p_init_msg_list,

Line 1434: --oke_debug.debug('end call oke_pool_pvt.delete_row');

1430:
1431: -- return overall status
1432: x_return_status := l_overall_status;
1433: END IF;
1434: --oke_debug.debug('end call oke_pool_pvt.delete_row');
1435: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1436:
1437: EXCEPTION
1438: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1499: --oke_debug.debug('start call oke_pool_pvt.lock_row');

1495: FOR UPDATE NOWAIT;
1496:
1497:
1498: BEGIN
1499: --oke_debug.debug('start call oke_pool_pvt.lock_row');
1500:
1501: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1502: G_PKG_NAME,
1503: p_init_msg_list,

Line 1539: --oke_debug.debug('end call oke_pool_pvt.lock_row');

1535: OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);
1536: RAISE OKE_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:
1539: --oke_debug.debug('end call oke_pool_pvt.lock_row');
1540: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1541:
1542: EXCEPTION
1543: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1576: END OKE_POOL_PVT;

1572: );
1573: END lock_row;
1574:
1575:
1576: END OKE_POOL_PVT;
1577: