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.PAY_USER_ROWS_PKG SQL Statements

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

Line: 24


  select '1'
  from   pay_user_rows_f  usr
  where  usr.user_table_id                = p_user_table_id
  and    upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name)
  and    ( p_rowid is null
	  or ( p_rowid is not null and usr.user_row_id <> p_user_row_id ) )
  and    ((usr.effective_start_date between p_validation_start_date and p_validation_end_date)
           or (usr.effective_end_date between p_validation_start_date and p_validation_end_date)
	   or (usr.effective_start_date < p_validation_start_date and usr.effective_end_date > p_validation_end_date))
  and    ( usr.business_group_id is null
          or ( usr.business_group_id = p_business_group_id ) );

Line: 62


  select '1'
  from   pay_user_rows_f  usr
  where  usr.user_table_id                = p_user_table_id
  and    upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name)
  and    ( p_rowid is null
	  or ( p_rowid is not null and usr.user_row_id <> p_user_row_id ) )
  and    ( usr.business_group_id is null
          or ( usr.business_group_id = p_business_group_id ) );

Line: 101


  select '1'
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    ((usr.effective_start_date between p_validation_start_date and p_validation_end_date)
           or (usr.effective_end_date between p_validation_start_date and p_validation_end_date)
	   or (usr.effective_start_date < p_validation_start_date and usr.effective_end_date > p_validation_end_date))
  and    (p_rowid is null
  or     (p_rowid is not null
  and    usr.user_row_id <> p_user_row_id))
  and    (fnd_number.canonical_to_number(p_row_low_range_or_name) between
          fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
  or     (fnd_number.canonical_to_number(p_row_high_range) between
          fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
  or     (fnd_number.canonical_to_number(usr.row_low_range_or_name) > fnd_number.canonical_to_number(p_row_low_range_or_name)
     and fnd_number.canonical_to_number(usr.row_high_range) < fnd_number.canonical_to_number(p_row_high_range))
  );

Line: 147


  select '1'
  from   pay_user_rows usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    (p_rowid is null
  or     (p_rowid is not null
  and    usr.user_row_id <> p_user_row_id))
  and    (fnd_number.canonical_to_number(p_row_low_range_or_name) between
          fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
  or     (fnd_number.canonical_to_number(p_row_high_range) between
          fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)));

Line: 183


  select (min(usr.effective_start_date)-1)
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    usr.effective_start_date > p_effective_start_date
  and    ((upper(lpad(p_row_low_range_or_name,80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(usr.row_low_range_or_name,80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0'))));

Line: 219


  select (min(usr.effective_start_date)-1)
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    usr.effective_start_date > p_effective_start_date
  and    upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name);

Line: 262


  select '1'
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))

  and    (usr.effective_start_date between p_validation_start_date and p_validation_end_date)
  and    usr.user_row_id <> p_user_row_id
  and    ((upper(lpad(p_row_low_range_or_name,80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(usr.row_low_range_or_name,80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0'))));

Line: 306


  select '1'
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    usr.effective_start_date > p_effective_start_date
  and    ((upper(lpad(p_row_low_range_or_name,80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')) between
         upper(lpad(usr.row_low_range_or_name,80,'0')) and upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')))
  or     (upper(lpad(usr.row_low_range_or_name,80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0')))
  or     (upper(lpad(nvl(usr.row_high_range,usr.row_low_range_or_name),80,'0')) between
         upper(lpad(p_row_low_range_or_name,80,'0')) and upper(lpad(nvl(p_row_high_range,p_row_low_range_or_name),80,'0'))));

Line: 343


  select '1'
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    (usr.business_group_id is null
  or     (usr.business_group_id = p_business_group_id))
  and    usr.effective_start_date > p_effective_start_date
  and    upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name);

Line: 371


      select pay_user_rows_s.nextval
      from   dual  ;

Line: 381


procedure pre_insert ( p_rowid                 in 		varchar2,
                       p_user_table_id         in 		number,
                       p_row_low_range_or_name in 		varchar2,
		       p_user_row_id           in out 	NOCOPY 	number,
                       p_business_group_id     in 		number,
		       p_ghr_installed	       in 		varchar2 default 'N') is
begin
--
  if ( p_ghr_installed = 'N' ) then
  --
  --  if GHR product component not installed then
  --  check value is unique
  --
    check_unique( p_rowid                 => p_rowid,
		  p_user_table_id         => p_user_table_id,
		  p_user_row_id           => p_user_row_id,
		  p_row_low_range_or_name => p_row_low_range_or_name,
                  p_business_group_id     => p_business_group_id ) ;

Line: 403


end pre_insert ;

Line: 406


procedure check_delete_row ( p_user_row_id           in number,
			     p_validation_start_date in date,
			     p_dt_delete_mode        in varchar2 ) is
--
--  Check for DATE EFFECTIVE DELETE
--  Check there are no column instances which end
--  after the validation start date
--
procedure check_dt_delete_row ( p_user_row_id           in number ,
	                        p_validation_start_date in date ) is
cursor c1 is
   select null
   from   pay_user_column_instances_f
   where  user_row_id         = p_user_row_id
   and    effective_end_date >= p_validation_start_date  ;

Line: 431


end check_dt_delete_row ;

Line: 438


   select null
   from   pay_user_column_instances_f
   where  user_row_id = p_user_row_id ;

Line: 458


  if p_dt_delete_mode = 'ZAP' then
       check_dt_zap_row ( p_user_row_id ) ;

Line: 460


  elsif p_dt_delete_mode = 'DELETE' then
       check_dt_delete_row( p_user_row_id , p_validation_start_date ) ;

Line: 463


       app_exception.invalid_argument('pay_user_rows_pkg.check_delete_row',
				      'p_dt_delete_mode',
				       p_dt_delete_mode ) ;

Line: 468


end check_delete_row ;

Line: 474


  delete from PAY_USER_ROWS_F_TL T
  where not exists
    (select NULL
     from PAY_USER_ROWS_F B
     where B.USER_ROW_ID = T.USER_ROW_ID
    );

Line: 480


  update PAY_USER_ROWS_F_TL T
  set (ROW_LOW_RANGE_OR_NAME) =
  (select B.ROW_LOW_RANGE_OR_NAME
   from PAY_USER_ROWS_F_TL B
   where B.USER_ROW_ID = T.USER_ROW_ID
   and B.LANGUAGE = T.SOURCE_LANG)
  where (T.USER_ROW_ID,T.LANGUAGE) in
  (select SUBT.USER_ROW_ID,SUBT.LANGUAGE
    from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT
    where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME
  ));

Line: 493


 insert into PAY_USER_ROWS_F_TL (
    USER_ROW_ID,
    ROW_LOW_RANGE_OR_NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.USER_ROW_ID,
    B.ROW_LOW_RANGE_OR_NAME,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CREATED_BY,
    B.CREATION_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PAY_USER_ROWS_F_TL T
    where T.USER_ROW_ID = B.USER_ROW_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 530


  UPDATE PAY_USER_ROWS_F_TL
    SET ROW_LOW_RANGE_OR_NAME = nvl(X_ROW_LOW_RANGE_OR_NAME,ROW_LOW_RANGE_OR_NAME),
        last_update_date = SYSDATE,
        last_updated_by = decode(x_owner,'SEED',1,0),
        last_update_login = 0,
        source_lang = userenv('LANG')
  WHERE userenv('LANG') IN (language,source_lang)
    AND USER_ROW_ID in
        (select USER_ROW_ID
           from PAY_USER_ROWS_F
          where nvl(ROW_LOW_RANGE_OR_NAME,'~null~')=nvl(X_B_ROW_LOW_RANGE_OR_NAME,'~null~')
            and nvl(LEGISLATION_CODE,'~null~') = nvl(X_B_LEGISLATION_CODE,'~null~')
            and BUSINESS_GROUP_ID is NULL);

Line: 583


       select '1'
	from   pay_user_rows_f pur,
	       pay_user_rows_f_tl urt
	where  upper(urt.row_low_range_or_name) = upper(p_row_low_range_or_name)
	AND   pur.user_row_id = urt.user_row_id
	AND   (urt.user_row_id <> p_user_row_id OR p_user_row_id IS NULL)
	AND   pur.user_table_id   = p_user_table_id
        AND   urt.language = p_language
	AND   (nvl(pur.business_group_id,-1) = nvl(p_bus_grp_id,-1) OR p_bus_grp_id IS NULL)
	AND   (nvl(pur.LEGISLATION_CODE,'~null~') = nvl(p_leg_code,'~null~') OR p_leg_code IS NULL);