APPS.ARP_ACCT_EVENT_PKG dependencies on XLA_EVENTS

Line 169: xla_events ev,

165: FROM ra_customer_trx trx,
166: ra_cust_trx_line_gl_dist gld,
167: ra_cust_trx_types ctt,
168: xla_transaction_entities_upg xet,
169: xla_events ev,
170: xla_events distev
171: WHERE trx.customer_trx_id = p_source_id_int_1
172: AND trx.customer_trx_id = gld.customer_trx_id
173: AND gld.account_class = 'REC'

Line 170: xla_events distev

166: ra_cust_trx_line_gl_dist gld,
167: ra_cust_trx_types ctt,
168: xla_transaction_entities_upg xet,
169: xla_events ev,
170: xla_events distev
171: WHERE trx.customer_trx_id = p_source_id_int_1
172: AND trx.customer_trx_id = gld.customer_trx_id
173: AND gld.account_class = 'REC'
174: AND gld.posting_control_id = -3

Line 192: l_event_source_info xla_events_pub_pkg.t_event_source_info;

188: l_rec c%ROWTYPE;
189: l_upg_trx_date DATE := FND_API.G_MISS_DATE;
190: l_upg_gl_date DATE := FND_API.G_MISS_DATE;
191:
192: l_event_source_info xla_events_pub_pkg.t_event_source_info;
193: l_event_id NUMBER;
194: l_valuation_method VARCHAR2(10);
195: l_event_info_t xla_events_pub_pkg.t_array_event_info;
196: l_security xla_events_pub_pkg.t_security;

Line 195: l_event_info_t xla_events_pub_pkg.t_array_event_info;

191:
192: l_event_source_info xla_events_pub_pkg.t_event_source_info;
193: l_event_id NUMBER;
194: l_valuation_method VARCHAR2(10);
195: l_event_info_t xla_events_pub_pkg.t_array_event_info;
196: l_security xla_events_pub_pkg.t_security;
197:
198: not_suffisant_info EXCEPTION;
199: done EXCEPTION;

Line 196: l_security xla_events_pub_pkg.t_security;

192: l_event_source_info xla_events_pub_pkg.t_event_source_info;
193: l_event_id NUMBER;
194: l_valuation_method VARCHAR2(10);
195: l_event_info_t xla_events_pub_pkg.t_array_event_info;
196: l_security xla_events_pub_pkg.t_security;
197:
198: not_suffisant_info EXCEPTION;
199: done EXCEPTION;
200: not_supported_action EXCEPTION;

Line 315: xla_events_pub_pkg.update_event

311:
312:
313: IF l_upg_trx_date <> FND_API.G_MISS_DATE OR l_upg_gl_date <> FND_API.G_MISS_DATE THEN
314: arp_standard.debug(' call update event with at transaction level');
315: xla_events_pub_pkg.update_event
316: (p_event_source_info => l_event_source_info,
317: p_event_id => l_event_id,
318: p_event_date => p_event_date,
319: p_valuation_method => p_valuation_method,

Line 477: FROM xla_events e,

473: t.source_id_int_1,
474: t.entity_code,
475: e.event_id,
476: 'XLA'
477: FROM xla_events e,
478: xla_transaction_entities_upg t
479: WHERE t.application_id = 222
480: AND t.ledger_id = arp_global.set_of_books_id
481: AND t.entity_code = p_entity_code

Line 614: -- 3 Get XLA events

610: x_upgrade_status := 'Y';
611: RAISE end_execution;
612: END IF;
613:
614: -- 3 Get XLA events
615: get_xla_event_info
616: (p_entity_code => p_entity_code,
617: p_source_int_id => p_source_int_id);
618:

Line 1449: INSERT INTO xla_events_gt

1445: IF p_original_third_party_id <> p_new_third_party_id OR
1446: p_new_third_party_id IS NULL
1447: THEN
1448:
1449: INSERT INTO xla_events_gt
1450: (APPLICATION_ID
1451: ,LEDGER_ID
1452: ,ENTITY_CODE
1453: ,SOURCE_ID_INT_1

Line 1537: FROM xla_events e,

1533: x_msg_data OUT NOCOPY VARCHAR2)
1534: IS
1535: CURSOR c_verif_date(p_entity_id IN NUMBER) IS
1536: SELECT e.event_date
1537: FROM xla_events e,
1538: xla_transaction_entities_upg t
1539: WHERE e.application_id = 222
1540: AND e.entity_id = p_entity_id
1541: AND t.application_id = 222