50: p_log_level_rec => p_log_level_rec);
51: end if;
52: Select sob.chart_of_accounts_id
53: into h_chart_of_accounts_id
54: From fa_book_controls bc, gl_sets_of_books sob
55: Where sob.set_of_books_id = bc.set_of_books_id
56: And bc.book_type_code = p_book_type_code;
57:
58: l_err_stage := 'Get Account Qualifier Segment Number';
184: l_book_type_code varchar2(30);
185: cost_center_seg varchar(50);
186: cost_center_seg_index number;
187: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
188: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
189: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
190: l_gl_ccid_enabled_flag varchar2(1);
191: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
192: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
277: --do transfer
278:
279: select ACCOUNTING_FLEX_STRUCTURE
280: into l_ACCOUNTING_FLEX_STRUCTURE
281: from fa_book_controls
282: where book_type_code = l_book_type_code;
283:
284: if not
285: (FND_FLEX_APIS.get_segment_column(x_application_id => 101,
473: l_book_type_code varchar2(30);
474: cost_center_seg varchar(50);
475: cost_center_seg_index number;
476: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
477: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
478: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
479: l_gl_ccid_enabled_flag varchar2(1);
480: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
481: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
564: --do transfer
565:
566: select ACCOUNTING_FLEX_STRUCTURE
567: into l_ACCOUNTING_FLEX_STRUCTURE
568: from fa_book_controls
569: where book_type_code = l_book_type_code;
570:
571: if not
572: (FND_FLEX_APIS.get_segment_column(x_application_id => 101,