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_PARTY_PVT

Line 867: p_party_rec IN oke_party_pvt.party_rec_type,

863: p_init_msg_list IN VARCHAR2 ,
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2,
867: p_party_rec IN oke_party_pvt.party_rec_type,
868: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS
869:
870:
871: l_party_rec oke_party_pvt.party_rec_type;

Line 868: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS

864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2,
867: p_party_rec IN oke_party_pvt.party_rec_type,
868: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS
869:
870:
871: l_party_rec oke_party_pvt.party_rec_type;
872:

Line 871: l_party_rec oke_party_pvt.party_rec_type;

867: p_party_rec IN oke_party_pvt.party_rec_type,
868: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS
869:
870:
871: l_party_rec oke_party_pvt.party_rec_type;
872:
873: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY';
874: l_api_version CONSTANT NUMBER := 1.0;
875: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 903: OKE_PARTY_PVT.Insert_Row(

899: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call partys pvt');
900:
901: -- call procedure in complex API
902:
903: OKE_PARTY_PVT.Insert_Row(
904: p_api_version => p_api_version,
905: p_init_msg_list => p_init_msg_list,
906: x_return_status => x_return_status,
907: x_msg_count => x_msg_count,

Line 961: p_party_tbl IN oke_party_pvt.party_tbl_type,

957: p_init_msg_list IN VARCHAR2 ,
958: x_return_status OUT NOCOPY VARCHAR2,
959: x_msg_count OUT NOCOPY NUMBER,
960: x_msg_data OUT NOCOPY VARCHAR2,
961: p_party_tbl IN oke_party_pvt.party_tbl_type,
962: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS
963:
964: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY';
965: l_api_version CONSTANT NUMBER := 1.0;

Line 962: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS

958: x_return_status OUT NOCOPY VARCHAR2,
959: x_msg_count OUT NOCOPY NUMBER,
960: x_msg_data OUT NOCOPY VARCHAR2,
961: p_party_tbl IN oke_party_pvt.party_tbl_type,
962: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS
963:
964: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY';
965: l_api_version CONSTANT NUMBER := 1.0;
966: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 969: l_party_tbl oke_party_pvt.party_tbl_type;

965: l_api_version CONSTANT NUMBER := 1.0;
966: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
967: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
968: i NUMBER;
969: l_party_tbl oke_party_pvt.party_tbl_type;
970: BEGIN
971: -- call START_ACTIVITY to create savepoint, check compatibility
972: -- and initialize message list
973: l_return_status := OKE_API.START_ACTIVITY(

Line 989: OKE_PARTY_PVT.Insert_Row(

985: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
986: raise OKE_API.G_EXCEPTION_ERROR;
987: End If;
988:
989: OKE_PARTY_PVT.Insert_Row(
990: p_api_version => p_api_version,
991: p_init_msg_list => p_init_msg_list,
992: x_return_status => x_return_status,
993: x_msg_count => x_msg_count,

Line 1044: p_party_rec IN oke_party_pvt.party_rec_type,

1040: p_init_msg_list IN VARCHAR2 ,
1041: x_return_status OUT NOCOPY VARCHAR2,
1042: x_msg_count OUT NOCOPY NUMBER,
1043: x_msg_data OUT NOCOPY VARCHAR2,
1044: p_party_rec IN oke_party_pvt.party_rec_type,
1045: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS
1046:
1047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
1048: l_api_version CONSTANT NUMBER := 1.0;

Line 1045: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS

1041: x_return_status OUT NOCOPY VARCHAR2,
1042: x_msg_count OUT NOCOPY NUMBER,
1043: x_msg_data OUT NOCOPY VARCHAR2,
1044: p_party_rec IN oke_party_pvt.party_rec_type,
1045: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS
1046:
1047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
1048: l_api_version CONSTANT NUMBER := 1.0;
1049: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1083: OKE_PARTY_PVT.Update_Row(

1079:
1080:
1081: -- call complex api
1082: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call pvt_update_row');
1083: OKE_PARTY_PVT.Update_Row(
1084: p_api_version => p_api_version,
1085: p_init_msg_list => p_init_msg_list,
1086: x_return_status => x_return_status,
1087: x_msg_count => x_msg_count,

Line 1139: p_party_tbl IN oke_party_pvt.party_tbl_type,

1135: p_init_msg_list IN VARCHAR2 ,
1136: x_return_status OUT NOCOPY VARCHAR2,
1137: x_msg_count OUT NOCOPY NUMBER,
1138: x_msg_data OUT NOCOPY VARCHAR2,
1139: p_party_tbl IN oke_party_pvt.party_tbl_type,
1140: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS
1141:
1142: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
1143: l_api_version CONSTANT NUMBER := 1.0;

Line 1140: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS

1136: x_return_status OUT NOCOPY VARCHAR2,
1137: x_msg_count OUT NOCOPY NUMBER,
1138: x_msg_data OUT NOCOPY VARCHAR2,
1139: p_party_tbl IN oke_party_pvt.party_tbl_type,
1140: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS
1141:
1142: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY';
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1180: OKE_PARTY_PVT.Update_Row(

1176: End If;
1177:
1178: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call PVT.update_row table version');
1179:
1180: OKE_PARTY_PVT.Update_Row(
1181: p_api_version => p_api_version,
1182: p_init_msg_list => p_init_msg_list,
1183: x_return_status => x_return_status,
1184: x_msg_count => x_msg_count,

Line 1238: p_party_rec IN oke_party_pvt.party_rec_type) IS

1234: p_init_msg_list IN VARCHAR2 ,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2,
1238: p_party_rec IN oke_party_pvt.party_rec_type) IS
1239:
1240: l_party_rec oke_party_pvt.party_rec_type;
1241: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
1242: l_api_version CONSTANT NUMBER := 1.0;

Line 1240: l_party_rec oke_party_pvt.party_rec_type;

1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2,
1238: p_party_rec IN oke_party_pvt.party_rec_type) IS
1239:
1240: l_party_rec oke_party_pvt.party_rec_type;
1241: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
1242: l_api_version CONSTANT NUMBER := 1.0;
1243: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1244: BEGIN

Line 1326: l_party_rec oke_party_pvt.party_rec_type;

1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_pool_party_id IN NUMBER) IS
1325:
1326: l_party_rec oke_party_pvt.party_rec_type;
1327: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
1328: l_api_version CONSTANT NUMBER := 1.0;
1329: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1330: l_current_id NUMBER;

Line 1407: OKE_PARTY_PVT.delete_row(

1403:
1404:
1405: -- call complex api
1406:
1407: OKE_PARTY_PVT.delete_row(
1408: p_api_version => p_api_version,
1409: p_init_msg_list => p_init_msg_list,
1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,

Line 1463: p_party_tbl IN oke_party_pvt.party_tbl_type) IS

1459: p_init_msg_list IN VARCHAR2 ,
1460: x_return_status OUT NOCOPY VARCHAR2,
1461: x_msg_count OUT NOCOPY NUMBER,
1462: x_msg_data OUT NOCOPY VARCHAR2,
1463: p_party_tbl IN oke_party_pvt.party_tbl_type) IS
1464:
1465: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY';
1466: l_api_version CONSTANT NUMBER := 1.0;
1467: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1561: p_party_rec IN OKE_PARTY_PVT.party_rec_type) IS

1557: p_init_msg_list IN VARCHAR2 ,
1558: x_return_status OUT NOCOPY VARCHAR2,
1559: x_msg_count OUT NOCOPY NUMBER,
1560: x_msg_data OUT NOCOPY VARCHAR2,
1561: p_party_rec IN OKE_PARTY_PVT.party_rec_type) IS
1562:
1563:
1564: l_del_rec oke_deliverable_pvt.del_rec_type;
1565: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY';

Line 1586: OKE_PARTY_PVT.Lock_Row(

1582: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1583: raise OKE_API.G_EXCEPTION_ERROR;
1584: End If;
1585:
1586: OKE_PARTY_PVT.Lock_Row(
1587: p_api_version => p_api_version,
1588: p_init_msg_list => p_init_msg_list,
1589: x_return_status => x_return_status,
1590: x_msg_count => x_msg_count,

Line 1639: p_party_tbl IN oke_party_pvt.party_tbl_type) IS

1635: p_init_msg_list IN VARCHAR2 ,
1636: x_return_status OUT NOCOPY VARCHAR2,
1637: x_msg_count OUT NOCOPY NUMBER,
1638: x_msg_data OUT NOCOPY VARCHAR2,
1639: p_party_tbl IN oke_party_pvt.party_tbl_type) IS
1640:
1641: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY';
1642: l_api_version CONSTANT NUMBER := 1.0;
1643: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1669: OKE_PARTY_PVT.lock_row(

1665: If (p_party_tbl.COUNT > 0) Then
1666: i := p_party_tbl.FIRST;
1667: LOOP
1668: -- call procedure in complex API
1669: OKE_PARTY_PVT.lock_row(
1670: p_api_version => p_api_version,
1671: p_init_msg_list => p_init_msg_list,
1672: x_return_status => x_return_status,
1673: x_msg_count => x_msg_count,