[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
1961: 222,
1962: TRX_DATE
1963: )
1964: WHEN (JLBR_TRANSFER_TO_GL_FLAG = 'Y') THEN
1965: INTO jl_remit1_gt
1966: (
1967: SET_OF_BOOKS_ID,
1968: ENTITY_ID,
1969: EVENT_TYPE_CODE,
2435: 'PAYMENT_AFTER_WRITE_OFF', 'Bank Receipts', 'AUTOMATIC_WRITE_OFF', 'Write-off', 'Bank Charges' )) ||
2436: ' - Invoice ' ||substr(TR2.trx_number,1,15)) DESCRIPTION,
2437: grm.multiplier MULTIPLIER
2438: FROM
2439: jl_remit1_gt TR2,
2440: jl_remit1_gt refTR2,
2441: jl_br_ar_distributns_all dist,
2442: gl_row_multipliers grm
2443: WHERE
2436: ' - Invoice ' ||substr(TR2.trx_number,1,15)) DESCRIPTION,
2437: grm.multiplier MULTIPLIER
2438: FROM
2439: jl_remit1_gt TR2,
2440: jl_remit1_gt refTR2,
2441: jl_br_ar_distributns_all dist,
2442: gl_row_multipliers grm
2443: WHERE
2444: dist.occurrence_id = TR2.occurrence_id