DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ACCESSES

Line 1216: --Proceudre copy_accesses - Makes a copy of the okc_k_accesses.

1212: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1213: END copy_react_intervals;
1214:
1215: --------------------------------------------------------------------------
1216: --Proceudre copy_accesses - Makes a copy of the okc_k_accesses.
1217: --------------------------------------------------------------------------
1218: PROCEDURE copy_accesses(
1219: p_api_version IN NUMBER,
1220: p_init_msg_list IN VARCHAR2 ,

Line 1233: FROM okc_k_accesses_v

1229: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1230:
1231: CURSOR c_access IS
1232: SELECT id
1233: FROM okc_k_accesses_v
1234: WHERE chr_id = p_from_chr_id;
1235:
1236: BEGIN
1237: x_return_status := l_return_status;

Line 6846: FROM OKC_K_ACCESSES_V

6842: GROUP_ID,
6843: CHR_ID,
6844: RESOURCE_ID,
6845: ACCESS_LEVEL
6846: FROM OKC_K_ACCESSES_V
6847: WHERE ID = p_cac_id;
6848:
6849: BEGIN
6850: OPEN c_cacv_rec;

Line 11800: FROM okc_k_accesses

11796:
11797: -- Get current security restrictions
11798: CURSOR get_access_level (p_chr_id IN NUMBER) IS
11799: SELECT id
11800: FROM okc_k_accesses
11801: WHERE chr_id = p_chr_id;
11802:
11803: -- Select all top lines and sublines
11804: CURSOR get_contract_lines_csr (p_chr_id IN NUMBER) IS