APPS.CN_QUOTA_CATEGORIES_PUB SQL Statements

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

Line: 23

   G_LAST_UPDATE_DATE        DATE    := sysdate;

Line: 24

   G_LAST_UPDATED_BY         NUMBER  := fnd_global.user_id;

Line: 27

   G_LAST_UPDATE_LOGIN       NUMBER  := fnd_global.login_id;

Line: 51

   SELECT count(quota_category_id)
  INTO l_count
  FROM cn_quota_categories
    WHERE UPPER(name) = UPPER(l_newrec.name);

Line: 61

   cn_quota_categories_pkg.insert_row(l_newrec);

Line: 98

PROCEDURE Update_Quota_Category(
  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      quota_category_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_Quota_Category';

Line: 114

   G_LAST_UPDATE_DATE        DATE    := sysdate;

Line: 115

   G_LAST_UPDATED_BY         NUMBER  := fnd_global.user_id;

Line: 116

   G_LAST_UPDATE_LOGIN       NUMBER  := fnd_global.login_id;

Line: 120

   SAVEPOINT   Update_Quota_Category;

Line: 137

   SELECT count(quota_category_id)
     INTO l_count
     FROM cn_quota_categories
    WHERE quota_category_id = p_rec.quota_category_id;

Line: 142

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

Line: 149

   SELECT count(quota_category_id)
     INTO l_count
     FROM cn_role_quota_cates
    WHERE quota_category_id = p_rec.quota_category_id;

Line: 155

     SELECT NAME
      INTO l_old_name
     FROM cn_quota_categories
     WHERE quota_category_id = p_rec.quota_category_id;

Line: 176

   cn_quota_categories_pkg.lock_update_row(l_newrec);

Line: 189

   ROLLBACK TO Update_Quota_Category;

Line: 196

      ROLLBACK TO Update_Quota_Category;

Line: 203

      ROLLBACK TO Update_Quota_Category;

Line: 212

END Update_Quota_Category;

Line: 214

PROCEDURE Delete_Quota_Category(
  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_quota_category_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_Quota_Category';

Line: 232

   SAVEPOINT Delete_Quota_Category;

Line: 247

   SELECT count(quota_category_id)
     INTO l_count
     FROM cn_quota_categories
    WHERE quota_category_id = p_quota_category_id;

Line: 252

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

Line: 258

   SELECT count(quota_category_id)
     INTO l_count
     FROM cn_role_quota_cates
    WHERE quota_category_id = p_quota_category_id;

Line: 264

       SELECT NAME
       INTO qc_name
       FROM CN_QUOTA_CATEGORIES
       WHERE quota_category_id = p_quota_category_id;

Line: 276

   cn_quota_categories_pkg.delete_row(p_quota_category_id);

Line: 289

   ROLLBACK TO Delete_Quota_Category;

Line: 296

      ROLLBACK TO Delete_Quota_Category;

Line: 303

      ROLLBACK TO Delete_Quota_Category;

Line: 312

END Delete_Quota_Category;

Line: 342

    SELECT cn_cat.quota_CATEGORY_ID,
      cn_cat.name ,
      cn_cat.description ,
      cn_cat.type ,
      Nvl(cn_cat.compute_flag,'N') compute_flag,
      cn_cat.object_version_number,
            cn_cat.interval_type_id,
            cn_cat.quota_unit_code
      FROM cn_quota_categories cn_cat
           WHERE upper(name) like upper(p_search_name)
             AND type = p_search_type
             AND quota_unit_code = p_search_unit
      ORDER BY name;

Line: 420

   SELECT meaning INTO x_quota_categories_tbl(l_counter).computed
     FROM fnd_lookups
     WHERE lookup_code = quota_categories_rec.compute_flag
     AND lookup_type = 'YES_NO';