APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_RECURRING_PAYMENTS_V

Line 1787: --* : ap_recurring_payments_v VIEW, SELECT *--

1783: --* Called from : validate_po *--
1784: --* Calls : fv_utility.debug_mesg *--
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: --****************************************************************************************--

Line 1824: ap_recurring_payments_v arp

1820: IS
1821: SELECT ai.invoice_id,
1822: ai.approval_status_lookup_code
1823: FROM ap_invoices_v ai,
1824: ap_recurring_payments_v arp
1825: WHERE arp.recurring_payment_id = ai.recurring_payment_id
1826: AND arp.set_of_books_id = ai.set_of_books_id
1827: AND arp.po_number = c_po_num
1828: AND arp.line_num = NVL(c_po_line_num, 1)

Line 1835: ap_recurring_payments_v arpb

1831: AND ai.payment_status_flag = 'N'
1832: AND ai.set_of_books_id = g_set_of_books_id
1833: AND ai.invoice_date = (SELECT MIN(invoice_date)
1834: FROM ap_invoices aib,
1835: ap_recurring_payments_v arpb
1836: WHERE aib.source = 'RECURRING INVOICE'
1837: AND aib.set_of_books_id = g_set_of_books_id
1838: AND aib.payment_status_flag = 'N'
1839: AND aib.invoice_amount = c_amount

Line 2327: --* : ap_recurring_payments_v SELECT *--

2323: --* Tables Used : po_headers SELECT *--
2324: --* : po_distributions SELECT *--
2325: --* : po_lines SELECT *--
2326: --* : ap_invoice_distributions SELECT *--
2327: --* : ap_recurring_payments_v SELECT *--
2328: --* Logic : *--
2329: --****************************************************************************************--
2330: PROCEDURE validate_po
2331: (

Line 2643: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from ap_recurring_payments_v');

2639: --Check whether Recurring Invoice has been created for
2640: --the PO_NUMBER and LINE_NUMBER.
2641: BEGIN
2642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2643: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from ap_recurring_payments_v');
2644: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_id = '||p_ap_inv_lines_rec.po_line_id);
2645: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id = '||p_ap_inv_lines_rec.po_header_id);
2646: END IF;
2647: l_exists := 0;

Line 2650: FROM ap_recurring_payments_v aprpv

2646: END IF;
2647: l_exists := 0;
2648: SELECT COUNT(*)
2649: INTO l_exists
2650: FROM ap_recurring_payments_v aprpv
2651: WHERE aprpv.po_header_id = p_ap_inv_lines_rec.po_header_id
2652: AND aprpv.po_line_id = p_ap_inv_lines_rec.po_line_id;
2653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2654: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_exists='||l_exists);

Line 2660: l_location := l_module_name||'.ap_recurring_payments_v';

2656: EXCEPTION
2657: WHEN OTHERS THEN
2658: p_error_code := g_FAILURE;
2659: p_error_desc := SQLERRM;
2660: l_location := l_module_name||'.ap_recurring_payments_v';
2661: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2662: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2663: END ;
2664: */