DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_AE_LINES

Line 2167: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Creating journal entries by inserting into xla_ae_lines, xla_distribution_links');

2163: -------------------------------------------------------------------
2164: -- Create the Journal Entry Lines
2165: -------------------------------------------------------------------
2166: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2167: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Creating journal entries by inserting into xla_ae_lines, xla_distribution_links');
2168: END IF;
2169:
2170: INSERT ALL
2171: WHEN 1 = 1 THEN

Line 2172: INTO xla_ae_lines

2168: END IF;
2169:
2170: INSERT ALL
2171: WHEN 1 = 1 THEN
2172: INTO xla_ae_lines
2173: (
2174: AE_HEADER_ID,
2175: AE_LINE_NUM,
2176: DISPLAYED_LINE_NUMBER,

Line 3189: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_MC_OCCURRENCES','Create the Journal Entry Lines and Distribution Links, insert into XLA_AE_LINES');

3185: -----------------------------------------------------------
3186: -- Create the Journal Entry Lines and Distribution Links --
3187: -----------------------------------------------------------
3188: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3189: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_MC_OCCURRENCES','Create the Journal Entry Lines and Distribution Links, insert into XLA_AE_LINES');
3190: END IF;
3191: INSERT ALL
3192: WHEN 1 = 1 THEN
3193: INTO XLA_AE_LINES

Line 3193: INTO XLA_AE_LINES

3189: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_MC_OCCURRENCES','Create the Journal Entry Lines and Distribution Links, insert into XLA_AE_LINES');
3190: END IF;
3191: INSERT ALL
3192: WHEN 1 = 1 THEN
3193: INTO XLA_AE_LINES
3194: (
3195: AE_HEADER_ID,
3196: AE_LINE_NUM,
3197: DISPLAYED_LINE_NUMBER,

Line 3439: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */

3435: RANK() OVER (PARTITION BY event_id, ref_header_id,sob_id
3436: ORDER BY distribution_id, amount_dr) AS line_num
3437: FROM
3438: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,lin,hdr,hdr1,lgr1)
3439: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */
3440: hdr1.ae_header_id header_id,
3441: ref.ae_header_id ref_header_id,
3442: ref.event_id ref_event_id,
3443: dist.distribution_id distribution_id,

Line 3480: xla_ae_lines lin,

3476: gl_period_statuses gps,
3477: jl_br_ar_distributns_all dist,
3478: ar_mc_payment_schedules ps,
3479: xla_distribution_links dl,
3480: xla_ae_lines lin,
3481: xla_ae_headers hdr,
3482: xla_ae_headers hdr1,
3483: xla_ae_headers ref,
3484: xla_ae_headers ref1,