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 273: FROM FA_BOOKS

269: /*bug#15897249 starts */
270: CURSOR c_get_group_reduction_val IS
271: SELECT reduction_rate,
272: reduce_retirement_flag
273: FROM FA_BOOKS
274: WHERE ASSET_ID = l_asset_fin_rec.group_asset_id
275: AND BOOK_TYPE_CODE = px_asset_hdr_rec.book_type_code
276: AND transaction_header_id_out is null;
277:

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

444: end if;
445:
446: /* Bug# 4663092: fyi: May not needed at this level */
447: -- pop asset_fin_rec
448: -- get fa_books row where transaction_header_id_out is null
449: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => g_log_level_rec); end if;
450: if not FA_UTIL_PVT.get_asset_fin_rec
451: (p_asset_hdr_rec => l_asset_hdr_rec
452: ,px_asset_fin_rec => l_asset_fin_rec

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

1295:
1296: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1297:
1298: -- pop asset_fin_rec
1299: -- get fa_books row where transaction_header_id_out is null
1300: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => p_log_level_rec); end if;
1301: if not FA_UTIL_PVT.get_asset_fin_rec
1302: (p_asset_hdr_rec => l_asset_hdr_rec
1303: ,px_asset_fin_rec => l_asset_fin_rec

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

1857: -- ** Pop local rec types
1858: -- ***************************
1859:
1860: -- pop asset_fin_rec
1861: -- get fa_books row where transaction_header_id_out is null
1862: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => p_log_level_rec); end if;
1863: if not FA_UTIL_PVT.get_asset_fin_rec
1864: (p_asset_hdr_rec => l_asset_hdr_rec
1865: ,px_asset_fin_rec => l_asset_fin_mrc_rec

Line 2254: from fa_books bk

2250: ,bk.date_effective
2251: ,itc.basis_reduction_rate
2252: ,ce.limit
2253: ,lk.lookup_type
2254: from fa_books bk
2255: ,fa_itc_rates itc
2256: ,fa_ceilings ce
2257: ,fa_lookups_b lk
2258: where bk.asset_id = p_asset_id

Line 2336: from fa_books_summary -- ENERGY

2332: and date_ineffective is null;
2333:
2334: CURSOR c_get_reserve is -- ENERGY
2335: select deprn_reserve -- ENERGY
2336: from fa_books_summary -- ENERGY
2337: where asset_id = p_asset_id -- ENERGY
2338: and book_type_code = p_book_type_code -- ENERGY
2339: and period_counter = p_period_rec.period_counter -- ENERGY
2340: and transaction_header_id_out is null; -- ENERGY

Line 2346: , fa_books bk -- ENERGY

2342: CURSOR c_get_group_method_info is -- ENERGY
2343: select db.rule_name -- ENERGY
2344: from fa_deprn_basis_rules db -- ENERGY
2345: , fa_methods mt -- ENERGY
2346: , fa_books bk -- ENERGY
2347: where bk.asset_id = p_asset_fin_rec.group_asset_id -- ENERGY
2348: and bk.book_type_code = p_asset_hdr_rec.book_type_code -- ENERGY
2349: and bk.transaction_header_id_out is null -- ENERGY
2350: and bk.deprn_method_code = mt.method_code -- ENERGY

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

2430:
2431: if p_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 => p_log_level_rec); end if;
2432:
2433: -- pop asset_fin_rec
2434: -- get fa_books row where transaction_header_id_out is null
2435: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => p_log_level_rec); end if;
2436: if not FA_UTIL_PVT.get_asset_fin_rec
2437: (p_asset_hdr_rec => l_asset_hdr_rec,
2438: px_asset_fin_rec => l_asset_fin_rec,

Line 2971: FROM fa_books

2967: if nvl(fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG,'NO') = 'YES' then
2968:
2969: SELECT nvl(rate_in_use,0)
2970: INTO l_rate_in_use
2971: FROM fa_books
2972: WHERE asset_id = l_asset_hdr_rec.asset_id
2973: AND book_type_code = l_asset_hdr_rec.Book_Type_Code
2974: AND transaction_header_id_out is null;
2975:

Line 3005: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;

3001: DP1.CALENDAR_PERIOD_CLOSE_DATE > l_ret_prorate_date;
3002: end if;
3003: -- bug 14286465 end
3004:
3005: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;
3006: -- terminate current fa_books row
3007: fa_books_pkg.update_row (
3008: X_Rowid => NULL,
3009: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,

Line 3006: -- terminate current fa_books row

3002: end if;
3003: -- bug 14286465 end
3004:
3005: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;
3006: -- terminate current fa_books row
3007: fa_books_pkg.update_row (
3008: X_Rowid => NULL,
3009: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
3010: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 3007: fa_books_pkg.update_row (

3003: -- bug 14286465 end
3004:
3005: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;
3006: -- terminate current fa_books row
3007: fa_books_pkg.update_row (
3008: X_Rowid => NULL,
3009: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
3010: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3011: X_Date_Placed_In_Service => l_asset_fin_rec.Date_Placed_In_Service,

Line 3097: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;

3093: X_prior_basic_rate => l_asset_fin_rec.prior_basic_rate ,
3094: X_prior_adjusted_rate => l_asset_fin_rec.prior_adjusted_rate -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
3095: , p_log_level_rec => p_log_level_rec);
3096:
3097: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
3098: -- insert into fa books
3099: fa_books_pkg.insert_row
3100: (X_Rowid => l_bk_rowid,
3101: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,

Line 3098: -- insert into fa books

3094: X_prior_adjusted_rate => l_asset_fin_rec.prior_adjusted_rate -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
3095: , p_log_level_rec => p_log_level_rec);
3096:
3097: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
3098: -- insert into fa books
3099: fa_books_pkg.insert_row
3100: (X_Rowid => l_bk_rowid,
3101: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
3102: X_Asset_Id => l_asset_hdr_rec.asset_id,

Line 3099: fa_books_pkg.insert_row

3095: , p_log_level_rec => p_log_level_rec);
3096:
3097: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_books_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
3098: -- insert into fa books
3099: fa_books_pkg.insert_row
3100: (X_Rowid => l_bk_rowid,
3101: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
3102: X_Asset_Id => l_asset_hdr_rec.asset_id,
3103: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

Line 3237: UPDATE fa_books

3233:
3234: -- Bug:5930979:Japan Tax Reform Project (Start)
3235: if nvl(fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG,'NO') = 'YES' then
3236:
3237: UPDATE fa_books
3238: SET rate_in_use = l_rate_in_use
3239: WHERE asset_id = l_asset_hdr_rec.asset_id
3240: AND book_type_code = l_asset_hdr_rec.Book_Type_Code
3241: AND transaction_header_id_out is null;

Line 3972: from fa_books

3968: where transaction_header_id = c_thid;
3969:
3970: cursor get_cost_before_ret(c_asset_id number, c_book varchar2, c_ret_id number, c_reporting_flag varchar2) is
3971: select cost
3972: from fa_books
3973: where asset_id = c_asset_id
3974: and book_type_code = c_book
3975: and retirement_id = c_ret_id
3976: and c_reporting_flag <> 'R'

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

4017: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4018: end if;
4019:
4020: -- pop asset_fin_rec
4021: -- get fa_books row where transaction_header_id_out is null
4022: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => p_log_level_rec); end if;
4023: if not FA_UTIL_PVT.get_asset_fin_rec
4024: (p_asset_hdr_rec => l_asset_hdr_rec
4025: ,px_asset_fin_rec => l_asset_fin_rec

Line 4095: update fa_books

4091: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
4092: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4093: end if;
4094: elsif (p_mrc_sob_type_code <> 'R') then
4095: update fa_books
4096: set adjustment_required_status = 'NONE'
4097: where asset_id = l_asset_fin_rec.group_asset_id
4098: and book_type_code = l_asset_hdr_rec.book_type_code
4099: and transaction_header_id_out is null;

Line 4172: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);

4168: -- of PARTIAL RETIREMENT row in TH table
4169:
4170: if p_log_level_rec.statement_level then
4171: fa_debug_pkg.add(l_calling_fn, 'deleting a partial unit retirement', '', p_log_level_rec => p_log_level_rec);
4172: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);
4173: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec => p_log_level_rec);
4174: end if;
4175: FA_BOOKS_PKG.DELETE_ROW
4176: (X_Transaction_Header_Id_In =>

Line 4175: FA_BOOKS_PKG.DELETE_ROW

4171: fa_debug_pkg.add(l_calling_fn, 'deleting a partial unit retirement', '', p_log_level_rec => p_log_level_rec);
4172: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);
4173: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec => p_log_level_rec);
4174: end if;
4175: FA_BOOKS_PKG.DELETE_ROW
4176: (X_Transaction_Header_Id_In =>
4177: l_asset_retire_rec.detail_info.transaction_header_id_in,
4178: X_mrc_sob_type_code => p_mrc_sob_type_code,
4179: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,

Line 4183: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec);

4179: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4180: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4181:
4182: if p_log_level_rec.statement_level then
4183: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec);
4184: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec => p_log_level_rec);
4185: end if;
4186: FA_BOOKS_PKG.REACTIVATE_ROW
4187: (X_Transaction_Header_Id_Out =>

Line 4186: FA_BOOKS_PKG.REACTIVATE_ROW

4182: if p_log_level_rec.statement_level then
4183: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec);
4184: fa_debug_pkg.add(l_calling_fn, 'trx_id: ', l_asset_retire_rec.detail_info.transaction_header_id_in, p_log_level_rec => p_log_level_rec);
4185: end if;
4186: FA_BOOKS_PKG.REACTIVATE_ROW
4187: (X_Transaction_Header_Id_Out =>
4188: l_asset_retire_rec.detail_info.transaction_header_id_in,
4189: X_mrc_sob_type_code => p_mrc_sob_type_code,
4190: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,

Line 4193: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;

4189: X_mrc_sob_type_code => p_mrc_sob_type_code,
4190: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4191: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4192:
4193: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4194: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec => p_log_level_rec); end if;
4195: FA_RETIREMENTS_PKG.DELETE_ROW
4196: (X_Rowid => l_asset_retire_rec.detail_info.row_id,
4197: X_mrc_sob_type_code => p_mrc_sob_type_code,

Line 4337: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;

4333: else -- if not partial unit retirement
4334:
4335: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'not a partial unit retirement', '', p_log_level_rec => p_log_level_rec); end if;
4336:
4337: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4338: FA_BOOKS_PKG.DELETE_ROW
4339: (X_Transaction_Header_Id_In =>
4340: l_asset_retire_rec.detail_info.transaction_header_id_in,
4341: X_mrc_sob_type_code => p_mrc_sob_type_code,

Line 4338: FA_BOOKS_PKG.DELETE_ROW

4334:
4335: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'not a partial unit retirement', '', p_log_level_rec => p_log_level_rec); end if;
4336:
4337: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4338: FA_BOOKS_PKG.DELETE_ROW
4339: (X_Transaction_Header_Id_In =>
4340: l_asset_retire_rec.detail_info.transaction_header_id_in,
4341: X_mrc_sob_type_code => p_mrc_sob_type_code,
4342: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,

Line 4344: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;

4340: l_asset_retire_rec.detail_info.transaction_header_id_in,
4341: X_mrc_sob_type_code => p_mrc_sob_type_code,
4342: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4343: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4344: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4345: FA_BOOKS_PKG.REACTIVATE_ROW
4346: (X_Transaction_Header_Id_Out =>
4347: l_asset_retire_rec.detail_info.transaction_header_id_in,
4348: X_mrc_sob_type_code => p_mrc_sob_type_code,

Line 4345: FA_BOOKS_PKG.REACTIVATE_ROW

4341: X_mrc_sob_type_code => p_mrc_sob_type_code,
4342: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4343: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4344: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4345: FA_BOOKS_PKG.REACTIVATE_ROW
4346: (X_Transaction_Header_Id_Out =>
4347: l_asset_retire_rec.detail_info.transaction_header_id_in,
4348: X_mrc_sob_type_code => p_mrc_sob_type_code,
4349: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,

Line 4473: ,fa_books bk

4469: cursor tde_cursor is
4470: select max(th.transaction_date_entered)
4471: from fa_deprn_periods dp
4472: ,fa_transaction_headers th
4473: ,fa_books bk
4474: where dp.book_type_code = l_asset_hdr_rec.book_type_code
4475: and dp.period_close_date is null
4476: and bk.book_type_code = dp.book_type_code
4477: and bk.asset_id = l_asset_hdr_rec.asset_id

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

5332: -- ** Pop local rec types
5333: -- ***************************
5334:
5335: -- pop asset_fin_rec
5336: -- get fa_books row where transaction_header_id_out is null
5337: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'pop asset_fin_rec', '', p_log_level_rec => p_log_level_rec); end if;
5338: if not FA_UTIL_PVT.get_asset_fin_rec
5339: (p_asset_hdr_rec => l_asset_hdr_rec
5340: ,px_asset_fin_rec => l_asset_fin_rec