APPS.FA_DEPRN_RULE_DETAILS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  PROCEDURE Insert_Row(
			p_deprn_rule_detail_id		IN OUT NOCOPY NUMBER,
			p_deprn_basis_rule_id		IN OUT NOCOPY NUMBER,
			p_rule_name			VARCHAR2,
			p_rate_source_rule		VARCHAR2,
			p_deprn_basis_rule		VARCHAR2,
         p_asset_type                    VARCHAR2,
         p_period_update_flag            VARCHAR2,
         p_subtract_ytd_flag             VARCHAR2,
         p_allow_reduction_rate_flag     VARCHAR2,
         p_use_eofy_reserve_flag         VARCHAR2,
			p_last_update_date		DATE,
			p_last_updated_by		NUMBER,
			p_created_by			NUMBER,
			p_creation_date		DATE,
			p_last_update_login	NUMBER,
         p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS
   CURSOR C is SELECT FA_DEPRN_RULE_DETAILS_S.nextval from sys.dual;

Line: 24

    select deprn_basis_rule_id
    from   FA_DEPRN_BASIS_RULES
    where  rule_name = p_rule_name;

Line: 30

     select nvl(max(deprn_rule_detail_id),0)+1
     from   FA_DEPRN_RULE_DETAILS;

Line: 53

    Insert into fa_deprn_rule_details (
        deprn_rule_detail_id,
	     deprn_basis_rule_id,
	     rule_name,
        rate_source_rule,
        deprn_basis_rule,
        asset_type,
        period_update_flag,
        subtract_ytd_flag,
        allow_reduction_rate_flag,
        use_eofy_reserve_flag,
	     last_update_date,
	     last_updated_by,
	     created_by,
	     creation_date,
	     last_update_login
	)
    values (
        p_deprn_rule_detail_id,
	     p_deprn_basis_rule_id,
	     p_rule_name,
        p_rate_source_rule,
        p_deprn_basis_rule,
        p_asset_type,
        p_period_update_flag,
        p_subtract_ytd_flag,
        p_allow_reduction_rate_flag,
        p_use_eofy_reserve_flag,
	     p_last_update_date,
	     p_last_updated_by,
	     p_created_by,
	     p_creation_date,
	     p_last_update_login
	);

Line: 92

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

Line: 95

  END Insert_Row;

Line: 104

         p_period_update_flag            VARCHAR2,
         p_subtract_ytd_flag             VARCHAR2,
         p_allow_reduction_rate_flag     VARCHAR2,
         p_use_eofy_reserve_flag          VARCHAR2,
			p_last_update_date		DATE,
			p_last_updated_by		NUMBER,
			p_last_update_login		NUMBER,
         p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS
   CURSOR C IS
	Select deprn_rule_detail_id,
        	deprn_basis_rule_id,
        	rule_name,
         rate_source_rule,
         deprn_basis_rule,
         asset_type,
         period_update_flag,
         subtract_ytd_flag,
         allow_reduction_rate_flag,
         use_eofy_reserve_flag,
        	last_update_date,
        	last_updated_by,
        	last_update_login
	from 	FA_DEPRN_RULE_DETAILS
	Where rule_name = p_rule_name
   and   rate_source_rule = p_rate_source_rule
   and   deprn_basis_rule = p_deprn_basis_rule
	for update of deprn_basis_rule_id nowait;

Line: 141

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

Line: 153

        AND     (Recinfo.period_update_flag = p_period_update_flag)
        AND     (Recinfo.subtract_ytd_flag = p_subtract_ytd_flag)
        AND     (Recinfo.allow_reduction_rate_flag
                                    = p_allow_reduction_rate_flag)
        AND     (Recinfo.use_eofy_reserve_flag = p_use_eofy_reserve_flag)) then
	return;

Line: 165

  PROCEDURE Update_Row(
			p_deprn_rule_detail_id		NUMBER,
			p_deprn_basis_rule_id		NUMBER,
			p_rule_name			VARCHAR2,
			p_rate_source_rule		VARCHAR2,
			p_deprn_basis_rule		VARCHAR2,
         p_asset_type                    VARCHAR2,
         p_period_update_flag            VARCHAR2,
         p_subtract_ytd_flag             VARCHAR2,
         p_allow_reduction_rate_flag     VARCHAR2,
         p_use_eofy_reserve_flag          VARCHAR2,
			p_last_update_date		DATE,
			p_last_updated_by		NUMBER,
			p_last_update_login		NUMBER,
        p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS

  BEGIN

    UPDATE FA_DEPRN_RULE_DETAILS
    SET
        asset_type                =       p_asset_type,
        period_update_flag        =       p_period_update_flag,
        subtract_ytd_flag         =       p_subtract_ytd_flag,
        allow_reduction_rate_flag =       p_allow_reduction_rate_flag,
        use_eofy_reserve_flag     =       p_use_eofy_reserve_flag,
	last_update_date	  =	  p_last_update_date,
	last_updated_by		  =	  p_last_updated_by,
	last_update_login	  =	  p_last_update_login
    WHERE deprn_rule_detail_id    =       p_deprn_rule_detail_id;

Line: 202

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

Line: 205

  END Update_Row;

Line: 207

  PROCEDURE Delete_Row(p_deprn_rule_detail_id 	NUMBER,
                       p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS
  BEGIN

    DELETE FROM fa_deprn_rule_details
    WHERE deprn_rule_detail_id = p_deprn_rule_detail_id;

Line: 221

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

Line: 224

  END DELETE_ROW;

Line: 230

             p_last_update_date          IN DATE,
             p_deprn_basis_rule_id       IN NUMBER,
             p_rule_name                 IN VARCHAR2,
             p_rate_source_rule          IN VARCHAR2,
             p_deprn_basis_rule          IN VARCHAR2,
             p_asset_type                IN VARCHAR2,
             p_period_update_flag        IN VARCHAR2,
             p_subtract_ytd_flag         IN VARCHAR2,
             p_allow_reduction_rate_flag IN VARCHAR2,
             p_use_eofy_reserve_flag     IN VARCHAR2,
             p_log_level_rec             IN FA_API_TYPES.log_level_rec_type
                                            default null ) IS



  h_record_exists		number(15);

Line: 250

  db_last_updated_by   number;

Line: 251

  db_last_update_date  date;

Line: 257

    select count(*)
    into   h_record_exists
    from   fa_deprn_rule_details
    where  rule_name = p_rule_name
    and    rate_source_rule = p_rate_source_rule
    and    deprn_basis_rule = p_deprn_basis_rule;

Line: 266

       select last_updated_by, last_update_date
       into   db_last_updated_by, db_last_update_date
       from   fa_deprn_rule_details
       where  rule_name = p_rule_name
       and    rate_source_rule = p_rate_source_rule
       and    deprn_basis_rule = p_deprn_basis_rule;

Line: 273

       if (fnd_load_util.upload_test(user_id, p_last_update_date,
                                     db_last_updated_by, db_last_update_date,
                                     P_CUSTOM_MODE)) then

          fa_deprn_rule_details_pkg.update_row (
             p_deprn_rule_detail_id          => p_deprn_rule_detail_id,
             p_deprn_basis_rule_id           => p_deprn_basis_rule_id,
	     p_rule_name		     => p_rule_name,
	     p_rate_source_rule		     => p_rate_source_rule,
	     p_deprn_basis_rule		     => p_deprn_basis_rule,
             p_asset_type                    => p_asset_type,
             p_period_update_flag            => p_period_update_flag,
             p_subtract_ytd_flag             => p_subtract_ytd_flag,
             p_allow_reduction_rate_flag     => p_allow_reduction_rate_flag,
             p_use_eofy_reserve_flag         => p_use_eofy_reserve_flag,
             p_last_update_date		     => sysdate,
	     p_last_updated_by               => user_id,
	     p_last_update_login             => 0,
             p_log_level_rec => p_log_level_rec);

Line: 299

       fa_deprn_rule_details_pkg.insert_row (
	            p_deprn_rule_detail_id      => h_deprn_rule_detail_id,
	            p_deprn_basis_rule_id	=> h_deprn_basis_rule_id,
	            p_rule_name			=> p_rule_name,
	            p_rate_source_rule		=> p_rate_source_rule,
	            p_deprn_basis_rule		=> p_deprn_basis_rule,
                    p_asset_type                => p_asset_type,
                    p_period_update_flag        => p_period_update_flag,
                    p_subtract_ytd_flag         => p_subtract_ytd_flag,
                    p_allow_reduction_rate_flag => p_allow_reduction_rate_flag,
                    p_use_eofy_reserve_flag     => p_use_eofy_reserve_flag,
	            p_last_update_date		=> sysdate,
	            p_last_updated_by		=> user_id,
	            p_created_by		=> user_id,
	            p_creation_date		=> sysdate,
	            p_last_update_login		=> 0,
                    p_log_level_rec => p_log_level_rec);

Line: 332

               p_last_update_date           IN DATE,
               p_deprn_basis_rule_id        IN NUMBER,
               p_rule_name                  IN VARCHAR2,
               p_rate_source_rule           IN VARCHAR2,
               p_deprn_basis_rule           IN VARCHAR2,
               p_asset_type                 IN VARCHAR2,
               p_period_update_flag         IN VARCHAR2,
               p_subtract_ytd_flag          IN VARCHAR2,
               p_allow_reduction_rate_flag  IN VARCHAR2,
               p_use_eofy_reserve_flag      IN VARCHAR2) IS



BEGIN

        if (p_upload_mode = 'NLS') then
           null;

Line: 354

               p_last_update_date           => p_last_update_date,
               p_deprn_basis_rule_id        => p_deprn_basis_rule_id,
               p_rule_name                  => p_rule_name,
               p_rate_source_rule           => p_rate_source_rule,
               p_deprn_basis_rule           => p_deprn_basis_rule,
               p_asset_type                 => p_asset_type,
               p_period_update_flag         => p_period_update_flag,
               p_subtract_ytd_flag          => p_subtract_ytd_flag,
               p_allow_reduction_rate_flag  => p_allow_reduction_rate_flag,
               p_use_eofy_reserve_flag      => p_use_eofy_reserve_flag);