DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_BOOK_CONTROLS

Line 104: from fa_book_controls

100: BEGIN
101:
102: select count(*)
103: into l_count
104: from fa_book_controls
105: where set_of_books_id = p_ledger_id
106: and book_class = 'CORPORATE';
107:
108: if (g_log_level_rec.statement_level) then

Line 167: fa_book_controls bc,

163: from (select asset_clearing_acct clearing_acct
164: ,cb.book_type_code
165: ,2 acct_type
166: from fa_category_books cb,
167: fa_book_controls bc,
168: fa_categories fc
169: where cb.book_type_code = bc.book_type_code
170: and bc.book_class = 'CORPORATE'
171: and bc.set_of_books_id = p_ledger_id

Line 179: fa_book_controls bc,

175: select cip_clearing_acct
176: ,cb.book_type_code
177: ,1
178: from fa_category_books cb,
179: fa_book_controls bc,
180: fa_categories fc
181: where cip_clearing_acct is not null
182: and cb.book_type_code = bc.book_type_code
183: and bc.book_class = 'CORPORATE'

Line 1344: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;

1340: l_calling_fn varchar2(40) := 'FA_MASS_ADDITIONS_PKG.create_lines';
1341:
1342: l_count INTEGER;
1343:
1344: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
1345: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
1346: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
1347: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
1348: l_segment_num NUMBER;

Line 1345: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;

1341:
1342: l_count INTEGER;
1343:
1344: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
1345: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
1346: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
1347: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
1348: l_segment_num NUMBER;
1349: l_app_column_name VARCHAR2(100);

Line 1346: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;

1342: l_count INTEGER;
1343:
1344: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
1345: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
1346: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
1347: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
1348: l_segment_num NUMBER;
1349: l_app_column_name VARCHAR2(100);
1350: l_def_dpis_option VARCHAR2(1);

Line 1347: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;

1343:
1344: l_date_ineffective FA_BOOK_CONTROLS.DATE_INEFFECTIVE%TYPE;
1345: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
1346: l_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
1347: l_coa_id FA_BOOK_CONTROLS.ACCOUNTING_FLEX_STRUCTURE%TYPE;
1348: l_segment_num NUMBER;
1349: l_app_column_name VARCHAR2(100);
1350: l_def_dpis_option VARCHAR2(1);
1351: l_def_dpis_enabled INTEGER;