APPS.FA_MASSADD_CREATE_PKG dependencies on FA_BOOK_CONTROLS

Line 158: from fa_book_controls

154: savepoint FAMADC_preprocess1;
155:
156: select count(*)
157: into l_count
158: from fa_book_controls
159: where set_of_books_id = p_ledger_id
160: and book_class = 'CORPORATE';
161:
162: DebugLog( 'number of book for this ledger', to_char(l_count) );

Line 204: fa_book_controls bc

200: from (select asset_clearing_acct clearing_acct
201: , cb.book_type_code
202: , 2 acct_type
203: from fa_category_books cb,
204: fa_book_controls bc
205: where cb.book_type_code = bc.book_type_code
206: and bc.book_class = 'CORPORATE'
207: and bc.set_of_books_id = p_ledger_id
208: UNION

Line 211: fa_book_controls bc

207: and bc.set_of_books_id = p_ledger_id
208: UNION
209: select cip_clearing_acct , cb.book_type_code, 1
210: from fa_category_books cb,
211: fa_book_controls bc
212: where cip_clearing_acct is not null
213: and cb.book_type_code = bc.book_type_code
214: and bc.book_class = 'CORPORATE'
215: and bc.set_of_books_id = p_ledger_id)

Line 506: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;

502: l_calling_fn varchar2(40) := 'FA_MASS_ADDITIONS_PKG.create_lines';
503:
504: l_count INTEGER;
505:
506: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
507: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
508: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
509: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
510: l_segment_num NUMBER;

Line 507: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;

503:
504: l_count INTEGER;
505:
506: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
507: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
508: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
509: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
510: l_segment_num NUMBER;
511: l_def_dpis_option VARCHAR2(1);

Line 508: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;

504: l_count INTEGER;
505:
506: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
507: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
508: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
509: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
510: l_segment_num NUMBER;
511: l_def_dpis_option VARCHAR2(1);
512: l_def_dpis_enabled INTEGER;

Line 509: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;

505:
506: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
507: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
508: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
509: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
510: l_segment_num NUMBER;
511: l_def_dpis_option VARCHAR2(1);
512: l_def_dpis_enabled INTEGER;
513: l_def_dpis_dt DATE;