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_TRACK_MEMBER_PVT dependencies on FA_TRACK_MEMBERS

Line 75: from FA_TRACK_MEMBERS

71:
72: -- cursor to check data existing
73: cursor CHECK_TEMP_TABLE is
74: select 1
75: from FA_TRACK_MEMBERS
76: where group_asset_id = P_group_asset_id
77: and period_counter = h_period_counter - 1
78: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);
79:

Line 214: delete fa_track_members;

210: return 0;
211:
212: exception
213: when main_err then
214: delete fa_track_members;
215: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
216: p_log_level_rec => p_log_level_rec);
217: return 1;
218:

Line 581: from fa_track_members

577:
578: --* Cursor to check if the member becomes fully reserved
579: cursor FULLY_RSV_MEMBER is
580: select 'Y'
581: from fa_track_members
582: where group_asset_id=h_group_asset_id
583: and member_asset_id=h_member_asset_id
584: and period_counter=h_period_counter
585: and (fully_reserved_flag is not null

Line 603: from fa_track_members tr,

599: ds.deprn_reserve,
600: ds.ytd_deprn,
601: ds.bonus_deprn_reserve,
602: ds.bonus_ytd_deprn
603: from fa_track_members tr,
604: fa_books bk,
605: fa_deprn_summary ds,
606: fa_deprn_periods dp,
607: fa_additions_b ad

Line 638: from fa_track_members tr,

634: ds.deprn_reserve,
635: ds.ytd_deprn,
636: ds.bonus_deprn_reserve,
637: ds.bonus_ytd_deprn
638: from fa_track_members tr,
639: fa_mc_books bk,
640: fa_mc_deprn_summary ds,
641: fa_mc_deprn_periods dp,
642: fa_additions_b ad

Line 741: from fa_track_members

737:
738: --* Cursor for member assets not to reallocate
739: cursor FIX_AMOUNT_MEMBER is
740: select member_asset_id
741: from fa_track_members
742: where group_asset_id = P_group_asset_id
743: and period_counter = P_period_counter
744: and fiscal_year = P_fiscal_year
745: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');

Line 817: from fa_track_members

813:
814: --* cursor for FA_
815: cursor ALLOCATED_MEMBERS is
816: select member_asset_id
817: from fa_track_members
818: where group_asset_id = P_group_asset_id
819: and period_counter = P_period_counter
820: and fiscal_year = P_fiscal_year
821: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 1173: -- member asset retired in this period will be picked up and gets row in FA_TRACK_MEMBERS and

1169: end if;
1170:
1171: --bug6923135
1172: -- bypassing following check if the mode is DEPRECIATION so that even allocation basis is zero,
1173: -- member asset retired in this period will be picked up and gets row in FA_TRACK_MEMBERS and
1174: -- eventually gets rows in DD and DS. Since I do not know the impact for ADJUSTMENT case, lifting this
1175: -- for DEPRECIATION only
1176: if nvl(h_total_allocation_basis,0) = 0
1177: and nvl(P_mode,'DEPRECIATION') <> 'DEPRECIATION' --bug6923135

Line 1747: from fa_track_members

1743:
1744: select nvl(sum(system_deprn_amount),0),
1745: nvl(sum(system_bonus_amount),0)
1746: into x_sum_of_deprn_amount,x_sum_of_bonus_amount
1747: from fa_track_members
1748: where group_asset_id = P_group_asset_id
1749: and member_asset_id <> l_track_member_in.member_asset_id
1750: and period_counter = P_period_counter
1751: and fiscal_year = P_fiscal_year

Line 1759: from fa_track_members

1755: --to check if the last member is already fully reserved
1756: begin
1757: select fully_reserved_flag
1758: into x_fully_reserved_flag
1759: from fa_track_members
1760: where group_asset_id = P_group_asset_id
1761: and member_asset_id = l_track_member_in.member_asset_id
1762: and period_counter = P_period_counter
1763: and fiscal_year = P_fiscal_year

Line 1969: -- Update FA_TRACK_MEMBERS table

1965: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec);
1966: end if;
1967: -- ENERGY
1968:
1969: -- Update FA_TRACK_MEMBERS table
1970: update FA_TRACK_MEMBERS
1971: set allocated_deprn_amount = x_allocated_deprn_amount,
1972: allocated_bonus_amount = x_allocated_bonus_amount,
1973: fully_reserved_flag = x_fully_reserved_flag,

Line 1970: update FA_TRACK_MEMBERS

1966: end if;
1967: -- ENERGY
1968:
1969: -- Update FA_TRACK_MEMBERS table
1970: update FA_TRACK_MEMBERS
1971: set allocated_deprn_amount = x_allocated_deprn_amount,
1972: allocated_bonus_amount = x_allocated_bonus_amount,
1973: fully_reserved_flag = x_fully_reserved_flag,
1974: system_deprn_amount = h_system_deprn_amount,

Line 2021: from fa_track_members

2017: sum(decode(nvl(P_subtraction_flag,'N'),'N',
2018: decode(nvl(override_flag,'N'),'Y',system_bonus_amount,allocated_bonus_amount), -- Periodic Case
2019: system_bonus_amount)) -- Subtraction Case
2020: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2021: from fa_track_members
2022: where group_asset_id = P_group_asset_id
2023: and period_counter = P_period_counter
2024: and fiscal_year = P_fiscal_year
2025: and nvl(set_of_books_id,-99) = h_set_of_books_id;

Line 2096: from fa_track_members

2092: system_bonus_amount), -- Normal Case
2093: system_deprn_amount)), -- Subtraction Case
2094: 0)
2095: into h_fixed_deprn_amount,h_fixed_bonus_amount
2096: from fa_track_members
2097: where group_asset_id = P_group_asset_id
2098: and period_counter = P_period_counter
2099: and fiscal_year = P_fiscal_year
2100: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');

Line 2164: from fa_track_members

2160: end if;
2161: END LOOP;
2162: else
2163: Select nvl(sum(allocation_basis),0) into h_total_allocation_basis
2164: from fa_track_members
2165: where group_asset_id = P_group_asset_id
2166: and period_counter = P_period_counter
2167: and fiscal_year = P_fiscal_year
2168: and nvl(fully_reserved_flag,'N') <> 'Y'

Line 2488: from fa_track_members

2484: END LOOP;
2485: else
2486: select nvl(sum(system_deprn_amount),0),nvl(sum(system_bonus_amount),0)
2487: into x_sum_of_deprn_amount,x_sum_of_bonus_amount
2488: from fa_track_members
2489: where group_asset_id = P_group_asset_id
2490: and member_asset_id <> l_track_member_in.member_asset_id
2491: and period_counter = P_period_counter
2492: and fiscal_year = P_fiscal_year

Line 2632: -- Update FA_TRACK_MEMBERS table

2628: fa_debug_pkg.add(l_calling_fn, 'h_ytd_deprn', h_ytd_deprn, p_log_level_rec);
2629: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec);
2630: end if;
2631: -- ENERGY
2632: -- Update FA_TRACK_MEMBERS table
2633: update FA_TRACK_MEMBERS
2634: set allocated_deprn_amount = x_allocated_deprn_amount,
2635: allocated_bonus_amount = x_allocated_bonus_amount,
2636: fully_reserved_flag = x_fully_reserved_flag,

Line 2633: update FA_TRACK_MEMBERS

2629: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec);
2630: end if;
2631: -- ENERGY
2632: -- Update FA_TRACK_MEMBERS table
2633: update FA_TRACK_MEMBERS
2634: set allocated_deprn_amount = x_allocated_deprn_amount,
2635: allocated_bonus_amount = x_allocated_bonus_amount,
2636: fully_reserved_flag = x_fully_reserved_flag,
2637: system_deprn_amount = h_system_deprn_amount,

Line 2672: from fa_track_members

2668: else
2669: -- Query total of allocated amounts
2670: select sum(allocated_deprn_amount),sum(allocated_bonus_amount)
2671: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2672: from fa_track_members
2673: where group_asset_id = P_group_asset_id
2674: and period_counter = P_period_counter
2675: and fiscal_year = P_fiscal_year
2676: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 2716: from fa_track_members

2712: else
2713: -- Query total of allocated amounts using really applocated amounts
2714: select sum(allocated_deprn_amount),sum(allocated_bonus_amount)
2715: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2716: from fa_track_members
2717: where group_asset_id = P_group_asset_id
2718: and period_counter = P_period_counter
2719: and fiscal_year = P_fiscal_year
2720: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 3091: from fa_track_members

3087:
3088: -- Check cursor
3089: cursor CHECK_EXISTS is
3090: select 1
3091: from fa_track_members
3092: where group_asset_id = h_group_asset_id
3093: and member_asset_id = h_member_asset_id
3094: and period_counter = h_period_counter
3095: and fiscal_year = h_fiscal_year

Line 3509: -- Insert into FA_TRACK_MEMBERS table

3505:
3506: --bug6923135
3507: --Placing nvl around variables so that pro*c code can handle the fetched value.
3508: if x_dummy is NULL then
3509: -- Insert into FA_TRACK_MEMBERS table
3510: Insert into FA_TRACK_MEMBERS(group_asset_id,
3511: member_asset_id,
3512: period_counter,
3513: fiscal_year,

Line 3510: Insert into FA_TRACK_MEMBERS(group_asset_id,

3506: --bug6923135
3507: --Placing nvl around variables so that pro*c code can handle the fetched value.
3508: if x_dummy is NULL then
3509: -- Insert into FA_TRACK_MEMBERS table
3510: Insert into FA_TRACK_MEMBERS(group_asset_id,
3511: member_asset_id,
3512: period_counter,
3513: fiscal_year,
3514: set_of_books_id,

Line 3559: Update FA_TRACK_MEMBERS

3555: x_bonus_ytd_deprn,
3556: h_deprn_override);
3557: else -- Need to update
3558: if nvl(P_member_override_flag,'N') <> 'Y' then
3559: Update FA_TRACK_MEMBERS
3560: set allocation_basis = h_allocation_basis,
3561: total_allocation_basis = h_total_allocation_basis,
3562: allocated_deprn_amount = x_allocated_deprn_amount,
3563: allocated_bonus_amount = x_allocated_bonus_amount,

Line 3577: Update FA_TRACK_MEMBERS

3573: and period_counter = h_period_counter
3574: and fiscal_year = h_fiscal_year
3575: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);
3576: else -- In case this member has been overridden...
3577: Update FA_TRACK_MEMBERS
3578: set system_deprn_amount = x_system_deprn_amount,
3579: system_bonus_amount = x_system_bonus_amount
3580: where group_asset_id = h_group_asset_id
3581: and member_asset_id = h_member_asset_id

Line 3801: fa_track_members temp

3797: temp.eofy_salvage_value temp_eofy_salvage_value,
3798: temp.eop_salvage_value temp_eop_salvage_value
3799: from fa_books bk,
3800: fa_deprn_summary ds,
3801: fa_track_members temp
3802: where bk.book_type_code = h_book_type_code
3803: and bk.group_asset_id = h_group_asset_id
3804: and bk.date_ineffective is null
3805: and ds.book_type_code = bk.book_type_code

Line 3848: fa_track_members temp

3844: temp.eofy_salvage_value temp_eofy_salvage_value,
3845: temp.eop_salvage_value temp_eop_salvage_value
3846: from fa_mc_books bk,
3847: fa_mc_deprn_summary ds,
3848: fa_track_members temp
3849: where bk.book_type_code = h_book_type_code
3850: and bk.group_asset_id = h_group_asset_id
3851: and bk.date_ineffective is null
3852: and bk.set_of_books_id = h_set_of_books_id

Line 3878: from fa_track_members temp

3874: temp.salvage_value,
3875: temp.recoverable_cost,
3876: temp.adjusted_cost,
3877: temp.adjusted_recoverable_cost
3878: from fa_track_members temp
3879: where temp.group_asset_id = h_group_asset_id
3880: and temp.member_asset_id = h_member_asset_id
3881: and temp.period_counter = h_period_counter
3882: and nvl(temp.set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 3887: from fa_track_members

3883:
3884: --* Check if current period table exists or not
3885: cursor CHECK_CURRENT_TABLE is
3886: select 1
3887: from fa_track_members
3888: where group_asset_id = h_group_asset_id
3889: and member_asset_id = h_member_asset_id
3890: and period_counter = h_period_counter
3891: and fiscal_year = h_fiscal_year

Line 5397: --* cursor to query the member inserted into FA_TRACK_MEMBERS

5393: l_allocated_deprn_amount number;
5394: l_deprn_adjustment_amount number;
5395:
5396:
5397: --* cursor to query the member inserted into FA_TRACK_MEMBERS
5398: -- after allocation
5399: cursor MEMBERS is
5400: select member_asset_id,
5401: allocated_deprn_amount,

Line 5403: from fa_track_members

5399: cursor MEMBERS is
5400: select member_asset_id,
5401: allocated_deprn_amount,
5402: fully_reserved_flag
5403: from fa_track_members
5404: where group_asset_id = p_group_asset_id
5405: and period_counter = p_period_counter
5406: and fiscal_year = p_fiscal_year
5407: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 7727: -- Using stored adjusted_cost in FA_TRACK_MEMBERS,

7723: -- Function: update_member_books
7724: --
7725: -- This function will be called from adjustment engine
7726: -- to update FA_BOOKS for each member assets
7727: -- Using stored adjusted_cost in FA_TRACK_MEMBERS,
7728: -- FA_BOOKS will be updated.
7729: --
7730: --+=====================================================================
7731: