APPS.FA_CEILINGS_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_START_DATE in DATE,
  X_YEAR_OF_LIFE in NUMBER,
  X_END_DATE in DATE,
  X_LIMIT in NUMBER,
  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_ceilings
              WHERE  ceiling_name = X_Ceiling_Name
              AND    start_date   = X_Start_Date
              AND    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);

Line: 41

  INSERT INTO fa_ceilings (
	ceiling_name,
	start_date,
	year_of_life,
	end_date,
	limit,
	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_Name,
	X_Start_Date,
	X_Year_Of_Life,
	X_End_Date,
	X_Limit,
	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: 108

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

Line: 113

end INSERT_ROW;

Line: 139

  CURSOR C is SELECT ceiling_name,
                     start_date,
                     year_of_life,
                     end_date,
                     limit,
                     attribute1,
                     attribute2,
                     attribute3,
                     attribute4,
                     attribute5,
                     attribute6,
                     attribute7,
                     attribute8,
                     attribute9,
                     attribute10,
                     attribute11,
                     attribute12,
                     attribute13,
                     attribute14,
                     attribute15,
                     attribute_category_code
              FROM   fa_ceilings
              WHERE  ceiling_name = X_Ceiling_Name
              AND    start_date   = X_Start_Date
              AND    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999)
              FOR UPDATE of ceiling_name, start_date, year_of_life NOWAIT;

Line: 173

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

Line: 243

procedure UPDATE_ROW (
  X_CEILING_NAME in VARCHAR2,
  X_START_DATE in DATE,
  X_YEAR_OF_LIFE in NUMBER,
  X_END_DATE in DATE,
  X_LIMIT in NUMBER,
  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_ceilings
  SET    ceiling_name = X_Ceiling_Name,
         start_date = X_Start_Date,
         end_date = X_End_Date,
         year_of_life = X_Year_Of_Life,
         limit = X_Limit,
         attribute1 = X_Attribute1,
         attribute2 = X_Attribute2,
         attribute3 = X_Attribute3,
         attribute4 = X_Attribute4,
         attribute5 = X_Attribute5,
         attribute6 = X_Attribute6,
         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,
         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
  AND    start_date   = X_Start_Date
  AND    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);

Line: 307

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

Line: 311

end UPDATE_ROW;

Line: 313

procedure DELETE_ROW (
  X_CEILING_NAME in VARCHAR2,
  X_START_DATE in DATE,
  X_YEAR_OF_LIFE in NUMBER,
  p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

begin

  DELETE FROM fa_ceilings
  WHERE  ceiling_name = X_Ceiling_Name
  AND    start_date   = X_Start_Date
  AND    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);

Line: 333

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

Line: 337

end DELETE_ROW;

Line: 346

  X_LAST_UPDATE_DATE in DATE,
  X_LIMIT in NUMBER,
  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: 371

  db_last_updated_by    number;

Line: 372

  db_last_update_date   date;

Line: 378

  select count(*)
  into   h_record_exists
  from   fa_ceilings
  where  ceiling_name = X_Ceiling_Name
  and    start_date = X_Start_Date
  and    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);

Line: 387

     select last_updated_by, last_update_date
     into   db_last_updated_by, db_last_update_date
     from   fa_ceilings
     where  ceiling_name = X_Ceiling_Name
     and    start_date = X_Start_Date
     and    nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);

Line: 394

     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_ceilings_pkg.update_row (
           X_Ceiling_Name              => X_Ceiling_Name,
           X_Start_Date                => X_Start_Date,
           X_End_Date                  => X_End_Date,
           X_Year_Of_Life              => X_Year_Of_Life,
           X_Limit                     => X_Limit,
           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: 426

     fa_ceilings_pkg.insert_row (
	X_Rowid				=> row_id,
	X_Ceiling_Name			=> X_Ceiling_Name,
	X_Start_Date			=> X_Start_Date,
	X_End_Date			=> X_End_Date,
	X_Year_Of_Life			=> X_Year_Of_Life,
	X_Limit				=> X_Limit,
	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: 474

          x_last_update_date            IN DATE,
          x_limit                       IN NUMBER,
          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: 506

          x_last_update_date            => x_last_update_date,
          x_limit                       => x_limit,
          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);