APPS.FA_MC_BOOK_CONTROLS_PKG dependencies on FA_BOOK_CONTROLS

Line 60: from fa_book_controls

56: error_found EXCEPTION;
57:
58: cursor c_book_controls is
59: select book_type_code
60: from fa_book_controls
61: where set_of_books_id = p_src_ledger_id;
62:
63: BEGIN
64:

Line 252: from fa_book_controls bc,

248: l_src_currency,
249: l_book_class,
250: l_ledger_category_code,
251: l_corp_book
252: from fa_book_controls bc,
253: gl_ledgers lg
254: where bc.book_type_code = p_book_type_code
255: and lg.ledger_id = bc.set_of_books_id;
256: --Secondary Changes start

Line 410: from fa_book_controls

406:
407: BEGIN
408: select mass_request_id
409: into l_mass_id
410: from fa_book_controls
411: where book_type_code = p_book_type_code
412: and deprn_status = 'C';
413: EXCEPTION
414: WHEN OTHERS THEN

Line 426: from fa_book_controls

422:
423: BEGIN
424: select mass_request_id
425: into l_mass_id
426: from fa_book_controls
427: where book_type_code = p_book_type_code
428: and mass_request_id is null
429: for update of mass_request_id
430: NOWAIT;

Line 483: 'remaining values from fa_book_controls',

479: if (g_log_level_rec.statement_level) then
480: fa_debug_pkg.add
481: (l_calling_fn,
482: 'fetching',
483: 'remaining values from fa_book_controls',
484: p_log_level_rec => g_log_level_rec);
485: end if;
486:
487: select last_deprn_run_date,

Line 493: from fa_book_controls

489: current_fiscal_year
490: into l_last_deprn_run_date,
491: l_last_period_counter,
492: l_current_fiscal_year
493: from fa_book_controls
494: where book_type_code = p_book_type_code;
495:
496: -- insert mc book controls record
497: if (g_log_level_rec.statement_level) then

Line 668: 'fa_book_controls.mc_source_flag',

664: if (g_log_level_rec.statement_level) then
665: fa_debug_pkg.add
666: (l_calling_fn,
667: 'updating',
668: 'fa_book_controls.mc_source_flag',
669: p_log_level_rec => g_log_level_rec);
670: end if;
671:
672: update fa_book_controls

Line 672: update fa_book_controls

668: 'fa_book_controls.mc_source_flag',
669: p_log_level_rec => g_log_level_rec);
670: end if;
671:
672: update fa_book_controls
673: set mc_source_flag = 'Y'
674: where book_type_code = p_book_type_code;
675:
676: if (g_log_level_rec.statement_level) then