APPS.OKE_FUNDINGSOURCE_PVT dependencies on OKE_K_FUNDING_SOURCES

Line 76: from OKE_K_FUNDING_SOURCES

72: ) is
73:
74: cursor C is
75: select rowid
76: from OKE_K_FUNDING_SOURCES
77: where funding_source_id = X_Funding_Source_Id;
78:
79: begin
80: --oke_debug.debug('entering funding source insert_row');

Line 81: insert into OKE_K_FUNDING_SOURCES(

77: where funding_source_id = X_Funding_Source_Id;
78:
79: begin
80: --oke_debug.debug('entering funding source insert_row');
81: insert into OKE_K_FUNDING_SOURCES(
82: funding_source_id,
83: pool_party_id,
84: k_party_id,
85: object_type,

Line 368: from OKE_K_FUNDING_SOURCES

364: pa_attribute22,
365: pa_attribute23,
366: pa_attribute24,
367: pa_attribute25
368: from OKE_K_FUNDING_SOURCES
369: where funding_source_id = X_Funding_Source_Id
370: for update of funding_source_id nowait;
371:
372: recinfo c%rowtype;

Line 572: from oke_k_funding_sources

568: ) is
569:
570: cursor c_source is
571: select nvl(sum(amount), 0)
572: from oke_k_funding_sources
573: where pool_party_id = x_pool_party_id;
574:
575: l_amount number;
576:

Line 579: update OKE_K_FUNDING_SOURCES

575: l_amount number;
576:
577: begin
578:
579: update OKE_K_FUNDING_SOURCES
580: set
581: pool_party_id = X_Pool_Party_Id,
582: k_party_id = X_K_Party_Id,
583: amount = X_Amount,

Line 680: from oke_k_funding_sources

676: for update of pool_party_id nowait;
677:
678: cursor c_source is
679: select nvl(amount, 0)
680: from oke_k_funding_sources
681: where rowid = x_rowid;
682:
683: l_source_amount number;
684: l_pool_party_row c_pool%ROWTYPE;

Line 692: DELETE FROM OKE_K_FUNDING_SOURCES

688: OPEN c_source;
689: FETCH c_source into l_source_amount;
690: CLOSE c_source;
691:
692: DELETE FROM OKE_K_FUNDING_SOURCES
693: WHERE rowid = X_Rowid;
694:
695: if (SQL%NOTFOUND) then
696: Raise NO_DATA_FOUND;