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

Line 8: g_release number := fa_cache_pkg.fazarel_release;

4: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
5: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
6:
7: g_log_level_rec fa_api_types.log_level_rec_type;
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: --*********************** Private functions ******************************--
11: -- private declaration for books (mrc) wrapper
12: FUNCTION do_all_books(

Line 46: g_release := fa_cache_pkg.fazarel_release;

42: raise FND_API.G_EXC_ERROR;
43: end if;
44: end if;
45:
46: g_release := fa_cache_pkg.fazarel_release;
47:
48: fa_srvr_msg.Init_Server_Message; -- Initialize server message stack
49: fa_debug_pkg.Initialize; -- Initialize debug message stack
50:

Line 146: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
143:
144: l_trx_ref_rec fa_api_types.trx_ref_rec_type;
145:
146: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
147: l_mrc_sob_type_code varchar2(1);
148:
149: l_source_asset_id number;
150: l_dest_asset_id number;

Line 485: if not FA_CACHE_PKG.fazcrsob

481: 'begin', p_log_level_rec => g_log_level_rec);
482: end if;
483:
484: -- call the sob cache to get the table of sob_ids
485: if not FA_CACHE_PKG.fazcrsob
486: (x_book_type_code => p_book,
487: x_sob_tbl => l_sob_tbl, p_log_level_rec => g_log_level_rec) then
488: raise group_adj_err;
489: end if;

Line 492: if NOT fa_cache_pkg.fazcbc(X_book => p_book, p_log_level_rec => g_log_level_rec) then

488: raise group_adj_err;
489: end if;
490:
491: -- call the book_controls cache
492: if NOT fa_cache_pkg.fazcbc(X_book => p_book, p_log_level_rec => g_log_level_rec) then
493: raise group_adj_err;
494: end if;
495:
496: l_source_asset_id := nvl(p_source_group_asset_id, -1);

Line 509: if NOT fa_cache_pkg.fazcbc(X_book => p_book,

505: end if;
506: loop
507:
508: -- recall the book_controls cache for each trx
509: if NOT fa_cache_pkg.fazcbc(X_book => p_book,
510: p_log_level_rec => g_log_level_rec) then
511: raise group_adj_err;
512: end if;
513:

Line 578: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

574: close get_old_trx;
575:
576: l_asset_hdr_rec.asset_id := l_asset_id;
577: l_asset_hdr_rec.book_type_code := p_book;
578: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
579:
580: if (g_log_level_rec.statement_level) then
581: fa_debug_pkg.add('do_pending_groups.do_all_books',
582: 'fetched asset and trx',

Line 592: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

588: -- call the private API for each
589: FOR l_sob_index in 0..l_sob_tbl.count LOOP
590: if (l_sob_index = 0) then
591: l_mrc_sob_type_code := 'P';
592: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
593:
594: -- SLA uptake - set event status from incomplete to unprocessed
595: -- need to determine original event type in this case
596: --

Line 702: if NOT fa_cache_pkg.fazcbcs(X_book => p_book,

698: end if;
699:
700: -- call the cache to set the sob_id used for rounding and other lower
701: -- level code for each book.
702: if NOT fa_cache_pkg.fazcbcs(X_book => p_book,
703: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
704: p_log_level_rec => g_log_level_rec)
705: then
706: raise group_adj_err;

Line 1032: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,

1028: (P_book_type_code => l_asset_hdr_rec.book_type_code,
1029: P_group_asset_id => l_asset_hdr_rec.asset_id,
1030: P_period_counter => l_period_rec.period_num,
1031: P_fiscal_year => l_period_rec.fiscal_year,
1032: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1033: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1034: P_group_bonus_rule => l_asset_fin_rec_new.bonus_rule,
1035: P_group_deprn_amount => l_deprn_exp,
1036: P_group_bonus_amount => l_bonus_deprn_exp,

Line 1033: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,

1029: P_group_asset_id => l_asset_hdr_rec.asset_id,
1030: P_period_counter => l_period_rec.period_num,
1031: P_fiscal_year => l_period_rec.fiscal_year,
1032: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1033: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1034: P_group_bonus_rule => l_asset_fin_rec_new.bonus_rule,
1035: P_group_deprn_amount => l_deprn_exp,
1036: P_group_bonus_amount => l_bonus_deprn_exp,
1037: P_tracking_method => l_asset_fin_rec_new.tracking_method,

Line 1131: if not fa_cache_pkg.fazccmt(l_asset_fin_rec_new.deprn_method_code

1127: raise group_adj_err;
1128: end if;
1129:
1130: if (l_mrc_sob_type_code <> 'R') then
1131: if not fa_cache_pkg.fazccmt(l_asset_fin_rec_new.deprn_method_code
1132: , l_asset_fin_rec_new.life_in_months, p_log_level_rec => g_log_level_rec) then
1133: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1134: raise group_adj_err;
1135: end if;

Line 1156: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,

1152: (P_book_type_code => l_asset_hdr_rec.book_type_code,
1153: P_group_asset_id => l_asset_hdr_rec.asset_id,
1154: P_period_counter => l_period_rec.period_num,
1155: P_fiscal_year => l_period_rec.fiscal_year,
1156: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1157: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1158: P_group_bonus_rule => l_asset_fin_rec_new.bonus_rule,
1159: P_group_deprn_amount => l_unplanned_deprn_rec.unplanned_amount,
1160: P_group_bonus_amount => 0,

Line 1157: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,

1153: P_group_asset_id => l_asset_hdr_rec.asset_id,
1154: P_period_counter => l_period_rec.period_num,
1155: P_fiscal_year => l_period_rec.fiscal_year,
1156: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1157: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1158: P_group_bonus_rule => l_asset_fin_rec_new.bonus_rule,
1159: P_group_deprn_amount => l_unplanned_deprn_rec.unplanned_amount,
1160: P_group_bonus_amount => 0,
1161: P_tracking_method => l_asset_fin_rec_new.tracking_method,

Line 1550: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

1546: and book_type_code = p_trx_ref_rec.book_type_code
1547: order by trx_reference_id desc;
1548:
1549: --Bug 8941132 Start
1550: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1551:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;

Line 1587: if not FA_CACHE_PKG.fazcrsob

1583: 'in do_group_reclass', p_log_level_rec => p_log_level_rec);
1584: end if;
1585:
1586: -- Bug 8941132: call the sob cache to get the table of sob_ids
1587: if not FA_CACHE_PKG.fazcrsob
1588: (x_book_type_code => p_trx_ref_rec.book_type_code,
1589: x_sob_tbl => l_sob_tbl,
1590: p_log_level_rec => p_log_level_rec) then
1591: raise group_rec_err;

Line 1597: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1593:
1594: -- get the member asset recs
1595: l_mem_asset_hdr_rec.asset_id := p_trx_ref_rec.member_asset_id;
1596: l_mem_asset_hdr_rec.book_type_code := p_trx_ref_rec.book_type_code;
1597: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1598:
1599: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1600:
1601: if (p_log_level_rec.statement_level) then

Line 1599: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1595: l_mem_asset_hdr_rec.asset_id := p_trx_ref_rec.member_asset_id;
1596: l_mem_asset_hdr_rec.book_type_code := p_trx_ref_rec.book_type_code;
1597: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1598:
1599: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1600:
1601: if (p_log_level_rec.statement_level) then
1602: fa_debug_pkg.add('do_group_reclass',
1603: 'member_asset_id START',

Line 1898: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1894: FOR l_sob_index in 0..l_sob_tbl.count LOOP
1895:
1896: if (l_sob_index = 0) then
1897: l_mrc_sob_type_code := 'P';
1898: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1899: else
1900: l_mrc_sob_type_code := 'R';
1901: l_mem_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);
1902: end if;

Line 1932: l_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1928: FA_AMORT_PVT.initMemberTable;
1929:
1930: if (l_sob_index = 0) then
1931: l_mrc_sob_type_code := 'P';
1932: l_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1933: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1934: else
1935: l_mrc_sob_type_code := 'R';
1936: l_src_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);

Line 1933: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1929:
1930: if (l_sob_index = 0) then
1931: l_mrc_sob_type_code := 'P';
1932: l_src_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1933: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1934: else
1935: l_mrc_sob_type_code := 'R';
1936: l_src_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);
1937: l_mem_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);

Line 1994: if not fa_cache_pkg.fazccmt(l_src_asset_fin_rec_old.deprn_method_code,

1990: p_log_level_rec => p_log_level_rec) then raise group_rec_err;
1991: end if;
1992:
1993: /*Bug 8765735 - Start*/
1994: if not fa_cache_pkg.fazccmt(l_src_asset_fin_rec_old.deprn_method_code,
1995: l_src_asset_fin_rec_old.life_in_months,
1996: p_log_level_rec => g_log_level_rec) then
1997: fa_srvr_msg.add_message (calling_fn => l_calling_fn,p_log_level_rec=>g_log_level_rec);
1998: raise group_rec_err;

Line 2003: if (not(nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') = 'ENERGY PERIOD END BALANCE' and

1999: end if;
2000: /*Bug 8765735 - End*/
2001: /*Bug 8814747 added this condition for Energy methods amortization date is always current period.
2002: So we are calculating the reserve in bsRecalculate. Not required to pass from here.*/
2003: if (not(nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') = 'ENERGY PERIOD END BALANCE' and
2004: l_src_asset_fin_rec_old.tracking_method = 'ALLOCATE')) then
2005:
2006: if (l_src_asset_fin_rec_old.tracking_method = 'ALLOCATE' or
2007: (l_src_asset_fin_rec_old.tracking_method = 'CALCULATE' and

Line 2079: if not fa_cache_pkg.fazccb

2075: END LOOP;
2076: End If;
2077:
2078: -- call the category books cache for the accounts
2079: if not fa_cache_pkg.fazccb
2080: (X_book => l_src_asset_hdr_rec.book_type_code,
2081: X_cat_id => l_src_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2082: raise group_rec_err;
2083: end if;

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

2083: end if;
2084:
2085: -- set up the structs to be passed to faxinaj
2086: l_rsv_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2087: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2088: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2089: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2090: l_rsv_adj.selection_thid := 0;
2091: l_rsv_adj.selection_retid := 0;

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

2084:
2085: -- set up the structs to be passed to faxinaj
2086: l_rsv_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2087: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2088: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2089: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2090: l_rsv_adj.selection_thid := 0;
2091: l_rsv_adj.selection_retid := 0;
2092: l_rsv_adj.leveling_flag := TRUE;

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

2099: l_rsv_adj.mrc_sob_type_code := l_mrc_sob_type_code;
2100: l_rsv_adj.set_of_books_id := l_src_asset_hdr_rec.set_of_books_id;
2101: l_rsv_adj.source_type_code := 'ADJUSTMENT';
2102: l_rsv_adj.adjustment_type := 'RESERVE';
2103: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2104: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2105: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
2106:
2107: l_rsv_adj.transaction_header_id := l_src_trans_rec.transaction_header_id;

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

2100: l_rsv_adj.set_of_books_id := l_src_asset_hdr_rec.set_of_books_id;
2101: l_rsv_adj.source_type_code := 'ADJUSTMENT';
2102: l_rsv_adj.adjustment_type := 'RESERVE';
2103: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2104: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2105: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
2106:
2107: l_rsv_adj.transaction_header_id := l_src_trans_rec.transaction_header_id;
2108: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;

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

2106:
2107: l_rsv_adj.transaction_header_id := l_src_trans_rec.transaction_header_id;
2108: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2109: l_rsv_adj.current_units := l_src_asset_desc_rec.current_units;
2110: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2111: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2112: l_rsv_adj.debit_credit_flag := 'DR';
2113:
2114:

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

2107: l_rsv_adj.transaction_header_id := l_src_trans_rec.transaction_header_id;
2108: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2109: l_rsv_adj.current_units := l_src_asset_desc_rec.current_units;
2110: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2111: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2112: l_rsv_adj.debit_credit_flag := 'DR';
2113:
2114:
2115: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;

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

2112: l_rsv_adj.debit_credit_flag := 'DR';
2113:
2114:
2115: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2116: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2117: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2118: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2119: l_exp_adj.selection_thid := 0;
2120: l_exp_adj.selection_retid := 0;

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

2113:
2114:
2115: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2116: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2117: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2118: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2119: l_exp_adj.selection_thid := 0;
2120: l_exp_adj.selection_retid := 0;
2121: l_exp_adj.leveling_flag := TRUE;

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

2134: l_exp_adj.transaction_header_id := l_src_trans_rec.transaction_header_id;
2135: l_exp_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2136: l_exp_adj.current_units := l_src_asset_desc_rec.current_units;
2137: l_exp_adj.code_combination_id := 0;
2138: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2139: l_exp_adj.debit_credit_flag := 'CR';
2140:
2141: -- Expense accounts have to be CR for the old acct
2142: -- Reserve accounts have to be DR for the old acct

Line 2165: if not fa_cache_pkg.fazccb

2161:
2162: if (nvl(l_src_asset_fin_rec_old.tracking_method, 'NO TRACK') = 'ALLOCATE') then
2163:
2164: -- call the category books cache for the accounts
2165: if not fa_cache_pkg.fazccb
2166: (X_book => l_mem_asset_hdr_rec.book_type_code,
2167: X_cat_id => l_mem_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2168: raise group_rec_err;
2169: end if;

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

2170:
2171: l_exp_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2172: l_exp_adj.current_units := l_mem_asset_desc_rec.current_units;
2173: l_exp_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2174: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2175: l_exp_adj.track_member_flag := 'Y';
2176:
2177: if (p_log_level_rec.statement_level) then
2178: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for exp source track', p_log_level_rec => p_log_level_rec);

Line 2214: if not fa_cache_pkg.fazccb

2210:
2211: if (nvl(l_src_asset_fin_rec_old.tracking_method,'NO TRACK')='ALLOCATE') then
2212:
2213: -- call the category books cache for the accounts
2214: if not fa_cache_pkg.fazccb
2215: (X_book => l_mem_asset_hdr_rec.book_type_code,
2216: X_cat_id => l_mem_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2217: raise group_rec_err;
2218: end if;

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

2219:
2220: l_rsv_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2221: l_rsv_adj.current_units := l_mem_asset_desc_rec.current_units;
2222: l_rsv_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2223: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2224: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2225: l_rsv_adj.track_member_flag := 'Y';
2226:
2227: if (p_log_level_rec.statement_level) then

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

2220: l_rsv_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2221: l_rsv_adj.current_units := l_mem_asset_desc_rec.current_units;
2222: l_rsv_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2223: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2224: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2225: l_rsv_adj.track_member_flag := 'Y';
2226:
2227: if (p_log_level_rec.statement_level) then
2228: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv source track', p_log_level_rec => p_log_level_rec);

Line 2361: l_asset_hdr_rec.book_type_code := fa_cache_pkg.fazcbc_record.distribution_source_book;

2357: fa_debug_pkg.add(l_calling_fn, 'calling' ,'transfer api for standalone asset', p_log_level_rec => p_log_level_rec);
2358: end if;
2359:
2360: l_asset_hdr_rec := l_mem_asset_hdr_rec;
2361: l_asset_hdr_rec.book_type_code := fa_cache_pkg.fazcbc_record.distribution_source_book;
2362:
2363: FA_TRANSFER_PUB.do_transfer
2364: (p_api_version => l_api_version,
2365: p_init_msg_list => l_init_msg_list,

Line 2427: l_dest_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

2423: FA_AMORT_PVT.initMemberTable;
2424:
2425: if (l_sob_index = 0) then
2426: l_mrc_sob_type_code := 'P';
2427: l_dest_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2428: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2429: else
2430: l_mrc_sob_type_code := 'R';
2431: l_dest_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);

Line 2428: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

2424:
2425: if (l_sob_index = 0) then
2426: l_mrc_sob_type_code := 'P';
2427: l_dest_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2428: l_mem_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2429: else
2430: l_mrc_sob_type_code := 'R';
2431: l_dest_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);
2432: l_mem_asset_hdr_rec.set_of_books_id := l_sob_tbl(l_sob_index);

Line 2560: if not fa_cache_pkg.fazccb

2556: l_grp_dest_asset_type_rec(l_sob_index) := l_dest_asset_type_rec;
2557: l_grp_dest_asset_fin_rec_new(l_sob_index) := l_dest_asset_fin_rec_new;
2558:
2559: -- call the category books cache for the accounts
2560: if not fa_cache_pkg.fazccb
2561: (X_book => l_dest_asset_hdr_rec.book_type_code,
2562: X_cat_id => l_dest_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2563: raise group_rec_err;
2564: end if;

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

2564: end if;
2565:
2566: -- set up the structs to be passed to faxinaj
2567: l_rsv_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2568: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2569: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2570: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2571: l_rsv_adj.selection_thid := 0;
2572: l_rsv_adj.selection_retid := 0;

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

2565:
2566: -- set up the structs to be passed to faxinaj
2567: l_rsv_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2568: l_rsv_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2569: l_rsv_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2570: l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2571: l_rsv_adj.selection_thid := 0;
2572: l_rsv_adj.selection_retid := 0;
2573: l_rsv_adj.leveling_flag := TRUE;

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

2580: l_rsv_adj.mrc_sob_type_code := l_mrc_sob_type_code;
2581: l_rsv_adj.set_of_books_id := l_dest_asset_hdr_rec.set_of_books_id;
2582: l_rsv_adj.source_type_code := 'ADJUSTMENT';
2583: l_rsv_adj.adjustment_type := 'RESERVE';
2584: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2585: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2586: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
2587:
2588: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;

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

2581: l_rsv_adj.set_of_books_id := l_dest_asset_hdr_rec.set_of_books_id;
2582: l_rsv_adj.source_type_code := 'ADJUSTMENT';
2583: l_rsv_adj.adjustment_type := 'RESERVE';
2584: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2585: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2586: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
2587:
2588: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2589: l_rsv_adj.current_units := l_src_asset_desc_rec.current_units;

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

2586: l_rsv_adj.account_type := 'DEPRN_RESERVE_ACCT';
2587:
2588: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2589: l_rsv_adj.current_units := l_src_asset_desc_rec.current_units;
2590: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2591: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2592: l_rsv_adj.debit_credit_flag := 'CR';
2593:
2594: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;

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

2587:
2588: l_rsv_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2589: l_rsv_adj.current_units := l_src_asset_desc_rec.current_units;
2590: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2591: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2592: l_rsv_adj.debit_credit_flag := 'CR';
2593:
2594: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2595: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

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

2591: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2592: l_rsv_adj.debit_credit_flag := 'CR';
2593:
2594: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2595: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2596: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2597: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2598: l_exp_adj.selection_thid := 0;
2599: l_exp_adj.selection_retid := 0;

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

2592: l_rsv_adj.debit_credit_flag := 'CR';
2593:
2594: l_exp_adj.book_type_code := l_src_asset_hdr_rec.book_type_code;
2595: l_exp_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2596: l_exp_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2597: l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2598: l_exp_adj.selection_thid := 0;
2599: l_exp_adj.selection_retid := 0;
2600: l_exp_adj.leveling_flag := TRUE;

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

2612:
2613: l_exp_adj.asset_id := l_src_asset_hdr_rec.asset_id;
2614: l_exp_adj.current_units := l_src_asset_desc_rec.current_units;
2615: l_exp_adj.code_combination_id := 0;
2616: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2617: l_exp_adj.debit_credit_flag := 'DR';
2618:
2619: -- set up the structs to be passed to faxinaj
2620: l_rsv_adj.transaction_header_id := l_dest_trans_rec.transaction_header_id;

Line 2656: if not fa_cache_pkg.fazccb

2652: (nvl(l_dest_asset_fin_rec_new.tracking_method,'NO TRACK')='CALCULATE' and
2653: nvl(l_dest_asset_fin_rec_new.member_rollup_flag,'N') = 'N') then
2654:
2655: -- call the category books cache for the accounts
2656: if not fa_cache_pkg.fazccb
2657: (X_book => l_mem_asset_hdr_rec.book_type_code,
2658: X_cat_id => l_mem_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2659: raise group_rec_err;
2660: end if;

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

2661:
2662: l_exp_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2663: l_exp_adj.current_units := l_mem_asset_desc_rec.current_units;
2664: l_exp_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2665: l_exp_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2666: l_exp_adj.track_member_flag := 'Y';
2667:
2668: if (p_log_level_rec.statement_level) then
2669: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for exp dest track', p_log_level_rec => p_log_level_rec);

Line 2708: if not fa_cache_pkg.fazccb

2704: (nvl(l_dest_asset_fin_rec_new.tracking_method,'NO TRACK')='CALCULATE' and
2705: nvl(l_dest_asset_fin_rec_new.member_rollup_flag,'N') = 'N') then
2706:
2707: -- call the category books cache for the accounts
2708: if not fa_cache_pkg.fazccb
2709: (X_book => l_mem_asset_hdr_rec.book_type_code,
2710: X_cat_id => l_mem_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2711: raise group_rec_err;
2712: end if;

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

2713:
2714: l_rsv_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2715: l_rsv_adj.current_units := l_mem_asset_desc_rec.current_units;
2716: l_rsv_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2717: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2718: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2719: l_rsv_adj.track_member_flag := 'Y';
2720:
2721: if (p_log_level_rec.statement_level) then

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

2714: l_rsv_adj.transaction_header_id := l_mem_trans_rec.transaction_header_id;
2715: l_rsv_adj.current_units := l_mem_asset_desc_rec.current_units;
2716: l_rsv_adj.asset_id := l_mem_asset_hdr_rec.asset_id;
2717: l_rsv_adj.code_combination_id := fa_cache_pkg.fazccb_record.reserve_account_ccid;
2718: l_rsv_adj.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
2719: l_rsv_adj.track_member_flag := 'Y';
2720:
2721: if (p_log_level_rec.statement_level) then
2722: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv dest track', p_log_level_rec => p_log_level_rec);