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_EVENTS_PKG dependencies on AP_INVOICES_ALL

Line 906: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

902: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
903: l_prepay_app_event_id NUMBER;
904: l_inv_adj_event_id NUMBER;
905: l_curr_calling_sequence VARCHAR2(2000);
906: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
907:
908: -- Logging:
909: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_INVOICE_EVENTS';
910: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1239: FROM ap_invoices_all AI

1235: 'DEBIT', DEBIT_MEMOS_CLASS,
1236: 'PREPAYMENT', PREPAYMENTS_CLASS,
1237: INVOICES_CLASS) event_class
1238: INTO l_event_type, l_event_class
1239: FROM ap_invoices_all AI
1240: WHERE AI.invoice_id = p_invoice_id;
1241:
1242: l_log_msg := 'Before calling procedure create_invoice_event';
1243: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1277: FROM ap_invoices_all AI

1273: 'DEBIT', DEBIT_MEMOS_CLASS,
1274: 'PREPAYMENT', PREPAYMENTS_CLASS,
1275: INVOICES_CLASS) event_class
1276: INTO l_event_type, l_event_class
1277: FROM ap_invoices_all AI
1278: WHERE AI.invoice_id = p_invoice_id;
1279:
1280: BEGIN
1281: SELECT MAX(accounting_event_id)

Line 1576: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

1572: l_ledger_id NUMBER(15);
1573: l_org_id NUMBER(15);
1574: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
1575: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1576: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
1577:
1578: l_curr_calling_sequence VARCHAR2(2000);
1579:
1580: -- Logging:

Line 2018: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

2014: l_Event_count NUMBER;
2015: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
2016: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
2017: l_event_info XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
2018: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
2019:
2020: l_curr_calling_sequence VARCHAR2(2000);
2021:
2022: -- Logging:

Line 2574: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

2570: l_org_id NUMBER(15);
2571: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
2572: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
2573: l_event_info XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
2574: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
2575:
2576: l_curr_calling_sequence VARCHAR2(2000);
2577:
2578: -- Logging:

Line 3733: ap_invoices_all AI

3729: WHERE D.accounting_event_id IS NULL
3730: AND D.invoice_id IN
3731: (SELECT AI.invoice_id
3732: FROM ap_invoice_payments_all AIP2,
3733: ap_invoices_all AI
3734: WHERE AI.invoice_id = AIP2.invoice_id
3735: AND AIP2.check_id = p_check_id
3736: AND AIP2.accounting_event_id = p_event_id
3737: AND AI.invoice_type_lookup_code = 'INTEREST');

Line 3881: ap_invoices_all AI

3877: WHERE AID.accounting_event_id IS NULL
3878: AND AID.invoice_id IN
3879: ( SELECT AI.invoice_id
3880: FROM ap_invoice_payments_all AIP,
3881: ap_invoices_all AI
3882: WHERE AIP.invoice_id = AI.invoice_id
3883: AND AIP.accounting_event_id = l_accounting_event_ids(i)
3884: AND AIP.check_id = l_check_ids(i)
3885: AND AI.invoice_type_lookup_code = 'INTEREST');

Line 5205: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

5201: l_org_id NUMBER(15);
5202: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
5203: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
5204: l_diff_gl_date_dists NUMBER := 0;
5205: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
5206:
5207: l_curr_calling_sequence VARCHAR2(2000);
5208:
5209: -- Logging:

Line 5243: FROM ap_invoices_all AI

5239: INVOICES_CLASS
5240: ) event_class
5241: INTO l_event_type,
5242: l_event_class
5243: FROM ap_invoices_all AI
5244: WHERE AI.invoice_id = p_invoice_id;
5245:
5246: l_log_msg := 'Before calling procedure create_invoice_event';
5247: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 5726: ap_invoices_all AI

5722: AID.org_id,
5723: AI.legal_entity_id,
5724: AID.set_of_books_id ledger_id
5725: FROM ap_invoice_distributions_all AID,
5726: ap_invoices_all AI
5727: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
5728: = p_period_name
5729: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5730: AND aid.org_id = ai.org_id

Line 5758: ap_invoices_all AI

5754: AID.org_id,
5755: AI.legal_entity_id,
5756: AID.set_of_books_id ledger_id
5757: FROM ap_invoice_distributions_all AID,
5758: ap_invoices_all AI
5759: WHERE AID.accounting_date BETWEEN p_from_date AND p_to_date
5760: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5761: AND aid.org_id = ai.org_id
5762: AND AID.org_id IN

Line 6758: from ap_invoices_all --bug6705052

6754: END IF;
6755:
6756: select invoice_num
6757: into l_invoice_num
6758: from ap_invoices_all --bug6705052
6759: where invoice_id = p_invoice_id;
6760:
6761: l_event_source_info.application_id := 200;
6762: l_event_source_info.legal_entity_id := p_legal_entity_id;

Line 6914: ap_invoices_all AI --bug6705052

6910: p_legal_entity_id,
6911: p_ledger_id,
6912: p_transaction_date
6913: FROM
6914: ap_invoices_all AI --bug6705052
6915: WHERE
6916: AI.invoice_id = p_invoice_id;
6917:
6918: l_log_msg :='End of procedure '||l_procedure_name;