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_RETIREMENT_PUB dependencies on FA_BOOKS

Line 414: -- get fa_books row where transaction_header_id_out is null

410: raise FND_API.G_EXC_UNEXPECTED_ERROR;
411: end if;
412:
413: -- pop asset_fin_rec
414: -- get fa_books row where transaction_header_id_out is null
415: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', g_log_level_rec); end if;
416: if not FA_UTIL_PVT.get_asset_fin_rec
417: (p_asset_hdr_rec => l_asset_hdr_rec
418: ,px_asset_fin_rec => l_asset_fin_rec

Line 1141: -- get fa_books row where transaction_header_id_out is null

1137: fnd_profile.put('GL_SET_OF_BKS_ID', l_asset_hdr_rec.set_of_books_id);
1138: fnd_client_info.set_currency_context(to_char(l_asset_hdr_rec.set_of_books_id));
1139:
1140: -- pop asset_fin_rec
1141: -- get fa_books row where transaction_header_id_out is null
1142: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec); end if;
1143: if not FA_UTIL_PVT.get_asset_fin_rec
1144: (p_asset_hdr_rec => l_asset_hdr_rec
1145: ,px_asset_fin_rec => l_asset_fin_rec

Line 1680: -- get fa_books row where transaction_header_id_out is null

1676: fnd_profile.put('GL_SET_OF_BKS_ID', l_asset_hdr_rec.set_of_books_id);
1677: fnd_client_info.set_currency_context(to_char(l_asset_hdr_rec.set_of_books_id));
1678:
1679: -- pop asset_fin_rec
1680: -- get fa_books row where transaction_header_id_out is null
1681: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec); end if;
1682: if not FA_UTIL_PVT.get_asset_fin_rec
1683: (p_asset_hdr_rec => l_asset_hdr_rec
1684: ,px_asset_fin_rec => l_asset_fin_mrc_rec

Line 2035: from fa_books bk

2031: ,bk.date_effective
2032: ,itc.basis_reduction_rate
2033: ,ce.limit
2034: ,lk.lookup_type
2035: from fa_books bk
2036: ,fa_itc_rates itc
2037: ,fa_ceilings ce
2038: ,fa_lookups_b lk
2039: where bk.asset_id = p_asset_id

Line 2116: from fa_books_summary -- ENERGY

2112: and date_ineffective is null;
2113:
2114: CURSOR c_get_reserve is -- ENERGY
2115: select deprn_reserve -- ENERGY
2116: from fa_books_summary -- ENERGY
2117: where asset_id = p_asset_id -- ENERGY
2118: and book_type_code = p_book_type_code -- ENERGY
2119: and period_counter = p_period_rec.period_counter -- ENERGY
2120: and transaction_header_id_out is null; -- ENERGY

Line 2126: , fa_books bk -- ENERGY

2122: CURSOR c_get_group_method_info is -- ENERGY
2123: select db.rule_name -- ENERGY
2124: from fa_deprn_basis_rules db -- ENERGY
2125: , fa_methods mt -- ENERGY
2126: , fa_books bk -- ENERGY
2127: where bk.asset_id = p_asset_fin_rec.group_asset_id -- ENERGY
2128: and bk.book_type_code = p_asset_hdr_rec.book_type_code -- ENERGY
2129: and bk.transaction_header_id_out is null -- ENERGY
2130: and bk.deprn_method_code = mt.method_code -- ENERGY

Line 2210: -- get fa_books row where transaction_header_id_out is null

2206:
2207: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'set_of_books_id: ', l_asset_hdr_rec.set_of_books_id, p_log_level_rec); end if;
2208:
2209: -- pop asset_fin_rec
2210: -- get fa_books row where transaction_header_id_out is null
2211: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec); end if;
2212: if not FA_UTIL_PVT.get_asset_fin_rec
2213: (p_asset_hdr_rec => l_asset_hdr_rec,
2214: px_asset_fin_rec => l_asset_fin_rec,

Line 2744: FROM fa_books

2740: if nvl(fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG,'NO') = 'YES' then
2741:
2742: SELECT nvl(rate_in_use,0)
2743: INTO l_rate_in_use
2744: FROM fa_books
2745: WHERE asset_id = l_asset_hdr_rec.asset_id
2746: AND book_type_code = l_asset_hdr_rec.Book_Type_Code
2747: AND transaction_header_id_out is null;
2748:

Line 2756: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec); end if;

