APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1119: l_invoice_pay_id AP_INVOICE_PAYMENTS.INVOICE_PAYMENT_ID%TYPE;

1115: P_calling_sequence IN VARCHAR2 DEFAULT NULL) IS
1116: --
1117: l_current_calling_sequence VARCHAR2(2000);
1118: l_debug_info VARCHAR2(2000);
1119: l_invoice_pay_id AP_INVOICE_PAYMENTS.INVOICE_PAYMENT_ID%TYPE;
1120: l_count INTEGER;
1121: l_dis_total INTEGER;
1122: l_api_name CONSTANT VARCHAR2(100) := 'INSERT_DISCOUNT';
1123: /*----------------------------------------------------------------

Line 1134: FROM ap_invoice_payments APIP

1130: P_acctg_date IN DATE,
1131: P_ledger_id IN NUMBER,
1132: P_calling_sequence IN VARCHAR2) IS
1133: SELECT invoice_payment_id
1134: FROM ap_invoice_payments APIP
1135: WHERE APIP.assets_addition_flag = 'U'
1136: AND APIP.posted_flag = 'Y'
1137: AND APIP.accounting_date <= P_acctg_date
1138: AND APIP.set_of_books_id = P_ledger_id

Line 1415: ap_invoice_payments_all APIP,

1411: 'NEW',
1412: APIP.invoice_payment_id
1413: FROM ap_invoice_distributions_all APID,
1414: ap_invoice_lines_all APIL,
1415: ap_invoice_payments_all APIP,
1416: ap_payment_hist_dists APHD,
1417: ap_invoices_all API,
1418: ap_batches_all APB,
1419: po_distributions_all POD,

Line 2003: UPDATE ap_invoice_payments_all APIP

1999: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
2001: END IF;
2002: --
2003: UPDATE ap_invoice_payments_all APIP
2004: SET APIP.assets_addition_flag = 'Y'
2005: WHERE APIP.assets_addition_flag = 'U'
2006: AND APIP.posted_flag = 'Y'
2007: AND APIP.set_of_books_id = l_ledger_id

Line 2031: UPDATE ap_invoice_payments_all APIP

2027: ||'after successfully transferred to Asset: '
2028: ||TO_CHAR(l_count));
2029: END IF;
2030: --
2031: UPDATE ap_invoice_payments_all APIP
2032: SET APIP.assets_addition_flag = 'N'
2033: WHERE APIP.assets_addition_flag = 'U'
2034: AND APIP.posted_flag = 'Y'
2035: AND APIP.set_of_books_id = l_ledger_id