APPS.CN_USER_ACCESS_PVT dependencies on CN_USER_ACCESSES

Line 54: from cn_user_accesses

50:
51: -- make sure the access level for the current comp group and org
52: -- isn't already assigned
53: select count(user_access_id) into l_count
54: from cn_user_accesses
55: where user_id = l_newrec.user_id
56: and comp_group_id = l_newrec.comp_group_id
57: and org_code = l_newrec.org_code;
58: IF l_count > 0 THEN

Line 147: from cn_user_accesses

143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- make sure record to be updated exists.
146: select count(*) into l_count
147: from cn_user_accesses
148: where user_access_id = l_newrec.user_access_id;
149:
150: if l_count = 0 then
151: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');

Line 159: from cn_user_accesses

155:
156: -- make sure the access level for the current comp group and org
157: -- isn't already assigned
158: select count(user_access_id) into l_count
159: from cn_user_accesses
160: where user_id = l_newrec.user_id
161: and comp_group_id = l_newrec.comp_group_id
162: and org_code = l_newrec.org_code
163: and user_access_id <> l_newrec.user_access_id;

Line 257: from cn_user_accesses

253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- make sure record to be deleted exists.
256: select count(*) into l_count
257: from cn_user_accesses
258: where user_access_id = p_user_access_id;
259:
260: if l_count = 0 then
261: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DEL_REC');

Line 409: FROM cn_user_accesses

405:
406: cursor get_data is
407: SELECT user_access_id, user_id, comp_group_id, org_code, access_code,
408: object_version_number
409: FROM cn_user_accesses
410: WHERE user_id = p_user_id
411: ORDER BY 3,5;
412:
413: BEGIN