APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on XLA_EVENTS

Line 42: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;

38: l_procedure_name CONSTANT VARCHAR2(30) := 'DO_Rounding';
39: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
40:
41: -- bug 6600341
42: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;
43:
44:
45: BEGIN
46:

Line 191: -- Final Payment Rounding should not be done if there are XLA Events

187: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
188: END IF;
189:
190: -- Bug 6600341
191: -- Final Payment Rounding should not be done if there are XLA Events
192: -- still pending processing
193:
194: SELECT MAX(accounting_event_id)
195: INTO l_acctg_event_id

Line 312: FROM xla_events

308: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
309: AND AID.Org_ID = FSP.Org_ID
310: --Bug6511672
311: /*AND 'INVOICE CANCELLED' <> (SELECT event_type_code
312: FROM xla_events
313: WHERE event_id = AID.accounting_event_id)*/
314: --bug6614371
315: -- Bug 6712649. Added Credit and Debit memo cancelled
316: AND NOT EXISTS (SELECT 1

Line 317: FROM xla_events

313: WHERE event_id = AID.accounting_event_id)*/
314: --bug6614371
315: -- Bug 6712649. Added Credit and Debit memo cancelled
316: AND NOT EXISTS (SELECT 1
317: FROM xla_events
318: WHERE event_id = AID.accounting_event_id
319: AND event_type_code IN ('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
320: 'CREDIT MEMO CANCELLED',
321: 'DEBIT MEMO CANCELLED'))

Line 335: xla_events evnt,

331: -- under no liability posting method.
332: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
333: SELECT SUM(amount), count(1)
334: FROM ap_invoice_distributions_all aid,
335: xla_events evnt,
336: ap_system_parameters_all asp
337: WHERE aid.accounting_event_id = p_acct_event_id
338: AND aid.accounting_event_id = evnt.event_id
339: AND evnt.event_type_code='INVOICE ADJUSTED'