DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_REMIT3_GT

Line 1440: from jl_remit3_gt) where r=1;

1436: decode(event_type_code,'CANCEL_COLL_DOC',2,'CANCEL_FACT_DOC',2,1)) cancel_event_id,
1437: row_number()
1438: over (partition by row_id order by
1439: decode(event_type_code,'CANCEL_COLL_DOC',2,'CANCEL_FACT_DOC',2,1)) r
1440: from jl_remit3_gt) where r=1;
1441:
1442: BEGIN
1443: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1444: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_OCCURRENCES','Start procedure UPGRADE_OCCURRENCES');

Line 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');

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

Line 2054: INTO jl_remit3_gt

2050: 222,
2051: 'N'
2052: )
2053: WHEN 1 = 1 THEN
2054: INTO jl_remit3_gt
2055: (
2056: ROW_ID,
2057: EVENT_TYPE_CODE,
2058: EVENT_ID