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.

[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_METHODS

Line 1911: l_method_name fa_methods.name%type;

1907: l_method_id number;
1908: l_rowid rowid;
1909:
1910: l_method_id_old number;
1911: l_method_name fa_methods.name%type;
1912: l_deprn_basis_rule varchar2(4);
1913: l_stl_method_flag varchar2(3);
1914: l_dep_last_year_flag varchar2(3);
1915: l_exclude_sal_flag varchar2(3);

Line 1944: FROM FA_METHODS

1940: stl_method_flag,
1941: exclude_salvage_value_flag,
1942: polish_adj_calc_basis_flag,
1943: guarantee_rate_method_flag
1944: FROM FA_METHODS
1945: WHERE METHOD_CODE = p_deprn_method
1946: AND LIFE_IN_MONTHS = p_life_in_months;
1947:
1948: CURSOR C_FORMULA (p_method_id number) IS

Line 1988: select FA_METHODS_S.NEXTVAL

1984: end if;
1985:
1986: else -- not table
1987:
1988: select FA_METHODS_S.NEXTVAL
1989: into l_method_id
1990: from sys.dual;
1991:
1992: -- need to derive more values to distinguish between

Line 2027: FA_METHODS_PKG.Insert_Row(

2023: if (p_log_level_rec.statement_level) then
2024: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method', p_log_level_rec => p_log_level_rec);
2025: end if;
2026:
2027: FA_METHODS_PKG.Insert_Row(
2028: X_Rowid => l_rowid,
2029: X_Method_Id => l_method_id,
2030: X_Method_Code => p_deprn_method,
2031: X_Life_In_Months => p_lim,

Line 2482: fa_methods mt

2478: (bk.rate_adjustment_factor = 1 and
2479: exists
2480: (select 'YES' -- and amortized before.
2481: from fa_transaction_headers th,
2482: fa_methods mt
2483: where th.book_type_code = bk.book_type_code
2484: and th.asset_id = bk.asset_id
2485: and (th.transaction_subtype = 'AMORTIZED'
2486: OR th.transaction_key = 'UA')

Line 2506: fa_methods mt

2502: (bk.rate_adjustment_factor = 1 and
2503: exists
2504: (select 'YES'
2505: from fa_transaction_headers th,
2506: fa_methods mt
2507: where th.book_type_code = bk.book_type_code
2508: and th.asset_id = bk.asset_id
2509: and (th.transaction_subtype = 'AMORTIZED'
2510: OR th.transaction_key = 'UA')

Line 2561: fa_methods mt

2557: and (bk.rate_Adjustment_factor <> 1 OR
2558: (bk.rate_adjustment_factor = 1 and
2559: exists (select 'YES' -- and amortized before.
2560: from fa_transaction_headers th,
2561: fa_methods mt
2562: where th.book_type_code = bk.book_type_code
2563: and th.asset_id = bk.asset_id
2564: and th.transaction_type_code = 'ADJUSTMENT'
2565: and (th.transaction_subtype = 'AMORTIZED' OR th.transaction_key = 'UA')

Line 4437: from fa_methods fm

4433: cursor lcu_deprn_method(p_prior_deprn_method in varchar2)
4434: is
4435:
4436: select count('1')
4437: from fa_methods fm
4438: where fm.method_code = p_prior_deprn_method;
4439:
4440: CURSOR l_life_in_months(p_method IN VARCHAR2
4441: ,p_life_in_months IN NUMBER

Line 4445: from fa_methods fm

4441: ,p_life_in_months IN NUMBER
4442: )
4443: IS
4444: select count(1)
4445: from fa_methods fm
4446: where fm.method_code = p_method
4447: and fm.life_in_months = p_life_in_months;
4448:
4449: CURSOR lc_depr_rates(p_method IN VARCHAR2

Line 4454: from fa_methods fm

4450: ,p_prior_basic_rate IN NUMBER
4451: ,p_prior_adjusted_rate IN NUMBER )
4452: IS
4453: select count(1)
4454: from fa_methods fm
4455: ,fa_flat_rates ffr
4456: where fm.method_code = p_method
4457: and ffr.method_id = fm.method_id
4458: and ffr.basic_rate = p_prior_basic_rate

Line 4930: ,fa_methods fm

4926: select ff.original_rate
4927: ,ff.revised_rate
4928: ,ff.guarantee_rate
4929: from fa_formulas ff
4930: ,fa_methods fm
4931: where ff.method_id = fm.method_id
4932: and fm.method_code = p_method_code;
4933:
4934: TYPE l_msg_error_rec IS RECORD(mass_addition_id NUMBER

Line 6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;

6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;

Line 6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;

6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

Line 6496: l_rate_source_rule fa_methods.rate_source_rule%type;

6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;

Line 6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;

6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;

Line 6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;

6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

Line 6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;

Line 6500: l_grp_method_code fa_methods.method_code%type;

6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;

Line 6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;

6497: l_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

Line 6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

6498: l_grp_rate_source_rule fa_methods.rate_source_rule%type;
6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;

Line 6503: l_old_grp_method_code fa_methods.method_code%type;

6499: l_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;
6507:

Line 6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;

6500: l_grp_method_code fa_methods.method_code%type;
6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;
6507:
6508: /* Added for ENH 12600386 Start */

Line 6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;

6501: l_old_grp_rate_source_rule fa_methods.rate_source_rule%type;
6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;
6507:
6508: /* Added for ENH 12600386 Start */
6509: l_deprn_reserve fa_deprn_summary.deprn_reserve%type;

Line 6506: l_corp_method_code fa_methods.method_code%type;

6502: l_old_grp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6503: l_old_grp_method_code fa_methods.method_code%type;
6504: l_corp_rate_source_rule fa_methods.rate_source_rule%type;
6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;
6507:
6508: /* Added for ENH 12600386 Start */
6509: l_deprn_reserve fa_deprn_summary.deprn_reserve%type;
6510: l_ytd_deprn fa_deprn_summary.ytd_deprn%type;

Line 6525: from fa_methods mth

6521:
6522: /* Get method details */
6523: cursor method_details(p_method_code in varchar2) is
6524: select rate_source_rule, deprn_basis_rule
6525: from fa_methods mth
6526: where mth.method_code = p_method_code;
6527:
6528: cursor group_method_details(p_group_asset_id in number) is
6529: select method_code, rate_source_rule, deprn_basis_rule

Line 6530: from fa_methods mth, fa_books bk

6526: where mth.method_code = p_method_code;
6527:
6528: cursor group_method_details(p_group_asset_id in number) is
6529: select method_code, rate_source_rule, deprn_basis_rule
6530: from fa_methods mth, fa_books bk
6531: where mth.method_code = bk.deprn_method_code
6532: and bk.asset_id = p_group_asset_id
6533: and bk.book_type_code = p_asset_hdr_rec.book_type_code
6534: and bk.transaction_header_id_out is null;

Line 6538: from fa_methods mth, fa_books bk

6534: and bk.transaction_header_id_out is null;
6535:
6536: cursor corp_method_details is
6537: select method_code, rate_source_rule, deprn_basis_rule
6538: from fa_methods mth, fa_books bk
6539: where mth.method_code = bk.deprn_method_code
6540: and bk.asset_id = p_asset_hdr_rec.asset_id
6541: and bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
6542: and bk.transaction_header_id_out is null;

Line 6556: fa_methods mth

6552: cursor check_tax_book_method is
6553: select 'x'
6554: from fa_books bk,
6555: fa_book_controls bc,
6556: fa_methods mth
6557: where bc.distribution_source_book = p_asset_hdr_rec.book_type_code
6558: and bc.book_class = 'TAX'
6559: and bk.book_type_code = bc.book_type_code
6560: and bk.asset_id = p_asset_hdr_rec.asset_id

Line 6816: fa_methods mt

6812: (bk.rate_adjustment_factor = 1 and
6813: exists
6814: (select 'YES'
6815: from fa_transaction_headers th,
6816: fa_methods mt
6817: where th.book_type_code = bk.book_type_code
6818: and th.asset_id = bk.asset_id
6819: and (th.transaction_subtype = 'AMORTIZED'
6820: OR th.transaction_key = 'UA')

Line 7022: from fa_methods mt, fa_deprn_basis_rules ru

7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7019:
7020: cursor c_method_details(p_method_code in varchar2) is
7021: select mt.method_code, mt.method_id, mt.deprn_basis_rule,ru.rule_name
7022: from fa_methods mt, fa_deprn_basis_rules ru
7023: where mt.deprn_basis_rule_id = ru.deprn_basis_rule_id(+)
7024: and mt.method_code = p_method_code;
7025:
7026: cursor c_grp_details(p_grp_asset_id in number) is