APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_EXT_PAY_INVS_B

Line 21: l_xpi_id okl_ext_pay_invs_b.id%type;

17: IS
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';

Line 45: FROM okl_ext_pay_invs_b

41: --end:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
42:
43: CURSOR c_invoice_hdr IS
44: SELECT *
45: FROM okl_ext_pay_invs_b
46: WHERE trx_status_code = 'ENTERED'
47: FOR UPDATE OF TRX_STATUS_CODE;
48:
49:

Line 750: UPDATE okl_ext_pay_invs_b

746:
747: END LOOP;
748:
749: IF (l_tax_call_success_flag = 'Y') THEN
750: UPDATE okl_ext_pay_invs_b
751: SET trx_status_code = 'PROCESSED'
752: WHERE CURRENT OF c_invoice_hdr;
753:
754: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |