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 283: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

279: l_ledger_id NUMBER(15);
280: l_org_id NUMBER(15);
281: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
282: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
283: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
284:
285: BEGIN
286:
287: l_curr_calling_sequence :=

Line 1051: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

1047: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1048: l_prepay_app_event_id NUMBER;
1049: l_inv_adj_event_id NUMBER;
1050: l_curr_calling_sequence VARCHAR2(2000);
1051: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
1052:
1053: -- Logging:
1054: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_INVOICE_EVENTS';
1055: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1393: FROM ap_invoices_all AI

1389: 'DEBIT', DEBIT_MEMOS_CLASS,
1390: 'PREPAYMENT', PREPAYMENTS_CLASS,
1391: INVOICES_CLASS) event_class
1392: INTO l_event_type, l_event_class
1393: FROM ap_invoices_all AI
1394: WHERE AI.invoice_id = p_invoice_id;
1395:
1396: l_log_msg := 'Before calling procedure create_invoice_event';
1397: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1431: FROM ap_invoices_all AI

1427: 'DEBIT', DEBIT_MEMOS_CLASS,
1428: 'PREPAYMENT', PREPAYMENTS_CLASS,
1429: INVOICES_CLASS) event_class
1430: INTO l_event_type, l_event_class
1431: FROM ap_invoices_all AI
1432: WHERE AI.invoice_id = p_invoice_id;
1433: --11659317
1434: BEGIN
1435: SELECT MAX(accounting_event_id)

Line 1835: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

1831: l_ledger_id NUMBER(15);
1832: l_org_id NUMBER(15);
1833: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
1834: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1835: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
1836:
1837: l_curr_calling_sequence VARCHAR2(2000);
1838:
1839: -- Logging:

Line 2515: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

2511: l_Event_count NUMBER;
2512: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
2513: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
2514: l_event_info XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
2515: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
2516:
2517: l_curr_calling_sequence VARCHAR2(2000);
2518:
2519: -- Logging:

Line 3094: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

3090: l_org_id NUMBER(15);
3091: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
3092: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
3093: l_event_info XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
3094: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
3095:
3096: l_curr_calling_sequence VARCHAR2(2000);
3097:
3098: -- Logging:

Line 4274: ap_invoices_all AI

4270: WHERE D.accounting_event_id IS NULL
4271: AND D.invoice_id IN
4272: (SELECT AI.invoice_id
4273: FROM ap_invoice_payments_all AIP2,
4274: ap_invoices_all AI
4275: WHERE AI.invoice_id = AIP2.invoice_id
4276: AND AIP2.check_id = p_check_id
4277: AND AIP2.accounting_event_id = p_event_id
4278: AND AI.invoice_type_lookup_code = 'INTEREST');

Line 4447: ap_invoices_all AI

4443: WHERE AID.accounting_event_id IS NULL
4444: AND AID.invoice_id IN
4445: ( SELECT AI.invoice_id
4446: FROM ap_invoice_payments_all AIP,
4447: ap_invoices_all AI
4448: WHERE AIP.invoice_id = AI.invoice_id
4449: AND AIP.accounting_event_id = l_accounting_event_ids(i)
4450: AND AIP.check_id = l_check_ids(i)
4451: AND AI.invoice_id= l_invoice_ids(i) /* Added for bug#8438184 */

Line 5958: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

5954: l_org_id NUMBER(15);
5955: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
5956: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
5957: l_diff_gl_date_dists NUMBER := 0;
5958: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
5959:
5960: l_curr_calling_sequence VARCHAR2(2000);
5961:
5962: -- Logging:

Line 5996: FROM ap_invoices_all AI

5992: INVOICES_CLASS
5993: ) event_class
5994: INTO l_event_type,
5995: l_event_class
5996: FROM ap_invoices_all AI
5997: WHERE AI.invoice_id = p_invoice_id;
5998:
5999: l_log_msg := 'Before calling procedure create_invoice_event';
6000: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 6470: ap_invoices_all AI

6466: AID.org_id,
6467: AI.legal_entity_id,
6468: AID.set_of_books_id ledger_id
6469: FROM ap_invoice_distributions_all AID,
6470: ap_invoices_all AI
6471: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
6472: = p_period_name
6473: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
6474: AND aid.org_id = ai.org_id

Line 6502: ap_invoices_all AI

6498: AID.org_id,
6499: AI.legal_entity_id,
6500: AID.set_of_books_id ledger_id
6501: FROM ap_invoice_distributions_all AID,
6502: ap_invoices_all AI
6503: WHERE AID.accounting_date BETWEEN p_from_date AND p_to_date
6504: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
6505: AND aid.org_id = ai.org_id
6506: AND AID.org_id IN

Line 7503: from ap_invoices_all --bug6705052

7499: END IF;
7500:
7501: select invoice_num
7502: into l_invoice_num
7503: from ap_invoices_all --bug6705052
7504: where invoice_id = p_invoice_id;
7505:
7506: l_event_source_info.application_id := 200;
7507: l_event_source_info.legal_entity_id := p_legal_entity_id;

Line 7659: ap_invoices_all AI --bug6705052

7655: p_legal_entity_id,
7656: p_ledger_id,
7657: p_transaction_date
7658: FROM
7659: ap_invoices_all AI --bug6705052
7660: WHERE
7661: AI.invoice_id = p_invoice_id;
7662:
7663: l_log_msg :='End of procedure '||l_procedure_name;

Line 8179: ap_invoices_all ai

8175: CURSOR reversed_prepay_events IS
8176: SELECT DISTINCT aid.invoice_id,
8177: aid.accounting_event_id
8178: FROM ap_invoice_distributions_all aid,
8179: ap_invoices_all ai
8180: WHERE ai.invoice_id = p_invoice_id
8181: AND aid.invoice_id = ai.invoice_id
8182: --AND ai.cancelled_date IS NOT NULL --bug9441420
8183: AND aid.line_type_lookup_code IN ('PREPAY','REC_TAX','NONREC_TAX')

Line 8223: ap_invoices_all ai,

8219: SELECT app_aid.invoice_id,
8220: unapp_aid.accounting_Event_id unapp_event_id
8221: FROM ap_invoice_distributions_all app_aid,
8222: xla_events xe_app,
8223: ap_invoices_all ai,
8224: ap_invoice_distributions_all unapp_aid,
8225: xla_events xe_unapp
8226: WHERE ai.invoice_id = p_invoice_id
8227: AND app_aid.prepay_distribution_id IS NOT NULL

Line 8242: l_org_id AP_INVOICES_ALL.org_id%TYPE;

8238: AND xe_unapp.application_id = 200
8239: AND xe_unapp.event_status_code = 'U'
8240: AND app_aid.invoice_id = ai.invoice_id;
8241:
8242: l_org_id AP_INVOICES_ALL.org_id%TYPE;
8243: l_legal_entity_id AP_INVOICES_ALL.legal_entity_id%TYPE;
8244: l_ledger_id AP_INVOICES_ALL.set_of_books_id%TYPE;
8245: l_transaction_date DATE;
8246: l_curr_calling_sequence VARCHAR2(4000);

Line 8243: l_legal_entity_id AP_INVOICES_ALL.legal_entity_id%TYPE;

8239: AND xe_unapp.event_status_code = 'U'
8240: AND app_aid.invoice_id = ai.invoice_id;
8241:
8242: l_org_id AP_INVOICES_ALL.org_id%TYPE;
8243: l_legal_entity_id AP_INVOICES_ALL.legal_entity_id%TYPE;
8244: l_ledger_id AP_INVOICES_ALL.set_of_books_id%TYPE;
8245: l_transaction_date DATE;
8246: l_curr_calling_sequence VARCHAR2(4000);
8247: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

Line 8244: l_ledger_id AP_INVOICES_ALL.set_of_books_id%TYPE;

8240: AND app_aid.invoice_id = ai.invoice_id;
8241:
8242: l_org_id AP_INVOICES_ALL.org_id%TYPE;
8243: l_legal_entity_id AP_INVOICES_ALL.legal_entity_id%TYPE;
8244: l_ledger_id AP_INVOICES_ALL.set_of_books_id%TYPE;
8245: l_transaction_date DATE;
8246: l_curr_calling_sequence VARCHAR2(4000);
8247: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
8248: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

Line 8248: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

8244: l_ledger_id AP_INVOICES_ALL.set_of_books_id%TYPE;
8245: l_transaction_date DATE;
8246: l_curr_calling_sequence VARCHAR2(4000);
8247: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
8248: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
8249: l_accounting_event_id XLA_EVENTS.event_id%TYPE;
8250: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
8251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
8252: