APPS.CN_USER_ACCESS_PVT SQL Statements

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

Line: 53

   select count(user_access_id) into l_count
     from cn_user_accesses
    where user_id      = l_newrec.user_id
     and comp_group_id = l_newrec.comp_group_id
     and org_code      = l_newrec.org_code;

Line: 64

   cn_user_access_pkg.insert_row(l_newrec);

Line: 113

PROCEDURE Update_User_Access
  (p_api_version                IN      NUMBER,
   p_init_msg_list              IN      VARCHAR2 := FND_API.G_FALSE,
   p_commit                     IN      VARCHAR2 := FND_API.G_FALSE,
   p_validation_level           IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
   p_rec                        IN      user_access_rec_type,
   x_return_status              OUT NOCOPY     VARCHAR2,
   x_msg_count                  OUT NOCOPY     NUMBER,
   x_msg_data                   OUT NOCOPY     VARCHAR2) IS

   l_api_name                   CONSTANT VARCHAR2(30) := 'Update_User_Access';

Line: 129

   SAVEPOINT   Update_User_Access;

Line: 146

   select count(*) into l_count
     from cn_user_accesses
    where user_access_id = l_newrec.user_access_id;

Line: 151

      FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');

Line: 158

   select count(user_access_id) into l_count
     from cn_user_accesses
    where user_id         = l_newrec.user_id
      and comp_group_id   = l_newrec.comp_group_id
      and org_code        = l_newrec.org_code
      and user_access_id <> l_newrec.user_access_id;

Line: 174

   cn_user_access_pkg.update_row(l_newrec);

Line: 187

      ROLLBACK TO Update_User_Access;

Line: 194

      ROLLBACK TO Update_User_Access;

Line: 201

      ROLLBACK TO Update_User_Access;

Line: 210

END Update_User_Access;

Line: 222

PROCEDURE Delete_User_Access
  (p_api_version                IN      NUMBER,
   p_init_msg_list              IN      VARCHAR2 := FND_API.G_FALSE,
   p_commit                     IN      VARCHAR2 := FND_API.G_FALSE,
   p_validation_level           IN      NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_user_access_id             IN      NUMBER,
   p_object_version_number      IN      NUMBER,
   x_return_status              OUT NOCOPY     VARCHAR2,
   x_msg_count                  OUT NOCOPY     NUMBER,
   x_msg_data                   OUT NOCOPY     VARCHAR2) IS

   l_api_name                   CONSTANT VARCHAR2(30) := 'Delete_User_Access';

Line: 239

   SAVEPOINT   Delete_User_Access;

Line: 256

   select count(*) into l_count
     from cn_user_accesses
    where user_access_id = p_user_access_id;

Line: 270

   cn_user_access_pkg.delete_row(p_user_access_id);

Line: 283

      ROLLBACK TO Delete_User_Access;

Line: 290

      ROLLBACK TO Delete_User_Access;

Line: 297

      ROLLBACK TO Delete_Job_Role;

Line: 306

END Delete_User_Access;

Line: 329

   SELECT DISTINCT f.user_id, p.full_name, f.user_name
     FROM fnd_user_resp_groups fr, fnd_user f,
          fnd_responsibility_vl r, per_all_people_f p
    WHERE f.user_id = fr.user_id
      AND fr.responsibility_id = r.responsibility_id
      AND r.application_id = 283
      AND r.responsibility_key = c_fm_resp_key
      AND f.employee_id = p.person_id(+)
     AND trunc(sysdate) BETWEEN p.effective_start_date(+) AND
      nvl(p.effective_end_date(+), trunc(sysdate))
   ORDER BY 3,2;

Line: 342

     SELECT responsibility_id, responsibility_key
       FROM fnd_responsibility
       WHERE application_id = 283
     AND sysdate BETWEEN start_date AND nvl(end_date, sysdate)
       ;

Line: 407

   SELECT user_access_id, user_id, comp_group_id, org_code, access_code,
	  object_version_number
     FROM cn_user_accesses
    WHERE user_id = p_user_id
    ORDER BY 3,5;