DBA Data[Home] [Help]

APPS.FA_GAINLOSS_PKG dependencies on FA_CACHE_PKG

Line 5: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_GAINLOSS_PKG as
2: /* $Header: FAGMNB.pls 120.41.12020000.2 2012/07/23 10:54:59 rmandali ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_release number := fa_cache_pkg.fazarel_release;
6: g_run_mode varchar2(20) := 'NORMAL';
7:
8: PROCEDURE Do_Calc_GainLoss (
9: p_book_type_code IN VARCHAR2,

Line 96: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

92: value => '', p_log_level_rec => g_log_level_rec);
93: end if;
94:
95: -- call the book controls cache
96: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
97: raise gainloss_err;
98: end if;
99:
100: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

Line 100: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

96: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
97: raise gainloss_err;
98: end if;
99:
100: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
101:
102: if g_log_level_rec.statement_level then
103: fa_debug_pkg.add
104: (fname => l_calling_fn,

Line 260: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

256: l_user_id number;
257: l_sysdate date;
258:
259: -- Local record types
260: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
261: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
262: l_trans_rec FA_API_TYPES.trans_rec_type;
263: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
264: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 342: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then

338: value => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec);
339: end if;
340:
341: -- call the book controls cache
342: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
343: raise gainloss_err;
344: end if;
345:
346: -- CHECK: Would asset_number be really necessary for processing fagpsa ?

Line 484: if fa_cache_pkg.fazcbc_record.deprn_allocation_code = 'E' then

480:
481: ret.prorate_convention := l_asset_retire_rec.retirement_prorate_convention;
482:
483: -- from primary book
484: if fa_cache_pkg.fazcbc_record.deprn_allocation_code = 'E' then
485: ret.dpr_evenly := 1;
486: else
487: ret.dpr_evenly := 0;
488: end if;

Line 497: ret.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

493: element => 'l_asset_retire_rec.cost_retired',
494: value => l_asset_retire_rec.cost_retired, p_log_level_rec => p_log_level_rec);
495: end if;
496:
497: ret.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
498:
499: -- Call fagpsa to process a retirement
500: if not FA_GAINLOSS_PRO_PKG.fagpsa
501: (ret,

Line 560: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then

556:
557: end if; -- fagpsa
558:
559: -- code fix for bug no.3641602.Call the book controls cache again
560: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
561: raise gainloss_err;
562: end if;
563:
564: -- SLA: store the ledger id for future use

Line 565: l_primary_sob_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

561: raise gainloss_err;
562: end if;
563:
564: -- SLA: store the ledger id for future use
565: l_primary_sob_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
566: l_asset_hdr_rec.set_of_books_id := l_primary_sob_id;--Bug 10252159
567:
568: /*******************************
569: * MRC LOOP for Reporting books

Line 572: if fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y' then

568: /*******************************
569: * MRC LOOP for Reporting books
570: ********************************/
571: -- if this is a primary book, process reporting books(sobs)
572: if fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y' then
573:
574: -- call the sob cache to get the table of sob_ids
575: if not FA_CACHE_PKG.fazcrsob
576: (x_book_type_code => l_asset_hdr_rec.book_type_code,

Line 575: if not FA_CACHE_PKG.fazcrsob

571: -- if this is a primary book, process reporting books(sobs)
572: if fa_cache_pkg.fazcbc_record.mc_source_flag = 'Y' then
573:
574: -- call the sob cache to get the table of sob_ids
575: if not FA_CACHE_PKG.fazcrsob
576: (x_book_type_code => l_asset_hdr_rec.book_type_code,
577: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
578: raise gainloss_err;
579: end if;

Line 592: if not fa_cache_pkg.fazcbcs(x_book => l_asset_hdr_rec.book_type_code,

588: element => '+++ Step 2: in Reporting book loop: Set_of_books_id',
589: value => l_sob_tbl(l_sob_index));
590: end if;
591:
592: if not fa_cache_pkg.fazcbcs(x_book => l_asset_hdr_rec.book_type_code,
593: x_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
594: p_log_level_rec => p_log_level_rec) then
595: raise gainloss_err;
596: end if;

Line 653: if fa_cache_pkg.fazcbcs_record.deprn_allocation_code = 'E' then

649: and set_of_books_id = l_sob_tbl(l_sob_index);
650:
651: ret.prorate_convention := lv_asset_retire_rec.retirement_prorate_convention;
652: -- from reporting book
653: if fa_cache_pkg.fazcbcs_record.deprn_allocation_code = 'E' then
654: ret.dpr_evenly := 1;
655: else
656: ret.dpr_evenly := 0;
657: end if;

Line 683: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then

679:
680: end loop; -- loop through reporting books
681:
682: --for bug no.3831503
683: if not fa_cache_pkg.fazcbc(X_book => l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
684: raise gainloss_err;
685: end if;
686: end if; -- if this is a primary book
687:

Line 765: if p_log_level_rec.statement_level then fa_debug_pkg.add (fname => l_calling_fn,element => 'before secondary create fa_cache_pkg.fazcbcs_record.SET_OF_BOOKS_ID ',value => fa_cache_pkg.fazcbcs_record.SET_OF_BOOKS_ID); end if;

761: l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(l_asset_hdr_rec.book_type_code);
762:
763: if p_log_level_rec.statement_level then fa_debug_pkg.add (fname => l_calling_fn,element => 'before secondary create l_secondary_sob_id ',value => l_secondary_sob_id); end if;
764: if p_log_level_rec.statement_level then fa_debug_pkg.add (fname => l_calling_fn,element => 'before secondary create l_primary_sob_id ',value => l_primary_sob_id); end if;
765: if p_log_level_rec.statement_level then fa_debug_pkg.add (fname => l_calling_fn,element => 'before secondary create fa_cache_pkg.fazcbcs_record.SET_OF_BOOKS_ID ',value => fa_cache_pkg.fazcbcs_record.SET_OF_BOOKS_ID); end if;
766: if (l_secondary_sob_id is not null) then
767: l_secondary_asset_hdr_rec := l_asset_hdr_rec;
768: l_secondary_asset_hdr_rec.set_of_books_id := l_secondary_sob_id;
769: l_secondary_trans_rec := l_trans_rec;