DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 2050: l_ctxt_val_tbl := okl_execute_formula_pub.g_additional_parameters;

2046: l_acc_gen_tbl(i).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
2047: l_acc_gen_tbl(i).source_id := x_tclv_tbl(i).id;
2048:
2049: --Bug# 6189396
2050: l_ctxt_val_tbl := okl_execute_formula_pub.g_additional_parameters;
2051:
2052: l_dist_info_tbl(i).SOURCE_ID := x_tclv_tbl(i).id;
2053: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
2054: l_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';

Line 11410: okl_execute_formula_pub.g_additional_parameters(1).name := 'SPLIT_ASSET_DEPRN_RESRVE';

11406: l_asset_deprn_rec.bonus_ytd_deprn:=l_asset_deprn_rec.bonus_ytd_deprn - (l_asset_deprn_rec.bonus_ytd_deprn-(l_asset_deprn_rec.bonus_ytd_deprn*l_split_factor));
11407: l_asset_deprn_rec.bonus_deprn_reserve:=l_asset_deprn_rec.bonus_deprn_reserve - (l_asset_deprn_rec.bonus_deprn_reserve-(l_asset_deprn_rec.bonus_deprn_reserve*l_split_factor));
11408:
11409: -- Bug# 6189396 -- start
11410: okl_execute_formula_pub.g_additional_parameters(1).name := 'SPLIT_ASSET_DEPRN_RESRVE';
11411: okl_execute_formula_pub.g_additional_parameters(1).value := to_char(l_asset_deprn_rec.deprn_reserve);
11412: -- Bug# 6189396 -- end
11413:
11414: ---------------------------------------------------------------------------------------

Line 11411: okl_execute_formula_pub.g_additional_parameters(1).value := to_char(l_asset_deprn_rec.deprn_reserve);

11407: l_asset_deprn_rec.bonus_deprn_reserve:=l_asset_deprn_rec.bonus_deprn_reserve - (l_asset_deprn_rec.bonus_deprn_reserve-(l_asset_deprn_rec.bonus_deprn_reserve*l_split_factor));
11408:
11409: -- Bug# 6189396 -- start
11410: okl_execute_formula_pub.g_additional_parameters(1).name := 'SPLIT_ASSET_DEPRN_RESRVE';
11411: okl_execute_formula_pub.g_additional_parameters(1).value := to_char(l_asset_deprn_rec.deprn_reserve);
11412: -- Bug# 6189396 -- end
11413:
11414: ---------------------------------------------------------------------------------------
11415: --Bug# 3156924 : Due to partial retirement ytd_deprn may get greater than deprn_reserve

Line 14565: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,

14561: IF p_cle_tbl.COUNT > 0 THEN
14562: FOR i IN p_cle_tbl.FIRST..p_cle_tbl.LAST
14563: LOOP
14564: --calculate and update subsidised OEC , Capital Amount, Residual Value
14565: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14566: p_init_msg_list => p_init_msg_list,
14567: x_return_status => x_return_status,
14568: x_msg_count => x_msg_count,
14569: x_msg_data => x_msg_data,

Line 14581: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,

14577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14578: RAISE OKL_API.G_EXCEPTION_ERROR;
14579: END IF;
14580:
14581: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14582: p_init_msg_list => p_init_msg_list,
14583: x_return_status => x_return_status,
14584: x_msg_count => x_msg_count,
14585: x_msg_data => x_msg_data,

Line 14597: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,

14593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14594: RAISE OKL_API.G_EXCEPTION_ERROR;
14595: END IF;
14596:
14597: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14598: p_init_msg_list => p_init_msg_list,
14599: x_return_status => x_return_status,
14600: x_msg_count => x_msg_count,
14601: x_msg_data => x_msg_data,

Line 15518: okl_execute_formula_pub.g_additional_parameters(1).name := '';

15514: RAISE OKL_API.G_EXCEPTION_ERROR;
15515: END IF; */
15516:
15517: -- Bug# 6189396 -- start
15518: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15519: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15520: -- Bug# 6189396 -- end
15521:
15522: End If;

Line 15519: okl_execute_formula_pub.g_additional_parameters(1).value := null;

15515: END IF; */
15516:
15517: -- Bug# 6189396 -- start
15518: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15519: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15520: -- Bug# 6189396 -- end
15521:
15522: End If;
15523: --End Bug# 4028371

Line 15545: okl_execute_formula_pub.g_additional_parameters(1).name := '';

15541: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
15542: RAISE OKL_API.G_EXCEPTION_ERROR;
15543: END IF;
15544:
15545: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15546: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15547: END IF; --l_fa_exists
15548: --5. Tie back new asset records to OKL
15549: --dbms_output.put_line('before fetching the cim_id for FA link');

Line 15546: okl_execute_formula_pub.g_additional_parameters(1).value := null;

15542: RAISE OKL_API.G_EXCEPTION_ERROR;
15543: END IF;
15544:
15545: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15546: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15547: END IF; --l_fa_exists
15548: --5. Tie back new asset records to OKL
15549: --dbms_output.put_line('before fetching the cim_id for FA link');
15550: OPEN c_cim(l_txdv_rec.id);