APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_VENDOR_SITES_V

Line 4680: FROM okx_vendor_sites_v

4676: RETURN NUMBER IS
4677: CURSOR site_csr (p_name VARCHAR2,
4678: p_id NUMBER) IS
4679: SELECT id1
4680: FROM okx_vendor_sites_v
4681: WHERE (name = p_name
4682: AND
4683: p_name IS NOT NULL)
4684: OR

Line 4691: l_id1 okx_vendor_sites_v.id1%TYPE;

4687: p_id IS NOT NULL)
4688: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE))
4689: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
4690:
4691: l_id1 okx_vendor_sites_v.id1%TYPE;
4692: BEGIN
4693:
4694: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4695:

Line 5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

5397: x_base_uom_id okx_tuom_v.id1%TYPE;
5398: x_price_list_id okx_list_headers_v.id1%TYPE;
5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5402: l_freq_id okl_time_units_v.id1%TYPE;
5403:
5404: -- Rule Rec
5405: x_rgpv_rec rgpv_rec_type;

Line 5960: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;

5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5960: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5961: l_freq_id okl_time_units_v.id1%TYPE;
5962:
5963: CURSOR freq_csr (p_frequency VARCHAR2) IS
5964: SELECT id1