eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_FLAT_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_METHOD_ID in NUMBER,
   X_BASIC_RATE in NUMBER,
   X_ADJUSTED_RATE in NUMBER,
   X_ADJUSTING_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_flat_rates
              where  method_id = X_Method_Id
              and    basic_rate = X_Basic_Rate
              and    adjusted_rate = X_Adjusted_Rate;

Line: 40


   INSERT INTO fa_flat_rates (
	method_id,
	basic_rate,
	adjusted_rate,
	adjusting_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_Method_ID,
        X_Basic_Rate,
        X_Adjusted_Rate,
        X_Adjusting_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: 105


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

Line: 109


end INSERT_ROW;

Line: 134


      	SELECT method_id,
               basic_rate,
               adjusted_rate,
               adjusting_rate,
               attribute1,
               attribute2,
               attribute3,
               attribute4,
               attribute5,
               attribute6,
               attribute7,
               attribute8,
               attribute9,
               attribute10,
               attribute11,
               attribute12,
               attribute13,
               attribute14,
               attribute15,
               attribute_category_code
         FROM  fa_flat_rates
         where  method_id = X_Method_Id
         and    basic_rate = X_Basic_Rate
         and    adjusted_rate = X_Adjusted_Rate
	 FOR UPDATE of method_id, basic_rate, adjusted_rate NOWAIT;

Line: 167


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

Line: 229


procedure UPDATE_ROW (
   X_METHOD_ID in NUMBER,
   X_BASIC_RATE in NUMBER,
   X_ADJUSTED_RATE in NUMBER,
   X_ADJUSTING_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_flat_rates
   SET  method_id		= X_Method_ID,
	basic_rate		= X_Basic_Rate,
	adjusted_rate		= X_Adjusted_Rate,
	adjusting_rate		= X_Adjusting_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
   where  method_id = X_Method_Id
   and    basic_rate = X_Basic_Rate
   and    adjusted_rate = X_Adjusted_Rate;

Line: 288


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

Line: 292


end UPDATE_ROW;

Line: 294


procedure DELETE_ROW (
   X_METHOD_ID in NUMBER,
   X_BASIC_RATE in NUMBER,
   X_ADJUSTED_RATE in NUMBER,
   p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) is

begin

   DELETE FROM fa_flat_rates
   where  method_id = X_Method_Id
   and    basic_rate = X_Basic_Rate
   and    adjusted_rate = X_Adjusted_Rate;

Line: 314


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

Line: 318


end DELETE_ROW;

Line: 323


   X_DB_LAST_UPDATED_BY NUMBER,
   X_DB_LAST_UPDATE_DATE DATE,
   X_OWNER in VARCHAR2,
   X_LAST_UPDATE_DATE in DATE,
   X_BASIC_RATE in NUMBER,
   X_ADJUSTING_RATE in NUMBER,
   X_ADJUSTED_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


   select count(*)
   into   h_record_exists
   from   fa_flat_rates fr
   where  fr.method_id = X_Method_Id
   and    fr.basic_rate = X_Basic_Rate
   and    fr.adjusted_rate = X_Adjusted_Rate;

Line: 365


      if (fnd_load_util.upload_test(user_id, x_last_update_date,
                                    x_db_last_updated_by,x_db_last_update_date,
                                    X_CUSTOM_MODE )) then

         fa_flat_rates_pkg.update_row (
            X_Method_Id	                 => X_Method_Id,
            X_Basic_Rate                 => X_Basic_Rate,
            X_Adjusted_Rate              => X_Adjusted_Rate,
            X_Adjusting_Rate             => X_Adjusting_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: 398


      fa_flat_rates_pkg.insert_row (
         X_Rowid		      => row_id,
         X_Method_Id                  => X_Method_Id,
         X_Basic_Rate                 => X_Basic_Rate,
         X_Adjusted_Rate              => X_Adjusted_Rate,
         X_Adjusting_Rate             => X_Adjusting_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: 443


               x_last_update_date        IN DATE,
               x_basic_rate              IN NUMBER,
               x_adjusting_rate          IN NUMBER,
               x_adjusted_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

   methods_err           exception;

Line: 467


   h_last_update_date    date;

Line: 468


   h_last_updated_by     number;

Line: 489


      h_last_update_date := fa_cache_pkg.fazccmt_record.last_update_date;

Line: 490


      h_last_updated_by := fa_cache_pkg.fazccmt_record.last_updated_by;

Line: 509


               x_db_last_update_date     => h_last_update_date,
               x_db_last_updated_by      => h_last_updated_by,
               x_owner                   => x_owner,
               x_last_update_date        => x_last_update_date,
               x_basic_rate              => x_basic_rate,
               x_adjusting_rate          => x_adjusting_rate,
               x_adjusted_rate           => x_adjusted_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
               ,p_log_level_rec => p_log_level_rec);