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.211.12020000.7 2013/03/19 18:02:38 dvjoshi ship $ */
3:
4: G_primary_new_cost NUMBER;
5: G_primary_salvage_value NUMBER;

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

63: x_new_impairment_amount number;
64: l_rc number;
65:
66: l_trxs_exist VARCHAR2(1);
67: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_fin_info';
68: l_last_trx_count number;
69:
70: l_deprn_reserve_exists number;
71:

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

2598: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2599:
2600: l_reval_ceiling_adj NUMBER; -- BUG 2620221
2601:
2602: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_new_amounts';
2603: calc_err EXCEPTION;
2604:
2605: BEGIN
2606:

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

2924: p_mrc_sob_type_code IN VARCHAR2
2925: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2926:
2927: l_count number := 0;
2928: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_derived_amounts';
2929: calc_err EXCEPTION;
2930:
2931: BEGIN
2932:

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

3076:
3077: l_count number:= 0;
3078: l_prorate_calendar varchar2(15);
3079: l_fiscal_year_name varchar2(30);
3080: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_prorate_date';
3081: calc_err EXCEPTION;
3082:
3083: BEGIN
3084:

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

3178: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3179:
3180: l_dwaf varchar2(3);
3181: l_fiscal_year_name varchar2(30);
3182: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_deprn_start_date';
3183: calc_err EXCEPTION;
3184:
3185: BEGIN
3186:

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

3233: between ce.start_date and
3234: nvl(ce.end_date, px_asset_fin_rec_new.date_placed_in_service);
3235:
3236: l_ceiling_type varchar2(30);
3237: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_rec_cost';
3238:
3239: l_temp_rec_cost number;
3240:
3241: calc_err EXCEPTION;

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

3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3320: p_mrc_sob_type_code IN VARCHAR2
3321: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3322:
3323: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_limit';
3324: calc_err EXCEPTION;
3325:
3326: BEGIN
3327:

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

3644: l_basis_reduction_rate number;
3645: l_itc_basis number;
3646: l_itc_basis_reduction_amount number;
3647: l_ceiling_limit number := 0;
3648: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_itc_info';
3649: calc_err EXCEPTION;
3650:
3651: BEGIN
3652:

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

3716: p_mrc_sob_type_code IN VARCHAR2
3717: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3718:
3719: calc_err EXCEPTION;
3720: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_salvage_value';
3721:
3722: BEGIN
3723:
3724: if (p_log_level_rec.statement_level) then

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

3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3920:
3921: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3922: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3923:
3924: CURSOR RATE_DEF IS
3925: SELECT DISTINCT RATE_SOURCE_RULE
3926: FROM FA_METHODS

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

4221: l_dep_flag_thid number;
4222: l_count_dep_flag number;
4223:
4224: l_sty_success varchar2(3) := 'NO';
4225: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_flags';
4226:
4227: calc_err EXCEPTION;
4228:
4229: BEGIN

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

4525: where asset_id = p_asset_hdr_rec.asset_id
4526: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
4527: and transaction_header_id_out is NULL;
4528:
4529: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_info';
4530: calc_err EXCEPTION;
4531:
4532: BEGIN
4533:

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

4828: WHERE GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4829: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4830: AND TRANSACTION_HEADER_ID_OUT is NULL;
4831:
4832: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_group_info';
4833:
4834: l_member_exists VARCHAR2(1) := null;
4835:
4836: calc_err EXCEPTION;

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

5133: ((px_asset_fin_rec_new.member_rollup_flag = 'Y' and
5134: nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')
5135: ) then
5136: fa_srvr_msg.add_message(
5137: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
5138: name => 'FA_INVALID_PARAMETER',
5139: token1 => 'VALUE',
5140: value1 => px_asset_fin_rec_new.recognize_gain_loss,
5141: token2 => 'PARAM',

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

5140: value1 => px_asset_fin_rec_new.recognize_gain_loss,
5141: token2 => 'PARAM',
5142: value2 => 'RECOGNIZE_GAIN_LOSS', p_log_level_rec => p_log_level_rec);
5143: fa_srvr_msg.add_message(
5144: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
5145: name => 'FA_INVALID_PARAMETER',
5146: token1 => 'VALUE',
5147: value1 => px_asset_fin_rec_new.terminal_gain_loss,
5148: token2 => 'PARAM',

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

5147: value1 => px_asset_fin_rec_new.terminal_gain_loss,
5148: token2 => 'PARAM',
5149: value2 => 'TERMINAL_GAIN_LOSS', p_log_level_rec => p_log_level_rec);
5150: fa_srvr_msg.add_message(
5151: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
5152: name => 'FA_INVALID_PARAMETER',
5153: token1 => 'VALUE',
5154: value1 => px_asset_fin_rec_new.member_rollup_flag,
5155: token2 => 'PARAM',

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

5270: l_reduce_retirement_flag varchar2(1);
5271: l_disabled_flag varchar2(1); --HH
5272: l_over_depreciate_option varchar2(30); --hh
5273:
5274: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_member_info';
5275:
5276: calc_member_err EXCEPTION;
5277:
5278: BEGIN

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

5316: If ((p_trans_rec.transaction_type_code = 'ADDITION' and
5317: nvl(l_reduce_addition_flag,'N') = 'N') or
5318: ((p_trans_rec.transaction_type_code = 'ADJUSTMENT') and
5319: nvl(l_reduce_adjustment_flag,'N') = 'N') )then fa_srvr_msg.add_message(
5320: calling_fn => 'fa_asset_calc_pvt.calc_member_info',
5321: name => 'FA_BOOK_NO_REDUCTION', p_log_level_rec => p_log_level_rec);
5322: raise calc_member_err;
5323: end if;
5324: end if;

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

5358: -- This is a case in which tracking method is not assigned to the group
5359: -- to which this member asset belongs...
5360:
5361: fa_srvr_msg.add_message(
5362: calling_fn => 'fa_asset_calc_pvt.calc_member_info',
5363: name => 'FA_BOOK_INEFFECTIVE_BOOK', p_log_level_rec => p_log_level_rec);
5364: raise calc_member_err;
5365:
5366: else

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

5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5506:
5507: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
5508:
5509: BEGIN
5510:
5511: --

Line 5559: END FA_ASSET_CALC_PVT;

5555: END calc_standalone_info;
5556:
5557:
5558:
5559: END FA_ASSET_CALC_PVT;