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 167: 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 ' );

163: 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);
164: 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);
165: 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);
166: 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);
167: 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 ' );
168: END IF;
169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,

Line 169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

165: 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);
166: 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);
167: 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 ' );
168: END IF;
169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,
172: p_event_date => p_event_date ,
173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,
172: p_event_date => p_event_date ,
173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
174: p_event_number => 2 ,
175: p_reference_info => l_reference_info ,
176: p_valuation_method => '' ,
177: p_security_context => l_security_context );

Line 180: 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 );

176: p_valuation_method => '' ,
177: p_security_context => l_security_context );
178:
179: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
180: 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 );
181: END IF;
182: /* ############### ELSE PART ############################# */
183: ELSE
184:

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

210: 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);
211: 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);
212: 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);
213: 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);
214: 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 ' );
215: END IF;
216:
217:
218:

Line 219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

215: END IF;
216:
217:
218:
219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
220: p_event_source_info => l_event_source_info ,
221: p_event_type_code => p_sla_event_type ,
222: p_event_date => p_event_date ,
223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
220: p_event_source_info => l_event_source_info ,
221: p_event_type_code => p_sla_event_type ,
222: p_event_date => p_event_date ,
223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
224: p_event_number => 1 ,
225: p_reference_info => l_reference_info ,
226: p_valuation_method => '' ,
227: p_security_context => l_security_context );

Line 233: 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 );

229:
230: /* ############### END IF ############################# */
231: --
232: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
233: 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 );
234: END IF;
235: return (l_event_id);
236: EXCEPTION
237: WHEN OTHERS THEN

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

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

Line 1918: INTO xla_events

1914: END IF;
1915:
1916: INSERT ALL
1917: WHEN 1 = 1 THEN
1918: INTO xla_events
1919: (
1920: EVENT_ID,
1921: APPLICATION_ID,
1922: EVENT_TYPE_CODE,

Line 1943: xla_events_s.nextval ,

1939: TRANSACTION_DATE
1940: )
1941: VALUES
1942: (
1943: xla_events_s.nextval ,
1944: 222,
1945: EVENT_TYPE_CODE,
1946: EVENT_DATE,
1947: ENTITY_ID,

Line 2028: xla_events_s.nextval,

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

Line 2067: xla_events_s.currval ,

2063: xla_ae_headers_s.nextval,
2064: 222,
2065: SET_OF_BOOKS_ID,
2066: ENTITY_ID,
2067: xla_events_s.currval ,
2068: EVENT_TYPE_CODE,
2069: ACCOUNT_DATE,
2070: PERIOD_NAME,
2071: CATEGORY_NAME,

Line 2101: xla_events_s.nextval

2097: VALUES
2098: (
2099: RID,
2100: EVENT_TYPE_CODE,
2101: xla_events_s.nextval
2102: )
2103: SELECT
2104: SET_OF_BOOKS_ID,
2105: ENTITY_ID,

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

2586: -- program of SLA is run for the non posted data
2587: -------------------------------------------------------------------
2588: /* UPDATE jl_br_ar_occurrence_docs_all oc
2589: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2590: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2591: WHERE sys.org_id = oc.org_id
2592: AND a.entity_id = c.entity_id
2593: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2594: AND c.APPLICATION_ID = 222

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

2596: AND c.LEDGER_ID = sys.set_of_books_id
2597: AND c.SOURCE_ID_INT_1 = oc.document_id
2598: AND c.source_id_int_2 = oc.occurrence_id),NULL) ,
2599: cancel_event_id = decode(oc.occurrence_status, 'CANCELED',(SELECT a1.event_id
2600: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1
2601: WHERE sys1.org_id = oc.org_id
2602: AND a1.entity_id = c1.entity_id
2603: AND a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2604: AND c1.APPLICATION_ID = 222

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

2620: END IF;
2621: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2622: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2623: (SELECT a1.event_id
2624: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2625: jl_br_ar_occurrence_docs_all oc1
2626: WHERE jlbr.occurrence_id = oc1.occurrence_id
2627: AND sys1.org_id = oc1.org_id
2628: AND a1.entity_id = c1.entity_id

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

2634: AND c1.LEDGER_ID = sys1.set_of_books_id
2635: AND nvl(c1.SOURCE_ID_INT_1,-99) = oc1.document_id
2636: AND nvl(c1.source_id_int_2,-99) = oc1.occurrence_id),
2637: (SELECT a.event_id
2638: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2639: WHERE sys.org_id = jlbr.org_id
2640: AND a.entity_id = c.entity_id
2641: AND a.event_type_code NOT IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')
2642: AND c.APPLICATION_ID = 222

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

2767: ,LEVEL_FLAG
2768: ,PAIRED_CCID
2769: ,EVENT_CLASS_CODE
2770: )
2771: SELECT /*+INDEX (gt XLA_EVENTS_GT_U1)*/
2772: gt.event_id -- EVENT_ID
2773: ,trx.set_of_books_id -- LEDGER_ID
2774: ,trx.set_of_books_id -- SET_OF_BOOKS_ID
2775: ,trx.org_id -- ORG_ID

Line 2795: xla_events_gt gt,

2791: ,'H' -- LEVEL_FLAG
2792: ,ctlgd.code_combination_id -- PAIRED_CCID
2793: ,'INVOICE' -- EVENT_CLASS_CODE
2794: FROM ra_customer_trx_all trx,
2795: xla_events_gt gt,
2796: ra_cust_trx_line_gl_dist_all ctlgd,
2797: jl_br_ar_collection_docs_all cd,
2798: jl_br_ar_coll_occ_docs_h_v jlh
2799: WHERE gt.entity_code = 'JL_BR_AR_COLL_DOC_OCCS'