[Home] [Help]
797: NO_FUND EXCEPTION;
798:
799: cursor c_currency is
800: select currency_code
801: from oke_k_funding_sources
802: where funding_source_id = p_allocation_in_rec.funding_source_id;
803:
804: cursor c_rate is
805: select pa_conversion_rate,
3011: --fnd_client_info.set_org_context(to_number(l_org_id_vc));
3012: mo_global.set_policy_context('S',to_number(l_org_id_vc));
3013:
3014: --
3015: -- update agreement flag of OKE_K_FUNDING_SOURCES table
3016: --
3017:
3018: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3019: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3266: where funding_source_id = p_funding_in_rec.funding_source_id;
3267:
3268: cursor c_source is
3269: select nvl(funding_across_ou, 'N')
3270: from oke_k_funding_sources
3271: where funding_source_id = p_funding_in_rec.funding_source_id;
3272:
3273: cursor c_non_mcb is
3274: select p.segment1
3273: cursor c_non_mcb is
3274: select p.segment1
3275: from pa_projects_all p,
3276: oke_k_fund_allocations f,
3277: oke_k_funding_sources s
3278: where p.project_id = f.project_id
3279: and f.funding_source_id = p_funding_in_rec.funding_source_id
3280: and f.amount <> 0
3281: and f.agreement_version is null
4310: s.currency_code
4311: from oke_k_fund_allocations o,
4312: pa_agreements_all a,
4313: --pa_projects_all p,
4314: oke_k_funding_sources s
4315: -- pa_implementations_all i
4316: where a.agreement_id = p_allocation_in_rec.agreement_id
4317: -- and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4318: and s.funding_source_id = o.funding_source_id
4329: i.multi_currency_billing_flag
4330: from oke_k_fund_allocations o,
4331: pa_agreements_all a,
4332: pa_projects_all p,
4333: oke_k_funding_sources s,
4334: pa_implementations_all i
4335: where a.agreement_id = p_allocation_in_rec.agreement_id
4336: and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4337: and s.funding_source_id = o.funding_source_id