APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on AP_INVOICES_INTERFACE

Line 22: v_description ap_invoices_interface.description%type;

18:
19: /* rkuttiya modified removed old code */
20:
21: l_xpi_id okl_ext_pay_invs_b.id%type;
22: v_description ap_invoices_interface.description%type;
23:
24: l_api_version CONSTANT NUMBER := 1;
25: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER';
26: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 346: INSERT INTO AP_INVOICES_INTERFACE(

342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
345:
346: INSERT INTO AP_INVOICES_INTERFACE(
347: Invoice_type_lookup_code
348: ,accts_pay_code_combination_id
349: ,attribute1
350: ,attribute10

Line 624: DELETE FROM AP_INVOICES_INTERFACE

620: DELETE FROM ap_invoice_lines_interface
621: WHERE invoice_id = r_invoice_hdr.invoice_id;
622:
623: --deleting invoice header
624: DELETE FROM AP_INVOICES_INTERFACE
625: WHERE invoice_id = r_invoice_hdr.invoice_id;
626:
627: EXIT;
628: END IF;

Line 756: UPDATE ap_invoices_interface

752: WHERE CURRENT OF c_invoice_hdr;
753:
754: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
755:
756: UPDATE ap_invoices_interface
757: SET TAXATION_COUNTRY = lx_tax_det_rec.X_DEFAULT_TAXATION_COUNTRY
758: WHERE invoice_id = r_invoice_hdr.invoice_id;
759:
760: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |