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 277: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

273: -- used for tax books when doing cip-in-tax or autocopy
274: l_trans_rec FA_API_TYPES.trans_rec_type;
275: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
276: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
277: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
278: l_tax_index NUMBER; -- index for tax loop
279:
280: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_cap_rev';
281: cap_rev_err EXCEPTION;

Line 346: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then

342: end if;
343: end if;
344:
345: -- call the cache for the primary transaction book
346: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
347: raise cap_rev_err;
348: end if;
349:
350: -- commenting this out until after complete uptake of apis

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

353: -- package will and must only be called for corporate book
354: -- (the if condition for book class for the cip-tax loop
355: -- will also become obsolete)
356: --
357: -- if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then
358: -- fa_srvr_msg.add_message
359: -- (calling_fn => l_calling_fn,
360: -- name => '**FA_NO_DIR_CAP_TAX***');
361: -- raise cap_rev_err;

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

360: -- name => '**FA_NO_DIR_CAP_TAX***');
361: -- raise cap_rev_err;
362: -- end if;
363:
364: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
365: -- verify the asset exist in the book already
366: if not FA_ASSET_VAL_PVT.validate_asset_book
367: (p_transaction_type_code => 'CAPITALIZATION',
368: p_book_type_code => px_asset_hdr_rec.book_type_code,

Line 388: if not fa_cache_pkg.fazcsob

384: -- that is not tied to a SOB_ID by getting the value from
385: -- the book struct
386:
387: -- Get the book type code P,R or N
388: if not fa_cache_pkg.fazcsob
389: (X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
390: X_mrc_sob_type_code => l_reporting_flag
391: , p_log_level_rec => p_log_level_rec) then
392: raise cap_rev_err;

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

446:
447: -- remove after api update
448: -- verify the transaction / asset type combi is valid for corp books
449:
450: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
451:
452: if (((l_asset_type_rec.asset_type = 'CIP') and
453: (px_trans_rec.transaction_type_code = 'CIP REVERSE')) or
454: ((l_asset_type_rec.asset_type = 'CAPITALIZED') and

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

480:
481: -- remove the if condition after api update as this will always be corp book
482: -- If book is a corporate book, process cip assets and autocopy
483:
484: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
485:
486: -- null out the deprn_adj table as we do not want to autocopy
487: -- any deprn info to tax books
488: -- still need to DO THIS!!!

Line 500: if not fa_cache_pkg.fazctbk

496: -- capitalization, calling the additions api or for reversals
497: -- deleting the asset from tax books in period of addition
498: -- if allow cip assets is not enabled.
499:
500: if not fa_cache_pkg.fazctbk
501: (x_corp_book => px_asset_hdr_rec.book_type_code,
502: x_asset_type => 'CIP',
503: x_tax_book_tbl => l_tax_book_tbl, p_log_level_rec => p_log_level_rec) then
504: raise cap_rev_err;

Line 564: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

560: l_asset_fin_rec.percent_salvage_value,
561: l_asset_fin_rec.salvage_value
562: from fa_books
563: where asset_id = px_asset_hdr_rec.asset_id
564: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
565: and transaction_header_id_in = l_corp_thid;
566:
567: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
568: l_asset_fin_rec.group_asset_id := null;

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

563: where asset_id = px_asset_hdr_rec.asset_id
564: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
565: and transaction_header_id_in = l_corp_thid;
566:
567: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
568: l_asset_fin_rec.group_asset_id := null;
569: end if;
570:
571: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

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

567: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
568: l_asset_fin_rec.group_asset_id := null;
569: end if;
570:
571: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
572: l_asset_fin_rec.salvage_type := null;
573: l_asset_fin_rec.percent_salvage_value := null;
574: l_asset_fin_rec.salvage_value := null;
575: end if;

Line 608: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index),

604: -- end bugfix# 5155488
605: else
606:
607: -- cache the book information for the tax book
608: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index),
609: p_log_level_rec => p_log_level_rec)) then
610: raise cap_rev_err;
611: end if;
612:

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

614: -- May need to set the transaction date, trx_type, subtype here as well
615: -- based on the open period and settings for each tax book in the loop
616:
617: l_asset_hdr_rec.book_type_code := l_tax_book_tbl(l_tax_index);
618: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
619:
620: l_trans_rec.source_transaction_header_id := px_trans_rec.transaction_header_id;
621: l_trans_rec.mass_reference_id := px_trans_rec.mass_reference_id;
622: l_trans_rec.transaction_header_id := null;

Line 700: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

696:
697: -- used for retrieving "new" structs from private api calls
698: l_reporting_flag varchar2(1);
699: l_period_rec FA_API_TYPES.period_rec_type;
700: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
701:
702: -- used for get_rate
703: l_exchange_date date;
704: l_rate number;

Line 736: if not fa_cache_pkg.fazccb

732:
733: BEGIN
734:
735: -- call the category cache used for faxinajc calls
736: if not fa_cache_pkg.fazccb
737: (X_book => px_asset_hdr_rec.book_type_code,
738: X_cat_id => p_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
739: raise cap_rev_err;
740: end if;

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

769: end if;
770:
771: -- Bugfix #4730248
772: if(px_asset_fin_rec.date_placed_in_service is null) then
773: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
774: l_date_placed_in_service := greatest(l_period_rec.calendar_period_open_date,
775: least(sysdate,l_period_rec.calendar_period_close_date));
776:
777: px_asset_fin_rec.date_placed_in_service :=

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

783: -- Default transaction_date_entered
784: if ((px_trans_rec.transaction_date_entered is null) and
785: (px_asset_fin_rec.date_placed_in_service is null)) then
786:
787: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
788: -- Default to last day of the period
789: l_transaction_date := greatest(l_period_rec.calendar_period_open_date,
790: least(sysdate,l_period_rec.calendar_period_close_date));
791: px_trans_rec.transaction_date_entered :=

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

812: -- NOTE: not overiding salvage /limit info here
813: --
814:
815:
816: if not fa_cache_pkg.fazccbd (X_book => px_asset_hdr_rec.book_type_code,
817: X_cat_id => p_asset_cat_rec.category_id,
818: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J')),
819: p_log_level_rec => p_log_level_rec) then
820: raise cap_rev_err;

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

820: raise cap_rev_err;
821: end if;
822:
823:
824: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;

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

821: end if;
822:
823:
824: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;

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

822:
823:
824: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;

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

823:
824: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;

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

824: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;

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

825: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;

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

826: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
834:

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

827: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
834:
835: -- call the sob cache to get the table of sob_ids

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

828: px_asset_fin_rec.prorate_convention_code := fa_cache_pkg.fazccbd_record.prorate_convention_code;
829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
834:
835: -- call the sob cache to get the table of sob_ids
836: if not FA_CACHE_PKG.fazcrsob

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

829: px_asset_fin_rec.depreciate_flag := fa_cache_pkg.fazccbd_record.depreciate_flag;
830: px_asset_fin_rec.bonus_rule := fa_cache_pkg.fazccbd_record.bonus_rule;
831: px_asset_fin_rec.ceiling_name := fa_cache_pkg.fazccbd_record.ceiling_name;
832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
834:
835: -- call the sob cache to get the table of sob_ids
836: if not FA_CACHE_PKG.fazcrsob
837: (x_book_type_code => px_asset_hdr_rec.book_type_code,

Line 836: if not FA_CACHE_PKG.fazcrsob

832: px_asset_fin_rec.production_capacity := fa_cache_pkg.fazccbd_record.production_capacity;
833: px_asset_fin_rec.unit_of_measure := fa_cache_pkg.fazccbd_record.unit_of_measure;
834:
835: -- call the sob cache to get the table of sob_ids
836: if not FA_CACHE_PKG.fazcrsob
837: (x_book_type_code => px_asset_hdr_rec.book_type_code,
838: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
839: raise cap_rev_err;
840: end if;

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

873:
874:
875: -- call the cache to set the sob_id used for rounding and other lower
876: -- level code for each book.
877: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,
878: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
879: p_log_level_rec => p_log_level_rec) then
880: raise cap_rev_err;
881: end if;