APPS.OKE_PARTY_PVT dependencies on OKE_POOL_PARTIES

Line 429: l_parent_currency OKE_POOL_PARTIES.CURRENCY_CODE%TYPE;

425:
426: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
427: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
428: l_result VARCHAR2(1);
429: l_parent_currency OKE_POOL_PARTIES.CURRENCY_CODE%TYPE;
430:
431: CURSOR l_conversion IS
432: SELECT CURRENCY_CODE
433: FROM OKE_FUNDING_POOLS

Line 868: FROM OKE_POOL_PARTIES a

864: ATTRIBUTE14 ,
865: ATTRIBUTE15
866:
867:
868: FROM OKE_POOL_PARTIES a
869: WHERE (a.pool_party_id = p_party_id);
870:
871: l_party_pk party_pk_csr%ROWTYPE;
872: l_party_rec party_rec_type;

Line 929: -- will create using nextVal from sequence OKE_POOL_PARTIES_s

925:
926:
927:
928: -- row level insert
929: -- will create using nextVal from sequence OKE_POOL_PARTIES_s
930:
931: PROCEDURE insert_row(
932: p_api_version IN NUMBER,
933: p_init_msg_list IN VARCHAR2 ,

Line 1113: SELECT OKE_POOL_PARTIES_S.nextval INTO l_seq FROM dual;

1109: RAISE OKE_API.G_EXCEPTION_ERROR;
1110: END IF;
1111: --oke_debug.debug('record validated');
1112:
1113: SELECT OKE_POOL_PARTIES_S.nextval INTO l_seq FROM dual;
1114:
1115: OKE_POOL_PARTIES_PKG.Insert_row
1116: ( l_row_id,
1117: l_seq ,

Line 1115: OKE_POOL_PARTIES_PKG.Insert_row

1111: --oke_debug.debug('record validated');
1112:
1113: SELECT OKE_POOL_PARTIES_S.nextval INTO l_seq FROM dual;
1114:
1115: OKE_POOL_PARTIES_PKG.Insert_row
1116: ( l_row_id,
1117: l_seq ,
1118: l_def_party_rec.FUNDING_POOL_ID,
1119: l_def_party_rec.PARTY_ID ,

Line 1317: from oke_pool_parties

1313: l_temp NUMBER;
1314:
1315: Cursor l_csr_id IS
1316: select pool_party_id
1317: from oke_pool_parties
1318: where pool_party_id=p_party_rec.pool_party_id;
1319:
1320: CURSOR l_csr IS
1321: SELECT 'x'

Line 1514: FROM OKE_POOL_PARTIES

1510:
1511: IF (p_party_rec.CONVERSION_TYPE IS NOT NULL) AND (p_party_rec.CONVERSION_TYPE <> OKE_API.G_MISS_CHAR) AND (p_party_rec.CONVERSION_DATE IS NOT NULL) AND (p_party_rec.CONVERSION_DATE <> OKE_API.G_MISS_DATE) THEN
1512:
1513: SELECT FUNDING_POOL_ID INTO l_pool_id
1514: FROM OKE_POOL_PARTIES
1515: WHERE pool_party_id = p_party_rec.pool_party_id;
1516:
1517: SELECT CURRENCY_CODE INTO l_to_currency
1518: FROM OKE_FUNDING_POOLS

Line 1660: FROM oke_funding_pools a,oke_pool_parties b

1656: END IF;
1657:
1658:
1659: SELECT a.currency_code INTO l_currency
1660: FROM oke_funding_pools a,oke_pool_parties b
1661: WHERE a.funding_pool_id = b.funding_pool_id
1662: AND b.pool_party_id=p_party_rec.pool_party_id;
1663:
1664: IF l_currency = p_party_rec.currency_code THEN

Line 1772: OKE_POOL_PARTIES_PKG.Update_Row(

1768: RAISE OKE_API.G_EXCEPTION_ERROR;
1769: END IF;
1770: --oke_debug.debug('record validated');
1771:
1772: OKE_POOL_PARTIES_PKG.Update_Row(
1773: l_def_party_rec.POOL_PARTY_ID,
1774: l_def_party_rec.PARTY_ID,
1775: l_def_party_rec.CURRENCY_CODE,
1776: l_def_party_rec.CONVERSION_TYPE,

Line 1963: from oke_pool_parties

1959: l_temp NUMBER;
1960:
1961: Cursor l_csr_id IS
1962: select pool_party_id
1963: from oke_pool_parties
1964: where pool_party_id=p_party_rec.pool_party_id;
1965:
1966: BEGIN
1967: --oke_debug.debug('start call oke_party_pvt.delete_row');

Line 2007: DELETE FROM OKE_POOL_PARTIES

2003: RAISE OKE_API.G_EXCEPTION_ERROR;
2004: END IF;
2005: CLOSE l_csr_id;
2006:
2007: DELETE FROM OKE_POOL_PARTIES
2008: WHERE POOL_PARTY_ID = p_party_rec.POOL_PARTY_ID;
2009:
2010: --oke_debug.debug('end call oke_party_pvt.delete_row');
2011: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2166: SELECT pool_party_id FROM OKE_POOL_PARTIES a

2162: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2163:
2164:
2165: CURSOR lock_csr (p IN party_rec_type) IS
2166: SELECT pool_party_id FROM OKE_POOL_PARTIES a
2167: WHERE
2168: a.pool_party_id = p.pool_party_id
2169: FOR UPDATE NOWAIT;
2170: