APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_CACHE_PKG

Line 20: l_sob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;

16: l_event_id_tbl FA_XLA_EVENTS_PVT.number_tbl_type;
17: l_event_date date;
18:
19: l_sob_index number;
20: l_sob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
21:
22: l_batch_size number;
23: l_calling_fn varchar2(60) := 'FA_DEPRN_EVENTS_PKG.process_deprn_events';
24:

Line 81: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,

77: if (g_log_level_rec.statement_level) then
78: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => g_log_level_rec);
79: end if;
80:
81: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,
82: p_log_level_rec => g_log_level_rec) then
83: raise error_found;
84: end if;
85:

Line 86: if not fa_cache_pkg.fazcdp(x_book_type_code => p_book_type_code,

82: p_log_level_rec => g_log_level_rec) then
83: raise error_found;
84: end if;
85:
86: if not fa_cache_pkg.fazcdp(x_book_type_code => p_book_type_code,
87: x_period_counter => p_period_counter,
88: x_effective_date => null,
89: p_log_level_rec => g_log_level_rec) then
90: raise error_found;

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

94: fa_debug_pkg.add(l_calling_fn, 'setting ', 'batch size',
95: p_log_level_rec => g_log_level_rec);
96: end if;
97:
98: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
99:
100: select fa_deprn_summary_s.nextval
101: into l_deprn_run_id
102: from dual;

Line 144: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,

140: p_log_level_rec => g_log_level_rec);
141: end if;
142:
143: l_event_date :=
144: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
145: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
146: sysdate),
147: sysdate));
148:

Line 145: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,

141: end if;
142:
143: l_event_date :=
144: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
145: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
146: sysdate),
147: sysdate));
148:
149: fa_xla_events_pvt.create_bulk_deprn_event

Line 288: if not FA_CACHE_PKG.fazcrsob

284:
285: CLOSE deprn_events;
286:
287: -- now find any mrc rows which are not processed yet and update
288: if not FA_CACHE_PKG.fazcrsob
289: (x_book_type_code => p_book_type_code,
290: x_sob_tbl => l_sob_tbl,
291: p_log_level_rec => g_log_level_rec) then
292: raise error_found;

Line 331: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,

327:
328: -- Bug 13481113 : Using fa_deprn_periods open and close dates as they
329: -- should match mc values instead of sysdate
330: l_event_date :=
331: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
332: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
333: sysdate),
334: sysdate));
335:

Line 332: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,

328: -- Bug 13481113 : Using fa_deprn_periods open and close dates as they
329: -- should match mc values instead of sysdate
330: l_event_date :=
331: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
332: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
333: sysdate),
334: sysdate));
335:
336: if (g_log_level_rec.statement_level) then

Line 496: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,

492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => p_log_level_rec);
494: end if;
495:
496: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,
497: p_log_level_rec => p_log_level_rec) then
498: raise error_found;
499: end if;
500:

Line 501: if not fa_cache_pkg.fazcdp(x_book_type_code => p_book_type_code,

497: p_log_level_rec => p_log_level_rec) then
498: raise error_found;
499: end if;
500:
501: if not fa_cache_pkg.fazcdp(x_book_type_code => p_book_type_code,
502: x_period_counter => p_period_counter,
503: x_effective_date => null,
504: p_log_level_rec => p_log_level_rec) then
505: raise error_found;

Line 518: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,

514: p_log_level_rec => p_log_level_rec);
515: end if;
516:
517: l_event_date :=
518: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
519: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
520: sysdate),
521: sysdate));
522:

Line 519: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,

515: end if;
516:
517: l_event_date :=
518: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
519: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
520: sysdate),
521: sysdate));
522:
523: fa_xla_events_pvt.create_deprn_event

Line 529: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

525: p_book_type_code => p_book_type_code,
526: p_period_counter => p_period_counter,
527: p_period_close_date => l_event_date,
528: p_deprn_run_id => l_deprn_run_id,
529: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
530: x_event_id => l_event_id,
531: p_calling_fn => l_calling_fn,
532: p_log_level_rec => p_log_level_rec);
533: