APPS.CN_USER_ACCESS_PKG dependencies on CN_USER_ACCESSES

Line 8: SELECT cn_user_accesses_s.nextval

4: PROCEDURE Insert_Row(newrec IN OUT
5: CN_USER_ACCESS_PVT.USER_ACCESS_REC_TYPE) IS
6: BEGIN
7: -- get the next pk from sequence
8: SELECT cn_user_accesses_s.nextval
9: INTO newrec.user_access_id
10: FROM dual;
11:
12: INSERT into cn_user_accesses

Line 12: INSERT into cn_user_accesses

8: SELECT cn_user_accesses_s.nextval
9: INTO newrec.user_access_id
10: FROM dual;
11:
12: INSERT into cn_user_accesses
13: (user_access_id,
14: user_id,
15: comp_group_id,
16: org_code,

Line 74: FROM cn_user_accesses

70: PROCEDURE Update_Row(newrec
71: CN_USER_ACCESS_PVT.USER_ACCESS_REC_TYPE) IS
72: CURSOR c IS
73: SELECT *
74: FROM cn_user_accesses
75: WHERE user_access_id = newrec.user_access_id;
76: oldrec c%ROWTYPE;
77: BEGIN
78: open c;

Line 82: update cn_user_accesses set

78: open c;
79: fetch c into oldrec;
80: close c;
81:
82: update cn_user_accesses set
83: user_id = decode(newrec.user_id, fnd_api.g_miss_num,
84: oldrec.user_id,
85: newrec.user_id),
86: comp_group_id = decode(newrec.comp_group_id, fnd_api.g_miss_num,

Line 154: from cn_user_accesses

150: PROCEDURE LOCK_ROW (p_user_access_id IN NUMBER,
151: p_object_version_number IN NUMBER) IS
152: cursor c is
153: select object_version_number
154: from cn_user_accesses
155: where user_access_id = p_user_access_id
156: for update of user_access_id nowait;
157: tlinfo c%rowtype ;
158: BEGIN

Line 179: DELETE from cn_user_accesses

175: END LOCK_ROW;
176:
177: PROCEDURE Delete_Row(p_user_access_id NUMBER) IS
178: BEGIN
179: DELETE from cn_user_accesses
180: WHERE user_access_id = p_user_access_id;
181: if (sql%notfound) then
182: raise no_data_found;
183: end if;