DBA Data[Home] [Help]

APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_FUNDING_UTIL_PKG

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

366: IF (upper(p_conversion_type) <> 'USER') THEN
367:
368: IF (p_conversion_rate is null) THEN
369:
370: OKE_FUNDING_UTIL_PKG.get_conversion_rate(x_from_currency => p_from_currency ,
371: x_to_currency => p_to_currency ,
372: x_conversion_type => p_conversion_type ,
373: x_conversion_date => p_conversion_date ,
374: x_conversion_rate => p_conversion_rate ,

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

1391: ELSE
1392: l_flag := 'Y';
1393: END IF;
1394:
1395: OKE_FUNDING_UTIL_PKG.validate_source_pool_amount(x_first_amount => p_amount ,
1396: x_pool_party_id => p_pool_party_id ,
1397: x_source_id => p_funding_source_id ,
1398: x_new_flag => l_flag ,
1399: x_return_status => l_return_status );

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

1407:
1408: -- bug 3346170
1409: /* ELSE
1410:
1411: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'START' ,
1412: x_pool_party_id => p_pool_party_id ,
1413: x_date => p_start_date ,
1414: x_return_status => l_return_status );
1415:

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

1430: );
1431:
1432: ELSE
1433:
1434: OKE_FUNDING_UTIL_PKG.validate_source_pool_date(x_start_end => 'END' ,
1435: x_pool_party_id => p_pool_party_id ,
1436: x_date => p_end_date ,
1437: x_return_status => l_return_status );
1438:

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

1661: --
1662: -- Validate start and end date range
1663: --
1664:
1665: OKE_FUNDING_UTIL_PKG.validate_start_end_date(x_start_date => p_funding_in_rec.start_date_active ,
1666: x_end_date => p_funding_in_rec.end_date_active ,
1667: x_return_status => l_return_status
1668: );
1669:

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

1753: --
1754: -- Validate hard limit against funding amount
1755: --
1756:
1757: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,
1758: x_hard_limit => p_funding_in_rec.hard_limit ,
1759: x_return_status => l_return_status
1760: );
1761:

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

1768: RAISE G_EXCEPTION_HALT_VALIDATION;
1769:
1770: END IF;
1771:
1772: OKE_FUNDING_UTIL_PKG.validate_hard_limit(x_fund_amount => p_funding_in_rec.amount ,
1773: x_hard_limit => p_funding_in_rec.revenue_hard_limit ,
1774: x_return_status => l_return_status
1775: );
1776:

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

1789: --
1790:
1791: IF (p_funding_in_rec.funding_source_id is not null) THEN
1792:
1793: OKE_FUNDING_UTIL_PKG.validate_source_alloc_limit(x_source_id => p_funding_in_rec.funding_source_id ,
1794: x_amount => nvl(p_funding_in_rec.hard_limit, 0) ,
1795: x_revenue_amount => nvl(p_funding_in_rec.revenue_hard_limit, 0) ,
1796: x_type => l_type ,
1797: x_return_status => l_return_status

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

1838: --
1839: -- Validate funding amount
1840: --
1841:
1842: OKE_FUNDING_UTIL_PKG.validate_source_alloc_amount(x_source_id => p_funding_in_rec.funding_source_id ,
1843: x_amount => nvl(p_funding_in_rec.amount,0) ,
1844: x_return_status => l_return_status
1845: );
1846:

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

1866: -- Validate the date range
1867: --
1868: -- bug 3346170
1869: /*
1870: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'START' ,
1871: x_funding_source_id => p_funding_in_rec.funding_source_id ,
1872: x_date => p_funding_in_rec.start_date_active ,
1873: x_return_status => l_return_status);
1874:

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

1890: RAISE G_EXCEPTION_HALT_VALIDATION;
1891:
1892: END IF;
1893:
1894: OKE_FUNDING_UTIL_PKG.validate_source_alloc_date(x_start_end => 'END' ,
1895: x_funding_source_id => p_funding_in_rec.funding_source_id ,
1896: x_date => p_funding_in_rec.end_date_active ,
1897: x_return_status => l_return_status);
1898:

Line 3289: -- OKE_FUNDING_UTIL_PKG.check_single_org

3285: -- Calling subprograms: OKE_API.start_activity
3286: -- OKE_API.end_activity
3287: -- OKE_FUNDSOURCE_PVT.create_funding
3288: -- OKE_ALLOCATION_PVT.add_allocation
3289: -- OKE_FUNDING_UTIL_PKG.check_single_org
3290: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3291: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3292: -- validate_pool_party_id
3293: -- get_min_unit

Line 3290: -- OKE_FUNDING_UTIL_PKG.update_source_flag

3286: -- OKE_API.end_activity
3287: -- OKE_FUNDSOURCE_PVT.create_funding
3288: -- OKE_ALLOCATION_PVT.add_allocation
3289: -- OKE_FUNDING_UTIL_PKG.check_single_org
3290: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3291: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3292: -- validate_pool_party_id
3293: -- get_min_unit
3294: -- lock_agreement

Line 3291: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

3287: -- OKE_FUNDSOURCE_PVT.create_funding
3288: -- OKE_ALLOCATION_PVT.add_allocation
3289: -- OKE_FUNDING_UTIL_PKG.check_single_org
3290: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3291: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3292: -- validate_pool_party_id
3293: -- get_min_unit
3294: -- lock_agreement
3295: -- update_agreement_reference

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

3803:
3804: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
3805: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
3806:
3807: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,
3808: x_version_add => 1 ,
3809: x_commit => OKE_API.G_FALSE
3810: );
3811:

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

3876: --
3877: -- update the agreement_flag in OKE_FUNDING_SOURCES table
3878: --
3879:
3880: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,
3881: x_commit => OKE_API.G_FALSE
3882: );
3883:
3884: IF FND_API.to_boolean(p_commit) THEN

Line 3934: -- OKE_FUNDING_UTIL_PKG.check_single_org

3930: -- Calling subprograms: OKE_API.start_activity
3931: -- OKE_API.end_activity
3932: -- OKE_FUNDSOURCE_PVT.create_funding
3933: -- OKE_ALLOCATION_PVT.add_allocation
3934: -- OKE_FUNDING_UTIL_PKG.check_single_org
3935: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3936: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3937: -- validate_parameters
3938: -- lock_agreement

Line 3935: -- OKE_FUNDING_UTIL_PKG.update_source_flag

3931: -- OKE_API.end_activity
3932: -- OKE_FUNDSOURCE_PVT.create_funding
3933: -- OKE_ALLOCATION_PVT.add_allocation
3934: -- OKE_FUNDING_UTIL_PKG.check_single_org
3935: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3936: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3937: -- validate_parameters
3938: -- lock_agreement
3939: -- validate_agreement_party

Line 3936: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

3932: -- OKE_FUNDSOURCE_PVT.create_funding
3933: -- OKE_ALLOCATION_PVT.add_allocation
3934: -- OKE_FUNDING_UTIL_PKG.check_single_org
3935: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3936: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
3937: -- validate_parameters
3938: -- lock_agreement
3939: -- validate_agreement_party
3940: -- get_k_currency

Line 4429: OKE_FUNDING_UTIL_PKG.check_single_org(l_single_org_flag);

4425: --
4426: -- check if it is a single org implementation
4427: --
4428:
4429: OKE_FUNDING_UTIL_PKG.check_single_org(l_single_org_flag);
4430:
4431: --
4432: -- get funding source amount
4433: --

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

4601:
4602: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4603: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4604:
4605: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => l_allocation_out_rec.fund_allocation_id ,
4606: x_version_add => 1 ,
4607: x_commit => OKE_API.G_FALSE
4608: );
4609:

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

4674: --
4675: -- update the agreement_flag in OKE_FUNDING_SOURCES table
4676: --
4677:
4678: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => l_funding_out_rec.funding_source_id ,
4679: x_commit => OKE_API.G_FALSE
4680: );
4681:
4682: IF FND_API.to_boolean(p_commit) THEN