DBA Data[Home] [Help]

APPS.OKE_FUNDINGSOURCE_PVT dependencies on OKE_K_FUNDING_SOURCES

Line 61: from OKE_K_FUNDING_SOURCES

57: ) is
58:
59: cursor C is
60: select rowid
61: from OKE_K_FUNDING_SOURCES
62: where funding_source_id = X_Funding_Source_Id;
63:
64: begin
65: --oke_debug.debug('entering funding source insert_row');

Line 66: insert into OKE_K_FUNDING_SOURCES(

62: where funding_source_id = X_Funding_Source_Id;
63:
64: begin
65: --oke_debug.debug('entering funding source insert_row');
66: insert into OKE_K_FUNDING_SOURCES(
67: funding_source_id,
68: pool_party_id,
69: k_party_id,
70: object_type,

Line 291: from OKE_K_FUNDING_SOURCES

287: pa_attribute7,
288: pa_attribute8,
289: pa_attribute9,
290: pa_attribute10
291: from OKE_K_FUNDING_SOURCES
292: where funding_source_id = X_Funding_Source_Id
293: for update of funding_source_id nowait;
294:
295: recinfo c%rowtype;

Line 449: from oke_k_funding_sources

445: ) is
446:
447: cursor c_source is
448: select nvl(sum(amount), 0)
449: from oke_k_funding_sources
450: where pool_party_id = x_pool_party_id;
451:
452: l_amount number;
453:

Line 456: update OKE_K_FUNDING_SOURCES

452: l_amount number;
453:
454: begin
455:
456: update OKE_K_FUNDING_SOURCES
457: set
458: pool_party_id = X_Pool_Party_Id,
459: k_party_id = X_K_Party_Id,
460: amount = X_Amount,

Line 542: from oke_k_funding_sources

538: for update of pool_party_id nowait;
539:
540: cursor c_source is
541: select nvl(amount, 0)
542: from oke_k_funding_sources
543: where rowid = x_rowid;
544:
545: l_source_amount number;
546: l_pool_party_row c_pool%ROWTYPE;

Line 554: DELETE FROM OKE_K_FUNDING_SOURCES

550: OPEN c_source;
551: FETCH c_source into l_source_amount;
552: CLOSE c_source;
553:
554: DELETE FROM OKE_K_FUNDING_SOURCES
555: WHERE rowid = X_Rowid;
556:
557: if (SQL%NOTFOUND) then
558: Raise NO_DATA_FOUND;