APPS.OKC_UTIL dependencies on OKC_K_ACCESSES

Line 19: g_resp_access okc_k_accesses.access_level%TYPE := OKC_API.G_MISS_CHAR;

15: g_reset_access_flag BOOLEAN := FALSE;
16: g_reset_lang_flag BOOLEAN := FALSE;
17: g_reset_resp_flag BOOLEAN := FALSE;
18: g_userenv_lang fnd_languages.language_code%TYPE;
19: g_resp_access okc_k_accesses.access_level%TYPE := OKC_API.G_MISS_CHAR;
20: g_user_resource_id okc_k_accesses.resource_id%TYPE := OKC_API.G_MISS_NUM;
21: g_scs_code okc_k_headers_b.scs_code%TYPE := OKC_API.G_MISS_CHAR;
22: g_groups_processed Boolean := False;
23:

Line 20: g_user_resource_id okc_k_accesses.resource_id%TYPE := OKC_API.G_MISS_NUM;

16: g_reset_lang_flag BOOLEAN := FALSE;
17: g_reset_resp_flag BOOLEAN := FALSE;
18: g_userenv_lang fnd_languages.language_code%TYPE;
19: g_resp_access okc_k_accesses.access_level%TYPE := OKC_API.G_MISS_CHAR;
20: g_user_resource_id okc_k_accesses.resource_id%TYPE := OKC_API.G_MISS_NUM;
21: g_scs_code okc_k_headers_b.scs_code%TYPE := OKC_API.G_MISS_CHAR;
22: g_groups_processed Boolean := False;
23:
24: TYPE sec_group_tbl IS TABLE OF okc_k_accesses.group_id%TYPE;

Line 24: TYPE sec_group_tbl IS TABLE OF okc_k_accesses.group_id%TYPE;

20: g_user_resource_id okc_k_accesses.resource_id%TYPE := OKC_API.G_MISS_NUM;
21: g_scs_code okc_k_headers_b.scs_code%TYPE := OKC_API.G_MISS_CHAR;
22: g_groups_processed Boolean := False;
23:
24: TYPE sec_group_tbl IS TABLE OF okc_k_accesses.group_id%TYPE;
25: g_sec_groups sec_group_tbl;
26:
27: TYPE lenchk_rec_type IS RECORD (
28: VName VARCHAR2(30),

Line 1638: l_group_access okc_k_accesses.access_level%TYPE;

1634: l_no_access CONSTANT Varchar2(1) := 'N';
1635:
1636: l_resp_access okc_subclass_resps.access_level%TYPE;
1637: l_resource_access okc_subclass_resps.access_level%TYPE;
1638: l_group_access okc_k_accesses.access_level%TYPE;
1639: l_group_id okc_k_accesses.group_id%TYPE;
1640:
1641: l_row_notfound Boolean;
1642: l_group_has_read_access Boolean;

Line 1639: l_group_id okc_k_accesses.group_id%TYPE;

1635:
1636: l_resp_access okc_subclass_resps.access_level%TYPE;
1637: l_resource_access okc_subclass_resps.access_level%TYPE;
1638: l_group_access okc_k_accesses.access_level%TYPE;
1639: l_group_id okc_k_accesses.group_id%TYPE;
1640:
1641: l_row_notfound Boolean;
1642: l_group_has_read_access Boolean;
1643:

Line 1699: FROM okc_k_accesses cas

1695: -- This checks the access level for the resource and the contract
1696:
1697: CURSOR res_acc_csr is
1698: SELECT cas.access_level
1699: FROM okc_k_accesses cas
1700: WHERE cas.chr_id = p_chr_id
1701: AND cas.resource_id = g_user_resource_id;
1702:
1703: -- This cursor selects all the resource groups and the access level

Line 1709: FROM okc_k_accesses cas

1705:
1706: CURSOR grp_acc_csr is
1707: SELECT cas.group_id,
1708: cas.access_level
1709: FROM okc_k_accesses cas
1710: WHERE cas.chr_id = p_chr_id
1711: AND cas.group_id is not null
1712: ORDER BY 2 DESC;
1713: