DBA Data[Home] [Help]

APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_K_FUNDING_SOURCES

Line 113: select oke_k_funding_sources_s.nextval

109: l_funding_source_id NUMBER;
110:
111: BEGIN
112:
113: select oke_k_funding_sources_s.nextval
114: into l_funding_source_id
115: from dual;
116:
117: return(l_funding_source_id);

Line 546: from oke_k_funding_sources

542: p_agreement_flag OUT NOCOPY VARCHAR2
543: ) is
544: cursor c_funding_source_id is
545: select rowid, pool_party_id, agreement_flag
546: from oke_k_funding_sources
547: where funding_source_id = p_funding_source_id;
548:
549: BEGIN
550:

Line 2138: from oke_k_funding_sources

2134: ) is
2135:
2136: cursor c_funding_row is
2137: select *
2138: from oke_k_funding_sources
2139: where funding_source_id = p_funding_in_rec.funding_source_id
2140: FOR UPDATE OF funding_source_id NOWAIT;
2141:
2142: l_funding_row c_funding_row%ROWTYPE;

Line 2714: -- Description: This procedure is used to insert record in OKE_K_FUNDING_SOURCES table

2710:
2711: --
2712: -- Procedure create_funding
2713: --
2714: -- Description: This procedure is used to insert record in OKE_K_FUNDING_SOURCES table
2715: --
2716: -- Calling subprograms: OKE_API.start_activity
2717: -- OKE_API.end_activity
2718: -- OKE_FUNDINGSOURCE_PVT.insert_row

Line 3110: -- Description: This procedure is used to delete record in OKE_K_FUNDING_SOURCES table

3106:
3107: --
3108: -- Procedure: delete_funding
3109: --
3110: -- Description: This procedure is used to delete record in OKE_K_FUNDING_SOURCES table
3111: --
3112: -- Calling subprograms: OKE_API.start_activity
3113: -- OKE_API.end_activity
3114: -- OKE_FUNDINGSOURCE_PVT.delete_row

Line 3864: update oke_k_funding_sources

3860:
3861: --
3862: -- Update initial amount and pa_flag
3863: --
3864: update oke_k_funding_sources
3865: set initial_amount = p_amount,
3866: funding_across_ou = decode(l_dummy, 'x', 'Y')
3867: where funding_source_id = l_funding_out_rec.funding_source_id;
3868:

Line 4659: update oke_k_funding_sources

4655:
4656: --
4657: -- Update initial amount and pa_flag
4658: --
4659: update oke_k_funding_sources
4660: set initial_amount = l_agreement.amount,
4661: funding_across_ou = decode(l_dummy, 'x', 'Y')
4662: where funding_source_id = l_funding_out_rec.funding_source_id;
4663: