[Home] [Help]
1213: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1214: END copy_react_intervals;
1215:
1216: --------------------------------------------------------------------------
1217: --Proceudre copy_accesses - Makes a copy of the okc_k_accesses.
1218: --------------------------------------------------------------------------
1219: PROCEDURE copy_accesses(
1220: p_api_version IN NUMBER,
1221: p_init_msg_list IN VARCHAR2 ,
1230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1231:
1232: CURSOR c_access IS
1233: SELECT id
1234: FROM okc_k_accesses_v
1235: WHERE chr_id = p_from_chr_id;
1236:
1237: BEGIN
1238: x_return_status := l_return_status;
6843: GROUP_ID,
6844: CHR_ID,
6845: RESOURCE_ID,
6846: ACCESS_LEVEL
6847: FROM OKC_K_ACCESSES_V
6848: WHERE ID = p_cac_id;
6849:
6850: BEGIN
6851: OPEN c_cacv_rec;
11797:
11798: -- Get current security restrictions
11799: CURSOR get_access_level (p_chr_id IN NUMBER) IS
11800: SELECT id
11801: FROM okc_k_accesses
11802: WHERE chr_id = p_chr_id;
11803:
11804: -- Select all top lines and sublines
11805: CURSOR get_contract_lines_csr (p_chr_id IN NUMBER) IS