APPS.OKE_FUNDINGSOURCE_PVT dependencies on OKE_POOL_PARTIES

Line 227: --oke_debug.debug('inside the update oke_pool_parties');

223: end if;
224: close c;
225: --oke_debug.debug('finishing insert_row');
226: if (x_pool_party_id is not null) then
227: --oke_debug.debug('inside the update oke_pool_parties');
228:
229: update oke_pool_parties
230: set available_amount = (available_amount - X_amount)
231: where pool_party_id = X_Pool_Party_Id;

Line 229: update oke_pool_parties

225: --oke_debug.debug('finishing insert_row');
226: if (x_pool_party_id is not null) then
227: --oke_debug.debug('inside the update oke_pool_parties');
228:
229: update oke_pool_parties
230: set available_amount = (available_amount - X_amount)
231: where pool_party_id = X_Pool_Party_Id;
232:
233: if (sql%notfound) then

Line 658: update oke_pool_parties

654: end if;
655:
656: close c_source;
657:
658: update oke_pool_parties
659: set available_amount = (amount - l_amount)
660: where pool_party_id = X_Pool_Party_Id;
661:
662: if (sql%notfound) then

Line 674: from oke_pool_parties

670: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
671: X_Pool_Party_Id NUMBER ) IS
672: cursor c_pool is
673: select *
674: from oke_pool_parties
675: where pool_party_id = x_pool_party_id
676: for update of pool_party_id nowait;
677:
678: cursor c_source is

Line 711: UPDATE OKE_POOL_PARTIES

707: end if;
708:
709: close c_pool;
710:
711: UPDATE OKE_POOL_PARTIES
712: SET available_amount = l_pool_party_row.available_amount + l_source_amount
713: WHERE pool_party_id = l_pool_party_row.pool_party_id;
714:
715: end if;