DBA Data[Home] [Help]

APPS.OKE_POOLS_PARTIES_PUB dependencies on OKE_PARTY_PVT

Line 868: p_party_rec IN oke_party_pvt.party_rec_type,

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

Line 869: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS

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

Line 872: l_party_rec oke_party_pvt.party_rec_type;

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

Line 905: OKE_PARTY_PVT.Insert_Row(

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

Line 963: p_party_tbl IN oke_party_pvt.party_tbl_type,

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

Line 964: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS

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

Line 971: l_party_tbl oke_party_pvt.party_tbl_type;

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

Line 991: OKE_PARTY_PVT.Insert_Row(

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

Line 1046: p_party_rec IN oke_party_pvt.party_rec_type,

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

Line 1047: x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type) IS

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

Line 1085: OKE_PARTY_PVT.Update_Row(

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

Line 1141: p_party_tbl IN oke_party_pvt.party_tbl_type,

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

Line 1142: x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type) IS

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

Line 1182: OKE_PARTY_PVT.Update_Row(

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

Line 1240: p_party_rec IN oke_party_pvt.party_rec_type) IS

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

Line 1242: l_party_rec oke_party_pvt.party_rec_type;

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

Line 1328: l_party_rec oke_party_pvt.party_rec_type;

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

Line 1409: OKE_PARTY_PVT.delete_row(

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

Line 1465: p_party_tbl IN oke_party_pvt.party_tbl_type) IS

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

Line 1563: p_party_rec IN OKE_PARTY_PVT.party_rec_type) IS

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

Line 1588: OKE_PARTY_PVT.Lock_Row(

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

Line 1641: p_party_tbl IN oke_party_pvt.party_tbl_type) IS

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

Line 1671: OKE_PARTY_PVT.lock_row(

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