APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_BOOK_CONTROLS

Line 261: FROM GL_Sets_Of_Books GL_sob, FA_Book_Controls FA_BC

257: l_debug_str := 'Getting SOB id and COA';
258: --code to get asset key using fedder system
259: SELECT Gl_sob.Set_Of_Books_id, Chart_Of_Accounts_ID
260: INTO l_sob_id, l_coa
261: FROM GL_Sets_Of_Books GL_sob, FA_Book_Controls FA_BC
262: WHERE GL_sob.Set_Of_Books_ID = FA_BC.Set_Of_Books_ID
263: AND Book_Type_Code = px_mass_add_rec.book_type_code;
264:
265: if (upper(px_mass_add_rec.FEEDER_SYSTEM_NAME) = 'ORACLE PAYABLES') then

Line 530: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;

526: l_minor_ccid number;
527: l_clearing_acct_ccid number;
528: l_category_id number;
529: l_gl_ccid_enabled_flag varchar2(1);
530: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
531: l_bal_seg_num NUMBER;
532: l_lookup_code varchar2(30);
533: l_debug_str varchar2(1000);
534: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

Line 545: From fa_book_controls bc, gl_sets_of_books sob

541:
542: begin
543: Select sob.chart_of_accounts_id
544: into h_chart_of_accounts_id
545: From fa_book_controls bc, gl_sets_of_books sob
546: Where sob.set_of_books_id = bc.set_of_books_id
547: And bc.book_type_code = px_mass_add_rec.book_type_code;
548:
549: if (px_mass_add_rec.PAYABLES_CODE_COMBINATION_ID is not null) then

Line 1178: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;

1174: l_segment varchar30_tbl;
1175: l_exp_acct_index number;
1176: l_exp_acct_ccid number;
1177: l_gl_ccid_enabled_flag varchar2(1);
1178: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
1179:
1180: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
1181: h_flex_segment_delimiter varchar2(5);
1182: h_flex_segment_number number;

Line 1214: from fa_book_controls

1210: begin
1211:
1212: select FLEXBUILDER_DEFAULTS_CCID
1213: into l_default_ccid
1214: from fa_book_controls
1215: where book_type_code = px_mass_add_rec.book_type_code;
1216:
1217: SELECT deprn_expense_account_ccid, asset_cost_account_ccid
1218: INTO l_DEPRN_EXPENSE_ACCT_CCID, h_cost_acct_ccid

Line 1225: From fa_book_controls bc, gl_sets_of_books sob

1221: AND category_id = px_mass_add_rec.asset_category_id;
1222:
1223: Select sob.chart_of_accounts_id
1224: into h_chart_of_accounts_id
1225: From fa_book_controls bc, gl_sets_of_books sob
1226: Where sob.set_of_books_id = bc.set_of_books_id
1227: And bc.book_type_code = px_mass_add_rec.book_type_code;
1228: l_TRANSACTION_COA_ID := h_chart_of_accounts_id;
1229:

Line 1316: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;

1312: l_seg_num num_tbl;
1313: l_location_index number;
1314: l_location_seg number;
1315: l_gl_ccid_enabled_flag varchar2(1);
1316: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
1317: l_location_id number;
1318: l_debug_str varchar2(1000);
1319: l_loc_seg_name varchar2(30) := null;
1320: l_calling_fn varchar2(40) := 'prepare_location_id';