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 93: IF (NVL(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y') THEN

89: -- with the new values where appropriate
90: l_asset_fin_rec_new := p_asset_fin_rec_old;
91: l_asset_deprn_rec_new := p_asset_deprn_rec_old;
92:
93: IF (NVL(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y') THEN
94:
95: l_nbv_old := (p_asset_fin_rec_old.recoverable_cost
96: - p_asset_deprn_rec_old.deprn_reserve
97: + NVL(p_asset_fin_rec_old.salvage_value,0)

Line 117: (NVL(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y') THEN

113: px_trans_rec.transaction_key := 'PR' ;
114: END IF;
115:
116: IF (l_nbv_delta < 0 ) AND
117: (NVL(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y') THEN
118: --New transaction key
119: px_trans_rec.transaction_key := 'RL';
120: -- call the revaluation loss engine
121: IF NOT reval_loss (px_trans_rec => px_trans_rec,

Line 163: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

159: /* Bug 7488356 - Begin
160: The following logic is added only for SORP.
161: When the Impairment is followed by Revaluation,
162: This particular flag should be set to 'NONE' such that catchup wont be calculated*/
163: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
164: THEN
165: IF (l_asset_fin_rec_new.adjustment_required_status = 'ADD')
166: THEN
167: l_asset_fin_rec_new.adjustment_required_status := 'NONE';

Line 320: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y' then

316:
317: raise reval_err;
318: end if;
319:
320: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y' then
321: l_capital_adj := l_dpr_row.capital_adjustment - nvl(l_asset_deprn_rec_new.reval_amortization,0) + nvl(l_asset_deprn_rec_new.DEPRN_AMOUNT,0);
322: l_general_fund := l_dpr_row.general_fund + nvl(l_asset_deprn_rec_new.DEPRN_AMOUNT,0);
323: else
324: l_capital_adj := 0;

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

660: fa_debug_pkg.ADD (l_calling_fn, 'after books insert', 1, p_log_level_rec => p_log_level_rec);
661: END IF;
662: --bug7719742
663: --Added the following code to populate the rat_in_use column during revaluation
664: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
665:
666: FA_CDE_PKG.faxgfr (X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
667: X_Asset_Id => px_asset_hdr_rec.asset_id,
668: X_Short_Fiscal_Year_Flag => NULL,

Line 702: IF NOT fa_cache_pkg.fazsys(p_log_level_rec)

698: -- insert into temp report table (ITF?)
699: -- we could also build an array here and insert in bulk periodically (as we do in faxinaj)
700:
701: -- Get the category in concatenated string for the asset's current category.
702: IF NOT fa_cache_pkg.fazsys(p_log_level_rec)
703: THEN
704: RAISE reval_err;
705: END IF;
706:

Line 712: fa_cache_pkg.fazsys_record.category_flex_structure

708: THEN
709: fa_debug_pkg.ADD
710: (l_calling_fn,
711: 'calling concat_category with cat struct: ',
712: fa_cache_pkg.fazsys_record.category_flex_structure
713: , p_log_level_rec => p_log_level_rec);
714: fa_debug_pkg.ADD (l_calling_fn,
715: 'calling concat_category with cat id: ',
716: p_asset_cat_rec.category_id

Line 721: (struct_id => fa_cache_pkg.fazsys_record.category_flex_structure,

717: , p_log_level_rec => p_log_level_rec);
718: END IF;
719:
720: fa_rx_shared_pkg.concat_category
721: (struct_id => fa_cache_pkg.fazsys_record.category_flex_structure,
722: ccid => p_asset_cat_rec.category_id,
723: concat_string => l_concat_cat,
724: segarray => l_cat_segs);
725:

Line 1010: IF NOT fa_cache_pkg.fazccmt

1006: x_reval_out.insert_txn_flag := FALSE;
1007: GOTO fareven_exit_noerr;
1008: END IF;
1009:
1010: IF NOT fa_cache_pkg.fazccmt
1011: (x_method => p_asset_fin_rec_old.deprn_method_code,
1012: x_life => p_asset_fin_rec_old.life_in_months
1013: , p_log_level_rec => p_log_level_rec)
1014: THEN

Line 1018: IF ( fa_cache_pkg.fazccmt_record.rate_source_rule =

1014: THEN
1015: RAISE fareven_err;
1016: END IF;
1017:
1018: IF ( fa_cache_pkg.fazccmt_record.rate_source_rule =
1019: fa_std_types.fad_rsr_flat
1020: AND l_fully_rsvd_flag
1021: )
1022: THEN

Line 1027: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL)

1023: x_reval_out.insert_txn_flag := FALSE;
1024: GOTO fareven_exit_noerr;
1025: END IF;
1026:
1027: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL)
1028: THEN
1029: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1030: END IF;
1031:

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

1025: END IF;
1026:
1027: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL)
1028: THEN
1029: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1030: END IF;
1031:
1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,

Line 1046: fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag;

1042: GOTO fareven_exit_noerr;
1043: END IF;
1044:
1045: l_reval_dep_rsv_flag :=
1046: fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag;
1047: l_reval_ytd_deprn_flag :=
1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;

Line 1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;

1044:
1045: l_reval_dep_rsv_flag :=
1046: fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag;
1047: l_reval_ytd_deprn_flag :=
1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
1051: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1052: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;

Line 1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;

1046: fa_cache_pkg.fazcbc_record.reval_deprn_reserve_flag;
1047: l_reval_ytd_deprn_flag :=
1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
1051: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1052: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
1053: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1054:

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

1047: l_reval_ytd_deprn_flag :=
1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
1051: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1052: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
1053: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1054:
1055: -- Bug#6666666 SORP Start

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

1048: fa_cache_pkg.fazcbc_record.reval_ytd_deprn_flag;
1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
1051: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1052: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
1053: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1054:
1055: -- Bug#6666666 SORP Start
1056: IF (p_log_level_rec.statement_level) THEN

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

1049: l_amor_reval_rsv_flag :=
1050: fa_cache_pkg.fazcbc_record.amortize_reval_reserve_flag;
1051: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1052: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
1053: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1054:
1055: -- Bug#6666666 SORP Start
1056: IF (p_log_level_rec.statement_level) THEN
1057:

Line 1065: NVL (fa_cache_pkg.fazcbc_record.sorp_enabled_flag,

1061: , p_log_level_rec => p_log_level_rec);
1062:
1063: fa_debug_pkg.ADD ('fareven' || ' SORP',
1064: 'SORP_Enabled_flag',
1065: NVL (fa_cache_pkg.fazcbc_record.sorp_enabled_flag,
1066: 'N'
1067: )
1068: );
1069: END IF;

Line 1071: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1067: )
1068: );
1069: END IF;
1070:
1071: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1072: THEN
1073: IF (p_log_level_rec.statement_level)
1074: THEN
1075: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1207: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1203:
1204: l_reval_loss_exp := 0;
1205: l_reval_deprn_exp := 0;
1206: -- This Call is made to caluclate impairment related amounts while performing linked revaluation
1207: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1208: AND p_reval_options_rec.linked_flag = 'YES'
1209: THEN
1210: l_gain_amount := x_reval_out.cost_adj;
1211: if not fa_sorp_revaluation_pkg.process_loss_reversal( p_asset_hdr_rec => p_asset_hdr_rec,

Line 1310: IF NOT fa_cache_pkg.fazccmt

1306: END IF;
1307:
1308: -- Find the Depreciation Basis Rule and Rate Source Rule
1309: -- for this depreciation method
1310: IF NOT fa_cache_pkg.fazccmt
1311: (x_method => p_asset_fin_rec_old.deprn_method_code,
1312: x_life => p_asset_fin_rec_old.life_in_months
1313: , p_log_level_rec => p_log_level_rec)
1314: THEN

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

1314: THEN
1315: RAISE fareven_err;
1316: END IF;
1317:
1318: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
1319:
1320: IF fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES'
1321: THEN
1322: l_depr_last_year_flag := TRUE;

Line 1320: IF fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES'

1316: END IF;
1317:
1318: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
1319:
1320: IF fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES'
1321: THEN
1322: l_depr_last_year_flag := TRUE;
1323: ELSE
1324: l_depr_last_year_flag := FALSE;

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

1323: ELSE
1324: l_depr_last_year_flag := FALSE;
1325: END IF;
1326:
1327: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1328: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1329:
1330: IF (p_log_level_rec.statement_level)
1331: THEN

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

1324: l_depr_last_year_flag := FALSE;
1325: END IF;
1326:
1327: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1328: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1329:
1330: IF (p_log_level_rec.statement_level)
1331: THEN
1332: fa_debug_pkg.ADD ('fareven', '3', 3, p_log_level_rec => p_log_level_rec);

Line 1336: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

1332: fa_debug_pkg.ADD ('fareven', '3', 3, p_log_level_rec => p_log_level_rec);
1333: END IF;
1334:
1335: -- Bug#6666666 SORP Start
1336: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
1337: THEN
1338: IF (l_reval_ceiling_flag)
1339: THEN
1340: IF ((p_asset_fin_rec_old.COST * (1 + l_reval_rate)) >

Line 1361: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

1357: END IF;
1358:
1359: --Calculate adjustment to asset cost
1360: -- Bug#6666666 SORP Start
1361: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
1362: THEN
1363: x_reval_out.cost_adj := p_asset_fin_rec_old.COST * l_reval_rate;
1364: END IF;
1365:

Line 1377: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

1373: RAISE fareven_err;
1374: END IF;
1375:
1376: -- Added for SORP
1377: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
1378: THEN
1379: px_asset_fin_rec_new.COST :=
1380: p_asset_fin_rec_old.COST + x_reval_out.cost_adj;
1381: END IF;

Line 1451: IF NOT fa_cache_pkg.fazccbd

1447: END IF;
1448:
1449: -- call fazccbd to initialize cat book defaults which is called in
1450: -- calc_salvage_value
1451: IF NOT fa_cache_pkg.fazccbd
1452: (x_book => p_asset_hdr_rec.book_type_code,
1453: x_cat_id => p_asset_cat_rec.category_id,
1454: x_jdpis => TO_NUMBER
1455: (TO_CHAR

Line 1520: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1516: x_reval_out.bonus_deprn_rsv_adj :=
1517: -p_asset_deprn_rec_old.bonus_deprn_reserve;
1518:
1519: -- Bug 6666666 START Added for SORP
1520: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1521: THEN
1522: IF ABS (x_reval_out.deprn_rsv_adj) <> 0
1523: THEN
1524: IF (x_reval_out.cost_adj > 0)

Line 1572: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1568: x_reval_out.cost_adj
1569: )
1570: THEN
1571: -- Bug 6666666 START Modified for SORP
1572: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1573: THEN
1574: x_reval_out.cost_adj :=
1575: ( p_asset_deprn_rec_old.impairment_reserve
1576: - x_reval_out.cost_adj

Line 1591: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1587: x_reval_out.deprn_rsv_adj := 0;
1588: x_reval_out.reval_rsv_adj := 0;*/
1589: END IF;
1590: ELSE
1591: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1592: THEN
1593: x_reval_out.cost_adj :=
1594: x_reval_out.cost_adj
1595: - p_asset_deprn_rec_old.impairment_reserve;

Line 1610: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

1606: x_reval_out.cost_adj - x_reval_out.deprn_rsv_adj;
1607: END IF;
1608: END IF;
1609: ELSE -- x_reval_out.deprn_rsv_adj < 0
1610: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
1611: THEN
1612: x_reval_out.impairment_rsv_adj := 0;
1613: ELSE
1614: x_reval_out.impairment_rsv_adj :=

Line 1688: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

1684: --because the ytd_deprn_adj has already included the bonus ytd amount.
1685: -- Compute Adjustment to Revaluation Reserve
1686:
1687: -- Added for SORP
1688: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
1689: THEN
1690: x_reval_out.reval_rsv_adj :=
1691: x_reval_out.cost_adj - x_reval_out.deprn_rsv_adj;
1692: END IF;

Line 1710: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1706: x_reval_out.new_life := p_asset_fin_rec_old.life_in_months;
1707: x_reval_out.new_fully_rsvd_revals_ctr :=
1708: p_asset_fin_rec_old.fully_rsvd_revals_counter;
1709:
1710: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1711: THEN
1712: px_asset_fin_rec_new.COST :=
1713: p_asset_fin_rec_old.COST + x_reval_out.cost_adj;
1714: x_reval_out.reval_rsv_adj := l_gain_amount;

Line 1852: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

1848: END IF;
1849:
1850: --Bug#7488735 - Depreciation not calculated for donated asset as
1851: -- cost is zero at this point and recoverable_cost is calculated as zero
1852: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1853: THEN
1854: --Bug#7553091
1855: --if x_reval_out.cost_adj <> 0 then
1856: px_asset_fin_rec_new.COST := x_reval_out.cost_adj;

Line 1974: IF NOT fa_cache_pkg.fazccmt

1970: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
1971: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
1972: )
1973: THEN
1974: IF NOT fa_cache_pkg.fazccmt
1975: (x_method => p_asset_fin_rec_old.deprn_method_code,
1976: x_life => l_recalc_life
1977: , p_log_level_rec => p_log_level_rec)
1978: THEN

Line 2188: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2184: x_reval_out.bonus_deprn_rsv_adj :=
2185: -p_asset_deprn_rec_old.bonus_deprn_reserve;
2186:
2187: -- Added for SORP
2188: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2189: THEN
2190: IF ABS (x_reval_out.deprn_rsv_adj) <> 0
2191: THEN
2192: --Bug#7553091

Line 2251: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

2247: x_reval_out.ytd_impairment_adj := 0;
2248: END IF; -- if YTD deprn. is not to be revalued
2249:
2250: -- Compute Adjustment to Revaluation Reserve
2251: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
2252: THEN
2253: x_reval_out.reval_rsv_adj :=
2254: x_reval_out.cost_adj - x_reval_out.deprn_rsv_adj;
2255: END IF;

Line 2279: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2275: x_reval_out.cost_adj
2276: )
2277: THEN
2278: -- -- Bug 6666666 START Modified for SORP
2279: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2280: THEN
2281: x_reval_out.cost_adj :=
2282: ( p_asset_deprn_rec_old.impairment_reserve
2283: - x_reval_out.cost_adj

Line 2295: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2291: x_reval_out.impairment_rsv_adj :=
2292: p_asset_deprn_rec_old.impairment_reserve * -1;
2293: END IF;
2294: ELSE
2295: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2296: THEN
2297: x_reval_out.cost_adj :=
2298: x_reval_out.cost_adj
2299: - p_asset_deprn_rec_old.impairment_reserve;

Line 2316: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

2312: x_reval_out.cost_adj - x_reval_out.deprn_rsv_adj;
2313: END IF;
2314: END IF;
2315: ELSE -- x_reval_out.deprn_rsv_adj < 0
2316: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
2317: THEN
2318: x_reval_out.impairment_rsv_adj := 0;
2319: ELSE
2320: x_reval_out.impairment_rsv_adj :=

Line 2352: IF NOT fa_cache_pkg.fazccmt

2348: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
2349: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
2350: )
2351: THEN
2352: IF NOT fa_cache_pkg.fazccmt
2353: (x_method => p_asset_fin_rec_old.deprn_method_code,
2354: x_life => l_recalc_life
2355: , p_log_level_rec => p_log_level_rec)
2356: THEN

Line 2405: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2401: px_asset_fin_rec_new.adjusted_cost :=
2402: px_asset_fin_rec_new.recoverable_cost;
2403: px_asset_fin_rec_new.life_in_months := l_recalc_life;
2404:
2405: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2406: THEN
2407: px_asset_fin_rec_new.COST :=
2408: p_asset_fin_rec_old.COST + x_reval_out.cost_adj;
2409:

Line 2462: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

2458:
2459: -- Bug 6666666 SORP START
2460: -- Amortization is calculated on total amount credited to Reval Reserve Account.
2461: -- This includes reval gain + reversed deprn effect on reval adjustment amount
2462: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
2463: THEN
2464: px_asset_deprn_rec_new.reval_deprn_reserve :=
2465: p_asset_deprn_rec_old.reval_deprn_reserve
2466: + x_reval_out.reval_rsv_adj;

Line 2484: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

2480: px_asset_deprn_rec_new.impairment_reserve := p_asset_deprn_rec_old.impairment_reserve + nvl(x_reval_out.impairment_rsv_adj,0) ;
2481: -- populate new reval_amort basis here
2482: -- Bug# 6684245 impairment_reserve added to amortisation basis
2483: -- Bug 6666666 SORP START
2484: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
2485: THEN
2486: px_asset_fin_rec_new.reval_amortization_basis :=
2487: px_asset_deprn_rec_new.reval_deprn_reserve
2488: + NVL (p_asset_deprn_rec_old.impairment_reserve, 0);

Line 2521: AND nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2517: IF ( x_reval_out.cost_adj <> 0
2518: OR p_asset_fin_rec_old.life_in_months <> x_reval_out.new_life
2519: )
2520: OR ( ( x_reval_out.cost_adj = 0
2521: AND nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2522: )
2523: OR p_asset_fin_rec_old.life_in_months <> x_reval_out.new_life
2524: )
2525: THEN

Line 2550: IF (NOT fa_cache_pkg.fazccb

2546: -- Get Asset Cost Account, Revaluation Reserve Account,
2547: -- Depreciation Reserve Account
2548: -- and Bonus Deprn Reserve Account
2549: -- from Category Books Cache
2550: IF (NOT fa_cache_pkg.fazccb
2551: (x_book => p_asset_hdr_rec.book_type_code,
2552: x_cat_id => p_asset_cat_rec.category_id,
2553: p_log_level_rec => p_log_level_rec
2554: )

Line 2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;

2556: THEN
2557: RAISE fareven_err;
2558: END IF;
2559:
2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;

Line 2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;

2557: RAISE fareven_err;
2558: END IF;
2559:
2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2565: -- Bonus Deprn - YYOON

Line 2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;

2558: END IF;
2559:
2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2565: -- Bonus Deprn - YYOON
2566: -- Getting the bonus deprn expense

Line 2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

2559:
2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2565: -- Bonus Deprn - YYOON
2566: -- Getting the bonus deprn expense
2567: -- and the bonus deprn reserve account

Line 2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;

2560: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
2561: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
2562: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
2563: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2564: l_deprn_exp_acct := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2565: -- Bonus Deprn - YYOON
2566: -- Getting the bonus deprn expense
2567: -- and the bonus deprn reserve account
2568: -- from asset category

Line 2570: fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;

2566: -- Getting the bonus deprn expense
2567: -- and the bonus deprn reserve account
2568: -- from asset category
2569: l_adj_in.ACCOUNT :=
2570: fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
2571: l_adj_in.ACCOUNT :=
2572: fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
2573: --End of Bonus Deprn Change
2574: l_impairment_rsv_acct :=

Line 2572: fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

2568: -- from asset category
2569: l_adj_in.ACCOUNT :=
2570: fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
2571: l_adj_in.ACCOUNT :=
2572: fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
2573: --End of Bonus Deprn Change
2574: l_impairment_rsv_acct :=
2575: fa_cache_pkg.fazccb_record.impair_reserve_acct;
2576: l_impairment_exp_acct :=

Line 2575: fa_cache_pkg.fazccb_record.impair_reserve_acct;

2571: l_adj_in.ACCOUNT :=
2572: fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
2573: --End of Bonus Deprn Change
2574: l_impairment_rsv_acct :=
2575: fa_cache_pkg.fazccb_record.impair_reserve_acct;
2576: l_impairment_exp_acct :=
2577: fa_cache_pkg.fazccb_record.impair_expense_acct;
2578: l_adj_in.transaction_header_id :=
2579: px_trans_rec.transaction_header_id;

Line 2577: fa_cache_pkg.fazccb_record.impair_expense_acct;

2573: --End of Bonus Deprn Change
2574: l_impairment_rsv_acct :=
2575: fa_cache_pkg.fazccb_record.impair_reserve_acct;
2576: l_impairment_exp_acct :=
2577: fa_cache_pkg.fazccb_record.impair_expense_acct;
2578: l_adj_in.transaction_header_id :=
2579: px_trans_rec.transaction_header_id;
2580: l_adj_in.asset_invoice_id := 0;
2581: l_adj_in.source_type_code := 'REVALUATION';

Line 2801: IF ( nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'

2797: 'px_trans_rec.mass_reference_id',
2798: px_trans_rec.mass_reference_id
2799: , p_log_level_rec => p_log_level_rec);
2800:
2801: IF ( nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
2802: AND p_reval_options_rec.linked_flag = 'YES'
2803: and p_reval_gain is not null
2804: )
2805: THEN

Line 2821: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;

2817: END IF;
2818:
2819: END IF;
2820:
2821: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
2822: IF l_reval_loss_exp <> 0 THEN
2823: l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
2824: l_adj_in.adjustment_type := 'REVAL LOSS';
2825: l_adj_in.adjustment_amount := l_reval_loss_exp;

Line 3042: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

3038: END IF;
3039:
3040: -- Bug#6666666 SORP START
3041: -- Below part is byepassed due to reason these are not part of SORP accounting
3042: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'
3043: THEN
3044: l_adj_in.adjustment_type := 'REVAL RESERVE';
3045:
3046: IF (x_reval_out.impairment_rsv_adj > 0)

Line 3297: IF (NOT fa_cache_pkg.fazccb

3293: px_asset_fin_rec_new.period_counter_life_complete := p_asset_fin_rec_old.period_counter_life_complete;
3294:
3295: IF (p_reval_options_rec.run_mode = 'RUN') THEN
3296:
3297: IF (NOT fa_cache_pkg.fazccb
3298: (x_book => p_asset_hdr_rec.book_type_code,
3299: x_cat_id => p_asset_cat_rec.category_id,
3300: p_log_level_rec => p_log_level_rec))
3301: THEN

Line 3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;

3301: THEN
3302: RAISE farevrl_err;
3303: END IF;
3304:
3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;

Line 3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;

3302: RAISE farevrl_err;
3303: END IF;
3304:
3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

Line 3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;

3303: END IF;
3304:
3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;

Line 3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

3304:
3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
3312:

Line 3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;

3305: l_cost_acct := fa_cache_pkg.fazccb_record.asset_cost_acct;
3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
3312:
3313: IF NOT fa_cache_pkg.fazccmt

Line 3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

3306: l_cip_cost_acct := fa_cache_pkg.fazccb_record.cip_cost_acct;
3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
3312:
3313: IF NOT fa_cache_pkg.fazccmt
3314: (x_method => p_asset_fin_rec_old.deprn_method_code,

Line 3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;

3307: l_reval_rsv_acct := fa_cache_pkg.fazccb_record.reval_reserve_acct;
3308: l_deprn_rsv_acct := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
3312:
3313: IF NOT fa_cache_pkg.fazccmt
3314: (x_method => p_asset_fin_rec_old.deprn_method_code,
3315: x_life => p_asset_fin_rec_old.life_in_months

Line 3313: IF NOT fa_cache_pkg.fazccmt

3309: l_impairment_rsv_acct := fa_cache_pkg.fazccb_record.impair_reserve_acct;
3310: l_bonus_deprn_rsv_acct := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
3311: l_reval_loss_acct := fa_cache_pkg.fazccb_record.reval_loss_acct;
3312:
3313: IF NOT fa_cache_pkg.fazccmt
3314: (x_method => p_asset_fin_rec_old.deprn_method_code,
3315: x_life => p_asset_fin_rec_old.life_in_months
3316: , p_log_level_rec => p_log_level_rec)
3317: THEN

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

3317: THEN
3318: RAISE farevrl_err;
3319: END IF;
3320:
3321: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
3322: l_adj_in.code_combination_id := 0;
3323: l_adj_in.book_type_code := p_asset_hdr_rec.book_type_code;
3324: l_adj_in.period_counter_created := l_last_period_counter + 1;
3325: l_adj_in.asset_id := p_asset_hdr_rec.asset_id;

Line 3592: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

3588: return TRUE;
3589: end if;
3590: --Prepare deprn_rec to call faxcde
3591: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
3592: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
3593: l_dpr_in.book := p_asset_hdr_rec.book_type_code;
3594: l_dpr_in.asset_id := p_asset_hdr_rec.asset_id;
3595: l_dpr_in.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
3596: l_dpr_in.mrc_sob_type_code := p_mrc_sob_type_code;