APPS.FA_ITC_RECAPTURE_RATES_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_ITC_RECAPTURE_ID in NUMBER,
  X_TAX_YEAR in NUMBER,
  X_LIFE_IN_MONTHS in NUMBER,
  X_YEAR_OF_RETIREMENT in NUMBER,
  X_ITC_RECAPTURE_RATE 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_itc_recapture_rates
              WHERE  itc_recapture_id = X_Itc_Recapture_Id;

Line: 39

  INSERT INTO fa_itc_recapture_rates (
	itc_recapture_id,
	tax_year,
	life_in_months,
	year_of_retirement,
	itc_recapture_rate,
	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_Itc_Recapture_Id,
	X_Tax_Year,
	X_Life_In_Months,
	X_Year_Of_Retirement,
	X_Itc_Recapture_Rate,
	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: 106

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

Line: 110

end INSERT_ROW;

Line: 136

      SELECT itc_recapture_id,
             tax_year,
             life_in_months,
             year_of_retirement,
             itc_recapture_rate,
             attribute1,
             attribute2,
             attribute3,
             attribute4,
             attribute5,
             attribute6,
             attribute7,
             attribute8,
             attribute9,
             attribute10,
             attribute11,
             attribute12,
             attribute13,
             attribute14,
             attribute15,
             attribute_category_code
      FROM   fa_itc_recapture_rates
      WHERE  itc_recapture_id = X_Itc_Recapture_Id
      FOR UPDATE of itc_recapture_id NOWAIT;

Line: 168

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

Line: 234

procedure UPDATE_ROW (
  X_ITC_RECAPTURE_ID in NUMBER,
  X_TAX_YEAR in NUMBER,
  X_LIFE_IN_MONTHS in NUMBER,
  X_YEAR_OF_RETIREMENT in NUMBER,
  X_ITC_RECAPTURE_RATE 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_itc_recapture_rates
  SET    itc_recapture_id = X_Itc_Recapture_Id,
         tax_year = X_Tax_Year,
         life_in_months = X_Life_In_Months,
         year_of_retirement = X_Year_Of_Retirement,
         itc_recapture_rate = X_Itc_Recapture_Rate,
         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,
         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  itc_recapture_id = X_Itc_Recapture_Id;

Line: 297

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

Line: 301

end UPDATE_ROW;

Line: 303

procedure DELETE_ROW (
  X_ITC_RECAPTURE_ID in NUMBER
 ,p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

begin

  DELETE FROM fa_itc_recapture_rates
  WHERE  itc_recapture_id = X_Itc_Recapture_Id;

Line: 319

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

Line: 323

end DELETE_ROW;

Line: 329

  X_LAST_UPDATE_DATE in DATE,
  X_TAX_YEAR in NUMBER,
  X_LIFE_IN_MONTHS in NUMBER,
  X_YEAR_OF_RETIREMENT in NUMBER,
  X_ITC_RECAPTURE_RATE 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: 357

  db_last_updated_by    number;

Line: 358

  db_last_update_date   date;

Line: 364

  select count(*)
  into   h_record_exists
  from   fa_itc_recapture_rates
  where  itc_recapture_id = X_Itc_Recapture_Id;

Line: 371

     select last_updated_by, last_update_date
     into   db_last_updated_by, db_last_update_date
     from   fa_itc_recapture_rates
     where  itc_recapture_id = X_Itc_Recapture_Id;

Line: 376

     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_itc_recapture_rates_pkg.update_row (
           X_Itc_Recapture_Id        => X_Itc_Recapture_Id,
           X_Tax_Year                => X_Tax_Year,
           X_Life_In_Months          => X_Life_In_Months,
           X_Year_Of_Retirement      => X_Year_Of_Retirement,
           X_Itc_Recapture_Rate      => X_Itc_Recapture_Rate,
           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: 408

     fa_itc_recapture_rates_pkg.insert_row (
	X_Rowid				=> row_id,
	X_Itc_Recapture_Id		=> X_Itc_Recapture_Id,
	X_Tax_Year			=> X_Tax_Year,
	X_Life_In_Months		=> X_Life_In_Months,
	X_Year_Of_Retirement		=> X_Year_Of_Retirement,
	X_Itc_Recapture_Rate		=> X_Itc_Recapture_Rate,
	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: 453

          x_last_update_date            IN DATE,
          x_tax_year                    IN NUMBER,
          x_life_in_months              IN NUMBER,
          x_year_of_retirement          IN NUMBER,
          x_itc_recapture_rate          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: 485

          x_last_update_date            => x_last_update_date,
          x_tax_year                    => x_tax_year,
          x_life_in_months              => x_life_in_months,
          x_year_of_retirement          => x_year_of_retirement,
          x_itc_recapture_rate          => x_itc_recapture_rate,
          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);