DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_VENDORS_V

Line 4080: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE

4076: x_msg_data OUT NOCOPY VARCHAR2,
4077: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
4078: p_line_number IN okl_lines_interface.line_number%TYPE,
4079: x_vendor_id OUT NOCOPY NUMBER,
4080: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE
4081: ) IS
4082:
4083: CURSOR vendor_csr (p_vendor_name VARCHAR2) IS
4084: SELECT id1

Line 4085: FROM okx_vendors_v

4081: ) IS
4082:
4083: CURSOR vendor_csr (p_vendor_name VARCHAR2) IS
4084: SELECT id1
4085: FROM okx_vendors_v
4086: WHERE name = p_vendor_name;
4087:
4088: l_id NUMBER;
4089: l_proc_name VARCHAR2(35) := 'GET_VENDOR_ID';