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_REVALUATION_PVT dependencies on FA_CACHE_PKG

Line 337: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then

333: end if;
334:
335: --bug6917615
336: --Added the following code to populate the rat_in_use column during revaluation
337: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
338:
339: FA_CDE_PKG.faxgfr (X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
340: X_Asset_Id => px_asset_hdr_rec.asset_id,
341: X_Short_Fiscal_Year_Flag => NULL,

Line 376: if not fa_cache_pkg.fazsys then

372: -- we could also build an array here and insert in bulk periodically (as we do in faxinaj)
373:
374: -- Get the category in concatenated string for the asset's current category.
375:
376: if not fa_cache_pkg.fazsys then
377: raise reval_err;
378: end if;
379:
380: if p_log_level_rec.statement_level then

Line 384: fa_cache_pkg.fazsys_record.category_flex_structure

380: if p_log_level_rec.statement_level then
381: fa_debug_pkg.add
382: (l_calling_fn,
383: 'calling concat_category with cat struct: ',
384: fa_cache_pkg.fazsys_record.category_flex_structure
385: ,p_log_level_rec => p_log_level_rec);
386: fa_debug_pkg.add
387: (l_calling_fn,
388: 'calling concat_category with cat id: ',

Line 394: struct_id => fa_cache_pkg.fazsys_record.category_flex_structure,

390: ,p_log_level_rec => p_log_level_rec);
391: end if;
392:
393: FA_RX_SHARED_PKG.Concat_Category(
394: struct_id => fa_cache_pkg.fazsys_record.category_flex_structure,
395: ccid => p_asset_cat_rec.category_id,
396: concat_string => l_concat_cat,
397: segarray => l_cat_segs);
398:

Line 662: if not fa_cache_pkg.fazccmt

658: x_reval_out.insert_txn_flag := FALSE;
659: goto fareven_exit_noerr;
660: end if;
661:
662: if not fa_cache_pkg.fazccmt
663: (X_method => p_asset_fin_rec_old.deprn_method_code,
664: X_life => p_asset_fin_rec_old.life_in_months
665: ,p_log_level_rec => p_log_level_rec) then
666: raise fareven_err;

Line 669: if (fa_cache_pkg.fazccmt_record.rate_source_rule =

665: ,p_log_level_rec => p_log_level_rec) then
666: raise fareven_err;
667: end if;
668:
669: if (fa_cache_pkg.fazccmt_record.rate_source_rule =
670: FA_STD_TYPES.FAD_RSR_FLAT AND
671: l_fully_rsvd_flag) then
672: x_reval_out.insert_txn_flag := FALSE;
673: goto fareven_exit_noerr;

Line 676: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then

672: x_reval_out.insert_txn_flag := FALSE;
673: goto fareven_exit_noerr;
674: end if;
675:
676: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
677: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
678: end if;
679:
680: if (nvl(l_polish_rule, FA_STD_TYPES.FAD_DBR_POLISH_NONE) in (

Line 677: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;

673: goto fareven_exit_noerr;
674: end if;
675:
676: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
677: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
678: end if;
679:
680: if (nvl(l_polish_rule, FA_STD_TYPES.FAD_DBR_POLISH_NONE) in (
681: FA_STD_TYPES.FAD_DBR_POLISH_1,

Line 697: l_reval_dep_rsv_flag := fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag; l_reval_ytd_deprn_flag := fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;

693:
694: -- Get Book Based Revaluation Rules from Book Controls Cache
695: -- Get some more information from the Book Controls Cache
696:
697: l_reval_dep_rsv_flag := fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag; l_reval_ytd_deprn_flag := fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
698: l_amor_reval_rsv_flag :=
699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
700:
701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

Line 699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;

695: -- Get some more information from the Book Controls Cache
696:
697: l_reval_dep_rsv_flag := fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag; l_reval_ytd_deprn_flag := fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
698: l_amor_reval_rsv_flag :=
699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
700:
701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
702: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
703: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

Line 701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

697: l_reval_dep_rsv_flag := fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag; l_reval_ytd_deprn_flag := fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
698: l_amor_reval_rsv_flag :=
699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
700:
701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
702: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
703: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
704:
705: if (p_log_level_rec.statement_level) then

Line 702: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;

698: l_amor_reval_rsv_flag :=
699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
700:
701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
702: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
703: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
704:
705: if (p_log_level_rec.statement_level) then
706: fa_debug_pkg.add('fareven', 'step', 2

Line 703: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

699: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
700:
701: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
702: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
703: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
704:
705: if (p_log_level_rec.statement_level) then
706: fa_debug_pkg.add('fareven', 'step', 2
707: ,p_log_level_rec => p_log_level_rec);

Line 714: if not fa_cache_pkg.fazccmt

710:
711: -- Find the Depreciation Basis Rule and Rate Source Rule
712: -- for this depreciation method
713:
714: if not fa_cache_pkg.fazccmt
715: (X_method => p_asset_fin_rec_old.deprn_method_code,
716: X_life => p_asset_fin_rec_old.life_in_months
717: ,p_log_level_rec => p_log_level_rec) then
718: raise fareven_err;

Line 721: l_method_id := fa_cache_pkg.fazccmt_record.method_id;

717: ,p_log_level_rec => p_log_level_rec) then
718: raise fareven_err;
719: end if;
720:
721: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
722: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then
723: l_depr_last_year_flag := TRUE;
724: else
725: l_depr_last_year_flag := FALSE;

Line 722: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then

718: raise fareven_err;
719: end if;
720:
721: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
722: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then
723: l_depr_last_year_flag := TRUE;
724: else
725: l_depr_last_year_flag := FALSE;
726: end if;

Line 727: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

723: l_depr_last_year_flag := TRUE;
724: else
725: l_depr_last_year_flag := FALSE;
726: end if;
727: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
728: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
729:
730: if (p_log_level_rec.statement_level) then
731: fa_debug_pkg.add('fareven', '3', 3

Line 728: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

724: else
725: l_depr_last_year_flag := FALSE;
726: end if;
727: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
728: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
729:
730: if (p_log_level_rec.statement_level) then
731: fa_debug_pkg.add('fareven', '3', 3
732: ,p_log_level_rec => p_log_level_rec);

Line 781: if not fa_cache_pkg.fazccbd

777:
778: -- call fazccbd to initialize cat book defaults which is called in
779: -- calc_salvage_value
780:
781: if not fa_cache_pkg.fazccbd
782: (X_book => p_asset_hdr_rec.book_type_code,
783: X_cat_id => p_asset_cat_rec.category_id,
784: X_jdpis =>
785: to_number(to_char(p_asset_fin_rec_old.date_placed_in_service, 'J')) ) then

Line 1119: if not fa_cache_pkg.fazccmt

1115: -- calculated life exists
1116: if ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) OR
1117: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE) OR
1118: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA)) then
1119: if not fa_cache_pkg.fazccmt
1120: (X_method => p_asset_fin_rec_old.deprn_method_code,
1121: X_life => l_recalc_life
1122: ,p_log_level_rec => p_log_level_rec) then
1123:

Line 1395: if not fa_cache_pkg.fazccmt

1391:
1392: if ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) OR
1393: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE) OR
1394: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA)) then
1395: if not fa_cache_pkg.fazccmt
1396: (X_method => p_asset_fin_rec_old.deprn_method_code,
1397: X_life => l_recalc_life
1398: ,p_log_level_rec => p_log_level_rec) then
1399: if (p_log_level_rec.statement_level) then

Line 1528: if (not fa_cache_pkg.fazccb

1524: -- Depreciation Reserve Account
1525: -- and Bonus Deprn Reserve Account
1526: -- from Category Books Cache
1527:
1528: if (not fa_cache_pkg.fazccb
1529: (X_book => p_asset_hdr_rec.book_type_code,
1530: X_cat_id => p_asset_cat_rec.category_id
1531: ,p_log_level_rec => p_log_level_rec)) then
1532: raise fareven_err;

Line 1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

1530: X_cat_id => p_asset_cat_rec.category_id
1531: ,p_log_level_rec => p_log_level_rec)) then
1532: raise fareven_err;
1533: end if;
1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;

Line 1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

1531: ,p_log_level_rec => p_log_level_rec)) then
1532: raise fareven_err;
1533: end if;
1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
1539:

Line 1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;

1532: raise fareven_err;
1533: end if;
1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
1539:
1540: -- Bonus Deprn - YYOON

Line 1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

1533: end if;
1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
1539:
1540: -- Bonus Deprn - YYOON
1541: -- Getting the bonus deprn expense

Line 1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;

1534: l_cost_acct := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1535: l_cip_cost_acct := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1536: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1537: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1538: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
1539:
1540: -- Bonus Deprn - YYOON
1541: -- Getting the bonus deprn expense
1542: -- and the bonus deprn reserve account

Line 1545: fa_cache_pkg.fazccb_record.BONUS_DEPRN_EXPENSE_ACCT;

1541: -- Getting the bonus deprn expense
1542: -- and the bonus deprn reserve account
1543: -- from asset category
1544: l_adj_in.account :=
1545: fa_cache_pkg.fazccb_record.BONUS_DEPRN_EXPENSE_ACCT;
1546: l_adj_in.account :=
1547: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;
1548: --End of Bonus Deprn Change
1549:

Line 1547: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;

1543: -- from asset category
1544: l_adj_in.account :=
1545: fa_cache_pkg.fazccb_record.BONUS_DEPRN_EXPENSE_ACCT;
1546: l_adj_in.account :=
1547: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;
1548: --End of Bonus Deprn Change
1549:
1550: l_adj_in.transaction_header_id := px_trans_rec.transaction_header_id;
1551: l_adj_in.asset_invoice_id := 0;