136: 'Beginning of procedure');
137: END IF;
138:
139:
140: insert into fa_xla_ext_lines_b_gt (
141: EVENT_ID ,
142: LINE_NUMBER ,
143: DISTRIBUTION_ID ,
144: DISTRIBUTION_TYPE_CODE ,
203: if (fa_xla_extract_util_pkg.G_alc_enabled) then
204:
205:
206:
207: insert into fa_xla_ext_lines_b_gt (
208: EVENT_ID ,
209: LINE_NUMBER ,
210: DISTRIBUTION_ID ,
211: DISTRIBUTION_TYPE_CODE ,
387:
388: l_last_book varchar2(15) := ' ';
389:
390: cursor c_def_deprn is
391: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
392: xl.rowid,
393: xb.book_type_code,
394: xl.distribution_id,
395: xl.EXPENSE_ACCOUNT_CCID,
399: xb.DEFERRED_DEPRN_EXPENSE_ACCT,
400: xb.DEFERRED_DEPRN_RESERVE_ACCT
401: from xla_events_gt xg,
402: fa_xla_ext_headers_b_gt xb,
403: fa_xla_ext_lines_b_gt xl,
404: fa_distribution_accounts da
405: where xg.event_class_code = 'DEFERRED DEPRECIATION'
406: and xb.event_id = xg.event_id
407: and xl.event_id = xg.event_id
491:
492: end loop;
493:
494: forall i in 1..l_def_deprn_tbl.count
495: update fa_xla_ext_lines_b_gt
496: set generated_ccid = l_generated_ccid(i),
497: generated_offset_ccid = l_generated_offset_ccid(i)
498: where rowid = l_rowid(i);
499: