APPS.FA_BONUS_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_BONUS_RULE in VARCHAR2,
   X_START_YEAR in NUMBER,
   X_END_YEAR in NUMBER,
   X_BONUS_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_bonus_rates
              where  bonus_rule = X_Bonus_Rule
              and    start_year = X_Start_Year;

Line: 39

   INSERT INTO fa_bonus_rates (
        bonus_rule,
        start_year,
	end_year,
        bonus_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_Bonus_Rule,
	X_Start_Year,
	X_End_Year,
        X_Bonus_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: 104

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

Line: 108

end INSERT_ROW;

Line: 133

        SELECT bonus_rule,
	       start_year,
	       end_year,
               bonus_rate,
               attribute1,
               attribute2,
               attribute3,
               attribute4,
               attribute5,
               attribute6,
               attribute7,
               attribute8,
               attribute9,
               attribute10,
               attribute11,
               attribute12,
               attribute13,
               attribute14,
               attribute15,
               attribute_category_code
         FROM  fa_bonus_rates
               where  bonus_rule = X_Bonus_Rule
               and    start_year = X_Start_Year
	 FOR UPDATE of bonus_rule, start_year NOWAIT;

Line: 165

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

Line: 229

procedure UPDATE_ROW (
   X_BONUS_RULE in VARCHAR2,
   X_START_YEAR in NUMBER,
   X_END_YEAR in NUMBER,
   X_BONUS_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_bonus_rates
   SET  bonus_rule              = X_Bonus_Rule,
        start_year              = X_Start_Year,
        end_year                = X_End_Year,
        bonus_rate              = X_Bonus_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,
	last_update_date	= X_Last_Update_Date,
	last_updated_by		= X_Last_Updated_By,
	last_update_login	= X_Last_Update_Login
   where  bonus_rule = X_Bonus_Rule
   and    start_year = X_Start_Year;

Line: 290

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

Line: 294

end UPDATE_ROW;

Line: 296

procedure DELETE_ROW (
   X_BONUS_RULE in VARCHAR2,
   X_START_YEAR in NUMBER,
   p_log_level_rec    in      fa_api_types.log_level_rec_type default null) is

begin

   DELETE FROM fa_bonus_rates
   where  bonus_rule = X_Bonus_Rule
   and    start_year = X_Start_Year;

Line: 314

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

Line: 318

end DELETE_ROW;

Line: 325

   X_LAST_UPDATE_DATE in DATE,
   X_START_YEAR in NUMBER,
   X_END_YEAR in NUMBER,
   X_BONUS_RATE 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: 352

  db_last_updated_by   number;

Line: 353

  db_last_update_date  date;

Line: 359

  select count(*)
  into   h_record_exists
  from   fa_bonus_rates
  where  bonus_rule = X_Bonus_Rule
  and start_year = X_Start_Year;

Line: 367

     select last_updated_by, last_update_date
     into   db_last_updated_by, db_last_update_date
     from   fa_bonus_rates
     where  bonus_rule = X_Bonus_Rule
     and start_year = X_Start_Year;

Line: 373

     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_bonus_rates_pkg.update_row (
           X_Bonus_Rule			=> X_Bonus_Rule,
           X_Start_Year			=> X_Start_Year,
           X_End_Year			=> X_End_Year,
           X_Bonus_Rate			=> X_Bonus_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: 405

      fa_bonus_rates_pkg.insert_row (
         X_Rowid		      => row_id,
         X_Bonus_Rule                 => X_Bonus_Rule,
         X_Start_Year                 => X_Start_Year,
         X_End_Year                   => X_End_Year,
         X_Bonus_Rate                 => X_Bonus_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: 449

             x_last_update_date         IN DATE,
             x_start_year               IN NUMBER,
             x_end_year                 IN NUMBER,
             x_bonus_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: 479

             x_last_update_date         => x_last_update_date,
             x_start_year               => x_start_year,
             x_end_year                 => x_end_year,
             x_bonus_rate               => x_bonus_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);