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

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_GROUP_RECLASS2_PVT AS
2: /* $Header: FAVGRECB.pls 120.71.12020000.2 2013/03/02 19:22:26 dvjoshi ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
8: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 181: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then

177: end if;
178:
179: -- validate intercompany impacts before doing anything else
180: if (l_group_reclass_code <> 'GRP-NONE' and
181: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then
182:
183: if not fa_interco_pvt.validate_grp_interco
184: (p_asset_hdr_rec => p_asset_hdr_rec,
185: p_trans_rec => p_trans_rec,

Line 216: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_old.deprn_method_code,

212: -- Method.
213:
214: -- For Source Group
215: -- Populate Subtract Ytd Flag
216: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_old.deprn_method_code,
217: X_life => p_asset_fin_rec_old.life_in_months, p_log_level_rec => p_log_level_rec) then
218: raise grp_rec_err;
219: end if;
220:

Line 221: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and

217: X_life => p_asset_fin_rec_old.life_in_months, p_log_level_rec => p_log_level_rec) then
218: raise grp_rec_err;
219: end if;
220:
221: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and
222: p_trans_rec.amortization_start_date <> p_asset_fin_rec_old.date_placed_in_service and
223: p_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date then
224: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
225: name => '***FA_AMORT_DATE_SUB***',

Line 233: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,

229: end if;
230:
231: -- For Target Group
232: -- Populate Subtract Ytd Flag
233: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,
234: X_life => p_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
235: raise grp_rec_err;
236: end if;
237:

Line 238: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and

234: X_life => p_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
235: raise grp_rec_err;
236: end if;
237:
238: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and
239: p_trans_rec.amortization_start_date <> p_asset_fin_rec_old.date_placed_in_service and
240: p_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date then
241: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
242: name => '***FA_AMORT_DATE_SUB***',

Line 284: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_old.deprn_method_code,

280: end if;
281:
282: -- For Source Group
283: -- Populate Subtract Ytd Flag
284: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_old.deprn_method_code,
285: X_life => p_asset_fin_rec_old.life_in_months, p_log_level_rec => p_log_level_rec) then
286: raise grp_rec_err;
287: end if;
288:

Line 370: -- if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

366:
367: -- If the deprn basis rule is defined as Year End Balance type,
368: -- new adjusted cost must be calculated based on the entered eofy_reserve
369: -- Need to set adj.eofy_reserve
370: -- if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
371: l_src_asset_fin_rec_adj.eofy_reserve := (-1)*nvl(px_group_reclass_options_rec.source_eofy_reserve,0);
372: -- end if;
373:
374: if (p_log_level_rec.statement_level) then

Line 414: if (not(fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE' and

410: nvl(l_src_asset_fin_rec_old.member_rollup_flag, 'N') = 'N')) then
411:
412: /*Bug 8814747 added this condition for Energy methods amortization date is always current period.
413: So we are calculating the reserve in bsRecalculate. Not required to pass from here.*/
414: if (not(fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE' and
415: l_src_asset_fin_rec_old.tracking_method = 'ALLOCATE')) then
416: OPEN c_get_reserve;
417: FETCH c_get_reserve INTO l_transfer_amount;
418: CLOSE c_get_reserve;

Line 582: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,

578: end if;
579:
580: -- For Source Group
581: -- Populate Subtract Ytd Flag
582: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,
583: X_life => p_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
584: raise grp_rec_err;
585: end if;
586:

Line 664: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

660: end if;
661:
662: -- If the deprn basis rule is defined as Year End Balance type,
663: -- new adjusted cost must be calculated based on the entered eofy_reserve
664: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
665: l_dest_asset_fin_rec_adj.eofy_reserve := nvl(px_group_reclass_options_rec.destination_eofy_reserve,0);
666: end if;
667:
668: --

Line 1076: if not fa_cache_pkg.fazccb

