APPS.FA_PERIOD_MAPS_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_QUARTER in NUMBER,
  X_QTR_FIRST_PERIOD in NUMBER,
  X_QTR_LAST_PERIOD in NUMBER,
  X_YEAR_FIRST_PERIOD in NUMBER,
  X_YEAR_LAST_PERIOD in NUMBER,
  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_period_maps
              WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);

Line: 23

  INSERT INTO fa_period_maps (
	quarter,
	qtr_first_period,
	qtr_last_period,
	year_first_period,
	year_last_period,
	created_by,
	creation_date,
	last_updated_by,
	last_update_date,
	last_update_login
  ) VALUES (
	X_Quarter,
	X_Qtr_First_Period,
	X_Qtr_Last_Period,
	X_Year_First_Period,
	X_Year_Last_Period,
	X_Created_By,
	X_Creation_Date,
	X_Last_Updated_By,
	X_Last_Update_Date,
	X_Last_Update_Login
  );

Line: 58

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

Line: 62

end INSERT_ROW;

Line: 72

      SELECT quarter,
             qtr_first_period,
             qtr_last_period,
             year_first_period,
             year_last_period
      FROM   fa_period_maps
      WHERE  nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999)
      FOR UPDATE of year_last_period NOWAIT;

Line: 88

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

Line: 116

procedure UPDATE_ROW (
  X_QUARTER in NUMBER,
  X_QTR_FIRST_PERIOD in NUMBER,
  X_QTR_LAST_PERIOD in NUMBER,
  X_YEAR_FIRST_PERIOD in NUMBER,
  X_YEAR_LAST_PERIOD 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

begin

  UPDATE fa_period_maps
  SET	 quarter		= X_Quarter,
	 qtr_first_period	= X_Qtr_First_Period,
	 qtr_last_period	= X_Qtr_Last_Period,
	 year_first_period	= X_Year_First_Period,
	 year_last_period	= X_Year_Last_Period,
	 last_update_date	= X_Last_Update_Date,
	 last_updated_by	= X_Last_Updated_By,
	 last_update_login	= X_Last_Update_Login
  WHERE  nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);

Line: 147

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

Line: 151

end UPDATE_ROW;

Line: 153

procedure DELETE_ROW (
  X_YEAR_LAST_PERIOD in NUMBER,
  p_log_level_rec  IN FA_API_TYPES.log_level_rec_type default null) is

begin

  DELETE FROM fa_period_maps
  WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);

Line: 169

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

Line: 173

end DELETE_ROW;

Line: 178

  X_LAST_UPDATE_DATE in DATE,
  X_QUARTER in NUMBER,
  X_QTR_FIRST_PERIOD in NUMBER,
  X_QTR_LAST_PERIOD in NUMBER,
  X_YEAR_FIRST_PERIOD in NUMBER,
  X_YEAR_LAST_PERIOD in NUMBER,
  p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) is

  h_record_exists	number(15);

Line: 191

  db_last_updated_by    number;

Line: 192

  db_last_update_date   date;

Line: 198

  select count(*)
  into   h_record_exists
  from   fa_period_maps pm
  where  nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);

Line: 205

     select last_updated_by, last_update_date
     into   db_last_updated_by, db_last_update_date
     from   fa_period_maps pm
     where  nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);

Line: 210

     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_period_maps_pkg.update_row (
           X_Quarter		=> X_Quarter,
           X_Qtr_First_Period	=> X_Qtr_First_Period,
           X_Qtr_Last_Period	=> X_Qtr_Last_Period,
           X_Year_First_Period	=> X_Year_First_Period,
           X_Year_Last_Period	=> X_Year_Last_Period,
           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: 226

     fa_period_maps_pkg.insert_row (
	X_Rowid			=> row_id,
	X_Quarter		=> X_Quarter,
	X_Qtr_First_Period	=> X_Qtr_First_Period,
	X_Qtr_Last_Period	=> X_Qtr_Last_Period,
	X_Year_First_Period	=> X_Year_First_Period,
	X_Year_Last_Period	=> X_Year_Last_Period,
	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: 254

          x_last_update_date            IN DATE,
          x_quarter                     IN NUMBER,
          x_qtr_first_period            IN NUMBER,
          x_qtr_last_period             IN NUMBER,
          x_year_first_period           IN NUMBER,
          x_year_last_period            IN NUMBER) IS


BEGIN

      if (x_upload_mode = 'NLS') then
         null;

Line: 270

          x_last_update_date            => x_last_update_date,
          x_quarter                     => x_quarter,
          x_qtr_first_period            => x_qtr_first_period,
          x_qtr_last_period             => x_qtr_last_period,
          x_year_first_period           => x_year_first_period,
          x_year_last_period            => x_year_last_period);