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

Line 101: from fa_books inbk

97:
98: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
99: CURSOR c_check_dpis_change is
100: select inbk.transaction_header_id_in
101: from fa_books inbk
102: , fa_books outbk
103: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
104: and outbk.asset_id = inbk.asset_id
105: and outbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 102: , fa_books outbk

98: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
99: CURSOR c_check_dpis_change is
100: select inbk.transaction_header_id_in
101: from fa_books inbk
102: , fa_books outbk
103: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
104: and outbk.asset_id = inbk.asset_id
105: and outbk.book_type_code = p_asset_hdr_rec.book_type_code
106: and outbk.transaction_header_id_out = px_trans_rec.member_transaction_header_id

Line 1402: FROM fa_books bk

1398: AND ov.status = 'SELECTED'
1399: AND ov.transaction_header_id is null
1400: AND ov.asset_id IN
1401: (SELECT bk.asset_id
1402: FROM fa_books bk
1403: WHERE bk.book_type_code = ov.book_type_code
1404: AND bk.group_asset_id = p_asset_hdr_rec.asset_id
1405: AND bk.date_ineffective IS NULL);
1406: else

Line 1597: -- This is the one will use FA_BOOKS_SUMMARY table to calculate

1593:
1594:
1595: --
1596: -- Following faxama will return catch-up for group.
1597: -- This is the one will use FA_BOOKS_SUMMARY table to calculate
1598: -- and maintain FA_BOOKS_SUMMARY.
1599: --
1600: if (p_asset_type_rec.asset_type = 'GROUP') and
1601: (l_call_bs) then

Line 1598: -- and maintain FA_BOOKS_SUMMARY.

1594:
1595: --
1596: -- Following faxama will return catch-up for group.
1597: -- This is the one will use FA_BOOKS_SUMMARY table to calculate
1598: -- and maintain FA_BOOKS_SUMMARY.
1599: --
1600: if (p_asset_type_rec.asset_type = 'GROUP') and
1601: (l_call_bs) then
1602:

Line 2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);

2344: end if;
2345: -- End Bug 7707540
2346:
2347: if (p_log_level_rec.statement_level) then
2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);
2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);

Line 2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);

2345: -- End Bug 7707540
2346:
2347: if (p_log_level_rec.statement_level) then
2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);
2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);

Line 2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);

2346:
2347: if (p_log_level_rec.statement_level) then
2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);
2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);

Line 2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);

2347: if (p_log_level_rec.statement_level) then
2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);
2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);

Line 2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);

2348: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_method_code', px_asset_fin_rec_new.deprn_method_code);
2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);

Line 2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);

2349: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books life_in_months', px_asset_fin_rec_new.life_in_months);
2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);
2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);

Line 2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);

2350: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books salvage_value', px_asset_fin_rec_new.salvage_value);
2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);
2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);
2358: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 px_asset_fin_rec_new.recoverable_cost', px_asset_fin_rec_new.recoverable_cost);

Line 2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);

2351: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_fully_reserved', px_asset_fin_rec_new.period_counter_fully_reserved);
2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);
2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);
2358: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 px_asset_fin_rec_new.recoverable_cost', px_asset_fin_rec_new.recoverable_cost);
2359: end if;

Line 2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);

2352: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books period_counter_life_complete', px_asset_fin_rec_new.period_counter_life_complete);
2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);
2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);
2358: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 px_asset_fin_rec_new.recoverable_cost', px_asset_fin_rec_new.recoverable_cost);
2359: end if;
2360:

Line 2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);

2353: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books basic_rate', px_asset_fin_rec_new.basic_rate);
2354: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books adjusted_rate', px_asset_fin_rec_new.adjusted_rate);
2355: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit', px_asset_fin_rec_new.allowed_deprn_limit);
2356: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books deprn_limit_type', px_asset_fin_rec_new.deprn_limit_type);
2357: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 fa_books allowed_deprn_limit_amount', px_asset_fin_rec_new.allowed_deprn_limit_amount);
2358: fa_debug_pkg.add(l_calling_fn, 'Japan Tax:1 px_asset_fin_rec_new.recoverable_cost', px_asset_fin_rec_new.recoverable_cost);
2359: end if;
2360:
2361: return true;

Line 2745: from fa_books bk,

2741: elsif (p_asset_fin_rec_old.deprn_limit_type <> 'SUM') then
2742: if (p_mrc_sob_type_code <> 'R') then
2743: select nvl(sum(allowed_deprn_limit_amount), 0)
2744: into px_asset_fin_rec_new.allowed_deprn_limit_amount
2745: from fa_books bk,
2746: fa_additions_b ad
2747: where bk.transaction_header_id_out is null
2748: and bk.group_asset_id = p_asset_hdr_rec.asset_id
2749: and bk.asset_id = ad.asset_id

Line 2755: from fa_books_mrc_v bk,

2751: and ad.asset_type = 'CAPITALIZED';
2752: else
2753: select nvl(sum(allowed_deprn_limit_amount), 0)
2754: into px_asset_fin_rec_new.allowed_deprn_limit_amount
2755: from fa_books_mrc_v bk,
2756: fa_additions_b ad
2757: where bk.transaction_header_id_out is null
2758: and bk.group_asset_id = p_asset_hdr_rec.asset_id
2759: and bk.asset_id = ad.asset_id

Line 3064: from fa_books bk,

3060: elsif (p_asset_fin_rec_old.salvage_type <> 'SUM') then
3061: if (p_mrc_sob_type_code <> 'R') then
3062: select nvl(sum(salvage_value), 0)
3063: into px_asset_fin_rec_new.salvage_value
3064: from fa_books bk,
3065: fa_additions_b ad
3066: where bk.transaction_header_id_out is null
3067: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3068: and bk.asset_id = ad.asset_id

Line 3074: from fa_books_mrc_v bk,

3070: and ad.asset_type = 'CAPITALIZED';
3071: else
3072: select nvl(sum(salvage_value), 0)
3073: into px_asset_fin_rec_new.salvage_value
3074: from fa_books_mrc_v bk,
3075: fa_additions_b ad
3076: where bk.transaction_header_id_out is null
3077: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3078: and bk.asset_id = ad.asset_id

Line 3179: from fa_books

3175: CURSOR LIFE1_DEF IS
3176: select nvl(life_in_months,0),
3177: nvl(life_in_months,0),
3178: prorate_date
3179: from fa_books
3180: where book_type_code = p_asset_hdr_rec.book_type_code
3181: and asset_id = p_asset_desc_rec.parent_asset_id
3182: and transaction_header_id_out is null;
3183:

Line 3604: from fa_books bk,

3600: select bk.depreciate_flag,
3601: bk.transaction_header_id_in
3602: into l_depreciate_flag,
3603: l_dep_flag_thid
3604: from fa_books bk,
3605: fa_transaction_headers th
3606: where th.asset_id = p_asset_hdr_rec.asset_id
3607: and th.book_type_code = p_asset_hdr_rec.book_type_code
3608: and th.transaction_type_code = 'ADDITION'

Line 3622: from fa_books

3618: begin
3619:
3620: select count(*)
3621: into l_count_dep_flag
3622: from fa_books
3623: where asset_id = p_asset_hdr_rec.asset_id
3624: and book_type_code = p_asset_hdr_rec.book_type_code
3625: and depreciate_flag = 'YES'
3626: and transaction_header_id_in >= l_dep_flag_thid;

Line 3749: l_unit_of_measure FA_BOOKS.UNIT_OF_MEASURE%TYPE;

3745: ) RETURN BOOLEAN IS
3746:
3747: l_count number;
3748: l_result boolean;
3749: l_unit_of_measure FA_BOOKS.UNIT_OF_MEASURE%TYPE;
3750:
3751: l_method_id number;
3752: l_rate_source_rule FA_METHODS.rate_source_rule%TYPE;
3753: l_deprn_basis_rule FA_METHODS.deprn_basis_rule%TYPE;

Line 3762: from fa_books

3758: h_prod_method number; -- added this for bug 3245984
3759:
3760: CURSOR unit_of_measure IS
3761: select unit_of_measure
3762: from fa_books
3763: where asset_id = p_asset_hdr_rec.asset_id
3764: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3765: and transaction_header_id_out is NULL
3766: and deprn_method_code = px_asset_fin_rec_new.deprn_method_code;

Line 3878: name => 'FA_BOOKS_NULL_PROD');

3874:
3875: if (px_asset_fin_rec_new.production_capacity is null) then
3876: fa_srvr_msg.add_message(
3877: calling_fn => l_calling_fn,
3878: name => 'FA_BOOKS_NULL_PROD');
3879: raise calc_err;
3880: else
3881: px_asset_fin_rec_new.life_in_months := NULL;
3882: px_asset_fin_rec_new.adjusted_rate := NULL;

Line 4059: FROM FA_BOOKS

4055: ) return boolean IS
4056:
4057: CURSOR c_find_member_asset IS
4058: SELECT 'Y'
4059: FROM FA_BOOKS
4060: WHERE GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4061: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4062: AND TRANSACTION_HEADER_ID_OUT is NULL;
4063:

Line 4481: FROM FA_BOOKS

4477: reduce_adjustment_flag,
4478: reduce_retirement_flag,
4479: disabled_flag, --HH
4480: over_depreciate_option -- hh
4481: FROM FA_BOOKS
4482: WHERE ASSET_ID = px_asset_fin_rec_new.group_asset_id
4483: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4484: AND transaction_header_id_out is null;
4485:

Line 4513: -- get new tracking related columns from FA_BOOKS instead of copying

4509: BEGIN
4510:
4511: -- This function will copy the tracking related columns from old structure
4512: -- to new structure. And if the group assignment is changed,
4513: -- get new tracking related columns from FA_BOOKS instead of copying
4514: -- old to new.
4515:
4516: -- Only when this asset is assigned to group, this module will be available.
4517:

Line 4523: -- User cursor for now since we only need part of fa_books.

4519:
4520: --
4521: -- Get group information for reduction rate and tracking related values.
4522: -- If there will be more, this can be replaced with get_asset_fin_rec.
4523: -- User cursor for now since we only need part of fa_books.
4524: --
4525: open c_get_group_values;
4526: fetch c_get_group_values into l_recognize_gain_loss,
4527: l_recapture_reserve_flag,

Line 4572: -- tracking related columns from FA_BOOKS.

4568: if px_asset_fin_rec_new.group_asset_id <>
4569: nvl(p_asset_fin_rec_old.group_asset_id,-99) then
4570:
4571: -- In case the group asset is changed, need to replace with new
4572: -- tracking related columns from FA_BOOKS.
4573:
4574: if c_get_group_values%NOTFOUND then
4575:
4576: -- This is a case in which tracking method is not assigned to the group