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 343: INSERT INTO AP_INVOICES_INTERFACE(

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

Line 613: DELETE FROM AP_INVOICES_INTERFACE

609: DELETE FROM ap_invoice_lines_interface
610: WHERE invoice_id = r_invoice_hdr.invoice_id;
611:
612: --deleting invoice header
613: DELETE FROM AP_INVOICES_INTERFACE
614: WHERE invoice_id = r_invoice_hdr.invoice_id;
615:
616: EXIT;
617: END IF;

Line 743: UPDATE ap_invoices_interface

739: WHERE CURRENT OF c_invoice_hdr;
740:
741: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
742:
743: UPDATE ap_invoices_interface
744: SET TAXATION_COUNTRY = lx_tax_det_rec.X_DEFAULT_TAXATION_COUNTRY
745: WHERE invoice_id = r_invoice_hdr.invoice_id;
746:
747: --end:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |