APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 256: FROM xla_ae_headers aeh, ap_invoice_payments aip

252: l_count number;
253: BEGIN
254: SELECT count(aeh.event_id)
255: INTO l_count
256: FROM xla_ae_headers aeh, ap_invoice_payments aip
257: WHERE aeh.ledger_id = aip.set_of_books_id
258: AND aeh.application_id = 200
259: AND aeh.event_id = aip.accounting_event_id
260: AND aip.invoice_id = p_invoice_id

Line 341: UPDATE ap_invoice_payments_all APIP

337: /* Bug#11868928 - End */
338:
339:
340: /* Bug#14712606 - Start */
341: UPDATE ap_invoice_payments_all APIP
342: SET APIP.assets_addition_flag = 'N'
343: WHERE APIP.assets_addition_flag = 'U'
344: AND APIP.posted_flag = 'Y'
345: AND APIP.accounting_date <= P_acctg_date

Line 1490: --l_invoice_pay_id AP_INVOICE_PAYMENTS.INVOICE_PAYMENT_ID%TYPE; --Bug 12703009: commented

1486: P_calling_sequence IN VARCHAR2 DEFAULT NULL) IS
1487: --
1488: l_current_calling_sequence VARCHAR2(2000);
1489: l_debug_info VARCHAR2(2000);
1490: --l_invoice_pay_id AP_INVOICE_PAYMENTS.INVOICE_PAYMENT_ID%TYPE; --Bug 12703009: commented
1491: l_count INTEGER;
1492: l_dis_total INTEGER;
1493: l_api_name CONSTANT VARCHAR2(100) := 'INSERT_DISCOUNT';
1494: /*----------------------------------------------------------------

Line 1506: FROM ap_invoice_payments APIP

1502: P_acctg_date IN DATE,
1503: P_ledger_id IN NUMBER,
1504: P_calling_sequence IN VARCHAR2) IS
1505: SELECT invoice_payment_id
1506: FROM ap_invoice_payments APIP
1507: WHERE APIP.assets_addition_flag = 'U'
1508: AND APIP.posted_flag = 'Y'
1509: AND APIP.accounting_date <= P_acctg_date
1510: AND APIP.set_of_books_id = P_ledger_id

Line 1786: ap_invoice_payments_all APIP,

1782: 'NEW',
1783: APIP.invoice_payment_id
1784: FROM ap_invoice_distributions_all APID,
1785: ap_invoice_lines_all APIL,
1786: ap_invoice_payments_all APIP,
1787: ap_payment_hist_dists APHD,
1788: ap_invoices_all API,
1789: ap_batches_all APB,
1790: po_distributions_all POD,

Line 2424: UPDATE ap_invoice_payments_all APIP

2420: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2421: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
2422: END IF;
2423: --
2424: UPDATE ap_invoice_payments_all APIP
2425: SET APIP.assets_addition_flag = 'Y'
2426: WHERE APIP.assets_addition_flag = 'U'
2427: AND APIP.posted_flag = 'Y'
2428: AND APIP.set_of_books_id = l_ledger_id

Line 2452: UPDATE ap_invoice_payments_all APIP

2448: ||'after successfully transferred to Asset: '
2449: ||TO_CHAR(l_count));
2450: END IF;
2451: --
2452: UPDATE ap_invoice_payments_all APIP
2453: SET APIP.assets_addition_flag = 'N'
2454: WHERE APIP.assets_addition_flag = 'U'
2455: AND APIP.posted_flag = 'Y'
2456: AND APIP.set_of_books_id = l_ledger_id