APPS.OKE_FUNDING_UTIL_PKG dependencies on OKE_K_FUNDING_SOURCES

Line 34: from oke_k_funding_sources

30: where pool_party_id = x_pool_party_id;
31:
32: cursor c_source is
33: select amount
34: from oke_k_funding_sources
35: where funding_source_id = x_source_id;
36:
37: l_amount number;
38: l_available_amount number;

Line 216: from oke_k_funding_sources

212: where funding_source_id = x_source_id;
213:
214: cursor c_source is
215: select amount
216: from oke_k_funding_sources
217: where funding_source_id = x_source_id;
218:
219: cursor c_existing is
220: select amount

Line 326: from oke_k_funding_sources

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)
326: from oke_k_funding_sources
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)

Line 449: from oke_k_funding_sources

445: x_return_status OUT NOCOPY varchar2 ) is
446:
447: cursor c_exist is
448: select 'x'
449: from oke_k_funding_sources
450: where pool_party_id = x_pool_party_id;
451:
452: cursor c_start_date is
453: select nvl(min(start_date_active), add_months(x_date, -1))

Line 454: from oke_k_funding_sources

450: where pool_party_id = x_pool_party_id;
451:
452: cursor c_start_date is
453: select nvl(min(start_date_active), add_months(x_date, -1))
454: from oke_k_funding_sources
455: where pool_party_id = x_pool_party_id;
456:
457: cursor c_end_date is
458: select nvl(max(end_date_active), add_months(x_date, 1))

Line 459: from oke_k_funding_sources

455: where pool_party_id = x_pool_party_id;
456:
457: cursor c_end_date is
458: select nvl(max(end_date_active), add_months(x_date, 1))
459: from oke_k_funding_sources
460: where pool_party_id = x_pool_party_id;
461:
462: compare_date date;
463: l_dummy_value varchar2(1) := '?';

Line 539: from oke_k_funding_sources

535: begin
536:
537: select count(1)
538: into l_count
539: from oke_k_funding_sources
540: where pool_party_id = x_pool_party_id;
541:
542: if l_count > 0 then
543:

Line 757: from oke_k_funding_sources

753: x_return_status OUT NOCOPY varchar2 ) is
754:
755: cursor c_start_date is
756: select nvl(start_date_active, x_date)
757: from oke_k_funding_sources
758: where funding_source_id = x_funding_source_id;
759:
760: cursor c_end_date is
761: select nvl(end_date_active, x_date)

Line 762: from oke_k_funding_sources

758: where funding_source_id = x_funding_source_id;
759:
760: cursor c_end_date is
761: select nvl(end_date_active, x_date)
762: from oke_k_funding_sources
763: where funding_source_id = x_funding_source_id;
764:
765: compare_date date;
766:

Line 1160: from oke_k_funding_sources

1156: x_return_status OUT NOCOPY varchar2 ) is
1157:
1158: cursor c_exist is
1159: select nvl(agreement_flag, 'N')
1160: from oke_k_funding_sources
1161: where funding_source_id = x_funding_source_id;
1162:
1163: begin
1164:

Line 1330: -- Description : This procedure is used to update agreement_flag of OKE_K_FUNDING_SOURCES table

1326:
1327: --
1328: -- Procedure : update_source_flag
1329: --
1330: -- Description : This procedure is used to update agreement_flag of OKE_K_FUNDING_SOURCES table
1331: --
1332: -- Parameters :
1333: -- (in) x_funding_source_id number funding_source_id
1334: -- x_commit varchar2 commit flag

Line 1352: UPDATE oke_k_funding_sources

1348: OPEN c_agr;
1349: FETCH c_agr INTO l_flag;
1350: CLOSE c_agr;
1351:
1352: UPDATE oke_k_funding_sources
1353: SET agreement_flag = l_flag
1354: WHERE funding_source_id = x_funding_source_id;
1355:
1356: IF FND_API.to_boolean(x_commit) THEN

Line 1534: from oke_k_funding_sources

1530: ) is
1531:
1532: cursor c_currency is
1533: select currency_code
1534: from oke_k_funding_sources
1535: where funding_source_id = x_funding_source_id;
1536:
1537: cursor c_min_unit is
1538: select nvl(minimum_accountable_unit, power(10, -1 * precision)),