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 179: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then

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

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

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

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

217: 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 232: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,

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

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

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

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

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

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

359:
360: -- If the deprn basis rule is defined as Year End Balance type,
361: -- new adjusted cost must be calculated based on the entered eofy_reserve
362: -- Need to set adj.eofy_reserve
363: -- if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
364: l_src_asset_fin_rec_adj.eofy_reserve := (-1)*nvl(px_group_reclass_options_rec.source_eofy_reserve,0);
365: -- end if;
366:
367: if (p_log_level_rec.statement_level) then

Line 482: if not fa_cache_pkg.fazccb

478: if px_group_reclass_options_rec.group_reclass_type = 'CALC' and
479: p_trans_rec.calling_interface <> 'FAXASSET' then
480:
481: -- call the category books cache for the accounts
482: if not fa_cache_pkg.fazccb
483: (X_book => p_asset_hdr_rec.book_type_code,
484: X_cat_id => p_src_asset_cat_rec.category_id) then
485: raise grp_rec_err;
486: end if;

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

488: -- set up the structs to be passed to faxinaj
489: l_rsv_adj.transaction_header_id := px_src_trans_rec.transaction_header_id;
490: l_rsv_adj.asset_id := px_src_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
491: l_rsv_adj.book_type_code := px_src_asset_hdr_rec.book_type_code;
492: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
493: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
494: l_rsv_adj.current_units := p_src_asset_desc_rec.current_units;
495: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
496: l_rsv_adj.selection_thid := 0;

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

489: l_rsv_adj.transaction_header_id := px_src_trans_rec.transaction_header_id;
490: l_rsv_adj.asset_id := px_src_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
491: l_rsv_adj.book_type_code := px_src_asset_hdr_rec.book_type_code;
492: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
493: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
494: l_rsv_adj.current_units := p_src_asset_desc_rec.current_units;
495: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
496: l_rsv_adj.selection_thid := 0;
497: l_rsv_adj.selection_retid := 0;

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

509: -- Reserve accounts have to be DR for the old acct
510:
511: l_rsv_adj.source_type_code := 'ADJUSTMENT';
512: l_rsv_adj.adjustment_type := 'RESERVE';
513: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
514: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
515: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
516: l_rsv_adj.debit_credit_flag := 'DR';
517:

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

510:
511: l_rsv_adj.source_type_code := 'ADJUSTMENT';
512: l_rsv_adj.adjustment_type := 'RESERVE';
513: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
514: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
515: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
516: l_rsv_adj.debit_credit_flag := 'DR';
517:
518: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then

Line 537: if not fa_cache_pkg.fazccb

533: end if;
534:
535: if (l_src_asset_fin_rec_old.tracking_method = 'ALLOCATE') then
536: -- call the category books cache for the accounts
537: if not fa_cache_pkg.fazccb
538: (X_book => p_asset_hdr_rec.book_type_code,
539: X_cat_id => p_asset_cat_rec.category_id) then
540: raise grp_rec_err;
541: end if;

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

547:
548: -- Expense accounts have to be CR for the old acct
549: -- Reserve accounts have to be DR for the old acct
550:
551: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
552: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
553: l_rsv_adj.track_member_flag := 'Y';
554:
555:

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

548: -- Expense accounts have to be CR for the old acct
549: -- Reserve accounts have to be DR for the old acct
550:
551: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
552: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
553: l_rsv_adj.track_member_flag := 'Y';
554:
555:
556: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then

Line 680: fa_cache_pkg.fazcbc_record.distribution_source_book;

676:
677: if (p_mrc_sob_type_code <> 'R') then
678:
679: l_asset_hdr_rec.book_type_code :=
680: fa_cache_pkg.fazcbc_record.distribution_source_book;
681:
682: open c_member_dists (p_asset_id => p_asset_hdr_rec.asset_id);
683: fetch c_member_dists bulk collect
684: into l_distribution_id,

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

760: end if;
761:
762: -- For Source Group
763: -- Populate Subtract Ytd Flag
764: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,
765: X_life => p_asset_fin_rec_new.life_in_months) then
766: raise grp_rec_err;
767: end if;
768:

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

840: end if;
841:
842: -- If the deprn basis rule is defined as Year End Balance type,
843: -- new adjusted cost must be calculated based on the entered eofy_reserve
844: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
845: l_dest_asset_fin_rec_adj.eofy_reserve := nvl(px_group_reclass_options_rec.destination_eofy_reserve,0);
846: end if;
847:
848: --

Line 935: if not fa_cache_pkg.fazccb

931: if px_group_reclass_options_rec.group_reclass_type = 'CALC' and
932: p_trans_rec.calling_interface <> 'FAXASSET' then
933:
934: -- call the category books cache for the accounts
935: if not fa_cache_pkg.fazccb
936: (X_book => p_asset_hdr_rec.book_type_code,
937: X_cat_id => p_dest_asset_cat_rec.category_id) then
938: raise grp_rec_err;
939: end if;

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

941: -- set up the structs to be passed to faxinaj
942: l_rsv_adj.transaction_header_id := px_dest_trans_rec.transaction_header_id;
943: l_rsv_adj.asset_id := px_dest_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
944: l_rsv_adj.book_type_code := px_dest_asset_hdr_rec.book_type_code;
945: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
946: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
947: l_rsv_adj.current_units := p_dest_asset_desc_rec.current_units;
948: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
949: l_rsv_adj.selection_thid := 0;

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

942: l_rsv_adj.transaction_header_id := px_dest_trans_rec.transaction_header_id;
943: l_rsv_adj.asset_id := px_dest_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
944: l_rsv_adj.book_type_code := px_dest_asset_hdr_rec.book_type_code;
945: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
946: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
947: l_rsv_adj.current_units := p_dest_asset_desc_rec.current_units;
948: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
949: l_rsv_adj.selection_thid := 0;
950: l_rsv_adj.selection_retid := 0;

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

962: -- Reserve accounts have to be CR for the new acct
963:
964: l_rsv_adj.source_type_code := 'ADJUSTMENT';
965: l_rsv_adj.adjustment_type := 'RESERVE';
966: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
967: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
968: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
969: l_rsv_adj.debit_credit_flag := 'CR';
970:

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

963:
964: l_rsv_adj.source_type_code := 'ADJUSTMENT';
965: l_rsv_adj.adjustment_type := 'RESERVE';
966: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
967: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
968: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
969: l_rsv_adj.debit_credit_flag := 'CR';
970:
971: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then

Line 991: if not fa_cache_pkg.fazccb

987:
988: if (l_dest_asset_fin_rec_new.tracking_method = 'ALLOCATE') then -- ENERGY
989:
990: -- call the category books cache for the accounts
991: if not fa_cache_pkg.fazccb
992: (X_book => p_asset_hdr_rec.book_type_code,
993: X_cat_id => p_asset_cat_rec.category_id) then
994: raise grp_rec_err;
995: end if;

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

997: -- set up the structs to be passed to faxinaj
998: l_rsv_adj.transaction_header_id := p_trans_rec.transaction_header_id;
999: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id;
1000: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1001: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1002: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1003: l_rsv_adj.debit_credit_flag := 'CR';
1004: l_rsv_adj.track_member_flag := 'Y'; --bug6951739
1005:

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

998: l_rsv_adj.transaction_header_id := p_trans_rec.transaction_header_id;
999: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id;
1000: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1001: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1002: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1003: l_rsv_adj.debit_credit_flag := 'CR';
1004: l_rsv_adj.track_member_flag := 'Y'; --bug6951739
1005:
1006: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then

Line 1316: if not fa_cache_pkg.fazccb

1312: --
1313:
1314:
1315: -- call the category books cache for the accounts
1316: if not fa_cache_pkg.fazccb
1317: (X_book => p_asset_hdr_rec.book_type_code,
1318: X_cat_id => p_asset_cat_rec.category_id) then
1319: raise grp_rec_err;
1320: end if;

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

1322: -- set up the structs to be passed to faxinaj
1323: l_rsv_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1324: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1325: l_rsv_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1326: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1327: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1328: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1329: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1330: l_rsv_adj.selection_thid := 0;

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

1323: l_rsv_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1324: l_rsv_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1325: l_rsv_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1326: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1327: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1328: l_rsv_adj.current_units := p_asset_desc_rec.current_units;
1329: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1330: l_rsv_adj.selection_thid := 0;
1331: l_rsv_adj.selection_retid := 0;

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

1340:
1341: l_exp_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1342: l_exp_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1343: l_exp_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1344: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1345: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1346: l_exp_adj.current_units := p_asset_desc_rec.current_units;
1347: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1348: l_exp_adj.selection_thid := 0;

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

1341: l_exp_adj.transaction_header_id := px_trans_rec.transaction_header_id;
1342: l_exp_adj.asset_id := p_asset_hdr_rec.asset_id; -- p_asset_fin_rec_new.group_asset_id;
1343: l_exp_adj.book_type_code := p_asset_hdr_rec.book_type_code;
1344: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1345: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1346: l_exp_adj.current_units := p_asset_desc_rec.current_units;
1347: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1348: l_exp_adj.selection_thid := 0;
1349: l_exp_adj.selection_retid := 0;

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

1367: -- Reserve accounts have to be DR for the old acct
1368:
1369: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1370: l_rsv_adj.adjustment_type := 'RESERVE';
1371: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1372: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1373: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1374: l_rsv_adj.debit_credit_flag := 'DR';
1375:

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

