DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 2022: l_ctxt_val_tbl := okl_execute_formula_pub.g_additional_parameters;

2018: l_acc_gen_tbl(i).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
2019: l_acc_gen_tbl(i).source_id := x_tclv_tbl(i).id;
2020:
2021: --Bug# 6189396
2022: l_ctxt_val_tbl := okl_execute_formula_pub.g_additional_parameters;
2023:
2024: l_dist_info_tbl(i).SOURCE_ID := x_tclv_tbl(i).id;
2025: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
2026: l_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';

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

11353: 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));
11354: 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));
11355:
11356: -- Bug# 6189396 -- start
11357: okl_execute_formula_pub.g_additional_parameters(1).name := 'SPLIT_ASSET_DEPRN_RESRVE';
11358: okl_execute_formula_pub.g_additional_parameters(1).value := to_char(l_asset_deprn_rec.deprn_reserve);
11359: -- Bug# 6189396 -- end
11360:
11361: ---------------------------------------------------------------------------------------

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

11354: 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));
11355:
11356: -- Bug# 6189396 -- start
11357: okl_execute_formula_pub.g_additional_parameters(1).name := 'SPLIT_ASSET_DEPRN_RESRVE';
11358: okl_execute_formula_pub.g_additional_parameters(1).value := to_char(l_asset_deprn_rec.deprn_reserve);
11359: -- Bug# 6189396 -- end
11360:
11361: ---------------------------------------------------------------------------------------
11362: --Bug# 3156924 : Due to partial retirement ytd_deprn may get greater than deprn_reserve

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

14508: IF p_cle_tbl.COUNT > 0 THEN
14509: FOR i IN p_cle_tbl.FIRST..p_cle_tbl.LAST
14510: LOOP
14511: --calculate and update subsidised OEC , Capital Amount, Residual Value
14512: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14513: p_init_msg_list => p_init_msg_list,
14514: x_return_status => x_return_status,
14515: x_msg_count => x_msg_count,
14516: x_msg_data => x_msg_data,

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

14524: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14525: RAISE OKL_API.G_EXCEPTION_ERROR;
14526: END IF;
14527:
14528: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14529: p_init_msg_list => p_init_msg_list,
14530: x_return_status => x_return_status,
14531: x_msg_count => x_msg_count,
14532: x_msg_data => x_msg_data,

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

14540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14541: RAISE OKL_API.G_EXCEPTION_ERROR;
14542: END IF;
14543:
14544: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => p_api_version,
14545: p_init_msg_list => p_init_msg_list,
14546: x_return_status => x_return_status,
14547: x_msg_count => x_msg_count,
14548: x_msg_data => x_msg_data,

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

15422: RAISE OKL_API.G_EXCEPTION_ERROR;
15423: END IF; */
15424:
15425: -- Bug# 6189396 -- start
15426: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15427: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15428: -- Bug# 6189396 -- end
15429:
15430: End If;

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

15423: END IF; */
15424:
15425: -- Bug# 6189396 -- start
15426: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15427: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15428: -- Bug# 6189396 -- end
15429:
15430: End If;
15431: --End Bug# 4028371

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

15449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
15450: RAISE OKL_API.G_EXCEPTION_ERROR;
15451: END IF;
15452:
15453: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15454: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15455: END IF; --l_fa_exists
15456: --5. Tie back new asset records to OKL
15457: --dbms_output.put_line('before fetching the cim_id for FA link');

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

15450: RAISE OKL_API.G_EXCEPTION_ERROR;
15451: END IF;
15452:
15453: okl_execute_formula_pub.g_additional_parameters(1).name := '';
15454: okl_execute_formula_pub.g_additional_parameters(1).value := null;
15455: END IF; --l_fa_exists
15456: --5. Tie back new asset records to OKL
15457: --dbms_output.put_line('before fetching the cim_id for FA link');
15458: OPEN c_cim(l_txdv_rec.id);