2752:
2753: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'l_rate_in_use: ', l_rate_in_use, p_log_level_rec); end if;
2754: -- Bug 6665510: FP: Japan Tax Reform Project (End)
2755:
2756: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec); end if;
2757: -- terminate current fa_books row
2758: fa_books_pkg.update_row (
2759: X_Rowid => NULL,
2760: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,

Line 2757: -- terminate current fa_books row

2753: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'l_rate_in_use: ', l_rate_in_use, p_log_level_rec); end if;
2754: -- Bug 6665510: FP: Japan Tax Reform Project (End)
2755:
2756: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec); end if;
2757: -- terminate current fa_books row
2758: fa_books_pkg.update_row (
2759: X_Rowid => NULL,
2760: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
2761: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 2758: fa_books_pkg.update_row (

2754: -- Bug 6665510: FP: Japan Tax Reform Project (End)
2755:
2756: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec); end if;
2757: -- terminate current fa_books row
2758: fa_books_pkg.update_row (
2759: X_Rowid => NULL,
2760: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
2761: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
2762: X_Date_Placed_In_Service => l_asset_fin_rec.Date_Placed_In_Service,

Line 2837: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec); end if;

2833: X_mrc_sob_type_code => p_mrc_sob_type_code,
2834: X_Calling_Fn => l_calling_fn
2835: ,p_log_level_rec => p_log_level_rec);
2836:
2837: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec); end if;
2838: -- insert into fa books
2839: fa_books_pkg.insert_row
2840: (X_Rowid => l_bk_rowid,
2841: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,

Line 2838: -- insert into fa books

2834: X_Calling_Fn => l_calling_fn
2835: ,p_log_level_rec => p_log_level_rec);
2836:
2837: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec); end if;
2838: -- insert into fa books
2839: fa_books_pkg.insert_row
2840: (X_Rowid => l_bk_rowid,
2841: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
2842: X_Asset_Id => l_asset_hdr_rec.asset_id,

Line 2839: fa_books_pkg.insert_row

2835: ,p_log_level_rec => p_log_level_rec);
2836:
2837: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec); end if;
2838: -- insert into fa books
2839: fa_books_pkg.insert_row
2840: (X_Rowid => l_bk_rowid,
2841: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
2842: X_Asset_Id => l_asset_hdr_rec.asset_id,
2843: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

Line 2962: UPDATE fa_books

2958:
2959: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
2960: if nvl(fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG,'NO') = 'YES' then
2961:
2962: UPDATE fa_books
2963: SET rate_in_use = l_rate_in_use
2964: WHERE asset_id = l_asset_hdr_rec.asset_id
2965: AND book_type_code = l_asset_hdr_rec.Book_Type_Code
2966: AND transaction_header_id_out is null;

Line 3687: from fa_books

3683: where transaction_header_id = c_thid;
3684:
3685: cursor get_cost_before_ret(c_asset_id number, c_book varchar2, c_ret_id number, c_reporting_flag varchar2) is
3686: select cost
3687: from fa_books
3688: where asset_id = c_asset_id
3689: and book_type_code = c_book
3690: and retirement_id = c_ret_id
3691: and c_reporting_flag <> 'R'

Line 3742: -- get fa_books row where transaction_header_id_out is null

3738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3739: end if;
3740:
3741: -- pop asset_fin_rec
3742: -- get fa_books row where transaction_header_id_out is null
3743: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec); end if;
3744: if not FA_UTIL_PVT.get_asset_fin_rec
3745: (p_asset_hdr_rec => l_asset_hdr_rec
3746: ,px_asset_fin_rec => l_asset_fin_rec

Line 3880: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);

3876:
3877: if g_log_level_rec.statement_level then
3878: fa_debug_pkg.add(l_calling_fn, 'deleting a partial unit retirement', '', p_log_level_rec);
3879:
3880: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
3881: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec);
3882: end if;
3883:
3884: FA_BOOKS_PKG.DELETE_ROW

Line 3884: FA_BOOKS_PKG.DELETE_ROW

3880: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
3881: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec);
3882: end if;
3883:
3884: FA_BOOKS_PKG.DELETE_ROW
3885: (X_Transaction_Header_Id_In =>
3886: l_asset_retire_rec.detail_info.transaction_header_id_in,
3887: X_mrc_sob_type_code => p_mrc_sob_type_code,
3888: X_Calling_Fn => l_calling_fn

Line 3892: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec);

