DBA Data[Home] [Help]

APPS.CN_USER_ACCESS_PKG dependencies on CN_USER_ACCESSES_S

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 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,