APPS.ARP_ACCT_EVENT_PKG dependencies on XLA_EVENTS

Line 168: xla_events ev,

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

Line 169: xla_events distev

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

Line 191: l_event_source_info xla_events_pub_pkg.t_event_source_info;

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

Line 194: l_event_info_t xla_events_pub_pkg.t_array_event_info;

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

Line 195: l_security xla_events_pub_pkg.t_security;

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

Line 314: xla_events_pub_pkg.update_event

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

Line 475: FROM xla_events e,

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

Line 612: -- 3 Get XLA events

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

Line 1447: INSERT INTO xla_events_gt

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

Line 1535: FROM xla_events e,

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