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_CIP_PUB dependencies on FA_CACHE_PKG

Line 291: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

287: -- used for tax books when doing cip-in-tax or autocopy
288: l_trans_rec FA_API_TYPES.trans_rec_type;
289: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
290: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
291: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
292: l_tax_index NUMBER; -- index for tax loop
293:
294: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_cap_rev';
295: cap_rev_err EXCEPTION;

Line 352: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code

348: end if;
349: end if;
350:
351: -- call the cache for the primary transaction book
352: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code
353: ,p_log_level_rec => p_log_level_rec) then
354: raise cap_rev_err;
355: end if;
356:

Line 364: -- if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then

360: -- package will and must only be called for corporate book
361: -- (the if condition for book class for the cip-tax loop
362: -- will also become obsolete)
363: --
364: -- if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then
365: -- fa_srvr_msg.add_message
366: -- (calling_fn => l_calling_fn,
367: -- name => '**FA_NO_DIR_CAP_TAX***');
368: -- raise cap_rev_err;

Line 371: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

367: -- name => '**FA_NO_DIR_CAP_TAX***');
368: -- raise cap_rev_err;
369: -- end if;
370:
371: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
372:
373: -- verify the asset exist in the book already
374: if not FA_ASSET_VAL_PVT.validate_asset_book
375: (p_transaction_type_code => 'CAPITALIZATION',

Line 402: if not fa_cache_pkg.fazcsob

398: -- that is not tied to a SOB_ID by getting the value from
399: -- the book struct
400:
401: -- Get the book type code P,R or N
402: if not fa_cache_pkg.fazcsob
403: (X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
404: X_mrc_sob_type_code => l_reporting_flag
405: ,p_log_level_rec => p_log_level_rec) then
406: raise cap_rev_err;

Line 465: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

461:
462: -- remove after api update
463: -- verify the transaction / asset type combi is valid for corp books
464:
465: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
466:
467: if (((l_asset_type_rec.asset_type = 'CIP') and
468: (px_trans_rec.transaction_type_code = 'CIP REVERSE')) or
469: ((l_asset_type_rec.asset_type = 'CAPITALIZED') and

Line 497: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

493:
494: -- remove the if condition after api update as this will always be corp book
495: -- If book is a corporate book, process cip assets and autocopy
496:
497: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
498:
499: -- null out the deprn_adj table as we do not want to autocopy
500: -- any deprn info to tax books
501: -- still need to DO THIS!!!

Line 513: if not fa_cache_pkg.fazctbk

509: -- capitalization, calling the additions api or for reversals
510: -- deleting the asset from tax books in period of addition
511: -- if allow cip assets is not enabled.
512:
513: if not fa_cache_pkg.fazctbk
514: (x_corp_book => px_asset_hdr_rec.book_type_code,
515: x_asset_type => 'CIP',
516: x_tax_book_tbl => l_tax_book_tbl
517: ,p_log_level_rec => p_log_level_rec) then

Line 578: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

574: l_asset_fin_rec.percent_salvage_value,
575: l_asset_fin_rec.salvage_value
576: from fa_books
577: where asset_id = px_asset_hdr_rec.asset_id
578: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
579: and transaction_header_id_in = l_corp_thid;
580:
581: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
582: l_asset_fin_rec.group_asset_id := null;

Line 581: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then

577: where asset_id = px_asset_hdr_rec.asset_id
578: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
579: and transaction_header_id_in = l_corp_thid;
580:
581: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
582: l_asset_fin_rec.group_asset_id := null;
583: end if;
584:
585: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

Line 585: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

581: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
582: l_asset_fin_rec.group_asset_id := null;
583: end if;
584:
585: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
586: l_asset_fin_rec.salvage_type := null;
587: l_asset_fin_rec.percent_salvage_value := null;
588: l_asset_fin_rec.salvage_value := null;
589: end if;

Line 622: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index))) then

618: -- end bugfix# 5155488
619: else
620:
621: -- cache the book information for the tax book
622: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index))) then
623: raise cap_rev_err;
624: end if;
625:
626: -- NOTE!!!!

Line 631: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

627: -- May need to set the transaction date, trx_type, subtype here as well
628: -- based on the open period and settings for each tax book in the loop
629:
630: l_asset_hdr_rec.book_type_code := l_tax_book_tbl(l_tax_index);
631: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
632:
633: l_trans_rec.source_transaction_header_id := px_trans_rec.transaction_header_id;
634: l_trans_rec.mass_reference_id := px_trans_rec.mass_reference_id;
635: l_trans_rec.transaction_header_id := null;

Line 722: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

718:
719: -- used for retrieving "new" structs from private api calls
720: l_reporting_flag varchar2(1);
721: l_period_rec FA_API_TYPES.period_rec_type;
722: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
723:
724: -- used for get_rate
725: l_exchange_date date;
726: l_rate number;

Line 758: if not fa_cache_pkg.fazccb

754:
755: BEGIN
756:
757: -- call the category cache used for faxinajc calls
758: if not fa_cache_pkg.fazccb
759: (X_book => px_asset_hdr_rec.book_type_code,
760: X_cat_id => p_asset_cat_rec.category_id
761: ,p_log_level_rec => p_log_level_rec) then
762: raise cap_rev_err;

Line 797: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

793: end if;
794:
795: -- Bugfix #4904281
796: if(px_asset_fin_rec.date_placed_in_service is null) then
797: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
798: l_date_placed_in_service := greatest(l_period_rec.calendar_period_open_date,
799: least(sysdate,l_period_rec.calendar_period_close_date));
800:
801: px_asset_fin_rec.date_placed_in_service :=

Line 810: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

806: -- Default transaction_date_entered
807: if ((px_trans_rec.transaction_date_entered is null) and
808: (px_asset_fin_rec.date_placed_in_service is null)) then
809:
810: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
811: -- Default to last day of the period
812: l_transaction_date := greatest(l_period_rec.calendar_period_open_date,
813: least(sysdate,l_period_rec.calendar_period_close_date));
814: px_trans_rec.transaction_date_entered :=

Line 840: if not fa_cache_pkg.fazccbd (X_book => px_asset_hdr_rec.book_type_code,

836: --
837: -- l_asset_fin_rec_old := NULL;
838:
839:
840: if not fa_cache_pkg.fazccbd (X_book => px_asset_hdr_rec.book_type_code,
841: X_cat_id => p_asset_cat_rec.category_id,
842: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J'))) then
843: raise cap_rev_err;
844: end if;

Line 846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;

842: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J'))) then
843: raise cap_rev_err;
844: end if;
845:
846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;

Line 847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;

843: raise cap_rev_err;
844: end if;
845:
846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;

Line 848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;

844: end if;
845:
846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;

Line 849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;

845:
846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;

Line 850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;

846: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;

Line 851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;

847: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;

Line 852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;

848: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
856:

Line 853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;

849: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
856:
857: -- call the sob cache to get the table of sob_ids

Line 854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;

850: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
856:
857: -- call the sob cache to get the table of sob_ids
858: if not FA_CACHE_PKG.fazcrsob

Line 855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;

851: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
852: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
853: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
856:
857: -- call the sob cache to get the table of sob_ids
858: if not FA_CACHE_PKG.fazcrsob
859: (x_book_type_code => px_asset_hdr_rec.book_type_code,

Line 858: if not FA_CACHE_PKG.fazcrsob

854: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
855: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
856:
857: -- call the sob cache to get the table of sob_ids
858: if not FA_CACHE_PKG.fazcrsob
859: (x_book_type_code => px_asset_hdr_rec.book_type_code,
860: x_sob_tbl => l_sob_tbl
861: ,p_log_level_rec => p_log_level_rec) then
862: raise cap_rev_err;

Line 907: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code

903:
904:
905: -- call the cache to set the sob_id used for rounding and other lower
906: -- level code for each book.
907: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code
908: ,p_log_level_rec => p_log_level_rec) then
909: raise cap_rev_err;
910: end if;
911: