[Home] [Help]
812: NO_FUND EXCEPTION;
813:
814: cursor c_currency is
815: select currency_code
816: from oke_k_funding_sources
817: where funding_source_id = p_allocation_in_rec.funding_source_id;
818:
819: cursor c_rate is
820: select pa_conversion_rate,
3031: --fnd_client_info.set_org_context(to_number(l_org_id_vc));
3032: mo_global.set_policy_context('S',to_number(l_org_id_vc));
3033:
3034: --
3035: -- update agreement flag of OKE_K_FUNDING_SOURCES table
3036: --
3037:
3038: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3039: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3287: where funding_source_id = p_funding_in_rec.funding_source_id;
3288:
3289: cursor c_source is
3290: select nvl(funding_across_ou, 'N')
3291: from oke_k_funding_sources
3292: where funding_source_id = p_funding_in_rec.funding_source_id;
3293:
3294: cursor c_non_mcb is
3295: select p.segment1
3294: cursor c_non_mcb is
3295: select p.segment1
3296: from pa_projects_all p,
3297: oke_k_fund_allocations f,
3298: oke_k_funding_sources s
3299: where p.project_id = f.project_id
3300: and f.funding_source_id = p_funding_in_rec.funding_source_id
3301: and f.amount <> 0
3302: and f.agreement_version is null
4335: s.currency_code
4336: from oke_k_fund_allocations o,
4337: pa_agreements_all a,
4338: --pa_projects_all p,
4339: oke_k_funding_sources s
4340: -- pa_implementations_all i
4341: where a.agreement_id = p_allocation_in_rec.agreement_id
4342: -- and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4343: and s.funding_source_id = o.funding_source_id
4354: i.multi_currency_billing_flag
4355: from oke_k_fund_allocations o,
4356: pa_agreements_all a,
4357: pa_projects_all p,
4358: oke_k_funding_sources s,
4359: pa_implementations_all i
4360: where a.agreement_id = p_allocation_in_rec.agreement_id
4361: and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4362: and s.funding_source_id = o.funding_source_id