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.

[Home] [Help]

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_BOOKS

Line 56: (asset_id fa_books.asset_id%type,

52: g_tbl_adj_cost tbl_adj;
53: g_tbl_adj_rsv tbl_adj;
54:
55: type typ_adj_rec is RECORD
56: (asset_id fa_books.asset_id%type,
57: dist_id fa_adjustments.distribution_id%type,
58: ccid fa_adjustments.code_combination_id%type,
59: adj_type fa_adjustments.adjustment_type%type,
60: dr_cr fa_adjustments.debit_credit_flag%type,

Line 477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk

473: retire.transaction_header_id_in,
474: bk.group_asset_id,
475: bk.member_rollup_flag,
476: bk.tracking_method
477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk
478: WHERE
479: retire.retirement_id = RET.retirement_id
480: AND retire.units is not null
481: AND bc.distribution_source_book = retire.book_type_code

Line 1586: element => 'Updating FA_BOOKS',

1582:
1583: if (p_log_level_rec.statement_level) then
1584: fa_debug_pkg.add
1585: (fname => l_calling_fn,
1586: element => 'Updating FA_BOOKS',
1587: value => '', p_log_level_rec => p_log_level_rec);
1588: fa_debug_pkg.add(l_calling_fn, '++ h_ret_id in fagiat',h_ret_id, p_log_level_rec => p_log_level_rec);
1589: fa_debug_pkg.add(l_calling_fn, '++ h_rethdrout',h_rethdrout, p_log_level_rec => p_log_level_rec);
1590: ENd if;

Line 1594: UPDATE FA_BOOKS

1590: ENd if;
1591:
1592: /* Replaced this with the following
1593: if (h_mrc_primary_book_flag = 1) then
1594: UPDATE FA_BOOKS
1595: SET date_ineffective = h_today, -- to_date(h_today,'DD/MM/YYYY hh24:mi:ss'),
1596: transaction_header_id_out = h_rethdrout,
1597: last_updated_by = h_user_id,
1598: last_update_date = h_today -- to_date(h_today, 'DD/MM/YYYY hh24:mi:ss')

Line 1607: element => 'Deactivate fa_books row',

1603: */
1604: if (p_log_level_rec.statement_level) then
1605: fa_debug_pkg.add
1606: (fname => l_calling_fn,
1607: element => 'Deactivate fa_books row',
1608: value => '', p_log_level_rec => p_log_level_rec);
1609: end if;
1610:
1611: if (p_log_level_rec.statement_level) then

Line 1623: from fa_books

1619: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1620: if ret.mrc_sob_type_code <> 'R' then
1621: select nvl(rate_in_use,0)
1622: into l_rate_in_use
1623: from fa_books
1624: where asset_id = ret.asset_id
1625: and book_type_code = ret.book
1626: and transaction_header_id_out is null;
1627:

Line 1650: fa_books_pkg.deactivate_row

1646: end if;
1647: -- Bug:5930979:Japan Tax Reform Project (End)
1648:
1649: -- terminate the active row
1650: fa_books_pkg.deactivate_row
1651: (X_asset_id => h_asset_id,
1652: X_book_type_code => h_book,
1653: X_transaction_header_id_out => h_rethdrout,
1654: X_date_ineffective => h_today,

Line 1664: element => 'Create a new fa_books row',

1660:
1661: if (p_log_level_rec.statement_level) then
1662: fa_debug_pkg.add
1663: (fname => l_calling_fn,
1664: element => 'Create a new fa_books row',
1665: value => '', p_log_level_rec => p_log_level_rec);
1666: end if;
1667:
1668: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books

Line 1668: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books

1664: element => 'Create a new fa_books row',
1665: value => '', p_log_level_rec => p_log_level_rec);
1666: end if;
1667:
1668: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books
1669: * had null in period_counter_life_complete since this was missing in the following insert.
1670: */
1671:
1672: if ret.mrc_sob_type_code <> 'R' then

Line 1673: INSERT into fa_books

1669: * had null in period_counter_life_complete since this was missing in the following insert.
1670: */
1671:
1672: if ret.mrc_sob_type_code <> 'R' then
1673: INSERT into fa_books
1674: (book_type_Code, asset_id, date_placed_in_service,
1675: transaction_header_id_in, date_effective, transaction_header_id_out,
1676: date_ineffective, deprn_start_date, deprn_method_code,
1677: life_in_months, rate_adjustment_factor, adjusted_cost, cost,

Line 1815: FROM fa_books

1811: , prior_deprn_method
1812: , prior_life_in_months
1813: , prior_basic_rate
1814: , prior_adjusted_rate
1815: FROM fa_books
1816: WHERE asset_id = ret.asset_id
1817: AND book_type_code = ret.book
1818: AND transaction_header_id_out = h_rethdrout;
1819: else -- for reporting

Line 1960: update fa_books

1956:
1957: -- Bug:5930979:Japan Tax Reform Project (Start)
1958: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1959: if ret.mrc_sob_type_code <> 'R' then
1960: update fa_books
1961: set rate_in_use = l_rate_in_use
1962: where asset_id = ret.asset_id
1963: and book_type_code = ret.Book
1964: and transaction_header_id_out is null;

Line 5128: FROM fa_books

5124: BEGIN
5125: IF (ret.mrc_sob_type_code <> 'R') THEN
5126: SELECT group_asset_id
5127: INTO l_cur_grp_id
5128: FROM fa_books
5129: WHERE asset_id = ret.asset_id
5130: AND book_type_code = ret.book
5131: AND transaction_header_id_out IS NULL;
5132: ELSE

Line 5735: l_asset_id fa_books.asset_id%type;

5731: p_tbl_cost_ret IN OUT NOCOPY tbl_cost_ret,
5732: p_tbl_adj_final IN OUT NOCOPY tbl_final_adj, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
5733: l_final_ind number := p_tbl_adj_final.count;
5734: l_calling_fn varchar2(40) := 'FA_GAINLOSS_UND_PKG.pradjtbl';
5735: l_asset_id fa_books.asset_id%type;
5736:
5737: /* Cursor of all active distributions */
5738: cursor c_active_dist is
5739: select distribution_id,