3888: X_Calling_Fn => l_calling_fn
3889: ,p_log_level_rec => p_log_level_rec);
3890:
3891: if g_log_level_rec.statement_level then
3892: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec);
3893: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec);
3894: end if;
3895:
3896: FA_BOOKS_PKG.REACTIVATE_ROW

Line 3896: FA_BOOKS_PKG.REACTIVATE_ROW

3892: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec);
3893: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec);
3894: end if;
3895:
3896: FA_BOOKS_PKG.REACTIVATE_ROW
3897: (X_Transaction_Header_Id_Out =>
3898: l_asset_retire_rec.detail_info.transaction_header_id_in,
3899: X_mrc_sob_type_code => p_mrc_sob_type_code,
3900: X_Calling_Fn => l_calling_fn

Line 3904: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);

3900: X_Calling_Fn => l_calling_fn
3901: ,p_log_level_rec => p_log_level_rec);
3902:
3903: if g_log_level_rec.statement_level then
3904: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
3905: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec);
3906: end if;
3907:
3908: FA_RETIREMENTS_PKG.DELETE_ROW

Line 4055: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);

4051: else -- if not partial unit retirement
4052:
4053: if g_log_level_rec.statement_level then
4054: fa_debug_pkg.add(l_calling_fn, 'not a partial unit retirement', '', p_log_level_rec);
4055: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
4056: end if;
4057: FA_BOOKS_PKG.DELETE_ROW
4058: (X_Transaction_Header_Id_In =>
4059: l_asset_retire_rec.detail_info.transaction_header_id_in,

Line 4057: FA_BOOKS_PKG.DELETE_ROW

4053: if g_log_level_rec.statement_level then
4054: fa_debug_pkg.add(l_calling_fn, 'not a partial unit retirement', '', p_log_level_rec);
4055: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
4056: end if;
4057: FA_BOOKS_PKG.DELETE_ROW
4058: (X_Transaction_Header_Id_In =>
4059: l_asset_retire_rec.detail_info.transaction_header_id_in,
4060: X_mrc_sob_type_code => p_mrc_sob_type_code,
4061: X_Calling_Fn => l_calling_fn

Line 4063: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;

4059: l_asset_retire_rec.detail_info.transaction_header_id_in,
4060: X_mrc_sob_type_code => p_mrc_sob_type_code,
4061: X_Calling_Fn => l_calling_fn
4062: ,p_log_level_rec => p_log_level_rec);
4063: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
4064: FA_BOOKS_PKG.REACTIVATE_ROW
4065: (X_Transaction_Header_Id_Out =>
4066: l_asset_retire_rec.detail_info.transaction_header_id_in,
4067: X_mrc_sob_type_code => p_mrc_sob_type_code,

Line 4064: FA_BOOKS_PKG.REACTIVATE_ROW

4060: X_mrc_sob_type_code => p_mrc_sob_type_code,
4061: X_Calling_Fn => l_calling_fn
4062: ,p_log_level_rec => p_log_level_rec);
4063: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
4064: FA_BOOKS_PKG.REACTIVATE_ROW
4065: (X_Transaction_Header_Id_Out =>
4066: l_asset_retire_rec.detail_info.transaction_header_id_in,
4067: X_mrc_sob_type_code => p_mrc_sob_type_code,
4068: X_Calling_Fn => l_calling_fn

Line 4191: ,fa_books bk

4187: cursor tde_cursor is
4188: select max(th.transaction_date_entered)
4189: from fa_deprn_periods dp
4190: ,fa_transaction_headers th
4191: ,fa_books bk
4192: where dp.book_type_code = l_asset_hdr_rec.book_type_code
4193: and dp.period_close_date is null
4194: and bk.book_type_code = dp.book_type_code
4195: and bk.asset_id = l_asset_hdr_rec.asset_id

Line 5018: -- get fa_books row where transaction_header_id_out is null

5014: fnd_profile.put('GL_SET_OF_BKS_ID', l_asset_hdr_rec.set_of_books_id);
5015: fnd_client_info.set_currency_context(to_char(l_asset_hdr_rec.set_of_books_id));
5016:
5017: -- pop asset_fin_rec
5018: -- get fa_books row where transaction_header_id_out is null
5019: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec); end if;
5020: if not FA_UTIL_PVT.get_asset_fin_rec
5021: (p_asset_hdr_rec => l_asset_hdr_rec
5022: ,px_asset_fin_rec => l_asset_fin_rec