eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICES_INTERFACE

Line 283: THEN UPDATE ap_invoices_interface

279:
280: --added nvl for bug 7314487
281: IF l_temp_vendor_id is NULL
282: AND nvl(p_invoice_rec.invoice_type_lookup_code,'STANDARD') <> 'PAYMENT REQUEST'
283: THEN UPDATE ap_invoices_interface
284: SET vendor_id = l_vendor_id
285: WHERE invoice_id = p_invoice_rec.invoice_id;
286: END IF;
287:

Line 6012: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;

6008: invalid_pay_curr_code_failure EXCEPTION;
6009: l_current_invoice_status VARCHAR2(1) := 'Y';
6010: l_start_date_active DATE;
6011: l_end_date_active DATE;
6012: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;
6013: l_warning VARCHAR2(240);
6014: current_calling_sequence VARCHAR2(2000);
6015: debug_info VARCHAR2(500);
6016:

Line 21414: | ap_invoices_interface table as part of the eTax Uptake project:

Line 21597: FROM ap_invoices_interface aii

21593:
21594: BEGIN
21595: SELECT 'Y'
21596: INTO l_alloc_not_provided
21597: FROM ap_invoices_interface aii
21598: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21599: AND 1 < (SELECT COUNT(*)
21600: FROM ap_invoice_lines_interface aili
21601: WHERE aili.line_type_lookup_code <> 'TAX'

Line 21644: FROM ap_invoices_interface aii

21640:
21641: BEGIN
21642: SELECT 'Y'
21643: INTO l_tax_found_in_nontax_line
21644: FROM ap_invoices_interface aii
21645: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21646: AND EXISTS (SELECT 'Y'
21647: FROM ap_invoice_lines_interface ail2
21648: WHERE ail2.invoice_id = aii.invoice_id

Line 21700: FROM ap_invoices_interface aii

21696: IF (NVL(p_invoice_rec.tax_only_flag, 'N') = 'Y') THEN
21697: BEGIN
21698: SELECT 'Y'
21699: INTO l_tax_lines_cannot_coexist
21700: FROM ap_invoices_interface aii
21701: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21702: AND EXISTS (SELECT 'Y'
21703: FROM ap_invoice_lines_interface ail2
21704: WHERE ail2.invoice_id = aii.invoice_id

Line 21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;

21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:

Line 21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;

21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;

21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
21829: --6412397

Line 21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;

21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
21829: --6412397
21830:

Line 21887: FROM ap_invoices_interface aii,

21883: /* --Bug 6925674 (Base bug6905106) Starts
21884: BEGIN
21885: SELECT aii.invoice_type_lookup_code
21886: INTO l_inv_hdr_inv_type
21887: FROM ap_invoices_interface aii,
21888: ap_invoice_lines_interface aili
21889: WHERE aii.invoice_id = aili.invoice_id
21890: AND aili.ROWID = p_invoice_lines_rec.row_id;
21891:

Line 22010: FROM ap_invoices_interface aii,

22006: INTO l_inv_hdr_org_id,
22007: l_inv_hdr_vendor_id,
22008: l_inv_hdr_vendor_site_id,
22009: l_inv_hdr_inv_type
22010: FROM ap_invoices_interface aii,
22011: ap_invoice_lines_interface aili
22012: WHERE aii.invoice_id = aili.invoice_id
22013: AND aili.ROWID = p_invoice_lines_rec.row_id;
22014: