[Home] [Help]
1872: -- are not added for Events, JE Headers, JE Lines and Dist Links
1873: -- because it is assumed that if the data in transaction entities is not
1874: -- present, then data in rest of the tables is also not present.
1875: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1876: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the Journal Entry Events and Headers. Inserting into xla_events, jl_remit1_gt,xla_ae_headers,jl_remit3_gt');
1877: END IF;
1878:
1879: INSERT ALL
1880: WHEN 1 = 1 THEN
1988: BILL_TO_SITE_USE_ID,
1989: REVERSE_CHARGES_CRED_CCID,
1990: TRX_NUMBER,
1991: xla_events_s.nextval,
1992: xla_ae_headers_s.nextval
1993: )
1994: WHEN JLBR_TRANSFER_TO_GL_FLAG = 'Y' THEN
1995: INTO xla_ae_headers
1996: (
1991: xla_events_s.nextval,
1992: xla_ae_headers_s.nextval
1993: )
1994: WHEN JLBR_TRANSFER_TO_GL_FLAG = 'Y' THEN
1995: INTO xla_ae_headers
1996: (
1997: AE_HEADER_ID,
1998: APPLICATION_ID,
1999: LEDGER_ID,
2022: ZERO_AMOUNT_FLAG
2023: )
2024: VALUES
2025: (
2026: xla_ae_headers_s.nextval,
2027: 222,
2028: SET_OF_BOOKS_ID,
2029: ENTITY_ID,
2030: xla_events_s.currval ,
2939:
2940: l_rows_processed := 0;
2941:
2942: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2943: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_MC_OCCURRENCES','Create the Journal Entry Headers, insert into XLA_AE_HEADERS, ');
2944: END IF;
2945: --------------------------------------
2946: -- Create the Journal Entry Headers --
2947: --------------------------------------
2946: -- Create the Journal Entry Headers --
2947: --------------------------------------
2948: INSERT ALL
2949: WHEN 1 = 1 THEN
2950: INTO XLA_AE_HEADERS
2951: (
2952: AE_HEADER_ID,
2953: APPLICATION_ID,
2954: LEDGER_ID,
3020: PARENT_AE_LINE_NUM
3021: )
3022: VALUES
3023: (
3024: xla_ae_headers_s.nextval,
3025: 222,
3026: sob_id,
3027: entity_id,
3028: event_id,
3101: category_name AS category_name,
3102: gl_transfer_date AS gl_transfer_date
3103: FROM
3104: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,hdr)
3105: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(HDR,XLA_AE_HEADERS_U1) */
3106: hdr.ae_header_id ae_header_id,
3107: hdr.entity_id entity_id,
3108: hdr.event_id event_id,
3109: hdr.event_type_code event_type_code,
3123: gl_period_statuses gps,
3124: jl_br_ar_distributns_all dist,
3125: ar_mc_payment_schedules ps,
3126: xla_distribution_links dl,
3127: xla_ae_headers hdr
3128: --
3129: where od.rowid >= l_start_rowid
3130: and od.rowid <= l_end_rowid
3131: --
3163: and hdr.ae_header_id = dl.ae_header_id
3164: and hdr.application_id = 222
3165: and hdr.ledger_id = ct.set_of_books_id
3166: --
3167: and NOT EXISTS(select 'Y' from xla_ae_headers hdr1
3168: where hdr1.application_id = 222
3169: and hdr1.ledger_id = mcod.set_of_books_id
3170: and hdr1.entity_id = hdr.entity_id
3171: and hdr1.event_id = hdr.event_id
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,
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,
3485: gl_ledgers lgr1
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,
3485: gl_ledgers lgr1
3486: --
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,
3485: gl_ledgers lgr1
3486: --
3487: where od.rowid >= l_start_rowid
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,
3485: gl_ledgers lgr1
3486: --
3487: where od.rowid >= l_start_rowid
3488: and od.rowid <= l_end_rowid
3540: and ref.event_type_code = ref1.event_type_code
3541: --
3542: and ref1.ae_header_id = dl.ref_ae_header_id
3543: --
3544: and NOT EXISTS(select 'Y' from xla_distribution_links dl2, xla_ae_headers hdr2
3545: where dl2.application_id = 222
3546: and dl2.source_distribution_id_num_1 = dist.distribution_id
3547: and dl2.source_distribution_type = 'JLBR_AR_DIST'
3548: and hdr2.ae_header_id = dl2.ae_header_id