APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_ROLE_SOURCES

Line 4492: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

4488: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PTY_RLS';
4489: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4490: l_debug_enabled VARCHAR2(10);
4491: l_chr_id NUMBER;
4492: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
4493: row_count NUMBER DEFAULT 0;
4494: l_cplv_id NUMBER;
4495: l_party_name VARCHAR2(200);
4496: l_party_desc VARCHAR2(2000);

Line 4518: FROM OKC_ROLE_SOURCES

4514: AND rle_code = G_RLE_CODE
4515: AND object1_id1 = p_customer_id;
4516: CURSOR role_csr(p_rle_code VARCHAR2) IS
4517: SELECT access_level
4518: FROM OKC_ROLE_SOURCES
4519: WHERE rle_code = p_rle_code
4520: AND buy_or_sell = 'S';
4521: --Get the vendor id
4522: CURSOR c_cplv (p_khr_id IN okl_lease_applications_v.PROGRAM_AGREEMENT_ID%TYPE) IS

Line 4607: okc_role_sources rse,

4603: Cursor c_rrd_id (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) is
4604: SELECT rgrdfs.id
4605: from okc_k_headers_b chr,
4606: okc_subclass_roles sre,
4607: okc_role_sources rse,
4608: okc_subclass_rg_defs rgdfs,
4609: okc_rg_role_defs rgrdfs
4610: where chr.id = cp_chr_id
4611: and sre.scs_code = chr.scs_code