APPS.AP_SLA_PROCESSING_PKG dependencies on XLA_EVENTS

Line 535: FROM xla_events_gt XEG

531:
532: --bug9377273
533: CURSOR l_events_gt_cur IS
534: SELECT XEG.event_id
535: FROM xla_events_gt XEG
536: WHERE XEG.application_id = 200
537: AND XEG.entity_code = 'AP_PAYMENTS';
538:
539: --bug 10412623, removed code introduced in 9936620

Line 1758: ( select event_id from xla_events_gt);

1754: /* -- need to make the following autonmous commit
1755: UPDATE ap_payment_history_All APH
1756: SET POSTED_FLAG = 'N'
1757: WHERE APH.accounting_event_id in
1758: ( select event_id from xla_events_gt);
1759:
1760: UPDATE ap_invoice_distributions_All AID
1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in

Line 1763: ( select event_id from xla_events_gt);

1759:
1760: UPDATE ap_invoice_distributions_All AID
1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in
1763: ( select event_id from xla_events_gt);
1764:
1765: UPDATE ap_self_assessed_tax_dist_all AID
1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in

Line 1768: ( select event_id from xla_events_gt);

1764:
1765: UPDATE ap_self_assessed_tax_dist_all AID
1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in
1768: ( select event_id from xla_events_gt);
1769:
1770: UPDATE ap_invoice_payments_all AIP
1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in

Line 1773: ( select event_id from xla_events_gt);

1769:
1770: UPDATE ap_invoice_payments_all AIP
1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in
1773: ( select event_id from xla_events_gt);
1774:
1775: UPDATE ap_prepay_history_all APPH
1776: SET APPH.posted_flag = 'N'
1777: WHERE APPH.accounting_event_id in

Line 1778: ( select event_id from xla_events_gt);

1774:
1775: UPDATE ap_prepay_history_all APPH
1776: SET APPH.posted_flag = 'N'
1777: WHERE APPH.accounting_event_id in
1778: ( select event_id from xla_events_gt);
1779: -- */
1780:
1781:
1782: IF (SQLCODE <> -20001) THEN

Line 1845: FROM xla_events_gt XEG

1841: IS
1842:
1843: CURSOR l_events_cur IS
1844: SELECT XEG.event_id
1845: FROM xla_events_gt XEG
1846: WHERE XEG.application_id = 200;
1847:
1848: l_event_ids l_event_ids_typ;
1849: l_debug_info VARCHAR2(240);

Line 1899: -- in xla_events_gt

1895:
1896: -------------------------------------------------------------------------
1897: -- The call below will populate the prepayment distributions table
1898: -- and the payment distributions table for the events that are
1899: -- in xla_events_gt
1900: -------------------------------------------------------------------------
1901:
1902: AP_ACCOUNTING_PAY_PKG.Do_Pay_Accounting(l_curr_calling_sequence);
1903:

Line 2042: TABLE OF xla_events.event_status_code%TYPE

2038: TABLE OF NUMBER(15)
2039: INDEX BY PLS_INTEGER;
2040:
2041: TYPE l_event_status_typ IS
2042: TABLE OF xla_events.event_status_code%TYPE
2043: INDEX BY PLS_INTEGER;
2044:
2045: -----------------------------------------------------------------------------
2046: -- The XLA_EVENTS table contains all the events processed in this run

Line 2046: -- The XLA_EVENTS table contains all the events processed in this run

2042: TABLE OF xla_events.event_status_code%TYPE
2043: INDEX BY PLS_INTEGER;
2044:
2045: -----------------------------------------------------------------------------
2046: -- The XLA_EVENTS table contains all the events processed in this run
2047: -- of the accounting.
2048: -----------------------------------------------------------------------------
2049:
2050: CURSOR l_events_cur IS

Line 2052: FROM xla_events XEE

2048: -----------------------------------------------------------------------------
2049:
2050: CURSOR l_events_cur IS
2051: SELECT XEE.event_id, XEE.event_status_code
2052: FROM xla_events XEE
2053: WHERE XEE.application_id = 200
2054: AND XEE.request_id = p_report_request_id
2055: AND XEE.event_status_code <> 'P';
2056: