APPS.OKE_FUNDING_UTIL_PKG dependencies on OKE_K_FUND_ALLOCATIONS

Line 211: from oke_k_fund_allocations

207: x_return_status OUT NOCOPY varchar2 ) is
208:
209: cursor c_alloc is
210: select nvl(sum(amount), 0)
211: from oke_k_fund_allocations
212: where funding_source_id = x_source_id;
213:
214: cursor c_source is
215: select amount

Line 221: from oke_k_fund_allocations

217: where funding_source_id = x_source_id;
218:
219: cursor c_existing is
220: select amount
221: from oke_k_fund_allocations
222: where fund_allocation_id = x_allocation_id;
223:
224: source_amount number;
225: alloc_amount number := 0;

Line 321: from oke_k_fund_allocations

317:
318:
319: cursor c_alloc is
320: select nvl(sum(hard_limit), 0), nvl(sum(revenue_hard_limit), 0)
321: from oke_k_fund_allocations
322: where funding_source_id = x_source_id;
323:
324: cursor c_source is
325: select nvl(hard_limit, 0), nvl(revenue_hard_limit, 0)

Line 331: from oke_k_fund_allocations

327: where funding_source_id = x_source_id;
328:
329: cursor c_existing is
330: select nvl(hard_limit, 0), nvl(revenue_hard_limit, 0)
331: from oke_k_fund_allocations
332: where fund_allocation_id = x_allocation_id;
333:
334: source_hl_amount number;
335: source_rhl_amount number;

Line 644: from oke_k_fund_allocations

640: x_return_status OUT NOCOPY varchar2 ) is
641:
642: cursor c_start_allocation is
643: select min(nvl(start_date_active, add_months(x_date, -1)))
644: from oke_k_fund_allocations
645: where funding_source_id = x_funding_source_id;
646:
647: cursor c_end_allocation is
648: select max(nvl(end_date_active, add_months(x_date, 1)))

Line 649: from oke_k_fund_allocations

645: where funding_source_id = x_funding_source_id;
646:
647: cursor c_end_allocation is
648: select max(nvl(end_date_active, add_months(x_date, 1)))
649: from oke_k_fund_allocations
650: where funding_source_id = x_funding_source_id;
651:
652: cursor c_scsr is
653: select start_date_active

Line 654: from oke_k_fund_allocations

650: where funding_source_id = x_funding_source_id;
651:
652: cursor c_scsr is
653: select start_date_active
654: from oke_k_fund_allocations
655: where funding_source_id = x_funding_source_id;
656:
657: cursor c_ecsr is
658: select end_date_active

Line 659: from oke_k_fund_allocations

655: where funding_source_id = x_funding_source_id;
656:
657: cursor c_ecsr is
658: select end_date_active
659: from oke_k_fund_allocations
660: where funding_source_id = x_funding_source_id;
661:
662: l_date date;
663: compare_date date;

Line 946: from oke_k_fund_allocations

942: x_return_status OUT NOCOPY varchar2 ) is
943:
944: cursor c_alloc is
945: select nvl(sum(amount), 0)
946: from oke_k_fund_allocations
947: where funding_source_id = x_source_id;
948:
949: l_alloc number;
950:

Line 1036: from oke_k_fund_allocations

1032: x_return_status OUT NOCOPY varchar2 ) is
1033:
1034: cursor c_alloc is
1035: select nvl(sum(hard_limit), 0), nvl(sum(revenue_hard_limit), 0)
1036: from oke_k_fund_allocations
1037: where funding_source_id = x_source_id;
1038:
1039: l_alloc number;
1040: l_revenue_alloc number;

Line 1297: -- Description : This procedure is used to update agreement_version and insert_update_flag of OKE_K_FUND_ALLOCATIONS table

1293:
1294: --
1295: -- Procedure : update_alloc_version
1296: --
1297: -- Description : This procedure is used to update agreement_version and insert_update_flag of OKE_K_FUND_ALLOCATIONS table
1298: --
1299: -- Parameters :
1300: -- (in) x_fund_allocation_id number fund_allocation_id
1301: -- x_version_add number version increment

Line 1312: update oke_k_fund_allocations

1308: ) is
1309:
1310: begin
1311:
1312: update oke_k_fund_allocations
1313: set agreement_version = nvl(agreement_version, 0) + x_version_add,
1314: insert_update_flag = null
1315: where fund_allocation_id = x_fund_allocation_id;
1316: