APPS.OKE_FUNDINGSOURCE_PVT dependencies on OKE_POOL_PARTIES

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

177: end if;
178: close c;
179: --oke_debug.debug('finishing insert_row');
180: if (x_pool_party_id is not null) then
181: --oke_debug.debug('inside the update oke_pool_parties');
182:
183: update oke_pool_parties
184: set available_amount = (available_amount - X_amount)
185: where pool_party_id = X_Pool_Party_Id;

Line 183: update oke_pool_parties

179: --oke_debug.debug('finishing insert_row');
180: if (x_pool_party_id is not null) then
181: --oke_debug.debug('inside the update oke_pool_parties');
182:
183: update oke_pool_parties
184: set available_amount = (available_amount - X_amount)
185: where pool_party_id = X_Pool_Party_Id;
186:
187: if (sql%notfound) then

Line 520: update oke_pool_parties

516: end if;
517:
518: close c_source;
519:
520: update oke_pool_parties
521: set available_amount = (amount - l_amount)
522: where pool_party_id = X_Pool_Party_Id;
523:
524: if (sql%notfound) then

Line 536: from oke_pool_parties

532: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
533: X_Pool_Party_Id NUMBER ) IS
534: cursor c_pool is
535: select *
536: from oke_pool_parties
537: where pool_party_id = x_pool_party_id
538: for update of pool_party_id nowait;
539:
540: cursor c_source is

Line 573: UPDATE OKE_POOL_PARTIES

569: end if;
570:
571: close c_pool;
572:
573: UPDATE OKE_POOL_PARTIES
574: SET available_amount = l_pool_party_row.available_amount + l_source_amount
575: WHERE pool_party_id = l_pool_party_row.pool_party_id;
576:
577: end if;