APPS.FA_CEILING_TYPES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_CEILING_NAME in VARCHAR2,
  X_CEILING_TYPE in VARCHAR2,
  X_CURRENCY_CODE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

  CURSOR C is SELECT rowid FROM fa_ceiling_types
              WHERE  ceiling_name = X_Ceiling_Name;

Line: 37

  INSERT INTO fa_ceiling_types (
	ceiling_type,
	ceiling_name,
	currency_code,
	description,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute_category_code,
	creation_date,
	created_by,
	last_update_date,
	last_updated_by,
	last_update_login
  ) VALUES (
	X_Ceiling_Type,
	X_Ceiling_Name,
	X_Currency_Code,
	X_Description,
	X_Attribute1,
	X_Attribute2,
	X_Attribute3,
	X_Attribute4,
	X_Attribute5,
	X_Attribute6,
	X_Attribute7,
	X_Attribute8,
	X_Attribute9,
	X_Attribute10,
	X_Attribute11,
	X_Attribute12,
	X_Attribute13,
	X_Attribute14,
	X_Attribute15,
	X_Attribute_Category_Code,
	X_Creation_Date,
	X_Created_By,
	X_Last_Update_Date,
	X_Last_Updated_By,
	X_Last_Update_Login
  );

Line: 102

                calling_fn => 'fa_ceiling_types_pkg.insert_row'
                ,p_log_level_rec => p_log_level_rec);

Line: 106

end INSERT_ROW;

Line: 131

      SELECT ceiling_name,
             ceiling_type,
             currency_code,
             description,
             attribute1,
             attribute2,
             attribute3,
             attribute4,
             attribute5,
             attribute6,
             attribute7,
             attribute8,
             attribute9,
             attribute10,
             attribute11,
             attribute12,
             attribute13,
             attribute14,
             attribute15,
             attribute_category_code
      FROM   fa_ceiling_types
      WHERE  ceiling_name = X_Ceiling_Name
      FOR UPDATE of ceiling_name NOWAIT;

Line: 162

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 227

procedure UPDATE_ROW (
  X_CEILING_NAME in VARCHAR2,
  X_CEILING_TYPE in VARCHAR2,
  X_CURRENCY_CODE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

begin

  UPDATE fa_ceiling_types
  SET    ceiling_name = X_Ceiling_Name,
         ceiling_type = X_Ceiling_Type,
         currency_code = X_Currency_Code,
         description = X_Description,
         attribute1 = X_Attribute1,
         attribute2 = X_Attribute2,
         attribute3 = X_Attribute3,
         attribute4 = X_Attribute4,
         attribute5 = X_Attribute5,
         attribute6 = X_Attribute5,
         attribute7 = X_Attribute7,
         attribute8 = X_Attribute8,
         attribute9 = X_Attribute9,
         attribute10 = X_Attribute10,
         attribute11 = X_Attribute11,
         attribute12 = X_Attribute12,
         attribute13 = X_Attribute13,
         attribute14 = X_Attribute14,
         attribute15 = X_Attribute15,
         attribute_category_code = X_Attribute_Category_Code,
         last_update_date = X_Last_Update_Date,
         last_updated_by = X_Last_Updated_By,
         last_update_login = X_Last_Update_Login
  WHERE  ceiling_name = X_Ceiling_Name;

Line: 288

                calling_fn => 'fa_ceiling_types_pkg.update_row'
                ,p_log_level_rec => p_log_level_rec);

Line: 292

end UPDATE_ROW;

Line: 294

procedure DELETE_ROW (
  X_CEILING_NAME in VARCHAR2
 ,p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

begin

  DELETE FROM fa_ceiling_types
  WHERE  ceiling_name = X_Ceiling_Name;

Line: 310

                calling_fn => 'fa_ceiling_types_pkg.delete_row'
                ,p_log_level_rec => p_log_level_rec);

Line: 314

end DELETE_ROW;

Line: 321

  X_LAST_UPDATE_DATE in DATE,
  X_CURRENCY_CODE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
  p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) is

  h_record_exists       number(15);

Line: 347

  db_last_updated_by    number;

Line: 348

  db_last_update_date   date;

Line: 354

  select count(*)
  into h_record_exists
  from fa_ceiling_types
  where ceiling_name = X_Ceiling_Name;

Line: 361

     select last_updated_by, last_update_date
     into   db_last_updated_by, db_last_update_date
     from fa_ceiling_types
     where ceiling_name = X_Ceiling_Name;

