APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_VENDOR_SITES_V

Line 4848: FROM okx_vendor_sites_v

4844: RETURN NUMBER IS
4845: CURSOR site_csr (p_name VARCHAR2,
4846: p_id NUMBER) IS
4847: SELECT id1
4848: FROM okx_vendor_sites_v
4849: WHERE (name = p_name
4850: AND
4851: p_name IS NOT NULL)
4852: OR

Line 4859: l_id1 okx_vendor_sites_v.id1%TYPE;

4855: p_id IS NOT NULL)
4856: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE))
4857: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
4858:
4859: l_id1 okx_vendor_sites_v.id1%TYPE;
4860: BEGIN
4861:
4862: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4863:

Line 5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

5565: x_base_uom_id okx_tuom_v.id1%TYPE;
5566: x_price_list_id okx_list_headers_v.id1%TYPE;
5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5570: l_freq_id okl_time_units_v.id1%TYPE;
5571:
5572: -- Rule Rec
5573: x_rgpv_rec rgpv_rec_type;

Line 6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;
6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;
6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
6129: l_freq_id okl_time_units_v.id1%TYPE;
6130:
6131: CURSOR freq_csr (p_frequency VARCHAR2) IS
6132: SELECT id1