eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_CALC_DEPRN_BASIS1_PKG

Line 1: PACKAGE BODY FA_CALC_DEPRN_BASIS1_PKG as

1: PACKAGE BODY FA_CALC_DEPRN_BASIS1_PKG as
2: /* $Header: faxcdb1b.pls 120.67.12010000.4 2009/02/04 14:22:51 souroy ship $ */
3: -- global variables
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_book_type_code fa_deprn_periods.book_type_code%TYPE;

Line 53: l_calling_fn varchar2(35) := 'fa_calc_deprn_basis1_pkg.faxcdb';

49: -- For reduction rate
50: l_member_reduction_rate NUMBER := null;
51: l_member_transaction_flag VARCHAR2(1) := null;
52:
53: l_calling_fn varchar2(35) := 'fa_calc_deprn_basis1_pkg.faxcdb';
54:
55: -- Bug 6665510: FP: Japan Tax Reform Project
56: l_rate_in_use NUMBER;
57: l_old_method_code VARCHAR2(12);

Line 1689: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.CALC_REDUCITON_AMOUNT';

1685: l_chk_count NUMBER := NULL;
1686:
1687: l_group_cost_accounting_flag VARCHAR2(1);
1688:
1689: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.CALC_REDUCITON_AMOUNT';
1690:
1691: no_mid_date_err exception;
1692: calc_reduction_amount_err exception;
1693:

Line 2214: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date

2210: ------------------------------------------------------
2211: -- Add this transaction's amount to queried variables
2212: -- for Group asset
2213: ------------------------------------------------------
2214: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2215: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2216: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2218: then

Line 2215: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)

2211: -- Add this transaction's amount to queried variables
2212: -- for Group asset
2213: ------------------------------------------------------
2214: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2215: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2216: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2218: then
2219:

Line 2216: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'

2212: -- for Group asset
2213: ------------------------------------------------------
2214: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2215: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2216: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2218: then
2219:
2220: -- Check whether this transaction is existing or not.

Line 2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')

2213: ------------------------------------------------------
2214: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2215: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2216: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2218: then
2219:
2220: -- Check whether this transaction is existing or not.
2221: OPEN C_CHK_TRANSACTION (fa_calc_deprn_basis1_pkg.g_rule_in.transaction_header_id);

Line 2221: OPEN C_CHK_TRANSACTION (fa_calc_deprn_basis1_pkg.g_rule_in.transaction_header_id);

2217: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2218: then
2219:
2220: -- Check whether this transaction is existing or not.
2221: OPEN C_CHK_TRANSACTION (fa_calc_deprn_basis1_pkg.g_rule_in.transaction_header_id);
2222: FETCH C_CHK_TRANSACTION into l_chk_count;
2223: CLOSE C_CHK_TRANSACTION;
2224:
2225: if nvl(l_chk_count,0) = 0 then

Line 2242: value=> fa_calc_deprn_basis1_pkg.g_rule_in.reduction_rate

2238:
2239: if p_log_level_rec.statement_level then
2240: fa_debug_pkg.add(fname=>'calc_reduction_amount',
2241: element=>'updated reduction_rate',
2242: value=> fa_calc_deprn_basis1_pkg.g_rule_in.reduction_rate
2243: ,p_log_level_rec => p_log_level_rec);
2244: end if;
2245: end if; -- End of Group
2246:

Line 2629: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_REC_COST';

2625: -- l_period_close_date date;
2626: l_last_recoverable_cost number;
2627: l_last_salvage_value number;
2628:
2629: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_REC_COST';
2630:
2631: grc_err exception;
2632:
2633: begin

Line 2938: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_EOFY_EOP';

2934: l_temp_period_counter number(15);
2935: l_rec_cost number;
2936: l_salvage_value number;
2937:
2938: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_EOFY_EOP';
2939:
2940: l_get_eofy_eop_err exception;
2941:
2942: begin

Line 3092: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST

3088: -------------------------------------------
3089:
3090: h_eofy_period_num := h_num_per_fy;
3091:
3092: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST
3093: (
3094: p_asset_id => p_asset_id,
3095: p_book_type_code => p_book_type_code,
3096: p_fiscal_year => p_fiscal_year -1,

Line 3125: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST

3121: h_eop_period_num := p_period_num -1;
3122: h_eop_fiscal_year := p_fiscal_year;
3123: end if;
3124:
3125: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST
3126: (
3127: p_asset_id => p_asset_id,
3128: p_book_type_code => p_book_type_code,
3129: p_fiscal_year => h_eop_fiscal_year,

Line 3220: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';

3216:
3217: tmp_method_code varchar2(12);
3218: tmp_life_in_months number(4);
3219:
3220: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
3221:
3222: call_deprn_basis_err exception;
3223:
3224: BEGIN

Line 3466: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP

3462: p_eofy_salvage_value is null or
3463: p_eop_recoverable_cost is null or
3464: p_eop_salvage_value is null then
3465:
3466: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP
3467: (
3468: p_asset_id => h_rule_in.asset_id,
3469: p_book_type_code => h_rule_in.book_type_code,
3470: p_fiscal_year => h_rule_in.fiscal_year,

Line 3511: if (not FA_CALC_DEPRN_BASIS1_PKG.faxcdb(h_rule_in,

3507: ---------------------------------------------
3508: -- Call faxcdb (Calculate depreciable basis)
3509: -- function
3510: ---------------------------------------------
3511: if (not FA_CALC_DEPRN_BASIS1_PKG.faxcdb(h_rule_in,
3512: h_rule_out
3513: ,p_log_level_rec => p_log_level_rec)) then
3514: raise call_deprn_basis_err;
3515:

Line 3600: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';

3596: px_new_raf IN OUT NOCOPY number,
3597: px_new_formula_factor IN OUT NOCOPY number,
3598: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
3599:
3600: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
3601: l_annual_deprn_rounding_flag varchar2(5);
3602:
3603: call_deprn_basis_err EXCEPTION;
3604: BEGIN

Line 3832: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALC_PROCEEDS';

3828: and ret.transaction_header_id_in = th.member_transaction_header_id
3829: and th.transaction_date_entered >= p_fy_start_date
3830: and th.transaction_date_entered <= p_period_end_date;
3831:
3832: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALC_PROCEEDS';
3833:
3834: Begin
3835:
3836: -- Initialization

Line 4106: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.calc_retired_cost';

4102: and ret.transaction_header_id_in = th.member_transaction_header_id
4103: and th.transaction_date_entered >= p_fy_start_date
4104: and th.transaction_date_entered <= p_period_end_date;
4105:
4106: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.calc_retired_cost';
4107:
4108:
4109: begin
4110:

Line 4184: and fa_calc_deprn_basis1_pkg.g_rule_in.used_by_adjustment is null

4180:
4181: end if; -- End of MRC
4182:
4183: if p_event_type ='RETIREMENT'
4184: and fa_calc_deprn_basis1_pkg.g_rule_in.used_by_adjustment is null
4185: then
4186: x_retired_cost := nvl(x_retired_cost,0) + abs(nvl(p_adjustment_amount,0));
4187: end if;
4188:

Line 4228: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.get_mem_trans_info';

4224: x_member_reduction_rate OUT NOCOPY NUMBER,
4225: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
4226: return boolean is
4227:
4228: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.get_mem_trans_info';
4229:
4230: get_mem_trans_info EXCEPTION;
4231:
4232: cursor C_GET_MEM_TRANS_HEADER is

Line 4337: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.server_validation';

4333: Function SERVER_VALIDATION (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
4334: return boolean is
4335:
4336: svr_val_err exception;
4337: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.server_validation';
4338:
4339: begin
4340:
4341: -- Validate recognize_gain_loss='Y'

Line 4393: end FA_CALC_DEPRN_BASIS1_PKG;

4389: return (false);
4390:
4391: End;
4392:
4393: end FA_CALC_DEPRN_BASIS1_PKG;