DBA Data[Home] [Help]

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_IPAC_RECURRING_INV

Line 1789: --* : fv_ipac_recurring_inv SELECT, INSERT *--

1785: --* : fv_utility.log_mesg *--
1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--
1787: --* : ap_recurring_payments_v VIEW, SELECT *--
1788: --* : ap_invoices VIEW, SELECT *--
1789: --* : fv_ipac_recurring_inv SELECT, INSERT *--
1790: --* Logic : Already existing code *--
1791: --****************************************************************************************--
1792: PROCEDURE process_recurr_invoice
1793: (

Line 1933: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_recurring_inv');

1929: -- insert this record if the invoice isn't already there
1930: -- the automatic payment program will refer to this table to create
1931: -- a payment for this invoice.
1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1933: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_recurring_inv');
1934: END IF;
1935: INSERT INTO fv_ipac_recurring_inv
1936: (
1937: batch_name,

Line 1935: INSERT INTO fv_ipac_recurring_inv

1931: -- a payment for this invoice.
1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1933: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_recurring_inv');
1934: END IF;
1935: INSERT INTO fv_ipac_recurring_inv
1936: (
1937: batch_name,
1938: invoice_id,
1939: invoice_action,

Line 1958: FROM fv_ipac_recurring_inv

1954: g_login_id,
1955: g_user_id
1956: FROM dual
1957: WHERE NOT EXISTS (SELECT invoice_id
1958: FROM fv_ipac_recurring_inv
1959: WHERE invoice_id = l_invoice_id
1960: AND batch_name = p_batch_name);
1961:
1962: p_invoice_found := 'Y';