eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_EVENTS

Line 49: l_event_source_info xla_events_pub_pkg.t_event_source_info;

45: p_bordero_id IN NUMBER,
46: p_payment_schedule_id IN NUMBER)
47: RETURN NUMBER IS
48:
49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;

Line 52: l_security_context xla_events_pub_pkg.t_security;

48:
49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;
54: l_category VARCHAR2(30) := NULL;
55: l_occurrence_id NUMBER;
56: l_event_number NUMBER;

Line 53: l_reference_info xla_events_pub_pkg.t_event_reference_info;

49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;
54: l_category VARCHAR2(30) := NULL;
55: l_occurrence_id NUMBER;
56: l_event_number NUMBER;
57:

Line 157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );

153: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.entity_type_code = '||l_event_source_info.entity_type_code);
154: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_1 = '||l_event_source_info.source_id_int_1);
155: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
156: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
158: END IF;
159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,

Line 159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

155: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
156: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
158: END IF;
159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,
162: p_event_date => p_event_date ,
163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,
162: p_event_date => p_event_date ,
163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
164: p_event_number => 2 ,
165: p_reference_info => l_reference_info ,
166: p_valuation_method => '' ,
167: p_security_context => l_security_context );

Line 170: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );

166: p_valuation_method => '' ,
167: p_security_context => l_security_context );
168:
169: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
170: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );
171: END IF;
172: ELSE
173:
174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );

199: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.entity_type_code = '||l_event_source_info.entity_type_code);
200: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_1 = '||l_event_source_info.source_id_int_1);
201: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
202: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
204: END IF;
205:
206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,

Line 206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

202: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
204: END IF;
205:
206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,
208: p_event_type_code => p_sla_event_type ,
209: p_event_date => p_event_date ,
210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,
208: p_event_type_code => p_sla_event_type ,
209: p_event_date => p_event_date ,
210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
211: p_event_number => 1 ,
212: p_reference_info => l_reference_info ,
213: p_valuation_method => '' ,
214: p_security_context => l_security_context );

Line 218: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );

214: p_security_context => l_security_context );
215: END IF;
216: --
217: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );
219: END IF;
220: return (l_event_id);
221: EXCEPTION
222: WHEN OTHERS THEN

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 1881: INTO xla_events

1877: END IF;
1878:
1879: INSERT ALL
1880: WHEN 1 = 1 THEN
1881: INTO xla_events
1882: (
1883: EVENT_ID,
1884: APPLICATION_ID,
1885: EVENT_TYPE_CODE,

Line 1906: xla_events_s.nextval ,

1902: TRANSACTION_DATE
1903: )
1904: VALUES
1905: (
1906: xla_events_s.nextval ,
1907: 222,
1908: EVENT_TYPE_CODE,
1909: EVENT_DATE,
1910: ENTITY_ID,

Line 1991: xla_events_s.nextval,

1987: BILL_TO_CUSTOMER_ID,
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

Line 2030: xla_events_s.currval ,

2026: xla_ae_headers_s.nextval,
2027: 222,
2028: SET_OF_BOOKS_ID,
2029: ENTITY_ID,
2030: xla_events_s.currval ,
2031: EVENT_TYPE_CODE,
2032: ACCOUNT_DATE,
2033: PERIOD_NAME,
2034: CATEGORY_NAME,

Line 2064: xla_events_s.nextval

2060: VALUES
2061: (
2062: RID,
2063: EVENT_TYPE_CODE,
2064: xla_events_s.nextval
2065: )
2066: SELECT
2067: SET_OF_BOOKS_ID,
2068: ENTITY_ID,

Line 2553: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys

2549: -- program of SLA is run for the non posted data
2550: -------------------------------------------------------------------
2551: /* UPDATE jl_br_ar_occurrence_docs_all oc
2552: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2553: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2554: WHERE sys.org_id = oc.org_id
2555: AND a.entity_id = c.entity_id
2556: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2557: AND c.APPLICATION_ID = 222

Line 2563: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1

2559: AND c.LEDGER_ID = sys.set_of_books_id
2560: AND c.SOURCE_ID_INT_1 = oc.document_id
2561: AND c.source_id_int_2 = oc.occurrence_id),NULL) ,
2562: cancel_event_id = decode(oc.occurrence_status, 'CANCELED',(SELECT a1.event_id
2563: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1
2564: WHERE sys1.org_id = oc.org_id
2565: AND a1.entity_id = c1.entity_id
2566: AND a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2567: AND c1.APPLICATION_ID = 222

Line 2587: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,

2583: END IF;
2584: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2585: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2586: (SELECT a1.event_id
2587: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2588: jl_br_ar_occurrence_docs_all oc1
2589: WHERE jlbr.occurrence_id = oc1.occurrence_id
2590: AND sys1.org_id = oc1.org_id
2591: AND a1.entity_id = c1.entity_id

Line 2601: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys

2597: AND c1.LEDGER_ID = sys1.set_of_books_id
2598: AND nvl(c1.SOURCE_ID_INT_1,-99) = oc1.document_id
2599: AND nvl(c1.source_id_int_2,-99) = oc1.occurrence_id),
2600: (SELECT a.event_id
2601: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2602: WHERE sys.org_id = jlbr.org_id
2603: AND a.entity_id = c.entity_id
2604: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2605: AND c.APPLICATION_ID = 222

Line 2734: SELECT /+INDEX (gt XLA_EVENTS_GT_U1)/

2730: ,LEVEL_FLAG
2731: ,PAIRED_CCID
2732: ,EVENT_CLASS_CODE
2733: )
2734: SELECT /*+INDEX (gt XLA_EVENTS_GT_U1)*/
2735: gt.event_id -- EVENT_ID
2736: ,trx.set_of_books_id -- LEDGER_ID
2737: ,trx.set_of_books_id -- SET_OF_BOOKS_ID
2738: ,trx.org_id -- ORG_ID

Line 2758: xla_events_gt gt,

2754: ,'H' -- LEVEL_FLAG
2755: ,ctlgd.code_combination_id -- PAIRED_CCID
2756: ,'INVOICE' -- EVENT_CLASS_CODE
2757: FROM ra_customer_trx_all trx,
2758: xla_events_gt gt,
2759: ra_cust_trx_line_gl_dist_all ctlgd,
2760: jl_br_ar_collection_docs_all cd,
2761: jl_br_ar_coll_occ_docs_h_v jlh
2762: WHERE gt.entity_code = 'JL_BR_AR_COLL_DOC_OCCS'