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 560: from oke_k_funding_sources

556: p_agreement_flag OUT NOCOPY VARCHAR2
557: ) is
558: cursor c_funding_source_id is
559: select rowid, pool_party_id, agreement_flag
560: from oke_k_funding_sources
561: where funding_source_id = p_funding_source_id;
562:
563: BEGIN
564:

Line 2212: from oke_k_funding_sources

2208: ) is
2209:
2210: cursor c_funding_row is
2211: select *
2212: from oke_k_funding_sources
2213: where funding_source_id = p_funding_in_rec.funding_source_id
2214: FOR UPDATE OF funding_source_id NOWAIT;
2215:
2216: l_funding_row c_funding_row%ROWTYPE;

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

2844:
2845: --
2846: -- Procedure create_funding
2847: --
2848: -- Description: This procedure is used to insert record in OKE_K_FUNDING_SOURCES table
2849: --
2850: -- Calling subprograms: OKE_API.start_activity
2851: -- OKE_API.end_activity
2852: -- OKE_FUNDINGSOURCE_PVT.insert_row

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

3270:
3271: --
3272: -- Procedure: delete_funding
3273: --
3274: -- Description: This procedure is used to delete record in OKE_K_FUNDING_SOURCES table
3275: --
3276: -- Calling subprograms: OKE_API.start_activity
3277: -- OKE_API.end_activity
3278: -- OKE_FUNDINGSOURCE_PVT.delete_row

Line 4061: update oke_k_funding_sources

4057:
4058: --
4059: -- Update initial amount and pa_flag
4060: --
4061: update oke_k_funding_sources
4062: set initial_amount = p_amount,
4063: funding_across_ou = decode(l_dummy, 'x', 'Y')
4064: where funding_source_id = l_funding_out_rec.funding_source_id;
4065:

Line 4873: update oke_k_funding_sources

4869:
4870: --
4871: -- Update initial amount and pa_flag
4872: --
4873: update oke_k_funding_sources
4874: set initial_amount = l_agreement.amount,
4875: funding_across_ou = decode(l_dummy, 'x', 'Y')
4876: where funding_source_id = l_funding_out_rec.funding_source_id;
4877: