APPS.FA_MASSADD_PREP_DEFAULT_PKG dependencies on FA_BOOK_CONTROLS

Line 29: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;

25: l_minor_ccid number;
26: l_clearing_acct_ccid number;
27: l_category_id number;
28: l_gl_ccid_enabled_flag varchar2(1);
29: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
30: l_bal_seg_num NUMBER;
31: l_lookup_code varchar2(30);
32: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
33: l_account_segment varchar2(30);

Line 41: From fa_book_controls bc, gl_sets_of_books sob

37: begin
38:
39: Select sob.chart_of_accounts_id
40: into h_chart_of_accounts_id
41: From fa_book_controls bc, gl_sets_of_books sob
42: Where sob.set_of_books_id = bc.set_of_books_id
43: And bc.book_type_code = px_mass_add_rec.book_type_code;
44:
45: if (px_mass_add_rec.PAYABLES_CODE_COMBINATION_ID is not null) then

Line 66: from fa_book_controls

62: p_log_level_rec => p_log_level_rec);
63: end if;
64: select ACCOUNTING_FLEX_STRUCTURE
65: into l_ACCOUNTING_FLEX_STRUCTURE
66: from fa_book_controls
67: where book_type_code = px_mass_add_rec.BOOK_TYPE_CODE;
68:
69: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
70: 101,

Line 219: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;

215: l_segment varchar30_tbl;
216: l_exp_acct_index number;
217: l_exp_acct_ccid number;
218: l_gl_ccid_enabled_flag varchar2(1);
219: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
220: l_calling_fn varchar2(40) := 'prepare_expense_ccid';
221: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
222: h_flex_segment_delimiter varchar2(5);
223: h_flex_segment_number number;

Line 263: from fa_book_controls

259: begin
260: /*commented for bug 4928682
261: select FLEXBUILDER_DEFAULTS_CCID
262: into l_default_ccid
263: from fa_book_controls
264: where book_type_code = px_mass_add_rec.book_type_code;
265: */
266: SELECT deprn_expense_acct,
267: asset_cost_account_ccid,

Line 280: From fa_book_controls bc,

276:
277: -- Get Chart of Accounts ID
278: Select sob.chart_of_accounts_id
279: into h_chart_of_accounts_id
280: From fa_book_controls bc,
281: gl_sets_of_books sob
282: Where sob.set_of_books_id = bc.set_of_books_id
283: And bc.book_type_code = px_mass_add_rec.book_type_code;
284: