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_DEPRN_BASIS_RULES_PKG SQL Statements

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

Line: 4


  PROCEDURE Insert_Row(	X_deprn_basis_rule_id		IN OUT NOCOPY NUMBER,
			X_rule_name			VARCHAR2,
			X_user_rule_name		VARCHAR2,
			X_last_update_date		DATE,
			X_last_updated_by		NUMBER,
			X_created_by			NUMBER,
			X_creation_date			DATE,
			X_last_update_login		NUMBER,
			X_rate_source			VARCHAR2,
			X_calculation_basis	VARCHAR2,
			X_enabled_flag			VARCHAR2,
			X_program_name			VARCHAR2,
         X_description        VARCHAR2,
         p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS
   CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;

Line: 22


     select nvl(max(deprn_basis_rule_id),0)+1
     from   FA_DEPRN_BASIS_RULES;

Line: 40


    Insert into fa_deprn_basis_rules (
	deprn_basis_rule_id,
	rule_name,
	user_rule_name,
	last_update_date,
	last_updated_by,
	created_by,
	creation_date,
	last_update_login,
	rate_source,
	deprn_basis,
	enabled_flag,
	program_name,
        description
	)
   values (
	X_deprn_basis_rule_id,
	X_rule_name,
	X_user_rule_name,
	X_last_update_date,
	X_last_updated_by,
	X_created_by,
	X_creation_date,
	X_last_update_login,
	X_rate_source,
	X_calculation_basis,
	X_enabled_flag,
	X_program_name,
        X_description
	);

Line: 75


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

Line: 78


  END Insert_Row;

Line: 83


			X_last_update_date	DATE,
			X_last_updated_by		NUMBER,
			X_last_update_login	NUMBER,
			X_rate_source			VARCHAR2,
			X_calculation_basis	VARCHAR2,
			X_enabled_flag			VARCHAR2,
			X_program_name			VARCHAR2,
         X_description        VARCHAR2,
         p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS
   CURSOR C IS
	Select	deprn_basis_rule_id,
		rule_name,
		user_rule_name,
		last_update_date,
		last_updated_by,
		last_update_login,
		rate_source,
		deprn_basis,
		enabled_flag,
		program_name,
                description
	from 	FA_DEPRN_BASIS_RULES
	Where 	DEPRN_BASIS_RULE_ID = x_deprn_basis_rule_id
	for update of deprn_basis_rule_id nowait;

Line: 117


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

Line: 140


  PROCEDURE Update_Row( X_deprn_basis_rule_id		NUMBER,
			X_rule_name			   VARCHAR2,
			X_user_rule_name		VARCHAR2,
			X_last_update_date	DATE,
			X_last_updated_by		NUMBER,
			X_last_update_login	NUMBER,
			X_rate_source			VARCHAR2,
			X_calculation_basis	VARCHAR2,
			X_enabled_flag			VARCHAR2,
			X_program_name			VARCHAR2,
         X_description        VARCHAR2,
         p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null) IS

  BEGIN

    UPDATE FA_DEPRN_BASIS_RULES
    SET
	rule_name		=	X_rule_name,
	user_rule_name		=	X_user_rule_name,
	last_update_date	=	X_last_update_date,
	last_updated_by		=	X_last_updated_by,
	last_update_login	=	X_last_update_login,
	rate_source		=	X_rate_source,
	deprn_basis		=	X_calculation_basis,
	enabled_flag		=	X_enabled_flag,
	program_name		=	X_program_name,
        description             =       X_description
    WHERE deprn_basis_rule_id = X_deprn_basis_rule_id;

Line: 176


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

Line: 179


  END Update_Row;

Line: 181


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

    h_count number;

Line: 187


    DELETE FROM fa_deprn_basis_rules
    WHERE deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 194


    select count(*)
    into   h_count
    from   FA_DEPRN_RULE_DETAILS
    where  deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 200


      DELETE from fa_deprn_rule_details
      WHERE deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 208


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

Line: 211


  END DELETE_ROW;

Line: 216


                      X_last_update_date    IN DATE,
                      X_rule_name           IN VARCHAR2,
                      X_user_rule_name      IN VARCHAR2 DEFAULT NULL,
                      X_rate_source         IN VARCHAR2 DEFAULT NULL,
                      X_calculation_basis   IN VARCHAR2 DEFAULT NULL,
                      X_enabled_flag        IN VARCHAR2,
                      X_program_name        IN VARCHAR2,
                      X_description         IN VARCHAR2 DEFAULT NULL,
                      p_log_level_rec       IN FA_API_TYPES.log_level_rec_type
                                                        DEFAULT NULL) IS


  h_record_exists		number(15);

Line: 232


  db_last_updated_by   number;

Line: 233


  db_last_update_date  date;

Line: 241


    select count(*)
    into   h_record_exists
    from   fa_deprn_basis_rules
    where  deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 248


       select last_updated_by, last_update_date
       into   db_last_updated_by, db_last_update_date
       from   fa_deprn_basis_rules
       where  deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 253


       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_deprn_basis_rules_pkg.update_row (
	             X_deprn_basis_rule_id => h_deprn_basis_rule_id,
	             X_rule_name           => X_rule_name,
	             X_user_rule_name      => X_user_rule_name,
	             X_last_update_date    => sysdate,
	             X_last_updated_by     => user_id,
	             X_last_update_login   => 0,
	             X_rate_source         => X_rate_source,
	             X_calculation_basis   => X_calculation_basis,
                     X_enabled_flag        => X_enabled_flag,
	             X_program_name        => X_program_name,
                     X_description         => X_description,
                     p_log_level_rec => p_log_level_rec);

Line: 280


     fa_deprn_basis_rules_pkg.insert_row (
	                X_deprn_basis_rule_id  => h_deprn_basis_rule_id,
	                X_rule_name            => X_rule_name,
	                X_user_rule_name       => X_user_rule_name,
	                X_last_update_date     => sysdate,
	                X_last_updated_by      => user_id,
	                X_created_by           => user_id,
	                X_creation_date        => sysdate,
	                X_last_update_login    => 0,
	                X_rate_source          => X_rate_source,
	                X_calculation_basis    => X_calculation_basis,
	                X_enabled_flag         => X_enabled_flag,
                        X_program_name         => X_program_name,
                        X_description          => X_description,
                        p_log_level_rec => p_log_level_rec);

Line: 310


      X_LAST_UPDATE_DATE    in DATE,
      X_USER_RULE_NAME      in VARCHAR2 DEFAULT NULL,
      X_RULE_NAME           in VARCHAR2 DEFAULT NULL,
      X_DESCRIPTION         in VARCHAR2 DEFAULT NULL,
      p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) IS

  user_id              number;

Line: 318


  db_last_updated_by   number;

Line: 319


  db_last_update_date  date;

Line: 325


  select last_updated_by, last_update_date
  into   db_last_updated_by, db_last_update_date
  from   fa_deprn_basis_rules
  where  deprn_basis_rule_id = x_deprn_basis_rule_id;

Line: 330


  if (fnd_load_util.upload_test(user_id, x_last_update_date,
                                db_last_updated_by, db_last_update_date,
                                X_CUSTOM_MODE)) then

     update FA_DEPRN_BASIS_RULES set
            USER_RULE_NAME  =nvl(X_USER_RULE_NAME, USER_RULE_NAME),
            LAST_UPDATED_BY = user_id,
            LAST_UPDATE_LOGIN = 0,
            DESCRIPTION = X_DESCRIPTION
     where  DEPRN_BASIS_RULE_ID = nvl(X_DEPRN_BASIS_RULE_ID,DEPRN_BASIS_RULE_ID)
     and    RULE_NAME = nvl(X_RULE_NAME,RULE_NAME)
     and    userenv('LANG') =
            (select language_code
             from   FND_LANGUAGES
             where  installed_flag = 'B');

Line: 367


                X_last_update_date              IN DATE,
                X_rule_name                     IN VARCHAR2,
                X_user_rule_name                IN VARCHAR2,
                X_description                   IN VARCHAR2,
                X_enabled_flag                  IN VARCHAR2,
                X_program_name                  IN VARCHAR2) IS


BEGIN

        if (X_upload_mode = 'NLS') then
           fa_deprn_basis_rules_pkg.TRANSLATE_ROW (
                X_custom_mode           => X_custom_mode,
                X_deprn_basis_rule_id   => X_deprn_basis_rule_id,
                X_owner                 => X_owner,
                X_last_update_date      => X_last_update_date,
                X_user_rule_name        => X_user_rule_name,
                X_description           => X_description);

Line: 390


                X_last_update_date              => X_last_update_date,
                X_rule_name                     => X_rule_name,
                X_user_rule_name                => X_user_rule_name,
                X_description                   => X_description,
                X_enabled_flag                  => X_enabled_flag,
                X_program_name                  => X_program_name);