DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 163: FROM ap_invoice_payments_all aip,

159:
160:
161: CURSOR C_INTEREST_INVOICES IS
162: SELECT i.invoice_id
163: FROM ap_invoice_payments_all aip,
164: ap_checks_all c,
165: ap_invoices_all i,
166: ap_invoice_relationships ir
167: WHERE c.check_id = p_check_id

Line 761: AP_Invoice_Payments_All AIP,

757: CURSOR c_subscribed_payments IS
758: SELECT Distinct AC.Check_ID,
759: APR.Reg_Application_ID
760: FROM AP_Checks_All AC,
761: AP_Invoice_Payments_All AIP,
762: AP_Invoices_All AI,
763: AP_Product_Registrations APR
764: WHERE AC.Checkrun_Name = l_checkrun_name
765: AND AC.Completed_Pmts_Group_ID = p_completed_pmts_group_id

Line 1927: l_debug_info := 'insert into ap_invoice_payments_all';

1923: CLOSE c_invoice_amounts; --Bug5733731
1924:
1925:
1926:
1927: l_debug_info := 'insert into ap_invoice_payments_all';
1928: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1930: END IF;
1931:

Line 1932: INSERT INTO ap_invoice_payments_all(

1928: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1930: END IF;
1931:
1932: INSERT INTO ap_invoice_payments_all(
1933: INVOICE_PAYMENT_ID,
1934: INVOICE_ID,
1935: PAYMENT_NUM,
1936: CHECK_ID,

Line 2206: p_key_table => 'AP_INVOICE_PAYMENTS_ALL',

2202: END IF;
2203: AP_DBI_PKG.Insert_Payment_Confirm_DBI(
2204: p_checkrun_name => l_checkrun_name,
2205: p_base_currency_code => l_base_currency_code,
2206: p_key_table => 'AP_INVOICE_PAYMENTS_ALL',
2207: p_calling_sequence => l_current_calling_sequence );
2208:
2209: l_debug_info := 'AP_Accounting_Events_Pkg.Batch_Update_Payment_Info';
2210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN