APPS.FA_MC_BOOK_CONTROLS_PKG dependencies on FA_BOOK_CONTROLS

Line 58: from fa_book_controls

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

Line 234: from fa_book_controls bc,

230: select lg.ledger_id,
231: lg.currency_code
232: into l_src_ledger_id,
233: l_src_currency
234: from fa_book_controls bc,
235: gl_ledgers lg
236: where bc.book_type_code = p_book_type_code
237: and lg.ledger_id = bc.set_of_books_id;
238:

Line 369: from fa_book_controls

365:
366: BEGIN
367: select mass_request_id
368: into l_mass_id
369: from fa_book_controls
370: where book_type_code = p_book_type_code
371: and deprn_status = 'C';
372: EXCEPTION
373: WHEN OTHERS THEN

Line 385: from fa_book_controls

381:
382: BEGIN
383: select mass_request_id
384: into l_mass_id
385: from fa_book_controls
386: where book_type_code = p_book_type_code
387: and mass_request_id is null
388: for update of mass_request_id
389: NOWAIT;

Line 442: 'remaining values from fa_book_controls',

438: if (g_log_level_rec.statement_level) then
439: fa_debug_pkg.add
440: (l_calling_fn,
441: 'fetching',
442: 'remaining values from fa_book_controls',
443: p_log_level_rec => g_log_level_rec);
444: end if;
445:
446: select last_deprn_run_date,

Line 452: from fa_book_controls

448: current_fiscal_year
449: into l_last_deprn_run_date,
450: l_last_period_counter,
451: l_current_fiscal_year
452: from fa_book_controls
453: where book_type_code = p_book_type_code;
454:
455: -- insert mc book controls record
456: if (g_log_level_rec.statement_level) then

Line 625: 'fa_book_controls.mc_source_flag',

621: if (g_log_level_rec.statement_level) then
622: fa_debug_pkg.add
623: (l_calling_fn,
624: 'updating',
625: 'fa_book_controls.mc_source_flag',
626: p_log_level_rec => g_log_level_rec);
627: end if;
628:
629: update fa_book_controls

Line 629: update fa_book_controls

625: 'fa_book_controls.mc_source_flag',
626: p_log_level_rec => g_log_level_rec);
627: end if;
628:
629: update fa_book_controls
630: set mc_source_flag = 'Y'
631: where book_type_code = p_book_type_code;
632:
633: if (g_log_level_rec.statement_level) then