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.96.12020000.4 2013/03/19 18:01:39 dvjoshi ship $ */
3: -- global variables
4: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
5: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;

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

75: l_recognize_gain_loss varchar2(3);
76:
77: l_deprn_amt number :=0; --bug#6658280
78:
79: l_calling_fn varchar2(35) := 'fa_calc_deprn_basis1_pkg.faxcdb';
80: l_original_Rate number;
81: l_Revised_Rate number;
82: l_Guaranteed_Rate number;
83: l_request_short_name VARCHAR2(100); --- BUG # 7193797 : Added to store the Concurrent Program Short Name

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

1835: l_chk_count NUMBER := NULL;
1836:
1837: l_group_cost_accounting_flag VARCHAR2(1);
1838:
1839: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.CALC_REDUCITON_AMOUNT';
1840:
1841: no_mid_date_err exception;
1842: calc_reduction_amount_err exception;
1843: /* bug#15897249 starts */

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

2432: ------------------------------------------------------
2433: -- Add this transaction's amount to queried variables
2434: -- for Group asset
2435: ------------------------------------------------------
2436: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2437: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2438: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2439: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2440: then

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

2433: -- Add this transaction's amount to queried variables
2434: -- for Group asset
2435: ------------------------------------------------------
2436: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2437: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2438: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2439: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2440: then
2441:

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

2434: -- for Group asset
2435: ------------------------------------------------------
2436: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2437: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2438: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2439: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2440: then
2441:
2442: -- Check whether this transaction is existing or not.

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

2435: ------------------------------------------------------
2436: if fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered >= l_fy_start_date
2437: and fa_calc_deprn_basis1_pkg.g_rule_in.transaction_date_entered <= nvl(l_transaction_date,l_fy_end_date)
2438: and not (fa_calc_deprn_basis1_pkg.g_rule_in.asset_type <>'GROUP'
2439: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2440: then
2441:
2442: -- Check whether this transaction is existing or not.
2443: OPEN C_CHK_TRANSACTION (fa_calc_deprn_basis1_pkg.g_rule_in.transaction_header_id);

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

2439: and fa_calc_deprn_basis1_pkg.g_rule_in.tracking_method='ALLOCATE')
2440: then
2441:
2442: -- Check whether this transaction is existing or not.
2443: OPEN C_CHK_TRANSACTION (fa_calc_deprn_basis1_pkg.g_rule_in.transaction_header_id);
2444: FETCH C_CHK_TRANSACTION into l_chk_count;
2445: CLOSE C_CHK_TRANSACTION;
2446:
2447: if nvl(l_chk_count,0) = 0 then

Line 2485: value=> fa_calc_deprn_basis1_pkg.g_rule_in.reduction_rate, p_log_level_rec => p_log_level_rec);

2481:
2482: if p_log_level_rec.statement_level then
2483: fa_debug_pkg.add(fname=>'calc_reduction_amount',
2484: element=>'updated reduction_rate',
2485: value=> fa_calc_deprn_basis1_pkg.g_rule_in.reduction_rate, p_log_level_rec => p_log_level_rec);
2486: end if;
2487: end if; -- End of Group
2488:
2489: if g_rule_in.event_type='RETIREMENT' then

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

2871: -- l_period_close_date date;
2872: l_last_recoverable_cost number;
2873: l_last_salvage_value number;
2874:
2875: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_REC_COST';
2876:
2877: grc_err exception;
2878:
2879: begin

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

3166: l_temp_period_counter number(15);
3167: l_rec_cost number;
3168: l_salvage_value number;
3169:
3170: l_calling_fn varchar2(40) := 'fa_calc_deprn_basis1_pkg.GET_EOFY_EOP';
3171:
3172: l_get_eofy_eop_err exception;
3173:
3174: begin

Line 3323: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST

3319: -- at the end of last fiscal year
3320: -------------------------------------------
3321:
3322: h_eofy_period_num := h_num_per_fy;
3323: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST
3324: (
3325: p_asset_id => p_asset_id,
3326: p_book_type_code => p_book_type_code,
3327: p_fiscal_year => p_fiscal_year -1,

Line 3356: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST

3352: h_eop_period_num := p_period_num -1;
3353: h_eop_fiscal_year := p_fiscal_year;
3354: end if;
3355:
3356: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_REC_COST
3357: (
3358: p_asset_id => p_asset_id,
3359: p_book_type_code => p_book_type_code,
3360: p_fiscal_year => h_eop_fiscal_year,

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

3455: l_old_trx_id NUMBER;
3456: l_trx_type VARCHAR2(100);
3457: l_adjusted_taxup boolean := FALSE; --Bug#10085574
3458:
3459: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
3460: call_deprn_basis_err exception;
3461:
3462: BEGIN
3463:

Line 3755: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP

3751: if p_log_level_rec.statement_level then
3752: fa_debug_pkg.add(l_calling_fn, '++ calling GET_EOFY_EOP', '...', p_log_level_rec => p_log_level_rec);
3753: end if;
3754:
3755: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP
3756: (
3757: p_asset_id => h_rule_in.asset_id,
3758: p_book_type_code => h_rule_in.book_type_code,
3759: p_fiscal_year => h_rule_in.fiscal_year,

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

3803: IF (NVL(p_trans_rec.transaction_key,'XX') = 'JI' and h_rule_in.transaction_flag is NULL) then
3804: h_rule_in.transaction_flag := p_trans_rec.transaction_key;
3805: h_rule_in.allowed_deprn_limit_amount := p_asset_fin_rec_old.allowed_deprn_limit_amount;
3806: END IF;
3807: if (not FA_CALC_DEPRN_BASIS1_PKG.faxcdb(h_rule_in,
3808: h_rule_out, p_log_level_rec => p_log_level_rec)) then
3809: raise call_deprn_basis_err;
3810:
3811: end if;

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

4021: px_new_formula_factor IN OUT NOCOPY number
4022:
4023: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
4024:
4025: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
4026: l_annual_deprn_rounding_flag varchar2(5);
4027: imp_next number;
4028: call_deprn_basis_err EXCEPTION;
4029: BEGIN

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

4260: and ret.set_of_books_id = p_set_of_books_id
4261: and th.transaction_date_entered >= p_fy_start_date
4262: and th.transaction_date_entered <= p_period_end_date;
4263:
4264: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALC_PROCEEDS';
4265:
4266: Begin
4267:
4268: -- Initialization

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

4539: and ret.set_of_books_id = p_set_of_books_id
4540: and th.transaction_date_entered >= p_fy_start_date
4541: and th.transaction_date_entered <= p_period_end_date;
4542:
4543: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.calc_retired_cost';
4544:
4545:
4546: begin
4547:

Line 4621: and fa_calc_deprn_basis1_pkg.g_rule_in.used_by_adjustment is null

4617:
4618: end if; -- End of MRC
4619:
4620: if p_event_type ='RETIREMENT'
4621: and fa_calc_deprn_basis1_pkg.g_rule_in.used_by_adjustment is null
4622: then
4623: x_retired_cost := nvl(x_retired_cost,0) + abs(nvl(p_adjustment_amount,0));
4624: end if;
4625:

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

4661: x_recognize_gain_loss OUT NOCOPY VARCHAR2
4662: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
4663: return boolean is
4664:
4665: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.get_mem_trans_info';
4666:
4667: get_mem_trans_info EXCEPTION;
4668:
4669: cursor C_GET_MEM_TRANS_HEADER is

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

4774:
4775: return boolean is
4776:
4777: svr_val_err exception;
4778: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.server_validation';
4779:
4780: begin
4781:
4782: -- Validate recognize_gain_loss='Y'

Line 4847: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.calc_adj_cost_diff';

4843: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN is
4844:
4845: l_min_amrt_date date;
4846: l_max_adjcost_date date;
4847: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.calc_adj_cost_diff';
4848: cursor c_adj_cost_diff is
4849: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date
4850: from fa_books bk, fa_transaction_headers th
4851: where bk.asset_id = th.asset_id

Line 4895: end FA_CALC_DEPRN_BASIS1_PKG;

4891: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4892: return (false);
4893: end CALC_ADJ_COST_DIFF;
4894:
4895: end FA_CALC_DEPRN_BASIS1_PKG;