DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_CACHE_PKG

Line 60: fa_cache_pkg.fazcdrd_record.period_update_flag = 'Y') and -- ENERGY

56: end if;
57:
58: end if;
59: elsif (px_rule_in.method_type = 'PRODUCTION' and
60: fa_cache_pkg.fazcdrd_record.period_update_flag = 'Y') and -- ENERGY
61: (px_rule_in.event_type <> 'AMORT_ADJ3') then -- ENERGY
62: -- -- ENERGY
63: -- There should be no EXPENSED ADJUSTMENT for now and CURRRENT -- ENERGY
64: -- period amortized adjustment is only allowed. -- ENERGY

Line 77: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

73: px_rule_in.impairment_reserve; -- ENERGY -- IAS36
74: end if;
75:
76: elsif (px_rule_in.method_type = 'CALCULATED') and
77: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
78: (px_rule_in.event_type not in ('AMORT_ADJ3','UNPLANNED_ADJ')) then
79:
80: if px_rule_in.recoverable_cost = 0 then
81: px_rule_out.new_adjusted_cost := 0;

Line 118: fa_debug_pkg.add('NSF', 'fa_cache_pkg.fazcdrd_record.period_update_flag', fa_cache_pkg.fazcdrd_record.period_update_flag, p_log_level_rec => p_log_level_rec);

114: end if;
115:
116: if p_log_level_rec.statement_level then
117: fa_debug_pkg.add('NSF', 'px_rule_in.method_type', px_rule_in.method_type, p_log_level_rec => p_log_level_rec);
118: fa_debug_pkg.add('NSF', 'fa_cache_pkg.fazcdrd_record.period_update_flag', fa_cache_pkg.fazcdrd_record.period_update_flag, p_log_level_rec => p_log_level_rec);
119: fa_debug_pkg.add('NSF', 'px_rule_in.recoverable_cost', px_rule_in.recoverable_cost, p_log_level_rec => p_log_level_rec);
120: fa_debug_pkg.add('NSF', 'px_rule_in.current_total_rsv', px_rule_in.current_total_rsv, p_log_level_rec => p_log_level_rec);
121: fa_debug_pkg.add('NSF', 'px_rule_in.unplanned_amount', px_rule_in.unplanned_amount, p_log_level_rec => p_log_level_rec);
122: fa_debug_pkg.add('NSF', 'new_adjusted_cost', px_rule_out.new_adjusted_cost, p_log_level_rec => p_log_level_rec);

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

147: -------------------------------------------------------------
148: if (px_rule_in.event_type ='DEPRECIATE_FLAG_ADJ') then
149:
150: -- Bug fix 6366379 (Added if part)
151: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
152:
153: if p_log_level_rec.statement_level then
154: fa_debug_pkg.add('faxcd2b', '+++ Inside Guarantee Logic', 'YES', p_log_level_rec => p_log_level_rec);
155: end if;

Line 165: fa_debug_pkg.add('faxcdb2b', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec => p_log_level_rec);

161: AND book_type_code = px_rule_in.book_type_code
162: AND date_ineffective is null;
163:
164: if p_log_level_rec.statement_level then
165: fa_debug_pkg.add('faxcdb2b', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add('faxcdb2b', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec => p_log_level_rec);
167: end if;
168:
169: if fa_cache_pkg.fazcfor_record.revised_rate = l_rate_in_use then

Line 169: if fa_cache_pkg.fazcfor_record.revised_rate = l_rate_in_use then

165: fa_debug_pkg.add('faxcdb2b', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add('faxcdb2b', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec => p_log_level_rec);
167: end if;
168:
169: if fa_cache_pkg.fazcfor_record.revised_rate = l_rate_in_use then
170: Null; -- Dont change adjusted cost.
171: else
172:
173: if p_log_level_rec.statement_level then

Line 964: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'Y%') then

960: px_rule_out.new_adjusted_cost := px_rule_in.cost - px_rule_in.current_total_rsv - NVL(px_rule_in.impairment_reserve,0) - NVL(px_rule_in.salvage_value,0);
961: -- Bug 14072769 start
962: -- Added following code to calculate correct adj cost for FLAT/NBV methods
963:
964: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'Y%') then
965: px_rule_out.new_adjusted_cost := px_rule_in.cost - (px_rule_in.current_total_rsv - px_rule_in.current_total_ytd )
966: - NVL(px_rule_in.impairment_reserve,0) - NVL(px_rule_in.salvage_value,0);
967:
968: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'N%') then

Line 968: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'N%') then

964: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'Y%') then
965: px_rule_out.new_adjusted_cost := px_rule_in.cost - (px_rule_in.current_total_rsv - px_rule_in.current_total_ytd )
966: - NVL(px_rule_in.impairment_reserve,0) - NVL(px_rule_in.salvage_value,0);
967:
968: elsif (px_rule_in.calc_basis = 'NBV' and NVL(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,'N') like 'N%') then
969: px_rule_out.new_adjusted_cost := px_rule_in.cost - (px_rule_in.current_total_rsv - px_rule_in.current_total_ytd )
970: - NVL(px_rule_in.impairment_reserve,0);
971: --Bug 14072769 end
972: end if; -- End if Deprn Basis = COST

Line 1062: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

1058: OPEN C_EXC_FULLY_RSV_FLAG;
1059: FETCH C_EXC_FULLY_RSV_FLAG into l_exclude_fully_rsv_flag;
1060: CLOSE C_EXC_FULLY_RSV_FLAG;
1061: /*Bug# 7462260 Added to fetch set_of_books_id from cache*/
1062: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1063:
1064: else -- MRC
1065:
1066: OPEN C_EXC_FULLY_RSV_FLAG_M;

Line 1070: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

1066: OPEN C_EXC_FULLY_RSV_FLAG_M;
1067: FETCH C_EXC_FULLY_RSV_FLAG_M into l_exclude_fully_rsv_flag;
1068: CLOSE C_EXC_FULLY_RSV_FLAG_M;
1069: /*Bug# 7462260 Added to fetch set_of_books_id from cache*/
1070: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
1071: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
1072:
1073: end if;
1074:

Line 1071: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

1067: FETCH C_EXC_FULLY_RSV_FLAG_M into l_exclude_fully_rsv_flag;
1068: CLOSE C_EXC_FULLY_RSV_FLAG_M;
1069: /*Bug# 7462260 Added to fetch set_of_books_id from cache*/
1070: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
1071: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
1072:
1073: end if;
1074:
1075: if p_log_level_rec.statement_level then

Line 1277: if fa_cache_pkg.fazccmt(px_rule_in.method_code,

1273: -- new adjusted cost.
1274: -- If not, Reduce fully reserved adjusted cost only
1275: -------------------------------------------------------------------------
1276:
1277: if fa_cache_pkg.fazccmt(px_rule_in.method_code,
1278: px_rule_in.life_in_months, p_log_level_rec => p_log_level_rec) then
1279:
1280: if p_log_level_rec.statement_level then
1281: fa_debug_pkg.add(l_function, 'fazccmt', 'Called', p_log_level_rec => p_log_level_rec);

Line 1284: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;

1280: if p_log_level_rec.statement_level then
1281: fa_debug_pkg.add(l_function, 'fazccmt', 'Called', p_log_level_rec => p_log_level_rec);
1282: end if;
1283:
1284: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;
1285: end if;
1286:
1287: if Upper(l_exclude_salvage_value_flag) like 'Y%' and
1288: px_rule_in.calc_basis= 'NBV' then

Line 1718: if fa_cache_pkg.fazccmt(px_rule_in.method_code,

1714: -- Check exclude salvage value flag.
1715: -- And if exclude salvage value flag is Yes,
1716: -- reduce salvage value from new adjusted cost
1717: ---------------------------------------------------------------------------
1718: if fa_cache_pkg.fazccmt(px_rule_in.method_code,
1719: px_rule_in.life_in_months, p_log_level_rec => p_log_level_rec) then
1720:
1721: if p_log_level_rec.statement_level then
1722: fa_debug_pkg.add(fname=>'period_average',

Line 1727: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;

1723: element=>'fazccmt',
1724: value=> 'Called', p_log_level_rec => p_log_level_rec);
1725: end if;
1726:
1727: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;
1728:
1729: end if;
1730:
1731:

Line 2151: if fa_cache_pkg.fazccmt(px_rule_in.method_code,

2147: -- And if exclude salvage value flag is Yes,
2148: -- reduce salvage value from new adjusted cost
2149: ------------------------------------------------------------
2150:
2151: if fa_cache_pkg.fazccmt(px_rule_in.method_code,
2152: px_rule_in.life_in_months, p_log_level_rec => p_log_level_rec) then
2153:
2154: if p_log_level_rec.statement_level then
2155: fa_debug_pkg.add(fname=>'ytd_average',

Line 2160: l_exclude_salvage_value_flag := nvl(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,0);

2156: element=>'fazccmt',
2157: value=> 'Called', p_log_level_rec => p_log_level_rec);
2158: end if;
2159:
2160: l_exclude_salvage_value_flag := nvl(fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,0);
2161:
2162: end if;
2163:
2164:

Line 3002: if not fa_cache_pkg.fazcdp

2998: -- Event Type: INITIAL_ADDITION
2999: ----------------------------------------------------------------
3000: if (px_rule_in.event_type in ('ADDITION', 'INITIAL_ADDITION')) THEN
3001:
3002: if not fa_cache_pkg.fazcdp
3003: (x_book_type_code => px_rule_in.book_type_code,
3004: x_period_counter => px_rule_in.period_counter,
3005: x_effective_date => null, p_log_level_rec => p_log_level_rec) then
3006: raise calc_basis_err;

Line 3014: fa_cache_pkg.fazcdp_record.calendar_period_open_date) and

3010: -- Bug4115689: Added check against reserve and set adj_cost
3011: -- to rec cost ONLY if this addition is with reserve
3012: --
3013: if (px_rule_in.transaction_date_entered <
3014: fa_cache_pkg.fazcdp_record.calendar_period_open_date) and
3015: ((nvl(px_rule_in.adj_reserve, 0) <> 0) or
3016: (nvl(px_rule_in.current_rsv, 0) <> 0)) then
3017:
3018: if px_rule_in.calc_basis='COST' then

Line 3154: if fa_cache_pkg.fazccmt(px_rule_in.method_code,

3150: -- Check exclude salvage value flag.
3151: -- And if exclude salvage value flag is Yes,
3152: -- reduce salvage value from new adjusted cost
3153: ---------------------------------------------------------------------------
3154: if fa_cache_pkg.fazccmt(px_rule_in.method_code,
3155: px_rule_in.life_in_months, p_log_level_rec => p_log_level_rec) then
3156:
3157: if p_log_level_rec.statement_level then
3158: fa_debug_pkg.add(fname=>'beginning_period',

Line 3163: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;

3159: element=>'fazccmt',
3160: value=> 'Called', p_log_level_rec => p_log_level_rec);
3161: end if;
3162:
3163: l_exclude_salvage_value_flag := fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag;
3164:
3165: end if;
3166:
3167: