DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_VENDORS_V

Line 3912: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE

3908: x_msg_data OUT NOCOPY VARCHAR2,
3909: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
3910: p_line_number IN okl_lines_interface.line_number%TYPE,
3911: x_vendor_id OUT NOCOPY NUMBER,
3912: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE
3913: ) IS
3914:
3915: CURSOR vendor_csr (p_vendor_name VARCHAR2) IS
3916: SELECT id1

Line 3917: FROM okx_vendors_v

3913: ) IS
3914:
3915: CURSOR vendor_csr (p_vendor_name VARCHAR2) IS
3916: SELECT id1
3917: FROM okx_vendors_v
3918: WHERE name = p_vendor_name;
3919:
3920: l_id NUMBER;
3921: l_proc_name VARCHAR2(35) := 'GET_VENDOR_ID';