1072: --
1073:
1074:
1075: -- call the category books cache for the accounts
1076: if not fa_cache_pkg.fazccb
1077: (X_book => p_asset_hdr_rec.book_type_code,
1078: X_cat_id => p_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1079: raise grp_rec_err;
1080: end if;

Line 1086: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1082: -- set up the structs to be passed to faxinaj
1083: l_rsv_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1084: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1085: l_rsv_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1086: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1087: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1088: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1089: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1090: l_rsv_adj.selection_thid := 0;

Line 1087: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1083: l_rsv_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1084: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1085: l_rsv_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1086: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1087: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1088: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1089: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1090: l_rsv_adj.selection_thid := 0;
1091: l_rsv_adj.selection_retid := 0;

Line 1105: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1101:
1102: l_exp_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1103: l_exp_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1104: l_exp_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1105: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1106: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1107: l_exp_adj.current_units := p_asset_desc_rec.current_units;
1108: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1109: l_exp_adj.selection_thid := 0;

Line 1106: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

1102: l_exp_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1103: l_exp_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1104: l_exp_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1105: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1106: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1107: l_exp_adj.current_units := p_asset_desc_rec.current_units;
1108: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1109: l_exp_adj.selection_thid := 0;
1110: l_exp_adj.selection_retid := 0;

Line 1133: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;

1129: -- Reserve accounts have to be DR for the old acct
1130:
1131: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1132: l_rsv_adj.adjustment_type := 'RESERVE';
1133: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1134: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1135: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1136: l_rsv_adj.debit_credit_flag := 'DR';
1137:

Line 1134: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

1130:
1131: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1132: l_rsv_adj.adjustment_type := 'RESERVE';
1133: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1134: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1135: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1136: l_rsv_adj.debit_credit_flag := 'DR';
1137:
1138: -- Bug4335926:

Line 1155: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;

1151:
1152: l_exp_adj.source_type_code := 'DEPRECIATION';
1153: l_exp_adj.adjustment_type := 'EXPENSE';
1154: l_exp_adj.code_combination_id := 0;
1155: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1156: l_exp_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1157: l_exp_adj.debit_credit_flag := 'CR';
1158:
1159: else -- (p_src_dest = 'DESTINATION') then

Line 1166: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;

1162: -- Reserve accounts have to be CR for the new acct
1163:
1164: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1165: l_rsv_adj.adjustment_type := 'RESERVE';
1166: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1167: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1168: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1169: l_rsv_adj.debit_credit_flag := 'CR';
1170:

Line 1167: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

1163:
1164: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1165: l_rsv_adj.adjustment_type := 'RESERVE';
1166: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1167: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1168: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1169: l_rsv_adj.debit_credit_flag := 'CR';
1170:
1171: l_exp_adj.source_type_code := 'DEPRECIATION';

Line 1174: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;

1170:
1171: l_exp_adj.source_type_code := 'DEPRECIATION';
1172: l_exp_adj.adjustment_type := 'EXPENSE';
1173: l_exp_adj.code_combination_id := 0;
1174: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1175: l_exp_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1176: l_exp_adj.debit_credit_flag := 'DR';
1177:
1178: end if;

Line 1311: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,

1307:
1308: if (p_src_dest = 'SOURCE') then
1309:
1310: -- Populate Subtract Ytd Flag
1311: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,
1312: X_life => l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
1313: raise grp_rec_err;
1314: end if;
1315:

Line 1363: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

1359: -- In case the Source Method is Year End Balance,
1360: -- Necessary Reserve Amount is NEW Eofy Reserve Amount.
1361: -- Here, the total rsv amount is calculated as New.Eofy - Old.Eofy
1362: -- This may be negative amount.
1363: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1364: if (p_log_level_rec.statement_level) then
1365: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec => p_log_level_rec);
1366: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1367: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);

Line 1382: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

1378: else
1379: l_total_rsv_amount := p_asset_deprn_rec_old.deprn_reserve;
1380: end if;
1381:
1382: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1383: --l_total_rsv_amount := nvl(l_eofy_reserve,0); --DVJ_CCA commented
1384: null;
1385: end if;
1386: end if;

Line 1441: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec => p_log_level_rec);

1437: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1438:
1439: if (p_log_level_rec.statement_level) then
1440: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec => p_log_level_rec);
1441: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec => p_log_level_rec);
1442: end if;
1443:
1444: if ((px_trans_rec.amortization_start_date <> p_mem_asset_fin_rec_new.date_placed_in_service OR
1445: p_src_dest = 'DESTINATION') and

Line 1532: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and

1528: -- In case of Year End Balance, amort date can be set only DPIS of reclassified member or
1529: -- Current Date.
1530: -- If the amort date is set as DPIS of member, all amount is treated as expense.
1531: -- on the other hand, it is treated as reserve.
1532: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and
1533: px_trans_rec.amortization_start_date = p_mem_asset_fin_rec_new.date_placed_in_service then
1534: if (p_src_dest = 'SOURCE') then
1535: l_exp_amount := l_total_rsv_amount;
1536: else

Line 1595: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

1591: l_rsv_adj.adjustment_amount := l_rsv_amount;
1592: l_exp_adj.adjustment_amount := l_exp_amount; -- l_deprn_exp; (need to use one with same sign as tot_rsv)
1593:
1594: -- In case of Year End Balance, back the values into original amount
1595: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1596: l_exp_amount := l_exp_amount_by_system;
1597: end if;
1598: -- if this is the source asset, reset the amount in the
1599: -- reclass structure to be the delta amount as dest will use this

Line 2026: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,

2022: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2023: h_eofy_reserve := p_asset_fin_rec_new.eofy_reserve;
2024:
2025: -- Populate Subtract Ytd Flag
2026: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,
2027: X_life => l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
2028: raise pop_mem_amt_err;
2029: end if;
2030:

Line 2032: h_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

2028: raise pop_mem_amt_err;
2029: end if;
2030:
2031: -- Get Period Counter for current period
2032: h_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
2033:
2034: -- Get Reserve Amount between member's DPIS and current period -- For Source Group Reserve
2035: if p_mrc_sob_type_code <> 'R' then
2036:

Line 2103: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

2099: h_eofy_reserve := h_reserve_dpis_current;
2100: end if;
2101: end if;
2102:
2103: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
2104: h_reserve_dpis_current := nvl(h_eofy_reserve,0);
2105: end if; -- Subtarct Flag
2106:
2107: if (p_src_dest = 'SOURCE') then

Line 2125: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type

2121: into h_period_counter,h_amort_fiscal_year
2122: from fa_fiscal_year fy
2123: , fa_calendar_types ct
2124: , fa_calendar_periods cp
2125: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
2126: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
2127: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2128: and ct.calendar_type = cp.calendar_type
2129: and cp.start_date between fy.start_date and fy.end_date

Line 2126: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name

2122: from fa_fiscal_year fy
2123: , fa_calendar_types ct
2124: , fa_calendar_periods cp
2125: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
2126: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
2127: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2128: and ct.calendar_type = cp.calendar_type
2129: and cp.start_date between fy.start_date and fy.end_date
2130: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >= fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 2127: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

2123: , fa_calendar_types ct
2124: , fa_calendar_periods cp
2125: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
2126: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
2127: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2128: and ct.calendar_type = cp.calendar_type
2129: and cp.start_date between fy.start_date and fy.end_date
2130: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >= fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
2131: and h_amort_start_date between cp.start_date and cp.end_date;

Line 2130: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >= fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

2126: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
2127: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2128: and ct.calendar_type = cp.calendar_type
2129: and cp.start_date between fy.start_date and fy.end_date
2130: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >= fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
2131: and h_amort_start_date between cp.start_date and cp.end_date;
2132:
2133: h_period_counter := h_period_counter - 1;
2134: