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

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

Line: 28


    select pbg.security_group_id
      from per_business_groups pbg
         , pay_user_rows_f pur
     where pur.user_row_id = p_user_row_id
       and pbg.business_group_id = pur.business_group_id;

Line: 92


    select pbg.legislation_code
      from per_business_groups pbg
         , pay_user_rows_f pur
     where pur.user_row_id = p_user_row_id
       and pbg.business_group_id (+) = pur.business_group_id;

Line: 185


select null
from fnd_territories
where territory_code = p_legislation_code ;

Line: 231


	select user_key_units
	from   pay_user_tables put
	where  put.user_table_id = p_user_table_id ;

Line: 284


	select range_or_match
	from   pay_user_tables put
	where  put.user_table_id = p_user_table_id ;

Line: 361


select put.legislation_code , put.business_group_id
from   pay_user_tables put
where  put.user_table_id = p_user_table_id ;

Line: 559


	select null
	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_user_row_id is null
		or ( p_user_row_id is not null and usr.user_row_id <> p_user_row_id ) )
        and    ( p_business_group_id is null
 	        or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
		or ( p_business_group_id is not null and
			usr.legislation_code is null and usr.business_group_id is null )
		or ( p_business_group_id is not null and
		        usr.legislation_code = hr_api.return_legislation_code(p_business_group_id )))
	and    ( p_legislation_code is null
		or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
		or ( p_legislation_code is not null and
			usr.legislation_code is null and usr.business_group_id is null)
		or ( p_legislation_code is not null and
			p_legislation_code = hr_api.return_legislation_code(usr.business_group_id )))
	and    ( usr.effective_start_date <= p_validation_end_date and
			usr.effective_end_date >= p_validation_start_date );

Line: 861


  select null
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    ( p_user_row_id is null
		or ( p_user_row_id is not null and usr.user_row_id <> p_user_row_id ) )
  and    ( p_business_group_id is null
          or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
   	  or ( p_business_group_id is not null and
			usr.legislation_code is null and usr.business_group_id is null )
	  or ( p_business_group_id is not null and
		        usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
  and    ( p_legislation_code is null
	  or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
	  or ( p_legislation_code is not null and
			usr.legislation_code is null and usr.business_group_id is null)
	  or ( p_legislation_code is not null and
			p_legislation_code = hr_api.return_legislation_code(usr.business_group_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) between
          fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
  or     (fnd_number.canonical_to_number(usr.row_high_range) between
          fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
  and    ( usr.effective_start_date <= p_validation_end_date and
			usr.effective_end_date >= p_validation_start_date );

Line: 1086


procedure chk_delete
(p_user_table_id in number
,p_user_row_id in number
,p_row_low_range_or_name in varchar2
,p_row_high_range in varchar2
,p_datetrack_mode in varchar2
,p_business_group_id in number
,p_legislation_code in varchar2
,p_disable_range_overlap_check in boolean
,p_validation_start_date in date
,p_validation_end_date in date
)is
--
cursor csr_unique_name is
  select null
  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_user_row_id is null
 	 or ( p_user_row_id is not null and usr.user_row_id <> p_user_row_id ) )
  and    ( p_business_group_id is null
          or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
   	  or ( p_business_group_id is not null and
			usr.legislation_code is null and usr.business_group_id is null )
	  or ( p_business_group_id is not null and
		        usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
  and    ( p_legislation_code is null
	  or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
	  or ( p_legislation_code is not null and
			usr.legislation_code is null and usr.business_group_id is null)
	  or ( p_legislation_code is not null and
			p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
  and    ( usr.effective_start_date <= p_validation_end_date and
			usr.effective_end_date >= p_validation_start_date );

Line: 1122


  select null
  from   pay_user_rows_f usr
  where  usr.user_table_id = p_user_table_id
  and    ( p_user_row_id is null
		or ( p_user_row_id is not null and usr.user_row_id <> p_user_row_id ) )
  and    ( p_business_group_id is null
          or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
   	  or ( p_business_group_id is not null and
			usr.legislation_code is null and usr.business_group_id is null )
	  or ( p_business_group_id is not null and
		        usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
  and    ( p_legislation_code is null
	  or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
	  or ( p_legislation_code is not null and
			usr.legislation_code is null and usr.business_group_id is null)
	  or ( p_legislation_code is not null and
			p_legislation_code = hr_api.return_legislation_code(usr.business_group_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) between
          fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
  or     (fnd_number.canonical_to_number(usr.row_high_range) between
          fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
  and    ( usr.effective_start_date <= p_validation_end_date and
			usr.effective_end_date >= p_validation_start_date );

Line: 1151


   select null
   from   pay_user_column_instances_f
   where  user_row_id = p_user_row_id ;

Line: 1155


cursor csr_delete_mode 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: 1163


l_proc   varchar2(100) := g_package || 'chk_delete';

Line: 1183


	if p_datetrack_mode = hr_api.g_delete then

		open csr_delete_mode;

Line: 1186


		fetch csr_delete_mode into l_exists;

Line: 1187


		if csr_delete_mode%found then
		       close csr_delete_mode;

Line: 1192


		close csr_delete_mode;

Line: 1206


	elsif  p_datetrack_mode in (hr_api.g_future_change,hr_api.g_delete_next_change) then


       	     l_result := fnd_installation.get_app_info ( 'GHR',
 	  				                 l_prod_status,
	 				                 l_industry,
  					                 l_oracle_scheema );

Line: 1276


       if csr_delete_mode%isopen then
      	    close csr_delete_mode;

Line: 1282


End chk_delete;

Line: 1311


Procedure chk_non_updateable_args
  (p_effective_date  in date
  ,p_rec             in pay_pur_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 1366


End chk_non_updateable_args;

Line: 1397


Procedure dt_update_validate
  (p_datetrack_mode                in varchar2
  ,p_validation_start_date         in date
  ,p_validation_end_date           in date
  ) Is
--
  l_proc  varchar2(72) := g_package||'dt_update_validate';

Line: 1443


End dt_update_validate;

Line: 1480


Procedure dt_delete_validate
  (p_user_row_id                      in number
  ,p_datetrack_mode                   in varchar2
  ,p_validation_start_date            in date
  ,p_validation_end_date              in date
  ) Is
--
  l_proc        varchar2(72)    := g_package||'dt_delete_validate';

Line: 1502


  If (p_datetrack_mode = hr_api.g_delete or
      p_datetrack_mode = hr_api.g_zap) then
    --
    --
    -- Ensure the arguments are not null
    --
    hr_api.mandatory_arg_error
      (p_api_name       => l_proc
      ,p_argument       => 'validation_start_date'
      ,p_argument_value => p_validation_start_date
      );

Line: 1541


End dt_delete_validate;

Line: 1553


  (p_insert               IN boolean
  ,p_business_group_id    IN number
  ,p_legislation_code     IN varchar2
  ,p_legislation_subgroup IN varchar2 DEFAULT NULL) IS
--
BEGIN
  --
  -- Call the supporting procedure to check startup mode

  IF (p_insert) THEN

    if p_business_group_id is not null and p_legislation_code is not null then
	fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');

Line: 1593


Procedure insert_validate
  (p_rec                   in out nocopy pay_pur_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ,p_disable_units_check   in boolean
  ,p_disable_range_overlap_check in boolean
  ) is
--
  l_proc        varchar2(72) := g_package||'insert_validate';

Line: 1705


End insert_validate;

Line: 1710


Procedure update_validate
  (p_rec                     in out nocopy pay_pur_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ,p_disable_units_check     in boolean
  ,p_disable_range_overlap_check in boolean
  ) is
--
  l_proc        varchar2(72) := g_package||'update_validate';

Line: 1761


  dt_update_validate
    (p_datetrack_mode                 => p_datetrack_mode
    ,p_validation_start_date          => p_validation_start_date
    ,p_validation_end_date            => p_validation_end_date
    );

Line: 1767


  chk_non_updateable_args
    (p_effective_date  => p_effective_date
    ,p_rec             => p_rec
    );

Line: 1816


End update_validate;

Line: 1821


Procedure delete_validate
  (p_rec                           in pay_pur_shd.g_rec_type
  ,p_effective_date                in date
  ,p_datetrack_mode                in varchar2
  ,p_disable_range_overlap_check   in boolean
  ,p_validation_start_date         in date
  ,p_validation_end_date           in date
  ) is
--
  l_proc        varchar2(72) := g_package||'delete_validate';

Line: 1860


  dt_delete_validate
    (p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => p_validation_start_date
    ,p_validation_end_date              => p_validation_end_date
    ,p_user_row_id                      => p_rec.user_row_id
    );

Line: 1868


  chk_delete
    (p_user_table_id => pay_pur_shd.g_old_rec.user_table_id
    ,p_user_row_id => p_rec.user_row_id
    ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
    ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
    ,p_datetrack_mode => p_datetrack_mode
    ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id
    ,p_legislation_code =>  pay_pur_shd.g_old_rec.legislation_code
    ,p_disable_range_overlap_check => p_disable_range_overlap_check
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date => p_validation_end_date
    );

Line: 1882


End delete_validate;