1368:
1369: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1370: l_rsv_adj.adjustment_type := 'RESERVE';
1371: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1372: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1373: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1374: l_rsv_adj.debit_credit_flag := 'DR';
1375:
1376: -- Bug4335926:

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

1396:
1397: l_exp_adj.source_type_code := 'DEPRECIATION';
1398: l_exp_adj.adjustment_type := 'EXPENSE';
1399: l_exp_adj.code_combination_id := 0;
1400: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1401: l_exp_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1402: l_exp_adj.debit_credit_flag := 'CR';
1403:
1404: else -- (p_src_dest = 'DESTINATION') then

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

1407: -- Reserve accounts have to be CR for the new acct
1408:
1409: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1410: l_rsv_adj.adjustment_type := 'RESERVE';
1411: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1412: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1413: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1414: l_rsv_adj.debit_credit_flag := 'CR';
1415:

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

1408:
1409: l_rsv_adj.source_type_code := 'ADJUSTMENT';
1410: l_rsv_adj.adjustment_type := 'RESERVE';
1411: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
1412: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
1413: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
1414: l_rsv_adj.debit_credit_flag := 'CR';
1415:
1416: l_exp_adj.source_type_code := 'DEPRECIATION';

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

1415:
1416: l_exp_adj.source_type_code := 'DEPRECIATION';
1417: l_exp_adj.adjustment_type := 'EXPENSE';
1418: l_exp_adj.code_combination_id := 0;
1419: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1420: l_exp_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1421: l_exp_adj.debit_credit_flag := 'DR';
1422:
1423: end if;

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

1553:
1554: if (p_src_dest = 'SOURCE') then
1555:
1556: -- Populate Subtract Ytd Flag
1557: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,
1558: X_life => l_asset_fin_rec_new.life_in_months) then
1559: raise grp_rec_err;
1560: end if;
1561:

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

1605: -- In case the Source Method is Year End Balance,
1606: -- Necessary Reserve Amount is NEW Eofy Reserve Amount.
1607: -- Here, the total rsv amount is calculated as New.Eofy - Old.Eofy
1608: -- This may be negative amount.
1609: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1610: if (p_log_level_rec.statement_level) then
1611: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec);
1612: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1613: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);

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

1624: else
1625: l_total_rsv_amount := p_asset_deprn_rec_old.deprn_reserve;
1626: end if;
1627:
1628: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1629: l_total_rsv_amount := nvl(l_eofy_reserve,0);
1630: end if;
1631: end if;
1632:

Line 1686: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec);

1682: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1683:
1684: if (p_log_level_rec.statement_level) then
1685: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec);
1686: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec);
1687: end if;
1688:
1689: if ((px_trans_rec.amortization_start_date <>
1690: p_mem_asset_fin_rec_new.date_placed_in_service or

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

1779: -- In case of Year End Balance, amort date can be set only DPIS of reclassified member or
1780: -- Current Date.
1781: -- If the amort date is set as DPIS of member, all amount is treated as expense.
1782: -- on the other hand, it is treated as reserve.
1783: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' and
1784: px_trans_rec.amortization_start_date = p_mem_asset_fin_rec_new.date_placed_in_service then
1785: if (p_src_dest = 'SOURCE') then
1786: l_exp_amount := l_total_rsv_amount;
1787: else

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

1842: l_rsv_adj.adjustment_amount := l_rsv_amount;
1843: l_exp_adj.adjustment_amount := l_exp_amount; -- l_deprn_exp; (need to use one with same sign as tot_rsv)
1844:
1845: -- In case of Year End Balance, back the values into original amount
1846: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1847: l_exp_amount := l_exp_amount_by_system;
1848: end if;
1849: -- if this is the source asset, reset the amount in the
1850: -- reclass structure to be the delta amount as dest will use this

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

2259: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2260: h_eofy_reserve := p_asset_fin_rec_new.eofy_reserve;
2261:
2262: -- Populate Subtract Ytd Flag
2263: if not fa_cache_pkg.fazccmt(X_method => l_asset_fin_rec_new.deprn_method_code,
2264: X_life => l_asset_fin_rec_new.life_in_months) then
2265: raise pop_mem_amt_err;
2266: end if;
2267:

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

2265: raise pop_mem_amt_err;
2266: end if;
2267:
2268: -- Get Period Counter for current period
2269: h_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
2270:
2271: -- Get Reserve Amount between member's DPIS and current period -- For Source Group Reserve
2272: if p_mrc_sob_type_code <> 'R' then
2273:

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

2336: h_eofy_reserve := h_reserve_dpis_current;
2337: end if;
2338: end if;
2339:
2340: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
2341: h_reserve_dpis_current := nvl(h_eofy_reserve,0);
2342: end if; -- Subtarct Flag
2343:
2344: if (p_src_dest = 'SOURCE') then