APPS.HXC_BUILDING_BLOCK_API SQL Statements

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

Line: 56

      select tau.time_attribute_id,
             tbb.data_set_id
        from hxc_time_attribute_usages tau,
             hxc_time_attributes ta,
             hxc_time_building_blocks tbb
       where tau.time_building_block_id = p_block_id
         and tau.time_building_block_ovn = p_block_ovn
         and tau.time_building_block_id = tbb.time_building_block_id
         and tau.time_building_block_ovn = tbb.object_version_number
         and tau.time_attribute_id = ta.time_attribute_id
         and ta.attribute_category <> 'REASON';

Line: 71

        insert into hxc_time_attribute_usages
                    (time_attribute_usage_id,
                     time_attribute_id,
                     time_building_block_id,
                     created_by,
                     creation_date,
                     last_updated_by,
                     last_update_date,
                     last_update_login,
                     object_version_number,
                     time_building_block_ovn,
                     data_set_id
                     ) values (hxc_time_attribute_usages_s.nextval,
                               attribute_record.time_attribute_id,
                               p_to_block_id,
                               null, -- WHO trigger sets
                               null, -- WHO trigger sets
                               null, -- WHO trigger sets
                               null, -- WHO trigger sets
                               null, -- WHO trigger sets
                               1,    -- Insert!
                               p_to_block_ovn,
                               attribute_record.data_set_id
                               );

Line: 126

  select max(object_version_number)
  from   hxc_time_building_blocks
  where  time_building_block_id = p_time_building_block_id
  group by time_building_block_id;

Line: 132

select data_set_id
  from hxc_time_building_blocks
 where time_building_block_id = p_time_building_block_id
   and date_to = hr_general.end_of_time;

Line: 138

select data_set_id
  from hxc_data_sets
 where p_stop_time between start_date and end_date
   and status = 'ON_LINE';

Line: 146

select tbb.data_set_id
  from hxc_time_building_blocks tbb
 where tbb.time_building_block_id = p_parent_building_block_id
   and tbb.object_version_number = p_parent_building_block_ovn;

Line: 221

    update hxc_time_building_blocks
    set    date_to                = decode(trunc(date_from)
			                  ,trunc(p_effective_date)
			                  ,p_effective_date
	                                  ,p_effective_date - 1)
    where  time_building_block_id = p_time_building_block_id
    and    date_to                = hr_general.end_of_time;

Line: 260

      update hxc_time_building_blocks
      set object_version_number    = l_max_ovn + 1,
          time_building_block_id   = p_time_building_block_id
      where time_building_block_id = l_time_building_block_id
      and   date_from              = p_effective_date
      and   date_to                = hr_general.end_of_time;

Line: 281

     update hxc_time_building_blocks
     set parent_building_block_ovn = l_object_version_number
     where parent_building_block_id = p_time_building_block_id;

Line: 425

  select max(object_version_number)
  from   hxc_time_building_blocks
  where  time_building_block_id = p_time_building_block_id
  group by time_building_block_id;

Line: 433

select tbb.data_set_id
  from hxc_time_building_blocks tbb
 where tbb.time_building_block_id = p_parent_building_block_id
   and tbb.object_version_number = p_parent_building_block_ovn;

Line: 589

procedure update_building_block
  (p_validate                  in     boolean default false
  ,p_effective_date            in     date
  ,p_type                      in     varchar2
  ,p_measure                   in     number
  ,p_unit_of_measure           in     varchar2
  ,p_start_time                in     date
  ,p_stop_time                 in     date
  ,p_parent_building_block_id  in     number
  ,p_parent_building_block_ovn in     number
  ,p_scope                     in     varchar2
  ,p_approval_style_id         in     number
  ,p_approval_status           in     varchar2
  ,p_resource_id               in     number
  ,p_resource_type             in     varchar2
  ,p_comment_text              in     varchar2
  ,p_time_building_block_id    in     number
  ,p_application_set_id        in     number
  ,p_translation_display_key   in     varchar2
  ,p_object_version_number     in out nocopy number
  ) is

l_proc                  varchar2(72);

Line: 616

select tbb.data_set_id
  from hxc_time_building_blocks tbb
 where tbb.time_building_block_id = p_tbb_id
   and tbb.object_version_number = p_tbb_ovn;

Line: 628

  	l_proc := g_package||'update_building_block';

Line: 633

  savepoint update_building_block;

Line: 674

    rollback to update_building_block;

Line: 678

end update_building_block;

Line: 685

   procedure delete_building_block
     (p_validate               in     boolean default false,
      p_object_version_number  in out nocopy number,
      p_time_building_block_id in     number,
      p_effective_date         in     date,
      p_application_set_id     in     number
      ) is

     cursor c_old_rec is
       select *
         from hxc_time_building_blocks
        where time_building_block_id = p_time_building_block_id
          and date_to = hr_general.end_of_time;

Line: 700

       select max(object_version_number)
         from   hxc_time_building_blocks
        where  time_building_block_id = p_time_building_block_id
        group by time_building_block_id;

Line: 706

       SELECT htau.time_attribute_id time_attribute_id
         FROM hxc_time_attribute_usages htau ,
              hxc_time_attributes hta
        WHERE htau.time_building_block_ovn = p_ovn
          AND htau.time_building_block_id =  p_building_block_id
          AND hta.time_attribute_id = htau.time_attribute_id
          AND hta.ATTRIBUTE_CATEGORY <> 'REASON';

Line: 728

       l_proc := g_package||'delete_building_block';

Line: 733

     savepoint delete_building_block;

Line: 738

       hxc_building_block_api_bk3.delete_building_block_b
         (p_effective_date           => p_effective_date);

Line: 744

           (p_module_name => 'delete_building_block',
            p_hook_type   => 'BP'
            );

Line: 753

         update hxc_time_building_blocks
            set date_to = p_effective_date
          where time_building_block_id = p_time_building_block_id
            and date_to = hr_general.end_of_time;

Line: 796

         update hxc_time_building_blocks
            set object_version_number    = l_max_ovn + 1,
                time_building_block_id   = p_time_building_block_id,
                date_to                  = p_effective_date
          where time_building_block_id = l_time_building_block_id
            and   date_from              = p_effective_date
            and   date_to                = hr_general.end_of_time;

Line: 822

      hxc_building_block_api_bk3.delete_building_block_a
        (p_effective_date           => p_effective_date,
         p_time_building_block_id   => l_time_building_block_id,
         p_object_version_number    => l_object_version_number
         );

Line: 831

          (p_module_name => 'delete_building_block',
           p_hook_type   => 'AP'
           );

Line: 844

      rollback to delete_building_block;

Line: 848

  end delete_building_block;