Line: 366

     if (fnd_load_util.upload_test(user_id, x_last_update_date,
                                   db_last_updated_by, db_last_update_date,
                                   X_CUSTOM_MODE)) then

        fa_ceiling_types_pkg.update_row (
           X_Ceiling_Type              => X_Ceiling_Type,
           X_Ceiling_Name              => X_Ceiling_Name,
           X_Currency_Code             => X_Currency_Code,
           X_Description               => X_Description,
           X_Attribute1                => X_Attribute1,
           X_Attribute2                => X_Attribute2,
           X_Attribute3                => X_Attribute3,
           X_Attribute4                => X_Attribute4,
           X_Attribute5                => X_Attribute5,
           X_Attribute6                => X_Attribute6,
           X_Attribute7                => X_Attribute7,
           X_Attribute8                => X_Attribute8,
           X_Attribute9                => X_Attribute9,
           X_Attribute10               => X_Attribute10,
           X_Attribute11               => X_Attribute11,
           X_Attribute12               => X_Attribute12,
           X_Attribute13               => X_Attribute13,
           X_Attribute14               => X_Attribute14,
           X_Attribute15               => X_Attribute15,
           X_Attribute_Category_Code   => X_Attribute_Category_Code,
           X_Last_Update_Date		=> sysdate,
           X_Last_Updated_By		=> user_id,
           X_Last_Update_Login		=> 0
           ,p_log_level_rec => p_log_level_rec);

Line: 397

     fa_ceiling_types_pkg.insert_row (
	X_Rowid				=> row_id,
	X_Ceiling_Type			=> X_Ceiling_Type,
	X_Ceiling_Name			=> X_Ceiling_Name,
	X_Currency_Code			=> X_Currency_Code,
	X_Description			=> X_Description,
	X_Attribute1			=> X_Attribute1,
	X_Attribute2			=> X_Attribute2,
	X_Attribute3			=> X_Attribute3,
	X_Attribute4			=> X_Attribute4,
	X_Attribute5			=> X_Attribute5,
	X_Attribute6			=> X_Attribute6,
	X_Attribute7			=> X_Attribute7,
	X_Attribute8			=> X_Attribute8,
	X_Attribute9			=> X_Attribute9,
	X_Attribute10			=> X_Attribute10,
	X_Attribute11			=> X_Attribute11,
	X_Attribute12			=> X_Attribute12,
	X_Attribute13			=> X_Attribute13,
	X_Attribute14			=> X_Attribute14,
	X_Attribute15			=> X_Attribute15,
	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
	X_Creation_Date			=> sysdate,
	X_Created_By			=> user_id,
	X_Last_Update_Date		=> sysdate,
	X_Last_Updated_By		=> user_id,
	X_Last_Update_Login		=> 0
	,p_log_level_rec => p_log_level_rec);

Line: 442

          x_last_update_date            IN DATE,
          x_currency_code               IN VARCHAR2,
          x_description                 IN VARCHAR2,
          x_attribute1                  IN VARCHAR2,
          x_attribute2                  IN VARCHAR2,
          x_attribute3                  IN VARCHAR2,
          x_attribute4                  IN VARCHAR2,
          x_attribute5                  IN VARCHAR2,
          x_attribute6                  IN VARCHAR2,
          x_attribute7                  IN VARCHAR2,
          x_attribute8                  IN VARCHAR2,
          x_attribute9                  IN VARCHAR2,
          x_attribute10                 IN VARCHAR2,
          x_attribute11                 IN VARCHAR2,
          x_attribute12                 IN VARCHAR2,
          x_attribute13                 IN VARCHAR2,
          x_attribute14                 IN VARCHAR2,
          x_attribute15                 IN VARCHAR2,
          x_attribute_category_code     IN VARCHAR2) IS


BEGIN

      if (x_upload_mode = 'NLS') then
         null;

Line: 473

          x_last_update_date            => x_last_update_date,
          x_currency_code               => x_currency_code,
          x_description                 => x_description,
          x_attribute1                  => x_attribute1,
          x_attribute2                  => x_attribute2,
          x_attribute3                  => x_attribute3,
          x_attribute4                  => x_attribute4,
          x_attribute5                  => x_attribute5,
          x_attribute6                  => x_attribute6,
          x_attribute7                  => x_attribute7,
          x_attribute8                  => x_attribute8,
          x_attribute9                  => x_attribute9,
          x_attribute10                 => x_attribute10,
          x_attribute11                 => x_attribute11,
          x_attribute12                 => x_attribute12,
          x_attribute13                 => x_attribute13,
          x_attribute14                 => x_attribute14,
          x_attribute15                 => x_attribute15,
          x_attribute_category_code     => x_attribute_category_code);