[Home] [Help]
1051:
1052: l_dummy_val VARCHAR2(1):='?';
1053: CURSOR l_csr IS
1054: SELECT 'x'
1055: FROM OKE_K_FUNDING_SOURCES
1056: WHERE POOL_PARTY_ID = p_party_rec.POOL_PARTY_ID;
1057:
1058:
1059: BEGIN
1148:
1149: l_dummy_val VARCHAR2(1):='?';
1150: CURSOR l_csr (p_row NUMBER) IS
1151: SELECT 'x'
1152: FROM OKE_K_FUNDING_SOURCES
1153: WHERE POOL_PARTY_ID = p_party_tbl(p_row).POOL_PARTY_ID;
1154:
1155: BEGIN
1156: -- call START_ACTIVITY to create savepoint, check compatibility
1331: l_temp NUMBER;
1332:
1333: CURSOR l_csr IS
1334: SELECT FUNDING_SOURCE_ID
1335: FROM OKE_K_FUNDING_SOURCES
1336: WHERE POOL_PARTY_ID = p_pool_party_id;
1337:
1338: Cursor l_csr_id IS
1339: select pool_party_id