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.AP_ACCOUNTING_PAY_PKG dependencies on XLA_EVENTS

Line 37: CURSOR xla_events_cur IS

33: -- bug11772495, removed budgetary control flag from the cursor
34: -- bug10412623, added entity_id, ledger_id to the cursor
35: -- bug12918263, removed entity_id, ledger_id to the cursor
36:
37: CURSOR xla_events_cur IS
38: SELECT Event_ID,
39: Event_Type_Code,
40: Event_Date,
41: Event_Number,

Line 45: FROM XLA_Events_GT

41: Event_Number,
42: Event_Status_Code,
43: Entity_Code,
44: Source_ID_Int_1
45: FROM XLA_Events_GT
46: WHERE (Entity_Code = 'AP_PAYMENTS'
47: OR Event_Type_Code IN ('PREPAYMENT APPLIED',
48: 'PREPAYMENT UNAPPLIED',
49: 'PREPAYMENT APPLICATION ADJ'))

Line 100: OPEN xla_events_cur;

96: l_log_msg := 'Procedure AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events executed';
97: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
98: END IF;
99:
100: OPEN xla_events_cur;
101: LOOP
102: BEGIN
103: FETCH xla_events_cur INTO l_xla_event_rec;
104: EXIT WHEN xla_events_cur%NOTFOUND OR

Line 103: FETCH xla_events_cur INTO l_xla_event_rec;

99:
100: OPEN xla_events_cur;
101: LOOP
102: BEGIN
103: FETCH xla_events_cur INTO l_xla_event_rec;
104: EXIT WHEN xla_events_cur%NOTFOUND OR
105: xla_events_cur%NOTFOUND IS NULL;
106:
107:

Line 104: EXIT WHEN xla_events_cur%NOTFOUND OR

100: OPEN xla_events_cur;
101: LOOP
102: BEGIN
103: FETCH xla_events_cur INTO l_xla_event_rec;
104: EXIT WHEN xla_events_cur%NOTFOUND OR
105: xla_events_cur%NOTFOUND IS NULL;
106:
107:
108: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 105: xla_events_cur%NOTFOUND IS NULL;

101: LOOP
102: BEGIN
103: FETCH xla_events_cur INTO l_xla_event_rec;
104: EXIT WHEN xla_events_cur%NOTFOUND OR
105: xla_events_cur%NOTFOUND IS NULL;
106:
107:
108: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
109: l_log_msg := 'CUR: xla_events_cur: entity_code = '|| l_xla_event_rec.entity_code

Line 109: l_log_msg := 'CUR: xla_events_cur: entity_code = '|| l_xla_event_rec.entity_code

105: xla_events_cur%NOTFOUND IS NULL;
106:
107:
108: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
109: l_log_msg := 'CUR: xla_events_cur: entity_code = '|| l_xla_event_rec.entity_code
110: || ' document_id = ' || l_xla_event_rec.source_id_int_1;
111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
112: END IF;
113:

Line 249: FROM xla_events xe

245: --
246: BEGIN
247: SELECT nvl(xe.budgetary_control_flag, 'N') --BUG12594203
248: INTO l_budgetary_control_flag
249: FROM xla_events xe
250: WHERE xe.application_id = 200
251: AND xe.event_id = l_xla_event_rec.event_id;
252:
253: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 320: FROM xla_events_gt xeg

316: SELECT DISTINCT xeg.entity_id
317: , xeg.ledger_id
318: INTO l_entity_id
319: , l_ledger_id
320: FROM xla_events_gt xeg
321: WHERE xeg.event_id = l_xla_event_rec.event_id
322: AND xeg.application_id = 200;
323:
324: XLA_ACCOUNTING_ERR_PKG.build_message('SQLAP',

Line 343: CLOSE xla_events_cur;

339: END IF;
340: END IF;
341: END; --end bug 9936620
342: END LOOP;
343: CLOSE xla_events_cur;
344:
345: -- Logging Infra: Procedure level
346: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
347: l_log_msg := 'End of procedure '|| l_procedure_name;

Line 400: FROM XLA_Events_GT

396: -- Bug 5098657. Added the where condition for both the delete statements
397: DELETE FROM AP_Payment_Hist_Dists
398: WHERE Accounting_Event_ID IN
399: (SELECT Event_ID
400: FROM XLA_Events_GT
401: WHERE Entity_Code = 'AP_PAYMENTS');
402:
403: DELETE FROM AP_Prepay_App_Dists
404: WHERE Accounting_Event_ID IN

Line 406: FROM XLA_Events_GT

402:
403: DELETE FROM AP_Prepay_App_Dists
404: WHERE Accounting_Event_ID IN
405: (SELECT Event_ID
406: FROM XLA_Events_GT
407: WHERE Event_Type_Code IN ('PREPAYMENT APPLICATION ADJ'));
408:
409:
410: EXCEPTION

Line 1588: xla_events_gt xe,

1584: CURSOR Aprvd_UnPrtd_His_Inv IS
1585: SELECT ai.invoice_id
1586: FROM ap_invoice_distributions_all aid,
1587: ap_invoices_all ai,
1588: xla_events_gt xe,
1589: xla_events xle,
1590: financials_system_params_all fsp
1591: WHERE xe.event_type_code IN('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
1592: AND xe.event_status_code NOT IN('N', 'P')

Line 1589: xla_events xle,

1585: SELECT ai.invoice_id
1586: FROM ap_invoice_distributions_all aid,
1587: ap_invoices_all ai,
1588: xla_events_gt xe,
1589: xla_events xle,
1590: financials_system_params_all fsp
1591: WHERE xe.event_type_code IN('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
1592: AND xe.event_status_code NOT IN('N', 'P')
1593: AND aid.accounting_event_id = xe.event_id

Line 1792: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;

1788:
1789: l_final_event BOOLEAN := FALSE;
1790: l_unacctg_events_exist VARCHAR2(1) := 'Y';
1791: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
1792: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;
1793:
1794: l_curr_calling_sequence VARCHAR2(2000);
1795:
1796: l_procedure_name CONSTANT VARCHAR2(30) := 'is_final_event';

Line 1821: , xla_events xe

1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip
1819: , xla_event_types_b xet
1820: , xla_event_types_b xet_rel
1821: , xla_events xe
1822: WHERE aip.invoice_id = p_inv_rec.invoice_id
1823: AND aph.check_id = aip.check_id
1824: AND xe.event_id = aph.accounting_event_id
1825: AND xet.event_type_code = p_xla_event_rec.event_type_code

Line 1895: , xla_events xe

1891: FROM ap_payment_history_all aph
1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt
1897: WHERE aip.invoice_id = p_inv_rec.invoice_id
1898: AND aph.check_id = aip.check_id
1899: AND xe.event_id = aph.accounting_event_id

Line 1896: , xla_events_gt xgt

1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt
1897: WHERE aip.invoice_id = p_inv_rec.invoice_id
1898: AND aph.check_id = aip.check_id
1899: AND xe.event_id = aph.accounting_event_id
1900: AND xet.event_type_code = p_xla_event_rec.event_type_code

Line 1919: xla_events_gt xgt

1915: UNION
1916: -- prepay adjustment
1917: SELECT MAX(apph.accounting_event_id) accounting_event_id
1918: FROM ap_prepay_history_all apph,
1919: xla_events_gt xgt
1920: WHERE xgt.event_id = apph.accounting_event_id
1921: AND apph.posted_flag = 'S'
1922: AND apph.invoice_id = p_inv_rec.invoice_id
1923: AND apph.invoice_adjustment_event_id IS NOT NULL