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_BOOKS_SUMMARY

Line 983: -- issue query against fa_books_summary

979: h_total_cost := 0;
980: h_total_adjusted_cost := 0;
981: h_total_recoverable_cost := 0;
982:
983: -- issue query against fa_books_summary
984: For i IN 1 .. p_track_member_table.COUNT LOOP
985:
986: if p_track_member_table(i).group_asset_id = h_group_asset_id and
987: p_track_member_table(i).period_counter = h_period_counter and

Line 2846: UPDATE FA_BOOKS_SUMMARY

2842:
2843: if h_unplanned_expense <> 0 then
2844:
2845: if p_mrc_sob_type_code <> 'R' then
2846: UPDATE FA_BOOKS_SUMMARY
2847: SET DEPRN_AMOUNT = h_unplanned_expense + DEPRN_AMOUNT,
2848: YTD_DEPRN = h_unplanned_expense + YTD_DEPRN
2849: WHERE BOOK_TYPE_CODE = h_book_type_code
2850: AND PERIOD_COUNTER = h_period_counter

Line 2853: UPDATE FA_BOOKS_SUMMARY_MRC_V

2849: WHERE BOOK_TYPE_CODE = h_book_type_code
2850: AND PERIOD_COUNTER = h_period_counter
2851: AND ASSET_ID = h_unplanned_member_asset;
2852: else
2853: UPDATE FA_BOOKS_SUMMARY_MRC_V
2854: SET DEPRN_AMOUNT = h_unplanned_expense + DEPRN_AMOUNT,
2855: YTD_DEPRN = h_unplanned_expense + YTD_DEPRN
2856: WHERE BOOK_TYPE_CODE = h_book_type_code
2857: AND PERIOD_COUNTER = h_period_counter

Line 8638: --* cursor to populate Group Assets record from FA_BOOKS_SUMMARY

8634: where adj.asset_id = h_group_asset_id
8635: and adj.book_type_code = h_book_type_code
8636: and adj.period_counter_adjusted = p_period_counter;
8637:
8638: --* cursor to populate Group Assets record from FA_BOOKS_SUMMARY
8639: cursor GET_GROUP_INFO(p_period_counter number) is
8640: select FISCAL_YEAR,
8641: PERIOD_NUM,
8642: CALENDAR_PERIOD_OPEN_DATE,

Line 8664: from FA_BOOKS_SUMMARY

8660: -- EOFY_SALVAGE_VALULE,
8661: EOFY_RESERVE,
8662: SYSTEM_DEPRN_AMOUNT,
8663: SYSTEM_BONUS_DEPRN_AMOUNT
8664: from FA_BOOKS_SUMMARY
8665: where book_type_code = h_book_type_code
8666: and asset_id = h_group_asset_id
8667: and period_counter = p_period_counter;
8668:

Line 8694: from FA_BOOKS_SUMMARY_MRC_V

8690: -- EOFY_SALVAGE_VALULE,
8691: EOFY_RESERVE,
8692: SYSTEM_DEPRN_AMOUNT,
8693: SYSTEM_BONUS_DEPRN_AMOUNT
8694: from FA_BOOKS_SUMMARY_MRC_V
8695: where book_type_code = h_book_type_code
8696: and asset_id = h_group_asset_id
8697: and period_counter = p_period_counter;
8698:

Line 8702: from FA_BOOKS_SUMMARY

8698:
8699: cursor GET_GROUP_SYSTEM_INFO(p_fiscal_year number, p_period_counter_end number) is
8700: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8701: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8702: from FA_BOOKS_SUMMARY
8703: where book_type_code = h_book_type_code
8704: and asset_id = h_group_asset_id
8705: and fiscal_year = p_fiscal_year
8706: and period_counter <= p_period_counter_end;

Line 8711: from FA_BOOKS_SUMMARY_MRC_V

8707:
8708: cursor GET_GROUP_SYSTEM_INFO_MRC(p_fiscal_year number, p_period_counter_end number) is
8709: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8710: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8711: from FA_BOOKS_SUMMARY_MRC_V
8712: where book_type_code = h_book_type_code
8713: and asset_id = h_group_asset_id
8714: and fiscal_year = p_fiscal_year
8715: and period_counter <= p_period_counter_end;

Line 8721: from FA_BOOKS_SUMMARY

8717: --* cursor to populate Group Assets record (Temporary)
8718: cursor GET_GROUP_SALVAGE(p_fiscal_year number, p_period_num number) is
8719: select SALVAGE_VALUE,
8720: RECOVERABLE_COST
8721: from FA_BOOKS_SUMMARY
8722: where book_type_code = h_book_type_code
8723: and asset_id = h_group_asset_id
8724: and fiscal_year = p_fiscal_year
8725: and period_num = p_period_num;

Line 8730: from FA_BOOKS_SUMMARY_MRC_V

8726:
8727: cursor GET_GROUP_SALVAGE_MRC(p_fiscal_year number, p_period_num number) is
8728: select SALVAGE_VALUE,
8729: RECOVERABLE_COST
8730: from FA_BOOKS_SUMMARY_MRC_V
8731: where book_type_code = h_book_type_code
8732: and asset_id = h_group_asset_id
8733: and fiscal_year = p_fiscal_year
8734: and period_num = p_period_num;

Line 8736: -- cursor to query fa_books_summary for this member/period

8732: and asset_id = h_group_asset_id
8733: and fiscal_year = p_fiscal_year
8734: and period_num = p_period_num;
8735:
8736: -- cursor to query fa_books_summary for this member/period
8737: cursor GET_PRV_ROW_BS is
8738: select COST,
8739: SALVAGE_VALUE,
8740: RECOVERABLE_COST,

Line 8748: from FA_BOOKS_SUMMARY

8744: BONUS_DEPRN_RESERVE,
8745: YTD_DEPRN,
8746: BONUS_YTD_DEPRN,
8747: EOFY_RESERVE
8748: from FA_BOOKS_SUMMARY
8749: where book_type_code = h_book_type_code
8750: and group_asset_id = h_group_asset_id
8751: and period_counter = h_processing_period_counter -1
8752: and asset_id = h_member_asset_id;

Line 8765: from FA_BOOKS_SUMMARY_MRC_V

8761: BONUS_DEPRN_RESERVE,
8762: YTD_DEPRN,
8763: BONUS_YTD_DEPRN,
8764: EOFY_RESERVE
8765: from FA_BOOKS_SUMMARY_MRC_V
8766: where book_type_code = h_book_type_code
8767: and group_asset_id = h_group_asset_id
8768: and period_counter = h_processing_period_counter -1
8769: and asset_id = h_member_asset_id;

Line 9014: fa_debug_pkg.add(l_calling_fn, 'Need to query fa_books_summary table due to no data in'||

9010: if (p_log_level_rec.statement_level) then
9011: if (h_find_flag_1) then
9012: fa_debug_pkg.add(l_calling_fn, 'Memory Table has data for this asset', '+++', p_log_level_rec);
9013: else
9014: fa_debug_pkg.add(l_calling_fn, 'Need to query fa_books_summary table due to no data in'||
9015: ' memory table','+++', p_log_level_rec);
9016: end if;
9017: end if;
9018:

Line 9446: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);

9442: h_bonus_ytd_deprn,
9443: h_eofy_reserve;
9444: if GET_PRV_ROW_BS%NOTFOUND then
9445: if (p_log_level_rec.statement_level) then
9446: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);
9447: end if;
9448: else
9449: if (p_log_level_rec.statement_level) then
9450: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);

Line 9450: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);

9446: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);
9447: end if;
9448: else
9449: if (p_log_level_rec.statement_level) then
9450: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);
9451: end if;
9452: if h_processing_period_num = 1 then
9453: h_ytd_deprn := 0;
9454: h_bonus_ytd_deprn := 0;

Line 9883: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);

9879: h_bonus_ytd_deprn,
9880: h_eofy_reserve;
9881: if GET_PRV_ROW_BS_MRC%NOTFOUND then
9882: if (p_log_level_rec.statement_level) then
9883: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);
9884: end if;
9885: else
9886: if (p_log_level_rec.statement_level) then
9887: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);

Line 9887: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);

9883: fa_debug_pkg.add(l_calling_fn, 'No data in FA_BOOKS_SUMMARY', '***', p_log_level_rec);
9884: end if;
9885: else
9886: if (p_log_level_rec.statement_level) then
9887: fa_debug_pkg.add(l_calling_fn, 'Data in FA_BOOKS_SUMMARY', 'FOUND', p_log_level_rec);
9888: end if;
9889: if h_processing_period_num = 1 then
9890: h_ytd_deprn := 0;
9891: h_bonus_ytd_deprn := 0;

Line 10974: -- This function will be called to insert row into fa_books_summary if not exists

10970:
10971: --+=====================================================================
10972: -- Function: create_update_books_summary
10973: --
10974: -- This function will be called to insert row into fa_books_summary if not exists
10975: -- update fa_books_summary row if exists
10976: --
10977: --+=====================================================================
10978:

Line 10975: -- update fa_books_summary row if exists

10971: --+=====================================================================
10972: -- Function: create_update_books_summary
10973: --
10974: -- This function will be called to insert row into fa_books_summary if not exists
10975: -- update fa_books_summary row if exists
10976: --
10977: --+=====================================================================
10978:
10979: FUNCTION create_update_bs_table(p_trans_rec in FA_API_TYPES.trans_rec_type,

Line 10996: --* Cursor for FA_BOOKS_SUMMARY

10992: h_set_of_books_id number;
10993:
10994: h_chk_bs_flag varchar2(1);
10995:
10996: --* Cursor for FA_BOOKS_SUMMARY
10997: cursor CHK_BS_TABLE is
10998: select 'Y'
10999: from fa_books_summary
11000: where book_type_code = h_book_type_code

Line 10999: from fa_books_summary

10995:
10996: --* Cursor for FA_BOOKS_SUMMARY
10997: cursor CHK_BS_TABLE is
10998: select 'Y'
10999: from fa_books_summary
11000: where book_type_code = h_book_type_code
11001: -- and group_asset_id = h_group_asset_id
11002: and asset_id = h_member_asset_id
11003: and period_counter = h_period_counter;

Line 11008: from fa_books_summary_mrc_v

11004: -- and nvl(set_of_books_id, -99) = nvl(h_set_of_books_id, -99);
11005:
11006: cursor CHK_BS_TABLE_MRC is
11007: select 'Y'
11008: from fa_books_summary_mrc_v
11009: where book_type_code = h_book_type_code
11010: -- and group_asset_id = h_group_asset_id
11011: and asset_id = h_member_asset_id
11012: and period_counter = h_period_counter;

Line 11021: fa_debug_pkg.add(l_calling_fn, '## Start to insert/update fa_books_summary for member assets','####', p_log_level_rec);

11017:
11018: begin
11019:
11020: if (p_log_level_rec.statement_level) then
11021: fa_debug_pkg.add(l_calling_fn, '## Start to insert/update fa_books_summary for member assets','####', p_log_level_rec);
11022: fa_debug_pkg.add(l_calling_fn, 'h_book_type_code:h_group_asset_id',p_book_type_code||':'||p_group_asset_id, p_log_level_rec);
11023: fa_debug_pkg.add(l_calling_fn, 'p_track_member_table.COUNT', p_track_member_table.COUNT, p_log_level_rec);
11024: end if;
11025:

Line 11044: --* query fa_books_summary if this member record for this period exists or not

11040: fa_debug_pkg.add(l_calling_fn, 'cost', p_track_member_table(i).cost, p_log_level_rec);
11041: end if;
11042:
11043: if p_mrc_sob_type_code <> 'R' then
11044: --* query fa_books_summary if this member record for this period exists or not
11045: open CHK_BS_TABLE;
11046: fetch CHK_BS_TABLE into h_chk_bs_flag;
11047: if CHK_BS_TABLE%NOTFOUND then
11048: if (p_log_level_rec.statement_level) then

Line 11049: fa_debug_pkg.add(l_calling_fn, 'Newly insert following assets into fa_books_summary','###', p_log_level_rec);

11045: open CHK_BS_TABLE;
11046: fetch CHK_BS_TABLE into h_chk_bs_flag;
11047: if CHK_BS_TABLE%NOTFOUND then
11048: if (p_log_level_rec.statement_level) then
11049: fa_debug_pkg.add(l_calling_fn, 'Newly insert following assets into fa_books_summary','###', p_log_level_rec);
11050: fa_debug_pkg.add(l_calling_fn, 'h_member_asset_id:h_group_asset_id:h_period_counter',
11051: h_member_asset_id||':'||h_group_asset_id||':'||h_period_counter, p_log_level_rec);
11052: end if;
11053: -- This means to insert new row into FA_BOOKS_SUMMARY

Line 11053: -- This means to insert new row into FA_BOOKS_SUMMARY

11049: fa_debug_pkg.add(l_calling_fn, 'Newly insert following assets into fa_books_summary','###', p_log_level_rec);
11050: fa_debug_pkg.add(l_calling_fn, 'h_member_asset_id:h_group_asset_id:h_period_counter',
11051: h_member_asset_id||':'||h_group_asset_id||':'||h_period_counter, p_log_level_rec);
11052: end if;
11053: -- This means to insert new row into FA_BOOKS_SUMMARY
11054: INSERT INTO FA_BOOKS_SUMMARY
11055: (ASSET_ID,
11056: GROUP_ASSET_ID,
11057: BOOK_TYPE_CODE,

Line 11054: INSERT INTO FA_BOOKS_SUMMARY

11050: fa_debug_pkg.add(l_calling_fn, 'h_member_asset_id:h_group_asset_id:h_period_counter',
11051: h_member_asset_id||':'||h_group_asset_id||':'||h_period_counter, p_log_level_rec);
11052: end if;
11053: -- This means to insert new row into FA_BOOKS_SUMMARY
11054: INSERT INTO FA_BOOKS_SUMMARY
11055: (ASSET_ID,
11056: GROUP_ASSET_ID,
11057: BOOK_TYPE_CODE,
11058: PERIOD_COUNTER,

Line 11102: fa_debug_pkg.add(l_calling_fn, 'Update following assets into fa_books_summary:','####', p_log_level_rec);

11098: fa_debug_pkg.add(l_calling_fn, 'Inserted new row for', h_member_asset_id||':'||h_period_counter, p_log_level_rec);
11099: end if;
11100: else
11101: if (p_log_level_rec.statement_level) then
11102: fa_debug_pkg.add(l_calling_fn, 'Update following assets into fa_books_summary:','####', p_log_level_rec);
11103: fa_debug_pkg.add(l_calling_fn, 'h_member_asset_id:h_group_asset_id:h_period_counter',
11104: h_member_asset_id||':'||h_group_asset_id||':'||h_period_counter, p_log_level_rec);
11105: end if;
11106: UPDATE FA_BOOKS_SUMMARY

Line 11106: UPDATE FA_BOOKS_SUMMARY

11102: fa_debug_pkg.add(l_calling_fn, 'Update following assets into fa_books_summary:','####', p_log_level_rec);
11103: fa_debug_pkg.add(l_calling_fn, 'h_member_asset_id:h_group_asset_id:h_period_counter',
11104: h_member_asset_id||':'||h_group_asset_id||':'||h_period_counter, p_log_level_rec);
11105: end if;
11106: UPDATE FA_BOOKS_SUMMARY
11107: SET COST = p_track_member_table(i).cost
11108: , SALVAGE_VALUE = p_track_member_table(i).salvage_value
11109: , RECOVERABLE_COST = p_track_member_table(i).recoverable_cost
11110: , ADJUSTED_RECOVERABLE_COST = p_track_member_table(i).adjusted_recoverable_cost

Line 11134: --* query fa_books_summary if this member record for this period exists or not

11130: end if;
11131: close CHK_BS_TABLE;
11132: else -- Reporting Book
11133:
11134: --* query fa_books_summary if this member record for this period exists or not
11135: open CHK_BS_TABLE_MRC;
11136: fetch CHK_BS_TABLE_MRC into h_chk_bs_flag;
11137: if CHK_BS_TABLE_MRC%NOTFOUND then
11138: -- This means to insert new row into FA_BOOKS_SUMMARY

Line 11138: -- This means to insert new row into FA_BOOKS_SUMMARY

11134: --* query fa_books_summary if this member record for this period exists or not
11135: open CHK_BS_TABLE_MRC;
11136: fetch CHK_BS_TABLE_MRC into h_chk_bs_flag;
11137: if CHK_BS_TABLE_MRC%NOTFOUND then
11138: -- This means to insert new row into FA_BOOKS_SUMMARY
11139: INSERT INTO FA_MC_BOOKS_SUMMARY
11140: (SET_OF_BOOKS_ID,
11141: ASSET_ID,
11142: GROUP_ASSET_ID,

Line 11188: UPDATE FA_BOOKS_SUMMARY_MRC_V

11184: if (p_log_level_rec.statement_level) then
11185: fa_debug_pkg.add(l_calling_fn, 'Inserted new row for', h_member_asset_id||':'||h_period_counter, p_log_level_rec);
11186: end if;
11187: else
11188: UPDATE FA_BOOKS_SUMMARY_MRC_V
11189: SET COST = p_track_member_table(i).cost
11190: , SALVAGE_VALUE = p_track_member_table(i).salvage_value
11191: , RECOVERABLE_COST = p_track_member_table(i).recoverable_cost
11192: , ADJUSTED_RECOVERABLE_COST = p_track_member_table(i).adjusted_recoverable_cost

Line 11220: fa_debug_pkg.add(l_calling_fn, '## End of insert/update fa_books_summary for member assets','####', p_log_level_rec);

11216: end if;
11217: END LOOP;
11218:
11219: if (p_log_level_rec.statement_level) then
11220: fa_debug_pkg.add(l_calling_fn, '## End of insert/update fa_books_summary for member assets','####', p_log_level_rec);
11221: end if;
11222:
11223: return (true);
11224: