DBA Data[Home] [Help]

APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_FUNDING_UTIL_PKG

Line 384: OKE_FUNDING_UTIL_PKG.get_conversion_rate(x_from_currency => p_from_currency ,

380: IF (upper(p_conversion_type) <> 'USER') THEN
381:
382: IF (p_conversion_rate is null) THEN
383:
384: OKE_FUNDING_UTIL_PKG.get_conversion_rate(x_from_currency => p_from_currency ,
385: x_to_currency => p_to_currency ,
386: x_conversion_type => p_conversion_type ,
387: x_conversion_date => p_conversion_date ,
388: x_conversion_rate => p_conversion_rate ,

Line 1409: OKE_FUNDING_UTIL_PKG.validate_source_pool_amount(x_first_amount => p_amount ,

1405: ELSE
1406: l_flag := 'Y';
1407: END IF;
1408:
1409: OKE_FUNDING_UTIL_PKG.validate_source_pool_amount(x_first_amount => p_amount ,
1410: x_pool_party_id => p_pool_party_id ,
1411: x_source_id => p_funding_source_id ,
1412: x_new_flag => l_flag ,
1413: x_return_status => l_return_status );

Line 1425: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'START' ,

1421:
1422: -- bug 3346170
1423: /* ELSE
1424:
1425: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'START' ,
1426: x_pool_party_id => p_pool_party_id ,
1427: x_date => p_start_date ,
1428: x_return_status => l_return_status );
1429:

Line 1448: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'END' ,

1444: );
1445:
1446: ELSE
1447:
1448: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'END' ,
1449: x_pool_party_id => p_pool_party_id ,
1450: x_date => p_end_date ,
1451: x_return_status => l_return_status );
1452:

Line 1679: OKE_FUNDING_UTIL_PKG.validate_start_end_date(x_start_date => p_funding_in_rec.start_date_active ,

1675: --
1676: -- Validate start and end date range
1677: --
1678:
1679: OKE_FUNDING_UTIL_PKG.validate_start_end_date(x_start_date => p_funding_in_rec.start_date_active ,
1680: x_end_date => p_funding_in_rec.end_date_active ,
1681: x_return_status => l_return_status
1682: );
1683:

Line 1771: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,

1767: --
1768: -- Validate hard limit against funding amount
1769: --
1770:
1771: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,
1772: x_hard_limit => p_funding_in_rec.hard_limit ,
1773: x_return_status => l_return_status
1774: );
1775:

Line 1786: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,

1782: RAISE G_EXCEPTION_HALT_VALIDATION;
1783:
1784: END IF;
1785:
1786: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,
1787: x_hard_limit => p_funding_in_rec.revenue_hard_limit ,
1788: x_return_status => l_return_status
1789: );
1790:

Line 1807: OKE_FUNDING_UTIL_PKG.validate_source_alloc_limit(x_source_id => p_funding_in_rec.funding_source_id ,

1803: --
1804:
1805: IF (p_funding_in_rec.funding_source_id is not null) THEN
1806:
1807: OKE_FUNDING_UTIL_PKG.validate_source_alloc_limit(x_source_id => p_funding_in_rec.funding_source_id ,
1808: x_amount => nvl(p_funding_in_rec.hard_limit, 0) ,
1809: x_revenue_amount => nvl(p_funding_in_rec.revenue_hard_limit, 0) ,
1810: x_type => l_type ,
1811: x_return_status => l_return_status

Line 1856: OKE_FUNDING_UTIL_PKG.validate_source_alloc_amount(x_source_id => p_funding_in_rec.funding_source_id ,

1852: --
1853: -- Validate funding amount
1854: --
1855:
1856: OKE_FUNDING_UTIL_PKG.validate_source_alloc_amount(x_source_id => p_funding_in_rec.funding_source_id ,
1857: x_amount => nvl(p_funding_in_rec.amount,0) ,
1858: x_return_status => l_return_status
1859: );
1860:

Line 1884: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'START' ,

1880: -- Validate the date range
1881: --
1882: -- bug 3346170
1883: /*
1884: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'START' ,
1885: x_funding_source_id => p_funding_in_rec.funding_source_id ,
1886: x_date => p_funding_in_rec.start_date_active ,
1887: x_return_status => l_return_status);
1888:

Line 1908: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'END' ,

1904: RAISE G_EXCEPTION_HALT_VALIDATION;
1905:
1906: END IF;
1907:
1908: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'END' ,
1909: x_funding_source_id => p_funding_in_rec.funding_source_id ,
1910: x_date => p_funding_in_rec.end_date_active ,
1911: x_return_status => l_return_status);
1912:

Line 3453: -- OKE_FUNDING_UTIL_PKG.check_single_org

3449: -- Calling subprograms: OKE_API.start_activity
3450: -- OKE_API.end_activity
3451: -- OKE_FUNDSOURCE_PVT.create_funding
3452: -- OKE_ALLOCATION_PVT.add_allocation
3453: -- OKE_FUNDING_UTIL_PKG.check_single_org
3454: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3455: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3456: -- validate_pool_party_id
3457: -- get_min_unit

Line 3454: -- OKE_FUNDING_UTIL_PKG.update_source_flag

3450: -- OKE_API.end_activity
3451: -- OKE_FUNDSOURCE_PVT.create_funding
3452: -- OKE_ALLOCATION_PVT.add_allocation
3453: -- OKE_FUNDING_UTIL_PKG.check_single_org
3454: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3455: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3456: -- validate_pool_party_id
3457: -- get_min_unit
3458: -- lock_agreement

Line 3455: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

3451: -- OKE_FUNDSOURCE_PVT.create_funding
3452: -- OKE_ALLOCATION_PVT.add_allocation
3453: -- OKE_FUNDING_UTIL_PKG.check_single_org
3454: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3455: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3456: -- validate_pool_party_id
3457: -- get_min_unit
3458: -- lock_agreement
3459: -- update_agreement_reference

Line 4004: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,

4000:
4001: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4002: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4003:
4004: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,
4005: x_version_add => 1 ,
4006: x_commit => OKE_API.G_FALSE
4007: );
4008:

Line 4077: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,

4073: --
4074: -- update the agreement_flag in OKE_FUNDING_SOURCES table
4075: --
4076:
4077: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,
4078: x_commit => OKE_API.G_FALSE
4079: );
4080:
4081: IF FND_API.to_boolean(p_commit) THEN

Line 4131: -- OKE_FUNDING_UTIL_PKG.check_single_org

4127: -- Calling subprograms: OKE_API.start_activity
4128: -- OKE_API.end_activity
4129: -- OKE_FUNDSOURCE_PVT.create_funding
4130: -- OKE_ALLOCATION_PVT.add_allocation
4131: -- OKE_FUNDING_UTIL_PKG.check_single_org
4132: -- OKE_FUNDING_UTIL_PKG.update_source_flag
4133: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4134: -- validate_parameters
4135: -- lock_agreement

Line 4132: -- OKE_FUNDING_UTIL_PKG.update_source_flag

4128: -- OKE_API.end_activity
4129: -- OKE_FUNDSOURCE_PVT.create_funding
4130: -- OKE_ALLOCATION_PVT.add_allocation
4131: -- OKE_FUNDING_UTIL_PKG.check_single_org
4132: -- OKE_FUNDING_UTIL_PKG.update_source_flag
4133: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4134: -- validate_parameters
4135: -- lock_agreement
4136: -- validate_agreement_party

Line 4133: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

4129: -- OKE_FUNDSOURCE_PVT.create_funding
4130: -- OKE_ALLOCATION_PVT.add_allocation
4131: -- OKE_FUNDING_UTIL_PKG.check_single_org
4132: -- OKE_FUNDING_UTIL_PKG.update_source_flag
4133: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4134: -- validate_parameters
4135: -- lock_agreement
4136: -- validate_agreement_party
4137: -- get_k_currency

Line 4629: OKE_FUNDING_UTIL_PKG.check_single_org(l_single_org_flag);

4625: --
4626: -- check if it is a single org implementation
4627: --
4628:
4629: OKE_FUNDING_UTIL_PKG.check_single_org(l_single_org_flag);
4630:
4631: --
4632: -- get funding source amount
4633: --

Line 4819: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,

4815:
4816: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4817: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4818:
4819: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,
4820: x_version_add => 1 ,
4821: x_commit => OKE_API.G_FALSE
4822: );
4823:

Line 4892: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,

4888: --
4889: -- update the agreement_flag in OKE_FUNDING_SOURCES table
4890: --
4891:
4892: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,
4893: x_commit => OKE_API.G_FALSE
4894: );
4895:
4896: IF FND_API.to_boolean(p_commit) THEN