APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_SUBCLASS_RESPS

Line 977: l_resp_access okc_subclass_resps.access_level%TYPE;

973: l_scs_code okc_k_headers_b.scs_code%TYPE;
974: l_modify_access CONSTANT VARCHAR2(1) := 'U';
975: l_read_access CONSTANT VARCHAR2(1) := 'R';
976: l_no_access CONSTANT VARCHAR2(1) := 'N';
977: l_resp_access okc_subclass_resps.access_level%TYPE;
978: l_resource_access okc_subclass_resps.access_level%TYPE;
979: l_group_access okc_k_accesses.access_level%TYPE;
980: l_group_id okc_k_accesses.group_id%TYPE;
981: l_row_notfound BOOLEAN;

Line 978: l_resource_access okc_subclass_resps.access_level%TYPE;

974: l_modify_access CONSTANT VARCHAR2(1) := 'U';
975: l_read_access CONSTANT VARCHAR2(1) := 'R';
976: l_no_access CONSTANT VARCHAR2(1) := 'N';
977: l_resp_access okc_subclass_resps.access_level%TYPE;
978: l_resource_access okc_subclass_resps.access_level%TYPE;
979: l_group_access okc_k_accesses.access_level%TYPE;
980: l_group_id okc_k_accesses.group_id%TYPE;
981: l_row_notfound BOOLEAN;
982: l_group_has_read_access BOOLEAN;

Line 997: FROM okc_subclass_resps ras

993: -- This cursor checks to see the type of access granted to the current
994: -- user'S responsibility TO the sub class
995: CURSOR resp_csr IS
996: SELECT ras.access_level
997: FROM okc_subclass_resps ras
998: WHERE ras.scs_code = l_scs_code
999: AND ras.resp_id = Fnd_Global.resp_id
1000: AND l_date BETWEEN ras.start_date AND NVL(ras.end_date, l_date);
1001: -- This cursor retrieves the resource id corresponding to the logged