DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_SUBCLASS_RESPS

Line 939: l_resp_access okc_subclass_resps.access_level%TYPE;

935: l_scs_code okc_k_headers_b.scs_code%TYPE;
936: l_modify_access CONSTANT VARCHAR2(1) := 'U';
937: l_read_access CONSTANT VARCHAR2(1) := 'R';
938: l_no_access CONSTANT VARCHAR2(1) := 'N';
939: l_resp_access okc_subclass_resps.access_level%TYPE;
940: l_resource_access okc_subclass_resps.access_level%TYPE;
941: l_group_access okc_k_accesses.access_level%TYPE;
942: l_group_id okc_k_accesses.group_id%TYPE;
943: l_row_notfound BOOLEAN;

Line 940: l_resource_access okc_subclass_resps.access_level%TYPE;

936: l_modify_access CONSTANT VARCHAR2(1) := 'U';
937: l_read_access CONSTANT VARCHAR2(1) := 'R';
938: l_no_access CONSTANT VARCHAR2(1) := 'N';
939: l_resp_access okc_subclass_resps.access_level%TYPE;
940: l_resource_access okc_subclass_resps.access_level%TYPE;
941: l_group_access okc_k_accesses.access_level%TYPE;
942: l_group_id okc_k_accesses.group_id%TYPE;
943: l_row_notfound BOOLEAN;
944: l_group_has_read_access BOOLEAN;

Line 959: FROM okc_subclass_resps ras

955: -- This cursor checks to see the type of access granted to the current
956: -- user'S responsibility TO the sub class
957: CURSOR resp_csr IS
958: SELECT ras.access_level
959: FROM okc_subclass_resps ras
960: WHERE ras.scs_code = l_scs_code
961: AND ras.resp_id = Fnd_Global.resp_id
962: AND l_date BETWEEN ras.start_date AND NVL(ras.end_date, l_date);
963: -- This cursor retrieves the resource id corresponding to the logged