[Home] [Help]
1909: -- are not added for Events, JE Headers, JE Lines and Dist Links
1910: -- because it is assumed that if the data in transaction entities is not
1911: -- present, then data in rest of the tables is also not present.
1912: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1913: 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');
1914: END IF;
1915:
1916: INSERT ALL
1917: WHEN 1 = 1 THEN
2025: BILL_TO_SITE_USE_ID,
2026: REVERSE_CHARGES_CRED_CCID,
2027: TRX_NUMBER,
2028: xla_events_s.nextval,
2029: xla_ae_headers_s.nextval
2030: )
2031: WHEN JLBR_TRANSFER_TO_GL_FLAG = 'Y' THEN
2032: INTO xla_ae_headers
2033: (
2028: xla_events_s.nextval,
2029: xla_ae_headers_s.nextval
2030: )
2031: WHEN JLBR_TRANSFER_TO_GL_FLAG = 'Y' THEN
2032: INTO xla_ae_headers
2033: (
2034: AE_HEADER_ID,
2035: APPLICATION_ID,
2036: LEDGER_ID,
2059: ZERO_AMOUNT_FLAG
2060: )
2061: VALUES
2062: (
2063: xla_ae_headers_s.nextval,
2064: 222,
2065: SET_OF_BOOKS_ID,
2066: ENTITY_ID,
2067: xla_events_s.currval ,
2977:
2978: l_rows_processed := 0;
2979:
2980: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2981: 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, ');
2982: END IF;
2983: --------------------------------------
2984: -- Create the Journal Entry Headers --
2985: --------------------------------------
2984: -- Create the Journal Entry Headers --
2985: --------------------------------------
2986: INSERT ALL
2987: WHEN 1 = 1 THEN
2988: INTO XLA_AE_HEADERS
2989: (
2990: AE_HEADER_ID,
2991: APPLICATION_ID,
2992: LEDGER_ID,
3058: PARENT_AE_LINE_NUM
3059: )
3060: VALUES
3061: (
3062: xla_ae_headers_s.nextval,
3063: 222,
3064: sob_id,
3065: entity_id,
3066: event_id,
3139: category_name AS category_name,
3140: gl_transfer_date AS gl_transfer_date
3141: FROM
3142: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,hdr)
3143: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(HDR,XLA_AE_HEADERS_U1) */
3144: hdr.ae_header_id ae_header_id,
3145: hdr.entity_id entity_id,
3146: hdr.event_id event_id,
3147: hdr.event_type_code event_type_code,
3161: gl_period_statuses gps,
3162: jl_br_ar_distributns_all dist,
3163: ar_mc_payment_schedules ps,
3164: xla_distribution_links dl,
3165: xla_ae_headers hdr
3166: --
3167: where od.rowid >= l_start_rowid
3168: and od.rowid <= l_end_rowid
3169: --
3201: and hdr.ae_header_id = dl.ae_header_id
3202: and hdr.application_id = 222
3203: and hdr.ledger_id = ct.set_of_books_id
3204: --
3205: and NOT EXISTS(select 'Y' from xla_ae_headers hdr1
3206: where hdr1.application_id = 222
3207: and hdr1.ledger_id = mcod.set_of_books_id
3208: and hdr1.entity_id = hdr.entity_id
3209: and hdr1.event_id = hdr.event_id
3473: RANK() OVER (PARTITION BY event_id, ref_header_id,sob_id
3474: ORDER BY distribution_id, amount_dr) AS line_num
3475: FROM
3476: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,lin,hdr,hdr1,lgr1)
3477: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */
3478: hdr1.ae_header_id header_id,
3479: ref.ae_header_id ref_header_id,
3480: ref.event_id ref_event_id,
3481: dist.distribution_id distribution_id,
3515: jl_br_ar_distributns_all dist,
3516: ar_mc_payment_schedules ps,
3517: xla_distribution_links dl,
3518: xla_ae_lines lin,
3519: xla_ae_headers hdr,
3520: xla_ae_headers hdr1,
3521: xla_ae_headers ref,
3522: xla_ae_headers ref1,
3523: gl_ledgers lgr1
3516: ar_mc_payment_schedules ps,
3517: xla_distribution_links dl,
3518: xla_ae_lines lin,
3519: xla_ae_headers hdr,
3520: xla_ae_headers hdr1,
3521: xla_ae_headers ref,
3522: xla_ae_headers ref1,
3523: gl_ledgers lgr1
3524: --
3517: xla_distribution_links dl,
3518: xla_ae_lines lin,
3519: xla_ae_headers hdr,
3520: xla_ae_headers hdr1,
3521: xla_ae_headers ref,
3522: xla_ae_headers ref1,
3523: gl_ledgers lgr1
3524: --
3525: where od.rowid >= l_start_rowid
3518: xla_ae_lines lin,
3519: xla_ae_headers hdr,
3520: xla_ae_headers hdr1,
3521: xla_ae_headers ref,
3522: xla_ae_headers ref1,
3523: gl_ledgers lgr1
3524: --
3525: where od.rowid >= l_start_rowid
3526: and od.rowid <= l_end_rowid
3578: and ref.event_type_code = ref1.event_type_code
3579: --
3580: and ref1.ae_header_id = dl.ref_ae_header_id
3581: --
3582: and NOT EXISTS(select 'Y' from xla_distribution_links dl2, xla_ae_headers hdr2
3583: where dl2.application_id = 222
3584: and dl2.source_distribution_id_num_1 = dist.distribution_id
3585: and dl2.source_distribution_type = 'JLBR_AR_DIST'
3586: and hdr2.ae_header_id = dl2.ae_header_id