DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ASSET_CALC_PVT

Line 1: PACKAGE BODY FA_ASSET_CALC_PVT as

1: PACKAGE BODY FA_ASSET_CALC_PVT as
2: /* $Header: FAVCALB.pls 120.138.12010000.9 2009/01/21 10:22:09 pmadas ship $ */
3:
4: G_primary_new_cost NUMBER;
5: G_primary_salvage_value NUMBER;

Line 60: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_fin_info';

56: x_new_bonus_amount number;
57: l_rc number;
58:
59: l_trxs_exist VARCHAR2(1);
60: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_fin_info';
61: l_last_trx_count number;
62:
63: l_deprn_reserve_exists number := 0;--intialized bug 5260170
64:

Line 1939: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_new_amounts';

1935: ) RETURN BOOLEAN IS
1936:
1937: l_reval_ceiling_adj NUMBER; -- BUG 2620221
1938:
1939: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_new_amounts';
1940: calc_err EXCEPTION;
1941:
1942: BEGIN
1943:

Line 2044: 'FA_ASSET_CALC_PVT.calc_new_amounts') then

2040:
2041: -- Bug:5154035
2042: if FA_ASSET_VAL_PVT.validate_reval_exists (p_asset_hdr_rec.book_type_code,
2043: p_asset_hdr_rec.asset_id,
2044: 'FA_ASSET_CALC_PVT.calc_new_amounts') then
2045: if (nvl(p_asset_deprn_rec_adj.bonus_ytd_deprn, 0) <> 0 or
2046: nvl(p_asset_deprn_rec_adj.bonus_deprn_reserve, 0) <> 0 or
2047: nvl(p_asset_deprn_rec_adj.deprn_reserve, 0) <> 0 or
2048: nvl(p_asset_deprn_rec_adj.ytd_deprn, 0) <> 0 or

Line 2240: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_derived_amounts';

2236: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2237: ) RETURN BOOLEAN IS
2238:
2239: l_count number := 0;
2240: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_derived_amounts';
2241: calc_err EXCEPTION;
2242:
2243: BEGIN
2244:

Line 2387: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_prorate_date';

2383:
2384: l_count number:= 0;
2385: l_prorate_calendar varchar2(15);
2386: l_fiscal_year_name varchar2(30);
2387: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_prorate_date';
2388: calc_err EXCEPTION;
2389:
2390: BEGIN
2391:

Line 2491: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_deprn_start_date';

2487: ) RETURN BOOLEAN IS
2488:
2489: l_dwaf varchar2(3);
2490: l_fiscal_year_name varchar2(30);
2491: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_deprn_start_date';
2492: calc_err EXCEPTION;
2493:
2494: BEGIN
2495:

Line 2548: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_rec_cost';

2544: between ce.start_date and
2545: nvl(ce.end_date, px_asset_fin_rec_new.date_placed_in_service);
2546:
2547: l_ceiling_type varchar2(30);
2548: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_rec_cost';
2549:
2550: l_temp_rec_cost number;
2551:
2552: calc_err EXCEPTION;

Line 2634: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_limit';

2630: p_mrc_sob_type_code IN VARCHAR2,
2631: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2632: ) RETURN BOOLEAN IS
2633:
2634: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_limit';
2635: calc_err EXCEPTION;
2636:
2637: BEGIN
2638:

Line 2893: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_itc_info';

2889: l_basis_reduction_rate number;
2890: l_itc_basis number;
2891: l_itc_basis_reduction_amount number;
2892: l_ceiling_limit number := 0;
2893: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_itc_info';
2894: calc_err EXCEPTION;
2895:
2896: BEGIN
2897:

Line 2964: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_salvage_value';

2960: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2961: ) RETURN BOOLEAN IS
2962:
2963: calc_err EXCEPTION;
2964: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_salvage_value';
2965:
2966: BEGIN
2967:
2968: if (p_log_level_rec.statement_level) then

Line 3162: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';

3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3159: ) RETURN BOOLEAN IS
3160:
3161: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3162: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3163:
3164: CURSOR RATE_DEF IS
3165: SELECT DISTINCT RATE_SOURCE_RULE
3166: FROM FA_METHODS

Line 3467: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_flags';

3463: l_dep_flag_thid number;
3464: l_count_dep_flag number;
3465:
3466: l_sty_success varchar2(3) := 'NO';
3467: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_flags';
3468:
3469: calc_err EXCEPTION;
3470:
3471: BEGIN

Line 3768: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_info';

3764: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3765: and transaction_header_id_out is NULL
3766: and deprn_method_code = px_asset_fin_rec_new.deprn_method_code;
3767:
3768: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_info';
3769: calc_err EXCEPTION;
3770:
3771: BEGIN
3772:

Line 4064: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_group_info';

4060: WHERE GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4061: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4062: AND TRANSACTION_HEADER_ID_OUT is NULL;
4063:
4064: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_group_info';
4065:
4066: l_member_exists VARCHAR2(1) := null;
4067:
4068: calc_err EXCEPTION;

Line 4368: calling_fn => 'fa_asset_calc_pvt.calc_group_info',

4364: if ((px_asset_fin_rec_new.recognize_gain_loss = 'NO') or
4365: (px_asset_fin_rec_new.terminal_gain_loss <> 'YES')) and
4366: (px_asset_fin_rec_new.member_rollup_flag = 'Y') then
4367: fa_srvr_msg.add_message(
4368: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
4369: name => 'FA_INVALID_PARAMETER',
4370: token1 => 'VALUE',
4371: value1 => px_asset_fin_rec_new.recognize_gain_loss,
4372: token2 => 'PARAM',

Line 4375: calling_fn => 'fa_asset_calc_pvt.calc_group_info',

4371: value1 => px_asset_fin_rec_new.recognize_gain_loss,
4372: token2 => 'PARAM',
4373: value2 => 'RECOGNIZE_GAIN_LOSS');
4374: fa_srvr_msg.add_message(
4375: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
4376: name => 'FA_INVALID_PARAMETER',
4377: token1 => 'VALUE',
4378: value1 => px_asset_fin_rec_new.terminal_gain_loss,
4379: token2 => 'PARAM',

Line 4382: calling_fn => 'fa_asset_calc_pvt.calc_group_info',

4378: value1 => px_asset_fin_rec_new.terminal_gain_loss,
4379: token2 => 'PARAM',
4380: value2 => 'TERMINAL_GAIN_LOSS');
4381: fa_srvr_msg.add_message(
4382: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
4383: name => 'FA_INVALID_PARAMETER',
4384: token1 => 'VALUE',
4385: value1 => px_asset_fin_rec_new.member_rollup_flag,
4386: token2 => 'PARAM',

Line 4505: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_member_info';

4501: l_reduce_retirement_flag varchar2(1);
4502: l_disabled_flag varchar2(1); --HH
4503: l_over_depreciate_option varchar2(30); --hh
4504:
4505: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_member_info';
4506:
4507: calc_member_err EXCEPTION;
4508:
4509: BEGIN

Line 4580: calling_fn => 'fa_asset_calc_pvt.calc_member_info',

4576: -- This is a case in which tracking method is not assigned to the group
4577: -- to which this member asset belongs...
4578:
4579: fa_srvr_msg.add_message(
4580: calling_fn => 'fa_asset_calc_pvt.calc_member_info',
4581: name => 'FA_BOOK_INEFFECTIVE_BOOK');
4582: raise calc_member_err;
4583:
4584: else

Line 4719: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';

4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4717: ) return boolean IS
4718:
4719: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
4720:
4721: BEGIN
4722:
4723: --

Line 4771: END FA_ASSET_CALC_PVT;

4767: END calc_standalone_info;
4768:
4769:
4770:
4771: END FA_ASSET_CALC_PVT;