APPS.HXC_TBB_BUS SQL Statements

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

Line: 46

procedure chk_non_updateable_args
  (p_effective_date in date
  ,p_rec in hxc_tbb_shd.g_rec_type
  ) is

  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 113

end chk_non_updateable_args;

Line: 285

  select null
  from hxc_time_building_blocks
  where time_building_block_id = p_parent_building_block_id
    and object_version_number = p_parent_building_block_ovn;

Line: 291

  select null
    from hxc_time_building_blocks
   where time_building_block_id = p_parent_building_block_id
     and object_version_number = p_parent_building_block_ovn
     and date_to = hr_general.end_of_time;

Line: 399

 select 'Y'
   from hxc_time_building_blocks
  where resource_id = p_resource_id
    and scope = 'TIMECARD'
    and resource_type = p_resource_type
    and p_start_time <= stop_time
    and p_stop_time >= start_time
    and date_to = hr_general.end_of_time;

Line: 451

end if; -- are we inserting a timecard scope building block

Line: 474

  select count(*)
  from   per_all_people_f
  where  p_date_from          <= effective_end_date
    and  effective_start_date <= p_date_to
    and  person_id = p_resource_id;

Line: 610

   select 1
   from hxc_data_sets d
   where p_stop_time between d.start_date and d.end_date
     and d.status in ('OFF_LINE','RESTORE_IN_PROGRESS','BACKUP_IN_PROGRESS');

Line: 634

procedure insert_validate
  (p_effective_date in date
  ,p_rec in hxc_tbb_shd.g_rec_type
  ) is

  l_proc varchar2(72);

Line: 646

  	l_proc := g_package||'insert_validate';

Line: 726

end insert_validate;

Line: 731

procedure update_validate
  (p_effective_date in date
  ,p_rec in hxc_tbb_shd.g_rec_type
  ) is

  l_proc  varchar2(72);

Line: 743

  	l_proc := g_package||'update_validate';

Line: 750

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

Line: 763

end update_validate;

Line: 768

procedure delete_validate
  (p_rec in hxc_tbb_shd.g_rec_type
  ) is

  l_proc  varchar2(72);

Line: 779

  	l_proc := g_package||'delete_validate';

Line: 789

end delete_validate;