APPS.CN_USER_ACCESS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE Insert_Row(newrec IN OUT
                     CN_USER_ACCESS_PVT.USER_ACCESS_REC_TYPE) IS
BEGIN
   -- get the next pk from sequence
   SELECT cn_user_accesses_s.nextval
     INTO newrec.user_access_id
     FROM dual;

Line: 12

   INSERT into cn_user_accesses
     (user_access_id,
      user_id,
      comp_group_id,
      org_code,
      access_code,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      last_update_date,
      last_updated_by,
      last_update_login,
      creation_date,
      created_by,
      object_version_number)
     VALUES
     (newrec.user_access_id,
      newrec.user_id,
      newrec.comp_group_id,
      newrec.org_code,
      newrec.access_code,
      newrec.attribute_category,
      newrec.attribute1,
      newrec.attribute2,
      newrec.attribute3,
      newrec.attribute4,
      newrec.attribute5,
      newrec.attribute6,
      newrec.attribute7,
      newrec.attribute8,
      newrec.attribute9,
      newrec.attribute10,
      newrec.attribute11,
      newrec.attribute12,
      newrec.attribute13,
      newrec.attribute14,
      newrec.attribute15,
      sysdate,
      fnd_global.user_id,
      fnd_global.login_id,
      sysdate,
      fnd_global.user_id,
      1);

Line: 68

END Insert_Row;

Line: 70

PROCEDURE Update_Row(newrec
                     CN_USER_ACCESS_PVT.USER_ACCESS_REC_TYPE) IS
   CURSOR c IS
      SELECT *
        FROM cn_user_accesses
        WHERE user_access_id = newrec.user_access_id;

Line: 82

   update cn_user_accesses set
     user_id           = decode(newrec.user_id,            fnd_api.g_miss_num,
                                oldrec.user_id,
                                newrec.user_id),
     comp_group_id     = decode(newrec.comp_group_id,      fnd_api.g_miss_num,
                                oldrec.comp_group_id,
                                newrec.comp_group_id),
     org_code          = decode(newrec.org_code,           fnd_api.g_miss_char,
                                oldrec.org_code,
                                newrec.org_code),
     access_code       = decode(newrec.access_code,        fnd_api.g_miss_char,
                                oldrec.access_code,
				newrec.access_code),
     attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
                                oldrec.attribute_category,
                                newrec.attribute_category),
     attribute1        = decode(newrec.attribute1,         fnd_api.g_miss_char,
                                oldrec.attribute1,
                                newrec.attribute1),
     attribute2        = decode(newrec.attribute2,         fnd_api.g_miss_char,
                                oldrec.attribute2,
                                newrec.attribute2),
     attribute3        = decode(newrec.attribute3,         fnd_api.g_miss_char,
                                oldrec.attribute3,
                                newrec.attribute3),
     attribute4        = decode(newrec.attribute4,         fnd_api.g_miss_char,
                                oldrec.attribute4,
                                newrec.attribute4),
     attribute5        = decode(newrec.attribute5,         fnd_api.g_miss_char,
                                oldrec.attribute5,
                                newrec.attribute5),
     attribute6        = decode(newrec.attribute6,         fnd_api.g_miss_char,
                                oldrec.attribute6,
                                newrec.attribute6),
     attribute7        = decode(newrec.attribute7,         fnd_api.g_miss_char,
                                oldrec.attribute7,
                                newrec.attribute7),
     attribute8        = decode(newrec.attribute8,         fnd_api.g_miss_char,
                                oldrec.attribute8,
                                newrec.attribute8),
     attribute9        = decode(newrec.attribute9,         fnd_api.g_miss_char,
                                oldrec.attribute9,
                                newrec.attribute9),
     attribute10       = decode(newrec.attribute10,        fnd_api.g_miss_char,
                                oldrec.attribute10,
                                newrec.attribute10),
     attribute11       = decode(newrec.attribute11,        fnd_api.g_miss_char,
                                oldrec.attribute11,
                                newrec.attribute11),
     attribute12       = decode(newrec.attribute12,        fnd_api.g_miss_char,
                                oldrec.attribute12,
                                newrec.attribute12),
     attribute13       = decode(newrec.attribute13,        fnd_api.g_miss_char,
                                oldrec.attribute13,
                                newrec.attribute13),
     attribute14       = decode(newrec.attribute14,        fnd_api.g_miss_char,
                                oldrec.attribute14,
                                newrec.attribute14),
     attribute15       = decode(newrec.attribute15,        fnd_api.g_miss_char,
                                oldrec.attribute15,
                                newrec.attribute15),
     last_update_login = fnd_global.login_id,
     last_update_date  = sysdate,
     last_updated_by   = fnd_global.user_id,
     object_version_number = oldrec.object_version_number + 1
     where user_access_id = oldrec.user_access_id;

Line: 148

END Update_Row;

Line: 153

   select object_version_number
     from cn_user_accesses
    where user_access_id = p_user_access_id
      for update of user_access_id nowait;

Line: 163

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 177

PROCEDURE Delete_Row(p_user_access_id NUMBER) IS
BEGIN
   DELETE from cn_user_accesses
     WHERE user_access_id = p_user_access_id;

Line: 185

END Delete_Row;