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 102: from FA_TRACK_MEMBERS

98:
99: -- cursor to check data existing
100: cursor CHECK_TEMP_TABLE is
101: select 1
102: from FA_TRACK_MEMBERS
103: where group_asset_id = P_group_asset_id
104: and period_counter = h_period_counter - 1
105: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
106:

Line 236: delete fa_track_members;

232: return 0;
233:
234: exception
235: when main_err then
236: delete fa_track_members;
237: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
238: return 1;
239:
240: when others then

Line 610: from fa_track_members

606:
607: --* Cursor to check if the member becomes fully reserved
608: cursor FULLY_RSV_MEMBER is
609: select 'Y'
610: from fa_track_members
611: where group_asset_id=h_group_asset_id
612: and member_asset_id=h_member_asset_id
613: and period_counter=h_period_counter
614: and (fully_reserved_flag is not null

Line 632: from fa_track_members tr,

628: ds.deprn_reserve,
629: ds.ytd_deprn,
630: ds.bonus_deprn_reserve,
631: ds.bonus_ytd_deprn
632: from fa_track_members tr,
633: fa_books bk,
634: fa_deprn_summary ds,
635: fa_deprn_periods dp,
636: fa_additions_b ad

Line 667: from fa_track_members tr,

663: ds.deprn_reserve,
664: ds.ytd_deprn,
665: ds.bonus_deprn_reserve,
666: ds.bonus_ytd_deprn
667: from fa_track_members tr,
668: fa_mc_books bk,
669: fa_mc_deprn_summary ds,
670: fa_mc_deprn_periods dp,
671: fa_additions_b ad

Line 770: from fa_track_members

766:
767: --* Cursor for member assets not to reallocate
768: cursor FIX_AMOUNT_MEMBER is
769: select member_asset_id
770: from fa_track_members
771: where group_asset_id = P_group_asset_id
772: and period_counter = P_period_counter
773: and fiscal_year = P_fiscal_year
774: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');

Line 849: select /+ Index (TM fa_track_members_N1) /

845: and th.transaction_key in ('UA','UE');
846:
847: -- Bug # 8394833 Added below index hint to improve the performance
848: cursor C_MEM_UNPLAN_ADJ is
849: select /*+ Index (TM fa_track_members_N1) */
850: member_asset_id
851: ,sum(decode(adj.adjustment_type,'EXPENSE'
852: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
853: , 'CR', -1 * adj.adjustment_amount))

Line 855: from fa_track_members tm

851: ,sum(decode(adj.adjustment_type,'EXPENSE'
852: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
853: , 'CR', -1 * adj.adjustment_amount))
854: )
855: from fa_track_members tm
856: , fa_adjustments adj
857: , fa_transaction_headers th1
858: , fa_transaction_headers th2
859: where tm.group_asset_id = P_group_asset_id

Line 875: select /+ Index (TM fa_track_members_N1) /

871: and th2.transaction_key in ('UA','UE')
872: Group by member_asset_id;
873:
874: cursor C_MEM_UNPLAN_ADJ_MRC is
875: select /*+ Index (TM fa_track_members_N1) */
876: member_asset_id
877: ,sum(decode(adj.adjustment_type,'EXPENSE'
878: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
879: , 'CR', -1 * adj.adjustment_amount))

Line 881: from fa_track_members tm

877: ,sum(decode(adj.adjustment_type,'EXPENSE'
878: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
879: , 'CR', -1 * adj.adjustment_amount))
880: )
881: from fa_track_members tm
882: , fa_mc_adjustments adj
883: , fa_transaction_headers th1
884: , fa_transaction_headers th2
885: where tm.group_asset_id = P_group_asset_id

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

1295: end if;
1296:
1297: --bug6923135
1298: -- bypassing following check if the mode is DEPRECIATION so that even allocation basis is zero,
1299: -- member asset retired in this period will be picked up and gets row in FA_TRACK_MEMBERS and
1300: -- eventually gets rows in DD and DS. Since I do not know the impact for ADJUSTMENT case, lifting this
1301: -- for DEPRECIATION only
1302: if nvl(h_total_allocation_basis,0) = 0
1303: and nvl(P_mode,'DEPRECIATION') <> 'DEPRECIATION' --bug6923135

Line 1888: from fa_track_members

1884:
1885: select nvl(sum(system_deprn_amount),0),
1886: nvl(sum(system_bonus_amount),0)
1887: into x_sum_of_deprn_amount,x_sum_of_bonus_amount
1888: from fa_track_members
1889: where group_asset_id = P_group_asset_id
1890: and member_asset_id <> l_track_member_in.member_asset_id
1891: and period_counter = P_period_counter
1892: and fiscal_year = P_fiscal_year

Line 1900: from fa_track_members

1896: --to check if the last member is already fully reserved
1897: begin
1898: select fully_reserved_flag
1899: into x_fully_reserved_flag
1900: from fa_track_members
1901: where group_asset_id = P_group_asset_id
1902: and member_asset_id = l_track_member_in.member_asset_id
1903: and period_counter = P_period_counter
1904: and fiscal_year = P_fiscal_year

Line 2114: -- Update FA_TRACK_MEMBERS table

2110: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec => p_log_level_rec);
2111: end if;
2112: -- ENERGY
2113:
2114: -- Update FA_TRACK_MEMBERS table
2115: update FA_TRACK_MEMBERS
2116: set allocated_deprn_amount = x_allocated_deprn_amount,
2117: allocated_bonus_amount = x_allocated_bonus_amount,
2118: fully_reserved_flag = x_fully_reserved_flag,

Line 2115: update FA_TRACK_MEMBERS

2111: end if;
2112: -- ENERGY
2113:
2114: -- Update FA_TRACK_MEMBERS table
2115: update FA_TRACK_MEMBERS
2116: set allocated_deprn_amount = x_allocated_deprn_amount,
2117: allocated_bonus_amount = x_allocated_bonus_amount,
2118: fully_reserved_flag = x_fully_reserved_flag,
2119: system_deprn_amount = h_system_deprn_amount,

Line 2166: from fa_track_members

2162: sum(decode(nvl(P_subtraction_flag,'N'),'N',
2163: decode(nvl(override_flag,'N'),'Y',system_bonus_amount,allocated_bonus_amount), -- Periodic Case
2164: system_bonus_amount)) -- Subtraction Case
2165: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2166: from fa_track_members
2167: where group_asset_id = P_group_asset_id
2168: and period_counter = P_period_counter
2169: and fiscal_year = P_fiscal_year
2170: and nvl(set_of_books_id,-99) = p_set_of_books_id;

Line 2241: from fa_track_members

2237: system_bonus_amount), -- Normal Case
2238: system_deprn_amount)), -- Subtraction Case
2239: 0)
2240: into h_fixed_deprn_amount,h_fixed_bonus_amount
2241: from fa_track_members
2242: where group_asset_id = P_group_asset_id
2243: and period_counter = P_period_counter
2244: and fiscal_year = P_fiscal_year
2245: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');

Line 2309: from fa_track_members

2305: end if;
2306: END LOOP;
2307: else
2308: Select nvl(sum(allocation_basis),0) into h_total_allocation_basis
2309: from fa_track_members
2310: where group_asset_id = P_group_asset_id
2311: and period_counter = P_period_counter
2312: and fiscal_year = P_fiscal_year
2313: and nvl(fully_reserved_flag,'N') <> 'Y'

Line 2636: from fa_track_members

2632: END LOOP;
2633: else
2634: select nvl(sum(system_deprn_amount),0),nvl(sum(system_bonus_amount),0)
2635: into x_sum_of_deprn_amount,x_sum_of_bonus_amount
2636: from fa_track_members
2637: where group_asset_id = P_group_asset_id
2638: and member_asset_id <> l_track_member_in.member_asset_id
2639: and period_counter = P_period_counter
2640: and fiscal_year = P_fiscal_year

Line 2779: -- Update FA_TRACK_MEMBERS table

2775: fa_debug_pkg.add(l_calling_fn, 'h_ytd_deprn', h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2776: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec => p_log_level_rec);
2777: end if;
2778: -- ENERGY
2779: -- Update FA_TRACK_MEMBERS table
2780: update FA_TRACK_MEMBERS
2781: set allocated_deprn_amount = x_allocated_deprn_amount,
2782: allocated_bonus_amount = x_allocated_bonus_amount,
2783: fully_reserved_flag = x_fully_reserved_flag,

Line 2780: update FA_TRACK_MEMBERS

2776: fa_debug_pkg.add(l_calling_fn, 'h_deprn_reserve', h_deprn_reserve, p_log_level_rec => p_log_level_rec);
2777: end if;
2778: -- ENERGY
2779: -- Update FA_TRACK_MEMBERS table
2780: update FA_TRACK_MEMBERS
2781: set allocated_deprn_amount = x_allocated_deprn_amount,
2782: allocated_bonus_amount = x_allocated_bonus_amount,
2783: fully_reserved_flag = x_fully_reserved_flag,
2784: system_deprn_amount = h_system_deprn_amount,

Line 2819: from fa_track_members

2815: else
2816: -- Query total of allocated amounts
2817: select sum(allocated_deprn_amount),sum(allocated_bonus_amount)
2818: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2819: from fa_track_members
2820: where group_asset_id = P_group_asset_id
2821: and period_counter = P_period_counter
2822: and fiscal_year = P_fiscal_year
2823: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);

Line 2863: from fa_track_members

2859: else
2860: -- Query total of allocated amounts using really applocated amounts
2861: select sum(allocated_deprn_amount),sum(allocated_bonus_amount)
2862: into x_total_allocated_deprn_amount,x_total_allocated_bonus_amount
2863: from fa_track_members
2864: where group_asset_id = P_group_asset_id
2865: and period_counter = P_period_counter
2866: and fiscal_year = P_fiscal_year
2867: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);

Line 3244: from fa_track_members

3240:
3241: -- Check cursor
3242: cursor CHECK_EXISTS is
3243: select 1
3244: from fa_track_members
3245: where group_asset_id = h_group_asset_id
3246: and member_asset_id = h_member_asset_id
3247: and period_counter = h_period_counter
3248: and fiscal_year = h_fiscal_year

Line 3662: -- Insert into FA_TRACK_MEMBERS table

3658:
3659: --bug6923135
3660: --Placing nvl around variables so that pro*c code can handle the fetched value.
3661: if x_dummy is NULL then
3662: -- Insert into FA_TRACK_MEMBERS table
3663: Insert into FA_TRACK_MEMBERS(group_asset_id,
3664: member_asset_id,
3665: period_counter,
3666: fiscal_year,

Line 3663: Insert into FA_TRACK_MEMBERS(group_asset_id,

3659: --bug6923135
3660: --Placing nvl around variables so that pro*c code can handle the fetched value.
3661: if x_dummy is NULL then
3662: -- Insert into FA_TRACK_MEMBERS table
3663: Insert into FA_TRACK_MEMBERS(group_asset_id,
3664: member_asset_id,
3665: period_counter,
3666: fiscal_year,
3667: set_of_books_id,

Line 3712: Update FA_TRACK_MEMBERS

3708: x_bonus_ytd_deprn,
3709: h_deprn_override);
3710: else -- Need to update
3711: if nvl(P_member_override_flag,'N') <> 'Y' then
3712: Update FA_TRACK_MEMBERS
3713: set allocation_basis = h_allocation_basis,
3714: total_allocation_basis = h_total_allocation_basis,
3715: allocated_deprn_amount = x_allocated_deprn_amount,
3716: allocated_bonus_amount = x_allocated_bonus_amount,

Line 3730: Update FA_TRACK_MEMBERS

3726: and period_counter = h_period_counter
3727: and fiscal_year = h_fiscal_year
3728: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
3729: else -- In case this member has been overridden...
3730: Update FA_TRACK_MEMBERS
3731: set system_deprn_amount = x_system_deprn_amount,
3732: system_bonus_amount = x_system_bonus_amount
3733: where group_asset_id = h_group_asset_id
3734: and member_asset_id = h_member_asset_id

Line 3951: fa_track_members temp

3947: temp.eofy_salvage_value temp_eofy_salvage_value,
3948: temp.eop_salvage_value temp_eop_salvage_value
3949: from fa_books bk,
3950: fa_deprn_summary ds,
3951: fa_track_members temp
3952: where bk.book_type_code = h_book_type_code
3953: and bk.group_asset_id = h_group_asset_id
3954: and bk.date_ineffective is null
3955: and ds.book_type_code = bk.book_type_code

Line 3998: fa_track_members temp

3994: temp.eofy_salvage_value temp_eofy_salvage_value,
3995: temp.eop_salvage_value temp_eop_salvage_value
3996: from fa_mc_books bk,
3997: fa_mc_deprn_summary ds,
3998: fa_track_members temp
3999: where bk.book_type_code = h_book_type_code
4000: and bk.group_asset_id = h_group_asset_id
4001: and bk.date_ineffective is null
4002: and bk.set_of_books_id =h_set_of_books_id

Line 4028: from fa_track_members temp

4024: temp.salvage_value,
4025: temp.recoverable_cost,
4026: temp.adjusted_cost,
4027: temp.adjusted_recoverable_cost
4028: from fa_track_members temp
4029: where temp.group_asset_id = h_group_asset_id
4030: and temp.member_asset_id = h_member_asset_id
4031: and temp.period_counter = h_period_counter
4032: and nvl(temp.set_of_books_id,-99) = nvl(h_set_of_books_id,-99);

Line 4037: from fa_track_members

4033:
4034: --* Check if current period table exists or not
4035: cursor CHECK_CURRENT_TABLE is
4036: select 1
4037: from fa_track_members
4038: where group_asset_id = h_group_asset_id
4039: and member_asset_id = h_member_asset_id
4040: and period_counter = h_period_counter
4041: and fiscal_year = h_fiscal_year

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

5549: l_deprn_adjustment_amount number;
5550:
5551: l_index number := 1; -- Bug 8703676
5552:
5553: --* cursor to query the member inserted into FA_TRACK_MEMBERS
5554: -- after allocation
5555: cursor MEMBERS is
5556: select member_asset_id,
5557: allocated_deprn_amount,

Line 5559: from fa_track_members

5555: cursor MEMBERS is
5556: select member_asset_id,
5557: allocated_deprn_amount,
5558: fully_reserved_flag
5559: from fa_track_members
5560: where group_asset_id = p_group_asset_id
5561: and period_counter = p_period_counter
5562: and fiscal_year = p_fiscal_year
5563: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);

Line 7906: -- Using stored adjusted_cost in FA_TRACK_MEMBERS,

7902: -- Function: update_member_books
7903: --
7904: -- This function will be called from adjustment engine
7905: -- to update FA_BOOKS for each member assets
7906: -- Using stored adjusted_cost in FA_TRACK_MEMBERS,
7907: -- FA_BOOKS will be updated.
7908: --
7909: --+=====================================================================
7910: